ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2022-01-28 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2158629 | 2158629 | 2022-01-28 | Adams | Indiana | 18001 | 7066 | 105 |
2158630 | 2158630 | 2022-01-28 | Allen | Indiana | 18003 | 99234 | 1082 |
2158631 | 2158631 | 2022-01-28 | Bartholomew | Indiana | 18005 | 19852 | 227 |
2158632 | 2158632 | 2022-01-28 | Benton | Indiana | 18007 | 2363 | 21 |
2158633 | 2158633 | 2022-01-28 | Blackford | Indiana | 18009 | 2941 | 63 |
2158634 | 2158634 | 2022-01-28 | Boone | Indiana | 18011 | 14309 | 154 |
2158635 | 2158635 | 2022-01-28 | Brown | Indiana | 18013 | 2463 | 60 |
2158636 | 2158636 | 2022-01-28 | Carroll | Indiana | 18015 | 4046 | 56 |
2158637 | 2158637 | 2022-01-28 | Cass | Indiana | 18017 | 10861 | 152 |
2158638 | 2158638 | 2022-01-28 | Clark | Indiana | 18019 | 28371 | 354 |
2158639 | 2158639 | 2022-01-28 | Clay | Indiana | 18021 | 6499 | 79 |
2158640 | 2158640 | 2022-01-28 | Clinton | Indiana | 18023 | 8748 | 108 |
2158641 | 2158641 | 2022-01-28 | Crawford | Indiana | 18025 | 2330 | 35 |
2158642 | 2158642 | 2022-01-28 | Daviess | Indiana | 18027 | 7063 | 134 |
2158643 | 2158643 | 2022-01-28 | DeKalb | Indiana | 18033 | 10801 | 137 |
2158644 | 2158644 | 2022-01-28 | Dearborn | Indiana | 18029 | 12724 | 122 |
2158645 | 2158645 | 2022-01-28 | Decatur | Indiana | 18031 | 6596 | 134 |
2158646 | 2158646 | 2022-01-28 | Delaware | Indiana | 18035 | 23088 | 399 |
2158647 | 2158647 | 2022-01-28 | Dubois | Indiana | 18037 | 12120 | 156 |
2158648 | 2158648 | 2022-01-28 | Elkhart | Indiana | 18039 | 52283 | 676 |
2158649 | 2158649 | 2022-01-28 | Fayette | Indiana | 18041 | 6405 | 131 |
2158650 | 2158650 | 2022-01-28 | Floyd | Indiana | 18043 | 17381 | 271 |
2158651 | 2158651 | 2022-01-28 | Fountain | Indiana | 18045 | 5090 | 88 |
2158652 | 2158652 | 2022-01-28 | Franklin | Indiana | 18047 | 4094 | 58 |
2158653 | 2158653 | 2022-01-28 | Fulton | Indiana | 18049 | 4637 | 99 |
2158654 | 2158654 | 2022-01-28 | Gibson | Indiana | 18051 | 10745 | 133 |
2158655 | 2158655 | 2022-01-28 | Grant | Indiana | 18053 | 16828 | 321 |
2158656 | 2158656 | 2022-01-28 | Greene | Indiana | 18055 | 6609 | 123 |
2158657 | 2158657 | 2022-01-28 | Hamilton | Indiana | 18057 | 77550 | 593 |
2158658 | 2158658 | 2022-01-28 | Hancock | Indiana | 18059 | 19786 | 234 |
2158659 | 2158659 | 2022-01-28 | Harrison | Indiana | 18061 | 9949 | 125 |
2158660 | 2158660 | 2022-01-28 | Hendricks | Indiana | 18063 | 38913 | 505 |
2158661 | 2158661 | 2022-01-28 | Henry | Indiana | 18065 | 12343 | 211 |
2158662 | 2158662 | 2022-01-28 | Howard | Indiana | 18067 | 24060 | 406 |
2158663 | 2158663 | 2022-01-28 | Huntington | Indiana | 18069 | 10853 | 146 |
2158664 | 2158664 | 2022-01-28 | Jackson | Indiana | 18071 | 11615 | 108 |
2158665 | 2158665 | 2022-01-28 | Jasper | Indiana | 18073 | 8641 | 126 |
2158666 | 2158666 | 2022-01-28 | Jay | Indiana | 18075 | 4523 | 73 |
2158667 | 2158667 | 2022-01-28 | Jefferson | Indiana | 18077 | 8742 | 137 |
2158668 | 2158668 | 2022-01-28 | Jennings | Indiana | 18079 | 6482 | 94 |
2158669 | 2158669 | 2022-01-28 | Johnson | Indiana | 18081 | 40646 | 566 |
2158670 | 2158670 | 2022-01-28 | Knox | Indiana | 18083 | 9837 | 131 |
2158671 | 2158671 | 2022-01-28 | Kosciusko | Indiana | 18085 | 18847 | 214 |
2158672 | 2158672 | 2022-01-28 | LaGrange | Indiana | 18087 | 5641 | 99 |
2158673 | 2158673 | 2022-01-28 | LaPorte | Indiana | 18091 | 24415 | 324 |
2158674 | 2158674 | 2022-01-28 | Lake | Indiana | 18089 | 103192 | 1653 |
2158675 | 2158675 | 2022-01-28 | Lawrence | Indiana | 18093 | 10887 | 229 |
2158676 | 2158676 | 2022-01-28 | Madison | Indiana | 18095 | 31136 | 591 |
2158677 | 2158677 | 2022-01-28 | Marion | Indiana | 18097 | 216186 | 2733 |
2158678 | 2158678 | 2022-01-28 | Marshall | Indiana | 18099 | 11854 | 183 |
2158679 | 2158679 | 2022-01-28 | Martin | Indiana | 18101 | 2058 | 23 |
2158680 | 2158680 | 2022-01-28 | Miami | Indiana | 18103 | 8741 | 144 |
2158681 | 2158681 | 2022-01-28 | Monroe | Indiana | 18105 | 25271 | 254 |
2158682 | 2158682 | 2022-01-28 | Montgomery | Indiana | 18107 | 10001 | 150 |
2158683 | 2158683 | 2022-01-28 | Morgan | Indiana | 18109 | 15560 | 256 |
2158684 | 2158684 | 2022-01-28 | Newton | Indiana | 18111 | 2445 | 64 |
2158685 | 2158685 | 2022-01-28 | Noble | Indiana | 18113 | 12515 | 146 |
2158686 | 2158686 | 2022-01-28 | Ohio | Indiana | 18115 | 1355 | 17 |
2158687 | 2158687 | 2022-01-28 | Orange | Indiana | 18117 | 4679 | 90 |
2158688 | 2158688 | 2022-01-28 | Owen | Indiana | 18119 | 5426 | 106 |
2158689 | 2158689 | 2022-01-28 | Parke | Indiana | 18121 | 3432 | 42 |
2158690 | 2158690 | 2022-01-28 | Perry | Indiana | 18123 | 4327 | 61 |
2158691 | 2158691 | 2022-01-28 | Pike | Indiana | 18125 | 3490 | 48 |
2158692 | 2158692 | 2022-01-28 | Porter | Indiana | 18127 | 35610 | 515 |
2158693 | 2158693 | 2022-01-28 | Posey | Indiana | 18129 | 6084 | 48 |
2158694 | 2158694 | 2022-01-28 | Pulaski | Indiana | 18131 | 2894 | 79 |
2158695 | 2158695 | 2022-01-28 | Putnam | Indiana | 18133 | 8800 | 106 |
2158696 | 2158696 | 2022-01-28 | Randolph | Indiana | 18135 | 5579 | 136 |
2158697 | 2158697 | 2022-01-28 | Ripley | Indiana | 18137 | 7838 | 124 |
2158698 | 2158698 | 2022-01-28 | Rush | Indiana | 18139 | 4577 | 42 |
2158699 | 2158699 | 2022-01-28 | Scott | Indiana | 18143 | 7241 | 91 |
2158700 | 2158700 | 2022-01-28 | Shelby | Indiana | 18145 | 13812 | 166 |
2158701 | 2158701 | 2022-01-28 | Spencer | Indiana | 18147 | 4875 | 58 |
2158702 | 2158702 | 2022-01-28 | St. Joseph | Indiana | 18141 | 67837 | 794 |
2158703 | 2158703 | 2022-01-28 | Starke | Indiana | 18149 | 4565 | 92 |
2158704 | 2158704 | 2022-01-28 | Steuben | Indiana | 18151 | 9189 | 110 |
2158705 | 2158705 | 2022-01-28 | Sullivan | Indiana | 18153 | 4843 | 68 |
2158706 | 2158706 | 2022-01-28 | Switzerland | Indiana | 18155 | 2175 | 15 |
2158707 | 2158707 | 2022-01-28 | Tippecanoe | Indiana | 18157 | 47140 | 352 |
2158708 | 2158708 | 2022-01-28 | Tipton | Indiana | 18159 | 3380 | 81 |
2158709 | 2158709 | 2022-01-28 | Union | Indiana | 18161 | 1887 | 21 |
2158710 | 2158710 | 2022-01-28 | Vanderburgh | Indiana | 18163 | 53066 | 554 |
2158711 | 2158711 | 2022-01-28 | Vermillion | Indiana | 18165 | 3838 | 67 |
2158712 | 2158712 | 2022-01-28 | Vigo | Indiana | 18167 | 27350 | 359 |
2158713 | 2158713 | 2022-01-28 | Wabash | Indiana | 18169 | 8238 | 142 |
2158714 | 2158714 | 2022-01-28 | Warren | Indiana | 18171 | 1934 | 24 |
2158715 | 2158715 | 2022-01-28 | Warrick | Indiana | 18173 | 18668 | 225 |
2158716 | 2158716 | 2022-01-28 | Washington | Indiana | 18175 | 5511 | 73 |
2158717 | 2158717 | 2022-01-28 | Wayne | Indiana | 18177 | 18004 | 313 |
2158718 | 2158718 | 2022-01-28 | Wells | Indiana | 18179 | 6253 | 126 |
2158719 | 2158719 | 2022-01-28 | White | Indiana | 18181 | 6506 | 86 |
2158720 | 2158720 | 2022-01-28 | Whitley | Indiana | 18183 | 9312 | 74 |
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);