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 |
---|---|---|---|---|---|---|---|
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 |
79090 | 79090 | 2020-04-22 | St. Clair | Illinois | 17163 | 316 | 19 |
76306 | 76306 | 2020-04-21 | St. Clair | Illinois | 17163 | 289 | 18 |
73529 | 73529 | 2020-04-20 | St. Clair | Illinois | 17163 | 276 | 18 |
70759 | 70759 | 2020-04-19 | St. Clair | Illinois | 17163 | 271 | 18 |
67997 | 67997 | 2020-04-18 | St. Clair | Illinois | 17163 | 265 | 17 |
65248 | 65248 | 2020-04-17 | St. Clair | Illinois | 17163 | 254 | 17 |
62515 | 62515 | 2020-04-16 | St. Clair | Illinois | 17163 | 239 | 14 |
59794 | 59794 | 2020-04-15 | St. Clair | Illinois | 17163 | 225 | 10 |
57087 | 57087 | 2020-04-14 | St. Clair | Illinois | 17163 | 220 | 8 |
54394 | 54394 | 2020-04-13 | St. Clair | Illinois | 17163 | 202 | 8 |
51713 | 51713 | 2020-04-12 | St. Clair | Illinois | 17163 | 189 | 8 |
49051 | 49051 | 2020-04-11 | St. Clair | Illinois | 17163 | 173 | 7 |
46418 | 46418 | 2020-04-10 | St. Clair | Illinois | 17163 | 159 | 5 |
43814 | 43814 | 2020-04-09 | St. Clair | Illinois | 17163 | 144 | 4 |
41238 | 41238 | 2020-04-08 | St. Clair | Illinois | 17163 | 127 | 3 |
38693 | 38693 | 2020-04-07 | St. Clair | Illinois | 17163 | 109 | 3 |
36195 | 36195 | 2020-04-06 | St. Clair | Illinois | 17163 | 92 | 3 |
33743 | 33743 | 2020-04-05 | St. Clair | Illinois | 17163 | 86 | 3 |
31333 | 31333 | 2020-04-04 | St. Clair | Illinois | 17163 | 80 | 3 |
28967 | 28967 | 2020-04-03 | St. Clair | Illinois | 17163 | 57 | 3 |
26657 | 26657 | 2020-04-02 | St. Clair | Illinois | 17163 | 55 | 3 |
24419 | 24419 | 2020-04-01 | St. Clair | Illinois | 17163 | 53 | 2 |
22250 | 22250 | 2020-03-31 | St. Clair | Illinois | 17163 | 43 | 2 |
20157 | 20157 | 2020-03-30 | St. Clair | Illinois | 17163 | 36 | 3 |
18152 | 18152 | 2020-03-29 | St. Clair | Illinois | 17163 | 31 | 3 |
16250 | 16250 | 2020-03-28 | St. Clair | Illinois | 17163 | 18 | 1 |
14454 | 14454 | 2020-03-27 | St. Clair | Illinois | 17163 | 15 | 1 |
12776 | 12776 | 2020-03-26 | St. Clair | Illinois | 17163 | 13 | 0 |
11220 | 11220 | 2020-03-25 | St. Clair | Illinois | 17163 | 7 | 0 |
9827 | 9827 | 2020-03-24 | St. Clair | Illinois | 17163 | 7 | 0 |
8563 | 8563 | 2020-03-23 | St. Clair | Illinois | 17163 | 4 | 0 |
7407 | 7407 | 2020-03-22 | St. Clair | Illinois | 17163 | 3 | 0 |
6354 | 6354 | 2020-03-21 | St. Clair | Illinois | 17163 | 3 | 0 |
5419 | 5419 | 2020-03-20 | St. Clair | Illinois | 17163 | 3 | 0 |
4613 | 4613 | 2020-03-19 | St. Clair | Illinois | 17163 | 3 | 0 |
3937 | 3937 | 2020-03-18 | St. Clair | Illinois | 17163 | 3 | 0 |
3369 | 3369 | 2020-03-17 | St. Clair | Illinois | 17163 | 2 | 0 |
2880 | 2880 | 2020-03-16 | St. Clair | Illinois | 17163 | 2 | 0 |
2438 | 2438 | 2020-03-15 | St. Clair | Illinois | 17163 | 2 | 0 |
2047 | 2047 | 2020-03-14 | St. Clair | Illinois | 17163 | 2 | 0 |
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);