ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 48439 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280386 | 1280386 | 2021-05-02 | Tarrant | Texas | 48439 | 256962 | 3419 |
1277139 | 1277139 | 2021-05-01 | Tarrant | Texas | 48439 | 256779 | 3419 |
1273892 | 1273892 | 2021-04-30 | Tarrant | Texas | 48439 | 256779 | 3419 |
1270645 | 1270645 | 2021-04-29 | Tarrant | Texas | 48439 | 256508 | 3417 |
1267398 | 1267398 | 2021-04-28 | Tarrant | Texas | 48439 | 256333 | 3411 |
1264151 | 1264151 | 2021-04-27 | Tarrant | Texas | 48439 | 256188 | 3404 |
1260904 | 1260904 | 2021-04-26 | Tarrant | Texas | 48439 | 255984 | 3402 |
1257657 | 1257657 | 2021-04-25 | Tarrant | Texas | 48439 | 255681 | 3383 |
1254410 | 1254410 | 2021-04-24 | Tarrant | Texas | 48439 | 255483 | 3383 |
1251163 | 1251163 | 2021-04-23 | Tarrant | Texas | 48439 | 255483 | 3383 |
1247916 | 1247916 | 2021-04-22 | Tarrant | Texas | 48439 | 255309 | 3382 |
1244669 | 1244669 | 2021-04-21 | Tarrant | Texas | 48439 | 255063 | 3379 |
1241422 | 1241422 | 2021-04-20 | Tarrant | Texas | 48439 | 254915 | 3378 |
1238175 | 1238175 | 2021-04-19 | Tarrant | Texas | 48439 | 254723 | 3375 |
1234928 | 1234928 | 2021-04-18 | Tarrant | Texas | 48439 | 254424 | 3371 |
1231680 | 1231680 | 2021-04-17 | Tarrant | Texas | 48439 | 254188 | 3371 |
1228432 | 1228432 | 2021-04-16 | Tarrant | Texas | 48439 | 254188 | 3371 |
1225184 | 1225184 | 2021-04-15 | Tarrant | Texas | 48439 | 253954 | 3369 |
1221937 | 1221937 | 2021-04-14 | Tarrant | Texas | 48439 | 253672 | 3365 |
1218689 | 1218689 | 2021-04-13 | Tarrant | Texas | 48439 | 253402 | 3360 |
1215441 | 1215441 | 2021-04-12 | Tarrant | Texas | 48439 | 253211 | 3357 |
1212194 | 1212194 | 2021-04-11 | Tarrant | Texas | 48439 | 252872 | 3351 |
1208945 | 1208945 | 2021-04-10 | Tarrant | Texas | 48439 | 252669 | 3351 |
1205697 | 1205697 | 2021-04-09 | Tarrant | Texas | 48439 | 252669 | 3351 |
1202449 | 1202449 | 2021-04-08 | Tarrant | Texas | 48439 | 252461 | 3340 |
1199200 | 1199200 | 2021-04-07 | Tarrant | Texas | 48439 | 252138 | 3333 |
1195951 | 1195951 | 2021-04-06 | Tarrant | Texas | 48439 | 251896 | 3324 |
1192703 | 1192703 | 2021-04-05 | Tarrant | Texas | 48439 | 251316 | 3314 |
1189454 | 1189454 | 2021-04-04 | Tarrant | Texas | 48439 | 251106 | 3300 |
1186207 | 1186207 | 2021-04-03 | Tarrant | Texas | 48439 | 251106 | 3300 |
1182960 | 1182960 | 2021-04-02 | Tarrant | Texas | 48439 | 251106 | 3300 |
1179713 | 1179713 | 2021-04-01 | Tarrant | Texas | 48439 | 251106 | 3300 |
1176466 | 1176466 | 2021-03-31 | Tarrant | Texas | 48439 | 250869 | 3290 |
1173219 | 1173219 | 2021-03-30 | Tarrant | Texas | 48439 | 250646 | 3284 |
1169972 | 1169972 | 2021-03-29 | Tarrant | Texas | 48439 | 250493 | 3277 |
1166724 | 1166724 | 2021-03-28 | Tarrant | Texas | 48439 | 250093 | 3258 |
1163476 | 1163476 | 2021-03-27 | Tarrant | Texas | 48439 | 249921 | 3258 |
1160227 | 1160227 | 2021-03-26 | Tarrant | Texas | 48439 | 249921 | 3258 |
1156980 | 1156980 | 2021-03-25 | Tarrant | Texas | 48439 | 249821 | 3240 |
1153733 | 1153733 | 2021-03-24 | Tarrant | Texas | 48439 | 249679 | 3231 |
1150486 | 1150486 | 2021-03-23 | Tarrant | Texas | 48439 | 249418 | 3226 |
1147239 | 1147239 | 2021-03-22 | Tarrant | Texas | 48439 | 249150 | 3222 |
1143992 | 1143992 | 2021-03-21 | Tarrant | Texas | 48439 | 248748 | 3184 |
1140745 | 1140745 | 2021-03-20 | Tarrant | Texas | 48439 | 248606 | 3184 |
1137499 | 1137499 | 2021-03-19 | Tarrant | Texas | 48439 | 248606 | 3184 |
1134253 | 1134253 | 2021-03-18 | Tarrant | Texas | 48439 | 248317 | 3160 |
1131005 | 1131005 | 2021-03-17 | Tarrant | Texas | 48439 | 248102 | 3147 |
1127758 | 1127758 | 2021-03-16 | Tarrant | Texas | 48439 | 247779 | 3138 |
1124512 | 1124512 | 2021-03-15 | Tarrant | Texas | 48439 | 247549 | 3132 |
1121266 | 1121266 | 2021-03-14 | Tarrant | Texas | 48439 | 247136 | 3074 |
1118019 | 1118019 | 2021-03-13 | Tarrant | Texas | 48439 | 246833 | 3074 |
1114772 | 1114772 | 2021-03-12 | Tarrant | Texas | 48439 | 246833 | 3074 |
1111526 | 1111526 | 2021-03-11 | Tarrant | Texas | 48439 | 246510 | 3038 |
1108280 | 1108280 | 2021-03-10 | Tarrant | Texas | 48439 | 246077 | 3030 |
1105034 | 1105034 | 2021-03-09 | Tarrant | Texas | 48439 | 245629 | 3028 |
1101788 | 1101788 | 2021-03-08 | Tarrant | Texas | 48439 | 245385 | 3021 |
1098542 | 1098542 | 2021-03-07 | Tarrant | Texas | 48439 | 244957 | 2967 |
1095294 | 1095294 | 2021-03-06 | Tarrant | Texas | 48439 | 244632 | 2967 |
1092048 | 1092048 | 2021-03-05 | Tarrant | Texas | 48439 | 244632 | 2967 |
1088802 | 1088802 | 2021-03-04 | Tarrant | Texas | 48439 | 244231 | 2930 |
1085557 | 1085557 | 2021-03-03 | Tarrant | Texas | 48439 | 243725 | 2912 |
1082311 | 1082311 | 2021-03-02 | Tarrant | Texas | 48439 | 243067 | 2897 |
1079065 | 1079065 | 2021-03-01 | Tarrant | Texas | 48439 | 242638 | 2883 |
1075820 | 1075820 | 2021-02-28 | Tarrant | Texas | 48439 | 241650 | 2841 |
1072574 | 1072574 | 2021-02-27 | Tarrant | Texas | 48439 | 241650 | 2841 |
1069328 | 1069328 | 2021-02-26 | Tarrant | Texas | 48439 | 241005 | 2841 |
1066083 | 1066083 | 2021-02-25 | Tarrant | Texas | 48439 | 240416 | 2818 |
1062838 | 1062838 | 2021-02-24 | Tarrant | Texas | 48439 | 239658 | 2805 |
1059593 | 1059593 | 2021-02-23 | Tarrant | Texas | 48439 | 239188 | 2794 |
1056347 | 1056347 | 2021-02-22 | Tarrant | Texas | 48439 | 238820 | 2789 |
1053101 | 1053101 | 2021-02-21 | Tarrant | Texas | 48439 | 238077 | 2731 |
1049854 | 1049854 | 2021-02-20 | Tarrant | Texas | 48439 | 238077 | 2731 |
1046607 | 1046607 | 2021-02-19 | Tarrant | Texas | 48439 | 237676 | 2731 |
1043362 | 1043362 | 2021-02-18 | Tarrant | Texas | 48439 | 236911 | 2689 |
1040117 | 1040117 | 2021-02-17 | Tarrant | Texas | 48439 | 236461 | 2671 |
1036872 | 1036872 | 2021-02-16 | Tarrant | Texas | 48439 | 235964 | 2625 |
1033627 | 1033627 | 2021-02-15 | Tarrant | Texas | 48439 | 235964 | 2625 |
1030381 | 1030381 | 2021-02-14 | Tarrant | Texas | 48439 | 235167 | 2625 |
1027134 | 1027134 | 2021-02-13 | Tarrant | Texas | 48439 | 234246 | 2625 |
1023889 | 1023889 | 2021-02-12 | Tarrant | Texas | 48439 | 234246 | 2625 |
1020644 | 1020644 | 2021-02-11 | Tarrant | Texas | 48439 | 233326 | 2554 |
1017399 | 1017399 | 2021-02-10 | Tarrant | Texas | 48439 | 232292 | 2529 |
1014154 | 1014154 | 2021-02-09 | Tarrant | Texas | 48439 | 230981 | 2509 |
1010909 | 1010909 | 2021-02-08 | Tarrant | Texas | 48439 | 230088 | 2473 |
1007663 | 1007663 | 2021-02-07 | Tarrant | Texas | 48439 | 228038 | 2387 |
1004417 | 1004417 | 2021-02-06 | Tarrant | Texas | 48439 | 226793 | 2387 |
1001171 | 1001171 | 2021-02-05 | Tarrant | Texas | 48439 | 226793 | 2387 |
997925 | 997925 | 2021-02-04 | Tarrant | Texas | 48439 | 225399 | 2306 |
994679 | 994679 | 2021-02-03 | Tarrant | Texas | 48439 | 223736 | 2291 |
991433 | 991433 | 2021-02-02 | Tarrant | Texas | 48439 | 222111 | 2277 |
988187 | 988187 | 2021-02-01 | Tarrant | Texas | 48439 | 220685 | 2240 |
984940 | 984940 | 2021-01-31 | Tarrant | Texas | 48439 | 216910 | 2160 |
981693 | 981693 | 2021-01-30 | Tarrant | Texas | 48439 | 215048 | 2160 |
978447 | 978447 | 2021-01-29 | Tarrant | Texas | 48439 | 215048 | 2160 |
975202 | 975202 | 2021-01-28 | Tarrant | Texas | 48439 | 213611 | 2123 |
971957 | 971957 | 2021-01-27 | Tarrant | Texas | 48439 | 211076 | 2113 |
968712 | 968712 | 2021-01-26 | Tarrant | Texas | 48439 | 208325 | 2072 |
965468 | 965468 | 2021-01-25 | Tarrant | Texas | 48439 | 208325 | 2072 |
962223 | 962223 | 2021-01-24 | Tarrant | Texas | 48439 | 205329 | 1991 |
958978 | 958978 | 2021-01-23 | Tarrant | Texas | 48439 | 203174 | 1991 |
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);