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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
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
- …
date (date) >30 ✖
- 2022-01-15 255
- 2022-01-16 255
- 2022-01-17 255
- 2022-01-18 255
- 2022-01-19 255
- 2022-01-20 255
- 2022-01-21 255
- 2022-01-22 255
- 2022-01-23 255
- 2022-01-24 255
- 2022-01-25 255
- 2022-01-26 255
- 2022-01-27 255
- 2022-01-28 255
- 2022-01-29 255
- 2022-01-30 255
- 2022-01-31 255
- 2022-02-01 255
- 2022-02-05 255
- 2022-02-06 255
- 2022-05-09 255
- 2022-05-10 255
- 2022-05-11 255
- 2022-05-12 255
- 2022-05-13 255
- 2020-11-17 254
- 2020-11-18 254
- 2020-11-19 254
- 2020-11-20 254
- 2020-11-21 254
- …
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 ▼ |
---|---|---|---|---|---|---|---|
144 | 144 | 2020-02-12 | Bexar | Texas | 48029 | 1 | 0 |
155 | 155 | 2020-02-13 | Bexar | Texas | 48029 | 2 | 0 |
166 | 166 | 2020-02-14 | Bexar | Texas | 48029 | 2 | 0 |
177 | 177 | 2020-02-15 | Bexar | Texas | 48029 | 2 | 0 |
188 | 188 | 2020-02-16 | Bexar | Texas | 48029 | 2 | 0 |
200 | 200 | 2020-02-17 | Bexar | Texas | 48029 | 2 | 0 |
212 | 212 | 2020-02-18 | Bexar | Texas | 48029 | 2 | 0 |
224 | 224 | 2020-02-19 | Bexar | Texas | 48029 | 2 | 0 |
237 | 237 | 2020-02-20 | Bexar | Texas | 48029 | 2 | 0 |
251 | 251 | 2020-02-21 | Bexar | Texas | 48029 | 4 | 0 |
265 | 265 | 2020-02-22 | Bexar | Texas | 48029 | 4 | 0 |
279 | 279 | 2020-02-23 | Bexar | Texas | 48029 | 4 | 0 |
294 | 294 | 2020-02-24 | Bexar | Texas | 48029 | 10 | 0 |
310 | 310 | 2020-02-25 | Bexar | Texas | 48029 | 10 | 0 |
330 | 330 | 2020-02-26 | Bexar | Texas | 48029 | 10 | 0 |
350 | 350 | 2020-02-27 | Bexar | Texas | 48029 | 10 | 0 |
371 | 371 | 2020-02-28 | Bexar | Texas | 48029 | 11 | 0 |
393 | 393 | 2020-02-29 | Bexar | Texas | 48029 | 11 | 0 |
420 | 420 | 2020-03-01 | Bexar | Texas | 48029 | 11 | 0 |
452 | 452 | 2020-03-02 | Bexar | Texas | 48029 | 11 | 0 |
487 | 487 | 2020-03-03 | Bexar | Texas | 48029 | 11 | 0 |
524 | 524 | 2020-03-04 | Bexar | Texas | 48029 | 11 | 0 |
525 | 525 | 2020-03-04 | Fort Bend | Texas | 48157 | 1 | 0 |
572 | 572 | 2020-03-05 | Bexar | Texas | 48029 | 11 | 0 |
573 | 573 | 2020-03-05 | Fort Bend | Texas | 48157 | 1 | 0 |
574 | 574 | 2020-03-05 | Harris | Texas | 48201 | 4 | 0 |
641 | 641 | 2020-03-06 | Bexar | Texas | 48029 | 11 | 0 |
642 | 642 | 2020-03-06 | Fort Bend | Texas | 48157 | 3 | 0 |
643 | 643 | 2020-03-06 | Harris | Texas | 48201 | 5 | 0 |
733 | 733 | 2020-03-07 | Bexar | Texas | 48029 | 11 | 0 |
734 | 734 | 2020-03-07 | Fort Bend | Texas | 48157 | 3 | 0 |
735 | 735 | 2020-03-07 | Harris | Texas | 48201 | 5 | 0 |
845 | 845 | 2020-03-08 | Bexar | Texas | 48029 | 11 | 0 |
846 | 846 | 2020-03-08 | Fort Bend | Texas | 48157 | 6 | 0 |
847 | 847 | 2020-03-08 | Harris | Texas | 48201 | 6 | 0 |
974 | 974 | 2020-03-09 | Bexar | Texas | 48029 | 11 | 0 |
975 | 975 | 2020-03-09 | Collin | Texas | 48085 | 1 | 0 |
976 | 976 | 2020-03-09 | Fort Bend | Texas | 48157 | 6 | 0 |
977 | 977 | 2020-03-09 | Harris | Texas | 48201 | 6 | 0 |
1132 | 1132 | 2020-03-10 | Bexar | Texas | 48029 | 11 | 0 |
1133 | 1133 | 2020-03-10 | Collin | Texas | 48085 | 3 | 0 |
1134 | 1134 | 2020-03-10 | Dallas | Texas | 48113 | 2 | 0 |
1135 | 1135 | 2020-03-10 | Fort Bend | Texas | 48157 | 6 | 0 |
1136 | 1136 | 2020-03-10 | Harris | Texas | 48201 | 7 | 0 |
1137 | 1137 | 2020-03-10 | Montgomery | Texas | 48339 | 1 | 0 |
1138 | 1138 | 2020-03-10 | Tarrant | Texas | 48439 | 1 | 0 |
1328 | 1328 | 2020-03-11 | Bexar | Texas | 48029 | 11 | 0 |
1329 | 1329 | 2020-03-11 | Collin | Texas | 48085 | 3 | 0 |
1330 | 1330 | 2020-03-11 | Dallas | Texas | 48113 | 3 | 0 |
1331 | 1331 | 2020-03-11 | Fort Bend | Texas | 48157 | 6 | 0 |
1332 | 1332 | 2020-03-11 | Gregg | Texas | 48183 | 1 | 0 |
1333 | 1333 | 2020-03-11 | Harris | Texas | 48201 | 7 | 0 |
1334 | 1334 | 2020-03-11 | Montgomery | Texas | 48339 | 1 | 0 |
1335 | 1335 | 2020-03-11 | Tarrant | Texas | 48439 | 1 | 0 |
1575 | 1575 | 2020-03-12 | Bexar | Texas | 48029 | 11 | 0 |
1576 | 1576 | 2020-03-12 | Collin | Texas | 48085 | 4 | 0 |
1577 | 1577 | 2020-03-12 | Dallas | Texas | 48113 | 8 | 0 |
1578 | 1578 | 2020-03-12 | Fort Bend | Texas | 48157 | 6 | 0 |
1579 | 1579 | 2020-03-12 | Gregg | Texas | 48183 | 1 | 0 |
1580 | 1580 | 2020-03-12 | Harris | Texas | 48201 | 9 | 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 |
1880 | 1880 | 2020-03-13 | Bexar | Texas | 48029 | 11 | 0 |
1881 | 1881 | 2020-03-13 | Collin | Texas | 48085 | 5 | 0 |
1882 | 1882 | 2020-03-13 | Dallas | Texas | 48113 | 9 | 0 |
1883 | 1883 | 2020-03-13 | El Paso | Texas | 48141 | 1 | 0 |
1884 | 1884 | 2020-03-13 | Fort Bend | Texas | 48157 | 9 | 0 |
1885 | 1885 | 2020-03-13 | Galveston | Texas | 48167 | 1 | 0 |
1886 | 1886 | 2020-03-13 | Gregg | Texas | 48183 | 1 | 0 |
1887 | 1887 | 2020-03-13 | Harris | Texas | 48201 | 10 | 0 |
1888 | 1888 | 2020-03-13 | Montgomery | Texas | 48339 | 1 | 0 |
1889 | 1889 | 2020-03-13 | Smith | Texas | 48423 | 3 | 0 |
1890 | 1890 | 2020-03-13 | Tarrant | Texas | 48439 | 2 | 0 |
1891 | 1891 | 2020-03-13 | Travis | Texas | 48453 | 4 | 0 |
2244 | 2244 | 2020-03-14 | Bell | Texas | 48027 | 1 | 0 |
2245 | 2245 | 2020-03-14 | Bexar | Texas | 48029 | 12 | 0 |
2246 | 2246 | 2020-03-14 | Brazoria | Texas | 48039 | 2 | 0 |
2247 | 2247 | 2020-03-14 | Collin | Texas | 48085 | 7 | 0 |
2248 | 2248 | 2020-03-14 | Dallas | Texas | 48113 | 11 | 0 |
2249 | 2249 | 2020-03-14 | El Paso | Texas | 48141 | 1 | 0 |
2250 | 2250 | 2020-03-14 | Fort Bend | Texas | 48157 | 9 | 0 |
2251 | 2251 | 2020-03-14 | Galveston | Texas | 48167 | 1 | 0 |
2252 | 2252 | 2020-03-14 | Gregg | Texas | 48183 | 1 | 0 |
2253 | 2253 | 2020-03-14 | Harris | Texas | 48201 | 11 | 0 |
2254 | 2254 | 2020-03-14 | Hays | Texas | 48209 | 1 | 0 |
2255 | 2255 | 2020-03-14 | Montgomery | Texas | 48339 | 1 | 0 |
2256 | 2256 | 2020-03-14 | Smith | Texas | 48423 | 3 | 0 |
2257 | 2257 | 2020-03-14 | Tarrant | Texas | 48439 | 4 | 0 |
2258 | 2258 | 2020-03-14 | Travis | Texas | 48453 | 4 | 0 |
2669 | 2669 | 2020-03-15 | Bell | Texas | 48027 | 1 | 0 |
2670 | 2670 | 2020-03-15 | Bexar | Texas | 48029 | 12 | 0 |
2671 | 2671 | 2020-03-15 | Brazoria | Texas | 48039 | 2 | 0 |
2672 | 2672 | 2020-03-15 | Collin | Texas | 48085 | 8 | 0 |
2673 | 2673 | 2020-03-15 | Dallas | Texas | 48113 | 14 | 0 |
2674 | 2674 | 2020-03-15 | Denton | Texas | 48121 | 1 | 0 |
2675 | 2675 | 2020-03-15 | El Paso | Texas | 48141 | 2 | 0 |
2676 | 2676 | 2020-03-15 | Fort Bend | Texas | 48157 | 9 | 0 |
2677 | 2677 | 2020-03-15 | Galveston | Texas | 48167 | 1 | 0 |
2678 | 2678 | 2020-03-15 | Gregg | Texas | 48183 | 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);