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 |
---|---|---|---|---|---|---|---|
742138 | 742138 | 2020-11-18 | Humboldt | California | 6023 | 699 | 9 |
738891 | 738891 | 2020-11-17 | Humboldt | California | 6023 | 695 | 10 |
735647 | 735647 | 2020-11-16 | Humboldt | California | 6023 | 687 | 10 |
732401 | 732401 | 2020-11-15 | Humboldt | California | 6023 | 658 | 10 |
729156 | 729156 | 2020-11-14 | Humboldt | California | 6023 | 658 | 10 |
725913 | 725913 | 2020-11-13 | Humboldt | California | 6023 | 658 | 10 |
722670 | 722670 | 2020-11-12 | Humboldt | California | 6023 | 653 | 10 |
719427 | 719427 | 2020-11-11 | Humboldt | California | 6023 | 624 | 10 |
716184 | 716184 | 2020-11-10 | Humboldt | California | 6023 | 624 | 10 |
712940 | 712940 | 2020-11-09 | Humboldt | California | 6023 | 621 | 10 |
709696 | 709696 | 2020-11-08 | Humboldt | California | 6023 | 605 | 10 |
706452 | 706452 | 2020-11-07 | Humboldt | California | 6023 | 605 | 10 |
703209 | 703209 | 2020-11-06 | Humboldt | California | 6023 | 605 | 10 |
699966 | 699966 | 2020-11-05 | Humboldt | California | 6023 | 599 | 10 |
696722 | 696722 | 2020-11-04 | Humboldt | California | 6023 | 592 | 10 |
693480 | 693480 | 2020-11-03 | Humboldt | California | 6023 | 586 | 10 |
690237 | 690237 | 2020-11-02 | Humboldt | California | 6023 | 579 | 10 |
686992 | 686992 | 2020-11-01 | Humboldt | California | 6023 | 571 | 10 |
683748 | 683748 | 2020-10-31 | Humboldt | California | 6023 | 571 | 10 |
680505 | 680505 | 2020-10-30 | Humboldt | California | 6023 | 571 | 10 |
677262 | 677262 | 2020-10-29 | Humboldt | California | 6023 | 569 | 10 |
674019 | 674019 | 2020-10-28 | Humboldt | California | 6023 | 568 | 10 |
670777 | 670777 | 2020-10-27 | Humboldt | California | 6023 | 568 | 10 |
667534 | 667534 | 2020-10-26 | Humboldt | California | 6023 | 567 | 10 |
664289 | 664289 | 2020-10-25 | Humboldt | California | 6023 | 562 | 9 |
661045 | 661045 | 2020-10-24 | Humboldt | California | 6023 | 562 | 9 |
657801 | 657801 | 2020-10-23 | Humboldt | California | 6023 | 562 | 9 |
654556 | 654556 | 2020-10-22 | Humboldt | California | 6023 | 561 | 9 |
651311 | 651311 | 2020-10-21 | Humboldt | California | 6023 | 560 | 9 |
648067 | 648067 | 2020-10-20 | Humboldt | California | 6023 | 558 | 9 |
644822 | 644822 | 2020-10-19 | Humboldt | California | 6023 | 554 | 9 |
641574 | 641574 | 2020-10-18 | Humboldt | California | 6023 | 544 | 8 |
638327 | 638327 | 2020-10-17 | Humboldt | California | 6023 | 544 | 8 |
635082 | 635082 | 2020-10-16 | Humboldt | California | 6023 | 544 | 8 |
631836 | 631836 | 2020-10-15 | Humboldt | California | 6023 | 544 | 8 |
628592 | 628592 | 2020-10-14 | Humboldt | California | 6023 | 542 | 8 |
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 |
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);