locations_expanded (view)

Data source: Vaccinate The States

21 rows where county = "Putnam" and state = "FL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, hours, website, vaccines_offered, vaccines_offered (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
10675 CVS Pharmacy, Inc. #03519 FL Pharmacy (386) 328-6713 238 Us Highway 17, East Palatka, FL 32131 East Palatka Putnam 32131 
{
    "unstructured": "08:00AM-08:00PM Mon-Fri, 09:00AM-06:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/003519 
[
    "Pfizer"
]
 
[
    "cvs:03519",
    "vaccinefinder:0748dd67-1776-4139-a24c-e16713709399",
    "us_giscorps_vaccine_providers:e1117762-8345-4ddb-90f6-41e07d65e43b",
    "vaccinespotter_org:270218114",
    "fl_state:39045"
]
   https://www.vaccinatethestates.com/?lng=-81.59621&lat=29.64719#lfmrr lfmrr <Binary: 60 bytes> 29.64719 -81.59621
10818 CVS Pharmacy, Inc. #04422 FL Pharmacy (386) 325-7576 201 South Sr 19, Palatka, FL 32177 Palatka Putnam 32177 
{
    "unstructured": "09:00AM-08:00PM Mon-Fri, 09:00AM-06:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/004422 
[
    "Pfizer"
]
 
[
    "cvs:04422",
    "vaccinefinder:535b10ab-c4af-4e10-a826-7a2a1a4f020c",
    "vaccinespotter_org:270427945",
    "fl_state:39046"
]
   https://www.vaccinatethestates.com/?lng=-81.67352&lat=29.64631#lfpfq lfpfq <Binary: 60 bytes> 29.64631 -81.67352
10841 CVS Pharmacy, Inc. #04629 FL Pharmacy (352) 481-3105 6025 Se Us Hwy 301, Hawthorne, FL 32640 Hawthorne Putnam 32640 
{
    "unstructured": "09:00AM-08:00PM Mon-Fri, 10:00AM-05:00PM Sat-Sun"
}
 https://www.cvs.com/store-locator/details-directions/004629 
[]
 
[
    "cvs:04629",
    "vaccinefinder:97e15966-2081-4dbd-a943-fe3d9d20380a",
    "vaccinespotter_org:270182663",
    "us_giscorps_vaccine_providers:7e82fedc-8a30-45e1-b1f2-f4f5a04a7f15"
]
   https://www.vaccinatethestates.com/?lng=-82.08633&lat=29.59843#lfphb lfphb <Binary: 60 bytes> 29.59843 -82.08633
23596 Winn-Dixie #163 FL Pharmacy 386-328-6239 901 Highway 19 South, Palatka, FL 32177 Palatka Putnam 32177 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 6:00PM Sat, 10:00AM - 6:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Moderna"
]
 
[
    "vaccinefinder:d66d7dbc-b465-40c5-8bdd-d44055be7131",
    "vaccinespotter_org:54271875",
    "vaccinefinder_org:d66d7dbc-b465-40c5-8bdd-d44055be7131",
    "winn_dixie:163",
    "fl_state:39044",
    "us_carbon_health:a0b89f7a-b495-4ca2-b5fd-57c4c25953cd",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-81.66656&lat=29.66018#lkrkq lkrkq <Binary: 60 bytes> 29.66018 -81.66656
23609 Winn-Dixie #196 FL Pharmacy 386-698-4922 1115 North Summit Street, Crescent City, FL 32112 Crescent City Putnam 32112 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 6:00PM Sat, 10:00AM - 5:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[]
 
[
    "vaccinefinder:797c9c90-0a73-4d8b-bf1f-f77b3463c34a",
    "vaccinespotter_org:54271877",
    "vaccinefinder_org:797c9c90-0a73-4d8b-bf1f-f77b3463c34a",
    "winn_dixie:196",
    "us_giscorps_vaccine_providers:702ba635-1ec8-477e-829b-7ad0fd6a689c",
    "us_carbon_health:ea619ce5-fb67-462c-857b-27a454e9ae51",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-81.51250&lat=29.44765#lkrmk lkrmk <Binary: 60 bytes> 29.44765 -81.5125
32445 Walmart Inc #10-0551 FL Pharmacy 3863286733 1024 S State Road 19, Palatka, FL 32177-9000 Palatka Putnam 32177-9000 
{
    "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/551 
[
    "Moderna"
]
 
[
    "vaccinefinder:6b322510-bc1c-4d46-ba52-defe14d9a489",
    "walmart:551",
    "us_carbon_health:1e66e021-bb71-43be-a5a3-159362742730",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-81.70624&lat=29.61763#lpxbr lpxbr <Binary: 60 bytes> 29.61763 -81.70624
38460 Community Pharmacy #1002144 FL Pharmacy (386) 698-2666 897 N. Summit Street, Crescent City, FL 32112 Crescent City Putnam 32112 
{
    "unstructured": "9:00 AM - 5:00 PM Mon-Fri, 9:00 AM - 12:00 PM Sat, Closed Sun"
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder_org:5b6f0a39-f83c-4951-ac39-763893919fde"
]
   https://www.vaccinatethestates.com/?lng=-81.51175&lat=29.44276#lrgyd lrgyd <Binary: 60 bytes> 29.44276 -81.51175
45347 Walmart FL Unknown   1024 S State Road 19 Palatka, FL 32177 Palatka Putnam 32177 
{
    "unstructured": null
}
 https://www.walmart.com/cp/1228302 
[]
 
[
    "us_giscorps_vaccine_providers:3044e687-3c1d-4ff3-a56c-45833ac42612",
    "fl_state:39043"
]
   https://www.vaccinatethestates.com/?lng=-81.68197&lat=29.63467#lwbrb lwbrb <Binary: 60 bytes> 29.63467 -81.68197
46321 Winn Dixie Pharmacy FL Unknown   901 S State Road 19 Palatka, FL 32177 Palatka Putnam 32177 
{
    "unstructured": null
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[]
 
[
    "us_giscorps_vaccine_providers:8de4ee6e-2de9-4f42-a9b0-b3a2dd4be046"
]
   https://www.vaccinatethestates.com/?lng=-81.67551&lat=29.63919#lwgmp lwgmp <Binary: 60 bytes> 29.63919 -81.67551
46391 Walgreens Co. #4734 FL Unknown 386-328-6787 719 S STATE ROAD 19 PALATKA, FL 32177 PALATKA Putnam 32177 
{
    "unstructured": null
}
 https://www.walgreens.com/findcare/vaccination/covid-19 
[
    "Moderna",
    "Pfizer"
]
 
[
    "vaccinefinder_org:5c06c83d-9d2d-4222-a7c6-ff09cedb5362",
    "walgreens:4734",
    "vaccinespotter_org:2717556",
    "fl_state:39050"
]
   https://www.vaccinatethestates.com/?lng=-81.72204&lat=29.57343#lwgty lwgty <Binary: 60 bytes> 29.57343 -81.72204
46760 CVS Pharmacy in INTERLACHEN, FL FL Unknown   1141 HIGHWAY 20 INTERLACHEN, FL 32148 INTERLACHEN Putnam 32148 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:270222109"
]
   https://www.vaccinatethestates.com/?lng=-81.88591&lat=29.62748#lwkfh lwkfh <Binary: 60 bytes> 29.62748 -81.88591
46871 ANGELS PHARMACY II FL Unknown   610 ZEAGLER DR PALATKA, FL 32177 PALATKA Putnam 32177 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141554209"
]
   https://www.vaccinatethestates.com/?lng=-81.69377&lat=29.64203#lwkrh lwkrh <Binary: 60 bytes> 29.64203 -81.69377
47126 Putnam County Fairgrounds FL Unknown   118 Fairgrounds Rd East Palatka, FL 32131 East Palatka Putnam 32131 
{
    "unstructured": null
}
 http://putnam.floridahealth.gov/ 
[]
 
[
    "us_giscorps_vaccine_providers:f41e446c-a7c3-43bf-b9c3-a5bd3c3f9f39",
    "us_carbon_health:5945fb35-81c7-4167-ab6e-b907c2d27b7e"
]
   https://www.vaccinatethestates.com/?lng=-81.58734&lat=29.64231#lwmrq lwmrq <Binary: 60 bytes> 29.64231 -81.58734
47212 Mt. Tabor Baptist Church FL Unknown   4909 St Johns Ave Palatka, FL 32177 Palatka Putnam 32177 
{
    "unstructured": null
}
   
[]
 
[
    "us_giscorps_vaccine_providers:ba95e703-0cc9-4490-84bd-cbe85d6cb1cb"
]
   https://www.vaccinatethestates.com/?lng=-81.67851&lat=29.64805#lwpbg lwpbg <Binary: 60 bytes> 29.64805 -81.67851
47227 Crescent City lot across from City Hall FL Unknown   3 Summit St Crescent City, FL 32112 Crescent City Putnam 32112 
{
    "unstructured": null
}
   
[]
 
[
    "us_giscorps_vaccine_providers:9ebe7b9a-eaac-4687-a516-198e64f46500"
]
   https://www.vaccinatethestates.com/?lng=-81.51017&lat=29.42982#lwpcf lwpcf <Binary: 60 bytes> 29.42982 -81.51017
47233 Putnam Community Medical Center FL Unknown   611 Zeagler Drive Palatka Palatka, FL 32177 Palatka Putnam 32177 
{
    "unstructured": null
}
 https://l.facebook.com/l.php?u=https%3A%2F%2Fwww.signupgenius.com%2Fgo%2F10C0C4EADAC2FA4F5C43-moderna1%3Ffbclid%3DIwAR2n58NLaoYADqUwu2Jat8j4cOLINgiGJKApQEDosINY0epPjh888BufJ_8&h=AT2oeU9WH7hWAZKeXd1wMhHrQlaSE85_4z1KdkUOwSUSI1Uvk1nx75Kl-BrRIl2diU-m7JmdMZc3et 
[]
 
[
    "us_giscorps_vaccine_providers:115f334a-7f83-4ffe-b7ba-864e990df2d9"
]
   https://www.vaccinatethestates.com/?lng=-81.69237&lat=29.64335#lwpcq lwpcq <Binary: 60 bytes> 29.64335 -81.69237
47467 First Choice Pharmacy FL Unknown   3208 CRILL AVE #2 PALATKA, FL 32177 PALATKA Putnam 32177 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141554211"
]
   https://www.vaccinatethestates.com/?lng=-81.66286&lat=29.64168#lwqbq lwqbq <Binary: 60 bytes> 29.64168 -81.66286
56349 Palatka CBOC FL Hospital / Clinic   400 North State Road 19 Suite 48 Palatka, FL 32177-2449 Palatka Putnam 32177 
{
    "unstructured": ""
}
 https://www.northflorida.va.gov/services/covid-19-vaccines.asp 
[]
 
[]
 2021-05-10T03:11:08.715070+00:00 https://www.vaccinatethestates.com/?lng=-81.67281&lat=29.65480#lyxfd lyxfd <Binary: 60 bytes> 29.6548 -81.67281
59994 AZA Health, Crescent CIty Medical Center FL Unknown   306 Union Ave. Crescent City, FL 32112 Crescent City Putnam 32112 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39048"
]
   https://www.vaccinatethestates.com/?lng=-81.53586&lat=29.46187#lztqg lztqg <Binary: 60 bytes> 29.46187 -81.53586
61281 AZA Health, Interlachen Medical Center FL Unknown   1213 Highway 20 West Interlachen, FL 32148 Interlachen Putnam 32148 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39047"
]
   https://www.vaccinatethestates.com/?lng=-81.89895&lat=29.62534#lcbbrb lcbbrb <Binary: 60 bytes> 29.62534 -81.89895
61393 Hitchcock's Market East Palatka FL Unknown   164 S. US HWY 17 East Palatka, FL 32131 East Palatka Putnam 32131 
{
    "unstructured": null
}
 https://vaccinations.myhitchcocks.com/ 
[]
 
[
    "fl_state:40067"
]
   https://www.vaccinatethestates.com/?lng=-81.60659&lat=29.64556#lcbccc lcbccc <Binary: 60 bytes> 29.64556 -81.60659

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW locations_expanded AS 
select
  locations.rowid,
  locations.*,
  y(locations.geometry) as latitude,
  x(locations.geometry) as longitude
from
  locations;