ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 47165 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 254 ✖
- 727 28
- 349 22
- 0 14
- 364 14
- 688 14
- 352 13
- 45 11
- 38 10
- 337 9
- 354 9
- 338 8
- 405 8
- 585 8
- 41 7
- 46 7
- 52 7
- 87 7
- 93 7
- 120 7
- 232 7
- 315 7
- 325 7
- 403 7
- 431 7
- 589 7
- 605 7
- 621 7
- 631 7
- 652 7
- 660 7
- 682 7
- 707 7
- 713 7
- 715 7
- 719 7
- 49 6
- 51 6
- 73 6
- 86 6
- 347 6
- 355 6
- 356 6
- 409 6
- 584 6
- 48 5
- 56 5
- 98 5
- 104 5
- 105 5
- 303 5
- 327 5
- 345 5
- 358 5
- 359 5
- 362 5
- 406 5
- 416 5
- 57 4
- 68 4
- 107 4
- 121 4
- 137 4
- 312 4
- 320 4
- 339 4
- 350 4
- 353 4
- 360 4
- 375 4
- 379 4
- 388 4
- 392 4
- 393 4
- 402 4
- 411 4
- 577 4
- 32 3
- 34 3
- 37 3
- 47 3
- 67 3
- 69 3
- 82 3
- 91 3
- 106 3
- 117 3
- 134 3
- 334 3
- 351 3
- 370 3
- 374 3
- 377 3
- 395 3
- 399 3
- 410 3
- 426 3
- 441 3
- 449 3
- 451 3
- 465 3
- 729 3
- 7 2
- 10 2
- 15 2
- 18 2
- 22 2
- 27 2
- 30 2
- 31 2
- 42 2
- 60 2
- 62 2
- 70 2
- 72 2
- 75 2
- 83 2
- 92 2
- 102 2
- 103 2
- 109 2
- 112 2
- 113 2
- 122 2
- 136 2
- 144 2
- 145 2
- 195 2
- 206 2
- 207 2
- 220 2
- 228 2
- 229 2
- 265 2
- 285 2
- 308 2
- 323 2
- 333 2
- 346 2
- 348 2
- 361 2
- 367 2
- 391 2
- 461 2
- 8 1
- 21 1
- 26 1
- 28 1
- 29 1
- 35 1
- 39 1
- 40 1
- 53 1
- 55 1
- 61 1
- 65 1
- 71 1
- 74 1
- 76 1
- 77 1
- 78 1
- 80 1
- 81 1
- 88 1
- 89 1
- 90 1
- 96 1
- 97 1
- 108 1
- 110 1
- 119 1
- 124 1
- 126 1
- 128 1
- 129 1
- 131 1
- 132 1
- 135 1
- 138 1
- 142 1
- 148 1
- 151 1
- 152 1
- 156 1
- 158 1
- 160 1
- 164 1
- 165 1
- 167 1
- 173 1
- 178 1
- 181 1
- 182 1
- 185 1
- 190 1
- 193 1
- 196 1
- 198 1
- 199 1
- 201 1
- 203 1
- 209 1
- 210 1
- 213 1
- 214 1
- 223 1
- 224 1
- 226 1
- 230 1
- 237 1
- 245 1
- 248 1
- 250 1
- 251 1
- 256 1
- 258 1
- 261 1
- 274 1
- 283 1
- 288 1
- 289 1
- 293 1
- 298 1
- 305 1
- 311 1
- 318 1
- 330 1
- 341 1
- 342 1
- 366 1
- 368 1
- 376 1
- 383 1
- 386 1
- 389 1
- 401 1
- 404 1
- 408 1
- 413 1
- 417 1
- 419 1
- 424 1
- 425 1
- 428 1
- 430 1
- 436 1
- 438 1
- 443 1
- 454 1
- 456 1
- 468 1
- 470 1
- 471 1
- 578 1
- 582 1
state 1
- Tennessee 787
fips 1
- 47165 · 787 ✖
county 1
- Sumner 787
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);