ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jackson" and fips = 18071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635622 | 635622 | 2020-10-16 | Jackson | Indiana | 18071 | 1014 | 12 |
632376 | 632376 | 2020-10-15 | Jackson | Indiana | 18071 | 990 | 11 |
629132 | 629132 | 2020-10-14 | Jackson | Indiana | 18071 | 968 | 11 |
625889 | 625889 | 2020-10-13 | Jackson | Indiana | 18071 | 960 | 11 |
622647 | 622647 | 2020-10-12 | Jackson | Indiana | 18071 | 950 | 11 |
619403 | 619403 | 2020-10-11 | Jackson | Indiana | 18071 | 931 | 11 |
616161 | 616161 | 2020-10-10 | Jackson | Indiana | 18071 | 911 | 11 |
612920 | 612920 | 2020-10-09 | Jackson | Indiana | 18071 | 894 | 11 |
609678 | 609678 | 2020-10-08 | Jackson | Indiana | 18071 | 873 | 11 |
606435 | 606435 | 2020-10-07 | Jackson | Indiana | 18071 | 868 | 11 |
603193 | 603193 | 2020-10-06 | Jackson | Indiana | 18071 | 865 | 11 |
599950 | 599950 | 2020-10-05 | Jackson | Indiana | 18071 | 835 | 11 |
596708 | 596708 | 2020-10-04 | Jackson | Indiana | 18071 | 824 | 11 |
593466 | 593466 | 2020-10-03 | Jackson | Indiana | 18071 | 818 | 11 |
590225 | 590225 | 2020-10-02 | Jackson | Indiana | 18071 | 803 | 11 |
586984 | 586984 | 2020-10-01 | Jackson | Indiana | 18071 | 789 | 11 |
583744 | 583744 | 2020-09-30 | Jackson | Indiana | 18071 | 783 | 11 |
580505 | 580505 | 2020-09-29 | Jackson | Indiana | 18071 | 780 | 11 |
577264 | 577264 | 2020-09-28 | Jackson | Indiana | 18071 | 777 | 10 |
574022 | 574022 | 2020-09-27 | Jackson | Indiana | 18071 | 772 | 10 |
570779 | 570779 | 2020-09-26 | Jackson | Indiana | 18071 | 762 | 10 |
567537 | 567537 | 2020-09-25 | Jackson | Indiana | 18071 | 753 | 10 |
564297 | 564297 | 2020-09-24 | Jackson | Indiana | 18071 | 750 | 10 |
561057 | 561057 | 2020-09-23 | Jackson | Indiana | 18071 | 746 | 10 |
557821 | 557821 | 2020-09-22 | Jackson | Indiana | 18071 | 744 | 10 |
554584 | 554584 | 2020-09-21 | Jackson | Indiana | 18071 | 744 | 10 |
551345 | 551345 | 2020-09-20 | Jackson | Indiana | 18071 | 738 | 10 |
548106 | 548106 | 2020-09-19 | Jackson | Indiana | 18071 | 735 | 10 |
544868 | 544868 | 2020-09-18 | Jackson | Indiana | 18071 | 731 | 10 |
541632 | 541632 | 2020-09-17 | Jackson | Indiana | 18071 | 729 | 10 |
538395 | 538395 | 2020-09-16 | Jackson | Indiana | 18071 | 729 | 10 |
535159 | 535159 | 2020-09-15 | Jackson | Indiana | 18071 | 729 | 10 |
531924 | 531924 | 2020-09-14 | Jackson | Indiana | 18071 | 726 | 10 |
528687 | 528687 | 2020-09-13 | Jackson | Indiana | 18071 | 725 | 10 |
525451 | 525451 | 2020-09-12 | Jackson | Indiana | 18071 | 725 | 10 |
522215 | 522215 | 2020-09-11 | Jackson | Indiana | 18071 | 723 | 10 |
518978 | 518978 | 2020-09-10 | Jackson | Indiana | 18071 | 722 | 10 |
515743 | 515743 | 2020-09-09 | Jackson | Indiana | 18071 | 718 | 10 |
512510 | 512510 | 2020-09-08 | Jackson | Indiana | 18071 | 717 | 10 |
509277 | 509277 | 2020-09-07 | Jackson | Indiana | 18071 | 717 | 10 |
506045 | 506045 | 2020-09-06 | Jackson | Indiana | 18071 | 716 | 10 |
502811 | 502811 | 2020-09-05 | Jackson | Indiana | 18071 | 716 | 10 |
499577 | 499577 | 2020-09-04 | Jackson | Indiana | 18071 | 717 | 10 |
496344 | 496344 | 2020-09-03 | Jackson | Indiana | 18071 | 715 | 10 |
493110 | 493110 | 2020-09-02 | Jackson | Indiana | 18071 | 709 | 10 |
489877 | 489877 | 2020-09-01 | Jackson | Indiana | 18071 | 704 | 10 |
486644 | 486644 | 2020-08-31 | Jackson | Indiana | 18071 | 703 | 10 |
483409 | 483409 | 2020-08-30 | Jackson | Indiana | 18071 | 700 | 9 |
480175 | 480175 | 2020-08-29 | Jackson | Indiana | 18071 | 692 | 9 |
476942 | 476942 | 2020-08-28 | Jackson | Indiana | 18071 | 688 | 9 |
473709 | 473709 | 2020-08-27 | Jackson | Indiana | 18071 | 685 | 9 |
470477 | 470477 | 2020-08-26 | Jackson | Indiana | 18071 | 679 | 8 |
467248 | 467248 | 2020-08-25 | Jackson | Indiana | 18071 | 677 | 8 |
464019 | 464019 | 2020-08-24 | Jackson | Indiana | 18071 | 676 | 8 |
460790 | 460790 | 2020-08-23 | Jackson | Indiana | 18071 | 657 | 8 |
457563 | 457563 | 2020-08-22 | Jackson | Indiana | 18071 | 654 | 8 |
454335 | 454335 | 2020-08-21 | Jackson | Indiana | 18071 | 649 | 8 |
451107 | 451107 | 2020-08-20 | Jackson | Indiana | 18071 | 646 | 8 |
447879 | 447879 | 2020-08-19 | Jackson | Indiana | 18071 | 637 | 8 |
444652 | 444652 | 2020-08-18 | Jackson | Indiana | 18071 | 636 | 7 |
441426 | 441426 | 2020-08-17 | Jackson | Indiana | 18071 | 636 | 6 |
438200 | 438200 | 2020-08-16 | Jackson | Indiana | 18071 | 632 | 6 |
434974 | 434974 | 2020-08-15 | Jackson | Indiana | 18071 | 625 | 6 |
431749 | 431749 | 2020-08-14 | Jackson | Indiana | 18071 | 611 | 6 |
428521 | 428521 | 2020-08-13 | Jackson | Indiana | 18071 | 610 | 6 |
425297 | 425297 | 2020-08-12 | Jackson | Indiana | 18071 | 601 | 6 |
422076 | 422076 | 2020-08-11 | Jackson | Indiana | 18071 | 600 | 6 |
418853 | 418853 | 2020-08-10 | Jackson | Indiana | 18071 | 592 | 6 |
415632 | 415632 | 2020-08-09 | Jackson | Indiana | 18071 | 590 | 6 |
412412 | 412412 | 2020-08-08 | Jackson | Indiana | 18071 | 589 | 6 |
409193 | 409193 | 2020-08-07 | Jackson | Indiana | 18071 | 576 | 6 |
405973 | 405973 | 2020-08-06 | Jackson | Indiana | 18071 | 566 | 6 |
402755 | 402755 | 2020-08-05 | Jackson | Indiana | 18071 | 560 | 5 |
399539 | 399539 | 2020-08-04 | Jackson | Indiana | 18071 | 558 | 5 |
396323 | 396323 | 2020-08-03 | Jackson | Indiana | 18071 | 556 | 5 |
393107 | 393107 | 2020-08-02 | Jackson | Indiana | 18071 | 555 | 5 |
389890 | 389890 | 2020-08-01 | Jackson | Indiana | 18071 | 551 | 5 |
386673 | 386673 | 2020-07-31 | Jackson | Indiana | 18071 | 547 | 5 |
383455 | 383455 | 2020-07-30 | Jackson | Indiana | 18071 | 543 | 5 |
380238 | 380238 | 2020-07-29 | Jackson | Indiana | 18071 | 538 | 5 |
377021 | 377021 | 2020-07-28 | Jackson | Indiana | 18071 | 536 | 5 |
373806 | 373806 | 2020-07-27 | Jackson | Indiana | 18071 | 530 | 5 |
370594 | 370594 | 2020-07-26 | Jackson | Indiana | 18071 | 529 | 5 |
367384 | 367384 | 2020-07-25 | Jackson | Indiana | 18071 | 525 | 5 |
364177 | 364177 | 2020-07-24 | Jackson | Indiana | 18071 | 523 | 4 |
360970 | 360970 | 2020-07-23 | Jackson | Indiana | 18071 | 518 | 4 |
357765 | 357765 | 2020-07-22 | Jackson | Indiana | 18071 | 514 | 4 |
354563 | 354563 | 2020-07-21 | Jackson | Indiana | 18071 | 512 | 4 |
351361 | 351361 | 2020-07-20 | Jackson | Indiana | 18071 | 510 | 4 |
348161 | 348161 | 2020-07-19 | Jackson | Indiana | 18071 | 506 | 4 |
344960 | 344960 | 2020-07-18 | Jackson | Indiana | 18071 | 503 | 4 |
341760 | 341760 | 2020-07-17 | Jackson | Indiana | 18071 | 493 | 4 |
338564 | 338564 | 2020-07-16 | Jackson | Indiana | 18071 | 490 | 4 |
335368 | 335368 | 2020-07-15 | Jackson | Indiana | 18071 | 489 | 4 |
332175 | 332175 | 2020-07-14 | Jackson | Indiana | 18071 | 485 | 4 |
328988 | 328988 | 2020-07-13 | Jackson | Indiana | 18071 | 483 | 4 |
325802 | 325802 | 2020-07-12 | Jackson | Indiana | 18071 | 482 | 4 |
322621 | 322621 | 2020-07-11 | Jackson | Indiana | 18071 | 482 | 4 |
319442 | 319442 | 2020-07-10 | Jackson | Indiana | 18071 | 482 | 4 |
316269 | 316269 | 2020-07-09 | Jackson | Indiana | 18071 | 481 | 4 |
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);