locations_expanded (view)
Data source: Vaccinate The States
12 rows where county = "Kauai" and state = "HI"
This data as json, CSV (advanced)
Suggested facets: name, location_type, zip_code, website, geometry, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
CREATE VIEW locations_expanded AS select locations.rowid, locations.*, y(locations.geometry) as latitude, x(locations.geometry) as longitude from locations;