ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22093 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947567 | 947567 | 2021-01-20 | St. James | Louisiana | 22093 | 1636 | 45 |
944320 | 944320 | 2021-01-19 | St. James | Louisiana | 22093 | 1617 | 45 |
941075 | 941075 | 2021-01-18 | St. James | Louisiana | 22093 | 1598 | 45 |
937830 | 937830 | 2021-01-17 | St. James | Louisiana | 22093 | 1594 | 45 |
934585 | 934585 | 2021-01-16 | St. James | Louisiana | 22093 | 1570 | 45 |
931340 | 931340 | 2021-01-15 | St. James | Louisiana | 22093 | 1570 | 45 |
928095 | 928095 | 2021-01-14 | St. James | Louisiana | 22093 | 1563 | 45 |
924849 | 924849 | 2021-01-13 | St. James | Louisiana | 22093 | 1540 | 45 |
921604 | 921604 | 2021-01-12 | St. James | Louisiana | 22093 | 1524 | 44 |
918359 | 918359 | 2021-01-11 | St. James | Louisiana | 22093 | 1490 | 44 |
915114 | 915114 | 2021-01-10 | St. James | Louisiana | 22093 | 1489 | 43 |
911869 | 911869 | 2021-01-09 | St. James | Louisiana | 22093 | 1475 | 43 |
908624 | 908624 | 2021-01-08 | St. James | Louisiana | 22093 | 1475 | 43 |
905378 | 905378 | 2021-01-07 | St. James | Louisiana | 22093 | 1446 | 43 |
902133 | 902133 | 2021-01-06 | St. James | Louisiana | 22093 | 1414 | 43 |
898888 | 898888 | 2021-01-05 | St. James | Louisiana | 22093 | 1387 | 43 |
895643 | 895643 | 2021-01-04 | St. James | Louisiana | 22093 | 1345 | 43 |
892396 | 892396 | 2021-01-03 | St. James | Louisiana | 22093 | 1338 | 43 |
889150 | 889150 | 2021-01-02 | St. James | Louisiana | 22093 | 1323 | 43 |
885904 | 885904 | 2021-01-01 | St. James | Louisiana | 22093 | 1323 | 43 |
882659 | 882659 | 2020-12-31 | St. James | Louisiana | 22093 | 1323 | 43 |
879414 | 879414 | 2020-12-30 | St. James | Louisiana | 22093 | 1311 | 43 |
876169 | 876169 | 2020-12-29 | St. James | Louisiana | 22093 | 1272 | 43 |
872924 | 872924 | 2020-12-28 | St. James | Louisiana | 22093 | 1263 | 43 |
869679 | 869679 | 2020-12-27 | St. James | Louisiana | 22093 | 1263 | 43 |
866434 | 866434 | 2020-12-26 | St. James | Louisiana | 22093 | 1253 | 43 |
863189 | 863189 | 2020-12-25 | St. James | Louisiana | 22093 | 1253 | 43 |
859944 | 859944 | 2020-12-24 | St. James | Louisiana | 22093 | 1253 | 43 |
856699 | 856699 | 2020-12-23 | St. James | Louisiana | 22093 | 1231 | 43 |
853454 | 853454 | 2020-12-22 | St. James | Louisiana | 22093 | 1221 | 43 |
850209 | 850209 | 2020-12-21 | St. James | Louisiana | 22093 | 1208 | 42 |
846964 | 846964 | 2020-12-20 | St. James | Louisiana | 22093 | 1204 | 42 |
843718 | 843718 | 2020-12-19 | St. James | Louisiana | 22093 | 1196 | 41 |
840473 | 840473 | 2020-12-18 | St. James | Louisiana | 22093 | 1196 | 41 |
837228 | 837228 | 2020-12-17 | St. James | Louisiana | 22093 | 1176 | 41 |
833982 | 833982 | 2020-12-16 | St. James | Louisiana | 22093 | 1164 | 41 |
830735 | 830735 | 2020-12-15 | St. James | Louisiana | 22093 | 1152 | 41 |
827489 | 827489 | 2020-12-14 | St. James | Louisiana | 22093 | 1137 | 40 |
824242 | 824242 | 2020-12-13 | St. James | Louisiana | 22093 | 1135 | 40 |
820996 | 820996 | 2020-12-12 | St. James | Louisiana | 22093 | 1121 | 40 |
817750 | 817750 | 2020-12-11 | St. James | Louisiana | 22093 | 1121 | 40 |
814504 | 814504 | 2020-12-10 | St. James | Louisiana | 22093 | 1117 | 40 |
811259 | 811259 | 2020-12-09 | St. James | Louisiana | 22093 | 1105 | 40 |
808014 | 808014 | 2020-12-08 | St. James | Louisiana | 22093 | 1095 | 40 |
804769 | 804769 | 2020-12-07 | St. James | Louisiana | 22093 | 1078 | 40 |
801524 | 801524 | 2020-12-06 | St. James | Louisiana | 22093 | 1073 | 40 |
798279 | 798279 | 2020-12-05 | St. James | Louisiana | 22093 | 1035 | 40 |
795034 | 795034 | 2020-12-04 | St. James | Louisiana | 22093 | 1035 | 40 |
791789 | 791789 | 2020-12-03 | St. James | Louisiana | 22093 | 1014 | 40 |
788544 | 788544 | 2020-12-02 | St. James | Louisiana | 22093 | 1011 | 40 |
785300 | 785300 | 2020-12-01 | St. James | Louisiana | 22093 | 1002 | 40 |
782055 | 782055 | 2020-11-30 | St. James | Louisiana | 22093 | 988 | 40 |
778809 | 778809 | 2020-11-29 | St. James | Louisiana | 22093 | 985 | 40 |
775564 | 775564 | 2020-11-28 | St. James | Louisiana | 22093 | 979 | 40 |
772319 | 772319 | 2020-11-27 | St. James | Louisiana | 22093 | 979 | 40 |
769074 | 769074 | 2020-11-26 | St. James | Louisiana | 22093 | 965 | 40 |
765828 | 765828 | 2020-11-25 | St. James | Louisiana | 22093 | 965 | 40 |
762583 | 762583 | 2020-11-24 | St. James | Louisiana | 22093 | 963 | 40 |
759338 | 759338 | 2020-11-23 | St. James | Louisiana | 22093 | 951 | 40 |
756091 | 756091 | 2020-11-22 | St. James | Louisiana | 22093 | 947 | 40 |
752845 | 752845 | 2020-11-21 | St. James | Louisiana | 22093 | 934 | 40 |
749599 | 749599 | 2020-11-20 | St. James | Louisiana | 22093 | 934 | 40 |
746353 | 746353 | 2020-11-19 | St. James | Louisiana | 22093 | 927 | 40 |
743106 | 743106 | 2020-11-18 | St. James | Louisiana | 22093 | 922 | 40 |
739859 | 739859 | 2020-11-17 | St. James | Louisiana | 22093 | 920 | 40 |
736615 | 736615 | 2020-11-16 | St. James | Louisiana | 22093 | 901 | 40 |
733369 | 733369 | 2020-11-15 | St. James | Louisiana | 22093 | 900 | 40 |
730124 | 730124 | 2020-11-14 | St. James | Louisiana | 22093 | 898 | 40 |
726881 | 726881 | 2020-11-13 | St. James | Louisiana | 22093 | 898 | 40 |
723638 | 723638 | 2020-11-12 | St. James | Louisiana | 22093 | 864 | 40 |
720395 | 720395 | 2020-11-11 | St. James | Louisiana | 22093 | 861 | 40 |
717152 | 717152 | 2020-11-10 | St. James | Louisiana | 22093 | 861 | 40 |
713908 | 713908 | 2020-11-09 | St. James | Louisiana | 22093 | 856 | 40 |
710664 | 710664 | 2020-11-08 | St. James | Louisiana | 22093 | 854 | 40 |
707420 | 707420 | 2020-11-07 | St. James | Louisiana | 22093 | 854 | 40 |
704177 | 704177 | 2020-11-06 | St. James | Louisiana | 22093 | 854 | 40 |
700935 | 700935 | 2020-11-05 | St. James | Louisiana | 22093 | 852 | 40 |
697691 | 697691 | 2020-11-04 | St. James | Louisiana | 22093 | 851 | 40 |
694448 | 694448 | 2020-11-03 | St. James | Louisiana | 22093 | 850 | 40 |
691206 | 691206 | 2020-11-02 | St. James | Louisiana | 22093 | 849 | 40 |
687961 | 687961 | 2020-11-01 | St. James | Louisiana | 22093 | 846 | 40 |
684717 | 684717 | 2020-10-31 | St. James | Louisiana | 22093 | 846 | 40 |
681474 | 681474 | 2020-10-30 | St. James | Louisiana | 22093 | 846 | 40 |
678230 | 678230 | 2020-10-29 | St. James | Louisiana | 22093 | 845 | 40 |
674988 | 674988 | 2020-10-28 | St. James | Louisiana | 22093 | 847 | 40 |
671745 | 671745 | 2020-10-27 | St. James | Louisiana | 22093 | 841 | 40 |
668503 | 668503 | 2020-10-26 | St. James | Louisiana | 22093 | 839 | 40 |
665259 | 665259 | 2020-10-25 | St. James | Louisiana | 22093 | 837 | 40 |
662014 | 662014 | 2020-10-24 | St. James | Louisiana | 22093 | 837 | 40 |
658770 | 658770 | 2020-10-23 | St. James | Louisiana | 22093 | 837 | 40 |
655525 | 655525 | 2020-10-22 | St. James | Louisiana | 22093 | 834 | 40 |
652280 | 652280 | 2020-10-21 | St. James | Louisiana | 22093 | 832 | 40 |
649035 | 649035 | 2020-10-20 | St. James | Louisiana | 22093 | 829 | 40 |
645791 | 645791 | 2020-10-19 | St. James | Louisiana | 22093 | 830 | 40 |
642544 | 642544 | 2020-10-18 | St. James | Louisiana | 22093 | 830 | 40 |
639297 | 639297 | 2020-10-17 | St. James | Louisiana | 22093 | 828 | 40 |
636051 | 636051 | 2020-10-16 | St. James | Louisiana | 22093 | 828 | 40 |
632805 | 632805 | 2020-10-15 | St. James | Louisiana | 22093 | 826 | 40 |
629561 | 629561 | 2020-10-14 | St. James | Louisiana | 22093 | 825 | 40 |
626317 | 626317 | 2020-10-13 | St. James | Louisiana | 22093 | 820 | 40 |
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);