ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 541 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2092382 | 2092382 | 2022-01-07 | Kinney | Texas | 48271 | 541 | 10 |
1851827 | 1851827 | 2021-10-25 | Hall | Texas | 48191 | 541 | 15 |
1848577 | 1848577 | 2021-10-24 | Hall | Texas | 48191 | 541 | 15 |
1845327 | 1845327 | 2021-10-23 | Hall | Texas | 48191 | 541 | 15 |
1842077 | 1842077 | 2021-10-22 | Hall | Texas | 48191 | 541 | 15 |
1838828 | 1838828 | 2021-10-21 | Hall | Texas | 48191 | 541 | 15 |
1835579 | 1835579 | 2021-10-20 | Hall | Texas | 48191 | 541 | 15 |
1773815 | 1773815 | 2021-10-01 | Donley | Texas | 48129 | 541 | 18 |
1770565 | 1770565 | 2021-09-30 | Donley | Texas | 48129 | 541 | 18 |
1767316 | 1767316 | 2021-09-29 | Donley | Texas | 48129 | 541 | 18 |
1760818 | 1760818 | 2021-09-27 | Donley | Texas | 48129 | 541 | 18 |
1757570 | 1757570 | 2021-09-26 | Donley | Texas | 48129 | 541 | 18 |
1754322 | 1754322 | 2021-09-25 | Donley | Texas | 48129 | 541 | 18 |
1738073 | 1738073 | 2021-09-20 | Delta | Texas | 48119 | 541 | 17 |
1734823 | 1734823 | 2021-09-19 | Delta | Texas | 48119 | 541 | 17 |
1731573 | 1731573 | 2021-09-18 | Delta | Texas | 48119 | 541 | 17 |
1504259 | 1504259 | 2021-07-10 | Hudspeth | Texas | 48229 | 541 | 12 |
1501013 | 1501013 | 2021-07-09 | Hudspeth | Texas | 48229 | 541 | 12 |
1497767 | 1497767 | 2021-07-08 | Hudspeth | Texas | 48229 | 541 | 12 |
1494520 | 1494520 | 2021-07-07 | Hudspeth | Texas | 48229 | 541 | 12 |
1491273 | 1491273 | 2021-07-06 | Hudspeth | Texas | 48229 | 541 | 12 |
1488026 | 1488026 | 2021-07-05 | Hudspeth | Texas | 48229 | 541 | 12 |
1484779 | 1484779 | 2021-07-04 | Hudspeth | Texas | 48229 | 541 | 12 |
1481533 | 1481533 | 2021-07-03 | Hudspeth | Texas | 48229 | 541 | 12 |
1478286 | 1478286 | 2021-07-02 | Hudspeth | Texas | 48229 | 541 | 12 |
1475040 | 1475040 | 2021-07-01 | Hudspeth | Texas | 48229 | 541 | 12 |
1471794 | 1471794 | 2021-06-30 | Hudspeth | Texas | 48229 | 541 | 12 |
1468486 | 1468486 | 2021-06-29 | Crane | Texas | 48103 | 541 | 12 |
1465241 | 1465241 | 2021-06-28 | Crane | Texas | 48103 | 541 | 12 |
1410066 | 1410066 | 2021-06-11 | Crane | Texas | 48103 | 541 | 12 |
1345254 | 1345254 | 2021-05-22 | Marion | Texas | 48315 | 541 | 33 |
1342006 | 1342006 | 2021-05-21 | Marion | Texas | 48315 | 541 | 33 |
1338758 | 1338758 | 2021-05-20 | Marion | Texas | 48315 | 541 | 33 |
1079005 | 1079005 | 2021-03-01 | McCulloch | Texas | 48307 | 541 | 15 |
1075760 | 1075760 | 2021-02-28 | McCulloch | Texas | 48307 | 541 | 15 |
1072514 | 1072514 | 2021-02-27 | McCulloch | Texas | 48307 | 541 | 15 |
1014110 | 1014110 | 2021-02-09 | Newton | Texas | 48351 | 541 | 28 |
1010865 | 1010865 | 2021-02-08 | Newton | Texas | 48351 | 541 | 28 |
1007619 | 1007619 | 2021-02-07 | Newton | Texas | 48351 | 541 | 28 |
1004373 | 1004373 | 2021-02-06 | Newton | Texas | 48351 | 541 | 28 |
994512 | 994512 | 2021-02-03 | Crockett | Texas | 48105 | 541 | 15 |
955631 | 955631 | 2021-01-22 | Jack | Texas | 48237 | 541 | 12 |
939478 | 939478 | 2021-01-17 | Red River | Texas | 48387 | 541 | 31 |
880873 | 880873 | 2020-12-30 | Archer | Texas | 48009 | 541 | 6 |
796569 | 796569 | 2020-12-04 | Freestone | Texas | 48161 | 541 | 14 |
760913 | 760913 | 2020-11-23 | Jasper | Texas | 48241 | 541 | 35 |
757668 | 757668 | 2020-11-22 | Jasper | Texas | 48241 | 541 | 35 |
754421 | 754421 | 2020-11-21 | Jasper | Texas | 48241 | 541 | 34 |
498463 | 498463 | 2020-09-03 | Wilson | Texas | 48493 | 541 | 25 |
495230 | 495230 | 2020-09-02 | Wilson | Texas | 48493 | 541 | 25 |
453112 | 453112 | 2020-08-20 | Kleberg | Texas | 48273 | 541 | 20 |
330999 | 330999 | 2020-07-13 | Navarro | Texas | 48349 | 541 | 7 |
308586 | 308586 | 2020-07-06 | Angelina | Texas | 48005 | 541 | 9 |
305418 | 305418 | 2020-07-05 | Angelina | Texas | 48005 | 541 | 9 |
302254 | 302254 | 2020-07-04 | Angelina | Texas | 48005 | 541 | 9 |
299090 | 299090 | 2020-07-03 | Angelina | Texas | 48005 | 541 | 9 |
295930 | 295930 | 2020-07-02 | Angelina | Texas | 48005 | 541 | 9 |
205689 | 205689 | 2020-06-03 | Titus | Texas | 48449 | 541 | 3 |
172041 | 172041 | 2020-05-23 | Williamson | Texas | 48491 | 541 | 21 |
92009 | 92009 | 2020-04-26 | Galveston | Texas | 48167 | 541 | 22 |
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);