ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 54, fips = 47041 and state = "Tennessee" 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 |
---|---|---|---|---|---|---|---|
1406693 | 1406693 | 2021-06-10 | DeKalb | Tennessee | 47041 | 2828 | 54 |
1403447 | 1403447 | 2021-06-09 | DeKalb | Tennessee | 47041 | 2827 | 54 |
1400202 | 1400202 | 2021-06-08 | DeKalb | Tennessee | 47041 | 2827 | 54 |
1396957 | 1396957 | 2021-06-07 | DeKalb | Tennessee | 47041 | 2826 | 54 |
1393710 | 1393710 | 2021-06-06 | DeKalb | Tennessee | 47041 | 2827 | 54 |
1390465 | 1390465 | 2021-06-05 | DeKalb | Tennessee | 47041 | 2827 | 54 |
1387220 | 1387220 | 2021-06-04 | DeKalb | Tennessee | 47041 | 2827 | 54 |
1383975 | 1383975 | 2021-06-03 | DeKalb | Tennessee | 47041 | 2826 | 54 |
1380729 | 1380729 | 2021-06-02 | DeKalb | Tennessee | 47041 | 2826 | 54 |
1377484 | 1377484 | 2021-06-01 | DeKalb | Tennessee | 47041 | 2824 | 54 |
1374238 | 1374238 | 2021-05-31 | DeKalb | Tennessee | 47041 | 2820 | 54 |
1370993 | 1370993 | 2021-05-30 | DeKalb | Tennessee | 47041 | 2820 | 54 |
1367747 | 1367747 | 2021-05-29 | DeKalb | Tennessee | 47041 | 2820 | 54 |
1364501 | 1364501 | 2021-05-28 | DeKalb | Tennessee | 47041 | 2820 | 54 |
1361255 | 1361255 | 2021-05-27 | DeKalb | Tennessee | 47041 | 2819 | 54 |
1358009 | 1358009 | 2021-05-26 | DeKalb | Tennessee | 47041 | 2817 | 54 |
1354763 | 1354763 | 2021-05-25 | DeKalb | Tennessee | 47041 | 2816 | 54 |
1351517 | 1351517 | 2021-05-24 | DeKalb | Tennessee | 47041 | 2816 | 54 |
1348271 | 1348271 | 2021-05-23 | DeKalb | Tennessee | 47041 | 2815 | 54 |
1345023 | 1345023 | 2021-05-22 | DeKalb | Tennessee | 47041 | 2815 | 54 |
1341775 | 1341775 | 2021-05-21 | DeKalb | Tennessee | 47041 | 2815 | 54 |
1338527 | 1338527 | 2021-05-20 | DeKalb | Tennessee | 47041 | 2813 | 54 |
1335280 | 1335280 | 2021-05-19 | DeKalb | Tennessee | 47041 | 2810 | 54 |
1332033 | 1332033 | 2021-05-18 | DeKalb | Tennessee | 47041 | 2809 | 54 |
1328786 | 1328786 | 2021-05-17 | DeKalb | Tennessee | 47041 | 2807 | 54 |
1325540 | 1325540 | 2021-05-16 | DeKalb | Tennessee | 47041 | 2807 | 54 |
1322294 | 1322294 | 2021-05-15 | DeKalb | Tennessee | 47041 | 2807 | 54 |
1319048 | 1319048 | 2021-05-14 | DeKalb | Tennessee | 47041 | 2807 | 54 |
1315800 | 1315800 | 2021-05-13 | DeKalb | Tennessee | 47041 | 2806 | 54 |
1312554 | 1312554 | 2021-05-12 | DeKalb | Tennessee | 47041 | 2805 | 54 |
1309307 | 1309307 | 2021-05-11 | DeKalb | Tennessee | 47041 | 2805 | 54 |
1306061 | 1306061 | 2021-05-10 | DeKalb | Tennessee | 47041 | 2803 | 54 |
1302815 | 1302815 | 2021-05-09 | DeKalb | Tennessee | 47041 | 2796 | 54 |
1299568 | 1299568 | 2021-05-08 | DeKalb | Tennessee | 47041 | 2796 | 54 |
1296321 | 1296321 | 2021-05-07 | DeKalb | Tennessee | 47041 | 2796 | 54 |
1293075 | 1293075 | 2021-05-06 | DeKalb | Tennessee | 47041 | 2795 | 54 |
1289829 | 1289829 | 2021-05-05 | DeKalb | Tennessee | 47041 | 2794 | 54 |
1286583 | 1286583 | 2021-05-04 | DeKalb | Tennessee | 47041 | 2792 | 54 |
1283337 | 1283337 | 2021-05-03 | DeKalb | Tennessee | 47041 | 2788 | 54 |
1280090 | 1280090 | 2021-05-02 | DeKalb | Tennessee | 47041 | 2787 | 54 |
1276843 | 1276843 | 2021-05-01 | DeKalb | Tennessee | 47041 | 2787 | 54 |
1273596 | 1273596 | 2021-04-30 | DeKalb | Tennessee | 47041 | 2787 | 54 |
1270349 | 1270349 | 2021-04-29 | DeKalb | Tennessee | 47041 | 2780 | 54 |
1267102 | 1267102 | 2021-04-28 | DeKalb | Tennessee | 47041 | 2780 | 54 |
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);