ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Muskogee", fips = 40101 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955089 | 955089 | 2021-01-22 | Muskogee | Oklahoma | 40101 | 8036 | 66 |
951844 | 951844 | 2021-01-21 | Muskogee | Oklahoma | 40101 | 7994 | 65 |
948599 | 948599 | 2021-01-20 | Muskogee | Oklahoma | 40101 | 7920 | 62 |
945353 | 945353 | 2021-01-19 | Muskogee | Oklahoma | 40101 | 7888 | 60 |
942106 | 942106 | 2021-01-18 | Muskogee | Oklahoma | 40101 | 7872 | 58 |
938861 | 938861 | 2021-01-17 | Muskogee | Oklahoma | 40101 | 7840 | 58 |
935616 | 935616 | 2021-01-16 | Muskogee | Oklahoma | 40101 | 7758 | 58 |
932371 | 932371 | 2021-01-15 | Muskogee | Oklahoma | 40101 | 7692 | 58 |
929126 | 929126 | 2021-01-14 | Muskogee | Oklahoma | 40101 | 7611 | 58 |
925881 | 925881 | 2021-01-13 | Muskogee | Oklahoma | 40101 | 7554 | 57 |
922635 | 922635 | 2021-01-12 | Muskogee | Oklahoma | 40101 | 7475 | 56 |
919390 | 919390 | 2021-01-11 | Muskogee | Oklahoma | 40101 | 7446 | 56 |
916145 | 916145 | 2021-01-10 | Muskogee | Oklahoma | 40101 | 7364 | 56 |
912900 | 912900 | 2021-01-09 | Muskogee | Oklahoma | 40101 | 7179 | 56 |
909655 | 909655 | 2021-01-08 | Muskogee | Oklahoma | 40101 | 7088 | 56 |
906410 | 906410 | 2021-01-07 | Muskogee | Oklahoma | 40101 | 6998 | 56 |
903164 | 903164 | 2021-01-06 | Muskogee | Oklahoma | 40101 | 6928 | 54 |
899919 | 899919 | 2021-01-05 | Muskogee | Oklahoma | 40101 | 6874 | 53 |
896674 | 896674 | 2021-01-04 | Muskogee | Oklahoma | 40101 | 6849 | 53 |
893428 | 893428 | 2021-01-03 | Muskogee | Oklahoma | 40101 | 6802 | 53 |
890182 | 890182 | 2021-01-02 | Muskogee | Oklahoma | 40101 | 6636 | 53 |
886935 | 886935 | 2021-01-01 | Muskogee | Oklahoma | 40101 | 6526 | 48 |
883690 | 883690 | 2020-12-31 | Muskogee | Oklahoma | 40101 | 6526 | 48 |
880445 | 880445 | 2020-12-30 | Muskogee | Oklahoma | 40101 | 6456 | 48 |
877200 | 877200 | 2020-12-29 | Muskogee | Oklahoma | 40101 | 6392 | 48 |
873955 | 873955 | 2020-12-28 | Muskogee | Oklahoma | 40101 | 6346 | 48 |
870710 | 870710 | 2020-12-27 | Muskogee | Oklahoma | 40101 | 6287 | 48 |
867465 | 867465 | 2020-12-26 | Muskogee | Oklahoma | 40101 | 6209 | 48 |
864220 | 864220 | 2020-12-25 | Muskogee | Oklahoma | 40101 | 6134 | 48 |
860975 | 860975 | 2020-12-24 | Muskogee | Oklahoma | 40101 | 6134 | 48 |
857730 | 857730 | 2020-12-23 | Muskogee | Oklahoma | 40101 | 6070 | 48 |
854485 | 854485 | 2020-12-22 | Muskogee | Oklahoma | 40101 | 5968 | 48 |
851240 | 851240 | 2020-12-21 | Muskogee | Oklahoma | 40101 | 5915 | 48 |
847995 | 847995 | 2020-12-20 | Muskogee | Oklahoma | 40101 | 5856 | 48 |
844750 | 844750 | 2020-12-19 | Muskogee | Oklahoma | 40101 | 5744 | 48 |
841504 | 841504 | 2020-12-18 | Muskogee | Oklahoma | 40101 | 5638 | 46 |
838259 | 838259 | 2020-12-17 | Muskogee | Oklahoma | 40101 | 5577 | 45 |
835013 | 835013 | 2020-12-16 | Muskogee | Oklahoma | 40101 | 5516 | 44 |
831767 | 831767 | 2020-12-15 | Muskogee | Oklahoma | 40101 | 5449 | 42 |
828520 | 828520 | 2020-12-14 | Muskogee | Oklahoma | 40101 | 5378 | 42 |
825274 | 825274 | 2020-12-13 | Muskogee | Oklahoma | 40101 | 5306 | 42 |
822027 | 822027 | 2020-12-12 | Muskogee | Oklahoma | 40101 | 5163 | 42 |
818781 | 818781 | 2020-12-11 | Muskogee | Oklahoma | 40101 | 5082 | 41 |
815535 | 815535 | 2020-12-10 | Muskogee | Oklahoma | 40101 | 5019 | 37 |
812289 | 812289 | 2020-12-09 | Muskogee | Oklahoma | 40101 | 4954 | 37 |
809045 | 809045 | 2020-12-08 | Muskogee | Oklahoma | 40101 | 4897 | 37 |
805800 | 805800 | 2020-12-07 | Muskogee | Oklahoma | 40101 | 4789 | 37 |
802555 | 802555 | 2020-12-06 | Muskogee | Oklahoma | 40101 | 4751 | 36 |
799310 | 799310 | 2020-12-05 | Muskogee | Oklahoma | 40101 | 4563 | 34 |
796065 | 796065 | 2020-12-04 | Muskogee | Oklahoma | 40101 | 4495 | 34 |
792820 | 792820 | 2020-12-03 | Muskogee | Oklahoma | 40101 | 4397 | 34 |
789575 | 789575 | 2020-12-02 | Muskogee | Oklahoma | 40101 | 4369 | 33 |
786330 | 786330 | 2020-12-01 | Muskogee | Oklahoma | 40101 | 4340 | 33 |
783086 | 783086 | 2020-11-30 | Muskogee | Oklahoma | 40101 | 4325 | 33 |
779840 | 779840 | 2020-11-29 | Muskogee | Oklahoma | 40101 | 4249 | 33 |
776595 | 776595 | 2020-11-28 | Muskogee | Oklahoma | 40101 | 4233 | 31 |
773350 | 773350 | 2020-11-27 | Muskogee | Oklahoma | 40101 | 4149 | 31 |
770105 | 770105 | 2020-11-26 | Muskogee | Oklahoma | 40101 | 4103 | 30 |
766859 | 766859 | 2020-11-25 | Muskogee | Oklahoma | 40101 | 4103 | 30 |
763614 | 763614 | 2020-11-24 | Muskogee | Oklahoma | 40101 | 3989 | 30 |
760369 | 760369 | 2020-11-23 | Muskogee | Oklahoma | 40101 | 3936 | 30 |
757124 | 757124 | 2020-11-22 | Muskogee | Oklahoma | 40101 | 3861 | 30 |
753877 | 753877 | 2020-11-21 | Muskogee | Oklahoma | 40101 | 3802 | 30 |
750631 | 750631 | 2020-11-20 | Muskogee | Oklahoma | 40101 | 3757 | 29 |
747385 | 747385 | 2020-11-19 | Muskogee | Oklahoma | 40101 | 3650 | 29 |
744139 | 744139 | 2020-11-18 | Muskogee | Oklahoma | 40101 | 3608 | 29 |
740892 | 740892 | 2020-11-17 | Muskogee | Oklahoma | 40101 | 3432 | 29 |
737646 | 737646 | 2020-11-16 | Muskogee | Oklahoma | 40101 | 3264 | 29 |
734402 | 734402 | 2020-11-15 | Muskogee | Oklahoma | 40101 | 3216 | 29 |
731156 | 731156 | 2020-11-14 | Muskogee | Oklahoma | 40101 | 3180 | 29 |
727912 | 727912 | 2020-11-13 | Muskogee | Oklahoma | 40101 | 3142 | 29 |
724668 | 724668 | 2020-11-12 | Muskogee | Oklahoma | 40101 | 2912 | 29 |
721425 | 721425 | 2020-11-11 | Muskogee | Oklahoma | 40101 | 2882 | 29 |
718182 | 718182 | 2020-11-10 | Muskogee | Oklahoma | 40101 | 2832 | 28 |
714939 | 714939 | 2020-11-09 | Muskogee | Oklahoma | 40101 | 2802 | 28 |
711695 | 711695 | 2020-11-08 | Muskogee | Oklahoma | 40101 | 2730 | 28 |
708451 | 708451 | 2020-11-07 | Muskogee | Oklahoma | 40101 | 2730 | 28 |
705208 | 705208 | 2020-11-06 | Muskogee | Oklahoma | 40101 | 2600 | 28 |
701965 | 701965 | 2020-11-05 | Muskogee | Oklahoma | 40101 | 2567 | 28 |
698721 | 698721 | 2020-11-04 | Muskogee | Oklahoma | 40101 | 2536 | 28 |
695478 | 695478 | 2020-11-03 | Muskogee | Oklahoma | 40101 | 2510 | 28 |
692236 | 692236 | 2020-11-02 | Muskogee | Oklahoma | 40101 | 2489 | 28 |
688992 | 688992 | 2020-11-01 | Muskogee | Oklahoma | 40101 | 2461 | 28 |
685747 | 685747 | 2020-10-31 | Muskogee | Oklahoma | 40101 | 2432 | 28 |
682504 | 682504 | 2020-10-30 | Muskogee | Oklahoma | 40101 | 2398 | 28 |
679261 | 679261 | 2020-10-29 | Muskogee | Oklahoma | 40101 | 2380 | 28 |
676018 | 676018 | 2020-10-28 | Muskogee | Oklahoma | 40101 | 2364 | 28 |
672775 | 672775 | 2020-10-27 | Muskogee | Oklahoma | 40101 | 2349 | 28 |
669533 | 669533 | 2020-10-26 | Muskogee | Oklahoma | 40101 | 2327 | 28 |
666289 | 666289 | 2020-10-25 | Muskogee | Oklahoma | 40101 | 2321 | 28 |
663044 | 663044 | 2020-10-24 | Muskogee | Oklahoma | 40101 | 2311 | 28 |
659800 | 659800 | 2020-10-23 | Muskogee | Oklahoma | 40101 | 2281 | 28 |
656556 | 656556 | 2020-10-22 | Muskogee | Oklahoma | 40101 | 2255 | 28 |
653311 | 653311 | 2020-10-21 | Muskogee | Oklahoma | 40101 | 2224 | 28 |
650066 | 650066 | 2020-10-20 | Muskogee | Oklahoma | 40101 | 2207 | 28 |
646822 | 646822 | 2020-10-19 | Muskogee | Oklahoma | 40101 | 2185 | 28 |
643576 | 643576 | 2020-10-18 | Muskogee | Oklahoma | 40101 | 2176 | 28 |
640328 | 640328 | 2020-10-17 | Muskogee | Oklahoma | 40101 | 2168 | 28 |
637082 | 637082 | 2020-10-16 | Muskogee | Oklahoma | 40101 | 2157 | 28 |
633836 | 633836 | 2020-10-15 | Muskogee | Oklahoma | 40101 | 2133 | 27 |
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);