{"dataset":"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 the phone was confirmed against an authoritative live source. Reserved — rarely set; numbers are sourced from authoritative directories and corrected from user reports, not independently call-verified."},{"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 date the record was reviewed/refreshed (e.g. URL HEAD probe, source re-ingest, or a corrected user report)."},{"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: numbers are sourced from authoritative federal/state directories and corrected from user reports; not independently call-verified.","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).","cached_seconds":86400,"_meta":{"publisher":{"name":"Wounded Warriors","legal_name":"Wounded Warriors","taxID":"86-1336741","wikidata":"Q139601544","wikipedia":"https://en.wikipedia.org/wiki/Warriors_Fund","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}}