ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2020-05-18 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 |
---|---|---|---|---|---|---|---|
154801 | 154801 | 2020-05-18 | Adams | Illinois | 17001 | 42 | 1 |
154802 | 154802 | 2020-05-18 | Alexander | Illinois | 17003 | 8 | 0 |
154803 | 154803 | 2020-05-18 | Bond | Illinois | 17005 | 11 | 1 |
154804 | 154804 | 2020-05-18 | Boone | Illinois | 17007 | 307 | 14 |
154805 | 154805 | 2020-05-18 | Brown | Illinois | 17009 | 11 | 0 |
154806 | 154806 | 2020-05-18 | Bureau | Illinois | 17011 | 15 | 1 |
154807 | 154807 | 2020-05-18 | Calhoun | Illinois | 17013 | 1 | 0 |
154808 | 154808 | 2020-05-18 | Carroll | Illinois | 17015 | 14 | 2 |
154809 | 154809 | 2020-05-18 | Cass | Illinois | 17017 | 64 | 0 |
154810 | 154810 | 2020-05-18 | Champaign | Illinois | 17019 | 418 | 7 |
154811 | 154811 | 2020-05-18 | Christian | Illinois | 17021 | 32 | 5 |
154812 | 154812 | 2020-05-18 | Clark | Illinois | 17023 | 9 | 0 |
154813 | 154813 | 2020-05-18 | Clay | Illinois | 17025 | 2 | 0 |
154814 | 154814 | 2020-05-18 | Clinton | Illinois | 17027 | 161 | 14 |
154815 | 154815 | 2020-05-18 | Coles | Illinois | 17029 | 85 | 5 |
154816 | 154816 | 2020-05-18 | Cook | Illinois | 17031 | 63690 | 2889 |
154817 | 154817 | 2020-05-18 | Crawford | Illinois | 17033 | 11 | 0 |
154818 | 154818 | 2020-05-18 | Cumberland | Illinois | 17035 | 9 | 0 |
154819 | 154819 | 2020-05-18 | De Witt | Illinois | 17039 | 4 | 0 |
154820 | 154820 | 2020-05-18 | DeKalb | Illinois | 17037 | 262 | 2 |
154821 | 154821 | 2020-05-18 | Douglas | Illinois | 17041 | 26 | 0 |
154822 | 154822 | 2020-05-18 | DuPage | Illinois | 17043 | 6076 | 300 |
154823 | 154823 | 2020-05-18 | Edwards | Illinois | 17047 | 2 | 0 |
154824 | 154824 | 2020-05-18 | Effingham | Illinois | 17049 | 6 | 1 |
154825 | 154825 | 2020-05-18 | Fayette | Illinois | 17051 | 19 | 2 |
154826 | 154826 | 2020-05-18 | Ford | Illinois | 17053 | 18 | 1 |
154827 | 154827 | 2020-05-18 | Franklin | Illinois | 17055 | 11 | 0 |
154828 | 154828 | 2020-05-18 | Fulton | Illinois | 17057 | 8 | 0 |
154829 | 154829 | 2020-05-18 | Gallatin | Illinois | 17059 | 2 | 0 |
154830 | 154830 | 2020-05-18 | Greene | Illinois | 17061 | 4 | 0 |
154831 | 154831 | 2020-05-18 | Grundy | Illinois | 17063 | 75 | 1 |
154832 | 154832 | 2020-05-18 | Hamilton | Illinois | 17065 | 2 | 0 |
154833 | 154833 | 2020-05-18 | Hancock | Illinois | 17067 | 13 | 0 |
154834 | 154834 | 2020-05-18 | Hardin | Illinois | 17069 | 1 | 0 |
154835 | 154835 | 2020-05-18 | Henderson | Illinois | 17071 | 8 | 0 |
154836 | 154836 | 2020-05-18 | Henry | Illinois | 17073 | 65 | 0 |
154837 | 154837 | 2020-05-18 | Iroquois | Illinois | 17075 | 118 | 3 |
154838 | 154838 | 2020-05-18 | Jackson | Illinois | 17077 | 181 | 10 |
154839 | 154839 | 2020-05-18 | Jasper | Illinois | 17079 | 45 | 7 |
154840 | 154840 | 2020-05-18 | Jefferson | Illinois | 17081 | 99 | 17 |
154841 | 154841 | 2020-05-18 | Jersey | Illinois | 17083 | 19 | 1 |
154842 | 154842 | 2020-05-18 | Jo Daviess | Illinois | 17085 | 19 | 0 |
154843 | 154843 | 2020-05-18 | Johnson | Illinois | 17087 | 7 | 0 |
154844 | 154844 | 2020-05-18 | Kane | Illinois | 17089 | 4584 | 115 |
154845 | 154845 | 2020-05-18 | Kankakee | Illinois | 17091 | 957 | 40 |
154846 | 154846 | 2020-05-18 | Kendall | Illinois | 17093 | 579 | 22 |
154847 | 154847 | 2020-05-18 | Knox | Illinois | 17095 | 89 | 0 |
154848 | 154848 | 2020-05-18 | LaSalle | Illinois | 17099 | 121 | 8 |
154849 | 154849 | 2020-05-18 | Lake | Illinois | 17097 | 6645 | 215 |
154850 | 154850 | 2020-05-18 | Lawrence | Illinois | 17101 | 4 | 0 |
154851 | 154851 | 2020-05-18 | Lee | Illinois | 17103 | 74 | 1 |
154852 | 154852 | 2020-05-18 | Livingston | Illinois | 17105 | 27 | 1 |
154853 | 154853 | 2020-05-18 | Logan | Illinois | 17107 | 10 | 0 |
154854 | 154854 | 2020-05-18 | Macon | Illinois | 17115 | 169 | 17 |
154855 | 154855 | 2020-05-18 | Macoupin | Illinois | 17117 | 41 | 1 |
154856 | 154856 | 2020-05-18 | Madison | Illinois | 17119 | 493 | 42 |
154857 | 154857 | 2020-05-18 | Marion | Illinois | 17121 | 48 | 0 |
154858 | 154858 | 2020-05-18 | Marshall | Illinois | 17123 | 5 | 0 |
154859 | 154859 | 2020-05-18 | Mason | Illinois | 17125 | 16 | 0 |
154860 | 154860 | 2020-05-18 | Massac | Illinois | 17127 | 6 | 0 |
154861 | 154861 | 2020-05-18 | McDonough | Illinois | 17109 | 64 | 2 |
154862 | 154862 | 2020-05-18 | McHenry | Illinois | 17111 | 1209 | 62 |
154863 | 154863 | 2020-05-18 | McLean | Illinois | 17113 | 186 | 6 |
154864 | 154864 | 2020-05-18 | Menard | Illinois | 17129 | 17 | 0 |
154865 | 154865 | 2020-05-18 | Mercer | Illinois | 17131 | 14 | 0 |
154866 | 154866 | 2020-05-18 | Monroe | Illinois | 17133 | 89 | 11 |
154867 | 154867 | 2020-05-18 | Montgomery | Illinois | 17135 | 39 | 0 |
154868 | 154868 | 2020-05-18 | Morgan | Illinois | 17137 | 36 | 1 |
154869 | 154869 | 2020-05-18 | Moultrie | Illinois | 17139 | 8 | 0 |
154870 | 154870 | 2020-05-18 | Ogle | Illinois | 17141 | 180 | 2 |
154871 | 154871 | 2020-05-18 | Peoria | Illinois | 17143 | 160 | 6 |
154872 | 154872 | 2020-05-18 | Perry | Illinois | 17145 | 39 | 0 |
154873 | 154873 | 2020-05-18 | Piatt | Illinois | 17147 | 9 | 0 |
154874 | 154874 | 2020-05-18 | Pike | Illinois | 17149 | 1 | 0 |
154875 | 154875 | 2020-05-18 | Pope | Illinois | 17151 | 1 | 0 |
154876 | 154876 | 2020-05-18 | Pulaski | Illinois | 17153 | 40 | 0 |
154877 | 154877 | 2020-05-18 | Putnam | Illinois | 17155 | 1 | 0 |
154878 | 154878 | 2020-05-18 | Randolph | Illinois | 17157 | 237 | 3 |
154879 | 154879 | 2020-05-18 | Richland | Illinois | 17159 | 3 | 0 |
154880 | 154880 | 2020-05-18 | Rock Island | Illinois | 17161 | 590 | 18 |
154881 | 154881 | 2020-05-18 | Saline | Illinois | 17165 | 6 | 0 |
154882 | 154882 | 2020-05-18 | Sangamon | Illinois | 17167 | 319 | 27 |
154883 | 154883 | 2020-05-18 | Schuyler | Illinois | 17169 | 7 | 0 |
154884 | 154884 | 2020-05-18 | Shelby | Illinois | 17173 | 13 | 1 |
154885 | 154885 | 2020-05-18 | St. Clair | Illinois | 17163 | 893 | 69 |
154886 | 154886 | 2020-05-18 | Stark | Illinois | 17175 | 2 | 0 |
154887 | 154887 | 2020-05-18 | Stephenson | Illinois | 17177 | 156 | 1 |
154888 | 154888 | 2020-05-18 | Tazewell | Illinois | 17179 | 63 | 4 |
154889 | 154889 | 2020-05-18 | Union | Illinois | 17181 | 122 | 4 |
154890 | 154890 | 2020-05-18 | Vermilion | Illinois | 17183 | 31 | 1 |
154891 | 154891 | 2020-05-18 | Wabash | Illinois | 17185 | 1 | 0 |
154892 | 154892 | 2020-05-18 | Warren | Illinois | 17187 | 109 | 0 |
154893 | 154893 | 2020-05-18 | Washington | Illinois | 17189 | 17 | 0 |
154894 | 154894 | 2020-05-18 | Wayne | Illinois | 17191 | 9 | 1 |
154895 | 154895 | 2020-05-18 | White | Illinois | 17193 | 2 | 0 |
154896 | 154896 | 2020-05-18 | Whiteside | Illinois | 17195 | 123 | 9 |
154897 | 154897 | 2020-05-18 | Will | Illinois | 17197 | 4508 | 240 |
154898 | 154898 | 2020-05-18 | Williamson | Illinois | 17199 | 52 | 1 |
154899 | 154899 | 2020-05-18 | Winnebago | Illinois | 17201 | 1558 | 41 |
154900 | 154900 | 2020-05-18 | Woodford | Illinois | 17203 | 16 | 1 |
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);