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 |
---|---|---|---|---|---|---|---|
1195317 | 1195317 | 2021-04-06 | Payne | Oklahoma | 40119 | 8571 | 52 |
1192069 | 1192069 | 2021-04-05 | Payne | Oklahoma | 40119 | 8571 | 52 |
1188820 | 1188820 | 2021-04-04 | Payne | Oklahoma | 40119 | 8571 | 52 |
1185573 | 1185573 | 2021-04-03 | Payne | Oklahoma | 40119 | 8571 | 52 |
1182326 | 1182326 | 2021-04-02 | Payne | Oklahoma | 40119 | 8571 | 52 |
1179079 | 1179079 | 2021-04-01 | Payne | Oklahoma | 40119 | 8571 | 52 |
1175832 | 1175832 | 2021-03-31 | Payne | Oklahoma | 40119 | 8571 | 52 |
1172585 | 1172585 | 2021-03-30 | Payne | Oklahoma | 40119 | 8531 | 51 |
1169338 | 1169338 | 2021-03-29 | Payne | Oklahoma | 40119 | 8531 | 51 |
1166090 | 1166090 | 2021-03-28 | Payne | Oklahoma | 40119 | 8531 | 51 |
1162842 | 1162842 | 2021-03-27 | Payne | Oklahoma | 40119 | 8531 | 51 |
1159593 | 1159593 | 2021-03-26 | Payne | Oklahoma | 40119 | 8531 | 51 |
1156346 | 1156346 | 2021-03-25 | Payne | Oklahoma | 40119 | 8531 | 51 |
1153099 | 1153099 | 2021-03-24 | Payne | Oklahoma | 40119 | 8531 | 51 |
1149852 | 1149852 | 2021-03-23 | Payne | Oklahoma | 40119 | 8494 | 50 |
1146605 | 1146605 | 2021-03-22 | Payne | Oklahoma | 40119 | 8494 | 50 |
1143358 | 1143358 | 2021-03-21 | Payne | Oklahoma | 40119 | 8494 | 50 |
1140111 | 1140111 | 2021-03-20 | Payne | Oklahoma | 40119 | 8494 | 50 |
1136865 | 1136865 | 2021-03-19 | Payne | Oklahoma | 40119 | 8494 | 50 |
1133619 | 1133619 | 2021-03-18 | Payne | Oklahoma | 40119 | 8494 | 50 |
1130371 | 1130371 | 2021-03-17 | Payne | Oklahoma | 40119 | 8494 | 50 |
1127124 | 1127124 | 2021-03-16 | Payne | Oklahoma | 40119 | 8494 | 50 |
1123878 | 1123878 | 2021-03-15 | Payne | Oklahoma | 40119 | 8494 | 49 |
1120632 | 1120632 | 2021-03-14 | Payne | Oklahoma | 40119 | 8490 | 49 |
1117385 | 1117385 | 2021-03-13 | Payne | Oklahoma | 40119 | 8481 | 49 |
1114138 | 1114138 | 2021-03-12 | Payne | Oklahoma | 40119 | 8478 | 49 |
1110892 | 1110892 | 2021-03-11 | Payne | Oklahoma | 40119 | 8473 | 49 |
1107646 | 1107646 | 2021-03-10 | Payne | Oklahoma | 40119 | 8461 | 49 |
1104400 | 1104400 | 2021-03-09 | Payne | Oklahoma | 40119 | 8452 | 49 |
1101154 | 1101154 | 2021-03-08 | Payne | Oklahoma | 40119 | 8442 | 47 |
1097908 | 1097908 | 2021-03-07 | Payne | Oklahoma | 40119 | 8442 | 47 |
1094660 | 1094660 | 2021-03-06 | Payne | Oklahoma | 40119 | 8428 | 47 |
1091414 | 1091414 | 2021-03-05 | Payne | Oklahoma | 40119 | 8420 | 47 |
1088168 | 1088168 | 2021-03-04 | Payne | Oklahoma | 40119 | 8397 | 47 |
1084923 | 1084923 | 2021-03-03 | Payne | Oklahoma | 40119 | 8380 | 47 |
1081677 | 1081677 | 2021-03-02 | Payne | Oklahoma | 40119 | 8360 | 47 |
1078431 | 1078431 | 2021-03-01 | Payne | Oklahoma | 40119 | 8360 | 47 |
1075186 | 1075186 | 2021-02-28 | Payne | Oklahoma | 40119 | 8357 | 47 |
1071940 | 1071940 | 2021-02-27 | Payne | Oklahoma | 40119 | 8346 | 46 |
1068694 | 1068694 | 2021-02-26 | Payne | Oklahoma | 40119 | 8335 | 46 |
1065449 | 1065449 | 2021-02-25 | Payne | Oklahoma | 40119 | 8310 | 46 |
1062205 | 1062205 | 2021-02-24 | Payne | Oklahoma | 40119 | 8305 | 46 |
1058959 | 1058959 | 2021-02-23 | Payne | Oklahoma | 40119 | 8295 | 46 |
1055713 | 1055713 | 2021-02-22 | Payne | Oklahoma | 40119 | 8284 | 46 |
1052467 | 1052467 | 2021-02-21 | Payne | Oklahoma | 40119 | 8276 | 46 |
1049220 | 1049220 | 2021-02-20 | Payne | Oklahoma | 40119 | 8264 | 46 |
1045973 | 1045973 | 2021-02-19 | Payne | Oklahoma | 40119 | 8254 | 46 |
1042728 | 1042728 | 2021-02-18 | Payne | Oklahoma | 40119 | 8249 | 46 |
1039483 | 1039483 | 2021-02-17 | Payne | Oklahoma | 40119 | 8244 | 46 |
1036238 | 1036238 | 2021-02-16 | Payne | Oklahoma | 40119 | 8238 | 45 |
1032993 | 1032993 | 2021-02-15 | Payne | Oklahoma | 40119 | 8225 | 45 |
1029747 | 1029747 | 2021-02-14 | Payne | Oklahoma | 40119 | 8212 | 45 |
1026500 | 1026500 | 2021-02-13 | Payne | Oklahoma | 40119 | 8187 | 44 |
1023255 | 1023255 | 2021-02-12 | Payne | Oklahoma | 40119 | 8161 | 44 |
1020010 | 1020010 | 2021-02-11 | Payne | Oklahoma | 40119 | 8146 | 44 |
1016765 | 1016765 | 2021-02-10 | Payne | Oklahoma | 40119 | 8126 | 43 |
1013520 | 1013520 | 2021-02-09 | Payne | Oklahoma | 40119 | 8118 | 43 |
1010275 | 1010275 | 2021-02-08 | Payne | Oklahoma | 40119 | 8105 | 43 |
1007029 | 1007029 | 2021-02-07 | Payne | Oklahoma | 40119 | 8087 | 43 |
1003783 | 1003783 | 2021-02-06 | Payne | Oklahoma | 40119 | 8061 | 43 |
1000537 | 1000537 | 2021-02-05 | Payne | Oklahoma | 40119 | 8030 | 43 |
997291 | 997291 | 2021-02-04 | Payne | Oklahoma | 40119 | 8000 | 43 |
994045 | 994045 | 2021-02-03 | Payne | Oklahoma | 40119 | 7936 | 42 |
990799 | 990799 | 2021-02-02 | Payne | Oklahoma | 40119 | 7887 | 42 |
987553 | 987553 | 2021-02-01 | Payne | Oklahoma | 40119 | 7869 | 42 |
984306 | 984306 | 2021-01-31 | Payne | Oklahoma | 40119 | 7851 | 42 |
981059 | 981059 | 2021-01-30 | Payne | Oklahoma | 40119 | 7810 | 42 |
977813 | 977813 | 2021-01-29 | Payne | Oklahoma | 40119 | 7752 | 42 |
974568 | 974568 | 2021-01-28 | Payne | Oklahoma | 40119 | 7679 | 41 |
971323 | 971323 | 2021-01-27 | Payne | Oklahoma | 40119 | 7636 | 41 |
968078 | 968078 | 2021-01-26 | Payne | Oklahoma | 40119 | 7575 | 39 |
964834 | 964834 | 2021-01-25 | Payne | Oklahoma | 40119 | 7550 | 39 |
961589 | 961589 | 2021-01-24 | Payne | Oklahoma | 40119 | 7520 | 39 |
958344 | 958344 | 2021-01-23 | Payne | Oklahoma | 40119 | 7471 | 39 |
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 |
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);