ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 40103 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
630592 | 630592 | 2020-10-14 | Noble | Oklahoma | 40103 | 166 | 3 |
627348 | 627348 | 2020-10-13 | Noble | Oklahoma | 40103 | 165 | 3 |
624106 | 624106 | 2020-10-12 | Noble | Oklahoma | 40103 | 163 | 3 |
620863 | 620863 | 2020-10-11 | Noble | Oklahoma | 40103 | 163 | 3 |
617621 | 617621 | 2020-10-10 | Noble | Oklahoma | 40103 | 163 | 3 |
614379 | 614379 | 2020-10-09 | Noble | Oklahoma | 40103 | 162 | 3 |
611138 | 611138 | 2020-10-08 | Noble | Oklahoma | 40103 | 162 | 3 |
607896 | 607896 | 2020-10-07 | Noble | Oklahoma | 40103 | 163 | 3 |
604653 | 604653 | 2020-10-06 | Noble | Oklahoma | 40103 | 162 | 3 |
601411 | 601411 | 2020-10-05 | Noble | Oklahoma | 40103 | 161 | 3 |
598168 | 598168 | 2020-10-04 | Noble | Oklahoma | 40103 | 163 | 3 |
594925 | 594925 | 2020-10-03 | Noble | Oklahoma | 40103 | 163 | 3 |
591684 | 591684 | 2020-10-02 | Noble | Oklahoma | 40103 | 162 | 3 |
588443 | 588443 | 2020-10-01 | Noble | Oklahoma | 40103 | 162 | 3 |
585203 | 585203 | 2020-09-30 | Noble | Oklahoma | 40103 | 158 | 3 |
581963 | 581963 | 2020-09-29 | Noble | Oklahoma | 40103 | 152 | 2 |
578723 | 578723 | 2020-09-28 | Noble | Oklahoma | 40103 | 152 | 2 |
575482 | 575482 | 2020-09-27 | Noble | Oklahoma | 40103 | 152 | 2 |
572238 | 572238 | 2020-09-26 | Noble | Oklahoma | 40103 | 151 | 2 |
568996 | 568996 | 2020-09-25 | Noble | Oklahoma | 40103 | 151 | 2 |
565755 | 565755 | 2020-09-24 | Noble | Oklahoma | 40103 | 149 | 2 |
562514 | 562514 | 2020-09-23 | Noble | Oklahoma | 40103 | 142 | 2 |
559277 | 559277 | 2020-09-22 | Noble | Oklahoma | 40103 | 143 | 2 |
556040 | 556040 | 2020-09-21 | Noble | Oklahoma | 40103 | 141 | 2 |
552803 | 552803 | 2020-09-20 | Noble | Oklahoma | 40103 | 140 | 2 |
549564 | 549564 | 2020-09-19 | Noble | Oklahoma | 40103 | 140 | 2 |
546325 | 546325 | 2020-09-18 | Noble | Oklahoma | 40103 | 139 | 2 |
543088 | 543088 | 2020-09-17 | Noble | Oklahoma | 40103 | 139 | 2 |
539852 | 539852 | 2020-09-16 | Noble | Oklahoma | 40103 | 138 | 2 |
536615 | 536615 | 2020-09-15 | Noble | Oklahoma | 40103 | 136 | 2 |
533379 | 533379 | 2020-09-14 | Noble | Oklahoma | 40103 | 131 | 2 |
530144 | 530144 | 2020-09-13 | Noble | Oklahoma | 40103 | 129 | 2 |
526907 | 526907 | 2020-09-12 | Noble | Oklahoma | 40103 | 129 | 2 |
523671 | 523671 | 2020-09-11 | Noble | Oklahoma | 40103 | 126 | 2 |
520435 | 520435 | 2020-09-10 | Noble | Oklahoma | 40103 | 121 | 2 |
517199 | 517199 | 2020-09-09 | Noble | Oklahoma | 40103 | 119 | 2 |
513964 | 513964 | 2020-09-08 | Noble | Oklahoma | 40103 | 118 | 2 |
510731 | 510731 | 2020-09-07 | Noble | Oklahoma | 40103 | 118 | 2 |
507498 | 507498 | 2020-09-06 | Noble | Oklahoma | 40103 | 118 | 2 |
504266 | 504266 | 2020-09-05 | Noble | Oklahoma | 40103 | 117 | 2 |
501032 | 501032 | 2020-09-04 | Noble | Oklahoma | 40103 | 115 | 2 |
497798 | 497798 | 2020-09-03 | Noble | Oklahoma | 40103 | 113 | 2 |
494565 | 494565 | 2020-09-02 | Noble | Oklahoma | 40103 | 111 | 2 |
491331 | 491331 | 2020-09-01 | Noble | Oklahoma | 40103 | 107 | 2 |
488098 | 488098 | 2020-08-31 | Noble | Oklahoma | 40103 | 105 | 2 |
484865 | 484865 | 2020-08-30 | Noble | Oklahoma | 40103 | 104 | 2 |
481630 | 481630 | 2020-08-29 | Noble | Oklahoma | 40103 | 102 | 2 |
478396 | 478396 | 2020-08-28 | Noble | Oklahoma | 40103 | 101 | 2 |
475163 | 475163 | 2020-08-27 | Noble | Oklahoma | 40103 | 101 | 2 |
471929 | 471929 | 2020-08-26 | Noble | Oklahoma | 40103 | 100 | 2 |
468697 | 468697 | 2020-08-25 | Noble | Oklahoma | 40103 | 99 | 2 |
465469 | 465469 | 2020-08-24 | Noble | Oklahoma | 40103 | 99 | 2 |
462240 | 462240 | 2020-08-23 | Noble | Oklahoma | 40103 | 97 | 2 |
459012 | 459012 | 2020-08-22 | Noble | Oklahoma | 40103 | 97 | 2 |
455784 | 455784 | 2020-08-21 | Noble | Oklahoma | 40103 | 93 | 2 |
452556 | 452556 | 2020-08-20 | Noble | Oklahoma | 40103 | 92 | 2 |
449328 | 449328 | 2020-08-19 | Noble | Oklahoma | 40103 | 92 | 2 |
446100 | 446100 | 2020-08-18 | Noble | Oklahoma | 40103 | 92 | 2 |
442874 | 442874 | 2020-08-17 | Noble | Oklahoma | 40103 | 92 | 2 |
439647 | 439647 | 2020-08-16 | Noble | Oklahoma | 40103 | 91 | 2 |
436422 | 436422 | 2020-08-15 | Noble | Oklahoma | 40103 | 91 | 2 |
433196 | 433196 | 2020-08-14 | Noble | Oklahoma | 40103 | 89 | 2 |
429970 | 429970 | 2020-08-13 | Noble | Oklahoma | 40103 | 87 | 2 |
426745 | 426745 | 2020-08-12 | Noble | Oklahoma | 40103 | 87 | 2 |
423522 | 423522 | 2020-08-11 | Noble | Oklahoma | 40103 | 87 | 2 |
420299 | 420299 | 2020-08-10 | Noble | Oklahoma | 40103 | 84 | 2 |
417079 | 417079 | 2020-08-09 | Noble | Oklahoma | 40103 | 83 | 2 |
413858 | 413858 | 2020-08-08 | Noble | Oklahoma | 40103 | 83 | 2 |
410638 | 410638 | 2020-08-07 | Noble | Oklahoma | 40103 | 83 | 2 |
407418 | 407418 | 2020-08-06 | Noble | Oklahoma | 40103 | 83 | 2 |
404199 | 404199 | 2020-08-05 | Noble | Oklahoma | 40103 | 83 | 2 |
400981 | 400981 | 2020-08-04 | Noble | Oklahoma | 40103 | 81 | 2 |
397766 | 397766 | 2020-08-03 | Noble | Oklahoma | 40103 | 77 | 2 |
394549 | 394549 | 2020-08-02 | Noble | Oklahoma | 40103 | 77 | 2 |
391333 | 391333 | 2020-08-01 | Noble | Oklahoma | 40103 | 77 | 2 |
388116 | 388116 | 2020-07-31 | Noble | Oklahoma | 40103 | 77 | 2 |
384899 | 384899 | 2020-07-30 | Noble | Oklahoma | 40103 | 74 | 2 |
381681 | 381681 | 2020-07-29 | Noble | Oklahoma | 40103 | 73 | 2 |
378464 | 378464 | 2020-07-28 | Noble | Oklahoma | 40103 | 74 | 2 |
375247 | 375247 | 2020-07-27 | Noble | Oklahoma | 40103 | 74 | 2 |
372035 | 372035 | 2020-07-26 | Noble | Oklahoma | 40103 | 73 | 2 |
368823 | 368823 | 2020-07-25 | Noble | Oklahoma | 40103 | 71 | 2 |
365614 | 365614 | 2020-07-24 | Noble | Oklahoma | 40103 | 69 | 2 |
362408 | 362408 | 2020-07-23 | Noble | Oklahoma | 40103 | 66 | 2 |
359202 | 359202 | 2020-07-22 | Noble | Oklahoma | 40103 | 65 | 2 |
355998 | 355998 | 2020-07-21 | Noble | Oklahoma | 40103 | 61 | 2 |
352795 | 352795 | 2020-07-20 | Noble | Oklahoma | 40103 | 59 | 1 |
349592 | 349592 | 2020-07-19 | Noble | Oklahoma | 40103 | 59 | 1 |
346392 | 346392 | 2020-07-18 | Noble | Oklahoma | 40103 | 58 | 1 |
343192 | 343192 | 2020-07-17 | Noble | Oklahoma | 40103 | 57 | 1 |
339994 | 339994 | 2020-07-16 | Noble | Oklahoma | 40103 | 56 | 1 |
336798 | 336798 | 2020-07-15 | Noble | Oklahoma | 40103 | 55 | 1 |
333604 | 333604 | 2020-07-14 | Noble | Oklahoma | 40103 | 53 | 1 |
330412 | 330412 | 2020-07-13 | Noble | Oklahoma | 40103 | 53 | 1 |
327225 | 327225 | 2020-07-12 | Noble | Oklahoma | 40103 | 52 | 1 |
324040 | 324040 | 2020-07-11 | Noble | Oklahoma | 40103 | 52 | 1 |
320860 | 320860 | 2020-07-10 | Noble | Oklahoma | 40103 | 51 | 1 |
317683 | 317683 | 2020-07-09 | Noble | Oklahoma | 40103 | 50 | 1 |
314510 | 314510 | 2020-07-08 | Noble | Oklahoma | 40103 | 48 | 1 |
311338 | 311338 | 2020-07-07 | Noble | Oklahoma | 40103 | 48 | 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);