ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 566 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2102041 | 2102041 | 2022-01-10 | Cochran | Texas | 48079 | 566 | 21 |
2098790 | 2098790 | 2022-01-09 | Cochran | Texas | 48079 | 566 | 21 |
2030697 | 2030697 | 2021-12-19 | Shackelford | Texas | 48417 | 566 | 7 |
2027446 | 2027446 | 2021-12-18 | Shackelford | Texas | 48417 | 566 | 7 |
1942815 | 1942815 | 2021-11-22 | Hall | Texas | 48191 | 566 | 15 |
1939565 | 1939565 | 2021-11-21 | Hall | Texas | 48191 | 566 | 15 |
1936315 | 1936315 | 2021-11-20 | Hall | Texas | 48191 | 566 | 15 |
1851888 | 1851888 | 2021-10-25 | Mason | Texas | 48319 | 566 | 7 |
1816054 | 1816054 | 2021-10-14 | Donley | Texas | 48129 | 566 | 18 |
1699144 | 1699144 | 2021-09-08 | Hudspeth | Texas | 48229 | 566 | 12 |
1650522 | 1650522 | 2021-08-24 | Sutton | Texas | 48435 | 566 | 8 |
1455539 | 1455539 | 2021-06-25 | Garza | Texas | 48169 | 566 | 22 |
1377802 | 1377802 | 2021-06-01 | Wheeler | Texas | 48483 | 566 | 11 |
1364819 | 1364819 | 2021-05-28 | Wheeler | Texas | 48483 | 566 | 11 |
1361573 | 1361573 | 2021-05-27 | Wheeler | Texas | 48483 | 566 | 11 |
1238115 | 1238115 | 2021-04-19 | McCulloch | Texas | 48307 | 566 | 19 |
1234868 | 1234868 | 2021-04-18 | McCulloch | Texas | 48307 | 566 | 19 |
1176406 | 1176406 | 2021-03-31 | McCulloch | Texas | 48307 | 566 | 19 |
1056303 | 1056303 | 2021-02-22 | Newton | Texas | 48351 | 566 | 29 |
1053057 | 1053057 | 2021-02-21 | Newton | Texas | 48351 | 566 | 29 |
1049810 | 1049810 | 2021-02-20 | Newton | Texas | 48351 | 566 | 29 |
926457 | 926457 | 2021-01-13 | Lynn | Texas | 48305 | 566 | 15 |
809486 | 809486 | 2020-12-08 | Bosque | Texas | 48035 | 566 | 16 |
741390 | 741390 | 2020-11-17 | Fayette | Texas | 48149 | 566 | 23 |
683009 | 683009 | 2020-10-30 | Gaines | Texas | 48165 | 566 | 12 |
679732 | 679732 | 2020-10-29 | Cooke | Texas | 48097 | 566 | 9 |
611617 | 611617 | 2020-10-08 | Dawson | Texas | 48115 | 566 | 10 |
537162 | 537162 | 2020-09-15 | Jones | Texas | 48253 | 566 | 0 |
534044 | 534044 | 2020-09-14 | Wilson | Texas | 48493 | 566 | 26 |
530809 | 530809 | 2020-09-13 | Wilson | Texas | 48493 | 566 | 26 |
527572 | 527572 | 2020-09-12 | Wilson | Texas | 48493 | 566 | 26 |
472424 | 472424 | 2020-08-26 | Fannin | Texas | 48147 | 566 | 10 |
372555 | 372555 | 2020-07-26 | Harrison | Texas | 48203 | 566 | 34 |
369397 | 369397 | 2020-07-25 | Matagorda | Texas | 48321 | 566 | 5 |
350206 | 350206 | 2020-07-19 | Rockwall | Texas | 48397 | 566 | 17 |
347006 | 347006 | 2020-07-18 | Rockwall | Texas | 48397 | 566 | 17 |
343806 | 343806 | 2020-07-17 | Rockwall | Texas | 48397 | 566 | 17 |
286558 | 286558 | 2020-06-29 | Grayson | Texas | 48181 | 566 | 5 |
114813 | 114813 | 2020-05-04 | Brazoria | Texas | 48039 | 566 | 7 |
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);