ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 47089 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 491 ✖
- 26 15
- 28 10
- 1 9
- 6326 8
- 11078 8
- 16 7
- 6281 7
- 11510 7
- 12371 7
- 13394 7
- 14227 7
- 14975 7
- 15302 7
- 15485 7
- 15585 7
- 15650 7
- 15674 7
- 15692 7
- 15706 7
- 15713 7
- 15716 7
- 15724 7
- 15734 7
- 15775 7
- 6 6
- 27 6
- 29 5
- 10121 5
- 5 4
- 18 4
- 5946 4
- 6280 4
- 6333 4
- 8024 4
- 9880 4
- 9952 4
- 9984 4
- 10621 4
- 10836 4
- 4 3
- 14 3
- 17 3
- 5787 3
- 5850 3
- 5917 3
- 6008 3
- 6061 3
- 6106 3
- 6155 3
- 6211 3
- 6244 3
- 6272 3
- 6320 3
- 6322 3
- 6349 3
- 6367 3
- 6412 3
- 6501 3
- 6649 3
- 6848 3
- 7185 3
- 7541 3
- 8540 3
- 9009 3
- 9330 3
- 9513 3
- 9653 3
- 9786 3
- 10032 3
- 10088 3
- 10260 3
- 10369 3
- 10493 3
- 15804 3
- 2 2
- 12 2
- 15 2
- 31 2
- 45 2
- 61 2
- 64 2
- 91 2
- 721 2
- 1066 2
- 3861 2
- 5729 2
- 6287 2
- 6327 2
- 6328 2
- 6329 2
- 6344 2
- 7397 2
- 9133 2
- 10020 2
- 10337 2
- 7 1
- 10 1
- 13 1
- 19 1
- 20 1
- 22 1
- 24 1
- 36 1
- 42 1
- 43 1
- 46 1
- 48 1
- 51 1
- 59 1
- 73 1
- 80 1
- 85 1
- 99 1
- 102 1
- 107 1
- 121 1
- 125 1
- 127 1
- 136 1
- 137 1
- 147 1
- 148 1
- 157 1
- 164 1
- 182 1
- 187 1
- 193 1
- 196 1
- 219 1
- 227 1
- 241 1
- 256 1
- 261 1
- 264 1
- 284 1
- 289 1
- 317 1
- 330 1
- 344 1
- 363 1
- 392 1
- 420 1
- 441 1
- 451 1
- 474 1
- 480 1
- 489 1
- 496 1
- 508 1
- 513 1
- 525 1
- 552 1
- 559 1
- 568 1
- 584 1
- 587 1
- 596 1
- 616 1
- 639 1
- 647 1
- 650 1
- 651 1
- 652 1
- 667 1
- 671 1
- 682 1
- 688 1
- 703 1
- 738 1
- 752 1
- 781 1
- 785 1
- 805 1
- 815 1
- 817 1
- 830 1
- 846 1
- 859 1
- 887 1
- 913 1
- 918 1
- 923 1
- 926 1
- 956 1
- 970 1
- 1002 1
- 1004 1
- 1013 1
- 1015 1
- 1019 1
- 1022 1
- 1046 1
- 1051 1
- 1074 1
- 1085 1
- 1097 1
- 1110 1
- 1119 1
- 1130 1
- 1134 1
- 1144 1
- 1161 1
- 1171 1
- 1189 1
- 1211 1
- 1216 1
- 1243 1
- 1258 1
- 1267 1
- 1286 1
- 1296 1
- 1324 1
- 1338 1
- 1359 1
- 1368 1
- 1380 1
- 1393 1
- 1407 1
- 1425 1
- 1445 1
- 1458 1
- 1466 1
- 1483 1
- 1492 1
- 1529 1
- 1537 1
- 1555 1
- 1564 1
- 1575 1
- 1588 1
- 1604 1
- 1622 1
- 1635 1
- 1636 1
- 1652 1
- 1668 1
- 1669 1
- 1674 1
- 1689 1
- 1715 1
- 1726 1
- 1775 1
- 1776 1
- 1799 1
- 1811 1
- 1855 1
- 1892 1
- 1914 1
- 1966 1
- 1974 1
- 1999 1
- 2033 1
- 2057 1
- 2086 1
- 2126 1
- 2153 1
- 2164 1
- 2190 1
- 2208 1
- 2227 1
- 2269 1
- 2295 1
- 2365 1
- 2412 1
- 2425 1
- 2454 1
- 2495 1
- 2536 1
- 2558 1
- 2618 1
- 2659 1
- 2720 1
- 2757 1
- 2810 1
- 2842 1
- 2907 1
- 2970 1
- 3031 1
- 3115 1
- 3166 1
- 3238 1
- 3273 1
- 3343 1
- 3435 1
- 3460 1
- 3529 1
- 3562 1
- 3645 1
- 3688 1
- 3711 1
- 3736 1
- 3752 1
- 3825 1
- 4021 1
- 4068 1
- 4090 1
- 4133 1
- 4202 1
- 4263 1
- 4301 1
- 4353 1
- 4406 1
- 4436 1
- 4495 1
- 4560 1
- 4609 1
- 4649 1
- 4705 1
- 4749 1
- 4779 1
- 4808 1
- 4838 1
- 4871 1
- 4901 1
- 4933 1
- 4960 1
- 4970 1
- 4994 1
- 5016 1
- 5042 1
- 5081 1
- 5106 1
- 5129 1
- 5141 1
- 5156 1
- 5165 1
- 5180 1
- 5205 1
- 5235 1
- 5246 1
- 5249 1
- 5274 1
- 5283 1
- 5315 1
- 5327 1
- 5373 1
- 5419 1
- 5458 1
- 5488 1
- 5500 1
- 5508 1
- 5516 1
- 5534 1
- 5546 1
- 5557 1
- 5569 1
- 5580 1
- 5605 1
- 5620 1
- 5633 1
- 5642 1
- 5650 1
- 5659 1
- 5677 1
- 5688 1
- 5700 1
- 5717 1
- 5741 1
- 5756 1
- 5774 1
- 5814 1
- 5823 1
- 5832 1
- 5838 1
- 5865 1
- 5879 1
- 5896 1
- 5907 1
- 5930 1
- 5936 1
- 5937 1
- 5971 1
- 5975 1
- 5984 1
- 6000 1
- 6026 1
- 6032 1
- 6038 1
- 6050 1
- 6073 1
- 6082 1
- 6089 1
- 6098 1
- 6122 1
- 6129 1
- 6139 1
- 6150 1
- 6167 1
- 6177 1
- 6186 1
- 6198 1
- 6222 1
- 6226 1
- 6236 1
- 6242 1
- 6249 1
- 6253 1
- 6256 1
- 6267 1
- 6275 1
- 6278 1
- 6283 1
- 6288 1
- 6289 1
- 6331 1
- 6340 1
- 6354 1
- 6359 1
- 6364 1
- 6368 1
- 6376 1
- 6383 1
- 6387 1
- 6396 1
- 6433 1
- 6450 1
- 6469 1
- 6486 1
- 6555 1
- 6573 1
- 6596 1
- 6626 1
- 6726 1
- 6744 1
- 6770 1
- 6823 1
- 6938 1
- 6983 1
- 7035 1
- 7101 1
- 7336 1
- 7493 1
- 7727 1
- 7812 1
- 7933 1
- 7983 1
- 8420 1
- 8470 1
- 8496 1
- 8797 1
- 8863 1
- 8897 1
- 8938 1
- 9234 1
- 9269 1
- 9388 1
- 9412 1
- 9442 1
- 9484 1
- 9567 1
- 9582 1
- 9604 1
- 9617 1
- 9707 1
- 9731 1
- 9746 1
- 9764 1
- 9811 1
- 9836 1
- 9853 1
- 9870 1
- 9919 1
- 9924 1
- 9943 1
- 9968 1
- 9974 1
- 9980 1
- 10009 1
- 10034 1
- 10043 1
- 10058 1
- 10075 1
- 10108 1
- 10113 1
- 10166 1
- 10187 1
- 10216 1
- 10234 1
- 10300 1
- 10320 1
- 10420 1
- 10440 1
- 10456 1
- 10478 1
- 10543 1
- 10557 1
- 10585 1
- 10696 1
- 10741 1
- 10776 1
- 11032 1
state 1
- Tennessee 792
fips 1
- 47089 · 792 ✖
county 1
- Jefferson 792
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1873 | 1873 | 2020-03-13 | Jefferson | Tennessee | 47089 | 1 | 0 |
2238 | 2238 | 2020-03-14 | Jefferson | Tennessee | 47089 | 1 | 0 |
2663 | 2663 | 2020-03-15 | Jefferson | Tennessee | 47089 | 1 | 0 |
3129 | 3129 | 2020-03-16 | Jefferson | Tennessee | 47089 | 1 | 0 |
3662 | 3662 | 2020-03-17 | Jefferson | Tennessee | 47089 | 1 | 0 |
4283 | 4283 | 2020-03-18 | Jefferson | Tennessee | 47089 | 1 | 0 |
5030 | 5030 | 2020-03-19 | Jefferson | Tennessee | 47089 | 1 | 0 |
5917 | 5917 | 2020-03-20 | Jefferson | Tennessee | 47089 | 1 | 0 |
6930 | 6930 | 2020-03-21 | Jefferson | Tennessee | 47089 | 1 | 0 |
8056 | 8056 | 2020-03-22 | Jefferson | Tennessee | 47089 | 2 | 0 |
9274 | 9274 | 2020-03-23 | Jefferson | Tennessee | 47089 | 2 | 0 |
10605 | 10605 | 2020-03-24 | Jefferson | Tennessee | 47089 | 4 | 0 |
12083 | 12083 | 2020-03-25 | Jefferson | Tennessee | 47089 | 4 | 0 |
13707 | 13707 | 2020-03-26 | Jefferson | Tennessee | 47089 | 4 | 0 |
15459 | 15459 | 2020-03-27 | Jefferson | Tennessee | 47089 | 5 | 0 |
17321 | 17321 | 2020-03-28 | Jefferson | Tennessee | 47089 | 5 | 0 |
19269 | 19269 | 2020-03-29 | Jefferson | Tennessee | 47089 | 5 | 0 |
21324 | 21324 | 2020-03-30 | Jefferson | Tennessee | 47089 | 5 | 0 |
23463 | 23463 | 2020-03-31 | Jefferson | Tennessee | 47089 | 6 | 0 |
25664 | 25664 | 2020-04-01 | Jefferson | Tennessee | 47089 | 6 | 0 |
27943 | 27943 | 2020-04-02 | Jefferson | Tennessee | 47089 | 6 | 0 |
30278 | 30278 | 2020-04-03 | Jefferson | Tennessee | 47089 | 6 | 0 |
32669 | 32669 | 2020-04-04 | Jefferson | Tennessee | 47089 | 6 | 0 |
35106 | 35106 | 2020-04-05 | Jefferson | Tennessee | 47089 | 6 | 0 |
37582 | 37582 | 2020-04-06 | Jefferson | Tennessee | 47089 | 7 | 0 |
40105 | 40105 | 2020-04-07 | Jefferson | Tennessee | 47089 | 10 | 0 |
42667 | 42667 | 2020-04-08 | Jefferson | Tennessee | 47089 | 12 | 0 |
45254 | 45254 | 2020-04-09 | Jefferson | Tennessee | 47089 | 12 | 0 |
47872 | 47872 | 2020-04-10 | Jefferson | Tennessee | 47089 | 13 | 0 |
50530 | 50530 | 2020-04-11 | Jefferson | Tennessee | 47089 | 14 | 0 |
53205 | 53205 | 2020-04-12 | Jefferson | Tennessee | 47089 | 14 | 0 |
55891 | 55891 | 2020-04-13 | Jefferson | Tennessee | 47089 | 16 | 0 |
58594 | 58594 | 2020-04-14 | Jefferson | Tennessee | 47089 | 16 | 0 |
61309 | 61309 | 2020-04-15 | Jefferson | Tennessee | 47089 | 16 | 1 |
64036 | 64036 | 2020-04-16 | Jefferson | Tennessee | 47089 | 16 | 1 |
66782 | 66782 | 2020-04-17 | Jefferson | Tennessee | 47089 | 14 | 0 |
69541 | 69541 | 2020-04-18 | Jefferson | Tennessee | 47089 | 15 | 0 |
72308 | 72308 | 2020-04-19 | Jefferson | Tennessee | 47089 | 15 | 0 |
75083 | 75083 | 2020-04-20 | Jefferson | Tennessee | 47089 | 16 | 0 |
77865 | 77865 | 2020-04-21 | Jefferson | Tennessee | 47089 | 16 | 0 |
80655 | 80655 | 2020-04-22 | Jefferson | Tennessee | 47089 | 17 | 0 |
83454 | 83454 | 2020-04-23 | Jefferson | Tennessee | 47089 | 16 | 0 |
86259 | 86259 | 2020-04-24 | Jefferson | Tennessee | 47089 | 17 | 0 |
89074 | 89074 | 2020-04-25 | Jefferson | Tennessee | 47089 | 17 | 0 |
91891 | 91891 | 2020-04-26 | Jefferson | Tennessee | 47089 | 18 | 0 |
94719 | 94719 | 2020-04-27 | Jefferson | Tennessee | 47089 | 18 | 0 |
97559 | 97559 | 2020-04-28 | Jefferson | Tennessee | 47089 | 18 | 0 |
100409 | 100409 | 2020-04-29 | Jefferson | Tennessee | 47089 | 18 | 0 |
103262 | 103262 | 2020-04-30 | Jefferson | Tennessee | 47089 | 19 | 0 |
106125 | 106125 | 2020-05-01 | Jefferson | Tennessee | 47089 | 20 | 0 |
108992 | 108992 | 2020-05-02 | Jefferson | Tennessee | 47089 | 22 | 0 |
111866 | 111866 | 2020-05-03 | Jefferson | Tennessee | 47089 | 24 | 0 |
114748 | 114748 | 2020-05-04 | Jefferson | Tennessee | 47089 | 28 | 0 |
117704 | 117704 | 2020-05-05 | Jefferson | Tennessee | 47089 | 27 | 0 |
120668 | 120668 | 2020-05-06 | Jefferson | Tennessee | 47089 | 26 | 0 |
123646 | 123646 | 2020-05-07 | Jefferson | Tennessee | 47089 | 26 | 0 |
126629 | 126629 | 2020-05-08 | Jefferson | Tennessee | 47089 | 26 | 0 |
129618 | 129618 | 2020-05-09 | Jefferson | Tennessee | 47089 | 26 | 0 |
132607 | 132607 | 2020-05-10 | Jefferson | Tennessee | 47089 | 26 | 0 |
135598 | 135598 | 2020-05-11 | Jefferson | Tennessee | 47089 | 26 | 0 |
138588 | 138588 | 2020-05-12 | Jefferson | Tennessee | 47089 | 26 | 0 |
141584 | 141584 | 2020-05-13 | Jefferson | Tennessee | 47089 | 26 | 0 |
144581 | 144581 | 2020-05-14 | Jefferson | Tennessee | 47089 | 26 | 0 |
147582 | 147582 | 2020-05-15 | Jefferson | Tennessee | 47089 | 26 | 0 |
150590 | 150590 | 2020-05-16 | Jefferson | Tennessee | 47089 | 26 | 0 |
153601 | 153601 | 2020-05-17 | Jefferson | Tennessee | 47089 | 26 | 0 |
156618 | 156618 | 2020-05-18 | Jefferson | Tennessee | 47089 | 26 | 0 |
159640 | 159640 | 2020-05-19 | Jefferson | Tennessee | 47089 | 26 | 0 |
162667 | 162667 | 2020-05-20 | Jefferson | Tennessee | 47089 | 26 | 0 |
165696 | 165696 | 2020-05-21 | Jefferson | Tennessee | 47089 | 27 | 0 |
168732 | 168732 | 2020-05-22 | Jefferson | Tennessee | 47089 | 27 | 0 |
171771 | 171771 | 2020-05-23 | Jefferson | Tennessee | 47089 | 27 | 0 |
174814 | 174814 | 2020-05-24 | Jefferson | Tennessee | 47089 | 27 | 0 |
177858 | 177858 | 2020-05-25 | Jefferson | Tennessee | 47089 | 27 | 0 |
180901 | 180901 | 2020-05-26 | Jefferson | Tennessee | 47089 | 28 | 0 |
183951 | 183951 | 2020-05-27 | Jefferson | Tennessee | 47089 | 28 | 0 |
187008 | 187008 | 2020-05-28 | Jefferson | Tennessee | 47089 | 28 | 0 |
190072 | 190072 | 2020-05-29 | Jefferson | Tennessee | 47089 | 28 | 0 |
193137 | 193137 | 2020-05-30 | Jefferson | Tennessee | 47089 | 28 | 0 |
196207 | 196207 | 2020-05-31 | Jefferson | Tennessee | 47089 | 28 | 0 |
199280 | 199280 | 2020-06-01 | Jefferson | Tennessee | 47089 | 28 | 0 |
202355 | 202355 | 2020-06-02 | Jefferson | Tennessee | 47089 | 28 | 0 |
205434 | 205434 | 2020-06-03 | Jefferson | Tennessee | 47089 | 28 | 0 |
208516 | 208516 | 2020-06-04 | Jefferson | Tennessee | 47089 | 29 | 0 |
211598 | 211598 | 2020-06-05 | Jefferson | Tennessee | 47089 | 29 | 0 |
214685 | 214685 | 2020-06-06 | Jefferson | Tennessee | 47089 | 29 | 0 |
217775 | 217775 | 2020-06-07 | Jefferson | Tennessee | 47089 | 29 | 0 |
220867 | 220867 | 2020-06-08 | Jefferson | Tennessee | 47089 | 29 | 0 |
223962 | 223962 | 2020-06-09 | Jefferson | Tennessee | 47089 | 31 | 0 |
227062 | 227062 | 2020-06-10 | Jefferson | Tennessee | 47089 | 31 | 0 |
230166 | 230166 | 2020-06-11 | Jefferson | Tennessee | 47089 | 36 | 0 |
233271 | 233271 | 2020-06-12 | Jefferson | Tennessee | 47089 | 42 | 0 |
236377 | 236377 | 2020-06-13 | Jefferson | Tennessee | 47089 | 43 | 0 |
239485 | 239485 | 2020-06-14 | Jefferson | Tennessee | 47089 | 45 | 0 |
242595 | 242595 | 2020-06-15 | Jefferson | Tennessee | 47089 | 45 | 0 |
245707 | 245707 | 2020-06-16 | Jefferson | Tennessee | 47089 | 46 | 0 |
248820 | 248820 | 2020-06-17 | Jefferson | Tennessee | 47089 | 48 | 0 |
251935 | 251935 | 2020-06-18 | Jefferson | Tennessee | 47089 | 51 | 0 |
255050 | 255050 | 2020-06-19 | Jefferson | Tennessee | 47089 | 59 | 0 |
258176 | 258176 | 2020-06-20 | Jefferson | Tennessee | 47089 | 61 | 0 |
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);