{"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 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).","cached_seconds":86400}