ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Marshall" and fips = 40095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637076 | 637076 | 2020-10-16 | Marshall | Oklahoma | 40095 | 246 | 2 |
633830 | 633830 | 2020-10-15 | Marshall | Oklahoma | 40095 | 235 | 2 |
630585 | 630585 | 2020-10-14 | Marshall | Oklahoma | 40095 | 228 | 2 |
627341 | 627341 | 2020-10-13 | Marshall | Oklahoma | 40095 | 222 | 2 |
624099 | 624099 | 2020-10-12 | Marshall | Oklahoma | 40095 | 218 | 2 |
620856 | 620856 | 2020-10-11 | Marshall | Oklahoma | 40095 | 215 | 2 |
617614 | 617614 | 2020-10-10 | Marshall | Oklahoma | 40095 | 212 | 2 |
614372 | 614372 | 2020-10-09 | Marshall | Oklahoma | 40095 | 209 | 2 |
611131 | 611131 | 2020-10-08 | Marshall | Oklahoma | 40095 | 201 | 2 |
607889 | 607889 | 2020-10-07 | Marshall | Oklahoma | 40095 | 201 | 2 |
604646 | 604646 | 2020-10-06 | Marshall | Oklahoma | 40095 | 200 | 2 |
601404 | 601404 | 2020-10-05 | Marshall | Oklahoma | 40095 | 196 | 2 |
598161 | 598161 | 2020-10-04 | Marshall | Oklahoma | 40095 | 196 | 2 |
594918 | 594918 | 2020-10-03 | Marshall | Oklahoma | 40095 | 196 | 2 |
591677 | 591677 | 2020-10-02 | Marshall | Oklahoma | 40095 | 193 | 2 |
588436 | 588436 | 2020-10-01 | Marshall | Oklahoma | 40095 | 190 | 2 |
585196 | 585196 | 2020-09-30 | Marshall | Oklahoma | 40095 | 187 | 2 |
581956 | 581956 | 2020-09-29 | Marshall | Oklahoma | 40095 | 183 | 2 |
578716 | 578716 | 2020-09-28 | Marshall | Oklahoma | 40095 | 181 | 2 |
575475 | 575475 | 2020-09-27 | Marshall | Oklahoma | 40095 | 180 | 2 |
572231 | 572231 | 2020-09-26 | Marshall | Oklahoma | 40095 | 180 | 2 |
568989 | 568989 | 2020-09-25 | Marshall | Oklahoma | 40095 | 180 | 2 |
565748 | 565748 | 2020-09-24 | Marshall | Oklahoma | 40095 | 178 | 1 |
562507 | 562507 | 2020-09-23 | Marshall | Oklahoma | 40095 | 178 | 1 |
559270 | 559270 | 2020-09-22 | Marshall | Oklahoma | 40095 | 173 | 1 |
556033 | 556033 | 2020-09-21 | Marshall | Oklahoma | 40095 | 171 | 1 |
552796 | 552796 | 2020-09-20 | Marshall | Oklahoma | 40095 | 171 | 1 |
549557 | 549557 | 2020-09-19 | Marshall | Oklahoma | 40095 | 170 | 1 |
546318 | 546318 | 2020-09-18 | Marshall | Oklahoma | 40095 | 169 | 1 |
543081 | 543081 | 2020-09-17 | Marshall | Oklahoma | 40095 | 166 | 1 |
539845 | 539845 | 2020-09-16 | Marshall | Oklahoma | 40095 | 163 | 1 |
536608 | 536608 | 2020-09-15 | Marshall | Oklahoma | 40095 | 161 | 1 |
533372 | 533372 | 2020-09-14 | Marshall | Oklahoma | 40095 | 157 | 1 |
530137 | 530137 | 2020-09-13 | Marshall | Oklahoma | 40095 | 147 | 1 |
526900 | 526900 | 2020-09-12 | Marshall | Oklahoma | 40095 | 147 | 1 |
523664 | 523664 | 2020-09-11 | Marshall | Oklahoma | 40095 | 144 | 1 |
520428 | 520428 | 2020-09-10 | Marshall | Oklahoma | 40095 | 144 | 1 |
517192 | 517192 | 2020-09-09 | Marshall | Oklahoma | 40095 | 143 | 1 |
513957 | 513957 | 2020-09-08 | Marshall | Oklahoma | 40095 | 140 | 1 |
510724 | 510724 | 2020-09-07 | Marshall | Oklahoma | 40095 | 138 | 1 |
507491 | 507491 | 2020-09-06 | Marshall | Oklahoma | 40095 | 136 | 1 |
504259 | 504259 | 2020-09-05 | Marshall | Oklahoma | 40095 | 135 | 1 |
501025 | 501025 | 2020-09-04 | Marshall | Oklahoma | 40095 | 133 | 1 |
497791 | 497791 | 2020-09-03 | Marshall | Oklahoma | 40095 | 133 | 1 |
494558 | 494558 | 2020-09-02 | Marshall | Oklahoma | 40095 | 132 | 1 |
491324 | 491324 | 2020-09-01 | Marshall | Oklahoma | 40095 | 131 | 1 |
488091 | 488091 | 2020-08-31 | Marshall | Oklahoma | 40095 | 130 | 1 |
484858 | 484858 | 2020-08-30 | Marshall | Oklahoma | 40095 | 130 | 1 |
481623 | 481623 | 2020-08-29 | Marshall | Oklahoma | 40095 | 130 | 1 |
478389 | 478389 | 2020-08-28 | Marshall | Oklahoma | 40095 | 130 | 1 |
475156 | 475156 | 2020-08-27 | Marshall | Oklahoma | 40095 | 129 | 1 |
471922 | 471922 | 2020-08-26 | Marshall | Oklahoma | 40095 | 128 | 1 |
468690 | 468690 | 2020-08-25 | Marshall | Oklahoma | 40095 | 127 | 1 |
465462 | 465462 | 2020-08-24 | Marshall | Oklahoma | 40095 | 126 | 1 |
462233 | 462233 | 2020-08-23 | Marshall | Oklahoma | 40095 | 125 | 1 |
459005 | 459005 | 2020-08-22 | Marshall | Oklahoma | 40095 | 126 | 1 |
455777 | 455777 | 2020-08-21 | Marshall | Oklahoma | 40095 | 124 | 1 |
452549 | 452549 | 2020-08-20 | Marshall | Oklahoma | 40095 | 123 | 1 |
449321 | 449321 | 2020-08-19 | Marshall | Oklahoma | 40095 | 123 | 1 |
446093 | 446093 | 2020-08-18 | Marshall | Oklahoma | 40095 | 126 | 1 |
442867 | 442867 | 2020-08-17 | Marshall | Oklahoma | 40095 | 121 | 1 |
439640 | 439640 | 2020-08-16 | Marshall | Oklahoma | 40095 | 121 | 1 |
436415 | 436415 | 2020-08-15 | Marshall | Oklahoma | 40095 | 121 | 1 |
433189 | 433189 | 2020-08-14 | Marshall | Oklahoma | 40095 | 119 | 1 |
429963 | 429963 | 2020-08-13 | Marshall | Oklahoma | 40095 | 118 | 1 |
426738 | 426738 | 2020-08-12 | Marshall | Oklahoma | 40095 | 111 | 1 |
423515 | 423515 | 2020-08-11 | Marshall | Oklahoma | 40095 | 110 | 1 |
420292 | 420292 | 2020-08-10 | Marshall | Oklahoma | 40095 | 107 | 1 |
417072 | 417072 | 2020-08-09 | Marshall | Oklahoma | 40095 | 107 | 1 |
413851 | 413851 | 2020-08-08 | Marshall | Oklahoma | 40095 | 107 | 1 |
410631 | 410631 | 2020-08-07 | Marshall | Oklahoma | 40095 | 106 | 1 |
407411 | 407411 | 2020-08-06 | Marshall | Oklahoma | 40095 | 102 | 1 |
404192 | 404192 | 2020-08-05 | Marshall | Oklahoma | 40095 | 99 | 0 |
400974 | 400974 | 2020-08-04 | Marshall | Oklahoma | 40095 | 100 | 0 |
397759 | 397759 | 2020-08-03 | Marshall | Oklahoma | 40095 | 97 | 0 |
394542 | 394542 | 2020-08-02 | Marshall | Oklahoma | 40095 | 96 | 0 |
391326 | 391326 | 2020-08-01 | Marshall | Oklahoma | 40095 | 97 | 0 |
388109 | 388109 | 2020-07-31 | Marshall | Oklahoma | 40095 | 93 | 0 |
384892 | 384892 | 2020-07-30 | Marshall | Oklahoma | 40095 | 83 | 0 |
381674 | 381674 | 2020-07-29 | Marshall | Oklahoma | 40095 | 78 | 0 |
378457 | 378457 | 2020-07-28 | Marshall | Oklahoma | 40095 | 69 | 0 |
375240 | 375240 | 2020-07-27 | Marshall | Oklahoma | 40095 | 67 | 0 |
372028 | 372028 | 2020-07-26 | Marshall | Oklahoma | 40095 | 64 | 0 |
368816 | 368816 | 2020-07-25 | Marshall | Oklahoma | 40095 | 59 | 0 |
365607 | 365607 | 2020-07-24 | Marshall | Oklahoma | 40095 | 59 | 0 |
362401 | 362401 | 2020-07-23 | Marshall | Oklahoma | 40095 | 59 | 0 |
359195 | 359195 | 2020-07-22 | Marshall | Oklahoma | 40095 | 58 | 0 |
355991 | 355991 | 2020-07-21 | Marshall | Oklahoma | 40095 | 51 | 0 |
352788 | 352788 | 2020-07-20 | Marshall | Oklahoma | 40095 | 51 | 0 |
349585 | 349585 | 2020-07-19 | Marshall | Oklahoma | 40095 | 50 | 0 |
346385 | 346385 | 2020-07-18 | Marshall | Oklahoma | 40095 | 50 | 0 |
343185 | 343185 | 2020-07-17 | Marshall | Oklahoma | 40095 | 49 | 0 |
339987 | 339987 | 2020-07-16 | Marshall | Oklahoma | 40095 | 49 | 0 |
336791 | 336791 | 2020-07-15 | Marshall | Oklahoma | 40095 | 49 | 0 |
333597 | 333597 | 2020-07-14 | Marshall | Oklahoma | 40095 | 47 | 0 |
330405 | 330405 | 2020-07-13 | Marshall | Oklahoma | 40095 | 43 | 0 |
327218 | 327218 | 2020-07-12 | Marshall | Oklahoma | 40095 | 43 | 0 |
324033 | 324033 | 2020-07-11 | Marshall | Oklahoma | 40095 | 43 | 0 |
320853 | 320853 | 2020-07-10 | Marshall | Oklahoma | 40095 | 43 | 0 |
317676 | 317676 | 2020-07-09 | Marshall | Oklahoma | 40095 | 43 | 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);