ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Creek" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195276 | 1195276 | 2021-04-06 | Creek | Oklahoma | 40037 | 6757 | 124 |
1192028 | 1192028 | 2021-04-05 | Creek | Oklahoma | 40037 | 6757 | 124 |
1188779 | 1188779 | 2021-04-04 | Creek | Oklahoma | 40037 | 6757 | 124 |
1185532 | 1185532 | 2021-04-03 | Creek | Oklahoma | 40037 | 6757 | 124 |
1182285 | 1182285 | 2021-04-02 | Creek | Oklahoma | 40037 | 6757 | 124 |
1179038 | 1179038 | 2021-04-01 | Creek | Oklahoma | 40037 | 6757 | 124 |
1175791 | 1175791 | 2021-03-31 | Creek | Oklahoma | 40037 | 6757 | 124 |
1172544 | 1172544 | 2021-03-30 | Creek | Oklahoma | 40037 | 6725 | 122 |
1169297 | 1169297 | 2021-03-29 | Creek | Oklahoma | 40037 | 6725 | 122 |
1166049 | 1166049 | 2021-03-28 | Creek | Oklahoma | 40037 | 6725 | 122 |
1162801 | 1162801 | 2021-03-27 | Creek | Oklahoma | 40037 | 6725 | 122 |
1159552 | 1159552 | 2021-03-26 | Creek | Oklahoma | 40037 | 6725 | 122 |
1156305 | 1156305 | 2021-03-25 | Creek | Oklahoma | 40037 | 6725 | 122 |
1153058 | 1153058 | 2021-03-24 | Creek | Oklahoma | 40037 | 6725 | 122 |
1149811 | 1149811 | 2021-03-23 | Creek | Oklahoma | 40037 | 6685 | 121 |
1146564 | 1146564 | 2021-03-22 | Creek | Oklahoma | 40037 | 6685 | 121 |
1143317 | 1143317 | 2021-03-21 | Creek | Oklahoma | 40037 | 6685 | 121 |
1140070 | 1140070 | 2021-03-20 | Creek | Oklahoma | 40037 | 6685 | 121 |
1136824 | 1136824 | 2021-03-19 | Creek | Oklahoma | 40037 | 6685 | 121 |
1133578 | 1133578 | 2021-03-18 | Creek | Oklahoma | 40037 | 6685 | 121 |
1130330 | 1130330 | 2021-03-17 | Creek | Oklahoma | 40037 | 6685 | 121 |
1127083 | 1127083 | 2021-03-16 | Creek | Oklahoma | 40037 | 6685 | 121 |
1123837 | 1123837 | 2021-03-15 | Creek | Oklahoma | 40037 | 6685 | 121 |
1120591 | 1120591 | 2021-03-14 | Creek | Oklahoma | 40037 | 6682 | 121 |
1117344 | 1117344 | 2021-03-13 | Creek | Oklahoma | 40037 | 6679 | 121 |
1114097 | 1114097 | 2021-03-12 | Creek | Oklahoma | 40037 | 6677 | 121 |
1110851 | 1110851 | 2021-03-11 | Creek | Oklahoma | 40037 | 6671 | 121 |
1107605 | 1107605 | 2021-03-10 | Creek | Oklahoma | 40037 | 6666 | 121 |
1104359 | 1104359 | 2021-03-09 | Creek | Oklahoma | 40037 | 6656 | 121 |
1101113 | 1101113 | 2021-03-08 | Creek | Oklahoma | 40037 | 6649 | 117 |
1097867 | 1097867 | 2021-03-07 | Creek | Oklahoma | 40037 | 6647 | 117 |
1094619 | 1094619 | 2021-03-06 | Creek | Oklahoma | 40037 | 6641 | 117 |
1091373 | 1091373 | 2021-03-05 | Creek | Oklahoma | 40037 | 6608 | 117 |
1088127 | 1088127 | 2021-03-04 | Creek | Oklahoma | 40037 | 6560 | 117 |
1084882 | 1084882 | 2021-03-03 | Creek | Oklahoma | 40037 | 6549 | 117 |
1081636 | 1081636 | 2021-03-02 | Creek | Oklahoma | 40037 | 6541 | 117 |
1078390 | 1078390 | 2021-03-01 | Creek | Oklahoma | 40037 | 6538 | 117 |
1075145 | 1075145 | 2021-02-28 | Creek | Oklahoma | 40037 | 6530 | 115 |
1071899 | 1071899 | 2021-02-27 | Creek | Oklahoma | 40037 | 6514 | 115 |
1068653 | 1068653 | 2021-02-26 | Creek | Oklahoma | 40037 | 6506 | 112 |
1065408 | 1065408 | 2021-02-25 | Creek | Oklahoma | 40037 | 6484 | 112 |
1062164 | 1062164 | 2021-02-24 | Creek | Oklahoma | 40037 | 6470 | 112 |
1058918 | 1058918 | 2021-02-23 | Creek | Oklahoma | 40037 | 6466 | 112 |
1055672 | 1055672 | 2021-02-22 | Creek | Oklahoma | 40037 | 6462 | 112 |
1052426 | 1052426 | 2021-02-21 | Creek | Oklahoma | 40037 | 6454 | 111 |
1049179 | 1049179 | 2021-02-20 | Creek | Oklahoma | 40037 | 6441 | 110 |
1045932 | 1045932 | 2021-02-19 | Creek | Oklahoma | 40037 | 6409 | 109 |
1042687 | 1042687 | 2021-02-18 | Creek | Oklahoma | 40037 | 6372 | 108 |
1039442 | 1039442 | 2021-02-17 | Creek | Oklahoma | 40037 | 6357 | 108 |
1036197 | 1036197 | 2021-02-16 | Creek | Oklahoma | 40037 | 6327 | 106 |
1032952 | 1032952 | 2021-02-15 | Creek | Oklahoma | 40037 | 6317 | 106 |
1029706 | 1029706 | 2021-02-14 | Creek | Oklahoma | 40037 | 6310 | 106 |
1026459 | 1026459 | 2021-02-13 | Creek | Oklahoma | 40037 | 6294 | 106 |
1023214 | 1023214 | 2021-02-12 | Creek | Oklahoma | 40037 | 6263 | 106 |
1019969 | 1019969 | 2021-02-11 | Creek | Oklahoma | 40037 | 6235 | 106 |
1016724 | 1016724 | 2021-02-10 | Creek | Oklahoma | 40037 | 6199 | 104 |
1013479 | 1013479 | 2021-02-09 | Creek | Oklahoma | 40037 | 6172 | 103 |
1010234 | 1010234 | 2021-02-08 | Creek | Oklahoma | 40037 | 6152 | 103 |
1006988 | 1006988 | 2021-02-07 | Creek | Oklahoma | 40037 | 6124 | 102 |
1003742 | 1003742 | 2021-02-06 | Creek | Oklahoma | 40037 | 6074 | 101 |
1000496 | 1000496 | 2021-02-05 | Creek | Oklahoma | 40037 | 6045 | 101 |
997250 | 997250 | 2021-02-04 | Creek | Oklahoma | 40037 | 5986 | 101 |
994004 | 994004 | 2021-02-03 | Creek | Oklahoma | 40037 | 5897 | 101 |
990758 | 990758 | 2021-02-02 | Creek | Oklahoma | 40037 | 5856 | 99 |
987512 | 987512 | 2021-02-01 | Creek | Oklahoma | 40037 | 5830 | 98 |
984265 | 984265 | 2021-01-31 | Creek | Oklahoma | 40037 | 5807 | 95 |
981018 | 981018 | 2021-01-30 | Creek | Oklahoma | 40037 | 5764 | 92 |
977772 | 977772 | 2021-01-29 | Creek | Oklahoma | 40037 | 5705 | 92 |
974527 | 974527 | 2021-01-28 | Creek | Oklahoma | 40037 | 5669 | 91 |
971282 | 971282 | 2021-01-27 | Creek | Oklahoma | 40037 | 5614 | 88 |
968037 | 968037 | 2021-01-26 | Creek | Oklahoma | 40037 | 5544 | 85 |
964793 | 964793 | 2021-01-25 | Creek | Oklahoma | 40037 | 5512 | 85 |
961548 | 961548 | 2021-01-24 | Creek | Oklahoma | 40037 | 5485 | 84 |
958303 | 958303 | 2021-01-23 | Creek | Oklahoma | 40037 | 5432 | 83 |
955057 | 955057 | 2021-01-22 | Creek | Oklahoma | 40037 | 5352 | 81 |
951812 | 951812 | 2021-01-21 | Creek | Oklahoma | 40037 | 5302 | 81 |
948567 | 948567 | 2021-01-20 | Creek | Oklahoma | 40037 | 5230 | 81 |
945321 | 945321 | 2021-01-19 | Creek | Oklahoma | 40037 | 5208 | 81 |
942074 | 942074 | 2021-01-18 | Creek | Oklahoma | 40037 | 5154 | 80 |
938829 | 938829 | 2021-01-17 | Creek | Oklahoma | 40037 | 5132 | 79 |
935584 | 935584 | 2021-01-16 | Creek | Oklahoma | 40037 | 5077 | 76 |
932339 | 932339 | 2021-01-15 | Creek | Oklahoma | 40037 | 5039 | 74 |
929094 | 929094 | 2021-01-14 | Creek | Oklahoma | 40037 | 4972 | 73 |
925849 | 925849 | 2021-01-13 | Creek | Oklahoma | 40037 | 4908 | 72 |
922603 | 922603 | 2021-01-12 | Creek | Oklahoma | 40037 | 4813 | 72 |
919358 | 919358 | 2021-01-11 | Creek | Oklahoma | 40037 | 4775 | 72 |
916113 | 916113 | 2021-01-10 | Creek | Oklahoma | 40037 | 4707 | 72 |
912868 | 912868 | 2021-01-09 | Creek | Oklahoma | 40037 | 4568 | 71 |
909623 | 909623 | 2021-01-08 | Creek | Oklahoma | 40037 | 4494 | 71 |
906378 | 906378 | 2021-01-07 | Creek | Oklahoma | 40037 | 4438 | 70 |
903132 | 903132 | 2021-01-06 | Creek | Oklahoma | 40037 | 4384 | 68 |
899887 | 899887 | 2021-01-05 | Creek | Oklahoma | 40037 | 4346 | 66 |
896642 | 896642 | 2021-01-04 | Creek | Oklahoma | 40037 | 4312 | 66 |
893396 | 893396 | 2021-01-03 | Creek | Oklahoma | 40037 | 4276 | 66 |
890150 | 890150 | 2021-01-02 | Creek | Oklahoma | 40037 | 4173 | 66 |
886903 | 886903 | 2021-01-01 | Creek | Oklahoma | 40037 | 4079 | 64 |
883658 | 883658 | 2020-12-31 | Creek | Oklahoma | 40037 | 4079 | 64 |
880413 | 880413 | 2020-12-30 | Creek | Oklahoma | 40037 | 4032 | 64 |
877168 | 877168 | 2020-12-29 | Creek | Oklahoma | 40037 | 3988 | 64 |
873923 | 873923 | 2020-12-28 | Creek | Oklahoma | 40037 | 3975 | 63 |
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);