ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 447 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
county 9
- Kings 17
- Solano 10
- Fresno 3
- San Mateo 3
- Kern 1
- Merced 1
- Sacramento 1
- San Joaquin 1
- Santa Barbara 1
state 1
- California · 38 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499777 | 2499777 | 2022-05-13 | Kings | California | 6031 | 55429 | 447 |
2496519 | 2496519 | 2022-05-12 | Kings | California | 6031 | 55391 | 447 |
2493261 | 2493261 | 2022-05-11 | Kings | California | 6031 | 55391 | 447 |
2490003 | 2490003 | 2022-05-10 | Kings | California | 6031 | 55391 | 447 |
2486746 | 2486746 | 2022-05-09 | Kings | California | 6031 | 55341 | 447 |
2483488 | 2483488 | 2022-05-08 | Kings | California | 6031 | 55341 | 447 |
2480230 | 2480230 | 2022-05-07 | Kings | California | 6031 | 55341 | 447 |
2476972 | 2476972 | 2022-05-06 | Kings | California | 6031 | 55341 | 447 |
2473714 | 2473714 | 2022-05-05 | Kings | California | 6031 | 55300 | 447 |
2470457 | 2470457 | 2022-05-04 | Kings | California | 6031 | 55300 | 447 |
2467201 | 2467201 | 2022-05-03 | Kings | California | 6031 | 55300 | 447 |
2463946 | 2463946 | 2022-05-02 | Kings | California | 6031 | 55277 | 447 |
2460690 | 2460690 | 2022-05-01 | Kings | California | 6031 | 55277 | 447 |
2457434 | 2457434 | 2022-04-30 | Kings | California | 6031 | 55277 | 447 |
2454178 | 2454178 | 2022-04-29 | Kings | California | 6031 | 55277 | 447 |
2450922 | 2450922 | 2022-04-28 | Kings | California | 6031 | 55249 | 447 |
2444410 | 2444410 | 2022-04-26 | Kings | California | 6031 | 55249 | 447 |
2428162 | 2428162 | 2022-04-21 | Solano | California | 6095 | 87416 | 447 |
2424906 | 2424906 | 2022-04-20 | Solano | California | 6095 | 87416 | 447 |
2421650 | 2421650 | 2022-04-19 | Solano | California | 6095 | 87416 | 447 |
2418394 | 2418394 | 2022-04-18 | Solano | California | 6095 | 87356 | 447 |
2415138 | 2415138 | 2022-04-17 | Solano | California | 6095 | 87356 | 447 |
2411882 | 2411882 | 2022-04-16 | Solano | California | 6095 | 87356 | 447 |
2408626 | 2408626 | 2022-04-15 | Solano | California | 6095 | 87356 | 447 |
2382583 | 2382583 | 2022-04-07 | Solano | California | 6095 | 87342 | 447 |
2379328 | 2379328 | 2022-04-06 | Solano | California | 6095 | 87342 | 447 |
2376074 | 2376074 | 2022-04-05 | Solano | California | 6095 | 87342 | 447 |
1251795 | 1251795 | 2021-04-24 | Santa Barbara | California | 6083 | 34017 | 447 |
1199815 | 1199815 | 2021-04-08 | Merced | California | 6047 | 30985 | 447 |
1018030 | 1018030 | 2021-02-11 | San Mateo | California | 6081 | 37437 | 447 |
1014785 | 1014785 | 2021-02-10 | San Mateo | California | 6081 | 37277 | 447 |
1011540 | 1011540 | 2021-02-09 | San Mateo | California | 6081 | 37139 | 447 |
761618 | 761618 | 2020-11-24 | Kern | California | 6029 | 39721 | 447 |
699964 | 699964 | 2020-11-05 | Fresno | California | 6019 | 32022 | 447 |
696720 | 696720 | 2020-11-04 | Fresno | California | 6019 | 32022 | 447 |
693478 | 693478 | 2020-11-03 | Fresno | California | 6019 | 32022 | 447 |
609160 | 609160 | 2020-10-08 | Sacramento | California | 6067 | 23522 | 447 |
579992 | 579992 | 2020-09-29 | San Joaquin | California | 6077 | 20357 | 447 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);