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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 96
- 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
- 47141 784
- 47145 784
- 47151 784
- 47023 783
- 47051 783
- 47053 783
- 47083 783
- 47105 783
- 47107 783
- 47115 783
- 47135 783
- 47025 781
- 47041 781
- 47061 781
- 47071 781
- 47103 781
- 47113 781
- 47133 781
- 47003 780
- 47073 780
- 47101 780
- 47185 780
- 47005 779
- 47015 779
- 47111 779
- 47121 779
- 47171 779
- 47159 778
- 47007 777
- 47019 777
- 47069 777
- 47091 777
- 47129 777
- 47169 777
- 47173 777
- 47183 777
- 47031 776
- 47075 776
- 47079 776
- 47109 776
- 47131 776
- 47049 775
- 47055 775
- 47099 775
- 47117 775
- 47177 775
- 47181 775
- 47085 774
- 47027 773
- 47057 773
- 47081 773
- 47097 773
- 47153 773
- 47087 772
- 47139 772
- 47161 770
- 47077 769
- 47039 766
- 47095 761
- 47175 761
- 47127 759
- 47143 757
- 47033 756
- 47137 734
- 47067 725
- - 711
county 96
- 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
- Putnam 784
- Roane 784
- Scott 784
- Chester 783
- Franklin 783
- Gibson 783
- Houston 783
- Loudon 783
- Marion 783
- McMinn 783
- Perry 783
- Claiborne 781
- DeKalb 781
- Grundy 781
- Hardin 781
- Lincoln 781
- Madison 781
- Overton 781
- Bedford 780
- Hawkins 780
- Lewis 780
- White 780
- Benton 779
- Cannon 779
- Macon 779
- Meigs 779
- Unicoi 779
- Smith 778
- Bledsoe 777
- Carter 777
- Hardeman 777
- Johnson 777
- Morgan 777
- Trousdale 777
- Union 777
- Weakley 777
- Coffee 776
- Haywood 776
- Henry 776
- McNairy 776
- Obion 776
- Fentress 775
- Giles 775
- Lawrence 775
- Marshall 775
- Warren 775
- Wayne 775
- Humphreys 774
- Clay 773
- Grainger 773
- Hickman 773
- Lauderdale 773
- Sequatchie 773
- Jackson 772
- Polk 772
- Stewart 770
- Henderson 769
- Decatur 766
- Lake 761
- Van Buren 761
- Moore 759
- Rhea 757
- Crockett 756
- Pickett 734
- Hancock 725
- Unknown 711
state 1
- Tennessee · 74,719 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
973 | 973 | 2020-03-09 | Williamson | Tennessee | 47187 | 2 | 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 |
1131 | 1131 | 2020-03-10 | Williamson | Tennessee | 47187 | 4 | 0 |
1324 | 1324 | 2020-03-11 | Davidson | Tennessee | 47037 | 2 | 0 |
1325 | 1325 | 2020-03-11 | Shelby | Tennessee | 47157 | 1 | 0 |
1326 | 1326 | 2020-03-11 | Sullivan | Tennessee | 47163 | 1 | 0 |
1327 | 1327 | 2020-03-11 | Williamson | Tennessee | 47187 | 4 | 0 |
1570 | 1570 | 2020-03-12 | Davidson | Tennessee | 47037 | 6 | 0 |
1571 | 1571 | 2020-03-12 | Knox | Tennessee | 47093 | 1 | 0 |
1572 | 1572 | 2020-03-12 | Shelby | Tennessee | 47157 | 2 | 0 |
1573 | 1573 | 2020-03-12 | Sullivan | Tennessee | 47163 | 1 | 0 |
1574 | 1574 | 2020-03-12 | Williamson | Tennessee | 47187 | 8 | 0 |
1871 | 1871 | 2020-03-13 | Davidson | Tennessee | 47037 | 10 | 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 |
1876 | 1876 | 2020-03-13 | Shelby | Tennessee | 47157 | 2 | 0 |
1877 | 1877 | 2020-03-13 | Sullivan | Tennessee | 47163 | 1 | 0 |
1878 | 1878 | 2020-03-13 | Williamson | Tennessee | 47187 | 9 | 0 |
2235 | 2235 | 2020-03-14 | Campbell | Tennessee | 47013 | 1 | 0 |
2236 | 2236 | 2020-03-14 | Davidson | Tennessee | 47037 | 14 | 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 |
2241 | 2241 | 2020-03-14 | Shelby | Tennessee | 47157 | 2 | 0 |
2242 | 2242 | 2020-03-14 | Sullivan | Tennessee | 47163 | 1 | 0 |
2243 | 2243 | 2020-03-14 | Williamson | Tennessee | 47187 | 10 | 0 |
2660 | 2660 | 2020-03-15 | Campbell | Tennessee | 47013 | 1 | 0 |
2661 | 2661 | 2020-03-15 | Davidson | Tennessee | 47037 | 17 | 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 |
2666 | 2666 | 2020-03-15 | Shelby | Tennessee | 47157 | 2 | 0 |
2667 | 2667 | 2020-03-15 | Sullivan | Tennessee | 47163 | 1 | 0 |
2668 | 2668 | 2020-03-15 | Williamson | Tennessee | 47187 | 14 | 0 |
3126 | 3126 | 2020-03-16 | Campbell | Tennessee | 47013 | 1 | 0 |
3127 | 3127 | 2020-03-16 | Davidson | Tennessee | 47037 | 25 | 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 |
3133 | 3133 | 2020-03-16 | Shelby | Tennessee | 47157 | 2 | 0 |
3134 | 3134 | 2020-03-16 | Sullivan | Tennessee | 47163 | 1 | 0 |
3135 | 3135 | 2020-03-16 | Williamson | Tennessee | 47187 | 18 | 0 |
3659 | 3659 | 2020-03-17 | Campbell | Tennessee | 47013 | 1 | 0 |
3660 | 3660 | 2020-03-17 | Davidson | Tennessee | 47037 | 42 | 0 |
3661 | 3661 | 2020-03-17 | Hamilton | Tennessee | 47065 | 1 | 0 |
3662 | 3662 | 2020-03-17 | Jefferson | Tennessee | 47089 | 1 | 0 |
3663 | 3663 | 2020-03-17 | Knox | Tennessee | 47093 | 2 | 0 |
3664 | 3664 | 2020-03-17 | Rutherford | Tennessee | 47149 | 1 | 0 |
3665 | 3665 | 2020-03-17 | Sevier | Tennessee | 47155 | 1 | 0 |
3666 | 3666 | 2020-03-17 | Shelby | Tennessee | 47157 | 2 | 0 |
3667 | 3667 | 2020-03-17 | Sullivan | Tennessee | 47163 | 1 | 0 |
3668 | 3668 | 2020-03-17 | Williamson | Tennessee | 47187 | 21 | 0 |
4279 | 4279 | 2020-03-18 | Campbell | Tennessee | 47013 | 1 | 0 |
4280 | 4280 | 2020-03-18 | Cheatham | Tennessee | 47021 | 1 | 0 |
4281 | 4281 | 2020-03-18 | Davidson | Tennessee | 47037 | 58 | 0 |
4282 | 4282 | 2020-03-18 | Hamilton | Tennessee | 47065 | 1 | 0 |
4283 | 4283 | 2020-03-18 | Jefferson | Tennessee | 47089 | 1 | 0 |
4284 | 4284 | 2020-03-18 | Knox | Tennessee | 47093 | 2 | 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 |
4288 | 4288 | 2020-03-18 | Shelby | Tennessee | 47157 | 4 | 0 |
4289 | 4289 | 2020-03-18 | Sullivan | Tennessee | 47163 | 1 | 0 |
4290 | 4290 | 2020-03-18 | Sumner | Tennessee | 47165 | 2 | 0 |
4291 | 4291 | 2020-03-18 | Williamson | Tennessee | 47187 | 24 | 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 |
5027 | 5027 | 2020-03-19 | Davidson | Tennessee | 47037 | 75 | 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 |
5031 | 5031 | 2020-03-19 | Knox | Tennessee | 47093 | 2 | 0 |
5032 | 5032 | 2020-03-19 | Montgomery | Tennessee | 47125 | 1 | 0 |
5033 | 5033 | 2020-03-19 | Robertson | Tennessee | 47147 | 2 | 0 |
5034 | 5034 | 2020-03-19 | Rutherford | Tennessee | 47149 | 1 | 0 |
5035 | 5035 | 2020-03-19 | Sevier | Tennessee | 47155 | 1 | 0 |
5036 | 5036 | 2020-03-19 | Shelby | Tennessee | 47157 | 22 | 0 |
5037 | 5037 | 2020-03-19 | Sullivan | Tennessee | 47163 | 1 | 0 |
5038 | 5038 | 2020-03-19 | Sumner | Tennessee | 47165 | 3 | 0 |
5039 | 5039 | 2020-03-19 | Unknown | Tennessee | 2 | 0 | |
5040 | 5040 | 2020-03-19 | Washington | Tennessee | 47179 | 2 | 0 |
5041 | 5041 | 2020-03-19 | Williamson | Tennessee | 47187 | 35 | 0 |
5042 | 5042 | 2020-03-19 | Wilson | Tennessee | 47189 | 2 | 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);