ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193,519 rows where state = "Texas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 48201 790
- 48209 790
- 48339 790
- 48423 790
- 48439 790
- 48453 790
- 48027 789
- 48029 789
- 48037 789
- 48039 789
- 48085 789
- 48113 789
- 48121 789
- 48141 789
- 48157 789
- 48167 789
- 48183 789
- 48321 789
- 48041 788
- 48139 788
- 48303 788
- 48285 787
- 48309 787
- 48325 787
- 48401 787
- 48479 787
- 48485 787
- 48491 787
- 48061 786
- 48103 786
- …
county >30
- Harris 790
- Hays 790
- Montgomery 790
- Smith 790
- Tarrant 790
- Travis 790
- Bell 789
- Bexar 789
- Bowie 789
- Brazoria 789
- Collin 789
- Dallas 789
- Denton 789
- El Paso 789
- Fort Bend 789
- Galveston 789
- Gregg 789
- Matagorda 789
- Brazos 788
- Ellis 788
- Lubbock 788
- Lavaca 787
- McLennan 787
- Medina 787
- Rusk 787
- Webb 787
- Wichita 787
- Williamson 787
- Cameron 786
- Crane 786
- …
state 1
- Texas · 193,419 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2679 | 2679 | 2020-03-15 | Harris | Texas | 48201 | 13 | 0 |
2680 | 2680 | 2020-03-15 | Hays | Texas | 48209 | 1 | 0 |
2681 | 2681 | 2020-03-15 | Montgomery | Texas | 48339 | 1 | 0 |
2682 | 2682 | 2020-03-15 | Smith | Texas | 48423 | 4 | 0 |
2683 | 2683 | 2020-03-15 | Tarrant | Texas | 48439 | 4 | 0 |
2684 | 2684 | 2020-03-15 | Travis | Texas | 48453 | 6 | 0 |
3136 | 3136 | 2020-03-16 | Bell | Texas | 48027 | 1 | 0 |
3137 | 3137 | 2020-03-16 | Bexar | Texas | 48029 | 13 | 0 |
3138 | 3138 | 2020-03-16 | Bowie | Texas | 48037 | 1 | 0 |
3139 | 3139 | 2020-03-16 | Brazoria | Texas | 48039 | 2 | 0 |
3140 | 3140 | 2020-03-16 | Collin | Texas | 48085 | 8 | 0 |
3141 | 3141 | 2020-03-16 | Dallas | Texas | 48113 | 14 | 0 |
3142 | 3142 | 2020-03-16 | Denton | Texas | 48121 | 1 | 0 |
3143 | 3143 | 2020-03-16 | El Paso | Texas | 48141 | 2 | 0 |
3144 | 3144 | 2020-03-16 | Fort Bend | Texas | 48157 | 9 | 0 |
3145 | 3145 | 2020-03-16 | Galveston | Texas | 48167 | 1 | 0 |
3146 | 3146 | 2020-03-16 | Gregg | Texas | 48183 | 1 | 0 |
3147 | 3147 | 2020-03-16 | Harris | Texas | 48201 | 13 | 0 |
3148 | 3148 | 2020-03-16 | Hays | Texas | 48209 | 1 | 0 |
3149 | 3149 | 2020-03-16 | Matagorda | Texas | 48321 | 2 | 1 |
3150 | 3150 | 2020-03-16 | Montgomery | Texas | 48339 | 3 | 0 |
3151 | 3151 | 2020-03-16 | Smith | Texas | 48423 | 4 | 0 |
3152 | 3152 | 2020-03-16 | Tarrant | Texas | 48439 | 5 | 0 |
3153 | 3153 | 2020-03-16 | Travis | Texas | 48453 | 6 | 0 |
3669 | 3669 | 2020-03-17 | Bell | Texas | 48027 | 1 | 0 |
3670 | 3670 | 2020-03-17 | Bexar | Texas | 48029 | 13 | 0 |
3671 | 3671 | 2020-03-17 | Bowie | Texas | 48037 | 1 | 0 |
3672 | 3672 | 2020-03-17 | Brazoria | Texas | 48039 | 2 | 0 |
3673 | 3673 | 2020-03-17 | Brazos | Texas | 48041 | 1 | 0 |
3674 | 3674 | 2020-03-17 | Collin | Texas | 48085 | 8 | 0 |
3675 | 3675 | 2020-03-17 | Dallas | Texas | 48113 | 23 | 0 |
3676 | 3676 | 2020-03-17 | Denton | Texas | 48121 | 1 | 0 |
3677 | 3677 | 2020-03-17 | El Paso | Texas | 48141 | 2 | 0 |
3678 | 3678 | 2020-03-17 | Ellis | Texas | 48139 | 2 | 0 |
3679 | 3679 | 2020-03-17 | Fort Bend | Texas | 48157 | 10 | 0 |
3680 | 3680 | 2020-03-17 | Galveston | Texas | 48167 | 1 | 0 |
3681 | 3681 | 2020-03-17 | Gregg | Texas | 48183 | 1 | 0 |
3682 | 3682 | 2020-03-17 | Harris | Texas | 48201 | 16 | 0 |
3683 | 3683 | 2020-03-17 | Hays | Texas | 48209 | 1 | 0 |
3684 | 3684 | 2020-03-17 | Lubbock | Texas | 48303 | 2 | 0 |
3685 | 3685 | 2020-03-17 | Matagorda | Texas | 48321 | 2 | 1 |
3686 | 3686 | 2020-03-17 | Montgomery | Texas | 48339 | 3 | 0 |
3687 | 3687 | 2020-03-17 | Smith | Texas | 48423 | 4 | 0 |
3688 | 3688 | 2020-03-17 | Tarrant | Texas | 48439 | 6 | 0 |
3689 | 3689 | 2020-03-17 | Travis | Texas | 48453 | 6 | 0 |
4292 | 4292 | 2020-03-18 | Bell | Texas | 48027 | 1 | 0 |
4293 | 4293 | 2020-03-18 | Bexar | Texas | 48029 | 13 | 0 |
4294 | 4294 | 2020-03-18 | Bowie | Texas | 48037 | 1 | 0 |
4295 | 4295 | 2020-03-18 | Brazoria | Texas | 48039 | 4 | 0 |
4296 | 4296 | 2020-03-18 | Brazos | Texas | 48041 | 3 | 0 |
4297 | 4297 | 2020-03-18 | Collin | Texas | 48085 | 13 | 1 |
4298 | 4298 | 2020-03-18 | Dallas | Texas | 48113 | 34 | 0 |
4299 | 4299 | 2020-03-18 | Denton | Texas | 48121 | 5 | 0 |
4300 | 4300 | 2020-03-18 | El Paso | Texas | 48141 | 3 | 0 |
4301 | 4301 | 2020-03-18 | Ellis | Texas | 48139 | 2 | 0 |
4302 | 4302 | 2020-03-18 | Fort Bend | Texas | 48157 | 12 | 0 |
4303 | 4303 | 2020-03-18 | Galveston | Texas | 48167 | 4 | 0 |
4304 | 4304 | 2020-03-18 | Gregg | Texas | 48183 | 1 | 0 |
4305 | 4305 | 2020-03-18 | Harris | Texas | 48201 | 28 | 0 |
4306 | 4306 | 2020-03-18 | Hays | Texas | 48209 | 3 | 0 |
4307 | 4307 | 2020-03-18 | Lavaca | Texas | 48285 | 1 | 0 |
4308 | 4308 | 2020-03-18 | Lubbock | Texas | 48303 | 3 | 0 |
4309 | 4309 | 2020-03-18 | Matagorda | Texas | 48321 | 2 | 1 |
4310 | 4310 | 2020-03-18 | McLennan | Texas | 48309 | 5 | 0 |
4311 | 4311 | 2020-03-18 | Medina | Texas | 48325 | 1 | 0 |
4312 | 4312 | 2020-03-18 | Montgomery | Texas | 48339 | 3 | 0 |
4313 | 4313 | 2020-03-18 | Rusk | Texas | 48401 | 1 | 0 |
4314 | 4314 | 2020-03-18 | Smith | Texas | 48423 | 5 | 0 |
4315 | 4315 | 2020-03-18 | Tarrant | Texas | 48439 | 6 | 0 |
4316 | 4316 | 2020-03-18 | Travis | Texas | 48453 | 6 | 0 |
4317 | 4317 | 2020-03-18 | Webb | Texas | 48479 | 1 | 0 |
4318 | 4318 | 2020-03-18 | Wichita | Texas | 48485 | 1 | 0 |
4319 | 4319 | 2020-03-18 | Williamson | Texas | 48491 | 4 | 0 |
5043 | 5043 | 2020-03-19 | Bell | Texas | 48027 | 1 | 0 |
5044 | 5044 | 2020-03-19 | Bexar | Texas | 48029 | 17 | 0 |
5045 | 5045 | 2020-03-19 | Bowie | Texas | 48037 | 1 | 0 |
5046 | 5046 | 2020-03-19 | Brazoria | Texas | 48039 | 4 | 0 |
5047 | 5047 | 2020-03-19 | Brazos | Texas | 48041 | 4 | 0 |
5048 | 5048 | 2020-03-19 | Cameron | Texas | 48061 | 1 | 0 |
5049 | 5049 | 2020-03-19 | Collin | Texas | 48085 | 18 | 1 |
5050 | 5050 | 2020-03-19 | Crane | Texas | 48103 | 1 | 0 |
5051 | 5051 | 2020-03-19 | Dallas | Texas | 48113 | 56 | 1 |
5052 | 5052 | 2020-03-19 | DeWitt | Texas | 48123 | 1 | 0 |
5053 | 5053 | 2020-03-19 | Denton | Texas | 48121 | 9 | 0 |
5054 | 5054 | 2020-03-19 | El Paso | Texas | 48141 | 6 | 0 |
5055 | 5055 | 2020-03-19 | Ellis | Texas | 48139 | 2 | 0 |
5056 | 5056 | 2020-03-19 | Fort Bend | Texas | 48157 | 19 | 0 |
5057 | 5057 | 2020-03-19 | Galveston | Texas | 48167 | 4 | 0 |
5058 | 5058 | 2020-03-19 | Gregg | Texas | 48183 | 1 | 0 |
5059 | 5059 | 2020-03-19 | Harris | Texas | 48201 | 35 | 1 |
5060 | 5060 | 2020-03-19 | Hays | Texas | 48209 | 5 | 0 |
5061 | 5061 | 2020-03-19 | Johnson | Texas | 48251 | 2 | 0 |
5062 | 5062 | 2020-03-19 | Lavaca | Texas | 48285 | 1 | 0 |
5063 | 5063 | 2020-03-19 | Lubbock | Texas | 48303 | 3 | 0 |
5064 | 5064 | 2020-03-19 | Matagorda | Texas | 48321 | 3 | 1 |
5065 | 5065 | 2020-03-19 | McLennan | Texas | 48309 | 7 | 0 |
5066 | 5066 | 2020-03-19 | Medina | Texas | 48325 | 1 | 0 |
5067 | 5067 | 2020-03-19 | Montgomery | Texas | 48339 | 3 | 0 |
5068 | 5068 | 2020-03-19 | Rusk | Texas | 48401 | 1 | 0 |
5069 | 5069 | 2020-03-19 | Smith | Texas | 48423 | 5 | 0 |
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);