ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Sumner" and state = "Tennessee" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4290 | 4290 | 2020-03-18 | Sumner | Tennessee | 47165 | 2 | 0 |
5038 | 5038 | 2020-03-19 | Sumner | Tennessee | 47165 | 3 | 0 |
5926 | 5926 | 2020-03-20 | Sumner | Tennessee | 47165 | 11 | 0 |
6943 | 6943 | 2020-03-21 | Sumner | Tennessee | 47165 | 11 | 0 |
8073 | 8073 | 2020-03-22 | Sumner | Tennessee | 47165 | 22 | 0 |
9291 | 9291 | 2020-03-23 | Sumner | Tennessee | 47165 | 22 | 0 |
10625 | 10625 | 2020-03-24 | Sumner | Tennessee | 47165 | 34 | 0 |
12104 | 12104 | 2020-03-25 | Sumner | Tennessee | 47165 | 36 | 0 |
13730 | 13730 | 2020-03-26 | Sumner | Tennessee | 47165 | 43 | 0 |
15483 | 15483 | 2020-03-27 | Sumner | Tennessee | 47165 | 58 | 0 |
17347 | 17347 | 2020-03-28 | Sumner | Tennessee | 47165 | 82 | 0 |
19297 | 19297 | 2020-03-29 | Sumner | Tennessee | 47165 | 93 | 0 |
21354 | 21354 | 2020-03-30 | Sumner | Tennessee | 47165 | 164 | 0 |
23493 | 23493 | 2020-03-31 | Sumner | Tennessee | 47165 | 164 | 0 |
25696 | 25696 | 2020-04-01 | Sumner | Tennessee | 47165 | 201 | 7 |
27976 | 27976 | 2020-04-02 | Sumner | Tennessee | 47165 | 268 | 7 |
30311 | 30311 | 2020-04-03 | Sumner | Tennessee | 47165 | 283 | 8 |
32703 | 32703 | 2020-04-04 | Sumner | Tennessee | 47165 | 301 | 10 |
35140 | 35140 | 2020-04-05 | Sumner | Tennessee | 47165 | 321 | 10 |
37616 | 37616 | 2020-04-06 | Sumner | Tennessee | 47165 | 335 | 15 |
40139 | 40139 | 2020-04-07 | Sumner | Tennessee | 47165 | 361 | 15 |
42701 | 42701 | 2020-04-08 | Sumner | Tennessee | 47165 | 376 | 18 |
45288 | 45288 | 2020-04-09 | Sumner | Tennessee | 47165 | 389 | 18 |
47906 | 47906 | 2020-04-10 | Sumner | Tennessee | 47165 | 413 | 21 |
50564 | 50564 | 2020-04-11 | Sumner | Tennessee | 47165 | 435 | 22 |
53239 | 53239 | 2020-04-12 | Sumner | Tennessee | 47165 | 435 | 22 |
55926 | 55926 | 2020-04-13 | Sumner | Tennessee | 47165 | 454 | 26 |
58629 | 58629 | 2020-04-14 | Sumner | Tennessee | 47165 | 466 | 27 |
61345 | 61345 | 2020-04-15 | Sumner | Tennessee | 47165 | 478 | 27 |
64072 | 64072 | 2020-04-16 | Sumner | Tennessee | 47165 | 491 | 28 |
66819 | 66819 | 2020-04-17 | Sumner | Tennessee | 47165 | 497 | 29 |
69578 | 69578 | 2020-04-18 | Sumner | Tennessee | 47165 | 503 | 30 |
72345 | 72345 | 2020-04-19 | Sumner | Tennessee | 47165 | 509 | 30 |
75120 | 75120 | 2020-04-20 | Sumner | Tennessee | 47165 | 518 | 31 |
77902 | 77902 | 2020-04-21 | Sumner | Tennessee | 47165 | 530 | 31 |
80692 | 80692 | 2020-04-22 | Sumner | Tennessee | 47165 | 550 | 32 |
83491 | 83491 | 2020-04-23 | Sumner | Tennessee | 47165 | 556 | 32 |
86296 | 86296 | 2020-04-24 | Sumner | Tennessee | 47165 | 573 | 32 |
89111 | 89111 | 2020-04-25 | Sumner | Tennessee | 47165 | 584 | 34 |
91928 | 91928 | 2020-04-26 | Sumner | Tennessee | 47165 | 593 | 34 |
94756 | 94756 | 2020-04-27 | Sumner | Tennessee | 47165 | 603 | 34 |
97596 | 97596 | 2020-04-28 | Sumner | Tennessee | 47165 | 608 | 35 |
100446 | 100446 | 2020-04-29 | Sumner | Tennessee | 47165 | 619 | 37 |
103299 | 103299 | 2020-04-30 | Sumner | Tennessee | 47165 | 623 | 37 |
106162 | 106162 | 2020-05-01 | Sumner | Tennessee | 47165 | 632 | 37 |
109029 | 109029 | 2020-05-02 | Sumner | Tennessee | 47165 | 640 | 38 |
111903 | 111903 | 2020-05-03 | Sumner | Tennessee | 47165 | 653 | 38 |
114785 | 114785 | 2020-05-04 | Sumner | Tennessee | 47165 | 663 | 38 |
117741 | 117741 | 2020-05-05 | Sumner | Tennessee | 47165 | 665 | 38 |
120705 | 120705 | 2020-05-06 | Sumner | Tennessee | 47165 | 671 | 38 |
123683 | 123683 | 2020-05-07 | Sumner | Tennessee | 47165 | 672 | 38 |
126666 | 126666 | 2020-05-08 | Sumner | Tennessee | 47165 | 683 | 38 |
129655 | 129655 | 2020-05-09 | Sumner | Tennessee | 47165 | 693 | 38 |
132645 | 132645 | 2020-05-10 | Sumner | Tennessee | 47165 | 698 | 38 |
135636 | 135636 | 2020-05-11 | Sumner | Tennessee | 47165 | 699 | 38 |
138626 | 138626 | 2020-05-12 | Sumner | Tennessee | 47165 | 708 | 39 |
141622 | 141622 | 2020-05-13 | Sumner | Tennessee | 47165 | 714 | 40 |
144619 | 144619 | 2020-05-14 | Sumner | Tennessee | 47165 | 720 | 41 |
147620 | 147620 | 2020-05-15 | Sumner | Tennessee | 47165 | 724 | 41 |
150628 | 150628 | 2020-05-16 | Sumner | Tennessee | 47165 | 737 | 41 |
153639 | 153639 | 2020-05-17 | Sumner | Tennessee | 47165 | 739 | 41 |
156656 | 156656 | 2020-05-18 | Sumner | Tennessee | 47165 | 749 | 41 |
159678 | 159678 | 2020-05-19 | Sumner | Tennessee | 47165 | 768 | 41 |
162705 | 162705 | 2020-05-20 | Sumner | Tennessee | 47165 | 768 | 41 |
165734 | 165734 | 2020-05-21 | Sumner | Tennessee | 47165 | 778 | 42 |
168770 | 168770 | 2020-05-22 | Sumner | Tennessee | 47165 | 792 | 42 |
171809 | 171809 | 2020-05-23 | Sumner | Tennessee | 47165 | 809 | 45 |
174852 | 174852 | 2020-05-24 | Sumner | Tennessee | 47165 | 811 | 45 |
177896 | 177896 | 2020-05-25 | Sumner | Tennessee | 47165 | 827 | 45 |
180939 | 180939 | 2020-05-26 | Sumner | Tennessee | 47165 | 838 | 45 |
183989 | 183989 | 2020-05-27 | Sumner | Tennessee | 47165 | 843 | 45 |
187046 | 187046 | 2020-05-28 | Sumner | Tennessee | 47165 | 852 | 45 |
190110 | 190110 | 2020-05-29 | Sumner | Tennessee | 47165 | 858 | 45 |
193175 | 193175 | 2020-05-30 | Sumner | Tennessee | 47165 | 881 | 45 |
196245 | 196245 | 2020-05-31 | Sumner | Tennessee | 47165 | 881 | 45 |
199318 | 199318 | 2020-06-01 | Sumner | Tennessee | 47165 | 881 | 45 |
202393 | 202393 | 2020-06-02 | Sumner | Tennessee | 47165 | 913 | 45 |
205472 | 205472 | 2020-06-03 | Sumner | Tennessee | 47165 | 931 | 46 |
208554 | 208554 | 2020-06-04 | Sumner | Tennessee | 47165 | 938 | 46 |
211636 | 211636 | 2020-06-05 | Sumner | Tennessee | 47165 | 951 | 46 |
214723 | 214723 | 2020-06-06 | Sumner | Tennessee | 47165 | 967 | 46 |
217813 | 217813 | 2020-06-07 | Sumner | Tennessee | 47165 | 975 | 46 |
220905 | 220905 | 2020-06-08 | Sumner | Tennessee | 47165 | 987 | 46 |
224000 | 224000 | 2020-06-09 | Sumner | Tennessee | 47165 | 1011 | 46 |
227100 | 227100 | 2020-06-10 | Sumner | Tennessee | 47165 | 1033 | 47 |
230204 | 230204 | 2020-06-11 | Sumner | Tennessee | 47165 | 1049 | 47 |
233309 | 233309 | 2020-06-12 | Sumner | Tennessee | 47165 | 1059 | 47 |
236415 | 236415 | 2020-06-13 | Sumner | Tennessee | 47165 | 1075 | 48 |
239523 | 239523 | 2020-06-14 | Sumner | Tennessee | 47165 | 1088 | 48 |
242633 | 242633 | 2020-06-15 | Sumner | Tennessee | 47165 | 1105 | 48 |
245745 | 245745 | 2020-06-16 | Sumner | Tennessee | 47165 | 1112 | 48 |
248858 | 248858 | 2020-06-17 | Sumner | Tennessee | 47165 | 1119 | 48 |
251973 | 251973 | 2020-06-18 | Sumner | Tennessee | 47165 | 1130 | 49 |
255088 | 255088 | 2020-06-19 | Sumner | Tennessee | 47165 | 1155 | 49 |
258214 | 258214 | 2020-06-20 | Sumner | Tennessee | 47165 | 1165 | 49 |
261341 | 261341 | 2020-06-21 | Sumner | Tennessee | 47165 | 1181 | 49 |
264469 | 264469 | 2020-06-22 | Sumner | Tennessee | 47165 | 1196 | 49 |
267597 | 267597 | 2020-06-23 | Sumner | Tennessee | 47165 | 1212 | 49 |
270731 | 270731 | 2020-06-24 | Sumner | Tennessee | 47165 | 1231 | 51 |
273870 | 273870 | 2020-06-25 | Sumner | Tennessee | 47165 | 1260 | 51 |
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);