ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Morgan" and fips = 18109 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
287823 | 287823 | 2020-06-30 | Morgan | Indiana | 18109 | 328 | 34 |
290973 | 290973 | 2020-07-01 | Morgan | Indiana | 18109 | 330 | 34 |
294127 | 294127 | 2020-07-02 | Morgan | Indiana | 18109 | 333 | 34 |
297285 | 297285 | 2020-07-03 | Morgan | Indiana | 18109 | 336 | 35 |
300447 | 300447 | 2020-07-04 | Morgan | Indiana | 18109 | 338 | 34 |
303611 | 303611 | 2020-07-05 | Morgan | Indiana | 18109 | 340 | 34 |
306776 | 306776 | 2020-07-06 | Morgan | Indiana | 18109 | 340 | 34 |
309944 | 309944 | 2020-07-07 | Morgan | Indiana | 18109 | 340 | 34 |
313114 | 313114 | 2020-07-08 | Morgan | Indiana | 18109 | 338 | 34 |
316288 | 316288 | 2020-07-09 | Morgan | Indiana | 18109 | 339 | 34 |
319461 | 319461 | 2020-07-10 | Morgan | Indiana | 18109 | 347 | 34 |
322640 | 322640 | 2020-07-11 | Morgan | Indiana | 18109 | 353 | 34 |
325821 | 325821 | 2020-07-12 | Morgan | Indiana | 18109 | 356 | 34 |
329007 | 329007 | 2020-07-13 | Morgan | Indiana | 18109 | 355 | 34 |
332194 | 332194 | 2020-07-14 | Morgan | Indiana | 18109 | 355 | 34 |
335387 | 335387 | 2020-07-15 | Morgan | Indiana | 18109 | 358 | 34 |
338583 | 338583 | 2020-07-16 | Morgan | Indiana | 18109 | 364 | 34 |
341779 | 341779 | 2020-07-17 | Morgan | Indiana | 18109 | 375 | 34 |
344979 | 344979 | 2020-07-18 | Morgan | Indiana | 18109 | 377 | 34 |
348180 | 348180 | 2020-07-19 | Morgan | Indiana | 18109 | 380 | 34 |
351380 | 351380 | 2020-07-20 | Morgan | Indiana | 18109 | 381 | 34 |
354582 | 354582 | 2020-07-21 | Morgan | Indiana | 18109 | 379 | 34 |
357784 | 357784 | 2020-07-22 | Morgan | Indiana | 18109 | 379 | 34 |
360989 | 360989 | 2020-07-23 | Morgan | Indiana | 18109 | 392 | 34 |
364196 | 364196 | 2020-07-24 | Morgan | Indiana | 18109 | 395 | 34 |
367403 | 367403 | 2020-07-25 | Morgan | Indiana | 18109 | 397 | 34 |
370613 | 370613 | 2020-07-26 | Morgan | Indiana | 18109 | 405 | 34 |
373825 | 373825 | 2020-07-27 | Morgan | Indiana | 18109 | 405 | 34 |
377040 | 377040 | 2020-07-28 | Morgan | Indiana | 18109 | 411 | 34 |
380257 | 380257 | 2020-07-29 | Morgan | Indiana | 18109 | 414 | 34 |
383474 | 383474 | 2020-07-30 | Morgan | Indiana | 18109 | 420 | 35 |
386692 | 386692 | 2020-07-31 | Morgan | Indiana | 18109 | 422 | 35 |
389909 | 389909 | 2020-08-01 | Morgan | Indiana | 18109 | 424 | 35 |
393126 | 393126 | 2020-08-02 | Morgan | Indiana | 18109 | 430 | 35 |
396342 | 396342 | 2020-08-03 | Morgan | Indiana | 18109 | 437 | 35 |
399558 | 399558 | 2020-08-04 | Morgan | Indiana | 18109 | 449 | 35 |
402774 | 402774 | 2020-08-05 | Morgan | Indiana | 18109 | 452 | 37 |
405992 | 405992 | 2020-08-06 | Morgan | Indiana | 18109 | 463 | 37 |
409212 | 409212 | 2020-08-07 | Morgan | Indiana | 18109 | 471 | 37 |
412431 | 412431 | 2020-08-08 | Morgan | Indiana | 18109 | 479 | 37 |
415651 | 415651 | 2020-08-09 | Morgan | Indiana | 18109 | 488 | 37 |
418872 | 418872 | 2020-08-10 | Morgan | Indiana | 18109 | 495 | 37 |
422095 | 422095 | 2020-08-11 | Morgan | Indiana | 18109 | 505 | 37 |
425316 | 425316 | 2020-08-12 | Morgan | Indiana | 18109 | 501 | 37 |
428540 | 428540 | 2020-08-13 | Morgan | Indiana | 18109 | 504 | 38 |
431768 | 431768 | 2020-08-14 | Morgan | Indiana | 18109 | 513 | 38 |
434993 | 434993 | 2020-08-15 | Morgan | Indiana | 18109 | 517 | 38 |
438219 | 438219 | 2020-08-16 | Morgan | Indiana | 18109 | 519 | 38 |
441445 | 441445 | 2020-08-17 | Morgan | Indiana | 18109 | 524 | 38 |
444671 | 444671 | 2020-08-18 | Morgan | Indiana | 18109 | 532 | 38 |
447898 | 447898 | 2020-08-19 | Morgan | Indiana | 18109 | 533 | 38 |
451126 | 451126 | 2020-08-20 | Morgan | Indiana | 18109 | 539 | 38 |
454354 | 454354 | 2020-08-21 | Morgan | Indiana | 18109 | 541 | 38 |
457582 | 457582 | 2020-08-22 | Morgan | Indiana | 18109 | 547 | 38 |
460809 | 460809 | 2020-08-23 | Morgan | Indiana | 18109 | 553 | 38 |
464038 | 464038 | 2020-08-24 | Morgan | Indiana | 18109 | 565 | 38 |
467267 | 467267 | 2020-08-25 | Morgan | Indiana | 18109 | 567 | 38 |
470496 | 470496 | 2020-08-26 | Morgan | Indiana | 18109 | 569 | 38 |
473728 | 473728 | 2020-08-27 | Morgan | Indiana | 18109 | 581 | 38 |
476961 | 476961 | 2020-08-28 | Morgan | Indiana | 18109 | 587 | 38 |
480194 | 480194 | 2020-08-29 | Morgan | Indiana | 18109 | 594 | 38 |
483428 | 483428 | 2020-08-30 | Morgan | Indiana | 18109 | 600 | 38 |
486663 | 486663 | 2020-08-31 | Morgan | Indiana | 18109 | 608 | 38 |
489896 | 489896 | 2020-09-01 | Morgan | Indiana | 18109 | 610 | 38 |
493129 | 493129 | 2020-09-02 | Morgan | Indiana | 18109 | 612 | 38 |
496363 | 496363 | 2020-09-03 | Morgan | Indiana | 18109 | 615 | 38 |
499596 | 499596 | 2020-09-04 | Morgan | Indiana | 18109 | 622 | 38 |
502830 | 502830 | 2020-09-05 | Morgan | Indiana | 18109 | 628 | 38 |
506064 | 506064 | 2020-09-06 | Morgan | Indiana | 18109 | 634 | 38 |
509296 | 509296 | 2020-09-07 | Morgan | Indiana | 18109 | 637 | 38 |
512529 | 512529 | 2020-09-08 | Morgan | Indiana | 18109 | 638 | 38 |
515762 | 515762 | 2020-09-09 | Morgan | Indiana | 18109 | 644 | 38 |
518997 | 518997 | 2020-09-10 | Morgan | Indiana | 18109 | 646 | 39 |
522234 | 522234 | 2020-09-11 | Morgan | Indiana | 18109 | 648 | 39 |
525470 | 525470 | 2020-09-12 | Morgan | Indiana | 18109 | 658 | 39 |
528706 | 528706 | 2020-09-13 | Morgan | Indiana | 18109 | 673 | 39 |
531943 | 531943 | 2020-09-14 | Morgan | Indiana | 18109 | 678 | 39 |
535178 | 535178 | 2020-09-15 | Morgan | Indiana | 18109 | 680 | 40 |
538414 | 538414 | 2020-09-16 | Morgan | Indiana | 18109 | 686 | 40 |
541651 | 541651 | 2020-09-17 | Morgan | Indiana | 18109 | 693 | 41 |
544887 | 544887 | 2020-09-18 | Morgan | Indiana | 18109 | 698 | 41 |
548125 | 548125 | 2020-09-19 | Morgan | Indiana | 18109 | 707 | 41 |
551364 | 551364 | 2020-09-20 | Morgan | Indiana | 18109 | 709 | 41 |
554603 | 554603 | 2020-09-21 | Morgan | Indiana | 18109 | 714 | 41 |
557840 | 557840 | 2020-09-22 | Morgan | Indiana | 18109 | 713 | 41 |
561076 | 561076 | 2020-09-23 | Morgan | Indiana | 18109 | 719 | 41 |
564316 | 564316 | 2020-09-24 | Morgan | Indiana | 18109 | 722 | 41 |
567556 | 567556 | 2020-09-25 | Morgan | Indiana | 18109 | 729 | 41 |
570798 | 570798 | 2020-09-26 | Morgan | Indiana | 18109 | 737 | 41 |
574041 | 574041 | 2020-09-27 | Morgan | Indiana | 18109 | 742 | 41 |
577283 | 577283 | 2020-09-28 | Morgan | Indiana | 18109 | 747 | 41 |
580524 | 580524 | 2020-09-29 | Morgan | Indiana | 18109 | 752 | 43 |
583763 | 583763 | 2020-09-30 | Morgan | Indiana | 18109 | 752 | 43 |
587003 | 587003 | 2020-10-01 | Morgan | Indiana | 18109 | 760 | 43 |
590244 | 590244 | 2020-10-02 | Morgan | Indiana | 18109 | 768 | 43 |
593485 | 593485 | 2020-10-03 | Morgan | Indiana | 18109 | 773 | 43 |
596727 | 596727 | 2020-10-04 | Morgan | Indiana | 18109 | 781 | 43 |
599969 | 599969 | 2020-10-05 | Morgan | Indiana | 18109 | 784 | 43 |
603212 | 603212 | 2020-10-06 | Morgan | Indiana | 18109 | 792 | 43 |
606454 | 606454 | 2020-10-07 | Morgan | Indiana | 18109 | 799 | 43 |
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);