ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Morton" 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 |
---|---|---|---|---|---|---|---|
1279577 | 1279577 | 2021-05-02 | Morton | North Dakota | 38059 | 5214 | 100 |
1276330 | 1276330 | 2021-05-01 | Morton | North Dakota | 38059 | 5211 | 100 |
1273083 | 1273083 | 2021-04-30 | Morton | North Dakota | 38059 | 5204 | 100 |
1269836 | 1269836 | 2021-04-29 | Morton | North Dakota | 38059 | 5201 | 100 |
1266589 | 1266589 | 2021-04-28 | Morton | North Dakota | 38059 | 5197 | 98 |
1263342 | 1263342 | 2021-04-27 | Morton | North Dakota | 38059 | 5188 | 98 |
1260095 | 1260095 | 2021-04-26 | Morton | North Dakota | 38059 | 5181 | 98 |
1256848 | 1256848 | 2021-04-25 | Morton | North Dakota | 38059 | 5176 | 98 |
1253601 | 1253601 | 2021-04-24 | Morton | North Dakota | 38059 | 5174 | 98 |
1250354 | 1250354 | 2021-04-23 | Morton | North Dakota | 38059 | 5167 | 98 |
1247107 | 1247107 | 2021-04-22 | Morton | North Dakota | 38059 | 5162 | 98 |
1243860 | 1243860 | 2021-04-21 | Morton | North Dakota | 38059 | 5152 | 98 |
1240613 | 1240613 | 2021-04-20 | Morton | North Dakota | 38059 | 5143 | 98 |
1237366 | 1237366 | 2021-04-19 | Morton | North Dakota | 38059 | 5126 | 98 |
1234119 | 1234119 | 2021-04-18 | Morton | North Dakota | 38059 | 5121 | 98 |
1230871 | 1230871 | 2021-04-17 | Morton | North Dakota | 38059 | 5114 | 98 |
1227623 | 1227623 | 2021-04-16 | Morton | North Dakota | 38059 | 5102 | 98 |
1224375 | 1224375 | 2021-04-15 | Morton | North Dakota | 38059 | 5099 | 98 |
1221128 | 1221128 | 2021-04-14 | Morton | North Dakota | 38059 | 5091 | 98 |
1217880 | 1217880 | 2021-04-13 | Morton | North Dakota | 38059 | 5079 | 98 |
1214632 | 1214632 | 2021-04-12 | Morton | North Dakota | 38059 | 5069 | 98 |
1211385 | 1211385 | 2021-04-11 | Morton | North Dakota | 38059 | 5066 | 98 |
1208136 | 1208136 | 2021-04-10 | Morton | North Dakota | 38059 | 5064 | 98 |
1204888 | 1204888 | 2021-04-09 | Morton | North Dakota | 38059 | 5057 | 98 |
1201640 | 1201640 | 2021-04-08 | Morton | North Dakota | 38059 | 5052 | 98 |
1198391 | 1198391 | 2021-04-07 | Morton | North Dakota | 38059 | 5048 | 98 |
1195142 | 1195142 | 2021-04-06 | Morton | North Dakota | 38059 | 5043 | 98 |
1191894 | 1191894 | 2021-04-05 | Morton | North Dakota | 38059 | 5039 | 98 |
1188645 | 1188645 | 2021-04-04 | Morton | North Dakota | 38059 | 5037 | 98 |
1185398 | 1185398 | 2021-04-03 | Morton | North Dakota | 38059 | 5036 | 98 |
1182151 | 1182151 | 2021-04-02 | Morton | North Dakota | 38059 | 5025 | 98 |
1178904 | 1178904 | 2021-04-01 | Morton | North Dakota | 38059 | 5019 | 98 |
1175657 | 1175657 | 2021-03-31 | Morton | North Dakota | 38059 | 5011 | 98 |
1172410 | 1172410 | 2021-03-30 | Morton | North Dakota | 38059 | 5009 | 98 |
1169163 | 1169163 | 2021-03-29 | Morton | North Dakota | 38059 | 5005 | 98 |
1165915 | 1165915 | 2021-03-28 | Morton | North Dakota | 38059 | 5002 | 98 |
1162667 | 1162667 | 2021-03-27 | Morton | North Dakota | 38059 | 4999 | 98 |
1159418 | 1159418 | 2021-03-26 | Morton | North Dakota | 38059 | 4992 | 98 |
1156171 | 1156171 | 2021-03-25 | Morton | North Dakota | 38059 | 4989 | 98 |
1152924 | 1152924 | 2021-03-24 | Morton | North Dakota | 38059 | 4986 | 98 |
1149677 | 1149677 | 2021-03-23 | Morton | North Dakota | 38059 | 4979 | 98 |
1146430 | 1146430 | 2021-03-22 | Morton | North Dakota | 38059 | 4979 | 97 |
1143183 | 1143183 | 2021-03-21 | Morton | North Dakota | 38059 | 4976 | 97 |
1139936 | 1139936 | 2021-03-20 | Morton | North Dakota | 38059 | 4976 | 97 |
1136690 | 1136690 | 2021-03-19 | Morton | North Dakota | 38059 | 4975 | 97 |
1133444 | 1133444 | 2021-03-18 | Morton | North Dakota | 38059 | 4974 | 97 |
1130196 | 1130196 | 2021-03-17 | Morton | North Dakota | 38059 | 4972 | 97 |
1126949 | 1126949 | 2021-03-16 | Morton | North Dakota | 38059 | 4969 | 97 |
1123703 | 1123703 | 2021-03-15 | Morton | North Dakota | 38059 | 4964 | 97 |
1120457 | 1120457 | 2021-03-14 | Morton | North Dakota | 38059 | 4962 | 97 |
1117210 | 1117210 | 2021-03-13 | Morton | North Dakota | 38059 | 4961 | 97 |
1113963 | 1113963 | 2021-03-12 | Morton | North Dakota | 38059 | 4961 | 97 |
1110717 | 1110717 | 2021-03-11 | Morton | North Dakota | 38059 | 4953 | 96 |
1107471 | 1107471 | 2021-03-10 | Morton | North Dakota | 38059 | 4951 | 96 |
1104225 | 1104225 | 2021-03-09 | Morton | North Dakota | 38059 | 4949 | 95 |
1100979 | 1100979 | 2021-03-08 | Morton | North Dakota | 38059 | 4949 | 95 |
1097733 | 1097733 | 2021-03-07 | Morton | North Dakota | 38059 | 4948 | 95 |
1094485 | 1094485 | 2021-03-06 | Morton | North Dakota | 38059 | 4947 | 95 |
1091239 | 1091239 | 2021-03-05 | Morton | North Dakota | 38059 | 4949 | 94 |
1087994 | 1087994 | 2021-03-04 | Morton | North Dakota | 38059 | 4948 | 94 |
1084749 | 1084749 | 2021-03-03 | Morton | North Dakota | 38059 | 4945 | 94 |
1081503 | 1081503 | 2021-03-02 | Morton | North Dakota | 38059 | 4942 | 94 |
1078257 | 1078257 | 2021-03-01 | Morton | North Dakota | 38059 | 4941 | 94 |
1075012 | 1075012 | 2021-02-28 | Morton | North Dakota | 38059 | 4941 | 94 |
1071766 | 1071766 | 2021-02-27 | Morton | North Dakota | 38059 | 4939 | 94 |
1068520 | 1068520 | 2021-02-26 | Morton | North Dakota | 38059 | 4936 | 94 |
1065275 | 1065275 | 2021-02-25 | Morton | North Dakota | 38059 | 4934 | 94 |
1062031 | 1062031 | 2021-02-24 | Morton | North Dakota | 38059 | 4932 | 94 |
1058785 | 1058785 | 2021-02-23 | Morton | North Dakota | 38059 | 4930 | 94 |
1055539 | 1055539 | 2021-02-22 | Morton | North Dakota | 38059 | 4924 | 94 |
1052293 | 1052293 | 2021-02-21 | Morton | North Dakota | 38059 | 4923 | 94 |
1049046 | 1049046 | 2021-02-20 | Morton | North Dakota | 38059 | 4920 | 94 |
1045799 | 1045799 | 2021-02-19 | Morton | North Dakota | 38059 | 4916 | 94 |
1042554 | 1042554 | 2021-02-18 | Morton | North Dakota | 38059 | 4913 | 94 |
1039309 | 1039309 | 2021-02-17 | Morton | North Dakota | 38059 | 4907 | 94 |
1036064 | 1036064 | 2021-02-16 | Morton | North Dakota | 38059 | 4904 | 94 |
1032819 | 1032819 | 2021-02-15 | Morton | North Dakota | 38059 | 4890 | 94 |
1029573 | 1029573 | 2021-02-14 | Morton | North Dakota | 38059 | 4889 | 94 |
1026326 | 1026326 | 2021-02-13 | Morton | North Dakota | 38059 | 4885 | 94 |
1023081 | 1023081 | 2021-02-12 | Morton | North Dakota | 38059 | 4885 | 94 |
1019836 | 1019836 | 2021-02-11 | Morton | North Dakota | 38059 | 4879 | 94 |
1016591 | 1016591 | 2021-02-10 | Morton | North Dakota | 38059 | 4873 | 94 |
1013346 | 1013346 | 2021-02-09 | Morton | North Dakota | 38059 | 4877 | 93 |
1010101 | 1010101 | 2021-02-08 | Morton | North Dakota | 38059 | 4884 | 93 |
1006855 | 1006855 | 2021-02-07 | Morton | North Dakota | 38059 | 4883 | 93 |
1003609 | 1003609 | 2021-02-06 | Morton | North Dakota | 38059 | 4880 | 93 |
1000363 | 1000363 | 2021-02-05 | Morton | North Dakota | 38059 | 4875 | 93 |
997117 | 997117 | 2021-02-04 | Morton | North Dakota | 38059 | 4865 | 93 |
993871 | 993871 | 2021-02-03 | Morton | North Dakota | 38059 | 4859 | 93 |
990625 | 990625 | 2021-02-02 | Morton | North Dakota | 38059 | 4851 | 93 |
987379 | 987379 | 2021-02-01 | Morton | North Dakota | 38059 | 4848 | 93 |
984132 | 984132 | 2021-01-31 | Morton | North Dakota | 38059 | 4840 | 93 |
980885 | 980885 | 2021-01-30 | Morton | North Dakota | 38059 | 4839 | 93 |
977639 | 977639 | 2021-01-29 | Morton | North Dakota | 38059 | 4836 | 93 |
974394 | 974394 | 2021-01-28 | Morton | North Dakota | 38059 | 4833 | 93 |
971149 | 971149 | 2021-01-27 | Morton | North Dakota | 38059 | 4827 | 93 |
967904 | 967904 | 2021-01-26 | Morton | North Dakota | 38059 | 4824 | 93 |
964660 | 964660 | 2021-01-25 | Morton | North Dakota | 38059 | 4817 | 93 |
961415 | 961415 | 2021-01-24 | Morton | North Dakota | 38059 | 4815 | 93 |
958170 | 958170 | 2021-01-23 | Morton | North Dakota | 38059 | 4812 | 93 |
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);