ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Madison" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
592773 | 592773 | 2020-10-03 | Madison | Alabama | 1089 | 8182 | 78 |
589533 | 589533 | 2020-10-02 | Madison | Alabama | 1089 | 8125 | 78 |
586292 | 586292 | 2020-10-01 | Madison | Alabama | 1089 | 8056 | 78 |
583052 | 583052 | 2020-09-30 | Madison | Alabama | 1089 | 8005 | 80 |
579813 | 579813 | 2020-09-29 | Madison | Alabama | 1089 | 7981 | 79 |
576572 | 576572 | 2020-09-28 | Madison | Alabama | 1089 | 7978 | 78 |
573328 | 573328 | 2020-09-27 | Madison | Alabama | 1089 | 7927 | 78 |
570086 | 570086 | 2020-09-26 | Madison | Alabama | 1089 | 7881 | 78 |
566845 | 566845 | 2020-09-25 | Madison | Alabama | 1089 | 7820 | 78 |
563604 | 563604 | 2020-09-24 | Madison | Alabama | 1089 | 7754 | 80 |
560365 | 560365 | 2020-09-23 | Madison | Alabama | 1089 | 7709 | 78 |
557129 | 557129 | 2020-09-22 | Madison | Alabama | 1089 | 7674 | 75 |
553892 | 553892 | 2020-09-21 | Madison | Alabama | 1089 | 7630 | 75 |
550653 | 550653 | 2020-09-20 | Madison | Alabama | 1089 | 7583 | 75 |
547414 | 547414 | 2020-09-19 | Madison | Alabama | 1089 | 7507 | 75 |
544177 | 544177 | 2020-09-18 | Madison | Alabama | 1089 | 7422 | 75 |
540941 | 540941 | 2020-09-17 | Madison | Alabama | 1089 | 7365 | 73 |
537704 | 537704 | 2020-09-16 | Madison | Alabama | 1089 | 7303 | 73 |
534468 | 534468 | 2020-09-15 | Madison | Alabama | 1089 | 7237 | 72 |
531233 | 531233 | 2020-09-14 | Madison | Alabama | 1089 | 7216 | 72 |
527996 | 527996 | 2020-09-13 | Madison | Alabama | 1089 | 7175 | 72 |
524760 | 524760 | 2020-09-12 | Madison | Alabama | 1089 | 7111 | 72 |
521524 | 521524 | 2020-09-11 | Madison | Alabama | 1089 | 7057 | 71 |
518287 | 518287 | 2020-09-10 | Madison | Alabama | 1089 | 6965 | 66 |
515052 | 515052 | 2020-09-09 | Madison | Alabama | 1089 | 6934 | 64 |
511819 | 511819 | 2020-09-08 | Madison | Alabama | 1089 | 6911 | 64 |
508586 | 508586 | 2020-09-07 | Madison | Alabama | 1089 | 6867 | 64 |
505354 | 505354 | 2020-09-06 | Madison | Alabama | 1089 | 6850 | 64 |
502120 | 502120 | 2020-09-05 | Madison | Alabama | 1089 | 6818 | 64 |
498886 | 498886 | 2020-09-04 | Madison | Alabama | 1089 | 6705 | 63 |
495653 | 495653 | 2020-09-03 | Madison | Alabama | 1089 | 6641 | 62 |
492419 | 492419 | 2020-09-02 | Madison | Alabama | 1089 | 6595 | 61 |
489186 | 489186 | 2020-09-01 | Madison | Alabama | 1089 | 6570 | 60 |
485953 | 485953 | 2020-08-31 | Madison | Alabama | 1089 | 6473 | 57 |
482718 | 482718 | 2020-08-30 | Madison | Alabama | 1089 | 6428 | 52 |
479484 | 479484 | 2020-08-29 | Madison | Alabama | 1089 | 6366 | 52 |
476251 | 476251 | 2020-08-28 | Madison | Alabama | 1089 | 6289 | 51 |
473018 | 473018 | 2020-08-27 | Madison | Alabama | 1089 | 6245 | 50 |
469786 | 469786 | 2020-08-26 | Madison | Alabama | 1089 | 6190 | 46 |
466557 | 466557 | 2020-08-25 | Madison | Alabama | 1089 | 6093 | 46 |
463328 | 463328 | 2020-08-24 | Madison | Alabama | 1089 | 6089 | 44 |
460099 | 460099 | 2020-08-23 | Madison | Alabama | 1089 | 6053 | 44 |
456872 | 456872 | 2020-08-22 | Madison | Alabama | 1089 | 6024 | 44 |
453644 | 453644 | 2020-08-21 | Madison | Alabama | 1089 | 6007 | 43 |
450416 | 450416 | 2020-08-20 | Madison | Alabama | 1089 | 5946 | 43 |
447188 | 447188 | 2020-08-19 | Madison | Alabama | 1089 | 5914 | 43 |
443961 | 443961 | 2020-08-18 | Madison | Alabama | 1089 | 5914 | 43 |
440735 | 440735 | 2020-08-17 | Madison | Alabama | 1089 | 5872 | 42 |
437509 | 437509 | 2020-08-16 | Madison | Alabama | 1089 | 5821 | 40 |
434283 | 434283 | 2020-08-15 | Madison | Alabama | 1089 | 5793 | 40 |
431058 | 431058 | 2020-08-14 | Madison | Alabama | 1089 | 5711 | 40 |
427830 | 427830 | 2020-08-13 | Madison | Alabama | 1089 | 5679 | 40 |
424606 | 424606 | 2020-08-12 | Madison | Alabama | 1089 | 5632 | 40 |
421385 | 421385 | 2020-08-11 | Madison | Alabama | 1089 | 5585 | 39 |
418164 | 418164 | 2020-08-10 | Madison | Alabama | 1089 | 5561 | 39 |
414943 | 414943 | 2020-08-09 | Madison | Alabama | 1089 | 5489 | 39 |
411723 | 411723 | 2020-08-08 | Madison | Alabama | 1089 | 5425 | 38 |
408504 | 408504 | 2020-08-07 | Madison | Alabama | 1089 | 5358 | 35 |
405284 | 405284 | 2020-08-06 | Madison | Alabama | 1089 | 5269 | 35 |
402066 | 402066 | 2020-08-05 | Madison | Alabama | 1089 | 5228 | 32 |
398850 | 398850 | 2020-08-04 | Madison | Alabama | 1089 | 5184 | 32 |
395634 | 395634 | 2020-08-03 | Madison | Alabama | 1089 | 5116 | 30 |
392418 | 392418 | 2020-08-02 | Madison | Alabama | 1089 | 5029 | 30 |
389201 | 389201 | 2020-08-01 | Madison | Alabama | 1089 | 4911 | 30 |
385984 | 385984 | 2020-07-31 | Madison | Alabama | 1089 | 4812 | 30 |
382766 | 382766 | 2020-07-30 | Madison | Alabama | 1089 | 4744 | 30 |
379549 | 379549 | 2020-07-29 | Madison | Alabama | 1089 | 4581 | 30 |
376333 | 376333 | 2020-07-28 | Madison | Alabama | 1089 | 4522 | 25 |
373119 | 373119 | 2020-07-27 | Madison | Alabama | 1089 | 4403 | 25 |
369907 | 369907 | 2020-07-26 | Madison | Alabama | 1089 | 4303 | 25 |
366697 | 366697 | 2020-07-25 | Madison | Alabama | 1089 | 4202 | 25 |
363490 | 363490 | 2020-07-24 | Madison | Alabama | 1089 | 4099 | 25 |
360284 | 360284 | 2020-07-23 | Madison | Alabama | 1089 | 3941 | 20 |
357079 | 357079 | 2020-07-22 | Madison | Alabama | 1089 | 3792 | 20 |
353876 | 353876 | 2020-07-21 | Madison | Alabama | 1089 | 3706 | 16 |
350674 | 350674 | 2020-07-20 | Madison | Alabama | 1089 | 3633 | 15 |
347473 | 347473 | 2020-07-19 | Madison | Alabama | 1089 | 3505 | 15 |
344273 | 344273 | 2020-07-18 | Madison | Alabama | 1089 | 3366 | 15 |
341074 | 341074 | 2020-07-17 | Madison | Alabama | 1089 | 3190 | 15 |
337878 | 337878 | 2020-07-16 | Madison | Alabama | 1089 | 3014 | 14 |
334683 | 334683 | 2020-07-15 | Madison | Alabama | 1089 | 2942 | 13 |
331490 | 331490 | 2020-07-14 | Madison | Alabama | 1089 | 2767 | 10 |
328304 | 328304 | 2020-07-13 | Madison | Alabama | 1089 | 2573 | 10 |
325118 | 325118 | 2020-07-12 | Madison | Alabama | 1089 | 2304 | 10 |
321937 | 321937 | 2020-07-11 | Madison | Alabama | 1089 | 2150 | 10 |
318758 | 318758 | 2020-07-10 | Madison | Alabama | 1089 | 2012 | 10 |
315585 | 315585 | 2020-07-09 | Madison | Alabama | 1089 | 1934 | 9 |
312410 | 312410 | 2020-07-08 | Madison | Alabama | 1089 | 1646 | 9 |
309241 | 309241 | 2020-07-07 | Madison | Alabama | 1089 | 1579 | 9 |
306072 | 306072 | 2020-07-06 | Madison | Alabama | 1089 | 1516 | 8 |
302908 | 302908 | 2020-07-05 | Madison | Alabama | 1089 | 1455 | 8 |
299744 | 299744 | 2020-07-04 | Madison | Alabama | 1089 | 1384 | 8 |
296582 | 296582 | 2020-07-03 | Madison | Alabama | 1089 | 1296 | 8 |
293427 | 293427 | 2020-07-02 | Madison | Alabama | 1089 | 1129 | 8 |
290274 | 290274 | 2020-07-01 | Madison | Alabama | 1089 | 1084 | 8 |
287124 | 287124 | 2020-06-30 | Madison | Alabama | 1089 | 1047 | 7 |
283978 | 283978 | 2020-06-29 | Madison | Alabama | 1089 | 1021 | 7 |
280832 | 280832 | 2020-06-28 | Madison | Alabama | 1089 | 930 | 7 |
277684 | 277684 | 2020-06-27 | Madison | Alabama | 1089 | 921 | 7 |
274536 | 274536 | 2020-06-26 | Madison | Alabama | 1089 | 889 | 7 |
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);