ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,502 rows where state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Cook 153
- Kane 107
- McHenry 107
- Lake 106
- Cumberland 103
- DuPage 103
- Sangamon 103
- St. Clair 103
- Woodford 103
- Clinton 102
- Whiteside 102
- Winnebago 102
- Peoria 101
- Will 101
- Jackson 99
- Kankakee 99
- Kendall 99
- LaSalle 99
- Madison 99
- Washington 99
- Williamson 99
- Adams 97
- Christian 97
- McLean 97
- DeKalb 96
- Champaign 95
- Jo Daviess 95
- Livingston 95
- Rock Island 95
- Stephenson 95
- …
state 1
- Illinois · 8,730 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
268798 | 268798 | 2020-06-24 | Adams | Illinois | 17001 | 67 | 1 |
268799 | 268799 | 2020-06-24 | Alexander | Illinois | 17003 | 21 | 0 |
268800 | 268800 | 2020-06-24 | Bond | Illinois | 17005 | 12 | 1 |
268801 | 268801 | 2020-06-24 | Boone | Illinois | 17007 | 560 | 21 |
268802 | 268802 | 2020-06-24 | Brown | Illinois | 17009 | 10 | 0 |
268803 | 268803 | 2020-06-24 | Bureau | Illinois | 17011 | 24 | 1 |
268804 | 268804 | 2020-06-24 | Calhoun | Illinois | 17013 | 1 | 0 |
268805 | 268805 | 2020-06-24 | Carroll | Illinois | 17015 | 21 | 2 |
268806 | 268806 | 2020-06-24 | Cass | Illinois | 17017 | 117 | 0 |
268807 | 268807 | 2020-06-24 | Champaign | Illinois | 17019 | 806 | 12 |
268808 | 268808 | 2020-06-24 | Christian | Illinois | 17021 | 42 | 5 |
268809 | 268809 | 2020-06-24 | Clark | Illinois | 17023 | 14 | 0 |
268810 | 268810 | 2020-06-24 | Clay | Illinois | 17025 | 2 | 0 |
268811 | 268811 | 2020-06-24 | Clinton | Illinois | 17027 | 224 | 17 |
268812 | 268812 | 2020-06-24 | Coles | Illinois | 17029 | 154 | 17 |
268813 | 268813 | 2020-06-24 | Cook | Illinois | 17031 | 88138 | 4478 |
268814 | 268814 | 2020-06-24 | Crawford | Illinois | 17033 | 18 | 0 |
268815 | 268815 | 2020-06-24 | Cumberland | Illinois | 17035 | 10 | 0 |
268816 | 268816 | 2020-06-24 | De Witt | Illinois | 17039 | 4 | 0 |
268817 | 268817 | 2020-06-24 | DeKalb | Illinois | 17037 | 554 | 18 |
268818 | 268818 | 2020-06-24 | Douglas | Illinois | 17041 | 43 | 0 |
268819 | 268819 | 2020-06-24 | DuPage | Illinois | 17043 | 8782 | 458 |
268820 | 268820 | 2020-06-24 | Edgar | Illinois | 17045 | 7 | 0 |
268821 | 268821 | 2020-06-24 | Edwards | Illinois | 17047 | 2 | 0 |
268822 | 268822 | 2020-06-24 | Effingham | Illinois | 17049 | 12 | 1 |
268823 | 268823 | 2020-06-24 | Fayette | Illinois | 17051 | 23 | 3 |
268824 | 268824 | 2020-06-24 | Ford | Illinois | 17053 | 26 | 1 |
268825 | 268825 | 2020-06-24 | Franklin | Illinois | 17055 | 12 | 0 |
268826 | 268826 | 2020-06-24 | Fulton | Illinois | 17057 | 15 | 0 |
268827 | 268827 | 2020-06-24 | Gallatin | Illinois | 17059 | 2 | 0 |
268828 | 268828 | 2020-06-24 | Greene | Illinois | 17061 | 9 | 0 |
268829 | 268829 | 2020-06-24 | Grundy | Illinois | 17063 | 144 | 4 |
268830 | 268830 | 2020-06-24 | Hamilton | Illinois | 17065 | 2 | 0 |
268831 | 268831 | 2020-06-24 | Hancock | Illinois | 17067 | 18 | 1 |
268832 | 268832 | 2020-06-24 | Hardin | Illinois | 17069 | 1 | 0 |
268833 | 268833 | 2020-06-24 | Henderson | Illinois | 17071 | 8 | 0 |
268834 | 268834 | 2020-06-24 | Henry | Illinois | 17073 | 77 | 1 |
268835 | 268835 | 2020-06-24 | Iroquois | Illinois | 17075 | 144 | 5 |
268836 | 268836 | 2020-06-24 | Jackson | Illinois | 17077 | 325 | 19 |
268837 | 268837 | 2020-06-24 | Jasper | Illinois | 17079 | 46 | 7 |
268838 | 268838 | 2020-06-24 | Jefferson | Illinois | 17081 | 107 | 17 |
268839 | 268839 | 2020-06-24 | Jersey | Illinois | 17083 | 33 | 1 |
268840 | 268840 | 2020-06-24 | Jo Daviess | Illinois | 17085 | 39 | 1 |
268841 | 268841 | 2020-06-24 | Johnson | Illinois | 17087 | 20 | 0 |
268842 | 268842 | 2020-06-24 | Kane | Illinois | 17089 | 7553 | 255 |
268843 | 268843 | 2020-06-24 | Kankakee | Illinois | 17091 | 1255 | 63 |
268844 | 268844 | 2020-06-24 | Kendall | Illinois | 17093 | 971 | 22 |
268845 | 268845 | 2020-06-24 | Knox | Illinois | 17095 | 119 | 0 |
268846 | 268846 | 2020-06-24 | LaSalle | Illinois | 17099 | 195 | 16 |
268847 | 268847 | 2020-06-24 | Lake | Illinois | 17097 | 9468 | 409 |
268848 | 268848 | 2020-06-24 | Lawrence | Illinois | 17101 | 6 | 0 |
268849 | 268849 | 2020-06-24 | Lee | Illinois | 17103 | 96 | 2 |
268850 | 268850 | 2020-06-24 | Livingston | Illinois | 17105 | 40 | 2 |
268851 | 268851 | 2020-06-24 | Logan | Illinois | 17107 | 13 | 0 |
268852 | 268852 | 2020-06-24 | Macon | Illinois | 17115 | 223 | 22 |
268853 | 268853 | 2020-06-24 | Macoupin | Illinois | 17117 | 48 | 3 |
268854 | 268854 | 2020-06-24 | Madison | Illinois | 17119 | 852 | 68 |
268855 | 268855 | 2020-06-24 | Marion | Illinois | 17121 | 63 | 0 |
268856 | 268856 | 2020-06-24 | Marshall | Illinois | 17123 | 6 | 0 |
268857 | 268857 | 2020-06-24 | Mason | Illinois | 17125 | 21 | 0 |
268858 | 268858 | 2020-06-24 | Massac | Illinois | 17127 | 8 | 0 |
268859 | 268859 | 2020-06-24 | McDonough | Illinois | 17109 | 101 | 15 |
268860 | 268860 | 2020-06-24 | McHenry | Illinois | 17111 | 1937 | 93 |
268861 | 268861 | 2020-06-24 | McLean | Illinois | 17113 | 253 | 13 |
268862 | 268862 | 2020-06-24 | Menard | Illinois | 17129 | 23 | 0 |
268863 | 268863 | 2020-06-24 | Mercer | Illinois | 17131 | 20 | 0 |
268864 | 268864 | 2020-06-24 | Monroe | Illinois | 17133 | 117 | 12 |
268865 | 268865 | 2020-06-24 | Montgomery | Illinois | 17135 | 41 | 0 |
268866 | 268866 | 2020-06-24 | Morgan | Illinois | 17137 | 123 | 3 |
268867 | 268867 | 2020-06-24 | Moultrie | Illinois | 17139 | 15 | 0 |
268868 | 268868 | 2020-06-24 | Ogle | Illinois | 17141 | 245 | 4 |
268869 | 268869 | 2020-06-24 | Peoria | Illinois | 17143 | 447 | 26 |
268870 | 268870 | 2020-06-24 | Perry | Illinois | 17145 | 46 | 0 |
268871 | 268871 | 2020-06-24 | Piatt | Illinois | 17147 | 17 | 0 |
268872 | 268872 | 2020-06-24 | Pike | Illinois | 17149 | 2 | 0 |
268873 | 268873 | 2020-06-24 | Pope | Illinois | 17151 | 1 | 0 |
268874 | 268874 | 2020-06-24 | Pulaski | Illinois | 17153 | 67 | 0 |
268875 | 268875 | 2020-06-24 | Putnam | Illinois | 17155 | 1 | 0 |
268876 | 268876 | 2020-06-24 | Randolph | Illinois | 17157 | 278 | 7 |
268877 | 268877 | 2020-06-24 | Richland | Illinois | 17159 | 4 | 0 |
268878 | 268878 | 2020-06-24 | Rock Island | Illinois | 17161 | 833 | 28 |
268879 | 268879 | 2020-06-24 | Saline | Illinois | 17165 | 8 | 0 |
268880 | 268880 | 2020-06-24 | Sangamon | Illinois | 17167 | 400 | 33 |
268881 | 268881 | 2020-06-24 | Schuyler | Illinois | 17169 | 13 | 0 |
268882 | 268882 | 2020-06-24 | Shelby | Illinois | 17173 | 16 | 1 |
268883 | 268883 | 2020-06-24 | St. Clair | Illinois | 17163 | 1869 | 136 |
268884 | 268884 | 2020-06-24 | Stark | Illinois | 17175 | 3 | 0 |
268885 | 268885 | 2020-06-24 | Stephenson | Illinois | 17177 | 257 | 5 |
268886 | 268886 | 2020-06-24 | Tazewell | Illinois | 17179 | 115 | 7 |
268887 | 268887 | 2020-06-24 | Union | Illinois | 17181 | 182 | 18 |
268888 | 268888 | 2020-06-24 | Unknown | Illinois | 1000 | 204 | |
268889 | 268889 | 2020-06-24 | Vermilion | Illinois | 17183 | 50 | 2 |
268890 | 268890 | 2020-06-24 | Wabash | Illinois | 17185 | 22 | 0 |
268891 | 268891 | 2020-06-24 | Warren | Illinois | 17187 | 130 | 0 |
268892 | 268892 | 2020-06-24 | Washington | Illinois | 17189 | 19 | 0 |
268893 | 268893 | 2020-06-24 | Wayne | Illinois | 17191 | 11 | 1 |
268894 | 268894 | 2020-06-24 | White | Illinois | 17193 | 3 | 0 |
268895 | 268895 | 2020-06-24 | Whiteside | Illinois | 17195 | 178 | 15 |
268896 | 268896 | 2020-06-24 | Will | Illinois | 17197 | 6480 | 315 |
268897 | 268897 | 2020-06-24 | Williamson | Illinois | 17199 | 99 | 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);