Public Data Sources - Complete Listing

Data steward(s):

U.S. Census Bureau
U.S. Patent and Trademark Office (USPTO)
U.S. Bureau of Labor Statistics (BLS)
U.S. Department of Agriculture (USDA)
Various federal agencies
Contact information to be updated

Coleridge Project Manager

Contact information to be updated

This file contains all 241 public data tables available in the ADRF across three schemas: - ds_public_1: 128 tables (General public data, patents, O*NET, LODES, etc.) - ds_public_2: 1 table (IRS data)
- ds_public_3: 112 tables (Food and nutrition data)

DS_PUBLIC_1 Schema (128 Tables)

Geographic and Administrative Data

ds_public_1	all_states_lodes_xwalk	Multi-state LODES geographic crosswalk \|
ds_public_1	ar_class_census_data	Arkansas census classification data
ds_public_1	ar_etpl	Arkansas Eligible Training Provider List \|
ds_public_1	hud_county_adjacency_2023	HUD county adjacency relationships
ds_public_1	hud_zip_county_crosswalks_2013_2024	HUD ZIP to county crosswalks for multiple years \|
ds_public_1	hud_zip_fips_xwalk	HUD ZIP Code to FIPS county crosswalk \|
ds_public_1	qcew_county_msa_csa_xwalk	QCEW county to MSA/CSA crosswalk \|
ds_public_1	usda_urban_rural_codes	USDA Rural-Urban Continuum Codes \|
ds_public_1	zip_county_wda_xwalk	ZIP code to workforce development area crosswalk \|

Bureau of Labor Statistics Data

ds_public_1	bls_oews	Occupational Employment and Wage Statistics \|
ds_public_1	bls_qcew	Quarterly Census of Employment and Wages \|
ds_public_1	cpi	Consumer Price Index data
ds_public_1	laus	Local Area Unemployment Statistics

LODES (Longitudinal Employer-Household Dynamics) Data

ds_public_1	lodes_ar_od_main_jt00_2018 \| Arkansas Origin-Destination commuting flows 2018 \|
ds_public_1	lodes_ar_rac_s000_jt00_2018 \| Arkansas Residence Area Characteristics 2018 \|
ds_public_1	lodes_ar_wac_s000_jt00_2018 \| Arkansas Workplace Area Characteristics 2018 \|
ds_public_1	lodes_ar_xwalk	Arkansas LODES geographic crosswalk \|
ds_public_1	lodes_ca_od_main_jt00_2015 \| California Origin-Destination commuting flows 2015 \|
ds_public_1	lodes_ca_rac_s000_jt00_2015 \| California Residence Area Characteristics 2015 \|
ds_public_1	lodes_ca_wac_s000_jt00_2015 \| California Workplace Area Characteristics 2015 \|
ds_public_1	lodes_ca_xwalk	California LODES geographic crosswalk \|
ds_public_1	lodes_il_od_main_jt00_2015 \| Illinois Origin-Destination commuting flows 2015 \|
ds_public_1	lodes_il_rac_s000_jt00_2015 \| Illinois Residence Area Characteristics 2015 \|
ds_public_1	lodes_il_wac_s000_jt00_2015 \| Illinois Workplace Area Characteristics 2015 \|
ds_public_1	lodes_il_xwalk	Illinois LODES geographic crosswalk \|
ds_public_1	lodes_ky_wac_s000_jt00_2015 \| Kentucky Workplace Area Characteristics 2015 \|
ds_public_1	lodes_md_wac_s000_jt00_2015 \| Maryland Workplace Area Characteristics 2015 \|
ds_public_1	lodes_wi_od_main_jt00_2020 \| Wisconsin Origin-Destination commuting flows 2020 \|
ds_public_1	lodes_wi_rac_s000_jt00_2020 \| Wisconsin Residence Area Characteristics 2020 \|
ds_public_1	lodes_wi_wac_s000_jt00_2020 \| Wisconsin Workplace Area Characteristics 2020 \|
ds_public_1	lodes_wi_xwalk	Wisconsin LODES geographic crosswalk \|

Patent and Innovation Data (USPTO)

ds_public_1	g_applicant_not_disambiguated	Patent applicant information (not disambiguated) \|
ds_public_1	g_application	Patent application information
ds_public_1	g_assignee_disambiguated	Patent assignee information (disambiguated) \|
ds_public_1	g_cpc_current	Cooperative Patent Classification codes
ds_public_1	g_gov_interest	Government interest in patents
ds_public_1	g_gov_interest_contracts	Government contract information related to patents
ds_public_1	g_gov_interest_org	Organizations with government patent interests
ds_public_1	g_inventor_disambiguated	Patent inventor information (disambiguated) \|
ds_public_1	g_location_disambiguated	Geographic location data for patents
ds_public_1	g_patent	Core patent records and characteristics
ds_public_1	g_persistent_assignee	Longitudinal patent assignee tracking \|
ds_public_1	g_persistent_inventor	Longitudinal patent inventor tracking \|
ds_public_1	g_us_patent_citation	Patent citation relationships
ds_public_1	g_wipo_technology	WIPO technology classification data
ds_public_1	uspto_inventor_names	USPTO inventor name disambiguation
ds_public_1	uspto_nih_fed_reporter	USPTO data linked to NIH Federal Reporter \|
ds_public_1	uspto_org_location	USPTO organization location information

O*NET Occupational Information Network Data (90+ Tables)

ds_public_1	onet_abilities	Worker abilities required for occupations \|
ds_public_1	onet_abilities_to_work_activities	Links abilities to work activities
ds_public_1	onet_abilities_to_work_context	Links abilities to work context
ds_public_1	onet_alternate_titles	Alternative occupational titles
ds_public_1	onet_basic_interests_to_riasec	Basic interests to RIASEC mapping \|
ds_public_1	onet_content_model_reference	Content model reference data
ds_public_1	onet_dwa_reference	Detailed Work Activities reference
ds_public_1	onet_education_training_experience	Education, training, and experience requirements
ds_public_1	onet_emerging_tasks	Emerging tasks in occupations
ds_public_1	onet_ete_categories	Education, training, experience categories
ds_public_1	onet_interests	Work interests
ds_public_1	onet_interests_illus_activities	Interest illustrative activities
ds_public_1	onet_interests_illus_occupations	Interest illustrative occupations
ds_public_1	onet_iwa_reference	Intermediate Work Activities reference
ds_public_1	onet_job_zone_reference	Job zone reference information
ds_public_1	onet_job_zones	Job zone classifications
ds_public_1	onet_knowledge	Knowledge requirements
ds_public_1	onet_level_scale_anchors	Level scale anchor points
ds_public_1	onet_occupation_data	Core occupational information
ds_public_1	onet_occupation_level_metadata	Occupation-level metadata
ds_public_1	onet_related_occupations	Related occupations data
ds_public_1	onet_riasec_keywords	RIASEC interest keywords
ds_public_1	onet_sample_of_reported_titles	Sample of reported job titles
ds_public_1	onet_scales_reference	Scale reference information
ds_public_1	onet_skills	Skills required for occupations
ds_public_1	onet_skills_to_work_activities	Links skills to work activities
ds_public_1	onet_skills_to_work_context	Links skills to work context
ds_public_1	onet_soc_2019_to_2018_soc	SOC 2019 to 2018 crosswalk \|
ds_public_1	onet_survey_booklet_locations	Survey booklet location information
ds_public_1	onet_task_categories	Task categories
ds_public_1	onet_task_ratings	Task ratings
ds_public_1	onet_task_statements	Task statements
ds_public_1	onet_tasks_to_dwas	Tasks to Detailed Work Activities mapping \|
ds_public_1	onet_technology_skills	Technology skills
ds_public_1	onet_tools_used	Tools used in occupations
ds_public_1	onet_unspsc_reference	UNSPSC (United Nations Standard Products and Services Code) reference \|
ds_public_1	onet_work_activities	Generalized work activities
ds_public_1	onet_work_context	Work context characteristics
ds_public_1	onet_work_context_categories	Work context categories
ds_public_1	onet_work_styles	Work styles
ds_public_1	onet_work_values	Work values

O*NET Version 3.0 Historical Data

ds_public_1	onet_3_ability	O*NET 3.0 abilities data \|
ds_public_1	onet_3_dot_to_onetsoc_xwalk	ONET 3.0 DOT to ONET-SOC crosswalk \|
ds_public_1	onet_3_interest	O*NET 3.0 interests data \|
ds_public_1	onet_3_job_zone_reference	O*NET 3.0 job zone reference \|
ds_public_1	onet_3_knowledge	O*NET 3.0 knowledge data \|
ds_public_1	onet_3_onet_content_model_reference	O*NET 3.0 content model reference \|
ds_public_1	onet_3_onetsoc_data	O*NET 3.0 SOC data \|
ds_public_1	onet_3_onetsoc_job_zones	O*NET 3.0 job zones \|
ds_public_1	onet_3_related_occupation_data	O*NET 3.0 related occupation data \|
ds_public_1	onet_3_scales_reference	O*NET 3.0 scales reference \|
ds_public_1	onet_3_skills	O*NET 3.0 skills data \|
ds_public_1	onet_3_soc_classification	O*NET 3.0 SOC classification \|
ds_public_1	onet_3_soc_ou_onetsoc_crosswalk	ONET 3.0 SOC to ONET-SOC crosswalk \|
ds_public_1	onet_3_tasks	O*NET 3.0 tasks data \|
ds_public_1	onet_3_workactivity	O*NET 3.0 work activities \|
ds_public_1	onet_3_workcontext	O*NET 3.0 work context \|
ds_public_1	onet_3_workvalue	O*NET 3.0 work values \|

Classification Systems and Crosswalks

ds_public_1	cip2020_soc2018_xwalk \| CIP 2020 to SOC 2018 crosswalk \|
ds_public_1	cip_lookup	Classification of Instructional Programs lookup \|
ds_public_1	naics_descriptions	NAICS industry classification descriptions
ds_public_1	nrccte_cip_to_soc_xwalk_2010	NRCCTE CIP to SOC crosswalk 2010 \|
ds_public_1	onet_2000_2006_xwalk	O*NET 2000 to 2006 crosswalk \|
ds_public_1	onet_2006_2009_xwalk	O*NET 2006 to 2009 crosswalk \|
ds_public_1	onet_2009_2010_xwalk	O*NET 2009 to 2010 crosswalk \|
ds_public_1	onet_2010_2019_xwalk	O*NET 2010 to 2019 crosswalk \|
ds_public_1	soc_xwalk	Standard Occupational Classification crosswalk \|

Research and Education Data

ds_public_1	ipeds_location	IPEDS higher education institution locations \|
ds_public_1	nih_fedreporter_grants	NIH Federal Reporter grant data
ds_public_1	rapids_apprentice	RAPIDS apprentice data
ds_public_1	rapids_program	RAPIDS program data
ds_public_1	rapids_programoccupation	RAPIDS program occupation data

Administrative and Miscellaneous Data

ds_public_1	case_months	Case duration data in months
ds_public_1	db_fake	Test/fake database
ds_public_1	departmenttest	Department test data
ds_public_1	guam_unemployment_historical_table	Guam historical unemployment data
ds_public_1	member_months	Program membership duration data
ds_public_1	prehsah_fakedata	Pre-HSAH fake data for testing
ds_public_1	sample_df_zip_ms	Sample dataframe ZIP codes for Mississippi \|
ds_public_1	warn_notice	Worker Adjustment and Retraining Notification Act notices \|

DS_PUBLIC_2 Schema (1 Table)

ds_public_2

irs_form_990

IRS Form 990 data for tax-exempt organizations |

DS_PUBLIC_3 Schema (112 Tables - Food and Nutrition Data)

USDA Food and Nutrient Database for Dietary Studies (FNDDS)

ds_public_3	fndds_1112_nutdesc	FNDDS 2011-12 nutrient descriptions \|
ds_public_3	fndds_1112_nutval	FNDDS 2011-12 nutrient values \|
ds_public_3	fndds_1314_nutdesc	FNDDS 2013-14 nutrient descriptions \|
ds_public_3	fndds_1314_nutval	FNDDS 2013-14 nutrient values \|
ds_public_3	fnddsnutval1516	FNDDS 2015-16 nutrient values \|
ds_public_3	fnddsnutval1718	FNDDS 2017-18 nutrient values \|
ds_public_3	fnddsingred1516	FNDDS 2015-16 ingredients \|
ds_public_3	fnddsingred1718	FNDDS 2017-18 ingredients \|
ds_public_3	fnddssrlinks1314	FNDDS 2013-14 Standard Reference links \|
ds_public_3	fnddssrlinks_1112	FNDDS 2011-12 Standard Reference links \|

USDA Standard Reference (SR) Database

ds_public_3	sr26_abbrev	SR26 abbreviated nutrient data \|
ds_public_3	sr26_add_ftnt	SR26 additional footnotes \|
ds_public_3	sr26_data_src	SR26 data sources \|
ds_public_3	sr26_datsrcln	SR26 data source links \|
ds_public_3	sr26_deriv_cd	SR26 derivation codes \|
ds_public_3	sr26_fd_group	SR26 food group descriptions \|
ds_public_3	sr26_food_des	SR26 food descriptions \|
ds_public_3	sr26_footnote	SR26 footnotes \|
ds_public_3	sr26_langdesc	SR26 language descriptions \|
ds_public_3	sr26_langual	SR26 LanguaL data \|
ds_public_3	sr26_nut_data	SR26 nutrient data \|
ds_public_3	sr26_nutr_def	SR26 nutrient definitions \|
ds_public_3	sr26_src_cd	SR26 source codes \|
ds_public_3	sr26_weight	SR26 weight data \|
ds_public_3	sr28_abbrev	SR28 abbreviated nutrient data \|
ds_public_3	sr28_data_src	SR28 data sources \|
ds_public_3	sr28_datsrcln	SR28 data source links \|
ds_public_3	sr28_deriv_cd	SR28 derivation codes \|
ds_public_3	sr28_fd_group	SR28 food group descriptions \|
ds_public_3	sr28food_des	SR28 food descriptions \|
ds_public_3	sr28_footnote	SR28 footnotes \|
ds_public_3	sr28_langdesc	SR28 language descriptions \|
ds_public_3	sr28_langual	SR28 LanguaL data \|
ds_public_3	sr28nut_data	SR28 nutrient data \|
ds_public_3	sr28_nutr_def	SR28 nutrient definitions \|
ds_public_3	sr28_src_cd	SR28 source codes \|
ds_public_3	sr28_weight	SR28 weight data \|

FoodData Central (FDC) Data

ds_public_3	bf_all_reccount	Branded Foods all record counts
ds_public_3	bf_branded_food	Branded Foods branded food data
ds_public_3	bf_food	Branded Foods food data
ds_public_3	bf_food_attribute	Branded Foods food attributes
ds_public_3	bf_food_nutrient	Branded Foods food nutrients
ds_public_3	bf_food_update_log_entry	Branded Foods update log entries
ds_public_3	srl_food	Survey Food food data
ds_public_3	srl_food_attribute	Survey Food food attributes
ds_public_3	srl_food_calorie_conversion_factor	Survey Food calorie conversion factors
ds_public_3	srl_food_nutrient	Survey Food nutrients
ds_public_3	srl_food_nutrient_conversion_factor	Survey Food nutrient conversion factors
ds_public_3	srl_food_portion	Survey Food portion data
ds_public_3	srl_food_protein_conversion_factor	Survey Food protein conversion factors
ds_public_3	srl_food_update_log_entry	Survey Food update log entries
ds_public_3	srl_sr_legacy_food	Survey Food Standard Reference legacy food data

What We Eat in America (WWEIA) Food Categories

ds_public_3	wweia1112_foodcat_fndds	WWEIA 2011-12 food categories FNDDS \|
ds_public_3	wweia1112_foodcat_fndds_category_list	WWEIA 2011-12 food categories list \|
ds_public_3	wweia1314_foodcat_fndds	WWEIA 2013-14 food categories FNDDS \|
ds_public_3	wweia1314_foodcat_fndds_category_list	WWEIA 2013-14 food categories list \|
ds_public_3	wweia1516_foodcat_fndds	WWEIA 2015-16 food categories FNDDS \|
ds_public_3	wweia1516_foodcat_fndds_category_list	WWEIA 2015-16 food categories list \|
ds_public_3	wweia1718_foodcat_fndds	WWEIA 2017-18 food categories FNDDS \|
ds_public_3	wweia1718_foodcat_fndds_category_list	WWEIA 2017-18 food categories list \|
ds_public_3	wweia17_prepandemic_foodcat_fndds	WWEIA 2017 pre-pandemic food categories \|
ds_public_3	wweia17_prepandemic_foodcat_fndds_category_list \| WWEIA 2017 pre-pandemic food categories list \|

Food Patterns Equivalents Database (FPED)

ds_public_3	fped_1112	FPED 2011-12 data \|
ds_public_3	fped_1314	FPED 2013-14 data \|
ds_public_3	fped_1516	FPED 2015-16 data \|
ds_public_3	fped_1718	FPED 2017-18 data \|
ds_public_3	fpid_1112	Food Patterns Ingredients Database 2011-12 \|
ds_public_3	fpid_1314	Food Patterns Ingredients Database 2013-14 \|
ds_public_3	fpid_1516	Food Patterns Ingredients Database 2015-16 \|
ds_public_3	fpid_1718	Food Patterns Ingredients Database 2017-18 \|

Food Description and Processing Data (Multiple Survey Years)

ds_public_3	addfooddesc1112	Additional food descriptions 2011-12 \|
ds_public_3	addfooddesc1314	Additional food descriptions 2013-14 \|
ds_public_3	addfooddesc1516	Additional food descriptions 2015-16 \|
ds_public_3	addfooddesc1718	Additional food descriptions 2017-18 \|
ds_public_3	derivdesc1516	Derivation descriptions 2015-16 \|
ds_public_3	derivdesc1718	Derivation descriptions 2017-18 \|
ds_public_3	foodportiondesc1112	Food portion descriptions 2011-12 \|
ds_public_3	foodportiondesc1314	Food portion descriptions 2013-14 \|
ds_public_3	foodportiondesc1516	Food portion descriptions 2015-16 \|
ds_public_3	foodportiondesc1718	Food portion descriptions 2017-18 \|
ds_public_3	foodsubcodelinks1112	Food subcode links 2011-12 \|
ds_public_3	foodsubcodelinks1314	Food subcode links 2013-14 \|
ds_public_3	foodsubcodelinks1516	Food subcode links 2015-16 \|
ds_public_3	foodsubcodelinks1718	Food subcode links 2017-18 \|
ds_public_3	foodweights1112	Food weights 2011-12 \|
ds_public_3	foodweights1314	Food weights 2013-14 \|
ds_public_3	foodweights1516	Food weights 2015-16 \|
ds_public_3	foodweights1718	Food weights 2017-18 \|
ds_public_3	mainfooddesc1112	Main food descriptions 2011-12 \|
ds_public_3	mainfooddesc1314	Main food descriptions 2013-14 \|
ds_public_3	mainfooddesc1516	Main food descriptions 2015-16 \|
ds_public_3	mainfooddesc1718	Main food descriptions 2017-18 \|

Nutrient and Processing Data

ds_public_3	ingrednutval1516	Ingredient nutrient values 2015-16 \|
ds_public_3	ingrednutval1718	Ingredient nutrient values 2017-18 \|
ds_public_3	moistadjust1516	Moisture adjustments 2015-16 \|
ds_public_3	moistadjust1718	Moisture adjustments 2017-18 \|
ds_public_3	moistnfatadjust1112	Moisture and fat adjustments 2011-12 \|
ds_public_3	moistnfatadjust1314	Moisture and fat adjustments 2013-14 \|
ds_public_3	moddesc1112	Modification descriptions 2011-12 \|
ds_public_3	modnutval1112	Modified nutrient values 2011-12 \|
ds_public_3	nutdesc1516	Nutrient descriptions 2015-16 \|
ds_public_3	nutdesc1718	Nutrient descriptions 2017-18 \|
ds_public_3	reccount1516	Recipe counts 2015-16 \|
ds_public_3	reccount1718	Recipe counts 2017-18 \|
ds_public_3	srnutval1314	Standard Reference nutrient values 2013-14 \|
ds_public_3	subcodedesc1112	Subcode descriptions 2011-12 \|
ds_public_3	subcodedesc1314	Subcode descriptions 2013-14 \|
ds_public_3	subcodedesc1516	Subcode descriptions 2015-16 \|
ds_public_3	subcodedesc1718	Subcode descriptions 2017-18 \|

Geographic and Research Data

ds_public_3	food_access_research_atlas_data_2019	USDA Food Access Research Atlas 2019 data \|
ds_public_3	ruca_2010	Rural-Urban Commuting Area codes 2010 \|