ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Autauga" and state = "Alabama" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9481 | 9481 | 2020-03-24 | Autauga | Alabama | 1001 | 1 | 0 |
10836 | 10836 | 2020-03-25 | Autauga | Alabama | 1001 | 4 | 0 |
12368 | 12368 | 2020-03-26 | Autauga | Alabama | 1001 | 6 | 0 |
14026 | 14026 | 2020-03-27 | Autauga | Alabama | 1001 | 6 | 0 |
15804 | 15804 | 2020-03-28 | Autauga | Alabama | 1001 | 6 | 0 |
17687 | 17687 | 2020-03-29 | Autauga | Alabama | 1001 | 6 | 0 |
19656 | 19656 | 2020-03-30 | Autauga | Alabama | 1001 | 7 | 0 |
21728 | 21728 | 2020-03-31 | Autauga | Alabama | 1001 | 7 | 0 |
23881 | 23881 | 2020-04-01 | Autauga | Alabama | 1001 | 10 | 0 |
26102 | 26102 | 2020-04-02 | Autauga | Alabama | 1001 | 10 | 0 |
28397 | 28397 | 2020-04-03 | Autauga | Alabama | 1001 | 12 | 0 |
30754 | 30754 | 2020-04-04 | Autauga | Alabama | 1001 | 12 | 0 |
33158 | 33158 | 2020-04-05 | Autauga | Alabama | 1001 | 12 | 0 |
35597 | 35597 | 2020-04-06 | Autauga | Alabama | 1001 | 12 | 1 |
38085 | 38085 | 2020-04-07 | Autauga | Alabama | 1001 | 12 | 1 |
40627 | 40627 | 2020-04-08 | Autauga | Alabama | 1001 | 12 | 1 |
43200 | 43200 | 2020-04-09 | Autauga | Alabama | 1001 | 17 | 1 |
45798 | 45798 | 2020-04-10 | Autauga | Alabama | 1001 | 17 | 1 |
48427 | 48427 | 2020-04-11 | Autauga | Alabama | 1001 | 19 | 1 |
51088 | 51088 | 2020-04-12 | Autauga | Alabama | 1001 | 19 | 1 |
53766 | 53766 | 2020-04-13 | Autauga | Alabama | 1001 | 19 | 1 |
56458 | 56458 | 2020-04-14 | Autauga | Alabama | 1001 | 23 | 1 |
59166 | 59166 | 2020-04-15 | Autauga | Alabama | 1001 | 25 | 1 |
61884 | 61884 | 2020-04-16 | Autauga | Alabama | 1001 | 25 | 2 |
64617 | 64617 | 2020-04-17 | Autauga | Alabama | 1001 | 26 | 2 |
67365 | 67365 | 2020-04-18 | Autauga | Alabama | 1001 | 25 | 2 |
70127 | 70127 | 2020-04-19 | Autauga | Alabama | 1001 | 27 | 2 |
72896 | 72896 | 2020-04-20 | Autauga | Alabama | 1001 | 28 | 1 |
75672 | 75672 | 2020-04-21 | Autauga | Alabama | 1001 | 30 | 1 |
78455 | 78455 | 2020-04-22 | Autauga | Alabama | 1001 | 32 | 2 |
81248 | 81248 | 2020-04-23 | Autauga | Alabama | 1001 | 33 | 2 |
84049 | 84049 | 2020-04-24 | Autauga | Alabama | 1001 | 36 | 2 |
86857 | 86857 | 2020-04-25 | Autauga | Alabama | 1001 | 37 | 2 |
89673 | 89673 | 2020-04-26 | Autauga | Alabama | 1001 | 37 | 2 |
92491 | 92491 | 2020-04-27 | Autauga | Alabama | 1001 | 39 | 3 |
95321 | 95321 | 2020-04-28 | Autauga | Alabama | 1001 | 40 | 4 |
98166 | 98166 | 2020-04-29 | Autauga | Alabama | 1001 | 43 | 4 |
101016 | 101016 | 2020-04-30 | Autauga | Alabama | 1001 | 42 | 4 |
103871 | 103871 | 2020-05-01 | Autauga | Alabama | 1001 | 42 | 3 |
106736 | 106736 | 2020-05-02 | Autauga | Alabama | 1001 | 45 | 3 |
109605 | 109605 | 2020-05-03 | Autauga | Alabama | 1001 | 48 | 3 |
112480 | 112480 | 2020-05-04 | Autauga | Alabama | 1001 | 53 | 3 |
115363 | 115363 | 2020-05-05 | Autauga | Alabama | 1001 | 53 | 3 |
118322 | 118322 | 2020-05-06 | Autauga | Alabama | 1001 | 58 | 3 |
121288 | 121288 | 2020-05-07 | Autauga | Alabama | 1001 | 61 | 3 |
124268 | 124268 | 2020-05-08 | Autauga | Alabama | 1001 | 67 | 4 |
127253 | 127253 | 2020-05-09 | Autauga | Alabama | 1001 | 68 | 4 |
130243 | 130243 | 2020-05-10 | Autauga | Alabama | 1001 | 74 | 4 |
133233 | 133233 | 2020-05-11 | Autauga | Alabama | 1001 | 84 | 4 |
136223 | 136223 | 2020-05-12 | Autauga | Alabama | 1001 | 91 | 4 |
139214 | 139214 | 2020-05-13 | Autauga | Alabama | 1001 | 93 | 4 |
142210 | 142210 | 2020-05-14 | Autauga | Alabama | 1001 | 104 | 4 |
145209 | 145209 | 2020-05-15 | Autauga | Alabama | 1001 | 103 | 4 |
148212 | 148212 | 2020-05-16 | Autauga | Alabama | 1001 | 110 | 4 |
151221 | 151221 | 2020-05-17 | Autauga | Alabama | 1001 | 110 | 4 |
154233 | 154233 | 2020-05-18 | Autauga | Alabama | 1001 | 120 | 4 |
157249 | 157249 | 2020-05-19 | Autauga | Alabama | 1001 | 127 | 4 |
160273 | 160273 | 2020-05-20 | Autauga | Alabama | 1001 | 136 | 3 |
163301 | 163301 | 2020-05-21 | Autauga | Alabama | 1001 | 147 | 3 |
166333 | 166333 | 2020-05-22 | Autauga | Alabama | 1001 | 149 | 3 |
169369 | 169369 | 2020-05-23 | Autauga | Alabama | 1001 | 155 | 3 |
172410 | 172410 | 2020-05-24 | Autauga | Alabama | 1001 | 159 | 3 |
175453 | 175453 | 2020-05-25 | Autauga | Alabama | 1001 | 168 | 3 |
178498 | 178498 | 2020-05-26 | Autauga | Alabama | 1001 | 189 | 3 |
181542 | 181542 | 2020-05-27 | Autauga | Alabama | 1001 | 192 | 3 |
184594 | 184594 | 2020-05-28 | Autauga | Alabama | 1001 | 205 | 3 |
187651 | 187651 | 2020-05-29 | Autauga | Alabama | 1001 | 212 | 3 |
190715 | 190715 | 2020-05-30 | Autauga | Alabama | 1001 | 216 | 4 |
193781 | 193781 | 2020-05-31 | Autauga | Alabama | 1001 | 221 | 4 |
196851 | 196851 | 2020-06-01 | Autauga | Alabama | 1001 | 234 | 5 |
199924 | 199924 | 2020-06-02 | Autauga | Alabama | 1001 | 240 | 5 |
203000 | 203000 | 2020-06-03 | Autauga | Alabama | 1001 | 240 | 5 |
206079 | 206079 | 2020-06-04 | Autauga | Alabama | 1001 | 242 | 5 |
209161 | 209161 | 2020-06-05 | Autauga | Alabama | 1001 | 249 | 5 |
212246 | 212246 | 2020-06-06 | Autauga | Alabama | 1001 | 260 | 5 |
215333 | 215333 | 2020-06-07 | Autauga | Alabama | 1001 | 266 | 5 |
218423 | 218423 | 2020-06-08 | Autauga | Alabama | 1001 | 273 | 5 |
221515 | 221515 | 2020-06-09 | Autauga | Alabama | 1001 | 283 | 5 |
224611 | 224611 | 2020-06-10 | Autauga | Alabama | 1001 | 296 | 6 |
227712 | 227712 | 2020-06-11 | Autauga | Alabama | 1001 | 316 | 6 |
230816 | 230816 | 2020-06-12 | Autauga | Alabama | 1001 | 327 | 6 |
233921 | 233921 | 2020-06-13 | Autauga | Alabama | 1001 | 335 | 6 |
237028 | 237028 | 2020-06-14 | Autauga | Alabama | 1001 | 361 | 6 |
240136 | 240136 | 2020-06-15 | Autauga | Alabama | 1001 | 368 | 6 |
243247 | 243247 | 2020-06-16 | Autauga | Alabama | 1001 | 373 | 7 |
246360 | 246360 | 2020-06-17 | Autauga | Alabama | 1001 | 375 | 7 |
249472 | 249472 | 2020-06-18 | Autauga | Alabama | 1001 | 400 | 8 |
252587 | 252587 | 2020-06-19 | Autauga | Alabama | 1001 | 411 | 8 |
255706 | 255706 | 2020-06-20 | Autauga | Alabama | 1001 | 431 | 9 |
258833 | 258833 | 2020-06-21 | Autauga | Alabama | 1001 | 434 | 9 |
261960 | 261960 | 2020-06-22 | Autauga | Alabama | 1001 | 442 | 9 |
265089 | 265089 | 2020-06-23 | Autauga | Alabama | 1001 | 453 | 9 |
268218 | 268218 | 2020-06-24 | Autauga | Alabama | 1001 | 469 | 11 |
271352 | 271352 | 2020-06-25 | Autauga | Alabama | 1001 | 479 | 11 |
274492 | 274492 | 2020-06-26 | Autauga | Alabama | 1001 | 488 | 11 |
277640 | 277640 | 2020-06-27 | Autauga | Alabama | 1001 | 498 | 12 |
280788 | 280788 | 2020-06-28 | Autauga | Alabama | 1001 | 503 | 12 |
283934 | 283934 | 2020-06-29 | Autauga | Alabama | 1001 | 527 | 12 |
287080 | 287080 | 2020-06-30 | Autauga | Alabama | 1001 | 537 | 12 |
290230 | 290230 | 2020-07-01 | Autauga | Alabama | 1001 | 553 | 12 |
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);