ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 47093 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 |
---|---|---|---|---|---|---|---|
1571 | 1571 | 2020-03-12 | Knox | Tennessee | 47093 | 1 | 0 |
1874 | 1874 | 2020-03-13 | Knox | Tennessee | 47093 | 1 | 0 |
2239 | 2239 | 2020-03-14 | Knox | Tennessee | 47093 | 1 | 0 |
2664 | 2664 | 2020-03-15 | Knox | Tennessee | 47093 | 1 | 0 |
3130 | 3130 | 2020-03-16 | Knox | Tennessee | 47093 | 1 | 0 |
3663 | 3663 | 2020-03-17 | Knox | Tennessee | 47093 | 2 | 0 |
4284 | 4284 | 2020-03-18 | Knox | Tennessee | 47093 | 2 | 0 |
5031 | 5031 | 2020-03-19 | Knox | Tennessee | 47093 | 2 | 0 |
5918 | 5918 | 2020-03-20 | Knox | Tennessee | 47093 | 3 | 0 |
6931 | 6931 | 2020-03-21 | Knox | Tennessee | 47093 | 4 | 0 |
8057 | 8057 | 2020-03-22 | Knox | Tennessee | 47093 | 5 | 0 |
9275 | 9275 | 2020-03-23 | Knox | Tennessee | 47093 | 5 | 0 |
10606 | 10606 | 2020-03-24 | Knox | Tennessee | 47093 | 15 | 0 |
12084 | 12084 | 2020-03-25 | Knox | Tennessee | 47093 | 20 | 0 |
13708 | 13708 | 2020-03-26 | Knox | Tennessee | 47093 | 26 | 0 |
15460 | 15460 | 2020-03-27 | Knox | Tennessee | 47093 | 31 | 0 |
17323 | 17323 | 2020-03-28 | Knox | Tennessee | 47093 | 33 | 0 |
19271 | 19271 | 2020-03-29 | Knox | Tennessee | 47093 | 38 | 0 |
21326 | 21326 | 2020-03-30 | Knox | Tennessee | 47093 | 52 | 0 |
23465 | 23465 | 2020-03-31 | Knox | Tennessee | 47093 | 66 | 1 |
25666 | 25666 | 2020-04-01 | Knox | Tennessee | 47093 | 78 | 1 |
27945 | 27945 | 2020-04-02 | Knox | Tennessee | 47093 | 92 | 1 |
30280 | 30280 | 2020-04-03 | Knox | Tennessee | 47093 | 98 | 1 |
32671 | 32671 | 2020-04-04 | Knox | Tennessee | 47093 | 99 | 1 |
35108 | 35108 | 2020-04-05 | Knox | Tennessee | 47093 | 115 | 1 |
37584 | 37584 | 2020-04-06 | Knox | Tennessee | 47093 | 119 | 3 |
40107 | 40107 | 2020-04-07 | Knox | Tennessee | 47093 | 143 | 3 |
42669 | 42669 | 2020-04-08 | Knox | Tennessee | 47093 | 148 | 3 |
45256 | 45256 | 2020-04-09 | Knox | Tennessee | 47093 | 157 | 4 |
47874 | 47874 | 2020-04-10 | Knox | Tennessee | 47093 | 164 | 4 |
50532 | 50532 | 2020-04-11 | Knox | Tennessee | 47093 | 169 | 4 |
53207 | 53207 | 2020-04-12 | Knox | Tennessee | 47093 | 169 | 4 |
55893 | 55893 | 2020-04-13 | Knox | Tennessee | 47093 | 173 | 4 |
58596 | 58596 | 2020-04-14 | Knox | Tennessee | 47093 | 174 | 4 |
61311 | 61311 | 2020-04-15 | Knox | Tennessee | 47093 | 179 | 4 |
64038 | 64038 | 2020-04-16 | Knox | Tennessee | 47093 | 186 | 4 |
66784 | 66784 | 2020-04-17 | Knox | Tennessee | 47093 | 194 | 4 |
69543 | 69543 | 2020-04-18 | Knox | Tennessee | 47093 | 194 | 4 |
72310 | 72310 | 2020-04-19 | Knox | Tennessee | 47093 | 194 | 4 |
75085 | 75085 | 2020-04-20 | Knox | Tennessee | 47093 | 193 | 4 |
77867 | 77867 | 2020-04-21 | Knox | Tennessee | 47093 | 196 | 4 |
80657 | 80657 | 2020-04-22 | Knox | Tennessee | 47093 | 199 | 4 |
83456 | 83456 | 2020-04-23 | Knox | Tennessee | 47093 | 203 | 4 |
86261 | 86261 | 2020-04-24 | Knox | Tennessee | 47093 | 207 | 4 |
89076 | 89076 | 2020-04-25 | Knox | Tennessee | 47093 | 210 | 4 |
91893 | 91893 | 2020-04-26 | Knox | Tennessee | 47093 | 210 | 4 |
94721 | 94721 | 2020-04-27 | Knox | Tennessee | 47093 | 214 | 4 |
97561 | 97561 | 2020-04-28 | Knox | Tennessee | 47093 | 214 | 5 |
100411 | 100411 | 2020-04-29 | Knox | Tennessee | 47093 | 221 | 5 |
103264 | 103264 | 2020-04-30 | Knox | Tennessee | 47093 | 228 | 5 |
106127 | 106127 | 2020-05-01 | Knox | Tennessee | 47093 | 233 | 5 |
108994 | 108994 | 2020-05-02 | Knox | Tennessee | 47093 | 236 | 5 |
111868 | 111868 | 2020-05-03 | Knox | Tennessee | 47093 | 243 | 5 |
114750 | 114750 | 2020-05-04 | Knox | Tennessee | 47093 | 249 | 5 |
117706 | 117706 | 2020-05-05 | Knox | Tennessee | 47093 | 251 | 5 |
120670 | 120670 | 2020-05-06 | Knox | Tennessee | 47093 | 252 | 5 |
123648 | 123648 | 2020-05-07 | Knox | Tennessee | 47093 | 253 | 5 |
126631 | 126631 | 2020-05-08 | Knox | Tennessee | 47093 | 255 | 5 |
129620 | 129620 | 2020-05-09 | Knox | Tennessee | 47093 | 262 | 5 |
132609 | 132609 | 2020-05-10 | Knox | Tennessee | 47093 | 263 | 5 |
135600 | 135600 | 2020-05-11 | Knox | Tennessee | 47093 | 280 | 5 |
138590 | 138590 | 2020-05-12 | Knox | Tennessee | 47093 | 286 | 5 |
141586 | 141586 | 2020-05-13 | Knox | Tennessee | 47093 | 295 | 5 |
144583 | 144583 | 2020-05-14 | Knox | Tennessee | 47093 | 297 | 5 |
147584 | 147584 | 2020-05-15 | Knox | Tennessee | 47093 | 302 | 5 |
150592 | 150592 | 2020-05-16 | Knox | Tennessee | 47093 | 309 | 5 |
153603 | 153603 | 2020-05-17 | Knox | Tennessee | 47093 | 311 | 5 |
156620 | 156620 | 2020-05-18 | Knox | Tennessee | 47093 | 315 | 5 |
159642 | 159642 | 2020-05-19 | Knox | Tennessee | 47093 | 320 | 5 |
162669 | 162669 | 2020-05-20 | Knox | Tennessee | 47093 | 327 | 5 |
165698 | 165698 | 2020-05-21 | Knox | Tennessee | 47093 | 328 | 5 |
168734 | 168734 | 2020-05-22 | Knox | Tennessee | 47093 | 333 | 5 |
171773 | 171773 | 2020-05-23 | Knox | Tennessee | 47093 | 337 | 5 |
174816 | 174816 | 2020-05-24 | Knox | Tennessee | 47093 | 341 | 5 |
177860 | 177860 | 2020-05-25 | Knox | Tennessee | 47093 | 352 | 5 |
180903 | 180903 | 2020-05-26 | Knox | Tennessee | 47093 | 362 | 5 |
183953 | 183953 | 2020-05-27 | Knox | Tennessee | 47093 | 376 | 5 |
187010 | 187010 | 2020-05-28 | Knox | Tennessee | 47093 | 377 | 5 |
190074 | 190074 | 2020-05-29 | Knox | Tennessee | 47093 | 386 | 5 |
193139 | 193139 | 2020-05-30 | Knox | Tennessee | 47093 | 402 | 5 |
196209 | 196209 | 2020-05-31 | Knox | Tennessee | 47093 | 413 | 5 |
199282 | 199282 | 2020-06-01 | Knox | Tennessee | 47093 | 421 | 5 |
202357 | 202357 | 2020-06-02 | Knox | Tennessee | 47093 | 441 | 5 |
205436 | 205436 | 2020-06-03 | Knox | Tennessee | 47093 | 449 | 5 |
208518 | 208518 | 2020-06-04 | Knox | Tennessee | 47093 | 463 | 5 |
211600 | 211600 | 2020-06-05 | Knox | Tennessee | 47093 | 471 | 5 |
214687 | 214687 | 2020-06-06 | Knox | Tennessee | 47093 | 474 | 5 |
217777 | 217777 | 2020-06-07 | Knox | Tennessee | 47093 | 487 | 5 |
220869 | 220869 | 2020-06-08 | Knox | Tennessee | 47093 | 504 | 5 |
223964 | 223964 | 2020-06-09 | Knox | Tennessee | 47093 | 513 | 5 |
227064 | 227064 | 2020-06-10 | Knox | Tennessee | 47093 | 529 | 5 |
230168 | 230168 | 2020-06-11 | Knox | Tennessee | 47093 | 537 | 5 |
233273 | 233273 | 2020-06-12 | Knox | Tennessee | 47093 | 559 | 5 |
236379 | 236379 | 2020-06-13 | Knox | Tennessee | 47093 | 574 | 5 |
239487 | 239487 | 2020-06-14 | Knox | Tennessee | 47093 | 587 | 5 |
242597 | 242597 | 2020-06-15 | Knox | Tennessee | 47093 | 593 | 5 |
245709 | 245709 | 2020-06-16 | Knox | Tennessee | 47093 | 610 | 5 |
248822 | 248822 | 2020-06-17 | Knox | Tennessee | 47093 | 617 | 5 |
251937 | 251937 | 2020-06-18 | Knox | Tennessee | 47093 | 637 | 5 |
255052 | 255052 | 2020-06-19 | Knox | Tennessee | 47093 | 658 | 5 |
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);