ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Marshall" and fips = 17123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054164 | 1054164 | 2021-02-22 | Marshall | Illinois | 17123 | 832 | 16 |
1050917 | 1050917 | 2021-02-21 | Marshall | Illinois | 17123 | 831 | 16 |
1047670 | 1047670 | 2021-02-20 | Marshall | Illinois | 17123 | 830 | 16 |
1044425 | 1044425 | 2021-02-19 | Marshall | Illinois | 17123 | 830 | 16 |
1041180 | 1041180 | 2021-02-18 | Marshall | Illinois | 17123 | 829 | 16 |
1037935 | 1037935 | 2021-02-17 | Marshall | Illinois | 17123 | 824 | 16 |
1034690 | 1034690 | 2021-02-16 | Marshall | Illinois | 17123 | 823 | 16 |
1031444 | 1031444 | 2021-02-15 | Marshall | Illinois | 17123 | 822 | 16 |
1028197 | 1028197 | 2021-02-14 | Marshall | Illinois | 17123 | 821 | 16 |
1024952 | 1024952 | 2021-02-13 | Marshall | Illinois | 17123 | 819 | 16 |
1021707 | 1021707 | 2021-02-12 | Marshall | Illinois | 17123 | 815 | 16 |
1018462 | 1018462 | 2021-02-11 | Marshall | Illinois | 17123 | 804 | 16 |
1015217 | 1015217 | 2021-02-10 | Marshall | Illinois | 17123 | 803 | 16 |
1011972 | 1011972 | 2021-02-09 | Marshall | Illinois | 17123 | 801 | 16 |
1008726 | 1008726 | 2021-02-08 | Marshall | Illinois | 17123 | 798 | 16 |
1005480 | 1005480 | 2021-02-07 | Marshall | Illinois | 17123 | 796 | 16 |
1002234 | 1002234 | 2021-02-06 | Marshall | Illinois | 17123 | 795 | 16 |
998988 | 998988 | 2021-02-05 | Marshall | Illinois | 17123 | 793 | 16 |
995742 | 995742 | 2021-02-04 | Marshall | Illinois | 17123 | 765 | 15 |
992496 | 992496 | 2021-02-03 | Marshall | Illinois | 17123 | 756 | 15 |
989250 | 989250 | 2021-02-02 | Marshall | Illinois | 17123 | 752 | 15 |
986003 | 986003 | 2021-02-01 | Marshall | Illinois | 17123 | 753 | 15 |
982756 | 982756 | 2021-01-31 | Marshall | Illinois | 17123 | 748 | 15 |
979510 | 979510 | 2021-01-30 | Marshall | Illinois | 17123 | 745 | 15 |
976265 | 976265 | 2021-01-29 | Marshall | Illinois | 17123 | 738 | 15 |
973020 | 973020 | 2021-01-28 | Marshall | Illinois | 17123 | 723 | 15 |
969775 | 969775 | 2021-01-27 | Marshall | Illinois | 17123 | 718 | 15 |
966531 | 966531 | 2021-01-26 | Marshall | Illinois | 17123 | 713 | 15 |
963286 | 963286 | 2021-01-25 | Marshall | Illinois | 17123 | 709 | 15 |
960041 | 960041 | 2021-01-24 | Marshall | Illinois | 17123 | 705 | 15 |
956795 | 956795 | 2021-01-23 | Marshall | Illinois | 17123 | 703 | 15 |
953550 | 953550 | 2021-01-22 | Marshall | Illinois | 17123 | 693 | 15 |
950305 | 950305 | 2021-01-21 | Marshall | Illinois | 17123 | 682 | 14 |
947059 | 947059 | 2021-01-20 | Marshall | Illinois | 17123 | 677 | 14 |
943812 | 943812 | 2021-01-19 | Marshall | Illinois | 17123 | 670 | 13 |
940567 | 940567 | 2021-01-18 | Marshall | Illinois | 17123 | 664 | 13 |
937322 | 937322 | 2021-01-17 | Marshall | Illinois | 17123 | 662 | 13 |
934077 | 934077 | 2021-01-16 | Marshall | Illinois | 17123 | 657 | 13 |
930832 | 930832 | 2021-01-15 | Marshall | Illinois | 17123 | 652 | 13 |
927587 | 927587 | 2021-01-14 | Marshall | Illinois | 17123 | 644 | 13 |
924341 | 924341 | 2021-01-13 | Marshall | Illinois | 17123 | 637 | 13 |
921096 | 921096 | 2021-01-12 | Marshall | Illinois | 17123 | 633 | 13 |
917851 | 917851 | 2021-01-11 | Marshall | Illinois | 17123 | 631 | 13 |
914606 | 914606 | 2021-01-10 | Marshall | Illinois | 17123 | 626 | 13 |
911361 | 911361 | 2021-01-09 | Marshall | Illinois | 17123 | 623 | 13 |
908116 | 908116 | 2021-01-08 | Marshall | Illinois | 17123 | 619 | 13 |
904870 | 904870 | 2021-01-07 | Marshall | Illinois | 17123 | 610 | 12 |
901625 | 901625 | 2021-01-06 | Marshall | Illinois | 17123 | 608 | 11 |
898380 | 898380 | 2021-01-05 | Marshall | Illinois | 17123 | 602 | 11 |
895135 | 895135 | 2021-01-04 | Marshall | Illinois | 17123 | 598 | 11 |
891888 | 891888 | 2021-01-03 | Marshall | Illinois | 17123 | 592 | 11 |
888641 | 888641 | 2021-01-02 | Marshall | Illinois | 17123 | 589 | 11 |
885396 | 885396 | 2021-01-01 | Marshall | Illinois | 17123 | 578 | 9 |
882151 | 882151 | 2020-12-31 | Marshall | Illinois | 17123 | 578 | 9 |
878906 | 878906 | 2020-12-30 | Marshall | Illinois | 17123 | 571 | 9 |
875661 | 875661 | 2020-12-29 | Marshall | Illinois | 17123 | 569 | 9 |
872416 | 872416 | 2020-12-28 | Marshall | Illinois | 17123 | 566 | 9 |
869171 | 869171 | 2020-12-27 | Marshall | Illinois | 17123 | 561 | 9 |
865926 | 865926 | 2020-12-26 | Marshall | Illinois | 17123 | 559 | 9 |
862681 | 862681 | 2020-12-25 | Marshall | Illinois | 17123 | 559 | 9 |
859436 | 859436 | 2020-12-24 | Marshall | Illinois | 17123 | 558 | 9 |
856191 | 856191 | 2020-12-23 | Marshall | Illinois | 17123 | 553 | 9 |
852946 | 852946 | 2020-12-22 | Marshall | Illinois | 17123 | 551 | 8 |
849701 | 849701 | 2020-12-21 | Marshall | Illinois | 17123 | 546 | 8 |
846456 | 846456 | 2020-12-20 | Marshall | Illinois | 17123 | 543 | 8 |
843210 | 843210 | 2020-12-19 | Marshall | Illinois | 17123 | 541 | 8 |
839965 | 839965 | 2020-12-18 | Marshall | Illinois | 17123 | 532 | 8 |
836720 | 836720 | 2020-12-17 | Marshall | Illinois | 17123 | 527 | 8 |
833474 | 833474 | 2020-12-16 | Marshall | Illinois | 17123 | 519 | 7 |
830227 | 830227 | 2020-12-15 | Marshall | Illinois | 17123 | 509 | 7 |
826981 | 826981 | 2020-12-14 | Marshall | Illinois | 17123 | 503 | 7 |
823734 | 823734 | 2020-12-13 | Marshall | Illinois | 17123 | 500 | 7 |
820488 | 820488 | 2020-12-12 | Marshall | Illinois | 17123 | 493 | 7 |
817242 | 817242 | 2020-12-11 | Marshall | Illinois | 17123 | 486 | 7 |
813996 | 813996 | 2020-12-10 | Marshall | Illinois | 17123 | 474 | 7 |
810751 | 810751 | 2020-12-09 | Marshall | Illinois | 17123 | 469 | 7 |
807506 | 807506 | 2020-12-08 | Marshall | Illinois | 17123 | 466 | 7 |
804261 | 804261 | 2020-12-07 | Marshall | Illinois | 17123 | 459 | 7 |
801016 | 801016 | 2020-12-06 | Marshall | Illinois | 17123 | 457 | 7 |
797771 | 797771 | 2020-12-05 | Marshall | Illinois | 17123 | 456 | 7 |
794526 | 794526 | 2020-12-04 | Marshall | Illinois | 17123 | 441 | 7 |
791281 | 791281 | 2020-12-03 | Marshall | Illinois | 17123 | 435 | 7 |
788036 | 788036 | 2020-12-02 | Marshall | Illinois | 17123 | 427 | 7 |
784792 | 784792 | 2020-12-01 | Marshall | Illinois | 17123 | 421 | 6 |
781547 | 781547 | 2020-11-30 | Marshall | Illinois | 17123 | 414 | 6 |
778301 | 778301 | 2020-11-29 | Marshall | Illinois | 17123 | 406 | 6 |
775056 | 775056 | 2020-11-28 | Marshall | Illinois | 17123 | 403 | 6 |
771811 | 771811 | 2020-11-27 | Marshall | Illinois | 17123 | 392 | 6 |
768566 | 768566 | 2020-11-26 | Marshall | Illinois | 17123 | 382 | 6 |
765320 | 765320 | 2020-11-25 | Marshall | Illinois | 17123 | 375 | 5 |
762075 | 762075 | 2020-11-24 | Marshall | Illinois | 17123 | 362 | 5 |
758830 | 758830 | 2020-11-23 | Marshall | Illinois | 17123 | 352 | 5 |
755583 | 755583 | 2020-11-22 | Marshall | Illinois | 17123 | 340 | 5 |
752337 | 752337 | 2020-11-21 | Marshall | Illinois | 17123 | 331 | 5 |
749091 | 749091 | 2020-11-20 | Marshall | Illinois | 17123 | 320 | 5 |
745845 | 745845 | 2020-11-19 | Marshall | Illinois | 17123 | 307 | 5 |
742598 | 742598 | 2020-11-18 | Marshall | Illinois | 17123 | 298 | 5 |
739351 | 739351 | 2020-11-17 | Marshall | Illinois | 17123 | 281 | 5 |
736107 | 736107 | 2020-11-16 | Marshall | Illinois | 17123 | 268 | 5 |
732861 | 732861 | 2020-11-15 | Marshall | Illinois | 17123 | 255 | 5 |
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);