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-07-02 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 |
---|---|---|---|---|---|---|
6670 | 6670 | 2020-07-02 | Alabama | 1 | 40111 | 985 |
6671 | 6671 | 2020-07-02 | Alaska | 2 | 1224 | 12 |
6672 | 6672 | 2020-07-02 | Arizona | 4 | 87495 | 1766 |
6673 | 6673 | 2020-07-02 | Arkansas | 5 | 22075 | 279 |
6674 | 6674 | 2020-07-02 | California | 6 | 248198 | 6263 |
6675 | 6675 | 2020-07-02 | Colorado | 8 | 33335 | 1701 |
6676 | 6676 | 2020-07-02 | Connecticut | 9 | 46646 | 4326 |
6677 | 6677 | 2020-07-02 | Delaware | 10 | 11731 | 510 |
6678 | 6678 | 2020-07-02 | District of Columbia | 11 | 10390 | 554 |
6679 | 6679 | 2020-07-02 | Florida | 12 | 169098 | 3616 |
6680 | 6680 | 2020-07-02 | Georgia | 13 | 82475 | 2801 |
6681 | 6681 | 2020-07-02 | Guam | 66 | 1249 | 6 |
6682 | 6682 | 2020-07-02 | Hawaii | 15 | 929 | 18 |
6683 | 6683 | 2020-07-02 | Idaho | 16 | 6688 | 93 |
6684 | 6684 | 2020-07-02 | Illinois | 17 | 146407 | 7197 |
6685 | 6685 | 2020-07-02 | Indiana | 18 | 47553 | 2662 |
6686 | 6686 | 2020-07-02 | Iowa | 19 | 30259 | 719 |
6687 | 6687 | 2020-07-02 | Kansas | 20 | 15226 | 282 |
6688 | 6688 | 2020-07-02 | Kentucky | 21 | 16370 | 605 |
6689 | 6689 | 2020-07-02 | Louisiana | 22 | 61669 | 3255 |
6690 | 6690 | 2020-07-02 | Maine | 23 | 3328 | 105 |
6691 | 6691 | 2020-07-02 | Maryland | 24 | 69015 | 3212 |
6692 | 6692 | 2020-07-02 | Massachusetts | 25 | 109338 | 8132 |
6693 | 6693 | 2020-07-02 | Michigan | 26 | 71853 | 6216 |
6694 | 6694 | 2020-07-02 | Minnesota | 27 | 37247 | 1495 |
6695 | 6695 | 2020-07-02 | Mississippi | 28 | 28770 | 1092 |
6696 | 6696 | 2020-07-02 | Missouri | 29 | 23085 | 1056 |
6697 | 6697 | 2020-07-02 | Montana | 30 | 1083 | 22 |
6698 | 6698 | 2020-07-02 | Nebraska | 31 | 19476 | 284 |
6699 | 6699 | 2020-07-02 | Nevada | 32 | 19871 | 525 |
6700 | 6700 | 2020-07-02 | New Hampshire | 33 | 5822 | 375 |
6701 | 6701 | 2020-07-02 | New Jersey | 34 | 174212 | 15107 |
6702 | 6702 | 2020-07-02 | New Mexico | 35 | 12520 | 503 |
6703 | 6703 | 2020-07-02 | New York | 36 | 399642 | 31814 |
6704 | 6704 | 2020-07-02 | North Carolina | 37 | 68512 | 1402 |
6705 | 6705 | 2020-07-02 | North Dakota | 38 | 3666 | 89 |
6706 | 6706 | 2020-07-02 | Northern Mariana Islands | 69 | 30 | 2 |
6707 | 6707 | 2020-07-02 | Ohio | 39 | 54166 | 2903 |
6708 | 6708 | 2020-07-02 | Oklahoma | 40 | 14539 | 395 |
6709 | 6709 | 2020-07-02 | Oregon | 41 | 9344 | 212 |
6710 | 6710 | 2020-07-02 | Pennsylvania | 42 | 92703 | 6758 |
6711 | 6711 | 2020-07-02 | Puerto Rico | 72 | 7608 | 153 |
6712 | 6712 | 2020-07-02 | Rhode Island | 44 | 16941 | 959 |
6713 | 6713 | 2020-07-02 | South Carolina | 45 | 39701 | 784 |
6714 | 6714 | 2020-07-02 | South Dakota | 46 | 6893 | 97 |
6715 | 6715 | 2020-07-02 | Tennessee | 47 | 46176 | 612 |
6716 | 6716 | 2020-07-02 | Texas | 48 | 182260 | 2562 |
6717 | 6717 | 2020-07-02 | Utah | 49 | 23466 | 176 |
6718 | 6718 | 2020-07-02 | Vermont | 50 | 1227 | 56 |
6719 | 6719 | 2020-07-02 | Virgin Islands | 78 | 98 | 6 |
6720 | 6720 | 2020-07-02 | Virginia | 51 | 63735 | 1816 |
6721 | 6721 | 2020-07-02 | Washington | 53 | 35921 | 1343 |
6722 | 6722 | 2020-07-02 | West Virginia | 54 | 3053 | 93 |
6723 | 6723 | 2020-07-02 | Wisconsin | 55 | 32876 | 801 |
6724 | 6724 | 2020-07-02 | Wyoming | 56 | 1550 | 20 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );