ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 172, fips = 47001 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 |
---|---|---|---|---|---|---|---|
1419655 | 1419655 | 2021-06-14 | Anderson | Tennessee | 47001 | 8847 | 172 |
1416410 | 1416410 | 2021-06-13 | Anderson | Tennessee | 47001 | 8847 | 172 |
1413164 | 1413164 | 2021-06-12 | Anderson | Tennessee | 47001 | 8847 | 172 |
1409919 | 1409919 | 2021-06-11 | Anderson | Tennessee | 47001 | 8847 | 172 |
1406674 | 1406674 | 2021-06-10 | Anderson | Tennessee | 47001 | 8842 | 172 |
1403428 | 1403428 | 2021-06-09 | Anderson | Tennessee | 47001 | 8837 | 172 |
1400183 | 1400183 | 2021-06-08 | Anderson | Tennessee | 47001 | 8844 | 172 |
1396938 | 1396938 | 2021-06-07 | Anderson | Tennessee | 47001 | 8846 | 172 |
1383956 | 1383956 | 2021-06-03 | Anderson | Tennessee | 47001 | 8830 | 172 |
1380710 | 1380710 | 2021-06-02 | Anderson | Tennessee | 47001 | 8836 | 172 |
1377465 | 1377465 | 2021-06-01 | Anderson | Tennessee | 47001 | 8838 | 172 |
1374219 | 1374219 | 2021-05-31 | Anderson | Tennessee | 47001 | 8822 | 172 |
1370974 | 1370974 | 2021-05-30 | Anderson | Tennessee | 47001 | 8822 | 172 |
1367728 | 1367728 | 2021-05-29 | Anderson | Tennessee | 47001 | 8822 | 172 |
1364482 | 1364482 | 2021-05-28 | Anderson | Tennessee | 47001 | 8822 | 172 |
1361236 | 1361236 | 2021-05-27 | Anderson | Tennessee | 47001 | 8830 | 172 |
1357990 | 1357990 | 2021-05-26 | Anderson | Tennessee | 47001 | 8823 | 172 |
1354744 | 1354744 | 2021-05-25 | Anderson | Tennessee | 47001 | 8821 | 172 |
1351498 | 1351498 | 2021-05-24 | Anderson | Tennessee | 47001 | 8822 | 172 |
1348252 | 1348252 | 2021-05-23 | Anderson | Tennessee | 47001 | 8817 | 172 |
1345004 | 1345004 | 2021-05-22 | Anderson | Tennessee | 47001 | 8817 | 172 |
1341756 | 1341756 | 2021-05-21 | Anderson | Tennessee | 47001 | 8817 | 172 |
1338508 | 1338508 | 2021-05-20 | Anderson | Tennessee | 47001 | 8815 | 172 |
1335261 | 1335261 | 2021-05-19 | Anderson | Tennessee | 47001 | 8814 | 172 |
1332014 | 1332014 | 2021-05-18 | Anderson | Tennessee | 47001 | 8812 | 172 |
1306042 | 1306042 | 2021-05-10 | Anderson | Tennessee | 47001 | 8768 | 172 |
1302796 | 1302796 | 2021-05-09 | Anderson | Tennessee | 47001 | 8760 | 172 |
1299549 | 1299549 | 2021-05-08 | Anderson | Tennessee | 47001 | 8760 | 172 |
1296302 | 1296302 | 2021-05-07 | Anderson | Tennessee | 47001 | 8760 | 172 |
1293056 | 1293056 | 2021-05-06 | Anderson | Tennessee | 47001 | 8758 | 172 |
1289810 | 1289810 | 2021-05-05 | Anderson | Tennessee | 47001 | 8751 | 172 |
1286564 | 1286564 | 2021-05-04 | Anderson | Tennessee | 47001 | 8750 | 172 |
1283318 | 1283318 | 2021-05-03 | Anderson | Tennessee | 47001 | 8746 | 172 |
1280071 | 1280071 | 2021-05-02 | Anderson | Tennessee | 47001 | 8729 | 172 |
1276824 | 1276824 | 2021-05-01 | Anderson | Tennessee | 47001 | 8729 | 172 |
1273577 | 1273577 | 2021-04-30 | Anderson | Tennessee | 47001 | 8729 | 172 |
1270330 | 1270330 | 2021-04-29 | Anderson | Tennessee | 47001 | 8724 | 172 |
1267083 | 1267083 | 2021-04-28 | Anderson | Tennessee | 47001 | 8718 | 172 |
1263836 | 1263836 | 2021-04-27 | Anderson | Tennessee | 47001 | 8698 | 172 |
1260589 | 1260589 | 2021-04-26 | Anderson | Tennessee | 47001 | 8690 | 172 |
1257342 | 1257342 | 2021-04-25 | Anderson | Tennessee | 47001 | 8674 | 172 |
1254095 | 1254095 | 2021-04-24 | Anderson | Tennessee | 47001 | 8674 | 172 |
1250848 | 1250848 | 2021-04-23 | Anderson | Tennessee | 47001 | 8674 | 172 |
1247601 | 1247601 | 2021-04-22 | Anderson | Tennessee | 47001 | 8657 | 172 |
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);