ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 40109 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
260946 | 260946 | 2020-06-21 | Oklahoma | Oklahoma | 40109 | 2099 | 65 |
264074 | 264074 | 2020-06-22 | Oklahoma | Oklahoma | 40109 | 2147 | 65 |
267202 | 267202 | 2020-06-23 | Oklahoma | Oklahoma | 40109 | 2230 | 65 |
270336 | 270336 | 2020-06-24 | Oklahoma | Oklahoma | 40109 | 2317 | 65 |
273475 | 273475 | 2020-06-25 | Oklahoma | Oklahoma | 40109 | 2410 | 68 |
276622 | 276622 | 2020-06-26 | Oklahoma | Oklahoma | 40109 | 2486 | 69 |
279770 | 279770 | 2020-06-27 | Oklahoma | Oklahoma | 40109 | 2600 | 69 |
282916 | 282916 | 2020-06-28 | Oklahoma | Oklahoma | 40109 | 2663 | 70 |
286061 | 286061 | 2020-06-29 | Oklahoma | Oklahoma | 40109 | 2732 | 70 |
289211 | 289211 | 2020-06-30 | Oklahoma | Oklahoma | 40109 | 2913 | 70 |
292364 | 292364 | 2020-07-01 | Oklahoma | Oklahoma | 40109 | 3029 | 70 |
295520 | 295520 | 2020-07-02 | Oklahoma | Oklahoma | 40109 | 3135 | 70 |
298679 | 298679 | 2020-07-03 | Oklahoma | Oklahoma | 40109 | 3263 | 70 |
301842 | 301842 | 2020-07-04 | Oklahoma | Oklahoma | 40109 | 3393 | 70 |
305005 | 305005 | 2020-07-05 | Oklahoma | Oklahoma | 40109 | 3479 | 70 |
308172 | 308172 | 2020-07-06 | Oklahoma | Oklahoma | 40109 | 3607 | 70 |
311341 | 311341 | 2020-07-07 | Oklahoma | Oklahoma | 40109 | 3819 | 70 |
314513 | 314513 | 2020-07-08 | Oklahoma | Oklahoma | 40109 | 4039 | 71 |
317686 | 317686 | 2020-07-09 | Oklahoma | Oklahoma | 40109 | 4194 | 72 |
320863 | 320863 | 2020-07-10 | Oklahoma | Oklahoma | 40109 | 4379 | 72 |
324043 | 324043 | 2020-07-11 | Oklahoma | Oklahoma | 40109 | 4613 | 74 |
327228 | 327228 | 2020-07-12 | Oklahoma | Oklahoma | 40109 | 4802 | 74 |
330415 | 330415 | 2020-07-13 | Oklahoma | Oklahoma | 40109 | 4986 | 74 |
333607 | 333607 | 2020-07-14 | Oklahoma | Oklahoma | 40109 | 5259 | 75 |
336801 | 336801 | 2020-07-15 | Oklahoma | Oklahoma | 40109 | 5591 | 76 |
339997 | 339997 | 2020-07-16 | Oklahoma | Oklahoma | 40109 | 5756 | 77 |
343195 | 343195 | 2020-07-17 | Oklahoma | Oklahoma | 40109 | 5978 | 77 |
346395 | 346395 | 2020-07-18 | Oklahoma | Oklahoma | 40109 | 6195 | 77 |
349595 | 349595 | 2020-07-19 | Oklahoma | Oklahoma | 40109 | 6271 | 77 |
352798 | 352798 | 2020-07-20 | Oklahoma | Oklahoma | 40109 | 6301 | 77 |
356001 | 356001 | 2020-07-21 | Oklahoma | Oklahoma | 40109 | 6492 | 82 |
359205 | 359205 | 2020-07-22 | Oklahoma | Oklahoma | 40109 | 6762 | 85 |
362411 | 362411 | 2020-07-23 | Oklahoma | Oklahoma | 40109 | 6981 | 85 |
365617 | 365617 | 2020-07-24 | Oklahoma | Oklahoma | 40109 | 7239 | 88 |
368826 | 368826 | 2020-07-25 | Oklahoma | Oklahoma | 40109 | 7415 | 90 |
372038 | 372038 | 2020-07-26 | Oklahoma | Oklahoma | 40109 | 7621 | 90 |
375250 | 375250 | 2020-07-27 | Oklahoma | Oklahoma | 40109 | 8019 | 89 |
378467 | 378467 | 2020-07-28 | Oklahoma | Oklahoma | 40109 | 8274 | 92 |
381684 | 381684 | 2020-07-29 | Oklahoma | Oklahoma | 40109 | 8444 | 94 |
384902 | 384902 | 2020-07-30 | Oklahoma | Oklahoma | 40109 | 8669 | 96 |
388119 | 388119 | 2020-07-31 | Oklahoma | Oklahoma | 40109 | 8910 | 97 |
391336 | 391336 | 2020-08-01 | Oklahoma | Oklahoma | 40109 | 9214 | 98 |
394552 | 394552 | 2020-08-02 | Oklahoma | Oklahoma | 40109 | 9357 | 98 |
397769 | 397769 | 2020-08-03 | Oklahoma | Oklahoma | 40109 | 9439 | 98 |
400984 | 400984 | 2020-08-04 | Oklahoma | Oklahoma | 40109 | 9593 | 102 |
404202 | 404202 | 2020-08-05 | Oklahoma | Oklahoma | 40109 | 9950 | 107 |
407421 | 407421 | 2020-08-06 | Oklahoma | Oklahoma | 40109 | 10113 | 109 |
410641 | 410641 | 2020-08-07 | Oklahoma | Oklahoma | 40109 | 10300 | 112 |
413861 | 413861 | 2020-08-08 | Oklahoma | Oklahoma | 40109 | 10424 | 112 |
417082 | 417082 | 2020-08-09 | Oklahoma | Oklahoma | 40109 | 10560 | 112 |
420302 | 420302 | 2020-08-10 | Oklahoma | Oklahoma | 40109 | 10665 | 112 |
423525 | 423525 | 2020-08-11 | Oklahoma | Oklahoma | 40109 | 10794 | 115 |
426748 | 426748 | 2020-08-12 | Oklahoma | Oklahoma | 40109 | 10951 | 119 |
429973 | 429973 | 2020-08-13 | Oklahoma | Oklahoma | 40109 | 11148 | 121 |
433199 | 433199 | 2020-08-14 | Oklahoma | Oklahoma | 40109 | 11312 | 124 |
436425 | 436425 | 2020-08-15 | Oklahoma | Oklahoma | 40109 | 11458 | 129 |
439650 | 439650 | 2020-08-16 | Oklahoma | Oklahoma | 40109 | 11600 | 131 |
442877 | 442877 | 2020-08-17 | Oklahoma | Oklahoma | 40109 | 11715 | 132 |
446103 | 446103 | 2020-08-18 | Oklahoma | Oklahoma | 40109 | 11801 | 132 |
449331 | 449331 | 2020-08-19 | Oklahoma | Oklahoma | 40109 | 11921 | 135 |
452559 | 452559 | 2020-08-20 | Oklahoma | Oklahoma | 40109 | 12037 | 139 |
455787 | 455787 | 2020-08-21 | Oklahoma | Oklahoma | 40109 | 12328 | 139 |
459015 | 459015 | 2020-08-22 | Oklahoma | Oklahoma | 40109 | 12515 | 142 |
462243 | 462243 | 2020-08-23 | Oklahoma | Oklahoma | 40109 | 12584 | 143 |
465472 | 465472 | 2020-08-24 | Oklahoma | Oklahoma | 40109 | 12651 | 144 |
468700 | 468700 | 2020-08-25 | Oklahoma | Oklahoma | 40109 | 12765 | 145 |
471932 | 471932 | 2020-08-26 | Oklahoma | Oklahoma | 40109 | 12870 | 148 |
475166 | 475166 | 2020-08-27 | Oklahoma | Oklahoma | 40109 | 12974 | 150 |
478399 | 478399 | 2020-08-28 | Oklahoma | Oklahoma | 40109 | 13144 | 153 |
481633 | 481633 | 2020-08-29 | Oklahoma | Oklahoma | 40109 | 13254 | 154 |
484868 | 484868 | 2020-08-30 | Oklahoma | Oklahoma | 40109 | 13357 | 155 |
488101 | 488101 | 2020-08-31 | Oklahoma | Oklahoma | 40109 | 13436 | 154 |
491334 | 491334 | 2020-09-01 | Oklahoma | Oklahoma | 40109 | 13566 | 154 |
494568 | 494568 | 2020-09-02 | Oklahoma | Oklahoma | 40109 | 13689 | 156 |
497801 | 497801 | 2020-09-03 | Oklahoma | Oklahoma | 40109 | 13791 | 158 |
501035 | 501035 | 2020-09-04 | Oklahoma | Oklahoma | 40109 | 13923 | 163 |
504269 | 504269 | 2020-09-05 | Oklahoma | Oklahoma | 40109 | 14107 | 165 |
507501 | 507501 | 2020-09-06 | Oklahoma | Oklahoma | 40109 | 14165 | 168 |
510734 | 510734 | 2020-09-07 | Oklahoma | Oklahoma | 40109 | 14272 | 168 |
513967 | 513967 | 2020-09-08 | Oklahoma | Oklahoma | 40109 | 14416 | 168 |
517202 | 517202 | 2020-09-09 | Oklahoma | Oklahoma | 40109 | 14543 | 168 |
520438 | 520438 | 2020-09-10 | Oklahoma | Oklahoma | 40109 | 14713 | 171 |
523674 | 523674 | 2020-09-11 | Oklahoma | Oklahoma | 40109 | 14872 | 173 |
526910 | 526910 | 2020-09-12 | Oklahoma | Oklahoma | 40109 | 15021 | 174 |
530147 | 530147 | 2020-09-13 | Oklahoma | Oklahoma | 40109 | 15178 | 175 |
533382 | 533382 | 2020-09-14 | Oklahoma | Oklahoma | 40109 | 15293 | 175 |
536618 | 536618 | 2020-09-15 | Oklahoma | Oklahoma | 40109 | 15517 | 176 |
539855 | 539855 | 2020-09-16 | Oklahoma | Oklahoma | 40109 | 15694 | 178 |
543091 | 543091 | 2020-09-17 | Oklahoma | Oklahoma | 40109 | 15859 | 178 |
546328 | 546328 | 2020-09-18 | Oklahoma | Oklahoma | 40109 | 16177 | 180 |
549567 | 549567 | 2020-09-19 | Oklahoma | Oklahoma | 40109 | 16435 | 180 |
552806 | 552806 | 2020-09-20 | Oklahoma | Oklahoma | 40109 | 16560 | 182 |
556043 | 556043 | 2020-09-21 | Oklahoma | Oklahoma | 40109 | 16749 | 183 |
559280 | 559280 | 2020-09-22 | Oklahoma | Oklahoma | 40109 | 16961 | 185 |
562517 | 562517 | 2020-09-23 | Oklahoma | Oklahoma | 40109 | 17135 | 186 |
565758 | 565758 | 2020-09-24 | Oklahoma | Oklahoma | 40109 | 17319 | 188 |
568999 | 568999 | 2020-09-25 | Oklahoma | Oklahoma | 40109 | 17556 | 190 |
572241 | 572241 | 2020-09-26 | Oklahoma | Oklahoma | 40109 | 17711 | 194 |
575485 | 575485 | 2020-09-27 | Oklahoma | Oklahoma | 40109 | 17869 | 194 |
578726 | 578726 | 2020-09-28 | Oklahoma | Oklahoma | 40109 | 18018 | 194 |
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);