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-06-12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- 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 |
---|---|---|---|---|---|---|
25645 | 25645 | 2021-06-12 | Alabama | 1 | 547323 | 11266 |
25646 | 25646 | 2021-06-12 | Alaska | 2 | 70065 | 356 |
25647 | 25647 | 2021-06-12 | Arizona | 4 | 886404 | 17761 |
25648 | 25648 | 2021-06-12 | Arkansas | 5 | 343873 | 5860 |
25649 | 25649 | 2021-06-12 | California | 6 | 3801812 | 63143 |
25650 | 25650 | 2021-06-12 | Colorado | 8 | 553568 | 6832 |
25651 | 25651 | 2021-06-12 | Connecticut | 9 | 348350 | 8261 |
25652 | 25652 | 2021-06-12 | Delaware | 10 | 109322 | 1679 |
25653 | 25653 | 2021-06-12 | District of Columbia | 11 | 49158 | 1137 |
25654 | 25654 | 2021-06-12 | Florida | 12 | 2300786 | 37265 |
25655 | 25655 | 2021-06-12 | Georgia | 13 | 1104019 | 20481 |
25656 | 25656 | 2021-06-12 | Guam | 66 | 9205 | 140 |
25657 | 25657 | 2021-06-12 | Hawaii | 15 | 35693 | 503 |
25658 | 25658 | 2021-06-12 | Idaho | 16 | 193593 | 2119 |
25659 | 25659 | 2021-06-12 | Illinois | 17 | 1391382 | 25469 |
25660 | 25660 | 2021-06-12 | Indiana | 18 | 752437 | 13745 |
25661 | 25661 | 2021-06-12 | Iowa | 19 | 372525 | 6099 |
25662 | 25662 | 2021-06-12 | Kansas | 20 | 317387 | 5140 |
25663 | 25663 | 2021-06-12 | Kentucky | 21 | 463294 | 7203 |
25664 | 25664 | 2021-06-12 | Louisiana | 22 | 475354 | 10648 |
25665 | 25665 | 2021-06-12 | Maine | 23 | 68540 | 845 |
25666 | 25666 | 2021-06-12 | Maryland | 24 | 461402 | 9683 |
25667 | 25667 | 2021-06-12 | Massachusetts | 25 | 708836 | 17939 |
25668 | 25668 | 2021-06-12 | Michigan | 26 | 995217 | 20764 |
25669 | 25669 | 2021-06-12 | Minnesota | 27 | 603707 | 7596 |
25670 | 25670 | 2021-06-12 | Mississippi | 28 | 319115 | 7353 |
25671 | 25671 | 2021-06-12 | Missouri | 29 | 621385 | 9803 |
25672 | 25672 | 2021-06-12 | Montana | 30 | 112868 | 1641 |
25673 | 25673 | 2021-06-12 | Nebraska | 31 | 224144 | 2517 |
25674 | 25674 | 2021-06-12 | Nevada | 32 | 327140 | 5622 |
25675 | 25675 | 2021-06-12 | New Hampshire | 33 | 99068 | 1360 |
25676 | 25676 | 2021-06-12 | New Jersey | 34 | 1019356 | 26327 |
25677 | 25677 | 2021-06-12 | New Mexico | 35 | 204044 | 4299 |
25678 | 25678 | 2021-06-12 | New York | 36 | 2107172 | 52958 |
25679 | 25679 | 2021-06-12 | North Carolina | 37 | 1008494 | 13287 |
25680 | 25680 | 2021-06-12 | North Dakota | 38 | 110457 | 1551 |
25681 | 25681 | 2021-06-12 | Northern Mariana Islands | 69 | 183 | 2 |
25682 | 25682 | 2021-06-12 | Ohio | 39 | 1106796 | 20091 |
25683 | 25683 | 2021-06-12 | Oklahoma | 40 | 454394 | 7325 |
25684 | 25684 | 2021-06-12 | Oregon | 41 | 204898 | 2759 |
25685 | 25685 | 2021-06-12 | Pennsylvania | 42 | 1212822 | 27526 |
25686 | 25686 | 2021-06-12 | Puerto Rico | 72 | 172938 | 2530 |
25687 | 25687 | 2021-06-12 | Rhode Island | 44 | 152213 | 2722 |
25688 | 25688 | 2021-06-12 | South Carolina | 45 | 594805 | 9776 |
25689 | 25689 | 2021-06-12 | South Dakota | 46 | 124343 | 2026 |
25690 | 25690 | 2021-06-12 | Tennessee | 47 | 852165 | 12398 |
25691 | 25691 | 2021-06-12 | Texas | 48 | 2971075 | 52096 |
25692 | 25692 | 2021-06-12 | Utah | 49 | 409435 | 2323 |
25693 | 25693 | 2021-06-12 | Vermont | 50 | 24320 | 256 |
25694 | 25694 | 2021-06-12 | Virgin Islands | 78 | 3690 | 28 |
25695 | 25695 | 2021-06-12 | Virginia | 51 | 677671 | 11293 |
25696 | 25696 | 2021-06-12 | Washington | 53 | 446034 | 5857 |
25697 | 25697 | 2021-06-12 | West Virginia | 54 | 162939 | 2849 |
25698 | 25698 | 2021-06-12 | Wisconsin | 55 | 676288 | 8013 |
25699 | 25699 | 2021-06-12 | Wyoming | 56 | 61115 | 725 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );