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 2021-05-24 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1349675 | 1349675 | 2021-05-24 | Adams | Indiana | 18001 | 3501 | 56 |
1349676 | 1349676 | 2021-05-24 | Allen | Indiana | 18003 | 41275 | 704 |
1349677 | 1349677 | 2021-05-24 | Bartholomew | Indiana | 18005 | 8139 | 161 |
1349678 | 1349678 | 2021-05-24 | Benton | Indiana | 18007 | 991 | 14 |
1349679 | 1349679 | 2021-05-24 | Blackford | Indiana | 18009 | 1366 | 32 |
1349680 | 1349680 | 2021-05-24 | Boone | Indiana | 18011 | 6812 | 106 |
1349681 | 1349681 | 2021-05-24 | Brown | Indiana | 18013 | 1030 | 41 |
1349682 | 1349682 | 2021-05-24 | Carroll | Indiana | 18015 | 1918 | 22 |
1349683 | 1349683 | 2021-05-24 | Cass | Indiana | 18017 | 5918 | 108 |
1349684 | 1349684 | 2021-05-24 | Clark | Indiana | 18019 | 13105 | 201 |
1349685 | 1349685 | 2021-05-24 | Clay | Indiana | 18021 | 2623 | 47 |
1349686 | 1349686 | 2021-05-24 | Clinton | Indiana | 18023 | 4316 | 58 |
1349687 | 1349687 | 2021-05-24 | Crawford | Indiana | 18025 | 1017 | 16 |
1349688 | 1349688 | 2021-05-24 | Daviess | Indiana | 18027 | 2993 | 101 |
1349689 | 1349689 | 2021-05-24 | DeKalb | Indiana | 18033 | 4345 | 88 |
1349690 | 1349690 | 2021-05-24 | Dearborn | Indiana | 18029 | 5857 | 81 |
1349691 | 1349691 | 2021-05-24 | Decatur | Indiana | 18031 | 2929 | 96 |
1349692 | 1349692 | 2021-05-24 | Delaware | Indiana | 18035 | 10848 | 196 |
1349693 | 1349693 | 2021-05-24 | Dubois | Indiana | 18037 | 6180 | 118 |
1349694 | 1349694 | 2021-05-24 | Elkhart | Indiana | 18039 | 29155 | 462 |
1349695 | 1349695 | 2021-05-24 | Fayette | Indiana | 18041 | 2968 | 65 |
1349696 | 1349696 | 2021-05-24 | Floyd | Indiana | 18043 | 7718 | 183 |
1349697 | 1349697 | 2021-05-24 | Fountain | Indiana | 18045 | 2154 | 47 |
1349698 | 1349698 | 2021-05-24 | Franklin | Indiana | 18047 | 1708 | 36 |
1349699 | 1349699 | 2021-05-24 | Fulton | Indiana | 18049 | 1973 | 40 |
1349700 | 1349700 | 2021-05-24 | Gibson | Indiana | 18051 | 4407 | 95 |
1349701 | 1349701 | 2021-05-24 | Grant | Indiana | 18053 | 7562 | 181 |
1349702 | 1349702 | 2021-05-24 | Greene | Indiana | 18055 | 2838 | 89 |
1349703 | 1349703 | 2021-05-24 | Hamilton | Indiana | 18057 | 36092 | 429 |
1349704 | 1349704 | 2021-05-24 | Hancock | Indiana | 18059 | 8441 | 146 |
1349705 | 1349705 | 2021-05-24 | Harrison | Indiana | 18061 | 4386 | 75 |
1349706 | 1349706 | 2021-05-24 | Hendricks | Indiana | 18063 | 17480 | 336 |
1349707 | 1349707 | 2021-05-24 | Henry | Indiana | 18065 | 5842 | 107 |
1349708 | 1349708 | 2021-05-24 | Howard | Indiana | 18067 | 10117 | 226 |
1349709 | 1349709 | 2021-05-24 | Huntington | Indiana | 18069 | 3983 | 82 |
1349710 | 1349710 | 2021-05-24 | Jackson | Indiana | 18071 | 5055 | 75 |
1349711 | 1349711 | 2021-05-24 | Jasper | Indiana | 18073 | 3778 | 54 |
1349712 | 1349712 | 2021-05-24 | Jay | Indiana | 18075 | 2001 | 33 |
1349713 | 1349713 | 2021-05-24 | Jefferson | Indiana | 18077 | 3327 | 83 |
1349714 | 1349714 | 2021-05-24 | Jennings | Indiana | 18079 | 2325 | 51 |
1349715 | 1349715 | 2021-05-24 | Johnson | Indiana | 18081 | 18221 | 398 |
1349716 | 1349716 | 2021-05-24 | Knox | Indiana | 18083 | 3743 | 90 |
1349717 | 1349717 | 2021-05-24 | Kosciusko | Indiana | 18085 | 9546 | 121 |
1349718 | 1349718 | 2021-05-24 | LaGrange | Indiana | 18087 | 2708 | 72 |
1349719 | 1349719 | 2021-05-24 | LaPorte | Indiana | 18091 | 12211 | 219 |
1349720 | 1349720 | 2021-05-24 | Lake | Indiana | 18089 | 54778 | 1033 |
1349721 | 1349721 | 2021-05-24 | Lawrence | Indiana | 18093 | 4651 | 123 |
1349722 | 1349722 | 2021-05-24 | Madison | Indiana | 18095 | 12861 | 360 |
1349723 | 1349723 | 2021-05-24 | Marion | Indiana | 18097 | 101628 | 1822 |
1349724 | 1349724 | 2021-05-24 | Marshall | Indiana | 18099 | 6163 | 114 |
1349725 | 1349725 | 2021-05-24 | Martin | Indiana | 18101 | 903 | 15 |
1349726 | 1349726 | 2021-05-24 | Miami | Indiana | 18103 | 3870 | 69 |
1349727 | 1349727 | 2021-05-24 | Monroe | Indiana | 18105 | 12021 | 174 |
1349728 | 1349728 | 2021-05-24 | Montgomery | Indiana | 18107 | 4277 | 91 |
1349729 | 1349729 | 2021-05-24 | Morgan | Indiana | 18109 | 6665 | 145 |
1349730 | 1349730 | 2021-05-24 | Newton | Indiana | 18111 | 1105 | 37 |
1349731 | 1349731 | 2021-05-24 | Noble | Indiana | 18113 | 5724 | 87 |
1349732 | 1349732 | 2021-05-24 | Ohio | Indiana | 18115 | 577 | 11 |
1349733 | 1349733 | 2021-05-24 | Orange | Indiana | 18117 | 1870 | 57 |
1349734 | 1349734 | 2021-05-24 | Owen | Indiana | 18119 | 2062 | 58 |
1349735 | 1349735 | 2021-05-24 | Parke | Indiana | 18121 | 1486 | 16 |
1349736 | 1349736 | 2021-05-24 | Perry | Indiana | 18123 | 1863 | 38 |
1349737 | 1349737 | 2021-05-24 | Pike | Indiana | 18125 | 1364 | 34 |
1349738 | 1349738 | 2021-05-24 | Porter | Indiana | 18127 | 19115 | 330 |
1349739 | 1349739 | 2021-05-24 | Posey | Indiana | 18129 | 2726 | 34 |
1349740 | 1349740 | 2021-05-24 | Pulaski | Indiana | 18131 | 1183 | 46 |
1349741 | 1349741 | 2021-05-24 | Putnam | Indiana | 18133 | 3674 | 60 |
1349742 | 1349742 | 2021-05-24 | Randolph | Indiana | 18135 | 2471 | 83 |
1349743 | 1349743 | 2021-05-24 | Ripley | Indiana | 18137 | 3428 | 70 |
1349744 | 1349744 | 2021-05-24 | Rush | Indiana | 18139 | 1814 | 25 |
1349745 | 1349745 | 2021-05-24 | Scott | Indiana | 18143 | 2688 | 57 |
1349746 | 1349746 | 2021-05-24 | Shelby | Indiana | 18145 | 5957 | 106 |
1349747 | 1349747 | 2021-05-24 | Spencer | Indiana | 18147 | 2337 | 31 |
1349748 | 1349748 | 2021-05-24 | St. Joseph | Indiana | 18141 | 36616 | 572 |
1349749 | 1349749 | 2021-05-24 | Starke | Indiana | 18149 | 2214 | 57 |
1349750 | 1349750 | 2021-05-24 | Steuben | Indiana | 18151 | 3941 | 59 |
1349751 | 1349751 | 2021-05-24 | Sullivan | Indiana | 18153 | 2129 | 42 |
1349752 | 1349752 | 2021-05-24 | Switzerland | Indiana | 18155 | 799 | 8 |
1349753 | 1349753 | 2021-05-24 | Tippecanoe | Indiana | 18157 | 22601 | 222 |
1349754 | 1349754 | 2021-05-24 | Tipton | Indiana | 18159 | 1642 | 47 |
1349755 | 1349755 | 2021-05-24 | Union | Indiana | 18161 | 750 | 11 |
1349756 | 1349756 | 2021-05-24 | Vanderburgh | Indiana | 18163 | 22468 | 402 |
1349757 | 1349757 | 2021-05-24 | Vermillion | Indiana | 18165 | 1709 | 44 |
1349758 | 1349758 | 2021-05-24 | Vigo | Indiana | 18167 | 12541 | 255 |
1349759 | 1349759 | 2021-05-24 | Wabash | Indiana | 18169 | 3575 | 81 |
1349760 | 1349760 | 2021-05-24 | Warren | Indiana | 18171 | 830 | 16 |
1349761 | 1349761 | 2021-05-24 | Warrick | Indiana | 18173 | 7823 | 158 |
1349762 | 1349762 | 2021-05-24 | Washington | Indiana | 18175 | 2427 | 33 |
1349763 | 1349763 | 2021-05-24 | Wayne | Indiana | 18177 | 7487 | 203 |
1349764 | 1349764 | 2021-05-24 | Wells | Indiana | 18179 | 2958 | 83 |
1349765 | 1349765 | 2021-05-24 | White | Indiana | 18181 | 3207 | 54 |
1349766 | 1349766 | 2021-05-24 | Whitley | Indiana | 18183 | 4019 | 40 |
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);