ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Winnebago" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535122 | 535122 | 2020-09-15 | Winnebago | Illinois | 17201 | 4883 | 152 |
531887 | 531887 | 2020-09-14 | Winnebago | Illinois | 17201 | 4843 | 152 |
528650 | 528650 | 2020-09-13 | Winnebago | Illinois | 17201 | 4790 | 152 |
525414 | 525414 | 2020-09-12 | Winnebago | Illinois | 17201 | 4757 | 152 |
522178 | 522178 | 2020-09-11 | Winnebago | Illinois | 17201 | 4731 | 152 |
518941 | 518941 | 2020-09-10 | Winnebago | Illinois | 17201 | 4661 | 152 |
515706 | 515706 | 2020-09-09 | Winnebago | Illinois | 17201 | 4609 | 152 |
512473 | 512473 | 2020-09-08 | Winnebago | Illinois | 17201 | 4572 | 152 |
509240 | 509240 | 2020-09-07 | Winnebago | Illinois | 17201 | 4539 | 152 |
506008 | 506008 | 2020-09-06 | Winnebago | Illinois | 17201 | 4507 | 152 |
502774 | 502774 | 2020-09-05 | Winnebago | Illinois | 17201 | 4469 | 152 |
499540 | 499540 | 2020-09-04 | Winnebago | Illinois | 17201 | 4422 | 152 |
496307 | 496307 | 2020-09-03 | Winnebago | Illinois | 17201 | 4342 | 152 |
493073 | 493073 | 2020-09-02 | Winnebago | Illinois | 17201 | 4326 | 151 |
489840 | 489840 | 2020-09-01 | Winnebago | Illinois | 17201 | 4278 | 151 |
486607 | 486607 | 2020-08-31 | Winnebago | Illinois | 17201 | 4248 | 150 |
483372 | 483372 | 2020-08-30 | Winnebago | Illinois | 17201 | 4218 | 150 |
480138 | 480138 | 2020-08-29 | Winnebago | Illinois | 17201 | 4187 | 150 |
476905 | 476905 | 2020-08-28 | Winnebago | Illinois | 17201 | 4175 | 150 |
473672 | 473672 | 2020-08-27 | Winnebago | Illinois | 17201 | 4153 | 150 |
470440 | 470440 | 2020-08-26 | Winnebago | Illinois | 17201 | 4116 | 149 |
467211 | 467211 | 2020-08-25 | Winnebago | Illinois | 17201 | 4087 | 148 |
463982 | 463982 | 2020-08-24 | Winnebago | Illinois | 17201 | 4070 | 147 |
460753 | 460753 | 2020-08-23 | Winnebago | Illinois | 17201 | 4048 | 144 |
457526 | 457526 | 2020-08-22 | Winnebago | Illinois | 17201 | 4018 | 144 |
454298 | 454298 | 2020-08-21 | Winnebago | Illinois | 17201 | 4006 | 144 |
451070 | 451070 | 2020-08-20 | Winnebago | Illinois | 17201 | 3981 | 144 |
447842 | 447842 | 2020-08-19 | Winnebago | Illinois | 17201 | 3966 | 144 |
444615 | 444615 | 2020-08-18 | Winnebago | Illinois | 17201 | 3901 | 144 |
441389 | 441389 | 2020-08-17 | Winnebago | Illinois | 17201 | 3885 | 144 |
438163 | 438163 | 2020-08-16 | Winnebago | Illinois | 17201 | 3861 | 144 |
434937 | 434937 | 2020-08-15 | Winnebago | Illinois | 17201 | 3853 | 144 |
431712 | 431712 | 2020-08-14 | Winnebago | Illinois | 17201 | 3835 | 144 |
428484 | 428484 | 2020-08-13 | Winnebago | Illinois | 17201 | 3814 | 144 |
425260 | 425260 | 2020-08-12 | Winnebago | Illinois | 17201 | 3806 | 140 |
422039 | 422039 | 2020-08-11 | Winnebago | Illinois | 17201 | 3797 | 134 |
418816 | 418816 | 2020-08-10 | Winnebago | Illinois | 17201 | 3784 | 131 |
415595 | 415595 | 2020-08-09 | Winnebago | Illinois | 17201 | 3779 | 131 |
412375 | 412375 | 2020-08-08 | Winnebago | Illinois | 17201 | 3772 | 131 |
409156 | 409156 | 2020-08-07 | Winnebago | Illinois | 17201 | 3755 | 129 |
405936 | 405936 | 2020-08-06 | Winnebago | Illinois | 17201 | 3746 | 128 |
402718 | 402718 | 2020-08-05 | Winnebago | Illinois | 17201 | 3730 | 128 |
399502 | 399502 | 2020-08-04 | Winnebago | Illinois | 17201 | 3704 | 127 |
396286 | 396286 | 2020-08-03 | Winnebago | Illinois | 17201 | 3688 | 125 |
393070 | 393070 | 2020-08-02 | Winnebago | Illinois | 17201 | 3673 | 124 |
389853 | 389853 | 2020-08-01 | Winnebago | Illinois | 17201 | 3663 | 122 |
386636 | 386636 | 2020-07-31 | Winnebago | Illinois | 17201 | 3641 | 122 |
383418 | 383418 | 2020-07-30 | Winnebago | Illinois | 17201 | 3610 | 122 |
380201 | 380201 | 2020-07-29 | Winnebago | Illinois | 17201 | 3582 | 121 |
376984 | 376984 | 2020-07-28 | Winnebago | Illinois | 17201 | 3570 | 120 |
373769 | 373769 | 2020-07-27 | Winnebago | Illinois | 17201 | 3539 | 118 |
370557 | 370557 | 2020-07-26 | Winnebago | Illinois | 17201 | 3516 | 115 |
367347 | 367347 | 2020-07-25 | Winnebago | Illinois | 17201 | 3486 | 115 |
364140 | 364140 | 2020-07-24 | Winnebago | Illinois | 17201 | 3457 | 115 |
360933 | 360933 | 2020-07-23 | Winnebago | Illinois | 17201 | 3424 | 113 |
357728 | 357728 | 2020-07-22 | Winnebago | Illinois | 17201 | 3394 | 113 |
354526 | 354526 | 2020-07-21 | Winnebago | Illinois | 17201 | 3369 | 111 |
351324 | 351324 | 2020-07-20 | Winnebago | Illinois | 17201 | 3362 | 108 |
348124 | 348124 | 2020-07-19 | Winnebago | Illinois | 17201 | 3342 | 108 |
344923 | 344923 | 2020-07-18 | Winnebago | Illinois | 17201 | 3318 | 108 |
341723 | 341723 | 2020-07-17 | Winnebago | Illinois | 17201 | 3303 | 108 |
338527 | 338527 | 2020-07-16 | Winnebago | Illinois | 17201 | 3264 | 108 |
335331 | 335331 | 2020-07-15 | Winnebago | Illinois | 17201 | 3228 | 106 |
332138 | 332138 | 2020-07-14 | Winnebago | Illinois | 17201 | 3212 | 106 |
328951 | 328951 | 2020-07-13 | Winnebago | Illinois | 17201 | 3191 | 106 |
325765 | 325765 | 2020-07-12 | Winnebago | Illinois | 17201 | 3169 | 106 |
322584 | 322584 | 2020-07-11 | Winnebago | Illinois | 17201 | 3156 | 105 |
319405 | 319405 | 2020-07-10 | Winnebago | Illinois | 17201 | 3161 | 104 |
316232 | 316232 | 2020-07-09 | Winnebago | Illinois | 17201 | 3143 | 101 |
313058 | 313058 | 2020-07-08 | Winnebago | Illinois | 17201 | 3131 | 101 |
309888 | 309888 | 2020-07-07 | Winnebago | Illinois | 17201 | 3118 | 97 |
306720 | 306720 | 2020-07-06 | Winnebago | Illinois | 17201 | 3109 | 96 |
303555 | 303555 | 2020-07-05 | Winnebago | Illinois | 17201 | 3091 | 96 |
300391 | 300391 | 2020-07-04 | Winnebago | Illinois | 17201 | 3084 | 96 |
297229 | 297229 | 2020-07-03 | Winnebago | Illinois | 17201 | 3067 | 96 |
294071 | 294071 | 2020-07-02 | Winnebago | Illinois | 17201 | 3054 | 96 |
290917 | 290917 | 2020-07-01 | Winnebago | Illinois | 17201 | 3046 | 95 |
287767 | 287767 | 2020-06-30 | Winnebago | Illinois | 17201 | 3030 | 94 |
284618 | 284618 | 2020-06-29 | Winnebago | Illinois | 17201 | 3014 | 93 |
281473 | 281473 | 2020-06-28 | Winnebago | Illinois | 17201 | 3004 | 92 |
278325 | 278325 | 2020-06-27 | Winnebago | Illinois | 17201 | 2992 | 91 |
275177 | 275177 | 2020-06-26 | Winnebago | Illinois | 17201 | 2959 | 90 |
272035 | 272035 | 2020-06-25 | Winnebago | Illinois | 17201 | 2947 | 89 |
268898 | 268898 | 2020-06-24 | Winnebago | Illinois | 17201 | 2933 | 88 |
265768 | 265768 | 2020-06-23 | Winnebago | Illinois | 17201 | 2916 | 85 |
262640 | 262640 | 2020-06-22 | Winnebago | Illinois | 17201 | 2903 | 85 |
259513 | 259513 | 2020-06-21 | Winnebago | Illinois | 17201 | 2884 | 85 |
256387 | 256387 | 2020-06-20 | Winnebago | Illinois | 17201 | 2849 | 85 |
253267 | 253267 | 2020-06-19 | Winnebago | Illinois | 17201 | 2824 | 85 |
250152 | 250152 | 2020-06-18 | Winnebago | Illinois | 17201 | 2824 | 85 |
247040 | 247040 | 2020-06-17 | Winnebago | Illinois | 17201 | 2806 | 85 |
243927 | 243927 | 2020-06-16 | Winnebago | Illinois | 17201 | 2785 | 85 |
240816 | 240816 | 2020-06-15 | Winnebago | Illinois | 17201 | 2774 | 85 |
237708 | 237708 | 2020-06-14 | Winnebago | Illinois | 17201 | 2765 | 79 |
234601 | 234601 | 2020-06-13 | Winnebago | Illinois | 17201 | 2730 | 79 |
231495 | 231495 | 2020-06-12 | Winnebago | Illinois | 17201 | 2701 | 79 |
228392 | 228392 | 2020-06-11 | Winnebago | Illinois | 17201 | 2669 | 78 |
225290 | 225290 | 2020-06-10 | Winnebago | Illinois | 17201 | 2634 | 78 |
222195 | 222195 | 2020-06-09 | Winnebago | Illinois | 17201 | 2619 | 78 |
219100 | 219100 | 2020-06-08 | Winnebago | Illinois | 17201 | 2594 | 76 |
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);