ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where county = "Putnam", deaths = 4 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 |
---|---|---|---|---|---|---|---|
1613532 | 1613532 | 2021-08-13 | Putnam | Missouri | 29171 | 527 | 4 |
1610283 | 1610283 | 2021-08-12 | Putnam | Missouri | 29171 | 521 | 4 |
1607035 | 1607035 | 2021-08-11 | Putnam | Missouri | 29171 | 518 | 4 |
1603786 | 1603786 | 2021-08-10 | Putnam | Missouri | 29171 | 514 | 4 |
1600537 | 1600537 | 2021-08-09 | Putnam | Missouri | 29171 | 514 | 4 |
1597289 | 1597289 | 2021-08-08 | Putnam | Missouri | 29171 | 514 | 4 |
1594040 | 1594040 | 2021-08-07 | Putnam | Missouri | 29171 | 514 | 4 |
1590791 | 1590791 | 2021-08-06 | Putnam | Missouri | 29171 | 514 | 4 |
1587542 | 1587542 | 2021-08-05 | Putnam | Missouri | 29171 | 509 | 4 |
1584291 | 1584291 | 2021-08-04 | Putnam | Missouri | 29171 | 505 | 4 |
1581042 | 1581042 | 2021-08-03 | Putnam | Missouri | 29171 | 503 | 4 |
1577793 | 1577793 | 2021-08-02 | Putnam | Missouri | 29171 | 502 | 4 |
1574545 | 1574545 | 2021-08-01 | Putnam | Missouri | 29171 | 502 | 4 |
1571297 | 1571297 | 2021-07-31 | Putnam | Missouri | 29171 | 501 | 4 |
1568049 | 1568049 | 2021-07-30 | Putnam | Missouri | 29171 | 500 | 4 |
1564801 | 1564801 | 2021-07-29 | Putnam | Missouri | 29171 | 500 | 4 |
1561553 | 1561553 | 2021-07-28 | Putnam | Missouri | 29171 | 500 | 4 |
1558305 | 1558305 | 2021-07-27 | Putnam | Missouri | 29171 | 499 | 4 |
1555058 | 1555058 | 2021-07-26 | Putnam | Missouri | 29171 | 497 | 4 |
1551811 | 1551811 | 2021-07-25 | Putnam | Missouri | 29171 | 497 | 4 |
1548564 | 1548564 | 2021-07-24 | Putnam | Missouri | 29171 | 497 | 4 |
1545317 | 1545317 | 2021-07-23 | Putnam | Missouri | 29171 | 497 | 4 |
1542069 | 1542069 | 2021-07-22 | Putnam | Missouri | 29171 | 497 | 4 |
1538822 | 1538822 | 2021-07-21 | Putnam | Missouri | 29171 | 493 | 4 |
1535575 | 1535575 | 2021-07-20 | Putnam | Missouri | 29171 | 490 | 4 |
1532327 | 1532327 | 2021-07-19 | Putnam | Missouri | 29171 | 489 | 4 |
1529080 | 1529080 | 2021-07-18 | Putnam | Missouri | 29171 | 489 | 4 |
1525833 | 1525833 | 2021-07-17 | Putnam | Missouri | 29171 | 489 | 4 |
1522586 | 1522586 | 2021-07-16 | Putnam | Missouri | 29171 | 489 | 4 |
1519337 | 1519337 | 2021-07-15 | Putnam | Missouri | 29171 | 490 | 4 |
1516090 | 1516090 | 2021-07-14 | Putnam | Missouri | 29171 | 488 | 4 |
1512844 | 1512844 | 2021-07-13 | Putnam | Missouri | 29171 | 488 | 4 |
1509597 | 1509597 | 2021-07-12 | Putnam | Missouri | 29171 | 488 | 4 |
1506351 | 1506351 | 2021-07-11 | Putnam | Missouri | 29171 | 488 | 4 |
1503105 | 1503105 | 2021-07-10 | Putnam | Missouri | 29171 | 488 | 4 |
1499859 | 1499859 | 2021-07-09 | Putnam | Missouri | 29171 | 488 | 4 |
1496613 | 1496613 | 2021-07-08 | Putnam | Missouri | 29171 | 487 | 4 |
1493366 | 1493366 | 2021-07-07 | Putnam | Missouri | 29171 | 486 | 4 |
1490119 | 1490119 | 2021-07-06 | Putnam | Missouri | 29171 | 486 | 4 |
1486872 | 1486872 | 2021-07-05 | Putnam | Missouri | 29171 | 486 | 4 |
1483626 | 1483626 | 2021-07-04 | Putnam | Missouri | 29171 | 486 | 4 |
1480380 | 1480380 | 2021-07-03 | Putnam | Missouri | 29171 | 486 | 4 |
1477133 | 1477133 | 2021-07-02 | Putnam | Missouri | 29171 | 486 | 4 |
1473887 | 1473887 | 2021-07-01 | Putnam | Missouri | 29171 | 485 | 4 |
1470641 | 1470641 | 2021-06-30 | Putnam | Missouri | 29171 | 485 | 4 |
1467396 | 1467396 | 2021-06-29 | Putnam | Missouri | 29171 | 485 | 4 |
1464151 | 1464151 | 2021-06-28 | Putnam | Missouri | 29171 | 485 | 4 |
1460906 | 1460906 | 2021-06-27 | Putnam | Missouri | 29171 | 485 | 4 |
1457661 | 1457661 | 2021-06-26 | Putnam | Missouri | 29171 | 485 | 4 |
1454416 | 1454416 | 2021-06-25 | Putnam | Missouri | 29171 | 485 | 4 |
1451171 | 1451171 | 2021-06-24 | Putnam | Missouri | 29171 | 485 | 4 |
1447925 | 1447925 | 2021-06-23 | Putnam | Missouri | 29171 | 485 | 4 |
1444680 | 1444680 | 2021-06-22 | Putnam | Missouri | 29171 | 484 | 4 |
1441435 | 1441435 | 2021-06-21 | Putnam | Missouri | 29171 | 484 | 4 |
1438189 | 1438189 | 2021-06-20 | Putnam | Missouri | 29171 | 484 | 4 |
1434942 | 1434942 | 2021-06-19 | Putnam | Missouri | 29171 | 484 | 4 |
1431695 | 1431695 | 2021-06-18 | Putnam | Missouri | 29171 | 484 | 4 |
1428450 | 1428450 | 2021-06-17 | Putnam | Missouri | 29171 | 484 | 4 |
1425205 | 1425205 | 2021-06-16 | Putnam | Missouri | 29171 | 483 | 4 |
1421957 | 1421957 | 2021-06-15 | Putnam | Missouri | 29171 | 483 | 4 |
1418712 | 1418712 | 2021-06-14 | Putnam | Missouri | 29171 | 483 | 4 |
1415467 | 1415467 | 2021-06-13 | Putnam | Missouri | 29171 | 483 | 4 |
1412221 | 1412221 | 2021-06-12 | Putnam | Missouri | 29171 | 483 | 4 |
1408976 | 1408976 | 2021-06-11 | Putnam | Missouri | 29171 | 483 | 4 |
1405731 | 1405731 | 2021-06-10 | Putnam | Missouri | 29171 | 481 | 4 |
1402485 | 1402485 | 2021-06-09 | Putnam | Missouri | 29171 | 481 | 4 |
1399240 | 1399240 | 2021-06-08 | Putnam | Missouri | 29171 | 468 | 4 |
1395994 | 1395994 | 2021-06-07 | Putnam | Missouri | 29171 | 465 | 4 |
1392748 | 1392748 | 2021-06-06 | Putnam | Missouri | 29171 | 459 | 4 |
1389503 | 1389503 | 2021-06-05 | Putnam | Missouri | 29171 | 459 | 4 |
1386258 | 1386258 | 2021-06-04 | Putnam | Missouri | 29171 | 428 | 4 |
1383013 | 1383013 | 2021-06-03 | Putnam | Missouri | 29171 | 416 | 4 |
1379767 | 1379767 | 2021-06-02 | Putnam | Missouri | 29171 | 412 | 4 |
1376522 | 1376522 | 2021-06-01 | Putnam | Missouri | 29171 | 404 | 4 |
1373276 | 1373276 | 2021-05-31 | Putnam | Missouri | 29171 | 404 | 4 |
1370031 | 1370031 | 2021-05-30 | Putnam | Missouri | 29171 | 404 | 4 |
1366785 | 1366785 | 2021-05-29 | Putnam | Missouri | 29171 | 403 | 4 |
1363539 | 1363539 | 2021-05-28 | Putnam | Missouri | 29171 | 391 | 4 |
1360292 | 1360292 | 2021-05-27 | Putnam | Missouri | 29171 | 385 | 4 |
1357046 | 1357046 | 2021-05-26 | Putnam | Missouri | 29171 | 368 | 4 |
1353800 | 1353800 | 2021-05-25 | Putnam | Missouri | 29171 | 362 | 4 |
1350554 | 1350554 | 2021-05-24 | Putnam | Missouri | 29171 | 358 | 4 |
1347308 | 1347308 | 2021-05-23 | Putnam | Missouri | 29171 | 358 | 4 |
1344060 | 1344060 | 2021-05-22 | Putnam | Missouri | 29171 | 353 | 4 |
1340811 | 1340811 | 2021-05-21 | Putnam | Missouri | 29171 | 335 | 4 |
1337564 | 1337564 | 2021-05-20 | Putnam | Missouri | 29171 | 328 | 4 |
1334317 | 1334317 | 2021-05-19 | Putnam | Missouri | 29171 | 320 | 4 |
1331070 | 1331070 | 2021-05-18 | Putnam | Missouri | 29171 | 320 | 4 |
1327823 | 1327823 | 2021-05-17 | Putnam | Missouri | 29171 | 319 | 4 |
1324577 | 1324577 | 2021-05-16 | Putnam | Missouri | 29171 | 319 | 4 |
1321331 | 1321331 | 2021-05-15 | Putnam | Missouri | 29171 | 318 | 4 |
1318085 | 1318085 | 2021-05-14 | Putnam | Missouri | 29171 | 315 | 4 |
1314837 | 1314837 | 2021-05-13 | Putnam | Missouri | 29171 | 314 | 4 |
1311591 | 1311591 | 2021-05-12 | Putnam | Missouri | 29171 | 304 | 4 |
1308344 | 1308344 | 2021-05-11 | Putnam | Missouri | 29171 | 302 | 4 |
1305098 | 1305098 | 2021-05-10 | Putnam | Missouri | 29171 | 302 | 4 |
1301852 | 1301852 | 2021-05-09 | Putnam | Missouri | 29171 | 302 | 4 |
1298604 | 1298604 | 2021-05-08 | Putnam | Missouri | 29171 | 302 | 4 |
1295358 | 1295358 | 2021-05-07 | Putnam | Missouri | 29171 | 301 | 4 |
1292112 | 1292112 | 2021-05-06 | Putnam | Missouri | 29171 | 300 | 4 |
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);