ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 18053 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 212 ✖
- 33 25
- 29 24
- 181 23
- 188 23
- 187 20
- 0 15
- 32 15
- 3 14
- 190 14
- 346 14
- 40 13
- 42 12
- 186 12
- 35 10
- 347 10
- 350 9
- 27 8
- 164 8
- 169 8
- 177 8
- 184 8
- 26 7
- 34 7
- 49 7
- 161 7
- 171 7
- 173 7
- 174 7
- 179 7
- 233 7
- 345 7
- 351 7
- 352 7
- 22 6
- 36 6
- 53 6
- 113 6
- 228 6
- 282 6
- 30 5
- 37 5
- 43 5
- 128 5
- 183 5
- 193 5
- 196 5
- 200 5
- 212 5
- 239 5
- 241 5
- 278 5
- 327 5
- 343 5
- 349 5
- 14 4
- 23 4
- 47 4
- 189 4
- 203 4
- 222 4
- 224 4
- 230 4
- 237 4
- 321 4
- 333 4
- 337 4
- 338 4
- 8 3
- 19 3
- 20 3
- 25 3
- 28 3
- 46 3
- 48 3
- 64 3
- 66 3
- 97 3
- 106 3
- 115 3
- 158 3
- 159 3
- 165 3
- 166 3
- 219 3
- 225 3
- 253 3
- 262 3
- 270 3
- 291 3
- 302 3
- 309 3
- 339 3
- 342 3
- 4 2
- 5 2
- 12 2
- 15 2
- 17 2
- 18 2
- 24 2
- 31 2
- 41 2
- 44 2
- 45 2
- 50 2
- 55 2
- 60 2
- 84 2
- 88 2
- 105 2
- 108 2
- 114 2
- 120 2
- 121 2
- 124 2
- 155 2
- 162 2
- 167 2
- 170 2
- 172 2
- 175 2
- 180 2
- 182 2
- 191 2
- 195 2
- 201 2
- 217 2
- 223 2
- 226 2
- 232 2
- 234 2
- 238 2
- 268 2
- 287 2
- 298 2
- 306 2
- 320 2
- 329 2
- 344 2
- 348 2
- 353 2
- 1 1
- 6 1
- 9 1
- 10 1
- 11 1
- 16 1
- 21 1
- 39 1
- 52 1
- 56 1
- 57 1
- 61 1
- 65 1
- 68 1
- 78 1
- 86 1
- 91 1
- 92 1
- 94 1
- 96 1
- 98 1
- 100 1
- 102 1
- 111 1
- 117 1
- 118 1
- 123 1
- 125 1
- 160 1
- 163 1
- 176 1
- 178 1
- 185 1
- 198 1
- 199 1
- 207 1
- 211 1
- 214 1
- 218 1
- 220 1
- 227 1
- 229 1
- 240 1
- 243 1
- 248 1
- 249 1
- 250 1
- 255 1
- 257 1
- 258 1
- 259 1
- 266 1
- 269 1
- 273 1
- 274 1
- 279 1
- 281 1
- 289 1
- 295 1
- 299 1
- 303 1
- 308 1
- 311 1
- 318 1
- 323 1
- 325 1
- 330 1
- 334 1
- 335 1
- 341 1
- 354 1
state 1
- Indiana 785
fips 1
- 18053 · 785 ✖
county 1
- Grant 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500306 | 2500306 | 2022-05-13 | Grant | Indiana | 18053 | 17380 | 354 |
2497048 | 2497048 | 2022-05-12 | Grant | Indiana | 18053 | 17369 | 353 |
2493790 | 2493790 | 2022-05-11 | Grant | Indiana | 18053 | 17369 | 353 |
2490532 | 2490532 | 2022-05-10 | Grant | Indiana | 18053 | 17366 | 352 |
2487275 | 2487275 | 2022-05-09 | Grant | Indiana | 18053 | 17366 | 352 |
2484017 | 2484017 | 2022-05-08 | Grant | Indiana | 18053 | 17352 | 352 |
2480759 | 2480759 | 2022-05-07 | Grant | Indiana | 18053 | 17352 | 352 |
2477501 | 2477501 | 2022-05-06 | Grant | Indiana | 18053 | 17352 | 352 |
2474243 | 2474243 | 2022-05-05 | Grant | Indiana | 18053 | 17352 | 352 |
2470986 | 2470986 | 2022-05-04 | Grant | Indiana | 18053 | 17352 | 352 |
2467730 | 2467730 | 2022-05-03 | Grant | Indiana | 18053 | 17348 | 351 |
2464475 | 2464475 | 2022-05-02 | Grant | Indiana | 18053 | 17348 | 351 |
2461219 | 2461219 | 2022-05-01 | Grant | Indiana | 18053 | 17347 | 351 |
2457963 | 2457963 | 2022-04-30 | Grant | Indiana | 18053 | 17347 | 351 |
2454707 | 2454707 | 2022-04-29 | Grant | Indiana | 18053 | 17347 | 351 |
2451451 | 2451451 | 2022-04-28 | Grant | Indiana | 18053 | 17341 | 351 |
2448195 | 2448195 | 2022-04-27 | Grant | Indiana | 18053 | 17341 | 351 |
2444939 | 2444939 | 2022-04-26 | Grant | Indiana | 18053 | 17334 | 350 |
2441683 | 2441683 | 2022-04-25 | Grant | Indiana | 18053 | 17334 | 350 |
2438427 | 2438427 | 2022-04-24 | Grant | Indiana | 18053 | 17320 | 350 |
2435171 | 2435171 | 2022-04-23 | Grant | Indiana | 18053 | 17320 | 350 |
2431915 | 2431915 | 2022-04-22 | Grant | Indiana | 18053 | 17320 | 350 |
2428659 | 2428659 | 2022-04-21 | Grant | Indiana | 18053 | 17317 | 350 |
2425403 | 2425403 | 2022-04-20 | Grant | Indiana | 18053 | 17317 | 350 |
2422147 | 2422147 | 2022-04-19 | Grant | Indiana | 18053 | 17316 | 350 |
2418891 | 2418891 | 2022-04-18 | Grant | Indiana | 18053 | 17316 | 350 |
2415635 | 2415635 | 2022-04-17 | Grant | Indiana | 18053 | 17303 | 349 |
2412379 | 2412379 | 2022-04-16 | Grant | Indiana | 18053 | 17303 | 349 |
2409123 | 2409123 | 2022-04-15 | Grant | Indiana | 18053 | 17303 | 349 |
2405867 | 2405867 | 2022-04-14 | Grant | Indiana | 18053 | 17303 | 349 |
2402612 | 2402612 | 2022-04-13 | Grant | Indiana | 18053 | 17303 | 349 |
2399357 | 2399357 | 2022-04-12 | Grant | Indiana | 18053 | 17300 | 348 |
2396102 | 2396102 | 2022-04-11 | Grant | Indiana | 18053 | 17300 | 348 |
2392846 | 2392846 | 2022-04-10 | Grant | Indiana | 18053 | 17294 | 347 |
2389590 | 2389590 | 2022-04-09 | Grant | Indiana | 18053 | 17294 | 347 |
2386335 | 2386335 | 2022-04-08 | Grant | Indiana | 18053 | 17294 | 347 |
2383080 | 2383080 | 2022-04-07 | Grant | Indiana | 18053 | 17293 | 347 |
2379825 | 2379825 | 2022-04-06 | Grant | Indiana | 18053 | 17293 | 347 |
2376571 | 2376571 | 2022-04-05 | Grant | Indiana | 18053 | 17284 | 347 |
2373319 | 2373319 | 2022-04-04 | Grant | Indiana | 18053 | 17284 | 347 |
2370066 | 2370066 | 2022-04-03 | Grant | Indiana | 18053 | 17280 | 347 |
2366813 | 2366813 | 2022-04-02 | Grant | Indiana | 18053 | 17280 | 347 |
2363560 | 2363560 | 2022-04-01 | Grant | Indiana | 18053 | 17280 | 347 |
2360306 | 2360306 | 2022-03-31 | Grant | Indiana | 18053 | 17271 | 345 |
2357052 | 2357052 | 2022-03-30 | Grant | Indiana | 18053 | 17271 | 345 |
2353799 | 2353799 | 2022-03-29 | Grant | Indiana | 18053 | 17684 | 345 |
2350547 | 2350547 | 2022-03-28 | Grant | Indiana | 18053 | 17683 | 345 |
2347294 | 2347294 | 2022-03-27 | Grant | Indiana | 18053 | 17678 | 346 |
2344041 | 2344041 | 2022-03-26 | Grant | Indiana | 18053 | 17678 | 346 |
2340788 | 2340788 | 2022-03-25 | Grant | Indiana | 18053 | 17678 | 346 |
2337535 | 2337535 | 2022-03-24 | Grant | Indiana | 18053 | 17676 | 346 |
2334281 | 2334281 | 2022-03-23 | Grant | Indiana | 18053 | 17674 | 346 |
2331027 | 2331027 | 2022-03-22 | Grant | Indiana | 18053 | 17676 | 346 |
2327775 | 2327775 | 2022-03-21 | Grant | Indiana | 18053 | 17672 | 346 |
2324522 | 2324522 | 2022-03-20 | Grant | Indiana | 18053 | 17662 | 346 |
2321268 | 2321268 | 2022-03-19 | Grant | Indiana | 18053 | 17662 | 346 |
2318014 | 2318014 | 2022-03-18 | Grant | Indiana | 18053 | 17662 | 346 |
2314761 | 2314761 | 2022-03-17 | Grant | Indiana | 18053 | 17663 | 346 |
2311508 | 2311508 | 2022-03-16 | Grant | Indiana | 18053 | 17660 | 346 |
2308255 | 2308255 | 2022-03-15 | Grant | Indiana | 18053 | 17657 | 346 |
2305004 | 2305004 | 2022-03-14 | Grant | Indiana | 18053 | 17654 | 346 |
2301752 | 2301752 | 2022-03-13 | Grant | Indiana | 18053 | 17649 | 345 |
2298500 | 2298500 | 2022-03-12 | Grant | Indiana | 18053 | 17649 | 345 |
2295248 | 2295248 | 2022-03-11 | Grant | Indiana | 18053 | 17649 | 345 |
2291996 | 2291996 | 2022-03-10 | Grant | Indiana | 18053 | 17649 | 344 |
2288744 | 2288744 | 2022-03-09 | Grant | Indiana | 18053 | 17646 | 344 |
2285493 | 2285493 | 2022-03-08 | Grant | Indiana | 18053 | 17644 | 343 |
2282241 | 2282241 | 2022-03-07 | Grant | Indiana | 18053 | 17640 | 343 |
2278988 | 2278988 | 2022-03-06 | Grant | Indiana | 18053 | 17633 | 343 |
2275735 | 2275735 | 2022-03-05 | Grant | Indiana | 18053 | 17633 | 343 |
2272482 | 2272482 | 2022-03-04 | Grant | Indiana | 18053 | 17633 | 343 |
2269230 | 2269230 | 2022-03-03 | Grant | Indiana | 18053 | 17625 | 342 |
2265977 | 2265977 | 2022-03-02 | Grant | Indiana | 18053 | 17617 | 342 |
2262726 | 2262726 | 2022-03-01 | Grant | Indiana | 18053 | 17614 | 342 |
2259475 | 2259475 | 2022-02-28 | Grant | Indiana | 18053 | 17612 | 341 |
2256224 | 2256224 | 2022-02-27 | Grant | Indiana | 18053 | 17598 | 339 |
2252973 | 2252973 | 2022-02-26 | Grant | Indiana | 18053 | 17598 | 339 |
2249722 | 2249722 | 2022-02-25 | Grant | Indiana | 18053 | 17598 | 339 |
2246471 | 2246471 | 2022-02-24 | Grant | Indiana | 18053 | 17594 | 338 |
2243220 | 2243220 | 2022-02-23 | Grant | Indiana | 18053 | 17584 | 338 |
2239969 | 2239969 | 2022-02-22 | Grant | Indiana | 18053 | 17574 | 338 |
2236718 | 2236718 | 2022-02-21 | Grant | Indiana | 18053 | 17567 | 338 |
2233467 | 2233467 | 2022-02-20 | Grant | Indiana | 18053 | 17553 | 337 |
2230216 | 2230216 | 2022-02-19 | Grant | Indiana | 18053 | 17553 | 337 |
2226965 | 2226965 | 2022-02-18 | Grant | Indiana | 18053 | 17553 | 337 |
2223714 | 2223714 | 2022-02-17 | Grant | Indiana | 18053 | 17539 | 337 |
2220463 | 2220463 | 2022-02-16 | Grant | Indiana | 18053 | 17528 | 335 |
2217212 | 2217212 | 2022-02-15 | Grant | Indiana | 18053 | 17515 | 334 |
2213961 | 2213961 | 2022-02-14 | Grant | Indiana | 18053 | 17496 | 333 |
2210709 | 2210709 | 2022-02-13 | Grant | Indiana | 18053 | 17445 | 333 |
2207456 | 2207456 | 2022-02-12 | Grant | Indiana | 18053 | 17445 | 333 |
2204203 | 2204203 | 2022-02-11 | Grant | Indiana | 18053 | 17445 | 333 |
2200950 | 2200950 | 2022-02-10 | Grant | Indiana | 18053 | 17416 | 330 |
2197696 | 2197696 | 2022-02-09 | Grant | Indiana | 18053 | 17365 | 329 |
2194442 | 2194442 | 2022-02-08 | Grant | Indiana | 18053 | 17365 | 329 |
2191188 | 2191188 | 2022-02-07 | Grant | Indiana | 18053 | 17321 | 327 |
2187935 | 2187935 | 2022-02-06 | Grant | Indiana | 18053 | 17278 | 327 |
2184682 | 2184682 | 2022-02-05 | Grant | Indiana | 18053 | 17278 | 327 |
2181430 | 2181430 | 2022-02-04 | Grant | Indiana | 18053 | 17278 | 327 |
2178179 | 2178179 | 2022-02-03 | Grant | Indiana | 18053 | 17220 | 327 |
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);