ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 48103 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280218 | 1280218 | 2021-05-02 | Crane | Texas | 48103 | 530 | 12 |
1276971 | 1276971 | 2021-05-01 | Crane | Texas | 48103 | 530 | 12 |
1273724 | 1273724 | 2021-04-30 | Crane | Texas | 48103 | 529 | 12 |
1270477 | 1270477 | 2021-04-29 | Crane | Texas | 48103 | 528 | 12 |
1267230 | 1267230 | 2021-04-28 | Crane | Texas | 48103 | 528 | 12 |
1263983 | 1263983 | 2021-04-27 | Crane | Texas | 48103 | 528 | 12 |
1260736 | 1260736 | 2021-04-26 | Crane | Texas | 48103 | 527 | 12 |
1257489 | 1257489 | 2021-04-25 | Crane | Texas | 48103 | 527 | 12 |
1254242 | 1254242 | 2021-04-24 | Crane | Texas | 48103 | 527 | 12 |
1250995 | 1250995 | 2021-04-23 | Crane | Texas | 48103 | 527 | 12 |
1247748 | 1247748 | 2021-04-22 | Crane | Texas | 48103 | 526 | 12 |
1244501 | 1244501 | 2021-04-21 | Crane | Texas | 48103 | 525 | 12 |
1241254 | 1241254 | 2021-04-20 | Crane | Texas | 48103 | 523 | 12 |
1238007 | 1238007 | 2021-04-19 | Crane | Texas | 48103 | 523 | 12 |
1234760 | 1234760 | 2021-04-18 | Crane | Texas | 48103 | 523 | 12 |
1231512 | 1231512 | 2021-04-17 | Crane | Texas | 48103 | 523 | 12 |
1228264 | 1228264 | 2021-04-16 | Crane | Texas | 48103 | 522 | 12 |
1225016 | 1225016 | 2021-04-15 | Crane | Texas | 48103 | 522 | 12 |
1221769 | 1221769 | 2021-04-14 | Crane | Texas | 48103 | 521 | 12 |
1218521 | 1218521 | 2021-04-13 | Crane | Texas | 48103 | 521 | 12 |
1215273 | 1215273 | 2021-04-12 | Crane | Texas | 48103 | 521 | 12 |
1212026 | 1212026 | 2021-04-11 | Crane | Texas | 48103 | 521 | 12 |
1208777 | 1208777 | 2021-04-10 | Crane | Texas | 48103 | 521 | 12 |
1205529 | 1205529 | 2021-04-09 | Crane | Texas | 48103 | 521 | 12 |
1202281 | 1202281 | 2021-04-08 | Crane | Texas | 48103 | 521 | 12 |
1199032 | 1199032 | 2021-04-07 | Crane | Texas | 48103 | 521 | 12 |
1195783 | 1195783 | 2021-04-06 | Crane | Texas | 48103 | 520 | 12 |
1192535 | 1192535 | 2021-04-05 | Crane | Texas | 48103 | 520 | 12 |
1189286 | 1189286 | 2021-04-04 | Crane | Texas | 48103 | 520 | 12 |
1186039 | 1186039 | 2021-04-03 | Crane | Texas | 48103 | 520 | 12 |
1182792 | 1182792 | 2021-04-02 | Crane | Texas | 48103 | 520 | 12 |
1179545 | 1179545 | 2021-04-01 | Crane | Texas | 48103 | 519 | 12 |
1176298 | 1176298 | 2021-03-31 | Crane | Texas | 48103 | 518 | 12 |
1173051 | 1173051 | 2021-03-30 | Crane | Texas | 48103 | 518 | 12 |
1169804 | 1169804 | 2021-03-29 | Crane | Texas | 48103 | 516 | 12 |
1166556 | 1166556 | 2021-03-28 | Crane | Texas | 48103 | 516 | 12 |
1163308 | 1163308 | 2021-03-27 | Crane | Texas | 48103 | 516 | 12 |
1160059 | 1160059 | 2021-03-26 | Crane | Texas | 48103 | 516 | 12 |
1156812 | 1156812 | 2021-03-25 | Crane | Texas | 48103 | 516 | 12 |
1153565 | 1153565 | 2021-03-24 | Crane | Texas | 48103 | 515 | 12 |
1150318 | 1150318 | 2021-03-23 | Crane | Texas | 48103 | 515 | 12 |
1147071 | 1147071 | 2021-03-22 | Crane | Texas | 48103 | 514 | 12 |
1143824 | 1143824 | 2021-03-21 | Crane | Texas | 48103 | 514 | 12 |
1140577 | 1140577 | 2021-03-20 | Crane | Texas | 48103 | 513 | 12 |
1137331 | 1137331 | 2021-03-19 | Crane | Texas | 48103 | 514 | 12 |
1134085 | 1134085 | 2021-03-18 | Crane | Texas | 48103 | 514 | 12 |
1130837 | 1130837 | 2021-03-17 | Crane | Texas | 48103 | 513 | 12 |
1127590 | 1127590 | 2021-03-16 | Crane | Texas | 48103 | 513 | 12 |
1124344 | 1124344 | 2021-03-15 | Crane | Texas | 48103 | 513 | 12 |
1121098 | 1121098 | 2021-03-14 | Crane | Texas | 48103 | 513 | 12 |
1117851 | 1117851 | 2021-03-13 | Crane | Texas | 48103 | 513 | 12 |
1114604 | 1114604 | 2021-03-12 | Crane | Texas | 48103 | 513 | 12 |
1111358 | 1111358 | 2021-03-11 | Crane | Texas | 48103 | 511 | 12 |
1108112 | 1108112 | 2021-03-10 | Crane | Texas | 48103 | 514 | 12 |
1104866 | 1104866 | 2021-03-09 | Crane | Texas | 48103 | 509 | 12 |
1101620 | 1101620 | 2021-03-08 | Crane | Texas | 48103 | 509 | 12 |
1098374 | 1098374 | 2021-03-07 | Crane | Texas | 48103 | 509 | 12 |
1095126 | 1095126 | 2021-03-06 | Crane | Texas | 48103 | 509 | 12 |
1091880 | 1091880 | 2021-03-05 | Crane | Texas | 48103 | 510 | 12 |
1088634 | 1088634 | 2021-03-04 | Crane | Texas | 48103 | 510 | 12 |
1085389 | 1085389 | 2021-03-03 | Crane | Texas | 48103 | 512 | 12 |
1082143 | 1082143 | 2021-03-02 | Crane | Texas | 48103 | 512 | 12 |
1078897 | 1078897 | 2021-03-01 | Crane | Texas | 48103 | 513 | 12 |
1075652 | 1075652 | 2021-02-28 | Crane | Texas | 48103 | 513 | 12 |
1072406 | 1072406 | 2021-02-27 | Crane | Texas | 48103 | 514 | 11 |
1069160 | 1069160 | 2021-02-26 | Crane | Texas | 48103 | 513 | 11 |
1065915 | 1065915 | 2021-02-25 | Crane | Texas | 48103 | 513 | 11 |
1062670 | 1062670 | 2021-02-24 | Crane | Texas | 48103 | 512 | 11 |
1059425 | 1059425 | 2021-02-23 | Crane | Texas | 48103 | 507 | 11 |
1056179 | 1056179 | 2021-02-22 | Crane | Texas | 48103 | 507 | 11 |
1052933 | 1052933 | 2021-02-21 | Crane | Texas | 48103 | 507 | 11 |
1049686 | 1049686 | 2021-02-20 | Crane | Texas | 48103 | 507 | 11 |
1046439 | 1046439 | 2021-02-19 | Crane | Texas | 48103 | 505 | 11 |
1043194 | 1043194 | 2021-02-18 | Crane | Texas | 48103 | 505 | 11 |
1039949 | 1039949 | 2021-02-17 | Crane | Texas | 48103 | 504 | 11 |
1036704 | 1036704 | 2021-02-16 | Crane | Texas | 48103 | 507 | 11 |
1033459 | 1033459 | 2021-02-15 | Crane | Texas | 48103 | 506 | 11 |
1030213 | 1030213 | 2021-02-14 | Crane | Texas | 48103 | 505 | 11 |
1026966 | 1026966 | 2021-02-13 | Crane | Texas | 48103 | 505 | 11 |
1023721 | 1023721 | 2021-02-12 | Crane | Texas | 48103 | 505 | 11 |
1020476 | 1020476 | 2021-02-11 | Crane | Texas | 48103 | 500 | 11 |
1017231 | 1017231 | 2021-02-10 | Crane | Texas | 48103 | 499 | 11 |
1013986 | 1013986 | 2021-02-09 | Crane | Texas | 48103 | 500 | 11 |
1010741 | 1010741 | 2021-02-08 | Crane | Texas | 48103 | 500 | 11 |
1007495 | 1007495 | 2021-02-07 | Crane | Texas | 48103 | 500 | 11 |
1004249 | 1004249 | 2021-02-06 | Crane | Texas | 48103 | 498 | 11 |
1001003 | 1001003 | 2021-02-05 | Crane | Texas | 48103 | 505 | 11 |
997757 | 997757 | 2021-02-04 | Crane | Texas | 48103 | 499 | 11 |
994511 | 994511 | 2021-02-03 | Crane | Texas | 48103 | 493 | 11 |
991265 | 991265 | 2021-02-02 | Crane | Texas | 48103 | 501 | 11 |
988019 | 988019 | 2021-02-01 | Crane | Texas | 48103 | 501 | 11 |
984772 | 984772 | 2021-01-31 | Crane | Texas | 48103 | 501 | 11 |
981525 | 981525 | 2021-01-30 | Crane | Texas | 48103 | 500 | 11 |
978279 | 978279 | 2021-01-29 | Crane | Texas | 48103 | 500 | 11 |
975034 | 975034 | 2021-01-28 | Crane | Texas | 48103 | 495 | 11 |
971789 | 971789 | 2021-01-27 | Crane | Texas | 48103 | 495 | 11 |
968544 | 968544 | 2021-01-26 | Crane | Texas | 48103 | 491 | 11 |
965300 | 965300 | 2021-01-25 | Crane | Texas | 48103 | 505 | 11 |
962055 | 962055 | 2021-01-24 | Crane | Texas | 48103 | 505 | 11 |
958810 | 958810 | 2021-01-23 | Crane | Texas | 48103 | 504 | 11 |
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);