VaccinateCA

Ten random locations with no county

Owned by swillison, visibility: Public

SQL query
select name, full_address, 'https://vial.calltheshots.us/admin/core/location/' || id || '/change/' as edit_link from location where county_id is null order by random() limit 10

1 row

name full_address edit_link
Bessie Kaningok Clinic 190 Clinic Rd Gambell, AK 99742 https://vial.calltheshots.us/admin/core/location/80910/change/
Copy and export data

Duration: 4.30ms

Number of locations with no county

1

SQL query
select count(*) as big_number, 'Number of locations with no county' as label from location where county_id is null
SQL query
select state.name, count(*) as number_of_locations_with_no_county from location join state on state.id = location.state_id where location.county_id is null group by state.name

1 row

name number_of_locations_with_no_county
Alaska 1
Copy and export data

Duration: 3.24ms