ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48309 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280327 | 1280327 | 2021-05-02 | McLennan | Texas | 48309 | 26984 | 470 |
1277080 | 1277080 | 2021-05-01 | McLennan | Texas | 48309 | 26984 | 470 |
1273833 | 1273833 | 2021-04-30 | McLennan | Texas | 48309 | 26984 | 470 |
1270586 | 1270586 | 2021-04-29 | McLennan | Texas | 48309 | 26896 | 470 |
1267339 | 1267339 | 2021-04-28 | McLennan | Texas | 48309 | 26896 | 470 |
1264092 | 1264092 | 2021-04-27 | McLennan | Texas | 48309 | 26836 | 470 |
1260845 | 1260845 | 2021-04-26 | McLennan | Texas | 48309 | 26822 | 470 |
1257598 | 1257598 | 2021-04-25 | McLennan | Texas | 48309 | 26761 | 470 |
1254351 | 1254351 | 2021-04-24 | McLennan | Texas | 48309 | 26761 | 470 |
1251104 | 1251104 | 2021-04-23 | McLennan | Texas | 48309 | 26761 | 469 |
1247857 | 1247857 | 2021-04-22 | McLennan | Texas | 48309 | 26714 | 468 |
1244610 | 1244610 | 2021-04-21 | McLennan | Texas | 48309 | 26714 | 467 |
1241363 | 1241363 | 2021-04-20 | McLennan | Texas | 48309 | 26670 | 465 |
1238116 | 1238116 | 2021-04-19 | McLennan | Texas | 48309 | 26603 | 465 |
1234869 | 1234869 | 2021-04-18 | McLennan | Texas | 48309 | 26528 | 465 |
1231621 | 1231621 | 2021-04-17 | McLennan | Texas | 48309 | 26528 | 465 |
1228373 | 1228373 | 2021-04-16 | McLennan | Texas | 48309 | 26528 | 465 |
1225125 | 1225125 | 2021-04-15 | McLennan | Texas | 48309 | 26499 | 465 |
1221878 | 1221878 | 2021-04-14 | McLennan | Texas | 48309 | 26473 | 463 |
1218630 | 1218630 | 2021-04-13 | McLennan | Texas | 48309 | 26439 | 463 |
1215382 | 1215382 | 2021-04-12 | McLennan | Texas | 48309 | 26406 | 462 |
1212135 | 1212135 | 2021-04-11 | McLennan | Texas | 48309 | 26347 | 462 |
1208886 | 1208886 | 2021-04-10 | McLennan | Texas | 48309 | 26347 | 462 |
1205638 | 1205638 | 2021-04-09 | McLennan | Texas | 48309 | 26347 | 462 |
1202390 | 1202390 | 2021-04-08 | McLennan | Texas | 48309 | 26324 | 462 |
1199141 | 1199141 | 2021-04-07 | McLennan | Texas | 48309 | 26297 | 462 |
1195892 | 1195892 | 2021-04-06 | McLennan | Texas | 48309 | 26262 | 462 |
1192644 | 1192644 | 2021-04-05 | McLennan | Texas | 48309 | 26236 | 462 |
1189395 | 1189395 | 2021-04-04 | McLennan | Texas | 48309 | 26164 | 462 |
1186148 | 1186148 | 2021-04-03 | McLennan | Texas | 48309 | 26164 | 462 |
1182901 | 1182901 | 2021-04-02 | McLennan | Texas | 48309 | 26164 | 461 |
1179654 | 1179654 | 2021-04-01 | McLennan | Texas | 48309 | 26164 | 461 |
1176407 | 1176407 | 2021-03-31 | McLennan | Texas | 48309 | 26122 | 461 |
1173160 | 1173160 | 2021-03-30 | McLennan | Texas | 48309 | 26096 | 461 |
1169913 | 1169913 | 2021-03-29 | McLennan | Texas | 48309 | 26074 | 461 |
1166665 | 1166665 | 2021-03-28 | McLennan | Texas | 48309 | 25991 | 461 |
1163417 | 1163417 | 2021-03-27 | McLennan | Texas | 48309 | 25991 | 461 |
1160168 | 1160168 | 2021-03-26 | McLennan | Texas | 48309 | 25991 | 461 |
1156921 | 1156921 | 2021-03-25 | McLennan | Texas | 48309 | 25950 | 461 |
1153674 | 1153674 | 2021-03-24 | McLennan | Texas | 48309 | 25920 | 459 |
1150427 | 1150427 | 2021-03-23 | McLennan | Texas | 48309 | 25885 | 458 |
1147180 | 1147180 | 2021-03-22 | McLennan | Texas | 48309 | 25846 | 457 |
1143933 | 1143933 | 2021-03-21 | McLennan | Texas | 48309 | 25747 | 455 |
1140686 | 1140686 | 2021-03-20 | McLennan | Texas | 48309 | 25747 | 452 |
1137440 | 1137440 | 2021-03-19 | McLennan | Texas | 48309 | 25747 | 452 |
1134194 | 1134194 | 2021-03-18 | McLennan | Texas | 48309 | 25713 | 452 |
1130946 | 1130946 | 2021-03-17 | McLennan | Texas | 48309 | 25678 | 452 |
1127699 | 1127699 | 2021-03-16 | McLennan | Texas | 48309 | 25644 | 452 |
1124453 | 1124453 | 2021-03-15 | McLennan | Texas | 48309 | 25592 | 451 |
1121207 | 1121207 | 2021-03-14 | McLennan | Texas | 48309 | 25521 | 451 |
1117960 | 1117960 | 2021-03-13 | McLennan | Texas | 48309 | 25521 | 450 |
1114713 | 1114713 | 2021-03-12 | McLennan | Texas | 48309 | 25521 | 450 |
1111467 | 1111467 | 2021-03-11 | McLennan | Texas | 48309 | 25493 | 449 |
1108221 | 1108221 | 2021-03-10 | McLennan | Texas | 48309 | 25455 | 449 |
1104975 | 1104975 | 2021-03-09 | McLennan | Texas | 48309 | 25428 | 447 |
1101729 | 1101729 | 2021-03-08 | McLennan | Texas | 48309 | 25387 | 444 |
1098483 | 1098483 | 2021-03-07 | McLennan | Texas | 48309 | 25335 | 443 |
1095235 | 1095235 | 2021-03-06 | McLennan | Texas | 48309 | 25335 | 443 |
1091989 | 1091989 | 2021-03-05 | McLennan | Texas | 48309 | 25335 | 443 |
1088743 | 1088743 | 2021-03-04 | McLennan | Texas | 48309 | 25291 | 441 |
1085498 | 1085498 | 2021-03-03 | McLennan | Texas | 48309 | 25237 | 440 |
1082252 | 1082252 | 2021-03-02 | McLennan | Texas | 48309 | 25192 | 440 |
1079006 | 1079006 | 2021-03-01 | McLennan | Texas | 48309 | 25132 | 437 |
1075761 | 1075761 | 2021-02-28 | McLennan | Texas | 48309 | 25024 | 437 |
1072515 | 1072515 | 2021-02-27 | McLennan | Texas | 48309 | 25024 | 435 |
1069269 | 1069269 | 2021-02-26 | McLennan | Texas | 48309 | 25024 | 434 |
1066024 | 1066024 | 2021-02-25 | McLennan | Texas | 48309 | 24966 | 431 |
1062779 | 1062779 | 2021-02-24 | McLennan | Texas | 48309 | 24896 | 429 |
1059534 | 1059534 | 2021-02-23 | McLennan | Texas | 48309 | 24826 | 427 |
1056288 | 1056288 | 2021-02-22 | McLennan | Texas | 48309 | 24747 | 424 |
1053042 | 1053042 | 2021-02-21 | McLennan | Texas | 48309 | 24268 | 424 |
1049795 | 1049795 | 2021-02-20 | McLennan | Texas | 48309 | 24268 | 423 |
1046548 | 1046548 | 2021-02-19 | McLennan | Texas | 48309 | 24268 | 421 |
1043303 | 1043303 | 2021-02-18 | McLennan | Texas | 48309 | 24268 | 421 |
1040058 | 1040058 | 2021-02-17 | McLennan | Texas | 48309 | 24268 | 420 |
1036813 | 1036813 | 2021-02-16 | McLennan | Texas | 48309 | 24268 | 419 |
1033568 | 1033568 | 2021-02-15 | McLennan | Texas | 48309 | 24268 | 419 |
1030322 | 1030322 | 2021-02-14 | McLennan | Texas | 48309 | 24245 | 419 |
1027075 | 1027075 | 2021-02-13 | McLennan | Texas | 48309 | 24245 | 419 |
1023830 | 1023830 | 2021-02-12 | McLennan | Texas | 48309 | 24214 | 414 |
1020585 | 1020585 | 2021-02-11 | McLennan | Texas | 48309 | 24168 | 410 |
1017340 | 1017340 | 2021-02-10 | McLennan | Texas | 48309 | 24112 | 406 |
1014095 | 1014095 | 2021-02-09 | McLennan | Texas | 48309 | 23953 | 405 |
1010850 | 1010850 | 2021-02-08 | McLennan | Texas | 48309 | 23826 | 402 |
1007604 | 1007604 | 2021-02-07 | McLennan | Texas | 48309 | 23624 | 402 |
1004358 | 1004358 | 2021-02-06 | McLennan | Texas | 48309 | 23575 | 395 |
1001112 | 1001112 | 2021-02-05 | McLennan | Texas | 48309 | 23575 | 390 |
997866 | 997866 | 2021-02-04 | McLennan | Texas | 48309 | 23499 | 388 |
994620 | 994620 | 2021-02-03 | McLennan | Texas | 48309 | 23444 | 385 |
991374 | 991374 | 2021-02-02 | McLennan | Texas | 48309 | 23333 | 380 |
988128 | 988128 | 2021-02-01 | McLennan | Texas | 48309 | 23284 | 379 |
984881 | 984881 | 2021-01-31 | McLennan | Texas | 48309 | 23200 | 379 |
981634 | 981634 | 2021-01-30 | McLennan | Texas | 48309 | 23200 | 378 |
978388 | 978388 | 2021-01-29 | McLennan | Texas | 48309 | 23140 | 374 |
975143 | 975143 | 2021-01-28 | McLennan | Texas | 48309 | 23074 | 370 |
971898 | 971898 | 2021-01-27 | McLennan | Texas | 48309 | 22994 | 366 |
968653 | 968653 | 2021-01-26 | McLennan | Texas | 48309 | 22846 | 365 |
965409 | 965409 | 2021-01-25 | McLennan | Texas | 48309 | 22801 | 363 |
962164 | 962164 | 2021-01-24 | McLennan | Texas | 48309 | 22657 | 363 |
958919 | 958919 | 2021-01-23 | McLennan | Texas | 48309 | 22657 | 362 |
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);