ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 17197 and state = "Illinois" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2882 | 2882 | 2020-03-16 | Will | Illinois | 17197 | 1 | 0 |
3371 | 3371 | 2020-03-17 | Will | Illinois | 17197 | 2 | 0 |
3940 | 3940 | 2020-03-18 | Will | Illinois | 17197 | 9 | 0 |
4616 | 4616 | 2020-03-19 | Will | Illinois | 17197 | 11 | 1 |
5422 | 5422 | 2020-03-20 | Will | Illinois | 17197 | 12 | 1 |
6357 | 6357 | 2020-03-21 | Will | Illinois | 17197 | 12 | 1 |
7411 | 7411 | 2020-03-22 | Will | Illinois | 17197 | 21 | 1 |
8568 | 8568 | 2020-03-23 | Will | Illinois | 17197 | 24 | 1 |
9832 | 9832 | 2020-03-24 | Will | Illinois | 17197 | 24 | 1 |
11225 | 11225 | 2020-03-25 | Will | Illinois | 17197 | 50 | 2 |
12781 | 12781 | 2020-03-26 | Will | Illinois | 17197 | 67 | 3 |
14459 | 14459 | 2020-03-27 | Will | Illinois | 17197 | 104 | 3 |
16256 | 16256 | 2020-03-28 | Will | Illinois | 17197 | 156 | 4 |
18157 | 18157 | 2020-03-29 | Will | Illinois | 17197 | 192 | 4 |
20163 | 20163 | 2020-03-30 | Will | Illinois | 17197 | 224 | 6 |
22256 | 22256 | 2020-03-31 | Will | Illinois | 17197 | 228 | 8 |
24426 | 24426 | 2020-04-01 | Will | Illinois | 17197 | 322 | 9 |
26664 | 26664 | 2020-04-02 | Will | Illinois | 17197 | 384 | 9 |
28974 | 28974 | 2020-04-03 | Will | Illinois | 17197 | 455 | 10 |
31340 | 31340 | 2020-04-04 | Will | Illinois | 17197 | 606 | 11 |
33750 | 33750 | 2020-04-05 | Will | Illinois | 17197 | 668 | 15 |
36203 | 36203 | 2020-04-06 | Will | Illinois | 17197 | 697 | 19 |
38701 | 38701 | 2020-04-07 | Will | Illinois | 17197 | 840 | 30 |
41247 | 41247 | 2020-04-08 | Will | Illinois | 17197 | 914 | 35 |
43823 | 43823 | 2020-04-09 | Will | Illinois | 17197 | 1012 | 46 |
46427 | 46427 | 2020-04-10 | Will | Illinois | 17197 | 1077 | 52 |
49061 | 49061 | 2020-04-11 | Will | Illinois | 17197 | 1126 | 56 |
51723 | 51723 | 2020-04-12 | Will | Illinois | 17197 | 1228 | 60 |
54404 | 54404 | 2020-04-13 | Will | Illinois | 17197 | 1283 | 63 |
57097 | 57097 | 2020-04-14 | Will | Illinois | 17197 | 1350 | 77 |
59805 | 59805 | 2020-04-15 | Will | Illinois | 17197 | 1433 | 81 |
62526 | 62526 | 2020-04-16 | Will | Illinois | 17197 | 1494 | 88 |
65260 | 65260 | 2020-04-17 | Will | Illinois | 17197 | 1566 | 92 |
68009 | 68009 | 2020-04-18 | Will | Illinois | 17197 | 1603 | 97 |
70771 | 70771 | 2020-04-19 | Will | Illinois | 17197 | 1643 | 101 |
73542 | 73542 | 2020-04-20 | Will | Illinois | 17197 | 1692 | 102 |
76319 | 76319 | 2020-04-21 | Will | Illinois | 17197 | 1736 | 105 |
79103 | 79103 | 2020-04-22 | Will | Illinois | 17197 | 1820 | 110 |
81896 | 81896 | 2020-04-23 | Will | Illinois | 17197 | 1885 | 119 |
84696 | 84696 | 2020-04-24 | Will | Illinois | 17197 | 2009 | 125 |
87506 | 87506 | 2020-04-25 | Will | Illinois | 17197 | 2060 | 131 |
90322 | 90322 | 2020-04-26 | Will | Illinois | 17197 | 2126 | 133 |
93141 | 93141 | 2020-04-27 | Will | Illinois | 17197 | 2173 | 136 |
95973 | 95973 | 2020-04-28 | Will | Illinois | 17197 | 2254 | 145 |
98817 | 98817 | 2020-04-29 | Will | Illinois | 17197 | 2369 | 148 |
101668 | 101668 | 2020-04-30 | Will | Illinois | 17197 | 2492 | 151 |
104524 | 104524 | 2020-05-01 | Will | Illinois | 17197 | 2617 | 158 |
107389 | 107389 | 2020-05-02 | Will | Illinois | 17197 | 2796 | 164 |
110259 | 110259 | 2020-05-03 | Will | Illinois | 17197 | 2868 | 165 |
113134 | 113134 | 2020-05-04 | Will | Illinois | 17197 | 3066 | 169 |
116017 | 116017 | 2020-05-05 | Will | Illinois | 17197 | 3150 | 178 |
118977 | 118977 | 2020-05-06 | Will | Illinois | 17197 | 3332 | 189 |
121947 | 121947 | 2020-05-07 | Will | Illinois | 17197 | 3434 | 195 |
124927 | 124927 | 2020-05-08 | Will | Illinois | 17197 | 3561 | 199 |
127914 | 127914 | 2020-05-09 | Will | Illinois | 17197 | 3636 | 202 |
130905 | 130905 | 2020-05-10 | Will | Illinois | 17197 | 3684 | 202 |
133895 | 133895 | 2020-05-11 | Will | Illinois | 17197 | 3740 | 202 |
136884 | 136884 | 2020-05-12 | Will | Illinois | 17197 | 3896 | 210 |
139876 | 139876 | 2020-05-13 | Will | Illinois | 17197 | 3973 | 214 |
142872 | 142872 | 2020-05-14 | Will | Illinois | 17197 | 4090 | 231 |
145872 | 145872 | 2020-05-15 | Will | Illinois | 17197 | 4277 | 237 |
148876 | 148876 | 2020-05-16 | Will | Illinois | 17197 | 4312 | 240 |
151885 | 151885 | 2020-05-17 | Will | Illinois | 17197 | 4388 | 240 |
154897 | 154897 | 2020-05-18 | Will | Illinois | 17197 | 4508 | 240 |
157913 | 157913 | 2020-05-19 | Will | Illinois | 17197 | 4577 | 244 |
160939 | 160939 | 2020-05-20 | Will | Illinois | 17197 | 4718 | 248 |
163967 | 163967 | 2020-05-21 | Will | Illinois | 17197 | 4811 | 252 |
167000 | 167000 | 2020-05-22 | Will | Illinois | 17197 | 4966 | 255 |
170037 | 170037 | 2020-05-23 | Will | Illinois | 17197 | 5012 | 257 |
173078 | 173078 | 2020-05-24 | Will | Illinois | 17197 | 5117 | 257 |
176122 | 176122 | 2020-05-25 | Will | Illinois | 17197 | 5188 | 258 |
179166 | 179166 | 2020-05-26 | Will | Illinois | 17197 | 5255 | 259 |
182210 | 182210 | 2020-05-27 | Will | Illinois | 17197 | 5301 | 264 |
185264 | 185264 | 2020-05-28 | Will | Illinois | 17197 | 5356 | 268 |
188322 | 188322 | 2020-05-29 | Will | Illinois | 17197 | 5459 | 269 |
191387 | 191387 | 2020-05-30 | Will | Illinois | 17197 | 5510 | 273 |
194454 | 194454 | 2020-05-31 | Will | Illinois | 17197 | 5566 | 276 |
197524 | 197524 | 2020-06-01 | Will | Illinois | 17197 | 5641 | 279 |
200597 | 200597 | 2020-06-02 | Will | Illinois | 17197 | 5649 | 280 |
203673 | 203673 | 2020-06-03 | Will | Illinois | 17197 | 5730 | 283 |
206753 | 206753 | 2020-06-04 | Will | Illinois | 17197 | 5752 | 286 |
209834 | 209834 | 2020-06-05 | Will | Illinois | 17197 | 5799 | 285 |
212919 | 212919 | 2020-06-06 | Will | Illinois | 17197 | 5858 | 285 |
216006 | 216006 | 2020-06-07 | Will | Illinois | 17197 | 5890 | 288 |
219098 | 219098 | 2020-06-08 | Will | Illinois | 17197 | 5942 | 289 |
222193 | 222193 | 2020-06-09 | Will | Illinois | 17197 | 5961 | 295 |
225288 | 225288 | 2020-06-10 | Will | Illinois | 17197 | 6025 | 296 |
228390 | 228390 | 2020-06-11 | Will | Illinois | 17197 | 6051 | 297 |
231493 | 231493 | 2020-06-12 | Will | Illinois | 17197 | 6100 | 300 |
234599 | 234599 | 2020-06-13 | Will | Illinois | 17197 | 6106 | 301 |
237706 | 237706 | 2020-06-14 | Will | Illinois | 17197 | 6140 | 302 |
240814 | 240814 | 2020-06-15 | Will | Illinois | 17197 | 6158 | 302 |
243925 | 243925 | 2020-06-16 | Will | Illinois | 17197 | 6207 | 303 |
247038 | 247038 | 2020-06-17 | Will | Illinois | 17197 | 6222 | 308 |
250150 | 250150 | 2020-06-18 | Will | Illinois | 17197 | 6258 | 310 |
253265 | 253265 | 2020-06-19 | Will | Illinois | 17197 | 6301 | 310 |
256385 | 256385 | 2020-06-20 | Will | Illinois | 17197 | 6317 | 310 |
259511 | 259511 | 2020-06-21 | Will | Illinois | 17197 | 6367 | 310 |
262638 | 262638 | 2020-06-22 | Will | Illinois | 17197 | 6398 | 310 |
265766 | 265766 | 2020-06-23 | Will | Illinois | 17197 | 6446 | 310 |
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);