ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Osage" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637088 | 637088 | 2020-10-16 | Osage | Oklahoma | 40113 | 1285 | 13 |
633842 | 633842 | 2020-10-15 | Osage | Oklahoma | 40113 | 1266 | 13 |
630597 | 630597 | 2020-10-14 | Osage | Oklahoma | 40113 | 1252 | 13 |
627353 | 627353 | 2020-10-13 | Osage | Oklahoma | 40113 | 1251 | 13 |
624111 | 624111 | 2020-10-12 | Osage | Oklahoma | 40113 | 1235 | 13 |
620868 | 620868 | 2020-10-11 | Osage | Oklahoma | 40113 | 1222 | 13 |
617626 | 617626 | 2020-10-10 | Osage | Oklahoma | 40113 | 1222 | 13 |
614384 | 614384 | 2020-10-09 | Osage | Oklahoma | 40113 | 1206 | 13 |
611143 | 611143 | 2020-10-08 | Osage | Oklahoma | 40113 | 1193 | 13 |
607901 | 607901 | 2020-10-07 | Osage | Oklahoma | 40113 | 1183 | 13 |
604658 | 604658 | 2020-10-06 | Osage | Oklahoma | 40113 | 1168 | 13 |
601416 | 601416 | 2020-10-05 | Osage | Oklahoma | 40113 | 1140 | 13 |
598173 | 598173 | 2020-10-04 | Osage | Oklahoma | 40113 | 1134 | 13 |
594930 | 594930 | 2020-10-03 | Osage | Oklahoma | 40113 | 1132 | 13 |
591689 | 591689 | 2020-10-02 | Osage | Oklahoma | 40113 | 1118 | 13 |
588448 | 588448 | 2020-10-01 | Osage | Oklahoma | 40113 | 1015 | 13 |
585208 | 585208 | 2020-09-30 | Osage | Oklahoma | 40113 | 1006 | 13 |
581968 | 581968 | 2020-09-29 | Osage | Oklahoma | 40113 | 1000 | 13 |
578728 | 578728 | 2020-09-28 | Osage | Oklahoma | 40113 | 985 | 13 |
575487 | 575487 | 2020-09-27 | Osage | Oklahoma | 40113 | 906 | 13 |
572243 | 572243 | 2020-09-26 | Osage | Oklahoma | 40113 | 903 | 13 |
569001 | 569001 | 2020-09-25 | Osage | Oklahoma | 40113 | 836 | 13 |
565760 | 565760 | 2020-09-24 | Osage | Oklahoma | 40113 | 811 | 13 |
562519 | 562519 | 2020-09-23 | Osage | Oklahoma | 40113 | 804 | 13 |
559282 | 559282 | 2020-09-22 | Osage | Oklahoma | 40113 | 796 | 13 |
556045 | 556045 | 2020-09-21 | Osage | Oklahoma | 40113 | 784 | 13 |
552808 | 552808 | 2020-09-20 | Osage | Oklahoma | 40113 | 779 | 13 |
549569 | 549569 | 2020-09-19 | Osage | Oklahoma | 40113 | 771 | 13 |
546330 | 546330 | 2020-09-18 | Osage | Oklahoma | 40113 | 766 | 13 |
543093 | 543093 | 2020-09-17 | Osage | Oklahoma | 40113 | 755 | 13 |
539857 | 539857 | 2020-09-16 | Osage | Oklahoma | 40113 | 752 | 13 |
536620 | 536620 | 2020-09-15 | Osage | Oklahoma | 40113 | 744 | 13 |
533384 | 533384 | 2020-09-14 | Osage | Oklahoma | 40113 | 733 | 13 |
530149 | 530149 | 2020-09-13 | Osage | Oklahoma | 40113 | 730 | 13 |
526912 | 526912 | 2020-09-12 | Osage | Oklahoma | 40113 | 729 | 13 |
523676 | 523676 | 2020-09-11 | Osage | Oklahoma | 40113 | 724 | 13 |
520440 | 520440 | 2020-09-10 | Osage | Oklahoma | 40113 | 720 | 13 |
517204 | 517204 | 2020-09-09 | Osage | Oklahoma | 40113 | 718 | 12 |
513969 | 513969 | 2020-09-08 | Osage | Oklahoma | 40113 | 710 | 12 |
510736 | 510736 | 2020-09-07 | Osage | Oklahoma | 40113 | 704 | 12 |
507503 | 507503 | 2020-09-06 | Osage | Oklahoma | 40113 | 695 | 12 |
504271 | 504271 | 2020-09-05 | Osage | Oklahoma | 40113 | 684 | 12 |
501037 | 501037 | 2020-09-04 | Osage | Oklahoma | 40113 | 666 | 12 |
497803 | 497803 | 2020-09-03 | Osage | Oklahoma | 40113 | 657 | 12 |
494570 | 494570 | 2020-09-02 | Osage | Oklahoma | 40113 | 649 | 12 |
491336 | 491336 | 2020-09-01 | Osage | Oklahoma | 40113 | 647 | 12 |
488103 | 488103 | 2020-08-31 | Osage | Oklahoma | 40113 | 640 | 12 |
484870 | 484870 | 2020-08-30 | Osage | Oklahoma | 40113 | 636 | 12 |
481635 | 481635 | 2020-08-29 | Osage | Oklahoma | 40113 | 629 | 12 |
478401 | 478401 | 2020-08-28 | Osage | Oklahoma | 40113 | 614 | 12 |
475168 | 475168 | 2020-08-27 | Osage | Oklahoma | 40113 | 609 | 12 |
471934 | 471934 | 2020-08-26 | Osage | Oklahoma | 40113 | 608 | 12 |
468702 | 468702 | 2020-08-25 | Osage | Oklahoma | 40113 | 602 | 12 |
465474 | 465474 | 2020-08-24 | Osage | Oklahoma | 40113 | 600 | 12 |
462245 | 462245 | 2020-08-23 | Osage | Oklahoma | 40113 | 596 | 12 |
459017 | 459017 | 2020-08-22 | Osage | Oklahoma | 40113 | 594 | 12 |
455789 | 455789 | 2020-08-21 | Osage | Oklahoma | 40113 | 589 | 12 |
452561 | 452561 | 2020-08-20 | Osage | Oklahoma | 40113 | 582 | 12 |
449333 | 449333 | 2020-08-19 | Osage | Oklahoma | 40113 | 575 | 12 |
446105 | 446105 | 2020-08-18 | Osage | Oklahoma | 40113 | 573 | 12 |
442879 | 442879 | 2020-08-17 | Osage | Oklahoma | 40113 | 564 | 12 |
439652 | 439652 | 2020-08-16 | Osage | Oklahoma | 40113 | 558 | 12 |
436427 | 436427 | 2020-08-15 | Osage | Oklahoma | 40113 | 559 | 12 |
433201 | 433201 | 2020-08-14 | Osage | Oklahoma | 40113 | 456 | 12 |
429975 | 429975 | 2020-08-13 | Osage | Oklahoma | 40113 | 446 | 11 |
426750 | 426750 | 2020-08-12 | Osage | Oklahoma | 40113 | 436 | 11 |
423527 | 423527 | 2020-08-11 | Osage | Oklahoma | 40113 | 431 | 11 |
420304 | 420304 | 2020-08-10 | Osage | Oklahoma | 40113 | 426 | 11 |
417084 | 417084 | 2020-08-09 | Osage | Oklahoma | 40113 | 417 | 11 |
413863 | 413863 | 2020-08-08 | Osage | Oklahoma | 40113 | 404 | 11 |
410643 | 410643 | 2020-08-07 | Osage | Oklahoma | 40113 | 397 | 11 |
407423 | 407423 | 2020-08-06 | Osage | Oklahoma | 40113 | 391 | 11 |
404204 | 404204 | 2020-08-05 | Osage | Oklahoma | 40113 | 385 | 11 |
400986 | 400986 | 2020-08-04 | Osage | Oklahoma | 40113 | 376 | 11 |
397771 | 397771 | 2020-08-03 | Osage | Oklahoma | 40113 | 367 | 11 |
394554 | 394554 | 2020-08-02 | Osage | Oklahoma | 40113 | 366 | 11 |
391338 | 391338 | 2020-08-01 | Osage | Oklahoma | 40113 | 360 | 11 |
388121 | 388121 | 2020-07-31 | Osage | Oklahoma | 40113 | 351 | 11 |
384904 | 384904 | 2020-07-30 | Osage | Oklahoma | 40113 | 346 | 11 |
381686 | 381686 | 2020-07-29 | Osage | Oklahoma | 40113 | 340 | 11 |
378469 | 378469 | 2020-07-28 | Osage | Oklahoma | 40113 | 334 | 10 |
375252 | 375252 | 2020-07-27 | Osage | Oklahoma | 40113 | 325 | 10 |
372040 | 372040 | 2020-07-26 | Osage | Oklahoma | 40113 | 304 | 10 |
368828 | 368828 | 2020-07-25 | Osage | Oklahoma | 40113 | 284 | 10 |
365619 | 365619 | 2020-07-24 | Osage | Oklahoma | 40113 | 277 | 10 |
362413 | 362413 | 2020-07-23 | Osage | Oklahoma | 40113 | 270 | 9 |
359207 | 359207 | 2020-07-22 | Osage | Oklahoma | 40113 | 257 | 9 |
356003 | 356003 | 2020-07-21 | Osage | Oklahoma | 40113 | 252 | 9 |
352800 | 352800 | 2020-07-20 | Osage | Oklahoma | 40113 | 246 | 9 |
349597 | 349597 | 2020-07-19 | Osage | Oklahoma | 40113 | 246 | 9 |
346397 | 346397 | 2020-07-18 | Osage | Oklahoma | 40113 | 246 | 9 |
343197 | 343197 | 2020-07-17 | Osage | Oklahoma | 40113 | 237 | 9 |
339999 | 339999 | 2020-07-16 | Osage | Oklahoma | 40113 | 230 | 9 |
336803 | 336803 | 2020-07-15 | Osage | Oklahoma | 40113 | 228 | 8 |
333609 | 333609 | 2020-07-14 | Osage | Oklahoma | 40113 | 221 | 8 |
330417 | 330417 | 2020-07-13 | Osage | Oklahoma | 40113 | 218 | 8 |
327230 | 327230 | 2020-07-12 | Osage | Oklahoma | 40113 | 215 | 8 |
324045 | 324045 | 2020-07-11 | Osage | Oklahoma | 40113 | 214 | 8 |
320865 | 320865 | 2020-07-10 | Osage | Oklahoma | 40113 | 203 | 8 |
317688 | 317688 | 2020-07-09 | Osage | Oklahoma | 40113 | 194 | 8 |
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);