ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Adams" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
904914 | 904914 | 2021-01-07 | Adams | Indiana | 18001 | 2774 | 35 |
901669 | 901669 | 2021-01-06 | Adams | Indiana | 18001 | 2744 | 35 |
898424 | 898424 | 2021-01-05 | Adams | Indiana | 18001 | 2714 | 35 |
895179 | 895179 | 2021-01-04 | Adams | Indiana | 18001 | 2690 | 35 |
891932 | 891932 | 2021-01-03 | Adams | Indiana | 18001 | 2659 | 35 |
888686 | 888686 | 2021-01-02 | Adams | Indiana | 18001 | 2657 | 35 |
885440 | 885440 | 2021-01-01 | Adams | Indiana | 18001 | 2646 | 35 |
882195 | 882195 | 2020-12-31 | Adams | Indiana | 18001 | 2616 | 34 |
878950 | 878950 | 2020-12-30 | Adams | Indiana | 18001 | 2595 | 34 |
875705 | 875705 | 2020-12-29 | Adams | Indiana | 18001 | 2579 | 32 |
872460 | 872460 | 2020-12-28 | Adams | Indiana | 18001 | 2561 | 32 |
869215 | 869215 | 2020-12-27 | Adams | Indiana | 18001 | 2546 | 32 |
865970 | 865970 | 2020-12-26 | Adams | Indiana | 18001 | 2543 | 32 |
862725 | 862725 | 2020-12-25 | Adams | Indiana | 18001 | 2533 | 32 |
859480 | 859480 | 2020-12-24 | Adams | Indiana | 18001 | 2514 | 31 |
856235 | 856235 | 2020-12-23 | Adams | Indiana | 18001 | 2497 | 31 |
852990 | 852990 | 2020-12-22 | Adams | Indiana | 18001 | 2477 | 31 |
849745 | 849745 | 2020-12-21 | Adams | Indiana | 18001 | 2463 | 31 |
846500 | 846500 | 2020-12-20 | Adams | Indiana | 18001 | 2446 | 31 |
843254 | 843254 | 2020-12-19 | Adams | Indiana | 18001 | 2422 | 30 |
840009 | 840009 | 2020-12-18 | Adams | Indiana | 18001 | 2391 | 29 |
836764 | 836764 | 2020-12-17 | Adams | Indiana | 18001 | 2363 | 29 |
833518 | 833518 | 2020-12-16 | Adams | Indiana | 18001 | 2339 | 29 |
830271 | 830271 | 2020-12-15 | Adams | Indiana | 18001 | 2309 | 29 |
827025 | 827025 | 2020-12-14 | Adams | Indiana | 18001 | 2291 | 29 |
823778 | 823778 | 2020-12-13 | Adams | Indiana | 18001 | 2267 | 29 |
820532 | 820532 | 2020-12-12 | Adams | Indiana | 18001 | 2242 | 29 |
817286 | 817286 | 2020-12-11 | Adams | Indiana | 18001 | 2223 | 29 |
814040 | 814040 | 2020-12-10 | Adams | Indiana | 18001 | 2177 | 29 |
810795 | 810795 | 2020-12-09 | Adams | Indiana | 18001 | 2144 | 28 |
807550 | 807550 | 2020-12-08 | Adams | Indiana | 18001 | 2124 | 28 |
804305 | 804305 | 2020-12-07 | Adams | Indiana | 18001 | 2094 | 27 |
801060 | 801060 | 2020-12-06 | Adams | Indiana | 18001 | 2058 | 27 |
797815 | 797815 | 2020-12-05 | Adams | Indiana | 18001 | 2031 | 26 |
794570 | 794570 | 2020-12-04 | Adams | Indiana | 18001 | 1960 | 25 |
791325 | 791325 | 2020-12-03 | Adams | Indiana | 18001 | 1928 | 25 |
788080 | 788080 | 2020-12-02 | Adams | Indiana | 18001 | 1875 | 25 |
784836 | 784836 | 2020-12-01 | Adams | Indiana | 18001 | 1846 | 25 |
781591 | 781591 | 2020-11-30 | Adams | Indiana | 18001 | 1801 | 24 |
778345 | 778345 | 2020-11-29 | Adams | Indiana | 18001 | 1763 | 24 |
775100 | 775100 | 2020-11-28 | Adams | Indiana | 18001 | 1739 | 24 |
771855 | 771855 | 2020-11-27 | Adams | Indiana | 18001 | 1725 | 23 |
768610 | 768610 | 2020-11-26 | Adams | Indiana | 18001 | 1711 | 23 |
765364 | 765364 | 2020-11-25 | Adams | Indiana | 18001 | 1683 | 23 |
762119 | 762119 | 2020-11-24 | Adams | Indiana | 18001 | 1665 | 23 |
758874 | 758874 | 2020-11-23 | Adams | Indiana | 18001 | 1653 | 20 |
755627 | 755627 | 2020-11-22 | Adams | Indiana | 18001 | 1601 | 20 |
752381 | 752381 | 2020-11-21 | Adams | Indiana | 18001 | 1575 | 20 |
749135 | 749135 | 2020-11-20 | Adams | Indiana | 18001 | 1540 | 20 |
745889 | 745889 | 2020-11-19 | Adams | Indiana | 18001 | 1483 | 19 |
742642 | 742642 | 2020-11-18 | Adams | Indiana | 18001 | 1432 | 19 |
739395 | 739395 | 2020-11-17 | Adams | Indiana | 18001 | 1377 | 18 |
736151 | 736151 | 2020-11-16 | Adams | Indiana | 18001 | 1351 | 16 |
732905 | 732905 | 2020-11-15 | Adams | Indiana | 18001 | 1301 | 16 |
729660 | 729660 | 2020-11-14 | Adams | Indiana | 18001 | 1235 | 16 |
726417 | 726417 | 2020-11-13 | Adams | Indiana | 18001 | 1158 | 16 |
723174 | 723174 | 2020-11-12 | Adams | Indiana | 18001 | 1119 | 15 |
719931 | 719931 | 2020-11-11 | Adams | Indiana | 18001 | 1043 | 15 |
716688 | 716688 | 2020-11-10 | Adams | Indiana | 18001 | 990 | 14 |
713444 | 713444 | 2020-11-09 | Adams | Indiana | 18001 | 943 | 12 |
710200 | 710200 | 2020-11-08 | Adams | Indiana | 18001 | 927 | 12 |
706956 | 706956 | 2020-11-07 | Adams | Indiana | 18001 | 870 | 11 |
703713 | 703713 | 2020-11-06 | Adams | Indiana | 18001 | 823 | 11 |
700471 | 700471 | 2020-11-05 | Adams | Indiana | 18001 | 798 | 11 |
697227 | 697227 | 2020-11-04 | Adams | Indiana | 18001 | 780 | 11 |
693985 | 693985 | 2020-11-03 | Adams | Indiana | 18001 | 745 | 10 |
690742 | 690742 | 2020-11-02 | Adams | Indiana | 18001 | 720 | 10 |
687497 | 687497 | 2020-11-01 | Adams | Indiana | 18001 | 706 | 9 |
684253 | 684253 | 2020-10-31 | Adams | Indiana | 18001 | 678 | 9 |
681010 | 681010 | 2020-10-30 | Adams | Indiana | 18001 | 653 | 9 |
677767 | 677767 | 2020-10-29 | Adams | Indiana | 18001 | 634 | 8 |
674524 | 674524 | 2020-10-28 | Adams | Indiana | 18001 | 618 | 8 |
671282 | 671282 | 2020-10-27 | Adams | Indiana | 18001 | 578 | 8 |
668039 | 668039 | 2020-10-26 | Adams | Indiana | 18001 | 561 | 8 |
664795 | 664795 | 2020-10-25 | Adams | Indiana | 18001 | 524 | 8 |
661550 | 661550 | 2020-10-24 | Adams | Indiana | 18001 | 511 | 8 |
658306 | 658306 | 2020-10-23 | Adams | Indiana | 18001 | 503 | 8 |
655061 | 655061 | 2020-10-22 | Adams | Indiana | 18001 | 484 | 8 |
651816 | 651816 | 2020-10-21 | Adams | Indiana | 18001 | 482 | 6 |
648572 | 648572 | 2020-10-20 | Adams | Indiana | 18001 | 473 | 6 |
645327 | 645327 | 2020-10-19 | Adams | Indiana | 18001 | 465 | 6 |
642080 | 642080 | 2020-10-18 | Adams | Indiana | 18001 | 456 | 6 |
638833 | 638833 | 2020-10-17 | Adams | Indiana | 18001 | 450 | 6 |
635587 | 635587 | 2020-10-16 | Adams | Indiana | 18001 | 433 | 6 |
632341 | 632341 | 2020-10-15 | Adams | Indiana | 18001 | 416 | 6 |
629097 | 629097 | 2020-10-14 | Adams | Indiana | 18001 | 406 | 5 |
625854 | 625854 | 2020-10-13 | Adams | Indiana | 18001 | 401 | 5 |
622612 | 622612 | 2020-10-12 | Adams | Indiana | 18001 | 384 | 5 |
619368 | 619368 | 2020-10-11 | Adams | Indiana | 18001 | 364 | 5 |
616126 | 616126 | 2020-10-10 | Adams | Indiana | 18001 | 360 | 5 |
612885 | 612885 | 2020-10-09 | Adams | Indiana | 18001 | 342 | 5 |
609643 | 609643 | 2020-10-08 | Adams | Indiana | 18001 | 334 | 5 |
606400 | 606400 | 2020-10-07 | Adams | Indiana | 18001 | 320 | 5 |
603158 | 603158 | 2020-10-06 | Adams | Indiana | 18001 | 318 | 5 |
599915 | 599915 | 2020-10-05 | Adams | Indiana | 18001 | 306 | 5 |
596673 | 596673 | 2020-10-04 | Adams | Indiana | 18001 | 343 | 5 |
593431 | 593431 | 2020-10-03 | Adams | Indiana | 18001 | 342 | 5 |
590190 | 590190 | 2020-10-02 | Adams | Indiana | 18001 | 316 | 5 |
586949 | 586949 | 2020-10-01 | Adams | Indiana | 18001 | 288 | 4 |
583709 | 583709 | 2020-09-30 | Adams | Indiana | 18001 | 284 | 4 |
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);