ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2022-04-14 and state = "Indiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2405922 | 2405922 | 2022-04-14 | Unknown | Indiana | 0 | 13 | |
2405898 | 2405898 | 2022-04-14 | Ohio | Indiana | 18115 | 1444 | 19 |
2405921 | 2405921 | 2022-04-14 | Union | Indiana | 18161 | 2019 | 21 |
2405927 | 2405927 | 2022-04-14 | Warren | Indiana | 18171 | 2091 | 30 |
2405891 | 2405891 | 2022-04-14 | Martin | Indiana | 18101 | 2163 | 25 |
2405918 | 2405918 | 2022-04-14 | Switzerland | Indiana | 18155 | 2311 | 20 |
2405844 | 2405844 | 2022-04-14 | Benton | Indiana | 18007 | 2477 | 21 |
2405853 | 2405853 | 2022-04-14 | Crawford | Indiana | 18025 | 2548 | 40 |
2405896 | 2405896 | 2022-04-14 | Newton | Indiana | 18111 | 2565 | 68 |
2405847 | 2405847 | 2022-04-14 | Brown | Indiana | 18013 | 2586 | 62 |
2405906 | 2405906 | 2022-04-14 | Pulaski | Indiana | 18131 | 3070 | 86 |
2405845 | 2405845 | 2022-04-14 | Blackford | Indiana | 18009 | 3107 | 69 |
2405920 | 2405920 | 2022-04-14 | Tipton | Indiana | 18159 | 3522 | 87 |
2405901 | 2405901 | 2022-04-14 | Parke | Indiana | 18121 | 3589 | 46 |
2405903 | 2405903 | 2022-04-14 | Pike | Indiana | 18125 | 3724 | 49 |
2405924 | 2405924 | 2022-04-14 | Vermillion | Indiana | 18165 | 4073 | 75 |
2405848 | 2405848 | 2022-04-14 | Carroll | Indiana | 18015 | 4222 | 68 |
2405864 | 2405864 | 2022-04-14 | Franklin | Indiana | 18047 | 4373 | 65 |
2405902 | 2405902 | 2022-04-14 | Perry | Indiana | 18123 | 4650 | 69 |
2405915 | 2405915 | 2022-04-14 | Starke | Indiana | 18149 | 4750 | 97 |
2405910 | 2405910 | 2022-04-14 | Rush | Indiana | 18139 | 4835 | 58 |
2405878 | 2405878 | 2022-04-14 | Jay | Indiana | 18075 | 4844 | 78 |
2405865 | 2405865 | 2022-04-14 | Fulton | Indiana | 18049 | 4918 | 102 |
2405899 | 2405899 | 2022-04-14 | Orange | Indiana | 18117 | 5032 | 96 |
2405913 | 2405913 | 2022-04-14 | Spencer | Indiana | 18147 | 5219 | 61 |
2405917 | 2405917 | 2022-04-14 | Sullivan | Indiana | 18153 | 5271 | 76 |
2405863 | 2405863 | 2022-04-14 | Fountain | Indiana | 18045 | 5423 | 102 |
2405900 | 2405900 | 2022-04-14 | Owen | Indiana | 18119 | 5838 | 120 |
2405884 | 2405884 | 2022-04-14 | LaGrange | Indiana | 18087 | 5842 | 102 |
2405908 | 2405908 | 2022-04-14 | Randolph | Indiana | 18135 | 5895 | 148 |
2405929 | 2405929 | 2022-04-14 | Washington | Indiana | 18175 | 5994 | 83 |
2405931 | 2405931 | 2022-04-14 | Wells | Indiana | 18179 | 6498 | 132 |
2405905 | 2405905 | 2022-04-14 | Posey | Indiana | 18129 | 6534 | 58 |
2405861 | 2405861 | 2022-04-14 | Fayette | Indiana | 18041 | 6738 | 146 |
2405851 | 2405851 | 2022-04-14 | Clay | Indiana | 18021 | 6825 | 88 |
2405932 | 2405932 | 2022-04-14 | White | Indiana | 18181 | 6867 | 96 |
2405880 | 2405880 | 2022-04-14 | Jennings | Indiana | 18079 | 6935 | 108 |
2405857 | 2405857 | 2022-04-14 | Decatur | Indiana | 18031 | 6994 | 145 |
2405868 | 2405868 | 2022-04-14 | Greene | Indiana | 18055 | 7199 | 139 |
2405841 | 2405841 | 2022-04-14 | Adams | Indiana | 18001 | 7263 | 112 |
2405854 | 2405854 | 2022-04-14 | Daviess | Indiana | 18027 | 7469 | 153 |
2405911 | 2405911 | 2022-04-14 | Scott | Indiana | 18143 | 7858 | 106 |
2405909 | 2405909 | 2022-04-14 | Ripley | Indiana | 18137 | 8289 | 138 |
2405926 | 2405926 | 2022-04-14 | Wabash | Indiana | 18169 | 8717 | 156 |
2405877 | 2405877 | 2022-04-14 | Jasper | Indiana | 18073 | 9016 | 148 |
2405852 | 2405852 | 2022-04-14 | Clinton | Indiana | 18023 | 9189 | 126 |
2405892 | 2405892 | 2022-04-14 | Miami | Indiana | 18103 | 9255 | 159 |
2405907 | 2405907 | 2022-04-14 | Putnam | Indiana | 18133 | 9317 | 129 |
2405879 | 2405879 | 2022-04-14 | Jefferson | Indiana | 18077 | 9341 | 157 |
2405916 | 2405916 | 2022-04-14 | Steuben | Indiana | 18151 | 9616 | 121 |
2405933 | 2405933 | 2022-04-14 | Whitley | Indiana | 18183 | 9659 | 84 |
2405894 | 2405894 | 2022-04-14 | Montgomery | Indiana | 18107 | 10666 | 164 |
2405882 | 2405882 | 2022-04-14 | Knox | Indiana | 18083 | 10743 | 153 |
2405871 | 2405871 | 2022-04-14 | Harrison | Indiana | 18061 | 10811 | 138 |
2405855 | 2405855 | 2022-04-14 | DeKalb | Indiana | 18033 | 11353 | 149 |
2405875 | 2405875 | 2022-04-14 | Huntington | Indiana | 18069 | 11495 | 156 |
2405866 | 2405866 | 2022-04-14 | Gibson | Indiana | 18051 | 11633 | 145 |
2405849 | 2405849 | 2022-04-14 | Cass | Indiana | 18017 | 11665 | 163 |
2405887 | 2405887 | 2022-04-14 | Lawrence | Indiana | 18093 | 11853 | 259 |
2405890 | 2405890 | 2022-04-14 | Marshall | Indiana | 18099 | 12322 | 196 |
2405876 | 2405876 | 2022-04-14 | Jackson | Indiana | 18071 | 12516 | 130 |
2405859 | 2405859 | 2022-04-14 | Dubois | Indiana | 18037 | 12859 | 165 |
2405873 | 2405873 | 2022-04-14 | Henry | Indiana | 18065 | 12980 | 230 |
2405897 | 2405897 | 2022-04-14 | Noble | Indiana | 18113 | 13069 | 157 |
2405856 | 2405856 | 2022-04-14 | Dearborn | Indiana | 18029 | 13430 | 140 |
2405912 | 2405912 | 2022-04-14 | Shelby | Indiana | 18145 | 13593 | 182 |
2405846 | 2405846 | 2022-04-14 | Boone | Indiana | 18011 | 15226 | 183 |
2405895 | 2405895 | 2022-04-14 | Morgan | Indiana | 18109 | 16451 | 286 |
2405867 | 2405867 | 2022-04-14 | Grant | Indiana | 18053 | 17303 | 349 |
2405930 | 2405930 | 2022-04-14 | Wayne | Indiana | 18177 | 18836 | 334 |
2405862 | 2405862 | 2022-04-14 | Floyd | Indiana | 18043 | 18936 | 299 |
2405883 | 2405883 | 2022-04-14 | Kosciusko | Indiana | 18085 | 19742 | 237 |
2405928 | 2405928 | 2022-04-14 | Warrick | Indiana | 18173 | 20267 | 238 |
2405870 | 2405870 | 2022-04-14 | Hancock | Indiana | 18059 | 20665 | 258 |
2405843 | 2405843 | 2022-04-14 | Bartholomew | Indiana | 18005 | 21321 | 249 |
2405858 | 2405858 | 2022-04-14 | Delaware | Indiana | 18035 | 24833 | 442 |
2405874 | 2405874 | 2022-04-14 | Howard | Indiana | 18067 | 25406 | 448 |
2405885 | 2405885 | 2022-04-14 | LaPorte | Indiana | 18091 | 25460 | 368 |
2405893 | 2405893 | 2022-04-14 | Monroe | Indiana | 18105 | 27733 | 279 |
2405925 | 2405925 | 2022-04-14 | Vigo | Indiana | 18167 | 28840 | 413 |
2405850 | 2405850 | 2022-04-14 | Clark | Indiana | 18019 | 31086 | 396 |
2405888 | 2405888 | 2022-04-14 | Madison | Indiana | 18095 | 32676 | 648 |
2405904 | 2405904 | 2022-04-14 | Porter | Indiana | 18127 | 37686 | 560 |
2405872 | 2405872 | 2022-04-14 | Hendricks | Indiana | 18063 | 40723 | 554 |
2405881 | 2405881 | 2022-04-14 | Johnson | Indiana | 18081 | 42266 | 613 |
2405919 | 2405919 | 2022-04-14 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2405860 | 2405860 | 2022-04-14 | Elkhart | Indiana | 18039 | 54080 | 730 |
2405923 | 2405923 | 2022-04-14 | Vanderburgh | Indiana | 18163 | 57278 | 629 |
2405914 | 2405914 | 2022-04-14 | St. Joseph | Indiana | 18141 | 70681 | 870 |
2405869 | 2405869 | 2022-04-14 | Hamilton | Indiana | 18057 | 81880 | 660 |
2405842 | 2405842 | 2022-04-14 | Allen | Indiana | 18003 | 103808 | 1181 |
2405886 | 2405886 | 2022-04-14 | Lake | Indiana | 18089 | 106291 | 1817 |
2405889 | 2405889 | 2022-04-14 | Marion | Indiana | 18097 | 225013 | 2990 |
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);