ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 40037 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637050 | 637050 | 2020-10-16 | Creek | Oklahoma | 40037 | 1426 | 36 |
633804 | 633804 | 2020-10-15 | Creek | Oklahoma | 40037 | 1413 | 36 |
630559 | 630559 | 2020-10-14 | Creek | Oklahoma | 40037 | 1407 | 36 |
627315 | 627315 | 2020-10-13 | Creek | Oklahoma | 40037 | 1381 | 35 |
624073 | 624073 | 2020-10-12 | Creek | Oklahoma | 40037 | 1359 | 35 |
620830 | 620830 | 2020-10-11 | Creek | Oklahoma | 40037 | 1348 | 35 |
617588 | 617588 | 2020-10-10 | Creek | Oklahoma | 40037 | 1340 | 35 |
614346 | 614346 | 2020-10-09 | Creek | Oklahoma | 40037 | 1325 | 35 |
611105 | 611105 | 2020-10-08 | Creek | Oklahoma | 40037 | 1305 | 35 |
607863 | 607863 | 2020-10-07 | Creek | Oklahoma | 40037 | 1296 | 35 |
604620 | 604620 | 2020-10-06 | Creek | Oklahoma | 40037 | 1280 | 35 |
601378 | 601378 | 2020-10-05 | Creek | Oklahoma | 40037 | 1258 | 34 |
598135 | 598135 | 2020-10-04 | Creek | Oklahoma | 40037 | 1252 | 34 |
594892 | 594892 | 2020-10-03 | Creek | Oklahoma | 40037 | 1238 | 34 |
591651 | 591651 | 2020-10-02 | Creek | Oklahoma | 40037 | 1216 | 34 |
588410 | 588410 | 2020-10-01 | Creek | Oklahoma | 40037 | 1199 | 34 |
585170 | 585170 | 2020-09-30 | Creek | Oklahoma | 40037 | 1185 | 34 |
581930 | 581930 | 2020-09-29 | Creek | Oklahoma | 40037 | 1175 | 34 |
578690 | 578690 | 2020-09-28 | Creek | Oklahoma | 40037 | 1157 | 33 |
575449 | 575449 | 2020-09-27 | Creek | Oklahoma | 40037 | 1145 | 33 |
572205 | 572205 | 2020-09-26 | Creek | Oklahoma | 40037 | 1138 | 33 |
568963 | 568963 | 2020-09-25 | Creek | Oklahoma | 40037 | 1121 | 33 |
565722 | 565722 | 2020-09-24 | Creek | Oklahoma | 40037 | 1109 | 33 |
562481 | 562481 | 2020-09-23 | Creek | Oklahoma | 40037 | 1095 | 33 |
559244 | 559244 | 2020-09-22 | Creek | Oklahoma | 40037 | 1083 | 32 |
556007 | 556007 | 2020-09-21 | Creek | Oklahoma | 40037 | 1067 | 30 |
552770 | 552770 | 2020-09-20 | Creek | Oklahoma | 40037 | 1061 | 30 |
549531 | 549531 | 2020-09-19 | Creek | Oklahoma | 40037 | 1051 | 30 |
546292 | 546292 | 2020-09-18 | Creek | Oklahoma | 40037 | 1032 | 29 |
543055 | 543055 | 2020-09-17 | Creek | Oklahoma | 40037 | 1017 | 29 |
539819 | 539819 | 2020-09-16 | Creek | Oklahoma | 40037 | 1011 | 29 |
536582 | 536582 | 2020-09-15 | Creek | Oklahoma | 40037 | 993 | 29 |
533346 | 533346 | 2020-09-14 | Creek | Oklahoma | 40037 | 974 | 28 |
530111 | 530111 | 2020-09-13 | Creek | Oklahoma | 40037 | 968 | 28 |
526874 | 526874 | 2020-09-12 | Creek | Oklahoma | 40037 | 964 | 27 |
523638 | 523638 | 2020-09-11 | Creek | Oklahoma | 40037 | 945 | 25 |
520402 | 520402 | 2020-09-10 | Creek | Oklahoma | 40037 | 925 | 25 |
517166 | 517166 | 2020-09-09 | Creek | Oklahoma | 40037 | 919 | 23 |
513931 | 513931 | 2020-09-08 | Creek | Oklahoma | 40037 | 904 | 22 |
510698 | 510698 | 2020-09-07 | Creek | Oklahoma | 40037 | 890 | 22 |
507465 | 507465 | 2020-09-06 | Creek | Oklahoma | 40037 | 884 | 22 |
504233 | 504233 | 2020-09-05 | Creek | Oklahoma | 40037 | 877 | 22 |
500999 | 500999 | 2020-09-04 | Creek | Oklahoma | 40037 | 860 | 22 |
497765 | 497765 | 2020-09-03 | Creek | Oklahoma | 40037 | 846 | 22 |
494532 | 494532 | 2020-09-02 | Creek | Oklahoma | 40037 | 836 | 22 |
491298 | 491298 | 2020-09-01 | Creek | Oklahoma | 40037 | 828 | 21 |
488065 | 488065 | 2020-08-31 | Creek | Oklahoma | 40037 | 812 | 21 |
484832 | 484832 | 2020-08-30 | Creek | Oklahoma | 40037 | 803 | 21 |
481597 | 481597 | 2020-08-29 | Creek | Oklahoma | 40037 | 796 | 21 |
478363 | 478363 | 2020-08-28 | Creek | Oklahoma | 40037 | 779 | 21 |
475130 | 475130 | 2020-08-27 | Creek | Oklahoma | 40037 | 769 | 21 |
471896 | 471896 | 2020-08-26 | Creek | Oklahoma | 40037 | 765 | 20 |
468664 | 468664 | 2020-08-25 | Creek | Oklahoma | 40037 | 758 | 19 |
465436 | 465436 | 2020-08-24 | Creek | Oklahoma | 40037 | 746 | 19 |
462207 | 462207 | 2020-08-23 | Creek | Oklahoma | 40037 | 745 | 19 |
458979 | 458979 | 2020-08-22 | Creek | Oklahoma | 40037 | 745 | 19 |
455751 | 455751 | 2020-08-21 | Creek | Oklahoma | 40037 | 735 | 19 |
452523 | 452523 | 2020-08-20 | Creek | Oklahoma | 40037 | 721 | 19 |
449295 | 449295 | 2020-08-19 | Creek | Oklahoma | 40037 | 711 | 19 |
446067 | 446067 | 2020-08-18 | Creek | Oklahoma | 40037 | 705 | 18 |
442841 | 442841 | 2020-08-17 | Creek | Oklahoma | 40037 | 681 | 15 |
439614 | 439614 | 2020-08-16 | Creek | Oklahoma | 40037 | 681 | 15 |
436389 | 436389 | 2020-08-15 | Creek | Oklahoma | 40037 | 678 | 15 |
433163 | 433163 | 2020-08-14 | Creek | Oklahoma | 40037 | 663 | 15 |
429937 | 429937 | 2020-08-13 | Creek | Oklahoma | 40037 | 657 | 15 |
426712 | 426712 | 2020-08-12 | Creek | Oklahoma | 40037 | 637 | 15 |
423489 | 423489 | 2020-08-11 | Creek | Oklahoma | 40037 | 621 | 14 |
420266 | 420266 | 2020-08-10 | Creek | Oklahoma | 40037 | 607 | 14 |
417046 | 417046 | 2020-08-09 | Creek | Oklahoma | 40037 | 596 | 14 |
413825 | 413825 | 2020-08-08 | Creek | Oklahoma | 40037 | 588 | 14 |
410605 | 410605 | 2020-08-07 | Creek | Oklahoma | 40037 | 580 | 14 |
407385 | 407385 | 2020-08-06 | Creek | Oklahoma | 40037 | 552 | 13 |
404166 | 404166 | 2020-08-05 | Creek | Oklahoma | 40037 | 536 | 13 |
400948 | 400948 | 2020-08-04 | Creek | Oklahoma | 40037 | 510 | 13 |
397733 | 397733 | 2020-08-03 | Creek | Oklahoma | 40037 | 500 | 13 |
394516 | 394516 | 2020-08-02 | Creek | Oklahoma | 40037 | 493 | 13 |
391300 | 391300 | 2020-08-01 | Creek | Oklahoma | 40037 | 495 | 13 |
388083 | 388083 | 2020-07-31 | Creek | Oklahoma | 40037 | 473 | 13 |
384866 | 384866 | 2020-07-30 | Creek | Oklahoma | 40037 | 468 | 12 |
381648 | 381648 | 2020-07-29 | Creek | Oklahoma | 40037 | 441 | 12 |
378431 | 378431 | 2020-07-28 | Creek | Oklahoma | 40037 | 429 | 12 |
375214 | 375214 | 2020-07-27 | Creek | Oklahoma | 40037 | 410 | 12 |
372002 | 372002 | 2020-07-26 | Creek | Oklahoma | 40037 | 388 | 12 |
368790 | 368790 | 2020-07-25 | Creek | Oklahoma | 40037 | 341 | 12 |
365581 | 365581 | 2020-07-24 | Creek | Oklahoma | 40037 | 321 | 10 |
362375 | 362375 | 2020-07-23 | Creek | Oklahoma | 40037 | 308 | 9 |
359169 | 359169 | 2020-07-22 | Creek | Oklahoma | 40037 | 299 | 9 |
355965 | 355965 | 2020-07-21 | Creek | Oklahoma | 40037 | 287 | 9 |
352762 | 352762 | 2020-07-20 | Creek | Oklahoma | 40037 | 272 | 9 |
349559 | 349559 | 2020-07-19 | Creek | Oklahoma | 40037 | 269 | 9 |
346359 | 346359 | 2020-07-18 | Creek | Oklahoma | 40037 | 267 | 9 |
343159 | 343159 | 2020-07-17 | Creek | Oklahoma | 40037 | 247 | 9 |
339961 | 339961 | 2020-07-16 | Creek | Oklahoma | 40037 | 233 | 9 |
336765 | 336765 | 2020-07-15 | Creek | Oklahoma | 40037 | 231 | 9 |
333571 | 333571 | 2020-07-14 | Creek | Oklahoma | 40037 | 223 | 8 |
330379 | 330379 | 2020-07-13 | Creek | Oklahoma | 40037 | 217 | 8 |
327192 | 327192 | 2020-07-12 | Creek | Oklahoma | 40037 | 212 | 8 |
324007 | 324007 | 2020-07-11 | Creek | Oklahoma | 40037 | 210 | 8 |
320827 | 320827 | 2020-07-10 | Creek | Oklahoma | 40037 | 204 | 7 |
317650 | 317650 | 2020-07-09 | Creek | Oklahoma | 40037 | 201 | 7 |
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);