ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
747 rows where fips = 40127 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637095 | 637095 | 2020-10-16 | Pushmataha | Oklahoma | 40127 | 241 | 4 |
633849 | 633849 | 2020-10-15 | Pushmataha | Oklahoma | 40127 | 233 | 4 |
630604 | 630604 | 2020-10-14 | Pushmataha | Oklahoma | 40127 | 231 | 4 |
627360 | 627360 | 2020-10-13 | Pushmataha | Oklahoma | 40127 | 230 | 3 |
624118 | 624118 | 2020-10-12 | Pushmataha | Oklahoma | 40127 | 225 | 3 |
620875 | 620875 | 2020-10-11 | Pushmataha | Oklahoma | 40127 | 222 | 3 |
617633 | 617633 | 2020-10-10 | Pushmataha | Oklahoma | 40127 | 219 | 3 |
614391 | 614391 | 2020-10-09 | Pushmataha | Oklahoma | 40127 | 217 | 3 |
611150 | 611150 | 2020-10-08 | Pushmataha | Oklahoma | 40127 | 212 | 3 |
607908 | 607908 | 2020-10-07 | Pushmataha | Oklahoma | 40127 | 208 | 2 |
604665 | 604665 | 2020-10-06 | Pushmataha | Oklahoma | 40127 | 203 | 2 |
601423 | 601423 | 2020-10-05 | Pushmataha | Oklahoma | 40127 | 201 | 2 |
598180 | 598180 | 2020-10-04 | Pushmataha | Oklahoma | 40127 | 199 | 2 |
594937 | 594937 | 2020-10-03 | Pushmataha | Oklahoma | 40127 | 199 | 2 |
591696 | 591696 | 2020-10-02 | Pushmataha | Oklahoma | 40127 | 174 | 2 |
588455 | 588455 | 2020-10-01 | Pushmataha | Oklahoma | 40127 | 170 | 2 |
585215 | 585215 | 2020-09-30 | Pushmataha | Oklahoma | 40127 | 165 | 2 |
581975 | 581975 | 2020-09-29 | Pushmataha | Oklahoma | 40127 | 164 | 2 |
578735 | 578735 | 2020-09-28 | Pushmataha | Oklahoma | 40127 | 164 | 2 |
575494 | 575494 | 2020-09-27 | Pushmataha | Oklahoma | 40127 | 164 | 2 |
572250 | 572250 | 2020-09-26 | Pushmataha | Oklahoma | 40127 | 163 | 2 |
569008 | 569008 | 2020-09-25 | Pushmataha | Oklahoma | 40127 | 154 | 2 |
565767 | 565767 | 2020-09-24 | Pushmataha | Oklahoma | 40127 | 151 | 1 |
562526 | 562526 | 2020-09-23 | Pushmataha | Oklahoma | 40127 | 149 | 1 |
559289 | 559289 | 2020-09-22 | Pushmataha | Oklahoma | 40127 | 149 | 1 |
556052 | 556052 | 2020-09-21 | Pushmataha | Oklahoma | 40127 | 148 | 1 |
552815 | 552815 | 2020-09-20 | Pushmataha | Oklahoma | 40127 | 147 | 1 |
549576 | 549576 | 2020-09-19 | Pushmataha | Oklahoma | 40127 | 145 | 1 |
546337 | 546337 | 2020-09-18 | Pushmataha | Oklahoma | 40127 | 144 | 1 |
543100 | 543100 | 2020-09-17 | Pushmataha | Oklahoma | 40127 | 139 | 1 |
539864 | 539864 | 2020-09-16 | Pushmataha | Oklahoma | 40127 | 139 | 1 |
536627 | 536627 | 2020-09-15 | Pushmataha | Oklahoma | 40127 | 139 | 1 |
533391 | 533391 | 2020-09-14 | Pushmataha | Oklahoma | 40127 | 137 | 1 |
530156 | 530156 | 2020-09-13 | Pushmataha | Oklahoma | 40127 | 136 | 1 |
526919 | 526919 | 2020-09-12 | Pushmataha | Oklahoma | 40127 | 134 | 1 |
523683 | 523683 | 2020-09-11 | Pushmataha | Oklahoma | 40127 | 134 | 1 |
520447 | 520447 | 2020-09-10 | Pushmataha | Oklahoma | 40127 | 134 | 1 |
517211 | 517211 | 2020-09-09 | Pushmataha | Oklahoma | 40127 | 132 | 1 |
513976 | 513976 | 2020-09-08 | Pushmataha | Oklahoma | 40127 | 131 | 1 |
510743 | 510743 | 2020-09-07 | Pushmataha | Oklahoma | 40127 | 131 | 1 |
507510 | 507510 | 2020-09-06 | Pushmataha | Oklahoma | 40127 | 131 | 1 |
504278 | 504278 | 2020-09-05 | Pushmataha | Oklahoma | 40127 | 131 | 1 |
501044 | 501044 | 2020-09-04 | Pushmataha | Oklahoma | 40127 | 131 | 1 |
497810 | 497810 | 2020-09-03 | Pushmataha | Oklahoma | 40127 | 131 | 1 |
494577 | 494577 | 2020-09-02 | Pushmataha | Oklahoma | 40127 | 127 | 1 |
491343 | 491343 | 2020-09-01 | Pushmataha | Oklahoma | 40127 | 126 | 1 |
488110 | 488110 | 2020-08-31 | Pushmataha | Oklahoma | 40127 | 126 | 1 |
484877 | 484877 | 2020-08-30 | Pushmataha | Oklahoma | 40127 | 126 | 1 |
481642 | 481642 | 2020-08-29 | Pushmataha | Oklahoma | 40127 | 126 | 1 |
478408 | 478408 | 2020-08-28 | Pushmataha | Oklahoma | 40127 | 125 | 1 |
475175 | 475175 | 2020-08-27 | Pushmataha | Oklahoma | 40127 | 123 | 1 |
471941 | 471941 | 2020-08-26 | Pushmataha | Oklahoma | 40127 | 121 | 1 |
468709 | 468709 | 2020-08-25 | Pushmataha | Oklahoma | 40127 | 121 | 1 |
465481 | 465481 | 2020-08-24 | Pushmataha | Oklahoma | 40127 | 121 | 0 |
462252 | 462252 | 2020-08-23 | Pushmataha | Oklahoma | 40127 | 121 | 0 |
459024 | 459024 | 2020-08-22 | Pushmataha | Oklahoma | 40127 | 121 | 0 |
455796 | 455796 | 2020-08-21 | Pushmataha | Oklahoma | 40127 | 119 | 0 |
452568 | 452568 | 2020-08-20 | Pushmataha | Oklahoma | 40127 | 118 | 0 |
449340 | 449340 | 2020-08-19 | Pushmataha | Oklahoma | 40127 | 118 | 0 |
446112 | 446112 | 2020-08-18 | Pushmataha | Oklahoma | 40127 | 117 | 0 |
442886 | 442886 | 2020-08-17 | Pushmataha | Oklahoma | 40127 | 116 | 0 |
439659 | 439659 | 2020-08-16 | Pushmataha | Oklahoma | 40127 | 117 | 0 |
436434 | 436434 | 2020-08-15 | Pushmataha | Oklahoma | 40127 | 116 | 0 |
433208 | 433208 | 2020-08-14 | Pushmataha | Oklahoma | 40127 | 111 | 0 |
429982 | 429982 | 2020-08-13 | Pushmataha | Oklahoma | 40127 | 112 | 0 |
426757 | 426757 | 2020-08-12 | Pushmataha | Oklahoma | 40127 | 112 | 0 |
423534 | 423534 | 2020-08-11 | Pushmataha | Oklahoma | 40127 | 109 | 0 |
420311 | 420311 | 2020-08-10 | Pushmataha | Oklahoma | 40127 | 108 | 0 |
417091 | 417091 | 2020-08-09 | Pushmataha | Oklahoma | 40127 | 108 | 0 |
413870 | 413870 | 2020-08-08 | Pushmataha | Oklahoma | 40127 | 109 | 0 |
410650 | 410650 | 2020-08-07 | Pushmataha | Oklahoma | 40127 | 107 | 0 |
407430 | 407430 | 2020-08-06 | Pushmataha | Oklahoma | 40127 | 105 | 0 |
404211 | 404211 | 2020-08-05 | Pushmataha | Oklahoma | 40127 | 101 | 0 |
400993 | 400993 | 2020-08-04 | Pushmataha | Oklahoma | 40127 | 103 | 0 |
397778 | 397778 | 2020-08-03 | Pushmataha | Oklahoma | 40127 | 100 | 0 |
394561 | 394561 | 2020-08-02 | Pushmataha | Oklahoma | 40127 | 102 | 0 |
391345 | 391345 | 2020-08-01 | Pushmataha | Oklahoma | 40127 | 101 | 0 |
388128 | 388128 | 2020-07-31 | Pushmataha | Oklahoma | 40127 | 89 | 0 |
384911 | 384911 | 2020-07-30 | Pushmataha | Oklahoma | 40127 | 83 | 0 |
381693 | 381693 | 2020-07-29 | Pushmataha | Oklahoma | 40127 | 79 | 0 |
378476 | 378476 | 2020-07-28 | Pushmataha | Oklahoma | 40127 | 78 | 0 |
375259 | 375259 | 2020-07-27 | Pushmataha | Oklahoma | 40127 | 67 | 0 |
372047 | 372047 | 2020-07-26 | Pushmataha | Oklahoma | 40127 | 60 | 0 |
368835 | 368835 | 2020-07-25 | Pushmataha | Oklahoma | 40127 | 53 | 0 |
365626 | 365626 | 2020-07-24 | Pushmataha | Oklahoma | 40127 | 51 | 0 |
362420 | 362420 | 2020-07-23 | Pushmataha | Oklahoma | 40127 | 47 | 0 |
359214 | 359214 | 2020-07-22 | Pushmataha | Oklahoma | 40127 | 46 | 0 |
356010 | 356010 | 2020-07-21 | Pushmataha | Oklahoma | 40127 | 40 | 0 |
352807 | 352807 | 2020-07-20 | Pushmataha | Oklahoma | 40127 | 39 | 0 |
349604 | 349604 | 2020-07-19 | Pushmataha | Oklahoma | 40127 | 39 | 0 |
346404 | 346404 | 2020-07-18 | Pushmataha | Oklahoma | 40127 | 37 | 0 |
343204 | 343204 | 2020-07-17 | Pushmataha | Oklahoma | 40127 | 37 | 0 |
340006 | 340006 | 2020-07-16 | Pushmataha | Oklahoma | 40127 | 35 | 0 |
336810 | 336810 | 2020-07-15 | Pushmataha | Oklahoma | 40127 | 35 | 0 |
333616 | 333616 | 2020-07-14 | Pushmataha | Oklahoma | 40127 | 31 | 0 |
330424 | 330424 | 2020-07-13 | Pushmataha | Oklahoma | 40127 | 25 | 0 |
327237 | 327237 | 2020-07-12 | Pushmataha | Oklahoma | 40127 | 25 | 0 |
324052 | 324052 | 2020-07-11 | Pushmataha | Oklahoma | 40127 | 25 | 0 |
320872 | 320872 | 2020-07-10 | Pushmataha | Oklahoma | 40127 | 22 | 0 |
317695 | 317695 | 2020-07-09 | Pushmataha | Oklahoma | 40127 | 20 | 0 |
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);