ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 13285 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2863 | 2863 | 2020-03-16 | Troup | Georgia | 13285 | 1 | 0 |
3349 | 3349 | 2020-03-17 | Troup | Georgia | 13285 | 2 | 0 |
3911 | 3911 | 2020-03-18 | Troup | Georgia | 13285 | 2 | 0 |
4587 | 4587 | 2020-03-19 | Troup | Georgia | 13285 | 2 | 0 |
5384 | 5384 | 2020-03-20 | Troup | Georgia | 13285 | 2 | 0 |
6318 | 6318 | 2020-03-21 | Troup | Georgia | 13285 | 4 | 0 |
7365 | 7365 | 2020-03-22 | Troup | Georgia | 13285 | 4 | 0 |
8518 | 8518 | 2020-03-23 | Troup | Georgia | 13285 | 4 | 0 |
9779 | 9779 | 2020-03-24 | Troup | Georgia | 13285 | 6 | 0 |
11161 | 11161 | 2020-03-25 | Troup | Georgia | 13285 | 7 | 0 |
12714 | 12714 | 2020-03-26 | Troup | Georgia | 13285 | 10 | 0 |
14388 | 14388 | 2020-03-27 | Troup | Georgia | 13285 | 11 | 1 |
16177 | 16177 | 2020-03-28 | Troup | Georgia | 13285 | 9 | 1 |
18074 | 18074 | 2020-03-29 | Troup | Georgia | 13285 | 10 | 1 |
20069 | 20069 | 2020-03-30 | Troup | Georgia | 13285 | 15 | 1 |
22154 | 22154 | 2020-03-31 | Troup | Georgia | 13285 | 18 | 1 |
24319 | 24319 | 2020-04-01 | Troup | Georgia | 13285 | 19 | 1 |
26551 | 26551 | 2020-04-02 | Troup | Georgia | 13285 | 21 | 1 |
28858 | 28858 | 2020-04-03 | Troup | Georgia | 13285 | 30 | 1 |
31218 | 31218 | 2020-04-04 | Troup | Georgia | 13285 | 33 | 1 |
33625 | 33625 | 2020-04-05 | Troup | Georgia | 13285 | 34 | 1 |
36076 | 36076 | 2020-04-06 | Troup | Georgia | 13285 | 36 | 2 |
38569 | 38569 | 2020-04-07 | Troup | Georgia | 13285 | 47 | 3 |
41113 | 41113 | 2020-04-08 | Troup | Georgia | 13285 | 49 | 3 |
43687 | 43687 | 2020-04-09 | Troup | Georgia | 13285 | 54 | 3 |
46289 | 46289 | 2020-04-10 | Troup | Georgia | 13285 | 56 | 3 |
48920 | 48920 | 2020-04-11 | Troup | Georgia | 13285 | 57 | 3 |
51582 | 51582 | 2020-04-12 | Troup | Georgia | 13285 | 60 | 3 |
54262 | 54262 | 2020-04-13 | Troup | Georgia | 13285 | 62 | 3 |
56954 | 56954 | 2020-04-14 | Troup | Georgia | 13285 | 68 | 4 |
59661 | 59661 | 2020-04-15 | Troup | Georgia | 13285 | 72 | 4 |
62381 | 62381 | 2020-04-16 | Troup | Georgia | 13285 | 77 | 4 |
65114 | 65114 | 2020-04-17 | Troup | Georgia | 13285 | 80 | 4 |
67862 | 67862 | 2020-04-18 | Troup | Georgia | 13285 | 86 | 4 |
70624 | 70624 | 2020-04-19 | Troup | Georgia | 13285 | 92 | 4 |
73393 | 73393 | 2020-04-20 | Troup | Georgia | 13285 | 100 | 4 |
76169 | 76169 | 2020-04-21 | Troup | Georgia | 13285 | 107 | 4 |
78953 | 78953 | 2020-04-22 | Troup | Georgia | 13285 | 109 | 4 |
81746 | 81746 | 2020-04-23 | Troup | Georgia | 13285 | 118 | 4 |
84546 | 84546 | 2020-04-24 | Troup | Georgia | 13285 | 122 | 4 |
87355 | 87355 | 2020-04-25 | Troup | Georgia | 13285 | 122 | 4 |
90171 | 90171 | 2020-04-26 | Troup | Georgia | 13285 | 126 | 4 |
92990 | 92990 | 2020-04-27 | Troup | Georgia | 13285 | 138 | 4 |
95822 | 95822 | 2020-04-28 | Troup | Georgia | 13285 | 140 | 4 |
98667 | 98667 | 2020-04-29 | Troup | Georgia | 13285 | 145 | 4 |
101517 | 101517 | 2020-04-30 | Troup | Georgia | 13285 | 148 | 4 |
104372 | 104372 | 2020-05-01 | Troup | Georgia | 13285 | 150 | 4 |
107237 | 107237 | 2020-05-02 | Troup | Georgia | 13285 | 154 | 4 |
110107 | 110107 | 2020-05-03 | Troup | Georgia | 13285 | 154 | 4 |
112982 | 112982 | 2020-05-04 | Troup | Georgia | 13285 | 159 | 5 |
115865 | 115865 | 2020-05-05 | Troup | Georgia | 13285 | 163 | 5 |
118825 | 118825 | 2020-05-06 | Troup | Georgia | 13285 | 168 | 5 |
121795 | 121795 | 2020-05-07 | Troup | Georgia | 13285 | 173 | 5 |
124774 | 124774 | 2020-05-08 | Troup | Georgia | 13285 | 177 | 5 |
127761 | 127761 | 2020-05-09 | Troup | Georgia | 13285 | 185 | 5 |
130752 | 130752 | 2020-05-10 | Troup | Georgia | 13285 | 186 | 5 |
133743 | 133743 | 2020-05-11 | Troup | Georgia | 13285 | 190 | 5 |
136732 | 136732 | 2020-05-12 | Troup | Georgia | 13285 | 196 | 5 |
139723 | 139723 | 2020-05-13 | Troup | Georgia | 13285 | 192 | 5 |
142719 | 142719 | 2020-05-14 | Troup | Georgia | 13285 | 192 | 5 |
145719 | 145719 | 2020-05-15 | Troup | Georgia | 13285 | 195 | 6 |
148722 | 148722 | 2020-05-16 | Troup | Georgia | 13285 | 199 | 6 |
151731 | 151731 | 2020-05-17 | Troup | Georgia | 13285 | 200 | 6 |
154743 | 154743 | 2020-05-18 | Troup | Georgia | 13285 | 201 | 6 |
157759 | 157759 | 2020-05-19 | Troup | Georgia | 13285 | 213 | 6 |
160785 | 160785 | 2020-05-20 | Troup | Georgia | 13285 | 215 | 6 |
163813 | 163813 | 2020-05-21 | Troup | Georgia | 13285 | 227 | 8 |
166846 | 166846 | 2020-05-22 | Troup | Georgia | 13285 | 238 | 9 |
169883 | 169883 | 2020-05-23 | Troup | Georgia | 13285 | 245 | 9 |
172924 | 172924 | 2020-05-24 | Troup | Georgia | 13285 | 250 | 9 |
175967 | 175967 | 2020-05-25 | Troup | Georgia | 13285 | 260 | 9 |
179011 | 179011 | 2020-05-26 | Troup | Georgia | 13285 | 268 | 10 |
182055 | 182055 | 2020-05-27 | Troup | Georgia | 13285 | 268 | 10 |
185109 | 185109 | 2020-05-28 | Troup | Georgia | 13285 | 283 | 10 |
188165 | 188165 | 2020-05-29 | Troup | Georgia | 13285 | 292 | 10 |
191230 | 191230 | 2020-05-30 | Troup | Georgia | 13285 | 307 | 11 |
194297 | 194297 | 2020-05-31 | Troup | Georgia | 13285 | 313 | 11 |
197367 | 197367 | 2020-06-01 | Troup | Georgia | 13285 | 318 | 11 |
200440 | 200440 | 2020-06-02 | Troup | Georgia | 13285 | 320 | 11 |
203516 | 203516 | 2020-06-03 | Troup | Georgia | 13285 | 345 | 11 |
206596 | 206596 | 2020-06-04 | Troup | Georgia | 13285 | 363 | 11 |
209677 | 209677 | 2020-06-05 | Troup | Georgia | 13285 | 395 | 11 |
212762 | 212762 | 2020-06-06 | Troup | Georgia | 13285 | 416 | 11 |
215849 | 215849 | 2020-06-07 | Troup | Georgia | 13285 | 426 | 11 |
218940 | 218940 | 2020-06-08 | Troup | Georgia | 13285 | 446 | 11 |
222035 | 222035 | 2020-06-09 | Troup | Georgia | 13285 | 476 | 11 |
225130 | 225130 | 2020-06-10 | Troup | Georgia | 13285 | 545 | 12 |
228232 | 228232 | 2020-06-11 | Troup | Georgia | 13285 | 613 | 13 |
231335 | 231335 | 2020-06-12 | Troup | Georgia | 13285 | 701 | 22 |
234441 | 234441 | 2020-06-13 | Troup | Georgia | 13285 | 733 | 23 |
237548 | 237548 | 2020-06-14 | Troup | Georgia | 13285 | 759 | 23 |
240656 | 240656 | 2020-06-15 | Troup | Georgia | 13285 | 792 | 23 |
243767 | 243767 | 2020-06-16 | Troup | Georgia | 13285 | 805 | 23 |
246880 | 246880 | 2020-06-17 | Troup | Georgia | 13285 | 844 | 25 |
249992 | 249992 | 2020-06-18 | Troup | Georgia | 13285 | 863 | 24 |
253107 | 253107 | 2020-06-19 | Troup | Georgia | 13285 | 922 | 25 |
256226 | 256226 | 2020-06-20 | Troup | Georgia | 13285 | 947 | 26 |
259353 | 259353 | 2020-06-21 | Troup | Georgia | 13285 | 978 | 26 |
262480 | 262480 | 2020-06-22 | Troup | Georgia | 13285 | 1027 | 28 |
265608 | 265608 | 2020-06-23 | Troup | Georgia | 13285 | 1158 | 29 |
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);