ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "McLean" and state = "Illinois" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5416 | 5416 | 2020-03-20 | McLean | Illinois | 17113 | 4 | 0 |
6351 | 6351 | 2020-03-21 | McLean | Illinois | 17113 | 6 | 0 |
7403 | 7403 | 2020-03-22 | McLean | Illinois | 17113 | 6 | 1 |
8558 | 8558 | 2020-03-23 | McLean | Illinois | 17113 | 7 | 1 |
9822 | 9822 | 2020-03-24 | McLean | Illinois | 17113 | 7 | 1 |
11214 | 11214 | 2020-03-25 | McLean | Illinois | 17113 | 7 | 1 |
12770 | 12770 | 2020-03-26 | McLean | Illinois | 17113 | 7 | 1 |
14448 | 14448 | 2020-03-27 | McLean | Illinois | 17113 | 10 | 1 |
16244 | 16244 | 2020-03-28 | McLean | Illinois | 17113 | 10 | 1 |
18144 | 18144 | 2020-03-29 | McLean | Illinois | 17113 | 14 | 1 |
20147 | 20147 | 2020-03-30 | McLean | Illinois | 17113 | 17 | 1 |
22239 | 22239 | 2020-03-31 | McLean | Illinois | 17113 | 19 | 2 |
24408 | 24408 | 2020-04-01 | McLean | Illinois | 17113 | 19 | 2 |
26643 | 26643 | 2020-04-02 | McLean | Illinois | 17113 | 32 | 2 |
28953 | 28953 | 2020-04-03 | McLean | Illinois | 17113 | 35 | 2 |
31318 | 31318 | 2020-04-04 | McLean | Illinois | 17113 | 40 | 2 |
33728 | 33728 | 2020-04-05 | McLean | Illinois | 17113 | 46 | 2 |
36180 | 36180 | 2020-04-06 | McLean | Illinois | 17113 | 46 | 2 |
38676 | 38676 | 2020-04-07 | McLean | Illinois | 17113 | 57 | 2 |
41221 | 41221 | 2020-04-08 | McLean | Illinois | 17113 | 65 | 2 |
43795 | 43795 | 2020-04-09 | McLean | Illinois | 17113 | 69 | 2 |
46399 | 46399 | 2020-04-10 | McLean | Illinois | 17113 | 75 | 2 |
49031 | 49031 | 2020-04-11 | McLean | Illinois | 17113 | 75 | 2 |
51693 | 51693 | 2020-04-12 | McLean | Illinois | 17113 | 77 | 2 |
54374 | 54374 | 2020-04-13 | McLean | Illinois | 17113 | 79 | 2 |
57067 | 57067 | 2020-04-14 | McLean | Illinois | 17113 | 81 | 2 |
59774 | 59774 | 2020-04-15 | McLean | Illinois | 17113 | 82 | 2 |
62495 | 62495 | 2020-04-16 | McLean | Illinois | 17113 | 82 | 3 |
65228 | 65228 | 2020-04-17 | McLean | Illinois | 17113 | 83 | 3 |
67977 | 67977 | 2020-04-18 | McLean | Illinois | 17113 | 83 | 3 |
70739 | 70739 | 2020-04-19 | McLean | Illinois | 17113 | 85 | 3 |
73509 | 73509 | 2020-04-20 | McLean | Illinois | 17113 | 86 | 3 |
76286 | 76286 | 2020-04-21 | McLean | Illinois | 17113 | 86 | 3 |
79070 | 79070 | 2020-04-22 | McLean | Illinois | 17113 | 86 | 3 |
81863 | 81863 | 2020-04-23 | McLean | Illinois | 17113 | 87 | 3 |
84663 | 84663 | 2020-04-24 | McLean | Illinois | 17113 | 87 | 3 |
87473 | 87473 | 2020-04-25 | McLean | Illinois | 17113 | 88 | 3 |
90289 | 90289 | 2020-04-26 | McLean | Illinois | 17113 | 88 | 3 |
93108 | 93108 | 2020-04-27 | McLean | Illinois | 17113 | 92 | 3 |
95940 | 95940 | 2020-04-28 | McLean | Illinois | 17113 | 94 | 3 |
98784 | 98784 | 2020-04-29 | McLean | Illinois | 17113 | 94 | 3 |
101635 | 101635 | 2020-04-30 | McLean | Illinois | 17113 | 95 | 3 |
104491 | 104491 | 2020-05-01 | McLean | Illinois | 17113 | 97 | 3 |
107356 | 107356 | 2020-05-02 | McLean | Illinois | 17113 | 99 | 3 |
110226 | 110226 | 2020-05-03 | McLean | Illinois | 17113 | 99 | 3 |
113101 | 113101 | 2020-05-04 | McLean | Illinois | 17113 | 103 | 3 |
115984 | 115984 | 2020-05-05 | McLean | Illinois | 17113 | 103 | 3 |
118944 | 118944 | 2020-05-06 | McLean | Illinois | 17113 | 108 | 3 |
121914 | 121914 | 2020-05-07 | McLean | Illinois | 17113 | 110 | 3 |
124893 | 124893 | 2020-05-08 | McLean | Illinois | 17113 | 112 | 3 |
127880 | 127880 | 2020-05-09 | McLean | Illinois | 17113 | 115 | 3 |
130871 | 130871 | 2020-05-10 | McLean | Illinois | 17113 | 117 | 3 |
133862 | 133862 | 2020-05-11 | McLean | Illinois | 17113 | 121 | 3 |
136851 | 136851 | 2020-05-12 | McLean | Illinois | 17113 | 126 | 3 |
139843 | 139843 | 2020-05-13 | McLean | Illinois | 17113 | 127 | 3 |
142839 | 142839 | 2020-05-14 | McLean | Illinois | 17113 | 130 | 3 |
145839 | 145839 | 2020-05-15 | McLean | Illinois | 17113 | 132 | 4 |
148842 | 148842 | 2020-05-16 | McLean | Illinois | 17113 | 158 | 4 |
151851 | 151851 | 2020-05-17 | McLean | Illinois | 17113 | 170 | 6 |
154863 | 154863 | 2020-05-18 | McLean | Illinois | 17113 | 186 | 6 |
157879 | 157879 | 2020-05-19 | McLean | Illinois | 17113 | 189 | 6 |
160905 | 160905 | 2020-05-20 | McLean | Illinois | 17113 | 191 | 6 |
163933 | 163933 | 2020-05-21 | McLean | Illinois | 17113 | 195 | 9 |
166966 | 166966 | 2020-05-22 | McLean | Illinois | 17113 | 195 | 9 |
170003 | 170003 | 2020-05-23 | McLean | Illinois | 17113 | 202 | 9 |
173044 | 173044 | 2020-05-24 | McLean | Illinois | 17113 | 204 | 10 |
176088 | 176088 | 2020-05-25 | McLean | Illinois | 17113 | 211 | 10 |
179132 | 179132 | 2020-05-26 | McLean | Illinois | 17113 | 212 | 10 |
182176 | 182176 | 2020-05-27 | McLean | Illinois | 17113 | 215 | 13 |
185230 | 185230 | 2020-05-28 | McLean | Illinois | 17113 | 216 | 13 |
188288 | 188288 | 2020-05-29 | McLean | Illinois | 17113 | 217 | 13 |
191353 | 191353 | 2020-05-30 | McLean | Illinois | 17113 | 218 | 13 |
194420 | 194420 | 2020-05-31 | McLean | Illinois | 17113 | 220 | 13 |
197490 | 197490 | 2020-06-01 | McLean | Illinois | 17113 | 220 | 13 |
200563 | 200563 | 2020-06-02 | McLean | Illinois | 17113 | 221 | 13 |
203639 | 203639 | 2020-06-03 | McLean | Illinois | 17113 | 224 | 13 |
206719 | 206719 | 2020-06-04 | McLean | Illinois | 17113 | 224 | 13 |
209800 | 209800 | 2020-06-05 | McLean | Illinois | 17113 | 226 | 13 |
212885 | 212885 | 2020-06-06 | McLean | Illinois | 17113 | 226 | 13 |
215972 | 215972 | 2020-06-07 | McLean | Illinois | 17113 | 226 | 13 |
219063 | 219063 | 2020-06-08 | McLean | Illinois | 17113 | 228 | 13 |
222158 | 222158 | 2020-06-09 | McLean | Illinois | 17113 | 230 | 13 |
225253 | 225253 | 2020-06-10 | McLean | Illinois | 17113 | 231 | 13 |
228355 | 228355 | 2020-06-11 | McLean | Illinois | 17113 | 235 | 13 |
231458 | 231458 | 2020-06-12 | McLean | Illinois | 17113 | 238 | 13 |
234564 | 234564 | 2020-06-13 | McLean | Illinois | 17113 | 241 | 13 |
237671 | 237671 | 2020-06-14 | McLean | Illinois | 17113 | 241 | 13 |
240779 | 240779 | 2020-06-15 | McLean | Illinois | 17113 | 241 | 13 |
243890 | 243890 | 2020-06-16 | McLean | Illinois | 17113 | 243 | 13 |
247003 | 247003 | 2020-06-17 | McLean | Illinois | 17113 | 246 | 13 |
250115 | 250115 | 2020-06-18 | McLean | Illinois | 17113 | 246 | 13 |
253230 | 253230 | 2020-06-19 | McLean | Illinois | 17113 | 246 | 13 |
256350 | 256350 | 2020-06-20 | McLean | Illinois | 17113 | 247 | 13 |
259476 | 259476 | 2020-06-21 | McLean | Illinois | 17113 | 251 | 13 |
265731 | 265731 | 2020-06-23 | McLean | Illinois | 17113 | 253 | 13 |
268861 | 268861 | 2020-06-24 | McLean | Illinois | 17113 | 253 | 13 |
262603 | 262603 | 2020-06-22 | McLean | Illinois | 17113 | 254 | 13 |
271998 | 271998 | 2020-06-25 | McLean | Illinois | 17113 | 254 | 13 |
275140 | 275140 | 2020-06-26 | McLean | Illinois | 17113 | 255 | 13 |
278288 | 278288 | 2020-06-27 | McLean | Illinois | 17113 | 256 | 13 |
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);