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 2020-11-06 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
13655 | 13655 | 2020-11-06 | Alabama | 1 | 200714 | 3049 |
13656 | 13656 | 2020-11-06 | Alaska | 2 | 18589 | 79 |
13657 | 13657 | 2020-11-06 | Arizona | 4 | 254961 | 6111 |
13658 | 13658 | 2020-11-06 | Arkansas | 5 | 119230 | 2056 |
13659 | 13659 | 2020-11-06 | California | 6 | 967618 | 17939 |
13660 | 13660 | 2020-11-06 | Colorado | 8 | 125397 | 2404 |
13661 | 13661 | 2020-11-06 | Connecticut | 9 | 78125 | 4671 |
13662 | 13662 | 2020-11-06 | Delaware | 10 | 26035 | 716 |
13663 | 13663 | 2020-11-06 | District of Columbia | 11 | 17792 | 652 |
13664 | 13664 | 2020-11-06 | Florida | 12 | 832617 | 17013 |
13665 | 13665 | 2020-11-06 | Georgia | 13 | 387202 | 8389 |
13666 | 13666 | 2020-11-06 | Guam | 66 | 6046 | 89 |
13667 | 13667 | 2020-11-06 | Hawaii | 15 | 15816 | 218 |
13668 | 13668 | 2020-11-06 | Idaho | 16 | 71496 | 685 |
13669 | 13669 | 2020-11-06 | Illinois | 17 | 466884 | 10412 |
13670 | 13670 | 2020-11-06 | Indiana | 18 | 203332 | 4547 |
13671 | 13671 | 2020-11-06 | Iowa | 19 | 146267 | 1828 |
13672 | 13672 | 2020-11-06 | Kansas | 20 | 99605 | 1172 |
13673 | 13673 | 2020-11-06 | Kentucky | 21 | 119952 | 1621 |
13674 | 13674 | 2020-11-06 | Louisiana | 22 | 191715 | 6016 |
13675 | 13675 | 2020-11-06 | Maine | 23 | 7444 | 150 |
13676 | 13676 | 2020-11-06 | Maryland | 24 | 151964 | 4194 |
13677 | 13677 | 2020-11-06 | Massachusetts | 25 | 167274 | 10123 |
13678 | 13678 | 2020-11-06 | Michigan | 26 | 222423 | 7883 |
13679 | 13679 | 2020-11-06 | Minnesota | 27 | 170361 | 2645 |
13680 | 13680 | 2020-11-06 | Mississippi | 28 | 124854 | 3419 |
13681 | 13681 | 2020-11-06 | Missouri | 29 | 210054 | 3217 |
13682 | 13682 | 2020-11-06 | Montana | 30 | 38012 | 420 |
13683 | 13683 | 2020-11-06 | Nebraska | 31 | 80693 | 710 |
13684 | 13684 | 2020-11-06 | Nevada | 32 | 107258 | 1846 |
13685 | 13685 | 2020-11-06 | New Hampshire | 33 | 12012 | 488 |
13686 | 13686 | 2020-11-06 | New Jersey | 34 | 251180 | 16416 |
13687 | 13687 | 2020-11-06 | New Mexico | 35 | 52394 | 1088 |
13688 | 13688 | 2020-11-06 | New York | 36 | 526767 | 33267 |
13689 | 13689 | 2020-11-06 | North Carolina | 37 | 289124 | 4608 |
13690 | 13690 | 2020-11-06 | North Dakota | 38 | 51607 | 618 |
13691 | 13691 | 2020-11-06 | Northern Mariana Islands | 69 | 98 | 2 |
13692 | 13692 | 2020-11-06 | Ohio | 39 | 240178 | 5494 |
13693 | 13693 | 2020-11-06 | Oklahoma | 40 | 131751 | 1429 |
13694 | 13694 | 2020-11-06 | Oregon | 41 | 48608 | 716 |
13695 | 13695 | 2020-11-06 | Pennsylvania | 42 | 229346 | 9052 |
13696 | 13696 | 2020-11-06 | Puerto Rico | 72 | 70519 | 862 |
13697 | 13697 | 2020-11-06 | Rhode Island | 44 | 36380 | 1224 |
13698 | 13698 | 2020-11-06 | South Carolina | 45 | 182872 | 4005 |
13699 | 13699 | 2020-11-06 | South Dakota | 46 | 52639 | 510 |
13700 | 13700 | 2020-11-06 | Tennessee | 47 | 269292 | 3508 |
13701 | 13701 | 2020-11-06 | Texas | 48 | 1003908 | 19125 |
13702 | 13702 | 2020-11-06 | Utah | 49 | 127294 | 649 |
13703 | 13703 | 2020-11-06 | Vermont | 50 | 2326 | 58 |
13704 | 13704 | 2020-11-06 | Virgin Islands | 78 | 1390 | 23 |
13705 | 13705 | 2020-11-06 | Virginia | 51 | 188770 | 3682 |
13706 | 13706 | 2020-11-06 | Washington | 53 | 120123 | 2552 |
13707 | 13707 | 2020-11-06 | West Virginia | 54 | 27087 | 487 |
13708 | 13708 | 2020-11-06 | Wisconsin | 55 | 270074 | 2340 |
13709 | 13709 | 2020-11-06 | Wyoming | 56 | 16405 | 105 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );