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-11-12 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 |
---|---|---|---|---|---|---|
13985 | 13985 | 2020-11-12 | Alabama | 1 | 210637 | 3213 |
13986 | 13986 | 2020-11-12 | Alaska | 2 | 21689 | 90 |
13987 | 13987 | 2020-11-12 | Arizona | 4 | 266644 | 6240 |
13988 | 13988 | 2020-11-12 | Arkansas | 5 | 128006 | 2144 |
13989 | 13989 | 2020-11-12 | California | 6 | 1009216 | 18141 |
13990 | 13990 | 2020-11-12 | Colorado | 8 | 149262 | 2512 |
13991 | 13991 | 2020-11-12 | Connecticut | 9 | 85899 | 4726 |
13992 | 13992 | 2020-11-12 | Delaware | 10 | 27546 | 732 |
13993 | 13993 | 2020-11-12 | District of Columbia | 11 | 18507 | 657 |
13994 | 13994 | 2020-11-12 | Florida | 12 | 863611 | 17371 |
13995 | 13995 | 2020-11-12 | Georgia | 13 | 401750 | 8655 |
13996 | 13996 | 2020-11-12 | Guam | 66 | 6819 | 92 |
13997 | 13997 | 2020-11-12 | Hawaii | 15 | 16403 | 221 |
13998 | 13998 | 2020-11-12 | Idaho | 16 | 78877 | 753 |
13999 | 13999 | 2020-11-12 | Illinois | 17 | 537860 | 10855 |
14000 | 14000 | 2020-11-12 | Indiana | 18 | 233540 | 4813 |
14001 | 14001 | 2020-11-12 | Iowa | 19 | 173401 | 1947 |
14002 | 14002 | 2020-11-12 | Kansas | 20 | 111503 | 1215 |
14003 | 14003 | 2020-11-12 | Kentucky | 21 | 132686 | 1702 |
14004 | 14004 | 2020-11-12 | Louisiana | 22 | 198531 | 6097 |
14005 | 14005 | 2020-11-12 | Maine | 23 | 8395 | 159 |
14006 | 14006 | 2020-11-12 | Maryland | 24 | 160311 | 4261 |
14007 | 14007 | 2020-11-12 | Massachusetts | 25 | 180189 | 10242 |
14008 | 14008 | 2020-11-12 | Michigan | 26 | 258973 | 8187 |
14009 | 14009 | 2020-11-12 | Minnesota | 27 | 201851 | 2849 |
14010 | 14010 | 2020-11-12 | Mississippi | 28 | 130665 | 3514 |
14011 | 14011 | 2020-11-12 | Missouri | 29 | 235341 | 3441 |
14012 | 14012 | 2020-11-12 | Montana | 30 | 43084 | 478 |
14013 | 14013 | 2020-11-12 | Nebraska | 31 | 92737 | 772 |
14014 | 14014 | 2020-11-12 | Nevada | 32 | 115360 | 1880 |
14015 | 14015 | 2020-11-12 | New Hampshire | 33 | 13470 | 495 |
14016 | 14016 | 2020-11-12 | New Jersey | 34 | 268787 | 16495 |
14017 | 14017 | 2020-11-12 | New Mexico | 35 | 60776 | 1176 |
14018 | 14018 | 2020-11-12 | New York | 36 | 550516 | 33424 |
14019 | 14019 | 2020-11-12 | North Carolina | 37 | 303931 | 4730 |
14020 | 14020 | 2020-11-12 | North Dakota | 38 | 59179 | 703 |
14021 | 14021 | 2020-11-12 | Northern Mariana Islands | 69 | 100 | 2 |
14022 | 14022 | 2020-11-12 | Ohio | 39 | 274457 | 5658 |
14023 | 14023 | 2020-11-12 | Oklahoma | 40 | 144691 | 1481 |
14024 | 14024 | 2020-11-12 | Oregon | 41 | 53879 | 748 |
14025 | 14025 | 2020-11-12 | Pennsylvania | 42 | 254167 | 9272 |
14026 | 14026 | 2020-11-12 | Puerto Rico | 72 | 74067 | 909 |
14027 | 14027 | 2020-11-12 | Rhode Island | 44 | 40764 | 1250 |
14028 | 14028 | 2020-11-12 | South Carolina | 45 | 190490 | 4084 |
14029 | 14029 | 2020-11-12 | South Dakota | 46 | 60716 | 567 |
14030 | 14030 | 2020-11-12 | Tennessee | 47 | 291482 | 3751 |
14031 | 14031 | 2020-11-12 | Texas | 48 | 1060798 | 19705 |
14032 | 14032 | 2020-11-12 | Utah | 49 | 143639 | 689 |
14033 | 14033 | 2020-11-12 | Vermont | 50 | 2651 | 59 |
14034 | 14034 | 2020-11-12 | Virgin Islands | 78 | 1413 | 23 |
14035 | 14035 | 2020-11-12 | Virginia | 51 | 198027 | 3758 |
14036 | 14036 | 2020-11-12 | Washington | 53 | 129672 | 2619 |
14037 | 14037 | 2020-11-12 | West Virginia | 54 | 30897 | 555 |
14038 | 14038 | 2020-11-12 | Wisconsin | 55 | 309605 | 2626 |
14039 | 14039 | 2020-11-12 | Wyoming | 56 | 20479 | 127 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );