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 |
---|---|---|---|---|---|---|---|
922641 | 922641 | 2021-01-12 | Osage | Oklahoma | 40113 | 3524 | 32 |
919396 | 919396 | 2021-01-11 | Osage | Oklahoma | 40113 | 3502 | 31 |
916151 | 916151 | 2021-01-10 | Osage | Oklahoma | 40113 | 3470 | 31 |
912906 | 912906 | 2021-01-09 | Osage | Oklahoma | 40113 | 3406 | 31 |
909661 | 909661 | 2021-01-08 | Osage | Oklahoma | 40113 | 3358 | 30 |
906416 | 906416 | 2021-01-07 | Osage | Oklahoma | 40113 | 3299 | 29 |
903170 | 903170 | 2021-01-06 | Osage | Oklahoma | 40113 | 3255 | 27 |
899925 | 899925 | 2021-01-05 | Osage | Oklahoma | 40113 | 3234 | 27 |
896680 | 896680 | 2021-01-04 | Osage | Oklahoma | 40113 | 3211 | 27 |
893434 | 893434 | 2021-01-03 | Osage | Oklahoma | 40113 | 3175 | 27 |
890188 | 890188 | 2021-01-02 | Osage | Oklahoma | 40113 | 3076 | 27 |
886941 | 886941 | 2021-01-01 | Osage | Oklahoma | 40113 | 3016 | 26 |
883696 | 883696 | 2020-12-31 | Osage | Oklahoma | 40113 | 3016 | 26 |
880451 | 880451 | 2020-12-30 | Osage | Oklahoma | 40113 | 2968 | 26 |
877206 | 877206 | 2020-12-29 | Osage | Oklahoma | 40113 | 2902 | 25 |
873961 | 873961 | 2020-12-28 | Osage | Oklahoma | 40113 | 2897 | 25 |
870716 | 870716 | 2020-12-27 | Osage | Oklahoma | 40113 | 2860 | 25 |
867471 | 867471 | 2020-12-26 | Osage | Oklahoma | 40113 | 2820 | 25 |
864226 | 864226 | 2020-12-25 | Osage | Oklahoma | 40113 | 2776 | 24 |
860981 | 860981 | 2020-12-24 | Osage | Oklahoma | 40113 | 2776 | 24 |
857736 | 857736 | 2020-12-23 | Osage | Oklahoma | 40113 | 2744 | 24 |
854491 | 854491 | 2020-12-22 | Osage | Oklahoma | 40113 | 2713 | 24 |
851246 | 851246 | 2020-12-21 | Osage | Oklahoma | 40113 | 2691 | 24 |
848001 | 848001 | 2020-12-20 | Osage | Oklahoma | 40113 | 2661 | 24 |
844756 | 844756 | 2020-12-19 | Osage | Oklahoma | 40113 | 2593 | 24 |
841510 | 841510 | 2020-12-18 | Osage | Oklahoma | 40113 | 2526 | 21 |
838265 | 838265 | 2020-12-17 | Osage | Oklahoma | 40113 | 2493 | 21 |
835019 | 835019 | 2020-12-16 | Osage | Oklahoma | 40113 | 2472 | 21 |
831773 | 831773 | 2020-12-15 | Osage | Oklahoma | 40113 | 2428 | 21 |
828526 | 828526 | 2020-12-14 | Osage | Oklahoma | 40113 | 2414 | 21 |
825280 | 825280 | 2020-12-13 | Osage | Oklahoma | 40113 | 2403 | 21 |
822033 | 822033 | 2020-12-12 | Osage | Oklahoma | 40113 | 2357 | 21 |
818787 | 818787 | 2020-12-11 | Osage | Oklahoma | 40113 | 2320 | 21 |
815541 | 815541 | 2020-12-10 | Osage | Oklahoma | 40113 | 2290 | 20 |
812295 | 812295 | 2020-12-09 | Osage | Oklahoma | 40113 | 2260 | 19 |
809051 | 809051 | 2020-12-08 | Osage | Oklahoma | 40113 | 2243 | 19 |
805806 | 805806 | 2020-12-07 | Osage | Oklahoma | 40113 | 2217 | 19 |
802561 | 802561 | 2020-12-06 | Osage | Oklahoma | 40113 | 2199 | 19 |
799316 | 799316 | 2020-12-05 | Osage | Oklahoma | 40113 | 2171 | 19 |
796071 | 796071 | 2020-12-04 | Osage | Oklahoma | 40113 | 2132 | 19 |
792826 | 792826 | 2020-12-03 | Osage | Oklahoma | 40113 | 2087 | 18 |
789581 | 789581 | 2020-12-02 | Osage | Oklahoma | 40113 | 2057 | 18 |
786336 | 786336 | 2020-12-01 | Osage | Oklahoma | 40113 | 2014 | 18 |
783092 | 783092 | 2020-11-30 | Osage | Oklahoma | 40113 | 2005 | 18 |
779846 | 779846 | 2020-11-29 | Osage | Oklahoma | 40113 | 1985 | 18 |
776601 | 776601 | 2020-11-28 | Osage | Oklahoma | 40113 | 1973 | 18 |
773356 | 773356 | 2020-11-27 | Osage | Oklahoma | 40113 | 1921 | 18 |
770111 | 770111 | 2020-11-26 | Osage | Oklahoma | 40113 | 1902 | 18 |
766865 | 766865 | 2020-11-25 | Osage | Oklahoma | 40113 | 1902 | 18 |
763620 | 763620 | 2020-11-24 | Osage | Oklahoma | 40113 | 1873 | 18 |
760375 | 760375 | 2020-11-23 | Osage | Oklahoma | 40113 | 1859 | 18 |
757130 | 757130 | 2020-11-22 | Osage | Oklahoma | 40113 | 1849 | 18 |
753883 | 753883 | 2020-11-21 | Osage | Oklahoma | 40113 | 1822 | 18 |
750637 | 750637 | 2020-11-20 | Osage | Oklahoma | 40113 | 1774 | 18 |
747391 | 747391 | 2020-11-19 | Osage | Oklahoma | 40113 | 1749 | 18 |
744145 | 744145 | 2020-11-18 | Osage | Oklahoma | 40113 | 1729 | 18 |
740898 | 740898 | 2020-11-17 | Osage | Oklahoma | 40113 | 1705 | 18 |
737652 | 737652 | 2020-11-16 | Osage | Oklahoma | 40113 | 1696 | 18 |
734408 | 734408 | 2020-11-15 | Osage | Oklahoma | 40113 | 1679 | 17 |
731162 | 731162 | 2020-11-14 | Osage | Oklahoma | 40113 | 1647 | 17 |
727918 | 727918 | 2020-11-13 | Osage | Oklahoma | 40113 | 1624 | 17 |
724674 | 724674 | 2020-11-12 | Osage | Oklahoma | 40113 | 1600 | 17 |
721431 | 721431 | 2020-11-11 | Osage | Oklahoma | 40113 | 1580 | 17 |
718188 | 718188 | 2020-11-10 | Osage | Oklahoma | 40113 | 1553 | 17 |
714945 | 714945 | 2020-11-09 | Osage | Oklahoma | 40113 | 1529 | 17 |
711701 | 711701 | 2020-11-08 | Osage | Oklahoma | 40113 | 1515 | 17 |
708457 | 708457 | 2020-11-07 | Osage | Oklahoma | 40113 | 1515 | 17 |
705214 | 705214 | 2020-11-06 | Osage | Oklahoma | 40113 | 1485 | 16 |
701971 | 701971 | 2020-11-05 | Osage | Oklahoma | 40113 | 1477 | 16 |
698727 | 698727 | 2020-11-04 | Osage | Oklahoma | 40113 | 1455 | 15 |
695484 | 695484 | 2020-11-03 | Osage | Oklahoma | 40113 | 1443 | 15 |
692242 | 692242 | 2020-11-02 | Osage | Oklahoma | 40113 | 1430 | 15 |
688998 | 688998 | 2020-11-01 | Osage | Oklahoma | 40113 | 1427 | 15 |
685753 | 685753 | 2020-10-31 | Osage | Oklahoma | 40113 | 1411 | 15 |
682510 | 682510 | 2020-10-30 | Osage | Oklahoma | 40113 | 1396 | 13 |
679267 | 679267 | 2020-10-29 | Osage | Oklahoma | 40113 | 1390 | 13 |
676024 | 676024 | 2020-10-28 | Osage | Oklahoma | 40113 | 1388 | 13 |
672781 | 672781 | 2020-10-27 | Osage | Oklahoma | 40113 | 1384 | 13 |
669539 | 669539 | 2020-10-26 | Osage | Oklahoma | 40113 | 1377 | 13 |
666295 | 666295 | 2020-10-25 | Osage | Oklahoma | 40113 | 1378 | 13 |
663050 | 663050 | 2020-10-24 | Osage | Oklahoma | 40113 | 1372 | 13 |
659806 | 659806 | 2020-10-23 | Osage | Oklahoma | 40113 | 1366 | 13 |
656562 | 656562 | 2020-10-22 | Osage | Oklahoma | 40113 | 1368 | 13 |
653317 | 653317 | 2020-10-21 | Osage | Oklahoma | 40113 | 1343 | 13 |
650072 | 650072 | 2020-10-20 | Osage | Oklahoma | 40113 | 1333 | 13 |
646828 | 646828 | 2020-10-19 | Osage | Oklahoma | 40113 | 1322 | 13 |
643582 | 643582 | 2020-10-18 | Osage | Oklahoma | 40113 | 1323 | 13 |
640334 | 640334 | 2020-10-17 | Osage | Oklahoma | 40113 | 1320 | 13 |
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 |
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);