ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 1936 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Tennessee · 18 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1747712 | 1747712 | 2021-09-23 | Lake | Tennessee | 47095 | 1936 | 31 |
1715233 | 1715233 | 2021-09-13 | Meigs | Tennessee | 47121 | 1936 | 24 |
1621049 | 1621049 | 2021-08-15 | Sequatchie | Tennessee | 47153 | 1936 | 30 |
1617801 | 1617801 | 2021-08-14 | Sequatchie | Tennessee | 47153 | 1936 | 30 |
1614553 | 1614553 | 2021-08-13 | Sequatchie | Tennessee | 47153 | 1936 | 30 |
1422943 | 1422943 | 2021-06-15 | Humphreys | Tennessee | 47085 | 1936 | 31 |
1380717 | 1380717 | 2021-06-02 | Cannon | Tennessee | 47015 | 1936 | 32 |
1377472 | 1377472 | 2021-06-01 | Cannon | Tennessee | 47015 | 1936 | 32 |
1374226 | 1374226 | 2021-05-31 | Cannon | Tennessee | 47015 | 1936 | 32 |
1370981 | 1370981 | 2021-05-30 | Cannon | Tennessee | 47015 | 1936 | 32 |
1367735 | 1367735 | 2021-05-29 | Cannon | Tennessee | 47015 | 1936 | 32 |
1364489 | 1364489 | 2021-05-28 | Cannon | Tennessee | 47015 | 1936 | 32 |
802967 | 802967 | 2020-12-06 | Trousdale | Tennessee | 47169 | 1936 | 12 |
796446 | 796446 | 2020-12-04 | Macon | Tennessee | 47111 | 1936 | 30 |
760722 | 760722 | 2020-11-23 | Franklin | Tennessee | 47051 | 1936 | 32 |
699114 | 699114 | 2020-11-04 | Obion | Tennessee | 47131 | 1936 | 28 |
436818 | 436818 | 2020-08-15 | Putnam | Tennessee | 47141 | 1936 | 20 |
77840 | 77840 | 2020-04-21 | Davidson | Tennessee | 47037 | 1936 | 22 |
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);