ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Comanche" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955054 | 955054 | 2021-01-22 | Comanche | Oklahoma | 40031 | 9099 | 95 |
951809 | 951809 | 2021-01-21 | Comanche | Oklahoma | 40031 | 8980 | 95 |
948564 | 948564 | 2021-01-20 | Comanche | Oklahoma | 40031 | 8907 | 92 |
945318 | 945318 | 2021-01-19 | Comanche | Oklahoma | 40031 | 8863 | 89 |
942071 | 942071 | 2021-01-18 | Comanche | Oklahoma | 40031 | 8828 | 87 |
938826 | 938826 | 2021-01-17 | Comanche | Oklahoma | 40031 | 8784 | 87 |
935581 | 935581 | 2021-01-16 | Comanche | Oklahoma | 40031 | 8678 | 85 |
932336 | 932336 | 2021-01-15 | Comanche | Oklahoma | 40031 | 8556 | 85 |
929091 | 929091 | 2021-01-14 | Comanche | Oklahoma | 40031 | 8438 | 84 |
925846 | 925846 | 2021-01-13 | Comanche | Oklahoma | 40031 | 8356 | 81 |
922600 | 922600 | 2021-01-12 | Comanche | Oklahoma | 40031 | 8145 | 79 |
919355 | 919355 | 2021-01-11 | Comanche | Oklahoma | 40031 | 8084 | 78 |
916110 | 916110 | 2021-01-10 | Comanche | Oklahoma | 40031 | 7981 | 78 |
912865 | 912865 | 2021-01-09 | Comanche | Oklahoma | 40031 | 7728 | 77 |
909620 | 909620 | 2021-01-08 | Comanche | Oklahoma | 40031 | 7620 | 74 |
906375 | 906375 | 2021-01-07 | Comanche | Oklahoma | 40031 | 7539 | 70 |
903129 | 903129 | 2021-01-06 | Comanche | Oklahoma | 40031 | 7431 | 70 |
899884 | 899884 | 2021-01-05 | Comanche | Oklahoma | 40031 | 7326 | 63 |
896639 | 896639 | 2021-01-04 | Comanche | Oklahoma | 40031 | 7299 | 62 |
893393 | 893393 | 2021-01-03 | Comanche | Oklahoma | 40031 | 7269 | 62 |
890147 | 890147 | 2021-01-02 | Comanche | Oklahoma | 40031 | 7126 | 60 |
886900 | 886900 | 2021-01-01 | Comanche | Oklahoma | 40031 | 6994 | 60 |
883655 | 883655 | 2020-12-31 | Comanche | Oklahoma | 40031 | 6994 | 60 |
880410 | 880410 | 2020-12-30 | Comanche | Oklahoma | 40031 | 6857 | 58 |
877165 | 877165 | 2020-12-29 | Comanche | Oklahoma | 40031 | 6771 | 56 |
873920 | 873920 | 2020-12-28 | Comanche | Oklahoma | 40031 | 6752 | 56 |
870675 | 870675 | 2020-12-27 | Comanche | Oklahoma | 40031 | 6694 | 55 |
867430 | 867430 | 2020-12-26 | Comanche | Oklahoma | 40031 | 6654 | 55 |
864185 | 864185 | 2020-12-25 | Comanche | Oklahoma | 40031 | 6559 | 55 |
860940 | 860940 | 2020-12-24 | Comanche | Oklahoma | 40031 | 6559 | 55 |
857695 | 857695 | 2020-12-23 | Comanche | Oklahoma | 40031 | 6517 | 54 |
854450 | 854450 | 2020-12-22 | Comanche | Oklahoma | 40031 | 6372 | 50 |
851205 | 851205 | 2020-12-21 | Comanche | Oklahoma | 40031 | 6335 | 50 |
847960 | 847960 | 2020-12-20 | Comanche | Oklahoma | 40031 | 6302 | 50 |
844715 | 844715 | 2020-12-19 | Comanche | Oklahoma | 40031 | 6172 | 50 |
841469 | 841469 | 2020-12-18 | Comanche | Oklahoma | 40031 | 6118 | 50 |
838224 | 838224 | 2020-12-17 | Comanche | Oklahoma | 40031 | 6030 | 50 |
834978 | 834978 | 2020-12-16 | Comanche | Oklahoma | 40031 | 5970 | 50 |
831732 | 831732 | 2020-12-15 | Comanche | Oklahoma | 40031 | 5829 | 46 |
828485 | 828485 | 2020-12-14 | Comanche | Oklahoma | 40031 | 5804 | 46 |
825239 | 825239 | 2020-12-13 | Comanche | Oklahoma | 40031 | 5785 | 46 |
821992 | 821992 | 2020-12-12 | Comanche | Oklahoma | 40031 | 5620 | 45 |
818746 | 818746 | 2020-12-11 | Comanche | Oklahoma | 40031 | 5565 | 43 |
815500 | 815500 | 2020-12-10 | Comanche | Oklahoma | 40031 | 5490 | 42 |
812254 | 812254 | 2020-12-09 | Comanche | Oklahoma | 40031 | 5443 | 41 |
809010 | 809010 | 2020-12-08 | Comanche | Oklahoma | 40031 | 5408 | 39 |
805765 | 805765 | 2020-12-07 | Comanche | Oklahoma | 40031 | 5377 | 39 |
802520 | 802520 | 2020-12-06 | Comanche | Oklahoma | 40031 | 5322 | 38 |
799275 | 799275 | 2020-12-05 | Comanche | Oklahoma | 40031 | 5255 | 37 |
796030 | 796030 | 2020-12-04 | Comanche | Oklahoma | 40031 | 5171 | 35 |
792785 | 792785 | 2020-12-03 | Comanche | Oklahoma | 40031 | 5043 | 35 |
789540 | 789540 | 2020-12-02 | Comanche | Oklahoma | 40031 | 4989 | 34 |
786295 | 786295 | 2020-12-01 | Comanche | Oklahoma | 40031 | 4921 | 33 |
783051 | 783051 | 2020-11-30 | Comanche | Oklahoma | 40031 | 4877 | 33 |
779805 | 779805 | 2020-11-29 | Comanche | Oklahoma | 40031 | 4788 | 33 |
776560 | 776560 | 2020-11-28 | Comanche | Oklahoma | 40031 | 4742 | 33 |
773315 | 773315 | 2020-11-27 | Comanche | Oklahoma | 40031 | 4553 | 33 |
770070 | 770070 | 2020-11-26 | Comanche | Oklahoma | 40031 | 4439 | 32 |
766824 | 766824 | 2020-11-25 | Comanche | Oklahoma | 40031 | 4439 | 32 |
763579 | 763579 | 2020-11-24 | Comanche | Oklahoma | 40031 | 4313 | 31 |
760334 | 760334 | 2020-11-23 | Comanche | Oklahoma | 40031 | 4218 | 30 |
757089 | 757089 | 2020-11-22 | Comanche | Oklahoma | 40031 | 4086 | 30 |
753842 | 753842 | 2020-11-21 | Comanche | Oklahoma | 40031 | 3988 | 29 |
750596 | 750596 | 2020-11-20 | Comanche | Oklahoma | 40031 | 3901 | 28 |
747350 | 747350 | 2020-11-19 | Comanche | Oklahoma | 40031 | 3819 | 28 |
744104 | 744104 | 2020-11-18 | Comanche | Oklahoma | 40031 | 3733 | 27 |
740857 | 740857 | 2020-11-17 | Comanche | Oklahoma | 40031 | 3616 | 27 |
737611 | 737611 | 2020-11-16 | Comanche | Oklahoma | 40031 | 3574 | 27 |
734367 | 734367 | 2020-11-15 | Comanche | Oklahoma | 40031 | 3503 | 26 |
731121 | 731121 | 2020-11-14 | Comanche | Oklahoma | 40031 | 3419 | 26 |
727877 | 727877 | 2020-11-13 | Comanche | Oklahoma | 40031 | 3264 | 24 |
724633 | 724633 | 2020-11-12 | Comanche | Oklahoma | 40031 | 3168 | 23 |
721390 | 721390 | 2020-11-11 | Comanche | Oklahoma | 40031 | 3114 | 22 |
718147 | 718147 | 2020-11-10 | Comanche | Oklahoma | 40031 | 3063 | 22 |
714904 | 714904 | 2020-11-09 | Comanche | Oklahoma | 40031 | 3003 | 22 |
711660 | 711660 | 2020-11-08 | Comanche | Oklahoma | 40031 | 2937 | 22 |
708416 | 708416 | 2020-11-07 | Comanche | Oklahoma | 40031 | 2937 | 22 |
705173 | 705173 | 2020-11-06 | Comanche | Oklahoma | 40031 | 2783 | 22 |
701930 | 701930 | 2020-11-05 | Comanche | Oklahoma | 40031 | 2759 | 21 |
698686 | 698686 | 2020-11-04 | Comanche | Oklahoma | 40031 | 2723 | 20 |
695443 | 695443 | 2020-11-03 | Comanche | Oklahoma | 40031 | 2685 | 20 |
692201 | 692201 | 2020-11-02 | Comanche | Oklahoma | 40031 | 2653 | 18 |
688957 | 688957 | 2020-11-01 | Comanche | Oklahoma | 40031 | 2590 | 18 |
685712 | 685712 | 2020-10-31 | Comanche | Oklahoma | 40031 | 2549 | 18 |
682469 | 682469 | 2020-10-30 | Comanche | Oklahoma | 40031 | 2509 | 17 |
679226 | 679226 | 2020-10-29 | Comanche | Oklahoma | 40031 | 2468 | 17 |
675983 | 675983 | 2020-10-28 | Comanche | Oklahoma | 40031 | 2437 | 17 |
672740 | 672740 | 2020-10-27 | Comanche | Oklahoma | 40031 | 2417 | 17 |
669498 | 669498 | 2020-10-26 | Comanche | Oklahoma | 40031 | 2390 | 17 |
666254 | 666254 | 2020-10-25 | Comanche | Oklahoma | 40031 | 2372 | 17 |
663009 | 663009 | 2020-10-24 | Comanche | Oklahoma | 40031 | 2317 | 17 |
659765 | 659765 | 2020-10-23 | Comanche | Oklahoma | 40031 | 2272 | 17 |
656521 | 656521 | 2020-10-22 | Comanche | Oklahoma | 40031 | 2252 | 17 |
653276 | 653276 | 2020-10-21 | Comanche | Oklahoma | 40031 | 2201 | 17 |
650031 | 650031 | 2020-10-20 | Comanche | Oklahoma | 40031 | 2171 | 17 |
646787 | 646787 | 2020-10-19 | Comanche | Oklahoma | 40031 | 2116 | 16 |
643541 | 643541 | 2020-10-18 | Comanche | Oklahoma | 40031 | 2104 | 16 |
640293 | 640293 | 2020-10-17 | Comanche | Oklahoma | 40031 | 2039 | 16 |
637047 | 637047 | 2020-10-16 | Comanche | Oklahoma | 40031 | 2001 | 16 |
633801 | 633801 | 2020-10-15 | Comanche | Oklahoma | 40031 | 1990 | 15 |
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);