ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Madison" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386591 | 386591 | 2020-07-31 | Madison | Illinois | 17119 | 2099 | 72 |
383373 | 383373 | 2020-07-30 | Madison | Illinois | 17119 | 2047 | 72 |
380156 | 380156 | 2020-07-29 | Madison | Illinois | 17119 | 1975 | 72 |
376939 | 376939 | 2020-07-28 | Madison | Illinois | 17119 | 1942 | 72 |
373724 | 373724 | 2020-07-27 | Madison | Illinois | 17119 | 1915 | 72 |
370512 | 370512 | 2020-07-26 | Madison | Illinois | 17119 | 1840 | 71 |
367302 | 367302 | 2020-07-25 | Madison | Illinois | 17119 | 1762 | 71 |
364095 | 364095 | 2020-07-24 | Madison | Illinois | 17119 | 1701 | 71 |
360888 | 360888 | 2020-07-23 | Madison | Illinois | 17119 | 1655 | 71 |
357683 | 357683 | 2020-07-22 | Madison | Illinois | 17119 | 1604 | 71 |
354481 | 354481 | 2020-07-21 | Madison | Illinois | 17119 | 1544 | 71 |
351279 | 351279 | 2020-07-20 | Madison | Illinois | 17119 | 1534 | 71 |
348079 | 348079 | 2020-07-19 | Madison | Illinois | 17119 | 1478 | 71 |
344878 | 344878 | 2020-07-18 | Madison | Illinois | 17119 | 1457 | 71 |
341678 | 341678 | 2020-07-17 | Madison | Illinois | 17119 | 1413 | 71 |
338482 | 338482 | 2020-07-16 | Madison | Illinois | 17119 | 1368 | 71 |
335286 | 335286 | 2020-07-15 | Madison | Illinois | 17119 | 1318 | 71 |
332093 | 332093 | 2020-07-14 | Madison | Illinois | 17119 | 1285 | 71 |
328906 | 328906 | 2020-07-13 | Madison | Illinois | 17119 | 1258 | 71 |
325720 | 325720 | 2020-07-12 | Madison | Illinois | 17119 | 1198 | 70 |
322539 | 322539 | 2020-07-11 | Madison | Illinois | 17119 | 1167 | 70 |
319360 | 319360 | 2020-07-10 | Madison | Illinois | 17119 | 1134 | 70 |
316187 | 316187 | 2020-07-09 | Madison | Illinois | 17119 | 1111 | 70 |
313013 | 313013 | 2020-07-08 | Madison | Illinois | 17119 | 1090 | 70 |
309843 | 309843 | 2020-07-07 | Madison | Illinois | 17119 | 1062 | 70 |
306675 | 306675 | 2020-07-06 | Madison | Illinois | 17119 | 1043 | 70 |
303510 | 303510 | 2020-07-05 | Madison | Illinois | 17119 | 1036 | 69 |
300346 | 300346 | 2020-07-04 | Madison | Illinois | 17119 | 1007 | 69 |
297184 | 297184 | 2020-07-03 | Madison | Illinois | 17119 | 993 | 69 |
294027 | 294027 | 2020-07-02 | Madison | Illinois | 17119 | 974 | 69 |
290873 | 290873 | 2020-07-01 | Madison | Illinois | 17119 | 960 | 69 |
287723 | 287723 | 2020-06-30 | Madison | Illinois | 17119 | 939 | 68 |
284574 | 284574 | 2020-06-29 | Madison | Illinois | 17119 | 931 | 68 |
281429 | 281429 | 2020-06-28 | Madison | Illinois | 17119 | 917 | 68 |
278281 | 278281 | 2020-06-27 | Madison | Illinois | 17119 | 903 | 68 |
275133 | 275133 | 2020-06-26 | Madison | Illinois | 17119 | 892 | 68 |
271991 | 271991 | 2020-06-25 | Madison | Illinois | 17119 | 877 | 68 |
268854 | 268854 | 2020-06-24 | Madison | Illinois | 17119 | 852 | 68 |
265724 | 265724 | 2020-06-23 | Madison | Illinois | 17119 | 829 | 67 |
262596 | 262596 | 2020-06-22 | Madison | Illinois | 17119 | 816 | 67 |
259469 | 259469 | 2020-06-21 | Madison | Illinois | 17119 | 813 | 66 |
256343 | 256343 | 2020-06-20 | Madison | Illinois | 17119 | 802 | 66 |
253223 | 253223 | 2020-06-19 | Madison | Illinois | 17119 | 790 | 66 |
250108 | 250108 | 2020-06-18 | Madison | Illinois | 17119 | 771 | 66 |
246996 | 246996 | 2020-06-17 | Madison | Illinois | 17119 | 752 | 66 |
243883 | 243883 | 2020-06-16 | Madison | Illinois | 17119 | 740 | 66 |
240772 | 240772 | 2020-06-15 | Madison | Illinois | 17119 | 733 | 66 |
237664 | 237664 | 2020-06-14 | Madison | Illinois | 17119 | 720 | 65 |
234557 | 234557 | 2020-06-13 | Madison | Illinois | 17119 | 707 | 65 |
231451 | 231451 | 2020-06-12 | Madison | Illinois | 17119 | 686 | 65 |
228348 | 228348 | 2020-06-11 | Madison | Illinois | 17119 | 682 | 65 |
225246 | 225246 | 2020-06-10 | Madison | Illinois | 17119 | 665 | 65 |
222151 | 222151 | 2020-06-09 | Madison | Illinois | 17119 | 652 | 65 |
219056 | 219056 | 2020-06-08 | Madison | Illinois | 17119 | 644 | 65 |
215965 | 215965 | 2020-06-07 | Madison | Illinois | 17119 | 640 | 65 |
212878 | 212878 | 2020-06-06 | Madison | Illinois | 17119 | 636 | 65 |
209793 | 209793 | 2020-06-05 | Madison | Illinois | 17119 | 629 | 65 |
206712 | 206712 | 2020-06-04 | Madison | Illinois | 17119 | 615 | 65 |
203632 | 203632 | 2020-06-03 | Madison | Illinois | 17119 | 608 | 65 |
200556 | 200556 | 2020-06-02 | Madison | Illinois | 17119 | 600 | 62 |
197483 | 197483 | 2020-06-01 | Madison | Illinois | 17119 | 597 | 62 |
194413 | 194413 | 2020-05-31 | Madison | Illinois | 17119 | 582 | 60 |
191346 | 191346 | 2020-05-30 | Madison | Illinois | 17119 | 578 | 60 |
188281 | 188281 | 2020-05-29 | Madison | Illinois | 17119 | 569 | 58 |
185223 | 185223 | 2020-05-28 | Madison | Illinois | 17119 | 558 | 58 |
182169 | 182169 | 2020-05-27 | Madison | Illinois | 17119 | 551 | 58 |
179125 | 179125 | 2020-05-26 | Madison | Illinois | 17119 | 545 | 57 |
176081 | 176081 | 2020-05-25 | Madison | Illinois | 17119 | 539 | 57 |
173037 | 173037 | 2020-05-24 | Madison | Illinois | 17119 | 535 | 54 |
169996 | 169996 | 2020-05-23 | Madison | Illinois | 17119 | 528 | 53 |
166959 | 166959 | 2020-05-22 | Madison | Illinois | 17119 | 516 | 49 |
163926 | 163926 | 2020-05-21 | Madison | Illinois | 17119 | 506 | 48 |
160898 | 160898 | 2020-05-20 | Madison | Illinois | 17119 | 502 | 46 |
157872 | 157872 | 2020-05-19 | Madison | Illinois | 17119 | 499 | 45 |
154856 | 154856 | 2020-05-18 | Madison | Illinois | 17119 | 493 | 42 |
151844 | 151844 | 2020-05-17 | Madison | Illinois | 17119 | 490 | 42 |
148835 | 148835 | 2020-05-16 | Madison | Illinois | 17119 | 481 | 39 |
145832 | 145832 | 2020-05-15 | Madison | Illinois | 17119 | 464 | 38 |
142832 | 142832 | 2020-05-14 | Madison | Illinois | 17119 | 461 | 35 |
139836 | 139836 | 2020-05-13 | Madison | Illinois | 17119 | 449 | 35 |
136844 | 136844 | 2020-05-12 | Madison | Illinois | 17119 | 445 | 32 |
133855 | 133855 | 2020-05-11 | Madison | Illinois | 17119 | 435 | 31 |
130864 | 130864 | 2020-05-10 | Madison | Illinois | 17119 | 427 | 31 |
127873 | 127873 | 2020-05-09 | Madison | Illinois | 17119 | 414 | 31 |
124886 | 124886 | 2020-05-08 | Madison | Illinois | 17119 | 401 | 30 |
121907 | 121907 | 2020-05-07 | Madison | Illinois | 17119 | 396 | 28 |
118937 | 118937 | 2020-05-06 | Madison | Illinois | 17119 | 374 | 28 |
115977 | 115977 | 2020-05-05 | Madison | Illinois | 17119 | 369 | 27 |
113094 | 113094 | 2020-05-04 | Madison | Illinois | 17119 | 365 | 26 |
110219 | 110219 | 2020-05-03 | Madison | Illinois | 17119 | 365 | 24 |
107349 | 107349 | 2020-05-02 | Madison | Illinois | 17119 | 337 | 22 |
104484 | 104484 | 2020-05-01 | Madison | Illinois | 17119 | 335 | 22 |
101628 | 101628 | 2020-04-30 | Madison | Illinois | 17119 | 333 | 21 |
98777 | 98777 | 2020-04-29 | Madison | Illinois | 17119 | 324 | 19 |
95933 | 95933 | 2020-04-28 | Madison | Illinois | 17119 | 318 | 18 |
93101 | 93101 | 2020-04-27 | Madison | Illinois | 17119 | 306 | 17 |
90282 | 90282 | 2020-04-26 | Madison | Illinois | 17119 | 305 | 16 |
87466 | 87466 | 2020-04-25 | Madison | Illinois | 17119 | 280 | 16 |
84656 | 84656 | 2020-04-24 | Madison | Illinois | 17119 | 268 | 15 |
81856 | 81856 | 2020-04-23 | Madison | Illinois | 17119 | 235 | 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);