ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2022-02-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Alabama 1
- Alaska 1
- American Samoa 1
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Connecticut 1
- Delaware 1
- District of Columbia 1
- Florida 1
- Georgia 1
- Guam 1
- Hawaii 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Montana 1
- Nebraska 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
40047 | 40047 | 2022-02-26 | Alabama | 1 | 1279006 | 18225 |
40048 | 40048 | 2022-02-26 | Alaska | 2 | 237255 | 1128 |
40049 | 40049 | 2022-02-26 | American Samoa | 60 | 84 | 0 |
40050 | 40050 | 2022-02-26 | Arizona | 4 | 1976890 | 27946 |
40051 | 40051 | 2022-02-26 | Arkansas | 5 | 818931 | 10465 |
40052 | 40052 | 2022-02-26 | California | 6 | 8958993 | 85142 |
40053 | 40053 | 2022-02-26 | Colorado | 8 | 1317067 | 11988 |
40054 | 40054 | 2022-02-26 | Connecticut | 9 | 722377 | 10465 |
40055 | 40055 | 2022-02-26 | Delaware | 10 | 256447 | 2709 |
40056 | 40056 | 2022-02-26 | District of Columbia | 11 | 134326 | 1317 |
40057 | 40057 | 2022-02-26 | Florida | 12 | 5803337 | 69790 |
40058 | 40058 | 2022-02-26 | Georgia | 13 | 2392516 | 33958 |
40059 | 40059 | 2022-02-26 | Guam | 66 | 45080 | 323 |
40060 | 40060 | 2022-02-26 | Hawaii | 15 | 230097 | 1327 |
40061 | 40061 | 2022-02-26 | Idaho | 16 | 423731 | 4732 |
40062 | 40062 | 2022-02-26 | Illinois | 17 | 3032190 | 36792 |
40063 | 40063 | 2022-02-26 | Indiana | 18 | 1684310 | 22800 |
40064 | 40064 | 2022-02-26 | Iowa | 19 | 748849 | 9085 |
40065 | 40065 | 2022-02-26 | Kansas | 20 | 766512 | 7961 |
40066 | 40066 | 2022-02-26 | Kentucky | 21 | 1285423 | 13832 |
40067 | 40067 | 2022-02-26 | Louisiana | 22 | 1225637 | 16606 |
40068 | 40068 | 2022-02-26 | Maine | 23 | 226120 | 2064 |
40069 | 40069 | 2022-02-26 | Maryland | 24 | 1001772 | 14105 |
40070 | 40070 | 2022-02-26 | Massachusetts | 25 | 1669594 | 23370 |
40071 | 40071 | 2022-02-26 | Michigan | 26 | 2352318 | 34439 |
40072 | 40072 | 2022-02-26 | Minnesota | 27 | 1412677 | 12261 |
40073 | 40073 | 2022-02-26 | Mississippi | 28 | 789056 | 12008 |
40074 | 40074 | 2022-02-26 | Missouri | 29 | 1411732 | 19045 |
40075 | 40075 | 2022-02-26 | Montana | 30 | 266080 | 3173 |
40076 | 40076 | 2022-02-26 | Nebraska | 31 | 453569 | 3956 |
40077 | 40077 | 2022-02-26 | Nevada | 32 | 681387 | 9664 |
40078 | 40078 | 2022-02-26 | New Hampshire | 33 | 297729 | 2373 |
40079 | 40079 | 2022-02-26 | New Jersey | 34 | 2165484 | 32888 |
40080 | 40080 | 2022-02-26 | New Mexico | 35 | 510783 | 6905 |
40081 | 40081 | 2022-02-26 | New York | 36 | 4904574 | 66681 |
40082 | 40082 | 2022-02-26 | North Carolina | 37 | 2585150 | 22510 |
40083 | 40083 | 2022-02-26 | North Dakota | 38 | 237935 | 2239 |
40084 | 40084 | 2022-02-26 | Northern Mariana Islands | 69 | 9534 | 29 |
40085 | 40085 | 2022-02-26 | Ohio | 39 | 2652634 | 36580 |
40086 | 40086 | 2022-02-26 | Oklahoma | 40 | 1019489 | 12990 |
40087 | 40087 | 2022-02-26 | Oregon | 41 | 692261 | 6582 |
40088 | 40088 | 2022-02-26 | Pennsylvania | 42 | 2755730 | 43203 |
40089 | 40089 | 2022-02-26 | Puerto Rico | 72 | 506739 | 4104 |
40090 | 40090 | 2022-02-26 | Rhode Island | 44 | 355509 | 3406 |
40091 | 40091 | 2022-02-26 | South Carolina | 45 | 1459070 | 16790 |
40092 | 40092 | 2022-02-26 | South Dakota | 46 | 235787 | 2802 |
40093 | 40093 | 2022-02-26 | Tennessee | 47 | 1955520 | 24219 |
40094 | 40094 | 2022-02-26 | Texas | 48 | 6559563 | 84876 |
40095 | 40095 | 2022-02-26 | Utah | 49 | 922139 | 4408 |
40096 | 40096 | 2022-02-26 | Vermont | 50 | 112023 | 595 |
40097 | 40097 | 2022-02-26 | Virgin Islands | 78 | 15362 | 109 |
40098 | 40098 | 2022-02-26 | Virginia | 51 | 1636510 | 18536 |
40099 | 40099 | 2022-02-26 | Washington | 53 | 1419088 | 11903 |
40100 | 40100 | 2022-02-26 | West Virginia | 54 | 488359 | 6308 |
40101 | 40101 | 2022-02-26 | Wisconsin | 55 | 1570683 | 13256 |
40102 | 40102 | 2022-02-26 | Wyoming | 56 | 154909 | 1718 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );