ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Decatur" and state = "Georgia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11101 | 11101 | 2020-03-25 | Decatur | Georgia | 13087 | 1 | 0 |
12650 | 12650 | 2020-03-26 | Decatur | Georgia | 13087 | 2 | 0 |
14322 | 14322 | 2020-03-27 | Decatur | Georgia | 13087 | 3 | 0 |
16108 | 16108 | 2020-03-28 | Decatur | Georgia | 13087 | 4 | 0 |
18005 | 18005 | 2020-03-29 | Decatur | Georgia | 13087 | 4 | 0 |
19993 | 19993 | 2020-03-30 | Decatur | Georgia | 13087 | 6 | 0 |
22072 | 22072 | 2020-03-31 | Decatur | Georgia | 13087 | 8 | 0 |
24235 | 24235 | 2020-04-01 | Decatur | Georgia | 13087 | 8 | 0 |
26466 | 26466 | 2020-04-02 | Decatur | Georgia | 13087 | 10 | 0 |
28769 | 28769 | 2020-04-03 | Decatur | Georgia | 13087 | 16 | 0 |
31129 | 31129 | 2020-04-04 | Decatur | Georgia | 13087 | 16 | 0 |
33536 | 33536 | 2020-04-05 | Decatur | Georgia | 13087 | 17 | 0 |
35984 | 35984 | 2020-04-06 | Decatur | Georgia | 13087 | 13 | 0 |
38476 | 38476 | 2020-04-07 | Decatur | Georgia | 13087 | 21 | 0 |
41020 | 41020 | 2020-04-08 | Decatur | Georgia | 13087 | 22 | 0 |
43594 | 43594 | 2020-04-09 | Decatur | Georgia | 13087 | 25 | 0 |
46196 | 46196 | 2020-04-10 | Decatur | Georgia | 13087 | 27 | 0 |
48826 | 48826 | 2020-04-11 | Decatur | Georgia | 13087 | 28 | 0 |
51487 | 51487 | 2020-04-12 | Decatur | Georgia | 13087 | 29 | 0 |
54167 | 54167 | 2020-04-13 | Decatur | Georgia | 13087 | 39 | 0 |
56859 | 56859 | 2020-04-14 | Decatur | Georgia | 13087 | 46 | 0 |
59566 | 59566 | 2020-04-15 | Decatur | Georgia | 13087 | 51 | 0 |
62286 | 62286 | 2020-04-16 | Decatur | Georgia | 13087 | 55 | 0 |
65019 | 65019 | 2020-04-17 | Decatur | Georgia | 13087 | 55 | 0 |
67767 | 67767 | 2020-04-18 | Decatur | Georgia | 13087 | 55 | 0 |
70529 | 70529 | 2020-04-19 | Decatur | Georgia | 13087 | 62 | 1 |
73298 | 73298 | 2020-04-20 | Decatur | Georgia | 13087 | 60 | 1 |
76074 | 76074 | 2020-04-21 | Decatur | Georgia | 13087 | 53 | 1 |
78858 | 78858 | 2020-04-22 | Decatur | Georgia | 13087 | 50 | 1 |
81651 | 81651 | 2020-04-23 | Decatur | Georgia | 13087 | 61 | 1 |
84451 | 84451 | 2020-04-24 | Decatur | Georgia | 13087 | 59 | 1 |
87260 | 87260 | 2020-04-25 | Decatur | Georgia | 13087 | 60 | 1 |
90076 | 90076 | 2020-04-26 | Decatur | Georgia | 13087 | 60 | 1 |
92895 | 92895 | 2020-04-27 | Decatur | Georgia | 13087 | 64 | 1 |
95727 | 95727 | 2020-04-28 | Decatur | Georgia | 13087 | 66 | 1 |
98572 | 98572 | 2020-04-29 | Decatur | Georgia | 13087 | 81 | 1 |
101422 | 101422 | 2020-04-30 | Decatur | Georgia | 13087 | 83 | 1 |
104277 | 104277 | 2020-05-01 | Decatur | Georgia | 13087 | 87 | 1 |
107142 | 107142 | 2020-05-02 | Decatur | Georgia | 13087 | 90 | 1 |
110011 | 110011 | 2020-05-03 | Decatur | Georgia | 13087 | 91 | 1 |
112886 | 112886 | 2020-05-04 | Decatur | Georgia | 13087 | 94 | 1 |
115769 | 115769 | 2020-05-05 | Decatur | Georgia | 13087 | 96 | 2 |
118729 | 118729 | 2020-05-06 | Decatur | Georgia | 13087 | 105 | 2 |
121698 | 121698 | 2020-05-07 | Decatur | Georgia | 13087 | 105 | 2 |
124677 | 124677 | 2020-05-08 | Decatur | Georgia | 13087 | 109 | 2 |
127664 | 127664 | 2020-05-09 | Decatur | Georgia | 13087 | 109 | 2 |
130655 | 130655 | 2020-05-10 | Decatur | Georgia | 13087 | 109 | 2 |
133646 | 133646 | 2020-05-11 | Decatur | Georgia | 13087 | 109 | 3 |
136635 | 136635 | 2020-05-12 | Decatur | Georgia | 13087 | 113 | 3 |
139626 | 139626 | 2020-05-13 | Decatur | Georgia | 13087 | 115 | 3 |
142622 | 142622 | 2020-05-14 | Decatur | Georgia | 13087 | 115 | 3 |
145622 | 145622 | 2020-05-15 | Decatur | Georgia | 13087 | 116 | 3 |
148625 | 148625 | 2020-05-16 | Decatur | Georgia | 13087 | 116 | 3 |
151634 | 151634 | 2020-05-17 | Decatur | Georgia | 13087 | 116 | 3 |
154646 | 154646 | 2020-05-18 | Decatur | Georgia | 13087 | 128 | 4 |
157662 | 157662 | 2020-05-19 | Decatur | Georgia | 13087 | 131 | 4 |
160688 | 160688 | 2020-05-20 | Decatur | Georgia | 13087 | 140 | 4 |
163716 | 163716 | 2020-05-21 | Decatur | Georgia | 13087 | 144 | 4 |
166749 | 166749 | 2020-05-22 | Decatur | Georgia | 13087 | 145 | 4 |
169786 | 169786 | 2020-05-23 | Decatur | Georgia | 13087 | 145 | 4 |
172827 | 172827 | 2020-05-24 | Decatur | Georgia | 13087 | 146 | 4 |
175870 | 175870 | 2020-05-25 | Decatur | Georgia | 13087 | 153 | 4 |
178914 | 178914 | 2020-05-26 | Decatur | Georgia | 13087 | 156 | 4 |
181958 | 181958 | 2020-05-27 | Decatur | Georgia | 13087 | 161 | 4 |
185012 | 185012 | 2020-05-28 | Decatur | Georgia | 13087 | 181 | 4 |
188068 | 188068 | 2020-05-29 | Decatur | Georgia | 13087 | 185 | 4 |
191133 | 191133 | 2020-05-30 | Decatur | Georgia | 13087 | 186 | 4 |
194200 | 194200 | 2020-05-31 | Decatur | Georgia | 13087 | 186 | 5 |
197270 | 197270 | 2020-06-01 | Decatur | Georgia | 13087 | 194 | 5 |
200343 | 200343 | 2020-06-02 | Decatur | Georgia | 13087 | 204 | 5 |
203419 | 203419 | 2020-06-03 | Decatur | Georgia | 13087 | 206 | 5 |
206499 | 206499 | 2020-06-04 | Decatur | Georgia | 13087 | 205 | 6 |
209580 | 209580 | 2020-06-05 | Decatur | Georgia | 13087 | 207 | 6 |
212665 | 212665 | 2020-06-06 | Decatur | Georgia | 13087 | 209 | 6 |
215752 | 215752 | 2020-06-07 | Decatur | Georgia | 13087 | 209 | 6 |
218843 | 218843 | 2020-06-08 | Decatur | Georgia | 13087 | 214 | 6 |
221938 | 221938 | 2020-06-09 | Decatur | Georgia | 13087 | 218 | 6 |
225033 | 225033 | 2020-06-10 | Decatur | Georgia | 13087 | 219 | 7 |
228135 | 228135 | 2020-06-11 | Decatur | Georgia | 13087 | 219 | 7 |
231238 | 231238 | 2020-06-12 | Decatur | Georgia | 13087 | 222 | 7 |
234344 | 234344 | 2020-06-13 | Decatur | Georgia | 13087 | 223 | 7 |
237451 | 237451 | 2020-06-14 | Decatur | Georgia | 13087 | 224 | 7 |
240559 | 240559 | 2020-06-15 | Decatur | Georgia | 13087 | 224 | 8 |
243670 | 243670 | 2020-06-16 | Decatur | Georgia | 13087 | 236 | 8 |
246783 | 246783 | 2020-06-17 | Decatur | Georgia | 13087 | 235 | 8 |
249895 | 249895 | 2020-06-18 | Decatur | Georgia | 13087 | 239 | 8 |
253010 | 253010 | 2020-06-19 | Decatur | Georgia | 13087 | 242 | 8 |
256129 | 256129 | 2020-06-20 | Decatur | Georgia | 13087 | 243 | 8 |
259256 | 259256 | 2020-06-21 | Decatur | Georgia | 13087 | 243 | 8 |
262383 | 262383 | 2020-06-22 | Decatur | Georgia | 13087 | 244 | 8 |
265511 | 265511 | 2020-06-23 | Decatur | Georgia | 13087 | 245 | 8 |
268641 | 268641 | 2020-06-24 | Decatur | Georgia | 13087 | 246 | 8 |
271777 | 271777 | 2020-06-25 | Decatur | Georgia | 13087 | 248 | 8 |
274917 | 274917 | 2020-06-26 | Decatur | Georgia | 13087 | 249 | 8 |
278065 | 278065 | 2020-06-27 | Decatur | Georgia | 13087 | 249 | 8 |
281212 | 281212 | 2020-06-28 | Decatur | Georgia | 13087 | 249 | 8 |
284358 | 284358 | 2020-06-29 | Decatur | Georgia | 13087 | 250 | 8 |
287504 | 287504 | 2020-06-30 | Decatur | Georgia | 13087 | 253 | 8 |
290655 | 290655 | 2020-07-01 | Decatur | Georgia | 13087 | 253 | 8 |
293809 | 293809 | 2020-07-02 | Decatur | Georgia | 13087 | 261 | 8 |
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);