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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 47001 785
- 47009 785
- 47011 785
- 47013 785
- 47021 785
- 47035 785
- 47037 785
- 47043 785
- 47045 785
- 47059 785
- 47063 785
- 47065 785
- 47089 785
- 47093 785
- 47119 785
- 47125 785
- 47147 785
- 47149 785
- 47155 785
- 47157 785
- 47163 785
- 47165 785
- 47167 785
- 47179 785
- 47187 785
- 47189 785
- 47017 784
- 47029 784
- 47047 784
- 47123 784
- …
date (date) >30 ✖
- 2020-05-19 96
- 2020-05-20 96
- 2020-05-21 96
- 2020-05-22 96
- 2020-05-23 96
- 2020-05-24 96
- 2020-05-25 96
- 2020-05-26 96
- 2020-05-27 96
- 2020-05-28 96
- 2020-05-29 96
- 2020-05-30 96
- 2020-05-31 96
- 2020-06-01 96
- 2020-06-02 96
- 2020-06-03 96
- 2020-06-04 96
- 2020-06-05 96
- 2020-06-06 96
- 2020-06-07 96
- 2020-06-08 96
- 2020-06-09 96
- 2020-06-10 96
- 2020-06-11 96
- 2020-06-29 96
- 2020-07-01 96
- 2020-07-05 96
- 2020-07-06 96
- 2020-07-07 96
- 2020-07-08 96
- …
county >30
- Anderson 785
- Blount 785
- Bradley 785
- Campbell 785
- Cheatham 785
- Cumberland 785
- Davidson 785
- Dickson 785
- Dyer 785
- Greene 785
- Hamblen 785
- Hamilton 785
- Jefferson 785
- Knox 785
- Maury 785
- Montgomery 785
- Robertson 785
- Rutherford 785
- Sevier 785
- Shelby 785
- Sullivan 785
- Sumner 785
- Tipton 785
- Washington 785
- Williamson 785
- Wilson 785
- Carroll 784
- Cocke 784
- Fayette 784
- Monroe 784
- …
state 1
- Tennessee · 74,619 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
5908 | 5908 | 2020-03-20 | Campbell | Tennessee | 47013 | 1 | 0 |
5909 | 5909 | 2020-03-20 | Cheatham | Tennessee | 47021 | 2 | 0 |
5910 | 5910 | 2020-03-20 | Cumberland | Tennessee | 47035 | 2 | 0 |
5911 | 5911 | 2020-03-20 | Davidson | Tennessee | 47037 | 110 | 0 |
5912 | 5912 | 2020-03-20 | Dickson | Tennessee | 47043 | 2 | 0 |
5913 | 5913 | 2020-03-20 | Dyer | Tennessee | 47045 | 1 | 0 |
5914 | 5914 | 2020-03-20 | Greene | Tennessee | 47059 | 1 | 0 |
5915 | 5915 | 2020-03-20 | Hamblen | Tennessee | 47063 | 1 | 0 |
5916 | 5916 | 2020-03-20 | Hamilton | Tennessee | 47065 | 5 | 0 |
5917 | 5917 | 2020-03-20 | Jefferson | Tennessee | 47089 | 1 | 0 |
5918 | 5918 | 2020-03-20 | Knox | Tennessee | 47093 | 3 | 0 |
5919 | 5919 | 2020-03-20 | Maury | Tennessee | 47119 | 1 | 0 |
5920 | 5920 | 2020-03-20 | Montgomery | Tennessee | 47125 | 3 | 0 |
5921 | 5921 | 2020-03-20 | Robertson | Tennessee | 47147 | 2 | 0 |
5922 | 5922 | 2020-03-20 | Rutherford | Tennessee | 47149 | 1 | 0 |
5923 | 5923 | 2020-03-20 | Sevier | Tennessee | 47155 | 1 | 0 |
5924 | 5924 | 2020-03-20 | Shelby | Tennessee | 47157 | 42 | 0 |
5925 | 5925 | 2020-03-20 | Sullivan | Tennessee | 47163 | 1 | 0 |
5926 | 5926 | 2020-03-20 | Sumner | Tennessee | 47165 | 11 | 0 |
5927 | 5927 | 2020-03-20 | Tipton | Tennessee | 47167 | 1 | 0 |
5928 | 5928 | 2020-03-20 | Unknown | Tennessee | 2 | 0 | |
5929 | 5929 | 2020-03-20 | Washington | Tennessee | 47179 | 2 | 0 |
5930 | 5930 | 2020-03-20 | Williamson | Tennessee | 47187 | 35 | 0 |
5931 | 5931 | 2020-03-20 | Wilson | Tennessee | 47189 | 3 | 0 |
6915 | 6915 | 2020-03-21 | Anderson | Tennessee | 47001 | 1 | 0 |
6916 | 6916 | 2020-03-21 | Blount | Tennessee | 47009 | 1 | 0 |
6917 | 6917 | 2020-03-21 | Bradley | Tennessee | 47011 | 1 | 0 |
6918 | 6918 | 2020-03-21 | Campbell | Tennessee | 47013 | 2 | 0 |
6919 | 6919 | 2020-03-21 | Carroll | Tennessee | 47017 | 1 | 0 |
6920 | 6920 | 2020-03-21 | Cheatham | Tennessee | 47021 | 2 | 0 |
6921 | 6921 | 2020-03-21 | Cocke | Tennessee | 47029 | 1 | 0 |
6922 | 6922 | 2020-03-21 | Cumberland | Tennessee | 47035 | 2 | 0 |
6923 | 6923 | 2020-03-21 | Davidson | Tennessee | 47037 | 140 | 2 |
6924 | 6924 | 2020-03-21 | Dickson | Tennessee | 47043 | 3 | 0 |
6925 | 6925 | 2020-03-21 | Dyer | Tennessee | 47045 | 2 | 0 |
6926 | 6926 | 2020-03-21 | Fayette | Tennessee | 47047 | 1 | 0 |
6927 | 6927 | 2020-03-21 | Greene | Tennessee | 47059 | 1 | 0 |
6928 | 6928 | 2020-03-21 | Hamblen | Tennessee | 47063 | 2 | 0 |
6929 | 6929 | 2020-03-21 | Hamilton | Tennessee | 47065 | 7 | 0 |
6930 | 6930 | 2020-03-21 | Jefferson | Tennessee | 47089 | 1 | 0 |
6931 | 6931 | 2020-03-21 | Knox | Tennessee | 47093 | 4 | 0 |
6932 | 6932 | 2020-03-21 | Maury | Tennessee | 47119 | 1 | 0 |
6933 | 6933 | 2020-03-21 | Monroe | Tennessee | 47123 | 3 | 0 |
6934 | 6934 | 2020-03-21 | Montgomery | Tennessee | 47125 | 3 | 0 |
6935 | 6935 | 2020-03-21 | Putnam | Tennessee | 47141 | 5 | 0 |
6936 | 6936 | 2020-03-21 | Roane | Tennessee | 47145 | 1 | 0 |
6937 | 6937 | 2020-03-21 | Robertson | Tennessee | 47147 | 2 | 0 |
6938 | 6938 | 2020-03-21 | Rutherford | Tennessee | 47149 | 5 | 0 |
6939 | 6939 | 2020-03-21 | Scott | Tennessee | 47151 | 2 | 0 |
6940 | 6940 | 2020-03-21 | Sevier | Tennessee | 47155 | 2 | 0 |
6941 | 6941 | 2020-03-21 | Shelby | Tennessee | 47157 | 42 | 0 |
6942 | 6942 | 2020-03-21 | Sullivan | Tennessee | 47163 | 1 | 0 |
6943 | 6943 | 2020-03-21 | Sumner | Tennessee | 47165 | 11 | 0 |
6944 | 6944 | 2020-03-21 | Tipton | Tennessee | 47167 | 2 | 0 |
6945 | 6945 | 2020-03-21 | Unknown | Tennessee | 8 | 0 | |
6946 | 6946 | 2020-03-21 | Washington | Tennessee | 47179 | 2 | 0 |
6947 | 6947 | 2020-03-21 | Williamson | Tennessee | 47187 | 47 | 0 |
6948 | 6948 | 2020-03-21 | Wilson | Tennessee | 47189 | 3 | 0 |
8037 | 8037 | 2020-03-22 | Anderson | Tennessee | 47001 | 1 | 0 |
8038 | 8038 | 2020-03-22 | Blount | Tennessee | 47009 | 1 | 0 |
8039 | 8039 | 2020-03-22 | Bradley | Tennessee | 47011 | 2 | 0 |
8040 | 8040 | 2020-03-22 | Campbell | Tennessee | 47013 | 2 | 0 |
8041 | 8041 | 2020-03-22 | Carroll | Tennessee | 47017 | 2 | 0 |
8042 | 8042 | 2020-03-22 | Cheatham | Tennessee | 47021 | 4 | 0 |
8043 | 8043 | 2020-03-22 | Chester | Tennessee | 47023 | 1 | 0 |
8044 | 8044 | 2020-03-22 | Cocke | Tennessee | 47029 | 1 | 0 |
8045 | 8045 | 2020-03-22 | Cumberland | Tennessee | 47035 | 2 | 0 |
8046 | 8046 | 2020-03-22 | Davidson | Tennessee | 47037 | 167 | 2 |
8047 | 8047 | 2020-03-22 | Dickson | Tennessee | 47043 | 4 | 0 |
8048 | 8048 | 2020-03-22 | Dyer | Tennessee | 47045 | 2 | 0 |
8049 | 8049 | 2020-03-22 | Fayette | Tennessee | 47047 | 3 | 0 |
8050 | 8050 | 2020-03-22 | Franklin | Tennessee | 47051 | 1 | 0 |
8051 | 8051 | 2020-03-22 | Gibson | Tennessee | 47053 | 1 | 0 |
8052 | 8052 | 2020-03-22 | Greene | Tennessee | 47059 | 2 | 0 |
8053 | 8053 | 2020-03-22 | Hamblen | Tennessee | 47063 | 2 | 0 |
8054 | 8054 | 2020-03-22 | Hamilton | Tennessee | 47065 | 8 | 0 |
8055 | 8055 | 2020-03-22 | Houston | Tennessee | 47083 | 1 | 0 |
8056 | 8056 | 2020-03-22 | Jefferson | Tennessee | 47089 | 2 | 0 |
8057 | 8057 | 2020-03-22 | Knox | Tennessee | 47093 | 5 | 0 |
8058 | 8058 | 2020-03-22 | Loudon | Tennessee | 47105 | 1 | 0 |
8059 | 8059 | 2020-03-22 | Marion | Tennessee | 47115 | 1 | 0 |
8060 | 8060 | 2020-03-22 | Maury | Tennessee | 47119 | 2 | 0 |
8061 | 8061 | 2020-03-22 | McMinn | Tennessee | 47107 | 1 | 0 |
8062 | 8062 | 2020-03-22 | Monroe | Tennessee | 47123 | 3 | 0 |
8063 | 8063 | 2020-03-22 | Montgomery | Tennessee | 47125 | 3 | 0 |
8064 | 8064 | 2020-03-22 | Perry | Tennessee | 47135 | 1 | 0 |
8065 | 8065 | 2020-03-22 | Putnam | Tennessee | 47141 | 6 | 0 |
8066 | 8066 | 2020-03-22 | Roane | Tennessee | 47145 | 1 | 0 |
8067 | 8067 | 2020-03-22 | Robertson | Tennessee | 47147 | 3 | 0 |
8068 | 8068 | 2020-03-22 | Rutherford | Tennessee | 47149 | 8 | 0 |
8069 | 8069 | 2020-03-22 | Scott | Tennessee | 47151 | 2 | 0 |
8070 | 8070 | 2020-03-22 | Sevier | Tennessee | 47155 | 3 | 0 |
8071 | 8071 | 2020-03-22 | Shelby | Tennessee | 47157 | 66 | 0 |
8072 | 8072 | 2020-03-22 | Sullivan | Tennessee | 47163 | 1 | 0 |
8073 | 8073 | 2020-03-22 | Sumner | Tennessee | 47165 | 22 | 0 |
8074 | 8074 | 2020-03-22 | Tipton | Tennessee | 47167 | 5 | 0 |
8075 | 8075 | 2020-03-22 | Unknown | Tennessee | 28 | 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);