ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Canadian" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955047 | 955047 | 2021-01-22 | Canadian | Oklahoma | 40017 | 13483 | 59 |
951802 | 951802 | 2021-01-21 | Canadian | Oklahoma | 40017 | 13384 | 59 |
948557 | 948557 | 2021-01-20 | Canadian | Oklahoma | 40017 | 13313 | 59 |
945311 | 945311 | 2021-01-19 | Canadian | Oklahoma | 40017 | 13242 | 59 |
942064 | 942064 | 2021-01-18 | Canadian | Oklahoma | 40017 | 13206 | 58 |
938819 | 938819 | 2021-01-17 | Canadian | Oklahoma | 40017 | 13134 | 58 |
935574 | 935574 | 2021-01-16 | Canadian | Oklahoma | 40017 | 13045 | 57 |
932329 | 932329 | 2021-01-15 | Canadian | Oklahoma | 40017 | 12900 | 57 |
929084 | 929084 | 2021-01-14 | Canadian | Oklahoma | 40017 | 12814 | 57 |
925839 | 925839 | 2021-01-13 | Canadian | Oklahoma | 40017 | 12709 | 57 |
922593 | 922593 | 2021-01-12 | Canadian | Oklahoma | 40017 | 12524 | 57 |
919348 | 919348 | 2021-01-11 | Canadian | Oklahoma | 40017 | 12437 | 57 |
916103 | 916103 | 2021-01-10 | Canadian | Oklahoma | 40017 | 12333 | 57 |
912858 | 912858 | 2021-01-09 | Canadian | Oklahoma | 40017 | 12127 | 56 |
909613 | 909613 | 2021-01-08 | Canadian | Oklahoma | 40017 | 11996 | 54 |
906368 | 906368 | 2021-01-07 | Canadian | Oklahoma | 40017 | 11752 | 54 |
903122 | 903122 | 2021-01-06 | Canadian | Oklahoma | 40017 | 11585 | 54 |
899877 | 899877 | 2021-01-05 | Canadian | Oklahoma | 40017 | 11448 | 53 |
896632 | 896632 | 2021-01-04 | Canadian | Oklahoma | 40017 | 11400 | 52 |
893386 | 893386 | 2021-01-03 | Canadian | Oklahoma | 40017 | 11246 | 52 |
890140 | 890140 | 2021-01-02 | Canadian | Oklahoma | 40017 | 10984 | 52 |
886893 | 886893 | 2021-01-01 | Canadian | Oklahoma | 40017 | 10582 | 52 |
883648 | 883648 | 2020-12-31 | Canadian | Oklahoma | 40017 | 10582 | 52 |
880403 | 880403 | 2020-12-30 | Canadian | Oklahoma | 40017 | 10486 | 51 |
877158 | 877158 | 2020-12-29 | Canadian | Oklahoma | 40017 | 10404 | 50 |
873913 | 873913 | 2020-12-28 | Canadian | Oklahoma | 40017 | 10351 | 50 |
870668 | 870668 | 2020-12-27 | Canadian | Oklahoma | 40017 | 10225 | 49 |
867423 | 867423 | 2020-12-26 | Canadian | Oklahoma | 40017 | 10150 | 49 |
864178 | 864178 | 2020-12-25 | Canadian | Oklahoma | 40017 | 10015 | 49 |
860933 | 860933 | 2020-12-24 | Canadian | Oklahoma | 40017 | 10015 | 49 |
857688 | 857688 | 2020-12-23 | Canadian | Oklahoma | 40017 | 9842 | 48 |
854443 | 854443 | 2020-12-22 | Canadian | Oklahoma | 40017 | 9737 | 47 |
851198 | 851198 | 2020-12-21 | Canadian | Oklahoma | 40017 | 9648 | 45 |
847953 | 847953 | 2020-12-20 | Canadian | Oklahoma | 40017 | 9550 | 45 |
844708 | 844708 | 2020-12-19 | Canadian | Oklahoma | 40017 | 9422 | 45 |
841462 | 841462 | 2020-12-18 | Canadian | Oklahoma | 40017 | 9272 | 45 |
838217 | 838217 | 2020-12-17 | Canadian | Oklahoma | 40017 | 9153 | 45 |
834971 | 834971 | 2020-12-16 | Canadian | Oklahoma | 40017 | 9016 | 44 |
831725 | 831725 | 2020-12-15 | Canadian | Oklahoma | 40017 | 8859 | 44 |
828478 | 828478 | 2020-12-14 | Canadian | Oklahoma | 40017 | 8731 | 41 |
825232 | 825232 | 2020-12-13 | Canadian | Oklahoma | 40017 | 8643 | 41 |
821985 | 821985 | 2020-12-12 | Canadian | Oklahoma | 40017 | 8484 | 41 |
818739 | 818739 | 2020-12-11 | Canadian | Oklahoma | 40017 | 8305 | 40 |
815493 | 815493 | 2020-12-10 | Canadian | Oklahoma | 40017 | 8162 | 39 |
812247 | 812247 | 2020-12-09 | Canadian | Oklahoma | 40017 | 8105 | 36 |
809003 | 809003 | 2020-12-08 | Canadian | Oklahoma | 40017 | 7960 | 35 |
805758 | 805758 | 2020-12-07 | Canadian | Oklahoma | 40017 | 7864 | 35 |
802513 | 802513 | 2020-12-06 | Canadian | Oklahoma | 40017 | 7811 | 35 |
799268 | 799268 | 2020-12-05 | Canadian | Oklahoma | 40017 | 7668 | 35 |
796023 | 796023 | 2020-12-04 | Canadian | Oklahoma | 40017 | 7479 | 34 |
792778 | 792778 | 2020-12-03 | Canadian | Oklahoma | 40017 | 7320 | 34 |
789533 | 789533 | 2020-12-02 | Canadian | Oklahoma | 40017 | 7258 | 34 |
786288 | 786288 | 2020-12-01 | Canadian | Oklahoma | 40017 | 7075 | 30 |
783044 | 783044 | 2020-11-30 | Canadian | Oklahoma | 40017 | 7002 | 28 |
779798 | 779798 | 2020-11-29 | Canadian | Oklahoma | 40017 | 6953 | 28 |
776553 | 776553 | 2020-11-28 | Canadian | Oklahoma | 40017 | 6890 | 28 |
773308 | 773308 | 2020-11-27 | Canadian | Oklahoma | 40017 | 6665 | 28 |
770063 | 770063 | 2020-11-26 | Canadian | Oklahoma | 40017 | 6515 | 27 |
766817 | 766817 | 2020-11-25 | Canadian | Oklahoma | 40017 | 6515 | 27 |
763572 | 763572 | 2020-11-24 | Canadian | Oklahoma | 40017 | 6417 | 27 |
760327 | 760327 | 2020-11-23 | Canadian | Oklahoma | 40017 | 6313 | 27 |
757082 | 757082 | 2020-11-22 | Canadian | Oklahoma | 40017 | 6221 | 27 |
753835 | 753835 | 2020-11-21 | Canadian | Oklahoma | 40017 | 6081 | 27 |
750589 | 750589 | 2020-11-20 | Canadian | Oklahoma | 40017 | 5913 | 25 |
747343 | 747343 | 2020-11-19 | Canadian | Oklahoma | 40017 | 5834 | 25 |
744097 | 744097 | 2020-11-18 | Canadian | Oklahoma | 40017 | 5721 | 25 |
740850 | 740850 | 2020-11-17 | Canadian | Oklahoma | 40017 | 5582 | 25 |
737604 | 737604 | 2020-11-16 | Canadian | Oklahoma | 40017 | 5534 | 24 |
734360 | 734360 | 2020-11-15 | Canadian | Oklahoma | 40017 | 5443 | 24 |
731114 | 731114 | 2020-11-14 | Canadian | Oklahoma | 40017 | 5230 | 24 |
727870 | 727870 | 2020-11-13 | Canadian | Oklahoma | 40017 | 5095 | 24 |
724626 | 724626 | 2020-11-12 | Canadian | Oklahoma | 40017 | 4967 | 24 |
721383 | 721383 | 2020-11-11 | Canadian | Oklahoma | 40017 | 4883 | 24 |
718140 | 718140 | 2020-11-10 | Canadian | Oklahoma | 40017 | 4807 | 24 |
714897 | 714897 | 2020-11-09 | Canadian | Oklahoma | 40017 | 4768 | 24 |
711653 | 711653 | 2020-11-08 | Canadian | Oklahoma | 40017 | 4692 | 24 |
708409 | 708409 | 2020-11-07 | Canadian | Oklahoma | 40017 | 4692 | 24 |
705166 | 705166 | 2020-11-06 | Canadian | Oklahoma | 40017 | 4478 | 24 |
701923 | 701923 | 2020-11-05 | Canadian | Oklahoma | 40017 | 4411 | 24 |
698679 | 698679 | 2020-11-04 | Canadian | Oklahoma | 40017 | 4334 | 24 |
695436 | 695436 | 2020-11-03 | Canadian | Oklahoma | 40017 | 4289 | 24 |
692194 | 692194 | 2020-11-02 | Canadian | Oklahoma | 40017 | 4232 | 24 |
688950 | 688950 | 2020-11-01 | Canadian | Oklahoma | 40017 | 4208 | 23 |
685705 | 685705 | 2020-10-31 | Canadian | Oklahoma | 40017 | 4163 | 23 |
682462 | 682462 | 2020-10-30 | Canadian | Oklahoma | 40017 | 4112 | 23 |
679219 | 679219 | 2020-10-29 | Canadian | Oklahoma | 40017 | 4070 | 23 |
675976 | 675976 | 2020-10-28 | Canadian | Oklahoma | 40017 | 4009 | 23 |
672733 | 672733 | 2020-10-27 | Canadian | Oklahoma | 40017 | 3987 | 23 |
669491 | 669491 | 2020-10-26 | Canadian | Oklahoma | 40017 | 3896 | 23 |
666247 | 666247 | 2020-10-25 | Canadian | Oklahoma | 40017 | 3846 | 23 |
663002 | 663002 | 2020-10-24 | Canadian | Oklahoma | 40017 | 3813 | 23 |
659758 | 659758 | 2020-10-23 | Canadian | Oklahoma | 40017 | 3754 | 22 |
656514 | 656514 | 2020-10-22 | Canadian | Oklahoma | 40017 | 3674 | 21 |
653269 | 653269 | 2020-10-21 | Canadian | Oklahoma | 40017 | 3607 | 21 |
650024 | 650024 | 2020-10-20 | Canadian | Oklahoma | 40017 | 3469 | 21 |
646780 | 646780 | 2020-10-19 | Canadian | Oklahoma | 40017 | 3386 | 21 |
643534 | 643534 | 2020-10-18 | Canadian | Oklahoma | 40017 | 3350 | 21 |
640286 | 640286 | 2020-10-17 | Canadian | Oklahoma | 40017 | 3324 | 21 |
637040 | 637040 | 2020-10-16 | Canadian | Oklahoma | 40017 | 3227 | 20 |
633794 | 633794 | 2020-10-15 | Canadian | Oklahoma | 40017 | 3073 | 20 |
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);