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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 48029 822
- 48157 801
- 48201 800
- 48085 796
- 48113 795
- 48339 795
- 48439 795
- 48183 794
- 48027 792
- 48141 792
- 48167 792
- 48423 792
- 48453 792
- 48039 791
- 48209 791
- 48121 790
- 48037 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
- Bexar 822
- Fort Bend 801
- Harris 800
- Collin 796
- Dallas 795
- Montgomery 795
- Tarrant 795
- Gregg 794
- Bell 792
- El Paso 792
- Galveston 792
- Smith 792
- Travis 792
- Brazoria 791
- Hays 791
- Denton 790
- Bowie 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,519 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
10679 | 10679 | 2020-03-24 | Unknown | Texas | 0 | 1 | |
144 | 144 | 2020-02-12 | Bexar | Texas | 48029 | 1 | 0 |
525 | 525 | 2020-03-04 | Fort Bend | Texas | 48157 | 1 | 0 |
573 | 573 | 2020-03-05 | Fort Bend | Texas | 48157 | 1 | 0 |
975 | 975 | 2020-03-09 | Collin | Texas | 48085 | 1 | 0 |
1137 | 1137 | 2020-03-10 | Montgomery | Texas | 48339 | 1 | 0 |
1138 | 1138 | 2020-03-10 | Tarrant | Texas | 48439 | 1 | 0 |
1332 | 1332 | 2020-03-11 | Gregg | Texas | 48183 | 1 | 0 |
1334 | 1334 | 2020-03-11 | Montgomery | Texas | 48339 | 1 | 0 |
1335 | 1335 | 2020-03-11 | Tarrant | Texas | 48439 | 1 | 0 |
1579 | 1579 | 2020-03-12 | Gregg | Texas | 48183 | 1 | 0 |
1581 | 1581 | 2020-03-12 | Montgomery | Texas | 48339 | 1 | 0 |
1582 | 1582 | 2020-03-12 | Tarrant | Texas | 48439 | 1 | 0 |
1879 | 1879 | 2020-03-13 | Bell | Texas | 48027 | 1 | 0 |
1883 | 1883 | 2020-03-13 | El Paso | Texas | 48141 | 1 | 0 |
1885 | 1885 | 2020-03-13 | Galveston | Texas | 48167 | 1 | 0 |
1886 | 1886 | 2020-03-13 | Gregg | Texas | 48183 | 1 | 0 |
1888 | 1888 | 2020-03-13 | Montgomery | Texas | 48339 | 1 | 0 |
2244 | 2244 | 2020-03-14 | Bell | Texas | 48027 | 1 | 0 |
2249 | 2249 | 2020-03-14 | El Paso | Texas | 48141 | 1 | 0 |
2251 | 2251 | 2020-03-14 | Galveston | Texas | 48167 | 1 | 0 |
2252 | 2252 | 2020-03-14 | Gregg | Texas | 48183 | 1 | 0 |
2254 | 2254 | 2020-03-14 | Hays | Texas | 48209 | 1 | 0 |
2255 | 2255 | 2020-03-14 | Montgomery | Texas | 48339 | 1 | 0 |
2669 | 2669 | 2020-03-15 | Bell | Texas | 48027 | 1 | 0 |
2674 | 2674 | 2020-03-15 | Denton | Texas | 48121 | 1 | 0 |
2677 | 2677 | 2020-03-15 | Galveston | Texas | 48167 | 1 | 0 |
2678 | 2678 | 2020-03-15 | Gregg | Texas | 48183 | 1 | 0 |
2680 | 2680 | 2020-03-15 | Hays | Texas | 48209 | 1 | 0 |
2681 | 2681 | 2020-03-15 | Montgomery | Texas | 48339 | 1 | 0 |
3136 | 3136 | 2020-03-16 | Bell | Texas | 48027 | 1 | 0 |
3138 | 3138 | 2020-03-16 | Bowie | Texas | 48037 | 1 | 0 |
3142 | 3142 | 2020-03-16 | Denton | Texas | 48121 | 1 | 0 |
3145 | 3145 | 2020-03-16 | Galveston | Texas | 48167 | 1 | 0 |
3146 | 3146 | 2020-03-16 | Gregg | Texas | 48183 | 1 | 0 |
3148 | 3148 | 2020-03-16 | Hays | Texas | 48209 | 1 | 0 |
3669 | 3669 | 2020-03-17 | Bell | Texas | 48027 | 1 | 0 |
3671 | 3671 | 2020-03-17 | Bowie | Texas | 48037 | 1 | 0 |
3673 | 3673 | 2020-03-17 | Brazos | Texas | 48041 | 1 | 0 |
3676 | 3676 | 2020-03-17 | Denton | Texas | 48121 | 1 | 0 |
3680 | 3680 | 2020-03-17 | Galveston | Texas | 48167 | 1 | 0 |
3681 | 3681 | 2020-03-17 | Gregg | Texas | 48183 | 1 | 0 |
3683 | 3683 | 2020-03-17 | Hays | Texas | 48209 | 1 | 0 |
4292 | 4292 | 2020-03-18 | Bell | Texas | 48027 | 1 | 0 |
4294 | 4294 | 2020-03-18 | Bowie | Texas | 48037 | 1 | 0 |
4304 | 4304 | 2020-03-18 | Gregg | Texas | 48183 | 1 | 0 |
4307 | 4307 | 2020-03-18 | Lavaca | Texas | 48285 | 1 | 0 |
4311 | 4311 | 2020-03-18 | Medina | Texas | 48325 | 1 | 0 |
4313 | 4313 | 2020-03-18 | Rusk | Texas | 48401 | 1 | 0 |
4317 | 4317 | 2020-03-18 | Webb | Texas | 48479 | 1 | 0 |
4318 | 4318 | 2020-03-18 | Wichita | Texas | 48485 | 1 | 0 |
5043 | 5043 | 2020-03-19 | Bell | Texas | 48027 | 1 | 0 |
5045 | 5045 | 2020-03-19 | Bowie | Texas | 48037 | 1 | 0 |
5048 | 5048 | 2020-03-19 | Cameron | Texas | 48061 | 1 | 0 |
5050 | 5050 | 2020-03-19 | Crane | Texas | 48103 | 1 | 0 |
5052 | 5052 | 2020-03-19 | DeWitt | Texas | 48123 | 1 | 0 |
5058 | 5058 | 2020-03-19 | Gregg | Texas | 48183 | 1 | 0 |
5062 | 5062 | 2020-03-19 | Lavaca | Texas | 48285 | 1 | 0 |
5066 | 5066 | 2020-03-19 | Medina | Texas | 48325 | 1 | 0 |
5068 | 5068 | 2020-03-19 | Rusk | Texas | 48401 | 1 | 0 |
5072 | 5072 | 2020-03-19 | Van Zandt | Texas | 48467 | 1 | 0 |
5073 | 5073 | 2020-03-19 | Webb | Texas | 48479 | 1 | 0 |
5074 | 5074 | 2020-03-19 | Wichita | Texas | 48485 | 1 | 0 |
5934 | 5934 | 2020-03-20 | Bowie | Texas | 48037 | 1 | 0 |
5937 | 5937 | 2020-03-20 | Brown | Texas | 48049 | 1 | 0 |
5938 | 5938 | 2020-03-20 | Cameron | Texas | 48061 | 1 | 0 |
5939 | 5939 | 2020-03-20 | Cass | Texas | 48067 | 1 | 0 |
5941 | 5941 | 2020-03-20 | Crane | Texas | 48103 | 1 | 0 |
5943 | 5943 | 2020-03-20 | DeWitt | Texas | 48123 | 1 | 0 |
5947 | 5947 | 2020-03-20 | Fannin | Texas | 48147 | 1 | 0 |
5950 | 5950 | 2020-03-20 | Gregg | Texas | 48183 | 1 | 0 |
5953 | 5953 | 2020-03-20 | Hockley | Texas | 48219 | 1 | 0 |
5955 | 5955 | 2020-03-20 | Lavaca | Texas | 48285 | 1 | 0 |
5959 | 5959 | 2020-03-20 | Medina | Texas | 48325 | 1 | 0 |
5961 | 5961 | 2020-03-20 | Rusk | Texas | 48401 | 1 | 0 |
5965 | 5965 | 2020-03-20 | Upshur | Texas | 48459 | 1 | 0 |
5966 | 5966 | 2020-03-20 | Van Zandt | Texas | 48467 | 1 | 0 |
5967 | 5967 | 2020-03-20 | Webb | Texas | 48479 | 1 | 0 |
6949 | 6949 | 2020-03-21 | Bastrop | Texas | 48021 | 1 | 0 |
6952 | 6952 | 2020-03-21 | Bowie | Texas | 48037 | 1 | 0 |
6957 | 6957 | 2020-03-21 | Cass | Texas | 48067 | 1 | 0 |
6958 | 6958 | 2020-03-21 | Castro | Texas | 48069 | 1 | 0 |
6960 | 6960 | 2020-03-21 | Crane | Texas | 48103 | 1 | 0 |
6962 | 6962 | 2020-03-21 | DeWitt | Texas | 48123 | 1 | 0 |
6963 | 6963 | 2020-03-21 | Deaf Smith | Texas | 48117 | 1 | 0 |
6967 | 6967 | 2020-03-21 | Fannin | Texas | 48147 | 1 | 0 |
6970 | 6970 | 2020-03-21 | Gregg | Texas | 48183 | 1 | 0 |
6975 | 6975 | 2020-03-21 | Lavaca | Texas | 48285 | 1 | 0 |
6979 | 6979 | 2020-03-21 | Medina | Texas | 48325 | 1 | 0 |
6980 | 6980 | 2020-03-21 | Midland | Texas | 48329 | 1 | 0 |
6982 | 6982 | 2020-03-21 | Oldham | Texas | 48359 | 1 | 0 |
6984 | 6984 | 2020-03-21 | Rusk | Texas | 48401 | 1 | 0 |
6988 | 6988 | 2020-03-21 | Upshur | Texas | 48459 | 1 | 0 |
6989 | 6989 | 2020-03-21 | Van Zandt | Texas | 48467 | 1 | 0 |
8079 | 8079 | 2020-03-22 | Bastrop | Texas | 48021 | 1 | 0 |
8082 | 8082 | 2020-03-22 | Bowie | Texas | 48037 | 1 | 0 |
8087 | 8087 | 2020-03-22 | Cass | Texas | 48067 | 1 | 0 |
8088 | 8088 | 2020-03-22 | Castro | Texas | 48069 | 1 | 0 |
8090 | 8090 | 2020-03-22 | Crane | Texas | 48103 | 1 | 0 |
8092 | 8092 | 2020-03-22 | DeWitt | Texas | 48123 | 1 | 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);