ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 18057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 290 ✖
- 661 24
- 426 21
- 445 19
- 0 17
- 116 17
- 118 16
- 423 16
- 107 14
- 442 12
- 119 11
- 447 11
- 102 9
- 112 9
- 416 9
- 450 9
- 100 8
- 101 8
- 115 8
- 110 7
- 113 7
- 435 7
- 504 7
- 660 7
- 96 6
- 99 6
- 122 6
- 421 6
- 429 6
- 436 6
- 454 6
- 471 6
- 502 6
- 534 6
- 646 6
- 654 6
- 656 6
- 105 5
- 121 5
- 330 5
- 338 5
- 418 5
- 420 5
- 424 5
- 444 5
- 446 5
- 510 5
- 516 5
- 519 5
- 639 5
- 653 5
- 659 5
- 4 4
- 163 4
- 422 4
- 425 4
- 432 4
- 434 4
- 451 4
- 459 4
- 486 4
- 507 4
- 525 4
- 539 4
- 584 4
- 36 3
- 88 3
- 95 3
- 97 3
- 114 3
- 117 3
- 318 3
- 414 3
- 428 3
- 466 3
- 472 3
- 477 3
- 492 3
- 498 3
- 551 3
- 571 3
- 593 3
- 606 3
- 620 3
- 631 3
- 650 3
- 652 3
- 5 2
- 28 2
- 53 2
- 82 2
- 84 2
- 106 2
- 123 2
- 140 2
- 141 2
- 145 2
- 170 2
- 177 2
- 180 2
- 196 2
- 223 2
- 295 2
- 306 2
- 307 2
- 337 2
- 378 2
- 384 2
- 389 2
- 391 2
- 394 2
- 417 2
- 431 2
- 437 2
- 449 2
- 453 2
- 464 2
- 469 2
- 470 2
- 474 2
- 491 2
- 496 2
- 521 2
- 538 2
- 600 2
- 612 2
- 648 2
- 657 2
- 658 2
- 10 1
- 15 1
- 16 1
- 19 1
- 23 1
- 24 1
- 25 1
- 30 1
- 32 1
- 40 1
- 42 1
- 43 1
- 46 1
- 52 1
- 60 1
- 62 1
- 64 1
- 70 1
- 71 1
- 72 1
- 75 1
- 77 1
- 80 1
- 86 1
- 91 1
- 98 1
- 103 1
- 108 1
- 109 1
- 120 1
- 124 1
- 126 1
- 128 1
- 129 1
- 131 1
- 133 1
- 134 1
- 135 1
- 150 1
- 157 1
- 159 1
- 161 1
- 164 1
- 165 1
- 167 1
- 173 1
- 174 1
- 179 1
- 181 1
- 182 1
- 185 1
- 192 1
- 193 1
- 195 1
- 197 1
- 202 1
- 211 1
- 216 1
- 217 1
- 221 1
- 228 1
- 240 1
- 243 1
- 244 1
- 247 1
- 248 1
- 249 1
- 260 1
- 265 1
- 272 1
- 275 1
- 277 1
- 278 1
- 281 1
- 284 1
- 286 1
- 288 1
- 297 1
- 301 1
- 304 1
- 305 1
- 309 1
- 312 1
- 317 1
- 319 1
- 320 1
- 323 1
- 329 1
- 331 1
- 335 1
- 377 1
- 380 1
- 381 1
- 383 1
- 386 1
- 388 1
- 392 1
- 405 1
- 406 1
- 410 1
- 411 1
- 412 1
- 415 1
- 419 1
- 427 1
- 430 1
- 443 1
- 456 1
- 457 1
- 461 1
- 468 1
- 475 1
- 476 1
- 478 1
- 479 1
- 482 1
- 487 1
- 490 1
- 494 1
- 495 1
- 500 1
- 501 1
- 503 1
- 505 1
- 508 1
- 509 1
- 511 1
- 513 1
- 517 1
- 518 1
- 523 1
- 526 1
- 532 1
- 541 1
- 546 1
- 547 1
- 548 1
- 555 1
- 556 1
- 561 1
- 569 1
- 572 1
- 573 1
- 580 1
- 583 1
- 589 1
- 590 1
- 591 1
- 594 1
- 602 1
- 611 1
- 615 1
- 622 1
- 623 1
- 626 1
- 629 1
- 633 1
- 635 1
- 640 1
- 642 1
- 647 1
- 651 1
state 1
- Indiana 790
fips 1
- 18057 · 790 ✖
county 1
- Hamilton 790
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500308 | 2500308 | 2022-05-13 | Hamilton | Indiana | 18057 | 83430 | 661 |
2497050 | 2497050 | 2022-05-12 | Hamilton | Indiana | 18057 | 83231 | 661 |
2493792 | 2493792 | 2022-05-11 | Hamilton | Indiana | 18057 | 83231 | 661 |
2490534 | 2490534 | 2022-05-10 | Hamilton | Indiana | 18057 | 83088 | 661 |
2487277 | 2487277 | 2022-05-09 | Hamilton | Indiana | 18057 | 83088 | 661 |
2484019 | 2484019 | 2022-05-08 | Hamilton | Indiana | 18057 | 82726 | 661 |
2480761 | 2480761 | 2022-05-07 | Hamilton | Indiana | 18057 | 82726 | 661 |
2477503 | 2477503 | 2022-05-06 | Hamilton | Indiana | 18057 | 82726 | 661 |
2474245 | 2474245 | 2022-05-05 | Hamilton | Indiana | 18057 | 82726 | 661 |
2470988 | 2470988 | 2022-05-04 | Hamilton | Indiana | 18057 | 82726 | 661 |
2467732 | 2467732 | 2022-05-03 | Hamilton | Indiana | 18057 | 82605 | 661 |
2464477 | 2464477 | 2022-05-02 | Hamilton | Indiana | 18057 | 82605 | 661 |
2461221 | 2461221 | 2022-05-01 | Hamilton | Indiana | 18057 | 82492 | 661 |
2457965 | 2457965 | 2022-04-30 | Hamilton | Indiana | 18057 | 82492 | 661 |
2454709 | 2454709 | 2022-04-29 | Hamilton | Indiana | 18057 | 82492 | 661 |
2451453 | 2451453 | 2022-04-28 | Hamilton | Indiana | 18057 | 82373 | 661 |
2448197 | 2448197 | 2022-04-27 | Hamilton | Indiana | 18057 | 82373 | 661 |
2444941 | 2444941 | 2022-04-26 | Hamilton | Indiana | 18057 | 82271 | 661 |
2441685 | 2441685 | 2022-04-25 | Hamilton | Indiana | 18057 | 82271 | 661 |
2438429 | 2438429 | 2022-04-24 | Hamilton | Indiana | 18057 | 82116 | 661 |
2435173 | 2435173 | 2022-04-23 | Hamilton | Indiana | 18057 | 82116 | 661 |
2431917 | 2431917 | 2022-04-22 | Hamilton | Indiana | 18057 | 82116 | 661 |
2428661 | 2428661 | 2022-04-21 | Hamilton | Indiana | 18057 | 82039 | 661 |
2425405 | 2425405 | 2022-04-20 | Hamilton | Indiana | 18057 | 82039 | 661 |
2422149 | 2422149 | 2022-04-19 | Hamilton | Indiana | 18057 | 81980 | 660 |
2418893 | 2418893 | 2022-04-18 | Hamilton | Indiana | 18057 | 81980 | 660 |
2415637 | 2415637 | 2022-04-17 | Hamilton | Indiana | 18057 | 81880 | 660 |
2412381 | 2412381 | 2022-04-16 | Hamilton | Indiana | 18057 | 81880 | 660 |
2409125 | 2409125 | 2022-04-15 | Hamilton | Indiana | 18057 | 81880 | 660 |
2405869 | 2405869 | 2022-04-14 | Hamilton | Indiana | 18057 | 81880 | 660 |
2402614 | 2402614 | 2022-04-13 | Hamilton | Indiana | 18057 | 81880 | 660 |
2399359 | 2399359 | 2022-04-12 | Hamilton | Indiana | 18057 | 81852 | 659 |
2396104 | 2396104 | 2022-04-11 | Hamilton | Indiana | 18057 | 81852 | 659 |
2392848 | 2392848 | 2022-04-10 | Hamilton | Indiana | 18057 | 81823 | 659 |
2389592 | 2389592 | 2022-04-09 | Hamilton | Indiana | 18057 | 81823 | 659 |
2386337 | 2386337 | 2022-04-08 | Hamilton | Indiana | 18057 | 81823 | 659 |
2383082 | 2383082 | 2022-04-07 | Hamilton | Indiana | 18057 | 81801 | 658 |
2379827 | 2379827 | 2022-04-06 | Hamilton | Indiana | 18057 | 81801 | 658 |
2376573 | 2376573 | 2022-04-05 | Hamilton | Indiana | 18057 | 81784 | 657 |
2373321 | 2373321 | 2022-04-04 | Hamilton | Indiana | 18057 | 81784 | 657 |
2370068 | 2370068 | 2022-04-03 | Hamilton | Indiana | 18057 | 81748 | 656 |
2366815 | 2366815 | 2022-04-02 | Hamilton | Indiana | 18057 | 81748 | 656 |
2363562 | 2363562 | 2022-04-01 | Hamilton | Indiana | 18057 | 81748 | 656 |
2360308 | 2360308 | 2022-03-31 | Hamilton | Indiana | 18057 | 81697 | 656 |
2357054 | 2357054 | 2022-03-30 | Hamilton | Indiana | 18057 | 81697 | 656 |
2353801 | 2353801 | 2022-03-29 | Hamilton | Indiana | 18057 | 81765 | 656 |
2350549 | 2350549 | 2022-03-28 | Hamilton | Indiana | 18057 | 81754 | 654 |
2347296 | 2347296 | 2022-03-27 | Hamilton | Indiana | 18057 | 81728 | 654 |
2344043 | 2344043 | 2022-03-26 | Hamilton | Indiana | 18057 | 81728 | 654 |
2340790 | 2340790 | 2022-03-25 | Hamilton | Indiana | 18057 | 81728 | 654 |
2337537 | 2337537 | 2022-03-24 | Hamilton | Indiana | 18057 | 81715 | 654 |
2334283 | 2334283 | 2022-03-23 | Hamilton | Indiana | 18057 | 81704 | 654 |
2331029 | 2331029 | 2022-03-22 | Hamilton | Indiana | 18057 | 81689 | 653 |
2327777 | 2327777 | 2022-03-21 | Hamilton | Indiana | 18057 | 81670 | 653 |
2324524 | 2324524 | 2022-03-20 | Hamilton | Indiana | 18057 | 81626 | 653 |
2321270 | 2321270 | 2022-03-19 | Hamilton | Indiana | 18057 | 81626 | 653 |
2318016 | 2318016 | 2022-03-18 | Hamilton | Indiana | 18057 | 81626 | 653 |
2314763 | 2314763 | 2022-03-17 | Hamilton | Indiana | 18057 | 81601 | 652 |
2311510 | 2311510 | 2022-03-16 | Hamilton | Indiana | 18057 | 81588 | 652 |
2308257 | 2308257 | 2022-03-15 | Hamilton | Indiana | 18057 | 81573 | 652 |
2305006 | 2305006 | 2022-03-14 | Hamilton | Indiana | 18057 | 81563 | 651 |
2301754 | 2301754 | 2022-03-13 | Hamilton | Indiana | 18057 | 81531 | 650 |
2298502 | 2298502 | 2022-03-12 | Hamilton | Indiana | 18057 | 81531 | 650 |
2295250 | 2295250 | 2022-03-11 | Hamilton | Indiana | 18057 | 81531 | 650 |
2291998 | 2291998 | 2022-03-10 | Hamilton | Indiana | 18057 | 81517 | 648 |
2288746 | 2288746 | 2022-03-09 | Hamilton | Indiana | 18057 | 81498 | 648 |
2285495 | 2285495 | 2022-03-08 | Hamilton | Indiana | 18057 | 81444 | 647 |
2282243 | 2282243 | 2022-03-07 | Hamilton | Indiana | 18057 | 81430 | 646 |
2278990 | 2278990 | 2022-03-06 | Hamilton | Indiana | 18057 | 81329 | 646 |
2275737 | 2275737 | 2022-03-05 | Hamilton | Indiana | 18057 | 81329 | 646 |
2272484 | 2272484 | 2022-03-04 | Hamilton | Indiana | 18057 | 81329 | 646 |
2269232 | 2269232 | 2022-03-03 | Hamilton | Indiana | 18057 | 81315 | 646 |
2265979 | 2265979 | 2022-03-02 | Hamilton | Indiana | 18057 | 81296 | 646 |
2262728 | 2262728 | 2022-03-01 | Hamilton | Indiana | 18057 | 81281 | 642 |
2259477 | 2259477 | 2022-02-28 | Hamilton | Indiana | 18057 | 81256 | 640 |
2256226 | 2256226 | 2022-02-27 | Hamilton | Indiana | 18057 | 81221 | 639 |
2252975 | 2252975 | 2022-02-26 | Hamilton | Indiana | 18057 | 81221 | 639 |
2249724 | 2249724 | 2022-02-25 | Hamilton | Indiana | 18057 | 81221 | 639 |
2246473 | 2246473 | 2022-02-24 | Hamilton | Indiana | 18057 | 81194 | 639 |
2243222 | 2243222 | 2022-02-23 | Hamilton | Indiana | 18057 | 81161 | 639 |
2239971 | 2239971 | 2022-02-22 | Hamilton | Indiana | 18057 | 81115 | 635 |
2236720 | 2236720 | 2022-02-21 | Hamilton | Indiana | 18057 | 81094 | 633 |
2233469 | 2233469 | 2022-02-20 | Hamilton | Indiana | 18057 | 80719 | 631 |
2230218 | 2230218 | 2022-02-19 | Hamilton | Indiana | 18057 | 80719 | 631 |
2226967 | 2226967 | 2022-02-18 | Hamilton | Indiana | 18057 | 80719 | 631 |
2223716 | 2223716 | 2022-02-17 | Hamilton | Indiana | 18057 | 80652 | 629 |
2220465 | 2220465 | 2022-02-16 | Hamilton | Indiana | 18057 | 80577 | 626 |
2217214 | 2217214 | 2022-02-15 | Hamilton | Indiana | 18057 | 80521 | 623 |
2213963 | 2213963 | 2022-02-14 | Hamilton | Indiana | 18057 | 80470 | 622 |
2210711 | 2210711 | 2022-02-13 | Hamilton | Indiana | 18057 | 80297 | 620 |
2207458 | 2207458 | 2022-02-12 | Hamilton | Indiana | 18057 | 80297 | 620 |
2204205 | 2204205 | 2022-02-11 | Hamilton | Indiana | 18057 | 80297 | 620 |
2200952 | 2200952 | 2022-02-10 | Hamilton | Indiana | 18057 | 80145 | 615 |
2197698 | 2197698 | 2022-02-09 | Hamilton | Indiana | 18057 | 79897 | 612 |
2194444 | 2194444 | 2022-02-08 | Hamilton | Indiana | 18057 | 79897 | 612 |
2191190 | 2191190 | 2022-02-07 | Hamilton | Indiana | 18057 | 79781 | 611 |
2187937 | 2187937 | 2022-02-06 | Hamilton | Indiana | 18057 | 79536 | 606 |
2184684 | 2184684 | 2022-02-05 | Hamilton | Indiana | 18057 | 79536 | 606 |
2181432 | 2181432 | 2022-02-04 | Hamilton | Indiana | 18057 | 79536 | 606 |
2178181 | 2178181 | 2022-02-03 | Hamilton | Indiana | 18057 | 79365 | 602 |
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);