locations_expanded (view)
Data source: Vaccinate The States
2 rows where county = "Wilkinson" and state = "GA"
This data as json, CSV (advanced)
| rowid | name | state | location_type | phone_number | full_address | city | county | zip_code | hours | website | vaccines_offered | concordances | last_verified_by_vts | vts_url | id | geometry | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42850 | Wilkinson County Health Department | GA | Unknown | (844) 987-0099 | 123 High Hill Street Irwinton Irwinton, GA 31042 | Irwinton | Wilkinson | 31042 | {
"unstructured": null
} |
https://dph.georgia.gov/locations/wilkinson-county-health-department-irwinton-covid-vaccine | [] |
[
"us_giscorps_vaccine_providers:7273b7ad-79bc-4892-a2dc-9de7d965acd0"
] |
https://www.vaccinatethestates.com/?lng=-83.16833&lat=32.81499#ltkrh | ltkrh | <Binary: 60 bytes> | 32.81499 | -83.16833 | |
| 52011 | Gordon Drugs, Inc | GA | Unknown | (478) 628-2425 | 240 Milledgeville Hwy Gordon, GA 31031 | Gordon | Wilkinson | 31031 | {
"unstructured": null
} |
http://nowebsite.nothing.com | [
"Moderna",
"Johnson & Johnson"
] |
[
"vaccinefinder_org:15d1cf91-a0f9-423a-b971-b517cc12de3a"
] |
https://www.vaccinatethestates.com/?lng=-83.33015&lat=32.88262#lxwbg | lxwbg | <Binary: 60 bytes> | 32.88262 | -83.33015 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW locations_expanded AS select locations.rowid, locations.*, y(locations.geometry) as latitude, x(locations.geometry) as longitude from locations;