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 |
---|---|---|---|---|---|---|---|
531214 | 531214 | 2020-09-14 | Elmore | Alabama | 1051 | 2449 | 47 |
527977 | 527977 | 2020-09-13 | Elmore | Alabama | 1051 | 2435 | 47 |
524741 | 524741 | 2020-09-12 | Elmore | Alabama | 1051 | 2410 | 47 |
521505 | 521505 | 2020-09-11 | Elmore | Alabama | 1051 | 2400 | 47 |
518268 | 518268 | 2020-09-10 | Elmore | Alabama | 1051 | 2385 | 47 |
515033 | 515033 | 2020-09-09 | Elmore | Alabama | 1051 | 2372 | 47 |
511800 | 511800 | 2020-09-08 | Elmore | Alabama | 1051 | 2352 | 47 |
508567 | 508567 | 2020-09-07 | Elmore | Alabama | 1051 | 2331 | 47 |
505335 | 505335 | 2020-09-06 | Elmore | Alabama | 1051 | 2312 | 47 |
502101 | 502101 | 2020-09-05 | Elmore | Alabama | 1051 | 2302 | 47 |
498867 | 498867 | 2020-09-04 | Elmore | Alabama | 1051 | 2281 | 46 |
495634 | 495634 | 2020-09-03 | Elmore | Alabama | 1051 | 2251 | 46 |
492400 | 492400 | 2020-09-02 | Elmore | Alabama | 1051 | 2234 | 46 |
489167 | 489167 | 2020-09-01 | Elmore | Alabama | 1051 | 2230 | 45 |
485934 | 485934 | 2020-08-31 | Elmore | Alabama | 1051 | 2195 | 44 |
482699 | 482699 | 2020-08-30 | Elmore | Alabama | 1051 | 2183 | 44 |
479465 | 479465 | 2020-08-29 | Elmore | Alabama | 1051 | 2159 | 44 |
476232 | 476232 | 2020-08-28 | Elmore | Alabama | 1051 | 2134 | 44 |
472999 | 472999 | 2020-08-27 | Elmore | Alabama | 1051 | 2112 | 44 |
469767 | 469767 | 2020-08-26 | Elmore | Alabama | 1051 | 2077 | 44 |
466538 | 466538 | 2020-08-25 | Elmore | Alabama | 1051 | 2061 | 44 |
463309 | 463309 | 2020-08-24 | Elmore | Alabama | 1051 | 2054 | 44 |
460080 | 460080 | 2020-08-23 | Elmore | Alabama | 1051 | 2010 | 44 |
456853 | 456853 | 2020-08-22 | Elmore | Alabama | 1051 | 2008 | 44 |
453625 | 453625 | 2020-08-21 | Elmore | Alabama | 1051 | 1998 | 44 |
450397 | 450397 | 2020-08-20 | Elmore | Alabama | 1051 | 1981 | 42 |
447169 | 447169 | 2020-08-19 | Elmore | Alabama | 1051 | 1945 | 42 |
443942 | 443942 | 2020-08-18 | Elmore | Alabama | 1051 | 1930 | 42 |
440716 | 440716 | 2020-08-17 | Elmore | Alabama | 1051 | 1914 | 41 |
437490 | 437490 | 2020-08-16 | Elmore | Alabama | 1051 | 1914 | 41 |
434264 | 434264 | 2020-08-15 | Elmore | Alabama | 1051 | 1886 | 41 |
431039 | 431039 | 2020-08-14 | Elmore | Alabama | 1051 | 1871 | 41 |
427811 | 427811 | 2020-08-13 | Elmore | Alabama | 1051 | 1865 | 41 |
424587 | 424587 | 2020-08-12 | Elmore | Alabama | 1051 | 1850 | 41 |
421366 | 421366 | 2020-08-11 | Elmore | Alabama | 1051 | 1843 | 41 |
418145 | 418145 | 2020-08-10 | Elmore | Alabama | 1051 | 1808 | 39 |
414924 | 414924 | 2020-08-09 | Elmore | Alabama | 1051 | 1800 | 39 |
411704 | 411704 | 2020-08-08 | Elmore | Alabama | 1051 | 1792 | 39 |
408485 | 408485 | 2020-08-07 | Elmore | Alabama | 1051 | 1769 | 39 |
405265 | 405265 | 2020-08-06 | Elmore | Alabama | 1051 | 1739 | 39 |
402047 | 402047 | 2020-08-05 | Elmore | Alabama | 1051 | 1697 | 37 |
398831 | 398831 | 2020-08-04 | Elmore | Alabama | 1051 | 1690 | 37 |
395615 | 395615 | 2020-08-03 | Elmore | Alabama | 1051 | 1665 | 37 |
392399 | 392399 | 2020-08-02 | Elmore | Alabama | 1051 | 1645 | 37 |
389182 | 389182 | 2020-08-01 | Elmore | Alabama | 1051 | 1622 | 37 |
385965 | 385965 | 2020-07-31 | Elmore | Alabama | 1051 | 1604 | 35 |
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 |
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);