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 · 918 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
49726 | 49726 | 2022-08-17 | Texas | 48 | 7627988 | 89995 |
49670 | 49670 | 2022-08-16 | Texas | 48 | 7619185 | 89953 |
49614 | 49614 | 2022-08-15 | Texas | 48 | 7611171 | 89908 |
49558 | 49558 | 2022-08-14 | Texas | 48 | 7589330 | 89859 |
49502 | 49502 | 2022-08-13 | Texas | 48 | 7588881 | 89859 |
49446 | 49446 | 2022-08-12 | Texas | 48 | 7588881 | 89859 |
49390 | 49390 | 2022-08-11 | Texas | 48 | 7575033 | 89819 |
49334 | 49334 | 2022-08-10 | Texas | 48 | 7563617 | 89788 |
49278 | 49278 | 2022-08-09 | Texas | 48 | 7552874 | 89753 |
49222 | 49222 | 2022-08-08 | Texas | 48 | 7544874 | 89708 |
49166 | 49166 | 2022-08-07 | Texas | 48 | 7519908 | 89643 |
49110 | 49110 | 2022-08-06 | Texas | 48 | 7519908 | 89643 |
49054 | 49054 | 2022-08-05 | Texas | 48 | 7519908 | 89643 |
48998 | 48998 | 2022-08-04 | Texas | 48 | 7507560 | 89628 |
48942 | 48942 | 2022-08-03 | Texas | 48 | 7496176 | 89592 |
48886 | 48886 | 2022-08-02 | Texas | 48 | 7485910 | 89544 |
48830 | 48830 | 2022-08-01 | Texas | 48 | 7471659 | 89517 |
48774 | 48774 | 2022-07-31 | Texas | 48 | 7443235 | 89455 |
48718 | 48718 | 2022-07-30 | Texas | 48 | 7443235 | 89455 |
48662 | 48662 | 2022-07-29 | Texas | 48 | 7443235 | 89455 |
48606 | 48606 | 2022-07-28 | Texas | 48 | 7429581 | 89399 |
48550 | 48550 | 2022-07-27 | Texas | 48 | 7415687 | 89377 |
48494 | 48494 | 2022-07-26 | Texas | 48 | 7404611 | 89346 |
48438 | 48438 | 2022-07-25 | Texas | 48 | 7394661 | 89321 |
48382 | 48382 | 2022-07-24 | Texas | 48 | 7382769 | 89309 |
48326 | 48326 | 2022-07-23 | Texas | 48 | 7372660 | 89298 |
48270 | 48270 | 2022-07-22 | Texas | 48 | 7362382 | 89268 |
48214 | 48214 | 2022-07-21 | Texas | 48 | 7347687 | 89228 |
48158 | 48158 | 2022-07-20 | Texas | 48 | 7334919 | 89209 |
48102 | 48102 | 2022-07-19 | Texas | 48 | 7321472 | 89201 |
48046 | 48046 | 2022-07-18 | Texas | 48 | 7311281 | 89174 |
47990 | 47990 | 2022-07-17 | Texas | 48 | 7299188 | 89163 |
47934 | 47934 | 2022-07-16 | Texas | 48 | 7289325 | 89155 |
47878 | 47878 | 2022-07-15 | Texas | 48 | 7277680 | 89134 |
47822 | 47822 | 2022-07-14 | Texas | 48 | 7263460 | 89110 |
47766 | 47766 | 2022-07-13 | Texas | 48 | 7249005 | 89097 |
47710 | 47710 | 2022-07-12 | Texas | 48 | 7236492 | 89073 |
47654 | 47654 | 2022-07-11 | Texas | 48 | 7224332 | 89049 |
47598 | 47598 | 2022-07-10 | Texas | 48 | 7211734 | 89045 |
47542 | 47542 | 2022-07-09 | Texas | 48 | 7200614 | 89040 |
47486 | 47486 | 2022-07-08 | Texas | 48 | 7188314 | 89026 |
47430 | 47430 | 2022-07-07 | Texas | 48 | 7176272 | 88997 |
47374 | 47374 | 2022-07-06 | Texas | 48 | 7164664 | 88975 |
47318 | 47318 | 2022-07-05 | Texas | 48 | 7155214 | 88952 |
47262 | 47262 | 2022-07-04 | Texas | 48 | 7118682 | 88923 |
47206 | 47206 | 2022-07-03 | Texas | 48 | 7118332 | 88923 |
47150 | 47150 | 2022-07-02 | Texas | 48 | 7118332 | 88923 |
47094 | 47094 | 2022-07-01 | Texas | 48 | 7118332 | 88923 |
47038 | 47038 | 2022-06-30 | Texas | 48 | 7105390 | 88901 |
46982 | 46982 | 2022-06-29 | Texas | 48 | 7092029 | 88873 |
46926 | 46926 | 2022-06-28 | Texas | 48 | 7081610 | 88848 |
46870 | 46870 | 2022-06-27 | Texas | 48 | 7071372 | 88838 |
46814 | 46814 | 2022-06-26 | Texas | 48 | 7061532 | 88827 |
46758 | 46758 | 2022-06-25 | Texas | 48 | 7052334 | 88826 |
46702 | 46702 | 2022-06-24 | Texas | 48 | 7043184 | 88808 |
46646 | 46646 | 2022-06-23 | Texas | 48 | 7031682 | 88794 |
46590 | 46590 | 2022-06-22 | Texas | 48 | 7020325 | 88775 |
46534 | 46534 | 2022-06-21 | Texas | 48 | 7012526 | 88760 |
46478 | 46478 | 2022-06-20 | Texas | 48 | 6994478 | 88742 |
46422 | 46422 | 2022-06-19 | Texas | 48 | 6991344 | 88742 |
46366 | 46366 | 2022-06-18 | Texas | 48 | 6987779 | 88730 |
46310 | 46310 | 2022-06-17 | Texas | 48 | 6982684 | 88727 |
46254 | 46254 | 2022-06-16 | Texas | 48 | 6976498 | 88713 |
46198 | 46198 | 2022-06-15 | Texas | 48 | 6968345 | 88707 |
46142 | 46142 | 2022-06-14 | Texas | 48 | 6961462 | 88690 |
46086 | 46086 | 2022-06-13 | Texas | 48 | 6954222 | 88684 |
46030 | 46030 | 2022-06-12 | Texas | 48 | 6946507 | 88678 |
45974 | 45974 | 2022-06-11 | Texas | 48 | 6941071 | 88676 |
45918 | 45918 | 2022-06-10 | Texas | 48 | 6934174 | 88668 |
45862 | 45862 | 2022-06-09 | Texas | 48 | 6927664 | 88652 |
45806 | 45806 | 2022-06-08 | Texas | 48 | 6919438 | 88626 |
45750 | 45750 | 2022-06-07 | Texas | 48 | 6912227 | 88615 |
45694 | 45694 | 2022-06-06 | Texas | 48 | 6906459 | 88602 |
45638 | 45638 | 2022-06-05 | Texas | 48 | 6900779 | 88599 |
45582 | 45582 | 2022-06-04 | Texas | 48 | 6895024 | 88596 |
45526 | 45526 | 2022-06-03 | Texas | 48 | 6887992 | 88591 |
45470 | 45470 | 2022-06-02 | Texas | 48 | 6880508 | 88580 |
45414 | 45414 | 2022-06-01 | Texas | 48 | 6873618 | 88572 |
45358 | 45358 | 2022-05-31 | Texas | 48 | 6868584 | 88569 |
45302 | 45302 | 2022-05-30 | Texas | 48 | 6849192 | 88553 |
45246 | 45246 | 2022-05-29 | Texas | 48 | 6849192 | 88553 |
45190 | 45190 | 2022-05-28 | Texas | 48 | 6849192 | 88553 |
45134 | 45134 | 2022-05-27 | Texas | 48 | 6849192 | 88553 |
45078 | 45078 | 2022-05-26 | Texas | 48 | 6843822 | 88542 |
45022 | 45022 | 2022-05-25 | Texas | 48 | 6838206 | 88537 |
44966 | 44966 | 2022-05-24 | Texas | 48 | 6833576 | 88521 |
44910 | 44910 | 2022-05-23 | Texas | 48 | 6829709 | 88519 |
44854 | 44854 | 2022-05-22 | Texas | 48 | 6825199 | 88513 |
44798 | 44798 | 2022-05-21 | Texas | 48 | 6821184 | 88510 |
44742 | 44742 | 2022-05-20 | Texas | 48 | 6816947 | 88507 |
44686 | 44686 | 2022-05-19 | Texas | 48 | 6811933 | 88496 |
44630 | 44630 | 2022-05-18 | Texas | 48 | 6807050 | 88477 |
44574 | 44574 | 2022-05-17 | Texas | 48 | 6802180 | 88462 |
44518 | 44518 | 2022-05-16 | Texas | 48 | 6799028 | 88452 |
44462 | 44462 | 2022-05-15 | Texas | 48 | 6796987 | 88450 |
44406 | 44406 | 2022-05-14 | Texas | 48 | 6794907 | 88446 |
44350 | 44350 | 2022-05-13 | Texas | 48 | 6791937 | 88439 |
44294 | 44294 | 2022-05-12 | Texas | 48 | 6786105 | 88425 |
44238 | 44238 | 2022-05-11 | Texas | 48 | 6781837 | 88414 |
44182 | 44182 | 2022-05-10 | Texas | 48 | 6778536 | 88391 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );