ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "St. James" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278710 | 1278710 | 2021-05-02 | St. James | Louisiana | 22093 | 1955 | 50 |
1275463 | 1275463 | 2021-05-01 | St. James | Louisiana | 22093 | 1955 | 50 |
1272216 | 1272216 | 2021-04-30 | St. James | Louisiana | 22093 | 1955 | 50 |
1268969 | 1268969 | 2021-04-29 | St. James | Louisiana | 22093 | 1946 | 50 |
1265722 | 1265722 | 2021-04-28 | St. James | Louisiana | 22093 | 1943 | 50 |
1262475 | 1262475 | 2021-04-27 | St. James | Louisiana | 22093 | 1939 | 50 |
1259228 | 1259228 | 2021-04-26 | St. James | Louisiana | 22093 | 1941 | 50 |
1255981 | 1255981 | 2021-04-25 | St. James | Louisiana | 22093 | 1937 | 50 |
1252734 | 1252734 | 2021-04-24 | St. James | Louisiana | 22093 | 1937 | 50 |
1249487 | 1249487 | 2021-04-23 | St. James | Louisiana | 22093 | 1937 | 50 |
1246240 | 1246240 | 2021-04-22 | St. James | Louisiana | 22093 | 1938 | 50 |
1242993 | 1242993 | 2021-04-21 | St. James | Louisiana | 22093 | 1937 | 50 |
1239746 | 1239746 | 2021-04-20 | St. James | Louisiana | 22093 | 1939 | 50 |
1236499 | 1236499 | 2021-04-19 | St. James | Louisiana | 22093 | 1938 | 50 |
1233252 | 1233252 | 2021-04-18 | St. James | Louisiana | 22093 | 1935 | 50 |
1230004 | 1230004 | 2021-04-17 | St. James | Louisiana | 22093 | 1935 | 50 |
1226756 | 1226756 | 2021-04-16 | St. James | Louisiana | 22093 | 1935 | 50 |
1223509 | 1223509 | 2021-04-15 | St. James | Louisiana | 22093 | 1931 | 50 |
1220261 | 1220261 | 2021-04-14 | St. James | Louisiana | 22093 | 1929 | 50 |
1217013 | 1217013 | 2021-04-13 | St. James | Louisiana | 22093 | 1923 | 50 |
1213766 | 1213766 | 2021-04-12 | St. James | Louisiana | 22093 | 1922 | 50 |
1210518 | 1210518 | 2021-04-11 | St. James | Louisiana | 22093 | 1922 | 49 |
1207269 | 1207269 | 2021-04-10 | St. James | Louisiana | 22093 | 1922 | 49 |
1204021 | 1204021 | 2021-04-09 | St. James | Louisiana | 22093 | 1922 | 49 |
1200773 | 1200773 | 2021-04-08 | St. James | Louisiana | 22093 | 1915 | 49 |
1197524 | 1197524 | 2021-04-07 | St. James | Louisiana | 22093 | 1915 | 49 |
1194276 | 1194276 | 2021-04-06 | St. James | Louisiana | 22093 | 1907 | 49 |
1191026 | 1191026 | 2021-04-05 | St. James | Louisiana | 22093 | 1912 | 49 |
1187779 | 1187779 | 2021-04-04 | St. James | Louisiana | 22093 | 1898 | 49 |
1184532 | 1184532 | 2021-04-03 | St. James | Louisiana | 22093 | 1898 | 49 |
1181285 | 1181285 | 2021-04-02 | St. James | Louisiana | 22093 | 1898 | 49 |
1178038 | 1178038 | 2021-04-01 | St. James | Louisiana | 22093 | 1898 | 49 |
1174791 | 1174791 | 2021-03-31 | St. James | Louisiana | 22093 | 1896 | 49 |
1171544 | 1171544 | 2021-03-30 | St. James | Louisiana | 22093 | 1895 | 49 |
1168296 | 1168296 | 2021-03-29 | St. James | Louisiana | 22093 | 1891 | 49 |
1165048 | 1165048 | 2021-03-28 | St. James | Louisiana | 22093 | 1888 | 49 |
1161800 | 1161800 | 2021-03-27 | St. James | Louisiana | 22093 | 1888 | 49 |
1158552 | 1158552 | 2021-03-26 | St. James | Louisiana | 22093 | 1888 | 49 |
1155305 | 1155305 | 2021-03-25 | St. James | Louisiana | 22093 | 1891 | 49 |
1152058 | 1152058 | 2021-03-24 | St. James | Louisiana | 22093 | 1888 | 49 |
1148811 | 1148811 | 2021-03-23 | St. James | Louisiana | 22093 | 1885 | 49 |
1145564 | 1145564 | 2021-03-22 | St. James | Louisiana | 22093 | 1889 | 49 |
1142317 | 1142317 | 2021-03-21 | St. James | Louisiana | 22093 | 1885 | 49 |
1139071 | 1139071 | 2021-03-20 | St. James | Louisiana | 22093 | 1885 | 49 |
1135825 | 1135825 | 2021-03-19 | St. James | Louisiana | 22093 | 1885 | 49 |
1132578 | 1132578 | 2021-03-18 | St. James | Louisiana | 22093 | 1884 | 49 |
1129330 | 1129330 | 2021-03-17 | St. James | Louisiana | 22093 | 1879 | 49 |
1126084 | 1126084 | 2021-03-16 | St. James | Louisiana | 22093 | 1882 | 49 |
1122838 | 1122838 | 2021-03-15 | St. James | Louisiana | 22093 | 1881 | 49 |
1119591 | 1119591 | 2021-03-14 | St. James | Louisiana | 22093 | 1880 | 49 |
1116344 | 1116344 | 2021-03-13 | St. James | Louisiana | 22093 | 1876 | 49 |
1113098 | 1113098 | 2021-03-12 | St. James | Louisiana | 22093 | 1876 | 49 |
1109852 | 1109852 | 2021-03-11 | St. James | Louisiana | 22093 | 1869 | 49 |
1106606 | 1106606 | 2021-03-10 | St. James | Louisiana | 22093 | 1869 | 49 |
1103360 | 1103360 | 2021-03-09 | St. James | Louisiana | 22093 | 1862 | 49 |
1100114 | 1100114 | 2021-03-08 | St. James | Louisiana | 22093 | 1863 | 49 |
1096866 | 1096866 | 2021-03-07 | St. James | Louisiana | 22093 | 1859 | 49 |
1093620 | 1093620 | 2021-03-06 | St. James | Louisiana | 22093 | 1858 | 49 |
1090374 | 1090374 | 2021-03-05 | St. James | Louisiana | 22093 | 1858 | 49 |
1087129 | 1087129 | 2021-03-04 | St. James | Louisiana | 22093 | 1858 | 49 |
1083883 | 1083883 | 2021-03-03 | St. James | Louisiana | 22093 | 1855 | 49 |
1080637 | 1080637 | 2021-03-02 | St. James | Louisiana | 22093 | 1854 | 49 |
1077392 | 1077392 | 2021-03-01 | St. James | Louisiana | 22093 | 1854 | 49 |
1074146 | 1074146 | 2021-02-28 | St. James | Louisiana | 22093 | 1853 | 49 |
1070900 | 1070900 | 2021-02-27 | St. James | Louisiana | 22093 | 1843 | 49 |
1067655 | 1067655 | 2021-02-26 | St. James | Louisiana | 22093 | 1843 | 49 |
1064410 | 1064410 | 2021-02-25 | St. James | Louisiana | 22093 | 1840 | 49 |
1061165 | 1061165 | 2021-02-24 | St. James | Louisiana | 22093 | 1844 | 49 |
1057919 | 1057919 | 2021-02-23 | St. James | Louisiana | 22093 | 1838 | 49 |
1054673 | 1054673 | 2021-02-22 | St. James | Louisiana | 22093 | 1836 | 49 |
1051426 | 1051426 | 2021-02-21 | St. James | Louisiana | 22093 | 1828 | 49 |
1048179 | 1048179 | 2021-02-20 | St. James | Louisiana | 22093 | 1817 | 49 |
1044934 | 1044934 | 2021-02-19 | St. James | Louisiana | 22093 | 1817 | 49 |
1041689 | 1041689 | 2021-02-18 | St. James | Louisiana | 22093 | 1821 | 48 |
1038444 | 1038444 | 2021-02-17 | St. James | Louisiana | 22093 | 1815 | 48 |
1035199 | 1035199 | 2021-02-16 | St. James | Louisiana | 22093 | 1814 | 48 |
1031953 | 1031953 | 2021-02-15 | St. James | Louisiana | 22093 | 1814 | 48 |
1028706 | 1028706 | 2021-02-14 | St. James | Louisiana | 22093 | 1800 | 48 |
1025461 | 1025461 | 2021-02-13 | St. James | Louisiana | 22093 | 1799 | 48 |
1022216 | 1022216 | 2021-02-12 | St. James | Louisiana | 22093 | 1799 | 48 |
1018971 | 1018971 | 2021-02-11 | St. James | Louisiana | 22093 | 1792 | 48 |
1015726 | 1015726 | 2021-02-10 | St. James | Louisiana | 22093 | 1783 | 48 |
1012481 | 1012481 | 2021-02-09 | St. James | Louisiana | 22093 | 1786 | 48 |
1009235 | 1009235 | 2021-02-08 | St. James | Louisiana | 22093 | 1774 | 48 |
1005989 | 1005989 | 2021-02-07 | St. James | Louisiana | 22093 | 1770 | 48 |
1002743 | 1002743 | 2021-02-06 | St. James | Louisiana | 22093 | 1756 | 48 |
999497 | 999497 | 2021-02-05 | St. James | Louisiana | 22093 | 1756 | 48 |
996251 | 996251 | 2021-02-04 | St. James | Louisiana | 22093 | 1753 | 48 |
993005 | 993005 | 2021-02-03 | St. James | Louisiana | 22093 | 1748 | 48 |
989759 | 989759 | 2021-02-02 | St. James | Louisiana | 22093 | 1741 | 48 |
986512 | 986512 | 2021-02-01 | St. James | Louisiana | 22093 | 1738 | 48 |
983265 | 983265 | 2021-01-31 | St. James | Louisiana | 22093 | 1724 | 47 |
980019 | 980019 | 2021-01-30 | St. James | Louisiana | 22093 | 1709 | 46 |
976773 | 976773 | 2021-01-29 | St. James | Louisiana | 22093 | 1709 | 46 |
973528 | 973528 | 2021-01-28 | St. James | Louisiana | 22093 | 1700 | 46 |
970283 | 970283 | 2021-01-27 | St. James | Louisiana | 22093 | 1697 | 46 |
967039 | 967039 | 2021-01-26 | St. James | Louisiana | 22093 | 1684 | 46 |
963794 | 963794 | 2021-01-25 | St. James | Louisiana | 22093 | 1670 | 46 |
960549 | 960549 | 2021-01-24 | St. James | Louisiana | 22093 | 1666 | 46 |
957303 | 957303 | 2021-01-23 | St. James | Louisiana | 22093 | 1648 | 46 |
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);