locations_expanded (view)

Data source: Vaccinate The States

17 rows where county = "Nevada" and state = "CA"

✎ 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
235 WALGREENS #10881 CA Pharmacy 530-271-1021 880 Sutton Way, Grass Valley, CA 95945   Nevada   
{
    "unstructured": "Monday - Friday: 8:00 AM \u2013 9:00 PM\nSaturday: 9:00am - 6:00pm (lunch 1:30 - 2:00pm)\nSunday: 10:00am - 6:00pm (lunch 1:30 - 2:00pm)"
}
   
[
    "Pfizer"
]
 
[
    "google_places:ChIJywzVe2Bwm4ARkof3qz-xQqk",
    "vaccinefinder:dddcd331-68e2-48b1-a5e5-0663be5034d6",
    "walgreens:10881",
    "vaccinespotter_org:2736957",
    "vaccinefinder_org:dddcd331-68e2-48b1-a5e5-0663be5034d6",
    "_tag_provider:walgreens",
    "us_carbon_health:23157b11-e3e3-4d02-8cee-631f6a136567",
    "us_carbon_health:51b62217-b784-4662-9dd1-a5f45ebc32f4"
]
 2021-05-11T22:29:46.038313+00:00 https://www.vaccinatethestates.com/?lng=-121.03496&lat=39.23521#rec3KyhfF2e3MRN96 rec3KyhfF2e3MRN96 <Binary: 60 bytes> 39.23521 -121.03496
927 RITE AID PHARMACY 06089 CA Pharmacy 530-273-7399 720 SUTTON WAY, GRASS VALLEY, CA 95945   Nevada   
{
    "unstructured": "Monday-Friday 8:00 AM - 9:00 PM\nSaturday\t9:00 AM - 6:00 PM\nSunday\t10:00 AM - 6:00 PM"
}
   
[
    "Johnson & Johnson"
]
 
[
    "google_places:ChIJQxgGS2Bwm4ARP_FXDEVl2DI",
    "vaccinefinder:df78e941-48e5-4651-97f5-38ceba8dbe90",
    "vaccinespotter_org:7384760",
    "rite_aid:106089",
    "vaccinefinder_org:df78e941-48e5-4651-97f5-38ceba8dbe90",
    "_tag_provider:rite_aid",
    "us_carbon_health:49abb3f7-9070-4567-a62d-b487ff260b6b"
]
 2021-05-07T23:44:03.933023+00:00 https://www.vaccinatethestates.com/?lng=-121.03655&lat=39.23363#recCoeeeEi9SZ357c recCoeeeEi9SZ357c <Binary: 60 bytes> 39.23363 -121.03655
1475 SAFEWAY PHARMACY #1266 CA Pharmacy 530-582-7952 11290 DONNER PASS RD, TRUCKEE, CA 96161   Nevada   
{
    "unstructured": "Monday - Friday: 9:00 AM \u2013 1:00 PM, 1:45 \u2013 8:00 PM\nSaturday: 9:00 AM \u2013 1:00 PM, 1:45 \u2013 5:00 PM\nSunday: 10:00 AM \u2013 1:00 PM, 1:45 \u2013 5:00 PM"
}
   
[
    "Moderna"
]
 
[
    "google_places:ChIJQxJhPTPem4AREa9YwvaUSzM",
    "vaccinefinder:d7cbeda7-84a3-4c52-8dbe-5630f4f3d8c2",
    "vaccinespotter_org:1046865",
    "vaccinefinder_org:d7cbeda7-84a3-4c52-8dbe-5630f4f3d8c2",
    "safeway:1266",
    "us_giscorps_vaccine_providers:856f3a74-bc0e-492b-8cf1-09c502a2d114",
    "us_carbon_health:1fa86ad4-4544-42cb-a9e1-4e152753dbfe",
    "_tag_provider:safeway",
    "us_carbon_health:4265894e-cc63-45d0-844a-15b7931d4990"
]
 2021-05-07T00:28:47.863356+00:00 https://www.vaccinatethestates.com/?lng=-120.20660&lat=39.32725#recKCiHVhz25tZU5F recKCiHVhz25tZU5F <Binary: 60 bytes> 39.32725 -120.2066
1724 Kuldip Gill MD PC CA Private Practice (530) 273-8452 280 Sierra College Drive Ste 205, Grass Valley, CA 95945   Nevada   
{
    "unstructured": null
}
 http://gill-kuldip-s-md.lany.io/ 
[]
 
[
    "google_places:ChIJNXlQK2xwm4ARQy4Xzq6fqls",
    "vaccinefinder:0adf5882-8000-4aac-9b60-b07ca86ac4a5",
    "us_carbon_health:df9785d9-86cf-44e1-a99b-50b9c99b93bb"
]
 2021-05-12T23:49:03.582688+00:00 https://www.vaccinatethestates.com/?lng=-121.05165&lat=39.23365#recNwL3BRnutvxgRu recNwL3BRnutvxgRu <Binary: 60 bytes> 39.23365 -121.05165
2622 Western Sierra Clinic CA Pharmacy (530) 274-9762 844 Old Tunnel Rd, Grass Valley, CA 95945   Nevada   
{
    "unstructured": "Monday - Friday: 9:00 AM \u2013 5:00 PM\nSaturday - Sunday: Closed"
}
   
[]
 
[
    "google_places:ChIJHWL8UIpwm4AR7PMJfDCk0bw"
]
 2021-04-28T17:51:54.439211+00:00 https://www.vaccinatethestates.com/?lng=-121.03122&lat=39.23567#recaUfjjUcl4u7hvi recaUfjjUcl4u7hvi <Binary: 60 bytes> 39.23567 -121.03122
2728 CVS Pharmacy® & Drug Store at 11411 Deerfield Dr Truckee, CA 96161 CA Pharmacy 530-587-5775 11411 Deerfield Dr, Truckee CA, 96161   Nevada   
{
    "unstructured": "Mo-Fr  07:00:00-22:00:00 | Sa  07:00:00-23:00:00 | Su  07:00:00-23:00:00"
}
 https://www.cvs.com/store-locator/details-directions/9174 
[
    "Pfizer"
]
 
[
    "google_places:ChIJq16Jd0rem4ARqs1fZgqDXBg"
]
 2021-05-11T22:02:27.874203+00:00 https://www.vaccinatethestates.com/?lng=-120.20930&lat=39.31970#recc1b3GSfyQcb6EI recc1b3GSfyQcb6EI <Binary: 60 bytes> 39.3197 -120.2093
3061 DOKIMOS NEVADA CITY PHARMACY CA Pharmacy 530-470-8854 737 ZION ST, NEVADA CITY, CA 95959   Nevada   
{
    "unstructured": "Monday - Friday: 9:00 AM \u2013 6:00 PM\r\nSaturday: 9:00 AM \u2013 1:00 PM\r\nSunday: Closed"
}
   
[
    "Pfizer"
]
 
[
    "google_places:ChIJvSQImnh6m4ARE2MS05QruAk",
    "vaccinefinder:23acc4bb-ea01-4078-a662-4ee91a543a7f",
    "us_carbon_health:ce569548-b3af-4443-99b4-7df2729f7774"
]
 2021-05-07T17:35:18.571831+00:00 https://www.vaccinatethestates.com/?lng=-121.02530&lat=39.25465#rech2kLn9doOi61PW rech2kLn9doOi61PW <Binary: 60 bytes> 39.25465 -121.0253
3288 KMART PHARMACY #9746 CA Pharmacy 530-272-2697 111 W MCKNIGHT WAY, GRASS VALLEY, CA 95949   Nevada   
{
    "unstructured": "Monday - Saturday: 9:00 AM \u2013 7:00 PM\nSunday: Closed"
}
   
[]
 
[
    "google_places:ChIJoSQ9Pclxm4ARWw3KU3aFK_8",
    "vaccinefinder:9687dab8-0916-41d9-8735-975071c2967d",
    "vaccinefinder_org:8e6214ed-51aa-4abd-ae1d-f49cf921cd70",
    "vaccinefinder_org:9687dab8-0916-41d9-8735-975071c2967d",
    "us_carbon_health:74404f6c-b389-4187-9063-a6b91110ed92",
    "us_carbon_health:c415960a-ccff-4844-8f7a-f33e9a80b5e5"
]
 2021-05-13T00:25:44.672669+00:00 https://www.vaccinatethestates.com/?lng=-121.06029&lat=39.19882#reckByRy4TwR1o2ga reckByRy4TwR1o2ga <Binary: 60 bytes> 39.19882 -121.06029
3549 Sierra College Tahoe-Truckee Campus CA Super Site   11001 College Trail, Truckee, CA 96161   Nevada   
{
    "unstructured": null
}
 https://www.tfhd.com/covid-19-vaccine-scheduling 
[]
 
[
    "google_places:ChIJ7VSlfLXfm4ARpgydqgf6jEQ",
    "us_giscorps_vaccine_providers:56aafb1a-508f-4fd9-b153-f393fc265bed",
    "us_carbon_health:4f7664b0-b687-43e5-b979-46941b700ce3"
]
 2021-04-29T09:05:28.837933+00:00 https://www.vaccinatethestates.com/?lng=-120.20304&lat=39.32148#recntupg9aoDiW6Dn recntupg9aoDiW6Dn <Binary: 60 bytes> 39.32148 -120.20304
3576 Sierra Family Health Center CA Hospital / Clinic (530) 292-3478 15301 Tyler Foote Road, Nevada City, CA 95959   Nevada   
{
    "unstructured": "Monday - Friday: 9:00 AM \u2013 5:00 PM; Saturday - Sunday: Closed"
}
 http://www.sierraclinic.org/ 
[
    "Moderna"
]
 
[
    "google_places:ChIJnZWbIQF9m4ARVX8xjjb3Z1M",
    "vaccinefinder:c8adb3ff-2496-4dfb-bcf6-3ea600a189c5",
    "us_carbon_health:ff2f7694-4f9b-436b-91d0-969be166c4ad"
]
 2021-05-05T16:45:23.587721+00:00 https://www.vaccinatethestates.com/?lng=-121.03680&lat=39.36584#recoHvAIvLf19g453 recoHvAIvLf19g453 <Binary: 60 bytes> 39.36584 -121.0368
3694 RITE AID PHARMACY 06108 CA Pharmacy 530-587-5296 11230 DONNER PASS ROAD GATEWAY SHOPPING CENTER, TRUCKEE, CA 96161   Nevada   
{
    "unstructured": "Monday - Sunday: 8:00 AM \u2013 10:00 PM"
}
   
[
    "Johnson & Johnson"
]
 
[
    "google_places:ChIJeemQrczfm4ARvL8kKl1PHi4",
    "vaccinefinder:fda0d7d2-9251-40f8-8b53-829c8b104010",
    "vaccinespotter_org:7381414"
]
 2021-05-07T22:26:53.150926+00:00 https://www.vaccinatethestates.com/?lng=-120.20506&lat=39.32695#recpqSu5IgvgbUGWg recpqSu5IgvgbUGWg <Binary: 60 bytes> 39.32695 -120.20506
3799 SAVE MART PHARMACY - GRASS VALLEY #608 CA Pharmacy 530-477-6857 2054 NEVADA CITY HWY, GRASS VALLEY, CA 95945   Nevada   
{
    "unstructured": "Monday - Friday: 9:00 AM \u2013 8:00 PM\nSaturday - Sunday: 9:00 AM \u2013 5:00 PM"
}
   
[]
 
[
    "google_places:ChIJZXgDOGNwm4ARc2uT5xznEag",
    "us_carbon_health:ccd91097-5aea-4dd5-91e7-37513fde231e"
]
 2021-05-12T22:22:20.568838+00:00 https://www.vaccinatethestates.com/?lng=-121.03609&lat=39.23848#recrYmQjnklZNYKdj recrYmQjnklZNYKdj <Binary: 60 bytes> 39.23848 -121.03609
4134 DOKIMOS EAST MAIN PHARMACY CA Pharmacy 530-274-0100 640 E MAIN ST STE 2, GRASS VALLEY, CA 95945   Nevada   
{
    "unstructured": "Monday - Friday: 9:00 AM \u2013 6:00 PM\r\nSaturday: 9:00 AM \u2013 1:00 PM\r\nSunday: Closed"
}
   
[]
 
[
    "google_places:ChIJEVGnOUBwm4ARQnJ59laalCE"
]
 2021-05-06T17:13:33.396663+00:00 https://www.vaccinatethestates.com/?lng=-121.05454&lat=39.22471#recwQ7ZsY5YvFeGwi recwQ7ZsY5YvFeGwi <Binary: 60 bytes> 39.22471 -121.05454
4911 CVS Pharmacy at 10045 Combie Rd CA Pharmacy 530-268-3753 10045 Combie Rd, Auburn, CA 95602   Nevada   
{
    "unstructured": "M-F:9:00 AM - 8:00 PM; Sat:10:00 AM - 6:00 PM; Sun:10:00 AM - 6:00 PM"
}
   
[
    "Moderna"
]
 
[
    "google_places:ChIJD07LHWMSm4ARsC_k3qs-tHQ",
    "vaccinefinder:2015fa68-9443-404f-bd93-4d7ce61bcbd6",
    "us_giscorps_vaccine_providers:50b7a10c-40fd-4b8b-bfbd-d3a56f341e82",
    "vaccinespotter_org:270489680",
    "us_carbon_health:9ec94363-dcec-47b8-b046-073b3368b8dc",
    "us_carbon_health:dcf6c5aa-d418-4d5b-8ce2-4121e4c1a281"
]
 2021-05-11T17:55:54.268390+00:00 https://www.vaccinatethestates.com/?lng=-121.09259&lat=39.04179#recqbQdpvroGffxtF recqbQdpvroGffxtF <Binary: 60 bytes> 39.04179 -121.09259
5007 Whispering Pines Clinic - Grass Valley CA Hospital / Clinic   1345 Whispering Pines Lane Grass Valley, CA 95945, USA   Nevada   
{
    "unstructured": null
}
 https://www.mynevadacounty.com/3148/Get-Vaccine-Information 
[]
 
[
    "google_places:ChIJHWL8UIpwm4ARXxeSpB3m0rY"
]
 2021-05-17T02:14:07.108304+00:00 https://www.vaccinatethestates.com/?lng=-121.03050&lat=39.22191#recFlwwFM4zxs3JfU recFlwwFM4zxs3JfU <Binary: 60 bytes> 39.22191 -121.0305
48485 Save Mart Supermarkets #068123 CA Unknown 530-477-6857 12054 NEVADA CITY HWY GRASS VALLEY, CA 95945 GRASS VALLEY Nevada 95945 
{
    "unstructured": null
}
 https://savemartluckysched.rxtouch.com/smsched/program/covid19/patient/advisory 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:b4e7252d-7db8-40c0-a780-97e5ea12ff2e"
]
   https://www.vaccinatethestates.com/?lng=-121.03775&lat=39.23908#lwxpp lwxpp <Binary: 60 bytes> 39.23908 -121.03775
54816 Chapa-De Indian Health CA Unknown (530) 477-8545 1350 East Main Street Grass Valley, CA 95945 Grass Valley Nevada 95945 
{
    "unstructured": null
}
   
[]
 
[
    "us_giscorps_vaccine_providers:83bfa787-b757-434a-a89f-3b5ae6de8460"
]
   https://www.vaccinatethestates.com/?lng=-121.04649&lat=39.23182#lymcp lymcp <Binary: 60 bytes> 39.23182 -121.04649

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;