ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where county = "Martin", deaths = 18 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1293307 | 1293307 | 2021-05-06 | Martin | Texas | 48317 | 632 | 18 |
1290061 | 1290061 | 2021-05-05 | Martin | Texas | 48317 | 631 | 18 |
1286815 | 1286815 | 2021-05-04 | Martin | Texas | 48317 | 631 | 18 |
1283569 | 1283569 | 2021-05-03 | Martin | Texas | 48317 | 631 | 18 |
1280322 | 1280322 | 2021-05-02 | Martin | Texas | 48317 | 631 | 18 |
1277075 | 1277075 | 2021-05-01 | Martin | Texas | 48317 | 631 | 18 |
1273828 | 1273828 | 2021-04-30 | Martin | Texas | 48317 | 631 | 18 |
1270581 | 1270581 | 2021-04-29 | Martin | Texas | 48317 | 630 | 18 |
1267334 | 1267334 | 2021-04-28 | Martin | Texas | 48317 | 629 | 18 |
1264087 | 1264087 | 2021-04-27 | Martin | Texas | 48317 | 629 | 18 |
1260840 | 1260840 | 2021-04-26 | Martin | Texas | 48317 | 629 | 18 |
1257593 | 1257593 | 2021-04-25 | Martin | Texas | 48317 | 629 | 18 |
1254346 | 1254346 | 2021-04-24 | Martin | Texas | 48317 | 631 | 18 |
1251099 | 1251099 | 2021-04-23 | Martin | Texas | 48317 | 631 | 18 |
1247852 | 1247852 | 2021-04-22 | Martin | Texas | 48317 | 631 | 18 |
1244605 | 1244605 | 2021-04-21 | Martin | Texas | 48317 | 631 | 18 |
1241358 | 1241358 | 2021-04-20 | Martin | Texas | 48317 | 631 | 18 |
1238111 | 1238111 | 2021-04-19 | Martin | Texas | 48317 | 632 | 18 |
1234864 | 1234864 | 2021-04-18 | Martin | Texas | 48317 | 632 | 18 |
1231616 | 1231616 | 2021-04-17 | Martin | Texas | 48317 | 630 | 18 |
1228368 | 1228368 | 2021-04-16 | Martin | Texas | 48317 | 631 | 18 |
1225120 | 1225120 | 2021-04-15 | Martin | Texas | 48317 | 630 | 18 |
1221873 | 1221873 | 2021-04-14 | Martin | Texas | 48317 | 626 | 18 |
1218625 | 1218625 | 2021-04-13 | Martin | Texas | 48317 | 624 | 18 |
1215377 | 1215377 | 2021-04-12 | Martin | Texas | 48317 | 624 | 18 |
1212130 | 1212130 | 2021-04-11 | Martin | Texas | 48317 | 624 | 18 |
1208881 | 1208881 | 2021-04-10 | Martin | Texas | 48317 | 624 | 18 |
1205633 | 1205633 | 2021-04-09 | Martin | Texas | 48317 | 621 | 18 |
1202385 | 1202385 | 2021-04-08 | Martin | Texas | 48317 | 621 | 18 |
1199136 | 1199136 | 2021-04-07 | Martin | Texas | 48317 | 620 | 18 |
1195887 | 1195887 | 2021-04-06 | Martin | Texas | 48317 | 619 | 18 |
1192639 | 1192639 | 2021-04-05 | Martin | Texas | 48317 | 618 | 18 |
1189390 | 1189390 | 2021-04-04 | Martin | Texas | 48317 | 618 | 18 |
1186143 | 1186143 | 2021-04-03 | Martin | Texas | 48317 | 618 | 18 |
1182896 | 1182896 | 2021-04-02 | Martin | Texas | 48317 | 616 | 18 |
1179649 | 1179649 | 2021-04-01 | Martin | Texas | 48317 | 615 | 18 |
1176402 | 1176402 | 2021-03-31 | Martin | Texas | 48317 | 615 | 18 |
1173155 | 1173155 | 2021-03-30 | Martin | Texas | 48317 | 614 | 18 |
1169908 | 1169908 | 2021-03-29 | Martin | Texas | 48317 | 614 | 18 |
1166660 | 1166660 | 2021-03-28 | Martin | Texas | 48317 | 614 | 18 |
1163412 | 1163412 | 2021-03-27 | Martin | Texas | 48317 | 614 | 18 |
1160163 | 1160163 | 2021-03-26 | Martin | Texas | 48317 | 614 | 18 |
1156916 | 1156916 | 2021-03-25 | Martin | Texas | 48317 | 614 | 18 |
1153669 | 1153669 | 2021-03-24 | Martin | Texas | 48317 | 616 | 18 |
1150422 | 1150422 | 2021-03-23 | Martin | Texas | 48317 | 617 | 18 |
1147175 | 1147175 | 2021-03-22 | Martin | Texas | 48317 | 617 | 18 |
1143928 | 1143928 | 2021-03-21 | Martin | Texas | 48317 | 617 | 18 |
1140681 | 1140681 | 2021-03-20 | Martin | Texas | 48317 | 614 | 18 |
1137435 | 1137435 | 2021-03-19 | Martin | Texas | 48317 | 614 | 18 |
1134189 | 1134189 | 2021-03-18 | Martin | Texas | 48317 | 615 | 18 |
1130941 | 1130941 | 2021-03-17 | Martin | Texas | 48317 | 615 | 18 |
1127694 | 1127694 | 2021-03-16 | Martin | Texas | 48317 | 615 | 18 |
1124448 | 1124448 | 2021-03-15 | Martin | Texas | 48317 | 615 | 18 |
1121202 | 1121202 | 2021-03-14 | Martin | Texas | 48317 | 615 | 18 |
1117955 | 1117955 | 2021-03-13 | Martin | Texas | 48317 | 615 | 18 |
1114708 | 1114708 | 2021-03-12 | Martin | Texas | 48317 | 611 | 18 |
1111462 | 1111462 | 2021-03-11 | Martin | Texas | 48317 | 611 | 18 |
1108216 | 1108216 | 2021-03-10 | Martin | Texas | 48317 | 611 | 18 |
1104970 | 1104970 | 2021-03-09 | Martin | Texas | 48317 | 609 | 18 |
1101724 | 1101724 | 2021-03-08 | Martin | Texas | 48317 | 609 | 18 |
1098478 | 1098478 | 2021-03-07 | Martin | Texas | 48317 | 609 | 18 |
1095230 | 1095230 | 2021-03-06 | Martin | Texas | 48317 | 609 | 18 |
1091984 | 1091984 | 2021-03-05 | Martin | Texas | 48317 | 616 | 18 |
1088738 | 1088738 | 2021-03-04 | Martin | Texas | 48317 | 616 | 18 |
1085493 | 1085493 | 2021-03-03 | Martin | Texas | 48317 | 615 | 18 |
1082247 | 1082247 | 2021-03-02 | Martin | Texas | 48317 | 615 | 18 |
1079001 | 1079001 | 2021-03-01 | Martin | Texas | 48317 | 614 | 18 |
1075756 | 1075756 | 2021-02-28 | Martin | Texas | 48317 | 614 | 18 |
1072510 | 1072510 | 2021-02-27 | Martin | Texas | 48317 | 613 | 18 |
1069264 | 1069264 | 2021-02-26 | Martin | Texas | 48317 | 612 | 18 |
1066019 | 1066019 | 2021-02-25 | Martin | Texas | 48317 | 612 | 18 |
1062774 | 1062774 | 2021-02-24 | Martin | Texas | 48317 | 612 | 18 |
1059529 | 1059529 | 2021-02-23 | Martin | Texas | 48317 | 613 | 18 |
1056283 | 1056283 | 2021-02-22 | Martin | Texas | 48317 | 613 | 18 |
1053037 | 1053037 | 2021-02-21 | Martin | Texas | 48317 | 613 | 18 |
1049790 | 1049790 | 2021-02-20 | Martin | Texas | 48317 | 613 | 18 |
1046543 | 1046543 | 2021-02-19 | Martin | Texas | 48317 | 612 | 18 |
1043298 | 1043298 | 2021-02-18 | Martin | Texas | 48317 | 612 | 18 |
1040053 | 1040053 | 2021-02-17 | Martin | Texas | 48317 | 611 | 18 |
1036808 | 1036808 | 2021-02-16 | Martin | Texas | 48317 | 613 | 18 |
1033563 | 1033563 | 2021-02-15 | Martin | Texas | 48317 | 613 | 18 |
1030317 | 1030317 | 2021-02-14 | Martin | Texas | 48317 | 613 | 18 |
1027070 | 1027070 | 2021-02-13 | Martin | Texas | 48317 | 612 | 18 |
1023825 | 1023825 | 2021-02-12 | Martin | Texas | 48317 | 612 | 18 |
1020580 | 1020580 | 2021-02-11 | Martin | Texas | 48317 | 608 | 18 |
1017335 | 1017335 | 2021-02-10 | Martin | Texas | 48317 | 608 | 18 |
1014090 | 1014090 | 2021-02-09 | Martin | Texas | 48317 | 606 | 18 |
1010845 | 1010845 | 2021-02-08 | Martin | Texas | 48317 | 591 | 18 |
1007599 | 1007599 | 2021-02-07 | Martin | Texas | 48317 | 591 | 18 |
1004353 | 1004353 | 2021-02-06 | Martin | Texas | 48317 | 591 | 18 |
1001107 | 1001107 | 2021-02-05 | Martin | Texas | 48317 | 591 | 18 |
997861 | 997861 | 2021-02-04 | Martin | Texas | 48317 | 590 | 18 |
994615 | 994615 | 2021-02-03 | Martin | Texas | 48317 | 593 | 18 |
991369 | 991369 | 2021-02-02 | Martin | Texas | 48317 | 579 | 18 |
988123 | 988123 | 2021-02-01 | Martin | Texas | 48317 | 577 | 18 |
984876 | 984876 | 2021-01-31 | Martin | Texas | 48317 | 574 | 18 |
981629 | 981629 | 2021-01-30 | Martin | Texas | 48317 | 572 | 18 |
978383 | 978383 | 2021-01-29 | Martin | Texas | 48317 | 565 | 18 |
975138 | 975138 | 2021-01-28 | Martin | Texas | 48317 | 564 | 18 |
971893 | 971893 | 2021-01-27 | Martin | Texas | 48317 | 563 | 18 |
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);