ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1051 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382747 | 382747 | 2020-07-30 | Elmore | Alabama | 1051 | 1568 | 35 |
379530 | 379530 | 2020-07-29 | Elmore | Alabama | 1051 | 1546 | 35 |
376314 | 376314 | 2020-07-28 | Elmore | Alabama | 1051 | 1527 | 34 |
373100 | 373100 | 2020-07-27 | Elmore | Alabama | 1051 | 1517 | 34 |
369888 | 369888 | 2020-07-26 | Elmore | Alabama | 1051 | 1488 | 34 |
366678 | 366678 | 2020-07-25 | Elmore | Alabama | 1051 | 1480 | 34 |
363471 | 363471 | 2020-07-24 | Elmore | Alabama | 1051 | 1438 | 34 |
360265 | 360265 | 2020-07-23 | Elmore | Alabama | 1051 | 1412 | 33 |
357060 | 357060 | 2020-07-22 | Elmore | Alabama | 1051 | 1353 | 33 |
353857 | 353857 | 2020-07-21 | Elmore | Alabama | 1051 | 1328 | 27 |
350655 | 350655 | 2020-07-20 | Elmore | Alabama | 1051 | 1305 | 27 |
347454 | 347454 | 2020-07-19 | Elmore | Alabama | 1051 | 1281 | 27 |
344254 | 344254 | 2020-07-18 | Elmore | Alabama | 1051 | 1254 | 27 |
341055 | 341055 | 2020-07-17 | Elmore | Alabama | 1051 | 1195 | 27 |
337859 | 337859 | 2020-07-16 | Elmore | Alabama | 1051 | 1175 | 26 |
334664 | 334664 | 2020-07-15 | Elmore | Alabama | 1051 | 1143 | 25 |
331471 | 331471 | 2020-07-14 | Elmore | Alabama | 1051 | 1126 | 24 |
328285 | 328285 | 2020-07-13 | Elmore | Alabama | 1051 | 1099 | 22 |
325099 | 325099 | 2020-07-12 | Elmore | Alabama | 1051 | 1086 | 21 |
321918 | 321918 | 2020-07-11 | Elmore | Alabama | 1051 | 1047 | 20 |
318739 | 318739 | 2020-07-10 | Elmore | Alabama | 1051 | 1025 | 21 |
315566 | 315566 | 2020-07-09 | Elmore | Alabama | 1051 | 1005 | 19 |
312391 | 312391 | 2020-07-08 | Elmore | Alabama | 1051 | 989 | 19 |
309222 | 309222 | 2020-07-07 | Elmore | Alabama | 1051 | 975 | 15 |
306053 | 306053 | 2020-07-06 | Elmore | Alabama | 1051 | 955 | 14 |
302889 | 302889 | 2020-07-05 | Elmore | Alabama | 1051 | 937 | 14 |
299725 | 299725 | 2020-07-04 | Elmore | Alabama | 1051 | 915 | 14 |
296563 | 296563 | 2020-07-03 | Elmore | Alabama | 1051 | 876 | 14 |
293408 | 293408 | 2020-07-02 | Elmore | Alabama | 1051 | 849 | 14 |
290255 | 290255 | 2020-07-01 | Elmore | Alabama | 1051 | 829 | 14 |
287105 | 287105 | 2020-06-30 | Elmore | Alabama | 1051 | 822 | 14 |
283959 | 283959 | 2020-06-29 | Elmore | Alabama | 1051 | 811 | 14 |
280813 | 280813 | 2020-06-28 | Elmore | Alabama | 1051 | 789 | 13 |
277665 | 277665 | 2020-06-27 | Elmore | Alabama | 1051 | 786 | 13 |
274517 | 274517 | 2020-06-26 | Elmore | Alabama | 1051 | 758 | 13 |
271377 | 271377 | 2020-06-25 | Elmore | Alabama | 1051 | 744 | 12 |
268243 | 268243 | 2020-06-24 | Elmore | Alabama | 1051 | 720 | 12 |
265114 | 265114 | 2020-06-23 | Elmore | Alabama | 1051 | 702 | 12 |
261985 | 261985 | 2020-06-22 | Elmore | Alabama | 1051 | 690 | 11 |
258858 | 258858 | 2020-06-21 | Elmore | Alabama | 1051 | 673 | 11 |
255731 | 255731 | 2020-06-20 | Elmore | Alabama | 1051 | 663 | 11 |
252612 | 252612 | 2020-06-19 | Elmore | Alabama | 1051 | 646 | 11 |
249497 | 249497 | 2020-06-18 | Elmore | Alabama | 1051 | 616 | 10 |
246385 | 246385 | 2020-06-17 | Elmore | Alabama | 1051 | 589 | 10 |
243272 | 243272 | 2020-06-16 | Elmore | Alabama | 1051 | 581 | 10 |
240161 | 240161 | 2020-06-15 | Elmore | Alabama | 1051 | 560 | 9 |
237053 | 237053 | 2020-06-14 | Elmore | Alabama | 1051 | 541 | 9 |
233946 | 233946 | 2020-06-13 | Elmore | Alabama | 1051 | 515 | 9 |
230841 | 230841 | 2020-06-12 | Elmore | Alabama | 1051 | 498 | 9 |
227737 | 227737 | 2020-06-11 | Elmore | Alabama | 1051 | 483 | 9 |
224636 | 224636 | 2020-06-10 | Elmore | Alabama | 1051 | 459 | 9 |
221540 | 221540 | 2020-06-09 | Elmore | Alabama | 1051 | 449 | 10 |
218448 | 218448 | 2020-06-08 | Elmore | Alabama | 1051 | 438 | 10 |
215358 | 215358 | 2020-06-07 | Elmore | Alabama | 1051 | 422 | 10 |
212271 | 212271 | 2020-06-06 | Elmore | Alabama | 1051 | 412 | 10 |
209186 | 209186 | 2020-06-05 | Elmore | Alabama | 1051 | 392 | 10 |
206104 | 206104 | 2020-06-04 | Elmore | Alabama | 1051 | 385 | 9 |
203025 | 203025 | 2020-06-03 | Elmore | Alabama | 1051 | 383 | 9 |
199949 | 199949 | 2020-06-02 | Elmore | Alabama | 1051 | 384 | 9 |
196876 | 196876 | 2020-06-01 | Elmore | Alabama | 1051 | 373 | 8 |
193806 | 193806 | 2020-05-31 | Elmore | Alabama | 1051 | 354 | 8 |
190740 | 190740 | 2020-05-30 | Elmore | Alabama | 1051 | 339 | 8 |
187676 | 187676 | 2020-05-29 | Elmore | Alabama | 1051 | 323 | 7 |
184619 | 184619 | 2020-05-28 | Elmore | Alabama | 1051 | 313 | 7 |
181567 | 181567 | 2020-05-27 | Elmore | Alabama | 1051 | 300 | 7 |
178523 | 178523 | 2020-05-26 | Elmore | Alabama | 1051 | 292 | 7 |
175478 | 175478 | 2020-05-25 | Elmore | Alabama | 1051 | 270 | 7 |
172435 | 172435 | 2020-05-24 | Elmore | Alabama | 1051 | 263 | 7 |
169394 | 169394 | 2020-05-23 | Elmore | Alabama | 1051 | 255 | 7 |
166358 | 166358 | 2020-05-22 | Elmore | Alabama | 1051 | 242 | 7 |
163326 | 163326 | 2020-05-21 | Elmore | Alabama | 1051 | 238 | 7 |
160298 | 160298 | 2020-05-20 | Elmore | Alabama | 1051 | 226 | 7 |
157274 | 157274 | 2020-05-19 | Elmore | Alabama | 1051 | 207 | 6 |
154258 | 154258 | 2020-05-18 | Elmore | Alabama | 1051 | 197 | 6 |
151246 | 151246 | 2020-05-17 | Elmore | Alabama | 1051 | 192 | 6 |
148237 | 148237 | 2020-05-16 | Elmore | Alabama | 1051 | 188 | 6 |
145234 | 145234 | 2020-05-15 | Elmore | Alabama | 1051 | 178 | 6 |
142235 | 142235 | 2020-05-14 | Elmore | Alabama | 1051 | 169 | 6 |
139239 | 139239 | 2020-05-13 | Elmore | Alabama | 1051 | 157 | 5 |
136248 | 136248 | 2020-05-12 | Elmore | Alabama | 1051 | 156 | 4 |
133258 | 133258 | 2020-05-11 | Elmore | Alabama | 1051 | 152 | 4 |
130268 | 130268 | 2020-05-10 | Elmore | Alabama | 1051 | 150 | 4 |
127278 | 127278 | 2020-05-09 | Elmore | Alabama | 1051 | 135 | 4 |
124293 | 124293 | 2020-05-08 | Elmore | Alabama | 1051 | 130 | 4 |
121313 | 121313 | 2020-05-07 | Elmore | Alabama | 1051 | 127 | 4 |
118347 | 118347 | 2020-05-06 | Elmore | Alabama | 1051 | 121 | 3 |
115388 | 115388 | 2020-05-05 | Elmore | Alabama | 1051 | 121 | 3 |
112505 | 112505 | 2020-05-04 | Elmore | Alabama | 1051 | 111 | 3 |
109630 | 109630 | 2020-05-03 | Elmore | Alabama | 1051 | 103 | 2 |
106761 | 106761 | 2020-05-02 | Elmore | Alabama | 1051 | 93 | 2 |
103896 | 103896 | 2020-05-01 | Elmore | Alabama | 1051 | 88 | 2 |
101041 | 101041 | 2020-04-30 | Elmore | Alabama | 1051 | 86 | 2 |
98191 | 98191 | 2020-04-29 | Elmore | Alabama | 1051 | 84 | 2 |
95346 | 95346 | 2020-04-28 | Elmore | Alabama | 1051 | 82 | 1 |
92516 | 92516 | 2020-04-27 | Elmore | Alabama | 1051 | 79 | 1 |
89698 | 89698 | 2020-04-26 | Elmore | Alabama | 1051 | 79 | 1 |
86882 | 86882 | 2020-04-25 | Elmore | Alabama | 1051 | 77 | 1 |
84074 | 84074 | 2020-04-24 | Elmore | Alabama | 1051 | 74 | 1 |
81273 | 81273 | 2020-04-23 | Elmore | Alabama | 1051 | 74 | 1 |
78480 | 78480 | 2020-04-22 | Elmore | Alabama | 1051 | 74 | 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);