ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Tulsa" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637103 | 637103 | 2020-10-16 | Tulsa | Oklahoma | 40143 | 20102 | 183 |
633857 | 633857 | 2020-10-15 | Tulsa | Oklahoma | 40143 | 19888 | 182 |
630612 | 630612 | 2020-10-14 | Tulsa | Oklahoma | 40143 | 19657 | 182 |
627368 | 627368 | 2020-10-13 | Tulsa | Oklahoma | 40143 | 19473 | 180 |
624126 | 624126 | 2020-10-12 | Tulsa | Oklahoma | 40143 | 19255 | 178 |
620883 | 620883 | 2020-10-11 | Tulsa | Oklahoma | 40143 | 19138 | 176 |
617641 | 617641 | 2020-10-10 | Tulsa | Oklahoma | 40143 | 19064 | 176 |
614399 | 614399 | 2020-10-09 | Tulsa | Oklahoma | 40143 | 18812 | 176 |
611158 | 611158 | 2020-10-08 | Tulsa | Oklahoma | 40143 | 18484 | 175 |
607916 | 607916 | 2020-10-07 | Tulsa | Oklahoma | 40143 | 18305 | 172 |
604673 | 604673 | 2020-10-06 | Tulsa | Oklahoma | 40143 | 18182 | 171 |
601431 | 601431 | 2020-10-05 | Tulsa | Oklahoma | 40143 | 17949 | 169 |
598188 | 598188 | 2020-10-04 | Tulsa | Oklahoma | 40143 | 17869 | 168 |
594945 | 594945 | 2020-10-03 | Tulsa | Oklahoma | 40143 | 17820 | 168 |
591704 | 591704 | 2020-10-02 | Tulsa | Oklahoma | 40143 | 17632 | 167 |
588463 | 588463 | 2020-10-01 | Tulsa | Oklahoma | 40143 | 17482 | 166 |
585223 | 585223 | 2020-09-30 | Tulsa | Oklahoma | 40143 | 17324 | 166 |
581983 | 581983 | 2020-09-29 | Tulsa | Oklahoma | 40143 | 17207 | 162 |
578743 | 578743 | 2020-09-28 | Tulsa | Oklahoma | 40143 | 17004 | 160 |
575502 | 575502 | 2020-09-27 | Tulsa | Oklahoma | 40143 | 16887 | 160 |
572258 | 572258 | 2020-09-26 | Tulsa | Oklahoma | 40143 | 16793 | 160 |
569016 | 569016 | 2020-09-25 | Tulsa | Oklahoma | 40143 | 16683 | 159 |
565775 | 565775 | 2020-09-24 | Tulsa | Oklahoma | 40143 | 16487 | 156 |
562534 | 562534 | 2020-09-23 | Tulsa | Oklahoma | 40143 | 16363 | 155 |
559297 | 559297 | 2020-09-22 | Tulsa | Oklahoma | 40143 | 16207 | 153 |
556060 | 556060 | 2020-09-21 | Tulsa | Oklahoma | 40143 | 16034 | 152 |
552823 | 552823 | 2020-09-20 | Tulsa | Oklahoma | 40143 | 15975 | 152 |
549584 | 549584 | 2020-09-19 | Tulsa | Oklahoma | 40143 | 15905 | 152 |
546345 | 546345 | 2020-09-18 | Tulsa | Oklahoma | 40143 | 15794 | 152 |
543108 | 543108 | 2020-09-17 | Tulsa | Oklahoma | 40143 | 15654 | 151 |
539872 | 539872 | 2020-09-16 | Tulsa | Oklahoma | 40143 | 15469 | 149 |
536635 | 536635 | 2020-09-15 | Tulsa | Oklahoma | 40143 | 15358 | 147 |
533399 | 533399 | 2020-09-14 | Tulsa | Oklahoma | 40143 | 15202 | 144 |
530164 | 530164 | 2020-09-13 | Tulsa | Oklahoma | 40143 | 15146 | 144 |
526927 | 526927 | 2020-09-12 | Tulsa | Oklahoma | 40143 | 15048 | 144 |
523691 | 523691 | 2020-09-11 | Tulsa | Oklahoma | 40143 | 14891 | 144 |
520455 | 520455 | 2020-09-10 | Tulsa | Oklahoma | 40143 | 14764 | 143 |
517219 | 517219 | 2020-09-09 | Tulsa | Oklahoma | 40143 | 14655 | 143 |
513984 | 513984 | 2020-09-08 | Tulsa | Oklahoma | 40143 | 14473 | 140 |
510751 | 510751 | 2020-09-07 | Tulsa | Oklahoma | 40143 | 14271 | 139 |
507518 | 507518 | 2020-09-06 | Tulsa | Oklahoma | 40143 | 14183 | 139 |
504286 | 504286 | 2020-09-05 | Tulsa | Oklahoma | 40143 | 14123 | 139 |
501052 | 501052 | 2020-09-04 | Tulsa | Oklahoma | 40143 | 13923 | 137 |
497818 | 497818 | 2020-09-03 | Tulsa | Oklahoma | 40143 | 13742 | 136 |
494585 | 494585 | 2020-09-02 | Tulsa | Oklahoma | 40143 | 13557 | 135 |
491351 | 491351 | 2020-09-01 | Tulsa | Oklahoma | 40143 | 13376 | 134 |
488118 | 488118 | 2020-08-31 | Tulsa | Oklahoma | 40143 | 13233 | 132 |
484885 | 484885 | 2020-08-30 | Tulsa | Oklahoma | 40143 | 13175 | 132 |
481650 | 481650 | 2020-08-29 | Tulsa | Oklahoma | 40143 | 13104 | 132 |
478416 | 478416 | 2020-08-28 | Tulsa | Oklahoma | 40143 | 12941 | 129 |
475183 | 475183 | 2020-08-27 | Tulsa | Oklahoma | 40143 | 12831 | 128 |
471949 | 471949 | 2020-08-26 | Tulsa | Oklahoma | 40143 | 12714 | 128 |
468717 | 468717 | 2020-08-25 | Tulsa | Oklahoma | 40143 | 12559 | 127 |
465489 | 465489 | 2020-08-24 | Tulsa | Oklahoma | 40143 | 12391 | 126 |
462260 | 462260 | 2020-08-23 | Tulsa | Oklahoma | 40143 | 12312 | 125 |
459032 | 459032 | 2020-08-22 | Tulsa | Oklahoma | 40143 | 12253 | 125 |
455804 | 455804 | 2020-08-21 | Tulsa | Oklahoma | 40143 | 12095 | 123 |
452576 | 452576 | 2020-08-20 | Tulsa | Oklahoma | 40143 | 11873 | 123 |
449348 | 449348 | 2020-08-19 | Tulsa | Oklahoma | 40143 | 11763 | 122 |
446120 | 446120 | 2020-08-18 | Tulsa | Oklahoma | 40143 | 11614 | 120 |
442894 | 442894 | 2020-08-17 | Tulsa | Oklahoma | 40143 | 11443 | 116 |
439667 | 439667 | 2020-08-16 | Tulsa | Oklahoma | 40143 | 11375 | 114 |
436442 | 436442 | 2020-08-15 | Tulsa | Oklahoma | 40143 | 11312 | 113 |
433216 | 433216 | 2020-08-14 | Tulsa | Oklahoma | 40143 | 11130 | 113 |
429990 | 429990 | 2020-08-13 | Tulsa | Oklahoma | 40143 | 10999 | 113 |
426765 | 426765 | 2020-08-12 | Tulsa | Oklahoma | 40143 | 10898 | 110 |
423542 | 423542 | 2020-08-11 | Tulsa | Oklahoma | 40143 | 10747 | 108 |
420319 | 420319 | 2020-08-10 | Tulsa | Oklahoma | 40143 | 10562 | 107 |
417099 | 417099 | 2020-08-09 | Tulsa | Oklahoma | 40143 | 10465 | 107 |
413878 | 413878 | 2020-08-08 | Tulsa | Oklahoma | 40143 | 10389 | 107 |
410658 | 410658 | 2020-08-07 | Tulsa | Oklahoma | 40143 | 10135 | 106 |
407438 | 407438 | 2020-08-06 | Tulsa | Oklahoma | 40143 | 9969 | 105 |
404219 | 404219 | 2020-08-05 | Tulsa | Oklahoma | 40143 | 9742 | 103 |
401001 | 401001 | 2020-08-04 | Tulsa | Oklahoma | 40143 | 9418 | 101 |
397786 | 397786 | 2020-08-03 | Tulsa | Oklahoma | 40143 | 9159 | 101 |
394569 | 394569 | 2020-08-02 | Tulsa | Oklahoma | 40143 | 9051 | 101 |
391353 | 391353 | 2020-08-01 | Tulsa | Oklahoma | 40143 | 8986 | 101 |
388136 | 388136 | 2020-07-31 | Tulsa | Oklahoma | 40143 | 8710 | 98 |
384919 | 384919 | 2020-07-30 | Tulsa | Oklahoma | 40143 | 8636 | 98 |
381701 | 381701 | 2020-07-29 | Tulsa | Oklahoma | 40143 | 8319 | 94 |
378484 | 378484 | 2020-07-28 | Tulsa | Oklahoma | 40143 | 8177 | 93 |
375267 | 375267 | 2020-07-27 | Tulsa | Oklahoma | 40143 | 7912 | 90 |
372055 | 372055 | 2020-07-26 | Tulsa | Oklahoma | 40143 | 7557 | 90 |
368843 | 368843 | 2020-07-25 | Tulsa | Oklahoma | 40143 | 7307 | 90 |
365634 | 365634 | 2020-07-24 | Tulsa | Oklahoma | 40143 | 7111 | 89 |
362428 | 362428 | 2020-07-23 | Tulsa | Oklahoma | 40143 | 6856 | 89 |
359222 | 359222 | 2020-07-22 | Tulsa | Oklahoma | 40143 | 6744 | 89 |
356018 | 356018 | 2020-07-21 | Tulsa | Oklahoma | 40143 | 6536 | 86 |
352815 | 352815 | 2020-07-20 | Tulsa | Oklahoma | 40143 | 6316 | 85 |
349612 | 349612 | 2020-07-19 | Tulsa | Oklahoma | 40143 | 6285 | 84 |
346412 | 346412 | 2020-07-18 | Tulsa | Oklahoma | 40143 | 6243 | 84 |
343212 | 343212 | 2020-07-17 | Tulsa | Oklahoma | 40143 | 5997 | 83 |
340013 | 340013 | 2020-07-16 | Tulsa | Oklahoma | 40143 | 5790 | 81 |
336817 | 336817 | 2020-07-15 | Tulsa | Oklahoma | 40143 | 5626 | 79 |
333623 | 333623 | 2020-07-14 | Tulsa | Oklahoma | 40143 | 5448 | 78 |
330431 | 330431 | 2020-07-13 | Tulsa | Oklahoma | 40143 | 5267 | 76 |
327245 | 327245 | 2020-07-12 | Tulsa | Oklahoma | 40143 | 5099 | 75 |
324060 | 324060 | 2020-07-11 | Tulsa | Oklahoma | 40143 | 5005 | 75 |
320880 | 320880 | 2020-07-10 | Tulsa | Oklahoma | 40143 | 4828 | 75 |
317702 | 317702 | 2020-07-09 | Tulsa | Oklahoma | 40143 | 4693 | 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);