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 2021-02-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 |
---|---|---|---|---|---|---|
19925 | 19925 | 2021-02-28 | Alabama | 1 | 493252 | 9929 |
19926 | 19926 | 2021-02-28 | Alaska | 2 | 57846 | 279 |
19927 | 19927 | 2021-02-28 | Arizona | 4 | 817232 | 15980 |
19928 | 19928 | 2021-02-28 | Arkansas | 5 | 322415 | 5243 |
19929 | 19929 | 2021-02-28 | California | 6 | 3569578 | 52213 |
19930 | 19930 | 2021-02-28 | Colorado | 8 | 430970 | 6045 |
19931 | 19931 | 2021-02-28 | Connecticut | 9 | 279946 | 7622 |
19932 | 19932 | 2021-02-28 | Delaware | 10 | 86799 | 1422 |
19933 | 19933 | 2021-02-28 | District of Columbia | 11 | 40598 | 1017 |
19934 | 19934 | 2021-02-28 | Florida | 12 | 1909213 | 30851 |
19935 | 19935 | 2021-02-28 | Georgia | 13 | 981844 | 16757 |
19936 | 19936 | 2021-02-28 | Guam | 66 | 8705 | 132 |
19937 | 19937 | 2021-02-28 | Hawaii | 15 | 27473 | 436 |
19938 | 19938 | 2021-02-28 | Idaho | 16 | 171209 | 1862 |
19939 | 19939 | 2021-02-28 | Illinois | 17 | 1189922 | 22735 |
19940 | 19940 | 2021-02-28 | Indiana | 18 | 664880 | 12573 |
19941 | 19941 | 2021-02-28 | Iowa | 19 | 336455 | 5470 |
19942 | 19942 | 2021-02-28 | Kansas | 20 | 296798 | 4735 |
19943 | 19943 | 2021-02-28 | Kentucky | 21 | 408392 | 4786 |
19944 | 19944 | 2021-02-28 | Louisiana | 22 | 430100 | 9608 |
19945 | 19945 | 2021-02-28 | Maine | 23 | 44634 | 703 |
19946 | 19946 | 2021-02-28 | Maryland | 24 | 382281 | 7869 |
19947 | 19947 | 2021-02-28 | Massachusetts | 25 | 581148 | 16118 |
19948 | 19948 | 2021-02-28 | Michigan | 26 | 644564 | 16498 |
19949 | 19949 | 2021-02-28 | Minnesota | 27 | 484662 | 6551 |
19950 | 19950 | 2021-02-28 | Mississippi | 28 | 294795 | 6681 |
19951 | 19951 | 2021-02-28 | Missouri | 29 | 524600 | 8382 |
19952 | 19952 | 2021-02-28 | Montana | 30 | 99999 | 1358 |
19953 | 19953 | 2021-02-28 | Nebraska | 31 | 201298 | 2199 |
19954 | 19954 | 2021-02-28 | Nevada | 32 | 293815 | 4957 |
19955 | 19955 | 2021-02-28 | New Hampshire | 33 | 75424 | 1170 |
19956 | 19956 | 2021-02-28 | New Jersey | 34 | 789354 | 23252 |
19957 | 19957 | 2021-02-28 | New Mexico | 35 | 185132 | 3716 |
19958 | 19958 | 2021-02-28 | New York | 36 | 1644124 | 47143 |
19959 | 19959 | 2021-02-28 | North Carolina | 37 | 859527 | 11241 |
19960 | 19960 | 2021-02-28 | North Dakota | 38 | 99839 | 1475 |
19961 | 19961 | 2021-02-28 | Northern Mariana Islands | 69 | 143 | 2 |
19962 | 19962 | 2021-02-28 | Ohio | 39 | 967422 | 17299 |
19963 | 19963 | 2021-02-28 | Oklahoma | 40 | 424508 | 4428 |
19964 | 19964 | 2021-02-28 | Oregon | 41 | 155597 | 2218 |
19965 | 19965 | 2021-02-28 | Pennsylvania | 42 | 935911 | 24056 |
19966 | 19966 | 2021-02-28 | Puerto Rico | 72 | 133912 | 2036 |
19967 | 19967 | 2021-02-28 | Rhode Island | 44 | 125622 | 2502 |
19968 | 19968 | 2021-02-28 | South Carolina | 45 | 516823 | 8546 |
19969 | 19969 | 2021-02-28 | South Dakota | 46 | 112427 | 1888 |
19970 | 19970 | 2021-02-28 | Tennessee | 47 | 761232 | 11317 |
19971 | 19971 | 2021-02-28 | Texas | 48 | 2650283 | 43949 |
19972 | 19972 | 2021-02-28 | Utah | 49 | 371291 | 1935 |
19973 | 19973 | 2021-02-28 | Vermont | 50 | 15198 | 204 |
19974 | 19974 | 2021-02-28 | Virgin Islands | 78 | 2646 | 25 |
19975 | 19975 | 2021-02-28 | Virginia | 51 | 576050 | 8552 |
19976 | 19976 | 2021-02-28 | Washington | 53 | 342644 | 5024 |
19977 | 19977 | 2021-02-28 | West Virginia | 54 | 131855 | 2300 |
19978 | 19978 | 2021-02-28 | Wisconsin | 55 | 617380 | 7019 |
19979 | 19979 | 2021-02-28 | Wyoming | 56 | 54394 | 671 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );