ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Jefferson" and fips = 22051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947546 | 947546 | 2021-01-20 | Jefferson | Louisiana | 22051 | 38283 | 738 |
944299 | 944299 | 2021-01-19 | Jefferson | Louisiana | 22051 | 38037 | 737 |
941054 | 941054 | 2021-01-18 | Jefferson | Louisiana | 22051 | 37813 | 734 |
937809 | 937809 | 2021-01-17 | Jefferson | Louisiana | 22051 | 37684 | 733 |
934564 | 934564 | 2021-01-16 | Jefferson | Louisiana | 22051 | 37200 | 715 |
931319 | 931319 | 2021-01-15 | Jefferson | Louisiana | 22051 | 37200 | 715 |
928074 | 928074 | 2021-01-14 | Jefferson | Louisiana | 22051 | 36677 | 715 |
924828 | 924828 | 2021-01-13 | Jefferson | Louisiana | 22051 | 36149 | 712 |
921583 | 921583 | 2021-01-12 | Jefferson | Louisiana | 22051 | 35823 | 709 |
918338 | 918338 | 2021-01-11 | Jefferson | Louisiana | 22051 | 35379 | 708 |
915093 | 915093 | 2021-01-10 | Jefferson | Louisiana | 22051 | 35137 | 708 |
911848 | 911848 | 2021-01-09 | Jefferson | Louisiana | 22051 | 34491 | 705 |
908603 | 908603 | 2021-01-08 | Jefferson | Louisiana | 22051 | 34491 | 705 |
905357 | 905357 | 2021-01-07 | Jefferson | Louisiana | 22051 | 34115 | 684 |
902112 | 902112 | 2021-01-06 | Jefferson | Louisiana | 22051 | 33629 | 682 |
898867 | 898867 | 2021-01-05 | Jefferson | Louisiana | 22051 | 33091 | 681 |
895622 | 895622 | 2021-01-04 | Jefferson | Louisiana | 22051 | 32601 | 679 |
892375 | 892375 | 2021-01-03 | Jefferson | Louisiana | 22051 | 32375 | 675 |
889129 | 889129 | 2021-01-02 | Jefferson | Louisiana | 22051 | 31498 | 669 |
885883 | 885883 | 2021-01-01 | Jefferson | Louisiana | 22051 | 31498 | 669 |
882638 | 882638 | 2020-12-31 | Jefferson | Louisiana | 22051 | 31498 | 669 |
879393 | 879393 | 2020-12-30 | Jefferson | Louisiana | 22051 | 31098 | 668 |
876148 | 876148 | 2020-12-29 | Jefferson | Louisiana | 22051 | 30628 | 667 |
872903 | 872903 | 2020-12-28 | Jefferson | Louisiana | 22051 | 30127 | 667 |
869658 | 869658 | 2020-12-27 | Jefferson | Louisiana | 22051 | 30031 | 666 |
866413 | 866413 | 2020-12-26 | Jefferson | Louisiana | 22051 | 29462 | 666 |
863168 | 863168 | 2020-12-25 | Jefferson | Louisiana | 22051 | 29462 | 666 |
859923 | 859923 | 2020-12-24 | Jefferson | Louisiana | 22051 | 29462 | 666 |
856678 | 856678 | 2020-12-23 | Jefferson | Louisiana | 22051 | 29190 | 665 |
853433 | 853433 | 2020-12-22 | Jefferson | Louisiana | 22051 | 28902 | 653 |
850188 | 850188 | 2020-12-21 | Jefferson | Louisiana | 22051 | 28613 | 647 |
846943 | 846943 | 2020-12-20 | Jefferson | Louisiana | 22051 | 28431 | 645 |
843697 | 843697 | 2020-12-19 | Jefferson | Louisiana | 22051 | 28045 | 644 |
840452 | 840452 | 2020-12-18 | Jefferson | Louisiana | 22051 | 28045 | 644 |
837207 | 837207 | 2020-12-17 | Jefferson | Louisiana | 22051 | 27741 | 644 |
833961 | 833961 | 2020-12-16 | Jefferson | Louisiana | 22051 | 27355 | 643 |
830714 | 830714 | 2020-12-15 | Jefferson | Louisiana | 22051 | 27128 | 643 |
827468 | 827468 | 2020-12-14 | Jefferson | Louisiana | 22051 | 26821 | 643 |
824221 | 824221 | 2020-12-13 | Jefferson | Louisiana | 22051 | 26686 | 643 |
820975 | 820975 | 2020-12-12 | Jefferson | Louisiana | 22051 | 26277 | 641 |
817729 | 817729 | 2020-12-11 | Jefferson | Louisiana | 22051 | 26277 | 641 |
814483 | 814483 | 2020-12-10 | Jefferson | Louisiana | 22051 | 25991 | 641 |
811238 | 811238 | 2020-12-09 | Jefferson | Louisiana | 22051 | 25767 | 639 |
807993 | 807993 | 2020-12-08 | Jefferson | Louisiana | 22051 | 25316 | 633 |
804748 | 804748 | 2020-12-07 | Jefferson | Louisiana | 22051 | 25072 | 631 |
801503 | 801503 | 2020-12-06 | Jefferson | Louisiana | 22051 | 24943 | 631 |
798258 | 798258 | 2020-12-05 | Jefferson | Louisiana | 22051 | 24588 | 631 |
795013 | 795013 | 2020-12-04 | Jefferson | Louisiana | 22051 | 24588 | 631 |
791768 | 791768 | 2020-12-03 | Jefferson | Louisiana | 22051 | 24328 | 631 |
788523 | 788523 | 2020-12-02 | Jefferson | Louisiana | 22051 | 24084 | 630 |
785279 | 785279 | 2020-12-01 | Jefferson | Louisiana | 22051 | 23160 | 629 |
782034 | 782034 | 2020-11-30 | Jefferson | Louisiana | 22051 | 22609 | 629 |
778788 | 778788 | 2020-11-29 | Jefferson | Louisiana | 22051 | 22603 | 629 |
775543 | 775543 | 2020-11-28 | Jefferson | Louisiana | 22051 | 22389 | 629 |
772298 | 772298 | 2020-11-27 | Jefferson | Louisiana | 22051 | 22389 | 629 |
769053 | 769053 | 2020-11-26 | Jefferson | Louisiana | 22051 | 21666 | 628 |
765807 | 765807 | 2020-11-25 | Jefferson | Louisiana | 22051 | 21666 | 628 |
762562 | 762562 | 2020-11-24 | Jefferson | Louisiana | 22051 | 21553 | 628 |
759317 | 759317 | 2020-11-23 | Jefferson | Louisiana | 22051 | 21281 | 628 |
756070 | 756070 | 2020-11-22 | Jefferson | Louisiana | 22051 | 21190 | 627 |
752824 | 752824 | 2020-11-21 | Jefferson | Louisiana | 22051 | 20927 | 625 |
749578 | 749578 | 2020-11-20 | Jefferson | Louisiana | 22051 | 20927 | 625 |
746332 | 746332 | 2020-11-19 | Jefferson | Louisiana | 22051 | 20680 | 622 |
743085 | 743085 | 2020-11-18 | Jefferson | Louisiana | 22051 | 20543 | 622 |
739838 | 739838 | 2020-11-17 | Jefferson | Louisiana | 22051 | 20357 | 621 |
736594 | 736594 | 2020-11-16 | Jefferson | Louisiana | 22051 | 20193 | 620 |
733348 | 733348 | 2020-11-15 | Jefferson | Louisiana | 22051 | 20149 | 620 |
730103 | 730103 | 2020-11-14 | Jefferson | Louisiana | 22051 | 19990 | 620 |
726860 | 726860 | 2020-11-13 | Jefferson | Louisiana | 22051 | 19990 | 620 |
723617 | 723617 | 2020-11-12 | Jefferson | Louisiana | 22051 | 19465 | 593 |
720374 | 720374 | 2020-11-11 | Jefferson | Louisiana | 22051 | 19302 | 592 |
717131 | 717131 | 2020-11-10 | Jefferson | Louisiana | 22051 | 19302 | 592 |
713887 | 713887 | 2020-11-09 | Jefferson | Louisiana | 22051 | 19220 | 592 |
710643 | 710643 | 2020-11-08 | Jefferson | Louisiana | 22051 | 19182 | 592 |
707399 | 707399 | 2020-11-07 | Jefferson | Louisiana | 22051 | 19077 | 590 |
704156 | 704156 | 2020-11-06 | Jefferson | Louisiana | 22051 | 19077 | 590 |
700914 | 700914 | 2020-11-05 | Jefferson | Louisiana | 22051 | 19015 | 589 |
697670 | 697670 | 2020-11-04 | Jefferson | Louisiana | 22051 | 18976 | 589 |
694427 | 694427 | 2020-11-03 | Jefferson | Louisiana | 22051 | 18934 | 589 |
691185 | 691185 | 2020-11-02 | Jefferson | Louisiana | 22051 | 18884 | 589 |
687940 | 687940 | 2020-11-01 | Jefferson | Louisiana | 22051 | 18866 | 589 |
684696 | 684696 | 2020-10-31 | Jefferson | Louisiana | 22051 | 18785 | 589 |
681453 | 681453 | 2020-10-30 | Jefferson | Louisiana | 22051 | 18785 | 589 |
678209 | 678209 | 2020-10-29 | Jefferson | Louisiana | 22051 | 18757 | 587 |
674967 | 674967 | 2020-10-28 | Jefferson | Louisiana | 22051 | 18726 | 585 |
671724 | 671724 | 2020-10-27 | Jefferson | Louisiana | 22051 | 18687 | 585 |
668482 | 668482 | 2020-10-26 | Jefferson | Louisiana | 22051 | 18645 | 584 |
665238 | 665238 | 2020-10-25 | Jefferson | Louisiana | 22051 | 18624 | 584 |
661993 | 661993 | 2020-10-24 | Jefferson | Louisiana | 22051 | 18539 | 583 |
658749 | 658749 | 2020-10-23 | Jefferson | Louisiana | 22051 | 18539 | 583 |
655504 | 655504 | 2020-10-22 | Jefferson | Louisiana | 22051 | 18491 | 581 |
652259 | 652259 | 2020-10-21 | Jefferson | Louisiana | 22051 | 18441 | 581 |
649014 | 649014 | 2020-10-20 | Jefferson | Louisiana | 22051 | 18405 | 580 |
645770 | 645770 | 2020-10-19 | Jefferson | Louisiana | 22051 | 18358 | 580 |
642523 | 642523 | 2020-10-18 | Jefferson | Louisiana | 22051 | 18344 | 580 |
639276 | 639276 | 2020-10-17 | Jefferson | Louisiana | 22051 | 18252 | 580 |
636030 | 636030 | 2020-10-16 | Jefferson | Louisiana | 22051 | 18252 | 580 |
632784 | 632784 | 2020-10-15 | Jefferson | Louisiana | 22051 | 18182 | 578 |
629540 | 629540 | 2020-10-14 | Jefferson | Louisiana | 22051 | 18116 | 578 |
626296 | 626296 | 2020-10-13 | Jefferson | Louisiana | 22051 | 18118 | 578 |
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);