ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where county = "Pemiscot" and deaths = 29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1220670 | 1220670 | 2021-04-14 | Pemiscot | Missouri | 29155 | 1553 | 29 |
1217422 | 1217422 | 2021-04-13 | Pemiscot | Missouri | 29155 | 1551 | 29 |
1214175 | 1214175 | 2021-04-12 | Pemiscot | Missouri | 29155 | 1551 | 29 |
1210927 | 1210927 | 2021-04-11 | Pemiscot | Missouri | 29155 | 1551 | 29 |
1207678 | 1207678 | 2021-04-10 | Pemiscot | Missouri | 29155 | 1551 | 29 |
1204430 | 1204430 | 2021-04-09 | Pemiscot | Missouri | 29155 | 1549 | 29 |
1201182 | 1201182 | 2021-04-08 | Pemiscot | Missouri | 29155 | 1548 | 29 |
1197933 | 1197933 | 2021-04-07 | Pemiscot | Missouri | 29155 | 1546 | 29 |
1194684 | 1194684 | 2021-04-06 | Pemiscot | Missouri | 29155 | 1546 | 29 |
1191435 | 1191435 | 2021-04-05 | Pemiscot | Missouri | 29155 | 1545 | 29 |
1188187 | 1188187 | 2021-04-04 | Pemiscot | Missouri | 29155 | 1545 | 29 |
1184940 | 1184940 | 2021-04-03 | Pemiscot | Missouri | 29155 | 1545 | 29 |
1181694 | 1181694 | 2021-04-02 | Pemiscot | Missouri | 29155 | 1545 | 29 |
1178447 | 1178447 | 2021-04-01 | Pemiscot | Missouri | 29155 | 1545 | 29 |
1175200 | 1175200 | 2021-03-31 | Pemiscot | Missouri | 29155 | 1546 | 29 |
1171953 | 1171953 | 2021-03-30 | Pemiscot | Missouri | 29155 | 1543 | 29 |
1168705 | 1168705 | 2021-03-29 | Pemiscot | Missouri | 29155 | 1543 | 29 |
1165457 | 1165457 | 2021-03-28 | Pemiscot | Missouri | 29155 | 1543 | 29 |
1162209 | 1162209 | 2021-03-27 | Pemiscot | Missouri | 29155 | 1543 | 29 |
1158961 | 1158961 | 2021-03-26 | Pemiscot | Missouri | 29155 | 1543 | 29 |
1155714 | 1155714 | 2021-03-25 | Pemiscot | Missouri | 29155 | 1543 | 29 |
1152467 | 1152467 | 2021-03-24 | Pemiscot | Missouri | 29155 | 1542 | 29 |
1149220 | 1149220 | 2021-03-23 | Pemiscot | Missouri | 29155 | 1541 | 29 |
1145973 | 1145973 | 2021-03-22 | Pemiscot | Missouri | 29155 | 1539 | 29 |
1142726 | 1142726 | 2021-03-21 | Pemiscot | Missouri | 29155 | 1539 | 29 |
1139479 | 1139479 | 2021-03-20 | Pemiscot | Missouri | 29155 | 1539 | 29 |
1136233 | 1136233 | 2021-03-19 | Pemiscot | Missouri | 29155 | 1539 | 29 |
1132987 | 1132987 | 2021-03-18 | Pemiscot | Missouri | 29155 | 1539 | 29 |
1129739 | 1129739 | 2021-03-17 | Pemiscot | Missouri | 29155 | 1537 | 29 |
1126492 | 1126492 | 2021-03-16 | Pemiscot | Missouri | 29155 | 1537 | 29 |
1123246 | 1123246 | 2021-03-15 | Pemiscot | Missouri | 29155 | 1537 | 29 |
1119999 | 1119999 | 2021-03-14 | Pemiscot | Missouri | 29155 | 1537 | 29 |
1116752 | 1116752 | 2021-03-13 | Pemiscot | Missouri | 29155 | 1537 | 29 |
1113506 | 1113506 | 2021-03-12 | Pemiscot | Missouri | 29155 | 1535 | 29 |
1110260 | 1110260 | 2021-03-11 | Pemiscot | Missouri | 29155 | 1535 | 29 |
1107014 | 1107014 | 2021-03-10 | Pemiscot | Missouri | 29155 | 1535 | 29 |
1103768 | 1103768 | 2021-03-09 | Pemiscot | Missouri | 29155 | 1535 | 29 |
1100522 | 1100522 | 2021-03-08 | Pemiscot | Missouri | 29155 | 1535 | 29 |
1097275 | 1097275 | 2021-03-07 | Pemiscot | Missouri | 29155 | 1413 | 29 |
1094028 | 1094028 | 2021-03-06 | Pemiscot | Missouri | 29155 | 1413 | 29 |
1090782 | 1090782 | 2021-03-05 | Pemiscot | Missouri | 29155 | 1413 | 29 |
1087537 | 1087537 | 2021-03-04 | Pemiscot | Missouri | 29155 | 1413 | 29 |
1084292 | 1084292 | 2021-03-03 | Pemiscot | Missouri | 29155 | 1413 | 29 |
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);