ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Richland" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279586 | 1279586 | 2021-05-02 | Richland | North Dakota | 38077 | 2002 | 17 |
1276339 | 1276339 | 2021-05-01 | Richland | North Dakota | 38077 | 2003 | 17 |
1273092 | 1273092 | 2021-04-30 | Richland | North Dakota | 38077 | 2000 | 17 |
1269845 | 1269845 | 2021-04-29 | Richland | North Dakota | 38077 | 1997 | 17 |
1266598 | 1266598 | 2021-04-28 | Richland | North Dakota | 38077 | 1993 | 17 |
1263351 | 1263351 | 2021-04-27 | Richland | North Dakota | 38077 | 1991 | 17 |
1260104 | 1260104 | 2021-04-26 | Richland | North Dakota | 38077 | 1983 | 17 |
1256857 | 1256857 | 2021-04-25 | Richland | North Dakota | 38077 | 1981 | 17 |
1253610 | 1253610 | 2021-04-24 | Richland | North Dakota | 38077 | 1980 | 17 |
1250363 | 1250363 | 2021-04-23 | Richland | North Dakota | 38077 | 1979 | 17 |
1247116 | 1247116 | 2021-04-22 | Richland | North Dakota | 38077 | 1975 | 17 |
1243869 | 1243869 | 2021-04-21 | Richland | North Dakota | 38077 | 1968 | 17 |
1240622 | 1240622 | 2021-04-20 | Richland | North Dakota | 38077 | 1962 | 17 |
1237375 | 1237375 | 2021-04-19 | Richland | North Dakota | 38077 | 1960 | 17 |
1234128 | 1234128 | 2021-04-18 | Richland | North Dakota | 38077 | 1958 | 17 |
1230880 | 1230880 | 2021-04-17 | Richland | North Dakota | 38077 | 1958 | 17 |
1227632 | 1227632 | 2021-04-16 | Richland | North Dakota | 38077 | 1956 | 17 |
1224384 | 1224384 | 2021-04-15 | Richland | North Dakota | 38077 | 1953 | 17 |
1221137 | 1221137 | 2021-04-14 | Richland | North Dakota | 38077 | 1952 | 17 |
1217889 | 1217889 | 2021-04-13 | Richland | North Dakota | 38077 | 1949 | 17 |
1214641 | 1214641 | 2021-04-12 | Richland | North Dakota | 38077 | 1940 | 17 |
1211394 | 1211394 | 2021-04-11 | Richland | North Dakota | 38077 | 1940 | 17 |
1208145 | 1208145 | 2021-04-10 | Richland | North Dakota | 38077 | 1940 | 17 |
1204897 | 1204897 | 2021-04-09 | Richland | North Dakota | 38077 | 1936 | 17 |
1201649 | 1201649 | 2021-04-08 | Richland | North Dakota | 38077 | 1931 | 17 |
1198400 | 1198400 | 2021-04-07 | Richland | North Dakota | 38077 | 1929 | 17 |
1195151 | 1195151 | 2021-04-06 | Richland | North Dakota | 38077 | 1922 | 17 |
1191903 | 1191903 | 2021-04-05 | Richland | North Dakota | 38077 | 1915 | 17 |
1188654 | 1188654 | 2021-04-04 | Richland | North Dakota | 38077 | 1915 | 17 |
1185407 | 1185407 | 2021-04-03 | Richland | North Dakota | 38077 | 1912 | 17 |
1182160 | 1182160 | 2021-04-02 | Richland | North Dakota | 38077 | 1911 | 17 |
1178913 | 1178913 | 2021-04-01 | Richland | North Dakota | 38077 | 1906 | 17 |
1175666 | 1175666 | 2021-03-31 | Richland | North Dakota | 38077 | 1900 | 17 |
1172419 | 1172419 | 2021-03-30 | Richland | North Dakota | 38077 | 1886 | 17 |
1169172 | 1169172 | 2021-03-29 | Richland | North Dakota | 38077 | 1878 | 17 |
1165924 | 1165924 | 2021-03-28 | Richland | North Dakota | 38077 | 1877 | 17 |
1162676 | 1162676 | 2021-03-27 | Richland | North Dakota | 38077 | 1877 | 17 |
1159427 | 1159427 | 2021-03-26 | Richland | North Dakota | 38077 | 1871 | 17 |
1156180 | 1156180 | 2021-03-25 | Richland | North Dakota | 38077 | 1866 | 17 |
1152933 | 1152933 | 2021-03-24 | Richland | North Dakota | 38077 | 1859 | 17 |
1149686 | 1149686 | 2021-03-23 | Richland | North Dakota | 38077 | 1851 | 17 |
1146439 | 1146439 | 2021-03-22 | Richland | North Dakota | 38077 | 1851 | 17 |
1143192 | 1143192 | 2021-03-21 | Richland | North Dakota | 38077 | 1851 | 17 |
1139945 | 1139945 | 2021-03-20 | Richland | North Dakota | 38077 | 1851 | 17 |
1136699 | 1136699 | 2021-03-19 | Richland | North Dakota | 38077 | 1847 | 17 |
1133453 | 1133453 | 2021-03-18 | Richland | North Dakota | 38077 | 1843 | 17 |
1130205 | 1130205 | 2021-03-17 | Richland | North Dakota | 38077 | 1841 | 17 |
1126958 | 1126958 | 2021-03-16 | Richland | North Dakota | 38077 | 1835 | 17 |
1123712 | 1123712 | 2021-03-15 | Richland | North Dakota | 38077 | 1826 | 17 |
1120466 | 1120466 | 2021-03-14 | Richland | North Dakota | 38077 | 1825 | 17 |
1117219 | 1117219 | 2021-03-13 | Richland | North Dakota | 38077 | 1824 | 17 |
1113972 | 1113972 | 2021-03-12 | Richland | North Dakota | 38077 | 1819 | 17 |
1110726 | 1110726 | 2021-03-11 | Richland | North Dakota | 38077 | 1808 | 17 |
1107480 | 1107480 | 2021-03-10 | Richland | North Dakota | 38077 | 1804 | 17 |
1104234 | 1104234 | 2021-03-09 | Richland | North Dakota | 38077 | 1797 | 16 |
1100988 | 1100988 | 2021-03-08 | Richland | North Dakota | 38077 | 1788 | 16 |
1097742 | 1097742 | 2021-03-07 | Richland | North Dakota | 38077 | 1783 | 16 |
1094494 | 1094494 | 2021-03-06 | Richland | North Dakota | 38077 | 1783 | 16 |
1091248 | 1091248 | 2021-03-05 | Richland | North Dakota | 38077 | 1777 | 16 |
1088003 | 1088003 | 2021-03-04 | Richland | North Dakota | 38077 | 1771 | 16 |
1084758 | 1084758 | 2021-03-03 | Richland | North Dakota | 38077 | 1766 | 16 |
1081512 | 1081512 | 2021-03-02 | Richland | North Dakota | 38077 | 1758 | 16 |
1078266 | 1078266 | 2021-03-01 | Richland | North Dakota | 38077 | 1749 | 16 |
1075021 | 1075021 | 2021-02-28 | Richland | North Dakota | 38077 | 1747 | 16 |
1071775 | 1071775 | 2021-02-27 | Richland | North Dakota | 38077 | 1747 | 16 |
1068529 | 1068529 | 2021-02-26 | Richland | North Dakota | 38077 | 1745 | 16 |
1065284 | 1065284 | 2021-02-25 | Richland | North Dakota | 38077 | 1740 | 16 |
1062040 | 1062040 | 2021-02-24 | Richland | North Dakota | 38077 | 1735 | 16 |
1058794 | 1058794 | 2021-02-23 | Richland | North Dakota | 38077 | 1727 | 16 |
1055548 | 1055548 | 2021-02-22 | Richland | North Dakota | 38077 | 1722 | 16 |
1052302 | 1052302 | 2021-02-21 | Richland | North Dakota | 38077 | 1722 | 16 |
1049055 | 1049055 | 2021-02-20 | Richland | North Dakota | 38077 | 1720 | 16 |
1045808 | 1045808 | 2021-02-19 | Richland | North Dakota | 38077 | 1721 | 16 |
1042563 | 1042563 | 2021-02-18 | Richland | North Dakota | 38077 | 1720 | 16 |
1039318 | 1039318 | 2021-02-17 | Richland | North Dakota | 38077 | 1718 | 16 |
1036073 | 1036073 | 2021-02-16 | Richland | North Dakota | 38077 | 1718 | 16 |
1032828 | 1032828 | 2021-02-15 | Richland | North Dakota | 38077 | 1717 | 16 |
1029582 | 1029582 | 2021-02-14 | Richland | North Dakota | 38077 | 1716 | 16 |
1026335 | 1026335 | 2021-02-13 | Richland | North Dakota | 38077 | 1716 | 16 |
1023090 | 1023090 | 2021-02-12 | Richland | North Dakota | 38077 | 1714 | 16 |
1019845 | 1019845 | 2021-02-11 | Richland | North Dakota | 38077 | 1714 | 16 |
1016600 | 1016600 | 2021-02-10 | Richland | North Dakota | 38077 | 1712 | 16 |
1013355 | 1013355 | 2021-02-09 | Richland | North Dakota | 38077 | 1713 | 16 |
1010110 | 1010110 | 2021-02-08 | Richland | North Dakota | 38077 | 1716 | 16 |
1006864 | 1006864 | 2021-02-07 | Richland | North Dakota | 38077 | 1714 | 16 |
1003618 | 1003618 | 2021-02-06 | Richland | North Dakota | 38077 | 1714 | 16 |
1000372 | 1000372 | 2021-02-05 | Richland | North Dakota | 38077 | 1715 | 16 |
997126 | 997126 | 2021-02-04 | Richland | North Dakota | 38077 | 1714 | 16 |
993880 | 993880 | 2021-02-03 | Richland | North Dakota | 38077 | 1708 | 16 |
990634 | 990634 | 2021-02-02 | Richland | North Dakota | 38077 | 1706 | 16 |
987388 | 987388 | 2021-02-01 | Richland | North Dakota | 38077 | 1699 | 16 |
984141 | 984141 | 2021-01-31 | Richland | North Dakota | 38077 | 1698 | 16 |
980894 | 980894 | 2021-01-30 | Richland | North Dakota | 38077 | 1697 | 16 |
977648 | 977648 | 2021-01-29 | Richland | North Dakota | 38077 | 1694 | 16 |
974403 | 974403 | 2021-01-28 | Richland | North Dakota | 38077 | 1684 | 15 |
971158 | 971158 | 2021-01-27 | Richland | North Dakota | 38077 | 1678 | 15 |
967913 | 967913 | 2021-01-26 | Richland | North Dakota | 38077 | 1671 | 15 |
964669 | 964669 | 2021-01-25 | Richland | North Dakota | 38077 | 1665 | 15 |
961424 | 961424 | 2021-01-24 | Richland | North Dakota | 38077 | 1664 | 15 |
958179 | 958179 | 2021-01-23 | Richland | North Dakota | 38077 | 1658 | 15 |
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);