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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382722 | 382722 | 2020-07-30 | Autauga | Alabama | 1001 | 1002 | 21 |
379505 | 379505 | 2020-07-29 | Autauga | Alabama | 1001 | 987 | 21 |
376289 | 376289 | 2020-07-28 | Autauga | Alabama | 1001 | 974 | 21 |
373075 | 373075 | 2020-07-27 | Autauga | Alabama | 1001 | 965 | 21 |
369863 | 369863 | 2020-07-26 | Autauga | Alabama | 1001 | 942 | 21 |
366653 | 366653 | 2020-07-25 | Autauga | Alabama | 1001 | 932 | 21 |
363446 | 363446 | 2020-07-24 | Autauga | Alabama | 1001 | 921 | 21 |
360240 | 360240 | 2020-07-23 | Autauga | Alabama | 1001 | 905 | 21 |
357035 | 357035 | 2020-07-22 | Autauga | Alabama | 1001 | 886 | 21 |
353832 | 353832 | 2020-07-21 | Autauga | Alabama | 1001 | 865 | 21 |
350630 | 350630 | 2020-07-20 | Autauga | Alabama | 1001 | 857 | 21 |
347429 | 347429 | 2020-07-19 | Autauga | Alabama | 1001 | 842 | 21 |
344229 | 344229 | 2020-07-18 | Autauga | Alabama | 1001 | 827 | 21 |
341030 | 341030 | 2020-07-17 | Autauga | Alabama | 1001 | 789 | 21 |
337834 | 337834 | 2020-07-16 | Autauga | Alabama | 1001 | 780 | 20 |
334639 | 334639 | 2020-07-15 | Autauga | Alabama | 1001 | 756 | 19 |
331446 | 331446 | 2020-07-14 | Autauga | Alabama | 1001 | 746 | 18 |
328260 | 328260 | 2020-07-13 | Autauga | Alabama | 1001 | 728 | 16 |
325074 | 325074 | 2020-07-12 | Autauga | Alabama | 1001 | 706 | 16 |
321893 | 321893 | 2020-07-11 | Autauga | Alabama | 1001 | 684 | 15 |
318714 | 318714 | 2020-07-10 | Autauga | Alabama | 1001 | 670 | 15 |
315541 | 315541 | 2020-07-09 | Autauga | Alabama | 1001 | 661 | 14 |
312366 | 312366 | 2020-07-08 | Autauga | Alabama | 1001 | 651 | 13 |
309197 | 309197 | 2020-07-07 | Autauga | Alabama | 1001 | 644 | 13 |
306028 | 306028 | 2020-07-06 | Autauga | Alabama | 1001 | 618 | 13 |
302864 | 302864 | 2020-07-05 | Autauga | Alabama | 1001 | 615 | 13 |
299700 | 299700 | 2020-07-04 | Autauga | Alabama | 1001 | 591 | 13 |
296538 | 296538 | 2020-07-03 | Autauga | Alabama | 1001 | 568 | 13 |
293383 | 293383 | 2020-07-02 | Autauga | Alabama | 1001 | 561 | 13 |
290230 | 290230 | 2020-07-01 | Autauga | Alabama | 1001 | 553 | 12 |
287080 | 287080 | 2020-06-30 | Autauga | Alabama | 1001 | 537 | 12 |
283934 | 283934 | 2020-06-29 | Autauga | Alabama | 1001 | 527 | 12 |
280788 | 280788 | 2020-06-28 | Autauga | Alabama | 1001 | 503 | 12 |
277640 | 277640 | 2020-06-27 | Autauga | Alabama | 1001 | 498 | 12 |
274492 | 274492 | 2020-06-26 | Autauga | Alabama | 1001 | 488 | 11 |
271352 | 271352 | 2020-06-25 | Autauga | Alabama | 1001 | 479 | 11 |
268218 | 268218 | 2020-06-24 | Autauga | Alabama | 1001 | 469 | 11 |
265089 | 265089 | 2020-06-23 | Autauga | Alabama | 1001 | 453 | 9 |
261960 | 261960 | 2020-06-22 | Autauga | Alabama | 1001 | 442 | 9 |
258833 | 258833 | 2020-06-21 | Autauga | Alabama | 1001 | 434 | 9 |
255706 | 255706 | 2020-06-20 | Autauga | Alabama | 1001 | 431 | 9 |
252587 | 252587 | 2020-06-19 | Autauga | Alabama | 1001 | 411 | 8 |
249472 | 249472 | 2020-06-18 | Autauga | Alabama | 1001 | 400 | 8 |
246360 | 246360 | 2020-06-17 | Autauga | Alabama | 1001 | 375 | 7 |
243247 | 243247 | 2020-06-16 | Autauga | Alabama | 1001 | 373 | 7 |
240136 | 240136 | 2020-06-15 | Autauga | Alabama | 1001 | 368 | 6 |
237028 | 237028 | 2020-06-14 | Autauga | Alabama | 1001 | 361 | 6 |
233921 | 233921 | 2020-06-13 | Autauga | Alabama | 1001 | 335 | 6 |
230816 | 230816 | 2020-06-12 | Autauga | Alabama | 1001 | 327 | 6 |
227712 | 227712 | 2020-06-11 | Autauga | Alabama | 1001 | 316 | 6 |
224611 | 224611 | 2020-06-10 | Autauga | Alabama | 1001 | 296 | 6 |
221515 | 221515 | 2020-06-09 | Autauga | Alabama | 1001 | 283 | 5 |
218423 | 218423 | 2020-06-08 | Autauga | Alabama | 1001 | 273 | 5 |
215333 | 215333 | 2020-06-07 | Autauga | Alabama | 1001 | 266 | 5 |
212246 | 212246 | 2020-06-06 | Autauga | Alabama | 1001 | 260 | 5 |
209161 | 209161 | 2020-06-05 | Autauga | Alabama | 1001 | 249 | 5 |
206079 | 206079 | 2020-06-04 | Autauga | Alabama | 1001 | 242 | 5 |
203000 | 203000 | 2020-06-03 | Autauga | Alabama | 1001 | 240 | 5 |
199924 | 199924 | 2020-06-02 | Autauga | Alabama | 1001 | 240 | 5 |
196851 | 196851 | 2020-06-01 | Autauga | Alabama | 1001 | 234 | 5 |
193781 | 193781 | 2020-05-31 | Autauga | Alabama | 1001 | 221 | 4 |
190715 | 190715 | 2020-05-30 | Autauga | Alabama | 1001 | 216 | 4 |
187651 | 187651 | 2020-05-29 | Autauga | Alabama | 1001 | 212 | 3 |
184594 | 184594 | 2020-05-28 | Autauga | Alabama | 1001 | 205 | 3 |
181542 | 181542 | 2020-05-27 | Autauga | Alabama | 1001 | 192 | 3 |
178498 | 178498 | 2020-05-26 | Autauga | Alabama | 1001 | 189 | 3 |
175453 | 175453 | 2020-05-25 | Autauga | Alabama | 1001 | 168 | 3 |
172410 | 172410 | 2020-05-24 | Autauga | Alabama | 1001 | 159 | 3 |
169369 | 169369 | 2020-05-23 | Autauga | Alabama | 1001 | 155 | 3 |
166333 | 166333 | 2020-05-22 | Autauga | Alabama | 1001 | 149 | 3 |
163301 | 163301 | 2020-05-21 | Autauga | Alabama | 1001 | 147 | 3 |
160273 | 160273 | 2020-05-20 | Autauga | Alabama | 1001 | 136 | 3 |
157249 | 157249 | 2020-05-19 | Autauga | Alabama | 1001 | 127 | 4 |
154233 | 154233 | 2020-05-18 | Autauga | Alabama | 1001 | 120 | 4 |
151221 | 151221 | 2020-05-17 | Autauga | Alabama | 1001 | 110 | 4 |
148212 | 148212 | 2020-05-16 | Autauga | Alabama | 1001 | 110 | 4 |
145209 | 145209 | 2020-05-15 | Autauga | Alabama | 1001 | 103 | 4 |
142210 | 142210 | 2020-05-14 | Autauga | Alabama | 1001 | 104 | 4 |
139214 | 139214 | 2020-05-13 | Autauga | Alabama | 1001 | 93 | 4 |
136223 | 136223 | 2020-05-12 | Autauga | Alabama | 1001 | 91 | 4 |
133233 | 133233 | 2020-05-11 | Autauga | Alabama | 1001 | 84 | 4 |
130243 | 130243 | 2020-05-10 | Autauga | Alabama | 1001 | 74 | 4 |
127253 | 127253 | 2020-05-09 | Autauga | Alabama | 1001 | 68 | 4 |
124268 | 124268 | 2020-05-08 | Autauga | Alabama | 1001 | 67 | 4 |
121288 | 121288 | 2020-05-07 | Autauga | Alabama | 1001 | 61 | 3 |
118322 | 118322 | 2020-05-06 | Autauga | Alabama | 1001 | 58 | 3 |
115363 | 115363 | 2020-05-05 | Autauga | Alabama | 1001 | 53 | 3 |
112480 | 112480 | 2020-05-04 | Autauga | Alabama | 1001 | 53 | 3 |
109605 | 109605 | 2020-05-03 | Autauga | Alabama | 1001 | 48 | 3 |
106736 | 106736 | 2020-05-02 | Autauga | Alabama | 1001 | 45 | 3 |
103871 | 103871 | 2020-05-01 | Autauga | Alabama | 1001 | 42 | 3 |
101016 | 101016 | 2020-04-30 | Autauga | Alabama | 1001 | 42 | 4 |
98166 | 98166 | 2020-04-29 | Autauga | Alabama | 1001 | 43 | 4 |
95321 | 95321 | 2020-04-28 | Autauga | Alabama | 1001 | 40 | 4 |
92491 | 92491 | 2020-04-27 | Autauga | Alabama | 1001 | 39 | 3 |
89673 | 89673 | 2020-04-26 | Autauga | Alabama | 1001 | 37 | 2 |
86857 | 86857 | 2020-04-25 | Autauga | Alabama | 1001 | 37 | 2 |
84049 | 84049 | 2020-04-24 | Autauga | Alabama | 1001 | 36 | 2 |
81248 | 81248 | 2020-04-23 | Autauga | Alabama | 1001 | 33 | 2 |
78455 | 78455 | 2020-04-22 | Autauga | Alabama | 1001 | 32 | 2 |
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);