ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2022-02-06" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2187909 | 2187909 | 2022-02-06 | Adams | Indiana | 18001 | 7215 | 106 |
2187910 | 2187910 | 2022-02-06 | Allen | Indiana | 18003 | 101467 | 1091 |
2187911 | 2187911 | 2022-02-06 | Bartholomew | Indiana | 18005 | 20708 | 232 |
2187912 | 2187912 | 2022-02-06 | Benton | Indiana | 18007 | 2405 | 21 |
2187913 | 2187913 | 2022-02-06 | Blackford | Indiana | 18009 | 3032 | 66 |
2187914 | 2187914 | 2022-02-06 | Boone | Indiana | 18011 | 14688 | 156 |
2187915 | 2187915 | 2022-02-06 | Brown | Indiana | 18013 | 2529 | 60 |
2187916 | 2187916 | 2022-02-06 | Carroll | Indiana | 18015 | 4141 | 59 |
2187917 | 2187917 | 2022-02-06 | Cass | Indiana | 18017 | 11199 | 154 |
2187918 | 2187918 | 2022-02-06 | Clark | Indiana | 18019 | 29717 | 361 |
2187919 | 2187919 | 2022-02-06 | Clay | Indiana | 18021 | 6675 | 81 |
2187920 | 2187920 | 2022-02-06 | Clinton | Indiana | 18023 | 8970 | 111 |
2187921 | 2187921 | 2022-02-06 | Crawford | Indiana | 18025 | 2420 | 35 |
2187922 | 2187922 | 2022-02-06 | Daviess | Indiana | 18027 | 7278 | 135 |
2187923 | 2187923 | 2022-02-06 | DeKalb | Indiana | 18033 | 11110 | 143 |
2187924 | 2187924 | 2022-02-06 | Dearborn | Indiana | 18029 | 13058 | 125 |
2187925 | 2187925 | 2022-02-06 | Decatur | Indiana | 18031 | 6859 | 136 |
2187926 | 2187926 | 2022-02-06 | Delaware | Indiana | 18035 | 23848 | 410 |
2187927 | 2187927 | 2022-02-06 | Dubois | Indiana | 18037 | 12514 | 157 |
2187928 | 2187928 | 2022-02-06 | Elkhart | Indiana | 18039 | 53257 | 688 |
2187929 | 2187929 | 2022-02-06 | Fayette | Indiana | 18041 | 6666 | 133 |
2187930 | 2187930 | 2022-02-06 | Floyd | Indiana | 18043 | 18072 | 272 |
2187931 | 2187931 | 2022-02-06 | Fountain | Indiana | 18045 | 5216 | 92 |
2187932 | 2187932 | 2022-02-06 | Franklin | Indiana | 18047 | 4259 | 60 |
2187933 | 2187933 | 2022-02-06 | Fulton | Indiana | 18049 | 4754 | 100 |
2187934 | 2187934 | 2022-02-06 | Gibson | Indiana | 18051 | 11253 | 135 |
2187935 | 2187935 | 2022-02-06 | Grant | Indiana | 18053 | 17278 | 327 |
2187936 | 2187936 | 2022-02-06 | Greene | Indiana | 18055 | 6889 | 126 |
2187937 | 2187937 | 2022-02-06 | Hamilton | Indiana | 18057 | 79536 | 606 |
2187938 | 2187938 | 2022-02-06 | Hancock | Indiana | 18059 | 20258 | 239 |
2187939 | 2187939 | 2022-02-06 | Harrison | Indiana | 18061 | 10357 | 126 |
2187940 | 2187940 | 2022-02-06 | Hendricks | Indiana | 18063 | 39880 | 514 |
2187941 | 2187941 | 2022-02-06 | Henry | Indiana | 18065 | 12623 | 214 |
2187942 | 2187942 | 2022-02-06 | Howard | Indiana | 18067 | 24782 | 411 |
2187943 | 2187943 | 2022-02-06 | Huntington | Indiana | 18069 | 11218 | 146 |
2187944 | 2187944 | 2022-02-06 | Jackson | Indiana | 18071 | 12082 | 112 |
2187945 | 2187945 | 2022-02-06 | Jasper | Indiana | 18073 | 8817 | 135 |
2187946 | 2187946 | 2022-02-06 | Jay | Indiana | 18075 | 4717 | 75 |
2187947 | 2187947 | 2022-02-06 | Jefferson | Indiana | 18077 | 9076 | 138 |
2187948 | 2187948 | 2022-02-06 | Jennings | Indiana | 18079 | 6731 | 96 |
2187949 | 2187949 | 2022-02-06 | Johnson | Indiana | 18081 | 41480 | 576 |
2187950 | 2187950 | 2022-02-06 | Knox | Indiana | 18083 | 10378 | 133 |
2187951 | 2187951 | 2022-02-06 | Kosciusko | Indiana | 18085 | 19280 | 218 |
2187952 | 2187952 | 2022-02-06 | LaGrange | Indiana | 18087 | 5774 | 99 |
2187953 | 2187953 | 2022-02-06 | LaPorte | Indiana | 18091 | 24851 | 332 |
2187954 | 2187954 | 2022-02-06 | Lake | Indiana | 18089 | 104306 | 1696 |
2187955 | 2187955 | 2022-02-06 | Lawrence | Indiana | 18093 | 11452 | 232 |
2187956 | 2187956 | 2022-02-06 | Madison | Indiana | 18095 | 31822 | 604 |
2187957 | 2187957 | 2022-02-06 | Marion | Indiana | 18097 | 220207 | 2788 |
2187958 | 2187958 | 2022-02-06 | Marshall | Indiana | 18099 | 12101 | 187 |
2187959 | 2187959 | 2022-02-06 | Martin | Indiana | 18101 | 2121 | 24 |
2187960 | 2187960 | 2022-02-06 | Miami | Indiana | 18103 | 8989 | 146 |
2187961 | 2187961 | 2022-02-06 | Monroe | Indiana | 18105 | 26418 | 258 |
2187962 | 2187962 | 2022-02-06 | Montgomery | Indiana | 18107 | 10323 | 153 |
2187963 | 2187963 | 2022-02-06 | Morgan | Indiana | 18109 | 16050 | 263 |
2187964 | 2187964 | 2022-02-06 | Newton | Indiana | 18111 | 2500 | 65 |
2187965 | 2187965 | 2022-02-06 | Noble | Indiana | 18113 | 12797 | 149 |
2187966 | 2187966 | 2022-02-06 | Ohio | Indiana | 18115 | 1408 | 17 |
2187967 | 2187967 | 2022-02-06 | Orange | Indiana | 18117 | 4874 | 91 |
2187968 | 2187968 | 2022-02-06 | Owen | Indiana | 18119 | 5623 | 108 |
2187969 | 2187969 | 2022-02-06 | Parke | Indiana | 18121 | 3528 | 43 |
2187970 | 2187970 | 2022-02-06 | Perry | Indiana | 18123 | 4513 | 64 |
2187971 | 2187971 | 2022-02-06 | Pike | Indiana | 18125 | 3616 | 48 |
2187972 | 2187972 | 2022-02-06 | Porter | Indiana | 18127 | 36235 | 522 |
2187973 | 2187973 | 2022-02-06 | Posey | Indiana | 18129 | 6334 | 50 |
2187974 | 2187974 | 2022-02-06 | Pulaski | Indiana | 18131 | 2978 | 81 |
2187975 | 2187975 | 2022-02-06 | Putnam | Indiana | 18133 | 9031 | 110 |
2187976 | 2187976 | 2022-02-06 | Randolph | Indiana | 18135 | 5768 | 139 |
2187977 | 2187977 | 2022-02-06 | Ripley | Indiana | 18137 | 8076 | 126 |
2187978 | 2187978 | 2022-02-06 | Rush | Indiana | 18139 | 4750 | 47 |
2187979 | 2187979 | 2022-02-06 | Scott | Indiana | 18143 | 7564 | 93 |
2187980 | 2187980 | 2022-02-06 | Shelby | Indiana | 18145 | 14321 | 167 |
2187981 | 2187981 | 2022-02-06 | Spencer | Indiana | 18147 | 5051 | 58 |
2187982 | 2187982 | 2022-02-06 | St. Joseph | Indiana | 18141 | 69076 | 813 |
2187983 | 2187983 | 2022-02-06 | Starke | Indiana | 18149 | 4631 | 92 |
2187984 | 2187984 | 2022-02-06 | Steuben | Indiana | 18151 | 9427 | 113 |
2187985 | 2187985 | 2022-02-06 | Sullivan | Indiana | 18153 | 5096 | 70 |
2187986 | 2187986 | 2022-02-06 | Switzerland | Indiana | 18155 | 2237 | 15 |
2187987 | 2187987 | 2022-02-06 | Tippecanoe | Indiana | 18157 | 48494 | 356 |
2187988 | 2187988 | 2022-02-06 | Tipton | Indiana | 18159 | 3451 | 82 |
2187989 | 2187989 | 2022-02-06 | Union | Indiana | 18161 | 1980 | 21 |
2187990 | 2187990 | 2022-02-06 | Vanderburgh | Indiana | 18163 | 55360 | 562 |
2187991 | 2187991 | 2022-02-06 | Vermillion | Indiana | 18165 | 3940 | 68 |
2187992 | 2187992 | 2022-02-06 | Vigo | Indiana | 18167 | 28112 | 370 |
2187993 | 2187993 | 2022-02-06 | Wabash | Indiana | 18169 | 8448 | 144 |
2187994 | 2187994 | 2022-02-06 | Warren | Indiana | 18171 | 2006 | 24 |
2187995 | 2187995 | 2022-02-06 | Warrick | Indiana | 18173 | 19557 | 225 |
2187996 | 2187996 | 2022-02-06 | Washington | Indiana | 18175 | 5764 | 75 |
2187997 | 2187997 | 2022-02-06 | Wayne | Indiana | 18177 | 18665 | 319 |
2187998 | 2187998 | 2022-02-06 | Wells | Indiana | 18179 | 6397 | 127 |
2187999 | 2187999 | 2022-02-06 | White | Indiana | 18181 | 6642 | 88 |
2188000 | 2188000 | 2022-02-06 | Whitley | Indiana | 18183 | 9497 | 77 |
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);