ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Blount" and state = "Tennessee" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5906 | 5906 | 2020-03-20 | Blount | Tennessee | 47009 | 1 | 0 |
6916 | 6916 | 2020-03-21 | Blount | Tennessee | 47009 | 1 | 0 |
8038 | 8038 | 2020-03-22 | Blount | Tennessee | 47009 | 1 | 0 |
9256 | 9256 | 2020-03-23 | Blount | Tennessee | 47009 | 1 | 0 |
10583 | 10583 | 2020-03-24 | Blount | Tennessee | 47009 | 3 | 0 |
12060 | 12060 | 2020-03-25 | Blount | Tennessee | 47009 | 3 | 0 |
13683 | 13683 | 2020-03-26 | Blount | Tennessee | 47009 | 4 | 0 |
15435 | 15435 | 2020-03-27 | Blount | Tennessee | 47009 | 6 | 0 |
17295 | 17295 | 2020-03-28 | Blount | Tennessee | 47009 | 9 | 0 |
19240 | 19240 | 2020-03-29 | Blount | Tennessee | 47009 | 9 | 0 |
21293 | 21293 | 2020-03-30 | Blount | Tennessee | 47009 | 10 | 0 |
23431 | 23431 | 2020-03-31 | Blount | Tennessee | 47009 | 25 | 0 |
25629 | 25629 | 2020-04-01 | Blount | Tennessee | 47009 | 28 | 0 |
27907 | 27907 | 2020-04-02 | Blount | Tennessee | 47009 | 32 | 0 |
30242 | 30242 | 2020-04-03 | Blount | Tennessee | 47009 | 33 | 0 |
32633 | 32633 | 2020-04-04 | Blount | Tennessee | 47009 | 34 | 0 |
35069 | 35069 | 2020-04-05 | Blount | Tennessee | 47009 | 36 | 1 |
37545 | 37545 | 2020-04-06 | Blount | Tennessee | 47009 | 38 | 2 |
40068 | 40068 | 2020-04-07 | Blount | Tennessee | 47009 | 41 | 2 |
42629 | 42629 | 2020-04-08 | Blount | Tennessee | 47009 | 42 | 2 |
45216 | 45216 | 2020-04-09 | Blount | Tennessee | 47009 | 44 | 2 |
47834 | 47834 | 2020-04-10 | Blount | Tennessee | 47009 | 45 | 3 |
50492 | 50492 | 2020-04-11 | Blount | Tennessee | 47009 | 46 | 3 |
53167 | 53167 | 2020-04-12 | Blount | Tennessee | 47009 | 46 | 3 |
55853 | 55853 | 2020-04-13 | Blount | Tennessee | 47009 | 46 | 3 |
58556 | 58556 | 2020-04-14 | Blount | Tennessee | 47009 | 47 | 3 |
61271 | 61271 | 2020-04-15 | Blount | Tennessee | 47009 | 47 | 3 |
63998 | 63998 | 2020-04-16 | Blount | Tennessee | 47009 | 46 | 3 |
66744 | 66744 | 2020-04-17 | Blount | Tennessee | 47009 | 46 | 3 |
69502 | 69502 | 2020-04-18 | Blount | Tennessee | 47009 | 46 | 3 |
72269 | 72269 | 2020-04-19 | Blount | Tennessee | 47009 | 46 | 3 |
75044 | 75044 | 2020-04-20 | Blount | Tennessee | 47009 | 46 | 3 |
77826 | 77826 | 2020-04-21 | Blount | Tennessee | 47009 | 46 | 3 |
80616 | 80616 | 2020-04-22 | Blount | Tennessee | 47009 | 47 | 3 |
83415 | 83415 | 2020-04-23 | Blount | Tennessee | 47009 | 48 | 3 |
86220 | 86220 | 2020-04-24 | Blount | Tennessee | 47009 | 49 | 3 |
89035 | 89035 | 2020-04-25 | Blount | Tennessee | 47009 | 53 | 3 |
91852 | 91852 | 2020-04-26 | Blount | Tennessee | 47009 | 53 | 3 |
94680 | 94680 | 2020-04-27 | Blount | Tennessee | 47009 | 54 | 3 |
97520 | 97520 | 2020-04-28 | Blount | Tennessee | 47009 | 55 | 3 |
100370 | 100370 | 2020-04-29 | Blount | Tennessee | 47009 | 55 | 3 |
103223 | 103223 | 2020-04-30 | Blount | Tennessee | 47009 | 56 | 3 |
106086 | 106086 | 2020-05-01 | Blount | Tennessee | 47009 | 58 | 3 |
108953 | 108953 | 2020-05-02 | Blount | Tennessee | 47009 | 63 | 3 |
111827 | 111827 | 2020-05-03 | Blount | Tennessee | 47009 | 63 | 3 |
114709 | 114709 | 2020-05-04 | Blount | Tennessee | 47009 | 70 | 3 |
117665 | 117665 | 2020-05-05 | Blount | Tennessee | 47009 | 73 | 3 |
120629 | 120629 | 2020-05-06 | Blount | Tennessee | 47009 | 69 | 3 |
123607 | 123607 | 2020-05-07 | Blount | Tennessee | 47009 | 69 | 3 |
126590 | 126590 | 2020-05-08 | Blount | Tennessee | 47009 | 69 | 3 |
129579 | 129579 | 2020-05-09 | Blount | Tennessee | 47009 | 71 | 3 |
132568 | 132568 | 2020-05-10 | Blount | Tennessee | 47009 | 71 | 3 |
135559 | 135559 | 2020-05-11 | Blount | Tennessee | 47009 | 72 | 3 |
138549 | 138549 | 2020-05-12 | Blount | Tennessee | 47009 | 73 | 3 |
141545 | 141545 | 2020-05-13 | Blount | Tennessee | 47009 | 74 | 3 |
144542 | 144542 | 2020-05-14 | Blount | Tennessee | 47009 | 75 | 3 |
147543 | 147543 | 2020-05-15 | Blount | Tennessee | 47009 | 75 | 3 |
150551 | 150551 | 2020-05-16 | Blount | Tennessee | 47009 | 75 | 3 |
153562 | 153562 | 2020-05-17 | Blount | Tennessee | 47009 | 75 | 3 |
156579 | 156579 | 2020-05-18 | Blount | Tennessee | 47009 | 76 | 3 |
159600 | 159600 | 2020-05-19 | Blount | Tennessee | 47009 | 76 | 3 |
162627 | 162627 | 2020-05-20 | Blount | Tennessee | 47009 | 76 | 3 |
165656 | 165656 | 2020-05-21 | Blount | Tennessee | 47009 | 77 | 3 |
168692 | 168692 | 2020-05-22 | Blount | Tennessee | 47009 | 78 | 3 |
171731 | 171731 | 2020-05-23 | Blount | Tennessee | 47009 | 81 | 3 |
174774 | 174774 | 2020-05-24 | Blount | Tennessee | 47009 | 82 | 3 |
177818 | 177818 | 2020-05-25 | Blount | Tennessee | 47009 | 82 | 3 |
180861 | 180861 | 2020-05-26 | Blount | Tennessee | 47009 | 84 | 3 |
183911 | 183911 | 2020-05-27 | Blount | Tennessee | 47009 | 89 | 3 |
186968 | 186968 | 2020-05-28 | Blount | Tennessee | 47009 | 89 | 3 |
190032 | 190032 | 2020-05-29 | Blount | Tennessee | 47009 | 89 | 3 |
193097 | 193097 | 2020-05-30 | Blount | Tennessee | 47009 | 91 | 3 |
196167 | 196167 | 2020-05-31 | Blount | Tennessee | 47009 | 91 | 3 |
199240 | 199240 | 2020-06-01 | Blount | Tennessee | 47009 | 91 | 3 |
202315 | 202315 | 2020-06-02 | Blount | Tennessee | 47009 | 93 | 3 |
205394 | 205394 | 2020-06-03 | Blount | Tennessee | 47009 | 93 | 3 |
208476 | 208476 | 2020-06-04 | Blount | Tennessee | 47009 | 93 | 3 |
211558 | 211558 | 2020-06-05 | Blount | Tennessee | 47009 | 93 | 3 |
214645 | 214645 | 2020-06-06 | Blount | Tennessee | 47009 | 93 | 3 |
217735 | 217735 | 2020-06-07 | Blount | Tennessee | 47009 | 94 | 3 |
220827 | 220827 | 2020-06-08 | Blount | Tennessee | 47009 | 94 | 3 |
223922 | 223922 | 2020-06-09 | Blount | Tennessee | 47009 | 96 | 3 |
227022 | 227022 | 2020-06-10 | Blount | Tennessee | 47009 | 96 | 3 |
230126 | 230126 | 2020-06-11 | Blount | Tennessee | 47009 | 97 | 3 |
233231 | 233231 | 2020-06-12 | Blount | Tennessee | 47009 | 104 | 3 |
236337 | 236337 | 2020-06-13 | Blount | Tennessee | 47009 | 103 | 3 |
239445 | 239445 | 2020-06-14 | Blount | Tennessee | 47009 | 104 | 3 |
242555 | 242555 | 2020-06-15 | Blount | Tennessee | 47009 | 106 | 3 |
245667 | 245667 | 2020-06-16 | Blount | Tennessee | 47009 | 110 | 3 |
248780 | 248780 | 2020-06-17 | Blount | Tennessee | 47009 | 115 | 3 |
251895 | 251895 | 2020-06-18 | Blount | Tennessee | 47009 | 118 | 3 |
255010 | 255010 | 2020-06-19 | Blount | Tennessee | 47009 | 119 | 3 |
258136 | 258136 | 2020-06-20 | Blount | Tennessee | 47009 | 127 | 3 |
261263 | 261263 | 2020-06-21 | Blount | Tennessee | 47009 | 127 | 3 |
264391 | 264391 | 2020-06-22 | Blount | Tennessee | 47009 | 130 | 3 |
267519 | 267519 | 2020-06-23 | Blount | Tennessee | 47009 | 139 | 3 |
270653 | 270653 | 2020-06-24 | Blount | Tennessee | 47009 | 142 | 3 |
273792 | 273792 | 2020-06-25 | Blount | Tennessee | 47009 | 150 | 3 |
276939 | 276939 | 2020-06-26 | Blount | Tennessee | 47009 | 152 | 3 |
280087 | 280087 | 2020-06-27 | Blount | Tennessee | 47009 | 156 | 3 |
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);