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

92 rows where date = "2021-02-22" and state = "Indiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Indiana · 92 ✖
Link rowid date ▲ county state fips cases deaths
1054209 1054209 2021-02-22 Adams Indiana 18001 3200 50
1054210 1054210 2021-02-22 Allen Indiana 18003 35545 655
1054211 1054211 2021-02-22 Bartholomew Indiana 18005 7380 153
1054212 1054212 2021-02-22 Benton Indiana 18007 911 13
1054213 1054213 2021-02-22 Blackford Indiana 18009 1211 27
1054214 1054214 2021-02-22 Boone Indiana 18011 6049 93
1054215 1054215 2021-02-22 Brown Indiana 18013 942 39
1054216 1054216 2021-02-22 Carroll Indiana 18015 1758 20
1054217 1054217 2021-02-22 Cass Indiana 18017 5352 101
1054218 1054218 2021-02-22 Clark Indiana 18019 11847 187
1054219 1054219 2021-02-22 Clay Indiana 18021 2388 44
1054220 1054220 2021-02-22 Clinton Indiana 18023 3925 58
1054221 1054221 2021-02-22 Crawford Indiana 18025 900 14
1054222 1054222 2021-02-22 Daviess Indiana 18027 2844 98
1054223 1054223 2021-02-22 DeKalb Indiana 18033 3819 81
1054224 1054224 2021-02-22 Dearborn Indiana 18029 5402 69
1054225 1054225 2021-02-22 Decatur Indiana 18031 2745 92
1054226 1054226 2021-02-22 Delaware Indiana 18035 9798 183
1054227 1054227 2021-02-22 Dubois Indiana 18037 5863 107
1054228 1054228 2021-02-22 Elkhart Indiana 18039 25352 428
1054229 1054229 2021-02-22 Fayette Indiana 18041 2834 56
1054230 1054230 2021-02-22 Floyd Indiana 18043 7146 168
1054231 1054231 2021-02-22 Fountain Indiana 18045 2004 41
1054232 1054232 2021-02-22 Franklin Indiana 18047 1601 36
1054233 1054233 2021-02-22 Fulton Indiana 18049 1765 38
1054234 1054234 2021-02-22 Gibson Indiana 18051 4002 84
1054235 1054235 2021-02-22 Grant Indiana 18053 6806 163
1054236 1054236 2021-02-22 Greene Indiana 18055 2603 82
1054237 1054237 2021-02-22 Hamilton Indiana 18057 31843 406
1054238 1054238 2021-02-22 Hancock Indiana 18059 7377 131
1054239 1054239 2021-02-22 Harrison Indiana 18061 3954 62
1054240 1054240 2021-02-22 Hendricks Indiana 18063 15759 313
1054241 1054241 2021-02-22 Henry Indiana 18065 5401 93
1054242 1054242 2021-02-22 Howard Indiana 18067 9024 196
1054243 1054243 2021-02-22 Huntington Indiana 18069 3380 77
1054244 1054244 2021-02-22 Jackson Indiana 18071 4620 64
1054245 1054245 2021-02-22 Jasper Indiana 18073 3130 44
1054246 1054246 2021-02-22 Jay Indiana 18075 1782 30
1054247 1054247 2021-02-22 Jefferson Indiana 18077 2928 73
1054248 1054248 2021-02-22 Jennings Indiana 18079 2137 46
1054249 1054249 2021-02-22 Johnson Indiana 18081 16298 365
1054250 1054250 2021-02-22 Knox Indiana 18083 3546 84
1054251 1054251 2021-02-22 Kosciusko Indiana 18085 8524 111
1054252 1054252 2021-02-22 LaGrange Indiana 18087 2407 72
1054253 1054253 2021-02-22 LaPorte Indiana 18091 9726 197
1054254 1054254 2021-02-22 Lake Indiana 18089 48150 899
1054255 1054255 2021-02-22 Lawrence Indiana 18093 4152 114
1054256 1054256 2021-02-22 Madison Indiana 18095 11700 332
1054257 1054257 2021-02-22 Marion Indiana 18097 90249 1691
1054258 1054258 2021-02-22 Marshall Indiana 18099 5387 105
1054259 1054259 2021-02-22 Martin Indiana 18101 800 14
1054260 1054260 2021-02-22 Miami Indiana 18103 3544 62
1054261 1054261 2021-02-22 Monroe Indiana 18105 10245 162
1054262 1054262 2021-02-22 Montgomery Indiana 18107 3806 84
1054263 1054263 2021-02-22 Morgan Indiana 18109 6046 129
1054264 1054264 2021-02-22 Newton Indiana 18111 966 33
1054265 1054265 2021-02-22 Noble Indiana 18113 5064 78
1054266 1054266 2021-02-22 Ohio Indiana 18115 526 11
1054267 1054267 2021-02-22 Orange Indiana 18117 1709 53
1054268 1054268 2021-02-22 Owen Indiana 18119 1819 54
1054269 1054269 2021-02-22 Parke Indiana 18121 1392 15
1054270 1054270 2021-02-22 Perry Indiana 18123 1731 36
1054271 1054271 2021-02-22 Pike Indiana 18125 1271 32
1054272 1054272 2021-02-22 Porter Indiana 18127 15851 279
1054273 1054273 2021-02-22 Posey Indiana 18129 2594 31
1054274 1054274 2021-02-22 Pulaski Indiana 18131 1057 42
1054275 1054275 2021-02-22 Putnam Indiana 18133 3264 60
1054276 1054276 2021-02-22 Randolph Indiana 18135 2292 77
1054277 1054277 2021-02-22 Ripley Indiana 18137 3253 60
1054278 1054278 2021-02-22 Rush Indiana 18139 1699 22
1054279 1054279 2021-02-22 Scott Indiana 18143 2487 48
1054280 1054280 2021-02-22 Shelby Indiana 18145 5496 100
1054281 1054281 2021-02-22 Spencer Indiana 18147 2161 30
1054282 1054282 2021-02-22 St. Joseph Indiana 18141 29522 528
1054283 1054283 2021-02-22 Starke Indiana 18149 1863 53
1054284 1054284 2021-02-22 Steuben Indiana 18151 3359 57
1054285 1054285 2021-02-22 Sullivan Indiana 18153 2022 38
1054286 1054286 2021-02-22 Switzerland Indiana 18155 751 7
1054287 1054287 2021-02-22 Tippecanoe Indiana 18157 19736 200
1054288 1054288 2021-02-22 Tipton Indiana 18159 1459 44
1054289 1054289 2021-02-22 Union Indiana 18161 695 10
1054290 1054290 2021-02-22 Vanderburgh Indiana 18163 21096 381
1054291 1054291 2021-02-22 Vermillion Indiana 18165 1581 40
1054292 1054292 2021-02-22 Vigo Indiana 18167 11504 235
1054293 1054293 2021-02-22 Wabash Indiana 18169 3290 75
1054294 1054294 2021-02-22 Warren Indiana 18171 747 13
1054295 1054295 2021-02-22 Warrick Indiana 18173 7365 147
1054296 1054296 2021-02-22 Washington Indiana 18175 2071 27
1054297 1054297 2021-02-22 Wayne Indiana 18177 6973 191
1054298 1054298 2021-02-22 Wells Indiana 18179 2574 78
1054299 1054299 2021-02-22 White Indiana 18181 2945 51
1054300 1054300 2021-02-22 Whitley Indiana 18183 3455 35

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