ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48423 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280378 | 1280378 | 2021-05-02 | Smith | Texas | 48423 | 20149 | 467 |
1277131 | 1277131 | 2021-05-01 | Smith | Texas | 48423 | 20149 | 466 |
1273884 | 1273884 | 2021-04-30 | Smith | Texas | 48423 | 20149 | 465 |
1270637 | 1270637 | 2021-04-29 | Smith | Texas | 48423 | 20078 | 465 |
1267390 | 1267390 | 2021-04-28 | Smith | Texas | 48423 | 20078 | 463 |
1264143 | 1264143 | 2021-04-27 | Smith | Texas | 48423 | 20078 | 463 |
1260896 | 1260896 | 2021-04-26 | Smith | Texas | 48423 | 20024 | 462 |
1257649 | 1257649 | 2021-04-25 | Smith | Texas | 48423 | 20024 | 462 |
1254402 | 1254402 | 2021-04-24 | Smith | Texas | 48423 | 20024 | 462 |
1251155 | 1251155 | 2021-04-23 | Smith | Texas | 48423 | 20024 | 462 |
1247908 | 1247908 | 2021-04-22 | Smith | Texas | 48423 | 20024 | 462 |
1244661 | 1244661 | 2021-04-21 | Smith | Texas | 48423 | 19927 | 459 |
1241414 | 1241414 | 2021-04-20 | Smith | Texas | 48423 | 19927 | 459 |
1238167 | 1238167 | 2021-04-19 | Smith | Texas | 48423 | 19868 | 459 |
1234920 | 1234920 | 2021-04-18 | Smith | Texas | 48423 | 19868 | 459 |
1231672 | 1231672 | 2021-04-17 | Smith | Texas | 48423 | 19868 | 457 |
1228424 | 1228424 | 2021-04-16 | Smith | Texas | 48423 | 19868 | 457 |
1225176 | 1225176 | 2021-04-15 | Smith | Texas | 48423 | 19868 | 456 |
1221929 | 1221929 | 2021-04-14 | Smith | Texas | 48423 | 19789 | 455 |
1218681 | 1218681 | 2021-04-13 | Smith | Texas | 48423 | 19789 | 454 |
1215433 | 1215433 | 2021-04-12 | Smith | Texas | 48423 | 19789 | 452 |
1212186 | 1212186 | 2021-04-11 | Smith | Texas | 48423 | 19696 | 452 |
1208937 | 1208937 | 2021-04-10 | Smith | Texas | 48423 | 19696 | 452 |
1205689 | 1205689 | 2021-04-09 | Smith | Texas | 48423 | 19696 | 450 |
1202441 | 1202441 | 2021-04-08 | Smith | Texas | 48423 | 19696 | 450 |
1199192 | 1199192 | 2021-04-07 | Smith | Texas | 48423 | 19624 | 449 |
1195943 | 1195943 | 2021-04-06 | Smith | Texas | 48423 | 19624 | 449 |
1192695 | 1192695 | 2021-04-05 | Smith | Texas | 48423 | 19624 | 448 |
1189446 | 1189446 | 2021-04-04 | Smith | Texas | 48423 | 19573 | 448 |
1186199 | 1186199 | 2021-04-03 | Smith | Texas | 48423 | 19573 | 447 |
1182952 | 1182952 | 2021-04-02 | Smith | Texas | 48423 | 19573 | 447 |
1179705 | 1179705 | 2021-04-01 | Smith | Texas | 48423 | 19573 | 447 |
1176458 | 1176458 | 2021-03-31 | Smith | Texas | 48423 | 19524 | 446 |
1173211 | 1173211 | 2021-03-30 | Smith | Texas | 48423 | 19524 | 444 |
1169964 | 1169964 | 2021-03-29 | Smith | Texas | 48423 | 19524 | 442 |
1166716 | 1166716 | 2021-03-28 | Smith | Texas | 48423 | 19454 | 442 |
1163468 | 1163468 | 2021-03-27 | Smith | Texas | 48423 | 19454 | 441 |
1160219 | 1160219 | 2021-03-26 | Smith | Texas | 48423 | 19454 | 441 |
1156972 | 1156972 | 2021-03-25 | Smith | Texas | 48423 | 19454 | 440 |
1153725 | 1153725 | 2021-03-24 | Smith | Texas | 48423 | 19368 | 439 |
1150478 | 1150478 | 2021-03-23 | Smith | Texas | 48423 | 19368 | 439 |
1147231 | 1147231 | 2021-03-22 | Smith | Texas | 48423 | 19368 | 439 |
1143984 | 1143984 | 2021-03-21 | Smith | Texas | 48423 | 19308 | 438 |
1140737 | 1140737 | 2021-03-20 | Smith | Texas | 48423 | 19308 | 438 |
1137491 | 1137491 | 2021-03-19 | Smith | Texas | 48423 | 19308 | 433 |
1134245 | 1134245 | 2021-03-18 | Smith | Texas | 48423 | 19248 | 431 |
1130997 | 1130997 | 2021-03-17 | Smith | Texas | 48423 | 19248 | 428 |
1127750 | 1127750 | 2021-03-16 | Smith | Texas | 48423 | 19188 | 427 |
1124504 | 1124504 | 2021-03-15 | Smith | Texas | 48423 | 19119 | 422 |
1121258 | 1121258 | 2021-03-14 | Smith | Texas | 48423 | 19107 | 422 |
1118011 | 1118011 | 2021-03-13 | Smith | Texas | 48423 | 19107 | 422 |
1114764 | 1114764 | 2021-03-12 | Smith | Texas | 48423 | 19107 | 419 |
1111518 | 1111518 | 2021-03-11 | Smith | Texas | 48423 | 19080 | 417 |
1108272 | 1108272 | 2021-03-10 | Smith | Texas | 48423 | 19029 | 416 |
1105026 | 1105026 | 2021-03-09 | Smith | Texas | 48423 | 19029 | 415 |
1101780 | 1101780 | 2021-03-08 | Smith | Texas | 48423 | 19029 | 411 |
1098534 | 1098534 | 2021-03-07 | Smith | Texas | 48423 | 18989 | 411 |
1095286 | 1095286 | 2021-03-06 | Smith | Texas | 48423 | 18989 | 410 |
1092040 | 1092040 | 2021-03-05 | Smith | Texas | 48423 | 18989 | 410 |
1088794 | 1088794 | 2021-03-04 | Smith | Texas | 48423 | 18944 | 410 |
1085549 | 1085549 | 2021-03-03 | Smith | Texas | 48423 | 18944 | 407 |
1082303 | 1082303 | 2021-03-02 | Smith | Texas | 48423 | 18896 | 406 |
1079057 | 1079057 | 2021-03-01 | Smith | Texas | 48423 | 18896 | 405 |
1075812 | 1075812 | 2021-02-28 | Smith | Texas | 48423 | 18831 | 405 |
1072566 | 1072566 | 2021-02-27 | Smith | Texas | 48423 | 18831 | 404 |
1069320 | 1069320 | 2021-02-26 | Smith | Texas | 48423 | 18831 | 401 |
1066075 | 1066075 | 2021-02-25 | Smith | Texas | 48423 | 18743 | 396 |
1062830 | 1062830 | 2021-02-24 | Smith | Texas | 48423 | 18634 | 391 |
1059585 | 1059585 | 2021-02-23 | Smith | Texas | 48423 | 18634 | 389 |
1056339 | 1056339 | 2021-02-22 | Smith | Texas | 48423 | 18634 | 389 |
1053093 | 1053093 | 2021-02-21 | Smith | Texas | 48423 | 18555 | 388 |
1049846 | 1049846 | 2021-02-20 | Smith | Texas | 48423 | 18555 | 387 |
1046599 | 1046599 | 2021-02-19 | Smith | Texas | 48423 | 18555 | 387 |
1043354 | 1043354 | 2021-02-18 | Smith | Texas | 48423 | 18535 | 387 |
1040109 | 1040109 | 2021-02-17 | Smith | Texas | 48423 | 18535 | 387 |
1036864 | 1036864 | 2021-02-16 | Smith | Texas | 48423 | 18476 | 387 |
1033619 | 1033619 | 2021-02-15 | Smith | Texas | 48423 | 18366 | 387 |
1030373 | 1030373 | 2021-02-14 | Smith | Texas | 48423 | 18366 | 387 |
1027126 | 1027126 | 2021-02-13 | Smith | Texas | 48423 | 18366 | 387 |
1023881 | 1023881 | 2021-02-12 | Smith | Texas | 48423 | 18366 | 383 |
1020636 | 1020636 | 2021-02-11 | Smith | Texas | 48423 | 18230 | 381 |
1017391 | 1017391 | 2021-02-10 | Smith | Texas | 48423 | 18230 | 381 |
1014146 | 1014146 | 2021-02-09 | Smith | Texas | 48423 | 18100 | 378 |
1010901 | 1010901 | 2021-02-08 | Smith | Texas | 48423 | 18100 | 375 |
1007655 | 1007655 | 2021-02-07 | Smith | Texas | 48423 | 17952 | 375 |
1004409 | 1004409 | 2021-02-06 | Smith | Texas | 48423 | 17952 | 371 |
1001163 | 1001163 | 2021-02-05 | Smith | Texas | 48423 | 17952 | 367 |
997917 | 997917 | 2021-02-04 | Smith | Texas | 48423 | 17764 | 362 |
994671 | 994671 | 2021-02-03 | Smith | Texas | 48423 | 17764 | 355 |
991425 | 991425 | 2021-02-02 | Smith | Texas | 48423 | 17553 | 350 |
988179 | 988179 | 2021-02-01 | Smith | Texas | 48423 | 17553 | 347 |
984932 | 984932 | 2021-01-31 | Smith | Texas | 48423 | 17292 | 346 |
981685 | 981685 | 2021-01-30 | Smith | Texas | 48423 | 17292 | 346 |
978439 | 978439 | 2021-01-29 | Smith | Texas | 48423 | 17206 | 340 |
975194 | 975194 | 2021-01-28 | Smith | Texas | 48423 | 17206 | 338 |
971949 | 971949 | 2021-01-27 | Smith | Texas | 48423 | 16779 | 338 |
968704 | 968704 | 2021-01-26 | Smith | Texas | 48423 | 16779 | 329 |
965460 | 965460 | 2021-01-25 | Smith | Texas | 48423 | 16335 | 324 |
962215 | 962215 | 2021-01-24 | Smith | Texas | 48423 | 16335 | 324 |
958970 | 958970 | 2021-01-23 | Smith | Texas | 48423 | 16335 | 323 |
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);