locations_expanded (view)

Data source: Vaccinate The States

12 rows where county = "Kauai" and state = "HI"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, location_type, phone_number, city, zip_code, hours, website, vaccines_offered, geometry, latitude, longitude, 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
7483 Safeway Pharmacy #1209 HI Pharmacy 808-822-2191 831 Kuhio Highway, Kapaa, HI 96746 Kapaa Kauai 96746 
{
    "unstructured": "08:00AM - 07:00PM Mon-Fri, 09:00AM - 05:00PM Sat, 10:00AM - 05:00PM Sun"
}
 https://www.safeway.com/pharmacy/covid-19.html 
[]
 
[
    "vaccinefinder:68faf2c5-51c2-4a59-84b4-c93b3a05b8a7",
    "vaccinefinder_org:68faf2c5-51c2-4a59-84b4-c93b3a05b8a7",
    "safeway:1209",
    "us_giscorps_vaccine_providers:cb10a156-097d-4293-8e47-4834de04b6cc",
    "vaccinespotter_org:1046855",
    "us_carbon_health:aa52ad7b-7332-4e44-b082-809577e15ac2",
    "us_carbon_health:b09fbf1e-49a9-4f4e-a714-d12bd9b2f683",
    "_tag_provider:safeway"
]
   https://www.vaccinatethestates.com/?lng=-159.31742&lat=22.06890#ldtdc ldtdc <Binary: 60 bytes> 22.0689 -159.31742
7911 Safeway Pharmacy #2894 HI Pharmacy 808-246-3680 4454 Nuhou St. Ste. 301, Lihue, HI 96766 Lihue Kauai 96766 
{
    "unstructured": "08:00AM - 07:00PM Mon-Fri, 09:00AM - 05:00PM Sat, 10:00AM - 05:00PM Sun"
}
 https://www.safeway.com/pharmacy/covid-19.html 
[]
 
[
    "vaccinefinder:c8d0dfac-0a37-492a-8614-ab278198ab2c",
    "safeway:2894",
    "vaccinefinder_org:c8d0dfac-0a37-492a-8614-ab278198ab2c",
    "us_giscorps_vaccine_providers:bffa6619-33ab-47d5-81cd-c77f0e37d486",
    "vaccinespotter_org:1046946",
    "us_carbon_health:7d735d5d-194e-43d5-bae3-b69b73731e84",
    "us_carbon_health:c55c3550-e548-45d1-96b9-0a6f4926ab5d",
    "_tag_provider:safeway"
]
   https://www.vaccinatethestates.com/?lng=-159.37858&lat=21.96993#ldwwx ldwwx <Binary: 60 bytes> 21.96993 -159.37858
11583 CVS Pharmacy, Inc. #09189 HI Pharmacy (808) 245-8871 3 2600 Kaumualii Hwy Ste 1100, Lihue, HI 96766 Lihue Kauai 96766 
{
    "unstructured": "08:00AM-09:00PM Mon-Fri, 08:00AM-06:00PM Sat, 09:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/009189 
[
    "Moderna"
]
 
[
    "cvs:09189",
    "vaccinefinder:e5891c7c-7736-4545-88c8-81176022164c",
    "vaccinespotter_org:270512471",
    "us_carbon_health:e4d11047-1308-4121-bfd4-5c0ae0c9ff9c"
]
   https://www.vaccinatethestates.com/?lng=-159.37912&lat=21.97012#lftfk lftfk <Binary: 60 bytes> 21.97012 -159.37912
11617 CVS Pharmacy, Inc. #09952 HI Pharmacy (808) 822-4918 645 Aleka Loop, Kapaa, HI 96746 Kapaa Kauai 96746 
{
    "unstructured": "08:00AM-09:00PM Mon-Fri, 09:00AM-05:00PM Sat-Sun"
}
 https://www.cvs.com/store-locator/details-directions/009952 
[]
 
[
    "cvs:09952",
    "vaccinefinder:4fe25247-fd74-4df1-aa7b-44bbd1fa0f6e",
    "us_giscorps_vaccine_providers:80354b1f-89f0-4759-8544-0c59b076025c",
    "vaccinespotter_org:270505804",
    "us_carbon_health:ce7c698a-4cd2-49f6-bf24-5eb89dbe2f3a",
    "us_carbon_health:dbe7f617-de94-4947-9ed6-9446048d14ab"
]
   https://www.vaccinatethestates.com/?lng=-159.32388&lat=22.05800#lfthp lfthp <Binary: 60 bytes> 22.058 -159.32388
13084 Lihue Pharmacy Inc. HI Pharmacy (808) 246-9100 4491 Kolopa St. #A, Lihue, HI 96766 Lihue Kauai 96766 
{
    "unstructured": "9:00 AM - 5:00 PM Mon-Fri, 9:00 AM - 4:00 PM Sat-Sun"
}
 http://kauairx.com/ 
[]
 
[
    "vaccinefinder:cc54800f-5a39-4875-b17b-691cbf7662ba",
    "vaccinefinder_org:cc54800f-5a39-4875-b17b-691cbf7662ba"
]
   https://www.vaccinatethestates.com/?lng=-159.38409&lat=21.96871#lgcct lgcct <Binary: 60 bytes> 21.96871 -159.38409
33901 Walmart Inc #10-2308 HI Pharmacy 8082461599 3-3300 Kuhio Hwy, Lihue, HI 96766-1009 Lihue Kauai 96766-1009 
{
    "unstructured": "8:00 AM - 1:15PM, 2:15PM - 7:00 PM Mon, 6:00 AM - 1:15PM, 2:15PM - 7:00 PM Tue, 8:00 AM - 1:15PM, 2:15PM - 7:00 PM Wed, 8:00 AM - 1:15PM, 2:15PM - 7:00 PM Thrus, 8:00 AM - 1:15PM, 2:15PM - 7:00 PM Fri, 9:00 AM - 1:15PM, 2:15PM - 7:00 PM Sat, 10:00 AM - 1:15PM, 2:15PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/2308 
[]
 
[
    "vaccinefinder:3ada219e-a522-48d2-b12b-1e37921a87cf",
    "walmart:2308",
    "us_carbon_health:0ec887fd-cab5-48fa-822f-f68192fa3d3a",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-159.36560&lat=21.98276#lqdtr lqdtr <Binary: 60 bytes> 21.98276 -159.3656
43254 CVS Pharmacy, Inc. #09952 HI Unknown (808) 822-4918 CVS Pharmacy KAPAA, HI 96746 KAPAA Kauai 96746 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:4fe25247-fd74-4df1-aa7b-44bbd1fa0f6e",
    "cvs:9952"
]
   https://www.vaccinatethestates.com/?lng=-159.32388&lat=22.05800#ltpgd ltpgd <Binary: 60 bytes> 22.058 -159.32388
43259 FOODLAND PHARMACY #30 HI Unknown 808 826-4228 5-4280 KUHIO HWY PRINCEVILLE, HI 96722 PRINCEVILLE Kauai 96722 
{
    "unstructured": null
}
 https://healthmartcovidvaccine.com 
[]
 
[
    "vaccinefinder_org:b5b4f729-1869-42bc-88ef-c0eb40b0d113",
    "vaccinefinder_org:e9af9881-e038-4c62-9dd7-47de7c31d73b",
    "vaccinespotter_org:141602930"
]
   https://www.vaccinatethestates.com/?lng=-159.47464&lat=22.21385#ltpgm ltpgm <Binary: 60 bytes> 22.21385 -159.47464
44057 Kauai HI Unknown   4300 NUHOU ST. LIHUE, HI 96766 LIHUE Kauai 96766 
{
    "unstructured": null
}
 https://www.costco.com/covid-vaccine.html 
[]
 
[
    "vaccinespotter_org:170721049"
]
   https://www.vaccinatethestates.com/?lng=-159.38200&lat=21.96800#lttky lttky <Binary: 60 bytes> 21.968 -159.382
47842 CVS Pharmacy in KOLOA, HI HI Unknown   2829 ALA KALANIKAUMAUKA ST. SUITE M-167 KOLOA, HI 96756 KOLOA Kauai 96756 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:270772389",
    "us_carbon_health:64a94bfe-fe3d-46b3-8c98-36e0e7883097"
]
   https://www.vaccinatethestates.com/?lng=-159.46961&lat=21.88400#lwrrg lwrrg <Binary: 60 bytes> 21.884 -159.46961
47848 CVS Pharmacy HI Unknown (808) 335-0700 4469 Waialo Road Eleele, HI 96705 Eleele Kauai 96705 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[]
 
[
    "us_giscorps_vaccine_providers:d7f34a50-ea0b-4f47-95a7-ba259b7b548e",
    "us_carbon_health:19e70b12-d007-4cb5-869b-c18c905529d4"
]
   https://www.vaccinatethestates.com/?lng=-159.58570&lat=21.90500#lwrrr lwrrr <Binary: 60 bytes> 21.905 -159.5857
49726 KALAHEO PHARMACY HI Unknown   2436 KAUMUALII HIGHWAY KALAHEO, HI 96741 KALAHEO Kauai 96741 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141602931"
]
   https://www.vaccinatethestates.com/?lng=-159.52738&lat=21.92542#lxdzx lxdzx <Binary: 60 bytes> 21.92542 -159.52738

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;