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-05 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 |
---|---|---|---|---|---|---|
11895 | 11895 | 2020-10-05 | Alabama | 1 | 159713 | 2559 |
11896 | 11896 | 2020-10-05 | Alaska | 2 | 9511 | 54 |
11897 | 11897 | 2020-10-05 | Arizona | 4 | 221091 | 5707 |
11898 | 11898 | 2020-10-05 | Arkansas | 5 | 87430 | 1447 |
11899 | 11899 | 2020-10-05 | California | 6 | 837722 | 16179 |
11900 | 11900 | 2020-10-05 | Colorado | 8 | 74029 | 2085 |
11901 | 11901 | 2020-10-05 | Connecticut | 9 | 59120 | 4517 |
11902 | 11902 | 2020-10-05 | Delaware | 10 | 21363 | 645 |
11903 | 11903 | 2020-10-05 | District of Columbia | 11 | 15547 | 631 |
11904 | 11904 | 2020-10-05 | Florida | 12 | 717866 | 14711 |
11905 | 11905 | 2020-10-05 | Georgia | 13 | 328127 | 7028 |
11906 | 11906 | 2020-10-05 | Guam | 66 | 3722 | 56 |
11907 | 11907 | 2020-10-05 | Hawaii | 15 | 13007 | 156 |
11908 | 11908 | 2020-10-05 | Idaho | 16 | 44832 | 487 |
11909 | 11909 | 2020-10-05 | Illinois | 17 | 307428 | 9071 |
11910 | 11910 | 2020-10-05 | Indiana | 18 | 128285 | 3681 |
11911 | 11911 | 2020-10-05 | Iowa | 19 | 93261 | 1399 |
11912 | 11912 | 2020-10-05 | Kansas | 20 | 63817 | 706 |
11913 | 11913 | 2020-10-05 | Kentucky | 21 | 76787 | 1248 |
11914 | 11914 | 2020-10-05 | Louisiana | 22 | 169937 | 5586 |
11915 | 11915 | 2020-10-05 | Maine | 23 | 5545 | 142 |
11916 | 11916 | 2020-10-05 | Maryland | 24 | 128277 | 3961 |
11917 | 11917 | 2020-10-05 | Massachusetts | 25 | 135462 | 9530 |
11918 | 11918 | 2020-10-05 | Michigan | 26 | 142757 | 7141 |
11919 | 11919 | 2020-10-05 | Minnesota | 27 | 104852 | 2136 |
11920 | 11920 | 2020-10-05 | Mississippi | 28 | 100703 | 3013 |
11921 | 11921 | 2020-10-05 | Missouri | 29 | 137297 | 2229 |
11922 | 11922 | 2020-10-05 | Montana | 30 | 15127 | 190 |
11923 | 11923 | 2020-10-05 | Nebraska | 31 | 48259 | 509 |
11924 | 11924 | 2020-10-05 | Nevada | 32 | 82544 | 1624 |
11925 | 11925 | 2020-10-05 | New Hampshire | 33 | 8680 | 444 |
11926 | 11926 | 2020-10-05 | New Jersey | 34 | 210500 | 16138 |
11927 | 11927 | 2020-10-05 | New Mexico | 35 | 30632 | 894 |
11928 | 11928 | 2020-10-05 | New York | 36 | 470244 | 32827 |
11929 | 11929 | 2020-10-05 | North Carolina | 37 | 220045 | 3656 |
11930 | 11930 | 2020-10-05 | North Dakota | 38 | 23865 | 280 |
11931 | 11931 | 2020-10-05 | Northern Mariana Islands | 69 | 75 | 2 |
11932 | 11932 | 2020-10-05 | Ohio | 39 | 159964 | 4931 |
11933 | 11933 | 2020-10-05 | Oklahoma | 40 | 91982 | 1055 |
11934 | 11934 | 2020-10-05 | Oregon | 41 | 35056 | 574 |
11935 | 11935 | 2020-10-05 | Pennsylvania | 42 | 169126 | 8300 |
11936 | 11936 | 2020-10-05 | Puerto Rico | 72 | 51305 | 695 |
11937 | 11937 | 2020-10-05 | Rhode Island | 44 | 25419 | 1121 |
11938 | 11938 | 2020-10-05 | South Carolina | 45 | 152159 | 3456 |
11939 | 11939 | 2020-10-05 | South Dakota | 46 | 24598 | 248 |
11940 | 11940 | 2020-10-05 | Tennessee | 47 | 200603 | 2570 |
11941 | 11941 | 2020-10-05 | Texas | 48 | 806535 | 16519 |
11942 | 11942 | 2020-10-05 | Utah | 49 | 78733 | 483 |
11943 | 11943 | 2020-10-05 | Vermont | 50 | 1817 | 58 |
11944 | 11944 | 2020-10-05 | Virgin Islands | 78 | 1322 | 20 |
11945 | 11945 | 2020-10-05 | Virginia | 51 | 152557 | 3276 |
11946 | 11946 | 2020-10-05 | Washington | 53 | 94202 | 2253 |
11947 | 11947 | 2020-10-05 | West Virginia | 54 | 16742 | 361 |
11948 | 11948 | 2020-10-05 | Wisconsin | 55 | 141780 | 1393 |
11949 | 11949 | 2020-10-05 | Wyoming | 56 | 6629 | 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 );