ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where date = "2020-03-21" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
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);