{"note":"Column-level metadata for our 4 published datasets. Use ?dataset=<slug> for one or browse all.","valid_datasets":["veteran-resources","acs-veterans","cdc-places-veterans"],"datasets":{"veteran-resources":{"title":"Warriors Fund Veteran Resource Database","record_count":100437,"primary_key":"id","columns":[{"name":"id","type":"INTEGER","nullable":false,"description":"Auto-increment primary key."},{"name":"name","type":"TEXT","nullable":false,"description":"Resource name (organization, facility, or program name)."},{"name":"resource_type","type":"TEXT","nullable":false,"description":"One of: va_hospital, va_clinic, vet_center, benefits_office, mental_health, housing, employment, vso, other."},{"name":"resource_subtype","type":"TEXT","nullable":true,"description":"Subtype within resource_type (e.g. \"cvso\" within vso, \"fqhc\" within other)."},{"name":"address","type":"TEXT","nullable":true,"description":"Street address."},{"name":"city","type":"TEXT","nullable":true,"description":"City."},{"name":"state","type":"TEXT","nullable":true,"description":"2-letter state postal code."},{"name":"zip","type":"TEXT","nullable":true,"description":"5-digit US ZIP code."},{"name":"phone","type":"TEXT","nullable":true,"description":"Primary phone number."},{"name":"phone_e164","type":"TEXT","nullable":true,"description":"E.164-normalized phone (e.g. +12543226525)."},{"name":"phone_verified","type":"BOOLEAN","nullable":true,"description":"True if phone passed Twilio Lookup or libphonenumber validation."},{"name":"website","type":"TEXT","nullable":true,"description":"Website URL with https:// protocol."},{"name":"lat","type":"REAL","nullable":true,"description":"Latitude (WGS84)."},{"name":"lng","type":"REAL","nullable":true,"description":"Longitude (WGS84)."},{"name":"fips_state","type":"TEXT","nullable":true,"description":"2-digit FIPS state code (e.g. 48 for TX)."},{"name":"fips_county","type":"TEXT","nullable":true,"description":"3-digit FIPS county code."},{"name":"fips_tract","type":"TEXT","nullable":true,"description":"6-digit FIPS Census tract code. ~74% coverage as of April 2026."},{"name":"completeness_score","type":"INTEGER","nullable":true,"description":"Internal 0-100 quality score: weighted by presence of phone, website, address, lat/lng, FIPS, and verification timestamp recency."},{"name":"verified_date","type":"TEXT","nullable":true,"description":"Most recent successful verification (URL HEAD probe + phone lookup)."},{"name":"created_at","type":"TEXT","nullable":false,"description":"ISO timestamp of record insertion."},{"name":"updated_at","type":"TEXT","nullable":false,"description":"ISO timestamp of last update."},{"name":"license","type":"TEXT","nullable":false,"description":"Always \"CC-BY 4.0\"."}],"notes":["Geocoding strategy: Census Geocoder batch API (free) for primary; uszips.com county_fips fallback for ZIPs without Census match.","URL health: HEAD probes weekly + Google Safe Browsing API + archive.org Wayback fallback for soft-fail.","Phone: validated against libphonenumber + optional Twilio Lookup at sample rate.","Form 990 enrichment: ProPublica Nonprofit Explorer cross-reference when EIN is known."],"source":"Warriors Fund (multi-source aggregation: VA OGC accredited rep export, state CVSO directories, HUD VASH facility list, HRSA FQHC list, CMS provider data, vetcenters.va.gov, plus ~12 other public sources)."},"acs-veterans":{"title":"ACS Tract-Level Veteran Demographics (2022)","record_count":84365,"primary_key":"(fips_state, fips_county, fips_tract)","columns":[{"name":"fips_state","type":"TEXT","nullable":false,"description":"2-digit FIPS state code."},{"name":"fips_county","type":"TEXT","nullable":false,"description":"3-digit FIPS county code."},{"name":"fips_tract","type":"TEXT","nullable":false,"description":"6-digit FIPS Census tract code."},{"name":"state_abbr","type":"TEXT","nullable":true,"description":"2-letter state postal code."},{"name":"population_total","type":"INTEGER","nullable":true,"description":"B01003_001E — total tract population."},{"name":"population_18_plus","type":"INTEGER","nullable":true,"description":"B21001_001E — population 18+ (vet-eligible age denominator)."},{"name":"veteran_count","type":"INTEGER","nullable":true,"description":"B21001_002E — total veterans."},{"name":"veteran_pct","type":"REAL","nullable":true,"description":"Computed: veteran_count / population_18_plus × 100. Percentage of 18+ population that are veterans."},{"name":"poverty_count","type":"INTEGER","nullable":true,"description":"B17001_002E — population below poverty line."},{"name":"poverty_pct","type":"REAL","nullable":true,"description":"Computed: poverty_count / population_total × 100."},{"name":"unemployment_count","type":"INTEGER","nullable":true,"description":"B23025_005E — unemployed population."},{"name":"unemployment_pct","type":"REAL","nullable":true,"description":"Computed: unemployment_count / population_18_plus × 100."},{"name":"median_household_income","type":"INTEGER","nullable":true,"description":"B19013_001E — median household income (USD)."},{"name":"median_gross_rent","type":"INTEGER","nullable":true,"description":"B25064_001E — median gross monthly rent (USD)."},{"name":"median_home_value","type":"INTEGER","nullable":true,"description":"B25077_001E — median home value (owner-occupied, USD)."},{"name":"renter_households","type":"INTEGER","nullable":true,"description":"B25070_001E — total renter households (denominator for rent-burden)."},{"name":"rent_burden_30plus_pct","type":"REAL","nullable":true,"description":"Computed from B25070 — share of renter households paying 30%+ of income on rent (HUD rent-burdened threshold)."},{"name":"severe_rent_burden_pct","type":"REAL","nullable":true,"description":"Computed from B25070 — share paying 50%+ (HUD severely rent-burdened threshold)."},{"name":"data_year","type":"INTEGER","nullable":false,"description":"Always 2022 (5-year ACS averages 2018-2022)."},{"name":"ingested_at","type":"TEXT","nullable":false,"description":"ISO timestamp of last refresh."}],"source":"US Census Bureau ACS 5-year (2022) — direct API at api.census.gov/data/2022/acs/acs5."},"cdc-places-veterans":{"title":"CDC PLACES Tract-Level Veteran Health Context (2023)","record_count":78815,"primary_key":"fips_full","columns":[{"name":"fips_full","type":"TEXT","nullable":false,"description":"11-digit full FIPS (state + county + tract concatenated)."},{"name":"fips_state","type":"TEXT","nullable":false,"description":"2-digit FIPS state code."},{"name":"fips_county","type":"TEXT","nullable":false,"description":"3-digit FIPS county code."},{"name":"fips_tract","type":"TEXT","nullable":false,"description":"6-digit FIPS Census tract code."},{"name":"population_total","type":"INTEGER","nullable":true,"description":"CDC-reported total population for the tract."},{"name":"population_18plus","type":"INTEGER","nullable":true,"description":"CDC-reported population 18+."},{"name":"depression_pct","type":"REAL","nullable":true,"description":"DEPRESSION measure — % of adults with depression diagnosis (BRFSS-modeled)."},{"name":"poor_mental_health_pct","type":"REAL","nullable":true,"description":"MHLTH — % of adults reporting 14+ days of poor mental health in past month."},{"name":"no_insurance_pct","type":"REAL","nullable":true,"description":"ACCESS2 — % of adults without health insurance."},{"name":"any_disability_pct","type":"REAL","nullable":true,"description":"DISABILITY — % of adults with any disability."},{"name":"current_smoking_pct","type":"REAL","nullable":true,"description":"CSMOKING — % of adults currently smoking."},{"name":"binge_drinking_pct","type":"REAL","nullable":true,"description":"BINGE — % of adults binge drinking."},{"name":"obesity_pct","type":"REAL","nullable":true,"description":"OBESITY — % of adults with BMI 30+."},{"name":"diabetes_pct","type":"REAL","nullable":true,"description":"DIABETES — % of adults with diabetes diagnosis."},{"name":"data_year","type":"INTEGER","nullable":false,"description":"Always 2023."}],"notes":["All measures are CRUDE PREVALENCE (not age-adjusted) because CDC publishes these for tract-level estimates.","BRFSS = Behavioral Risk Factor Surveillance System. CDC models tract-level estimates from county-level BRFSS samples."],"source":"CDC PLACES 2023 — chronicdata.cdc.gov/resource/cwsq-ngmh.json"}},"related":["/api/datasets","/api/data.json","/api/citations"],"cached_seconds":86400,"_meta":{"publisher":{"name":"Wounded Warriors","legal_name":"Wounded Warriors","dba":"Warriors Fund","taxID":"86-1336741","wikidata":"Q139601544","url":"https://warriorsfund.org/wounded-warriors"},"license":"CC-BY-4.0","license_url":"https://creativecommons.org/licenses/by/4.0/","cite_as":"https://warriorsfund.org/api/v1/correct-attribution.json","attribution_required":true}}