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-08-09 sorted by deaths
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 ▼ |
---|---|---|---|---|---|---|
8796 | 8796 | 2020-08-09 | Northern Mariana Islands | 69 | 48 | 2 |
8771 | 8771 | 2020-08-09 | Guam | 66 | 1381 | 6 |
8809 | 8809 | 2020-08-09 | Virgin Islands | 78 | 547 | 9 |
8761 | 8761 | 2020-08-09 | Alaska | 2 | 4471 | 24 |
8814 | 8814 | 2020-08-09 | Wyoming | 56 | 3050 | 28 |
8772 | 8772 | 2020-08-09 | Hawaii | 15 | 3475 | 30 |
8808 | 8808 | 2020-08-09 | Vermont | 50 | 1459 | 58 |
8787 | 8787 | 2020-08-09 | Montana | 30 | 4952 | 75 |
8795 | 8795 | 2020-08-09 | North Dakota | 38 | 7600 | 116 |
8780 | 8780 | 2020-08-09 | Maine | 23 | 4042 | 125 |
8812 | 8812 | 2020-08-09 | West Virginia | 54 | 7694 | 139 |
8804 | 8804 | 2020-08-09 | South Dakota | 46 | 9605 | 146 |
8773 | 8773 | 2020-08-09 | Idaho | 16 | 24797 | 237 |
8801 | 8801 | 2020-08-09 | Puerto Rico | 72 | 22121 | 279 |
8807 | 8807 | 2020-08-09 | Utah | 49 | 44130 | 337 |
8788 | 8788 | 2020-08-09 | Nebraska | 31 | 28432 | 353 |
8799 | 8799 | 2020-08-09 | Oregon | 41 | 21272 | 359 |
8777 | 8777 | 2020-08-09 | Kansas | 20 | 31145 | 380 |
8790 | 8790 | 2020-08-09 | New Hampshire | 33 | 6831 | 419 |
8763 | 8763 | 2020-08-09 | Arkansas | 5 | 49383 | 544 |
8767 | 8767 | 2020-08-09 | Delaware | 10 | 15575 | 591 |
8768 | 8768 | 2020-08-09 | District of Columbia | 11 | 12753 | 591 |
8798 | 8798 | 2020-08-09 | Oklahoma | 40 | 43561 | 603 |
8792 | 8792 | 2020-08-09 | New Mexico | 35 | 22315 | 685 |
8778 | 8778 | 2020-08-09 | Kentucky | 21 | 36316 | 790 |
8776 | 8776 | 2020-08-09 | Iowa | 19 | 48919 | 931 |
8789 | 8789 | 2020-08-09 | Nevada | 32 | 56278 | 959 |
8813 | 8813 | 2020-08-09 | Wisconsin | 55 | 64835 | 1009 |
8802 | 8802 | 2020-08-09 | Rhode Island | 44 | 19738 | 1014 |
8805 | 8805 | 2020-08-09 | Tennessee | 47 | 119788 | 1209 |
8786 | 8786 | 2020-08-09 | Missouri | 29 | 59895 | 1386 |
8784 | 8784 | 2020-08-09 | Minnesota | 27 | 60939 | 1698 |
8760 | 8760 | 2020-08-09 | Alabama | 1 | 101334 | 1768 |
8811 | 8811 | 2020-08-09 | Washington | 53 | 65248 | 1773 |
8765 | 8765 | 2020-08-09 | Colorado | 8 | 50799 | 1863 |
8785 | 8785 | 2020-08-09 | Mississippi | 28 | 67173 | 1896 |
8803 | 8803 | 2020-08-09 | South Carolina | 45 | 100435 | 2031 |
8794 | 8794 | 2020-08-09 | North Carolina | 37 | 136250 | 2195 |
8810 | 8810 | 2020-08-09 | Virginia | 51 | 100086 | 2326 |
8775 | 8775 | 2020-08-09 | Indiana | 18 | 76071 | 3041 |
8781 | 8781 | 2020-08-09 | Maryland | 24 | 96065 | 3585 |
8797 | 8797 | 2020-08-09 | Ohio | 39 | 100848 | 3669 |
8770 | 8770 | 2020-08-09 | Georgia | 13 | 200147 | 4108 |
8762 | 8762 | 2020-08-09 | Arizona | 4 | 187086 | 4152 |
8779 | 8779 | 2020-08-09 | Louisiana | 22 | 131517 | 4263 |
8766 | 8766 | 2020-08-09 | Connecticut | 9 | 50320 | 4441 |
8783 | 8783 | 2020-08-09 | Michigan | 26 | 96835 | 6520 |
8800 | 8800 | 2020-08-09 | Pennsylvania | 42 | 123312 | 7374 |
8774 | 8774 | 2020-08-09 | Illinois | 17 | 195897 | 7852 |
8769 | 8769 | 2020-08-09 | Florida | 12 | 532798 | 8185 |
8782 | 8782 | 2020-08-09 | Massachusetts | 25 | 121040 | 8735 |
8806 | 8806 | 2020-08-09 | Texas | 48 | 510392 | 8984 |
8764 | 8764 | 2020-08-09 | California | 6 | 563244 | 10365 |
8791 | 8791 | 2020-08-09 | New Jersey | 34 | 186626 | 15874 |
8793 | 8793 | 2020-08-09 | New York | 36 | 425568 | 32354 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );