ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
814 rows where county = "Humboldt" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386136 | 386136 | 2020-07-31 | Humboldt | California | 6023 | 233 | 4 |
382918 | 382918 | 2020-07-30 | Humboldt | California | 6023 | 231 | 4 |
379701 | 379701 | 2020-07-29 | Humboldt | California | 6023 | 228 | 4 |
376485 | 376485 | 2020-07-28 | Humboldt | California | 6023 | 221 | 4 |
373271 | 373271 | 2020-07-27 | Humboldt | California | 6023 | 217 | 4 |
370059 | 370059 | 2020-07-26 | Humboldt | California | 6023 | 212 | 4 |
366849 | 366849 | 2020-07-25 | Humboldt | California | 6023 | 210 | 4 |
363642 | 363642 | 2020-07-24 | Humboldt | California | 6023 | 208 | 4 |
360435 | 360435 | 2020-07-23 | Humboldt | California | 6023 | 203 | 4 |
357230 | 357230 | 2020-07-22 | Humboldt | California | 6023 | 200 | 4 |
354027 | 354027 | 2020-07-21 | Humboldt | California | 6023 | 195 | 4 |
350825 | 350825 | 2020-07-20 | Humboldt | California | 6023 | 195 | 4 |
347624 | 347624 | 2020-07-19 | Humboldt | California | 6023 | 189 | 4 |
344424 | 344424 | 2020-07-18 | Humboldt | California | 6023 | 185 | 4 |
341225 | 341225 | 2020-07-17 | Humboldt | California | 6023 | 184 | 4 |
338029 | 338029 | 2020-07-16 | Humboldt | California | 6023 | 181 | 4 |
334834 | 334834 | 2020-07-15 | Humboldt | California | 6023 | 175 | 4 |
331641 | 331641 | 2020-07-14 | Humboldt | California | 6023 | 174 | 4 |
328455 | 328455 | 2020-07-13 | Humboldt | California | 6023 | 174 | 4 |
325269 | 325269 | 2020-07-12 | Humboldt | California | 6023 | 174 | 4 |
322088 | 322088 | 2020-07-11 | Humboldt | California | 6023 | 168 | 4 |
318909 | 318909 | 2020-07-10 | Humboldt | California | 6023 | 166 | 4 |
315736 | 315736 | 2020-07-09 | Humboldt | California | 6023 | 162 | 4 |
312561 | 312561 | 2020-07-08 | Humboldt | California | 6023 | 157 | 4 |
309391 | 309391 | 2020-07-07 | Humboldt | California | 6023 | 154 | 4 |
306223 | 306223 | 2020-07-06 | Humboldt | California | 6023 | 149 | 4 |
303059 | 303059 | 2020-07-05 | Humboldt | California | 6023 | 144 | 4 |
299895 | 299895 | 2020-07-04 | Humboldt | California | 6023 | 143 | 4 |
296733 | 296733 | 2020-07-03 | Humboldt | California | 6023 | 138 | 4 |
293577 | 293577 | 2020-07-02 | Humboldt | California | 6023 | 138 | 4 |
290423 | 290423 | 2020-07-01 | Humboldt | California | 6023 | 136 | 4 |
287272 | 287272 | 2020-06-30 | Humboldt | California | 6023 | 133 | 4 |
284126 | 284126 | 2020-06-29 | Humboldt | California | 6023 | 133 | 4 |
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 |
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);