locations_expanded (view)

Data source: Vaccinate The States

21 rows where county = "Kankakee" and state = "IL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, location_type, city, zip_code, hours, website, vaccines_offered, geometry, latitude, longitude

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
7474 Osco Drug #1156 IL Pharmacy 815-935-2041 446 S Washington Ave, Kankakee, IL 60901 Kankakee Kankakee 60901 
{
    "unstructured": "08:00AM - 09:00PM Mon-Fri, 09:00AM - 06:00PM Sat, 09:00AM - 05:00PM Sun"
}
 https://www.jewelosco.com/pharmacy/covid-19.html 
[
    "Moderna"
]
 
[
    "vaccinefinder:52704c1d-760a-4e7a-9ff7-5a1f7f162aef",
    "vaccinefinder_org:52704c1d-760a-4e7a-9ff7-5a1f7f162aef",
    "il_sfsites:a05t000000972TwAAI",
    "il_sfsites:a05t000000973NXAAY",
    "osco:1156",
    "il_sfsites:a05t000000973lsAAA",
    "us_giscorps_vaccine_providers:c7848c4b-5507-4ca3-ac42-01f20f95e751",
    "vaccinespotter_org:1046654",
    "_tag_provider:osco",
    "us_carbon_health:6ae9b497-c5fa-46e4-92d3-9080cc239e31"
]
   https://www.vaccinatethestates.com/?lng=-87.86740&lat=41.11622#ldtcp ldtcp <Binary: 60 bytes> 41.11622 -87.8674
7791 Osco Drug #2488 IL Pharmacy 815-929-0590 655 Main St Nw, Bourbonnais, IL 60914 Bourbonnais Kankakee 60914 
{
    "unstructured": "08:00AM - 09:00PM Mon-Fri, 09:00AM - 06:00PM Sat, 09:00AM - 05:00PM Sun"
}
 https://www.jewelosco.com/pharmacy/covid-19.html 
[
    "Moderna"
]
 
[
    "vaccinefinder:70ad2961-872d-4716-ac64-9fee6e411215",
    "il_sfsites:a05t000000972TxAAI",
    "il_sfsites:a05t000000973NYAAY",
    "il_sfsites:a05t000000973ltAAA",
    "vaccinefinder_org:70ad2961-872d-4716-ac64-9fee6e411215",
    "osco:2488",
    "us_giscorps_vaccine_providers:af78fe3a-c35c-4ee4-be0f-df7fea6f0f19",
    "_tag_provider:osco",
    "us_carbon_health:7242e6db-4e1c-4db7-92a9-7bf9215354c8"
]
   https://www.vaccinatethestates.com/?lng=-87.88612&lat=41.16089#ldwhh ldwhh <Binary: 60 bytes> 41.16089 -87.88612
10546 CVS Pharmacy, Inc. #02663 IL Pharmacy (815) 929-3451 225 West Court St, Kankakee, IL 60901 Kankakee Kankakee 60901 
{
    "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/002663 
[
    "Pfizer"
]
 
[
    "cvs:02663",
    "vaccinefinder:30303511-91a3-4d15-9367-d08c319dfde6",
    "us_giscorps_vaccine_providers:61ee96c5-4fc9-4fc1-981e-86cb0d328c15",
    "vaccinespotter_org:270267175",
    "_tag_provider:cvs",
    "il_sfsites:a05t0000009768ZAAQ"
]
   https://www.vaccinatethestates.com/?lng=-87.86810&lat=41.12119#lfmdq lfmdq <Binary: 60 bytes> 41.12119 -87.8681
13970 Kankakee County Health Department IL Pharmacy (815) 802-9349 2390 W Station St, Kankakee, IL 60901-3000 Kankakee Kankakee 60901-3000 
{
    "unstructured": "8:30 AM - 4:30 PM Mon-Fri, Closed Sat-Sun"
}
 http://www.kankakeehealth.org 
[]
 
[
    "vaccinefinder:945f0095-ff79-4ff0-923b-e1d3c982cb21"
]
   https://www.vaccinatethestates.com/?lng=-87.89808&lat=41.11741#lggrd lggrd <Binary: 60 bytes> 41.11741 -87.89808
14908 Kroger Pharmacy #02100984 IL Pharmacy (815) 935-1653 633 Armour Rd, Bourbonnais, IL 60914 Bourbonnais Kankakee 60914 
{
    "unstructured": "9:00 AM - 9:00 PM Mon-Fri, 9:00 AM - 6:00 PM Sat, 11:00 AM - 6:00 PM Sun"
}
 www.krogerhealth.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:413697a9-4573-4c96-8082-acf6703e6e26",
    "il_sfsites:a05t000000972VWAAY",
    "il_sfsites:a05t000000973P6AAI",
    "il_sfsites:a05t000000973nSAAQ",
    "vaccinefinder_org:413697a9-4573-4c96-8082-acf6703e6e26",
    "kroger:2100984",
    "vaccinespotter_org:9612013"
]
   https://www.vaccinatethestates.com/?lng=-87.87247&lat=41.16363#lgpgy lgpgy <Binary: 60 bytes> 41.16363 -87.87247
18309 Meijer #301 IL Pharmacy 779-301-8210 990 N Kinzie Ave, Bradley, IL 60915 Bradley Kankakee 60915 
{
    "unstructured": "08:00AM - 09:00PM Mon-Fri, 08:00AM - 06:00PM Sat, 10:00AM - 06:00PM Sun"
}
 https://www.meijer.com/services/pharmacy.html 
[]
 
[
    "vaccinefinder:2f8f0af6-6e55-4b1c-bddb-d8fd7796980b",
    "il_sfsites:a05t000000972XBAAY",
    "il_sfsites:a05t000000973QnAAI",
    "il_sfsites:a05t000000973p8AAA",
    "vaccinefinder_org:2f8f0af6-6e55-4b1c-bddb-d8fd7796980b",
    "meijer:301",
    "_tag_provider:meijer",
    "us_carbon_health:eb86d450-6155-42b3-a760-f43b63f934a4"
]
   https://www.vaccinatethestates.com/?lng=-87.84730&lat=41.15876#lhhrb lhhrb <Binary: 60 bytes> 41.15876 -87.8473
26862 Walgreens Co. #4142 IL Pharmacy 815-932-9615 1050 N Kennedy Dr, Kankakee, IL 60901-2033 Kankakee Kankakee 60901-2033 
{
    "unstructured": "12:00AM - 11:59PM"
}
 https://www.walgreens.com 
[
    "Moderna"
]
 
[
    "walgreens:4142",
    "vaccinefinder:32efb65d-47be-4193-95ac-2ad4a088c6e0",
    "vaccinefinder_org:32efb65d-47be-4193-95ac-2ad4a088c6e0",
    "us_carbon_health:10ee5377-ea6a-4965-a5b9-89ca9233d0ac",
    "_tag_provider:walgreens"
]
   https://www.vaccinatethestates.com/?lng=-87.87730&lat=41.13236#lmmfq lmmfq <Binary: 60 bytes> 41.13236 -87.8773
29215 Walgreens Co. #10339 IL Pharmacy 815-937-0632 501 N Convent St, Bourbonnais, IL 60914-1329 Bourbonnais Kankakee 60914-1329 
{
    "unstructured": "06:00AM - 11:59PM"
}
 https://www.walgreens.com 
[
    "Moderna"
]
 
[
    "walgreens:10339",
    "vaccinefinder:87239ebc-6e43-42e4-b92c-51dd201ece49",
    "vaccinefinder_org:87239ebc-6e43-42e4-b92c-51dd201ece49",
    "_tag_provider:walgreens",
    "us_carbon_health:66524050-e603-448a-a8b2-0375b792d779"
]
   https://www.vaccinatethestates.com/?lng=-87.87599&lat=41.16313#lpbkr lpbkr <Binary: 60 bytes> 41.16313 -87.87599
30093 Walgreens Co. #12468 IL Pharmacy 815-936-0817 222 W Court St, Kankakee, IL 60901-3711 Kankakee Kankakee 60901-3711 
{
    "unstructured": "08:00AM - 10:00PM Mon-Fri, 08:00AM - 10:00PM Sat, 09:00AM - 9:00PM Sun"
}
 https://www.walgreens.com 
[
    "Moderna"
]
 
[
    "walgreens:12468",
    "vaccinefinder:3b036117-ed5d-4e77-a5e7-8b936d44c863",
    "vaccinefinder_org:3b036117-ed5d-4e77-a5e7-8b936d44c863",
    "_tag_provider:walgreens",
    "us_carbon_health:4893fb1f-f92b-4a94-8ee9-a49185560200"
]
   https://www.vaccinatethestates.com/?lng=-87.86825&lat=41.12025#lpfxp lpfxp <Binary: 60 bytes> 41.12025 -87.86825
33115 Walmart Inc #10-1307 IL Pharmacy 8159375100 2080 N State Route 50, Bourbonnais, IL 60914-4410 Bourbonnais Kankakee 60914-4410 
{
    "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/1307 
[]
 
[
    "vaccinefinder:9e645393-6af7-4168-b19f-0c090c041031",
    "us_carbon_health:2d02f642-7f79-4fe5-8d66-963b29ed8b1b",
    "walmart:1307",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-87.84669&lat=41.19017#lpzrp lpzrp <Binary: 60 bytes> 41.19017 -87.84669
35068 Walmart Inc #10-4323 IL Pharmacy 8158021884 505 Riverstone Pkwy, Kankakee, IL 60901-7207 Kankakee Kankakee 60901-7207 
{
    "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/4323 
[]
 
[
    "vaccinefinder:cdd73adb-6add-4b88-a0b6-b04a17f6ae5a",
    "us_carbon_health:a713d0f0-92ab-45bb-9dbd-d5f30d66e0ec",
    "walmart:4323",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-87.86142&lat=41.08040#lqmgr lqmgr <Binary: 60 bytes> 41.0804 -87.86142
38669 Main Street Pharmacy IL Pharmacy   24 W First St, Manteno, IL 60950-1239 Manteno Kankakee 60950-1239 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[]
   https://www.vaccinatethestates.com/?lng=-87.83531&lat=41.25016#lrhth lrhth <Binary: 60 bytes> 41.25016 -87.83531
41640 St. Marys Hospital Kankakee IL Unknown   500 W Court Kankakee, IL 60901 Kankakee Kankakee 60901 
{
    "unstructured": null
}
 https://www.amitahealth.org/covid-19/vaccine 
[]
 
[
    "il_sfsites:a05t000000972XyAAI"
]
   https://www.vaccinatethestates.com/?lng=-87.87181&lat=41.12101#ltcwt ltcwt <Binary: 60 bytes> 41.12101 -87.87181
41678 CVS IL Unknown   2764 N.ST RT 1-17 MOMENCE, IL 60954 MOMENCE Kankakee 60954 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine?icid=cvs-home-hero1-link1-coronavirus-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "il_sfsites:a05t000000972S8AAI",
    "il_sfsites:a05t000000973k5AAA",
    "cvs:10736",
    "vaccinefinder_org:a78c8e15-22b5-4d6d-83f2-17efe39a62f8",
    "vaccinespotter_org:270632482"
]
   https://www.vaccinatethestates.com/?lng=-87.66621&lat=41.15876#ltczc ltczc <Binary: 60 bytes> 41.15876 -87.66621
41720 IDHS - Shapiro Developmental Center Vaccination POD IL Unknown   100 E. Jeffery St Kankakee, IL 60901 Kankakee Kankakee 60901 
{
    "unstructured": null
}
 https://covidvaccination.dph.illinois.gov/ 
[]
 
[
    "il_sfsites:a05t000000973l8AAA",
    "il_juvare:9c613793-7b66-4f0c-8f2e-09c30d953ad0"
]
   https://www.vaccinatethestates.com/?lng=-87.86773&lat=41.10579#ltdcx ltdcx <Binary: 60 bytes> 41.10579 -87.86773
41850 CVS IL Unknown   279 W RT 115 HERSCHER, IL 60941 HERSCHER Kankakee 60941 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine?icid=cvs-home-hero1-link1-coronavirus-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "il_sfsites:a05t000000972ReAAI",
    "il_sfsites:a05t000000973jbAAA",
    "us_giscorps_vaccine_providers:25945619-96d2-41ec-88e2-868ebb40bdd9",
    "vaccinespotter_org:270630133",
    "vaccinefinder_org:b9f6cb50-b0d8-4a5c-bdff-a36ae5cd72c7",
    "cvs:10674"
]
   https://www.vaccinatethestates.com/?lng=-88.10027&lat=41.05748#ltdrb ltdrb <Binary: 60 bytes> 41.05748 -88.10027
42423 St. Mary's Hospital IL Unknown   1800 E Lakeshore Dr. Decatur, IL 62521 Decatur Kankakee 62521 
{
    "unstructured": null
}
 https://www.amitahealth.org/covid-19/vaccine 
[]
 
[
    "il_sfsites:a05t000000972XxAAI"
]
   https://www.vaccinatethestates.com/?lng=-87.87181&lat=41.12101#ltgyy ltgyy <Binary: 60 bytes> 41.12101 -87.87181
42494 CVS IL Unknown   47 S LOCUST MANTENO, IL 60950 MANTENO Kankakee 60950 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine?icid=cvs-home-hero1-link1-coronavirus-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "il_sfsites:a05t000000972R6AAI",
    "vaccinefinder_org:c708408b-c024-4e51-ba1d-e14542a40e26",
    "cvs:10680",
    "vaccinespotter_org:270632950"
]
   https://www.vaccinatethestates.com/?lng=-87.83389&lat=41.24772#lthfm lthfm <Binary: 60 bytes> 41.24772 -87.83389
43208 CVS Pharmacy in BOURBONNAIS, IL IL Unknown   1615 N STATE ROUTE 50 BOURBONNAIS, IL 60914 BOURBONNAIS Kankakee 60914 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:270758064",
    "us_giscorps_vaccine_providers:34aa44a5-79eb-41f2-9c41-a51ca2e2350a"
]
   https://www.vaccinatethestates.com/?lng=-87.85393&lat=41.17410#ltpcg ltpcg <Binary: 60 bytes> 41.1741 -87.85393
56573 Riverside Healthcare IL Unknown   1901 E Court Kankakee, IL 60901 Kankakee Kankakee 60901 
{
    "unstructured": null
}
 https://www.riversidehealthcare.org/services/covid-19/covid-19-vaccine 
[]
 
[
    "il_sfsites:a05t000000973pXAAQ"
]
   https://www.vaccinatethestates.com/?lng=-87.87462&lat=41.12125#lyyck lyyck <Binary: 60 bytes> 41.12125 -87.87462
60534 First Church of the Nazarene IL Unknown   1000 North Entrance Avenue Kankakee, IL 60901 Kankakee Kankakee 60901 
{
    "unstructured": null
}
 https://events.juvare.com/IL-IDPH/7vbvl-97/ 
[]
 
[
    "il_juvare:7vbvl-97",
    "il_sfsites:a05t0000009770RAAQ"
]
   https://www.vaccinatethestates.com/?lng=-87.86955&lat=41.13276#lzxth lzxth <Binary: 60 bytes> 41.13276 -87.86955

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;