ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Payne" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637091 | 637091 | 2020-10-16 | Payne | Oklahoma | 40119 | 2653 | 9 |
633845 | 633845 | 2020-10-15 | Payne | Oklahoma | 40119 | 2618 | 9 |
630600 | 630600 | 2020-10-14 | Payne | Oklahoma | 40119 | 2598 | 8 |
627356 | 627356 | 2020-10-13 | Payne | Oklahoma | 40119 | 2585 | 8 |
624114 | 624114 | 2020-10-12 | Payne | Oklahoma | 40119 | 2566 | 8 |
620871 | 620871 | 2020-10-11 | Payne | Oklahoma | 40119 | 2554 | 8 |
617629 | 617629 | 2020-10-10 | Payne | Oklahoma | 40119 | 2546 | 8 |
614387 | 614387 | 2020-10-09 | Payne | Oklahoma | 40119 | 2519 | 8 |
611146 | 611146 | 2020-10-08 | Payne | Oklahoma | 40119 | 2492 | 7 |
607904 | 607904 | 2020-10-07 | Payne | Oklahoma | 40119 | 2471 | 7 |
604661 | 604661 | 2020-10-06 | Payne | Oklahoma | 40119 | 2460 | 7 |
601419 | 601419 | 2020-10-05 | Payne | Oklahoma | 40119 | 2436 | 7 |
598176 | 598176 | 2020-10-04 | Payne | Oklahoma | 40119 | 2430 | 7 |
594933 | 594933 | 2020-10-03 | Payne | Oklahoma | 40119 | 2416 | 7 |
591692 | 591692 | 2020-10-02 | Payne | Oklahoma | 40119 | 2386 | 7 |
588451 | 588451 | 2020-10-01 | Payne | Oklahoma | 40119 | 2346 | 7 |
585211 | 585211 | 2020-09-30 | Payne | Oklahoma | 40119 | 2309 | 7 |
581971 | 581971 | 2020-09-29 | Payne | Oklahoma | 40119 | 2275 | 7 |
578731 | 578731 | 2020-09-28 | Payne | Oklahoma | 40119 | 2254 | 6 |
575490 | 575490 | 2020-09-27 | Payne | Oklahoma | 40119 | 2231 | 6 |
572246 | 572246 | 2020-09-26 | Payne | Oklahoma | 40119 | 2215 | 6 |
569004 | 569004 | 2020-09-25 | Payne | Oklahoma | 40119 | 2181 | 6 |
565763 | 565763 | 2020-09-24 | Payne | Oklahoma | 40119 | 2149 | 6 |
562522 | 562522 | 2020-09-23 | Payne | Oklahoma | 40119 | 2101 | 6 |
559285 | 559285 | 2020-09-22 | Payne | Oklahoma | 40119 | 2080 | 6 |
556048 | 556048 | 2020-09-21 | Payne | Oklahoma | 40119 | 2065 | 6 |
552811 | 552811 | 2020-09-20 | Payne | Oklahoma | 40119 | 2042 | 6 |
549572 | 549572 | 2020-09-19 | Payne | Oklahoma | 40119 | 2008 | 6 |
546333 | 546333 | 2020-09-18 | Payne | Oklahoma | 40119 | 1966 | 6 |
543096 | 543096 | 2020-09-17 | Payne | Oklahoma | 40119 | 1928 | 5 |
539860 | 539860 | 2020-09-16 | Payne | Oklahoma | 40119 | 1879 | 5 |
536623 | 536623 | 2020-09-15 | Payne | Oklahoma | 40119 | 1855 | 5 |
533387 | 533387 | 2020-09-14 | Payne | Oklahoma | 40119 | 1801 | 5 |
530152 | 530152 | 2020-09-13 | Payne | Oklahoma | 40119 | 1761 | 5 |
526915 | 526915 | 2020-09-12 | Payne | Oklahoma | 40119 | 1738 | 5 |
523679 | 523679 | 2020-09-11 | Payne | Oklahoma | 40119 | 1686 | 5 |
520443 | 520443 | 2020-09-10 | Payne | Oklahoma | 40119 | 1621 | 5 |
517207 | 517207 | 2020-09-09 | Payne | Oklahoma | 40119 | 1595 | 5 |
513972 | 513972 | 2020-09-08 | Payne | Oklahoma | 40119 | 1557 | 5 |
510739 | 510739 | 2020-09-07 | Payne | Oklahoma | 40119 | 1533 | 5 |
507506 | 507506 | 2020-09-06 | Payne | Oklahoma | 40119 | 1494 | 5 |
504274 | 504274 | 2020-09-05 | Payne | Oklahoma | 40119 | 1475 | 5 |
501040 | 501040 | 2020-09-04 | Payne | Oklahoma | 40119 | 1396 | 5 |
497806 | 497806 | 2020-09-03 | Payne | Oklahoma | 40119 | 1319 | 5 |
494573 | 494573 | 2020-09-02 | Payne | Oklahoma | 40119 | 1239 | 5 |
491339 | 491339 | 2020-09-01 | Payne | Oklahoma | 40119 | 1196 | 5 |
488106 | 488106 | 2020-08-31 | Payne | Oklahoma | 40119 | 1180 | 5 |
484873 | 484873 | 2020-08-30 | Payne | Oklahoma | 40119 | 1145 | 5 |
481638 | 481638 | 2020-08-29 | Payne | Oklahoma | 40119 | 1096 | 5 |
478404 | 478404 | 2020-08-28 | Payne | Oklahoma | 40119 | 1047 | 5 |
475171 | 475171 | 2020-08-27 | Payne | Oklahoma | 40119 | 1001 | 5 |
471937 | 471937 | 2020-08-26 | Payne | Oklahoma | 40119 | 961 | 5 |
468705 | 468705 | 2020-08-25 | Payne | Oklahoma | 40119 | 950 | 5 |
465477 | 465477 | 2020-08-24 | Payne | Oklahoma | 40119 | 935 | 4 |
462248 | 462248 | 2020-08-23 | Payne | Oklahoma | 40119 | 914 | 4 |
459020 | 459020 | 2020-08-22 | Payne | Oklahoma | 40119 | 893 | 4 |
455792 | 455792 | 2020-08-21 | Payne | Oklahoma | 40119 | 874 | 4 |
452564 | 452564 | 2020-08-20 | Payne | Oklahoma | 40119 | 847 | 4 |
449336 | 449336 | 2020-08-19 | Payne | Oklahoma | 40119 | 836 | 4 |
446108 | 446108 | 2020-08-18 | Payne | Oklahoma | 40119 | 814 | 4 |
442882 | 442882 | 2020-08-17 | Payne | Oklahoma | 40119 | 800 | 4 |
439655 | 439655 | 2020-08-16 | Payne | Oklahoma | 40119 | 794 | 4 |
436430 | 436430 | 2020-08-15 | Payne | Oklahoma | 40119 | 792 | 4 |
433204 | 433204 | 2020-08-14 | Payne | Oklahoma | 40119 | 788 | 4 |
429978 | 429978 | 2020-08-13 | Payne | Oklahoma | 40119 | 773 | 4 |
426753 | 426753 | 2020-08-12 | Payne | Oklahoma | 40119 | 766 | 4 |
423530 | 423530 | 2020-08-11 | Payne | Oklahoma | 40119 | 754 | 4 |
420307 | 420307 | 2020-08-10 | Payne | Oklahoma | 40119 | 740 | 4 |
417087 | 417087 | 2020-08-09 | Payne | Oklahoma | 40119 | 730 | 4 |
413866 | 413866 | 2020-08-08 | Payne | Oklahoma | 40119 | 721 | 4 |
410646 | 410646 | 2020-08-07 | Payne | Oklahoma | 40119 | 717 | 4 |
407426 | 407426 | 2020-08-06 | Payne | Oklahoma | 40119 | 698 | 4 |
404207 | 404207 | 2020-08-05 | Payne | Oklahoma | 40119 | 687 | 4 |
400989 | 400989 | 2020-08-04 | Payne | Oklahoma | 40119 | 678 | 3 |
397774 | 397774 | 2020-08-03 | Payne | Oklahoma | 40119 | 672 | 3 |
394557 | 394557 | 2020-08-02 | Payne | Oklahoma | 40119 | 663 | 3 |
391341 | 391341 | 2020-08-01 | Payne | Oklahoma | 40119 | 661 | 3 |
388124 | 388124 | 2020-07-31 | Payne | Oklahoma | 40119 | 651 | 3 |
384907 | 384907 | 2020-07-30 | Payne | Oklahoma | 40119 | 638 | 3 |
381689 | 381689 | 2020-07-29 | Payne | Oklahoma | 40119 | 635 | 3 |
378472 | 378472 | 2020-07-28 | Payne | Oklahoma | 40119 | 626 | 3 |
375255 | 375255 | 2020-07-27 | Payne | Oklahoma | 40119 | 622 | 3 |
372043 | 372043 | 2020-07-26 | Payne | Oklahoma | 40119 | 614 | 3 |
368831 | 368831 | 2020-07-25 | Payne | Oklahoma | 40119 | 583 | 3 |
365622 | 365622 | 2020-07-24 | Payne | Oklahoma | 40119 | 575 | 2 |
362416 | 362416 | 2020-07-23 | Payne | Oklahoma | 40119 | 565 | 2 |
359210 | 359210 | 2020-07-22 | Payne | Oklahoma | 40119 | 560 | 2 |
356006 | 356006 | 2020-07-21 | Payne | Oklahoma | 40119 | 551 | 2 |
352803 | 352803 | 2020-07-20 | Payne | Oklahoma | 40119 | 528 | 2 |
349600 | 349600 | 2020-07-19 | Payne | Oklahoma | 40119 | 526 | 2 |
346400 | 346400 | 2020-07-18 | Payne | Oklahoma | 40119 | 526 | 2 |
343200 | 343200 | 2020-07-17 | Payne | Oklahoma | 40119 | 511 | 2 |
340002 | 340002 | 2020-07-16 | Payne | Oklahoma | 40119 | 499 | 2 |
336806 | 336806 | 2020-07-15 | Payne | Oklahoma | 40119 | 493 | 2 |
333612 | 333612 | 2020-07-14 | Payne | Oklahoma | 40119 | 484 | 2 |
330420 | 330420 | 2020-07-13 | Payne | Oklahoma | 40119 | 481 | 2 |
327233 | 327233 | 2020-07-12 | Payne | Oklahoma | 40119 | 480 | 1 |
324048 | 324048 | 2020-07-11 | Payne | Oklahoma | 40119 | 478 | 1 |
320868 | 320868 | 2020-07-10 | Payne | Oklahoma | 40119 | 476 | 1 |
317691 | 317691 | 2020-07-09 | Payne | Oklahoma | 40119 | 465 | 1 |
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);