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-03-06 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 |
---|---|---|---|---|---|---|
40495 | 40495 | 2022-03-06 | Alabama | 1 | 1282945 | 18480 |
40496 | 40496 | 2022-03-06 | Alaska | 2 | 239242 | 1155 |
40497 | 40497 | 2022-03-06 | American Samoa | 60 | 243 | 0 |
40498 | 40498 | 2022-03-06 | Arizona | 4 | 1980769 | 27947 |
40499 | 40499 | 2022-03-06 | Arkansas | 5 | 823210 | 10713 |
40500 | 40500 | 2022-03-06 | California | 6 | 9003101 | 86429 |
40501 | 40501 | 2022-03-06 | Colorado | 8 | 1323915 | 12051 |
40502 | 40502 | 2022-03-06 | Connecticut | 9 | 724833 | 10543 |
40503 | 40503 | 2022-03-06 | Delaware | 10 | 257270 | 2751 |
40504 | 40504 | 2022-03-06 | District of Columbia | 11 | 134678 | 1321 |
40505 | 40505 | 2022-03-06 | Florida | 12 | 5816275 | 70997 |
40506 | 40506 | 2022-03-06 | Georgia | 13 | 2400173 | 34406 |
40507 | 40507 | 2022-03-06 | Guam | 66 | 46511 | 332 |
40508 | 40508 | 2022-03-06 | Hawaii | 15 | 231572 | 1351 |
40509 | 40509 | 2022-03-06 | Idaho | 16 | 432574 | 4790 |
40510 | 40510 | 2022-03-06 | Illinois | 17 | 3042622 | 37108 |
40511 | 40511 | 2022-03-06 | Indiana | 18 | 1687733 | 23002 |
40512 | 40512 | 2022-03-06 | Iowa | 19 | 755547 | 9171 |
40513 | 40513 | 2022-03-06 | Kansas | 20 | 768454 | 8007 |
40514 | 40514 | 2022-03-06 | Kentucky | 21 | 1297318 | 14075 |
40515 | 40515 | 2022-03-06 | Louisiana | 22 | 1228045 | 16754 |
40516 | 40516 | 2022-03-06 | Maine | 23 | 230720 | 2136 |
40517 | 40517 | 2022-03-06 | Maryland | 24 | 1004802 | 14183 |
40518 | 40518 | 2022-03-06 | Massachusetts | 25 | 1675767 | 23577 |
40519 | 40519 | 2022-03-06 | Michigan | 26 | 2360182 | 34802 |
40520 | 40520 | 2022-03-06 | Minnesota | 27 | 1418001 | 12373 |
40521 | 40521 | 2022-03-06 | Mississippi | 28 | 791208 | 12151 |
40522 | 40522 | 2022-03-06 | Missouri | 29 | 1416369 | 19312 |
40523 | 40523 | 2022-03-06 | Montana | 30 | 271257 | 3205 |
40524 | 40524 | 2022-03-06 | Nebraska | 31 | 476194 | 4013 |
40525 | 40525 | 2022-03-06 | Nevada | 32 | 685346 | 9799 |
40526 | 40526 | 2022-03-06 | New Hampshire | 33 | 299213 | 2402 |
40527 | 40527 | 2022-03-06 | New Jersey | 34 | 2174464 | 33015 |
40528 | 40528 | 2022-03-06 | New Mexico | 35 | 513311 | 6974 |
40529 | 40529 | 2022-03-06 | New York | 36 | 4920181 | 66940 |
40530 | 40530 | 2022-03-06 | North Carolina | 37 | 2599829 | 22773 |
40531 | 40531 | 2022-03-06 | North Dakota | 38 | 238753 | 2258 |
40532 | 40532 | 2022-03-06 | Northern Mariana Islands | 69 | 10074 | 30 |
40533 | 40533 | 2022-03-06 | Ohio | 39 | 2659498 | 37018 |
40534 | 40534 | 2022-03-06 | Oklahoma | 40 | 1024471 | 13278 |
40535 | 40535 | 2022-03-06 | Oregon | 41 | 696717 | 6709 |
40536 | 40536 | 2022-03-06 | Pennsylvania | 42 | 2763589 | 43600 |
40537 | 40537 | 2022-03-06 | Puerto Rico | 72 | 508376 | 4134 |
40538 | 40538 | 2022-03-06 | Rhode Island | 44 | 356783 | 3417 |
40539 | 40539 | 2022-03-06 | South Carolina | 45 | 1462846 | 16961 |
40540 | 40540 | 2022-03-06 | South Dakota | 46 | 236276 | 2827 |
40541 | 40541 | 2022-03-06 | Tennessee | 47 | 1963475 | 24432 |
40542 | 40542 | 2022-03-06 | Texas | 48 | 6582314 | 85835 |
40543 | 40543 | 2022-03-06 | Utah | 49 | 924436 | 4453 |
40544 | 40544 | 2022-03-06 | Vermont | 50 | 113107 | 607 |
40545 | 40545 | 2022-03-06 | Virgin Islands | 78 | 15426 | 109 |
40546 | 40546 | 2022-03-06 | Virginia | 51 | 1645791 | 18955 |
40547 | 40547 | 2022-03-06 | Washington | 53 | 1430938 | 12098 |
40548 | 40548 | 2022-03-06 | West Virginia | 54 | 492276 | 6440 |
40549 | 40549 | 2022-03-06 | Wisconsin | 55 | 1574810 | 13489 |
40550 | 40550 | 2022-03-06 | Wyoming | 56 | 155426 | 1741 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );