ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where date = "2020-06-05" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
209737 | 209737 | 2020-06-05 | Adams | Illinois | 17001 | 44 | 1 |
209738 | 209738 | 2020-06-05 | Alexander | Illinois | 17003 | 14 | 0 |
209739 | 209739 | 2020-06-05 | Bond | Illinois | 17005 | 12 | 1 |
209740 | 209740 | 2020-06-05 | Boone | Illinois | 17007 | 498 | 17 |
209741 | 209741 | 2020-06-05 | Brown | Illinois | 17009 | 10 | 0 |
209742 | 209742 | 2020-06-05 | Bureau | Illinois | 17011 | 21 | 1 |
209743 | 209743 | 2020-06-05 | Calhoun | Illinois | 17013 | 1 | 0 |
209744 | 209744 | 2020-06-05 | Carroll | Illinois | 17015 | 17 | 2 |
209745 | 209745 | 2020-06-05 | Cass | Illinois | 17017 | 76 | 0 |
209746 | 209746 | 2020-06-05 | Champaign | Illinois | 17019 | 677 | 7 |
209747 | 209747 | 2020-06-05 | Christian | Illinois | 17021 | 35 | 5 |
209748 | 209748 | 2020-06-05 | Clark | Illinois | 17023 | 11 | 0 |
209749 | 209749 | 2020-06-05 | Clay | Illinois | 17025 | 2 | 0 |
209750 | 209750 | 2020-06-05 | Clinton | Illinois | 17027 | 190 | 17 |
209751 | 209751 | 2020-06-05 | Coles | Illinois | 17029 | 138 | 17 |
209752 | 209752 | 2020-06-05 | Cook | Illinois | 17031 | 81344 | 3880 |
209753 | 209753 | 2020-06-05 | Crawford | Illinois | 17033 | 11 | 0 |
209754 | 209754 | 2020-06-05 | Cumberland | Illinois | 17035 | 10 | 0 |
209755 | 209755 | 2020-06-05 | De Witt | Illinois | 17039 | 4 | 0 |
209756 | 209756 | 2020-06-05 | DeKalb | Illinois | 17037 | 465 | 8 |
209757 | 209757 | 2020-06-05 | Douglas | Illinois | 17041 | 28 | 0 |
209758 | 209758 | 2020-06-05 | DuPage | Illinois | 17043 | 8003 | 394 |
209759 | 209759 | 2020-06-05 | Edgar | Illinois | 17045 | 1 | 0 |
209760 | 209760 | 2020-06-05 | Edwards | Illinois | 17047 | 2 | 0 |
209761 | 209761 | 2020-06-05 | Effingham | Illinois | 17049 | 8 | 1 |
209762 | 209762 | 2020-06-05 | Fayette | Illinois | 17051 | 21 | 3 |
209763 | 209763 | 2020-06-05 | Ford | Illinois | 17053 | 21 | 1 |
209764 | 209764 | 2020-06-05 | Franklin | Illinois | 17055 | 12 | 0 |
209765 | 209765 | 2020-06-05 | Fulton | Illinois | 17057 | 12 | 0 |
209766 | 209766 | 2020-06-05 | Gallatin | Illinois | 17059 | 2 | 0 |
209767 | 209767 | 2020-06-05 | Greene | Illinois | 17061 | 6 | 0 |
209768 | 209768 | 2020-06-05 | Grundy | Illinois | 17063 | 111 | 2 |
209769 | 209769 | 2020-06-05 | Hamilton | Illinois | 17065 | 2 | 0 |
209770 | 209770 | 2020-06-05 | Hancock | Illinois | 17067 | 17 | 1 |
209771 | 209771 | 2020-06-05 | Hardin | Illinois | 17069 | 1 | 0 |
209772 | 209772 | 2020-06-05 | Henderson | Illinois | 17071 | 8 | 0 |
209773 | 209773 | 2020-06-05 | Henry | Illinois | 17073 | 70 | 0 |
209774 | 209774 | 2020-06-05 | Iroquois | Illinois | 17075 | 135 | 5 |
209775 | 209775 | 2020-06-05 | Jackson | Illinois | 17077 | 300 | 10 |
209776 | 209776 | 2020-06-05 | Jasper | Illinois | 17079 | 46 | 7 |
209777 | 209777 | 2020-06-05 | Jefferson | Illinois | 17081 | 101 | 16 |
209778 | 209778 | 2020-06-05 | Jersey | Illinois | 17083 | 24 | 1 |
209779 | 209779 | 2020-06-05 | Jo Daviess | Illinois | 17085 | 32 | 1 |
209780 | 209780 | 2020-06-05 | Johnson | Illinois | 17087 | 11 | 0 |
209781 | 209781 | 2020-06-05 | Kane | Illinois | 17089 | 6736 | 207 |
209782 | 209782 | 2020-06-05 | Kankakee | Illinois | 17091 | 1211 | 58 |
209783 | 209783 | 2020-06-05 | Kendall | Illinois | 17093 | 868 | 22 |
209784 | 209784 | 2020-06-05 | Knox | Illinois | 17095 | 102 | 0 |
209785 | 209785 | 2020-06-05 | LaSalle | Illinois | 17099 | 160 | 16 |
209786 | 209786 | 2020-06-05 | Lake | Illinois | 17097 | 8683 | 334 |
209787 | 209787 | 2020-06-05 | Lawrence | Illinois | 17101 | 4 | 0 |
209788 | 209788 | 2020-06-05 | Lee | Illinois | 17103 | 82 | 1 |
209789 | 209789 | 2020-06-05 | Livingston | Illinois | 17105 | 36 | 2 |
209790 | 209790 | 2020-06-05 | Logan | Illinois | 17107 | 11 | 0 |
209791 | 209791 | 2020-06-05 | Macon | Illinois | 17115 | 200 | 20 |
209792 | 209792 | 2020-06-05 | Macoupin | Illinois | 17117 | 46 | 2 |
209793 | 209793 | 2020-06-05 | Madison | Illinois | 17119 | 629 | 65 |
209794 | 209794 | 2020-06-05 | Marion | Illinois | 17121 | 52 | 0 |
209795 | 209795 | 2020-06-05 | Marshall | Illinois | 17123 | 5 | 0 |
209796 | 209796 | 2020-06-05 | Mason | Illinois | 17125 | 18 | 0 |
209797 | 209797 | 2020-06-05 | Massac | Illinois | 17127 | 7 | 0 |
209798 | 209798 | 2020-06-05 | McDonough | Illinois | 17109 | 91 | 13 |
209799 | 209799 | 2020-06-05 | McHenry | Illinois | 17111 | 1692 | 82 |
209800 | 209800 | 2020-06-05 | McLean | Illinois | 17113 | 226 | 13 |
209801 | 209801 | 2020-06-05 | Menard | Illinois | 17129 | 22 | 0 |
209802 | 209802 | 2020-06-05 | Mercer | Illinois | 17131 | 18 | 0 |
209803 | 209803 | 2020-06-05 | Monroe | Illinois | 17133 | 100 | 12 |
209804 | 209804 | 2020-06-05 | Montgomery | Illinois | 17135 | 41 | 0 |
209805 | 209805 | 2020-06-05 | Morgan | Illinois | 17137 | 42 | 1 |
209806 | 209806 | 2020-06-05 | Moultrie | Illinois | 17139 | 12 | 0 |
209807 | 209807 | 2020-06-05 | Ogle | Illinois | 17141 | 225 | 4 |
209808 | 209808 | 2020-06-05 | Peoria | Illinois | 17143 | 301 | 11 |
209809 | 209809 | 2020-06-05 | Perry | Illinois | 17145 | 42 | 0 |
209810 | 209810 | 2020-06-05 | Piatt | Illinois | 17147 | 11 | 0 |
209811 | 209811 | 2020-06-05 | Pike | Illinois | 17149 | 1 | 0 |
209812 | 209812 | 2020-06-05 | Pope | Illinois | 17151 | 1 | 0 |
209813 | 209813 | 2020-06-05 | Pulaski | Illinois | 17153 | 58 | 0 |
209814 | 209814 | 2020-06-05 | Putnam | Illinois | 17155 | 1 | 0 |
209815 | 209815 | 2020-06-05 | Randolph | Illinois | 17157 | 273 | 4 |
209816 | 209816 | 2020-06-05 | Richland | Illinois | 17159 | 4 | 0 |
209817 | 209817 | 2020-06-05 | Rock Island | Illinois | 17161 | 731 | 28 |
209818 | 209818 | 2020-06-05 | Saline | Illinois | 17165 | 7 | 0 |
209819 | 209819 | 2020-06-05 | Sangamon | Illinois | 17167 | 365 | 31 |
209820 | 209820 | 2020-06-05 | Schuyler | Illinois | 17169 | 13 | 0 |
209821 | 209821 | 2020-06-05 | Shelby | Illinois | 17173 | 16 | 1 |
209822 | 209822 | 2020-06-05 | St. Clair | Illinois | 17163 | 1404 | 104 |
209823 | 209823 | 2020-06-05 | Stark | Illinois | 17175 | 3 | 0 |
209824 | 209824 | 2020-06-05 | Stephenson | Illinois | 17177 | 211 | 5 |
209825 | 209825 | 2020-06-05 | Tazewell | Illinois | 17179 | 81 | 5 |
209826 | 209826 | 2020-06-05 | Union | Illinois | 17181 | 171 | 14 |
209827 | 209827 | 2020-06-05 | Vermilion | Illinois | 17183 | 42 | 1 |
209828 | 209828 | 2020-06-05 | Wabash | Illinois | 17185 | 6 | 0 |
209829 | 209829 | 2020-06-05 | Warren | Illinois | 17187 | 122 | 0 |
209830 | 209830 | 2020-06-05 | Washington | Illinois | 17189 | 19 | 0 |
209831 | 209831 | 2020-06-05 | Wayne | Illinois | 17191 | 9 | 1 |
209832 | 209832 | 2020-06-05 | White | Illinois | 17193 | 2 | 0 |
209833 | 209833 | 2020-06-05 | Whiteside | Illinois | 17195 | 153 | 13 |
209834 | 209834 | 2020-06-05 | Will | Illinois | 17197 | 5799 | 285 |
209835 | 209835 | 2020-06-05 | Williamson | Illinois | 17199 | 75 | 3 |
209836 | 209836 | 2020-06-05 | Winnebago | Illinois | 17201 | 2501 | 76 |
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);