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-10-04 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 |
---|---|---|---|---|---|---|
11840 | 11840 | 2020-10-04 | Alabama | 1 | 159169 | 2558 |
11841 | 11841 | 2020-10-04 | Alaska | 2 | 9300 | 54 |
11842 | 11842 | 2020-10-04 | Arizona | 4 | 220757 | 5706 |
11843 | 11843 | 2020-10-04 | Arkansas | 5 | 87013 | 1425 |
11844 | 11844 | 2020-10-04 | California | 6 | 834636 | 16150 |
11845 | 11845 | 2020-10-04 | Colorado | 8 | 73389 | 2077 |
11846 | 11846 | 2020-10-04 | Connecticut | 9 | 58297 | 4513 |
11847 | 11847 | 2020-10-04 | Delaware | 10 | 21243 | 645 |
11848 | 11848 | 2020-10-04 | District of Columbia | 11 | 15519 | 631 |
11849 | 11849 | 2020-10-04 | Florida | 12 | 716451 | 14670 |
11850 | 11850 | 2020-10-04 | Georgia | 13 | 306778 | 6999 |
11851 | 11851 | 2020-10-04 | Guam | 66 | 3586 | 53 |
11852 | 11852 | 2020-10-04 | Hawaii | 15 | 12957 | 155 |
11853 | 11853 | 2020-10-04 | Idaho | 16 | 43964 | 482 |
11854 | 11854 | 2020-10-04 | Illinois | 17 | 305218 | 9050 |
11855 | 11855 | 2020-10-04 | Indiana | 18 | 127501 | 3674 |
11856 | 11856 | 2020-10-04 | Iowa | 19 | 92744 | 1387 |
11857 | 11857 | 2020-10-04 | Kansas | 20 | 62479 | 698 |
11858 | 11858 | 2020-10-04 | Kentucky | 21 | 76086 | 1242 |
11859 | 11859 | 2020-10-04 | Louisiana | 22 | 169719 | 5577 |
11860 | 11860 | 2020-10-04 | Maine | 23 | 5519 | 142 |
11861 | 11861 | 2020-10-04 | Maryland | 24 | 127785 | 3958 |
11862 | 11862 | 2020-10-04 | Massachusetts | 25 | 134947 | 9510 |
11863 | 11863 | 2020-10-04 | Michigan | 26 | 141287 | 7125 |
11864 | 11864 | 2020-10-04 | Minnesota | 27 | 103879 | 2133 |
11865 | 11865 | 2020-10-04 | Mississippi | 28 | 100488 | 3013 |
11866 | 11866 | 2020-10-04 | Missouri | 29 | 135691 | 2220 |
11867 | 11867 | 2020-10-04 | Montana | 30 | 14738 | 187 |
11868 | 11868 | 2020-10-04 | Nebraska | 31 | 47807 | 504 |
11869 | 11869 | 2020-10-04 | Nevada | 32 | 82134 | 1623 |
11870 | 11870 | 2020-10-04 | New Hampshire | 33 | 8645 | 443 |
11871 | 11871 | 2020-10-04 | New Jersey | 34 | 209989 | 16136 |
11872 | 11872 | 2020-10-04 | New Mexico | 35 | 30477 | 892 |
11873 | 11873 | 2020-10-04 | New York | 36 | 469307 | 32813 |
11874 | 11874 | 2020-10-04 | North Carolina | 37 | 217641 | 3653 |
11875 | 11875 | 2020-10-04 | North Dakota | 38 | 23553 | 277 |
11876 | 11876 | 2020-10-04 | Northern Mariana Islands | 69 | 73 | 2 |
11877 | 11877 | 2020-10-04 | Ohio | 39 | 158907 | 4925 |
11878 | 11878 | 2020-10-04 | Oklahoma | 40 | 91317 | 1052 |
11879 | 11879 | 2020-10-04 | Oregon | 41 | 34771 | 573 |
11880 | 11880 | 2020-10-04 | Pennsylvania | 42 | 168161 | 8287 |
11881 | 11881 | 2020-10-04 | Puerto Rico | 72 | 50675 | 686 |
11882 | 11882 | 2020-10-04 | Rhode Island | 44 | 25076 | 1118 |
11883 | 11883 | 2020-10-04 | South Carolina | 45 | 151582 | 3453 |
11884 | 11884 | 2020-10-04 | South Dakota | 46 | 24418 | 248 |
11885 | 11885 | 2020-10-04 | Tennessee | 47 | 198262 | 2550 |
11886 | 11886 | 2020-10-04 | Texas | 48 | 802440 | 16471 |
11887 | 11887 | 2020-10-04 | Utah | 49 | 77618 | 478 |
11888 | 11888 | 2020-10-04 | Vermont | 50 | 1785 | 58 |
11889 | 11889 | 2020-10-04 | Virgin Islands | 78 | 1327 | 20 |
11890 | 11890 | 2020-10-04 | Virginia | 51 | 151870 | 3273 |
11891 | 11891 | 2020-10-04 | Washington | 53 | 93527 | 2238 |
11892 | 11892 | 2020-10-04 | West Virginia | 54 | 16628 | 358 |
11893 | 11893 | 2020-10-04 | Wisconsin | 55 | 139941 | 1388 |
11894 | 11894 | 2020-10-04 | Wyoming | 56 | 6504 | 53 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );