ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-08-23" 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 |
---|---|---|---|---|---|---|---|
1645033 | 1645033 | 2021-08-23 | Adams | Illinois | 17001 | 11161 | 166 |
1645034 | 1645034 | 2021-08-23 | Alexander | Illinois | 17003 | 565 | 11 |
1645035 | 1645035 | 2021-08-23 | Bond | Illinois | 17005 | 2239 | 29 |
1645036 | 1645036 | 2021-08-23 | Boone | Illinois | 17007 | 7186 | 93 |
1645037 | 1645037 | 2021-08-23 | Brown | Illinois | 17009 | 940 | 12 |
1645038 | 1645038 | 2021-08-23 | Bureau | Illinois | 17011 | 4004 | 99 |
1645039 | 1645039 | 2021-08-23 | Calhoun | Illinois | 17013 | 583 | 5 |
1645040 | 1645040 | 2021-08-23 | Carroll | Illinois | 17015 | 2105 | 38 |
1645041 | 1645041 | 2021-08-23 | Cass | Illinois | 17017 | 2244 | 36 |
1645042 | 1645042 | 2021-08-23 | Champaign | Illinois | 17019 | 23418 | 175 |
1645043 | 1645043 | 2021-08-23 | Christian | Illinois | 17021 | 4314 | 96 |
1645044 | 1645044 | 2021-08-23 | Clark | Illinois | 17023 | 2102 | 44 |
1645045 | 1645045 | 2021-08-23 | Clay | Illinois | 17025 | 1852 | 48 |
1645046 | 1645046 | 2021-08-23 | Clinton | Illinois | 17027 | 6304 | 102 |
1645047 | 1645047 | 2021-08-23 | Coles | Illinois | 17029 | 6358 | 105 |
1645048 | 1645048 | 2021-08-23 | Cook | Illinois | 17031 | 583679 | 11237 |
1645049 | 1645049 | 2021-08-23 | Crawford | Illinois | 17033 | 2631 | 43 |
1645050 | 1645050 | 2021-08-23 | Cumberland | Illinois | 17035 | 1385 | 32 |
1645051 | 1645051 | 2021-08-23 | De Witt | Illinois | 17039 | 1732 | 36 |
1645052 | 1645052 | 2021-08-23 | DeKalb | Illinois | 17037 | 10992 | 128 |
1645053 | 1645053 | 2021-08-23 | Douglas | Illinois | 17041 | 2801 | 42 |
1645054 | 1645054 | 2021-08-23 | DuPage | Illinois | 17043 | 97864 | 1415 |
1645055 | 1645055 | 2021-08-23 | Edgar | Illinois | 17045 | 1913 | 62 |
1645056 | 1645056 | 2021-08-23 | Edwards | Illinois | 17047 | 763 | 14 |
1645057 | 1645057 | 2021-08-23 | Effingham | Illinois | 17049 | 5043 | 87 |
1645058 | 1645058 | 2021-08-23 | Fayette | Illinois | 17051 | 3410 | 59 |
1645059 | 1645059 | 2021-08-23 | Ford | Illinois | 17053 | 2066 | 60 |
1645060 | 1645060 | 2021-08-23 | Franklin | Illinois | 17055 | 5752 | 95 |
1645061 | 1645061 | 2021-08-23 | Fulton | Illinois | 17057 | 4393 | 70 |
1645062 | 1645062 | 2021-08-23 | Gallatin | Illinois | 17059 | 602 | 5 |
1645063 | 1645063 | 2021-08-23 | Greene | Illinois | 17061 | 1737 | 48 |
1645064 | 1645064 | 2021-08-23 | Grundy | Illinois | 17063 | 6451 | 83 |
1645065 | 1645065 | 2021-08-23 | Hamilton | Illinois | 17065 | 1024 | 19 |
1645066 | 1645066 | 2021-08-23 | Hancock | Illinois | 17067 | 2197 | 44 |
1645067 | 1645067 | 2021-08-23 | Hardin | Illinois | 17069 | 482 | 12 |
1645068 | 1645068 | 2021-08-23 | Henderson | Illinois | 17071 | 573 | 23 |
1645069 | 1645069 | 2021-08-23 | Henry | Illinois | 17073 | 5452 | 99 |
1645070 | 1645070 | 2021-08-23 | Iroquois | Illinois | 17075 | 3489 | 71 |
1645071 | 1645071 | 2021-08-23 | Jackson | Illinois | 17077 | 6484 | 81 |
1645072 | 1645072 | 2021-08-23 | Jasper | Illinois | 17079 | 1254 | 20 |
1645073 | 1645073 | 2021-08-23 | Jefferson | Illinois | 17081 | 5248 | 127 |
1645074 | 1645074 | 2021-08-23 | Jersey | Illinois | 17083 | 2982 | 71 |
1645075 | 1645075 | 2021-08-23 | Jo Daviess | Illinois | 17085 | 1915 | 27 |
1645076 | 1645076 | 2021-08-23 | Johnson | Illinois | 17087 | 1808 | 25 |
1645077 | 1645077 | 2021-08-23 | Kane | Illinois | 17089 | 62439 | 874 |
1645078 | 1645078 | 2021-08-23 | Kankakee | Illinois | 17091 | 15365 | 232 |
1645079 | 1645079 | 2021-08-23 | Kendall | Illinois | 17093 | 14682 | 110 |
1645080 | 1645080 | 2021-08-23 | Knox | Illinois | 17095 | 6002 | 188 |
1645081 | 1645081 | 2021-08-23 | LaSalle | Illinois | 17099 | 13496 | 319 |
1645082 | 1645082 | 2021-08-23 | Lake | Illinois | 17097 | 72281 | 1103 |
1645083 | 1645083 | 2021-08-23 | Lawrence | Illinois | 17101 | 2625 | 38 |
1645084 | 1645084 | 2021-08-23 | Lee | Illinois | 17103 | 4335 | 95 |
1645085 | 1645085 | 2021-08-23 | Livingston | Illinois | 17105 | 5151 | 106 |
1645086 | 1645086 | 2021-08-23 | Logan | Illinois | 17107 | 4430 | 80 |
1645087 | 1645087 | 2021-08-23 | Macon | Illinois | 17115 | 12286 | 227 |
1645088 | 1645088 | 2021-08-23 | Macoupin | Illinois | 17117 | 5477 | 122 |
1645089 | 1645089 | 2021-08-23 | Madison | Illinois | 17119 | 35127 | 620 |
1645090 | 1645090 | 2021-08-23 | Marion | Illinois | 17121 | 5598 | 133 |
1645091 | 1645091 | 2021-08-23 | Marshall | Illinois | 17123 | 1210 | 21 |
1645092 | 1645092 | 2021-08-23 | Mason | Illinois | 17125 | 1783 | 49 |
1645093 | 1645093 | 2021-08-23 | Massac | Illinois | 17127 | 1620 | 45 |
1645094 | 1645094 | 2021-08-23 | McDonough | Illinois | 17109 | 3311 | 64 |
1645095 | 1645095 | 2021-08-23 | McHenry | Illinois | 17111 | 31040 | 328 |
1645096 | 1645096 | 2021-08-23 | McLean | Illinois | 17113 | 20057 | 231 |
1645097 | 1645097 | 2021-08-23 | Menard | Illinois | 17129 | 1398 | 16 |
1645098 | 1645098 | 2021-08-23 | Mercer | Illinois | 17131 | 1629 | 34 |
1645099 | 1645099 | 2021-08-23 | Monroe | Illinois | 17133 | 4789 | 96 |
1645100 | 1645100 | 2021-08-23 | Montgomery | Illinois | 17135 | 4122 | 80 |
1645101 | 1645101 | 2021-08-23 | Morgan | Illinois | 17137 | 4645 | 117 |
1645102 | 1645102 | 2021-08-23 | Moultrie | Illinois | 17139 | 1787 | 37 |
1645103 | 1645103 | 2021-08-23 | Ogle | Illinois | 17141 | 6523 | 92 |
1645104 | 1645104 | 2021-08-23 | Peoria | Illinois | 17143 | 24473 | 379 |
1645105 | 1645105 | 2021-08-23 | Perry | Illinois | 17145 | 3689 | 74 |
1645106 | 1645106 | 2021-08-23 | Piatt | Illinois | 17147 | 1704 | 20 |
1645107 | 1645107 | 2021-08-23 | Pike | Illinois | 17149 | 2281 | 57 |
1645108 | 1645108 | 2021-08-23 | Pope | Illinois | 17151 | 391 | 4 |
1645109 | 1645109 | 2021-08-23 | Pulaski | Illinois | 17153 | 834 | 9 |
1645110 | 1645110 | 2021-08-23 | Putnam | Illinois | 17155 | 516 | 4 |
1645111 | 1645111 | 2021-08-23 | Randolph | Illinois | 17157 | 4842 | 96 |
1645112 | 1645112 | 2021-08-23 | Richland | Illinois | 17159 | 2075 | 56 |
1645113 | 1645113 | 2021-08-23 | Rock Island | Illinois | 17161 | 16310 | 375 |
1645114 | 1645114 | 2021-08-23 | Saline | Illinois | 17165 | 3176 | 74 |
1645115 | 1645115 | 2021-08-23 | Sangamon | Illinois | 17167 | 21933 | 291 |
1645116 | 1645116 | 2021-08-23 | Schuyler | Illinois | 17169 | 890 | 19 |
1645117 | 1645117 | 2021-08-23 | Scott | Illinois | 17171 | 620 | 2 |
1645118 | 1645118 | 2021-08-23 | Shelby | Illinois | 17173 | 2538 | 43 |
1645119 | 1645119 | 2021-08-23 | St. Clair | Illinois | 17163 | 36161 | 584 |
1645120 | 1645120 | 2021-08-23 | Stark | Illinois | 17175 | 708 | 26 |
1645121 | 1645121 | 2021-08-23 | Stephenson | Illinois | 17177 | 5055 | 106 |
1645122 | 1645122 | 2021-08-23 | Tazewell | Illinois | 17179 | 18452 | 347 |
1645123 | 1645123 | 2021-08-23 | Union | Illinois | 17181 | 2740 | 46 |
1645124 | 1645124 | 2021-08-23 | Unknown | Illinois | 0 | 488 | |
1645125 | 1645125 | 2021-08-23 | Vermilion | Illinois | 17183 | 11418 | 178 |
1645126 | 1645126 | 2021-08-23 | Wabash | Illinois | 17185 | 1703 | 15 |
1645127 | 1645127 | 2021-08-23 | Warren | Illinois | 17187 | 1962 | 53 |
1645128 | 1645128 | 2021-08-23 | Washington | Illinois | 17189 | 1876 | 31 |
1645129 | 1645129 | 2021-08-23 | Wayne | Illinois | 17191 | 2181 | 55 |
1645130 | 1645130 | 2021-08-23 | White | Illinois | 17193 | 2090 | 37 |
1645131 | 1645131 | 2021-08-23 | Whiteside | Illinois | 17195 | 7533 | 216 |
1645132 | 1645132 | 2021-08-23 | Will | Illinois | 17197 | 82020 | 1129 |
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);