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-07 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 ▼ |
---|---|---|---|---|---|---|
12041 | 12041 | 2020-10-07 | Northern Mariana Islands | 69 | 75 | 2 |
12054 | 12054 | 2020-10-07 | Virgin Islands | 78 | 1322 | 20 |
12059 | 12059 | 2020-10-07 | Wyoming | 56 | 6899 | 53 |
12006 | 12006 | 2020-10-07 | Alaska | 2 | 9784 | 55 |
12016 | 12016 | 2020-10-07 | Guam | 66 | 3837 | 58 |
12053 | 12053 | 2020-10-07 | Vermont | 50 | 1827 | 58 |
12025 | 12025 | 2020-10-07 | Maine | 23 | 5604 | 142 |
12017 | 12017 | 2020-10-07 | Hawaii | 15 | 13196 | 162 |
12032 | 12032 | 2020-10-07 | Montana | 30 | 16194 | 193 |
12049 | 12049 | 2020-10-07 | South Dakota | 46 | 25906 | 258 |
12040 | 12040 | 2020-10-07 | North Dakota | 38 | 24861 | 308 |
12057 | 12057 | 2020-10-07 | West Virginia | 54 | 17139 | 369 |
12035 | 12035 | 2020-10-07 | New Hampshire | 33 | 8800 | 448 |
12052 | 12052 | 2020-10-07 | Utah | 49 | 80522 | 499 |
12018 | 12018 | 2020-10-07 | Idaho | 16 | 46233 | 502 |
12033 | 12033 | 2020-10-07 | Nebraska | 31 | 49396 | 516 |
12044 | 12044 | 2020-10-07 | Oregon | 41 | 35646 | 585 |
12013 | 12013 | 2020-10-07 | District of Columbia | 11 | 15697 | 632 |
12012 | 12012 | 2020-10-07 | Delaware | 10 | 21550 | 649 |
12046 | 12046 | 2020-10-07 | Puerto Rico | 72 | 51768 | 705 |
12022 | 12022 | 2020-10-07 | Kansas | 20 | 65131 | 725 |
12037 | 12037 | 2020-10-07 | New Mexico | 35 | 31372 | 896 |
12043 | 12043 | 2020-10-07 | Oklahoma | 40 | 94352 | 1075 |
12047 | 12047 | 2020-10-07 | Rhode Island | 44 | 25776 | 1126 |
12023 | 12023 | 2020-10-07 | Kentucky | 21 | 78669 | 1261 |
12021 | 12021 | 2020-10-07 | Iowa | 19 | 95205 | 1419 |
12058 | 12058 | 2020-10-07 | Wisconsin | 55 | 146376 | 1427 |
12008 | 12008 | 2020-10-07 | Arkansas | 5 | 88880 | 1482 |
12034 | 12034 | 2020-10-07 | Nevada | 32 | 83500 | 1639 |
12010 | 12010 | 2020-10-07 | Colorado | 8 | 75410 | 2097 |
12029 | 12029 | 2020-10-07 | Minnesota | 27 | 106704 | 2154 |
12056 | 12056 | 2020-10-07 | Washington | 53 | 95500 | 2274 |
12031 | 12031 | 2020-10-07 | Missouri | 29 | 141262 | 2334 |
12005 | 12005 | 2020-10-07 | Alabama | 1 | 161418 | 2601 |
12050 | 12050 | 2020-10-07 | Tennessee | 47 | 204286 | 2615 |
12030 | 12030 | 2020-10-07 | Mississippi | 28 | 102241 | 3051 |
12055 | 12055 | 2020-10-07 | Virginia | 51 | 153691 | 3303 |
12048 | 12048 | 2020-10-07 | South Carolina | 45 | 153705 | 3502 |
12039 | 12039 | 2020-10-07 | North Carolina | 37 | 223349 | 3716 |
12020 | 12020 | 2020-10-07 | Indiana | 18 | 130569 | 3727 |
12026 | 12026 | 2020-10-07 | Maryland | 24 | 129158 | 3973 |
12011 | 12011 | 2020-10-07 | Connecticut | 9 | 59364 | 4522 |
12042 | 12042 | 2020-10-07 | Ohio | 39 | 162723 | 4970 |
12024 | 12024 | 2020-10-07 | Louisiana | 22 | 172625 | 5604 |
12007 | 12007 | 2020-10-07 | Arizona | 4 | 222558 | 5733 |
12015 | 12015 | 2020-10-07 | Georgia | 13 | 330769 | 7089 |
12028 | 12028 | 2020-10-07 | Michigan | 26 | 145131 | 7171 |
12045 | 12045 | 2020-10-07 | Pennsylvania | 42 | 171550 | 8347 |
12019 | 12019 | 2020-10-07 | Illinois | 17 | 311614 | 9138 |
12027 | 12027 | 2020-10-07 | Massachusetts | 25 | 136492 | 9557 |
12014 | 12014 | 2020-10-07 | Florida | 12 | 722699 | 14903 |
12036 | 12036 | 2020-10-07 | New Jersey | 34 | 211638 | 16152 |
12009 | 12009 | 2020-10-07 | California | 6 | 843734 | 16358 |
12051 | 12051 | 2020-10-07 | Texas | 48 | 817166 | 16747 |
12038 | 12038 | 2020-10-07 | New York | 36 | 472994 | 32850 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );