ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 80 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2141181 | 2141181 | 2022-01-22 | Loving | Texas | 48301 | 80 | 0 |
1679757 | 1679757 | 2021-09-02 | Throckmorton | Texas | 48447 | 80 | 5 |
1676509 | 1676509 | 2021-09-01 | Throckmorton | Texas | 48447 | 80 | 5 |
1673262 | 1673262 | 2021-08-31 | Throckmorton | Texas | 48447 | 80 | 5 |
1670014 | 1670014 | 2021-08-30 | Throckmorton | Texas | 48447 | 80 | 5 |
1666767 | 1666767 | 2021-08-29 | Throckmorton | Texas | 48447 | 80 | 5 |
1663519 | 1663519 | 2021-08-28 | Throckmorton | Texas | 48447 | 80 | 5 |
1660271 | 1660271 | 2021-08-27 | Throckmorton | Texas | 48447 | 80 | 5 |
1657022 | 1657022 | 2021-08-26 | Throckmorton | Texas | 48447 | 80 | 5 |
1653775 | 1653775 | 2021-08-25 | Throckmorton | Texas | 48447 | 80 | 5 |
1605048 | 1605048 | 2021-08-10 | Terrell | Texas | 48443 | 80 | 2 |
1601799 | 1601799 | 2021-08-09 | Terrell | Texas | 48443 | 80 | 2 |
1598551 | 1598551 | 2021-08-08 | Terrell | Texas | 48443 | 80 | 2 |
1595302 | 1595302 | 2021-08-07 | Terrell | Texas | 48443 | 80 | 2 |
1592053 | 1592053 | 2021-08-06 | Terrell | Texas | 48443 | 80 | 2 |
1588804 | 1588804 | 2021-08-05 | Terrell | Texas | 48443 | 80 | 2 |
1585554 | 1585554 | 2021-08-04 | Terrell | Texas | 48443 | 80 | 2 |
1582304 | 1582304 | 2021-08-03 | Terrell | Texas | 48443 | 80 | 2 |
1579055 | 1579055 | 2021-08-02 | Terrell | Texas | 48443 | 80 | 2 |
1575807 | 1575807 | 2021-08-01 | Terrell | Texas | 48443 | 80 | 2 |
1572559 | 1572559 | 2021-07-31 | Terrell | Texas | 48443 | 80 | 2 |
1569311 | 1569311 | 2021-07-30 | Terrell | Texas | 48443 | 80 | 2 |
1566063 | 1566063 | 2021-07-29 | Terrell | Texas | 48443 | 80 | 2 |
1562815 | 1562815 | 2021-07-28 | Terrell | Texas | 48443 | 80 | 2 |
1559567 | 1559567 | 2021-07-27 | Terrell | Texas | 48443 | 80 | 2 |
1556320 | 1556320 | 2021-07-26 | Terrell | Texas | 48443 | 80 | 2 |
1553073 | 1553073 | 2021-07-25 | Terrell | Texas | 48443 | 80 | 2 |
1108192 | 1108192 | 2021-03-10 | Kent | Texas | 48263 | 80 | 2 |
1104946 | 1104946 | 2021-03-09 | Kent | Texas | 48263 | 80 | 1 |
1056289 | 1056289 | 2021-02-22 | McMullen | Texas | 48311 | 80 | 4 |
1053043 | 1053043 | 2021-02-21 | McMullen | Texas | 48311 | 80 | 4 |
1049796 | 1049796 | 2021-02-20 | McMullen | Texas | 48311 | 80 | 4 |
1046549 | 1046549 | 2021-02-19 | McMullen | Texas | 48311 | 80 | 4 |
1043304 | 1043304 | 2021-02-18 | McMullen | Texas | 48311 | 80 | 4 |
1014107 | 1014107 | 2021-02-09 | Motley | Texas | 48345 | 80 | 7 |
1010862 | 1010862 | 2021-02-08 | Motley | Texas | 48345 | 80 | 7 |
1007616 | 1007616 | 2021-02-07 | Motley | Texas | 48345 | 80 | 7 |
1004370 | 1004370 | 2021-02-06 | Motley | Texas | 48345 | 80 | 7 |
1001124 | 1001124 | 2021-02-05 | Motley | Texas | 48345 | 80 | 7 |
997878 | 997878 | 2021-02-04 | Motley | Texas | 48345 | 80 | 7 |
994632 | 994632 | 2021-02-03 | Motley | Texas | 48345 | 80 | 7 |
991386 | 991386 | 2021-02-02 | Motley | Texas | 48345 | 80 | 7 |
988140 | 988140 | 2021-02-01 | Motley | Texas | 48345 | 80 | 7 |
984893 | 984893 | 2021-01-31 | Motley | Texas | 48345 | 80 | 7 |
981646 | 981646 | 2021-01-30 | Motley | Texas | 48345 | 80 | 7 |
978400 | 978400 | 2021-01-29 | Motley | Texas | 48345 | 80 | 7 |
978449 | 978449 | 2021-01-29 | Terrell | Texas | 48443 | 80 | 2 |
975155 | 975155 | 2021-01-28 | Motley | Texas | 48345 | 80 | 7 |
975204 | 975204 | 2021-01-28 | Terrell | Texas | 48443 | 80 | 2 |
971910 | 971910 | 2021-01-27 | Motley | Texas | 48345 | 80 | 7 |
968665 | 968665 | 2021-01-26 | Motley | Texas | 48345 | 80 | 7 |
965421 | 965421 | 2021-01-25 | Motley | Texas | 48345 | 80 | 7 |
962176 | 962176 | 2021-01-24 | Motley | Texas | 48345 | 80 | 7 |
958931 | 958931 | 2021-01-23 | Motley | Texas | 48345 | 80 | 7 |
942647 | 942647 | 2021-01-18 | Irion | Texas | 48235 | 80 | 1 |
783605 | 783605 | 2020-11-30 | Hall | Texas | 48191 | 80 | 3 |
780360 | 780360 | 2020-11-29 | Hall | Texas | 48191 | 80 | 3 |
777114 | 777114 | 2020-11-28 | Hall | Texas | 48191 | 80 | 3 |
773869 | 773869 | 2020-11-27 | Hall | Texas | 48191 | 80 | 3 |
770624 | 770624 | 2020-11-26 | Hall | Texas | 48191 | 80 | 3 |
757681 | 757681 | 2020-11-22 | Kimble | Texas | 48267 | 80 | 2 |
718753 | 718753 | 2020-11-10 | Lipscomb | Texas | 48295 | 80 | 1 |
715498 | 715498 | 2020-11-09 | Kinney | Texas | 48271 | 80 | 1 |
715510 | 715510 | 2020-11-09 | Lipscomb | Texas | 48295 | 80 | 1 |
712266 | 712266 | 2020-11-08 | Lipscomb | Texas | 48295 | 80 | 1 |
709022 | 709022 | 2020-11-07 | Lipscomb | Texas | 48295 | 80 | 1 |
705840 | 705840 | 2020-11-06 | Sherman | Texas | 48421 | 80 | 1 |
702550 | 702550 | 2020-11-05 | Menard | Texas | 48327 | 80 | 0 |
702597 | 702597 | 2020-11-05 | Sherman | Texas | 48421 | 80 | 1 |
696066 | 696066 | 2020-11-03 | Mills | Texas | 48333 | 80 | 1 |
670059 | 670059 | 2020-10-26 | Haskell | Texas | 48207 | 80 | 3 |
670111 | 670111 | 2020-10-26 | Mason | Texas | 48319 | 80 | 2 |
666816 | 666816 | 2020-10-25 | Haskell | Texas | 48207 | 80 | 3 |
666868 | 666868 | 2020-10-25 | Mason | Texas | 48319 | 80 | 2 |
663571 | 663571 | 2020-10-24 | Haskell | Texas | 48207 | 80 | 3 |
663623 | 663623 | 2020-10-24 | Mason | Texas | 48319 | 80 | 2 |
660379 | 660379 | 2020-10-23 | Mason | Texas | 48319 | 80 | 2 |
657135 | 657135 | 2020-10-22 | Mason | Texas | 48319 | 80 | 2 |
653890 | 653890 | 2020-10-21 | Mason | Texas | 48319 | 80 | 2 |
650645 | 650645 | 2020-10-20 | Mason | Texas | 48319 | 80 | 2 |
647401 | 647401 | 2020-10-19 | Mason | Texas | 48319 | 80 | 2 |
644155 | 644155 | 2020-10-18 | Mason | Texas | 48319 | 80 | 2 |
644188 | 644188 | 2020-10-18 | Rains | Texas | 48379 | 80 | 5 |
640907 | 640907 | 2020-10-17 | Mason | Texas | 48319 | 80 | 2 |
640940 | 640940 | 2020-10-17 | Rains | Texas | 48379 | 80 | 5 |
637545 | 637545 | 2020-10-16 | Coke | Texas | 48081 | 80 | 4 |
637660 | 637660 | 2020-10-16 | Mason | Texas | 48319 | 80 | 2 |
634415 | 634415 | 2020-10-15 | Mason | Texas | 48319 | 80 | 2 |
631055 | 631055 | 2020-10-14 | Coke | Texas | 48081 | 80 | 4 |
631170 | 631170 | 2020-10-14 | Mason | Texas | 48319 | 80 | 2 |
624682 | 624682 | 2020-10-12 | Martin | Texas | 48317 | 80 | 6 |
621439 | 621439 | 2020-10-11 | Martin | Texas | 48317 | 80 | 6 |
618196 | 618196 | 2020-10-10 | Martin | Texas | 48317 | 80 | 6 |
601874 | 601874 | 2020-10-05 | Coleman | Texas | 48083 | 80 | 4 |
598631 | 598631 | 2020-10-04 | Coleman | Texas | 48083 | 80 | 4 |
595388 | 595388 | 2020-10-03 | Coleman | Texas | 48083 | 80 | 4 |
559735 | 559735 | 2020-09-22 | Clay | Texas | 48077 | 80 | 1 |
533965 | 533965 | 2020-09-14 | Mitchell | Texas | 48335 | 80 | 1 |
534015 | 534015 | 2020-09-14 | Sutton | Texas | 48435 | 80 | 3 |
530730 | 530730 | 2020-09-13 | Mitchell | Texas | 48335 | 80 | 1 |
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);