ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
814 rows where fips = 6023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10941 | 10941 | 2020-03-25 | Humboldt | California | 6023 | 10 | 0 |
9570 | 9570 | 2020-03-24 | Humboldt | California | 6023 | 5 | 0 |
8329 | 8329 | 2020-03-23 | Humboldt | California | 6023 | 2 | 0 |
7186 | 7186 | 2020-03-22 | Humboldt | California | 6023 | 2 | 0 |
6152 | 6152 | 2020-03-21 | Humboldt | California | 6023 | 2 | 0 |
5231 | 5231 | 2020-03-20 | Humboldt | California | 6023 | 2 | 0 |
4457 | 4457 | 2020-03-19 | Humboldt | California | 6023 | 1 | 0 |
3797 | 3797 | 2020-03-18 | Humboldt | California | 6023 | 1 | 0 |
3244 | 3244 | 2020-03-17 | Humboldt | California | 6023 | 1 | 0 |
2764 | 2764 | 2020-03-16 | Humboldt | California | 6023 | 1 | 0 |
2330 | 2330 | 2020-03-15 | Humboldt | California | 6023 | 1 | 0 |
1951 | 1951 | 2020-03-14 | Humboldt | California | 6023 | 1 | 0 |
1634 | 1634 | 2020-03-13 | Humboldt | California | 6023 | 1 | 0 |
1374 | 1374 | 2020-03-12 | Humboldt | California | 6023 | 1 | 0 |
1168 | 1168 | 2020-03-11 | Humboldt | California | 6023 | 1 | 0 |
1002 | 1002 | 2020-03-10 | Humboldt | California | 6023 | 1 | 0 |
870 | 870 | 2020-03-09 | Humboldt | California | 6023 | 1 | 0 |
756 | 756 | 2020-03-08 | Humboldt | California | 6023 | 1 | 0 |
661 | 661 | 2020-03-07 | Humboldt | California | 6023 | 1 | 0 |
586 | 586 | 2020-03-06 | Humboldt | California | 6023 | 1 | 0 |
536 | 536 | 2020-03-05 | Humboldt | California | 6023 | 1 | 0 |
497 | 497 | 2020-03-04 | Humboldt | California | 6023 | 1 | 0 |
462 | 462 | 2020-03-03 | Humboldt | California | 6023 | 1 | 0 |
428 | 428 | 2020-03-02 | Humboldt | California | 6023 | 1 | 0 |
401 | 401 | 2020-03-01 | Humboldt | California | 6023 | 1 | 0 |
378 | 378 | 2020-02-29 | Humboldt | California | 6023 | 1 | 0 |
356 | 356 | 2020-02-28 | Humboldt | California | 6023 | 1 | 0 |
336 | 336 | 2020-02-27 | Humboldt | California | 6023 | 1 | 0 |
316 | 316 | 2020-02-26 | Humboldt | California | 6023 | 1 | 0 |
299 | 299 | 2020-02-25 | Humboldt | California | 6023 | 1 | 0 |
283 | 283 | 2020-02-24 | Humboldt | California | 6023 | 1 | 0 |
269 | 269 | 2020-02-23 | Humboldt | California | 6023 | 1 | 0 |
255 | 255 | 2020-02-22 | Humboldt | California | 6023 | 1 | 0 |
241 | 241 | 2020-02-21 | Humboldt | California | 6023 | 1 | 0 |
228 | 228 | 2020-02-20 | Humboldt | California | 6023 | 1 | 0 |
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);