ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Hancock" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953623 | 953623 | 2021-01-22 | Hancock | Indiana | 18059 | 6661 | 107 |
950378 | 950378 | 2021-01-21 | Hancock | Indiana | 18059 | 6597 | 106 |
947132 | 947132 | 2021-01-20 | Hancock | Indiana | 18059 | 6557 | 102 |
943885 | 943885 | 2021-01-19 | Hancock | Indiana | 18059 | 6491 | 102 |
940640 | 940640 | 2021-01-18 | Hancock | Indiana | 18059 | 6447 | 100 |
937395 | 937395 | 2021-01-17 | Hancock | Indiana | 18059 | 6409 | 100 |
934150 | 934150 | 2021-01-16 | Hancock | Indiana | 18059 | 6354 | 100 |
930905 | 930905 | 2021-01-15 | Hancock | Indiana | 18059 | 6318 | 100 |
927660 | 927660 | 2021-01-14 | Hancock | Indiana | 18059 | 6241 | 98 |
924414 | 924414 | 2021-01-13 | Hancock | Indiana | 18059 | 6172 | 97 |
921169 | 921169 | 2021-01-12 | Hancock | Indiana | 18059 | 6126 | 94 |
917924 | 917924 | 2021-01-11 | Hancock | Indiana | 18059 | 6084 | 91 |
914679 | 914679 | 2021-01-10 | Hancock | Indiana | 18059 | 6023 | 91 |
911434 | 911434 | 2021-01-09 | Hancock | Indiana | 18059 | 5952 | 91 |
908189 | 908189 | 2021-01-08 | Hancock | Indiana | 18059 | 5881 | 91 |
904943 | 904943 | 2021-01-07 | Hancock | Indiana | 18059 | 5799 | 91 |
901698 | 901698 | 2021-01-06 | Hancock | Indiana | 18059 | 5651 | 91 |
898453 | 898453 | 2021-01-05 | Hancock | Indiana | 18059 | 5536 | 90 |
895208 | 895208 | 2021-01-04 | Hancock | Indiana | 18059 | 5484 | 87 |
891961 | 891961 | 2021-01-03 | Hancock | Indiana | 18059 | 5407 | 86 |
888715 | 888715 | 2021-01-02 | Hancock | Indiana | 18059 | 5338 | 86 |
885469 | 885469 | 2021-01-01 | Hancock | Indiana | 18059 | 5268 | 86 |
882224 | 882224 | 2020-12-31 | Hancock | Indiana | 18059 | 5166 | 86 |
878979 | 878979 | 2020-12-30 | Hancock | Indiana | 18059 | 5071 | 86 |
875734 | 875734 | 2020-12-29 | Hancock | Indiana | 18059 | 5006 | 86 |
872489 | 872489 | 2020-12-28 | Hancock | Indiana | 18059 | 4931 | 84 |
869244 | 869244 | 2020-12-27 | Hancock | Indiana | 18059 | 4877 | 84 |
865999 | 865999 | 2020-12-26 | Hancock | Indiana | 18059 | 4883 | 84 |
862754 | 862754 | 2020-12-25 | Hancock | Indiana | 18059 | 4848 | 83 |
859509 | 859509 | 2020-12-24 | Hancock | Indiana | 18059 | 4765 | 81 |
856264 | 856264 | 2020-12-23 | Hancock | Indiana | 18059 | 4713 | 81 |
853019 | 853019 | 2020-12-22 | Hancock | Indiana | 18059 | 4644 | 80 |
849774 | 849774 | 2020-12-21 | Hancock | Indiana | 18059 | 4597 | 80 |
846529 | 846529 | 2020-12-20 | Hancock | Indiana | 18059 | 4586 | 80 |
843283 | 843283 | 2020-12-19 | Hancock | Indiana | 18059 | 4501 | 80 |
840038 | 840038 | 2020-12-18 | Hancock | Indiana | 18059 | 4429 | 79 |
836793 | 836793 | 2020-12-17 | Hancock | Indiana | 18059 | 4353 | 78 |
833547 | 833547 | 2020-12-16 | Hancock | Indiana | 18059 | 4276 | 78 |
830300 | 830300 | 2020-12-15 | Hancock | Indiana | 18059 | 4199 | 78 |
827054 | 827054 | 2020-12-14 | Hancock | Indiana | 18059 | 4136 | 76 |
823807 | 823807 | 2020-12-13 | Hancock | Indiana | 18059 | 4071 | 74 |
820561 | 820561 | 2020-12-12 | Hancock | Indiana | 18059 | 3982 | 74 |
817315 | 817315 | 2020-12-11 | Hancock | Indiana | 18059 | 3855 | 74 |
814069 | 814069 | 2020-12-10 | Hancock | Indiana | 18059 | 3762 | 74 |
810824 | 810824 | 2020-12-09 | Hancock | Indiana | 18059 | 3683 | 72 |
807579 | 807579 | 2020-12-08 | Hancock | Indiana | 18059 | 3588 | 70 |
804334 | 804334 | 2020-12-07 | Hancock | Indiana | 18059 | 3540 | 70 |
801089 | 801089 | 2020-12-06 | Hancock | Indiana | 18059 | 3524 | 70 |
797844 | 797844 | 2020-12-05 | Hancock | Indiana | 18059 | 3414 | 69 |
794599 | 794599 | 2020-12-04 | Hancock | Indiana | 18059 | 3322 | 68 |
791354 | 791354 | 2020-12-03 | Hancock | Indiana | 18059 | 3224 | 66 |
788109 | 788109 | 2020-12-02 | Hancock | Indiana | 18059 | 3095 | 65 |
784865 | 784865 | 2020-12-01 | Hancock | Indiana | 18059 | 2994 | 65 |
781620 | 781620 | 2020-11-30 | Hancock | Indiana | 18059 | 2961 | 60 |
778374 | 778374 | 2020-11-29 | Hancock | Indiana | 18059 | 2887 | 60 |
775129 | 775129 | 2020-11-28 | Hancock | Indiana | 18059 | 2811 | 60 |
771884 | 771884 | 2020-11-27 | Hancock | Indiana | 18059 | 2747 | 60 |
768639 | 768639 | 2020-11-26 | Hancock | Indiana | 18059 | 2622 | 58 |
765393 | 765393 | 2020-11-25 | Hancock | Indiana | 18059 | 2557 | 55 |
762148 | 762148 | 2020-11-24 | Hancock | Indiana | 18059 | 2482 | 54 |
758903 | 758903 | 2020-11-23 | Hancock | Indiana | 18059 | 2454 | 52 |
755656 | 755656 | 2020-11-22 | Hancock | Indiana | 18059 | 2406 | 52 |
752410 | 752410 | 2020-11-21 | Hancock | Indiana | 18059 | 2366 | 52 |
749164 | 749164 | 2020-11-20 | Hancock | Indiana | 18059 | 2287 | 52 |
745918 | 745918 | 2020-11-19 | Hancock | Indiana | 18059 | 2236 | 51 |
742671 | 742671 | 2020-11-18 | Hancock | Indiana | 18059 | 2187 | 51 |
739424 | 739424 | 2020-11-17 | Hancock | Indiana | 18059 | 2119 | 51 |
736180 | 736180 | 2020-11-16 | Hancock | Indiana | 18059 | 2045 | 51 |
732934 | 732934 | 2020-11-15 | Hancock | Indiana | 18059 | 2030 | 50 |
729689 | 729689 | 2020-11-14 | Hancock | Indiana | 18059 | 1949 | 50 |
726446 | 726446 | 2020-11-13 | Hancock | Indiana | 18059 | 1884 | 50 |
723203 | 723203 | 2020-11-12 | Hancock | Indiana | 18059 | 1821 | 49 |
719960 | 719960 | 2020-11-11 | Hancock | Indiana | 18059 | 1764 | 48 |
716717 | 716717 | 2020-11-10 | Hancock | Indiana | 18059 | 1708 | 48 |
713473 | 713473 | 2020-11-09 | Hancock | Indiana | 18059 | 1657 | 48 |
710229 | 710229 | 2020-11-08 | Hancock | Indiana | 18059 | 1629 | 48 |
706985 | 706985 | 2020-11-07 | Hancock | Indiana | 18059 | 1603 | 48 |
703742 | 703742 | 2020-11-06 | Hancock | Indiana | 18059 | 1566 | 48 |
700500 | 700500 | 2020-11-05 | Hancock | Indiana | 18059 | 1513 | 48 |
697256 | 697256 | 2020-11-04 | Hancock | Indiana | 18059 | 1466 | 48 |
694014 | 694014 | 2020-11-03 | Hancock | Indiana | 18059 | 1426 | 48 |
690771 | 690771 | 2020-11-02 | Hancock | Indiana | 18059 | 1404 | 47 |
687526 | 687526 | 2020-11-01 | Hancock | Indiana | 18059 | 1385 | 47 |
684282 | 684282 | 2020-10-31 | Hancock | Indiana | 18059 | 1370 | 47 |
681039 | 681039 | 2020-10-30 | Hancock | Indiana | 18059 | 1341 | 47 |
677796 | 677796 | 2020-10-29 | Hancock | Indiana | 18059 | 1319 | 47 |
674553 | 674553 | 2020-10-28 | Hancock | Indiana | 18059 | 1288 | 47 |
671311 | 671311 | 2020-10-27 | Hancock | Indiana | 18059 | 1267 | 47 |
668068 | 668068 | 2020-10-26 | Hancock | Indiana | 18059 | 1264 | 47 |
664824 | 664824 | 2020-10-25 | Hancock | Indiana | 18059 | 1248 | 47 |
661579 | 661579 | 2020-10-24 | Hancock | Indiana | 18059 | 1240 | 47 |
658335 | 658335 | 2020-10-23 | Hancock | Indiana | 18059 | 1216 | 47 |
655090 | 655090 | 2020-10-22 | Hancock | Indiana | 18059 | 1199 | 48 |
651845 | 651845 | 2020-10-21 | Hancock | Indiana | 18059 | 1173 | 48 |
648601 | 648601 | 2020-10-20 | Hancock | Indiana | 18059 | 1158 | 48 |
645356 | 645356 | 2020-10-19 | Hancock | Indiana | 18059 | 1158 | 47 |
642109 | 642109 | 2020-10-18 | Hancock | Indiana | 18059 | 1145 | 47 |
638862 | 638862 | 2020-10-17 | Hancock | Indiana | 18059 | 1129 | 47 |
635616 | 635616 | 2020-10-16 | Hancock | Indiana | 18059 | 1115 | 47 |
632370 | 632370 | 2020-10-15 | Hancock | Indiana | 18059 | 1107 | 47 |
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);