Reference data

Value-set reference tables

The certified contracts' referential checks (e.g. "currency must be valid ISO 4217") join against reference tables in your warehouse. DQHub ships the small public code lists for download below; large or licensed terminologies link to their authoritative source to load yourself.

Bundled — download & load

Fetch as CSV (a single code column) or JSON and load into the named table.

iso4217_currencies

ISO 4217 currency codes

162 codes
iso3166_countries

ISO 3166-1 alpha-2 country codes

249 codes
fips_state_codes

US state/territory FIPS codes

57 codes

Customer-loaded — authoritative source

Large or licensed terminologies. Load these from the official source into the named table; DQHub does not redistribute them.

TableReferenceSource
naics_codesNAICS industry codeslink
county_codesUS county FIPS codeslink
ffiec_county_codesFFIEC county codeslink
ffiec_census_tractsFFIEC census tract filelink
loinc_codesLOINC laboratory codeslink
snomed_codesSNOMED CT concepts (license required)link
icd10_codesICD-10-CM diagnosis codeslink
icdo3_topographyICD-O-3 topography codeslink
icdo3_morphologyICD-O-3 morphology codeslink
cvx_codesCDC CVX vaccine codeslink
mvx_codesCDC MVX manufacturer codeslink
rctc_value_setReportable Conditions Trigger Codes (eRSD)link
vads_notifiable_conditionsPHIN VADS notifiable conditionslink
vads_race_codesCDC race value set (PHIN VADS)link
nhsn_locationsCDC NHSN location codeslink
nhsn_pathogensNHSN organism (SNOMED) value setlink
cms_ecqm_measuresCMS eCQM measure setlink
nppes_npiNPPES National Provider Identifier registrylink
ndc_directoryFDA National Drug Code directorylink
rxnorm_codesRxNorm clinical drug codeslink
ucum_unitsUCUM units of measurelink
procedure_codesCPT / HCPCS / SNOMED procedure codeslink
nucc_taxonomyNUCC Health Care Provider Taxonomylink
cdisc_unit_ctCDISC Unit controlled terminologylink
vsac_value_set_membersVSAC value set memberslink
cdisc_ct_termsCDISC Controlled Terminologylink
meddra_termsMedDRA terminology (license required)link
cat_symbol_masterFINRA CAT reportable securities symbol masterlink
iso10383_micISO 10383 Market Identifier Codeslink
mdrm_dictionaryFederal Reserve MDRM data dictionarylink
nic_institutionsFFIEC NIC institution registrylink
naic_companiesNAIC company registrylink
iard_advisersSEC IARD/IAPD adviser registrylink
epa_scc_codesEPA Source Classification Codeslink
epa_pollutantsEPA pollutant codeslink
part98_subparts40 CFR Part 98 subpartslink
ferc_product_namesFERC EQR product nameslink
esrs_taxonomyESRS XBRL taxonomy datapointslink