ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Adams" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930774 | 930774 | 2021-01-15 | Adams | Illinois | 17001 | 7314 | 114 |
927529 | 927529 | 2021-01-14 | Adams | Illinois | 17001 | 7266 | 108 |
924283 | 924283 | 2021-01-13 | Adams | Illinois | 17001 | 7215 | 100 |
921038 | 921038 | 2021-01-12 | Adams | Illinois | 17001 | 7192 | 99 |
917793 | 917793 | 2021-01-11 | Adams | Illinois | 17001 | 7115 | 98 |
914548 | 914548 | 2021-01-10 | Adams | Illinois | 17001 | 7062 | 97 |
911303 | 911303 | 2021-01-09 | Adams | Illinois | 17001 | 7045 | 97 |
908058 | 908058 | 2021-01-08 | Adams | Illinois | 17001 | 7011 | 96 |
904812 | 904812 | 2021-01-07 | Adams | Illinois | 17001 | 6960 | 94 |
901567 | 901567 | 2021-01-06 | Adams | Illinois | 17001 | 6925 | 86 |
898322 | 898322 | 2021-01-05 | Adams | Illinois | 17001 | 6942 | 84 |
895077 | 895077 | 2021-01-04 | Adams | Illinois | 17001 | 6763 | 83 |
891830 | 891830 | 2021-01-03 | Adams | Illinois | 17001 | 6616 | 83 |
888583 | 888583 | 2021-01-02 | Adams | Illinois | 17001 | 6628 | 83 |
885338 | 885338 | 2021-01-01 | Adams | Illinois | 17001 | 6582 | 82 |
882093 | 882093 | 2020-12-31 | Adams | Illinois | 17001 | 6582 | 82 |
878848 | 878848 | 2020-12-30 | Adams | Illinois | 17001 | 6433 | 80 |
875603 | 875603 | 2020-12-29 | Adams | Illinois | 17001 | 6470 | 79 |
872358 | 872358 | 2020-12-28 | Adams | Illinois | 17001 | 6172 | 78 |
869113 | 869113 | 2020-12-27 | Adams | Illinois | 17001 | 6156 | 77 |
865868 | 865868 | 2020-12-26 | Adams | Illinois | 17001 | 6117 | 77 |
862623 | 862623 | 2020-12-25 | Adams | Illinois | 17001 | 6162 | 74 |
859378 | 859378 | 2020-12-24 | Adams | Illinois | 17001 | 6162 | 73 |
856133 | 856133 | 2020-12-23 | Adams | Illinois | 17001 | 6051 | 72 |
852888 | 852888 | 2020-12-22 | Adams | Illinois | 17001 | 6040 | 72 |
849643 | 849643 | 2020-12-21 | Adams | Illinois | 17001 | 5922 | 69 |
846398 | 846398 | 2020-12-20 | Adams | Illinois | 17001 | 5827 | 69 |
843152 | 843152 | 2020-12-19 | Adams | Illinois | 17001 | 5811 | 68 |
839907 | 839907 | 2020-12-18 | Adams | Illinois | 17001 | 5752 | 68 |
836662 | 836662 | 2020-12-17 | Adams | Illinois | 17001 | 5746 | 67 |
833416 | 833416 | 2020-12-16 | Adams | Illinois | 17001 | 5629 | 67 |
830169 | 830169 | 2020-12-15 | Adams | Illinois | 17001 | 5640 | 64 |
826923 | 826923 | 2020-12-14 | Adams | Illinois | 17001 | 5478 | 63 |
823676 | 823676 | 2020-12-13 | Adams | Illinois | 17001 | 5434 | 63 |
820430 | 820430 | 2020-12-12 | Adams | Illinois | 17001 | 5494 | 63 |
817184 | 817184 | 2020-12-11 | Adams | Illinois | 17001 | 5391 | 63 |
813938 | 813938 | 2020-12-10 | Adams | Illinois | 17001 | 5308 | 61 |
810693 | 810693 | 2020-12-09 | Adams | Illinois | 17001 | 5279 | 58 |
807448 | 807448 | 2020-12-08 | Adams | Illinois | 17001 | 5227 | 57 |
804203 | 804203 | 2020-12-07 | Adams | Illinois | 17001 | 5086 | 57 |
800958 | 800958 | 2020-12-06 | Adams | Illinois | 17001 | 5074 | 57 |
797713 | 797713 | 2020-12-05 | Adams | Illinois | 17001 | 5038 | 57 |
794468 | 794468 | 2020-12-04 | Adams | Illinois | 17001 | 5049 | 56 |
791223 | 791223 | 2020-12-03 | Adams | Illinois | 17001 | 4996 | 55 |
787978 | 787978 | 2020-12-02 | Adams | Illinois | 17001 | 4886 | 54 |
784734 | 784734 | 2020-12-01 | Adams | Illinois | 17001 | 4901 | 50 |
781489 | 781489 | 2020-11-30 | Adams | Illinois | 17001 | 4815 | 48 |
778243 | 778243 | 2020-11-29 | Adams | Illinois | 17001 | 4768 | 48 |
774998 | 774998 | 2020-11-28 | Adams | Illinois | 17001 | 4732 | 48 |
771753 | 771753 | 2020-11-27 | Adams | Illinois | 17001 | 4651 | 48 |
768508 | 768508 | 2020-11-26 | Adams | Illinois | 17001 | 4652 | 48 |
765262 | 765262 | 2020-11-25 | Adams | Illinois | 17001 | 4652 | 48 |
762017 | 762017 | 2020-11-24 | Adams | Illinois | 17001 | 4585 | 46 |
758772 | 758772 | 2020-11-23 | Adams | Illinois | 17001 | 4442 | 46 |
755525 | 755525 | 2020-11-22 | Adams | Illinois | 17001 | 4402 | 46 |
752279 | 752279 | 2020-11-21 | Adams | Illinois | 17001 | 4372 | 46 |
749033 | 749033 | 2020-11-20 | Adams | Illinois | 17001 | 4328 | 43 |
745787 | 745787 | 2020-11-19 | Adams | Illinois | 17001 | 4243 | 41 |
742540 | 742540 | 2020-11-18 | Adams | Illinois | 17001 | 4042 | 41 |
739293 | 739293 | 2020-11-17 | Adams | Illinois | 17001 | 4138 | 40 |
736049 | 736049 | 2020-11-16 | Adams | Illinois | 17001 | 3733 | 39 |
732803 | 732803 | 2020-11-15 | Adams | Illinois | 17001 | 3629 | 39 |
729558 | 729558 | 2020-11-14 | Adams | Illinois | 17001 | 3506 | 37 |
726315 | 726315 | 2020-11-13 | Adams | Illinois | 17001 | 3561 | 34 |
723072 | 723072 | 2020-11-12 | Adams | Illinois | 17001 | 3375 | 34 |
719829 | 719829 | 2020-11-11 | Adams | Illinois | 17001 | 3247 | 33 |
716586 | 716586 | 2020-11-10 | Adams | Illinois | 17001 | 3136 | 31 |
713342 | 713342 | 2020-11-09 | Adams | Illinois | 17001 | 3027 | 30 |
710098 | 710098 | 2020-11-08 | Adams | Illinois | 17001 | 2876 | 30 |
706854 | 706854 | 2020-11-07 | Adams | Illinois | 17001 | 2763 | 30 |
703611 | 703611 | 2020-11-06 | Adams | Illinois | 17001 | 2726 | 30 |
700368 | 700368 | 2020-11-05 | Adams | Illinois | 17001 | 2707 | 30 |
697124 | 697124 | 2020-11-04 | Adams | Illinois | 17001 | 2520 | 28 |
693882 | 693882 | 2020-11-03 | Adams | Illinois | 17001 | 2517 | 27 |
690639 | 690639 | 2020-11-02 | Adams | Illinois | 17001 | 2379 | 27 |
687394 | 687394 | 2020-11-01 | Adams | Illinois | 17001 | 2297 | 27 |
684150 | 684150 | 2020-10-31 | Adams | Illinois | 17001 | 2285 | 26 |
680907 | 680907 | 2020-10-30 | Adams | Illinois | 17001 | 2237 | 24 |
677664 | 677664 | 2020-10-29 | Adams | Illinois | 17001 | 2131 | 23 |
674421 | 674421 | 2020-10-28 | Adams | Illinois | 17001 | 2107 | 22 |
671179 | 671179 | 2020-10-27 | Adams | Illinois | 17001 | 1985 | 21 |
667936 | 667936 | 2020-10-26 | Adams | Illinois | 17001 | 1924 | 20 |
664692 | 664692 | 2020-10-25 | Adams | Illinois | 17001 | 1885 | 19 |
661447 | 661447 | 2020-10-24 | Adams | Illinois | 17001 | 1892 | 19 |
658203 | 658203 | 2020-10-23 | Adams | Illinois | 17001 | 1838 | 16 |
654958 | 654958 | 2020-10-22 | Adams | Illinois | 17001 | 1771 | 15 |
651713 | 651713 | 2020-10-21 | Adams | Illinois | 17001 | 1743 | 15 |
648469 | 648469 | 2020-10-20 | Adams | Illinois | 17001 | 1677 | 15 |
645224 | 645224 | 2020-10-19 | Adams | Illinois | 17001 | 1670 | 15 |
641977 | 641977 | 2020-10-18 | Adams | Illinois | 17001 | 1616 | 15 |
638730 | 638730 | 2020-10-17 | Adams | Illinois | 17001 | 1568 | 14 |
635484 | 635484 | 2020-10-16 | Adams | Illinois | 17001 | 1558 | 14 |
632238 | 632238 | 2020-10-15 | Adams | Illinois | 17001 | 1515 | 14 |
628994 | 628994 | 2020-10-14 | Adams | Illinois | 17001 | 1458 | 14 |
625751 | 625751 | 2020-10-13 | Adams | Illinois | 17001 | 1432 | 11 |
622509 | 622509 | 2020-10-12 | Adams | Illinois | 17001 | 1416 | 11 |
619265 | 619265 | 2020-10-11 | Adams | Illinois | 17001 | 1381 | 11 |
616023 | 616023 | 2020-10-10 | Adams | Illinois | 17001 | 1366 | 11 |
612782 | 612782 | 2020-10-09 | Adams | Illinois | 17001 | 1349 | 11 |
609540 | 609540 | 2020-10-08 | Adams | Illinois | 17001 | 1319 | 11 |
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);