ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-12-08" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1992705 | 1992705 | 2021-12-08 | Adams | Illinois | 17001 | 14837 | 191 |
1992706 | 1992706 | 2021-12-08 | Alexander | Illinois | 17003 | 823 | 13 |
1992707 | 1992707 | 2021-12-08 | Bond | Illinois | 17005 | 2822 | 34 |
1992708 | 1992708 | 2021-12-08 | Boone | Illinois | 17007 | 9069 | 99 |
1992709 | 1992709 | 2021-12-08 | Brown | Illinois | 17009 | 1143 | 18 |
1992710 | 1992710 | 2021-12-08 | Bureau | Illinois | 17011 | 5070 | 112 |
1992711 | 1992711 | 2021-12-08 | Calhoun | Illinois | 17013 | 852 | 5 |
1992712 | 1992712 | 2021-12-08 | Carroll | Illinois | 17015 | 2743 | 42 |
1992713 | 1992713 | 2021-12-08 | Cass | Illinois | 17017 | 2834 | 40 |
1992714 | 1992714 | 2021-12-08 | Champaign | Illinois | 17019 | 31272 | 216 |
1992715 | 1992715 | 2021-12-08 | Christian | Illinois | 17021 | 6086 | 102 |
1992716 | 1992716 | 2021-12-08 | Clark | Illinois | 17023 | 3067 | 52 |
1992717 | 1992717 | 2021-12-08 | Clay | Illinois | 17025 | 3010 | 59 |
1992718 | 1992718 | 2021-12-08 | Clinton | Illinois | 17027 | 7639 | 114 |
1992719 | 1992719 | 2021-12-08 | Coles | Illinois | 17029 | 8941 | 141 |
1992720 | 1992720 | 2021-12-08 | Cook | Illinois | 17031 | 694323 | 12145 |
1992721 | 1992721 | 2021-12-08 | Crawford | Illinois | 17033 | 3615 | 47 |
1992722 | 1992722 | 2021-12-08 | Cumberland | Illinois | 17035 | 2145 | 39 |
1992723 | 1992723 | 2021-12-08 | De Witt | Illinois | 17039 | 2547 | 38 |
1992724 | 1992724 | 2021-12-08 | DeKalb | Illinois | 17037 | 14248 | 151 |
1992725 | 1992725 | 2021-12-08 | Douglas | Illinois | 17041 | 3678 | 44 |
1992726 | 1992726 | 2021-12-08 | DuPage | Illinois | 17043 | 121677 | 1502 |
1992727 | 1992727 | 2021-12-08 | Edgar | Illinois | 17045 | 3064 | 70 |
1992728 | 1992728 | 2021-12-08 | Edwards | Illinois | 17047 | 1178 | 20 |
1992729 | 1992729 | 2021-12-08 | Effingham | Illinois | 17049 | 7381 | 123 |
1992730 | 1992730 | 2021-12-08 | Fayette | Illinois | 17051 | 4763 | 74 |
1992731 | 1992731 | 2021-12-08 | Ford | Illinois | 17053 | 2762 | 67 |
1992732 | 1992732 | 2021-12-08 | Franklin | Illinois | 17055 | 7907 | 136 |
1992733 | 1992733 | 2021-12-08 | Fulton | Illinois | 17057 | 5830 | 96 |
1992734 | 1992734 | 2021-12-08 | Gallatin | Illinois | 17059 | 836 | 11 |
1992735 | 1992735 | 2021-12-08 | Greene | Illinois | 17061 | 2251 | 53 |
1992736 | 1992736 | 2021-12-08 | Grundy | Illinois | 17063 | 8570 | 94 |
1992737 | 1992737 | 2021-12-08 | Hamilton | Illinois | 17065 | 1456 | 26 |
1992738 | 1992738 | 2021-12-08 | Hancock | Illinois | 17067 | 3127 | 45 |
1992739 | 1992739 | 2021-12-08 | Hardin | Illinois | 17069 | 692 | 16 |
1992740 | 1992740 | 2021-12-08 | Henderson | Illinois | 17071 | 841 | 23 |
1992741 | 1992741 | 2021-12-08 | Henry | Illinois | 17073 | 7606 | 113 |
1992742 | 1992742 | 2021-12-08 | Iroquois | Illinois | 17075 | 4865 | 86 |
1992743 | 1992743 | 2021-12-08 | Jackson | Illinois | 17077 | 8538 | 108 |
1992744 | 1992744 | 2021-12-08 | Jasper | Illinois | 17079 | 1782 | 23 |
1992745 | 1992745 | 2021-12-08 | Jefferson | Illinois | 17081 | 7081 | 148 |
1992746 | 1992746 | 2021-12-08 | Jersey | Illinois | 17083 | 3898 | 74 |
1992747 | 1992747 | 2021-12-08 | Jo Daviess | Illinois | 17085 | 2678 | 32 |
1992748 | 1992748 | 2021-12-08 | Johnson | Illinois | 17087 | 2515 | 38 |
1992749 | 1992749 | 2021-12-08 | Kane | Illinois | 17089 | 75827 | 960 |
1992750 | 1992750 | 2021-12-08 | Kankakee | Illinois | 17091 | 20133 | 280 |
1992751 | 1992751 | 2021-12-08 | Kendall | Illinois | 17093 | 18680 | 129 |
1992752 | 1992752 | 2021-12-08 | Knox | Illinois | 17095 | 8091 | 210 |
1992753 | 1992753 | 2021-12-08 | LaSalle | Illinois | 17099 | 16859 | 351 |
1992754 | 1992754 | 2021-12-08 | Lake | Illinois | 17097 | 89768 | 1190 |
1992755 | 1992755 | 2021-12-08 | Lawrence | Illinois | 17101 | 3580 | 46 |
1992756 | 1992756 | 2021-12-08 | Lee | Illinois | 17103 | 5359 | 104 |
1992757 | 1992757 | 2021-12-08 | Livingston | Illinois | 17105 | 6599 | 119 |
1992758 | 1992758 | 2021-12-08 | Logan | Illinois | 17107 | 5455 | 90 |
1992759 | 1992759 | 2021-12-08 | Macon | Illinois | 17115 | 17408 | 275 |
1992760 | 1992760 | 2021-12-08 | Macoupin | Illinois | 17117 | 7795 | 147 |
1992761 | 1992761 | 2021-12-08 | Madison | Illinois | 17119 | 43916 | 700 |
1992762 | 1992762 | 2021-12-08 | Marion | Illinois | 17121 | 7658 | 161 |
1992763 | 1992763 | 2021-12-08 | Marshall | Illinois | 17123 | 1609 | 25 |
1992764 | 1992764 | 2021-12-08 | Mason | Illinois | 17125 | 2386 | 54 |
1992765 | 1992765 | 2021-12-08 | Massac | Illinois | 17127 | 2392 | 57 |
1992766 | 1992766 | 2021-12-08 | McDonough | Illinois | 17109 | 4224 | 79 |
1992767 | 1992767 | 2021-12-08 | McHenry | Illinois | 17111 | 40872 | 373 |
1992768 | 1992768 | 2021-12-08 | McLean | Illinois | 17113 | 26388 | 272 |
1992769 | 1992769 | 2021-12-08 | Menard | Illinois | 17129 | 1977 | 19 |
1992770 | 1992770 | 2021-12-08 | Mercer | Illinois | 17131 | 2412 | 37 |
1992771 | 1992771 | 2021-12-08 | Monroe | Illinois | 17133 | 5766 | 105 |
1992772 | 1992772 | 2021-12-08 | Montgomery | Illinois | 17135 | 5529 | 91 |
1992773 | 1992773 | 2021-12-08 | Morgan | Illinois | 17137 | 5651 | 125 |
1992774 | 1992774 | 2021-12-08 | Moultrie | Illinois | 17139 | 2704 | 43 |
1992775 | 1992775 | 2021-12-08 | Ogle | Illinois | 17141 | 8924 | 108 |
1992776 | 1992776 | 2021-12-08 | Peoria | Illinois | 17143 | 29931 | 424 |
1992777 | 1992777 | 2021-12-08 | Perry | Illinois | 17145 | 4621 | 88 |
1992778 | 1992778 | 2021-12-08 | Piatt | Illinois | 17147 | 2493 | 20 |
1992779 | 1992779 | 2021-12-08 | Pike | Illinois | 17149 | 3008 | 61 |
1992780 | 1992780 | 2021-12-08 | Pope | Illinois | 17151 | 613 | 6 |
1992781 | 1992781 | 2021-12-08 | Pulaski | Illinois | 17153 | 1114 | 13 |
1992782 | 1992782 | 2021-12-08 | Putnam | Illinois | 17155 | 667 | 6 |
1992783 | 1992783 | 2021-12-08 | Randolph | Illinois | 17157 | 5825 | 110 |
1992784 | 1992784 | 2021-12-08 | Richland | Illinois | 17159 | 3249 | 72 |
1992785 | 1992785 | 2021-12-08 | Rock Island | Illinois | 17161 | 21448 | 425 |
1992786 | 1992786 | 2021-12-08 | Saline | Illinois | 17165 | 4644 | 89 |
1992787 | 1992787 | 2021-12-08 | Sangamon | Illinois | 17167 | 28489 | 341 |
1992788 | 1992788 | 2021-12-08 | Schuyler | Illinois | 17169 | 1192 | 24 |
1992789 | 1992789 | 2021-12-08 | Scott | Illinois | 17171 | 794 | 7 |
1992790 | 1992790 | 2021-12-08 | Shelby | Illinois | 17173 | 4039 | 57 |
1992791 | 1992791 | 2021-12-08 | St. Clair | Illinois | 17163 | 43663 | 664 |
1992792 | 1992792 | 2021-12-08 | Stark | Illinois | 17175 | 947 | 29 |
1992793 | 1992793 | 2021-12-08 | Stephenson | Illinois | 17177 | 7533 | 131 |
1992794 | 1992794 | 2021-12-08 | Tazewell | Illinois | 17179 | 23361 | 393 |
1992795 | 1992795 | 2021-12-08 | Union | Illinois | 17181 | 3360 | 54 |
1992796 | 1992796 | 2021-12-08 | Unknown | Illinois | 0 | 991 | |
1992797 | 1992797 | 2021-12-08 | Vermilion | Illinois | 17183 | 17147 | 234 |
1992798 | 1992798 | 2021-12-08 | Wabash | Illinois | 17185 | 2282 | 22 |
1992799 | 1992799 | 2021-12-08 | Warren | Illinois | 17187 | 2682 | 72 |
1992800 | 1992800 | 2021-12-08 | Washington | Illinois | 17189 | 2275 | 36 |
1992801 | 1992801 | 2021-12-08 | Wayne | Illinois | 17191 | 3323 | 67 |
1992802 | 1992802 | 2021-12-08 | White | Illinois | 17193 | 2939 | 43 |
1992803 | 1992803 | 2021-12-08 | Whiteside | Illinois | 17195 | 9582 | 232 |
1992804 | 1992804 | 2021-12-08 | Will | Illinois | 17197 | 102835 | 1253 |
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);