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-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
40439 | 40439 | 2022-03-05 | Alabama | 1 | 1282945 | 18480 |
40440 | 40440 | 2022-03-05 | Alaska | 2 | 239242 | 1155 |
40441 | 40441 | 2022-03-05 | American Samoa | 60 | 229 | 0 |
40442 | 40442 | 2022-03-05 | Arizona | 4 | 1980769 | 27947 |
40443 | 40443 | 2022-03-05 | Arkansas | 5 | 822900 | 10699 |
40444 | 40444 | 2022-03-05 | California | 6 | 9002938 | 86394 |
40445 | 40445 | 2022-03-05 | Colorado | 8 | 1323810 | 12051 |
40446 | 40446 | 2022-03-05 | Connecticut | 9 | 724833 | 10543 |
40447 | 40447 | 2022-03-05 | Delaware | 10 | 257181 | 2751 |
40448 | 40448 | 2022-03-05 | District of Columbia | 11 | 134678 | 1321 |
40449 | 40449 | 2022-03-05 | Florida | 12 | 5816275 | 70997 |
40450 | 40450 | 2022-03-05 | Georgia | 13 | 2400173 | 34406 |
40451 | 40451 | 2022-03-05 | Guam | 66 | 46314 | 332 |
40452 | 40452 | 2022-03-05 | Hawaii | 15 | 231395 | 1350 |
40453 | 40453 | 2022-03-05 | Idaho | 16 | 432574 | 4790 |
40454 | 40454 | 2022-03-05 | Illinois | 17 | 3042622 | 37108 |
40455 | 40455 | 2022-03-05 | Indiana | 18 | 1687733 | 23002 |
40456 | 40456 | 2022-03-05 | Iowa | 19 | 755547 | 9171 |
40457 | 40457 | 2022-03-05 | Kansas | 20 | 768454 | 8007 |
40458 | 40458 | 2022-03-05 | Kentucky | 21 | 1297193 | 14075 |
40459 | 40459 | 2022-03-05 | Louisiana | 22 | 1228045 | 16754 |
40460 | 40460 | 2022-03-05 | Maine | 23 | 230720 | 2135 |
40461 | 40461 | 2022-03-05 | Maryland | 24 | 1004553 | 14176 |
40462 | 40462 | 2022-03-05 | Massachusetts | 25 | 1675767 | 23577 |
40463 | 40463 | 2022-03-05 | Michigan | 26 | 2360182 | 34802 |
40464 | 40464 | 2022-03-05 | Minnesota | 27 | 1418001 | 12373 |
40465 | 40465 | 2022-03-05 | Mississippi | 28 | 791208 | 12151 |
40466 | 40466 | 2022-03-05 | Missouri | 29 | 1416369 | 19312 |
40467 | 40467 | 2022-03-05 | Montana | 30 | 271257 | 3205 |
40468 | 40468 | 2022-03-05 | Nebraska | 31 | 476194 | 4013 |
40469 | 40469 | 2022-03-05 | Nevada | 32 | 685346 | 9799 |
40470 | 40470 | 2022-03-05 | New Hampshire | 33 | 299213 | 2402 |
40471 | 40471 | 2022-03-05 | New Jersey | 34 | 2173813 | 33012 |
40472 | 40472 | 2022-03-05 | New Mexico | 35 | 513311 | 6974 |
40473 | 40473 | 2022-03-05 | New York | 36 | 4917196 | 66907 |
40474 | 40474 | 2022-03-05 | North Carolina | 37 | 2599829 | 22773 |
40475 | 40475 | 2022-03-05 | North Dakota | 38 | 238702 | 2258 |
40476 | 40476 | 2022-03-05 | Northern Mariana Islands | 69 | 10074 | 30 |
40477 | 40477 | 2022-03-05 | Ohio | 39 | 2659138 | 37018 |
40478 | 40478 | 2022-03-05 | Oklahoma | 40 | 1024471 | 13278 |
40479 | 40479 | 2022-03-05 | Oregon | 41 | 696717 | 6709 |
40480 | 40480 | 2022-03-05 | Pennsylvania | 42 | 2763033 | 43525 |
40481 | 40481 | 2022-03-05 | Puerto Rico | 72 | 508188 | 4133 |
40482 | 40482 | 2022-03-05 | Rhode Island | 44 | 356783 | 3417 |
40483 | 40483 | 2022-03-05 | South Carolina | 45 | 1462846 | 16961 |
40484 | 40484 | 2022-03-05 | South Dakota | 46 | 236276 | 2827 |
40485 | 40485 | 2022-03-05 | Tennessee | 47 | 1963475 | 24432 |
40486 | 40486 | 2022-03-05 | Texas | 48 | 6581796 | 85793 |
40487 | 40487 | 2022-03-05 | Utah | 49 | 924436 | 4453 |
40488 | 40488 | 2022-03-05 | Vermont | 50 | 113107 | 607 |
40489 | 40489 | 2022-03-05 | Virgin Islands | 78 | 15426 | 109 |
40490 | 40490 | 2022-03-05 | Virginia | 51 | 1645791 | 18955 |
40491 | 40491 | 2022-03-05 | Washington | 53 | 1430901 | 12098 |
40492 | 40492 | 2022-03-05 | West Virginia | 54 | 492276 | 6440 |
40493 | 40493 | 2022-03-05 | Wisconsin | 55 | 1574810 | 13489 |
40494 | 40494 | 2022-03-05 | 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 );