ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17163 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386621 | 386621 | 2020-07-31 | St. Clair | Illinois | 17163 | 3792 | 155 |
383403 | 383403 | 2020-07-30 | St. Clair | Illinois | 17163 | 3708 | 154 |
380186 | 380186 | 2020-07-29 | St. Clair | Illinois | 17163 | 3659 | 154 |
376969 | 376969 | 2020-07-28 | St. Clair | Illinois | 17163 | 3593 | 154 |
373754 | 373754 | 2020-07-27 | St. Clair | Illinois | 17163 | 3530 | 153 |
370542 | 370542 | 2020-07-26 | St. Clair | Illinois | 17163 | 3473 | 153 |
367332 | 367332 | 2020-07-25 | St. Clair | Illinois | 17163 | 3433 | 153 |
364125 | 364125 | 2020-07-24 | St. Clair | Illinois | 17163 | 3357 | 152 |
360918 | 360918 | 2020-07-23 | St. Clair | Illinois | 17163 | 3270 | 152 |
357713 | 357713 | 2020-07-22 | St. Clair | Illinois | 17163 | 3210 | 152 |
354511 | 354511 | 2020-07-21 | St. Clair | Illinois | 17163 | 3138 | 151 |
351309 | 351309 | 2020-07-20 | St. Clair | Illinois | 17163 | 3095 | 150 |
348109 | 348109 | 2020-07-19 | St. Clair | Illinois | 17163 | 3053 | 150 |
344908 | 344908 | 2020-07-18 | St. Clair | Illinois | 17163 | 2976 | 149 |
341708 | 341708 | 2020-07-17 | St. Clair | Illinois | 17163 | 2871 | 148 |
338512 | 338512 | 2020-07-16 | St. Clair | Illinois | 17163 | 2803 | 147 |
335316 | 335316 | 2020-07-15 | St. Clair | Illinois | 17163 | 2732 | 147 |
332123 | 332123 | 2020-07-14 | St. Clair | Illinois | 17163 | 2471 | 145 |
328936 | 328936 | 2020-07-13 | St. Clair | Illinois | 17163 | 2471 | 144 |
325750 | 325750 | 2020-07-12 | St. Clair | Illinois | 17163 | 2471 | 144 |
322569 | 322569 | 2020-07-11 | St. Clair | Illinois | 17163 | 2471 | 144 |
319390 | 319390 | 2020-07-10 | St. Clair | Illinois | 17163 | 2471 | 144 |
316217 | 316217 | 2020-07-09 | St. Clair | Illinois | 17163 | 2412 | 144 |
313043 | 313043 | 2020-07-08 | St. Clair | Illinois | 17163 | 2297 | 143 |
309873 | 309873 | 2020-07-07 | St. Clair | Illinois | 17163 | 2297 | 140 |
306705 | 306705 | 2020-07-06 | St. Clair | Illinois | 17163 | 2208 | 140 |
303540 | 303540 | 2020-07-05 | St. Clair | Illinois | 17163 | 2208 | 140 |
300376 | 300376 | 2020-07-04 | St. Clair | Illinois | 17163 | 2208 | 140 |
297214 | 297214 | 2020-07-03 | St. Clair | Illinois | 17163 | 2167 | 139 |
294056 | 294056 | 2020-07-02 | St. Clair | Illinois | 17163 | 2167 | 139 |
290902 | 290902 | 2020-07-01 | St. Clair | Illinois | 17163 | 2133 | 138 |
287752 | 287752 | 2020-06-30 | St. Clair | Illinois | 17163 | 2086 | 138 |
284603 | 284603 | 2020-06-29 | St. Clair | Illinois | 17163 | 2039 | 138 |
281458 | 281458 | 2020-06-28 | St. Clair | Illinois | 17163 | 1956 | 138 |
278310 | 278310 | 2020-06-27 | St. Clair | Illinois | 17163 | 1956 | 138 |
275162 | 275162 | 2020-06-26 | St. Clair | Illinois | 17163 | 1921 | 136 |
272020 | 272020 | 2020-06-25 | St. Clair | Illinois | 17163 | 1896 | 136 |
268883 | 268883 | 2020-06-24 | St. Clair | Illinois | 17163 | 1869 | 136 |
265753 | 265753 | 2020-06-23 | St. Clair | Illinois | 17163 | 1816 | 135 |
262625 | 262625 | 2020-06-22 | St. Clair | Illinois | 17163 | 1799 | 132 |
259498 | 259498 | 2020-06-21 | St. Clair | Illinois | 17163 | 1799 | 132 |
256372 | 256372 | 2020-06-20 | St. Clair | Illinois | 17163 | 1772 | 131 |
253252 | 253252 | 2020-06-19 | St. Clair | Illinois | 17163 | 1748 | 131 |
250137 | 250137 | 2020-06-18 | St. Clair | Illinois | 17163 | 1716 | 131 |
247025 | 247025 | 2020-06-17 | St. Clair | Illinois | 17163 | 1698 | 130 |
243912 | 243912 | 2020-06-16 | St. Clair | Illinois | 17163 | 1668 | 130 |
240801 | 240801 | 2020-06-15 | St. Clair | Illinois | 17163 | 1662 | 129 |
237693 | 237693 | 2020-06-14 | St. Clair | Illinois | 17163 | 1626 | 126 |
234586 | 234586 | 2020-06-13 | St. Clair | Illinois | 17163 | 1610 | 124 |
231480 | 231480 | 2020-06-12 | St. Clair | Illinois | 17163 | 1569 | 123 |
228377 | 228377 | 2020-06-11 | St. Clair | Illinois | 17163 | 1546 | 117 |
225275 | 225275 | 2020-06-10 | St. Clair | Illinois | 17163 | 1490 | 112 |
222180 | 222180 | 2020-06-09 | St. Clair | Illinois | 17163 | 1490 | 112 |
219085 | 219085 | 2020-06-08 | St. Clair | Illinois | 17163 | 1467 | 109 |
215994 | 215994 | 2020-06-07 | St. Clair | Illinois | 17163 | 1450 | 106 |
212907 | 212907 | 2020-06-06 | St. Clair | Illinois | 17163 | 1440 | 105 |
209822 | 209822 | 2020-06-05 | St. Clair | Illinois | 17163 | 1404 | 104 |
206741 | 206741 | 2020-06-04 | St. Clair | Illinois | 17163 | 1362 | 102 |
203661 | 203661 | 2020-06-03 | St. Clair | Illinois | 17163 | 1331 | 101 |
200585 | 200585 | 2020-06-02 | St. Clair | Illinois | 17163 | 1299 | 98 |
197512 | 197512 | 2020-06-01 | St. Clair | Illinois | 17163 | 1257 | 97 |
194442 | 194442 | 2020-05-31 | St. Clair | Illinois | 17163 | 1230 | 96 |
191375 | 191375 | 2020-05-30 | St. Clair | Illinois | 17163 | 1217 | 95 |
188310 | 188310 | 2020-05-29 | St. Clair | Illinois | 17163 | 1198 | 94 |
185252 | 185252 | 2020-05-28 | St. Clair | Illinois | 17163 | 1167 | 92 |
182198 | 182198 | 2020-05-27 | St. Clair | Illinois | 17163 | 1117 | 83 |
179154 | 179154 | 2020-05-26 | St. Clair | Illinois | 17163 | 1117 | 83 |
176110 | 176110 | 2020-05-25 | St. Clair | Illinois | 17163 | 1097 | 82 |
173066 | 173066 | 2020-05-24 | St. Clair | Illinois | 17163 | 1079 | 82 |
170025 | 170025 | 2020-05-23 | St. Clair | Illinois | 17163 | 1016 | 79 |
166988 | 166988 | 2020-05-22 | St. Clair | Illinois | 17163 | 983 | 74 |
163955 | 163955 | 2020-05-21 | St. Clair | Illinois | 17163 | 961 | 72 |
160927 | 160927 | 2020-05-20 | St. Clair | Illinois | 17163 | 926 | 70 |
157901 | 157901 | 2020-05-19 | St. Clair | Illinois | 17163 | 905 | 69 |
154885 | 154885 | 2020-05-18 | St. Clair | Illinois | 17163 | 893 | 69 |
151873 | 151873 | 2020-05-17 | St. Clair | Illinois | 17163 | 875 | 68 |
148864 | 148864 | 2020-05-16 | St. Clair | Illinois | 17163 | 850 | 67 |
145860 | 145860 | 2020-05-15 | St. Clair | Illinois | 17163 | 805 | 66 |
142860 | 142860 | 2020-05-14 | St. Clair | Illinois | 17163 | 788 | 64 |
139864 | 139864 | 2020-05-13 | St. Clair | Illinois | 17163 | 788 | 64 |
136872 | 136872 | 2020-05-12 | St. Clair | Illinois | 17163 | 771 | 63 |
133883 | 133883 | 2020-05-11 | St. Clair | Illinois | 17163 | 761 | 59 |
130892 | 130892 | 2020-05-10 | St. Clair | Illinois | 17163 | 711 | 59 |
127901 | 127901 | 2020-05-09 | St. Clair | Illinois | 17163 | 689 | 55 |
124914 | 124914 | 2020-05-08 | St. Clair | Illinois | 17163 | 648 | 55 |
121934 | 121934 | 2020-05-07 | St. Clair | Illinois | 17163 | 623 | 55 |
118964 | 118964 | 2020-05-06 | St. Clair | Illinois | 17163 | 601 | 42 |
116004 | 116004 | 2020-05-05 | St. Clair | Illinois | 17163 | 579 | 41 |
113121 | 113121 | 2020-05-04 | St. Clair | Illinois | 17163 | 551 | 34 |
110246 | 110246 | 2020-05-03 | St. Clair | Illinois | 17163 | 537 | 33 |
107376 | 107376 | 2020-05-02 | St. Clair | Illinois | 17163 | 507 | 33 |
104511 | 104511 | 2020-05-01 | St. Clair | Illinois | 17163 | 492 | 31 |
101655 | 101655 | 2020-04-30 | St. Clair | Illinois | 17163 | 475 | 30 |
98804 | 98804 | 2020-04-29 | St. Clair | Illinois | 17163 | 442 | 29 |
95960 | 95960 | 2020-04-28 | St. Clair | Illinois | 17163 | 434 | 25 |
93128 | 93128 | 2020-04-27 | St. Clair | Illinois | 17163 | 403 | 24 |
90309 | 90309 | 2020-04-26 | St. Clair | Illinois | 17163 | 391 | 24 |
87493 | 87493 | 2020-04-25 | St. Clair | Illinois | 17163 | 363 | 24 |
84683 | 84683 | 2020-04-24 | St. Clair | Illinois | 17163 | 350 | 19 |
81883 | 81883 | 2020-04-23 | St. Clair | Illinois | 17163 | 330 | 19 |
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);