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 |
---|---|---|---|---|---|---|---|
280980 | 280980 | 2020-06-28 | Humboldt | California | 6023 | 129 | 4 |
277833 | 277833 | 2020-06-27 | Humboldt | California | 6023 | 129 | 4 |
274685 | 274685 | 2020-06-26 | Humboldt | California | 6023 | 129 | 4 |
271545 | 271545 | 2020-06-25 | Humboldt | California | 6023 | 127 | 4 |
268410 | 268410 | 2020-06-24 | Humboldt | California | 6023 | 122 | 4 |
265280 | 265280 | 2020-06-23 | Humboldt | California | 6023 | 113 | 4 |
262152 | 262152 | 2020-06-22 | Humboldt | California | 6023 | 112 | 4 |
259025 | 259025 | 2020-06-21 | Humboldt | California | 6023 | 110 | 4 |
255898 | 255898 | 2020-06-20 | Humboldt | California | 6023 | 110 | 4 |
252779 | 252779 | 2020-06-19 | Humboldt | California | 6023 | 110 | 4 |
249664 | 249664 | 2020-06-18 | Humboldt | California | 6023 | 108 | 4 |
246552 | 246552 | 2020-06-17 | Humboldt | California | 6023 | 108 | 4 |
243439 | 243439 | 2020-06-16 | Humboldt | California | 6023 | 107 | 4 |
240328 | 240328 | 2020-06-15 | Humboldt | California | 6023 | 106 | 4 |
237220 | 237220 | 2020-06-14 | Humboldt | California | 6023 | 106 | 4 |
234113 | 234113 | 2020-06-13 | Humboldt | California | 6023 | 106 | 4 |
231007 | 231007 | 2020-06-12 | Humboldt | California | 6023 | 113 | 4 |
227904 | 227904 | 2020-06-11 | Humboldt | California | 6023 | 112 | 4 |
224802 | 224802 | 2020-06-10 | Humboldt | California | 6023 | 113 | 4 |
221707 | 221707 | 2020-06-09 | Humboldt | California | 6023 | 112 | 4 |
218612 | 218612 | 2020-06-08 | Humboldt | California | 6023 | 112 | 4 |
215521 | 215521 | 2020-06-07 | Humboldt | California | 6023 | 112 | 4 |
212434 | 212434 | 2020-06-06 | Humboldt | California | 6023 | 111 | 4 |
209349 | 209349 | 2020-06-05 | Humboldt | California | 6023 | 109 | 4 |
206268 | 206268 | 2020-06-04 | Humboldt | California | 6023 | 104 | 4 |
203188 | 203188 | 2020-06-03 | Humboldt | California | 6023 | 104 | 4 |
200112 | 200112 | 2020-06-02 | Humboldt | California | 6023 | 103 | 4 |
197039 | 197039 | 2020-06-01 | Humboldt | California | 6023 | 102 | 3 |
193969 | 193969 | 2020-05-31 | Humboldt | California | 6023 | 101 | 3 |
190902 | 190902 | 2020-05-30 | Humboldt | California | 6023 | 101 | 3 |
187837 | 187837 | 2020-05-29 | Humboldt | California | 6023 | 99 | 3 |
184781 | 184781 | 2020-05-28 | Humboldt | California | 6023 | 98 | 3 |
181727 | 181727 | 2020-05-27 | Humboldt | California | 6023 | 98 | 2 |
178683 | 178683 | 2020-05-26 | Humboldt | California | 6023 | 94 | 2 |
175639 | 175639 | 2020-05-25 | Humboldt | California | 6023 | 94 | 2 |
172595 | 172595 | 2020-05-24 | Humboldt | California | 6023 | 93 | 2 |
169554 | 169554 | 2020-05-23 | Humboldt | California | 6023 | 93 | 2 |
166518 | 166518 | 2020-05-22 | Humboldt | California | 6023 | 91 | 2 |
163486 | 163486 | 2020-05-21 | Humboldt | California | 6023 | 88 | 2 |
160458 | 160458 | 2020-05-20 | Humboldt | California | 6023 | 88 | 0 |
157432 | 157432 | 2020-05-19 | Humboldt | California | 6023 | 86 | 0 |
154416 | 154416 | 2020-05-18 | Humboldt | California | 6023 | 81 | 0 |
151404 | 151404 | 2020-05-17 | Humboldt | California | 6023 | 77 | 0 |
148395 | 148395 | 2020-05-16 | Humboldt | California | 6023 | 77 | 0 |
145391 | 145391 | 2020-05-15 | Humboldt | California | 6023 | 72 | 0 |
142392 | 142392 | 2020-05-14 | Humboldt | California | 6023 | 68 | 0 |
139396 | 139396 | 2020-05-13 | Humboldt | California | 6023 | 67 | 0 |
136405 | 136405 | 2020-05-12 | Humboldt | California | 6023 | 64 | 0 |
133415 | 133415 | 2020-05-11 | Humboldt | California | 6023 | 61 | 0 |
130425 | 130425 | 2020-05-10 | Humboldt | California | 6023 | 57 | 0 |
127435 | 127435 | 2020-05-09 | Humboldt | California | 6023 | 57 | 0 |
124450 | 124450 | 2020-05-08 | Humboldt | California | 6023 | 55 | 0 |
121470 | 121470 | 2020-05-07 | Humboldt | California | 6023 | 55 | 0 |
118503 | 118503 | 2020-05-06 | Humboldt | California | 6023 | 55 | 0 |
115544 | 115544 | 2020-05-05 | Humboldt | California | 6023 | 54 | 0 |
112661 | 112661 | 2020-05-04 | Humboldt | California | 6023 | 54 | 0 |
109786 | 109786 | 2020-05-03 | Humboldt | California | 6023 | 54 | 0 |
106917 | 106917 | 2020-05-02 | Humboldt | California | 6023 | 54 | 0 |
104052 | 104052 | 2020-05-01 | Humboldt | California | 6023 | 54 | 0 |
101197 | 101197 | 2020-04-30 | Humboldt | California | 6023 | 54 | 0 |
98347 | 98347 | 2020-04-29 | Humboldt | California | 6023 | 54 | 0 |
95502 | 95502 | 2020-04-28 | Humboldt | California | 6023 | 53 | 0 |
92671 | 92671 | 2020-04-27 | Humboldt | California | 6023 | 53 | 0 |
89853 | 89853 | 2020-04-26 | Humboldt | California | 6023 | 53 | 0 |
87036 | 87036 | 2020-04-25 | Humboldt | California | 6023 | 53 | 0 |
84228 | 84228 | 2020-04-24 | Humboldt | California | 6023 | 53 | 0 |
81428 | 81428 | 2020-04-23 | Humboldt | California | 6023 | 52 | 0 |
78634 | 78634 | 2020-04-22 | Humboldt | California | 6023 | 52 | 0 |
75850 | 75850 | 2020-04-21 | Humboldt | California | 6023 | 52 | 0 |
73074 | 73074 | 2020-04-20 | Humboldt | California | 6023 | 52 | 0 |
70305 | 70305 | 2020-04-19 | Humboldt | California | 6023 | 52 | 0 |
67543 | 67543 | 2020-04-18 | Humboldt | California | 6023 | 52 | 0 |
64795 | 64795 | 2020-04-17 | Humboldt | California | 6023 | 52 | 0 |
62062 | 62062 | 2020-04-16 | Humboldt | California | 6023 | 52 | 0 |
59343 | 59343 | 2020-04-15 | Humboldt | California | 6023 | 52 | 0 |
56635 | 56635 | 2020-04-14 | Humboldt | California | 6023 | 51 | 0 |
53943 | 53943 | 2020-04-13 | Humboldt | California | 6023 | 50 | 0 |
51264 | 51264 | 2020-04-12 | Humboldt | California | 6023 | 50 | 0 |
48602 | 48602 | 2020-04-11 | Humboldt | California | 6023 | 50 | 0 |
45972 | 45972 | 2020-04-10 | Humboldt | California | 6023 | 50 | 0 |
43372 | 43372 | 2020-04-09 | Humboldt | California | 6023 | 50 | 0 |
40800 | 40800 | 2020-04-08 | Humboldt | California | 6023 | 50 | 0 |
38256 | 38256 | 2020-04-07 | Humboldt | California | 6023 | 50 | 0 |
35767 | 35767 | 2020-04-06 | Humboldt | California | 6023 | 49 | 0 |
33323 | 33323 | 2020-04-05 | Humboldt | California | 6023 | 44 | 0 |
30917 | 30917 | 2020-04-04 | Humboldt | California | 6023 | 44 | 0 |
28559 | 28559 | 2020-04-03 | Humboldt | California | 6023 | 40 | 0 |
26260 | 26260 | 2020-04-02 | Humboldt | California | 6023 | 37 | 0 |
24031 | 24031 | 2020-04-01 | Humboldt | California | 6023 | 27 | 0 |
21873 | 21873 | 2020-03-31 | Humboldt | California | 6023 | 27 | 0 |
19799 | 19799 | 2020-03-30 | Humboldt | California | 6023 | 21 | 0 |
17822 | 17822 | 2020-03-29 | Humboldt | California | 6023 | 18 | 0 |
15933 | 15933 | 2020-03-28 | Humboldt | California | 6023 | 18 | 0 |
14151 | 14151 | 2020-03-27 | Humboldt | California | 6023 | 14 | 0 |
12486 | 12486 | 2020-03-26 | Humboldt | California | 6023 | 12 | 0 |
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 |
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);