ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Foster" 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 |
---|---|---|---|---|---|---|---|
1279563 | 1279563 | 2021-05-02 | Foster | North Dakota | 38031 | 582 | 19 |
1276316 | 1276316 | 2021-05-01 | Foster | North Dakota | 38031 | 582 | 19 |
1273069 | 1273069 | 2021-04-30 | Foster | North Dakota | 38031 | 582 | 19 |
1269822 | 1269822 | 2021-04-29 | Foster | North Dakota | 38031 | 582 | 19 |
1266575 | 1266575 | 2021-04-28 | Foster | North Dakota | 38031 | 581 | 19 |
1263328 | 1263328 | 2021-04-27 | Foster | North Dakota | 38031 | 580 | 19 |
1260081 | 1260081 | 2021-04-26 | Foster | North Dakota | 38031 | 580 | 19 |
1256834 | 1256834 | 2021-04-25 | Foster | North Dakota | 38031 | 580 | 19 |
1253587 | 1253587 | 2021-04-24 | Foster | North Dakota | 38031 | 580 | 19 |
1250340 | 1250340 | 2021-04-23 | Foster | North Dakota | 38031 | 579 | 19 |
1247093 | 1247093 | 2021-04-22 | Foster | North Dakota | 38031 | 579 | 19 |
1243846 | 1243846 | 2021-04-21 | Foster | North Dakota | 38031 | 579 | 19 |
1240599 | 1240599 | 2021-04-20 | Foster | North Dakota | 38031 | 576 | 19 |
1237352 | 1237352 | 2021-04-19 | Foster | North Dakota | 38031 | 576 | 19 |
1234105 | 1234105 | 2021-04-18 | Foster | North Dakota | 38031 | 576 | 19 |
1230857 | 1230857 | 2021-04-17 | Foster | North Dakota | 38031 | 576 | 19 |
1227609 | 1227609 | 2021-04-16 | Foster | North Dakota | 38031 | 576 | 19 |
1224361 | 1224361 | 2021-04-15 | Foster | North Dakota | 38031 | 575 | 19 |
1221114 | 1221114 | 2021-04-14 | Foster | North Dakota | 38031 | 575 | 19 |
1217866 | 1217866 | 2021-04-13 | Foster | North Dakota | 38031 | 574 | 19 |
1214618 | 1214618 | 2021-04-12 | Foster | North Dakota | 38031 | 574 | 19 |
1211371 | 1211371 | 2021-04-11 | Foster | North Dakota | 38031 | 574 | 19 |
1208122 | 1208122 | 2021-04-10 | Foster | North Dakota | 38031 | 574 | 19 |
1204874 | 1204874 | 2021-04-09 | Foster | North Dakota | 38031 | 574 | 19 |
1201626 | 1201626 | 2021-04-08 | Foster | North Dakota | 38031 | 574 | 19 |
1198377 | 1198377 | 2021-04-07 | Foster | North Dakota | 38031 | 574 | 19 |
1195128 | 1195128 | 2021-04-06 | Foster | North Dakota | 38031 | 574 | 19 |
1191880 | 1191880 | 2021-04-05 | Foster | North Dakota | 38031 | 572 | 19 |
1188631 | 1188631 | 2021-04-04 | Foster | North Dakota | 38031 | 571 | 19 |
1185384 | 1185384 | 2021-04-03 | Foster | North Dakota | 38031 | 571 | 19 |
1182137 | 1182137 | 2021-04-02 | Foster | North Dakota | 38031 | 571 | 19 |
1178890 | 1178890 | 2021-04-01 | Foster | North Dakota | 38031 | 571 | 19 |
1175643 | 1175643 | 2021-03-31 | Foster | North Dakota | 38031 | 571 | 19 |
1172396 | 1172396 | 2021-03-30 | Foster | North Dakota | 38031 | 571 | 19 |
1169149 | 1169149 | 2021-03-29 | Foster | North Dakota | 38031 | 571 | 19 |
1165901 | 1165901 | 2021-03-28 | Foster | North Dakota | 38031 | 571 | 19 |
1162653 | 1162653 | 2021-03-27 | Foster | North Dakota | 38031 | 571 | 19 |
1159404 | 1159404 | 2021-03-26 | Foster | North Dakota | 38031 | 571 | 19 |
1156157 | 1156157 | 2021-03-25 | Foster | North Dakota | 38031 | 571 | 19 |
1152910 | 1152910 | 2021-03-24 | Foster | North Dakota | 38031 | 571 | 19 |
1149663 | 1149663 | 2021-03-23 | Foster | North Dakota | 38031 | 572 | 19 |
1146416 | 1146416 | 2021-03-22 | Foster | North Dakota | 38031 | 571 | 19 |
1143169 | 1143169 | 2021-03-21 | Foster | North Dakota | 38031 | 571 | 19 |
1139922 | 1139922 | 2021-03-20 | Foster | North Dakota | 38031 | 571 | 19 |
1136676 | 1136676 | 2021-03-19 | Foster | North Dakota | 38031 | 570 | 19 |
1133430 | 1133430 | 2021-03-18 | Foster | North Dakota | 38031 | 570 | 19 |
1130182 | 1130182 | 2021-03-17 | Foster | North Dakota | 38031 | 571 | 19 |
1126935 | 1126935 | 2021-03-16 | Foster | North Dakota | 38031 | 571 | 19 |
1123689 | 1123689 | 2021-03-15 | Foster | North Dakota | 38031 | 570 | 19 |
1120443 | 1120443 | 2021-03-14 | Foster | North Dakota | 38031 | 570 | 19 |
1117196 | 1117196 | 2021-03-13 | Foster | North Dakota | 38031 | 570 | 19 |
1113949 | 1113949 | 2021-03-12 | Foster | North Dakota | 38031 | 570 | 19 |
1110703 | 1110703 | 2021-03-11 | Foster | North Dakota | 38031 | 570 | 19 |
1107457 | 1107457 | 2021-03-10 | Foster | North Dakota | 38031 | 569 | 19 |
1104211 | 1104211 | 2021-03-09 | Foster | North Dakota | 38031 | 569 | 19 |
1100965 | 1100965 | 2021-03-08 | Foster | North Dakota | 38031 | 568 | 19 |
1097719 | 1097719 | 2021-03-07 | Foster | North Dakota | 38031 | 568 | 19 |
1094471 | 1094471 | 2021-03-06 | Foster | North Dakota | 38031 | 568 | 19 |
1091225 | 1091225 | 2021-03-05 | Foster | North Dakota | 38031 | 568 | 19 |
1087980 | 1087980 | 2021-03-04 | Foster | North Dakota | 38031 | 567 | 19 |
1084735 | 1084735 | 2021-03-03 | Foster | North Dakota | 38031 | 564 | 19 |
1081489 | 1081489 | 2021-03-02 | Foster | North Dakota | 38031 | 564 | 19 |
1078243 | 1078243 | 2021-03-01 | Foster | North Dakota | 38031 | 562 | 19 |
1074998 | 1074998 | 2021-02-28 | Foster | North Dakota | 38031 | 562 | 19 |
1071752 | 1071752 | 2021-02-27 | Foster | North Dakota | 38031 | 562 | 19 |
1068506 | 1068506 | 2021-02-26 | Foster | North Dakota | 38031 | 561 | 19 |
1065261 | 1065261 | 2021-02-25 | Foster | North Dakota | 38031 | 561 | 19 |
1062017 | 1062017 | 2021-02-24 | Foster | North Dakota | 38031 | 559 | 19 |
1058771 | 1058771 | 2021-02-23 | Foster | North Dakota | 38031 | 558 | 19 |
1055525 | 1055525 | 2021-02-22 | Foster | North Dakota | 38031 | 555 | 19 |
1052279 | 1052279 | 2021-02-21 | Foster | North Dakota | 38031 | 555 | 19 |
1049032 | 1049032 | 2021-02-20 | Foster | North Dakota | 38031 | 555 | 19 |
1045785 | 1045785 | 2021-02-19 | Foster | North Dakota | 38031 | 555 | 19 |
1042540 | 1042540 | 2021-02-18 | Foster | North Dakota | 38031 | 553 | 19 |
1039295 | 1039295 | 2021-02-17 | Foster | North Dakota | 38031 | 551 | 19 |
1036050 | 1036050 | 2021-02-16 | Foster | North Dakota | 38031 | 551 | 19 |
1032805 | 1032805 | 2021-02-15 | Foster | North Dakota | 38031 | 550 | 19 |
1029559 | 1029559 | 2021-02-14 | Foster | North Dakota | 38031 | 550 | 19 |
1026312 | 1026312 | 2021-02-13 | Foster | North Dakota | 38031 | 550 | 19 |
1023067 | 1023067 | 2021-02-12 | Foster | North Dakota | 38031 | 550 | 19 |
1019822 | 1019822 | 2021-02-11 | Foster | North Dakota | 38031 | 550 | 19 |
1016577 | 1016577 | 2021-02-10 | Foster | North Dakota | 38031 | 547 | 19 |
1013332 | 1013332 | 2021-02-09 | Foster | North Dakota | 38031 | 545 | 19 |
1010087 | 1010087 | 2021-02-08 | Foster | North Dakota | 38031 | 546 | 19 |
1006841 | 1006841 | 2021-02-07 | Foster | North Dakota | 38031 | 546 | 19 |
1003595 | 1003595 | 2021-02-06 | Foster | North Dakota | 38031 | 546 | 19 |
1000349 | 1000349 | 2021-02-05 | Foster | North Dakota | 38031 | 549 | 19 |
997103 | 997103 | 2021-02-04 | Foster | North Dakota | 38031 | 549 | 19 |
993857 | 993857 | 2021-02-03 | Foster | North Dakota | 38031 | 548 | 19 |
990611 | 990611 | 2021-02-02 | Foster | North Dakota | 38031 | 547 | 19 |
987365 | 987365 | 2021-02-01 | Foster | North Dakota | 38031 | 546 | 19 |
984118 | 984118 | 2021-01-31 | Foster | North Dakota | 38031 | 546 | 19 |
980871 | 980871 | 2021-01-30 | Foster | North Dakota | 38031 | 546 | 19 |
977625 | 977625 | 2021-01-29 | Foster | North Dakota | 38031 | 546 | 19 |
974380 | 974380 | 2021-01-28 | Foster | North Dakota | 38031 | 546 | 19 |
971135 | 971135 | 2021-01-27 | Foster | North Dakota | 38031 | 545 | 19 |
967890 | 967890 | 2021-01-26 | Foster | North Dakota | 38031 | 544 | 19 |
964646 | 964646 | 2021-01-25 | Foster | North Dakota | 38031 | 544 | 19 |
961401 | 961401 | 2021-01-24 | Foster | North Dakota | 38031 | 544 | 19 |
958156 | 958156 | 2021-01-23 | Foster | North Dakota | 38031 | 544 | 19 |
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);