ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18157 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 205 ✖
- 14 57
- 2 35
- 394 26
- 12 22
- 1 19
- 227 19
- 213 18
- 396 17
- 233 16
- 240 15
- 9 14
- 3 13
- 214 12
- 275 12
- 392 11
- 5 10
- 237 10
- 221 9
- 231 9
- 258 9
- 0 8
- 11 8
- 13 8
- 209 8
- 219 8
- 222 8
- 10 7
- 235 7
- 384 7
- 24 6
- 232 6
- 257 6
- 274 6
- 301 6
- 4 5
- 8 5
- 15 5
- 16 5
- 17 5
- 23 5
- 28 5
- 212 5
- 230 5
- 234 5
- 251 5
- 266 5
- 309 5
- 335 5
- 18 4
- 217 4
- 245 4
- 255 4
- 260 4
- 264 4
- 270 4
- 271 4
- 280 4
- 295 4
- 343 4
- 352 4
- 356 4
- 363 4
- 370 4
- 375 4
- 380 4
- 31 3
- 66 3
- 193 3
- 207 3
- 210 3
- 215 3
- 239 3
- 262 3
- 272 3
- 285 3
- 321 3
- 362 3
- 391 3
- 26 2
- 30 2
- 34 2
- 38 2
- 39 2
- 51 2
- 52 2
- 70 2
- 71 2
- 113 2
- 122 2
- 151 2
- 197 2
- 200 2
- 201 2
- 203 2
- 205 2
- 220 2
- 224 2
- 226 2
- 228 2
- 229 2
- 253 2
- 278 2
- 288 2
- 313 2
- 324 2
- 341 2
- 353 2
- 376 2
- 7 1
- 19 1
- 20 1
- 25 1
- 36 1
- 37 1
- 42 1
- 43 1
- 48 1
- 53 1
- 54 1
- 65 1
- 69 1
- 72 1
- 73 1
- 81 1
- 84 1
- 88 1
- 91 1
- 93 1
- 94 1
- 98 1
- 101 1
- 102 1
- 106 1
- 110 1
- 111 1
- 115 1
- 116 1
- 117 1
- 119 1
- 123 1
- 126 1
- 129 1
- 131 1
- 134 1
- 139 1
- 141 1
- 142 1
- 145 1
- 147 1
- 149 1
- 150 1
- 152 1
- 154 1
- 157 1
- 175 1
- 176 1
- 177 1
- 179 1
- 184 1
- 185 1
- 187 1
- 188 1
- 189 1
- 191 1
- 195 1
- 196 1
- 204 1
- 208 1
- 216 1
- 225 1
- 241 1
- 244 1
- 246 1
- 249 1
- 250 1
- 254 1
- 256 1
- 261 1
- 265 1
- 277 1
- 282 1
- 283 1
- 284 1
- 292 1
- 298 1
- 300 1
- 305 1
- 310 1
- 316 1
- 331 1
- 334 1
- 345 1
- 349 1
- 354 1
- 358 1
- 364 1
- 366 1
- 369 1
- 372 1
- 374 1
- 377 1
- 379 1
- 381 1
- 388 1
- 389 1
state 1
- Indiana 786
fips 1
- 18157 · 786 ✖
county 1
- Tippecanoe 786
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500358 | 2500358 | 2022-05-13 | Tippecanoe | Indiana | 18157 | 51787 | 396 |
2497100 | 2497100 | 2022-05-12 | Tippecanoe | Indiana | 18157 | 51667 | 396 |
2493842 | 2493842 | 2022-05-11 | Tippecanoe | Indiana | 18157 | 51667 | 396 |
2490584 | 2490584 | 2022-05-10 | Tippecanoe | Indiana | 18157 | 51554 | 396 |
2487327 | 2487327 | 2022-05-09 | Tippecanoe | Indiana | 18157 | 51554 | 396 |
2484069 | 2484069 | 2022-05-08 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2480811 | 2480811 | 2022-05-07 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2477553 | 2477553 | 2022-05-06 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2474295 | 2474295 | 2022-05-05 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2471038 | 2471038 | 2022-05-04 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2467782 | 2467782 | 2022-05-03 | Tippecanoe | Indiana | 18157 | 51087 | 396 |
2464527 | 2464527 | 2022-05-02 | Tippecanoe | Indiana | 18157 | 51087 | 396 |
2461271 | 2461271 | 2022-05-01 | Tippecanoe | Indiana | 18157 | 50955 | 396 |
2458015 | 2458015 | 2022-04-30 | Tippecanoe | Indiana | 18157 | 50955 | 396 |
2454759 | 2454759 | 2022-04-29 | Tippecanoe | Indiana | 18157 | 50955 | 396 |
2451503 | 2451503 | 2022-04-28 | Tippecanoe | Indiana | 18157 | 50819 | 396 |
2448247 | 2448247 | 2022-04-27 | Tippecanoe | Indiana | 18157 | 50819 | 396 |
2444991 | 2444991 | 2022-04-26 | Tippecanoe | Indiana | 18157 | 50678 | 394 |
2441735 | 2441735 | 2022-04-25 | Tippecanoe | Indiana | 18157 | 50678 | 394 |
2438479 | 2438479 | 2022-04-24 | Tippecanoe | Indiana | 18157 | 50427 | 394 |
2435223 | 2435223 | 2022-04-23 | Tippecanoe | Indiana | 18157 | 50427 | 394 |
2431967 | 2431967 | 2022-04-22 | Tippecanoe | Indiana | 18157 | 50427 | 394 |
2428711 | 2428711 | 2022-04-21 | Tippecanoe | Indiana | 18157 | 50317 | 394 |
2425455 | 2425455 | 2022-04-20 | Tippecanoe | Indiana | 18157 | 50317 | 394 |
2422199 | 2422199 | 2022-04-19 | Tippecanoe | Indiana | 18157 | 50245 | 394 |
2418943 | 2418943 | 2022-04-18 | Tippecanoe | Indiana | 18157 | 50245 | 394 |
2415687 | 2415687 | 2022-04-17 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2412431 | 2412431 | 2022-04-16 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2409175 | 2409175 | 2022-04-15 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2405919 | 2405919 | 2022-04-14 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2402664 | 2402664 | 2022-04-13 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2399409 | 2399409 | 2022-04-12 | Tippecanoe | Indiana | 18157 | 50076 | 394 |
2396154 | 2396154 | 2022-04-11 | Tippecanoe | Indiana | 18157 | 50076 | 394 |
2392898 | 2392898 | 2022-04-10 | Tippecanoe | Indiana | 18157 | 50042 | 394 |
2389642 | 2389642 | 2022-04-09 | Tippecanoe | Indiana | 18157 | 50042 | 394 |
2386387 | 2386387 | 2022-04-08 | Tippecanoe | Indiana | 18157 | 50042 | 394 |
2383132 | 2383132 | 2022-04-07 | Tippecanoe | Indiana | 18157 | 50005 | 394 |
2379877 | 2379877 | 2022-04-06 | Tippecanoe | Indiana | 18157 | 50005 | 394 |
2376623 | 2376623 | 2022-04-05 | Tippecanoe | Indiana | 18157 | 49970 | 394 |
2373371 | 2373371 | 2022-04-04 | Tippecanoe | Indiana | 18157 | 49970 | 394 |
2370118 | 2370118 | 2022-04-03 | Tippecanoe | Indiana | 18157 | 49936 | 394 |
2366865 | 2366865 | 2022-04-02 | Tippecanoe | Indiana | 18157 | 49936 | 394 |
2363612 | 2363612 | 2022-04-01 | Tippecanoe | Indiana | 18157 | 49936 | 394 |
2360358 | 2360358 | 2022-03-31 | Tippecanoe | Indiana | 18157 | 49902 | 392 |
2357104 | 2357104 | 2022-03-30 | Tippecanoe | Indiana | 18157 | 49902 | 392 |
2353851 | 2353851 | 2022-03-29 | Tippecanoe | Indiana | 18157 | 49917 | 392 |
2350599 | 2350599 | 2022-03-28 | Tippecanoe | Indiana | 18157 | 49904 | 392 |
2347346 | 2347346 | 2022-03-27 | Tippecanoe | Indiana | 18157 | 49866 | 392 |
2344093 | 2344093 | 2022-03-26 | Tippecanoe | Indiana | 18157 | 49866 | 392 |
2340840 | 2340840 | 2022-03-25 | Tippecanoe | Indiana | 18157 | 49866 | 392 |
2337587 | 2337587 | 2022-03-24 | Tippecanoe | Indiana | 18157 | 49855 | 392 |
2334333 | 2334333 | 2022-03-23 | Tippecanoe | Indiana | 18157 | 49838 | 392 |
2331079 | 2331079 | 2022-03-22 | Tippecanoe | Indiana | 18157 | 49822 | 392 |
2327827 | 2327827 | 2022-03-21 | Tippecanoe | Indiana | 18157 | 49810 | 392 |
2324574 | 2324574 | 2022-03-20 | Tippecanoe | Indiana | 18157 | 49795 | 391 |
2321320 | 2321320 | 2022-03-19 | Tippecanoe | Indiana | 18157 | 49795 | 391 |
2318066 | 2318066 | 2022-03-18 | Tippecanoe | Indiana | 18157 | 49795 | 391 |
2314813 | 2314813 | 2022-03-17 | Tippecanoe | Indiana | 18157 | 49782 | 389 |
2311560 | 2311560 | 2022-03-16 | Tippecanoe | Indiana | 18157 | 49771 | 388 |
2308307 | 2308307 | 2022-03-15 | Tippecanoe | Indiana | 18157 | 49762 | 384 |
2305056 | 2305056 | 2022-03-14 | Tippecanoe | Indiana | 18157 | 49752 | 384 |
2301804 | 2301804 | 2022-03-13 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2298552 | 2298552 | 2022-03-12 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2295300 | 2295300 | 2022-03-11 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2292048 | 2292048 | 2022-03-10 | Tippecanoe | Indiana | 18157 | 49731 | 384 |
2288796 | 2288796 | 2022-03-09 | Tippecanoe | Indiana | 18157 | 49712 | 384 |
2285545 | 2285545 | 2022-03-08 | Tippecanoe | Indiana | 18157 | 49700 | 381 |
2282293 | 2282293 | 2022-03-07 | Tippecanoe | Indiana | 18157 | 49690 | 380 |
2279040 | 2279040 | 2022-03-06 | Tippecanoe | Indiana | 18157 | 49664 | 380 |
2275787 | 2275787 | 2022-03-05 | Tippecanoe | Indiana | 18157 | 49664 | 380 |
2272534 | 2272534 | 2022-03-04 | Tippecanoe | Indiana | 18157 | 49664 | 380 |
2269282 | 2269282 | 2022-03-03 | Tippecanoe | Indiana | 18157 | 49650 | 379 |
2266029 | 2266029 | 2022-03-02 | Tippecanoe | Indiana | 18157 | 49637 | 377 |
2262778 | 2262778 | 2022-03-01 | Tippecanoe | Indiana | 18157 | 49633 | 376 |
2259527 | 2259527 | 2022-02-28 | Tippecanoe | Indiana | 18157 | 49609 | 376 |
2256276 | 2256276 | 2022-02-27 | Tippecanoe | Indiana | 18157 | 49552 | 375 |
2253025 | 2253025 | 2022-02-26 | Tippecanoe | Indiana | 18157 | 49552 | 375 |
2249774 | 2249774 | 2022-02-25 | Tippecanoe | Indiana | 18157 | 49552 | 375 |
2246523 | 2246523 | 2022-02-24 | Tippecanoe | Indiana | 18157 | 49519 | 375 |
2243272 | 2243272 | 2022-02-23 | Tippecanoe | Indiana | 18157 | 49474 | 374 |
2240021 | 2240021 | 2022-02-22 | Tippecanoe | Indiana | 18157 | 49441 | 372 |
2236770 | 2236770 | 2022-02-21 | Tippecanoe | Indiana | 18157 | 49409 | 370 |
2233519 | 2233519 | 2022-02-20 | Tippecanoe | Indiana | 18157 | 49332 | 370 |
2230268 | 2230268 | 2022-02-19 | Tippecanoe | Indiana | 18157 | 49332 | 370 |
2227017 | 2227017 | 2022-02-18 | Tippecanoe | Indiana | 18157 | 49332 | 370 |
2223766 | 2223766 | 2022-02-17 | Tippecanoe | Indiana | 18157 | 49278 | 369 |
2220515 | 2220515 | 2022-02-16 | Tippecanoe | Indiana | 18157 | 49228 | 366 |
2217264 | 2217264 | 2022-02-15 | Tippecanoe | Indiana | 18157 | 49190 | 364 |
2214013 | 2214013 | 2022-02-14 | Tippecanoe | Indiana | 18157 | 49134 | 363 |
2210761 | 2210761 | 2022-02-13 | Tippecanoe | Indiana | 18157 | 48994 | 363 |
2207508 | 2207508 | 2022-02-12 | Tippecanoe | Indiana | 18157 | 48994 | 363 |
2204255 | 2204255 | 2022-02-11 | Tippecanoe | Indiana | 18157 | 48994 | 363 |
2201002 | 2201002 | 2022-02-10 | Tippecanoe | Indiana | 18157 | 48920 | 362 |
2197748 | 2197748 | 2022-02-09 | Tippecanoe | Indiana | 18157 | 48740 | 362 |
2194494 | 2194494 | 2022-02-08 | Tippecanoe | Indiana | 18157 | 48740 | 362 |
2191240 | 2191240 | 2022-02-07 | Tippecanoe | Indiana | 18157 | 48631 | 358 |
2187987 | 2187987 | 2022-02-06 | Tippecanoe | Indiana | 18157 | 48494 | 356 |
2184734 | 2184734 | 2022-02-05 | Tippecanoe | Indiana | 18157 | 48494 | 356 |
2181482 | 2181482 | 2022-02-04 | Tippecanoe | Indiana | 18157 | 48494 | 356 |
2178231 | 2178231 | 2022-02-03 | Tippecanoe | Indiana | 18157 | 48413 | 356 |
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);