ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Pawnee" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955097 | 955097 | 2021-01-22 | Pawnee | Oklahoma | 40117 | 1388 | 18 |
951852 | 951852 | 2021-01-21 | Pawnee | Oklahoma | 40117 | 1379 | 18 |
948607 | 948607 | 2021-01-20 | Pawnee | Oklahoma | 40117 | 1370 | 18 |
945361 | 945361 | 2021-01-19 | Pawnee | Oklahoma | 40117 | 1363 | 18 |
942114 | 942114 | 2021-01-18 | Pawnee | Oklahoma | 40117 | 1355 | 17 |
938869 | 938869 | 2021-01-17 | Pawnee | Oklahoma | 40117 | 1346 | 17 |
935624 | 935624 | 2021-01-16 | Pawnee | Oklahoma | 40117 | 1331 | 17 |
932379 | 932379 | 2021-01-15 | Pawnee | Oklahoma | 40117 | 1306 | 17 |
929134 | 929134 | 2021-01-14 | Pawnee | Oklahoma | 40117 | 1286 | 17 |
925889 | 925889 | 2021-01-13 | Pawnee | Oklahoma | 40117 | 1272 | 17 |
922643 | 922643 | 2021-01-12 | Pawnee | Oklahoma | 40117 | 1262 | 16 |
919398 | 919398 | 2021-01-11 | Pawnee | Oklahoma | 40117 | 1252 | 16 |
916153 | 916153 | 2021-01-10 | Pawnee | Oklahoma | 40117 | 1237 | 16 |
912908 | 912908 | 2021-01-09 | Pawnee | Oklahoma | 40117 | 1209 | 16 |
909663 | 909663 | 2021-01-08 | Pawnee | Oklahoma | 40117 | 1187 | 15 |
906418 | 906418 | 2021-01-07 | Pawnee | Oklahoma | 40117 | 1170 | 14 |
903172 | 903172 | 2021-01-06 | Pawnee | Oklahoma | 40117 | 1143 | 14 |
899927 | 899927 | 2021-01-05 | Pawnee | Oklahoma | 40117 | 1129 | 14 |
896682 | 896682 | 2021-01-04 | Pawnee | Oklahoma | 40117 | 1124 | 13 |
893436 | 893436 | 2021-01-03 | Pawnee | Oklahoma | 40117 | 1115 | 13 |
890190 | 890190 | 2021-01-02 | Pawnee | Oklahoma | 40117 | 1080 | 13 |
886943 | 886943 | 2021-01-01 | Pawnee | Oklahoma | 40117 | 1065 | 12 |
883698 | 883698 | 2020-12-31 | Pawnee | Oklahoma | 40117 | 1065 | 12 |
880453 | 880453 | 2020-12-30 | Pawnee | Oklahoma | 40117 | 1046 | 11 |
877208 | 877208 | 2020-12-29 | Pawnee | Oklahoma | 40117 | 989 | 10 |
873963 | 873963 | 2020-12-28 | Pawnee | Oklahoma | 40117 | 989 | 10 |
870718 | 870718 | 2020-12-27 | Pawnee | Oklahoma | 40117 | 977 | 10 |
867473 | 867473 | 2020-12-26 | Pawnee | Oklahoma | 40117 | 969 | 9 |
864228 | 864228 | 2020-12-25 | Pawnee | Oklahoma | 40117 | 956 | 9 |
860983 | 860983 | 2020-12-24 | Pawnee | Oklahoma | 40117 | 956 | 9 |
857738 | 857738 | 2020-12-23 | Pawnee | Oklahoma | 40117 | 935 | 9 |
854493 | 854493 | 2020-12-22 | Pawnee | Oklahoma | 40117 | 917 | 9 |
851248 | 851248 | 2020-12-21 | Pawnee | Oklahoma | 40117 | 913 | 9 |
848003 | 848003 | 2020-12-20 | Pawnee | Oklahoma | 40117 | 906 | 9 |
844758 | 844758 | 2020-12-19 | Pawnee | Oklahoma | 40117 | 878 | 9 |
841512 | 841512 | 2020-12-18 | Pawnee | Oklahoma | 40117 | 853 | 9 |
838267 | 838267 | 2020-12-17 | Pawnee | Oklahoma | 40117 | 834 | 9 |
835021 | 835021 | 2020-12-16 | Pawnee | Oklahoma | 40117 | 808 | 9 |
831775 | 831775 | 2020-12-15 | Pawnee | Oklahoma | 40117 | 782 | 9 |
828528 | 828528 | 2020-12-14 | Pawnee | Oklahoma | 40117 | 774 | 9 |
825282 | 825282 | 2020-12-13 | Pawnee | Oklahoma | 40117 | 770 | 9 |
822035 | 822035 | 2020-12-12 | Pawnee | Oklahoma | 40117 | 752 | 9 |
818789 | 818789 | 2020-12-11 | Pawnee | Oklahoma | 40117 | 736 | 9 |
815543 | 815543 | 2020-12-10 | Pawnee | Oklahoma | 40117 | 723 | 9 |
812297 | 812297 | 2020-12-09 | Pawnee | Oklahoma | 40117 | 709 | 9 |
809053 | 809053 | 2020-12-08 | Pawnee | Oklahoma | 40117 | 695 | 9 |
805808 | 805808 | 2020-12-07 | Pawnee | Oklahoma | 40117 | 687 | 9 |
802563 | 802563 | 2020-12-06 | Pawnee | Oklahoma | 40117 | 674 | 9 |
799318 | 799318 | 2020-12-05 | Pawnee | Oklahoma | 40117 | 653 | 9 |
796073 | 796073 | 2020-12-04 | Pawnee | Oklahoma | 40117 | 633 | 9 |
792828 | 792828 | 2020-12-03 | Pawnee | Oklahoma | 40117 | 625 | 9 |
789583 | 789583 | 2020-12-02 | Pawnee | Oklahoma | 40117 | 610 | 9 |
786338 | 786338 | 2020-12-01 | Pawnee | Oklahoma | 40117 | 604 | 8 |
783094 | 783094 | 2020-11-30 | Pawnee | Oklahoma | 40117 | 601 | 8 |
779848 | 779848 | 2020-11-29 | Pawnee | Oklahoma | 40117 | 596 | 7 |
776603 | 776603 | 2020-11-28 | Pawnee | Oklahoma | 40117 | 591 | 7 |
773358 | 773358 | 2020-11-27 | Pawnee | Oklahoma | 40117 | 563 | 6 |
770113 | 770113 | 2020-11-26 | Pawnee | Oklahoma | 40117 | 556 | 6 |
766867 | 766867 | 2020-11-25 | Pawnee | Oklahoma | 40117 | 556 | 6 |
763622 | 763622 | 2020-11-24 | Pawnee | Oklahoma | 40117 | 538 | 6 |
760377 | 760377 | 2020-11-23 | Pawnee | Oklahoma | 40117 | 534 | 6 |
757132 | 757132 | 2020-11-22 | Pawnee | Oklahoma | 40117 | 528 | 6 |
753885 | 753885 | 2020-11-21 | Pawnee | Oklahoma | 40117 | 502 | 6 |
750639 | 750639 | 2020-11-20 | Pawnee | Oklahoma | 40117 | 488 | 5 |
747393 | 747393 | 2020-11-19 | Pawnee | Oklahoma | 40117 | 480 | 5 |
744147 | 744147 | 2020-11-18 | Pawnee | Oklahoma | 40117 | 477 | 5 |
740900 | 740900 | 2020-11-17 | Pawnee | Oklahoma | 40117 | 462 | 5 |
737654 | 737654 | 2020-11-16 | Pawnee | Oklahoma | 40117 | 453 | 5 |
734410 | 734410 | 2020-11-15 | Pawnee | Oklahoma | 40117 | 444 | 5 |
731164 | 731164 | 2020-11-14 | Pawnee | Oklahoma | 40117 | 425 | 5 |
727920 | 727920 | 2020-11-13 | Pawnee | Oklahoma | 40117 | 422 | 5 |
724676 | 724676 | 2020-11-12 | Pawnee | Oklahoma | 40117 | 415 | 5 |
721433 | 721433 | 2020-11-11 | Pawnee | Oklahoma | 40117 | 404 | 5 |
718190 | 718190 | 2020-11-10 | Pawnee | Oklahoma | 40117 | 392 | 5 |
714947 | 714947 | 2020-11-09 | Pawnee | Oklahoma | 40117 | 389 | 5 |
711703 | 711703 | 2020-11-08 | Pawnee | Oklahoma | 40117 | 384 | 5 |
708459 | 708459 | 2020-11-07 | Pawnee | Oklahoma | 40117 | 384 | 5 |
705216 | 705216 | 2020-11-06 | Pawnee | Oklahoma | 40117 | 370 | 5 |
701973 | 701973 | 2020-11-05 | Pawnee | Oklahoma | 40117 | 364 | 5 |
698729 | 698729 | 2020-11-04 | Pawnee | Oklahoma | 40117 | 356 | 5 |
695486 | 695486 | 2020-11-03 | Pawnee | Oklahoma | 40117 | 355 | 5 |
692244 | 692244 | 2020-11-02 | Pawnee | Oklahoma | 40117 | 353 | 5 |
689000 | 689000 | 2020-11-01 | Pawnee | Oklahoma | 40117 | 349 | 5 |
685755 | 685755 | 2020-10-31 | Pawnee | Oklahoma | 40117 | 345 | 5 |
682512 | 682512 | 2020-10-30 | Pawnee | Oklahoma | 40117 | 343 | 5 |
679269 | 679269 | 2020-10-29 | Pawnee | Oklahoma | 40117 | 339 | 5 |
676026 | 676026 | 2020-10-28 | Pawnee | Oklahoma | 40117 | 339 | 5 |
672783 | 672783 | 2020-10-27 | Pawnee | Oklahoma | 40117 | 336 | 5 |
669541 | 669541 | 2020-10-26 | Pawnee | Oklahoma | 40117 | 331 | 5 |
666297 | 666297 | 2020-10-25 | Pawnee | Oklahoma | 40117 | 331 | 5 |
663052 | 663052 | 2020-10-24 | Pawnee | Oklahoma | 40117 | 331 | 5 |
659808 | 659808 | 2020-10-23 | Pawnee | Oklahoma | 40117 | 330 | 5 |
656564 | 656564 | 2020-10-22 | Pawnee | Oklahoma | 40117 | 327 | 5 |
653319 | 653319 | 2020-10-21 | Pawnee | Oklahoma | 40117 | 322 | 5 |
650074 | 650074 | 2020-10-20 | Pawnee | Oklahoma | 40117 | 315 | 5 |
646830 | 646830 | 2020-10-19 | Pawnee | Oklahoma | 40117 | 312 | 5 |
643584 | 643584 | 2020-10-18 | Pawnee | Oklahoma | 40117 | 306 | 5 |
640336 | 640336 | 2020-10-17 | Pawnee | Oklahoma | 40117 | 303 | 5 |
637090 | 637090 | 2020-10-16 | Pawnee | Oklahoma | 40117 | 298 | 5 |
633844 | 633844 | 2020-10-15 | Pawnee | Oklahoma | 40117 | 294 | 5 |
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);