ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Slope" 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 |
---|---|---|---|---|---|---|---|
1279591 | 1279591 | 2021-05-02 | Slope | North Dakota | 38087 | 32 | 0 |
1276344 | 1276344 | 2021-05-01 | Slope | North Dakota | 38087 | 32 | 0 |
1273097 | 1273097 | 2021-04-30 | Slope | North Dakota | 38087 | 32 | 0 |
1269850 | 1269850 | 2021-04-29 | Slope | North Dakota | 38087 | 32 | 0 |
1266603 | 1266603 | 2021-04-28 | Slope | North Dakota | 38087 | 32 | 0 |
1263356 | 1263356 | 2021-04-27 | Slope | North Dakota | 38087 | 32 | 0 |
1260109 | 1260109 | 2021-04-26 | Slope | North Dakota | 38087 | 32 | 0 |
1256862 | 1256862 | 2021-04-25 | Slope | North Dakota | 38087 | 32 | 0 |
1253615 | 1253615 | 2021-04-24 | Slope | North Dakota | 38087 | 32 | 0 |
1250368 | 1250368 | 2021-04-23 | Slope | North Dakota | 38087 | 32 | 0 |
1247121 | 1247121 | 2021-04-22 | Slope | North Dakota | 38087 | 32 | 0 |
1243874 | 1243874 | 2021-04-21 | Slope | North Dakota | 38087 | 32 | 0 |
1240627 | 1240627 | 2021-04-20 | Slope | North Dakota | 38087 | 32 | 0 |
1237380 | 1237380 | 2021-04-19 | Slope | North Dakota | 38087 | 32 | 0 |
1234133 | 1234133 | 2021-04-18 | Slope | North Dakota | 38087 | 32 | 0 |
1230885 | 1230885 | 2021-04-17 | Slope | North Dakota | 38087 | 32 | 0 |
1227637 | 1227637 | 2021-04-16 | Slope | North Dakota | 38087 | 32 | 0 |
1224389 | 1224389 | 2021-04-15 | Slope | North Dakota | 38087 | 32 | 0 |
1221142 | 1221142 | 2021-04-14 | Slope | North Dakota | 38087 | 32 | 0 |
1217894 | 1217894 | 2021-04-13 | Slope | North Dakota | 38087 | 32 | 0 |
1214646 | 1214646 | 2021-04-12 | Slope | North Dakota | 38087 | 32 | 0 |
1211399 | 1211399 | 2021-04-11 | Slope | North Dakota | 38087 | 32 | 0 |
1208150 | 1208150 | 2021-04-10 | Slope | North Dakota | 38087 | 32 | 0 |
1204902 | 1204902 | 2021-04-09 | Slope | North Dakota | 38087 | 32 | 0 |
1201654 | 1201654 | 2021-04-08 | Slope | North Dakota | 38087 | 32 | 0 |
1198405 | 1198405 | 2021-04-07 | Slope | North Dakota | 38087 | 32 | 0 |
1195156 | 1195156 | 2021-04-06 | Slope | North Dakota | 38087 | 32 | 0 |
1191908 | 1191908 | 2021-04-05 | Slope | North Dakota | 38087 | 32 | 0 |
1188659 | 1188659 | 2021-04-04 | Slope | North Dakota | 38087 | 32 | 0 |
1185412 | 1185412 | 2021-04-03 | Slope | North Dakota | 38087 | 32 | 0 |
1182165 | 1182165 | 2021-04-02 | Slope | North Dakota | 38087 | 32 | 0 |
1178918 | 1178918 | 2021-04-01 | Slope | North Dakota | 38087 | 32 | 0 |
1175671 | 1175671 | 2021-03-31 | Slope | North Dakota | 38087 | 32 | 0 |
1172424 | 1172424 | 2021-03-30 | Slope | North Dakota | 38087 | 32 | 0 |
1169177 | 1169177 | 2021-03-29 | Slope | North Dakota | 38087 | 32 | 0 |
1165929 | 1165929 | 2021-03-28 | Slope | North Dakota | 38087 | 32 | 0 |
1162681 | 1162681 | 2021-03-27 | Slope | North Dakota | 38087 | 32 | 0 |
1159432 | 1159432 | 2021-03-26 | Slope | North Dakota | 38087 | 32 | 0 |
1156185 | 1156185 | 2021-03-25 | Slope | North Dakota | 38087 | 32 | 0 |
1152938 | 1152938 | 2021-03-24 | Slope | North Dakota | 38087 | 31 | 0 |
1149691 | 1149691 | 2021-03-23 | Slope | North Dakota | 38087 | 31 | 0 |
1146444 | 1146444 | 2021-03-22 | Slope | North Dakota | 38087 | 31 | 0 |
1143197 | 1143197 | 2021-03-21 | Slope | North Dakota | 38087 | 31 | 0 |
1139950 | 1139950 | 2021-03-20 | Slope | North Dakota | 38087 | 31 | 0 |
1136704 | 1136704 | 2021-03-19 | Slope | North Dakota | 38087 | 31 | 0 |
1133458 | 1133458 | 2021-03-18 | Slope | North Dakota | 38087 | 31 | 0 |
1130210 | 1130210 | 2021-03-17 | Slope | North Dakota | 38087 | 31 | 0 |
1126963 | 1126963 | 2021-03-16 | Slope | North Dakota | 38087 | 31 | 0 |
1123717 | 1123717 | 2021-03-15 | Slope | North Dakota | 38087 | 31 | 0 |
1120471 | 1120471 | 2021-03-14 | Slope | North Dakota | 38087 | 31 | 0 |
1117224 | 1117224 | 2021-03-13 | Slope | North Dakota | 38087 | 31 | 0 |
1113977 | 1113977 | 2021-03-12 | Slope | North Dakota | 38087 | 31 | 0 |
1110731 | 1110731 | 2021-03-11 | Slope | North Dakota | 38087 | 31 | 0 |
1107485 | 1107485 | 2021-03-10 | Slope | North Dakota | 38087 | 31 | 0 |
1104239 | 1104239 | 2021-03-09 | Slope | North Dakota | 38087 | 31 | 0 |
1100993 | 1100993 | 2021-03-08 | Slope | North Dakota | 38087 | 31 | 0 |
1097747 | 1097747 | 2021-03-07 | Slope | North Dakota | 38087 | 31 | 0 |
1094499 | 1094499 | 2021-03-06 | Slope | North Dakota | 38087 | 31 | 0 |
1091253 | 1091253 | 2021-03-05 | Slope | North Dakota | 38087 | 31 | 0 |
1088008 | 1088008 | 2021-03-04 | Slope | North Dakota | 38087 | 31 | 0 |
1084763 | 1084763 | 2021-03-03 | Slope | North Dakota | 38087 | 31 | 0 |
1081517 | 1081517 | 2021-03-02 | Slope | North Dakota | 38087 | 31 | 0 |
1078271 | 1078271 | 2021-03-01 | Slope | North Dakota | 38087 | 31 | 0 |
1075026 | 1075026 | 2021-02-28 | Slope | North Dakota | 38087 | 31 | 0 |
1071780 | 1071780 | 2021-02-27 | Slope | North Dakota | 38087 | 31 | 0 |
1068534 | 1068534 | 2021-02-26 | Slope | North Dakota | 38087 | 31 | 0 |
1065289 | 1065289 | 2021-02-25 | Slope | North Dakota | 38087 | 31 | 0 |
1062045 | 1062045 | 2021-02-24 | Slope | North Dakota | 38087 | 31 | 0 |
1058799 | 1058799 | 2021-02-23 | Slope | North Dakota | 38087 | 31 | 0 |
1055553 | 1055553 | 2021-02-22 | Slope | North Dakota | 38087 | 30 | 0 |
1052307 | 1052307 | 2021-02-21 | Slope | North Dakota | 38087 | 30 | 0 |
1049060 | 1049060 | 2021-02-20 | Slope | North Dakota | 38087 | 30 | 0 |
1045813 | 1045813 | 2021-02-19 | Slope | North Dakota | 38087 | 30 | 0 |
1042568 | 1042568 | 2021-02-18 | Slope | North Dakota | 38087 | 30 | 0 |
1039323 | 1039323 | 2021-02-17 | Slope | North Dakota | 38087 | 30 | 0 |
1036078 | 1036078 | 2021-02-16 | Slope | North Dakota | 38087 | 30 | 0 |
1032833 | 1032833 | 2021-02-15 | Slope | North Dakota | 38087 | 30 | 0 |
1029587 | 1029587 | 2021-02-14 | Slope | North Dakota | 38087 | 30 | 0 |
1026340 | 1026340 | 2021-02-13 | Slope | North Dakota | 38087 | 30 | 0 |
1023095 | 1023095 | 2021-02-12 | Slope | North Dakota | 38087 | 30 | 0 |
1019850 | 1019850 | 2021-02-11 | Slope | North Dakota | 38087 | 30 | 0 |
1016605 | 1016605 | 2021-02-10 | Slope | North Dakota | 38087 | 30 | 0 |
1013360 | 1013360 | 2021-02-09 | Slope | North Dakota | 38087 | 30 | 0 |
1010115 | 1010115 | 2021-02-08 | Slope | North Dakota | 38087 | 30 | 0 |
1006869 | 1006869 | 2021-02-07 | Slope | North Dakota | 38087 | 30 | 0 |
1003623 | 1003623 | 2021-02-06 | Slope | North Dakota | 38087 | 30 | 0 |
1000377 | 1000377 | 2021-02-05 | Slope | North Dakota | 38087 | 30 | 0 |
997131 | 997131 | 2021-02-04 | Slope | North Dakota | 38087 | 30 | 0 |
993885 | 993885 | 2021-02-03 | Slope | North Dakota | 38087 | 30 | 0 |
990639 | 990639 | 2021-02-02 | Slope | North Dakota | 38087 | 30 | 0 |
987393 | 987393 | 2021-02-01 | Slope | North Dakota | 38087 | 30 | 0 |
984146 | 984146 | 2021-01-31 | Slope | North Dakota | 38087 | 30 | 0 |
980899 | 980899 | 2021-01-30 | Slope | North Dakota | 38087 | 30 | 0 |
977653 | 977653 | 2021-01-29 | Slope | North Dakota | 38087 | 30 | 0 |
974408 | 974408 | 2021-01-28 | Slope | North Dakota | 38087 | 30 | 0 |
971163 | 971163 | 2021-01-27 | Slope | North Dakota | 38087 | 30 | 0 |
967918 | 967918 | 2021-01-26 | Slope | North Dakota | 38087 | 30 | 0 |
964674 | 964674 | 2021-01-25 | Slope | North Dakota | 38087 | 30 | 0 |
961429 | 961429 | 2021-01-24 | Slope | North Dakota | 38087 | 30 | 0 |
958184 | 958184 | 2021-01-23 | Slope | North Dakota | 38087 | 30 | 0 |
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);