ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 40119 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955098 | 955098 | 2021-01-22 | Payne | Oklahoma | 40119 | 7395 | 38 |
951853 | 951853 | 2021-01-21 | Payne | Oklahoma | 40119 | 7304 | 38 |
948608 | 948608 | 2021-01-20 | Payne | Oklahoma | 40119 | 7229 | 37 |
945362 | 945362 | 2021-01-19 | Payne | Oklahoma | 40119 | 7200 | 36 |
942115 | 942115 | 2021-01-18 | Payne | Oklahoma | 40119 | 7177 | 35 |
938870 | 938870 | 2021-01-17 | Payne | Oklahoma | 40119 | 7149 | 35 |
935625 | 935625 | 2021-01-16 | Payne | Oklahoma | 40119 | 7105 | 34 |
932380 | 932380 | 2021-01-15 | Payne | Oklahoma | 40119 | 7039 | 34 |
929135 | 929135 | 2021-01-14 | Payne | Oklahoma | 40119 | 7004 | 33 |
925890 | 925890 | 2021-01-13 | Payne | Oklahoma | 40119 | 6970 | 33 |
922644 | 922644 | 2021-01-12 | Payne | Oklahoma | 40119 | 6907 | 33 |
919399 | 919399 | 2021-01-11 | Payne | Oklahoma | 40119 | 6862 | 33 |
916154 | 916154 | 2021-01-10 | Payne | Oklahoma | 40119 | 6833 | 33 |
912909 | 912909 | 2021-01-09 | Payne | Oklahoma | 40119 | 6747 | 33 |
909664 | 909664 | 2021-01-08 | Payne | Oklahoma | 40119 | 6611 | 33 |
906419 | 906419 | 2021-01-07 | Payne | Oklahoma | 40119 | 6370 | 33 |
903173 | 903173 | 2021-01-06 | Payne | Oklahoma | 40119 | 6299 | 32 |
899928 | 899928 | 2021-01-05 | Payne | Oklahoma | 40119 | 6226 | 31 |
896683 | 896683 | 2021-01-04 | Payne | Oklahoma | 40119 | 6212 | 30 |
893437 | 893437 | 2021-01-03 | Payne | Oklahoma | 40119 | 6184 | 30 |
890191 | 890191 | 2021-01-02 | Payne | Oklahoma | 40119 | 5970 | 30 |
886944 | 886944 | 2021-01-01 | Payne | Oklahoma | 40119 | 5883 | 28 |
883699 | 883699 | 2020-12-31 | Payne | Oklahoma | 40119 | 5883 | 28 |
880454 | 880454 | 2020-12-30 | Payne | Oklahoma | 40119 | 5793 | 28 |
877209 | 877209 | 2020-12-29 | Payne | Oklahoma | 40119 | 5686 | 27 |
873964 | 873964 | 2020-12-28 | Payne | Oklahoma | 40119 | 5676 | 27 |
870719 | 870719 | 2020-12-27 | Payne | Oklahoma | 40119 | 5610 | 27 |
867474 | 867474 | 2020-12-26 | Payne | Oklahoma | 40119 | 5593 | 27 |
864229 | 864229 | 2020-12-25 | Payne | Oklahoma | 40119 | 5539 | 26 |
860984 | 860984 | 2020-12-24 | Payne | Oklahoma | 40119 | 5539 | 26 |
857739 | 857739 | 2020-12-23 | Payne | Oklahoma | 40119 | 5477 | 26 |
854494 | 854494 | 2020-12-22 | Payne | Oklahoma | 40119 | 5409 | 25 |
851249 | 851249 | 2020-12-21 | Payne | Oklahoma | 40119 | 5400 | 25 |
848004 | 848004 | 2020-12-20 | Payne | Oklahoma | 40119 | 5371 | 25 |
844759 | 844759 | 2020-12-19 | Payne | Oklahoma | 40119 | 5296 | 25 |
841513 | 841513 | 2020-12-18 | Payne | Oklahoma | 40119 | 5222 | 24 |
838268 | 838268 | 2020-12-17 | Payne | Oklahoma | 40119 | 5167 | 24 |
835022 | 835022 | 2020-12-16 | Payne | Oklahoma | 40119 | 5100 | 24 |
831776 | 831776 | 2020-12-15 | Payne | Oklahoma | 40119 | 5061 | 24 |
828529 | 828529 | 2020-12-14 | Payne | Oklahoma | 40119 | 5020 | 24 |
825283 | 825283 | 2020-12-13 | Payne | Oklahoma | 40119 | 4992 | 24 |
822036 | 822036 | 2020-12-12 | Payne | Oklahoma | 40119 | 4926 | 24 |
818790 | 818790 | 2020-12-11 | Payne | Oklahoma | 40119 | 4843 | 24 |
815544 | 815544 | 2020-12-10 | Payne | Oklahoma | 40119 | 4780 | 23 |
812298 | 812298 | 2020-12-09 | Payne | Oklahoma | 40119 | 4707 | 23 |
809054 | 809054 | 2020-12-08 | Payne | Oklahoma | 40119 | 4686 | 23 |
805809 | 805809 | 2020-12-07 | Payne | Oklahoma | 40119 | 4664 | 23 |
802564 | 802564 | 2020-12-06 | Payne | Oklahoma | 40119 | 4607 | 22 |
799319 | 799319 | 2020-12-05 | Payne | Oklahoma | 40119 | 4531 | 22 |
796074 | 796074 | 2020-12-04 | Payne | Oklahoma | 40119 | 4468 | 21 |
792829 | 792829 | 2020-12-03 | Payne | Oklahoma | 40119 | 4373 | 21 |
789584 | 789584 | 2020-12-02 | Payne | Oklahoma | 40119 | 4326 | 19 |
786339 | 786339 | 2020-12-01 | Payne | Oklahoma | 40119 | 4285 | 19 |
783095 | 783095 | 2020-11-30 | Payne | Oklahoma | 40119 | 4272 | 19 |
779849 | 779849 | 2020-11-29 | Payne | Oklahoma | 40119 | 4252 | 19 |
776604 | 776604 | 2020-11-28 | Payne | Oklahoma | 40119 | 4239 | 18 |
773359 | 773359 | 2020-11-27 | Payne | Oklahoma | 40119 | 4091 | 18 |
770114 | 770114 | 2020-11-26 | Payne | Oklahoma | 40119 | 4050 | 18 |
766868 | 766868 | 2020-11-25 | Payne | Oklahoma | 40119 | 4050 | 18 |
763623 | 763623 | 2020-11-24 | Payne | Oklahoma | 40119 | 4019 | 17 |
760378 | 760378 | 2020-11-23 | Payne | Oklahoma | 40119 | 3967 | 17 |
757133 | 757133 | 2020-11-22 | Payne | Oklahoma | 40119 | 3904 | 17 |
753886 | 753886 | 2020-11-21 | Payne | Oklahoma | 40119 | 3833 | 17 |
750640 | 750640 | 2020-11-20 | Payne | Oklahoma | 40119 | 3745 | 17 |
747394 | 747394 | 2020-11-19 | Payne | Oklahoma | 40119 | 3697 | 17 |
744148 | 744148 | 2020-11-18 | Payne | Oklahoma | 40119 | 3641 | 17 |
740901 | 740901 | 2020-11-17 | Payne | Oklahoma | 40119 | 3581 | 17 |
737655 | 737655 | 2020-11-16 | Payne | Oklahoma | 40119 | 3570 | 17 |
734411 | 734411 | 2020-11-15 | Payne | Oklahoma | 40119 | 3517 | 17 |
731165 | 731165 | 2020-11-14 | Payne | Oklahoma | 40119 | 3413 | 16 |
727921 | 727921 | 2020-11-13 | Payne | Oklahoma | 40119 | 3391 | 16 |
724677 | 724677 | 2020-11-12 | Payne | Oklahoma | 40119 | 3319 | 15 |
721434 | 721434 | 2020-11-11 | Payne | Oklahoma | 40119 | 3285 | 15 |
718191 | 718191 | 2020-11-10 | Payne | Oklahoma | 40119 | 3250 | 15 |
714948 | 714948 | 2020-11-09 | Payne | Oklahoma | 40119 | 3228 | 15 |
711704 | 711704 | 2020-11-08 | Payne | Oklahoma | 40119 | 3176 | 15 |
708460 | 708460 | 2020-11-07 | Payne | Oklahoma | 40119 | 3176 | 15 |
705217 | 705217 | 2020-11-06 | Payne | Oklahoma | 40119 | 3106 | 15 |
701974 | 701974 | 2020-11-05 | Payne | Oklahoma | 40119 | 3042 | 15 |
698730 | 698730 | 2020-11-04 | Payne | Oklahoma | 40119 | 2997 | 14 |
695487 | 695487 | 2020-11-03 | Payne | Oklahoma | 40119 | 2929 | 14 |
692245 | 692245 | 2020-11-02 | Payne | Oklahoma | 40119 | 2919 | 14 |
689001 | 689001 | 2020-11-01 | Payne | Oklahoma | 40119 | 2917 | 14 |
685756 | 685756 | 2020-10-31 | Payne | Oklahoma | 40119 | 2882 | 14 |
682513 | 682513 | 2020-10-30 | Payne | Oklahoma | 40119 | 2841 | 13 |
679270 | 679270 | 2020-10-29 | Payne | Oklahoma | 40119 | 2817 | 12 |
676027 | 676027 | 2020-10-28 | Payne | Oklahoma | 40119 | 2812 | 12 |
672784 | 672784 | 2020-10-27 | Payne | Oklahoma | 40119 | 2811 | 12 |
669542 | 669542 | 2020-10-26 | Payne | Oklahoma | 40119 | 2804 | 12 |
666298 | 666298 | 2020-10-25 | Payne | Oklahoma | 40119 | 2791 | 12 |
663053 | 663053 | 2020-10-24 | Payne | Oklahoma | 40119 | 2784 | 12 |
659809 | 659809 | 2020-10-23 | Payne | Oklahoma | 40119 | 2772 | 12 |
656565 | 656565 | 2020-10-22 | Payne | Oklahoma | 40119 | 2752 | 11 |
653320 | 653320 | 2020-10-21 | Payne | Oklahoma | 40119 | 2718 | 11 |
650075 | 650075 | 2020-10-20 | Payne | Oklahoma | 40119 | 2704 | 10 |
646831 | 646831 | 2020-10-19 | Payne | Oklahoma | 40119 | 2695 | 10 |
643585 | 643585 | 2020-10-18 | Payne | Oklahoma | 40119 | 2680 | 10 |
640337 | 640337 | 2020-10-17 | Payne | Oklahoma | 40119 | 2678 | 9 |
637091 | 637091 | 2020-10-16 | Payne | Oklahoma | 40119 | 2653 | 9 |
633845 | 633845 | 2020-10-15 | Payne | Oklahoma | 40119 | 2618 | 9 |
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);