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 · 347 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17991 | 17991 | 2021-01-23 | Texas | 48 | 2240136 | 34859 |
17936 | 17936 | 2021-01-22 | Texas | 48 | 2226203 | 34496 |
17881 | 17881 | 2021-01-21 | Texas | 48 | 2207935 | 34075 |
17826 | 17826 | 2021-01-20 | Texas | 48 | 2186469 | 33632 |
17771 | 17771 | 2021-01-19 | Texas | 48 | 2158462 | 33176 |
17716 | 17716 | 2021-01-18 | Texas | 48 | 2136595 | 32858 |
17661 | 17661 | 2021-01-17 | Texas | 48 | 2125391 | 32747 |
17606 | 17606 | 2021-01-16 | Texas | 48 | 2112925 | 32581 |
17551 | 17551 | 2021-01-15 | Texas | 48 | 2094606 | 32212 |
17496 | 17496 | 2021-01-14 | Texas | 48 | 2070044 | 31819 |
17441 | 17441 | 2021-01-13 | Texas | 48 | 2040144 | 31396 |
17386 | 17386 | 2021-01-12 | Texas | 48 | 2017036 | 31017 |
17331 | 17331 | 2021-01-11 | Texas | 48 | 1989821 | 30720 |
17276 | 17276 | 2021-01-10 | Texas | 48 | 1966081 | 30599 |
17221 | 17221 | 2021-01-09 | Texas | 48 | 1952047 | 30441 |
17166 | 17166 | 2021-01-08 | Texas | 48 | 1934504 | 30109 |
17111 | 17111 | 2021-01-07 | Texas | 48 | 1910426 | 29645 |
17056 | 17056 | 2021-01-06 | Texas | 48 | 1887800 | 29278 |
17001 | 17001 | 2021-01-05 | Texas | 48 | 1862478 | 28949 |
16946 | 16946 | 2021-01-04 | Texas | 48 | 1831486 | 28681 |
16891 | 16891 | 2021-01-03 | Texas | 48 | 1808382 | 28554 |
16836 | 16836 | 2021-01-02 | Texas | 48 | 1792363 | 28508 |
16781 | 16781 | 2021-01-01 | Texas | 48 | 1778306 | 28434 |
16726 | 16726 | 2020-12-31 | Texas | 48 | 1770527 | 28155 |
16671 | 16671 | 2020-12-30 | Texas | 48 | 1753686 | 27821 |
16616 | 16616 | 2020-12-29 | Texas | 48 | 1734268 | 27499 |
16561 | 16561 | 2020-12-28 | Texas | 48 | 1710489 | 27245 |
16506 | 16506 | 2020-12-27 | Texas | 48 | 1690021 | 27110 |
16451 | 16451 | 2020-12-26 | Texas | 48 | 1667352 | 27062 |
16396 | 16396 | 2020-12-25 | Texas | 48 | 1661619 | 27042 |
16341 | 16341 | 2020-12-24 | Texas | 48 | 1659551 | 26879 |
16286 | 16286 | 2020-12-23 | Texas | 48 | 1651560 | 26624 |
16231 | 16231 | 2020-12-22 | Texas | 48 | 1630886 | 26363 |
16176 | 16176 | 2020-12-21 | Texas | 48 | 1608768 | 26164 |
16121 | 16121 | 2020-12-20 | Texas | 48 | 1591885 | 25948 |
16066 | 16066 | 2020-12-19 | Texas | 48 | 1584055 | 25841 |
16011 | 16011 | 2020-12-18 | Texas | 48 | 1570679 | 25608 |
15956 | 15956 | 2020-12-17 | Texas | 48 | 1551333 | 25336 |
15901 | 15901 | 2020-12-16 | Texas | 48 | 1534822 | 25078 |
15846 | 15846 | 2020-12-15 | Texas | 48 | 1513068 | 24796 |
15791 | 15791 | 2020-12-14 | Texas | 48 | 1493407 | 24582 |
15736 | 15736 | 2020-12-13 | Texas | 48 | 1479805 | 24501 |
15681 | 15681 | 2020-12-12 | Texas | 48 | 1473080 | 24400 |
15626 | 15626 | 2020-12-11 | Texas | 48 | 1461605 | 24208 |
15571 | 15571 | 2020-12-10 | Texas | 48 | 1403359 | 23967 |
15516 | 15516 | 2020-12-09 | Texas | 48 | 1390227 | 23727 |
15461 | 15461 | 2020-12-08 | Texas | 48 | 1374960 | 23439 |
15406 | 15406 | 2020-12-07 | Texas | 48 | 1361070 | 23258 |
15351 | 15351 | 2020-12-06 | Texas | 48 | 1346249 | 23187 |
15296 | 15296 | 2020-12-05 | Texas | 48 | 1337030 | 23111 |
15241 | 15241 | 2020-12-04 | Texas | 48 | 1325855 | 22890 |
15186 | 15186 | 2020-12-03 | Texas | 48 | 1311751 | 22645 |
15131 | 15131 | 2020-12-02 | Texas | 48 | 1293839 | 22422 |
15076 | 15076 | 2020-12-01 | Texas | 48 | 1275295 | 22204 |
15021 | 15021 | 2020-11-30 | Texas | 48 | 1261943 | 21968 |
14966 | 14966 | 2020-11-29 | Texas | 48 | 1246883 | 21900 |
14911 | 14911 | 2020-11-28 | Texas | 48 | 1234740 | 21847 |
14856 | 14856 | 2020-11-27 | Texas | 48 | 1228514 | 21762 |
14801 | 14801 | 2020-11-26 | Texas | 48 | 1223893 | 21709 |
14746 | 14746 | 2020-11-25 | Texas | 48 | 1219283 | 21536 |
14691 | 14691 | 2020-11-24 | Texas | 48 | 1204366 | 21338 |
14636 | 14636 | 2020-11-23 | Texas | 48 | 1183834 | 21144 |
14581 | 14581 | 2020-11-22 | Texas | 48 | 1172761 | 21083 |
14526 | 14526 | 2020-11-21 | Texas | 48 | 1164267 | 21004 |
14471 | 14471 | 2020-11-20 | Texas | 48 | 1153363 | 20872 |
14416 | 14416 | 2020-11-19 | Texas | 48 | 1139676 | 20689 |
14361 | 14361 | 2020-11-18 | Texas | 48 | 1125898 | 20471 |
14306 | 14306 | 2020-11-17 | Texas | 48 | 1112676 | 20278 |
14251 | 14251 | 2020-11-16 | Texas | 48 | 1101781 | 20157 |
14196 | 14196 | 2020-11-15 | Texas | 48 | 1090500 | 20110 |
14141 | 14141 | 2020-11-14 | Texas | 48 | 1083132 | 20035 |
14086 | 14086 | 2020-11-13 | Texas | 48 | 1073382 | 19917 |
14031 | 14031 | 2020-11-12 | Texas | 48 | 1060798 | 19705 |
13976 | 13976 | 2020-11-11 | Texas | 48 | 1051071 | 19544 |
13921 | 13921 | 2020-11-10 | Texas | 48 | 1038214 | 19423 |
13866 | 13866 | 2020-11-09 | Texas | 48 | 1026570 | 19298 |
13811 | 13811 | 2020-11-08 | Texas | 48 | 1016772 | 19256 |
13756 | 13756 | 2020-11-07 | Texas | 48 | 1009837 | 19219 |
13701 | 13701 | 2020-11-06 | Texas | 48 | 1003908 | 19125 |
13646 | 13646 | 2020-11-05 | Texas | 48 | 993894 | 19000 |
13591 | 13591 | 2020-11-04 | Texas | 48 | 984919 | 18870 |
13536 | 13536 | 2020-11-03 | Texas | 48 | 974292 | 18722 |
13481 | 13481 | 2020-11-02 | Texas | 48 | 965780 | 18626 |
13426 | 13426 | 2020-11-01 | Texas | 48 | 957789 | 18582 |
13371 | 13371 | 2020-10-31 | Texas | 48 | 953451 | 18549 |
13316 | 13316 | 2020-10-30 | Texas | 48 | 946023 | 18477 |
13261 | 13261 | 2020-10-29 | Texas | 48 | 939355 | 18372 |
13206 | 13206 | 2020-10-28 | Texas | 48 | 932245 | 18251 |
13151 | 13151 | 2020-10-27 | Texas | 48 | 924475 | 18155 |
13096 | 13096 | 2020-10-26 | Texas | 48 | 917240 | 18077 |
13041 | 13041 | 2020-10-25 | Texas | 48 | 910592 | 18042 |
12986 | 12986 | 2020-10-24 | Texas | 48 | 906657 | 17998 |
12931 | 12931 | 2020-10-23 | Texas | 48 | 899390 | 17874 |
12876 | 12876 | 2020-10-22 | Texas | 48 | 891714 | 17760 |
12821 | 12821 | 2020-10-21 | Texas | 48 | 886421 | 17743 |
12766 | 12766 | 2020-10-20 | Texas | 48 | 879949 | 17644 |
12711 | 12711 | 2020-10-19 | Texas | 48 | 874080 | 17564 |
12656 | 12656 | 2020-10-18 | Texas | 48 | 869376 | 17541 |
12601 | 12601 | 2020-10-17 | Texas | 48 | 863993 | 17518 |
12546 | 12546 | 2020-10-16 | Texas | 48 | 859567 | 17454 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );