ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Wagoner" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637105 | 637105 | 2020-10-16 | Wagoner | Oklahoma | 40145 | 1731 | 27 |
633859 | 633859 | 2020-10-15 | Wagoner | Oklahoma | 40145 | 1722 | 27 |
630614 | 630614 | 2020-10-14 | Wagoner | Oklahoma | 40145 | 1711 | 27 |
627370 | 627370 | 2020-10-13 | Wagoner | Oklahoma | 40145 | 1692 | 27 |
624128 | 624128 | 2020-10-12 | Wagoner | Oklahoma | 40145 | 1658 | 27 |
620885 | 620885 | 2020-10-11 | Wagoner | Oklahoma | 40145 | 1652 | 27 |
617643 | 617643 | 2020-10-10 | Wagoner | Oklahoma | 40145 | 1649 | 27 |
614401 | 614401 | 2020-10-09 | Wagoner | Oklahoma | 40145 | 1629 | 26 |
611160 | 611160 | 2020-10-08 | Wagoner | Oklahoma | 40145 | 1614 | 26 |
607918 | 607918 | 2020-10-07 | Wagoner | Oklahoma | 40145 | 1604 | 26 |
604675 | 604675 | 2020-10-06 | Wagoner | Oklahoma | 40145 | 1588 | 26 |
601433 | 601433 | 2020-10-05 | Wagoner | Oklahoma | 40145 | 1564 | 26 |
598190 | 598190 | 2020-10-04 | Wagoner | Oklahoma | 40145 | 1555 | 26 |
594947 | 594947 | 2020-10-03 | Wagoner | Oklahoma | 40145 | 1555 | 26 |
591706 | 591706 | 2020-10-02 | Wagoner | Oklahoma | 40145 | 1531 | 26 |
588465 | 588465 | 2020-10-01 | Wagoner | Oklahoma | 40145 | 1519 | 26 |
585225 | 585225 | 2020-09-30 | Wagoner | Oklahoma | 40145 | 1508 | 26 |
581985 | 581985 | 2020-09-29 | Wagoner | Oklahoma | 40145 | 1498 | 26 |
578745 | 578745 | 2020-09-28 | Wagoner | Oklahoma | 40145 | 1481 | 26 |
575504 | 575504 | 2020-09-27 | Wagoner | Oklahoma | 40145 | 1476 | 26 |
572260 | 572260 | 2020-09-26 | Wagoner | Oklahoma | 40145 | 1467 | 26 |
569018 | 569018 | 2020-09-25 | Wagoner | Oklahoma | 40145 | 1455 | 26 |
565777 | 565777 | 2020-09-24 | Wagoner | Oklahoma | 40145 | 1441 | 26 |
562536 | 562536 | 2020-09-23 | Wagoner | Oklahoma | 40145 | 1430 | 26 |
559299 | 559299 | 2020-09-22 | Wagoner | Oklahoma | 40145 | 1422 | 26 |
556062 | 556062 | 2020-09-21 | Wagoner | Oklahoma | 40145 | 1398 | 24 |
552825 | 552825 | 2020-09-20 | Wagoner | Oklahoma | 40145 | 1390 | 24 |
549586 | 549586 | 2020-09-19 | Wagoner | Oklahoma | 40145 | 1388 | 24 |
546347 | 546347 | 2020-09-18 | Wagoner | Oklahoma | 40145 | 1379 | 23 |
543110 | 543110 | 2020-09-17 | Wagoner | Oklahoma | 40145 | 1364 | 23 |
539874 | 539874 | 2020-09-16 | Wagoner | Oklahoma | 40145 | 1353 | 23 |
536637 | 536637 | 2020-09-15 | Wagoner | Oklahoma | 40145 | 1342 | 23 |
533401 | 533401 | 2020-09-14 | Wagoner | Oklahoma | 40145 | 1327 | 23 |
530166 | 530166 | 2020-09-13 | Wagoner | Oklahoma | 40145 | 1316 | 23 |
526929 | 526929 | 2020-09-12 | Wagoner | Oklahoma | 40145 | 1308 | 23 |
523693 | 523693 | 2020-09-11 | Wagoner | Oklahoma | 40145 | 1300 | 23 |
520457 | 520457 | 2020-09-10 | Wagoner | Oklahoma | 40145 | 1290 | 23 |
517221 | 517221 | 2020-09-09 | Wagoner | Oklahoma | 40145 | 1270 | 23 |
513986 | 513986 | 2020-09-08 | Wagoner | Oklahoma | 40145 | 1250 | 23 |
510753 | 510753 | 2020-09-07 | Wagoner | Oklahoma | 40145 | 1228 | 23 |
507520 | 507520 | 2020-09-06 | Wagoner | Oklahoma | 40145 | 1222 | 23 |
504288 | 504288 | 2020-09-05 | Wagoner | Oklahoma | 40145 | 1214 | 23 |
501054 | 501054 | 2020-09-04 | Wagoner | Oklahoma | 40145 | 1200 | 23 |
497820 | 497820 | 2020-09-03 | Wagoner | Oklahoma | 40145 | 1188 | 23 |
494587 | 494587 | 2020-09-02 | Wagoner | Oklahoma | 40145 | 1179 | 23 |
491353 | 491353 | 2020-09-01 | Wagoner | Oklahoma | 40145 | 1164 | 23 |
488120 | 488120 | 2020-08-31 | Wagoner | Oklahoma | 40145 | 1147 | 23 |
484887 | 484887 | 2020-08-30 | Wagoner | Oklahoma | 40145 | 1137 | 23 |
481652 | 481652 | 2020-08-29 | Wagoner | Oklahoma | 40145 | 1127 | 23 |
478418 | 478418 | 2020-08-28 | Wagoner | Oklahoma | 40145 | 1114 | 23 |
475185 | 475185 | 2020-08-27 | Wagoner | Oklahoma | 40145 | 1102 | 23 |
471951 | 471951 | 2020-08-26 | Wagoner | Oklahoma | 40145 | 1086 | 23 |
468719 | 468719 | 2020-08-25 | Wagoner | Oklahoma | 40145 | 1075 | 23 |
465491 | 465491 | 2020-08-24 | Wagoner | Oklahoma | 40145 | 1056 | 23 |
462262 | 462262 | 2020-08-23 | Wagoner | Oklahoma | 40145 | 1052 | 23 |
459034 | 459034 | 2020-08-22 | Wagoner | Oklahoma | 40145 | 1051 | 23 |
455806 | 455806 | 2020-08-21 | Wagoner | Oklahoma | 40145 | 1034 | 23 |
452578 | 452578 | 2020-08-20 | Wagoner | Oklahoma | 40145 | 1003 | 23 |
449350 | 449350 | 2020-08-19 | Wagoner | Oklahoma | 40145 | 996 | 23 |
446122 | 446122 | 2020-08-18 | Wagoner | Oklahoma | 40145 | 981 | 23 |
442896 | 442896 | 2020-08-17 | Wagoner | Oklahoma | 40145 | 968 | 23 |
439669 | 439669 | 2020-08-16 | Wagoner | Oklahoma | 40145 | 960 | 23 |
436444 | 436444 | 2020-08-15 | Wagoner | Oklahoma | 40145 | 954 | 23 |
433217 | 433217 | 2020-08-14 | Wagoner | Oklahoma | 40145 | 940 | 23 |
429991 | 429991 | 2020-08-13 | Wagoner | Oklahoma | 40145 | 922 | 23 |
426766 | 426766 | 2020-08-12 | Wagoner | Oklahoma | 40145 | 903 | 23 |
423543 | 423543 | 2020-08-11 | Wagoner | Oklahoma | 40145 | 890 | 23 |
420320 | 420320 | 2020-08-10 | Wagoner | Oklahoma | 40145 | 864 | 23 |
417100 | 417100 | 2020-08-09 | Wagoner | Oklahoma | 40145 | 860 | 23 |
413879 | 413879 | 2020-08-08 | Wagoner | Oklahoma | 40145 | 848 | 23 |
410659 | 410659 | 2020-08-07 | Wagoner | Oklahoma | 40145 | 825 | 23 |
407439 | 407439 | 2020-08-06 | Wagoner | Oklahoma | 40145 | 805 | 23 |
404220 | 404220 | 2020-08-05 | Wagoner | Oklahoma | 40145 | 787 | 22 |
401002 | 401002 | 2020-08-04 | Wagoner | Oklahoma | 40145 | 762 | 22 |
397787 | 397787 | 2020-08-03 | Wagoner | Oklahoma | 40145 | 738 | 22 |
394570 | 394570 | 2020-08-02 | Wagoner | Oklahoma | 40145 | 733 | 22 |
391354 | 391354 | 2020-08-01 | Wagoner | Oklahoma | 40145 | 726 | 22 |
388137 | 388137 | 2020-07-31 | Wagoner | Oklahoma | 40145 | 686 | 22 |
384920 | 384920 | 2020-07-30 | Wagoner | Oklahoma | 40145 | 673 | 22 |
381702 | 381702 | 2020-07-29 | Wagoner | Oklahoma | 40145 | 640 | 22 |
378485 | 378485 | 2020-07-28 | Wagoner | Oklahoma | 40145 | 631 | 21 |
375269 | 375269 | 2020-07-27 | Wagoner | Oklahoma | 40145 | 606 | 20 |
372056 | 372056 | 2020-07-26 | Wagoner | Oklahoma | 40145 | 577 | 20 |
368844 | 368844 | 2020-07-25 | Wagoner | Oklahoma | 40145 | 562 | 20 |
365635 | 365635 | 2020-07-24 | Wagoner | Oklahoma | 40145 | 537 | 19 |
362429 | 362429 | 2020-07-23 | Wagoner | Oklahoma | 40145 | 516 | 19 |
359223 | 359223 | 2020-07-22 | Wagoner | Oklahoma | 40145 | 507 | 19 |
356019 | 356019 | 2020-07-21 | Wagoner | Oklahoma | 40145 | 488 | 19 |
352816 | 352816 | 2020-07-20 | Wagoner | Oklahoma | 40145 | 464 | 19 |
349613 | 349613 | 2020-07-19 | Wagoner | Oklahoma | 40145 | 460 | 19 |
346413 | 346413 | 2020-07-18 | Wagoner | Oklahoma | 40145 | 458 | 19 |
343213 | 343213 | 2020-07-17 | Wagoner | Oklahoma | 40145 | 440 | 19 |
340015 | 340015 | 2020-07-16 | Wagoner | Oklahoma | 40145 | 434 | 19 |
336818 | 336818 | 2020-07-15 | Wagoner | Oklahoma | 40145 | 410 | 19 |
333624 | 333624 | 2020-07-14 | Wagoner | Oklahoma | 40145 | 400 | 19 |
330432 | 330432 | 2020-07-13 | Wagoner | Oklahoma | 40145 | 376 | 19 |
327246 | 327246 | 2020-07-12 | Wagoner | Oklahoma | 40145 | 370 | 19 |
324061 | 324061 | 2020-07-11 | Wagoner | Oklahoma | 40145 | 366 | 19 |
320881 | 320881 | 2020-07-10 | Wagoner | Oklahoma | 40145 | 350 | 19 |
317703 | 317703 | 2020-07-09 | Wagoner | Oklahoma | 40145 | 344 | 19 |
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);