ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

71,921 rows where state = "Indiana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • Indiana · 71,921 ✖
Link rowid date ▲ county state fips cases deaths
2500280 2500280 2022-05-13 Adams Indiana 18001 7288 112
2500281 2500281 2022-05-13 Allen Indiana 18003 104713 1188
2500282 2500282 2022-05-13 Bartholomew Indiana 18005 21574 250
2500283 2500283 2022-05-13 Benton Indiana 18007 2508 21
2500284 2500284 2022-05-13 Blackford Indiana 18009 3118 69
2500285 2500285 2022-05-13 Boone Indiana 18011 15456 186
2500286 2500286 2022-05-13 Brown Indiana 18013 2608 62
2500287 2500287 2022-05-13 Carroll Indiana 18015 4268 68
2500288 2500288 2022-05-13 Cass Indiana 18017 11711 164
2500289 2500289 2022-05-13 Clark Indiana 18019 31580 396
2500290 2500290 2022-05-13 Clay Indiana 18021 6856 88
2500291 2500291 2022-05-13 Clinton Indiana 18023 9259 127
2500292 2500292 2022-05-13 Crawford Indiana 18025 2560 40
2500293 2500293 2022-05-13 Daviess Indiana 18027 7496 154
2500294 2500294 2022-05-13 DeKalb Indiana 18033 11406 152
2500295 2500295 2022-05-13 Dearborn Indiana 18029 13547 140
2500296 2500296 2022-05-13 Decatur Indiana 18031 7019 147
2500297 2500297 2022-05-13 Delaware Indiana 18035 25113 444
2500298 2500298 2022-05-13 Dubois Indiana 18037 12909 165
2500299 2500299 2022-05-13 Elkhart Indiana 18039 54388 734
2500300 2500300 2022-05-13 Fayette Indiana 18041 6751 146
2500301 2500301 2022-05-13 Floyd Indiana 18043 19191 302
2500302 2500302 2022-05-13 Fountain Indiana 18045 5491 103
2500303 2500303 2022-05-13 Franklin Indiana 18047 4390 65
2500304 2500304 2022-05-13 Fulton Indiana 18049 4935 103
2500305 2500305 2022-05-13 Gibson Indiana 18051 11742 145
2500306 2500306 2022-05-13 Grant Indiana 18053 17380 354
2500307 2500307 2022-05-13 Greene Indiana 18055 7262 139
2500308 2500308 2022-05-13 Hamilton Indiana 18057 83430 661
2500309 2500309 2022-05-13 Hancock Indiana 18059 20888 258
2500310 2500310 2022-05-13 Harrison Indiana 18061 10889 138
2500311 2500311 2022-05-13 Hendricks Indiana 18063 41062 554
2500312 2500312 2022-05-13 Henry Indiana 18065 13055 231
2500313 2500313 2022-05-13 Howard Indiana 18067 25568 449
2500314 2500314 2022-05-13 Huntington Indiana 18069 11572 157
2500315 2500315 2022-05-13 Jackson Indiana 18071 12568 130
2500316 2500316 2022-05-13 Jasper Indiana 18073 9159 149
2500317 2500317 2022-05-13 Jay Indiana 18075 4866 78
2500318 2500318 2022-05-13 Jefferson Indiana 18077 9383 159
2500319 2500319 2022-05-13 Jennings Indiana 18079 6995 108
2500320 2500320 2022-05-13 Johnson Indiana 18081 42798 615
2500321 2500321 2022-05-13 Knox Indiana 18083 10800 153
2500322 2500322 2022-05-13 Kosciusko Indiana 18085 19862 237
2500323 2500323 2022-05-13 LaGrange Indiana 18087 5871 102
2500324 2500324 2022-05-13 LaPorte Indiana 18091 25905 367
2500325 2500325 2022-05-13 Lake Indiana 18089 108660 1834
2500326 2500326 2022-05-13 Lawrence Indiana 18093 12021 261
2500327 2500327 2022-05-13 Madison Indiana 18095 32870 653
2500328 2500328 2022-05-13 Marion Indiana 18097 227486 3000
2500329 2500329 2022-05-13 Marshall Indiana 18099 12437 197
2500330 2500330 2022-05-13 Martin Indiana 18101 2173 25
2500331 2500331 2022-05-13 Miami Indiana 18103 9292 159
2500332 2500332 2022-05-13 Monroe Indiana 18105 28850 281
2500333 2500333 2022-05-13 Montgomery Indiana 18107 10737 164
2500334 2500334 2022-05-13 Morgan Indiana 18109 16603 287
2500335 2500335 2022-05-13 Newton Indiana 18111 2591 68
2500336 2500336 2022-05-13 Noble Indiana 18113 13139 157
2500337 2500337 2022-05-13 Ohio Indiana 18115 1458 19
2500338 2500338 2022-05-13 Orange Indiana 18117 5051 96
2500339 2500339 2022-05-13 Owen Indiana 18119 5911 121
2500340 2500340 2022-05-13 Parke Indiana 18121 3608 46
2500341 2500341 2022-05-13 Perry Indiana 18123 4675 69
2500342 2500342 2022-05-13 Pike Indiana 18125 3761 49
2500343 2500343 2022-05-13 Porter Indiana 18127 38632 564
2500344 2500344 2022-05-13 Posey Indiana 18129 6580 58
2500345 2500345 2022-05-13 Pulaski Indiana 18131 3086 86
2500346 2500346 2022-05-13 Putnam Indiana 18133 9427 129
2500347 2500347 2022-05-13 Randolph Indiana 18135 5913 148
2500348 2500348 2022-05-13 Ripley Indiana 18137 8360 138
2500349 2500349 2022-05-13 Rush Indiana 18139 4866 58
2500350 2500350 2022-05-13 Scott Indiana 18143 7943 106
2500351 2500351 2022-05-13 Shelby Indiana 18145 13647 182
2500352 2500352 2022-05-13 Spencer Indiana 18147 5253 61
2500353 2500353 2022-05-13 St. Joseph Indiana 18141 71793 874
2500354 2500354 2022-05-13 Starke Indiana 18149 4785 99
2500355 2500355 2022-05-13 Steuben Indiana 18151 9685 121
2500356 2500356 2022-05-13 Sullivan Indiana 18153 5296 76
2500357 2500357 2022-05-13 Switzerland Indiana 18155 2320 20
2500358 2500358 2022-05-13 Tippecanoe Indiana 18157 51787 396
2500359 2500359 2022-05-13 Tipton Indiana 18159 3544 87
2500360 2500360 2022-05-13 Union Indiana 18161 2027 21
2500361 2500361 2022-05-13 Unknown Indiana   0 20
2500362 2500362 2022-05-13 Vanderburgh Indiana 18163 57824 640
2500363 2500363 2022-05-13 Vermillion Indiana 18165 4130 75
2500364 2500364 2022-05-13 Vigo Indiana 18167 29049 414
2500365 2500365 2022-05-13 Wabash Indiana 18169 8750 157
2500366 2500366 2022-05-13 Warren Indiana 18171 2109 30
2500367 2500367 2022-05-13 Warrick Indiana 18173 20420 239
2500368 2500368 2022-05-13 Washington Indiana 18175 6010 85
2500369 2500369 2022-05-13 Wayne Indiana 18177 18900 337
2500370 2500370 2022-05-13 Wells Indiana 18179 6511 132
2500371 2500371 2022-05-13 White Indiana 18181 6934 97
2500372 2500372 2022-05-13 Whitley Indiana 18183 9740 84
2497022 2497022 2022-05-12 Adams Indiana 18001 7284 112
2497023 2497023 2022-05-12 Allen Indiana 18003 104575 1187
2497024 2497024 2022-05-12 Bartholomew Indiana 18005 21537 249
2497025 2497025 2022-05-12 Benton Indiana 18007 2503 21
2497026 2497026 2022-05-12 Blackford Indiana 18009 3116 69
2497027 2497027 2022-05-12 Boone Indiana 18011 15430 186
2497028 2497028 2022-05-12 Brown Indiana 18013 2607 62

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);