ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "McClain" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637078 | 637078 | 2020-10-16 | McClain | Oklahoma | 40087 | 1148 | 9 |
633832 | 633832 | 2020-10-15 | McClain | Oklahoma | 40087 | 1135 | 8 |
630587 | 630587 | 2020-10-14 | McClain | Oklahoma | 40087 | 1131 | 8 |
627343 | 627343 | 2020-10-13 | McClain | Oklahoma | 40087 | 1103 | 8 |
624101 | 624101 | 2020-10-12 | McClain | Oklahoma | 40087 | 1086 | 7 |
620858 | 620858 | 2020-10-11 | McClain | Oklahoma | 40087 | 1073 | 7 |
617616 | 617616 | 2020-10-10 | McClain | Oklahoma | 40087 | 1044 | 7 |
614374 | 614374 | 2020-10-09 | McClain | Oklahoma | 40087 | 1024 | 7 |
611133 | 611133 | 2020-10-08 | McClain | Oklahoma | 40087 | 1003 | 7 |
607891 | 607891 | 2020-10-07 | McClain | Oklahoma | 40087 | 987 | 7 |
604648 | 604648 | 2020-10-06 | McClain | Oklahoma | 40087 | 970 | 7 |
601406 | 601406 | 2020-10-05 | McClain | Oklahoma | 40087 | 962 | 7 |
598163 | 598163 | 2020-10-04 | McClain | Oklahoma | 40087 | 953 | 7 |
594920 | 594920 | 2020-10-03 | McClain | Oklahoma | 40087 | 935 | 7 |
591679 | 591679 | 2020-10-02 | McClain | Oklahoma | 40087 | 924 | 7 |
588438 | 588438 | 2020-10-01 | McClain | Oklahoma | 40087 | 918 | 7 |
585198 | 585198 | 2020-09-30 | McClain | Oklahoma | 40087 | 904 | 7 |
581958 | 581958 | 2020-09-29 | McClain | Oklahoma | 40087 | 884 | 7 |
578718 | 578718 | 2020-09-28 | McClain | Oklahoma | 40087 | 874 | 7 |
575477 | 575477 | 2020-09-27 | McClain | Oklahoma | 40087 | 861 | 7 |
572233 | 572233 | 2020-09-26 | McClain | Oklahoma | 40087 | 854 | 7 |
568991 | 568991 | 2020-09-25 | McClain | Oklahoma | 40087 | 846 | 7 |
565750 | 565750 | 2020-09-24 | McClain | Oklahoma | 40087 | 830 | 7 |
562509 | 562509 | 2020-09-23 | McClain | Oklahoma | 40087 | 809 | 7 |
559272 | 559272 | 2020-09-22 | McClain | Oklahoma | 40087 | 799 | 7 |
556035 | 556035 | 2020-09-21 | McClain | Oklahoma | 40087 | 779 | 6 |
552798 | 552798 | 2020-09-20 | McClain | Oklahoma | 40087 | 778 | 6 |
549559 | 549559 | 2020-09-19 | McClain | Oklahoma | 40087 | 776 | 6 |
546320 | 546320 | 2020-09-18 | McClain | Oklahoma | 40087 | 755 | 6 |
543083 | 543083 | 2020-09-17 | McClain | Oklahoma | 40087 | 732 | 6 |
539847 | 539847 | 2020-09-16 | McClain | Oklahoma | 40087 | 727 | 6 |
536610 | 536610 | 2020-09-15 | McClain | Oklahoma | 40087 | 711 | 6 |
533374 | 533374 | 2020-09-14 | McClain | Oklahoma | 40087 | 698 | 6 |
530139 | 530139 | 2020-09-13 | McClain | Oklahoma | 40087 | 696 | 6 |
526902 | 526902 | 2020-09-12 | McClain | Oklahoma | 40087 | 688 | 5 |
523666 | 523666 | 2020-09-11 | McClain | Oklahoma | 40087 | 672 | 5 |
520430 | 520430 | 2020-09-10 | McClain | Oklahoma | 40087 | 659 | 4 |
517194 | 517194 | 2020-09-09 | McClain | Oklahoma | 40087 | 647 | 4 |
513959 | 513959 | 2020-09-08 | McClain | Oklahoma | 40087 | 639 | 4 |
510726 | 510726 | 2020-09-07 | McClain | Oklahoma | 40087 | 627 | 4 |
507493 | 507493 | 2020-09-06 | McClain | Oklahoma | 40087 | 622 | 4 |
504261 | 504261 | 2020-09-05 | McClain | Oklahoma | 40087 | 613 | 4 |
501027 | 501027 | 2020-09-04 | McClain | Oklahoma | 40087 | 602 | 4 |
497793 | 497793 | 2020-09-03 | McClain | Oklahoma | 40087 | 599 | 4 |
494560 | 494560 | 2020-09-02 | McClain | Oklahoma | 40087 | 588 | 4 |
491326 | 491326 | 2020-09-01 | McClain | Oklahoma | 40087 | 580 | 4 |
488093 | 488093 | 2020-08-31 | McClain | Oklahoma | 40087 | 574 | 4 |
484860 | 484860 | 2020-08-30 | McClain | Oklahoma | 40087 | 570 | 4 |
481625 | 481625 | 2020-08-29 | McClain | Oklahoma | 40087 | 561 | 4 |
478391 | 478391 | 2020-08-28 | McClain | Oklahoma | 40087 | 551 | 4 |
475158 | 475158 | 2020-08-27 | McClain | Oklahoma | 40087 | 548 | 4 |
471924 | 471924 | 2020-08-26 | McClain | Oklahoma | 40087 | 544 | 4 |
468692 | 468692 | 2020-08-25 | McClain | Oklahoma | 40087 | 540 | 4 |
465464 | 465464 | 2020-08-24 | McClain | Oklahoma | 40087 | 536 | 4 |
462235 | 462235 | 2020-08-23 | McClain | Oklahoma | 40087 | 534 | 4 |
459007 | 459007 | 2020-08-22 | McClain | Oklahoma | 40087 | 522 | 4 |
455779 | 455779 | 2020-08-21 | McClain | Oklahoma | 40087 | 519 | 4 |
452551 | 452551 | 2020-08-20 | McClain | Oklahoma | 40087 | 506 | 4 |
449323 | 449323 | 2020-08-19 | McClain | Oklahoma | 40087 | 503 | 4 |
446095 | 446095 | 2020-08-18 | McClain | Oklahoma | 40087 | 494 | 4 |
442869 | 442869 | 2020-08-17 | McClain | Oklahoma | 40087 | 483 | 4 |
439642 | 439642 | 2020-08-16 | McClain | Oklahoma | 40087 | 480 | 4 |
436417 | 436417 | 2020-08-15 | McClain | Oklahoma | 40087 | 479 | 4 |
433191 | 433191 | 2020-08-14 | McClain | Oklahoma | 40087 | 473 | 4 |
429965 | 429965 | 2020-08-13 | McClain | Oklahoma | 40087 | 464 | 4 |
426740 | 426740 | 2020-08-12 | McClain | Oklahoma | 40087 | 457 | 4 |
423517 | 423517 | 2020-08-11 | McClain | Oklahoma | 40087 | 454 | 4 |
420294 | 420294 | 2020-08-10 | McClain | Oklahoma | 40087 | 445 | 4 |
417074 | 417074 | 2020-08-09 | McClain | Oklahoma | 40087 | 440 | 4 |
413853 | 413853 | 2020-08-08 | McClain | Oklahoma | 40087 | 430 | 4 |
410633 | 410633 | 2020-08-07 | McClain | Oklahoma | 40087 | 427 | 4 |
407413 | 407413 | 2020-08-06 | McClain | Oklahoma | 40087 | 424 | 4 |
404194 | 404194 | 2020-08-05 | McClain | Oklahoma | 40087 | 420 | 4 |
400976 | 400976 | 2020-08-04 | McClain | Oklahoma | 40087 | 402 | 4 |
397761 | 397761 | 2020-08-03 | McClain | Oklahoma | 40087 | 397 | 4 |
394544 | 394544 | 2020-08-02 | McClain | Oklahoma | 40087 | 396 | 4 |
391328 | 391328 | 2020-08-01 | McClain | Oklahoma | 40087 | 389 | 4 |
388111 | 388111 | 2020-07-31 | McClain | Oklahoma | 40087 | 383 | 4 |
384894 | 384894 | 2020-07-30 | McClain | Oklahoma | 40087 | 379 | 4 |
381676 | 381676 | 2020-07-29 | McClain | Oklahoma | 40087 | 367 | 4 |
378459 | 378459 | 2020-07-28 | McClain | Oklahoma | 40087 | 356 | 4 |
375242 | 375242 | 2020-07-27 | McClain | Oklahoma | 40087 | 349 | 4 |
372030 | 372030 | 2020-07-26 | McClain | Oklahoma | 40087 | 342 | 4 |
368818 | 368818 | 2020-07-25 | McClain | Oklahoma | 40087 | 336 | 4 |
365609 | 365609 | 2020-07-24 | McClain | Oklahoma | 40087 | 332 | 4 |
362403 | 362403 | 2020-07-23 | McClain | Oklahoma | 40087 | 322 | 4 |
359197 | 359197 | 2020-07-22 | McClain | Oklahoma | 40087 | 315 | 4 |
355993 | 355993 | 2020-07-21 | McClain | Oklahoma | 40087 | 302 | 4 |
352790 | 352790 | 2020-07-20 | McClain | Oklahoma | 40087 | 289 | 4 |
349587 | 349587 | 2020-07-19 | McClain | Oklahoma | 40087 | 288 | 4 |
346387 | 346387 | 2020-07-18 | McClain | Oklahoma | 40087 | 286 | 4 |
343187 | 343187 | 2020-07-17 | McClain | Oklahoma | 40087 | 285 | 4 |
339989 | 339989 | 2020-07-16 | McClain | Oklahoma | 40087 | 277 | 4 |
336793 | 336793 | 2020-07-15 | McClain | Oklahoma | 40087 | 271 | 4 |
333599 | 333599 | 2020-07-14 | McClain | Oklahoma | 40087 | 261 | 4 |
330407 | 330407 | 2020-07-13 | McClain | Oklahoma | 40087 | 241 | 4 |
327220 | 327220 | 2020-07-12 | McClain | Oklahoma | 40087 | 238 | 4 |
324035 | 324035 | 2020-07-11 | McClain | Oklahoma | 40087 | 235 | 4 |
320855 | 320855 | 2020-07-10 | McClain | Oklahoma | 40087 | 230 | 4 |
317678 | 317678 | 2020-07-09 | McClain | Oklahoma | 40087 | 229 | 4 |
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);