ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-05-21" 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 |
---|---|---|---|---|---|---|---|
1339829 | 1339829 | 2021-05-21 | Adams | Illinois | 17001 | 8551 | 153 |
1339830 | 1339830 | 2021-05-21 | Alexander | Illinois | 17003 | 470 | 11 |
1339831 | 1339831 | 2021-05-21 | Bond | Illinois | 17005 | 2070 | 30 |
1339832 | 1339832 | 2021-05-21 | Boone | Illinois | 17007 | 6737 | 87 |
1339833 | 1339833 | 2021-05-21 | Brown | Illinois | 17009 | 721 | 12 |
1339834 | 1339834 | 2021-05-21 | Bureau | Illinois | 17011 | 3741 | 95 |
1339835 | 1339835 | 2021-05-21 | Calhoun | Illinois | 17013 | 518 | 5 |
1339836 | 1339836 | 2021-05-21 | Carroll | Illinois | 17015 | 1759 | 37 |
1339837 | 1339837 | 2021-05-21 | Cass | Illinois | 17017 | 2001 | 34 |
1339838 | 1339838 | 2021-05-21 | Champaign | Illinois | 17019 | 20826 | 154 |
1339839 | 1339839 | 2021-05-21 | Christian | Illinois | 17021 | 3723 | 91 |
1339840 | 1339840 | 2021-05-21 | Clark | Illinois | 17023 | 1810 | 41 |
1339841 | 1339841 | 2021-05-21 | Clay | Illinois | 17025 | 1486 | 48 |
1339842 | 1339842 | 2021-05-21 | Clinton | Illinois | 17027 | 5769 | 99 |
1339843 | 1339843 | 2021-05-21 | Coles | Illinois | 17029 | 5707 | 101 |
1339844 | 1339844 | 2021-05-21 | Cook | Illinois | 17031 | 549886 | 10747 |
1339845 | 1339845 | 2021-05-21 | Crawford | Illinois | 17033 | 2130 | 42 |
1339846 | 1339846 | 2021-05-21 | Cumberland | Illinois | 17035 | 1291 | 31 |
1339847 | 1339847 | 2021-05-21 | De Witt | Illinois | 17039 | 1536 | 34 |
1339848 | 1339848 | 2021-05-21 | DeKalb | Illinois | 17037 | 10201 | 125 |
1339849 | 1339849 | 2021-05-21 | Douglas | Illinois | 17041 | 2594 | 40 |
1339850 | 1339850 | 2021-05-21 | DuPage | Illinois | 17043 | 91288 | 1373 |
1339851 | 1339851 | 2021-05-21 | Edgar | Illinois | 17045 | 1725 | 60 |
1339852 | 1339852 | 2021-05-21 | Edwards | Illinois | 17047 | 572 | 13 |
1339853 | 1339853 | 2021-05-21 | Effingham | Illinois | 17049 | 4738 | 83 |
1339854 | 1339854 | 2021-05-21 | Fayette | Illinois | 17051 | 3186 | 58 |
1339855 | 1339855 | 2021-05-21 | Ford | Illinois | 17053 | 1807 | 55 |
1339856 | 1339856 | 2021-05-21 | Franklin | Illinois | 17055 | 4477 | 88 |
1339857 | 1339857 | 2021-05-21 | Fulton | Illinois | 17057 | 3998 | 65 |
1339858 | 1339858 | 2021-05-21 | Gallatin | Illinois | 17059 | 461 | 5 |
1339859 | 1339859 | 2021-05-21 | Greene | Illinois | 17061 | 1443 | 46 |
1339860 | 1339860 | 2021-05-21 | Grundy | Illinois | 17063 | 5923 | 80 |
1339861 | 1339861 | 2021-05-21 | Hamilton | Illinois | 17065 | 838 | 18 |
1339862 | 1339862 | 2021-05-21 | Hancock | Illinois | 17067 | 1775 | 41 |
1339863 | 1339863 | 2021-05-21 | Hardin | Illinois | 17069 | 387 | 12 |
1339864 | 1339864 | 2021-05-21 | Henderson | Illinois | 17071 | 525 | 23 |
1339865 | 1339865 | 2021-05-21 | Henry | Illinois | 17073 | 5029 | 97 |
1339866 | 1339866 | 2021-05-21 | Iroquois | Illinois | 17075 | 3048 | 68 |
1339867 | 1339867 | 2021-05-21 | Jackson | Illinois | 17077 | 5051 | 75 |
1339868 | 1339868 | 2021-05-21 | Jasper | Illinois | 17079 | 1156 | 20 |
1339869 | 1339869 | 2021-05-21 | Jefferson | Illinois | 17081 | 4398 | 121 |
1339870 | 1339870 | 2021-05-21 | Jersey | Illinois | 17083 | 2699 | 69 |
1339871 | 1339871 | 2021-05-21 | Jo Daviess | Illinois | 17085 | 1821 | 27 |
1339872 | 1339872 | 2021-05-21 | Johnson | Illinois | 17087 | 1456 | 21 |
1339873 | 1339873 | 2021-05-21 | Kane | Illinois | 17089 | 58837 | 834 |
1339874 | 1339874 | 2021-05-21 | Kankakee | Illinois | 17091 | 14316 | 219 |
1339875 | 1339875 | 2021-05-21 | Kendall | Illinois | 17093 | 13676 | 104 |
1339876 | 1339876 | 2021-05-21 | Knox | Illinois | 17095 | 5589 | 181 |
1339877 | 1339877 | 2021-05-21 | LaSalle | Illinois | 17099 | 12653 | 300 |
1339878 | 1339878 | 2021-05-21 | Lake | Illinois | 17097 | 67718 | 1064 |
1339879 | 1339879 | 2021-05-21 | Lawrence | Illinois | 17101 | 2409 | 34 |
1339880 | 1339880 | 2021-05-21 | Lee | Illinois | 17103 | 4185 | 91 |
1339881 | 1339881 | 2021-05-21 | Livingston | Illinois | 17105 | 4847 | 98 |
1339882 | 1339882 | 2021-05-21 | Logan | Illinois | 17107 | 3911 | 73 |
1339883 | 1339883 | 2021-05-21 | Macon | Illinois | 17115 | 10848 | 212 |
1339884 | 1339884 | 2021-05-21 | Macoupin | Illinois | 17117 | 4744 | 114 |
1339885 | 1339885 | 2021-05-21 | Madison | Illinois | 17119 | 30684 | 595 |
1339886 | 1339886 | 2021-05-21 | Marion | Illinois | 17121 | 4481 | 121 |
1339887 | 1339887 | 2021-05-21 | Marshall | Illinois | 17123 | 1078 | 20 |
1339888 | 1339888 | 2021-05-21 | Mason | Illinois | 17125 | 1526 | 46 |
1339889 | 1339889 | 2021-05-21 | Massac | Illinois | 17127 | 1349 | 43 |
1339890 | 1339890 | 2021-05-21 | McDonough | Illinois | 17109 | 2879 | 61 |
1339891 | 1339891 | 2021-05-21 | McHenry | Illinois | 17111 | 28823 | 314 |
1339892 | 1339892 | 2021-05-21 | McLean | Illinois | 17113 | 18341 | 217 |
1339893 | 1339893 | 2021-05-21 | Menard | Illinois | 17129 | 1239 | 16 |
1339894 | 1339894 | 2021-05-21 | Mercer | Illinois | 17131 | 1479 | 33 |
1339895 | 1339895 | 2021-05-21 | Monroe | Illinois | 17133 | 4359 | 93 |
1339896 | 1339896 | 2021-05-21 | Montgomery | Illinois | 17135 | 3748 | 79 |
1339897 | 1339897 | 2021-05-21 | Morgan | Illinois | 17137 | 4008 | 104 |
1339898 | 1339898 | 2021-05-21 | Moultrie | Illinois | 17139 | 1618 | 36 |
1339899 | 1339899 | 2021-05-21 | Ogle | Illinois | 17141 | 6134 | 91 |
1339900 | 1339900 | 2021-05-21 | Peoria | Illinois | 17143 | 23400 | 352 |
1339901 | 1339901 | 2021-05-21 | Perry | Illinois | 17145 | 3185 | 69 |
1339902 | 1339902 | 2021-05-21 | Piatt | Illinois | 17147 | 1513 | 20 |
1339903 | 1339903 | 2021-05-21 | Pike | Illinois | 17149 | 1794 | 55 |
1339904 | 1339904 | 2021-05-21 | Pope | Illinois | 17151 | 323 | 4 |
1339905 | 1339905 | 2021-05-21 | Pulaski | Illinois | 17153 | 692 | 7 |
1339906 | 1339906 | 2021-05-21 | Putnam | Illinois | 17155 | 484 | 4 |
1339907 | 1339907 | 2021-05-21 | Randolph | Illinois | 17157 | 4140 | 90 |
1339908 | 1339908 | 2021-05-21 | Richland | Illinois | 17159 | 1759 | 48 |
1339909 | 1339909 | 2021-05-21 | Rock Island | Illinois | 17161 | 15122 | 363 |
1339910 | 1339910 | 2021-05-21 | Saline | Illinois | 17165 | 2576 | 70 |
1339911 | 1339911 | 2021-05-21 | Sangamon | Illinois | 17167 | 18908 | 277 |
1339912 | 1339912 | 2021-05-21 | Schuyler | Illinois | 17169 | 775 | 19 |
1339913 | 1339913 | 2021-05-21 | Scott | Illinois | 17171 | 480 | 1 |
1339914 | 1339914 | 2021-05-21 | Shelby | Illinois | 17173 | 2306 | 40 |
1339915 | 1339915 | 2021-05-21 | St. Clair | Illinois | 17163 | 30964 | 559 |
1339916 | 1339916 | 2021-05-21 | Stark | Illinois | 17175 | 641 | 24 |
1339917 | 1339917 | 2021-05-21 | Stephenson | Illinois | 17177 | 4795 | 103 |
1339918 | 1339918 | 2021-05-21 | Tazewell | Illinois | 17179 | 17068 | 329 |
1339919 | 1339919 | 2021-05-21 | Union | Illinois | 17181 | 2262 | 44 |
1339920 | 1339920 | 2021-05-21 | Unknown | Illinois | 0 | 355 | |
1339921 | 1339921 | 2021-05-21 | Vermilion | Illinois | 17183 | 9815 | 150 |
1339922 | 1339922 | 2021-05-21 | Wabash | Illinois | 17185 | 1347 | 15 |
1339923 | 1339923 | 2021-05-21 | Warren | Illinois | 17187 | 1806 | 49 |
1339924 | 1339924 | 2021-05-21 | Washington | Illinois | 17189 | 1646 | 31 |
1339925 | 1339925 | 2021-05-21 | Wayne | Illinois | 17191 | 1796 | 54 |
1339926 | 1339926 | 2021-05-21 | White | Illinois | 17193 | 1696 | 36 |
1339927 | 1339927 | 2021-05-21 | Whiteside | Illinois | 17195 | 7258 | 214 |
1339928 | 1339928 | 2021-05-21 | Will | Illinois | 17197 | 76164 | 1077 |
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);