ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,566 rows where county = "Fannin" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9730 | 9730 | 2020-03-24 | Fannin | Georgia | 13111 | 1 | 0 |
11107 | 11107 | 2020-03-25 | Fannin | Georgia | 13111 | 1 | 0 |
12656 | 12656 | 2020-03-26 | Fannin | Georgia | 13111 | 1 | 0 |
14328 | 14328 | 2020-03-27 | Fannin | Georgia | 13111 | 3 | 0 |
16114 | 16114 | 2020-03-28 | Fannin | Georgia | 13111 | 3 | 0 |
18011 | 18011 | 2020-03-29 | Fannin | Georgia | 13111 | 3 | 0 |
20000 | 20000 | 2020-03-30 | Fannin | Georgia | 13111 | 3 | 0 |
22080 | 22080 | 2020-03-31 | Fannin | Georgia | 13111 | 4 | 0 |
24243 | 24243 | 2020-04-01 | Fannin | Georgia | 13111 | 6 | 0 |
26474 | 26474 | 2020-04-02 | Fannin | Georgia | 13111 | 8 | 0 |
28778 | 28778 | 2020-04-03 | Fannin | Georgia | 13111 | 8 | 0 |
31138 | 31138 | 2020-04-04 | Fannin | Georgia | 13111 | 8 | 0 |
33545 | 33545 | 2020-04-05 | Fannin | Georgia | 13111 | 8 | 0 |
35994 | 35994 | 2020-04-06 | Fannin | Georgia | 13111 | 10 | 0 |
38486 | 38486 | 2020-04-07 | Fannin | Georgia | 13111 | 10 | 0 |
41030 | 41030 | 2020-04-08 | Fannin | Georgia | 13111 | 9 | 0 |
43604 | 43604 | 2020-04-09 | Fannin | Georgia | 13111 | 9 | 0 |
46206 | 46206 | 2020-04-10 | Fannin | Georgia | 13111 | 9 | 0 |
48836 | 48836 | 2020-04-11 | Fannin | Georgia | 13111 | 9 | 0 |
51498 | 51498 | 2020-04-12 | Fannin | Georgia | 13111 | 9 | 0 |
54178 | 54178 | 2020-04-13 | Fannin | Georgia | 13111 | 12 | 0 |
56870 | 56870 | 2020-04-14 | Fannin | Georgia | 13111 | 13 | 0 |
59577 | 59577 | 2020-04-15 | Fannin | Georgia | 13111 | 14 | 0 |
62297 | 62297 | 2020-04-16 | Fannin | Georgia | 13111 | 14 | 0 |
65030 | 65030 | 2020-04-17 | Fannin | Georgia | 13111 | 15 | 0 |
67778 | 67778 | 2020-04-18 | Fannin | Georgia | 13111 | 15 | 0 |
70540 | 70540 | 2020-04-19 | Fannin | Georgia | 13111 | 16 | 0 |
73309 | 73309 | 2020-04-20 | Fannin | Georgia | 13111 | 19 | 1 |
76085 | 76085 | 2020-04-21 | Fannin | Georgia | 13111 | 19 | 1 |
78869 | 78869 | 2020-04-22 | Fannin | Georgia | 13111 | 20 | 0 |
81662 | 81662 | 2020-04-23 | Fannin | Georgia | 13111 | 20 | 0 |
84462 | 84462 | 2020-04-24 | Fannin | Georgia | 13111 | 21 | 0 |
87271 | 87271 | 2020-04-25 | Fannin | Georgia | 13111 | 21 | 0 |
90087 | 90087 | 2020-04-26 | Fannin | Georgia | 13111 | 23 | 0 |
92906 | 92906 | 2020-04-27 | Fannin | Georgia | 13111 | 24 | 0 |
95738 | 95738 | 2020-04-28 | Fannin | Georgia | 13111 | 27 | 1 |
98583 | 98583 | 2020-04-29 | Fannin | Georgia | 13111 | 28 | 1 |
101433 | 101433 | 2020-04-30 | Fannin | Georgia | 13111 | 29 | 1 |
104288 | 104288 | 2020-05-01 | Fannin | Georgia | 13111 | 30 | 1 |
107153 | 107153 | 2020-05-02 | Fannin | Georgia | 13111 | 31 | 1 |
110022 | 110022 | 2020-05-03 | Fannin | Georgia | 13111 | 31 | 1 |
112897 | 112897 | 2020-05-04 | Fannin | Georgia | 13111 | 32 | 1 |
115780 | 115780 | 2020-05-05 | Fannin | Georgia | 13111 | 32 | 1 |
118740 | 118740 | 2020-05-06 | Fannin | Georgia | 13111 | 33 | 1 |
121709 | 121709 | 2020-05-07 | Fannin | Georgia | 13111 | 34 | 1 |
124688 | 124688 | 2020-05-08 | Fannin | Georgia | 13111 | 34 | 1 |
127675 | 127675 | 2020-05-09 | Fannin | Georgia | 13111 | 34 | 1 |
130666 | 130666 | 2020-05-10 | Fannin | Georgia | 13111 | 34 | 1 |
133657 | 133657 | 2020-05-11 | Fannin | Georgia | 13111 | 34 | 1 |
136646 | 136646 | 2020-05-12 | Fannin | Georgia | 13111 | 35 | 1 |
139637 | 139637 | 2020-05-13 | Fannin | Georgia | 13111 | 36 | 1 |
142633 | 142633 | 2020-05-14 | Fannin | Georgia | 13111 | 36 | 1 |
145633 | 145633 | 2020-05-15 | Fannin | Georgia | 13111 | 36 | 1 |
148636 | 148636 | 2020-05-16 | Fannin | Georgia | 13111 | 36 | 1 |
151645 | 151645 | 2020-05-17 | Fannin | Georgia | 13111 | 36 | 1 |
154657 | 154657 | 2020-05-18 | Fannin | Georgia | 13111 | 38 | 1 |
157673 | 157673 | 2020-05-19 | Fannin | Georgia | 13111 | 38 | 1 |
160699 | 160699 | 2020-05-20 | Fannin | Georgia | 13111 | 39 | 1 |
163727 | 163727 | 2020-05-21 | Fannin | Georgia | 13111 | 39 | 1 |
166760 | 166760 | 2020-05-22 | Fannin | Georgia | 13111 | 39 | 1 |
169797 | 169797 | 2020-05-23 | Fannin | Georgia | 13111 | 39 | 1 |
172838 | 172838 | 2020-05-24 | Fannin | Georgia | 13111 | 40 | 1 |
175881 | 175881 | 2020-05-25 | Fannin | Georgia | 13111 | 40 | 1 |
178925 | 178925 | 2020-05-26 | Fannin | Georgia | 13111 | 40 | 1 |
181969 | 181969 | 2020-05-27 | Fannin | Georgia | 13111 | 40 | 1 |
185023 | 185023 | 2020-05-28 | Fannin | Georgia | 13111 | 41 | 1 |
188079 | 188079 | 2020-05-29 | Fannin | Georgia | 13111 | 43 | 1 |
191144 | 191144 | 2020-05-30 | Fannin | Georgia | 13111 | 43 | 1 |
194211 | 194211 | 2020-05-31 | Fannin | Georgia | 13111 | 44 | 1 |
197281 | 197281 | 2020-06-01 | Fannin | Georgia | 13111 | 46 | 1 |
200354 | 200354 | 2020-06-02 | Fannin | Georgia | 13111 | 47 | 1 |
203430 | 203430 | 2020-06-03 | Fannin | Georgia | 13111 | 49 | 1 |
206510 | 206510 | 2020-06-04 | Fannin | Georgia | 13111 | 50 | 1 |
209591 | 209591 | 2020-06-05 | Fannin | Georgia | 13111 | 49 | 1 |
212676 | 212676 | 2020-06-06 | Fannin | Georgia | 13111 | 51 | 1 |
215763 | 215763 | 2020-06-07 | Fannin | Georgia | 13111 | 52 | 1 |
218854 | 218854 | 2020-06-08 | Fannin | Georgia | 13111 | 55 | 1 |
221949 | 221949 | 2020-06-09 | Fannin | Georgia | 13111 | 57 | 1 |
225044 | 225044 | 2020-06-10 | Fannin | Georgia | 13111 | 59 | 1 |
228146 | 228146 | 2020-06-11 | Fannin | Georgia | 13111 | 63 | 1 |
231249 | 231249 | 2020-06-12 | Fannin | Georgia | 13111 | 65 | 1 |
234355 | 234355 | 2020-06-13 | Fannin | Georgia | 13111 | 65 | 1 |
237462 | 237462 | 2020-06-14 | Fannin | Georgia | 13111 | 67 | 1 |
240570 | 240570 | 2020-06-15 | Fannin | Georgia | 13111 | 67 | 1 |
243681 | 243681 | 2020-06-16 | Fannin | Georgia | 13111 | 69 | 1 |
246794 | 246794 | 2020-06-17 | Fannin | Georgia | 13111 | 70 | 1 |
249906 | 249906 | 2020-06-18 | Fannin | Georgia | 13111 | 73 | 1 |
253021 | 253021 | 2020-06-19 | Fannin | Georgia | 13111 | 74 | 1 |
256140 | 256140 | 2020-06-20 | Fannin | Georgia | 13111 | 75 | 1 |
259267 | 259267 | 2020-06-21 | Fannin | Georgia | 13111 | 75 | 1 |
262394 | 262394 | 2020-06-22 | Fannin | Georgia | 13111 | 79 | 1 |
265522 | 265522 | 2020-06-23 | Fannin | Georgia | 13111 | 82 | 1 |
268652 | 268652 | 2020-06-24 | Fannin | Georgia | 13111 | 92 | 1 |
271788 | 271788 | 2020-06-25 | Fannin | Georgia | 13111 | 94 | 1 |
274928 | 274928 | 2020-06-26 | Fannin | Georgia | 13111 | 94 | 1 |
278076 | 278076 | 2020-06-27 | Fannin | Georgia | 13111 | 94 | 1 |
281223 | 281223 | 2020-06-28 | Fannin | Georgia | 13111 | 94 | 1 |
284369 | 284369 | 2020-06-29 | Fannin | Georgia | 13111 | 94 | 1 |
287515 | 287515 | 2020-06-30 | Fannin | Georgia | 13111 | 97 | 1 |
290666 | 290666 | 2020-07-01 | Fannin | Georgia | 13111 | 101 | 1 |
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);