ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635579 | 635579 | 2020-10-16 | Washington | Illinois | 17189 | 271 | 1 |
632333 | 632333 | 2020-10-15 | Washington | Illinois | 17189 | 269 | 1 |
629089 | 629089 | 2020-10-14 | Washington | Illinois | 17189 | 265 | 1 |
625846 | 625846 | 2020-10-13 | Washington | Illinois | 17189 | 262 | 1 |
622604 | 622604 | 2020-10-12 | Washington | Illinois | 17189 | 259 | 1 |
619360 | 619360 | 2020-10-11 | Washington | Illinois | 17189 | 254 | 1 |
616118 | 616118 | 2020-10-10 | Washington | Illinois | 17189 | 254 | 1 |
612877 | 612877 | 2020-10-09 | Washington | Illinois | 17189 | 248 | 1 |
609635 | 609635 | 2020-10-08 | Washington | Illinois | 17189 | 242 | 1 |
606392 | 606392 | 2020-10-07 | Washington | Illinois | 17189 | 237 | 1 |
603150 | 603150 | 2020-10-06 | Washington | Illinois | 17189 | 236 | 1 |
599907 | 599907 | 2020-10-05 | Washington | Illinois | 17189 | 232 | 1 |
596665 | 596665 | 2020-10-04 | Washington | Illinois | 17189 | 231 | 1 |
593423 | 593423 | 2020-10-03 | Washington | Illinois | 17189 | 230 | 1 |
590182 | 590182 | 2020-10-02 | Washington | Illinois | 17189 | 227 | 1 |
586941 | 586941 | 2020-10-01 | Washington | Illinois | 17189 | 224 | 1 |
583701 | 583701 | 2020-09-30 | Washington | Illinois | 17189 | 219 | 1 |
580462 | 580462 | 2020-09-29 | Washington | Illinois | 17189 | 217 | 1 |
577221 | 577221 | 2020-09-28 | Washington | Illinois | 17189 | 216 | 1 |
573979 | 573979 | 2020-09-27 | Washington | Illinois | 17189 | 211 | 1 |
570736 | 570736 | 2020-09-26 | Washington | Illinois | 17189 | 210 | 1 |
567494 | 567494 | 2020-09-25 | Washington | Illinois | 17189 | 204 | 1 |
564254 | 564254 | 2020-09-24 | Washington | Illinois | 17189 | 203 | 1 |
561014 | 561014 | 2020-09-23 | Washington | Illinois | 17189 | 198 | 1 |
557778 | 557778 | 2020-09-22 | Washington | Illinois | 17189 | 197 | 1 |
554541 | 554541 | 2020-09-21 | Washington | Illinois | 17189 | 193 | 1 |
551302 | 551302 | 2020-09-20 | Washington | Illinois | 17189 | 193 | 1 |
548063 | 548063 | 2020-09-19 | Washington | Illinois | 17189 | 189 | 1 |
544825 | 544825 | 2020-09-18 | Washington | Illinois | 17189 | 179 | 1 |
541589 | 541589 | 2020-09-17 | Washington | Illinois | 17189 | 172 | 1 |
538352 | 538352 | 2020-09-16 | Washington | Illinois | 17189 | 167 | 1 |
535116 | 535116 | 2020-09-15 | Washington | Illinois | 17189 | 160 | 1 |
531881 | 531881 | 2020-09-14 | Washington | Illinois | 17189 | 158 | 1 |
528644 | 528644 | 2020-09-13 | Washington | Illinois | 17189 | 158 | 1 |
525408 | 525408 | 2020-09-12 | Washington | Illinois | 17189 | 152 | 1 |
522172 | 522172 | 2020-09-11 | Washington | Illinois | 17189 | 148 | 1 |
518935 | 518935 | 2020-09-10 | Washington | Illinois | 17189 | 145 | 1 |
515700 | 515700 | 2020-09-09 | Washington | Illinois | 17189 | 142 | 1 |
512467 | 512467 | 2020-09-08 | Washington | Illinois | 17189 | 138 | 1 |
509234 | 509234 | 2020-09-07 | Washington | Illinois | 17189 | 138 | 1 |
506002 | 506002 | 2020-09-06 | Washington | Illinois | 17189 | 133 | 1 |
502768 | 502768 | 2020-09-05 | Washington | Illinois | 17189 | 128 | 1 |
499534 | 499534 | 2020-09-04 | Washington | Illinois | 17189 | 126 | 1 |
496301 | 496301 | 2020-09-03 | Washington | Illinois | 17189 | 119 | 1 |
493067 | 493067 | 2020-09-02 | Washington | Illinois | 17189 | 116 | 1 |
489834 | 489834 | 2020-09-01 | Washington | Illinois | 17189 | 115 | 1 |
486601 | 486601 | 2020-08-31 | Washington | Illinois | 17189 | 114 | 1 |
483366 | 483366 | 2020-08-30 | Washington | Illinois | 17189 | 111 | 1 |
480132 | 480132 | 2020-08-29 | Washington | Illinois | 17189 | 111 | 1 |
476899 | 476899 | 2020-08-28 | Washington | Illinois | 17189 | 109 | 1 |
473666 | 473666 | 2020-08-27 | Washington | Illinois | 17189 | 106 | 1 |
470434 | 470434 | 2020-08-26 | Washington | Illinois | 17189 | 101 | 1 |
467205 | 467205 | 2020-08-25 | Washington | Illinois | 17189 | 98 | 1 |
463976 | 463976 | 2020-08-24 | Washington | Illinois | 17189 | 92 | 1 |
460747 | 460747 | 2020-08-23 | Washington | Illinois | 17189 | 88 | 1 |
457520 | 457520 | 2020-08-22 | Washington | Illinois | 17189 | 87 | 1 |
454292 | 454292 | 2020-08-21 | Washington | Illinois | 17189 | 82 | 1 |
451064 | 451064 | 2020-08-20 | Washington | Illinois | 17189 | 80 | 1 |
447836 | 447836 | 2020-08-19 | Washington | Illinois | 17189 | 78 | 1 |
444609 | 444609 | 2020-08-18 | Washington | Illinois | 17189 | 76 | 1 |
441383 | 441383 | 2020-08-17 | Washington | Illinois | 17189 | 75 | 1 |
438157 | 438157 | 2020-08-16 | Washington | Illinois | 17189 | 73 | 1 |
434931 | 434931 | 2020-08-15 | Washington | Illinois | 17189 | 73 | 1 |
431706 | 431706 | 2020-08-14 | Washington | Illinois | 17189 | 69 | 1 |
428478 | 428478 | 2020-08-13 | Washington | Illinois | 17189 | 69 | 1 |
425254 | 425254 | 2020-08-12 | Washington | Illinois | 17189 | 67 | 0 |
422033 | 422033 | 2020-08-11 | Washington | Illinois | 17189 | 67 | 0 |
418810 | 418810 | 2020-08-10 | Washington | Illinois | 17189 | 67 | 0 |
415589 | 415589 | 2020-08-09 | Washington | Illinois | 17189 | 66 | 0 |
412369 | 412369 | 2020-08-08 | Washington | Illinois | 17189 | 66 | 0 |
409150 | 409150 | 2020-08-07 | Washington | Illinois | 17189 | 64 | 0 |
405930 | 405930 | 2020-08-06 | Washington | Illinois | 17189 | 60 | 0 |
402712 | 402712 | 2020-08-05 | Washington | Illinois | 17189 | 60 | 0 |
399496 | 399496 | 2020-08-04 | Washington | Illinois | 17189 | 59 | 0 |
396280 | 396280 | 2020-08-03 | Washington | Illinois | 17189 | 58 | 0 |
393064 | 393064 | 2020-08-02 | Washington | Illinois | 17189 | 57 | 0 |
389847 | 389847 | 2020-08-01 | Washington | Illinois | 17189 | 56 | 0 |
386630 | 386630 | 2020-07-31 | Washington | Illinois | 17189 | 56 | 0 |
383412 | 383412 | 2020-07-30 | Washington | Illinois | 17189 | 53 | 0 |
380195 | 380195 | 2020-07-29 | Washington | Illinois | 17189 | 52 | 0 |
376978 | 376978 | 2020-07-28 | Washington | Illinois | 17189 | 50 | 0 |
373763 | 373763 | 2020-07-27 | Washington | Illinois | 17189 | 50 | 0 |
370551 | 370551 | 2020-07-26 | Washington | Illinois | 17189 | 43 | 0 |
367341 | 367341 | 2020-07-25 | Washington | Illinois | 17189 | 43 | 0 |
364134 | 364134 | 2020-07-24 | Washington | Illinois | 17189 | 41 | 0 |
360927 | 360927 | 2020-07-23 | Washington | Illinois | 17189 | 40 | 0 |
357722 | 357722 | 2020-07-22 | Washington | Illinois | 17189 | 35 | 0 |
354520 | 354520 | 2020-07-21 | Washington | Illinois | 17189 | 35 | 0 |
351318 | 351318 | 2020-07-20 | Washington | Illinois | 17189 | 35 | 0 |
348118 | 348118 | 2020-07-19 | Washington | Illinois | 17189 | 31 | 0 |
344917 | 344917 | 2020-07-18 | Washington | Illinois | 17189 | 30 | 0 |
341717 | 341717 | 2020-07-17 | Washington | Illinois | 17189 | 29 | 0 |
338521 | 338521 | 2020-07-16 | Washington | Illinois | 17189 | 29 | 0 |
335325 | 335325 | 2020-07-15 | Washington | Illinois | 17189 | 28 | 0 |
332132 | 332132 | 2020-07-14 | Washington | Illinois | 17189 | 25 | 0 |
328945 | 328945 | 2020-07-13 | Washington | Illinois | 17189 | 25 | 0 |
325759 | 325759 | 2020-07-12 | Washington | Illinois | 17189 | 25 | 0 |
322578 | 322578 | 2020-07-11 | Washington | Illinois | 17189 | 25 | 0 |
319399 | 319399 | 2020-07-10 | Washington | Illinois | 17189 | 25 | 0 |
316226 | 316226 | 2020-07-09 | Washington | Illinois | 17189 | 25 | 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);