ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 48165 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280249 | 1280249 | 2021-05-02 | Gaines | Texas | 48165 | 1434 | 43 |
1277002 | 1277002 | 2021-05-01 | Gaines | Texas | 48165 | 1434 | 43 |
1273755 | 1273755 | 2021-04-30 | Gaines | Texas | 48165 | 1434 | 43 |
1270508 | 1270508 | 2021-04-29 | Gaines | Texas | 48165 | 1434 | 43 |
1267261 | 1267261 | 2021-04-28 | Gaines | Texas | 48165 | 1434 | 43 |
1264014 | 1264014 | 2021-04-27 | Gaines | Texas | 48165 | 1433 | 43 |
1260767 | 1260767 | 2021-04-26 | Gaines | Texas | 48165 | 1433 | 43 |
1257520 | 1257520 | 2021-04-25 | Gaines | Texas | 48165 | 1433 | 43 |
1254273 | 1254273 | 2021-04-24 | Gaines | Texas | 48165 | 1433 | 43 |
1251026 | 1251026 | 2021-04-23 | Gaines | Texas | 48165 | 1433 | 43 |
1247779 | 1247779 | 2021-04-22 | Gaines | Texas | 48165 | 1431 | 43 |
1244532 | 1244532 | 2021-04-21 | Gaines | Texas | 48165 | 1431 | 43 |
1241285 | 1241285 | 2021-04-20 | Gaines | Texas | 48165 | 1431 | 43 |
1238038 | 1238038 | 2021-04-19 | Gaines | Texas | 48165 | 1429 | 43 |
1234791 | 1234791 | 2021-04-18 | Gaines | Texas | 48165 | 1429 | 43 |
1231543 | 1231543 | 2021-04-17 | Gaines | Texas | 48165 | 1429 | 43 |
1228295 | 1228295 | 2021-04-16 | Gaines | Texas | 48165 | 1429 | 43 |
1225047 | 1225047 | 2021-04-15 | Gaines | Texas | 48165 | 1423 | 43 |
1221800 | 1221800 | 2021-04-14 | Gaines | Texas | 48165 | 1423 | 43 |
1218552 | 1218552 | 2021-04-13 | Gaines | Texas | 48165 | 1423 | 43 |
1215304 | 1215304 | 2021-04-12 | Gaines | Texas | 48165 | 1423 | 43 |
1212057 | 1212057 | 2021-04-11 | Gaines | Texas | 48165 | 1423 | 43 |
1208808 | 1208808 | 2021-04-10 | Gaines | Texas | 48165 | 1423 | 43 |
1205560 | 1205560 | 2021-04-09 | Gaines | Texas | 48165 | 1423 | 43 |
1202312 | 1202312 | 2021-04-08 | Gaines | Texas | 48165 | 1423 | 43 |
1199063 | 1199063 | 2021-04-07 | Gaines | Texas | 48165 | 1422 | 43 |
1195814 | 1195814 | 2021-04-06 | Gaines | Texas | 48165 | 1421 | 43 |
1192566 | 1192566 | 2021-04-05 | Gaines | Texas | 48165 | 1421 | 43 |
1189317 | 1189317 | 2021-04-04 | Gaines | Texas | 48165 | 1421 | 43 |
1186070 | 1186070 | 2021-04-03 | Gaines | Texas | 48165 | 1421 | 43 |
1182823 | 1182823 | 2021-04-02 | Gaines | Texas | 48165 | 1418 | 43 |
1179576 | 1179576 | 2021-04-01 | Gaines | Texas | 48165 | 1418 | 43 |
1176329 | 1176329 | 2021-03-31 | Gaines | Texas | 48165 | 1418 | 43 |
1173082 | 1173082 | 2021-03-30 | Gaines | Texas | 48165 | 1418 | 43 |
1169835 | 1169835 | 2021-03-29 | Gaines | Texas | 48165 | 1418 | 43 |
1166587 | 1166587 | 2021-03-28 | Gaines | Texas | 48165 | 1418 | 43 |
1163339 | 1163339 | 2021-03-27 | Gaines | Texas | 48165 | 1418 | 43 |
1160090 | 1160090 | 2021-03-26 | Gaines | Texas | 48165 | 1418 | 42 |
1156843 | 1156843 | 2021-03-25 | Gaines | Texas | 48165 | 1418 | 42 |
1153596 | 1153596 | 2021-03-24 | Gaines | Texas | 48165 | 1416 | 42 |
1150349 | 1150349 | 2021-03-23 | Gaines | Texas | 48165 | 1416 | 42 |
1147102 | 1147102 | 2021-03-22 | Gaines | Texas | 48165 | 1416 | 42 |
1143855 | 1143855 | 2021-03-21 | Gaines | Texas | 48165 | 1416 | 42 |
1140608 | 1140608 | 2021-03-20 | Gaines | Texas | 48165 | 1416 | 42 |
1137362 | 1137362 | 2021-03-19 | Gaines | Texas | 48165 | 1416 | 42 |
1134116 | 1134116 | 2021-03-18 | Gaines | Texas | 48165 | 1416 | 42 |
1130868 | 1130868 | 2021-03-17 | Gaines | Texas | 48165 | 1416 | 42 |
1127621 | 1127621 | 2021-03-16 | Gaines | Texas | 48165 | 1416 | 42 |
1124375 | 1124375 | 2021-03-15 | Gaines | Texas | 48165 | 1416 | 42 |
1121129 | 1121129 | 2021-03-14 | Gaines | Texas | 48165 | 1416 | 42 |
1117882 | 1117882 | 2021-03-13 | Gaines | Texas | 48165 | 1416 | 42 |
1114635 | 1114635 | 2021-03-12 | Gaines | Texas | 48165 | 1414 | 42 |
1111389 | 1111389 | 2021-03-11 | Gaines | Texas | 48165 | 1414 | 42 |
1108143 | 1108143 | 2021-03-10 | Gaines | Texas | 48165 | 1414 | 42 |
1104897 | 1104897 | 2021-03-09 | Gaines | Texas | 48165 | 1414 | 42 |
1101651 | 1101651 | 2021-03-08 | Gaines | Texas | 48165 | 1412 | 42 |
1098405 | 1098405 | 2021-03-07 | Gaines | Texas | 48165 | 1412 | 42 |
1095157 | 1095157 | 2021-03-06 | Gaines | Texas | 48165 | 1412 | 42 |
1091911 | 1091911 | 2021-03-05 | Gaines | Texas | 48165 | 1412 | 41 |
1088665 | 1088665 | 2021-03-04 | Gaines | Texas | 48165 | 1412 | 41 |
1085420 | 1085420 | 2021-03-03 | Gaines | Texas | 48165 | 1412 | 41 |
1082174 | 1082174 | 2021-03-02 | Gaines | Texas | 48165 | 1412 | 41 |
1078928 | 1078928 | 2021-03-01 | Gaines | Texas | 48165 | 1412 | 41 |
1075683 | 1075683 | 2021-02-28 | Gaines | Texas | 48165 | 1412 | 41 |
1072437 | 1072437 | 2021-02-27 | Gaines | Texas | 48165 | 1412 | 41 |
1069191 | 1069191 | 2021-02-26 | Gaines | Texas | 48165 | 1412 | 41 |
1065946 | 1065946 | 2021-02-25 | Gaines | Texas | 48165 | 1412 | 40 |
1062701 | 1062701 | 2021-02-24 | Gaines | Texas | 48165 | 1411 | 40 |
1059456 | 1059456 | 2021-02-23 | Gaines | Texas | 48165 | 1411 | 40 |
1056210 | 1056210 | 2021-02-22 | Gaines | Texas | 48165 | 1411 | 40 |
1052964 | 1052964 | 2021-02-21 | Gaines | Texas | 48165 | 1411 | 40 |
1049717 | 1049717 | 2021-02-20 | Gaines | Texas | 48165 | 1411 | 40 |
1046470 | 1046470 | 2021-02-19 | Gaines | Texas | 48165 | 1411 | 39 |
1043225 | 1043225 | 2021-02-18 | Gaines | Texas | 48165 | 1410 | 39 |
1039980 | 1039980 | 2021-02-17 | Gaines | Texas | 48165 | 1409 | 39 |
1036735 | 1036735 | 2021-02-16 | Gaines | Texas | 48165 | 1409 | 39 |
1033490 | 1033490 | 2021-02-15 | Gaines | Texas | 48165 | 1409 | 39 |
1030244 | 1030244 | 2021-02-14 | Gaines | Texas | 48165 | 1409 | 39 |
1026997 | 1026997 | 2021-02-13 | Gaines | Texas | 48165 | 1409 | 39 |
1023752 | 1023752 | 2021-02-12 | Gaines | Texas | 48165 | 1402 | 39 |
1020507 | 1020507 | 2021-02-11 | Gaines | Texas | 48165 | 1402 | 39 |
1017262 | 1017262 | 2021-02-10 | Gaines | Texas | 48165 | 1402 | 39 |
1014017 | 1014017 | 2021-02-09 | Gaines | Texas | 48165 | 1402 | 38 |
1010772 | 1010772 | 2021-02-08 | Gaines | Texas | 48165 | 1394 | 38 |
1007526 | 1007526 | 2021-02-07 | Gaines | Texas | 48165 | 1394 | 38 |
1004280 | 1004280 | 2021-02-06 | Gaines | Texas | 48165 | 1394 | 38 |
1001034 | 1001034 | 2021-02-05 | Gaines | Texas | 48165 | 1394 | 38 |
997788 | 997788 | 2021-02-04 | Gaines | Texas | 48165 | 1389 | 37 |
994542 | 994542 | 2021-02-03 | Gaines | Texas | 48165 | 1386 | 37 |
991296 | 991296 | 2021-02-02 | Gaines | Texas | 48165 | 1382 | 36 |
988050 | 988050 | 2021-02-01 | Gaines | Texas | 48165 | 1382 | 36 |
984803 | 984803 | 2021-01-31 | Gaines | Texas | 48165 | 1382 | 36 |
981556 | 981556 | 2021-01-30 | Gaines | Texas | 48165 | 1379 | 36 |
978310 | 978310 | 2021-01-29 | Gaines | Texas | 48165 | 1379 | 36 |
975065 | 975065 | 2021-01-28 | Gaines | Texas | 48165 | 1379 | 36 |
971820 | 971820 | 2021-01-27 | Gaines | Texas | 48165 | 1376 | 36 |
968575 | 968575 | 2021-01-26 | Gaines | Texas | 48165 | 1354 | 36 |
965331 | 965331 | 2021-01-25 | Gaines | Texas | 48165 | 1354 | 36 |
962086 | 962086 | 2021-01-24 | Gaines | Texas | 48165 | 1354 | 36 |
958841 | 958841 | 2021-01-23 | Gaines | Texas | 48165 | 1354 | 36 |
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);