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-12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|
7220 | 7220 | 2020-07-12 | Alabama | 1 | 53587 | 1121 |
7221 | 7221 | 2020-07-12 | Alaska | 2 | 1772 | 15 |
7222 | 7222 | 2020-07-12 | Arizona | 4 | 122479 | 2239 |
7223 | 7223 | 2020-07-12 | Arkansas | 5 | 28367 | 321 |
7224 | 7224 | 2020-07-12 | California | 6 | 327676 | 7042 |
7225 | 7225 | 2020-07-12 | Colorado | 8 | 36933 | 1726 |
7226 | 7226 | 2020-07-12 | Connecticut | 9 | 47287 | 4348 |
7227 | 7227 | 2020-07-12 | Delaware | 10 | 12804 | 517 |
7228 | 7228 | 2020-07-12 | District of Columbia | 11 | 10847 | 568 |
7229 | 7229 | 2020-07-12 | Florida | 12 | 269803 | 4241 |
7230 | 7230 | 2020-07-12 | Georgia | 13 | 108389 | 2951 |
7231 | 7231 | 2020-07-12 | Guam | 66 | 1281 | 6 |
7232 | 7232 | 2020-07-12 | Hawaii | 15 | 1201 | 19 |
7233 | 7233 | 2020-07-12 | Idaho | 16 | 10971 | 102 |
7234 | 7234 | 2020-07-12 | Illinois | 17 | 155355 | 7391 |
7235 | 7235 | 2020-07-12 | Indiana | 18 | 52892 | 2760 |
7236 | 7236 | 2020-07-12 | Iowa | 19 | 35410 | 752 |
7237 | 7237 | 2020-07-12 | Kansas | 20 | 19295 | 300 |
7238 | 7238 | 2020-07-12 | Kentucky | 21 | 19762 | 649 |
7239 | 7239 | 2020-07-12 | Louisiana | 22 | 78230 | 3416 |
7240 | 7240 | 2020-07-12 | Maine | 23 | 3539 | 114 |
7241 | 7241 | 2020-07-12 | Maryland | 24 | 73705 | 3319 |
7242 | 7242 | 2020-07-12 | Massachusetts | 25 | 111597 | 8325 |
7243 | 7243 | 2020-07-12 | Michigan | 26 | 76936 | 6317 |
7244 | 7244 | 2020-07-12 | Minnesota | 27 | 42319 | 1540 |
7245 | 7245 | 2020-07-12 | Mississippi | 28 | 36287 | 1249 |
7246 | 7246 | 2020-07-12 | Missouri | 29 | 29173 | 1113 |
7247 | 7247 | 2020-07-12 | Montana | 30 | 1758 | 29 |
7248 | 7248 | 2020-07-12 | Nebraska | 31 | 21214 | 296 |
7249 | 7249 | 2020-07-12 | Nevada | 32 | 27745 | 593 |
7250 | 7250 | 2020-07-12 | New Hampshire | 33 | 6054 | 391 |
7251 | 7251 | 2020-07-12 | New Jersey | 34 | 177245 | 15525 |
7252 | 7252 | 2020-07-12 | New Mexico | 35 | 15028 | 545 |
7253 | 7253 | 2020-07-12 | New York | 36 | 406403 | 32029 |
7254 | 7254 | 2020-07-12 | North Carolina | 37 | 85831 | 1532 |
7255 | 7255 | 2020-07-12 | North Dakota | 38 | 4338 | 91 |
7256 | 7256 | 2020-07-12 | Northern Mariana Islands | 69 | 33 | 2 |
7257 | 7257 | 2020-07-12 | Ohio | 39 | 65592 | 3058 |
7258 | 7258 | 2020-07-12 | Oklahoma | 40 | 20235 | 422 |
7259 | 7259 | 2020-07-12 | Oregon | 41 | 12170 | 237 |
7260 | 7260 | 2020-07-12 | Pennsylvania | 42 | 99794 | 6950 |
7261 | 7261 | 2020-07-12 | Puerto Rico | 72 | 9654 | 167 |
7262 | 7262 | 2020-07-12 | Rhode Island | 44 | 17312 | 976 |
7263 | 7263 | 2020-07-12 | South Carolina | 45 | 56648 | 961 |
7264 | 7264 | 2020-07-12 | South Dakota | 46 | 7499 | 109 |
7265 | 7265 | 2020-07-12 | Tennessee | 47 | 61106 | 731 |
7266 | 7266 | 2020-07-12 | Texas | 48 | 264811 | 3246 |
7267 | 7267 | 2020-07-12 | Utah | 49 | 29552 | 215 |
7268 | 7268 | 2020-07-12 | Vermont | 50 | 1296 | 56 |
7269 | 7269 | 2020-07-12 | Virgin Islands | 78 | 206 | 6 |
7270 | 7270 | 2020-07-12 | Virginia | 51 | 70670 | 1966 |
7271 | 7271 | 2020-07-12 | Washington | 53 | 42181 | 1438 |
7272 | 7272 | 2020-07-12 | West Virginia | 54 | 4244 | 96 |
7273 | 7273 | 2020-07-12 | Wisconsin | 55 | 39901 | 828 |
7274 | 7274 | 2020-07-12 | Wyoming | 56 | 1862 | 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 );