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-01-07 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 |
---|---|---|---|---|---|---|
37247 | 37247 | 2022-01-07 | Alabama | 1 | 957848 | 16585 |
37248 | 37248 | 2022-01-07 | Alaska | 2 | 164255 | 956 |
37249 | 37249 | 2022-01-07 | American Samoa | 60 | 11 | 0 |
37250 | 37250 | 2022-01-07 | Arizona | 4 | 1445129 | 24616 |
37251 | 37251 | 2022-01-07 | Arkansas | 5 | 604843 | 9298 |
37252 | 37252 | 2022-01-07 | California | 6 | 6003256 | 77231 |
37253 | 37253 | 2022-01-07 | Colorado | 8 | 994404 | 10633 |
37254 | 37254 | 2022-01-07 | Connecticut | 9 | 573711 | 9377 |
37255 | 37255 | 2022-01-07 | Delaware | 10 | 198507 | 2330 |
37256 | 37256 | 2022-01-07 | District of Columbia | 11 | 110040 | 1227 |
37257 | 37257 | 2022-01-07 | Florida | 12 | 4563163 | 62688 |
37258 | 37258 | 2022-01-07 | Georgia | 13 | 1925143 | 30478 |
37259 | 37259 | 2022-01-07 | Guam | 66 | 21563 | 275 |
37260 | 37260 | 2022-01-07 | Hawaii | 15 | 130605 | 1098 |
37261 | 37261 | 2022-01-07 | Idaho | 16 | 327122 | 4236 |
37262 | 37262 | 2022-01-07 | Illinois | 17 | 2386672 | 31660 |
37263 | 37263 | 2022-01-07 | Indiana | 18 | 1333147 | 19614 |
37264 | 37264 | 2022-01-07 | Iowa | 19 | 596296 | 8019 |
37265 | 37265 | 2022-01-07 | Kansas | 20 | 566401 | 7124 |
37266 | 37266 | 2022-01-07 | Kentucky | 21 | 922708 | 12390 |
37267 | 37267 | 2022-01-07 | Louisiana | 22 | 908428 | 15054 |
37268 | 37268 | 2022-01-07 | Maine | 23 | 152173 | 1599 |
37269 | 37269 | 2022-01-07 | Maryland | 24 | 800982 | 12107 |
37270 | 37270 | 2022-01-07 | Massachusetts | 25 | 1279928 | 20568 |
37271 | 37271 | 2022-01-07 | Michigan | 26 | 1850791 | 29920 |
37272 | 37272 | 2022-01-07 | Minnesota | 27 | 1064205 | 10906 |
37273 | 37273 | 2022-01-07 | Mississippi | 28 | 586547 | 10527 |
37274 | 37274 | 2022-01-07 | Missouri | 29 | 1096061 | 16492 |
37275 | 37275 | 2022-01-07 | Montana | 30 | 203192 | 2918 |
37276 | 37276 | 2022-01-07 | Nebraska | 31 | 355928 | 3456 |
37277 | 37277 | 2022-01-07 | Nevada | 32 | 528892 | 8510 |
37278 | 37278 | 2022-01-07 | New Hampshire | 33 | 214572 | 2019 |
37279 | 37279 | 2022-01-07 | New Jersey | 34 | 1782463 | 29374 |
37280 | 37280 | 2022-01-07 | New Mexico | 35 | 369113 | 5985 |
37281 | 37281 | 2022-01-07 | New York | 36 | 3966952 | 59827 |
37282 | 37282 | 2022-01-07 | North Carolina | 37 | 1812597 | 19629 |
37283 | 37283 | 2022-01-07 | North Dakota | 38 | 180691 | 2073 |
37284 | 37284 | 2022-01-07 | Northern Mariana Islands | 69 | 3561 | 19 |
37285 | 37285 | 2022-01-07 | Ohio | 39 | 2151829 | 30072 |
37286 | 37286 | 2022-01-07 | Oklahoma | 40 | 737593 | 11647 |
37287 | 37287 | 2022-01-07 | Oregon | 41 | 459700 | 5761 |
37288 | 37288 | 2022-01-07 | Pennsylvania | 42 | 2206899 | 37522 |
37289 | 37289 | 2022-01-07 | Puerto Rico | 72 | 373722 | 3357 |
37290 | 37290 | 2022-01-07 | Rhode Island | 44 | 266066 | 3121 |
37291 | 37291 | 2022-01-07 | South Carolina | 45 | 1048252 | 14746 |
37292 | 37292 | 2022-01-07 | South Dakota | 46 | 189411 | 2522 |
37293 | 37293 | 2022-01-07 | Tennessee | 47 | 1461058 | 20824 |
37294 | 37294 | 2022-01-07 | Texas | 48 | 4947742 | 76676 |
37295 | 37295 | 2022-01-07 | Utah | 49 | 682182 | 3887 |
37296 | 37296 | 2022-01-07 | Vermont | 50 | 73802 | 482 |
37297 | 37297 | 2022-01-07 | Virgin Islands | 78 | 11160 | 89 |
37298 | 37298 | 2022-01-07 | Virginia | 51 | 1221036 | 15651 |
37299 | 37299 | 2022-01-07 | Washington | 53 | 935391 | 10067 |
37300 | 37300 | 2022-01-07 | West Virginia | 54 | 351688 | 5421 |
37301 | 37301 | 2022-01-07 | Wisconsin | 55 | 1186069 | 11402 |
37302 | 37302 | 2022-01-07 | Wyoming | 56 | 119857 | 1572 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );