ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 22031 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1087098 | 1087098 | 2021-03-04 | De Soto | Louisiana | 22031 | 2653 | 73 |
1083852 | 1083852 | 2021-03-03 | De Soto | Louisiana | 22031 | 2650 | 73 |
1080606 | 1080606 | 2021-03-02 | De Soto | Louisiana | 22031 | 2644 | 72 |
1077361 | 1077361 | 2021-03-01 | De Soto | Louisiana | 22031 | 2643 | 71 |
1074115 | 1074115 | 2021-02-28 | De Soto | Louisiana | 22031 | 2639 | 71 |
1070869 | 1070869 | 2021-02-27 | De Soto | Louisiana | 22031 | 2640 | 71 |
1067624 | 1067624 | 2021-02-26 | De Soto | Louisiana | 22031 | 2640 | 71 |
1064379 | 1064379 | 2021-02-25 | De Soto | Louisiana | 22031 | 2635 | 71 |
1061134 | 1061134 | 2021-02-24 | De Soto | Louisiana | 22031 | 2635 | 71 |
1057888 | 1057888 | 2021-02-23 | De Soto | Louisiana | 22031 | 2624 | 71 |
1054642 | 1054642 | 2021-02-22 | De Soto | Louisiana | 22031 | 2619 | 71 |
1051395 | 1051395 | 2021-02-21 | De Soto | Louisiana | 22031 | 2617 | 70 |
1048148 | 1048148 | 2021-02-20 | De Soto | Louisiana | 22031 | 2609 | 70 |
1044903 | 1044903 | 2021-02-19 | De Soto | Louisiana | 22031 | 2609 | 70 |
1041658 | 1041658 | 2021-02-18 | De Soto | Louisiana | 22031 | 2609 | 70 |
1038413 | 1038413 | 2021-02-17 | De Soto | Louisiana | 22031 | 2602 | 69 |
1035168 | 1035168 | 2021-02-16 | De Soto | Louisiana | 22031 | 2609 | 69 |
1031922 | 1031922 | 2021-02-15 | De Soto | Louisiana | 22031 | 2609 | 69 |
1028675 | 1028675 | 2021-02-14 | De Soto | Louisiana | 22031 | 2603 | 69 |
1025430 | 1025430 | 2021-02-13 | De Soto | Louisiana | 22031 | 2593 | 69 |
1022185 | 1022185 | 2021-02-12 | De Soto | Louisiana | 22031 | 2593 | 69 |
1018940 | 1018940 | 2021-02-11 | De Soto | Louisiana | 22031 | 2590 | 69 |
1015695 | 1015695 | 2021-02-10 | De Soto | Louisiana | 22031 | 2574 | 69 |
1012450 | 1012450 | 2021-02-09 | De Soto | Louisiana | 22031 | 2568 | 68 |
1009204 | 1009204 | 2021-02-08 | De Soto | Louisiana | 22031 | 2569 | 68 |
1005958 | 1005958 | 2021-02-07 | De Soto | Louisiana | 22031 | 2552 | 67 |
1002712 | 1002712 | 2021-02-06 | De Soto | Louisiana | 22031 | 2544 | 67 |
999466 | 999466 | 2021-02-05 | De Soto | Louisiana | 22031 | 2544 | 67 |
996220 | 996220 | 2021-02-04 | De Soto | Louisiana | 22031 | 2534 | 67 |
992974 | 992974 | 2021-02-03 | De Soto | Louisiana | 22031 | 2464 | 67 |
989728 | 989728 | 2021-02-02 | De Soto | Louisiana | 22031 | 2465 | 66 |
986481 | 986481 | 2021-02-01 | De Soto | Louisiana | 22031 | 2445 | 65 |
983234 | 983234 | 2021-01-31 | De Soto | Louisiana | 22031 | 2441 | 63 |
979988 | 979988 | 2021-01-30 | De Soto | Louisiana | 22031 | 2402 | 61 |
976742 | 976742 | 2021-01-29 | De Soto | Louisiana | 22031 | 2402 | 61 |
973497 | 973497 | 2021-01-28 | De Soto | Louisiana | 22031 | 2390 | 61 |
970252 | 970252 | 2021-01-27 | De Soto | Louisiana | 22031 | 2343 | 61 |
967008 | 967008 | 2021-01-26 | De Soto | Louisiana | 22031 | 2312 | 59 |
963763 | 963763 | 2021-01-25 | De Soto | Louisiana | 22031 | 2287 | 59 |
960518 | 960518 | 2021-01-24 | De Soto | Louisiana | 22031 | 2231 | 59 |
957272 | 957272 | 2021-01-23 | De Soto | Louisiana | 22031 | 2193 | 58 |
954027 | 954027 | 2021-01-22 | De Soto | Louisiana | 22031 | 2193 | 58 |
950782 | 950782 | 2021-01-21 | De Soto | Louisiana | 22031 | 2155 | 56 |
947536 | 947536 | 2021-01-20 | De Soto | Louisiana | 22031 | 2108 | 56 |
944289 | 944289 | 2021-01-19 | De Soto | Louisiana | 22031 | 2088 | 55 |
941044 | 941044 | 2021-01-18 | De Soto | Louisiana | 22031 | 2081 | 55 |
937799 | 937799 | 2021-01-17 | De Soto | Louisiana | 22031 | 2071 | 54 |
934554 | 934554 | 2021-01-16 | De Soto | Louisiana | 22031 | 2031 | 54 |
931309 | 931309 | 2021-01-15 | De Soto | Louisiana | 22031 | 2031 | 54 |
928064 | 928064 | 2021-01-14 | De Soto | Louisiana | 22031 | 2004 | 54 |
924818 | 924818 | 2021-01-13 | De Soto | Louisiana | 22031 | 1987 | 54 |
921573 | 921573 | 2021-01-12 | De Soto | Louisiana | 22031 | 1975 | 54 |
918328 | 918328 | 2021-01-11 | De Soto | Louisiana | 22031 | 1958 | 54 |
915083 | 915083 | 2021-01-10 | De Soto | Louisiana | 22031 | 1954 | 54 |
911838 | 911838 | 2021-01-09 | De Soto | Louisiana | 22031 | 1916 | 54 |
908593 | 908593 | 2021-01-08 | De Soto | Louisiana | 22031 | 1916 | 54 |
905347 | 905347 | 2021-01-07 | De Soto | Louisiana | 22031 | 1888 | 53 |
902102 | 902102 | 2021-01-06 | De Soto | Louisiana | 22031 | 1865 | 53 |
898857 | 898857 | 2021-01-05 | De Soto | Louisiana | 22031 | 1825 | 52 |
895612 | 895612 | 2021-01-04 | De Soto | Louisiana | 22031 | 1805 | 52 |
892365 | 892365 | 2021-01-03 | De Soto | Louisiana | 22031 | 1801 | 51 |
889119 | 889119 | 2021-01-02 | De Soto | Louisiana | 22031 | 1764 | 51 |
885873 | 885873 | 2021-01-01 | De Soto | Louisiana | 22031 | 1764 | 51 |
882628 | 882628 | 2020-12-31 | De Soto | Louisiana | 22031 | 1764 | 51 |
879383 | 879383 | 2020-12-30 | De Soto | Louisiana | 22031 | 1738 | 51 |
876138 | 876138 | 2020-12-29 | De Soto | Louisiana | 22031 | 1708 | 51 |
872893 | 872893 | 2020-12-28 | De Soto | Louisiana | 22031 | 1685 | 50 |
869648 | 869648 | 2020-12-27 | De Soto | Louisiana | 22031 | 1686 | 49 |
866403 | 866403 | 2020-12-26 | De Soto | Louisiana | 22031 | 1665 | 49 |
863158 | 863158 | 2020-12-25 | De Soto | Louisiana | 22031 | 1665 | 49 |
859913 | 859913 | 2020-12-24 | De Soto | Louisiana | 22031 | 1665 | 49 |
856668 | 856668 | 2020-12-23 | De Soto | Louisiana | 22031 | 1651 | 45 |
853423 | 853423 | 2020-12-22 | De Soto | Louisiana | 22031 | 1633 | 45 |
850178 | 850178 | 2020-12-21 | De Soto | Louisiana | 22031 | 1610 | 45 |
846933 | 846933 | 2020-12-20 | De Soto | Louisiana | 22031 | 1599 | 45 |
843687 | 843687 | 2020-12-19 | De Soto | Louisiana | 22031 | 1578 | 44 |
840442 | 840442 | 2020-12-18 | De Soto | Louisiana | 22031 | 1578 | 44 |
837197 | 837197 | 2020-12-17 | De Soto | Louisiana | 22031 | 1558 | 44 |
833951 | 833951 | 2020-12-16 | De Soto | Louisiana | 22031 | 1541 | 44 |
830704 | 830704 | 2020-12-15 | De Soto | Louisiana | 22031 | 1513 | 43 |
827458 | 827458 | 2020-12-14 | De Soto | Louisiana | 22031 | 1500 | 43 |
824211 | 824211 | 2020-12-13 | De Soto | Louisiana | 22031 | 1488 | 43 |
820965 | 820965 | 2020-12-12 | De Soto | Louisiana | 22031 | 1472 | 43 |
817719 | 817719 | 2020-12-11 | De Soto | Louisiana | 22031 | 1472 | 43 |
814473 | 814473 | 2020-12-10 | De Soto | Louisiana | 22031 | 1452 | 42 |
811228 | 811228 | 2020-12-09 | De Soto | Louisiana | 22031 | 1436 | 41 |
807983 | 807983 | 2020-12-08 | De Soto | Louisiana | 22031 | 1415 | 41 |
804738 | 804738 | 2020-12-07 | De Soto | Louisiana | 22031 | 1406 | 41 |
801493 | 801493 | 2020-12-06 | De Soto | Louisiana | 22031 | 1401 | 41 |
798248 | 798248 | 2020-12-05 | De Soto | Louisiana | 22031 | 1366 | 39 |
795003 | 795003 | 2020-12-04 | De Soto | Louisiana | 22031 | 1366 | 39 |
791758 | 791758 | 2020-12-03 | De Soto | Louisiana | 22031 | 1341 | 39 |
788513 | 788513 | 2020-12-02 | De Soto | Louisiana | 22031 | 1320 | 39 |
785269 | 785269 | 2020-12-01 | De Soto | Louisiana | 22031 | 1283 | 39 |
782024 | 782024 | 2020-11-30 | De Soto | Louisiana | 22031 | 1262 | 39 |
778778 | 778778 | 2020-11-29 | De Soto | Louisiana | 22031 | 1260 | 39 |
775533 | 775533 | 2020-11-28 | De Soto | Louisiana | 22031 | 1253 | 39 |
772288 | 772288 | 2020-11-27 | De Soto | Louisiana | 22031 | 1253 | 39 |
769043 | 769043 | 2020-11-26 | De Soto | Louisiana | 22031 | 1230 | 39 |
765797 | 765797 | 2020-11-25 | De Soto | Louisiana | 22031 | 1230 | 39 |
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);