ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-04-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Alabama 1
- Alaska 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
- Nevada 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
23060 | 23060 | 2021-04-26 | Alabama | 1 | 526348 | 10852 |
23061 | 23061 | 2021-04-26 | Alaska | 2 | 66967 | 330 |
23062 | 23062 | 2021-04-26 | Arizona | 4 | 859487 | 17268 |
23063 | 23063 | 2021-04-26 | Arkansas | 5 | 334769 | 5720 |
23064 | 23064 | 2021-04-26 | California | 6 | 3734630 | 61485 |
23065 | 23065 | 2021-04-26 | Colorado | 8 | 505526 | 6390 |
23066 | 23066 | 2021-04-26 | Connecticut | 9 | 336933 | 8066 |
23067 | 23067 | 2021-04-26 | Delaware | 10 | 103459 | 1617 |
23068 | 23068 | 2021-04-26 | District of Columbia | 11 | 47378 | 1099 |
23069 | 23069 | 2021-04-26 | Florida | 12 | 2212089 | 34911 |
23070 | 23070 | 2021-04-26 | Georgia | 13 | 1070237 | 19391 |
23071 | 23071 | 2021-04-26 | Guam | 66 | 8892 | 137 |
23072 | 23072 | 2021-04-26 | Hawaii | 15 | 32349 | 475 |
23073 | 23073 | 2021-04-26 | Idaho | 16 | 186875 | 2036 |
23074 | 23074 | 2021-04-26 | Illinois | 17 | 1326850 | 24150 |
23075 | 23075 | 2021-04-26 | Indiana | 18 | 718771 | 13280 |
23076 | 23076 | 2021-04-26 | Iowa | 19 | 363158 | 5927 |
23077 | 23077 | 2021-04-26 | Kansas | 20 | 310013 | 5010 |
23078 | 23078 | 2021-04-26 | Kentucky | 21 | 444547 | 6575 |
23079 | 23079 | 2021-04-26 | Louisiana | 22 | 456432 | 10342 |
23080 | 23080 | 2021-04-26 | Maine | 23 | 60005 | 772 |
23081 | 23081 | 2021-04-26 | Maryland | 24 | 444001 | 8670 |
23082 | 23082 | 2021-04-26 | Massachusetts | 25 | 683665 | 17562 |
23083 | 23083 | 2021-04-26 | Michigan | 26 | 917016 | 18439 |
23084 | 23084 | 2021-04-26 | Minnesota | 27 | 569518 | 7157 |
23085 | 23085 | 2021-04-26 | Mississippi | 28 | 310987 | 7178 |
23086 | 23086 | 2021-04-26 | Missouri | 29 | 597967 | 9182 |
23087 | 23087 | 2021-04-26 | Montana | 30 | 108227 | 1563 |
23088 | 23088 | 2021-04-26 | Nebraska | 31 | 218832 | 2361 |
23089 | 23089 | 2021-04-26 | Nevada | 32 | 313680 | 5433 |
23090 | 23090 | 2021-04-26 | New Hampshire | 33 | 93935 | 1286 |
23091 | 23091 | 2021-04-26 | New Jersey | 34 | 988886 | 25399 |
23092 | 23092 | 2021-04-26 | New Mexico | 35 | 196844 | 4029 |
23093 | 23093 | 2021-04-26 | New York | 36 | 2032325 | 51511 |
23094 | 23094 | 2021-04-26 | North Carolina | 37 | 962978 | 12587 |
23095 | 23095 | 2021-04-26 | North Dakota | 38 | 106840 | 1517 |
23096 | 23096 | 2021-04-26 | Northern Mariana Islands | 69 | 164 | 2 |
23097 | 23097 | 2021-04-26 | Ohio | 39 | 1065702 | 19122 |
23098 | 23098 | 2021-04-26 | Oklahoma | 40 | 447278 | 6716 |
23099 | 23099 | 2021-04-26 | Oregon | 41 | 181413 | 2501 |
23100 | 23100 | 2021-04-26 | Pennsylvania | 42 | 1141219 | 26042 |
23101 | 23101 | 2021-04-26 | Puerto Rico | 72 | 162818 | 2265 |
23102 | 23102 | 2021-04-26 | Rhode Island | 44 | 146960 | 2663 |
23103 | 23103 | 2021-04-26 | South Carolina | 45 | 575515 | 9433 |
23104 | 23104 | 2021-04-26 | South Dakota | 46 | 122080 | 1960 |
23105 | 23105 | 2021-04-26 | Tennessee | 47 | 828528 | 12055 |
23106 | 23106 | 2021-04-26 | Texas | 48 | 2874150 | 50136 |
23107 | 23107 | 2021-04-26 | Utah | 49 | 395741 | 2183 |
23108 | 23108 | 2021-04-26 | Vermont | 50 | 22617 | 244 |
23109 | 23109 | 2021-04-26 | Virgin Islands | 78 | 3090 | 27 |
23110 | 23110 | 2021-04-26 | Virginia | 51 | 654929 | 10706 |
23111 | 23111 | 2021-04-26 | Washington | 53 | 399327 | 5498 |
23112 | 23112 | 2021-04-26 | West Virginia | 54 | 151671 | 2821 |
23113 | 23113 | 2021-04-26 | Wisconsin | 55 | 657144 | 7473 |
23114 | 23114 | 2021-04-26 | Wyoming | 56 | 57818 | 705 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );