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-21 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2135852 | 2135852 | 2022-01-21 | Adams | Indiana | 18001 | 6786 | 104 |
2135853 | 2135853 | 2022-01-21 | Allen | Indiana | 18003 | 94675 | 1055 |
2135854 | 2135854 | 2022-01-21 | Bartholomew | Indiana | 18005 | 18460 | 223 |
2135855 | 2135855 | 2022-01-21 | Benton | Indiana | 18007 | 2215 | 21 |
2135856 | 2135856 | 2022-01-21 | Blackford | Indiana | 18009 | 2774 | 59 |
2135857 | 2135857 | 2022-01-21 | Boone | Indiana | 18011 | 13645 | 146 |
2135858 | 2135858 | 2022-01-21 | Brown | Indiana | 18013 | 2337 | 58 |
2135859 | 2135859 | 2022-01-21 | Carroll | Indiana | 18015 | 3850 | 53 |
2135860 | 2135860 | 2022-01-21 | Cass | Indiana | 18017 | 10391 | 148 |
2135861 | 2135861 | 2022-01-21 | Clark | Indiana | 18019 | 26357 | 345 |
2135862 | 2135862 | 2022-01-21 | Clay | Indiana | 18021 | 6154 | 77 |
2135863 | 2135863 | 2022-01-21 | Clinton | Indiana | 18023 | 8283 | 103 |
2135864 | 2135864 | 2022-01-21 | Crawford | Indiana | 18025 | 2203 | 33 |
2135865 | 2135865 | 2022-01-21 | Daviess | Indiana | 18027 | 6663 | 132 |
2135866 | 2135866 | 2022-01-21 | DeKalb | Indiana | 18033 | 10296 | 135 |
2135867 | 2135867 | 2022-01-21 | Dearborn | Indiana | 18029 | 11839 | 121 |
2135868 | 2135868 | 2022-01-21 | Decatur | Indiana | 18031 | 6127 | 129 |
2135869 | 2135869 | 2022-01-21 | Delaware | Indiana | 18035 | 21903 | 388 |
2135870 | 2135870 | 2022-01-21 | Dubois | Indiana | 18037 | 11421 | 154 |
2135871 | 2135871 | 2022-01-21 | Elkhart | Indiana | 18039 | 50146 | 666 |
2135872 | 2135872 | 2022-01-21 | Fayette | Indiana | 18041 | 6029 | 128 |
2135873 | 2135873 | 2022-01-21 | Floyd | Indiana | 18043 | 16145 | 268 |
2135874 | 2135874 | 2022-01-21 | Fountain | Indiana | 18045 | 4832 | 84 |
2135875 | 2135875 | 2022-01-21 | Franklin | Indiana | 18047 | 3852 | 56 |
2135876 | 2135876 | 2022-01-21 | Fulton | Indiana | 18049 | 4406 | 95 |
2135877 | 2135877 | 2022-01-21 | Gibson | Indiana | 18051 | 9755 | 131 |
2135878 | 2135878 | 2022-01-21 | Grant | Indiana | 18053 | 15976 | 309 |
2135879 | 2135879 | 2022-01-21 | Greene | Indiana | 18055 | 6169 | 117 |
2135880 | 2135880 | 2022-01-21 | Hamilton | Indiana | 18057 | 73699 | 584 |
2135881 | 2135881 | 2022-01-21 | Hancock | Indiana | 18059 | 18888 | 227 |
2135882 | 2135882 | 2022-01-21 | Harrison | Indiana | 18061 | 9164 | 122 |
2135883 | 2135883 | 2022-01-21 | Hendricks | Indiana | 18063 | 36921 | 487 |
2135884 | 2135884 | 2022-01-21 | Henry | Indiana | 18065 | 11789 | 206 |
2135885 | 2135885 | 2022-01-21 | Howard | Indiana | 18067 | 22403 | 391 |
2135886 | 2135886 | 2022-01-21 | Huntington | Indiana | 18069 | 10284 | 144 |
2135887 | 2135887 | 2022-01-21 | Jackson | Indiana | 18071 | 10778 | 107 |
2135888 | 2135888 | 2022-01-21 | Jasper | Indiana | 18073 | 8334 | 122 |
2135889 | 2135889 | 2022-01-21 | Jay | Indiana | 18075 | 4215 | 71 |
2135890 | 2135890 | 2022-01-21 | Jefferson | Indiana | 18077 | 8035 | 132 |
2135891 | 2135891 | 2022-01-21 | Jennings | Indiana | 18079 | 6009 | 88 |
2135892 | 2135892 | 2022-01-21 | Johnson | Indiana | 18081 | 38853 | 553 |
2135893 | 2135893 | 2022-01-21 | Knox | Indiana | 18083 | 9167 | 128 |
2135894 | 2135894 | 2022-01-21 | Kosciusko | Indiana | 18085 | 18144 | 208 |
2135895 | 2135895 | 2022-01-21 | LaGrange | Indiana | 18087 | 5363 | 99 |
2135896 | 2135896 | 2022-01-21 | LaPorte | Indiana | 18091 | 23613 | 317 |
2135897 | 2135897 | 2022-01-21 | Lake | Indiana | 18089 | 101151 | 1582 |
2135898 | 2135898 | 2022-01-21 | Lawrence | Indiana | 18093 | 10312 | 225 |
2135899 | 2135899 | 2022-01-21 | Madison | Indiana | 18095 | 29339 | 575 |
2135900 | 2135900 | 2022-01-21 | Marion | Indiana | 18097 | 208002 | 2648 |
2135901 | 2135901 | 2022-01-21 | Marshall | Indiana | 18099 | 11456 | 181 |
2135902 | 2135902 | 2022-01-21 | Martin | Indiana | 18101 | 1920 | 23 |
2135903 | 2135903 | 2022-01-21 | Miami | Indiana | 18103 | 8258 | 139 |
2135904 | 2135904 | 2022-01-21 | Monroe | Indiana | 18105 | 23484 | 254 |
2135905 | 2135905 | 2022-01-21 | Montgomery | Indiana | 18107 | 9381 | 146 |
2135906 | 2135906 | 2022-01-21 | Morgan | Indiana | 18109 | 14642 | 248 |
2135907 | 2135907 | 2022-01-21 | Newton | Indiana | 18111 | 2356 | 63 |
2135908 | 2135908 | 2022-01-21 | Noble | Indiana | 18113 | 11988 | 146 |
2135909 | 2135909 | 2022-01-21 | Ohio | Indiana | 18115 | 1252 | 16 |
2135910 | 2135910 | 2022-01-21 | Orange | Indiana | 18117 | 4356 | 88 |
2135911 | 2135911 | 2022-01-21 | Owen | Indiana | 18119 | 5072 | 103 |
2135912 | 2135912 | 2022-01-21 | Parke | Indiana | 18121 | 3289 | 40 |
2135913 | 2135913 | 2022-01-21 | Perry | Indiana | 18123 | 3990 | 61 |
2135914 | 2135914 | 2022-01-21 | Pike | Indiana | 18125 | 3279 | 46 |
2135915 | 2135915 | 2022-01-21 | Porter | Indiana | 18127 | 34738 | 495 |
2135916 | 2135916 | 2022-01-21 | Posey | Indiana | 18129 | 5616 | 48 |
2135917 | 2135917 | 2022-01-21 | Pulaski | Indiana | 18131 | 2756 | 76 |
2135918 | 2135918 | 2022-01-21 | Putnam | Indiana | 18133 | 8320 | 104 |
2135919 | 2135919 | 2022-01-21 | Randolph | Indiana | 18135 | 5213 | 131 |
2135920 | 2135920 | 2022-01-21 | Ripley | Indiana | 18137 | 7283 | 119 |
2135921 | 2135921 | 2022-01-21 | Rush | Indiana | 18139 | 4260 | 39 |
2135922 | 2135922 | 2022-01-21 | Scott | Indiana | 18143 | 6644 | 90 |
2135923 | 2135923 | 2022-01-21 | Shelby | Indiana | 18145 | 12965 | 166 |
2135924 | 2135924 | 2022-01-21 | Spencer | Indiana | 18147 | 4578 | 58 |
2135925 | 2135925 | 2022-01-21 | St. Joseph | Indiana | 18141 | 65406 | 786 |
2135926 | 2135926 | 2022-01-21 | Starke | Indiana | 18149 | 4443 | 89 |
2135927 | 2135927 | 2022-01-21 | Steuben | Indiana | 18151 | 8747 | 108 |
2135928 | 2135928 | 2022-01-21 | Sullivan | Indiana | 18153 | 4505 | 68 |
2135929 | 2135929 | 2022-01-21 | Switzerland | Indiana | 18155 | 2015 | 14 |
2135930 | 2135930 | 2022-01-21 | Tippecanoe | Indiana | 18157 | 44423 | 343 |
2135931 | 2135931 | 2022-01-21 | Tipton | Indiana | 18159 | 3213 | 79 |
2135932 | 2135932 | 2022-01-21 | Union | Indiana | 18161 | 1755 | 20 |
2135933 | 2135933 | 2022-01-21 | Vanderburgh | Indiana | 18163 | 48981 | 547 |
2135934 | 2135934 | 2022-01-21 | Vermillion | Indiana | 18165 | 3636 | 62 |
2135935 | 2135935 | 2022-01-21 | Vigo | Indiana | 18167 | 25954 | 352 |
2135936 | 2135936 | 2022-01-21 | Wabash | Indiana | 18169 | 7919 | 140 |
2135937 | 2135937 | 2022-01-21 | Warren | Indiana | 18171 | 1798 | 24 |
2135938 | 2135938 | 2022-01-21 | Warrick | Indiana | 18173 | 17212 | 220 |
2135939 | 2135939 | 2022-01-21 | Washington | Indiana | 18175 | 5115 | 71 |
2135940 | 2135940 | 2022-01-21 | Wayne | Indiana | 18177 | 16851 | 310 |
2135941 | 2135941 | 2022-01-21 | Wells | Indiana | 18179 | 6030 | 125 |
2135942 | 2135942 | 2022-01-21 | White | Indiana | 18181 | 6246 | 86 |
2135943 | 2135943 | 2022-01-21 | Whitley | Indiana | 18183 | 8869 | 73 |
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);