ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,500 rows where county = "Harper" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 328 ✖
- 1 114
- 420 63
- 2 60
- 706 35
- 626 30
- 120 28
- 422 28
- 409 26
- 625 26
- 714 23
- 630 21
- 1651 21
- 1648 18
- 550 14
- 631 14
- 408 12
- 624 12
- 697 12
- 8 10
- 9 10
- 17 10
- 472 10
- 1647 10
- 29 9
- 588 9
- 4 8
- 702 8
- 11 7
- 412 7
- 416 7
- 421 7
- 426 7
- 428 7
- 429 7
- 430 7
- 433 7
- 435 7
- 436 7
- 440 7
- 463 7
- 475 7
- 484 7
- 486 7
- 493 7
- 503 7
- 516 7
- 530 7
- 534 7
- 540 7
- 549 7
- 551 7
- 567 7
- 599 7
- 603 7
- 605 7
- 628 7
- 629 7
- 636 7
- 637 7
- 672 7
- 687 7
- 693 7
- 700 7
- 705 7
- 1649 7
- 1650 7
- 1653 7
- 10 6
- 13 6
- 1591 6
- 26 5
- 42 5
- 117 5
- 391 5
- 402 5
- 404 5
- 643 5
- 1012 5
- 1253 5
- 1292 5
- 1625 5
- 1638 5
- 5 4
- 6 4
- 21 4
- 24 4
- 25 4
- 126 4
- 202 4
- 322 4
- 355 4
- 621 4
- 658 4
- 663 4
- 1449 4
- 16 3
- 19 3
- 31 3
- 72 3
- 95 3
- 110 3
- 112 3
- 121 3
- 133 3
- 149 3
- 165 3
- 191 3
- 275 3
- 313 3
- 345 3
- 349 3
- 350 3
- 358 3
- 363 3
- 386 3
- 387 3
- 403 3
- 407 3
- 434 3
- 526 3
- 562 3
- 573 3
- 583 3
- 601 3
- 608 3
- 619 3
- 652 3
- 662 3
- 668 3
- 686 3
- 721 3
- 756 3
- 786 3
- 849 3
- 886 3
- 895 3
- 915 3
- 926 3
- 932 3
- 943 3
- 969 3
- 1096 3
- 1150 3
- 1211 3
- 1379 3
- 1552 3
- 1610 3
- 1633 3
- 22 2
- 32 2
- 39 2
- 41 2
- 46 2
- 65 2
- 74 2
- 81 2
- 89 2
- 99 2
- 105 2
- 107 2
- 115 2
- 118 2
- 123 2
- 140 2
- 142 2
- 152 2
- 157 2
- 172 2
- 178 2
- 188 2
- 225 2
- 240 2
- 262 2
- 297 2
- 308 2
- 320 2
- 334 2
- 337 2
- 338 2
- 343 2
- 368 2
- 369 2
- 376 2
- 377 2
- 378 2
- 384 2
- 385 2
- 388 2
- 392 2
- 394 2
- 396 2
- 401 2
- 406 2
- 418 2
- 427 2
- 448 2
- 468 2
- 490 2
- 511 2
- 532 2
- 553 2
- 569 2
- 570 2
- 574 2
- 579 2
- 595 2
- 606 2
- 607 2
- 611 2
- 612 2
- 640 2
- 649 2
- 673 2
- 678 2
- 692 2
- 695 2
- 718 2
- 734 2
- 742 2
- 768 2
- 773 2
- 804 2
- 832 2
- 859 2
- 876 2
- 889 2
- 893 2
- 911 2
- 919 2
- 920 2
- 927 2
- 930 2
- 936 2
- 940 2
- 948 2
- 955 2
- 989 2
- 1052 2
- 1077 2
- 1116 2
- 1137 2
- 1170 2
- 1198 2
- 1232 2
- 1283 2
- 1316 2
- 1351 2
- 1399 2
- 1434 2
- 1498 2
- 1561 2
- 1607 2
- 1615 2
- 1629 2
- 1632 2
- 1634 2
- 1640 2
- 1643 2
- 14 1
- 15 1
- 18 1
- 27 1
- 30 1
- 33 1
- 35 1
- 36 1
- 37 1
- 44 1
- 47 1
- 49 1
- 52 1
- 57 1
- 66 1
- 67 1
- 70 1
- 79 1
- 80 1
- 83 1
- 87 1
- 100 1
- 122 1
- 128 1
- 139 1
- 146 1
- 155 1
- 171 1
- 180 1
- 195 1
- 213 1
- 214 1
- 216 1
- 233 1
- 237 1
- 238 1
- 253 1
- 261 1
- 268 1
- 271 1
- 272 1
- 276 1
- 285 1
- 291 1
- 299 1
- 307 1
- 317 1
- 318 1
- 321 1
- 326 1
- 327 1
- 329 1
- 335 1
- 342 1
- 353 1
- 365 1
- 371 1
- 375 1
- 379 1
- 381 1
- 382 1
- 383 1
- 390 1
- 405 1
- 410 1
- 896 1
- 904 1
- 1487 1
- 1572 1
- 1654 1
county 1
- Harper · 1,500 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500511 | 2500511 | 2022-05-13 | Harper | Kansas | 20077 | 1654 | 27 |
2501762 | 2501762 | 2022-05-13 | Harper | Oklahoma | 40059 | 714 | 12 |
2497253 | 2497253 | 2022-05-12 | Harper | Kansas | 20077 | 1653 | 27 |
2498504 | 2498504 | 2022-05-12 | Harper | Oklahoma | 40059 | 714 | 12 |
2493995 | 2493995 | 2022-05-11 | Harper | Kansas | 20077 | 1653 | 27 |
2495246 | 2495246 | 2022-05-11 | Harper | Oklahoma | 40059 | 714 | 12 |
2490737 | 2490737 | 2022-05-10 | Harper | Kansas | 20077 | 1653 | 27 |
2491988 | 2491988 | 2022-05-10 | Harper | Oklahoma | 40059 | 714 | 12 |
2487480 | 2487480 | 2022-05-09 | Harper | Kansas | 20077 | 1653 | 27 |
2488730 | 2488730 | 2022-05-09 | Harper | Oklahoma | 40059 | 714 | 12 |
2484222 | 2484222 | 2022-05-08 | Harper | Kansas | 20077 | 1653 | 27 |
2485473 | 2485473 | 2022-05-08 | Harper | Oklahoma | 40059 | 714 | 12 |
2480964 | 2480964 | 2022-05-07 | Harper | Kansas | 20077 | 1653 | 27 |
2482215 | 2482215 | 2022-05-07 | Harper | Oklahoma | 40059 | 714 | 12 |
2477706 | 2477706 | 2022-05-06 | Harper | Kansas | 20077 | 1653 | 27 |
2478957 | 2478957 | 2022-05-06 | Harper | Oklahoma | 40059 | 714 | 12 |
2474448 | 2474448 | 2022-05-05 | Harper | Kansas | 20077 | 1651 | 27 |
2475699 | 2475699 | 2022-05-05 | Harper | Oklahoma | 40059 | 714 | 12 |
2471191 | 2471191 | 2022-05-04 | Harper | Kansas | 20077 | 1651 | 27 |
2472442 | 2472442 | 2022-05-04 | Harper | Oklahoma | 40059 | 714 | 12 |
2467935 | 2467935 | 2022-05-03 | Harper | Kansas | 20077 | 1651 | 27 |
2469186 | 2469186 | 2022-05-03 | Harper | Oklahoma | 40059 | 714 | 12 |
2464680 | 2464680 | 2022-05-02 | Harper | Kansas | 20077 | 1651 | 27 |
2465930 | 2465930 | 2022-05-02 | Harper | Oklahoma | 40059 | 714 | 12 |
2461424 | 2461424 | 2022-05-01 | Harper | Kansas | 20077 | 1651 | 27 |
2462675 | 2462675 | 2022-05-01 | Harper | Oklahoma | 40059 | 714 | 12 |
2458168 | 2458168 | 2022-04-30 | Harper | Kansas | 20077 | 1651 | 27 |
2459419 | 2459419 | 2022-04-30 | Harper | Oklahoma | 40059 | 714 | 12 |
2454912 | 2454912 | 2022-04-29 | Harper | Kansas | 20077 | 1651 | 27 |
2456163 | 2456163 | 2022-04-29 | Harper | Oklahoma | 40059 | 714 | 12 |
2451656 | 2451656 | 2022-04-28 | Harper | Kansas | 20077 | 1651 | 27 |
2452907 | 2452907 | 2022-04-28 | Harper | Oklahoma | 40059 | 714 | 12 |
2448400 | 2448400 | 2022-04-27 | Harper | Kansas | 20077 | 1651 | 27 |
2449651 | 2449651 | 2022-04-27 | Harper | Oklahoma | 40059 | 714 | 12 |
2445144 | 2445144 | 2022-04-26 | Harper | Kansas | 20077 | 1651 | 27 |
2446394 | 2446394 | 2022-04-26 | Harper | Oklahoma | 40059 | 714 | 12 |
2441888 | 2441888 | 2022-04-25 | Harper | Kansas | 20077 | 1651 | 27 |
2443139 | 2443139 | 2022-04-25 | Harper | Oklahoma | 40059 | 714 | 12 |
2438632 | 2438632 | 2022-04-24 | Harper | Kansas | 20077 | 1651 | 27 |
2439883 | 2439883 | 2022-04-24 | Harper | Oklahoma | 40059 | 714 | 12 |
2435376 | 2435376 | 2022-04-23 | Harper | Kansas | 20077 | 1651 | 27 |
2436627 | 2436627 | 2022-04-23 | Harper | Oklahoma | 40059 | 714 | 12 |
2432120 | 2432120 | 2022-04-22 | Harper | Kansas | 20077 | 1651 | 27 |
2433371 | 2433371 | 2022-04-22 | Harper | Oklahoma | 40059 | 714 | 12 |
2428864 | 2428864 | 2022-04-21 | Harper | Kansas | 20077 | 1651 | 27 |
2430115 | 2430115 | 2022-04-21 | Harper | Oklahoma | 40059 | 714 | 12 |
2425608 | 2425608 | 2022-04-20 | Harper | Kansas | 20077 | 1651 | 27 |
2426859 | 2426859 | 2022-04-20 | Harper | Oklahoma | 40059 | 705 | 12 |
2422352 | 2422352 | 2022-04-19 | Harper | Kansas | 20077 | 1651 | 27 |
2423603 | 2423603 | 2022-04-19 | Harper | Oklahoma | 40059 | 705 | 12 |
2419096 | 2419096 | 2022-04-18 | Harper | Kansas | 20077 | 1651 | 27 |
2420346 | 2420346 | 2022-04-18 | Harper | Oklahoma | 40059 | 705 | 12 |
2415840 | 2415840 | 2022-04-17 | Harper | Kansas | 20077 | 1651 | 27 |
2417091 | 2417091 | 2022-04-17 | Harper | Oklahoma | 40059 | 705 | 12 |
2412584 | 2412584 | 2022-04-16 | Harper | Kansas | 20077 | 1651 | 27 |
2413835 | 2413835 | 2022-04-16 | Harper | Oklahoma | 40059 | 705 | 12 |
2409328 | 2409328 | 2022-04-15 | Harper | Kansas | 20077 | 1651 | 27 |
2410579 | 2410579 | 2022-04-15 | Harper | Oklahoma | 40059 | 705 | 12 |
2406072 | 2406072 | 2022-04-14 | Harper | Kansas | 20077 | 1650 | 27 |
2407323 | 2407323 | 2022-04-14 | Harper | Oklahoma | 40059 | 705 | 12 |
2402816 | 2402816 | 2022-04-13 | Harper | Kansas | 20077 | 1650 | 27 |
2404067 | 2404067 | 2022-04-13 | Harper | Oklahoma | 40059 | 706 | 12 |
2399562 | 2399562 | 2022-04-12 | Harper | Kansas | 20077 | 1650 | 27 |
2400812 | 2400812 | 2022-04-12 | Harper | Oklahoma | 40059 | 706 | 12 |
2396306 | 2396306 | 2022-04-11 | Harper | Kansas | 20077 | 1650 | 27 |
2397557 | 2397557 | 2022-04-11 | Harper | Oklahoma | 40059 | 706 | 12 |
2393051 | 2393051 | 2022-04-10 | Harper | Kansas | 20077 | 1650 | 27 |
2394302 | 2394302 | 2022-04-10 | Harper | Oklahoma | 40059 | 706 | 12 |
2389795 | 2389795 | 2022-04-09 | Harper | Kansas | 20077 | 1650 | 27 |
2391046 | 2391046 | 2022-04-09 | Harper | Oklahoma | 40059 | 706 | 12 |
2386539 | 2386539 | 2022-04-08 | Harper | Kansas | 20077 | 1650 | 27 |
2387790 | 2387790 | 2022-04-08 | Harper | Oklahoma | 40059 | 706 | 12 |
2383285 | 2383285 | 2022-04-07 | Harper | Kansas | 20077 | 1649 | 27 |
2384535 | 2384535 | 2022-04-07 | Harper | Oklahoma | 40059 | 706 | 12 |
2380030 | 2380030 | 2022-04-06 | Harper | Kansas | 20077 | 1649 | 27 |
2381280 | 2381280 | 2022-04-06 | Harper | Oklahoma | 40059 | 706 | 12 |
2376775 | 2376775 | 2022-04-05 | Harper | Kansas | 20077 | 1649 | 27 |
2378025 | 2378025 | 2022-04-05 | Harper | Oklahoma | 40059 | 706 | 12 |
2373523 | 2373523 | 2022-04-04 | Harper | Kansas | 20077 | 1649 | 27 |
2374771 | 2374771 | 2022-04-04 | Harper | Oklahoma | 40059 | 706 | 12 |
2370270 | 2370270 | 2022-04-03 | Harper | Kansas | 20077 | 1649 | 27 |
2371519 | 2371519 | 2022-04-03 | Harper | Oklahoma | 40059 | 706 | 12 |
2367017 | 2367017 | 2022-04-02 | Harper | Kansas | 20077 | 1649 | 27 |
2368266 | 2368266 | 2022-04-02 | Harper | Oklahoma | 40059 | 706 | 12 |
2363764 | 2363764 | 2022-04-01 | Harper | Kansas | 20077 | 1649 | 27 |
2365013 | 2365013 | 2022-04-01 | Harper | Oklahoma | 40059 | 706 | 12 |
2360510 | 2360510 | 2022-03-31 | Harper | Kansas | 20077 | 1648 | 26 |
2361760 | 2361760 | 2022-03-31 | Harper | Oklahoma | 40059 | 706 | 12 |
2357256 | 2357256 | 2022-03-30 | Harper | Kansas | 20077 | 1648 | 26 |
2358506 | 2358506 | 2022-03-30 | Harper | Oklahoma | 40059 | 706 | 12 |
2354003 | 2354003 | 2022-03-29 | Harper | Kansas | 20077 | 1648 | 26 |
2355252 | 2355252 | 2022-03-29 | Harper | Oklahoma | 40059 | 706 | 12 |
2350751 | 2350751 | 2022-03-28 | Harper | Kansas | 20077 | 1648 | 26 |
2351999 | 2351999 | 2022-03-28 | Harper | Oklahoma | 40059 | 706 | 12 |
2347498 | 2347498 | 2022-03-27 | Harper | Kansas | 20077 | 1647 | 26 |
2348747 | 2348747 | 2022-03-27 | Harper | Oklahoma | 40059 | 706 | 12 |
2344245 | 2344245 | 2022-03-26 | Harper | Kansas | 20077 | 1647 | 26 |
2345494 | 2345494 | 2022-03-26 | Harper | Oklahoma | 40059 | 706 | 12 |
2340992 | 2340992 | 2022-03-25 | Harper | Kansas | 20077 | 1647 | 26 |
2342241 | 2342241 | 2022-03-25 | Harper | Oklahoma | 40059 | 706 | 12 |
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);