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 |
---|---|---|---|---|---|---|---|
1054238 | 1054238 | 2021-02-22 | Hancock | Indiana | 18059 | 7377 | 131 |
1050991 | 1050991 | 2021-02-21 | Hancock | Indiana | 18059 | 7372 | 131 |
1047744 | 1047744 | 2021-02-20 | Hancock | Indiana | 18059 | 7388 | 132 |
1044499 | 1044499 | 2021-02-19 | Hancock | Indiana | 18059 | 7375 | 132 |
1041254 | 1041254 | 2021-02-18 | Hancock | Indiana | 18059 | 7366 | 132 |
1038009 | 1038009 | 2021-02-17 | Hancock | Indiana | 18059 | 7359 | 132 |
1034764 | 1034764 | 2021-02-16 | Hancock | Indiana | 18059 | 7344 | 131 |
1031518 | 1031518 | 2021-02-15 | Hancock | Indiana | 18059 | 7341 | 131 |
1028271 | 1028271 | 2021-02-14 | Hancock | Indiana | 18059 | 7332 | 130 |
1025026 | 1025026 | 2021-02-13 | Hancock | Indiana | 18059 | 7314 | 130 |
1021781 | 1021781 | 2021-02-12 | Hancock | Indiana | 18059 | 7303 | 130 |
1018536 | 1018536 | 2021-02-11 | Hancock | Indiana | 18059 | 7283 | 130 |
1015291 | 1015291 | 2021-02-10 | Hancock | Indiana | 18059 | 7260 | 130 |
1012046 | 1012046 | 2021-02-09 | Hancock | Indiana | 18059 | 7244 | 130 |
1008800 | 1008800 | 2021-02-08 | Hancock | Indiana | 18059 | 7220 | 130 |
1005554 | 1005554 | 2021-02-07 | Hancock | Indiana | 18059 | 7209 | 129 |
1002308 | 1002308 | 2021-02-06 | Hancock | Indiana | 18059 | 7179 | 129 |
999062 | 999062 | 2021-02-05 | Hancock | Indiana | 18059 | 7127 | 127 |
995816 | 995816 | 2021-02-04 | Hancock | Indiana | 18059 | 7107 | 127 |
992570 | 992570 | 2021-02-03 | Hancock | Indiana | 18059 | 7070 | 114 |
989324 | 989324 | 2021-02-02 | Hancock | Indiana | 18059 | 7044 | 113 |
986077 | 986077 | 2021-02-01 | Hancock | Indiana | 18059 | 7018 | 112 |
982830 | 982830 | 2021-01-31 | Hancock | Indiana | 18059 | 6991 | 111 |
979584 | 979584 | 2021-01-30 | Hancock | Indiana | 18059 | 6937 | 111 |
976338 | 976338 | 2021-01-29 | Hancock | Indiana | 18059 | 6912 | 110 |
973093 | 973093 | 2021-01-28 | Hancock | Indiana | 18059 | 6883 | 110 |
969848 | 969848 | 2021-01-27 | Hancock | Indiana | 18059 | 6854 | 109 |
966604 | 966604 | 2021-01-26 | Hancock | Indiana | 18059 | 6805 | 109 |
963359 | 963359 | 2021-01-25 | Hancock | Indiana | 18059 | 6804 | 107 |
960114 | 960114 | 2021-01-24 | Hancock | Indiana | 18059 | 6763 | 107 |
956868 | 956868 | 2021-01-23 | Hancock | Indiana | 18059 | 6719 | 107 |
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 |
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);