ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where date = "2021-01-12" 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 |
---|---|---|---|---|---|---|---|
921038 | 921038 | 2021-01-12 | Adams | Illinois | 17001 | 7192 | 99 |
921039 | 921039 | 2021-01-12 | Alexander | Illinois | 17003 | 370 | 7 |
921040 | 921040 | 2021-01-12 | Bond | Illinois | 17005 | 1695 | 20 |
921041 | 921041 | 2021-01-12 | Boone | Illinois | 17007 | 5420 | 76 |
921042 | 921042 | 2021-01-12 | Brown | Illinois | 17009 | 576 | 11 |
921043 | 921043 | 2021-01-12 | Bureau | Illinois | 17011 | 2954 | 77 |
921044 | 921044 | 2021-01-12 | Calhoun | Illinois | 17013 | 420 | 4 |
921045 | 921045 | 2021-01-12 | Carroll | Illinois | 17015 | 1399 | 32 |
921046 | 921046 | 2021-01-12 | Cass | Illinois | 17017 | 1713 | 31 |
921047 | 921047 | 2021-01-12 | Champaign | Illinois | 17019 | 14974 | 93 |
921048 | 921048 | 2021-01-12 | Christian | Illinois | 17021 | 2880 | 71 |
921049 | 921049 | 2021-01-12 | Clark | Illinois | 17023 | 1400 | 25 |
921050 | 921050 | 2021-01-12 | Clay | Illinois | 17025 | 1293 | 37 |
921051 | 921051 | 2021-01-12 | Clinton | Illinois | 17027 | 4831 | 81 |
921052 | 921052 | 2021-01-12 | Coles | Illinois | 17029 | 4602 | 78 |
921053 | 921053 | 2021-01-12 | Cook | Illinois | 17031 | 422159 | 8841 |
921054 | 921054 | 2021-01-12 | Crawford | Illinois | 17033 | 1705 | 32 |
921055 | 921055 | 2021-01-12 | Cumberland | Illinois | 17035 | 1046 | 27 |
921056 | 921056 | 2021-01-12 | De Witt | Illinois | 17039 | 1086 | 25 |
921057 | 921057 | 2021-01-12 | DeKalb | Illinois | 17037 | 7328 | 89 |
921058 | 921058 | 2021-01-12 | Douglas | Illinois | 17041 | 1967 | 32 |
921059 | 921059 | 2021-01-12 | DuPage | Illinois | 17043 | 66858 | 1116 |
921060 | 921060 | 2021-01-12 | Edgar | Illinois | 17045 | 1411 | 49 |
921061 | 921061 | 2021-01-12 | Edwards | Illinois | 17047 | 449 | 8 |
921062 | 921062 | 2021-01-12 | Effingham | Illinois | 17049 | 4207 | 65 |
921063 | 921063 | 2021-01-12 | Fayette | Illinois | 17051 | 2842 | 53 |
921064 | 921064 | 2021-01-12 | Ford | Illinois | 17053 | 1345 | 47 |
921065 | 921065 | 2021-01-12 | Franklin | Illinois | 17055 | 3693 | 65 |
921066 | 921066 | 2021-01-12 | Fulton | Illinois | 17057 | 2494 | 47 |
921067 | 921067 | 2021-01-12 | Gallatin | Illinois | 17059 | 375 | 4 |
921068 | 921068 | 2021-01-12 | Greene | Illinois | 17061 | 1221 | 42 |
921069 | 921069 | 2021-01-12 | Grundy | Illinois | 17063 | 4209 | 54 |
921070 | 921070 | 2021-01-12 | Hamilton | Illinois | 17065 | 670 | 14 |
921071 | 921071 | 2021-01-12 | Hancock | Illinois | 17067 | 1443 | 32 |
921072 | 921072 | 2021-01-12 | Hardin | Illinois | 17069 | 282 | 8 |
921073 | 921073 | 2021-01-12 | Henderson | Illinois | 17071 | 432 | 16 |
921074 | 921074 | 2021-01-12 | Henry | Illinois | 17073 | 3923 | 74 |
921075 | 921075 | 2021-01-12 | Iroquois | Illinois | 17075 | 2525 | 53 |
921076 | 921076 | 2021-01-12 | Jackson | Illinois | 17077 | 4002 | 67 |
921077 | 921077 | 2021-01-12 | Jasper | Illinois | 17079 | 1004 | 15 |
921078 | 921078 | 2021-01-12 | Jefferson | Illinois | 17081 | 3258 | 97 |
921079 | 921079 | 2021-01-12 | Jersey | Illinois | 17083 | 2122 | 51 |
921080 | 921080 | 2021-01-12 | Jo Daviess | Illinois | 17085 | 1450 | 24 |
921081 | 921081 | 2021-01-12 | Johnson | Illinois | 17087 | 1182 | 15 |
921082 | 921082 | 2021-01-12 | Kane | Illinois | 17089 | 44579 | 659 |
921083 | 921083 | 2021-01-12 | Kankakee | Illinois | 17091 | 11277 | 173 |
921084 | 921084 | 2021-01-12 | Kendall | Illinois | 17093 | 9514 | 76 |
921085 | 921085 | 2021-01-12 | Knox | Illinois | 17095 | 4411 | 137 |
921086 | 921086 | 2021-01-12 | LaSalle | Illinois | 17099 | 9031 | 244 |
921087 | 921087 | 2021-01-12 | Lake | Illinois | 17097 | 51685 | 864 |
921088 | 921088 | 2021-01-12 | Lawrence | Illinois | 17101 | 2121 | 29 |
921089 | 921089 | 2021-01-12 | Lee | Illinois | 17103 | 2921 | 70 |
921090 | 921090 | 2021-01-12 | Livingston | Illinois | 17105 | 3437 | 65 |
921091 | 921091 | 2021-01-12 | Logan | Illinois | 17107 | 2985 | 55 |
921092 | 921092 | 2021-01-12 | Macon | Illinois | 17115 | 8527 | 175 |
921093 | 921093 | 2021-01-12 | Macoupin | Illinois | 17117 | 3657 | 92 |
921094 | 921094 | 2021-01-12 | Madison | Illinois | 17119 | 23239 | 444 |
921095 | 921095 | 2021-01-12 | Marion | Illinois | 17121 | 3857 | 111 |
921096 | 921096 | 2021-01-12 | Marshall | Illinois | 17123 | 633 | 13 |
921097 | 921097 | 2021-01-12 | Mason | Illinois | 17125 | 1136 | 40 |
921098 | 921098 | 2021-01-12 | Massac | Illinois | 17127 | 978 | 30 |
921099 | 921099 | 2021-01-12 | McDonough | Illinois | 17109 | 2076 | 50 |
921100 | 921100 | 2021-01-12 | McHenry | Illinois | 17111 | 20894 | 234 |
921101 | 921101 | 2021-01-12 | McLean | Illinois | 17113 | 12772 | 146 |
921102 | 921102 | 2021-01-12 | Menard | Illinois | 17129 | 828 | 9 |
921103 | 921103 | 2021-01-12 | Mercer | Illinois | 17131 | 1151 | 27 |
921104 | 921104 | 2021-01-12 | Monroe | Illinois | 17133 | 3444 | 63 |
921105 | 921105 | 2021-01-12 | Montgomery | Illinois | 17135 | 2846 | 35 |
921106 | 921106 | 2021-01-12 | Morgan | Illinois | 17137 | 3248 | 87 |
921107 | 921107 | 2021-01-12 | Moultrie | Illinois | 17139 | 1334 | 28 |
921108 | 921108 | 2021-01-12 | Ogle | Illinois | 17141 | 4496 | 66 |
921109 | 921109 | 2021-01-12 | Peoria | Illinois | 17143 | 14426 | 226 |
921110 | 921110 | 2021-01-12 | Perry | Illinois | 17145 | 2512 | 60 |
921111 | 921111 | 2021-01-12 | Piatt | Illinois | 17147 | 1136 | 14 |
921112 | 921112 | 2021-01-12 | Pike | Illinois | 17149 | 1511 | 43 |
921113 | 921113 | 2021-01-12 | Pope | Illinois | 17151 | 230 | 2 |
921114 | 921114 | 2021-01-12 | Pulaski | Illinois | 17153 | 587 | 3 |
921115 | 921115 | 2021-01-12 | Putnam | Illinois | 17155 | 342 | 1 |
921116 | 921116 | 2021-01-12 | Randolph | Illinois | 17157 | 3603 | 62 |
921117 | 921117 | 2021-01-12 | Richland | Illinois | 17159 | 1486 | 40 |
921118 | 921118 | 2021-01-12 | Rock Island | Illinois | 17161 | 11595 | 294 |
921119 | 921119 | 2021-01-12 | Saline | Illinois | 17165 | 1958 | 49 |
921120 | 921120 | 2021-01-12 | Sangamon | Illinois | 17167 | 14076 | 226 |
921121 | 921121 | 2021-01-12 | Schuyler | Illinois | 17169 | 590 | 15 |
921122 | 921122 | 2021-01-12 | Scott | Illinois | 17171 | 362 | 1 |
921123 | 921123 | 2021-01-12 | Shelby | Illinois | 17173 | 1915 | 34 |
921124 | 921124 | 2021-01-12 | St. Clair | Illinois | 17163 | 23479 | 398 |
921125 | 921125 | 2021-01-12 | Stark | Illinois | 17175 | 489 | 20 |
921126 | 921126 | 2021-01-12 | Stephenson | Illinois | 17177 | 3428 | 73 |
921127 | 921127 | 2021-01-12 | Tazewell | Illinois | 17179 | 11588 | 233 |
921128 | 921128 | 2021-01-12 | Union | Illinois | 17181 | 1903 | 32 |
921129 | 921129 | 2021-01-12 | Vermilion | Illinois | 17183 | 7125 | 101 |
921130 | 921130 | 2021-01-12 | Wabash | Illinois | 17185 | 1143 | 14 |
921131 | 921131 | 2021-01-12 | Warren | Illinois | 17187 | 1564 | 42 |
921132 | 921132 | 2021-01-12 | Washington | Illinois | 17189 | 1392 | 25 |
921133 | 921133 | 2021-01-12 | Wayne | Illinois | 17191 | 1450 | 43 |
921134 | 921134 | 2021-01-12 | White | Illinois | 17193 | 1284 | 29 |
921135 | 921135 | 2021-01-12 | Whiteside | Illinois | 17195 | 5225 | 172 |
921136 | 921136 | 2021-01-12 | Will | Illinois | 17197 | 56435 | 845 |
921137 | 921137 | 2021-01-12 | Williamson | Illinois | 17199 | 5963 | 112 |
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);