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-11-16 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 |
---|---|---|---|---|---|---|
54775 | 54775 | 2022-11-16 | Alabama | 1 | 1542227 | 21100 |
54776 | 54776 | 2022-11-16 | Alaska | 2 | 299411 | 1390 |
54777 | 54777 | 2022-11-16 | American Samoa | 60 | 8257 | 34 |
54778 | 54778 | 2022-11-16 | Arizona | 4 | 2311150 | 31648 |
54779 | 54779 | 2022-11-16 | Arkansas | 5 | 964601 | 12537 |
54780 | 54780 | 2022-11-16 | California | 6 | 11420767 | 99555 |
54781 | 54781 | 2022-11-16 | Colorado | 8 | 1692199 | 13526 |
54782 | 54782 | 2022-11-16 | Connecticut | 9 | 920112 | 11559 |
54783 | 54783 | 2022-11-16 | Delaware | 10 | 315329 | 3163 |
54784 | 54784 | 2022-11-16 | District of Columbia | 11 | 170482 | 1487 |
54785 | 54785 | 2022-11-16 | Florida | 12 | 7172457 | 82541 |
54786 | 54786 | 2022-11-16 | Georgia | 13 | 2847567 | 39498 |
54787 | 54787 | 2022-11-16 | Guam | 66 | 60008 | 407 |
54788 | 54788 | 2022-11-16 | Hawaii | 15 | 356312 | 1719 |
54789 | 54789 | 2022-11-16 | Idaho | 16 | 503433 | 5259 |
54790 | 54790 | 2022-11-16 | Illinois | 17 | 3852801 | 40174 |
54791 | 54791 | 2022-11-16 | Indiana | 18 | 1953497 | 25013 |
54792 | 54792 | 2022-11-16 | Iowa | 19 | 868595 | 10255 |
54793 | 54793 | 2022-11-16 | Kansas | 20 | 895738 | 9767 |
54794 | 54794 | 2022-11-16 | Kentucky | 21 | 1628396 | 17507 |
54795 | 54795 | 2022-11-16 | Louisiana | 22 | 1467573 | 18255 |
54796 | 54796 | 2022-11-16 | Maine | 23 | 299998 | 2745 |
54797 | 54797 | 2022-11-16 | Maryland | 24 | 1280157 | 15757 |
54798 | 54798 | 2022-11-16 | Massachusetts | 25 | 2099238 | 22209 |
54799 | 54799 | 2022-11-16 | Michigan | 26 | 2911883 | 39645 |
54800 | 54800 | 2022-11-16 | Minnesota | 27 | 1696286 | 13931 |
54801 | 54801 | 2022-11-16 | Mississippi | 28 | 936814 | 13047 |
54802 | 54802 | 2022-11-16 | Missouri | 29 | 1699709 | 22996 |
54803 | 54803 | 2022-11-16 | Montana | 30 | 316504 | 3599 |
54804 | 54804 | 2022-11-16 | Nebraska | 31 | 538690 | 4763 |
54805 | 54805 | 2022-11-16 | Nevada | 32 | 857473 | 11725 |
54806 | 54806 | 2022-11-16 | New Hampshire | 33 | 359661 | 2794 |
54807 | 54807 | 2022-11-16 | New Jersey | 34 | 2824396 | 35029 |
54808 | 54808 | 2022-11-16 | New Mexico | 35 | 638055 | 8708 |
54809 | 54809 | 2022-11-16 | New York | 36 | 6309897 | 76488 |
54810 | 54810 | 2022-11-16 | North Carolina | 37 | 3262335 | 28519 |
54811 | 54811 | 2022-11-16 | North Dakota | 38 | 274701 | 2434 |
54812 | 54812 | 2022-11-16 | Northern Mariana Islands | 69 | 13212 | 41 |
54813 | 54813 | 2022-11-16 | Ohio | 39 | 3208165 | 40470 |
54814 | 54814 | 2022-11-16 | Oklahoma | 40 | 1214559 | 15775 |
54815 | 54815 | 2022-11-16 | Oregon | 41 | 917164 | 8794 |
54816 | 54816 | 2022-11-16 | Pennsylvania | 42 | 3340015 | 48212 |
54817 | 54817 | 2022-11-16 | Puerto Rico | 72 | 1030064 | 5305 |
54818 | 54818 | 2022-11-16 | Rhode Island | 44 | 434653 | 3751 |
54819 | 54819 | 2022-11-16 | South Carolina | 45 | 1732287 | 19250 |
54820 | 54820 | 2022-11-16 | South Dakota | 46 | 266843 | 3106 |
54821 | 54821 | 2022-11-16 | Tennessee | 47 | 2318836 | 27952 |
54822 | 54822 | 2022-11-16 | Texas | 48 | 7953853 | 92227 |
54823 | 54823 | 2022-11-16 | Utah | 49 | 1051549 | 5076 |
54824 | 54824 | 2022-11-16 | Vermont | 50 | 146143 | 763 |
54825 | 54825 | 2022-11-16 | Virgin Islands | 78 | 23445 | 124 |
54826 | 54826 | 2022-11-16 | Virginia | 51 | 2135778 | 22388 |
54827 | 54827 | 2022-11-16 | Washington | 53 | 1848239 | 14742 |
54828 | 54828 | 2022-11-16 | West Virginia | 54 | 611813 | 7686 |
54829 | 54829 | 2022-11-16 | Wisconsin | 55 | 1913316 | 15620 |
54830 | 54830 | 2022-11-16 | Wyoming | 56 | 179838 | 1924 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );