ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Oklahoma" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637086 | 637086 | 2020-10-16 | Oklahoma | Oklahoma | 40109 | 21506 | 216 |
633840 | 633840 | 2020-10-15 | Oklahoma | Oklahoma | 40109 | 21260 | 212 |
630595 | 630595 | 2020-10-14 | Oklahoma | Oklahoma | 40109 | 21043 | 208 |
627351 | 627351 | 2020-10-13 | Oklahoma | Oklahoma | 40109 | 20822 | 202 |
624109 | 624109 | 2020-10-12 | Oklahoma | Oklahoma | 40109 | 20620 | 202 |
620866 | 620866 | 2020-10-11 | Oklahoma | Oklahoma | 40109 | 20431 | 201 |
617624 | 617624 | 2020-10-10 | Oklahoma | Oklahoma | 40109 | 20207 | 201 |
614382 | 614382 | 2020-10-09 | Oklahoma | Oklahoma | 40109 | 19985 | 200 |
611141 | 611141 | 2020-10-08 | Oklahoma | Oklahoma | 40109 | 19736 | 200 |
607899 | 607899 | 2020-10-07 | Oklahoma | Oklahoma | 40109 | 19537 | 200 |
604656 | 604656 | 2020-10-06 | Oklahoma | Oklahoma | 40109 | 19307 | 197 |
601414 | 601414 | 2020-10-05 | Oklahoma | Oklahoma | 40109 | 19140 | 197 |
598171 | 598171 | 2020-10-04 | Oklahoma | Oklahoma | 40109 | 19008 | 197 |
594928 | 594928 | 2020-10-03 | Oklahoma | Oklahoma | 40109 | 18870 | 197 |
591687 | 591687 | 2020-10-02 | Oklahoma | Oklahoma | 40109 | 18709 | 197 |
588446 | 588446 | 2020-10-01 | Oklahoma | Oklahoma | 40109 | 18580 | 196 |
585206 | 585206 | 2020-09-30 | Oklahoma | Oklahoma | 40109 | 18344 | 195 |
581966 | 581966 | 2020-09-29 | Oklahoma | Oklahoma | 40109 | 18175 | 195 |
578726 | 578726 | 2020-09-28 | Oklahoma | Oklahoma | 40109 | 18018 | 194 |
575485 | 575485 | 2020-09-27 | Oklahoma | Oklahoma | 40109 | 17869 | 194 |
572241 | 572241 | 2020-09-26 | Oklahoma | Oklahoma | 40109 | 17711 | 194 |
568999 | 568999 | 2020-09-25 | Oklahoma | Oklahoma | 40109 | 17556 | 190 |
565758 | 565758 | 2020-09-24 | Oklahoma | Oklahoma | 40109 | 17319 | 188 |
562517 | 562517 | 2020-09-23 | Oklahoma | Oklahoma | 40109 | 17135 | 186 |
559280 | 559280 | 2020-09-22 | Oklahoma | Oklahoma | 40109 | 16961 | 185 |
556043 | 556043 | 2020-09-21 | Oklahoma | Oklahoma | 40109 | 16749 | 183 |
552806 | 552806 | 2020-09-20 | Oklahoma | Oklahoma | 40109 | 16560 | 182 |
549567 | 549567 | 2020-09-19 | Oklahoma | Oklahoma | 40109 | 16435 | 180 |
546328 | 546328 | 2020-09-18 | Oklahoma | Oklahoma | 40109 | 16177 | 180 |
543091 | 543091 | 2020-09-17 | Oklahoma | Oklahoma | 40109 | 15859 | 178 |
539855 | 539855 | 2020-09-16 | Oklahoma | Oklahoma | 40109 | 15694 | 178 |
536618 | 536618 | 2020-09-15 | Oklahoma | Oklahoma | 40109 | 15517 | 176 |
533382 | 533382 | 2020-09-14 | Oklahoma | Oklahoma | 40109 | 15293 | 175 |
530147 | 530147 | 2020-09-13 | Oklahoma | Oklahoma | 40109 | 15178 | 175 |
526910 | 526910 | 2020-09-12 | Oklahoma | Oklahoma | 40109 | 15021 | 174 |
523674 | 523674 | 2020-09-11 | Oklahoma | Oklahoma | 40109 | 14872 | 173 |
520438 | 520438 | 2020-09-10 | Oklahoma | Oklahoma | 40109 | 14713 | 171 |
517202 | 517202 | 2020-09-09 | Oklahoma | Oklahoma | 40109 | 14543 | 168 |
513967 | 513967 | 2020-09-08 | Oklahoma | Oklahoma | 40109 | 14416 | 168 |
510734 | 510734 | 2020-09-07 | Oklahoma | Oklahoma | 40109 | 14272 | 168 |
507501 | 507501 | 2020-09-06 | Oklahoma | Oklahoma | 40109 | 14165 | 168 |
504269 | 504269 | 2020-09-05 | Oklahoma | Oklahoma | 40109 | 14107 | 165 |
501035 | 501035 | 2020-09-04 | Oklahoma | Oklahoma | 40109 | 13923 | 163 |
497801 | 497801 | 2020-09-03 | Oklahoma | Oklahoma | 40109 | 13791 | 158 |
494568 | 494568 | 2020-09-02 | Oklahoma | Oklahoma | 40109 | 13689 | 156 |
491334 | 491334 | 2020-09-01 | Oklahoma | Oklahoma | 40109 | 13566 | 154 |
488101 | 488101 | 2020-08-31 | Oklahoma | Oklahoma | 40109 | 13436 | 154 |
484868 | 484868 | 2020-08-30 | Oklahoma | Oklahoma | 40109 | 13357 | 155 |
481633 | 481633 | 2020-08-29 | Oklahoma | Oklahoma | 40109 | 13254 | 154 |
478399 | 478399 | 2020-08-28 | Oklahoma | Oklahoma | 40109 | 13144 | 153 |
475166 | 475166 | 2020-08-27 | Oklahoma | Oklahoma | 40109 | 12974 | 150 |
471932 | 471932 | 2020-08-26 | Oklahoma | Oklahoma | 40109 | 12870 | 148 |
468700 | 468700 | 2020-08-25 | Oklahoma | Oklahoma | 40109 | 12765 | 145 |
465472 | 465472 | 2020-08-24 | Oklahoma | Oklahoma | 40109 | 12651 | 144 |
462243 | 462243 | 2020-08-23 | Oklahoma | Oklahoma | 40109 | 12584 | 143 |
459015 | 459015 | 2020-08-22 | Oklahoma | Oklahoma | 40109 | 12515 | 142 |
455787 | 455787 | 2020-08-21 | Oklahoma | Oklahoma | 40109 | 12328 | 139 |
452559 | 452559 | 2020-08-20 | Oklahoma | Oklahoma | 40109 | 12037 | 139 |
449331 | 449331 | 2020-08-19 | Oklahoma | Oklahoma | 40109 | 11921 | 135 |
446103 | 446103 | 2020-08-18 | Oklahoma | Oklahoma | 40109 | 11801 | 132 |
442877 | 442877 | 2020-08-17 | Oklahoma | Oklahoma | 40109 | 11715 | 132 |
439650 | 439650 | 2020-08-16 | Oklahoma | Oklahoma | 40109 | 11600 | 131 |
436425 | 436425 | 2020-08-15 | Oklahoma | Oklahoma | 40109 | 11458 | 129 |
433199 | 433199 | 2020-08-14 | Oklahoma | Oklahoma | 40109 | 11312 | 124 |
429973 | 429973 | 2020-08-13 | Oklahoma | Oklahoma | 40109 | 11148 | 121 |
426748 | 426748 | 2020-08-12 | Oklahoma | Oklahoma | 40109 | 10951 | 119 |
423525 | 423525 | 2020-08-11 | Oklahoma | Oklahoma | 40109 | 10794 | 115 |
420302 | 420302 | 2020-08-10 | Oklahoma | Oklahoma | 40109 | 10665 | 112 |
417082 | 417082 | 2020-08-09 | Oklahoma | Oklahoma | 40109 | 10560 | 112 |
413861 | 413861 | 2020-08-08 | Oklahoma | Oklahoma | 40109 | 10424 | 112 |
410641 | 410641 | 2020-08-07 | Oklahoma | Oklahoma | 40109 | 10300 | 112 |
407421 | 407421 | 2020-08-06 | Oklahoma | Oklahoma | 40109 | 10113 | 109 |
404202 | 404202 | 2020-08-05 | Oklahoma | Oklahoma | 40109 | 9950 | 107 |
400984 | 400984 | 2020-08-04 | Oklahoma | Oklahoma | 40109 | 9593 | 102 |
397769 | 397769 | 2020-08-03 | Oklahoma | Oklahoma | 40109 | 9439 | 98 |
394552 | 394552 | 2020-08-02 | Oklahoma | Oklahoma | 40109 | 9357 | 98 |
391336 | 391336 | 2020-08-01 | Oklahoma | Oklahoma | 40109 | 9214 | 98 |
388119 | 388119 | 2020-07-31 | Oklahoma | Oklahoma | 40109 | 8910 | 97 |
384902 | 384902 | 2020-07-30 | Oklahoma | Oklahoma | 40109 | 8669 | 96 |
381684 | 381684 | 2020-07-29 | Oklahoma | Oklahoma | 40109 | 8444 | 94 |
378467 | 378467 | 2020-07-28 | Oklahoma | Oklahoma | 40109 | 8274 | 92 |
375250 | 375250 | 2020-07-27 | Oklahoma | Oklahoma | 40109 | 8019 | 89 |
372038 | 372038 | 2020-07-26 | Oklahoma | Oklahoma | 40109 | 7621 | 90 |
368826 | 368826 | 2020-07-25 | Oklahoma | Oklahoma | 40109 | 7415 | 90 |
365617 | 365617 | 2020-07-24 | Oklahoma | Oklahoma | 40109 | 7239 | 88 |
362411 | 362411 | 2020-07-23 | Oklahoma | Oklahoma | 40109 | 6981 | 85 |
359205 | 359205 | 2020-07-22 | Oklahoma | Oklahoma | 40109 | 6762 | 85 |
356001 | 356001 | 2020-07-21 | Oklahoma | Oklahoma | 40109 | 6492 | 82 |
352798 | 352798 | 2020-07-20 | Oklahoma | Oklahoma | 40109 | 6301 | 77 |
349595 | 349595 | 2020-07-19 | Oklahoma | Oklahoma | 40109 | 6271 | 77 |
346395 | 346395 | 2020-07-18 | Oklahoma | Oklahoma | 40109 | 6195 | 77 |
343195 | 343195 | 2020-07-17 | Oklahoma | Oklahoma | 40109 | 5978 | 77 |
339997 | 339997 | 2020-07-16 | Oklahoma | Oklahoma | 40109 | 5756 | 77 |
336801 | 336801 | 2020-07-15 | Oklahoma | Oklahoma | 40109 | 5591 | 76 |
333607 | 333607 | 2020-07-14 | Oklahoma | Oklahoma | 40109 | 5259 | 75 |
330415 | 330415 | 2020-07-13 | Oklahoma | Oklahoma | 40109 | 4986 | 74 |
327228 | 327228 | 2020-07-12 | Oklahoma | Oklahoma | 40109 | 4802 | 74 |
324043 | 324043 | 2020-07-11 | Oklahoma | Oklahoma | 40109 | 4613 | 74 |
320863 | 320863 | 2020-07-10 | Oklahoma | Oklahoma | 40109 | 4379 | 72 |
317686 | 317686 | 2020-07-09 | Oklahoma | Oklahoma | 40109 | 4194 | 72 |
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);