ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where cases = 455 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 30
county 30
- Briscoe 9
- Hardeman 5
- Mitchell 5
- Shelby 5
- Sutton 4
- Culberson 3
- Robertson 3
- Bailey 2
- Edwards 2
- Fisher 2
- Kimble 2
- Lamar 2
- McCulloch 2
- Menard 2
- Morris 2
- Panola 2
- Real 2
- Sherman 2
- Brazos 1
- Collingsworth 1
- Galveston 1
- Hudspeth 1
- Limestone 1
- Lipscomb 1
- Martin 1
- Mason 1
- Maverick 1
- Refugio 1
- Smith 1
- Wheeler 1
state 1
- Texas · 68 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2365480 | 2365480 | 2022-04-01 | Briscoe | Texas | 48045 | 455 | 8 |
2362227 | 2362227 | 2022-03-31 | Briscoe | Texas | 48045 | 455 | 8 |
2358973 | 2358973 | 2022-03-30 | Briscoe | Texas | 48045 | 455 | 8 |
2355719 | 2355719 | 2022-03-29 | Briscoe | Texas | 48045 | 455 | 8 |
2352466 | 2352466 | 2022-03-28 | Briscoe | Texas | 48045 | 455 | 8 |
2349214 | 2349214 | 2022-03-27 | Briscoe | Texas | 48045 | 455 | 8 |
2345961 | 2345961 | 2022-03-26 | Briscoe | Texas | 48045 | 455 | 8 |
2342708 | 2342708 | 2022-03-25 | Briscoe | Texas | 48045 | 455 | 8 |
2339455 | 2339455 | 2022-03-24 | Briscoe | Texas | 48045 | 455 | 8 |
2199661 | 2199661 | 2022-02-09 | Edwards | Texas | 48137 | 455 | 10 |
2196407 | 2196407 | 2022-02-08 | Edwards | Texas | 48137 | 455 | 10 |
2160763 | 2160763 | 2022-01-28 | Sherman | Texas | 48421 | 455 | 16 |
2157460 | 2157460 | 2022-01-27 | Menard | Texas | 48327 | 455 | 12 |
2157507 | 2157507 | 2022-01-27 | Sherman | Texas | 48421 | 455 | 16 |
2154207 | 2154207 | 2022-01-26 | Menard | Texas | 48327 | 455 | 12 |
2128069 | 2128069 | 2022-01-18 | Culberson | Texas | 48109 | 455 | 13 |
2124817 | 2124817 | 2022-01-17 | Culberson | Texas | 48109 | 455 | 13 |
2111810 | 2111810 | 2022-01-13 | Culberson | Texas | 48109 | 455 | 13 |
2059811 | 2059811 | 2021-12-28 | Fisher | Texas | 48151 | 455 | 19 |
2056562 | 2056562 | 2021-12-27 | Fisher | Texas | 48151 | 455 | 19 |
2033782 | 2033782 | 2021-12-20 | Collingsworth | Texas | 48087 | 455 | 11 |
2033872 | 2033872 | 2021-12-20 | Kimble | Texas | 48267 | 455 | 11 |
2030622 | 2030622 | 2021-12-19 | Kimble | Texas | 48267 | 455 | 11 |
1991626 | 1991626 | 2021-12-07 | Lipscomb | Texas | 48295 | 455 | 12 |
1897320 | 1897320 | 2021-11-08 | Hardeman | Texas | 48197 | 455 | 14 |
1894070 | 1894070 | 2021-11-07 | Hardeman | Texas | 48197 | 455 | 14 |
1890820 | 1890820 | 2021-11-06 | Hardeman | Texas | 48197 | 455 | 14 |
1887570 | 1887570 | 2021-11-05 | Hardeman | Texas | 48197 | 455 | 14 |
1884320 | 1884320 | 2021-11-04 | Hardeman | Texas | 48197 | 455 | 14 |
1741454 | 1741454 | 2021-09-21 | Real | Texas | 48385 | 455 | 15 |
1738205 | 1738205 | 2021-09-20 | Real | Texas | 48385 | 455 | 15 |
1676442 | 1676442 | 2021-09-01 | Mason | Texas | 48319 | 455 | 6 |
1046605 | 1046605 | 2021-02-19 | Sutton | Texas | 48435 | 455 | 8 |
1043360 | 1043360 | 2021-02-18 | Sutton | Texas | 48435 | 455 | 8 |
1040115 | 1040115 | 2021-02-17 | Sutton | Texas | 48435 | 455 | 8 |
1036870 | 1036870 | 2021-02-16 | Sutton | Texas | 48435 | 455 | 8 |
1001193 | 1001193 | 2021-02-05 | Wheeler | Texas | 48483 | 455 | 9 |
919973 | 919973 | 2021-01-11 | McCulloch | Texas | 48307 | 455 | 12 |
916728 | 916728 | 2021-01-10 | McCulloch | Texas | 48307 | 455 | 12 |
906948 | 906948 | 2021-01-07 | Hudspeth | Texas | 48229 | 455 | 8 |
884309 | 884309 | 2020-12-31 | Refugio | Texas | 48391 | 455 | 17 |
874546 | 874546 | 2020-12-28 | Mitchell | Texas | 48335 | 455 | 12 |
871301 | 871301 | 2020-12-27 | Mitchell | Texas | 48335 | 455 | 12 |
868056 | 868056 | 2020-12-26 | Mitchell | Texas | 48335 | 455 | 12 |
864811 | 864811 | 2020-12-25 | Mitchell | Texas | 48335 | 455 | 12 |
864815 | 864815 | 2020-12-25 | Morris | Texas | 48343 | 455 | 8 |
861566 | 861566 | 2020-12-24 | Mitchell | Texas | 48335 | 455 | 12 |
861570 | 861570 | 2020-12-24 | Morris | Texas | 48343 | 455 | 8 |
822606 | 822606 | 2020-12-12 | Martin | Texas | 48317 | 455 | 11 |
767291 | 767291 | 2020-11-25 | Bailey | Texas | 48017 | 455 | 6 |
764046 | 764046 | 2020-11-24 | Bailey | Texas | 48017 | 455 | 6 |
738266 | 738266 | 2020-11-16 | Robertson | Texas | 48395 | 455 | 6 |
735022 | 735022 | 2020-11-15 | Robertson | Texas | 48395 | 455 | 6 |
731776 | 731776 | 2020-11-14 | Robertson | Texas | 48395 | 455 | 6 |
657161 | 657161 | 2020-10-22 | Panola | Texas | 48365 | 455 | 27 |
653916 | 653916 | 2020-10-21 | Panola | Texas | 48365 | 455 | 27 |
537243 | 537243 | 2020-09-15 | Shelby | Texas | 48419 | 455 | 22 |
534007 | 534007 | 2020-09-14 | Shelby | Texas | 48419 | 455 | 21 |
530772 | 530772 | 2020-09-13 | Shelby | Texas | 48419 | 455 | 21 |
527535 | 527535 | 2020-09-12 | Shelby | Texas | 48419 | 455 | 21 |
524299 | 524299 | 2020-09-11 | Shelby | Texas | 48419 | 455 | 21 |
488664 | 488664 | 2020-08-31 | Limestone | Texas | 48293 | 455 | 7 |
346948 | 346948 | 2020-07-18 | Lamar | Texas | 48277 | 455 | 15 |
343748 | 343748 | 2020-07-17 | Lamar | Texas | 48277 | 455 | 15 |
299241 | 299241 | 2020-07-03 | Maverick | Texas | 48323 | 455 | 5 |
274086 | 274086 | 2020-06-25 | Smith | Texas | 48423 | 455 | 4 |
184021 | 184021 | 2020-05-27 | Brazos | Texas | 48041 | 455 | 19 |
72424 | 72424 | 2020-04-19 | Galveston | Texas | 48167 | 455 | 17 |
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);