ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 741 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 4
- Imperial 27
- Monterey 3
- Sacramento 3
- Kern 1
state 1
- California · 34 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470468 | 2470468 | 2022-05-04 | Monterey | California | 6053 | 94198 | 741 |
2467212 | 2467212 | 2022-05-03 | Monterey | California | 6053 | 94198 | 741 |
2463957 | 2463957 | 2022-05-02 | Monterey | California | 6053 | 94041 | 741 |
1550427 | 1550427 | 2021-07-25 | Imperial | California | 6025 | 31944 | 741 |
1547180 | 1547180 | 2021-07-24 | Imperial | California | 6025 | 31944 | 741 |
1543933 | 1543933 | 2021-07-23 | Imperial | California | 6025 | 31944 | 741 |
1540685 | 1540685 | 2021-07-22 | Imperial | California | 6025 | 31912 | 741 |
1537438 | 1537438 | 2021-07-21 | Imperial | California | 6025 | 31880 | 741 |
1534190 | 1534190 | 2021-07-20 | Imperial | California | 6025 | 31835 | 741 |
1530943 | 1530943 | 2021-07-19 | Imperial | California | 6025 | 31824 | 741 |
1527696 | 1527696 | 2021-07-18 | Imperial | California | 6025 | 31787 | 741 |
1524449 | 1524449 | 2021-07-17 | Imperial | California | 6025 | 31787 | 741 |
1521201 | 1521201 | 2021-07-16 | Imperial | California | 6025 | 31787 | 741 |
1517953 | 1517953 | 2021-07-15 | Imperial | California | 6025 | 31769 | 741 |
1485487 | 1485487 | 2021-07-05 | Imperial | California | 6025 | 28981 | 741 |
1482241 | 1482241 | 2021-07-04 | Imperial | California | 6025 | 28981 | 741 |
1478994 | 1478994 | 2021-07-03 | Imperial | California | 6025 | 28981 | 741 |
1475748 | 1475748 | 2021-07-02 | Imperial | California | 6025 | 28981 | 741 |
1472502 | 1472502 | 2021-07-01 | Imperial | California | 6025 | 28981 | 741 |
1469257 | 1469257 | 2021-06-30 | Imperial | California | 6025 | 28981 | 741 |
1466012 | 1466012 | 2021-06-29 | Imperial | California | 6025 | 28981 | 741 |
1462767 | 1462767 | 2021-06-28 | Imperial | California | 6025 | 28987 | 741 |
1459522 | 1459522 | 2021-06-27 | Imperial | California | 6025 | 28970 | 741 |
1456277 | 1456277 | 2021-06-26 | Imperial | California | 6025 | 28968 | 741 |
1453032 | 1453032 | 2021-06-25 | Imperial | California | 6025 | 28981 | 741 |
1449786 | 1449786 | 2021-06-24 | Imperial | California | 6025 | 28908 | 741 |
1446541 | 1446541 | 2021-06-23 | Imperial | California | 6025 | 28880 | 741 |
1443296 | 1443296 | 2021-06-22 | Imperial | California | 6025 | 28855 | 741 |
1420573 | 1420573 | 2021-06-15 | Imperial | California | 6025 | 28836 | 741 |
1417328 | 1417328 | 2021-06-14 | Imperial | California | 6025 | 28800 | 741 |
1043967 | 1043967 | 2021-02-19 | Kern | California | 6029 | 101370 | 741 |
846017 | 846017 | 2020-12-20 | Sacramento | California | 6067 | 55168 | 741 |
842771 | 842771 | 2020-12-19 | Sacramento | California | 6067 | 54002 | 741 |
839526 | 839526 | 2020-12-18 | Sacramento | California | 6067 | 54002 | 741 |
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);