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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
190902 | 190902 | 2020-05-30 | Humboldt | California | 6023 | 101 | 3 |
193969 | 193969 | 2020-05-31 | Humboldt | California | 6023 | 101 | 3 |
197039 | 197039 | 2020-06-01 | Humboldt | California | 6023 | 102 | 3 |
200112 | 200112 | 2020-06-02 | Humboldt | California | 6023 | 103 | 4 |
203188 | 203188 | 2020-06-03 | Humboldt | California | 6023 | 104 | 4 |
206268 | 206268 | 2020-06-04 | Humboldt | California | 6023 | 104 | 4 |
209349 | 209349 | 2020-06-05 | Humboldt | California | 6023 | 109 | 4 |
212434 | 212434 | 2020-06-06 | Humboldt | California | 6023 | 111 | 4 |
215521 | 215521 | 2020-06-07 | Humboldt | California | 6023 | 112 | 4 |
218612 | 218612 | 2020-06-08 | Humboldt | California | 6023 | 112 | 4 |
221707 | 221707 | 2020-06-09 | Humboldt | California | 6023 | 112 | 4 |
224802 | 224802 | 2020-06-10 | Humboldt | California | 6023 | 113 | 4 |
227904 | 227904 | 2020-06-11 | Humboldt | California | 6023 | 112 | 4 |
231007 | 231007 | 2020-06-12 | Humboldt | California | 6023 | 113 | 4 |
234113 | 234113 | 2020-06-13 | Humboldt | California | 6023 | 106 | 4 |
237220 | 237220 | 2020-06-14 | Humboldt | California | 6023 | 106 | 4 |
240328 | 240328 | 2020-06-15 | Humboldt | California | 6023 | 106 | 4 |
243439 | 243439 | 2020-06-16 | Humboldt | California | 6023 | 107 | 4 |
246552 | 246552 | 2020-06-17 | Humboldt | California | 6023 | 108 | 4 |
249664 | 249664 | 2020-06-18 | Humboldt | California | 6023 | 108 | 4 |
252779 | 252779 | 2020-06-19 | Humboldt | California | 6023 | 110 | 4 |
255898 | 255898 | 2020-06-20 | Humboldt | California | 6023 | 110 | 4 |
259025 | 259025 | 2020-06-21 | Humboldt | California | 6023 | 110 | 4 |
262152 | 262152 | 2020-06-22 | Humboldt | California | 6023 | 112 | 4 |
265280 | 265280 | 2020-06-23 | Humboldt | California | 6023 | 113 | 4 |
268410 | 268410 | 2020-06-24 | Humboldt | California | 6023 | 122 | 4 |
271545 | 271545 | 2020-06-25 | Humboldt | California | 6023 | 127 | 4 |
274685 | 274685 | 2020-06-26 | Humboldt | California | 6023 | 129 | 4 |
277833 | 277833 | 2020-06-27 | Humboldt | California | 6023 | 129 | 4 |
280980 | 280980 | 2020-06-28 | Humboldt | California | 6023 | 129 | 4 |
284126 | 284126 | 2020-06-29 | Humboldt | California | 6023 | 133 | 4 |
287272 | 287272 | 2020-06-30 | Humboldt | California | 6023 | 133 | 4 |
290423 | 290423 | 2020-07-01 | Humboldt | California | 6023 | 136 | 4 |
293577 | 293577 | 2020-07-02 | Humboldt | California | 6023 | 138 | 4 |
296733 | 296733 | 2020-07-03 | Humboldt | California | 6023 | 138 | 4 |
299895 | 299895 | 2020-07-04 | Humboldt | California | 6023 | 143 | 4 |
303059 | 303059 | 2020-07-05 | Humboldt | California | 6023 | 144 | 4 |
306223 | 306223 | 2020-07-06 | Humboldt | California | 6023 | 149 | 4 |
309391 | 309391 | 2020-07-07 | Humboldt | California | 6023 | 154 | 4 |
312561 | 312561 | 2020-07-08 | Humboldt | California | 6023 | 157 | 4 |
315736 | 315736 | 2020-07-09 | Humboldt | California | 6023 | 162 | 4 |
318909 | 318909 | 2020-07-10 | Humboldt | California | 6023 | 166 | 4 |
322088 | 322088 | 2020-07-11 | Humboldt | California | 6023 | 168 | 4 |
325269 | 325269 | 2020-07-12 | Humboldt | California | 6023 | 174 | 4 |
328455 | 328455 | 2020-07-13 | Humboldt | California | 6023 | 174 | 4 |
331641 | 331641 | 2020-07-14 | Humboldt | California | 6023 | 174 | 4 |
334834 | 334834 | 2020-07-15 | Humboldt | California | 6023 | 175 | 4 |
338029 | 338029 | 2020-07-16 | Humboldt | California | 6023 | 181 | 4 |
341225 | 341225 | 2020-07-17 | Humboldt | California | 6023 | 184 | 4 |
344424 | 344424 | 2020-07-18 | Humboldt | California | 6023 | 185 | 4 |
347624 | 347624 | 2020-07-19 | Humboldt | California | 6023 | 189 | 4 |
350825 | 350825 | 2020-07-20 | Humboldt | California | 6023 | 195 | 4 |
354027 | 354027 | 2020-07-21 | Humboldt | California | 6023 | 195 | 4 |
357230 | 357230 | 2020-07-22 | Humboldt | California | 6023 | 200 | 4 |
360435 | 360435 | 2020-07-23 | Humboldt | California | 6023 | 203 | 4 |
363642 | 363642 | 2020-07-24 | Humboldt | California | 6023 | 208 | 4 |
366849 | 366849 | 2020-07-25 | Humboldt | California | 6023 | 210 | 4 |
370059 | 370059 | 2020-07-26 | Humboldt | California | 6023 | 212 | 4 |
373271 | 373271 | 2020-07-27 | Humboldt | California | 6023 | 217 | 4 |
376485 | 376485 | 2020-07-28 | Humboldt | California | 6023 | 221 | 4 |
379701 | 379701 | 2020-07-29 | Humboldt | California | 6023 | 228 | 4 |
382918 | 382918 | 2020-07-30 | Humboldt | California | 6023 | 231 | 4 |
386136 | 386136 | 2020-07-31 | Humboldt | California | 6023 | 233 | 4 |
389353 | 389353 | 2020-08-01 | Humboldt | California | 6023 | 233 | 4 |
392570 | 392570 | 2020-08-02 | Humboldt | California | 6023 | 233 | 4 |
395786 | 395786 | 2020-08-03 | Humboldt | California | 6023 | 236 | 4 |
399002 | 399002 | 2020-08-04 | Humboldt | California | 6023 | 245 | 4 |
402218 | 402218 | 2020-08-05 | Humboldt | California | 6023 | 255 | 4 |
405436 | 405436 | 2020-08-06 | Humboldt | California | 6023 | 280 | 4 |
408656 | 408656 | 2020-08-07 | Humboldt | California | 6023 | 282 | 4 |
411875 | 411875 | 2020-08-08 | Humboldt | California | 6023 | 282 | 4 |
415095 | 415095 | 2020-08-09 | Humboldt | California | 6023 | 282 | 4 |
418316 | 418316 | 2020-08-10 | Humboldt | California | 6023 | 286 | 4 |
421537 | 421537 | 2020-08-11 | Humboldt | California | 6023 | 293 | 4 |
424758 | 424758 | 2020-08-12 | Humboldt | California | 6023 | 299 | 4 |
427982 | 427982 | 2020-08-13 | Humboldt | California | 6023 | 302 | 4 |
431210 | 431210 | 2020-08-14 | Humboldt | California | 6023 | 309 | 4 |
434435 | 434435 | 2020-08-15 | Humboldt | California | 6023 | 309 | 4 |
437661 | 437661 | 2020-08-16 | Humboldt | California | 6023 | 309 | 4 |
440887 | 440887 | 2020-08-17 | Humboldt | California | 6023 | 320 | 4 |
444113 | 444113 | 2020-08-18 | Humboldt | California | 6023 | 325 | 4 |
447340 | 447340 | 2020-08-19 | Humboldt | California | 6023 | 333 | 4 |
450568 | 450568 | 2020-08-20 | Humboldt | California | 6023 | 342 | 4 |
453796 | 453796 | 2020-08-21 | Humboldt | California | 6023 | 345 | 4 |
457024 | 457024 | 2020-08-22 | Humboldt | California | 6023 | 345 | 4 |
460251 | 460251 | 2020-08-23 | Humboldt | California | 6023 | 345 | 4 |
463480 | 463480 | 2020-08-24 | Humboldt | California | 6023 | 359 | 4 |
466709 | 466709 | 2020-08-25 | Humboldt | California | 6023 | 360 | 4 |
469938 | 469938 | 2020-08-26 | Humboldt | California | 6023 | 361 | 4 |
473170 | 473170 | 2020-08-27 | Humboldt | California | 6023 | 364 | 4 |
476403 | 476403 | 2020-08-28 | Humboldt | California | 6023 | 368 | 4 |
479636 | 479636 | 2020-08-29 | Humboldt | California | 6023 | 368 | 4 |
482870 | 482870 | 2020-08-30 | Humboldt | California | 6023 | 368 | 4 |
486105 | 486105 | 2020-08-31 | Humboldt | California | 6023 | 388 | 4 |
489338 | 489338 | 2020-09-01 | Humboldt | California | 6023 | 393 | 4 |
492571 | 492571 | 2020-09-02 | Humboldt | California | 6023 | 397 | 4 |
495805 | 495805 | 2020-09-03 | Humboldt | California | 6023 | 403 | 4 |
499038 | 499038 | 2020-09-04 | Humboldt | California | 6023 | 409 | 4 |
502272 | 502272 | 2020-09-05 | Humboldt | California | 6023 | 409 | 4 |
505506 | 505506 | 2020-09-06 | Humboldt | California | 6023 | 409 | 4 |
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);