ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47059 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 498 ✖
- 46 11
- 52 10
- 43 8
- 15499 8
- 16008 7
- 17078 7
- 18608 7
- 20077 7
- 20926 7
- 21459 7
- 21773 7
- 21883 7
- 21952 7
- 21992 7
- 22029 7
- 22045 7
- 22053 7
- 22058 7
- 22066 7
- 22084 7
- 22102 7
- 47 5
- 55 5
- 14165 5
- 41 4
- 53 4
- 7535 4
- 7966 4
- 8002 4
- 8045 4
- 8057 4
- 10369 4
- 13554 4
- 13685 4
- 13839 4
- 15025 4
- 15255 4
- 8 3
- 16 3
- 30 3
- 44 3
- 48 3
- 50 3
- 56 3
- 7356 3
- 7402 3
- 7472 3
- 7645 3
- 7715 3
- 7785 3
- 7827 3
- 7877 3
- 7928 3
- 7951 3
- 7984 3
- 8019 3
- 8034 3
- 8080 3
- 8132 3
- 8241 3
- 8425 3
- 8686 3
- 9129 3
- 9631 3
- 11119 3
- 11859 3
- 12295 3
- 12636 3
- 13035 3
- 13339 3
- 13960 3
- 14092 3
- 14449 3
- 14657 3
- 14837 3
- 22140 3
- 1 2
- 2 2
- 12 2
- 17 2
- 26 2
- 27 2
- 37 2
- 74 2
- 85 2
- 151 2
- 504 2
- 5517 2
- 7317 2
- 7739 2
- 7989 2
- 8016 2
- 8029 2
- 8030 2
- 8040 2
- 9414 2
- 12040 2
- 13912 2
- 14566 2
- 5 1
- 7 1
- 9 1
- 15 1
- 18 1
- 20 1
- 22 1
- 25 1
- 28 1
- 29 1
- 35 1
- 38 1
- 42 1
- 49 1
- 58 1
- 66 1
- 68 1
- 81 1
- 86 1
- 95 1
- 101 1
- 103 1
- 114 1
- 117 1
- 122 1
- 123 1
- 138 1
- 157 1
- 163 1
- 173 1
- 187 1
- 193 1
- 196 1
- 209 1
- 223 1
- 237 1
- 238 1
- 243 1
- 248 1
- 261 1
- 284 1
- 295 1
- 300 1
- 316 1
- 324 1
- 344 1
- 362 1
- 369 1
- 371 1
- 376 1
- 398 1
- 418 1
- 447 1
- 467 1
- 492 1
- 524 1
- 552 1
- 561 1
- 563 1
- 605 1
- 609 1
- 627 1
- 653 1
- 669 1
- 685 1
- 712 1
- 721 1
- 730 1
- 738 1
- 759 1
- 779 1
- 800 1
- 814 1
- 816 1
- 820 1
- 844 1
- 857 1
- 878 1
- 890 1
- 916 1
- 926 1
- 937 1
- 938 1
- 948 1
- 962 1
- 974 1
- 976 1
- 979 1
- 1010 1
- 1018 1
- 1026 1
- 1037 1
- 1075 1
- 1079 1
- 1106 1
- 1107 1
- 1112 1
- 1118 1
- 1129 1
- 1142 1
- 1156 1
- 1161 1
- 1166 1
- 1169 1
- 1185 1
- 1189 1
- 1198 1
- 1200 1
- 1214 1
- 1230 1
- 1234 1
- 1258 1
- 1268 1
- 1288 1
- 1308 1
- 1336 1
- 1365 1
- 1374 1
- 1383 1
- 1435 1
- 1444 1
- 1464 1
- 1492 1
- 1556 1
- 1565 1
- 1575 1
- 1618 1
- 1654 1
- 1684 1
- 1750 1
- 1812 1
- 1821 1
- 1831 1
- 1876 1
- 1927 1
- 1967 1
- 1973 1
- 1998 1
- 2038 1
- 2112 1
- 2143 1
- 2156 1
- 2175 1
- 2191 1
- 2271 1
- 2291 1
- 2332 1
- 2381 1
- 2394 1
- 2451 1
- 2496 1
- 2572 1
- 2591 1
- 2663 1
- 2693 1
- 2715 1
- 2741 1
- 2818 1
- 2859 1
- 2878 1
- 2903 1
- 2953 1
- 3006 1
- 3082 1
- 3116 1
- 3248 1
- 3304 1
- 3330 1
- 3355 1
- 3380 1
- 3430 1
- 3449 1
- 3574 1
- 3630 1
- 3738 1
- 3815 1
- 3891 1
- 3959 1
- 4063 1
- 4173 1
- 4292 1
- 4402 1
- 4547 1
- 4657 1
- 4739 1
- 4866 1
- 4970 1
- 5026 1
- 5086 1
- 5129 1
- 5206 1
- 5259 1
- 5295 1
- 5371 1
- 5423 1
- 5482 1
- 5713 1
- 5811 1
- 5861 1
- 5916 1
- 6013 1
- 6086 1
- 6161 1
- 6222 1
- 6294 1
- 6322 1
- 6391 1
- 6438 1
- 6459 1
- 6500 1
- 6548 1
- 6569 1
- 6598 1
- 6615 1
- 6655 1
- 6679 1
- 6719 1
- 6749 1
- 6766 1
- 6779 1
- 6790 1
- 6796 1
- 6799 1
- 6848 1
- 6867 1
- 6883 1
- 6893 1
- 6917 1
- 6935 1
- 6957 1
- 6968 1
- 6990 1
- 7013 1
- 7024 1
- 7046 1
- 7118 1
- 7154 1
- 7156 1
- 7172 1
- 7177 1
- 7186 1
- 7197 1
- 7203 1
- 7213 1
- 7220 1
- 7238 1
- 7244 1
- 7249 1
- 7251 1
- 7258 1
- 7270 1
- 7271 1
- 7277 1
- 7283 1
- 7292 1
- 7294 1
- 7301 1
- 7309 1
- 7315 1
- 7321 1
- 7330 1
- 7336 1
- 7345 1
- 7368 1
- 7376 1
- 7386 1
- 7397 1
- 7429 1
- 7438 1
- 7444 1
- 7454 1
- 7495 1
- 7497 1
- 7510 1
- 7589 1
- 7604 1
- 7621 1
- 7632 1
- 7675 1
- 7683 1
- 7694 1
- 7703 1
- 7746 1
- 7777 1
- 7802 1
- 7807 1
- 7814 1
- 7822 1
- 7838 1
- 7840 1
- 7844 1
- 7864 1
- 7889 1
- 7899 1
- 7910 1
- 7924 1
- 7936 1
- 7939 1
- 7944 1
- 7952 1
- 7954 1
- 7955 1
- 7961 1
- 7963 1
- 7976 1
- 7978 1
- 7982 1
- 7988 1
- 7990 1
- 8017 1
- 8041 1
- 8043 1
- 8055 1
- 8056 1
- 8059 1
- 8063 1
- 8071 1
- 8079 1
- 8091 1
- 8107 1
- 8116 1
- 8126 1
- 8159 1
- 8176 1
- 8199 1
- 8226 1
- 8298 1
- 8330 1
- 8365 1
- 8393 1
- 8505 1
- 8554 1
- 8592 1
- 8650 1
- 8816 1
- 8873 1
- 8939 1
- 9040 1
- 9361 1
- 9547 1
- 9930 1
- 10055 1
- 10189 1
- 10266 1
- 10905 1
- 10943 1
- 11028 1
- 11566 1
- 11638 1
- 11736 1
- 11768 1
- 12157 1
- 12228 1
- 12428 1
- 12483 1
- 12527 1
- 12600 1
- 12779 1
- 12820 1
- 12884 1
- 12954 1
- 13132 1
- 13216 1
- 13270 1
- 13304 1
- 13414 1
- 13443 1
- 13483 1
- 13531 1
- 13615 1
- 13628 1
- 13662 1
- 13757 1
- 13786 1
- 13813 1
- 13892 1
- 13990 1
- 14007 1
- 14026 1
- 14065 1
- 14130 1
- 14151 1
- 14258 1
- 14299 1
- 14341 1
- 14394 1
- 14514 1
- 14537 1
- 14728 1
- 14767 1
- 14793 1
- 14818 1
- 14904 1
- 14949 1
- 14976 1
- 15097 1
- 15133 1
- 15171 1
- 15432 1
state 1
- Tennessee 785
fips 1
- 47059 · 785 ✖
county 1
- Greene 785
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
5914 | 5914 | 2020-03-20 | Greene | Tennessee | 47059 | 1 | 0 |
6927 | 6927 | 2020-03-21 | Greene | Tennessee | 47059 | 1 | 0 |
8052 | 8052 | 2020-03-22 | Greene | Tennessee | 47059 | 2 | 0 |
9270 | 9270 | 2020-03-23 | Greene | Tennessee | 47059 | 2 | 0 |
10599 | 10599 | 2020-03-24 | Greene | Tennessee | 47059 | 5 | 0 |
12076 | 12076 | 2020-03-25 | Greene | Tennessee | 47059 | 7 | 0 |
13700 | 13700 | 2020-03-26 | Greene | Tennessee | 47059 | 8 | 0 |
15452 | 15452 | 2020-03-27 | Greene | Tennessee | 47059 | 8 | 0 |
17313 | 17313 | 2020-03-28 | Greene | Tennessee | 47059 | 8 | 0 |
19259 | 19259 | 2020-03-29 | Greene | Tennessee | 47059 | 9 | 0 |
21314 | 21314 | 2020-03-30 | Greene | Tennessee | 47059 | 12 | 0 |
23452 | 23452 | 2020-03-31 | Greene | Tennessee | 47059 | 12 | 0 |
25652 | 25652 | 2020-04-01 | Greene | Tennessee | 47059 | 15 | 1 |
27930 | 27930 | 2020-04-02 | Greene | Tennessee | 47059 | 16 | 1 |
30265 | 30265 | 2020-04-03 | Greene | Tennessee | 47059 | 16 | 1 |
32656 | 32656 | 2020-04-04 | Greene | Tennessee | 47059 | 16 | 1 |
35092 | 35092 | 2020-04-05 | Greene | Tennessee | 47059 | 17 | 1 |
37568 | 37568 | 2020-04-06 | Greene | Tennessee | 47059 | 17 | 1 |
40091 | 40091 | 2020-04-07 | Greene | Tennessee | 47059 | 18 | 1 |
42653 | 42653 | 2020-04-08 | Greene | Tennessee | 47059 | 20 | 1 |
45240 | 45240 | 2020-04-09 | Greene | Tennessee | 47059 | 22 | 1 |
47858 | 47858 | 2020-04-10 | Greene | Tennessee | 47059 | 25 | 1 |
50516 | 50516 | 2020-04-11 | Greene | Tennessee | 47059 | 26 | 1 |
53191 | 53191 | 2020-04-12 | Greene | Tennessee | 47059 | 26 | 1 |
55877 | 55877 | 2020-04-13 | Greene | Tennessee | 47059 | 27 | 1 |
58580 | 58580 | 2020-04-14 | Greene | Tennessee | 47059 | 27 | 2 |
61295 | 61295 | 2020-04-15 | Greene | Tennessee | 47059 | 28 | 2 |
64022 | 64022 | 2020-04-16 | Greene | Tennessee | 47059 | 29 | 2 |
66768 | 66768 | 2020-04-17 | Greene | Tennessee | 47059 | 30 | 2 |
69527 | 69527 | 2020-04-18 | Greene | Tennessee | 47059 | 30 | 2 |
72294 | 72294 | 2020-04-19 | Greene | Tennessee | 47059 | 30 | 2 |
75069 | 75069 | 2020-04-20 | Greene | Tennessee | 47059 | 35 | 2 |
77851 | 77851 | 2020-04-21 | Greene | Tennessee | 47059 | 37 | 2 |
80641 | 80641 | 2020-04-22 | Greene | Tennessee | 47059 | 37 | 2 |
83440 | 83440 | 2020-04-23 | Greene | Tennessee | 47059 | 38 | 2 |
86245 | 86245 | 2020-04-24 | Greene | Tennessee | 47059 | 41 | 2 |
89060 | 89060 | 2020-04-25 | Greene | Tennessee | 47059 | 41 | 2 |
91877 | 91877 | 2020-04-26 | Greene | Tennessee | 47059 | 41 | 2 |
94705 | 94705 | 2020-04-27 | Greene | Tennessee | 47059 | 41 | 2 |
97545 | 97545 | 2020-04-28 | Greene | Tennessee | 47059 | 42 | 2 |
100395 | 100395 | 2020-04-29 | Greene | Tennessee | 47059 | 43 | 2 |
103248 | 103248 | 2020-04-30 | Greene | Tennessee | 47059 | 44 | 2 |
106111 | 106111 | 2020-05-01 | Greene | Tennessee | 47059 | 44 | 2 |
108978 | 108978 | 2020-05-02 | Greene | Tennessee | 47059 | 43 | 2 |
111852 | 111852 | 2020-05-03 | Greene | Tennessee | 47059 | 43 | 2 |
114734 | 114734 | 2020-05-04 | Greene | Tennessee | 47059 | 43 | 2 |
117690 | 117690 | 2020-05-05 | Greene | Tennessee | 47059 | 43 | 2 |
120654 | 120654 | 2020-05-06 | Greene | Tennessee | 47059 | 43 | 2 |
123632 | 123632 | 2020-05-07 | Greene | Tennessee | 47059 | 43 | 2 |
126615 | 126615 | 2020-05-08 | Greene | Tennessee | 47059 | 43 | 2 |
129604 | 129604 | 2020-05-09 | Greene | Tennessee | 47059 | 44 | 2 |
132593 | 132593 | 2020-05-10 | Greene | Tennessee | 47059 | 46 | 2 |
135584 | 135584 | 2020-05-11 | Greene | Tennessee | 47059 | 46 | 2 |
138574 | 138574 | 2020-05-12 | Greene | Tennessee | 47059 | 46 | 2 |
141570 | 141570 | 2020-05-13 | Greene | Tennessee | 47059 | 47 | 2 |
144567 | 144567 | 2020-05-14 | Greene | Tennessee | 47059 | 46 | 2 |
147568 | 147568 | 2020-05-15 | Greene | Tennessee | 47059 | 46 | 2 |
150576 | 150576 | 2020-05-16 | Greene | Tennessee | 47059 | 46 | 2 |
153587 | 153587 | 2020-05-17 | Greene | Tennessee | 47059 | 46 | 2 |
156604 | 156604 | 2020-05-18 | Greene | Tennessee | 47059 | 46 | 2 |
159625 | 159625 | 2020-05-19 | Greene | Tennessee | 47059 | 46 | 2 |
162652 | 162652 | 2020-05-20 | Greene | Tennessee | 47059 | 46 | 2 |
165681 | 165681 | 2020-05-21 | Greene | Tennessee | 47059 | 46 | 2 |
168717 | 168717 | 2020-05-22 | Greene | Tennessee | 47059 | 47 | 2 |
171756 | 171756 | 2020-05-23 | Greene | Tennessee | 47059 | 48 | 2 |
174799 | 174799 | 2020-05-24 | Greene | Tennessee | 47059 | 47 | 2 |
177843 | 177843 | 2020-05-25 | Greene | Tennessee | 47059 | 47 | 2 |
180886 | 180886 | 2020-05-26 | Greene | Tennessee | 47059 | 47 | 2 |
183936 | 183936 | 2020-05-27 | Greene | Tennessee | 47059 | 48 | 2 |
186993 | 186993 | 2020-05-28 | Greene | Tennessee | 47059 | 48 | 2 |
190057 | 190057 | 2020-05-29 | Greene | Tennessee | 47059 | 49 | 2 |
193122 | 193122 | 2020-05-30 | Greene | Tennessee | 47059 | 50 | 2 |
196192 | 196192 | 2020-05-31 | Greene | Tennessee | 47059 | 50 | 2 |
199265 | 199265 | 2020-06-01 | Greene | Tennessee | 47059 | 50 | 2 |
202340 | 202340 | 2020-06-02 | Greene | Tennessee | 47059 | 52 | 2 |
205419 | 205419 | 2020-06-03 | Greene | Tennessee | 47059 | 52 | 2 |
208501 | 208501 | 2020-06-04 | Greene | Tennessee | 47059 | 52 | 2 |
211583 | 211583 | 2020-06-05 | Greene | Tennessee | 47059 | 52 | 2 |
214670 | 214670 | 2020-06-06 | Greene | Tennessee | 47059 | 52 | 2 |
217760 | 217760 | 2020-06-07 | Greene | Tennessee | 47059 | 52 | 2 |
220852 | 220852 | 2020-06-08 | Greene | Tennessee | 47059 | 52 | 2 |
223947 | 223947 | 2020-06-09 | Greene | Tennessee | 47059 | 52 | 2 |
227047 | 227047 | 2020-06-10 | Greene | Tennessee | 47059 | 52 | 2 |
230151 | 230151 | 2020-06-11 | Greene | Tennessee | 47059 | 52 | 2 |
233256 | 233256 | 2020-06-12 | Greene | Tennessee | 47059 | 53 | 2 |
236362 | 236362 | 2020-06-13 | Greene | Tennessee | 47059 | 53 | 2 |
239470 | 239470 | 2020-06-14 | Greene | Tennessee | 47059 | 53 | 2 |
242580 | 242580 | 2020-06-15 | Greene | Tennessee | 47059 | 53 | 2 |
245692 | 245692 | 2020-06-16 | Greene | Tennessee | 47059 | 55 | 2 |
248805 | 248805 | 2020-06-17 | Greene | Tennessee | 47059 | 55 | 2 |
251920 | 251920 | 2020-06-18 | Greene | Tennessee | 47059 | 56 | 2 |
255035 | 255035 | 2020-06-19 | Greene | Tennessee | 47059 | 55 | 2 |
258161 | 258161 | 2020-06-20 | Greene | Tennessee | 47059 | 55 | 2 |
261288 | 261288 | 2020-06-21 | Greene | Tennessee | 47059 | 55 | 2 |
264416 | 264416 | 2020-06-22 | Greene | Tennessee | 47059 | 56 | 2 |
267544 | 267544 | 2020-06-23 | Greene | Tennessee | 47059 | 56 | 2 |
270678 | 270678 | 2020-06-24 | Greene | Tennessee | 47059 | 58 | 2 |
273817 | 273817 | 2020-06-25 | Greene | Tennessee | 47059 | 66 | 2 |
280112 | 280112 | 2020-06-27 | Greene | Tennessee | 47059 | 74 | 2 |
283258 | 283258 | 2020-06-28 | Greene | Tennessee | 47059 | 74 | 2 |
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);