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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Texas · 182 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
8916 | 8916 | 2020-08-11 | Texas | 48 | 524898 | 9311 |
8861 | 8861 | 2020-08-10 | Texas | 48 | 517182 | 9064 |
8806 | 8806 | 2020-08-09 | Texas | 48 | 510392 | 8984 |
8751 | 8751 | 2020-08-08 | Texas | 48 | 504605 | 8885 |
8696 | 8696 | 2020-08-07 | Texas | 48 | 498266 | 8680 |
8641 | 8641 | 2020-08-06 | Texas | 48 | 490102 | 8400 |
8586 | 8586 | 2020-08-05 | Texas | 48 | 482467 | 8152 |
8531 | 8531 | 2020-08-04 | Texas | 48 | 473105 | 7951 |
8476 | 8476 | 2020-08-03 | Texas | 48 | 463541 | 7697 |
8421 | 8421 | 2020-08-02 | Texas | 48 | 454759 | 7520 |
8366 | 8366 | 2020-08-01 | Texas | 48 | 448224 | 7477 |
8311 | 8311 | 2020-07-31 | Texas | 48 | 443090 | 7273 |
8256 | 8256 | 2020-07-30 | Texas | 48 | 432134 | 6987 |
8201 | 8201 | 2020-07-29 | Texas | 48 | 421891 | 6834 |
8146 | 8146 | 2020-07-28 | Texas | 48 | 412849 | 6518 |
8091 | 8091 | 2020-07-27 | Texas | 48 | 402295 | 6292 |
8036 | 8036 | 2020-07-26 | Texas | 48 | 395738 | 5090 |
7981 | 7981 | 2020-07-25 | Texas | 48 | 391609 | 5002 |
7926 | 7926 | 2020-07-24 | Texas | 48 | 383662 | 4876 |
7871 | 7871 | 2020-07-23 | Texas | 48 | 376104 | 4714 |
7816 | 7816 | 2020-07-22 | Texas | 48 | 366561 | 4522 |
7761 | 7761 | 2020-07-21 | Texas | 48 | 355594 | 4319 |
7706 | 7706 | 2020-07-20 | Texas | 48 | 345672 | 4160 |
7651 | 7651 | 2020-07-19 | Texas | 48 | 338036 | 4033 |
7596 | 7596 | 2020-07-18 | Texas | 48 | 330059 | 3972 |
7541 | 7541 | 2020-07-17 | Texas | 48 | 321254 | 3889 |
7486 | 7486 | 2020-07-16 | Texas | 48 | 311516 | 3744 |
7431 | 7431 | 2020-07-15 | Texas | 48 | 296478 | 3590 |
7376 | 7376 | 2020-07-14 | Texas | 48 | 284638 | 3449 |
7321 | 7321 | 2020-07-13 | Texas | 48 | 273732 | 3313 |
7266 | 7266 | 2020-07-12 | Texas | 48 | 264811 | 3246 |
7211 | 7211 | 2020-07-11 | Texas | 48 | 258280 | 3206 |
7156 | 7156 | 2020-07-10 | Texas | 48 | 249948 | 3129 |
7101 | 7101 | 2020-07-09 | Texas | 48 | 240025 | 3037 |
7046 | 7046 | 2020-07-08 | Texas | 48 | 229116 | 2935 |
6991 | 6991 | 2020-07-07 | Texas | 48 | 219164 | 2816 |
6936 | 6936 | 2020-07-06 | Texas | 48 | 209350 | 2726 |
6881 | 6881 | 2020-07-05 | Texas | 48 | 200137 | 2666 |
6826 | 6826 | 2020-07-04 | Texas | 48 | 195707 | 2646 |
6771 | 6771 | 2020-07-03 | Texas | 48 | 190049 | 2609 |
6716 | 6716 | 2020-07-02 | Texas | 48 | 182260 | 2562 |
6661 | 6661 | 2020-07-01 | Texas | 48 | 174826 | 2518 |
6606 | 6606 | 2020-06-30 | Texas | 48 | 166703 | 2482 |
6551 | 6551 | 2020-06-29 | Texas | 48 | 158756 | 2430 |
6496 | 6496 | 2020-06-28 | Texas | 48 | 152866 | 2408 |
6441 | 6441 | 2020-06-27 | Texas | 48 | 148639 | 2398 |
6386 | 6386 | 2020-06-26 | Texas | 48 | 142582 | 2362 |
6331 | 6331 | 2020-06-25 | Texas | 48 | 136783 | 2321 |
6276 | 6276 | 2020-06-24 | Texas | 48 | 131310 | 2292 |
6221 | 6221 | 2020-06-23 | Texas | 48 | 124726 | 2246 |
6166 | 6166 | 2020-06-22 | Texas | 48 | 119646 | 2213 |
6111 | 6111 | 2020-06-21 | Texas | 48 | 114886 | 2195 |
6056 | 6056 | 2020-06-20 | Texas | 48 | 111594 | 2186 |
6001 | 6001 | 2020-06-19 | Texas | 48 | 107322 | 2168 |
5946 | 5946 | 2020-06-18 | Texas | 48 | 102677 | 2137 |
5891 | 5891 | 2020-06-17 | Texas | 48 | 99466 | 2099 |
5836 | 5836 | 2020-06-16 | Texas | 48 | 95973 | 2057 |
5781 | 5781 | 2020-06-15 | Texas | 48 | 91726 | 2018 |
5726 | 5726 | 2020-06-14 | Texas | 48 | 89542 | 1995 |
5671 | 5671 | 2020-06-13 | Texas | 48 | 88120 | 1989 |
5616 | 5616 | 2020-06-12 | Texas | 48 | 86031 | 1965 |
5561 | 5561 | 2020-06-11 | Texas | 48 | 83772 | 1942 |
5506 | 5506 | 2020-06-10 | Texas | 48 | 81771 | 1916 |
5451 | 5451 | 2020-06-09 | Texas | 48 | 79271 | 1886 |
5396 | 5396 | 2020-06-08 | Texas | 48 | 77326 | 1856 |
5341 | 5341 | 2020-06-07 | Texas | 48 | 75948 | 1846 |
5286 | 5286 | 2020-06-06 | Texas | 48 | 75077 | 1840 |
5231 | 5231 | 2020-06-05 | Texas | 48 | 73323 | 1821 |
5176 | 5176 | 2020-06-04 | Texas | 48 | 71330 | 1793 |
5121 | 5121 | 2020-06-03 | Texas | 48 | 69546 | 1766 |
5066 | 5066 | 2020-06-02 | Texas | 48 | 67966 | 1732 |
5011 | 5011 | 2020-06-01 | Texas | 48 | 66081 | 1695 |
4956 | 4956 | 2020-05-31 | Texas | 48 | 64974 | 1683 |
4901 | 4901 | 2020-05-30 | Texas | 48 | 63396 | 1676 |
4846 | 4846 | 2020-05-29 | Texas | 48 | 62073 | 1645 |
4791 | 4791 | 2020-05-28 | Texas | 48 | 60820 | 1618 |
4736 | 4736 | 2020-05-27 | Texas | 48 | 59105 | 1598 |
4681 | 4681 | 2020-05-26 | Texas | 48 | 57573 | 1552 |
4626 | 4626 | 2020-05-25 | Texas | 48 | 56490 | 1536 |
4571 | 4571 | 2020-05-24 | Texas | 48 | 56050 | 1533 |
4516 | 4516 | 2020-05-23 | Texas | 48 | 55451 | 1522 |
4461 | 4461 | 2020-05-22 | Texas | 48 | 54369 | 1498 |
4406 | 4406 | 2020-05-21 | Texas | 48 | 53441 | 1480 |
4351 | 4351 | 2020-05-20 | Texas | 48 | 52369 | 1443 |
4296 | 4296 | 2020-05-19 | Texas | 48 | 51080 | 1405 |
4241 | 4241 | 2020-05-18 | Texas | 48 | 49788 | 1362 |
4186 | 4186 | 2020-05-17 | Texas | 48 | 48828 | 1356 |
4131 | 4131 | 2020-05-16 | Texas | 48 | 47866 | 1330 |
4076 | 4076 | 2020-05-15 | Texas | 48 | 46987 | 1300 |
4021 | 4021 | 2020-05-14 | Texas | 48 | 45169 | 1256 |
3966 | 3966 | 2020-05-13 | Texas | 48 | 43822 | 1205 |
3911 | 3911 | 2020-05-12 | Texas | 48 | 42348 | 1169 |
3856 | 3856 | 2020-05-11 | Texas | 48 | 40988 | 1137 |
3801 | 3801 | 2020-05-10 | Texas | 48 | 40037 | 1110 |
3746 | 3746 | 2020-05-09 | Texas | 48 | 38849 | 1086 |
3691 | 3691 | 2020-05-08 | Texas | 48 | 37943 | 1059 |
3636 | 3636 | 2020-05-07 | Texas | 48 | 36682 | 1016 |
3581 | 3581 | 2020-05-06 | Texas | 48 | 35441 | 985 |
3526 | 3526 | 2020-05-05 | Texas | 48 | 34286 | 955 |
3471 | 3471 | 2020-05-04 | Texas | 48 | 33134 | 914 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );