ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 47187 and state = "Tennessee" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
844 | 844 | 2020-03-08 | Williamson | Tennessee | 47187 | 1 | 0 |
973 | 973 | 2020-03-09 | Williamson | Tennessee | 47187 | 2 | 0 |
1131 | 1131 | 2020-03-10 | Williamson | Tennessee | 47187 | 4 | 0 |
1327 | 1327 | 2020-03-11 | Williamson | Tennessee | 47187 | 4 | 0 |
1574 | 1574 | 2020-03-12 | Williamson | Tennessee | 47187 | 8 | 0 |
1878 | 1878 | 2020-03-13 | Williamson | Tennessee | 47187 | 9 | 0 |
2243 | 2243 | 2020-03-14 | Williamson | Tennessee | 47187 | 10 | 0 |
2668 | 2668 | 2020-03-15 | Williamson | Tennessee | 47187 | 14 | 0 |
3135 | 3135 | 2020-03-16 | Williamson | Tennessee | 47187 | 18 | 0 |
3668 | 3668 | 2020-03-17 | Williamson | Tennessee | 47187 | 21 | 0 |
4291 | 4291 | 2020-03-18 | Williamson | Tennessee | 47187 | 24 | 0 |
5041 | 5041 | 2020-03-19 | Williamson | Tennessee | 47187 | 35 | 0 |
5930 | 5930 | 2020-03-20 | Williamson | Tennessee | 47187 | 35 | 0 |
6947 | 6947 | 2020-03-21 | Williamson | Tennessee | 47187 | 47 | 0 |
8077 | 8077 | 2020-03-22 | Williamson | Tennessee | 47187 | 48 | 0 |
9295 | 9295 | 2020-03-23 | Williamson | Tennessee | 47187 | 48 | 0 |
10629 | 10629 | 2020-03-24 | Williamson | Tennessee | 47187 | 64 | 0 |
12109 | 12109 | 2020-03-25 | Williamson | Tennessee | 47187 | 66 | 0 |
13736 | 13736 | 2020-03-26 | Williamson | Tennessee | 47187 | 70 | 0 |
15489 | 15489 | 2020-03-27 | Williamson | Tennessee | 47187 | 91 | 0 |
17356 | 17356 | 2020-03-28 | Williamson | Tennessee | 47187 | 95 | 0 |
19306 | 19306 | 2020-03-29 | Williamson | Tennessee | 47187 | 101 | 0 |
21365 | 21365 | 2020-03-30 | Williamson | Tennessee | 47187 | 111 | 0 |
23504 | 23504 | 2020-03-31 | Williamson | Tennessee | 47187 | 111 | 0 |
25707 | 25707 | 2020-04-01 | Williamson | Tennessee | 47187 | 148 | 2 |
27987 | 27987 | 2020-04-02 | Williamson | Tennessee | 47187 | 199 | 3 |
30322 | 30322 | 2020-04-03 | Williamson | Tennessee | 47187 | 221 | 3 |
32714 | 32714 | 2020-04-04 | Williamson | Tennessee | 47187 | 239 | 2 |
35151 | 35151 | 2020-04-05 | Williamson | Tennessee | 47187 | 258 | 2 |
37627 | 37627 | 2020-04-06 | Williamson | Tennessee | 47187 | 260 | 2 |
40149 | 40149 | 2020-04-07 | Williamson | Tennessee | 47187 | 278 | 3 |
42711 | 42711 | 2020-04-08 | Williamson | Tennessee | 47187 | 287 | 3 |
45299 | 45299 | 2020-04-09 | Williamson | Tennessee | 47187 | 288 | 3 |
47917 | 47917 | 2020-04-10 | Williamson | Tennessee | 47187 | 299 | 4 |
50574 | 50574 | 2020-04-11 | Williamson | Tennessee | 47187 | 312 | 4 |
53249 | 53249 | 2020-04-12 | Williamson | Tennessee | 47187 | 312 | 4 |
55937 | 55937 | 2020-04-13 | Williamson | Tennessee | 47187 | 318 | 4 |
58640 | 58640 | 2020-04-14 | Williamson | Tennessee | 47187 | 322 | 5 |
61356 | 61356 | 2020-04-15 | Williamson | Tennessee | 47187 | 322 | 5 |
64083 | 64083 | 2020-04-16 | Williamson | Tennessee | 47187 | 324 | 5 |
66830 | 66830 | 2020-04-17 | Williamson | Tennessee | 47187 | 336 | 5 |
69589 | 69589 | 2020-04-18 | Williamson | Tennessee | 47187 | 342 | 6 |
72356 | 72356 | 2020-04-19 | Williamson | Tennessee | 47187 | 348 | 6 |
75131 | 75131 | 2020-04-20 | Williamson | Tennessee | 47187 | 358 | 6 |
77913 | 77913 | 2020-04-21 | Williamson | Tennessee | 47187 | 359 | 6 |
80703 | 80703 | 2020-04-22 | Williamson | Tennessee | 47187 | 365 | 6 |
83502 | 83502 | 2020-04-23 | Williamson | Tennessee | 47187 | 369 | 7 |
86307 | 86307 | 2020-04-24 | Williamson | Tennessee | 47187 | 377 | 7 |
89122 | 89122 | 2020-04-25 | Williamson | Tennessee | 47187 | 381 | 7 |
91939 | 91939 | 2020-04-26 | Williamson | Tennessee | 47187 | 397 | 7 |
94767 | 94767 | 2020-04-27 | Williamson | Tennessee | 47187 | 399 | 7 |
97607 | 97607 | 2020-04-28 | Williamson | Tennessee | 47187 | 399 | 8 |
100457 | 100457 | 2020-04-29 | Williamson | Tennessee | 47187 | 408 | 9 |
103310 | 103310 | 2020-04-30 | Williamson | Tennessee | 47187 | 411 | 9 |
106173 | 106173 | 2020-05-01 | Williamson | Tennessee | 47187 | 416 | 9 |
109040 | 109040 | 2020-05-02 | Williamson | Tennessee | 47187 | 419 | 9 |
111914 | 111914 | 2020-05-03 | Williamson | Tennessee | 47187 | 427 | 9 |
114796 | 114796 | 2020-05-04 | Williamson | Tennessee | 47187 | 431 | 9 |
117752 | 117752 | 2020-05-05 | Williamson | Tennessee | 47187 | 439 | 9 |
120716 | 120716 | 2020-05-06 | Williamson | Tennessee | 47187 | 436 | 10 |
123695 | 123695 | 2020-05-07 | Williamson | Tennessee | 47187 | 434 | 10 |
126678 | 126678 | 2020-05-08 | Williamson | Tennessee | 47187 | 441 | 10 |
129667 | 129667 | 2020-05-09 | Williamson | Tennessee | 47187 | 441 | 10 |
132657 | 132657 | 2020-05-10 | Williamson | Tennessee | 47187 | 443 | 10 |
135648 | 135648 | 2020-05-11 | Williamson | Tennessee | 47187 | 445 | 10 |
138638 | 138638 | 2020-05-12 | Williamson | Tennessee | 47187 | 447 | 10 |
141634 | 141634 | 2020-05-13 | Williamson | Tennessee | 47187 | 453 | 10 |
144631 | 144631 | 2020-05-14 | Williamson | Tennessee | 47187 | 456 | 10 |
147632 | 147632 | 2020-05-15 | Williamson | Tennessee | 47187 | 462 | 10 |
150640 | 150640 | 2020-05-16 | Williamson | Tennessee | 47187 | 471 | 10 |
153651 | 153651 | 2020-05-17 | Williamson | Tennessee | 47187 | 471 | 10 |
156668 | 156668 | 2020-05-18 | Williamson | Tennessee | 47187 | 480 | 10 |
159690 | 159690 | 2020-05-19 | Williamson | Tennessee | 47187 | 492 | 10 |
162717 | 162717 | 2020-05-20 | Williamson | Tennessee | 47187 | 492 | 10 |
165746 | 165746 | 2020-05-21 | Williamson | Tennessee | 47187 | 491 | 10 |
168782 | 168782 | 2020-05-22 | Williamson | Tennessee | 47187 | 500 | 10 |
171821 | 171821 | 2020-05-23 | Williamson | Tennessee | 47187 | 503 | 10 |
174864 | 174864 | 2020-05-24 | Williamson | Tennessee | 47187 | 512 | 10 |
177908 | 177908 | 2020-05-25 | Williamson | Tennessee | 47187 | 522 | 10 |
180951 | 180951 | 2020-05-26 | Williamson | Tennessee | 47187 | 527 | 10 |
184001 | 184001 | 2020-05-27 | Williamson | Tennessee | 47187 | 532 | 10 |
187058 | 187058 | 2020-05-28 | Williamson | Tennessee | 47187 | 533 | 10 |
190122 | 190122 | 2020-05-29 | Williamson | Tennessee | 47187 | 542 | 10 |
193187 | 193187 | 2020-05-30 | Williamson | Tennessee | 47187 | 552 | 10 |
196257 | 196257 | 2020-05-31 | Williamson | Tennessee | 47187 | 552 | 10 |
199330 | 199330 | 2020-06-01 | Williamson | Tennessee | 47187 | 552 | 10 |
202405 | 202405 | 2020-06-02 | Williamson | Tennessee | 47187 | 567 | 11 |
205484 | 205484 | 2020-06-03 | Williamson | Tennessee | 47187 | 577 | 11 |
208566 | 208566 | 2020-06-04 | Williamson | Tennessee | 47187 | 589 | 11 |
211648 | 211648 | 2020-06-05 | Williamson | Tennessee | 47187 | 595 | 11 |
214735 | 214735 | 2020-06-06 | Williamson | Tennessee | 47187 | 606 | 11 |
217825 | 217825 | 2020-06-07 | Williamson | Tennessee | 47187 | 621 | 11 |
220917 | 220917 | 2020-06-08 | Williamson | Tennessee | 47187 | 630 | 11 |
224012 | 224012 | 2020-06-09 | Williamson | Tennessee | 47187 | 648 | 11 |
227112 | 227112 | 2020-06-10 | Williamson | Tennessee | 47187 | 654 | 11 |
230216 | 230216 | 2020-06-11 | Williamson | Tennessee | 47187 | 662 | 11 |
233320 | 233320 | 2020-06-12 | Williamson | Tennessee | 47187 | 670 | 12 |
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);