ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where county = "Pemiscot" and deaths = 30 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 |
---|---|---|---|---|---|---|---|
1327815 | 1327815 | 2021-05-17 | Pemiscot | Missouri | 29155 | 1595 | 30 |
1324569 | 1324569 | 2021-05-16 | Pemiscot | Missouri | 29155 | 1595 | 30 |
1321323 | 1321323 | 2021-05-15 | Pemiscot | Missouri | 29155 | 1595 | 30 |
1318077 | 1318077 | 2021-05-14 | Pemiscot | Missouri | 29155 | 1594 | 30 |
1314829 | 1314829 | 2021-05-13 | Pemiscot | Missouri | 29155 | 1591 | 30 |
1311583 | 1311583 | 2021-05-12 | Pemiscot | Missouri | 29155 | 1590 | 30 |
1308336 | 1308336 | 2021-05-11 | Pemiscot | Missouri | 29155 | 1588 | 30 |
1305090 | 1305090 | 2021-05-10 | Pemiscot | Missouri | 29155 | 1585 | 30 |
1301844 | 1301844 | 2021-05-09 | Pemiscot | Missouri | 29155 | 1585 | 30 |
1298596 | 1298596 | 2021-05-08 | Pemiscot | Missouri | 29155 | 1584 | 30 |
1295350 | 1295350 | 2021-05-07 | Pemiscot | Missouri | 29155 | 1582 | 30 |
1292104 | 1292104 | 2021-05-06 | Pemiscot | Missouri | 29155 | 1581 | 30 |
1288858 | 1288858 | 2021-05-05 | Pemiscot | Missouri | 29155 | 1578 | 30 |
1285612 | 1285612 | 2021-05-04 | Pemiscot | Missouri | 29155 | 1578 | 30 |
1282366 | 1282366 | 2021-05-03 | Pemiscot | Missouri | 29155 | 1579 | 30 |
1279119 | 1279119 | 2021-05-02 | Pemiscot | Missouri | 29155 | 1579 | 30 |
1275872 | 1275872 | 2021-05-01 | Pemiscot | Missouri | 29155 | 1578 | 30 |
1272625 | 1272625 | 2021-04-30 | Pemiscot | Missouri | 29155 | 1577 | 30 |
1269378 | 1269378 | 2021-04-29 | Pemiscot | Missouri | 29155 | 1576 | 30 |
1266131 | 1266131 | 2021-04-28 | Pemiscot | Missouri | 29155 | 1573 | 30 |
1262884 | 1262884 | 2021-04-27 | Pemiscot | Missouri | 29155 | 1570 | 30 |
1259637 | 1259637 | 2021-04-26 | Pemiscot | Missouri | 29155 | 1570 | 30 |
1256390 | 1256390 | 2021-04-25 | Pemiscot | Missouri | 29155 | 1569 | 30 |
1253143 | 1253143 | 2021-04-24 | Pemiscot | Missouri | 29155 | 1569 | 30 |
1249896 | 1249896 | 2021-04-23 | Pemiscot | Missouri | 29155 | 1566 | 30 |
1246649 | 1246649 | 2021-04-22 | Pemiscot | Missouri | 29155 | 1565 | 30 |
1243402 | 1243402 | 2021-04-21 | Pemiscot | Missouri | 29155 | 1563 | 30 |
1240155 | 1240155 | 2021-04-20 | Pemiscot | Missouri | 29155 | 1562 | 30 |
1236908 | 1236908 | 2021-04-19 | Pemiscot | Missouri | 29155 | 1559 | 30 |
1233661 | 1233661 | 2021-04-18 | Pemiscot | Missouri | 29155 | 1559 | 30 |
1230413 | 1230413 | 2021-04-17 | Pemiscot | Missouri | 29155 | 1556 | 30 |
1227165 | 1227165 | 2021-04-16 | Pemiscot | Missouri | 29155 | 1566 | 30 |
1223917 | 1223917 | 2021-04-15 | Pemiscot | Missouri | 29155 | 1561 | 30 |
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);