ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,052 rows where state = "Texas" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Texas · 1,052 ✖
Link | rowid | date | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|
99 | 99 | 2020-02-12 | Texas | 48 | 1 | 0 |
106 | 106 | 2020-02-13 | Texas | 48 | 2 | 0 |
113 | 113 | 2020-02-14 | Texas | 48 | 2 | 0 |
120 | 120 | 2020-02-15 | Texas | 48 | 2 | 0 |
127 | 127 | 2020-02-16 | Texas | 48 | 2 | 0 |
135 | 135 | 2020-02-17 | Texas | 48 | 2 | 0 |
143 | 143 | 2020-02-18 | Texas | 48 | 2 | 0 |
151 | 151 | 2020-02-19 | Texas | 48 | 2 | 0 |
159 | 159 | 2020-02-20 | Texas | 48 | 2 | 0 |
167 | 167 | 2020-02-21 | Texas | 48 | 4 | 0 |
175 | 175 | 2020-02-22 | Texas | 48 | 4 | 0 |
183 | 183 | 2020-02-23 | Texas | 48 | 4 | 0 |
191 | 191 | 2020-02-24 | Texas | 48 | 10 | 0 |
199 | 199 | 2020-02-25 | Texas | 48 | 10 | 0 |
208 | 208 | 2020-02-26 | Texas | 48 | 10 | 0 |
217 | 217 | 2020-02-27 | Texas | 48 | 10 | 0 |
227 | 227 | 2020-02-28 | Texas | 48 | 11 | 0 |
237 | 237 | 2020-02-29 | Texas | 48 | 11 | 0 |
250 | 250 | 2020-03-01 | Texas | 48 | 11 | 0 |
265 | 265 | 2020-03-02 | Texas | 48 | 11 | 0 |
281 | 281 | 2020-03-03 | Texas | 48 | 11 | 0 |
298 | 298 | 2020-03-04 | Texas | 48 | 12 | 0 |
319 | 319 | 2020-03-05 | Texas | 48 | 16 | 0 |
347 | 347 | 2020-03-06 | Texas | 48 | 19 | 0 |
378 | 378 | 2020-03-07 | Texas | 48 | 19 | 0 |
413 | 413 | 2020-03-08 | Texas | 48 | 23 | 0 |
450 | 450 | 2020-03-09 | Texas | 48 | 24 | 0 |
489 | 489 | 2020-03-10 | Texas | 48 | 31 | 0 |
533 | 533 | 2020-03-11 | Texas | 48 | 33 | 0 |
580 | 580 | 2020-03-12 | Texas | 48 | 41 | 0 |
631 | 631 | 2020-03-13 | Texas | 48 | 58 | 0 |
682 | 682 | 2020-03-14 | Texas | 48 | 69 | 0 |
735 | 735 | 2020-03-15 | Texas | 48 | 80 | 0 |
788 | 788 | 2020-03-16 | Texas | 48 | 87 | 1 |
841 | 841 | 2020-03-17 | Texas | 48 | 106 | 1 |
895 | 895 | 2020-03-18 | Texas | 48 | 166 | 2 |
949 | 949 | 2020-03-19 | Texas | 48 | 248 | 4 |
1003 | 1003 | 2020-03-20 | Texas | 48 | 386 | 5 |
1057 | 1057 | 2020-03-21 | Texas | 48 | 547 | 5 |
1111 | 1111 | 2020-03-22 | Texas | 48 | 639 | 7 |
1165 | 1165 | 2020-03-23 | Texas | 48 | 728 | 7 |
1219 | 1219 | 2020-03-24 | Texas | 48 | 857 | 11 |
1273 | 1273 | 2020-03-25 | Texas | 48 | 1132 | 13 |
1327 | 1327 | 2020-03-26 | Texas | 48 | 1542 | 21 |
1381 | 1381 | 2020-03-27 | Texas | 48 | 1971 | 25 |
1436 | 1436 | 2020-03-28 | Texas | 48 | 2381 | 30 |
1491 | 1491 | 2020-03-29 | Texas | 48 | 2722 | 35 |
1546 | 1546 | 2020-03-30 | Texas | 48 | 3065 | 46 |
1601 | 1601 | 2020-03-31 | Texas | 48 | 3588 | 57 |
1656 | 1656 | 2020-04-01 | Texas | 48 | 4402 | 65 |
1711 | 1711 | 2020-04-02 | Texas | 48 | 4952 | 80 |
1766 | 1766 | 2020-04-03 | Texas | 48 | 5773 | 98 |
1821 | 1821 | 2020-04-04 | Texas | 48 | 6566 | 124 |
1876 | 1876 | 2020-04-05 | Texas | 48 | 7117 | 136 |
1931 | 1931 | 2020-04-06 | Texas | 48 | 8150 | 159 |
1986 | 1986 | 2020-04-07 | Texas | 48 | 8968 | 177 |
2041 | 2041 | 2020-04-08 | Texas | 48 | 9897 | 195 |
2096 | 2096 | 2020-04-09 | Texas | 48 | 11372 | 228 |
2151 | 2151 | 2020-04-10 | Texas | 48 | 12291 | 249 |
2206 | 2206 | 2020-04-11 | Texas | 48 | 13208 | 265 |
2261 | 2261 | 2020-04-12 | Texas | 48 | 13776 | 288 |
2316 | 2316 | 2020-04-13 | Texas | 48 | 14487 | 320 |
2371 | 2371 | 2020-04-14 | Texas | 48 | 15303 | 365 |
2426 | 2426 | 2020-04-15 | Texas | 48 | 16106 | 395 |
2481 | 2481 | 2020-04-16 | Texas | 48 | 16928 | 428 |
2536 | 2536 | 2020-04-17 | Texas | 48 | 18131 | 461 |
2591 | 2591 | 2020-04-18 | Texas | 48 | 18927 | 487 |
2646 | 2646 | 2020-04-19 | Texas | 48 | 19441 | 503 |
2701 | 2701 | 2020-04-20 | Texas | 48 | 20035 | 523 |
2756 | 2756 | 2020-04-21 | Texas | 48 | 20949 | 552 |
2811 | 2811 | 2020-04-22 | Texas | 48 | 21769 | 571 |
2866 | 2866 | 2020-04-23 | Texas | 48 | 22706 | 601 |
2921 | 2921 | 2020-04-24 | Texas | 48 | 23650 | 625 |
2976 | 2976 | 2020-04-25 | Texas | 48 | 24494 | 662 |
3031 | 3031 | 2020-04-26 | Texas | 48 | 25209 | 676 |
3086 | 3086 | 2020-04-27 | Texas | 48 | 25963 | 699 |
3141 | 3141 | 2020-04-28 | Texas | 48 | 26868 | 738 |
3196 | 3196 | 2020-04-29 | Texas | 48 | 27839 | 776 |
3251 | 3251 | 2020-04-30 | Texas | 48 | 29072 | 828 |
3306 | 3306 | 2020-05-01 | Texas | 48 | 30342 | 853 |
3361 | 3361 | 2020-05-02 | Texas | 48 | 31433 | 875 |
3416 | 3416 | 2020-05-03 | Texas | 48 | 32299 | 890 |
3471 | 3471 | 2020-05-04 | Texas | 48 | 33134 | 914 |
3526 | 3526 | 2020-05-05 | Texas | 48 | 34286 | 955 |
3581 | 3581 | 2020-05-06 | Texas | 48 | 35441 | 985 |
3636 | 3636 | 2020-05-07 | Texas | 48 | 36682 | 1016 |
3691 | 3691 | 2020-05-08 | Texas | 48 | 37943 | 1059 |
3746 | 3746 | 2020-05-09 | Texas | 48 | 38849 | 1086 |
3801 | 3801 | 2020-05-10 | Texas | 48 | 40037 | 1110 |
3856 | 3856 | 2020-05-11 | Texas | 48 | 40988 | 1137 |
3911 | 3911 | 2020-05-12 | Texas | 48 | 42348 | 1169 |
3966 | 3966 | 2020-05-13 | Texas | 48 | 43822 | 1205 |
4021 | 4021 | 2020-05-14 | Texas | 48 | 45169 | 1256 |
4076 | 4076 | 2020-05-15 | Texas | 48 | 46987 | 1300 |
4131 | 4131 | 2020-05-16 | Texas | 48 | 47866 | 1330 |
4186 | 4186 | 2020-05-17 | Texas | 48 | 48828 | 1356 |
4241 | 4241 | 2020-05-18 | Texas | 48 | 49788 | 1362 |
4296 | 4296 | 2020-05-19 | Texas | 48 | 51080 | 1405 |
4351 | 4351 | 2020-05-20 | Texas | 48 | 52369 | 1443 |
4406 | 4406 | 2020-05-21 | Texas | 48 | 53441 | 1480 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );