locations_expanded (view)
Data source: Vaccinate The States
4 rows where county = "McDuffie" and state = "GA"
This data as json, CSV (advanced)
Suggested facets: location_type, city, zip_code, hours, vaccines_offered, vaccines_offered (array), concordances (array)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29933 | Walgreens Co. #11995 | GA | Pharmacy | 706-595-1667 | 668 Main St, Thomson, GA 30824-7416 | Thomson | McDuffie | 30824-7416 | {
"unstructured": "09:00AM - 9:00PM"
} |
https://www.walgreens.com | [
"Pfizer",
"Johnson & Johnson"
] |
[
"walgreens:11995",
"vaccinefinder:0e2a3e2f-bfa9-44cb-8207-389238a16c07",
"vaccinefinder_org:0e2a3e2f-bfa9-44cb-8207-389238a16c07"
] |
https://www.vaccinatethestates.com/?lng=-82.50459&lat=33.48354#lpffp | lpffp | <Binary: 60 bytes> | 33.48354 | -82.50459 | |
| 33426 | Walmart Inc #10-1658 | GA | Pharmacy | 7065955530 | 2205 Harrison Rd Se, Thomson, GA 30824-7455 | Thomson | McDuffie | 30824-7455 | {
"unstructured": "9:00 AM - 7:00 PM Mon, 6:00 AM - 7:00 PM Tue, 9:00 AM - 7:00 PM Wed, 9:00 AM - 7:00 PM Thrus, 9:00 AM - 7:00 PM Fri, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Sat, 10:00 AM - 1:30PM, 2:00 PM - 6:00 PM Sun"
} |
https://www.walmart.com/store/1658 | [
"Moderna"
] |
[
"vaccinefinder:a17e2c60-24a0-4214-9b54-ccb2a52460b8",
"us_carbon_health:3858f7bc-c4d6-4830-b5db-5c2ca3f47cf4",
"_tag_provider:walmart",
"walmart:1658"
] |
https://www.vaccinatethestates.com/?lng=-82.50150&lat=33.48079#lqbxz | lqbxz | <Binary: 60 bytes> | 33.48079 | -82.5015 | |
| 42203 | CVS Pharmacy in THOMSON, GA | GA | Unknown | 109 WEST HILL STREET THOMSON, GA 30824 | THOMSON | McDuffie | 30824 | {
"unstructured": null
} |
https://www.cvs.com/vaccine/intake/store/cvd-schedule | [] |
[
"vaccinespotter_org:270194232",
"us_giscorps_vaccine_providers:03af5088-75d9-4774-9529-5cc88c259506"
] |
https://www.vaccinatethestates.com/?lng=-82.50448&lat=33.46830#ltgby | ltgby | <Binary: 60 bytes> | 33.4683 | -82.50448 | ||
| 49437 | Walmart | GA | Unknown | 2205 Harrison Rd SE Thomson, GA 30824 | Thomson | McDuffie | 30824 | {
"unstructured": null
} |
https://www.walmart.com/cp/1228302 | [] |
[
"us_giscorps_vaccine_providers:ac239b1a-3f71-4f10-bdca-39904e2f17f3"
] |
https://www.vaccinatethestates.com/?lng=-82.48040&lat=33.47266#lxcxq | lxcxq | <Binary: 60 bytes> | 33.47266 | -82.4804 |
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;