ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
814 rows where fips = 6023 and state = "California" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-02-20 1
- 2020-02-21 1
- 2020-02-22 1
- 2020-02-23 1
- 2020-02-24 1
- 2020-02-25 1
- 2020-02-26 1
- 2020-02-27 1
- 2020-02-28 1
- 2020-02-29 1
- 2020-03-01 1
- 2020-03-02 1
- 2020-03-03 1
- 2020-03-04 1
- 2020-03-05 1
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- …
state 1
- California · 814 ✖
fips 1
- 6023 · 814 ✖
county 1
- Humboldt 814
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
228 | 228 | 2020-02-20 | Humboldt | California | 6023 | 1 | 0 |
241 | 241 | 2020-02-21 | Humboldt | California | 6023 | 1 | 0 |
255 | 255 | 2020-02-22 | Humboldt | California | 6023 | 1 | 0 |
269 | 269 | 2020-02-23 | Humboldt | California | 6023 | 1 | 0 |
283 | 283 | 2020-02-24 | Humboldt | California | 6023 | 1 | 0 |
299 | 299 | 2020-02-25 | Humboldt | California | 6023 | 1 | 0 |
316 | 316 | 2020-02-26 | Humboldt | California | 6023 | 1 | 0 |
336 | 336 | 2020-02-27 | Humboldt | California | 6023 | 1 | 0 |
356 | 356 | 2020-02-28 | Humboldt | California | 6023 | 1 | 0 |
378 | 378 | 2020-02-29 | Humboldt | California | 6023 | 1 | 0 |
401 | 401 | 2020-03-01 | Humboldt | California | 6023 | 1 | 0 |
428 | 428 | 2020-03-02 | Humboldt | California | 6023 | 1 | 0 |
462 | 462 | 2020-03-03 | Humboldt | California | 6023 | 1 | 0 |
497 | 497 | 2020-03-04 | Humboldt | California | 6023 | 1 | 0 |
536 | 536 | 2020-03-05 | Humboldt | California | 6023 | 1 | 0 |
586 | 586 | 2020-03-06 | Humboldt | California | 6023 | 1 | 0 |
661 | 661 | 2020-03-07 | Humboldt | California | 6023 | 1 | 0 |
756 | 756 | 2020-03-08 | Humboldt | California | 6023 | 1 | 0 |
870 | 870 | 2020-03-09 | Humboldt | California | 6023 | 1 | 0 |
1002 | 1002 | 2020-03-10 | Humboldt | California | 6023 | 1 | 0 |
1168 | 1168 | 2020-03-11 | Humboldt | California | 6023 | 1 | 0 |
1374 | 1374 | 2020-03-12 | Humboldt | California | 6023 | 1 | 0 |
1634 | 1634 | 2020-03-13 | Humboldt | California | 6023 | 1 | 0 |
1951 | 1951 | 2020-03-14 | Humboldt | California | 6023 | 1 | 0 |
2330 | 2330 | 2020-03-15 | Humboldt | California | 6023 | 1 | 0 |
2764 | 2764 | 2020-03-16 | Humboldt | California | 6023 | 1 | 0 |
3244 | 3244 | 2020-03-17 | Humboldt | California | 6023 | 1 | 0 |
3797 | 3797 | 2020-03-18 | Humboldt | California | 6023 | 1 | 0 |
4457 | 4457 | 2020-03-19 | Humboldt | California | 6023 | 1 | 0 |
5231 | 5231 | 2020-03-20 | Humboldt | California | 6023 | 2 | 0 |
6152 | 6152 | 2020-03-21 | Humboldt | California | 6023 | 2 | 0 |
7186 | 7186 | 2020-03-22 | Humboldt | California | 6023 | 2 | 0 |
8329 | 8329 | 2020-03-23 | Humboldt | California | 6023 | 2 | 0 |
9570 | 9570 | 2020-03-24 | Humboldt | California | 6023 | 5 | 0 |
10941 | 10941 | 2020-03-25 | Humboldt | California | 6023 | 10 | 0 |
12486 | 12486 | 2020-03-26 | Humboldt | California | 6023 | 12 | 0 |
14151 | 14151 | 2020-03-27 | Humboldt | California | 6023 | 14 | 0 |
15933 | 15933 | 2020-03-28 | Humboldt | California | 6023 | 18 | 0 |
17822 | 17822 | 2020-03-29 | Humboldt | California | 6023 | 18 | 0 |
19799 | 19799 | 2020-03-30 | Humboldt | California | 6023 | 21 | 0 |
21873 | 21873 | 2020-03-31 | Humboldt | California | 6023 | 27 | 0 |
24031 | 24031 | 2020-04-01 | Humboldt | California | 6023 | 27 | 0 |
26260 | 26260 | 2020-04-02 | Humboldt | California | 6023 | 37 | 0 |
28559 | 28559 | 2020-04-03 | Humboldt | California | 6023 | 40 | 0 |
30917 | 30917 | 2020-04-04 | Humboldt | California | 6023 | 44 | 0 |
33323 | 33323 | 2020-04-05 | Humboldt | California | 6023 | 44 | 0 |
35767 | 35767 | 2020-04-06 | Humboldt | California | 6023 | 49 | 0 |
38256 | 38256 | 2020-04-07 | Humboldt | California | 6023 | 50 | 0 |
40800 | 40800 | 2020-04-08 | Humboldt | California | 6023 | 50 | 0 |
43372 | 43372 | 2020-04-09 | Humboldt | California | 6023 | 50 | 0 |
45972 | 45972 | 2020-04-10 | Humboldt | California | 6023 | 50 | 0 |
48602 | 48602 | 2020-04-11 | Humboldt | California | 6023 | 50 | 0 |
51264 | 51264 | 2020-04-12 | Humboldt | California | 6023 | 50 | 0 |
53943 | 53943 | 2020-04-13 | Humboldt | California | 6023 | 50 | 0 |
56635 | 56635 | 2020-04-14 | Humboldt | California | 6023 | 51 | 0 |
59343 | 59343 | 2020-04-15 | Humboldt | California | 6023 | 52 | 0 |
62062 | 62062 | 2020-04-16 | Humboldt | California | 6023 | 52 | 0 |
64795 | 64795 | 2020-04-17 | Humboldt | California | 6023 | 52 | 0 |
67543 | 67543 | 2020-04-18 | Humboldt | California | 6023 | 52 | 0 |
70305 | 70305 | 2020-04-19 | Humboldt | California | 6023 | 52 | 0 |
73074 | 73074 | 2020-04-20 | Humboldt | California | 6023 | 52 | 0 |
75850 | 75850 | 2020-04-21 | Humboldt | California | 6023 | 52 | 0 |
78634 | 78634 | 2020-04-22 | Humboldt | California | 6023 | 52 | 0 |
81428 | 81428 | 2020-04-23 | Humboldt | California | 6023 | 52 | 0 |
84228 | 84228 | 2020-04-24 | Humboldt | California | 6023 | 53 | 0 |
87036 | 87036 | 2020-04-25 | Humboldt | California | 6023 | 53 | 0 |
89853 | 89853 | 2020-04-26 | Humboldt | California | 6023 | 53 | 0 |
92671 | 92671 | 2020-04-27 | Humboldt | California | 6023 | 53 | 0 |
95502 | 95502 | 2020-04-28 | Humboldt | California | 6023 | 53 | 0 |
98347 | 98347 | 2020-04-29 | Humboldt | California | 6023 | 54 | 0 |
101197 | 101197 | 2020-04-30 | Humboldt | California | 6023 | 54 | 0 |
104052 | 104052 | 2020-05-01 | Humboldt | California | 6023 | 54 | 0 |
106917 | 106917 | 2020-05-02 | Humboldt | California | 6023 | 54 | 0 |
109786 | 109786 | 2020-05-03 | Humboldt | California | 6023 | 54 | 0 |
112661 | 112661 | 2020-05-04 | Humboldt | California | 6023 | 54 | 0 |
115544 | 115544 | 2020-05-05 | Humboldt | California | 6023 | 54 | 0 |
118503 | 118503 | 2020-05-06 | Humboldt | California | 6023 | 55 | 0 |
121470 | 121470 | 2020-05-07 | Humboldt | California | 6023 | 55 | 0 |
124450 | 124450 | 2020-05-08 | Humboldt | California | 6023 | 55 | 0 |
127435 | 127435 | 2020-05-09 | Humboldt | California | 6023 | 57 | 0 |
130425 | 130425 | 2020-05-10 | Humboldt | California | 6023 | 57 | 0 |
133415 | 133415 | 2020-05-11 | Humboldt | California | 6023 | 61 | 0 |
136405 | 136405 | 2020-05-12 | Humboldt | California | 6023 | 64 | 0 |
139396 | 139396 | 2020-05-13 | Humboldt | California | 6023 | 67 | 0 |
142392 | 142392 | 2020-05-14 | Humboldt | California | 6023 | 68 | 0 |
145391 | 145391 | 2020-05-15 | Humboldt | California | 6023 | 72 | 0 |
148395 | 148395 | 2020-05-16 | Humboldt | California | 6023 | 77 | 0 |
151404 | 151404 | 2020-05-17 | Humboldt | California | 6023 | 77 | 0 |
154416 | 154416 | 2020-05-18 | Humboldt | California | 6023 | 81 | 0 |
157432 | 157432 | 2020-05-19 | Humboldt | California | 6023 | 86 | 0 |
160458 | 160458 | 2020-05-20 | Humboldt | California | 6023 | 88 | 0 |
163486 | 163486 | 2020-05-21 | Humboldt | California | 6023 | 88 | 2 |
166518 | 166518 | 2020-05-22 | Humboldt | California | 6023 | 91 | 2 |
169554 | 169554 | 2020-05-23 | Humboldt | California | 6023 | 93 | 2 |
172595 | 172595 | 2020-05-24 | Humboldt | California | 6023 | 93 | 2 |
175639 | 175639 | 2020-05-25 | Humboldt | California | 6023 | 94 | 2 |
178683 | 178683 | 2020-05-26 | Humboldt | California | 6023 | 94 | 2 |
181727 | 181727 | 2020-05-27 | Humboldt | California | 6023 | 98 | 2 |
184781 | 184781 | 2020-05-28 | Humboldt | California | 6023 | 98 | 3 |
187837 | 187837 | 2020-05-29 | Humboldt | California | 6023 | 99 | 3 |
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);