ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 40013 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091361 | 1091361 | 2021-03-05 | Bryan | Oklahoma | 40013 | 5933 | 56 |
1088115 | 1088115 | 2021-03-04 | Bryan | Oklahoma | 40013 | 5929 | 56 |
1084870 | 1084870 | 2021-03-03 | Bryan | Oklahoma | 40013 | 5917 | 56 |
1081624 | 1081624 | 2021-03-02 | Bryan | Oklahoma | 40013 | 5913 | 56 |
1078378 | 1078378 | 2021-03-01 | Bryan | Oklahoma | 40013 | 5911 | 55 |
1075133 | 1075133 | 2021-02-28 | Bryan | Oklahoma | 40013 | 5907 | 55 |
1071887 | 1071887 | 2021-02-27 | Bryan | Oklahoma | 40013 | 5886 | 55 |
1068641 | 1068641 | 2021-02-26 | Bryan | Oklahoma | 40013 | 5866 | 55 |
1065396 | 1065396 | 2021-02-25 | Bryan | Oklahoma | 40013 | 5857 | 55 |
1062152 | 1062152 | 2021-02-24 | Bryan | Oklahoma | 40013 | 5838 | 55 |
1058906 | 1058906 | 2021-02-23 | Bryan | Oklahoma | 40013 | 5814 | 54 |
1055660 | 1055660 | 2021-02-22 | Bryan | Oklahoma | 40013 | 5810 | 54 |
1052414 | 1052414 | 2021-02-21 | Bryan | Oklahoma | 40013 | 5802 | 54 |
1049167 | 1049167 | 2021-02-20 | Bryan | Oklahoma | 40013 | 5779 | 52 |
1045920 | 1045920 | 2021-02-19 | Bryan | Oklahoma | 40013 | 5769 | 52 |
1042675 | 1042675 | 2021-02-18 | Bryan | Oklahoma | 40013 | 5763 | 52 |
1039430 | 1039430 | 2021-02-17 | Bryan | Oklahoma | 40013 | 5746 | 52 |
1036185 | 1036185 | 2021-02-16 | Bryan | Oklahoma | 40013 | 5731 | 52 |
1032940 | 1032940 | 2021-02-15 | Bryan | Oklahoma | 40013 | 5712 | 52 |
1029694 | 1029694 | 2021-02-14 | Bryan | Oklahoma | 40013 | 5707 | 52 |
1026447 | 1026447 | 2021-02-13 | Bryan | Oklahoma | 40013 | 5686 | 52 |
1023202 | 1023202 | 2021-02-12 | Bryan | Oklahoma | 40013 | 5658 | 51 |
1019957 | 1019957 | 2021-02-11 | Bryan | Oklahoma | 40013 | 5634 | 51 |
1016712 | 1016712 | 2021-02-10 | Bryan | Oklahoma | 40013 | 5611 | 51 |
1013467 | 1013467 | 2021-02-09 | Bryan | Oklahoma | 40013 | 5552 | 51 |
1010222 | 1010222 | 2021-02-08 | Bryan | Oklahoma | 40013 | 5544 | 51 |
1006976 | 1006976 | 2021-02-07 | Bryan | Oklahoma | 40013 | 5511 | 51 |
1003730 | 1003730 | 2021-02-06 | Bryan | Oklahoma | 40013 | 5476 | 51 |
1000484 | 1000484 | 2021-02-05 | Bryan | Oklahoma | 40013 | 5427 | 50 |
997238 | 997238 | 2021-02-04 | Bryan | Oklahoma | 40013 | 5392 | 50 |
993992 | 993992 | 2021-02-03 | Bryan | Oklahoma | 40013 | 5372 | 50 |
990746 | 990746 | 2021-02-02 | Bryan | Oklahoma | 40013 | 5340 | 45 |
987500 | 987500 | 2021-02-01 | Bryan | Oklahoma | 40013 | 5330 | 45 |
984253 | 984253 | 2021-01-31 | Bryan | Oklahoma | 40013 | 5315 | 45 |
981006 | 981006 | 2021-01-30 | Bryan | Oklahoma | 40013 | 5269 | 45 |
977760 | 977760 | 2021-01-29 | Bryan | Oklahoma | 40013 | 5246 | 45 |
974515 | 974515 | 2021-01-28 | Bryan | Oklahoma | 40013 | 5219 | 45 |
971270 | 971270 | 2021-01-27 | Bryan | Oklahoma | 40013 | 5177 | 44 |
968025 | 968025 | 2021-01-26 | Bryan | Oklahoma | 40013 | 5142 | 44 |
964781 | 964781 | 2021-01-25 | Bryan | Oklahoma | 40013 | 5131 | 44 |
961536 | 961536 | 2021-01-24 | Bryan | Oklahoma | 40013 | 5099 | 44 |
958291 | 958291 | 2021-01-23 | Bryan | Oklahoma | 40013 | 5051 | 44 |
955045 | 955045 | 2021-01-22 | Bryan | Oklahoma | 40013 | 5011 | 44 |
951800 | 951800 | 2021-01-21 | Bryan | Oklahoma | 40013 | 4945 | 44 |
948555 | 948555 | 2021-01-20 | Bryan | Oklahoma | 40013 | 4907 | 44 |
945309 | 945309 | 2021-01-19 | Bryan | Oklahoma | 40013 | 4858 | 44 |
942062 | 942062 | 2021-01-18 | Bryan | Oklahoma | 40013 | 4847 | 44 |
938817 | 938817 | 2021-01-17 | Bryan | Oklahoma | 40013 | 4837 | 44 |
935572 | 935572 | 2021-01-16 | Bryan | Oklahoma | 40013 | 4803 | 44 |
932327 | 932327 | 2021-01-15 | Bryan | Oklahoma | 40013 | 4758 | 44 |
929082 | 929082 | 2021-01-14 | Bryan | Oklahoma | 40013 | 4705 | 44 |
925837 | 925837 | 2021-01-13 | Bryan | Oklahoma | 40013 | 4642 | 41 |
922591 | 922591 | 2021-01-12 | Bryan | Oklahoma | 40013 | 4578 | 40 |
919346 | 919346 | 2021-01-11 | Bryan | Oklahoma | 40013 | 4564 | 40 |
916101 | 916101 | 2021-01-10 | Bryan | Oklahoma | 40013 | 4541 | 40 |
912856 | 912856 | 2021-01-09 | Bryan | Oklahoma | 40013 | 4487 | 39 |
909611 | 909611 | 2021-01-08 | Bryan | Oklahoma | 40013 | 4420 | 39 |
906366 | 906366 | 2021-01-07 | Bryan | Oklahoma | 40013 | 4367 | 39 |
903120 | 903120 | 2021-01-06 | Bryan | Oklahoma | 40013 | 4293 | 39 |
899875 | 899875 | 2021-01-05 | Bryan | Oklahoma | 40013 | 4184 | 33 |
896630 | 896630 | 2021-01-04 | Bryan | Oklahoma | 40013 | 4161 | 33 |
893384 | 893384 | 2021-01-03 | Bryan | Oklahoma | 40013 | 4153 | 33 |
890138 | 890138 | 2021-01-02 | Bryan | Oklahoma | 40013 | 4055 | 33 |
886891 | 886891 | 2021-01-01 | Bryan | Oklahoma | 40013 | 3980 | 32 |
883646 | 883646 | 2020-12-31 | Bryan | Oklahoma | 40013 | 3980 | 32 |
880401 | 880401 | 2020-12-30 | Bryan | Oklahoma | 40013 | 3904 | 32 |
877156 | 877156 | 2020-12-29 | Bryan | Oklahoma | 40013 | 3823 | 32 |
873911 | 873911 | 2020-12-28 | Bryan | Oklahoma | 40013 | 3816 | 32 |
870666 | 870666 | 2020-12-27 | Bryan | Oklahoma | 40013 | 3779 | 32 |
867421 | 867421 | 2020-12-26 | Bryan | Oklahoma | 40013 | 3751 | 32 |
864176 | 864176 | 2020-12-25 | Bryan | Oklahoma | 40013 | 3702 | 32 |
860931 | 860931 | 2020-12-24 | Bryan | Oklahoma | 40013 | 3702 | 32 |
857686 | 857686 | 2020-12-23 | Bryan | Oklahoma | 40013 | 3660 | 30 |
854441 | 854441 | 2020-12-22 | Bryan | Oklahoma | 40013 | 3582 | 28 |
851196 | 851196 | 2020-12-21 | Bryan | Oklahoma | 40013 | 3576 | 27 |
847951 | 847951 | 2020-12-20 | Bryan | Oklahoma | 40013 | 3539 | 27 |
844706 | 844706 | 2020-12-19 | Bryan | Oklahoma | 40013 | 3503 | 27 |
841460 | 841460 | 2020-12-18 | Bryan | Oklahoma | 40013 | 3442 | 26 |
838215 | 838215 | 2020-12-17 | Bryan | Oklahoma | 40013 | 3383 | 26 |
834969 | 834969 | 2020-12-16 | Bryan | Oklahoma | 40013 | 3338 | 26 |
831723 | 831723 | 2020-12-15 | Bryan | Oklahoma | 40013 | 3275 | 26 |
828476 | 828476 | 2020-12-14 | Bryan | Oklahoma | 40013 | 3265 | 26 |
825230 | 825230 | 2020-12-13 | Bryan | Oklahoma | 40013 | 3255 | 25 |
821983 | 821983 | 2020-12-12 | Bryan | Oklahoma | 40013 | 3214 | 25 |
818737 | 818737 | 2020-12-11 | Bryan | Oklahoma | 40013 | 3159 | 25 |
815491 | 815491 | 2020-12-10 | Bryan | Oklahoma | 40013 | 3120 | 25 |
812245 | 812245 | 2020-12-09 | Bryan | Oklahoma | 40013 | 3087 | 25 |
809001 | 809001 | 2020-12-08 | Bryan | Oklahoma | 40013 | 3037 | 25 |
805756 | 805756 | 2020-12-07 | Bryan | Oklahoma | 40013 | 3031 | 25 |
802511 | 802511 | 2020-12-06 | Bryan | Oklahoma | 40013 | 3025 | 25 |
799266 | 799266 | 2020-12-05 | Bryan | Oklahoma | 40013 | 2991 | 24 |
796021 | 796021 | 2020-12-04 | Bryan | Oklahoma | 40013 | 2952 | 24 |
792776 | 792776 | 2020-12-03 | Bryan | Oklahoma | 40013 | 2909 | 23 |
789531 | 789531 | 2020-12-02 | Bryan | Oklahoma | 40013 | 2880 | 23 |
786286 | 786286 | 2020-12-01 | Bryan | Oklahoma | 40013 | 2824 | 19 |
783042 | 783042 | 2020-11-30 | Bryan | Oklahoma | 40013 | 2817 | 18 |
779796 | 779796 | 2020-11-29 | Bryan | Oklahoma | 40013 | 2812 | 18 |
776551 | 776551 | 2020-11-28 | Bryan | Oklahoma | 40013 | 2794 | 18 |
773306 | 773306 | 2020-11-27 | Bryan | Oklahoma | 40013 | 2749 | 18 |
770061 | 770061 | 2020-11-26 | Bryan | Oklahoma | 40013 | 2710 | 18 |
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);