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-05-28 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 |
---|---|---|---|---|---|---|
4745 | 4745 | 2020-05-28 | Alabama | 1 | 16530 | 591 |
4746 | 4746 | 2020-05-28 | Alaska | 2 | 430 | 8 |
4747 | 4747 | 2020-05-28 | Arizona | 4 | 17763 | 857 |
4748 | 4748 | 2020-05-28 | Arkansas | 5 | 6538 | 125 |
4749 | 4749 | 2020-05-28 | California | 6 | 104071 | 4042 |
4750 | 4750 | 2020-05-28 | Colorado | 8 | 25116 | 1422 |
4751 | 4751 | 2020-05-28 | Connecticut | 9 | 41559 | 3826 |
4752 | 4752 | 2020-05-28 | Delaware | 10 | 9171 | 345 |
4753 | 4753 | 2020-05-28 | District of Columbia | 11 | 8492 | 453 |
4754 | 4754 | 2020-05-28 | Florida | 12 | 53277 | 2363 |
4755 | 4755 | 2020-05-28 | Georgia | 13 | 43363 | 1942 |
4756 | 4756 | 2020-05-28 | Guam | 66 | 1141 | 6 |
4757 | 4757 | 2020-05-28 | Hawaii | 15 | 637 | 17 |
4758 | 4758 | 2020-05-28 | Idaho | 16 | 2770 | 82 |
4759 | 4759 | 2020-05-28 | Illinois | 17 | 116128 | 5225 |
4760 | 4760 | 2020-05-28 | Indiana | 18 | 33885 | 2068 |
4761 | 4761 | 2020-05-28 | Iowa | 19 | 18672 | 510 |
4762 | 4762 | 2020-05-28 | Kansas | 20 | 9513 | 209 |
4763 | 4763 | 2020-05-28 | Kentucky | 21 | 9510 | 424 |
4764 | 4764 | 2020-05-28 | Louisiana | 22 | 38907 | 2740 |
4765 | 4765 | 2020-05-28 | Maine | 23 | 2189 | 84 |
4766 | 4766 | 2020-05-28 | Maryland | 24 | 50334 | 2428 |
4767 | 4767 | 2020-05-28 | Massachusetts | 25 | 94895 | 6640 |
4768 | 4768 | 2020-05-28 | Michigan | 26 | 55944 | 5372 |
4769 | 4769 | 2020-05-28 | Minnesota | 27 | 22957 | 977 |
4770 | 4770 | 2020-05-28 | Mississippi | 28 | 14372 | 693 |
4771 | 4771 | 2020-05-28 | Missouri | 29 | 12815 | 715 |
4772 | 4772 | 2020-05-28 | Montana | 30 | 485 | 17 |
4773 | 4773 | 2020-05-28 | Nebraska | 31 | 13260 | 170 |
4774 | 4774 | 2020-05-28 | Nevada | 32 | 8247 | 410 |
4775 | 4775 | 2020-05-28 | New Hampshire | 33 | 4389 | 232 |
4776 | 4776 | 2020-05-28 | New Jersey | 34 | 157815 | 11401 |
4777 | 4777 | 2020-05-28 | New Mexico | 35 | 7364 | 335 |
4778 | 4778 | 2020-05-28 | New York | 36 | 371559 | 29438 |
4779 | 4779 | 2020-05-28 | North Carolina | 37 | 25616 | 859 |
4780 | 4780 | 2020-05-28 | North Dakota | 38 | 2484 | 60 |
4781 | 4781 | 2020-05-28 | Northern Mariana Islands | 69 | 22 | 2 |
4782 | 4782 | 2020-05-28 | Ohio | 39 | 33915 | 2098 |
4783 | 4783 | 2020-05-28 | Oklahoma | 40 | 6270 | 326 |
4784 | 4784 | 2020-05-28 | Oregon | 41 | 4087 | 151 |
4785 | 4785 | 2020-05-28 | Pennsylvania | 42 | 74312 | 5397 |
4786 | 4786 | 2020-05-28 | Puerto Rico | 72 | 3486 | 131 |
4787 | 4787 | 2020-05-28 | Rhode Island | 44 | 14494 | 677 |
4788 | 4788 | 2020-05-28 | South Carolina | 45 | 10788 | 470 |
4789 | 4789 | 2020-05-28 | South Dakota | 46 | 4793 | 54 |
4790 | 4790 | 2020-05-28 | Tennessee | 47 | 21763 | 352 |
4791 | 4791 | 2020-05-28 | Texas | 48 | 60820 | 1618 |
4792 | 4792 | 2020-05-28 | Utah | 49 | 8953 | 106 |
4793 | 4793 | 2020-05-28 | Vermont | 50 | 974 | 55 |
4794 | 4794 | 2020-05-28 | Virgin Islands | 78 | 69 | 6 |
4795 | 4795 | 2020-05-28 | Virginia | 51 | 41401 | 1338 |
4796 | 4796 | 2020-05-28 | Washington | 53 | 22091 | 1116 |
4797 | 4797 | 2020-05-28 | West Virginia | 54 | 1935 | 74 |
4798 | 4798 | 2020-05-28 | Wisconsin | 55 | 17476 | 550 |
4799 | 4799 | 2020-05-28 | Wyoming | 56 | 876 | 15 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );