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 · 952 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
51630 | 51630 | 2022-09-20 | Texas | 48 | 7849650 | 90760 |
51574 | 51574 | 2022-09-19 | Texas | 48 | 7848768 | 90760 |
51518 | 51518 | 2022-09-18 | Texas | 48 | 7838132 | 90734 |
51462 | 51462 | 2022-09-17 | Texas | 48 | 7838132 | 90734 |
51406 | 51406 | 2022-09-16 | Texas | 48 | 7838132 | 90734 |
51350 | 51350 | 2022-09-15 | Texas | 48 | 7827898 | 90683 |
51294 | 51294 | 2022-09-14 | Texas | 48 | 7826318 | 90673 |
51238 | 51238 | 2022-09-13 | Texas | 48 | 7817015 | 90622 |
51182 | 51182 | 2022-09-12 | Texas | 48 | 7815931 | 90615 |
51126 | 51126 | 2022-09-11 | Texas | 48 | 7800411 | 90588 |
51070 | 51070 | 2022-09-10 | Texas | 48 | 7800411 | 90588 |
51014 | 51014 | 2022-09-09 | Texas | 48 | 7800411 | 90588 |
50958 | 50958 | 2022-09-08 | Texas | 48 | 7794086 | 90554 |
50902 | 50902 | 2022-09-07 | Texas | 48 | 7787183 | 90527 |
50846 | 50846 | 2022-09-06 | Texas | 48 | 7781839 | 90506 |
50790 | 50790 | 2022-09-05 | Texas | 48 | 7758225 | 90450 |
50734 | 50734 | 2022-09-04 | Texas | 48 | 7758066 | 90450 |
50678 | 50678 | 2022-09-03 | Texas | 48 | 7758066 | 90450 |
50622 | 50622 | 2022-09-02 | Texas | 48 | 7758066 | 90450 |
50566 | 50566 | 2022-09-01 | Texas | 48 | 7748171 | 90413 |
50510 | 50510 | 2022-08-31 | Texas | 48 | 7738083 | 90390 |
50454 | 50454 | 2022-08-30 | Texas | 48 | 7729794 | 90355 |
50398 | 50398 | 2022-08-29 | Texas | 48 | 7719024 | 90312 |
50342 | 50342 | 2022-08-28 | Texas | 48 | 7701117 | 90268 |
50286 | 50286 | 2022-08-27 | Texas | 48 | 7700317 | 90268 |
50230 | 50230 | 2022-08-26 | Texas | 48 | 7700317 | 90268 |
50174 | 50174 | 2022-08-25 | Texas | 48 | 7690700 | 90227 |
50118 | 50118 | 2022-08-24 | Texas | 48 | 7681619 | 90188 |
50062 | 50062 | 2022-08-23 | Texas | 48 | 7673700 | 90150 |
50006 | 50006 | 2022-08-22 | Texas | 48 | 7667298 | 90121 |
49950 | 49950 | 2022-08-21 | Texas | 48 | 7647335 | 90074 |
49894 | 49894 | 2022-08-20 | Texas | 48 | 7647335 | 90074 |
49838 | 49838 | 2022-08-19 | Texas | 48 | 7647335 | 90074 |
49782 | 49782 | 2022-08-18 | Texas | 48 | 7638144 | 90023 |
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );