ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where deaths = 17, fips = 47127 and state = "Tennessee" 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 |
---|---|---|---|---|---|---|---|
1598297 | 1598297 | 2021-08-08 | Moore | Tennessee | 47127 | 1087 | 17 |
1595048 | 1595048 | 2021-08-07 | Moore | Tennessee | 47127 | 1087 | 17 |
1591799 | 1591799 | 2021-08-06 | Moore | Tennessee | 47127 | 1087 | 17 |
1588550 | 1588550 | 2021-08-05 | Moore | Tennessee | 47127 | 1086 | 17 |
1585300 | 1585300 | 2021-08-04 | Moore | Tennessee | 47127 | 1074 | 17 |
1582050 | 1582050 | 2021-08-03 | Moore | Tennessee | 47127 | 1074 | 17 |
1578801 | 1578801 | 2021-08-02 | Moore | Tennessee | 47127 | 1073 | 17 |
1575553 | 1575553 | 2021-08-01 | Moore | Tennessee | 47127 | 1070 | 17 |
1572305 | 1572305 | 2021-07-31 | Moore | Tennessee | 47127 | 1070 | 17 |
1569057 | 1569057 | 2021-07-30 | Moore | Tennessee | 47127 | 1070 | 17 |
1565809 | 1565809 | 2021-07-29 | Moore | Tennessee | 47127 | 1068 | 17 |
1562561 | 1562561 | 2021-07-28 | Moore | Tennessee | 47127 | 1064 | 17 |
1559313 | 1559313 | 2021-07-27 | Moore | Tennessee | 47127 | 1057 | 17 |
1556066 | 1556066 | 2021-07-26 | Moore | Tennessee | 47127 | 1055 | 17 |
1552819 | 1552819 | 2021-07-25 | Moore | Tennessee | 47127 | 1049 | 17 |
1549572 | 1549572 | 2021-07-24 | Moore | Tennessee | 47127 | 1049 | 17 |
1546325 | 1546325 | 2021-07-23 | Moore | Tennessee | 47127 | 1049 | 17 |
1543078 | 1543078 | 2021-07-22 | Moore | Tennessee | 47127 | 1046 | 17 |
1539830 | 1539830 | 2021-07-21 | Moore | Tennessee | 47127 | 1041 | 17 |
1536583 | 1536583 | 2021-07-20 | Moore | Tennessee | 47127 | 1036 | 17 |
1533335 | 1533335 | 2021-07-19 | Moore | Tennessee | 47127 | 1037 | 17 |
1530088 | 1530088 | 2021-07-18 | Moore | Tennessee | 47127 | 1036 | 17 |
1526841 | 1526841 | 2021-07-17 | Moore | Tennessee | 47127 | 1036 | 17 |
1523594 | 1523594 | 2021-07-16 | Moore | Tennessee | 47127 | 1036 | 17 |
1520346 | 1520346 | 2021-07-15 | Moore | Tennessee | 47127 | 1035 | 17 |
1517098 | 1517098 | 2021-07-14 | Moore | Tennessee | 47127 | 1035 | 17 |
1513851 | 1513851 | 2021-07-13 | Moore | Tennessee | 47127 | 1033 | 17 |
1510605 | 1510605 | 2021-07-12 | Moore | Tennessee | 47127 | 1032 | 17 |
1507358 | 1507358 | 2021-07-11 | Moore | Tennessee | 47127 | 1033 | 17 |
1504112 | 1504112 | 2021-07-10 | Moore | Tennessee | 47127 | 1033 | 17 |
1500866 | 1500866 | 2021-07-09 | Moore | Tennessee | 47127 | 1033 | 17 |
1497620 | 1497620 | 2021-07-08 | Moore | Tennessee | 47127 | 1033 | 17 |
1494373 | 1494373 | 2021-07-07 | Moore | Tennessee | 47127 | 1033 | 17 |
1491126 | 1491126 | 2021-07-06 | Moore | Tennessee | 47127 | 1033 | 17 |
1487879 | 1487879 | 2021-07-05 | Moore | Tennessee | 47127 | 1033 | 17 |
1484632 | 1484632 | 2021-07-04 | Moore | Tennessee | 47127 | 1033 | 17 |
1481386 | 1481386 | 2021-07-03 | Moore | Tennessee | 47127 | 1033 | 17 |
1478139 | 1478139 | 2021-07-02 | Moore | Tennessee | 47127 | 1033 | 17 |
1474893 | 1474893 | 2021-07-01 | Moore | Tennessee | 47127 | 1033 | 17 |
1471647 | 1471647 | 2021-06-30 | Moore | Tennessee | 47127 | 1032 | 17 |
1468402 | 1468402 | 2021-06-29 | Moore | Tennessee | 47127 | 1032 | 17 |
1465157 | 1465157 | 2021-06-28 | Moore | Tennessee | 47127 | 1032 | 17 |
1461912 | 1461912 | 2021-06-27 | Moore | Tennessee | 47127 | 1034 | 17 |
1458667 | 1458667 | 2021-06-26 | Moore | Tennessee | 47127 | 1034 | 17 |
1455422 | 1455422 | 2021-06-25 | Moore | Tennessee | 47127 | 1034 | 17 |
1452177 | 1452177 | 2021-06-24 | Moore | Tennessee | 47127 | 1034 | 17 |
1448931 | 1448931 | 2021-06-23 | Moore | Tennessee | 47127 | 1034 | 17 |
1445686 | 1445686 | 2021-06-22 | Moore | Tennessee | 47127 | 1034 | 17 |
1442441 | 1442441 | 2021-06-21 | Moore | Tennessee | 47127 | 1034 | 17 |
1439196 | 1439196 | 2021-06-20 | Moore | Tennessee | 47127 | 1034 | 17 |
1435949 | 1435949 | 2021-06-19 | Moore | Tennessee | 47127 | 1034 | 17 |
1432702 | 1432702 | 2021-06-18 | Moore | Tennessee | 47127 | 1034 | 17 |
1429456 | 1429456 | 2021-06-17 | Moore | Tennessee | 47127 | 1034 | 17 |
1426211 | 1426211 | 2021-06-16 | Moore | Tennessee | 47127 | 1034 | 17 |
1422964 | 1422964 | 2021-06-15 | Moore | Tennessee | 47127 | 1034 | 17 |
1419718 | 1419718 | 2021-06-14 | Moore | Tennessee | 47127 | 1024 | 17 |
1416473 | 1416473 | 2021-06-13 | Moore | Tennessee | 47127 | 1024 | 17 |
1413227 | 1413227 | 2021-06-12 | Moore | Tennessee | 47127 | 1024 | 17 |
1409982 | 1409982 | 2021-06-11 | Moore | Tennessee | 47127 | 1024 | 17 |
1406737 | 1406737 | 2021-06-10 | Moore | Tennessee | 47127 | 1019 | 17 |
1403491 | 1403491 | 2021-06-09 | Moore | Tennessee | 47127 | 1019 | 17 |
1400246 | 1400246 | 2021-06-08 | Moore | Tennessee | 47127 | 1019 | 17 |
1397001 | 1397001 | 2021-06-07 | Moore | Tennessee | 47127 | 1019 | 17 |
1393754 | 1393754 | 2021-06-06 | Moore | Tennessee | 47127 | 1019 | 17 |
1390509 | 1390509 | 2021-06-05 | Moore | Tennessee | 47127 | 1019 | 17 |
1387264 | 1387264 | 2021-06-04 | Moore | Tennessee | 47127 | 1019 | 17 |
1384019 | 1384019 | 2021-06-03 | Moore | Tennessee | 47127 | 1019 | 17 |
1380773 | 1380773 | 2021-06-02 | Moore | Tennessee | 47127 | 1018 | 17 |
1377528 | 1377528 | 2021-06-01 | Moore | Tennessee | 47127 | 1019 | 17 |
1374282 | 1374282 | 2021-05-31 | Moore | Tennessee | 47127 | 1019 | 17 |
1371037 | 1371037 | 2021-05-30 | Moore | Tennessee | 47127 | 1019 | 17 |
1367791 | 1367791 | 2021-05-29 | Moore | Tennessee | 47127 | 1019 | 17 |
1364545 | 1364545 | 2021-05-28 | Moore | Tennessee | 47127 | 1019 | 17 |
1361299 | 1361299 | 2021-05-27 | Moore | Tennessee | 47127 | 1019 | 17 |
1358053 | 1358053 | 2021-05-26 | Moore | Tennessee | 47127 | 1020 | 17 |
1354807 | 1354807 | 2021-05-25 | Moore | Tennessee | 47127 | 1019 | 17 |
1351561 | 1351561 | 2021-05-24 | Moore | Tennessee | 47127 | 1019 | 17 |
1348315 | 1348315 | 2021-05-23 | Moore | Tennessee | 47127 | 1018 | 17 |
1345067 | 1345067 | 2021-05-22 | Moore | Tennessee | 47127 | 1018 | 17 |
1341819 | 1341819 | 2021-05-21 | Moore | Tennessee | 47127 | 1018 | 17 |
1338571 | 1338571 | 2021-05-20 | Moore | Tennessee | 47127 | 1019 | 17 |
1335324 | 1335324 | 2021-05-19 | Moore | Tennessee | 47127 | 1018 | 17 |
1332077 | 1332077 | 2021-05-18 | Moore | Tennessee | 47127 | 1018 | 17 |
1328830 | 1328830 | 2021-05-17 | Moore | Tennessee | 47127 | 1018 | 17 |
1325584 | 1325584 | 2021-05-16 | Moore | Tennessee | 47127 | 1017 | 17 |
1322338 | 1322338 | 2021-05-15 | Moore | Tennessee | 47127 | 1017 | 17 |
1319092 | 1319092 | 2021-05-14 | Moore | Tennessee | 47127 | 1017 | 17 |
1315844 | 1315844 | 2021-05-13 | Moore | Tennessee | 47127 | 1014 | 17 |
1312598 | 1312598 | 2021-05-12 | Moore | Tennessee | 47127 | 1014 | 17 |
1309351 | 1309351 | 2021-05-11 | Moore | Tennessee | 47127 | 1012 | 17 |
1306105 | 1306105 | 2021-05-10 | Moore | Tennessee | 47127 | 1012 | 17 |
1302859 | 1302859 | 2021-05-09 | Moore | Tennessee | 47127 | 1011 | 17 |
1299612 | 1299612 | 2021-05-08 | Moore | Tennessee | 47127 | 1011 | 17 |
1296365 | 1296365 | 2021-05-07 | Moore | Tennessee | 47127 | 1011 | 17 |
1293119 | 1293119 | 2021-05-06 | Moore | Tennessee | 47127 | 1010 | 17 |
1289873 | 1289873 | 2021-05-05 | Moore | Tennessee | 47127 | 1010 | 17 |
1286627 | 1286627 | 2021-05-04 | Moore | Tennessee | 47127 | 1010 | 17 |
1283381 | 1283381 | 2021-05-03 | Moore | Tennessee | 47127 | 1009 | 17 |
1280134 | 1280134 | 2021-05-02 | Moore | Tennessee | 47127 | 1008 | 17 |
1276887 | 1276887 | 2021-05-01 | Moore | Tennessee | 47127 | 1008 | 17 |
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);