ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Kendall" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386581 | 386581 | 2020-07-31 | Kendall | Illinois | 17093 | 1322 | 24 |
383363 | 383363 | 2020-07-30 | Kendall | Illinois | 17093 | 1309 | 24 |
380146 | 380146 | 2020-07-29 | Kendall | Illinois | 17093 | 1295 | 23 |
376929 | 376929 | 2020-07-28 | Kendall | Illinois | 17093 | 1287 | 23 |
373714 | 373714 | 2020-07-27 | Kendall | Illinois | 17093 | 1274 | 23 |
370502 | 370502 | 2020-07-26 | Kendall | Illinois | 17093 | 1249 | 23 |
367292 | 367292 | 2020-07-25 | Kendall | Illinois | 17093 | 1249 | 23 |
364085 | 364085 | 2020-07-24 | Kendall | Illinois | 17093 | 1235 | 23 |
360878 | 360878 | 2020-07-23 | Kendall | Illinois | 17093 | 1218 | 23 |
357673 | 357673 | 2020-07-22 | Kendall | Illinois | 17093 | 1210 | 23 |
354471 | 354471 | 2020-07-21 | Kendall | Illinois | 17093 | 1198 | 23 |
351269 | 351269 | 2020-07-20 | Kendall | Illinois | 17093 | 1184 | 23 |
348069 | 348069 | 2020-07-19 | Kendall | Illinois | 17093 | 1170 | 23 |
344868 | 344868 | 2020-07-18 | Kendall | Illinois | 17093 | 1170 | 23 |
341668 | 341668 | 2020-07-17 | Kendall | Illinois | 17093 | 1157 | 23 |
338472 | 338472 | 2020-07-16 | Kendall | Illinois | 17093 | 1152 | 23 |
335276 | 335276 | 2020-07-15 | Kendall | Illinois | 17093 | 1141 | 23 |
332083 | 332083 | 2020-07-14 | Kendall | Illinois | 17093 | 1127 | 23 |
328896 | 328896 | 2020-07-13 | Kendall | Illinois | 17093 | 1099 | 23 |
325710 | 325710 | 2020-07-12 | Kendall | Illinois | 17093 | 1099 | 23 |
322529 | 322529 | 2020-07-11 | Kendall | Illinois | 17093 | 1099 | 23 |
319350 | 319350 | 2020-07-10 | Kendall | Illinois | 17093 | 1084 | 23 |
316177 | 316177 | 2020-07-09 | Kendall | Illinois | 17093 | 1078 | 23 |
313003 | 313003 | 2020-07-08 | Kendall | Illinois | 17093 | 1071 | 23 |
309833 | 309833 | 2020-07-07 | Kendall | Illinois | 17093 | 1058 | 23 |
306665 | 306665 | 2020-07-06 | Kendall | Illinois | 17093 | 1050 | 23 |
303500 | 303500 | 2020-07-05 | Kendall | Illinois | 17093 | 1029 | 23 |
300336 | 300336 | 2020-07-04 | Kendall | Illinois | 17093 | 1029 | 23 |
297174 | 297174 | 2020-07-03 | Kendall | Illinois | 17093 | 1029 | 23 |
294017 | 294017 | 2020-07-02 | Kendall | Illinois | 17093 | 1021 | 23 |
290863 | 290863 | 2020-07-01 | Kendall | Illinois | 17093 | 1013 | 23 |
287713 | 287713 | 2020-06-30 | Kendall | Illinois | 17093 | 1008 | 23 |
284564 | 284564 | 2020-06-29 | Kendall | Illinois | 17093 | 1001 | 23 |
281419 | 281419 | 2020-06-28 | Kendall | Illinois | 17093 | 990 | 23 |
278271 | 278271 | 2020-06-27 | Kendall | Illinois | 17093 | 990 | 23 |
275123 | 275123 | 2020-06-26 | Kendall | Illinois | 17093 | 985 | 23 |
271981 | 271981 | 2020-06-25 | Kendall | Illinois | 17093 | 982 | 22 |
268844 | 268844 | 2020-06-24 | Kendall | Illinois | 17093 | 971 | 22 |
265714 | 265714 | 2020-06-23 | Kendall | Illinois | 17093 | 966 | 22 |
262586 | 262586 | 2020-06-22 | Kendall | Illinois | 17093 | 949 | 22 |
259459 | 259459 | 2020-06-21 | Kendall | Illinois | 17093 | 946 | 22 |
256333 | 256333 | 2020-06-20 | Kendall | Illinois | 17093 | 946 | 22 |
253213 | 253213 | 2020-06-19 | Kendall | Illinois | 17093 | 943 | 22 |
250098 | 250098 | 2020-06-18 | Kendall | Illinois | 17093 | 938 | 22 |
246986 | 246986 | 2020-06-17 | Kendall | Illinois | 17093 | 928 | 22 |
243873 | 243873 | 2020-06-16 | Kendall | Illinois | 17093 | 924 | 22 |
240762 | 240762 | 2020-06-15 | Kendall | Illinois | 17093 | 911 | 22 |
237654 | 237654 | 2020-06-14 | Kendall | Illinois | 17093 | 906 | 22 |
234547 | 234547 | 2020-06-13 | Kendall | Illinois | 17093 | 906 | 22 |
231441 | 231441 | 2020-06-12 | Kendall | Illinois | 17093 | 905 | 22 |
228338 | 228338 | 2020-06-11 | Kendall | Illinois | 17093 | 898 | 22 |
225236 | 225236 | 2020-06-10 | Kendall | Illinois | 17093 | 893 | 22 |
222141 | 222141 | 2020-06-09 | Kendall | Illinois | 17093 | 886 | 22 |
219046 | 219046 | 2020-06-08 | Kendall | Illinois | 17093 | 874 | 22 |
215955 | 215955 | 2020-06-07 | Kendall | Illinois | 17093 | 869 | 22 |
212868 | 212868 | 2020-06-06 | Kendall | Illinois | 17093 | 869 | 22 |
209783 | 209783 | 2020-06-05 | Kendall | Illinois | 17093 | 868 | 22 |
206702 | 206702 | 2020-06-04 | Kendall | Illinois | 17093 | 860 | 22 |
203622 | 203622 | 2020-06-03 | Kendall | Illinois | 17093 | 853 | 22 |
200546 | 200546 | 2020-06-02 | Kendall | Illinois | 17093 | 843 | 22 |
197473 | 197473 | 2020-06-01 | Kendall | Illinois | 17093 | 832 | 22 |
194403 | 194403 | 2020-05-31 | Kendall | Illinois | 17093 | 798 | 22 |
191336 | 191336 | 2020-05-30 | Kendall | Illinois | 17093 | 793 | 22 |
188271 | 188271 | 2020-05-29 | Kendall | Illinois | 17093 | 793 | 22 |
185213 | 185213 | 2020-05-28 | Kendall | Illinois | 17093 | 781 | 22 |
182159 | 182159 | 2020-05-27 | Kendall | Illinois | 17093 | 769 | 22 |
179115 | 179115 | 2020-05-26 | Kendall | Illinois | 17093 | 754 | 22 |
176071 | 176071 | 2020-05-25 | Kendall | Illinois | 17093 | 722 | 22 |
173027 | 173027 | 2020-05-24 | Kendall | Illinois | 17093 | 709 | 22 |
169986 | 169986 | 2020-05-23 | Kendall | Illinois | 17093 | 705 | 22 |
166949 | 166949 | 2020-05-22 | Kendall | Illinois | 17093 | 680 | 22 |
163916 | 163916 | 2020-05-21 | Kendall | Illinois | 17093 | 650 | 22 |
160888 | 160888 | 2020-05-20 | Kendall | Illinois | 17093 | 635 | 22 |
157862 | 157862 | 2020-05-19 | Kendall | Illinois | 17093 | 602 | 22 |
154846 | 154846 | 2020-05-18 | Kendall | Illinois | 17093 | 579 | 22 |
151834 | 151834 | 2020-05-17 | Kendall | Illinois | 17093 | 563 | 20 |
148825 | 148825 | 2020-05-16 | Kendall | Illinois | 17093 | 559 | 20 |
145822 | 145822 | 2020-05-15 | Kendall | Illinois | 17093 | 531 | 20 |
142822 | 142822 | 2020-05-14 | Kendall | Illinois | 17093 | 518 | 20 |
139826 | 139826 | 2020-05-13 | Kendall | Illinois | 17093 | 497 | 20 |
136834 | 136834 | 2020-05-12 | Kendall | Illinois | 17093 | 477 | 16 |
133845 | 133845 | 2020-05-11 | Kendall | Illinois | 17093 | 431 | 14 |
130854 | 130854 | 2020-05-10 | Kendall | Illinois | 17093 | 421 | 14 |
127863 | 127863 | 2020-05-09 | Kendall | Illinois | 17093 | 388 | 14 |
124876 | 124876 | 2020-05-08 | Kendall | Illinois | 17093 | 373 | 14 |
121897 | 121897 | 2020-05-07 | Kendall | Illinois | 17093 | 363 | 14 |
118927 | 118927 | 2020-05-06 | Kendall | Illinois | 17093 | 346 | 10 |
115967 | 115967 | 2020-05-05 | Kendall | Illinois | 17093 | 334 | 9 |
113084 | 113084 | 2020-05-04 | Kendall | Illinois | 17093 | 326 | 9 |
110209 | 110209 | 2020-05-03 | Kendall | Illinois | 17093 | 305 | 9 |
107339 | 107339 | 2020-05-02 | Kendall | Illinois | 17093 | 291 | 9 |
104474 | 104474 | 2020-05-01 | Kendall | Illinois | 17093 | 281 | 7 |
101618 | 101618 | 2020-04-30 | Kendall | Illinois | 17093 | 266 | 7 |
98767 | 98767 | 2020-04-29 | Kendall | Illinois | 17093 | 255 | 7 |
95923 | 95923 | 2020-04-28 | Kendall | Illinois | 17093 | 235 | 5 |
93091 | 93091 | 2020-04-27 | Kendall | Illinois | 17093 | 218 | 5 |
90272 | 90272 | 2020-04-26 | Kendall | Illinois | 17093 | 208 | 5 |
87456 | 87456 | 2020-04-25 | Kendall | Illinois | 17093 | 203 | 5 |
84646 | 84646 | 2020-04-24 | Kendall | Illinois | 17093 | 191 | 5 |
81846 | 81846 | 2020-04-23 | Kendall | Illinois | 17093 | 171 | 5 |
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);