ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74,719 rows where state = "Tennessee" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 47187 800
- 47037 797
- 47157 797
- 47163 795
- 47093 793
- 47065 792
- 47089 792
- 47149 792
- 47013 791
- 47155 789
- 47021 787
- 47147 787
- 47165 787
- 47035 786
- 47045 786
- 47125 786
- 47179 786
- 47189 786
- 47001 785
- 47009 785
- 47011 785
- 47043 785
- 47059 785
- 47063 785
- 47119 785
- 47167 785
- 47017 784
- 47029 784
- 47047 784
- 47123 784
- …
county >30
- Williamson 800
- Davidson 797
- Shelby 797
- Sullivan 795
- Knox 793
- Hamilton 792
- Jefferson 792
- Rutherford 792
- Campbell 791
- Sevier 789
- Cheatham 787
- Robertson 787
- Sumner 787
- Cumberland 786
- Dyer 786
- Montgomery 786
- Washington 786
- Wilson 786
- Anderson 785
- Blount 785
- Bradley 785
- Dickson 785
- Greene 785
- Hamblen 785
- Maury 785
- Tipton 785
- Carroll 784
- Cocke 784
- Fayette 784
- Monroe 784
- …
state 1
- Tennessee · 74,719 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
45293 | 45293 | 2020-04-09 | Unknown | Tennessee | 0 | 8 | |
292764 | 292764 | 2020-07-01 | Unknown | Tennessee | 0 | 1 | |
305407 | 305407 | 2020-07-05 | Unknown | Tennessee | 0 | 1 | |
308575 | 308575 | 2020-07-06 | Unknown | Tennessee | 0 | 1 | |
311744 | 311744 | 2020-07-07 | Unknown | Tennessee | 0 | 1 | |
318091 | 318091 | 2020-07-09 | Unknown | Tennessee | 0 | 1 | |
321269 | 321269 | 2020-07-10 | Unknown | Tennessee | 0 | 1 | |
324450 | 324450 | 2020-07-11 | Unknown | Tennessee | 0 | 1 | |
327635 | 327635 | 2020-07-12 | Unknown | Tennessee | 0 | 1 | |
337207 | 337207 | 2020-07-15 | Unknown | Tennessee | 0 | 1 | |
343602 | 343602 | 2020-07-17 | Unknown | Tennessee | 0 | 1 | |
346802 | 346802 | 2020-07-18 | Unknown | Tennessee | 0 | 1 | |
350002 | 350002 | 2020-07-19 | Unknown | Tennessee | 0 | 1 | |
494978 | 494978 | 2020-09-02 | Unknown | Tennessee | 0 | 6 | |
520848 | 520848 | 2020-09-10 | Unknown | Tennessee | 0 | 4 | |
524084 | 524084 | 2020-09-11 | Unknown | Tennessee | 0 | 4 | |
527320 | 527320 | 2020-09-12 | Unknown | Tennessee | 0 | 3 | |
530557 | 530557 | 2020-09-13 | Unknown | Tennessee | 0 | 4 | |
537028 | 537028 | 2020-09-15 | Unknown | Tennessee | 0 | 5 | |
543501 | 543501 | 2020-09-17 | Unknown | Tennessee | 0 | 2 | |
546738 | 546738 | 2020-09-18 | Unknown | Tennessee | 0 | 4 | |
549977 | 549977 | 2020-09-19 | Unknown | Tennessee | 0 | 2 | |
553216 | 553216 | 2020-09-20 | Unknown | Tennessee | 0 | 2 | |
556453 | 556453 | 2020-09-21 | Unknown | Tennessee | 0 | 3 | |
562927 | 562927 | 2020-09-23 | Unknown | Tennessee | 0 | 4 | |
566168 | 566168 | 2020-09-24 | Unknown | Tennessee | 0 | 2 | |
569409 | 569409 | 2020-09-25 | Unknown | Tennessee | 0 | 1 | |
572651 | 572651 | 2020-09-26 | Unknown | Tennessee | 0 | 3 | |
579136 | 579136 | 2020-09-28 | Unknown | Tennessee | 0 | 3 | |
588856 | 588856 | 2020-10-01 | Unknown | Tennessee | 0 | 1 | |
595338 | 595338 | 2020-10-03 | Unknown | Tennessee | 0 | 3 | |
598581 | 598581 | 2020-10-04 | Unknown | Tennessee | 0 | 3 | |
802970 | 802970 | 2020-12-06 | Unknown | Tennessee | 0 | 14 | |
845165 | 845165 | 2020-12-19 | Unknown | Tennessee | 0 | 37 | |
571 | 571 | 2020-03-05 | Williamson | Tennessee | 47187 | 1 | 0 |
640 | 640 | 2020-03-06 | Williamson | Tennessee | 47187 | 1 | 0 |
732 | 732 | 2020-03-07 | Williamson | Tennessee | 47187 | 1 | 0 |
842 | 842 | 2020-03-08 | Davidson | Tennessee | 47037 | 1 | 0 |
843 | 843 | 2020-03-08 | Shelby | Tennessee | 47157 | 1 | 0 |
844 | 844 | 2020-03-08 | Williamson | Tennessee | 47187 | 1 | 0 |
971 | 971 | 2020-03-09 | Davidson | Tennessee | 47037 | 1 | 0 |
972 | 972 | 2020-03-09 | Shelby | Tennessee | 47157 | 1 | 0 |
1128 | 1128 | 2020-03-10 | Davidson | Tennessee | 47037 | 1 | 0 |
1129 | 1129 | 2020-03-10 | Shelby | Tennessee | 47157 | 1 | 0 |
1130 | 1130 | 2020-03-10 | Sullivan | Tennessee | 47163 | 1 | 0 |
1325 | 1325 | 2020-03-11 | Shelby | Tennessee | 47157 | 1 | 0 |
1326 | 1326 | 2020-03-11 | Sullivan | Tennessee | 47163 | 1 | 0 |
1571 | 1571 | 2020-03-12 | Knox | Tennessee | 47093 | 1 | 0 |
1573 | 1573 | 2020-03-12 | Sullivan | Tennessee | 47163 | 1 | 0 |
1872 | 1872 | 2020-03-13 | Hamilton | Tennessee | 47065 | 1 | 0 |
1873 | 1873 | 2020-03-13 | Jefferson | Tennessee | 47089 | 1 | 0 |
1874 | 1874 | 2020-03-13 | Knox | Tennessee | 47093 | 1 | 0 |
1875 | 1875 | 2020-03-13 | Rutherford | Tennessee | 47149 | 1 | 0 |
1877 | 1877 | 2020-03-13 | Sullivan | Tennessee | 47163 | 1 | 0 |
2235 | 2235 | 2020-03-14 | Campbell | Tennessee | 47013 | 1 | 0 |
2237 | 2237 | 2020-03-14 | Hamilton | Tennessee | 47065 | 1 | 0 |
2238 | 2238 | 2020-03-14 | Jefferson | Tennessee | 47089 | 1 | 0 |
2239 | 2239 | 2020-03-14 | Knox | Tennessee | 47093 | 1 | 0 |
2240 | 2240 | 2020-03-14 | Rutherford | Tennessee | 47149 | 1 | 0 |
2242 | 2242 | 2020-03-14 | Sullivan | Tennessee | 47163 | 1 | 0 |
2660 | 2660 | 2020-03-15 | Campbell | Tennessee | 47013 | 1 | 0 |
2662 | 2662 | 2020-03-15 | Hamilton | Tennessee | 47065 | 1 | 0 |
2663 | 2663 | 2020-03-15 | Jefferson | Tennessee | 47089 | 1 | 0 |
2664 | 2664 | 2020-03-15 | Knox | Tennessee | 47093 | 1 | 0 |
2665 | 2665 | 2020-03-15 | Rutherford | Tennessee | 47149 | 1 | 0 |
2667 | 2667 | 2020-03-15 | Sullivan | Tennessee | 47163 | 1 | 0 |
3126 | 3126 | 2020-03-16 | Campbell | Tennessee | 47013 | 1 | 0 |
3128 | 3128 | 2020-03-16 | Hamilton | Tennessee | 47065 | 1 | 0 |
3129 | 3129 | 2020-03-16 | Jefferson | Tennessee | 47089 | 1 | 0 |
3130 | 3130 | 2020-03-16 | Knox | Tennessee | 47093 | 1 | 0 |
3131 | 3131 | 2020-03-16 | Rutherford | Tennessee | 47149 | 1 | 0 |
3132 | 3132 | 2020-03-16 | Sevier | Tennessee | 47155 | 1 | 0 |
3134 | 3134 | 2020-03-16 | Sullivan | Tennessee | 47163 | 1 | 0 |
3659 | 3659 | 2020-03-17 | Campbell | Tennessee | 47013 | 1 | 0 |
3661 | 3661 | 2020-03-17 | Hamilton | Tennessee | 47065 | 1 | 0 |
3662 | 3662 | 2020-03-17 | Jefferson | Tennessee | 47089 | 1 | 0 |
3664 | 3664 | 2020-03-17 | Rutherford | Tennessee | 47149 | 1 | 0 |
3665 | 3665 | 2020-03-17 | Sevier | Tennessee | 47155 | 1 | 0 |
3667 | 3667 | 2020-03-17 | Sullivan | Tennessee | 47163 | 1 | 0 |
4279 | 4279 | 2020-03-18 | Campbell | Tennessee | 47013 | 1 | 0 |
4280 | 4280 | 2020-03-18 | Cheatham | Tennessee | 47021 | 1 | 0 |
4282 | 4282 | 2020-03-18 | Hamilton | Tennessee | 47065 | 1 | 0 |
4283 | 4283 | 2020-03-18 | Jefferson | Tennessee | 47089 | 1 | 0 |
4285 | 4285 | 2020-03-18 | Robertson | Tennessee | 47147 | 1 | 0 |
4286 | 4286 | 2020-03-18 | Rutherford | Tennessee | 47149 | 1 | 0 |
4287 | 4287 | 2020-03-18 | Sevier | Tennessee | 47155 | 1 | 0 |
4289 | 4289 | 2020-03-18 | Sullivan | Tennessee | 47163 | 1 | 0 |
5024 | 5024 | 2020-03-19 | Campbell | Tennessee | 47013 | 1 | 0 |
5025 | 5025 | 2020-03-19 | Cheatham | Tennessee | 47021 | 1 | 0 |
5026 | 5026 | 2020-03-19 | Cumberland | Tennessee | 47035 | 1 | 0 |
5028 | 5028 | 2020-03-19 | Dyer | Tennessee | 47045 | 1 | 0 |
5029 | 5029 | 2020-03-19 | Hamilton | Tennessee | 47065 | 1 | 0 |
5030 | 5030 | 2020-03-19 | Jefferson | Tennessee | 47089 | 1 | 0 |
5032 | 5032 | 2020-03-19 | Montgomery | Tennessee | 47125 | 1 | 0 |
5034 | 5034 | 2020-03-19 | Rutherford | Tennessee | 47149 | 1 | 0 |
5035 | 5035 | 2020-03-19 | Sevier | Tennessee | 47155 | 1 | 0 |
5037 | 5037 | 2020-03-19 | Sullivan | Tennessee | 47163 | 1 | 0 |
5905 | 5905 | 2020-03-20 | Anderson | Tennessee | 47001 | 1 | 0 |
5906 | 5906 | 2020-03-20 | Blount | Tennessee | 47009 | 1 | 0 |
5907 | 5907 | 2020-03-20 | Bradley | Tennessee | 47011 | 1 | 0 |
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);