ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-11-03" 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 |
---|---|---|---|---|---|---|---|
693882 | 693882 | 2020-11-03 | Adams | Illinois | 17001 | 2517 | 27 |
693883 | 693883 | 2020-11-03 | Alexander | Illinois | 17003 | 156 | 2 |
693884 | 693884 | 2020-11-03 | Bond | Illinois | 17005 | 566 | 9 |
693885 | 693885 | 2020-11-03 | Boone | Illinois | 17007 | 2232 | 26 |
693886 | 693886 | 2020-11-03 | Brown | Illinois | 17009 | 133 | 0 |
693887 | 693887 | 2020-11-03 | Bureau | Illinois | 17011 | 1055 | 19 |
693888 | 693888 | 2020-11-03 | Calhoun | Illinois | 17013 | 86 | 0 |
693889 | 693889 | 2020-11-03 | Carroll | Illinois | 17015 | 559 | 14 |
693890 | 693890 | 2020-11-03 | Cass | Illinois | 17017 | 478 | 11 |
693891 | 693891 | 2020-11-03 | Champaign | Illinois | 17019 | 6999 | 29 |
693892 | 693892 | 2020-11-03 | Christian | Illinois | 17021 | 942 | 32 |
693893 | 693893 | 2020-11-03 | Clark | Illinois | 17023 | 338 | 18 |
693894 | 693894 | 2020-11-03 | Clay | Illinois | 17025 | 363 | 15 |
693895 | 693895 | 2020-11-03 | Clinton | Illinois | 17027 | 1966 | 32 |
693896 | 693896 | 2020-11-03 | Coles | Illinois | 17029 | 2229 | 42 |
693897 | 693897 | 2020-11-03 | Cook | Illinois | 17031 | 198184 | 5517 |
693898 | 693898 | 2020-11-03 | Crawford | Illinois | 17033 | 689 | 6 |
693899 | 693899 | 2020-11-03 | Cumberland | Illinois | 17035 | 330 | 6 |
693900 | 693900 | 2020-11-03 | De Witt | Illinois | 17039 | 312 | 6 |
693901 | 693901 | 2020-11-03 | DeKalb | Illinois | 17037 | 2978 | 43 |
693902 | 693902 | 2020-11-03 | Douglas | Illinois | 17041 | 853 | 9 |
693903 | 693903 | 2020-11-03 | DuPage | Illinois | 17043 | 26512 | 626 |
693904 | 693904 | 2020-11-03 | Edgar | Illinois | 17045 | 185 | 11 |
693905 | 693905 | 2020-11-03 | Edwards | Illinois | 17047 | 119 | 0 |
693906 | 693906 | 2020-11-03 | Effingham | Illinois | 17049 | 1385 | 5 |
693907 | 693907 | 2020-11-03 | Fayette | Illinois | 17051 | 762 | 24 |
693908 | 693908 | 2020-11-03 | Ford | Illinois | 17053 | 228 | 16 |
693909 | 693909 | 2020-11-03 | Franklin | Illinois | 17055 | 1141 | 11 |
693910 | 693910 | 2020-11-03 | Fulton | Illinois | 17057 | 691 | 2 |
693911 | 693911 | 2020-11-03 | Gallatin | Illinois | 17059 | 122 | 2 |
693912 | 693912 | 2020-11-03 | Greene | Illinois | 17061 | 356 | 17 |
693913 | 693913 | 2020-11-03 | Grundy | Illinois | 17063 | 1175 | 8 |
693914 | 693914 | 2020-11-03 | Hamilton | Illinois | 17065 | 155 | 2 |
693915 | 693915 | 2020-11-03 | Hancock | Illinois | 17067 | 395 | 4 |
693916 | 693916 | 2020-11-03 | Hardin | Illinois | 17069 | 61 | 0 |
693917 | 693917 | 2020-11-03 | Henderson | Illinois | 17071 | 145 | 0 |
693918 | 693918 | 2020-11-03 | Henry | Illinois | 17073 | 914 | 9 |
693919 | 693919 | 2020-11-03 | Iroquois | Illinois | 17075 | 625 | 20 |
693920 | 693920 | 2020-11-03 | Jackson | Illinois | 17077 | 1698 | 26 |
693921 | 693921 | 2020-11-03 | Jasper | Illinois | 17079 | 301 | 10 |
693922 | 693922 | 2020-11-03 | Jefferson | Illinois | 17081 | 1036 | 52 |
693923 | 693923 | 2020-11-03 | Jersey | Illinois | 17083 | 517 | 21 |
693924 | 693924 | 2020-11-03 | Jo Daviess | Illinois | 17085 | 604 | 9 |
693925 | 693925 | 2020-11-03 | Johnson | Illinois | 17087 | 417 | 0 |
693926 | 693926 | 2020-11-03 | Kane | Illinois | 17089 | 19337 | 360 |
693927 | 693927 | 2020-11-03 | Kankakee | Illinois | 17091 | 3997 | 81 |
693928 | 693928 | 2020-11-03 | Kendall | Illinois | 17093 | 3228 | 30 |
693929 | 693929 | 2020-11-03 | Knox | Illinois | 17095 | 1509 | 22 |
693930 | 693930 | 2020-11-03 | LaSalle | Illinois | 17099 | 2937 | 70 |
693931 | 693931 | 2020-11-03 | Lake | Illinois | 17097 | 23177 | 524 |
693932 | 693932 | 2020-11-03 | Lawrence | Illinois | 17101 | 385 | 8 |
693933 | 693933 | 2020-11-03 | Lee | Illinois | 17103 | 973 | 4 |
693934 | 693934 | 2020-11-03 | Livingston | Illinois | 17105 | 803 | 12 |
693935 | 693935 | 2020-11-03 | Logan | Illinois | 17107 | 705 | 4 |
693936 | 693936 | 2020-11-03 | Macon | Illinois | 17115 | 3861 | 64 |
693937 | 693937 | 2020-11-03 | Macoupin | Illinois | 17117 | 893 | 11 |
693938 | 693938 | 2020-11-03 | Madison | Illinois | 17119 | 8032 | 163 |
693939 | 693939 | 2020-11-03 | Marion | Illinois | 17121 | 1238 | 25 |
693940 | 693940 | 2020-11-03 | Marshall | Illinois | 17123 | 181 | 4 |
693941 | 693941 | 2020-11-03 | Mason | Illinois | 17125 | 372 | 12 |
693942 | 693942 | 2020-11-03 | Massac | Illinois | 17127 | 181 | 2 |
693943 | 693943 | 2020-11-03 | McDonough | Illinois | 17109 | 858 | 21 |
693944 | 693944 | 2020-11-03 | McHenry | Illinois | 17111 | 7841 | 125 |
693945 | 693945 | 2020-11-03 | McLean | Illinois | 17113 | 4570 | 38 |
693946 | 693946 | 2020-11-03 | Menard | Illinois | 17129 | 196 | 1 |
693947 | 693947 | 2020-11-03 | Mercer | Illinois | 17131 | 362 | 7 |
693948 | 693948 | 2020-11-03 | Monroe | Illinois | 17133 | 1096 | 34 |
693949 | 693949 | 2020-11-03 | Montgomery | Illinois | 17135 | 706 | 16 |
693950 | 693950 | 2020-11-03 | Morgan | Illinois | 17137 | 1126 | 28 |
693951 | 693951 | 2020-11-03 | Moultrie | Illinois | 17139 | 526 | 6 |
693952 | 693952 | 2020-11-03 | Ogle | Illinois | 17141 | 1541 | 8 |
693953 | 693953 | 2020-11-03 | Peoria | Illinois | 17143 | 5237 | 85 |
693954 | 693954 | 2020-11-03 | Perry | Illinois | 17145 | 534 | 16 |
693955 | 693955 | 2020-11-03 | Piatt | Illinois | 17147 | 302 | 3 |
693956 | 693956 | 2020-11-03 | Pike | Illinois | 17149 | 470 | 8 |
693957 | 693957 | 2020-11-03 | Pope | Illinois | 17151 | 47 | 1 |
693958 | 693958 | 2020-11-03 | Pulaski | Illinois | 17153 | 255 | 1 |
693959 | 693959 | 2020-11-03 | Putnam | Illinois | 17155 | 115 | 0 |
693960 | 693960 | 2020-11-03 | Randolph | Illinois | 17157 | 1445 | 15 |
693961 | 693961 | 2020-11-03 | Richland | Illinois | 17159 | 360 | 18 |
693962 | 693962 | 2020-11-03 | Rock Island | Illinois | 17161 | 4833 | 105 |
693963 | 693963 | 2020-11-03 | Saline | Illinois | 17165 | 673 | 11 |
693964 | 693964 | 2020-11-03 | Sangamon | Illinois | 17167 | 4883 | 67 |
693965 | 693965 | 2020-11-03 | Schuyler | Illinois | 17169 | 106 | 1 |
693966 | 693966 | 2020-11-03 | Scott | Illinois | 17171 | 121 | 0 |
693967 | 693967 | 2020-11-03 | Shelby | Illinois | 17173 | 784 | 14 |
693968 | 693968 | 2020-11-03 | St. Clair | Illinois | 17163 | 9608 | 228 |
693969 | 693969 | 2020-11-03 | Stark | Illinois | 17175 | 99 | 3 |
693970 | 693970 | 2020-11-03 | Stephenson | Illinois | 17177 | 1346 | 10 |
693971 | 693971 | 2020-11-03 | Tazewell | Illinois | 17179 | 3144 | 60 |
693972 | 693972 | 2020-11-03 | Union | Illinois | 17181 | 835 | 25 |
693973 | 693973 | 2020-11-03 | Unknown | Illinois | 6034 | 278 | |
693974 | 693974 | 2020-11-03 | Vermilion | Illinois | 17183 | 2036 | 12 |
693975 | 693975 | 2020-11-03 | Wabash | Illinois | 17185 | 265 | 6 |
693976 | 693976 | 2020-11-03 | Warren | Illinois | 17187 | 587 | 10 |
693977 | 693977 | 2020-11-03 | Washington | Illinois | 17189 | 362 | 2 |
693978 | 693978 | 2020-11-03 | Wayne | Illinois | 17191 | 550 | 18 |
693979 | 693979 | 2020-11-03 | White | Illinois | 17193 | 304 | 5 |
693980 | 693980 | 2020-11-03 | Whiteside | Illinois | 17195 | 1950 | 32 |
693981 | 693981 | 2020-11-03 | Will | Illinois | 17197 | 21419 | 448 |
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);