ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2022-03-14" 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 |
---|---|---|---|---|---|---|---|
2304978 | 2304978 | 2022-03-14 | Adams | Indiana | 18001 | 7324 | 112 |
2304979 | 2304979 | 2022-03-14 | Allen | Indiana | 18003 | 103527 | 1167 |
2304980 | 2304980 | 2022-03-14 | Bartholomew | Indiana | 18005 | 21292 | 247 |
2304981 | 2304981 | 2022-03-14 | Benton | Indiana | 18007 | 2470 | 21 |
2304982 | 2304982 | 2022-03-14 | Blackford | Indiana | 18009 | 3120 | 69 |
2304983 | 2304983 | 2022-03-14 | Boone | Indiana | 18011 | 15138 | 176 |
2304984 | 2304984 | 2022-03-14 | Brown | Indiana | 18013 | 2581 | 62 |
2304985 | 2304985 | 2022-03-14 | Carroll | Indiana | 18015 | 4213 | 65 |
2304986 | 2304986 | 2022-03-14 | Cass | Indiana | 18017 | 11634 | 162 |
2304987 | 2304987 | 2022-03-14 | Clark | Indiana | 18019 | 30970 | 389 |
2304988 | 2304988 | 2022-03-14 | Clay | Indiana | 18021 | 6819 | 87 |
2304989 | 2304989 | 2022-03-14 | Clinton | Indiana | 18023 | 9177 | 120 |
2304990 | 2304990 | 2022-03-14 | Crawford | Indiana | 18025 | 2539 | 37 |
2304991 | 2304991 | 2022-03-14 | Daviess | Indiana | 18027 | 7459 | 150 |
2304992 | 2304992 | 2022-03-14 | DeKalb | Indiana | 18033 | 11319 | 148 |
2304993 | 2304993 | 2022-03-14 | Dearborn | Indiana | 18029 | 13413 | 136 |
2304994 | 2304994 | 2022-03-14 | Decatur | Indiana | 18031 | 7052 | 145 |
2304995 | 2304995 | 2022-03-14 | Delaware | Indiana | 18035 | 24731 | 433 |
2304996 | 2304996 | 2022-03-14 | Dubois | Indiana | 18037 | 12835 | 165 |
2304997 | 2304997 | 2022-03-14 | Elkhart | Indiana | 18039 | 54086 | 726 |
2304998 | 2304998 | 2022-03-14 | Fayette | Indiana | 18041 | 6862 | 146 |
2304999 | 2304999 | 2022-03-14 | Floyd | Indiana | 18043 | 18863 | 291 |
2305000 | 2305000 | 2022-03-14 | Fountain | Indiana | 18045 | 5381 | 100 |
2305001 | 2305001 | 2022-03-14 | Franklin | Indiana | 18047 | 4393 | 65 |
2305002 | 2305002 | 2022-03-14 | Fulton | Indiana | 18049 | 4903 | 102 |
2305003 | 2305003 | 2022-03-14 | Gibson | Indiana | 18051 | 11617 | 143 |
2305004 | 2305004 | 2022-03-14 | Grant | Indiana | 18053 | 17654 | 346 |
2305005 | 2305005 | 2022-03-14 | Greene | Indiana | 18055 | 7190 | 138 |
2305006 | 2305006 | 2022-03-14 | Hamilton | Indiana | 18057 | 81563 | 651 |
2305007 | 2305007 | 2022-03-14 | Hancock | Indiana | 18059 | 20625 | 258 |
2305008 | 2305008 | 2022-03-14 | Harrison | Indiana | 18061 | 10777 | 137 |
2305009 | 2305009 | 2022-03-14 | Hendricks | Indiana | 18063 | 40715 | 549 |
2305010 | 2305010 | 2022-03-14 | Henry | Indiana | 18065 | 12948 | 227 |
2305011 | 2305011 | 2022-03-14 | Howard | Indiana | 18067 | 25367 | 438 |
2305012 | 2305012 | 2022-03-14 | Huntington | Indiana | 18069 | 11478 | 153 |
2305013 | 2305013 | 2022-03-14 | Jackson | Indiana | 18071 | 12497 | 126 |
2305014 | 2305014 | 2022-03-14 | Jasper | Indiana | 18073 | 8987 | 146 |
2305015 | 2305015 | 2022-03-14 | Jay | Indiana | 18075 | 4846 | 77 |
2305016 | 2305016 | 2022-03-14 | Jefferson | Indiana | 18077 | 9342 | 154 |
2305017 | 2305017 | 2022-03-14 | Jennings | Indiana | 18079 | 6939 | 106 |
2305018 | 2305018 | 2022-03-14 | Johnson | Indiana | 18081 | 42258 | 604 |
2305019 | 2305019 | 2022-03-14 | Knox | Indiana | 18083 | 10725 | 149 |
2305020 | 2305020 | 2022-03-14 | Kosciusko | Indiana | 18085 | 19714 | 235 |
2305021 | 2305021 | 2022-03-14 | LaGrange | Indiana | 18087 | 5846 | 102 |
2305022 | 2305022 | 2022-03-14 | LaPorte | Indiana | 18091 | 25346 | 361 |
2305023 | 2305023 | 2022-03-14 | Lake | Indiana | 18089 | 105831 | 1803 |
2305024 | 2305024 | 2022-03-14 | Lawrence | Indiana | 18093 | 11816 | 256 |
2305025 | 2305025 | 2022-03-14 | Madison | Indiana | 18095 | 32604 | 645 |
2305026 | 2305026 | 2022-03-14 | Marion | Indiana | 18097 | 224463 | 2940 |
2305027 | 2305027 | 2022-03-14 | Marshall | Indiana | 18099 | 12303 | 193 |
2305028 | 2305028 | 2022-03-14 | Martin | Indiana | 18101 | 2163 | 25 |
2305029 | 2305029 | 2022-03-14 | Miami | Indiana | 18103 | 9239 | 158 |
2305030 | 2305030 | 2022-03-14 | Monroe | Indiana | 18105 | 27512 | 277 |
2305031 | 2305031 | 2022-03-14 | Montgomery | Indiana | 18107 | 10643 | 163 |
2305032 | 2305032 | 2022-03-14 | Morgan | Indiana | 18109 | 16437 | 279 |
2305033 | 2305033 | 2022-03-14 | Newton | Indiana | 18111 | 2557 | 68 |
2305034 | 2305034 | 2022-03-14 | Noble | Indiana | 18113 | 13044 | 156 |
2305035 | 2305035 | 2022-03-14 | Ohio | Indiana | 18115 | 1442 | 19 |
2305036 | 2305036 | 2022-03-14 | Orange | Indiana | 18117 | 5028 | 96 |
2305037 | 2305037 | 2022-03-14 | Owen | Indiana | 18119 | 5815 | 114 |
2305038 | 2305038 | 2022-03-14 | Parke | Indiana | 18121 | 3606 | 49 |
2305039 | 2305039 | 2022-03-14 | Perry | Indiana | 18123 | 4654 | 68 |
2305040 | 2305040 | 2022-03-14 | Pike | Indiana | 18125 | 3720 | 48 |
2305041 | 2305041 | 2022-03-14 | Porter | Indiana | 18127 | 37387 | 554 |
2305042 | 2305042 | 2022-03-14 | Posey | Indiana | 18129 | 6523 | 56 |
2305043 | 2305043 | 2022-03-14 | Pulaski | Indiana | 18131 | 3067 | 85 |
2305044 | 2305044 | 2022-03-14 | Putnam | Indiana | 18133 | 9297 | 125 |
2305045 | 2305045 | 2022-03-14 | Randolph | Indiana | 18135 | 5931 | 144 |
2305046 | 2305046 | 2022-03-14 | Ripley | Indiana | 18137 | 8270 | 137 |
2305047 | 2305047 | 2022-03-14 | Rush | Indiana | 18139 | 4899 | 59 |
2305048 | 2305048 | 2022-03-14 | Scott | Indiana | 18143 | 7854 | 105 |
2305049 | 2305049 | 2022-03-14 | Shelby | Indiana | 18145 | 14656 | 181 |
2305050 | 2305050 | 2022-03-14 | Spencer | Indiana | 18147 | 5213 | 60 |
2305051 | 2305051 | 2022-03-14 | St. Joseph | Indiana | 18141 | 70385 | 859 |
2305052 | 2305052 | 2022-03-14 | Starke | Indiana | 18149 | 4727 | 94 |
2305053 | 2305053 | 2022-03-14 | Steuben | Indiana | 18151 | 9616 | 120 |
2305054 | 2305054 | 2022-03-14 | Sullivan | Indiana | 18153 | 5266 | 76 |
2305055 | 2305055 | 2022-03-14 | Switzerland | Indiana | 18155 | 2307 | 19 |
2305056 | 2305056 | 2022-03-14 | Tippecanoe | Indiana | 18157 | 49752 | 384 |
2305057 | 2305057 | 2022-03-14 | Tipton | Indiana | 18159 | 3521 | 87 |
2305058 | 2305058 | 2022-03-14 | Union | Indiana | 18161 | 2044 | 21 |
2305059 | 2305059 | 2022-03-14 | Vanderburgh | Indiana | 18163 | 57146 | 621 |
2305060 | 2305060 | 2022-03-14 | Vermillion | Indiana | 18165 | 4060 | 74 |
2305061 | 2305061 | 2022-03-14 | Vigo | Indiana | 18167 | 28806 | 406 |
2305062 | 2305062 | 2022-03-14 | Wabash | Indiana | 18169 | 8704 | 152 |
2305063 | 2305063 | 2022-03-14 | Warren | Indiana | 18171 | 2076 | 29 |
2305064 | 2305064 | 2022-03-14 | Warrick | Indiana | 18173 | 20220 | 236 |
2305065 | 2305065 | 2022-03-14 | Washington | Indiana | 18175 | 5982 | 79 |
2305066 | 2305066 | 2022-03-14 | Wayne | Indiana | 18177 | 19178 | 330 |
2305067 | 2305067 | 2022-03-14 | Wells | Indiana | 18179 | 6517 | 132 |
2305068 | 2305068 | 2022-03-14 | White | Indiana | 18181 | 6825 | 92 |
2305069 | 2305069 | 2022-03-14 | Whitley | Indiana | 18183 | 9636 | 83 |
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);