ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Jackson" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921582 | 921582 | 2021-01-12 | Jackson | Louisiana | 22049 | 1497 | 39 |
918337 | 918337 | 2021-01-11 | Jackson | Louisiana | 22049 | 1486 | 39 |
915092 | 915092 | 2021-01-10 | Jackson | Louisiana | 22049 | 1477 | 39 |
911847 | 911847 | 2021-01-09 | Jackson | Louisiana | 22049 | 1467 | 39 |
908602 | 908602 | 2021-01-08 | Jackson | Louisiana | 22049 | 1467 | 39 |
905356 | 905356 | 2021-01-07 | Jackson | Louisiana | 22049 | 1465 | 39 |
902111 | 902111 | 2021-01-06 | Jackson | Louisiana | 22049 | 1454 | 39 |
898866 | 898866 | 2021-01-05 | Jackson | Louisiana | 22049 | 1415 | 39 |
895621 | 895621 | 2021-01-04 | Jackson | Louisiana | 22049 | 1401 | 38 |
892374 | 892374 | 2021-01-03 | Jackson | Louisiana | 22049 | 1402 | 38 |
889128 | 889128 | 2021-01-02 | Jackson | Louisiana | 22049 | 1392 | 38 |
885882 | 885882 | 2021-01-01 | Jackson | Louisiana | 22049 | 1392 | 38 |
882637 | 882637 | 2020-12-31 | Jackson | Louisiana | 22049 | 1392 | 38 |
879392 | 879392 | 2020-12-30 | Jackson | Louisiana | 22049 | 1362 | 38 |
876147 | 876147 | 2020-12-29 | Jackson | Louisiana | 22049 | 1348 | 38 |
872902 | 872902 | 2020-12-28 | Jackson | Louisiana | 22049 | 1337 | 37 |
869657 | 869657 | 2020-12-27 | Jackson | Louisiana | 22049 | 1331 | 37 |
866412 | 866412 | 2020-12-26 | Jackson | Louisiana | 22049 | 1333 | 37 |
863167 | 863167 | 2020-12-25 | Jackson | Louisiana | 22049 | 1333 | 37 |
859922 | 859922 | 2020-12-24 | Jackson | Louisiana | 22049 | 1333 | 37 |
856677 | 856677 | 2020-12-23 | Jackson | Louisiana | 22049 | 1326 | 37 |
853432 | 853432 | 2020-12-22 | Jackson | Louisiana | 22049 | 1317 | 37 |
850187 | 850187 | 2020-12-21 | Jackson | Louisiana | 22049 | 1310 | 37 |
846942 | 846942 | 2020-12-20 | Jackson | Louisiana | 22049 | 1315 | 37 |
843696 | 843696 | 2020-12-19 | Jackson | Louisiana | 22049 | 1302 | 36 |
840451 | 840451 | 2020-12-18 | Jackson | Louisiana | 22049 | 1302 | 36 |
837206 | 837206 | 2020-12-17 | Jackson | Louisiana | 22049 | 1296 | 36 |
833960 | 833960 | 2020-12-16 | Jackson | Louisiana | 22049 | 1282 | 35 |
830713 | 830713 | 2020-12-15 | Jackson | Louisiana | 22049 | 1273 | 34 |
827467 | 827467 | 2020-12-14 | Jackson | Louisiana | 22049 | 1260 | 34 |
824220 | 824220 | 2020-12-13 | Jackson | Louisiana | 22049 | 1263 | 34 |
820974 | 820974 | 2020-12-12 | Jackson | Louisiana | 22049 | 1251 | 34 |
817728 | 817728 | 2020-12-11 | Jackson | Louisiana | 22049 | 1251 | 34 |
814482 | 814482 | 2020-12-10 | Jackson | Louisiana | 22049 | 1244 | 34 |
811237 | 811237 | 2020-12-09 | Jackson | Louisiana | 22049 | 1237 | 33 |
807992 | 807992 | 2020-12-08 | Jackson | Louisiana | 22049 | 1218 | 33 |
804747 | 804747 | 2020-12-07 | Jackson | Louisiana | 22049 | 1209 | 33 |
801502 | 801502 | 2020-12-06 | Jackson | Louisiana | 22049 | 1207 | 33 |
798257 | 798257 | 2020-12-05 | Jackson | Louisiana | 22049 | 1195 | 33 |
795012 | 795012 | 2020-12-04 | Jackson | Louisiana | 22049 | 1195 | 33 |
791767 | 791767 | 2020-12-03 | Jackson | Louisiana | 22049 | 1182 | 33 |
788522 | 788522 | 2020-12-02 | Jackson | Louisiana | 22049 | 1171 | 33 |
785278 | 785278 | 2020-12-01 | Jackson | Louisiana | 22049 | 1164 | 31 |
782033 | 782033 | 2020-11-30 | Jackson | Louisiana | 22049 | 1149 | 31 |
778787 | 778787 | 2020-11-29 | Jackson | Louisiana | 22049 | 1147 | 31 |
775542 | 775542 | 2020-11-28 | Jackson | Louisiana | 22049 | 1146 | 31 |
772297 | 772297 | 2020-11-27 | Jackson | Louisiana | 22049 | 1146 | 31 |
769052 | 769052 | 2020-11-26 | Jackson | Louisiana | 22049 | 1132 | 31 |
765806 | 765806 | 2020-11-25 | Jackson | Louisiana | 22049 | 1132 | 31 |
762561 | 762561 | 2020-11-24 | Jackson | Louisiana | 22049 | 1120 | 31 |
759316 | 759316 | 2020-11-23 | Jackson | Louisiana | 22049 | 1107 | 26 |
756069 | 756069 | 2020-11-22 | Jackson | Louisiana | 22049 | 1108 | 26 |
752823 | 752823 | 2020-11-21 | Jackson | Louisiana | 22049 | 1098 | 26 |
749577 | 749577 | 2020-11-20 | Jackson | Louisiana | 22049 | 1098 | 26 |
746331 | 746331 | 2020-11-19 | Jackson | Louisiana | 22049 | 1062 | 26 |
743084 | 743084 | 2020-11-18 | Jackson | Louisiana | 22049 | 1045 | 26 |
739837 | 739837 | 2020-11-17 | Jackson | Louisiana | 22049 | 1038 | 25 |
736593 | 736593 | 2020-11-16 | Jackson | Louisiana | 22049 | 1032 | 25 |
733347 | 733347 | 2020-11-15 | Jackson | Louisiana | 22049 | 1024 | 25 |
730102 | 730102 | 2020-11-14 | Jackson | Louisiana | 22049 | 1007 | 25 |
726859 | 726859 | 2020-11-13 | Jackson | Louisiana | 22049 | 1007 | 25 |
723616 | 723616 | 2020-11-12 | Jackson | Louisiana | 22049 | 936 | 24 |
720373 | 720373 | 2020-11-11 | Jackson | Louisiana | 22049 | 914 | 24 |
717130 | 717130 | 2020-11-10 | Jackson | Louisiana | 22049 | 914 | 24 |
713886 | 713886 | 2020-11-09 | Jackson | Louisiana | 22049 | 908 | 24 |
710642 | 710642 | 2020-11-08 | Jackson | Louisiana | 22049 | 908 | 24 |
707398 | 707398 | 2020-11-07 | Jackson | Louisiana | 22049 | 903 | 24 |
704155 | 704155 | 2020-11-06 | Jackson | Louisiana | 22049 | 903 | 24 |
700913 | 700913 | 2020-11-05 | Jackson | Louisiana | 22049 | 893 | 24 |
697669 | 697669 | 2020-11-04 | Jackson | Louisiana | 22049 | 890 | 24 |
694426 | 694426 | 2020-11-03 | Jackson | Louisiana | 22049 | 879 | 24 |
691184 | 691184 | 2020-11-02 | Jackson | Louisiana | 22049 | 875 | 24 |
687939 | 687939 | 2020-11-01 | Jackson | Louisiana | 22049 | 875 | 24 |
684695 | 684695 | 2020-10-31 | Jackson | Louisiana | 22049 | 869 | 24 |
681452 | 681452 | 2020-10-30 | Jackson | Louisiana | 22049 | 869 | 24 |
678208 | 678208 | 2020-10-29 | Jackson | Louisiana | 22049 | 861 | 24 |
674966 | 674966 | 2020-10-28 | Jackson | Louisiana | 22049 | 860 | 24 |
671723 | 671723 | 2020-10-27 | Jackson | Louisiana | 22049 | 858 | 23 |
668481 | 668481 | 2020-10-26 | Jackson | Louisiana | 22049 | 856 | 23 |
665237 | 665237 | 2020-10-25 | Jackson | Louisiana | 22049 | 851 | 23 |
661992 | 661992 | 2020-10-24 | Jackson | Louisiana | 22049 | 846 | 23 |
658748 | 658748 | 2020-10-23 | Jackson | Louisiana | 22049 | 846 | 23 |
655503 | 655503 | 2020-10-22 | Jackson | Louisiana | 22049 | 847 | 22 |
652258 | 652258 | 2020-10-21 | Jackson | Louisiana | 22049 | 829 | 22 |
649013 | 649013 | 2020-10-20 | Jackson | Louisiana | 22049 | 814 | 22 |
645769 | 645769 | 2020-10-19 | Jackson | Louisiana | 22049 | 809 | 22 |
642522 | 642522 | 2020-10-18 | Jackson | Louisiana | 22049 | 806 | 22 |
639275 | 639275 | 2020-10-17 | Jackson | Louisiana | 22049 | 787 | 22 |
636029 | 636029 | 2020-10-16 | Jackson | Louisiana | 22049 | 787 | 22 |
632783 | 632783 | 2020-10-15 | Jackson | Louisiana | 22049 | 780 | 22 |
629539 | 629539 | 2020-10-14 | Jackson | Louisiana | 22049 | 758 | 22 |
626295 | 626295 | 2020-10-13 | Jackson | Louisiana | 22049 | 753 | 22 |
623053 | 623053 | 2020-10-12 | Jackson | Louisiana | 22049 | 744 | 22 |
619809 | 619809 | 2020-10-11 | Jackson | Louisiana | 22049 | 745 | 22 |
616567 | 616567 | 2020-10-10 | Jackson | Louisiana | 22049 | 719 | 22 |
613326 | 613326 | 2020-10-09 | Jackson | Louisiana | 22049 | 719 | 22 |
610084 | 610084 | 2020-10-08 | Jackson | Louisiana | 22049 | 718 | 22 |
606842 | 606842 | 2020-10-07 | Jackson | Louisiana | 22049 | 703 | 22 |
603600 | 603600 | 2020-10-06 | Jackson | Louisiana | 22049 | 688 | 22 |
600357 | 600357 | 2020-10-05 | Jackson | Louisiana | 22049 | 692 | 22 |
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);