ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where deaths = 30, fips = 29157 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1655752 | 1655752 | 2021-08-26 | Perry | Missouri | 29157 | 2571 | 30 |
1652505 | 1652505 | 2021-08-25 | Perry | Missouri | 29157 | 2548 | 30 |
1649257 | 1649257 | 2021-08-24 | Perry | Missouri | 29157 | 2546 | 30 |
1646008 | 1646008 | 2021-08-23 | Perry | Missouri | 29157 | 2530 | 30 |
1642759 | 1642759 | 2021-08-22 | Perry | Missouri | 29157 | 2528 | 30 |
1639509 | 1639509 | 2021-08-21 | Perry | Missouri | 29157 | 2514 | 30 |
1636259 | 1636259 | 2021-08-20 | Perry | Missouri | 29157 | 2501 | 30 |
1633009 | 1633009 | 2021-08-19 | Perry | Missouri | 29157 | 2499 | 30 |
1629762 | 1629762 | 2021-08-18 | Perry | Missouri | 29157 | 2483 | 30 |
1626515 | 1626515 | 2021-08-17 | Perry | Missouri | 29157 | 2471 | 30 |
1623268 | 1623268 | 2021-08-16 | Perry | Missouri | 29157 | 2460 | 30 |
1620021 | 1620021 | 2021-08-15 | Perry | Missouri | 29157 | 2460 | 30 |
1616773 | 1616773 | 2021-08-14 | Perry | Missouri | 29157 | 2457 | 30 |
1613525 | 1613525 | 2021-08-13 | Perry | Missouri | 29157 | 2444 | 30 |
1610276 | 1610276 | 2021-08-12 | Perry | Missouri | 29157 | 2434 | 30 |
1607028 | 1607028 | 2021-08-11 | Perry | Missouri | 29157 | 2428 | 30 |
1603779 | 1603779 | 2021-08-10 | Perry | Missouri | 29157 | 2407 | 30 |
1600530 | 1600530 | 2021-08-09 | Perry | Missouri | 29157 | 2400 | 30 |
1597282 | 1597282 | 2021-08-08 | Perry | Missouri | 29157 | 2400 | 30 |
1594033 | 1594033 | 2021-08-07 | Perry | Missouri | 29157 | 2399 | 30 |
1590784 | 1590784 | 2021-08-06 | Perry | Missouri | 29157 | 2388 | 30 |
1587535 | 1587535 | 2021-08-05 | Perry | Missouri | 29157 | 2379 | 30 |
1584284 | 1584284 | 2021-08-04 | Perry | Missouri | 29157 | 2375 | 30 |
1581035 | 1581035 | 2021-08-03 | Perry | Missouri | 29157 | 2358 | 30 |
1577786 | 1577786 | 2021-08-02 | Perry | Missouri | 29157 | 2354 | 30 |
1574538 | 1574538 | 2021-08-01 | Perry | Missouri | 29157 | 2354 | 30 |
1571290 | 1571290 | 2021-07-31 | Perry | Missouri | 29157 | 2351 | 30 |
1568042 | 1568042 | 2021-07-30 | Perry | Missouri | 29157 | 2347 | 30 |
1564794 | 1564794 | 2021-07-29 | Perry | Missouri | 29157 | 2334 | 30 |
1561546 | 1561546 | 2021-07-28 | Perry | Missouri | 29157 | 2325 | 30 |
1558298 | 1558298 | 2021-07-27 | Perry | Missouri | 29157 | 2323 | 30 |
1555051 | 1555051 | 2021-07-26 | Perry | Missouri | 29157 | 2314 | 30 |
1551804 | 1551804 | 2021-07-25 | Perry | Missouri | 29157 | 2314 | 30 |
1548557 | 1548557 | 2021-07-24 | Perry | Missouri | 29157 | 2313 | 30 |
1545310 | 1545310 | 2021-07-23 | Perry | Missouri | 29157 | 2310 | 30 |
1542062 | 1542062 | 2021-07-22 | Perry | Missouri | 29157 | 2308 | 30 |
1538815 | 1538815 | 2021-07-21 | Perry | Missouri | 29157 | 2305 | 30 |
1535568 | 1535568 | 2021-07-20 | Perry | Missouri | 29157 | 2304 | 30 |
1532320 | 1532320 | 2021-07-19 | Perry | Missouri | 29157 | 2302 | 30 |
1529073 | 1529073 | 2021-07-18 | Perry | Missouri | 29157 | 2302 | 30 |
1525826 | 1525826 | 2021-07-17 | Perry | Missouri | 29157 | 2301 | 30 |
1522579 | 1522579 | 2021-07-16 | Perry | Missouri | 29157 | 2300 | 30 |
1519330 | 1519330 | 2021-07-15 | Perry | Missouri | 29157 | 2301 | 30 |
1516083 | 1516083 | 2021-07-14 | Perry | Missouri | 29157 | 2294 | 30 |
1512837 | 1512837 | 2021-07-13 | Perry | Missouri | 29157 | 2292 | 30 |
1509590 | 1509590 | 2021-07-12 | Perry | Missouri | 29157 | 2291 | 30 |
1506344 | 1506344 | 2021-07-11 | Perry | Missouri | 29157 | 2291 | 30 |
1503098 | 1503098 | 2021-07-10 | Perry | Missouri | 29157 | 2291 | 30 |
1499852 | 1499852 | 2021-07-09 | Perry | Missouri | 29157 | 2288 | 30 |
1496606 | 1496606 | 2021-07-08 | Perry | Missouri | 29157 | 2287 | 30 |
1493359 | 1493359 | 2021-07-07 | Perry | Missouri | 29157 | 2286 | 30 |
1490112 | 1490112 | 2021-07-06 | Perry | Missouri | 29157 | 2282 | 30 |
1486865 | 1486865 | 2021-07-05 | Perry | Missouri | 29157 | 2282 | 30 |
1483619 | 1483619 | 2021-07-04 | Perry | Missouri | 29157 | 2282 | 30 |
1480373 | 1480373 | 2021-07-03 | Perry | Missouri | 29157 | 2282 | 30 |
1477126 | 1477126 | 2021-07-02 | Perry | Missouri | 29157 | 2280 | 30 |
1473880 | 1473880 | 2021-07-01 | Perry | Missouri | 29157 | 2279 | 30 |
1470634 | 1470634 | 2021-06-30 | Perry | Missouri | 29157 | 2279 | 30 |
1467389 | 1467389 | 2021-06-29 | Perry | Missouri | 29157 | 2279 | 30 |
1464144 | 1464144 | 2021-06-28 | Perry | Missouri | 29157 | 2276 | 30 |
1460899 | 1460899 | 2021-06-27 | Perry | Missouri | 29157 | 2276 | 30 |
1457654 | 1457654 | 2021-06-26 | Perry | Missouri | 29157 | 2274 | 30 |
1454409 | 1454409 | 2021-06-25 | Perry | Missouri | 29157 | 2274 | 30 |
1451164 | 1451164 | 2021-06-24 | Perry | Missouri | 29157 | 2272 | 30 |
1447918 | 1447918 | 2021-06-23 | Perry | Missouri | 29157 | 2271 | 30 |
1444673 | 1444673 | 2021-06-22 | Perry | Missouri | 29157 | 2271 | 30 |
1441428 | 1441428 | 2021-06-21 | Perry | Missouri | 29157 | 2271 | 30 |
1438182 | 1438182 | 2021-06-20 | Perry | Missouri | 29157 | 2270 | 30 |
1434935 | 1434935 | 2021-06-19 | Perry | Missouri | 29157 | 2270 | 30 |
1431688 | 1431688 | 2021-06-18 | Perry | Missouri | 29157 | 2270 | 30 |
1428443 | 1428443 | 2021-06-17 | Perry | Missouri | 29157 | 2270 | 30 |
1425198 | 1425198 | 2021-06-16 | Perry | Missouri | 29157 | 2270 | 30 |
1421950 | 1421950 | 2021-06-15 | Perry | Missouri | 29157 | 2269 | 30 |
1418705 | 1418705 | 2021-06-14 | Perry | Missouri | 29157 | 2269 | 30 |
1415460 | 1415460 | 2021-06-13 | Perry | Missouri | 29157 | 2269 | 30 |
1412214 | 1412214 | 2021-06-12 | Perry | Missouri | 29157 | 2268 | 30 |
1408969 | 1408969 | 2021-06-11 | Perry | Missouri | 29157 | 2268 | 30 |
1405724 | 1405724 | 2021-06-10 | Perry | Missouri | 29157 | 2266 | 30 |
1402478 | 1402478 | 2021-06-09 | Perry | Missouri | 29157 | 2264 | 30 |
1399233 | 1399233 | 2021-06-08 | Perry | Missouri | 29157 | 2260 | 30 |
1395987 | 1395987 | 2021-06-07 | Perry | Missouri | 29157 | 2256 | 30 |
1392741 | 1392741 | 2021-06-06 | Perry | Missouri | 29157 | 2256 | 30 |
1389496 | 1389496 | 2021-06-05 | Perry | Missouri | 29157 | 2256 | 30 |
1386251 | 1386251 | 2021-06-04 | Perry | Missouri | 29157 | 2254 | 30 |
1383006 | 1383006 | 2021-06-03 | Perry | Missouri | 29157 | 2253 | 30 |
1379760 | 1379760 | 2021-06-02 | Perry | Missouri | 29157 | 2248 | 30 |
1376515 | 1376515 | 2021-06-01 | Perry | Missouri | 29157 | 2248 | 30 |
1373269 | 1373269 | 2021-05-31 | Perry | Missouri | 29157 | 2247 | 30 |
1370024 | 1370024 | 2021-05-30 | Perry | Missouri | 29157 | 2246 | 30 |
1366778 | 1366778 | 2021-05-29 | Perry | Missouri | 29157 | 2246 | 30 |
1363532 | 1363532 | 2021-05-28 | Perry | Missouri | 29157 | 2246 | 30 |
1360285 | 1360285 | 2021-05-27 | Perry | Missouri | 29157 | 2245 | 30 |
1357039 | 1357039 | 2021-05-26 | Perry | Missouri | 29157 | 2244 | 30 |
1353793 | 1353793 | 2021-05-25 | Perry | Missouri | 29157 | 2244 | 30 |
1350547 | 1350547 | 2021-05-24 | Perry | Missouri | 29157 | 2244 | 30 |
1347301 | 1347301 | 2021-05-23 | Perry | Missouri | 29157 | 2244 | 30 |
1344053 | 1344053 | 2021-05-22 | Perry | Missouri | 29157 | 2244 | 30 |
1340804 | 1340804 | 2021-05-21 | Perry | Missouri | 29157 | 2242 | 30 |
1337557 | 1337557 | 2021-05-20 | Perry | Missouri | 29157 | 2240 | 30 |
1334310 | 1334310 | 2021-05-19 | Perry | Missouri | 29157 | 2239 | 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);