locations_expanded (view)

Data source: Vaccinate The States

4 rows where county = "Jefferson" and state = "FL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, hours, vaccines_offered, last_verified_by_vts (date), 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
23572 Winn-Dixie #3 FL Pharmacy 850-997-9632 1245 S. Jefferson Street, Monticello, FL 32344 Monticello Jefferson 32344 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 5:00PM Sat, 10:00AM - 5:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Moderna"
]
 
[
    "vaccinefinder:5fc6e1af-931f-4c84-acb6-12d31d62964b",
    "vaccinespotter_org:54271921",
    "vaccinefinder_org:5fc6e1af-931f-4c84-acb6-12d31d62964b",
    "winn_dixie:3",
    "us_giscorps_vaccine_providers:2a018c05-2e2e-43e6-b5af-1f9c6bf4cc7f",
    "fl_state:38020",
    "us_carbon_health:a490d855-196d-4d34-8a3a-e0994707a802",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-83.87132&lat=30.53521#lkrhc lkrhc <Binary: 60 bytes> 30.53521 -83.87132
46928 CVS Pharmacy FL Unknown (850) 997-4108 1390 South Jefferson Street Monticello, FL 32344 Monticello Jefferson 32344 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:b0c84b13-394a-4080-8667-9c9de027a668",
    "vaccinespotter_org:270168046",
    "fl_state:38017",
    "fl_state:40138",
    "us_carbon_health:4b3dddcb-16a7-40ac-ba3a-76acac52ec55"
]
 2021-05-10T22:13:36.130196+00:00 https://www.vaccinatethestates.com/?lng=-83.86975&lat=30.53326#lwkyc lwkyc <Binary: 60 bytes> 30.53326 -83.86975
60224 Jefferson County Health Department FL Unknown   1255 W. Washington Monticello, FL 32344 Monticello Jefferson 32344 
{
    "unstructured": null
}
 http://jefferson.floridahealth.gov/newsroom/2020/12/2020-12-28-COVID-Vaccine-Sign-Up.html 
[]
 
[
    "fl_state:38018",
    "us_carbon_health:e664d192-1404-454d-bcb5-fe977ae12035"
]
   https://www.vaccinatethestates.com/?lng=-83.88205&lat=30.54470#lzwmw lzwmw <Binary: 60 bytes> 30.5447 -83.88205
60801 Tallahassee Memorial Physician Partners FL Unknown   1549 S Jefferson Street Monticello, FL 32344 Monticello Jefferson 32344 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:38019"
]
   https://www.vaccinatethestates.com/?lng=-83.87070&lat=30.52752#lzywb lzywb <Binary: 60 bytes> 30.52752 -83.8707

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;