ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Morgan" and fips = 17137 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
297196 | 297196 | 2020-07-03 | Morgan | Illinois | 17137 | 130 | 3 |
300358 | 300358 | 2020-07-04 | Morgan | Illinois | 17137 | 130 | 3 |
303522 | 303522 | 2020-07-05 | Morgan | Illinois | 17137 | 130 | 3 |
306687 | 306687 | 2020-07-06 | Morgan | Illinois | 17137 | 130 | 3 |
309855 | 309855 | 2020-07-07 | Morgan | Illinois | 17137 | 132 | 3 |
313025 | 313025 | 2020-07-08 | Morgan | Illinois | 17137 | 132 | 3 |
316199 | 316199 | 2020-07-09 | Morgan | Illinois | 17137 | 132 | 3 |
319372 | 319372 | 2020-07-10 | Morgan | Illinois | 17137 | 132 | 3 |
322551 | 322551 | 2020-07-11 | Morgan | Illinois | 17137 | 134 | 3 |
325732 | 325732 | 2020-07-12 | Morgan | Illinois | 17137 | 134 | 4 |
328918 | 328918 | 2020-07-13 | Morgan | Illinois | 17137 | 134 | 4 |
332105 | 332105 | 2020-07-14 | Morgan | Illinois | 17137 | 134 | 4 |
335298 | 335298 | 2020-07-15 | Morgan | Illinois | 17137 | 135 | 4 |
338494 | 338494 | 2020-07-16 | Morgan | Illinois | 17137 | 137 | 4 |
341690 | 341690 | 2020-07-17 | Morgan | Illinois | 17137 | 138 | 4 |
344890 | 344890 | 2020-07-18 | Morgan | Illinois | 17137 | 142 | 5 |
348091 | 348091 | 2020-07-19 | Morgan | Illinois | 17137 | 145 | 5 |
351291 | 351291 | 2020-07-20 | Morgan | Illinois | 17137 | 145 | 5 |
354493 | 354493 | 2020-07-21 | Morgan | Illinois | 17137 | 145 | 5 |
357695 | 357695 | 2020-07-22 | Morgan | Illinois | 17137 | 146 | 5 |
360900 | 360900 | 2020-07-23 | Morgan | Illinois | 17137 | 148 | 5 |
364107 | 364107 | 2020-07-24 | Morgan | Illinois | 17137 | 151 | 5 |
367314 | 367314 | 2020-07-25 | Morgan | Illinois | 17137 | 153 | 5 |
370524 | 370524 | 2020-07-26 | Morgan | Illinois | 17137 | 156 | 5 |
373736 | 373736 | 2020-07-27 | Morgan | Illinois | 17137 | 160 | 5 |
376951 | 376951 | 2020-07-28 | Morgan | Illinois | 17137 | 161 | 5 |
380168 | 380168 | 2020-07-29 | Morgan | Illinois | 17137 | 167 | 5 |
383385 | 383385 | 2020-07-30 | Morgan | Illinois | 17137 | 176 | 5 |
386603 | 386603 | 2020-07-31 | Morgan | Illinois | 17137 | 184 | 5 |
389820 | 389820 | 2020-08-01 | Morgan | Illinois | 17137 | 189 | 5 |
393037 | 393037 | 2020-08-02 | Morgan | Illinois | 17137 | 196 | 5 |
396253 | 396253 | 2020-08-03 | Morgan | Illinois | 17137 | 203 | 5 |
399469 | 399469 | 2020-08-04 | Morgan | Illinois | 17137 | 205 | 6 |
402685 | 402685 | 2020-08-05 | Morgan | Illinois | 17137 | 213 | 6 |
405903 | 405903 | 2020-08-06 | Morgan | Illinois | 17137 | 222 | 6 |
409123 | 409123 | 2020-08-07 | Morgan | Illinois | 17137 | 229 | 6 |
412342 | 412342 | 2020-08-08 | Morgan | Illinois | 17137 | 242 | 6 |
415562 | 415562 | 2020-08-09 | Morgan | Illinois | 17137 | 249 | 6 |
418783 | 418783 | 2020-08-10 | Morgan | Illinois | 17137 | 268 | 6 |
422006 | 422006 | 2020-08-11 | Morgan | Illinois | 17137 | 269 | 6 |
425227 | 425227 | 2020-08-12 | Morgan | Illinois | 17137 | 348 | 14 |
428451 | 428451 | 2020-08-13 | Morgan | Illinois | 17137 | 372 | 15 |
431679 | 431679 | 2020-08-14 | Morgan | Illinois | 17137 | 384 | 15 |
434904 | 434904 | 2020-08-15 | Morgan | Illinois | 17137 | 384 | 15 |
438130 | 438130 | 2020-08-16 | Morgan | Illinois | 17137 | 392 | 15 |
441356 | 441356 | 2020-08-17 | Morgan | Illinois | 17137 | 426 | 17 |
444582 | 444582 | 2020-08-18 | Morgan | Illinois | 17137 | 430 | 17 |
447809 | 447809 | 2020-08-19 | Morgan | Illinois | 17137 | 430 | 17 |
451037 | 451037 | 2020-08-20 | Morgan | Illinois | 17137 | 444 | 18 |
454265 | 454265 | 2020-08-21 | Morgan | Illinois | 17137 | 444 | 18 |
457493 | 457493 | 2020-08-22 | Morgan | Illinois | 17137 | 449 | 18 |
460720 | 460720 | 2020-08-23 | Morgan | Illinois | 17137 | 449 | 18 |
463949 | 463949 | 2020-08-24 | Morgan | Illinois | 17137 | 480 | 18 |
467178 | 467178 | 2020-08-25 | Morgan | Illinois | 17137 | 485 | 18 |
470407 | 470407 | 2020-08-26 | Morgan | Illinois | 17137 | 485 | 18 |
473639 | 473639 | 2020-08-27 | Morgan | Illinois | 17137 | 494 | 18 |
476872 | 476872 | 2020-08-28 | Morgan | Illinois | 17137 | 500 | 18 |
480105 | 480105 | 2020-08-29 | Morgan | Illinois | 17137 | 500 | 18 |
483339 | 483339 | 2020-08-30 | Morgan | Illinois | 17137 | 500 | 18 |
486574 | 486574 | 2020-08-31 | Morgan | Illinois | 17137 | 500 | 18 |
489807 | 489807 | 2020-09-01 | Morgan | Illinois | 17137 | 500 | 20 |
493040 | 493040 | 2020-09-02 | Morgan | Illinois | 17137 | 558 | 21 |
496274 | 496274 | 2020-09-03 | Morgan | Illinois | 17137 | 558 | 21 |
499507 | 499507 | 2020-09-04 | Morgan | Illinois | 17137 | 575 | 21 |
502741 | 502741 | 2020-09-05 | Morgan | Illinois | 17137 | 594 | 21 |
505975 | 505975 | 2020-09-06 | Morgan | Illinois | 17137 | 594 | 21 |
509207 | 509207 | 2020-09-07 | Morgan | Illinois | 17137 | 594 | 21 |
512440 | 512440 | 2020-09-08 | Morgan | Illinois | 17137 | 594 | 21 |
515673 | 515673 | 2020-09-09 | Morgan | Illinois | 17137 | 598 | 21 |
518908 | 518908 | 2020-09-10 | Morgan | Illinois | 17137 | 598 | 21 |
522145 | 522145 | 2020-09-11 | Morgan | Illinois | 17137 | 601 | 21 |
525381 | 525381 | 2020-09-12 | Morgan | Illinois | 17137 | 606 | 21 |
528617 | 528617 | 2020-09-13 | Morgan | Illinois | 17137 | 606 | 21 |
531854 | 531854 | 2020-09-14 | Morgan | Illinois | 17137 | 615 | 21 |
535089 | 535089 | 2020-09-15 | Morgan | Illinois | 17137 | 619 | 21 |
538325 | 538325 | 2020-09-16 | Morgan | Illinois | 17137 | 619 | 21 |
541562 | 541562 | 2020-09-17 | Morgan | Illinois | 17137 | 622 | 21 |
544798 | 544798 | 2020-09-18 | Morgan | Illinois | 17137 | 628 | 23 |
548036 | 548036 | 2020-09-19 | Morgan | Illinois | 17137 | 628 | 23 |
551275 | 551275 | 2020-09-20 | Morgan | Illinois | 17137 | 628 | 23 |
554514 | 554514 | 2020-09-21 | Morgan | Illinois | 17137 | 638 | 24 |
557751 | 557751 | 2020-09-22 | Morgan | Illinois | 17137 | 646 | 24 |
560987 | 560987 | 2020-09-23 | Morgan | Illinois | 17137 | 650 | 24 |
564227 | 564227 | 2020-09-24 | Morgan | Illinois | 17137 | 664 | 24 |
567467 | 567467 | 2020-09-25 | Morgan | Illinois | 17137 | 664 | 24 |
570709 | 570709 | 2020-09-26 | Morgan | Illinois | 17137 | 671 | 24 |
573952 | 573952 | 2020-09-27 | Morgan | Illinois | 17137 | 671 | 24 |
577194 | 577194 | 2020-09-28 | Morgan | Illinois | 17137 | 687 | 24 |
580435 | 580435 | 2020-09-29 | Morgan | Illinois | 17137 | 687 | 24 |
583674 | 583674 | 2020-09-30 | Morgan | Illinois | 17137 | 697 | 24 |
586914 | 586914 | 2020-10-01 | Morgan | Illinois | 17137 | 697 | 24 |
590155 | 590155 | 2020-10-02 | Morgan | Illinois | 17137 | 702 | 24 |
593396 | 593396 | 2020-10-03 | Morgan | Illinois | 17137 | 702 | 24 |
596638 | 596638 | 2020-10-04 | Morgan | Illinois | 17137 | 702 | 24 |
599880 | 599880 | 2020-10-05 | Morgan | Illinois | 17137 | 720 | 25 |
603123 | 603123 | 2020-10-06 | Morgan | Illinois | 17137 | 724 | 25 |
606365 | 606365 | 2020-10-07 | Morgan | Illinois | 17137 | 724 | 25 |
609608 | 609608 | 2020-10-08 | Morgan | Illinois | 17137 | 724 | 25 |
612850 | 612850 | 2020-10-09 | Morgan | Illinois | 17137 | 724 | 25 |
616091 | 616091 | 2020-10-10 | Morgan | Illinois | 17137 | 724 | 25 |
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);