An experimental load of select QWI files is available on VRDC6402 for VirtualRDC compute node users. Updated MySQL load files are available in the download area for registered download users. Access to QWI download is described on the QWI download page.VirtualRDC compute node users should use the following MySQL information:
- Host: vrdc6402b
- User: qwi
- Password: qwi
- Database: qwi
Note that an auxiliary database is available containing a mapping of 2-digit FIPS state codes into FIPS state abbreviation.
Currently, only two tables are loaded (for all currently available LEHD states):
qwi_wia_county_naicssec_pri and qwi_wia_wib_naicssec_pri. Furthermore, you can access the MySQL data from R on most nodes by using library 'RMySQL' (see RMySQL and DBI usage information).