ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Creek" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955057 | 955057 | 2021-01-22 | Creek | Oklahoma | 40037 | 5352 | 81 |
951812 | 951812 | 2021-01-21 | Creek | Oklahoma | 40037 | 5302 | 81 |
948567 | 948567 | 2021-01-20 | Creek | Oklahoma | 40037 | 5230 | 81 |
945321 | 945321 | 2021-01-19 | Creek | Oklahoma | 40037 | 5208 | 81 |
942074 | 942074 | 2021-01-18 | Creek | Oklahoma | 40037 | 5154 | 80 |
938829 | 938829 | 2021-01-17 | Creek | Oklahoma | 40037 | 5132 | 79 |
935584 | 935584 | 2021-01-16 | Creek | Oklahoma | 40037 | 5077 | 76 |
932339 | 932339 | 2021-01-15 | Creek | Oklahoma | 40037 | 5039 | 74 |
929094 | 929094 | 2021-01-14 | Creek | Oklahoma | 40037 | 4972 | 73 |
925849 | 925849 | 2021-01-13 | Creek | Oklahoma | 40037 | 4908 | 72 |
922603 | 922603 | 2021-01-12 | Creek | Oklahoma | 40037 | 4813 | 72 |
919358 | 919358 | 2021-01-11 | Creek | Oklahoma | 40037 | 4775 | 72 |
916113 | 916113 | 2021-01-10 | Creek | Oklahoma | 40037 | 4707 | 72 |
912868 | 912868 | 2021-01-09 | Creek | Oklahoma | 40037 | 4568 | 71 |
909623 | 909623 | 2021-01-08 | Creek | Oklahoma | 40037 | 4494 | 71 |
906378 | 906378 | 2021-01-07 | Creek | Oklahoma | 40037 | 4438 | 70 |
903132 | 903132 | 2021-01-06 | Creek | Oklahoma | 40037 | 4384 | 68 |
899887 | 899887 | 2021-01-05 | Creek | Oklahoma | 40037 | 4346 | 66 |
896642 | 896642 | 2021-01-04 | Creek | Oklahoma | 40037 | 4312 | 66 |
893396 | 893396 | 2021-01-03 | Creek | Oklahoma | 40037 | 4276 | 66 |
890150 | 890150 | 2021-01-02 | Creek | Oklahoma | 40037 | 4173 | 66 |
886903 | 886903 | 2021-01-01 | Creek | Oklahoma | 40037 | 4079 | 64 |
883658 | 883658 | 2020-12-31 | Creek | Oklahoma | 40037 | 4079 | 64 |
880413 | 880413 | 2020-12-30 | Creek | Oklahoma | 40037 | 4032 | 64 |
877168 | 877168 | 2020-12-29 | Creek | Oklahoma | 40037 | 3988 | 64 |
873923 | 873923 | 2020-12-28 | Creek | Oklahoma | 40037 | 3975 | 63 |
870678 | 870678 | 2020-12-27 | Creek | Oklahoma | 40037 | 3934 | 63 |
867433 | 867433 | 2020-12-26 | Creek | Oklahoma | 40037 | 3891 | 63 |
864188 | 864188 | 2020-12-25 | Creek | Oklahoma | 40037 | 3813 | 61 |
860943 | 860943 | 2020-12-24 | Creek | Oklahoma | 40037 | 3813 | 61 |
857698 | 857698 | 2020-12-23 | Creek | Oklahoma | 40037 | 3784 | 61 |
854453 | 854453 | 2020-12-22 | Creek | Oklahoma | 40037 | 3711 | 58 |
851208 | 851208 | 2020-12-21 | Creek | Oklahoma | 40037 | 3673 | 57 |
847963 | 847963 | 2020-12-20 | Creek | Oklahoma | 40037 | 3630 | 57 |
844718 | 844718 | 2020-12-19 | Creek | Oklahoma | 40037 | 3485 | 57 |
841472 | 841472 | 2020-12-18 | Creek | Oklahoma | 40037 | 3419 | 57 |
838227 | 838227 | 2020-12-17 | Creek | Oklahoma | 40037 | 3374 | 57 |
834981 | 834981 | 2020-12-16 | Creek | Oklahoma | 40037 | 3340 | 57 |
831735 | 831735 | 2020-12-15 | Creek | Oklahoma | 40037 | 3295 | 55 |
828488 | 828488 | 2020-12-14 | Creek | Oklahoma | 40037 | 3275 | 55 |
825242 | 825242 | 2020-12-13 | Creek | Oklahoma | 40037 | 3257 | 55 |
821995 | 821995 | 2020-12-12 | Creek | Oklahoma | 40037 | 3166 | 55 |
818749 | 818749 | 2020-12-11 | Creek | Oklahoma | 40037 | 3118 | 54 |
815503 | 815503 | 2020-12-10 | Creek | Oklahoma | 40037 | 3071 | 54 |
812257 | 812257 | 2020-12-09 | Creek | Oklahoma | 40037 | 3032 | 53 |
809013 | 809013 | 2020-12-08 | Creek | Oklahoma | 40037 | 3006 | 52 |
805768 | 805768 | 2020-12-07 | Creek | Oklahoma | 40037 | 2966 | 52 |
802523 | 802523 | 2020-12-06 | Creek | Oklahoma | 40037 | 2941 | 52 |
799278 | 799278 | 2020-12-05 | Creek | Oklahoma | 40037 | 2910 | 52 |
796033 | 796033 | 2020-12-04 | Creek | Oklahoma | 40037 | 2856 | 52 |
792788 | 792788 | 2020-12-03 | Creek | Oklahoma | 40037 | 2778 | 52 |
789543 | 789543 | 2020-12-02 | Creek | Oklahoma | 40037 | 2755 | 52 |
786298 | 786298 | 2020-12-01 | Creek | Oklahoma | 40037 | 2725 | 52 |
783054 | 783054 | 2020-11-30 | Creek | Oklahoma | 40037 | 2706 | 51 |
779808 | 779808 | 2020-11-29 | Creek | Oklahoma | 40037 | 2680 | 50 |
776563 | 776563 | 2020-11-28 | Creek | Oklahoma | 40037 | 2658 | 48 |
773318 | 773318 | 2020-11-27 | Creek | Oklahoma | 40037 | 2586 | 45 |
770073 | 770073 | 2020-11-26 | Creek | Oklahoma | 40037 | 2530 | 44 |
766827 | 766827 | 2020-11-25 | Creek | Oklahoma | 40037 | 2530 | 44 |
763582 | 763582 | 2020-11-24 | Creek | Oklahoma | 40037 | 2460 | 44 |
760337 | 760337 | 2020-11-23 | Creek | Oklahoma | 40037 | 2429 | 44 |
757092 | 757092 | 2020-11-22 | Creek | Oklahoma | 40037 | 2357 | 43 |
753845 | 753845 | 2020-11-21 | Creek | Oklahoma | 40037 | 2308 | 43 |
750599 | 750599 | 2020-11-20 | Creek | Oklahoma | 40037 | 2263 | 42 |
747353 | 747353 | 2020-11-19 | Creek | Oklahoma | 40037 | 2208 | 42 |
744107 | 744107 | 2020-11-18 | Creek | Oklahoma | 40037 | 2194 | 42 |
740860 | 740860 | 2020-11-17 | Creek | Oklahoma | 40037 | 2124 | 41 |
737614 | 737614 | 2020-11-16 | Creek | Oklahoma | 40037 | 2109 | 41 |
734370 | 734370 | 2020-11-15 | Creek | Oklahoma | 40037 | 2069 | 41 |
731124 | 731124 | 2020-11-14 | Creek | Oklahoma | 40037 | 1999 | 41 |
727880 | 727880 | 2020-11-13 | Creek | Oklahoma | 40037 | 1967 | 41 |
724636 | 724636 | 2020-11-12 | Creek | Oklahoma | 40037 | 1937 | 41 |
721393 | 721393 | 2020-11-11 | Creek | Oklahoma | 40037 | 1918 | 41 |
718150 | 718150 | 2020-11-10 | Creek | Oklahoma | 40037 | 1889 | 41 |
714907 | 714907 | 2020-11-09 | Creek | Oklahoma | 40037 | 1849 | 40 |
711663 | 711663 | 2020-11-08 | Creek | Oklahoma | 40037 | 1814 | 40 |
708419 | 708419 | 2020-11-07 | Creek | Oklahoma | 40037 | 1814 | 40 |
705176 | 705176 | 2020-11-06 | Creek | Oklahoma | 40037 | 1761 | 40 |
701933 | 701933 | 2020-11-05 | Creek | Oklahoma | 40037 | 1731 | 40 |
698689 | 698689 | 2020-11-04 | Creek | Oklahoma | 40037 | 1706 | 40 |
695446 | 695446 | 2020-11-03 | Creek | Oklahoma | 40037 | 1691 | 39 |
692204 | 692204 | 2020-11-02 | Creek | Oklahoma | 40037 | 1668 | 39 |
688960 | 688960 | 2020-11-01 | Creek | Oklahoma | 40037 | 1651 | 39 |
685715 | 685715 | 2020-10-31 | Creek | Oklahoma | 40037 | 1635 | 39 |
682472 | 682472 | 2020-10-30 | Creek | Oklahoma | 40037 | 1625 | 39 |
679229 | 679229 | 2020-10-29 | Creek | Oklahoma | 40037 | 1609 | 39 |
675986 | 675986 | 2020-10-28 | Creek | Oklahoma | 40037 | 1597 | 37 |
672743 | 672743 | 2020-10-27 | Creek | Oklahoma | 40037 | 1582 | 37 |
669501 | 669501 | 2020-10-26 | Creek | Oklahoma | 40037 | 1568 | 37 |
666257 | 666257 | 2020-10-25 | Creek | Oklahoma | 40037 | 1562 | 37 |
663012 | 663012 | 2020-10-24 | Creek | Oklahoma | 40037 | 1546 | 37 |
659768 | 659768 | 2020-10-23 | Creek | Oklahoma | 40037 | 1536 | 37 |
656524 | 656524 | 2020-10-22 | Creek | Oklahoma | 40037 | 1523 | 37 |
653279 | 653279 | 2020-10-21 | Creek | Oklahoma | 40037 | 1495 | 38 |
650034 | 650034 | 2020-10-20 | Creek | Oklahoma | 40037 | 1484 | 37 |
646790 | 646790 | 2020-10-19 | Creek | Oklahoma | 40037 | 1467 | 36 |
643544 | 643544 | 2020-10-18 | Creek | Oklahoma | 40037 | 1458 | 36 |
640296 | 640296 | 2020-10-17 | Creek | Oklahoma | 40037 | 1449 | 36 |
637050 | 637050 | 2020-10-16 | Creek | Oklahoma | 40037 | 1426 | 36 |
633804 | 633804 | 2020-10-15 | Creek | Oklahoma | 40037 | 1413 | 36 |
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);