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 |
---|---|---|---|---|---|---|---|
625349 | 625349 | 2020-10-13 | Humboldt | California | 6023 | 534 | 8 |
622106 | 622106 | 2020-10-12 | Humboldt | California | 6023 | 533 | 8 |
618863 | 618863 | 2020-10-11 | Humboldt | California | 6023 | 529 | 8 |
615621 | 615621 | 2020-10-10 | Humboldt | California | 6023 | 529 | 8 |
612380 | 612380 | 2020-10-09 | Humboldt | California | 6023 | 529 | 8 |
609138 | 609138 | 2020-10-08 | Humboldt | California | 6023 | 528 | 8 |
605895 | 605895 | 2020-10-07 | Humboldt | California | 6023 | 527 | 8 |
602653 | 602653 | 2020-10-06 | Humboldt | California | 6023 | 524 | 8 |
599410 | 599410 | 2020-10-05 | Humboldt | California | 6023 | 522 | 8 |
596167 | 596167 | 2020-10-04 | Humboldt | California | 6023 | 518 | 8 |
592925 | 592925 | 2020-10-03 | Humboldt | California | 6023 | 518 | 8 |
589685 | 589685 | 2020-10-02 | Humboldt | California | 6023 | 518 | 8 |
586444 | 586444 | 2020-10-01 | Humboldt | California | 6023 | 515 | 8 |
583204 | 583204 | 2020-09-30 | Humboldt | California | 6023 | 512 | 8 |
579965 | 579965 | 2020-09-29 | Humboldt | California | 6023 | 509 | 8 |
576724 | 576724 | 2020-09-28 | Humboldt | California | 6023 | 508 | 8 |
573481 | 573481 | 2020-09-27 | Humboldt | California | 6023 | 501 | 7 |
570239 | 570239 | 2020-09-26 | Humboldt | California | 6023 | 501 | 7 |
566997 | 566997 | 2020-09-25 | Humboldt | California | 6023 | 501 | 7 |
563757 | 563757 | 2020-09-24 | Humboldt | California | 6023 | 496 | 7 |
560518 | 560518 | 2020-09-23 | Humboldt | California | 6023 | 490 | 6 |
557282 | 557282 | 2020-09-22 | Humboldt | California | 6023 | 489 | 6 |
554045 | 554045 | 2020-09-21 | Humboldt | California | 6023 | 485 | 6 |
550806 | 550806 | 2020-09-20 | Humboldt | California | 6023 | 482 | 6 |
547567 | 547567 | 2020-09-19 | Humboldt | California | 6023 | 482 | 6 |
544329 | 544329 | 2020-09-18 | Humboldt | California | 6023 | 482 | 6 |
541093 | 541093 | 2020-09-17 | Humboldt | California | 6023 | 482 | 6 |
537856 | 537856 | 2020-09-16 | Humboldt | California | 6023 | 481 | 6 |
534620 | 534620 | 2020-09-15 | Humboldt | California | 6023 | 479 | 6 |
531385 | 531385 | 2020-09-14 | Humboldt | California | 6023 | 473 | 6 |
528148 | 528148 | 2020-09-13 | Humboldt | California | 6023 | 447 | 5 |
524912 | 524912 | 2020-09-12 | Humboldt | California | 6023 | 447 | 5 |
521676 | 521676 | 2020-09-11 | Humboldt | California | 6023 | 447 | 5 |
518439 | 518439 | 2020-09-10 | Humboldt | California | 6023 | 442 | 4 |
515204 | 515204 | 2020-09-09 | Humboldt | California | 6023 | 434 | 4 |
511971 | 511971 | 2020-09-08 | Humboldt | California | 6023 | 434 | 4 |
508738 | 508738 | 2020-09-07 | Humboldt | California | 6023 | 409 | 4 |
505506 | 505506 | 2020-09-06 | Humboldt | California | 6023 | 409 | 4 |
502272 | 502272 | 2020-09-05 | Humboldt | California | 6023 | 409 | 4 |
499038 | 499038 | 2020-09-04 | Humboldt | California | 6023 | 409 | 4 |
495805 | 495805 | 2020-09-03 | Humboldt | California | 6023 | 403 | 4 |
492571 | 492571 | 2020-09-02 | Humboldt | California | 6023 | 397 | 4 |
489338 | 489338 | 2020-09-01 | Humboldt | California | 6023 | 393 | 4 |
486105 | 486105 | 2020-08-31 | Humboldt | California | 6023 | 388 | 4 |
482870 | 482870 | 2020-08-30 | Humboldt | California | 6023 | 368 | 4 |
479636 | 479636 | 2020-08-29 | Humboldt | California | 6023 | 368 | 4 |
476403 | 476403 | 2020-08-28 | Humboldt | California | 6023 | 368 | 4 |
473170 | 473170 | 2020-08-27 | Humboldt | California | 6023 | 364 | 4 |
469938 | 469938 | 2020-08-26 | Humboldt | California | 6023 | 361 | 4 |
466709 | 466709 | 2020-08-25 | Humboldt | California | 6023 | 360 | 4 |
463480 | 463480 | 2020-08-24 | Humboldt | California | 6023 | 359 | 4 |
460251 | 460251 | 2020-08-23 | Humboldt | California | 6023 | 345 | 4 |
457024 | 457024 | 2020-08-22 | Humboldt | California | 6023 | 345 | 4 |
453796 | 453796 | 2020-08-21 | Humboldt | California | 6023 | 345 | 4 |
450568 | 450568 | 2020-08-20 | Humboldt | California | 6023 | 342 | 4 |
447340 | 447340 | 2020-08-19 | Humboldt | California | 6023 | 333 | 4 |
444113 | 444113 | 2020-08-18 | Humboldt | California | 6023 | 325 | 4 |
440887 | 440887 | 2020-08-17 | Humboldt | California | 6023 | 320 | 4 |
437661 | 437661 | 2020-08-16 | Humboldt | California | 6023 | 309 | 4 |
434435 | 434435 | 2020-08-15 | Humboldt | California | 6023 | 309 | 4 |
431210 | 431210 | 2020-08-14 | Humboldt | California | 6023 | 309 | 4 |
427982 | 427982 | 2020-08-13 | Humboldt | California | 6023 | 302 | 4 |
424758 | 424758 | 2020-08-12 | Humboldt | California | 6023 | 299 | 4 |
421537 | 421537 | 2020-08-11 | Humboldt | California | 6023 | 293 | 4 |
418316 | 418316 | 2020-08-10 | Humboldt | California | 6023 | 286 | 4 |
415095 | 415095 | 2020-08-09 | Humboldt | California | 6023 | 282 | 4 |
411875 | 411875 | 2020-08-08 | Humboldt | California | 6023 | 282 | 4 |
408656 | 408656 | 2020-08-07 | Humboldt | California | 6023 | 282 | 4 |
405436 | 405436 | 2020-08-06 | Humboldt | California | 6023 | 280 | 4 |
402218 | 402218 | 2020-08-05 | Humboldt | California | 6023 | 255 | 4 |
399002 | 399002 | 2020-08-04 | Humboldt | California | 6023 | 245 | 4 |
395786 | 395786 | 2020-08-03 | Humboldt | California | 6023 | 236 | 4 |
392570 | 392570 | 2020-08-02 | Humboldt | California | 6023 | 233 | 4 |
389353 | 389353 | 2020-08-01 | Humboldt | California | 6023 | 233 | 4 |
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 |
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);