ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Montgomery" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280336 | 1280336 | 2021-05-02 | Montgomery | Texas | 48339 | 52540 | 562 |
1277089 | 1277089 | 2021-05-01 | Montgomery | Texas | 48339 | 52540 | 562 |
1273842 | 1273842 | 2021-04-30 | Montgomery | Texas | 48339 | 52540 | 561 |
1270595 | 1270595 | 2021-04-29 | Montgomery | Texas | 48339 | 52299 | 560 |
1267348 | 1267348 | 2021-04-28 | Montgomery | Texas | 48339 | 52207 | 557 |
1264101 | 1264101 | 2021-04-27 | Montgomery | Texas | 48339 | 51928 | 555 |
1260854 | 1260854 | 2021-04-26 | Montgomery | Texas | 48339 | 51928 | 554 |
1257607 | 1257607 | 2021-04-25 | Montgomery | Texas | 48339 | 51683 | 554 |
1254360 | 1254360 | 2021-04-24 | Montgomery | Texas | 48339 | 51683 | 553 |
1251113 | 1251113 | 2021-04-23 | Montgomery | Texas | 48339 | 51683 | 552 |
1247866 | 1247866 | 2021-04-22 | Montgomery | Texas | 48339 | 51582 | 548 |
1244619 | 1244619 | 2021-04-21 | Montgomery | Texas | 48339 | 51558 | 545 |
1241372 | 1241372 | 2021-04-20 | Montgomery | Texas | 48339 | 51425 | 543 |
1238125 | 1238125 | 2021-04-19 | Montgomery | Texas | 48339 | 51224 | 539 |
1234878 | 1234878 | 2021-04-18 | Montgomery | Texas | 48339 | 50976 | 539 |
1231630 | 1231630 | 2021-04-17 | Montgomery | Texas | 48339 | 50976 | 536 |
1228382 | 1228382 | 2021-04-16 | Montgomery | Texas | 48339 | 50976 | 536 |
1225134 | 1225134 | 2021-04-15 | Montgomery | Texas | 48339 | 50915 | 536 |
1221887 | 1221887 | 2021-04-14 | Montgomery | Texas | 48339 | 50866 | 534 |
1218639 | 1218639 | 2021-04-13 | Montgomery | Texas | 48339 | 50740 | 533 |
1215391 | 1215391 | 2021-04-12 | Montgomery | Texas | 48339 | 50660 | 533 |
1212144 | 1212144 | 2021-04-11 | Montgomery | Texas | 48339 | 50287 | 533 |
1208895 | 1208895 | 2021-04-10 | Montgomery | Texas | 48339 | 50287 | 534 |
1205647 | 1205647 | 2021-04-09 | Montgomery | Texas | 48339 | 50287 | 533 |
1202399 | 1202399 | 2021-04-08 | Montgomery | Texas | 48339 | 50184 | 531 |
1199150 | 1199150 | 2021-04-07 | Montgomery | Texas | 48339 | 50084 | 527 |
1195901 | 1195901 | 2021-04-06 | Montgomery | Texas | 48339 | 49936 | 526 |
1192653 | 1192653 | 2021-04-05 | Montgomery | Texas | 48339 | 49839 | 524 |
1189404 | 1189404 | 2021-04-04 | Montgomery | Texas | 48339 | 49605 | 524 |
1186157 | 1186157 | 2021-04-03 | Montgomery | Texas | 48339 | 49605 | 523 |
1182910 | 1182910 | 2021-04-02 | Montgomery | Texas | 48339 | 49605 | 522 |
1179663 | 1179663 | 2021-04-01 | Montgomery | Texas | 48339 | 49605 | 521 |
1176416 | 1176416 | 2021-03-31 | Montgomery | Texas | 48339 | 49477 | 519 |
1173169 | 1173169 | 2021-03-30 | Montgomery | Texas | 48339 | 49368 | 516 |
1169922 | 1169922 | 2021-03-29 | Montgomery | Texas | 48339 | 49238 | 514 |
1166674 | 1166674 | 2021-03-28 | Montgomery | Texas | 48339 | 48926 | 513 |
1163426 | 1163426 | 2021-03-27 | Montgomery | Texas | 48339 | 48926 | 512 |
1160177 | 1160177 | 2021-03-26 | Montgomery | Texas | 48339 | 48926 | 510 |
1156930 | 1156930 | 2021-03-25 | Montgomery | Texas | 48339 | 48832 | 509 |
1153683 | 1153683 | 2021-03-24 | Montgomery | Texas | 48339 | 48713 | 504 |
1150436 | 1150436 | 2021-03-23 | Montgomery | Texas | 48339 | 48506 | 499 |
1147189 | 1147189 | 2021-03-22 | Montgomery | Texas | 48339 | 48355 | 499 |
1143942 | 1143942 | 2021-03-21 | Montgomery | Texas | 48339 | 48064 | 499 |
1140695 | 1140695 | 2021-03-20 | Montgomery | Texas | 48339 | 48064 | 498 |
1137449 | 1137449 | 2021-03-19 | Montgomery | Texas | 48339 | 48064 | 496 |
1134203 | 1134203 | 2021-03-18 | Montgomery | Texas | 48339 | 47834 | 494 |
1130955 | 1130955 | 2021-03-17 | Montgomery | Texas | 48339 | 47666 | 490 |
1127708 | 1127708 | 2021-03-16 | Montgomery | Texas | 48339 | 47595 | 484 |
1124462 | 1124462 | 2021-03-15 | Montgomery | Texas | 48339 | 47478 | 483 |
1121216 | 1121216 | 2021-03-14 | Montgomery | Texas | 48339 | 47171 | 483 |
1117969 | 1117969 | 2021-03-13 | Montgomery | Texas | 48339 | 47171 | 483 |
1114722 | 1114722 | 2021-03-12 | Montgomery | Texas | 48339 | 47171 | 483 |
1111476 | 1111476 | 2021-03-11 | Montgomery | Texas | 48339 | 46993 | 479 |
1108230 | 1108230 | 2021-03-10 | Montgomery | Texas | 48339 | 46794 | 474 |
1104984 | 1104984 | 2021-03-09 | Montgomery | Texas | 48339 | 46713 | 472 |
1101738 | 1101738 | 2021-03-08 | Montgomery | Texas | 48339 | 46534 | 471 |
1098492 | 1098492 | 2021-03-07 | Montgomery | Texas | 48339 | 46244 | 471 |
1095244 | 1095244 | 2021-03-06 | Montgomery | Texas | 48339 | 46244 | 471 |
1091998 | 1091998 | 2021-03-05 | Montgomery | Texas | 48339 | 46058 | 469 |
1088752 | 1088752 | 2021-03-04 | Montgomery | Texas | 48339 | 46058 | 464 |
1085507 | 1085507 | 2021-03-03 | Montgomery | Texas | 48339 | 45872 | 459 |
1082261 | 1082261 | 2021-03-02 | Montgomery | Texas | 48339 | 45635 | 455 |
1079015 | 1079015 | 2021-03-01 | Montgomery | Texas | 48339 | 45528 | 450 |
1075770 | 1075770 | 2021-02-28 | Montgomery | Texas | 48339 | 44999 | 450 |
1072524 | 1072524 | 2021-02-27 | Montgomery | Texas | 48339 | 44999 | 450 |
1069278 | 1069278 | 2021-02-26 | Montgomery | Texas | 48339 | 44999 | 450 |
1066033 | 1066033 | 2021-02-25 | Montgomery | Texas | 48339 | 44862 | 448 |
1062788 | 1062788 | 2021-02-24 | Montgomery | Texas | 48339 | 44579 | 443 |
1059543 | 1059543 | 2021-02-23 | Montgomery | Texas | 48339 | 44439 | 442 |
1056297 | 1056297 | 2021-02-22 | Montgomery | Texas | 48339 | 44346 | 439 |
1053051 | 1053051 | 2021-02-21 | Montgomery | Texas | 48339 | 44060 | 439 |
1049804 | 1049804 | 2021-02-20 | Montgomery | Texas | 48339 | 44060 | 436 |
1046557 | 1046557 | 2021-02-19 | Montgomery | Texas | 48339 | 44060 | 432 |
1043312 | 1043312 | 2021-02-18 | Montgomery | Texas | 48339 | 43077 | 431 |
1040067 | 1040067 | 2021-02-17 | Montgomery | Texas | 48339 | 43077 | 430 |
1036822 | 1036822 | 2021-02-16 | Montgomery | Texas | 48339 | 43077 | 430 |
1033577 | 1033577 | 2021-02-15 | Montgomery | Texas | 48339 | 43077 | 430 |
1030331 | 1030331 | 2021-02-14 | Montgomery | Texas | 48339 | 43077 | 428 |
1027084 | 1027084 | 2021-02-13 | Montgomery | Texas | 48339 | 43077 | 424 |
1023839 | 1023839 | 2021-02-12 | Montgomery | Texas | 48339 | 43077 | 418 |
1020594 | 1020594 | 2021-02-11 | Montgomery | Texas | 48339 | 42810 | 418 |
1017349 | 1017349 | 2021-02-10 | Montgomery | Texas | 48339 | 42477 | 413 |
1014104 | 1014104 | 2021-02-09 | Montgomery | Texas | 48339 | 42261 | 408 |
1010859 | 1010859 | 2021-02-08 | Montgomery | Texas | 48339 | 41848 | 407 |
1007613 | 1007613 | 2021-02-07 | Montgomery | Texas | 48339 | 41310 | 406 |
1004367 | 1004367 | 2021-02-06 | Montgomery | Texas | 48339 | 41310 | 403 |
1001121 | 1001121 | 2021-02-05 | Montgomery | Texas | 48339 | 41310 | 401 |
997875 | 997875 | 2021-02-04 | Montgomery | Texas | 48339 | 40954 | 398 |
994629 | 994629 | 2021-02-03 | Montgomery | Texas | 48339 | 40601 | 394 |
991383 | 991383 | 2021-02-02 | Montgomery | Texas | 48339 | 40360 | 389 |
988137 | 988137 | 2021-02-01 | Montgomery | Texas | 48339 | 40042 | 384 |
984890 | 984890 | 2021-01-31 | Montgomery | Texas | 48339 | 39241 | 383 |
981643 | 981643 | 2021-01-30 | Montgomery | Texas | 48339 | 39241 | 382 |
978397 | 978397 | 2021-01-29 | Montgomery | Texas | 48339 | 39241 | 375 |
975152 | 975152 | 2021-01-28 | Montgomery | Texas | 48339 | 38904 | 369 |
971907 | 971907 | 2021-01-27 | Montgomery | Texas | 48339 | 38557 | 365 |
968662 | 968662 | 2021-01-26 | Montgomery | Texas | 48339 | 38075 | 358 |
965418 | 965418 | 2021-01-25 | Montgomery | Texas | 48339 | 36344 | 351 |
962173 | 962173 | 2021-01-24 | Montgomery | Texas | 48339 | 35480 | 351 |
958928 | 958928 | 2021-01-23 | Montgomery | Texas | 48339 | 35480 | 347 |
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);