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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 563 ✖
- 39506 8
- 41555 7
- 44490 7
- 47376 7
- 49665 7
- 51397 7
- 52168 7
- 52623 7
- 52831 7
- 52955 7
- 53026 7
- 53057 7
- 53087 7
- 53118 7
- 53161 7
- 53214 7
- 53296 7
- 53376 7
- 24305 5
- 35025 5
- 22594 4
- 24449 4
- 24553 4
- 30035 4
- 34088 4
- 34283 4
- 34483 4
- 36648 4
- 38033 4
- 881 3
- 21786 3
- 22074 3
- 22370 3
- 22909 3
- 23155 3
- 23628 3
- 23831 3
- 24012 3
- 24135 3
- 24233 3
- 24324 3
- 24496 3
- 24511 3
- 24687 3
- 24864 3
- 25096 3
- 25399 3
- 25922 3
- 26688 3
- 27666 3
- 28853 3
- 31121 3
- 32184 3
- 32739 3
- 33172 3
- 33528 3
- 33846 3
- 34671 3
- 34924 3
- 35420 3
- 35748 3
- 36119 3
- 53504 3
- 11 2
- 22 2
- 164 2
- 435 2
- 768 2
- 1318 2
- 15789 2
- 24345 2
- 28357 2
- 32399 2
- 34606 2
- 35649 2
- 2 1
- 3 1
- 34 1
- 36 1
- 43 1
- 58 1
- 82 1
- 93 1
- 201 1
- 268 1
- 283 1
- 301 1
- 321 1
- 335 1
- 361 1
- 376 1
- 389 1
- 413 1
- 454 1
- 466 1
- 478 1
- 491 1
- 497 1
- 503 1
- 509 1
- 518 1
- 530 1
- 550 1
- 556 1
- 573 1
- 584 1
- 593 1
- 603 1
- 608 1
- 619 1
- 623 1
- 632 1
- 640 1
- 653 1
- 663 1
- 665 1
- 671 1
- 672 1
- 683 1
- 693 1
- 698 1
- 699 1
- 708 1
- 714 1
- 720 1
- 724 1
- 737 1
- 739 1
- 749 1
- 778 1
- 792 1
- 809 1
- 811 1
- 827 1
- 838 1
- 843 1
- 852 1
- 858 1
- 913 1
- 931 1
- 938 1
- 951 1
- 967 1
- 975 1
- 987 1
- 1011 1
- 1033 1
- 1049 1
- 1059 1
- 1075 1
- 1088 1
- 1105 1
- 1112 1
- 1119 1
- 1130 1
- 1155 1
- 1165 1
- 1181 1
- 1196 1
- 1212 1
- 1231 1
- 1260 1
- 1296 1
- 1371 1
- 1417 1
- 1469 1
- 1507 1
- 1559 1
- 1593 1
- 1610 1
- 1636 1
- 1670 1
- 1727 1
- 1802 1
- 1874 1
- 1897 1
- 1945 1
- 2040 1
- 2103 1
- 2189 1
- 2264 1
- 2344 1
- 2426 1
- 2458 1
- 2505 1
- 2571 1
- 2670 1
- 2721 1
- 2790 1
- 2833 1
- 2889 1
- 2925 1
- 2962 1
- 3014 1
- 3044 1
- 3106 1
- 3136 1
- 3160 1
- 3178 1
- 3219 1
- 3264 1
- 3316 1
- 3365 1
- 3404 1
- 3433 1
- 3449 1
- 3473 1
- 3501 1
- 3538 1
- 3581 1
- 3622 1
- 3636 1
- 3649 1
- 3665 1
- 3730 1
- 3781 1
- 3808 1
- 3846 1
- 3871 1
- 3889 1
- 3903 1
- 3939 1
- 3972 1
- 4007 1
- 4051 1
- 4065 1
- 4094 1
- 4117 1
- 4136 1
- 4192 1
- 4220 1
- 4246 1
- 4263 1
- 4282 1
- 4300 1
- 4318 1
- 4384 1
- 4433 1
- 4458 1
- 4469 1
- 4532 1
- 4548 1
- 4568 1
- 4585 1
- 4621 1
- 4629 1
- 4686 1
- 4705 1
- 4721 1
- 4750 1
- 4758 1
- 4794 1
- 4819 1
- 4865 1
- 4883 1
- 4895 1
- 4922 1
- 4968 1
- 4989 1
- 5016 1
- 5044 1
- 5088 1
- 5109 1
- 5138 1
- 5169 1
- 5200 1
- 5222 1
- 5243 1
- 5311 1
- 5338 1
- 5360 1
- 5428 1
- 5442 1
- 5486 1
- 5551 1
- 5636 1
- 5664 1
- 5715 1
- 5788 1
- 5900 1
- 5948 1
- 6114 1
- 6184 1
- 6230 1
- 6305 1
- 6371 1
- 6439 1
- 6459 1
- 6500 1
- 6598 1
- 6639 1
- 6723 1
- 6770 1
- 6796 1
- 6922 1
- 7025 1
- 7168 1
- 7273 1
- 7356 1
- 7480 1
- 7638 1
- 7776 1
- 7995 1
- 8211 1
- 8312 1
- 8422 1
- 8529 1
- 8696 1
- 8833 1
- 9016 1
- 9141 1
- 9163 1
- 9248 1
- 9412 1
- 9573 1
- 9744 1
- 9817 1
- 10123 1
- 10255 1
- 10404 1
- 10566 1
- 10700 1
- 10851 1
- 10928 1
- 11148 1
- 11380 1
- 11558 1
- 11785 1
- 11986 1
- 12156 1
- 12456 1
- 12762 1
- 12925 1
- 13216 1
- 13383 1
- 13676 1
- 13866 1
- 14081 1
- 14339 1
- 14458 1
- 14616 1
- 14760 1
- 14953 1
- 15076 1
- 15132 1
- 15219 1
- 15380 1
- 15645 1
- 16241 1
- 16292 1
- 16390 1
- 16501 1
- 16714 1
- 16992 1
- 17105 1
- 17243 1
- 17405 1
- 17473 1
- 17584 1
- 17710 1
- 17850 1
- 17980 1
- 18067 1
- 18205 1
- 18262 1
- 18322 1
- 18454 1
- 18551 1
- 18644 1
- 18744 1
- 18819 1
- 18862 1
- 18891 1
- 18985 1
- 19035 1
- 19144 1
- 19210 1
- 19283 1
- 19339 1
- 19414 1
- 19478 1
- 19575 1
- 19641 1
- 19736 1
- 19803 1
- 19852 1
- 19892 1
- 19975 1
- 20234 1
- 20727 1
- 20789 1
- 20843 1
- 20884 1
- 20912 1
- 20939 1
- 20964 1
- 20994 1
- 21030 1
- 21064 1
- 21081 1
- 21120 1
- 21166 1
- 21216 1
- 21260 1
- 21290 1
- 21329 1
- 21354 1
- 21383 1
- 21415 1
- 21448 1
- 21498 1
- 21542 1
- 21597 1
- 21607 1
- 21638 1
- 21668 1
- 21718 1
- 21884 1
- 21933 1
- 21987 1
- 22008 1
- 22166 1
- 22207 1
- 22277 1
- 22331 1
- 22470 1
- 22505 1
- 22555 1
- 22742 1
- 22768 1
- 22831 1
- 22880 1
- 22983 1
- 23020 1
- 23064 1
- 23112 1
- 23492 1
- 23515 1
- 23549 1
- 23591 1
- 23692 1
- 23754 1
- 23790 1
- 23814 1
- 23910 1
- 23921 1
- 23951 1
- 23978 1
- 24052 1
- 24069 1
- 24100 1
- 24122 1
- 24170 1
- 24188 1
- 24207 1
- 24226 1
- 24257 1
- 24271 1
- 24290 1
- 24310 1
- 24312 1
- 24318 1
- 24338 1
- 24341 1
- 24480 1
- 24487 1
- 24490 1
- 24504 1
- 24505 1
- 24510 1
- 24512 1
- 24518 1
- 24521 1
- 24527 1
- 24536 1
- 24610 1
- 24637 1
- 24657 1
- 24742 1
- 24771 1
- 24810 1
- 24832 1
- 24940 1
- 24971 1
- 25015 1
- 25054 1
- 25183 1
- 25235 1
- 25292 1
- 25348 1
- 25579 1
- 25647 1
- 25751 1
- 25814 1
- 26151 1
- 26234 1
- 26379 1
- 26562 1
- 27032 1
- 27137 1
- 27283 1
- 27498 1
- 28216 1
- 28653 1
- 29350 1
- 29584 1
- 29801 1
- 29854 1
- 30827 1
- 30897 1
- 31021 1
- 31688 1
- 31788 1
- 31992 1
- 32103 1
- 32544 1
- 32636 1
- 32898 1
- 32944 1
- 33027 1
- 33100 1
- 33318 1
- 33342 1
- 33392 1
- 33446 1
- 33636 1
- 33669 1
- 33735 1
- 33802 1
- 33940 1
- 33979 1
- 34034 1
- 34051 1
- 34189 1
- 34223 1
- 34256 1
- 34365 1
- 34418 1
- 34452 1
- 34567 1
- 34747 1
- 34776 1
- 34828 1
- 34885 1
- 34988 1
- 35009 1
- 35193 1
- 35244 1
- 35301 1
- 35362 1
- 35537 1
- 35580 1
- 35847 1
- 35896 1
- 35980 1
- 36057 1
- 36316 1
- 36389 1
- 36489 1
- 37052 1
- 37271 1
- 37585 1
- 39307 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);