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-07-11 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 |
---|---|---|---|---|---|---|
7165 | 7165 | 2020-07-11 | Alabama | 1 | 51947 | 1114 |
7166 | 7166 | 2020-07-11 | Alaska | 2 | 1656 | 15 |
7167 | 7167 | 2020-07-11 | Arizona | 4 | 119991 | 2158 |
7168 | 7168 | 2020-07-11 | Arkansas | 5 | 27864 | 319 |
7169 | 7169 | 2020-07-11 | California | 6 | 320030 | 7012 |
7170 | 7170 | 2020-07-11 | Colorado | 8 | 36633 | 1725 |
7171 | 7171 | 2020-07-11 | Connecticut | 9 | 47287 | 4348 |
7172 | 7172 | 2020-07-11 | Delaware | 10 | 12743 | 517 |
7173 | 7173 | 2020-07-11 | District of Columbia | 11 | 10801 | 568 |
7174 | 7174 | 2020-07-11 | Florida | 12 | 254503 | 4196 |
7175 | 7175 | 2020-07-11 | Georgia | 13 | 106574 | 2946 |
7176 | 7176 | 2020-07-11 | Guam | 66 | 1281 | 6 |
7177 | 7177 | 2020-07-11 | Hawaii | 15 | 1181 | 19 |
7178 | 7178 | 2020-07-11 | Idaho | 16 | 10584 | 102 |
7179 | 7179 | 2020-07-11 | Illinois | 17 | 154530 | 7372 |
7180 | 7180 | 2020-07-11 | Indiana | 18 | 52358 | 2756 |
7181 | 7181 | 2020-07-11 | Iowa | 19 | 34695 | 748 |
7182 | 7182 | 2020-07-11 | Kansas | 20 | 18983 | 294 |
7183 | 7183 | 2020-07-11 | Kentucky | 21 | 19530 | 647 |
7184 | 7184 | 2020-07-11 | Louisiana | 22 | 76911 | 3403 |
7185 | 7185 | 2020-07-11 | Maine | 23 | 3520 | 112 |
7186 | 7186 | 2020-07-11 | Maryland | 24 | 73060 | 3310 |
7187 | 7187 | 2020-07-11 | Massachusetts | 25 | 111398 | 8310 |
7188 | 7188 | 2020-07-11 | Michigan | 26 | 76499 | 6316 |
7189 | 7189 | 2020-07-11 | Minnesota | 27 | 41609 | 1537 |
7190 | 7190 | 2020-07-11 | Mississippi | 28 | 35419 | 1230 |
7191 | 7191 | 2020-07-11 | Missouri | 29 | 28649 | 1112 |
7192 | 7192 | 2020-07-11 | Montana | 30 | 1677 | 29 |
7193 | 7193 | 2020-07-11 | Nebraska | 31 | 21035 | 296 |
7194 | 7194 | 2020-07-11 | Nevada | 32 | 26912 | 592 |
7195 | 7195 | 2020-07-11 | New Hampshire | 33 | 6024 | 391 |
7196 | 7196 | 2020-07-11 | New Jersey | 34 | 176906 | 15525 |
7197 | 7197 | 2020-07-11 | New Mexico | 35 | 14773 | 543 |
7198 | 7198 | 2020-07-11 | New York | 36 | 405724 | 32019 |
7199 | 7199 | 2020-07-11 | North Carolina | 37 | 83996 | 1520 |
7200 | 7200 | 2020-07-11 | North Dakota | 38 | 4247 | 91 |
7201 | 7201 | 2020-07-11 | Northern Mariana Islands | 69 | 33 | 2 |
7202 | 7202 | 2020-07-11 | Ohio | 39 | 64214 | 3036 |
7203 | 7203 | 2020-07-11 | Oklahoma | 40 | 19779 | 421 |
7204 | 7204 | 2020-07-11 | Oregon | 41 | 11851 | 235 |
7205 | 7205 | 2020-07-11 | Pennsylvania | 42 | 99252 | 6945 |
7206 | 7206 | 2020-07-11 | Puerto Rico | 72 | 9366 | 167 |
7207 | 7207 | 2020-07-11 | Rhode Island | 44 | 17312 | 976 |
7208 | 7208 | 2020-07-11 | South Carolina | 45 | 54699 | 951 |
7209 | 7209 | 2020-07-11 | South Dakota | 46 | 7454 | 109 |
7210 | 7210 | 2020-07-11 | Tennessee | 47 | 59981 | 728 |
7211 | 7211 | 2020-07-11 | Texas | 48 | 258280 | 3206 |
7212 | 7212 | 2020-07-11 | Utah | 49 | 29071 | 212 |
7213 | 7213 | 2020-07-11 | Vermont | 50 | 1283 | 56 |
7214 | 7214 | 2020-07-11 | Virgin Islands | 78 | 181 | 6 |
7215 | 7215 | 2020-07-11 | Virginia | 51 | 69782 | 1962 |
7216 | 7216 | 2020-07-11 | Washington | 53 | 41326 | 1426 |
7217 | 7217 | 2020-07-11 | West Virginia | 54 | 4146 | 96 |
7218 | 7218 | 2020-07-11 | Wisconsin | 55 | 39095 | 829 |
7219 | 7219 | 2020-07-11 | Wyoming | 56 | 1839 | 21 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );