ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 40115 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955096 | 955096 | 2021-01-22 | Ottawa | Oklahoma | 40115 | 3300 | 34 |
951851 | 951851 | 2021-01-21 | Ottawa | Oklahoma | 40115 | 3270 | 33 |
948606 | 948606 | 2021-01-20 | Ottawa | Oklahoma | 40115 | 3253 | 33 |
945360 | 945360 | 2021-01-19 | Ottawa | Oklahoma | 40115 | 3234 | 33 |
942113 | 942113 | 2021-01-18 | Ottawa | Oklahoma | 40115 | 3228 | 32 |
938868 | 938868 | 2021-01-17 | Ottawa | Oklahoma | 40115 | 3219 | 32 |
935623 | 935623 | 2021-01-16 | Ottawa | Oklahoma | 40115 | 3199 | 32 |
932378 | 932378 | 2021-01-15 | Ottawa | Oklahoma | 40115 | 3159 | 32 |
929133 | 929133 | 2021-01-14 | Ottawa | Oklahoma | 40115 | 3131 | 32 |
925888 | 925888 | 2021-01-13 | Ottawa | Oklahoma | 40115 | 3103 | 32 |
922642 | 922642 | 2021-01-12 | Ottawa | Oklahoma | 40115 | 3104 | 32 |
919397 | 919397 | 2021-01-11 | Ottawa | Oklahoma | 40115 | 3071 | 32 |
916152 | 916152 | 2021-01-10 | Ottawa | Oklahoma | 40115 | 3043 | 32 |
912907 | 912907 | 2021-01-09 | Ottawa | Oklahoma | 40115 | 3001 | 30 |
909662 | 909662 | 2021-01-08 | Ottawa | Oklahoma | 40115 | 2981 | 30 |
906417 | 906417 | 2021-01-07 | Ottawa | Oklahoma | 40115 | 2938 | 30 |
903171 | 903171 | 2021-01-06 | Ottawa | Oklahoma | 40115 | 2884 | 29 |
899926 | 899926 | 2021-01-05 | Ottawa | Oklahoma | 40115 | 2843 | 29 |
896681 | 896681 | 2021-01-04 | Ottawa | Oklahoma | 40115 | 2839 | 28 |
893435 | 893435 | 2021-01-03 | Ottawa | Oklahoma | 40115 | 2816 | 28 |
890189 | 890189 | 2021-01-02 | Ottawa | Oklahoma | 40115 | 2779 | 28 |
886942 | 886942 | 2021-01-01 | Ottawa | Oklahoma | 40115 | 2728 | 28 |
883697 | 883697 | 2020-12-31 | Ottawa | Oklahoma | 40115 | 2728 | 28 |
880452 | 880452 | 2020-12-30 | Ottawa | Oklahoma | 40115 | 2691 | 28 |
877207 | 877207 | 2020-12-29 | Ottawa | Oklahoma | 40115 | 2637 | 28 |
873962 | 873962 | 2020-12-28 | Ottawa | Oklahoma | 40115 | 2629 | 28 |
870717 | 870717 | 2020-12-27 | Ottawa | Oklahoma | 40115 | 2607 | 28 |
867472 | 867472 | 2020-12-26 | Ottawa | Oklahoma | 40115 | 2584 | 28 |
864227 | 864227 | 2020-12-25 | Ottawa | Oklahoma | 40115 | 2535 | 27 |
860982 | 860982 | 2020-12-24 | Ottawa | Oklahoma | 40115 | 2535 | 27 |
857737 | 857737 | 2020-12-23 | Ottawa | Oklahoma | 40115 | 2501 | 26 |
854492 | 854492 | 2020-12-22 | Ottawa | Oklahoma | 40115 | 2461 | 26 |
851247 | 851247 | 2020-12-21 | Ottawa | Oklahoma | 40115 | 2431 | 25 |
848002 | 848002 | 2020-12-20 | Ottawa | Oklahoma | 40115 | 2410 | 25 |
844757 | 844757 | 2020-12-19 | Ottawa | Oklahoma | 40115 | 2360 | 25 |
841511 | 841511 | 2020-12-18 | Ottawa | Oklahoma | 40115 | 2263 | 25 |
838266 | 838266 | 2020-12-17 | Ottawa | Oklahoma | 40115 | 2216 | 25 |
835020 | 835020 | 2020-12-16 | Ottawa | Oklahoma | 40115 | 2191 | 25 |
831774 | 831774 | 2020-12-15 | Ottawa | Oklahoma | 40115 | 2161 | 25 |
828527 | 828527 | 2020-12-14 | Ottawa | Oklahoma | 40115 | 2121 | 25 |
825281 | 825281 | 2020-12-13 | Ottawa | Oklahoma | 40115 | 2109 | 25 |
822034 | 822034 | 2020-12-12 | Ottawa | Oklahoma | 40115 | 2077 | 25 |
818788 | 818788 | 2020-12-11 | Ottawa | Oklahoma | 40115 | 2046 | 25 |
815542 | 815542 | 2020-12-10 | Ottawa | Oklahoma | 40115 | 2021 | 25 |
812296 | 812296 | 2020-12-09 | Ottawa | Oklahoma | 40115 | 1996 | 25 |
809052 | 809052 | 2020-12-08 | Ottawa | Oklahoma | 40115 | 1973 | 25 |
805807 | 805807 | 2020-12-07 | Ottawa | Oklahoma | 40115 | 1953 | 25 |
802562 | 802562 | 2020-12-06 | Ottawa | Oklahoma | 40115 | 1951 | 25 |
799317 | 799317 | 2020-12-05 | Ottawa | Oklahoma | 40115 | 1912 | 25 |
796072 | 796072 | 2020-12-04 | Ottawa | Oklahoma | 40115 | 1864 | 24 |
792827 | 792827 | 2020-12-03 | Ottawa | Oklahoma | 40115 | 1823 | 24 |
789582 | 789582 | 2020-12-02 | Ottawa | Oklahoma | 40115 | 1790 | 24 |
786337 | 786337 | 2020-12-01 | Ottawa | Oklahoma | 40115 | 1769 | 22 |
783093 | 783093 | 2020-11-30 | Ottawa | Oklahoma | 40115 | 1765 | 22 |
779847 | 779847 | 2020-11-29 | Ottawa | Oklahoma | 40115 | 1755 | 22 |
776602 | 776602 | 2020-11-28 | Ottawa | Oklahoma | 40115 | 1739 | 22 |
773357 | 773357 | 2020-11-27 | Ottawa | Oklahoma | 40115 | 1702 | 22 |
770112 | 770112 | 2020-11-26 | Ottawa | Oklahoma | 40115 | 1681 | 22 |
766866 | 766866 | 2020-11-25 | Ottawa | Oklahoma | 40115 | 1681 | 22 |
763621 | 763621 | 2020-11-24 | Ottawa | Oklahoma | 40115 | 1652 | 22 |
760376 | 760376 | 2020-11-23 | Ottawa | Oklahoma | 40115 | 1638 | 22 |
757131 | 757131 | 2020-11-22 | Ottawa | Oklahoma | 40115 | 1620 | 22 |
753884 | 753884 | 2020-11-21 | Ottawa | Oklahoma | 40115 | 1601 | 22 |
750638 | 750638 | 2020-11-20 | Ottawa | Oklahoma | 40115 | 1573 | 22 |
747392 | 747392 | 2020-11-19 | Ottawa | Oklahoma | 40115 | 1549 | 22 |
744146 | 744146 | 2020-11-18 | Ottawa | Oklahoma | 40115 | 1533 | 22 |
740899 | 740899 | 2020-11-17 | Ottawa | Oklahoma | 40115 | 1517 | 22 |
737653 | 737653 | 2020-11-16 | Ottawa | Oklahoma | 40115 | 1515 | 22 |
734409 | 734409 | 2020-11-15 | Ottawa | Oklahoma | 40115 | 1499 | 22 |
731163 | 731163 | 2020-11-14 | Ottawa | Oklahoma | 40115 | 1459 | 22 |
727919 | 727919 | 2020-11-13 | Ottawa | Oklahoma | 40115 | 1441 | 21 |
724675 | 724675 | 2020-11-12 | Ottawa | Oklahoma | 40115 | 1426 | 21 |
721432 | 721432 | 2020-11-11 | Ottawa | Oklahoma | 40115 | 1411 | 21 |
718189 | 718189 | 2020-11-10 | Ottawa | Oklahoma | 40115 | 1405 | 21 |
714946 | 714946 | 2020-11-09 | Ottawa | Oklahoma | 40115 | 1391 | 21 |
711702 | 711702 | 2020-11-08 | Ottawa | Oklahoma | 40115 | 1376 | 21 |
708458 | 708458 | 2020-11-07 | Ottawa | Oklahoma | 40115 | 1376 | 21 |
705215 | 705215 | 2020-11-06 | Ottawa | Oklahoma | 40115 | 1354 | 21 |
701972 | 701972 | 2020-11-05 | Ottawa | Oklahoma | 40115 | 1340 | 21 |
698728 | 698728 | 2020-11-04 | Ottawa | Oklahoma | 40115 | 1321 | 21 |
695485 | 695485 | 2020-11-03 | Ottawa | Oklahoma | 40115 | 1312 | 21 |
692243 | 692243 | 2020-11-02 | Ottawa | Oklahoma | 40115 | 1306 | 19 |
688999 | 688999 | 2020-11-01 | Ottawa | Oklahoma | 40115 | 1300 | 19 |
685754 | 685754 | 2020-10-31 | Ottawa | Oklahoma | 40115 | 1290 | 18 |
682511 | 682511 | 2020-10-30 | Ottawa | Oklahoma | 40115 | 1271 | 17 |
679268 | 679268 | 2020-10-29 | Ottawa | Oklahoma | 40115 | 1263 | 16 |
676025 | 676025 | 2020-10-28 | Ottawa | Oklahoma | 40115 | 1260 | 10 |
672782 | 672782 | 2020-10-27 | Ottawa | Oklahoma | 40115 | 1246 | 9 |
669540 | 669540 | 2020-10-26 | Ottawa | Oklahoma | 40115 | 1231 | 9 |
666296 | 666296 | 2020-10-25 | Ottawa | Oklahoma | 40115 | 1226 | 9 |
663051 | 663051 | 2020-10-24 | Ottawa | Oklahoma | 40115 | 1222 | 9 |
659807 | 659807 | 2020-10-23 | Ottawa | Oklahoma | 40115 | 1202 | 9 |
656563 | 656563 | 2020-10-22 | Ottawa | Oklahoma | 40115 | 1192 | 9 |
653318 | 653318 | 2020-10-21 | Ottawa | Oklahoma | 40115 | 1167 | 9 |
650073 | 650073 | 2020-10-20 | Ottawa | Oklahoma | 40115 | 1143 | 8 |
646829 | 646829 | 2020-10-19 | Ottawa | Oklahoma | 40115 | 1134 | 8 |
643583 | 643583 | 2020-10-18 | Ottawa | Oklahoma | 40115 | 1131 | 8 |
640335 | 640335 | 2020-10-17 | Ottawa | Oklahoma | 40115 | 1126 | 8 |
637089 | 637089 | 2020-10-16 | Ottawa | Oklahoma | 40115 | 1113 | 8 |
633843 | 633843 | 2020-10-15 | Ottawa | Oklahoma | 40115 | 1098 | 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);