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-09 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2096830 | 2096830 | 2022-01-09 | Adams | Indiana | 18001 | 6164 | 97 |
2096831 | 2096831 | 2022-01-09 | Allen | Indiana | 18003 | 80867 | 1009 |
2096832 | 2096832 | 2022-01-09 | Bartholomew | Indiana | 18005 | 15460 | 214 |
2096833 | 2096833 | 2022-01-09 | Benton | Indiana | 18007 | 1976 | 21 |
2096834 | 2096834 | 2022-01-09 | Blackford | Indiana | 18009 | 2526 | 56 |
2096835 | 2096835 | 2022-01-09 | Boone | Indiana | 18011 | 11928 | 140 |
2096836 | 2096836 | 2022-01-09 | Brown | Indiana | 18013 | 2069 | 53 |
2096837 | 2096837 | 2022-01-09 | Carroll | Indiana | 18015 | 3402 | 49 |
2096838 | 2096838 | 2022-01-09 | Cass | Indiana | 18017 | 9137 | 143 |
2096839 | 2096839 | 2022-01-09 | Clark | Indiana | 18019 | 23171 | 319 |
2096840 | 2096840 | 2022-01-09 | Clay | Indiana | 18021 | 5399 | 72 |
2096841 | 2096841 | 2022-01-09 | Clinton | Indiana | 18023 | 7330 | 97 |
2096842 | 2096842 | 2022-01-09 | Crawford | Indiana | 18025 | 1927 | 32 |
2096843 | 2096843 | 2022-01-09 | Daviess | Indiana | 18027 | 5698 | 126 |
2096844 | 2096844 | 2022-01-09 | DeKalb | Indiana | 18033 | 9191 | 127 |
2096845 | 2096845 | 2022-01-09 | Dearborn | Indiana | 18029 | 10321 | 117 |
2096846 | 2096846 | 2022-01-09 | Decatur | Indiana | 18031 | 5416 | 121 |
2096847 | 2096847 | 2022-01-09 | Delaware | Indiana | 18035 | 19479 | 363 |
2096848 | 2096848 | 2022-01-09 | Dubois | Indiana | 18037 | 9846 | 153 |
2096849 | 2096849 | 2022-01-09 | Elkhart | Indiana | 18039 | 45106 | 637 |
2096850 | 2096850 | 2022-01-09 | Fayette | Indiana | 18041 | 5464 | 120 |
2096851 | 2096851 | 2022-01-09 | Floyd | Indiana | 18043 | 13952 | 252 |
2096852 | 2096852 | 2022-01-09 | Fountain | Indiana | 18045 | 4353 | 81 |
2096853 | 2096853 | 2022-01-09 | Franklin | Indiana | 18047 | 3492 | 54 |
2096854 | 2096854 | 2022-01-09 | Fulton | Indiana | 18049 | 4048 | 91 |
2096855 | 2096855 | 2022-01-09 | Gibson | Indiana | 18051 | 8179 | 129 |
2096856 | 2096856 | 2022-01-09 | Grant | Indiana | 18053 | 14231 | 291 |
2096857 | 2096857 | 2022-01-09 | Greene | Indiana | 18055 | 5440 | 114 |
2096858 | 2096858 | 2022-01-09 | Hamilton | Indiana | 18057 | 63192 | 551 |
2096859 | 2096859 | 2022-01-09 | Hancock | Indiana | 18059 | 16204 | 209 |
2096860 | 2096860 | 2022-01-09 | Harrison | Indiana | 18061 | 7951 | 114 |
2096861 | 2096861 | 2022-01-09 | Hendricks | Indiana | 18063 | 31375 | 457 |
2096862 | 2096862 | 2022-01-09 | Henry | Indiana | 18065 | 10511 | 192 |
2096863 | 2096863 | 2022-01-09 | Howard | Indiana | 18067 | 19527 | 369 |
2096864 | 2096864 | 2022-01-09 | Huntington | Indiana | 18069 | 9006 | 138 |
2096865 | 2096865 | 2022-01-09 | Jackson | Indiana | 18071 | 9148 | 104 |
2096866 | 2096866 | 2022-01-09 | Jasper | Indiana | 18073 | 7486 | 113 |
2096867 | 2096867 | 2022-01-09 | Jay | Indiana | 18075 | 3791 | 67 |
2096868 | 2096868 | 2022-01-09 | Jefferson | Indiana | 18077 | 7004 | 124 |
2096869 | 2096869 | 2022-01-09 | Jennings | Indiana | 18079 | 5268 | 76 |
2096870 | 2096870 | 2022-01-09 | Johnson | Indiana | 18081 | 33159 | 522 |
2096871 | 2096871 | 2022-01-09 | Knox | Indiana | 18083 | 7972 | 124 |
2096872 | 2096872 | 2022-01-09 | Kosciusko | Indiana | 18085 | 16457 | 197 |
2096873 | 2096873 | 2022-01-09 | LaGrange | Indiana | 18087 | 4786 | 97 |
2096874 | 2096874 | 2022-01-09 | LaPorte | Indiana | 18091 | 21042 | 300 |
2096875 | 2096875 | 2022-01-09 | Lake | Indiana | 18089 | 92404 | 1451 |
2096876 | 2096876 | 2022-01-09 | Lawrence | Indiana | 18093 | 9161 | 213 |
2096877 | 2096877 | 2022-01-09 | Madison | Indiana | 18095 | 25534 | 538 |
2096878 | 2096878 | 2022-01-09 | Marion | Indiana | 18097 | 179388 | 2510 |
2096879 | 2096879 | 2022-01-09 | Marshall | Indiana | 18099 | 10435 | 173 |
2096880 | 2096880 | 2022-01-09 | Martin | Indiana | 18101 | 1687 | 21 |
2096881 | 2096881 | 2022-01-09 | Miami | Indiana | 18103 | 7384 | 131 |
2096882 | 2096882 | 2022-01-09 | Monroe | Indiana | 18105 | 19393 | 240 |
2096883 | 2096883 | 2022-01-09 | Montgomery | Indiana | 18107 | 8250 | 140 |
2096884 | 2096884 | 2022-01-09 | Morgan | Indiana | 18109 | 12457 | 230 |
2096885 | 2096885 | 2022-01-09 | Newton | Indiana | 18111 | 2130 | 60 |
2096886 | 2096886 | 2022-01-09 | Noble | Indiana | 18113 | 10562 | 141 |
2096887 | 2096887 | 2022-01-09 | Ohio | Indiana | 18115 | 1044 | 16 |
2096888 | 2096888 | 2022-01-09 | Orange | Indiana | 18117 | 3817 | 84 |
2096889 | 2096889 | 2022-01-09 | Owen | Indiana | 18119 | 4219 | 90 |
2096890 | 2096890 | 2022-01-09 | Parke | Indiana | 18121 | 2833 | 39 |
2096891 | 2096891 | 2022-01-09 | Perry | Indiana | 18123 | 3374 | 59 |
2096892 | 2096892 | 2022-01-09 | Pike | Indiana | 18125 | 2856 | 46 |
2096893 | 2096893 | 2022-01-09 | Porter | Indiana | 18127 | 31667 | 462 |
2096894 | 2096894 | 2022-01-09 | Posey | Indiana | 18129 | 4712 | 46 |
2096895 | 2096895 | 2022-01-09 | Pulaski | Indiana | 18131 | 2491 | 72 |
2096896 | 2096896 | 2022-01-09 | Putnam | Indiana | 18133 | 7390 | 95 |
2096897 | 2096897 | 2022-01-09 | Randolph | Indiana | 18135 | 4663 | 123 |
2096898 | 2096898 | 2022-01-09 | Ripley | Indiana | 18137 | 6507 | 107 |
2096899 | 2096899 | 2022-01-09 | Rush | Indiana | 18139 | 3718 | 36 |
2096900 | 2096900 | 2022-01-09 | Scott | Indiana | 18143 | 5770 | 88 |
2096901 | 2096901 | 2022-01-09 | Shelby | Indiana | 18145 | 11217 | 159 |
2096902 | 2096902 | 2022-01-09 | Spencer | Indiana | 18147 | 4109 | 58 |
2096903 | 2096903 | 2022-01-09 | St. Joseph | Indiana | 18141 | 58613 | 745 |
2096904 | 2096904 | 2022-01-09 | Starke | Indiana | 18149 | 4142 | 85 |
2096905 | 2096905 | 2022-01-09 | Steuben | Indiana | 18151 | 7773 | 101 |
2096906 | 2096906 | 2022-01-09 | Sullivan | Indiana | 18153 | 3987 | 62 |
2096907 | 2096907 | 2022-01-09 | Switzerland | Indiana | 18155 | 1728 | 14 |
2096908 | 2096908 | 2022-01-09 | Tippecanoe | Indiana | 18157 | 37079 | 321 |
2096909 | 2096909 | 2022-01-09 | Tipton | Indiana | 18159 | 2853 | 75 |
2096910 | 2096910 | 2022-01-09 | Union | Indiana | 18161 | 1505 | 19 |
2096911 | 2096911 | 2022-01-09 | Vanderburgh | Indiana | 18163 | 40423 | 534 |
2096912 | 2096912 | 2022-01-09 | Vermillion | Indiana | 18165 | 3244 | 61 |
2096913 | 2096913 | 2022-01-09 | Vigo | Indiana | 18167 | 22525 | 339 |
2096914 | 2096914 | 2022-01-09 | Wabash | Indiana | 18169 | 7132 | 134 |
2096915 | 2096915 | 2022-01-09 | Warren | Indiana | 18171 | 1585 | 22 |
2096916 | 2096916 | 2022-01-09 | Warrick | Indiana | 18173 | 14268 | 212 |
2096917 | 2096917 | 2022-01-09 | Washington | Indiana | 18175 | 4422 | 63 |
2096918 | 2096918 | 2022-01-09 | Wayne | Indiana | 18177 | 14528 | 298 |
2096919 | 2096919 | 2022-01-09 | Wells | Indiana | 18179 | 5493 | 120 |
2096920 | 2096920 | 2022-01-09 | White | Indiana | 18181 | 5548 | 78 |
2096921 | 2096921 | 2022-01-09 | Whitley | Indiana | 18183 | 7676 | 71 |
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);