Skip to main content

Access to ECCO

The Economics Compute Cluster (ECCO) has migrated to the BioHPC environment, and accounts are not handled on this website anymore. See the BioHPC User Guide.

Latest Tweets

Error: Could not authenticate you.

Experimental MySQL server and updated readin statements

Print Friendly, PDF & Email

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.

1 comment to Experimental MySQL server and updated readin statements

  • 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).