locations_expanded (view)

Data source: Vaccinate The States

3 rows where county = "Warren" and state = "IL"

✎ View and edit SQL

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
13976 Warren County Health Department IL Pharmacy 309-734-0823 240 S Main St, Monmouth, IL 61462-2160 Monmouth Warren 61462-2160 
{
    "unstructured": ""
}
 http://www.warrencohealth.com 
[
    "Pfizer"
]
 
[
    "vaccinefinder:be767bf0-0dff-42de-ae66-c681f3be4694"
]
   https://www.vaccinatethestates.com/?lng=-90.64852&lat=40.90980#lggrp lggrp <Binary: 60 bytes> 40.9098 -90.64852
13984 Axline Pharmacy (01) IL Pharmacy   220 N Main St, Monmouth, IL 61462-1741 Monmouth Warren 61462-1741 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:7d47b1b8-8479-4470-9140-26af8ef53a6c"
]
   https://www.vaccinatethestates.com/?lng=-90.64902&lat=40.91382#lggtb lggtb <Binary: 60 bytes> 40.91382 -90.64902
29886 Walgreens Co. #11881 IL Pharmacy 309-734-6644 600 N Main St, Monmouth, IL 61462-1267 Monmouth Warren 61462-1267 
{
    "unstructured": "08:00AM - 8:00PM"
}
 https://www.walgreens.com 
[
    "Moderna",
    "Pfizer"
]
 
[
    "walgreens:11881",
    "vaccinefinder:795ff3ff-5a23-4837-b889-46823ae2787b",
    "vaccinefinder_org:795ff3ff-5a23-4837-b889-46823ae2787b",
    "_tag_provider:walgreens",
    "us_carbon_health:1eb619bf-26a6-4c16-b6d9-b864cc32438f"
]
   https://www.vaccinatethestates.com/?lng=-90.64878&lat=40.91781#lpfbq lpfbq <Binary: 60 bytes> 40.91781 -90.64878

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;