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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5947 | 5947 | 2020-03-20 | Fannin | Texas | 48147 | 1 | 0 |
6967 | 6967 | 2020-03-21 | Fannin | Texas | 48147 | 1 | 0 |
8097 | 8097 | 2020-03-22 | Fannin | Texas | 48147 | 1 | 0 |
9315 | 9315 | 2020-03-23 | Fannin | Texas | 48147 | 1 | 0 |
9730 | 9730 | 2020-03-24 | Fannin | Georgia | 13111 | 1 | 0 |
10652 | 10652 | 2020-03-24 | Fannin | Texas | 48147 | 1 | 0 |
11107 | 11107 | 2020-03-25 | Fannin | Georgia | 13111 | 1 | 0 |
12139 | 12139 | 2020-03-25 | Fannin | Texas | 48147 | 1 | 0 |
12656 | 12656 | 2020-03-26 | Fannin | Georgia | 13111 | 1 | 0 |
13768 | 13768 | 2020-03-26 | Fannin | Texas | 48147 | 1 | 0 |
14328 | 14328 | 2020-03-27 | Fannin | Georgia | 13111 | 3 | 0 |
15522 | 15522 | 2020-03-27 | Fannin | Texas | 48147 | 1 | 0 |
16114 | 16114 | 2020-03-28 | Fannin | Georgia | 13111 | 3 | 0 |
17391 | 17391 | 2020-03-28 | Fannin | Texas | 48147 | 1 | 0 |
18011 | 18011 | 2020-03-29 | Fannin | Georgia | 13111 | 3 | 0 |
19343 | 19343 | 2020-03-29 | Fannin | Texas | 48147 | 1 | 0 |
20000 | 20000 | 2020-03-30 | Fannin | Georgia | 13111 | 3 | 0 |
21402 | 21402 | 2020-03-30 | Fannin | Texas | 48147 | 1 | 0 |
22080 | 22080 | 2020-03-31 | Fannin | Georgia | 13111 | 4 | 0 |
23541 | 23541 | 2020-03-31 | Fannin | Texas | 48147 | 1 | 0 |
24243 | 24243 | 2020-04-01 | Fannin | Georgia | 13111 | 6 | 0 |
25749 | 25749 | 2020-04-01 | Fannin | Texas | 48147 | 1 | 0 |
26474 | 26474 | 2020-04-02 | Fannin | Georgia | 13111 | 8 | 0 |
28030 | 28030 | 2020-04-02 | Fannin | Texas | 48147 | 1 | 0 |
28778 | 28778 | 2020-04-03 | Fannin | Georgia | 13111 | 8 | 0 |
30365 | 30365 | 2020-04-03 | Fannin | Texas | 48147 | 2 | 0 |
31138 | 31138 | 2020-04-04 | Fannin | Georgia | 13111 | 8 | 0 |
32758 | 32758 | 2020-04-04 | Fannin | Texas | 48147 | 2 | 0 |
33545 | 33545 | 2020-04-05 | Fannin | Georgia | 13111 | 8 | 0 |
35196 | 35196 | 2020-04-05 | Fannin | Texas | 48147 | 2 | 0 |
35994 | 35994 | 2020-04-06 | Fannin | Georgia | 13111 | 10 | 0 |
37672 | 37672 | 2020-04-06 | Fannin | Texas | 48147 | 2 | 0 |
38486 | 38486 | 2020-04-07 | Fannin | Georgia | 13111 | 10 | 0 |
40197 | 40197 | 2020-04-07 | Fannin | Texas | 48147 | 2 | 0 |
41030 | 41030 | 2020-04-08 | Fannin | Georgia | 13111 | 9 | 0 |
42762 | 42762 | 2020-04-08 | Fannin | Texas | 48147 | 2 | 0 |
43604 | 43604 | 2020-04-09 | Fannin | Georgia | 13111 | 9 | 0 |
45351 | 45351 | 2020-04-09 | Fannin | Texas | 48147 | 4 | 0 |
46206 | 46206 | 2020-04-10 | Fannin | Georgia | 13111 | 9 | 0 |
47971 | 47971 | 2020-04-10 | Fannin | Texas | 48147 | 5 | 0 |
48836 | 48836 | 2020-04-11 | Fannin | Georgia | 13111 | 9 | 0 |
50629 | 50629 | 2020-04-11 | Fannin | Texas | 48147 | 5 | 0 |
51498 | 51498 | 2020-04-12 | Fannin | Georgia | 13111 | 9 | 0 |
53304 | 53304 | 2020-04-12 | Fannin | Texas | 48147 | 5 | 0 |
54178 | 54178 | 2020-04-13 | Fannin | Georgia | 13111 | 12 | 0 |
55992 | 55992 | 2020-04-13 | Fannin | Texas | 48147 | 5 | 0 |
56870 | 56870 | 2020-04-14 | Fannin | Georgia | 13111 | 13 | 0 |
58697 | 58697 | 2020-04-14 | Fannin | Texas | 48147 | 5 | 0 |
59577 | 59577 | 2020-04-15 | Fannin | Georgia | 13111 | 14 | 0 |
61414 | 61414 | 2020-04-15 | Fannin | Texas | 48147 | 5 | 0 |
62297 | 62297 | 2020-04-16 | Fannin | Georgia | 13111 | 14 | 0 |
64141 | 64141 | 2020-04-16 | Fannin | Texas | 48147 | 5 | 0 |
65030 | 65030 | 2020-04-17 | Fannin | Georgia | 13111 | 15 | 0 |
66888 | 66888 | 2020-04-17 | Fannin | Texas | 48147 | 5 | 0 |
67778 | 67778 | 2020-04-18 | Fannin | Georgia | 13111 | 15 | 0 |
69648 | 69648 | 2020-04-18 | Fannin | Texas | 48147 | 7 | 0 |
70540 | 70540 | 2020-04-19 | Fannin | Georgia | 13111 | 16 | 0 |
72416 | 72416 | 2020-04-19 | Fannin | Texas | 48147 | 7 | 0 |
73309 | 73309 | 2020-04-20 | Fannin | Georgia | 13111 | 19 | 1 |
75191 | 75191 | 2020-04-20 | Fannin | Texas | 48147 | 8 | 0 |
76085 | 76085 | 2020-04-21 | Fannin | Georgia | 13111 | 19 | 1 |
77973 | 77973 | 2020-04-21 | Fannin | Texas | 48147 | 9 | 0 |
78869 | 78869 | 2020-04-22 | Fannin | Georgia | 13111 | 20 | 0 |
80764 | 80764 | 2020-04-22 | Fannin | Texas | 48147 | 12 | 0 |
81662 | 81662 | 2020-04-23 | Fannin | Georgia | 13111 | 20 | 0 |
83564 | 83564 | 2020-04-23 | Fannin | Texas | 48147 | 13 | 0 |
84462 | 84462 | 2020-04-24 | Fannin | Georgia | 13111 | 21 | 0 |
86369 | 86369 | 2020-04-24 | Fannin | Texas | 48147 | 13 | 0 |
87271 | 87271 | 2020-04-25 | Fannin | Georgia | 13111 | 21 | 0 |
89184 | 89184 | 2020-04-25 | Fannin | Texas | 48147 | 15 | 0 |
90087 | 90087 | 2020-04-26 | Fannin | Georgia | 13111 | 23 | 0 |
92001 | 92001 | 2020-04-26 | Fannin | Texas | 48147 | 15 | 0 |
92906 | 92906 | 2020-04-27 | Fannin | Georgia | 13111 | 24 | 0 |
94830 | 94830 | 2020-04-27 | Fannin | Texas | 48147 | 16 | 0 |
95738 | 95738 | 2020-04-28 | Fannin | Georgia | 13111 | 27 | 1 |
97670 | 97670 | 2020-04-28 | Fannin | Texas | 48147 | 17 | 0 |
98583 | 98583 | 2020-04-29 | Fannin | Georgia | 13111 | 28 | 1 |
100520 | 100520 | 2020-04-29 | Fannin | Texas | 48147 | 18 | 0 |
101433 | 101433 | 2020-04-30 | Fannin | Georgia | 13111 | 29 | 1 |
103373 | 103373 | 2020-04-30 | Fannin | Texas | 48147 | 18 | 0 |
104288 | 104288 | 2020-05-01 | Fannin | Georgia | 13111 | 30 | 1 |
106237 | 106237 | 2020-05-01 | Fannin | Texas | 48147 | 18 | 0 |
107153 | 107153 | 2020-05-02 | Fannin | Georgia | 13111 | 31 | 1 |
109106 | 109106 | 2020-05-02 | Fannin | Texas | 48147 | 19 | 0 |
110022 | 110022 | 2020-05-03 | Fannin | Georgia | 13111 | 31 | 1 |
111980 | 111980 | 2020-05-03 | Fannin | Texas | 48147 | 19 | 0 |
112897 | 112897 | 2020-05-04 | Fannin | Georgia | 13111 | 32 | 1 |
114862 | 114862 | 2020-05-04 | Fannin | Texas | 48147 | 20 | 0 |
115780 | 115780 | 2020-05-05 | Fannin | Georgia | 13111 | 32 | 1 |
117821 | 117821 | 2020-05-05 | Fannin | Texas | 48147 | 20 | 0 |
118740 | 118740 | 2020-05-06 | Fannin | Georgia | 13111 | 33 | 1 |
120785 | 120785 | 2020-05-06 | Fannin | Texas | 48147 | 22 | 1 |
121709 | 121709 | 2020-05-07 | Fannin | Georgia | 13111 | 34 | 1 |
123764 | 123764 | 2020-05-07 | Fannin | Texas | 48147 | 23 | 1 |
124688 | 124688 | 2020-05-08 | Fannin | Georgia | 13111 | 34 | 1 |
126747 | 126747 | 2020-05-08 | Fannin | Texas | 48147 | 23 | 1 |
127675 | 127675 | 2020-05-09 | Fannin | Georgia | 13111 | 34 | 1 |
129736 | 129736 | 2020-05-09 | Fannin | Texas | 48147 | 23 | 1 |
130666 | 130666 | 2020-05-10 | Fannin | Georgia | 13111 | 34 | 1 |
132726 | 132726 | 2020-05-10 | Fannin | Texas | 48147 | 23 | 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);