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-06-25 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 |
---|---|---|---|---|---|---|
6285 | 6285 | 2020-06-25 | Alabama | 1 | 33206 | 896 |
6286 | 6286 | 2020-06-25 | Alaska | 2 | 971 | 10 |
6287 | 6287 | 2020-06-25 | Arizona | 4 | 63297 | 1495 |
6288 | 6288 | 2020-06-25 | Arkansas | 5 | 18062 | 240 |
6289 | 6289 | 2020-06-25 | California | 6 | 201413 | 5810 |
6290 | 6290 | 2020-06-25 | Colorado | 8 | 31463 | 1669 |
6291 | 6291 | 2020-06-25 | Connecticut | 9 | 45994 | 4298 |
6292 | 6292 | 2020-06-25 | Delaware | 10 | 10980 | 507 |
6293 | 6293 | 2020-06-25 | District of Columbia | 11 | 10159 | 543 |
6294 | 6294 | 2020-06-25 | Florida | 12 | 114010 | 3326 |
6295 | 6295 | 2020-06-25 | Georgia | 13 | 67796 | 2704 |
6296 | 6296 | 2020-06-25 | Guam | 66 | 1214 | 6 |
6297 | 6297 | 2020-06-25 | Hawaii | 15 | 836 | 17 |
6298 | 6298 | 2020-06-25 | Idaho | 16 | 4869 | 91 |
6299 | 6299 | 2020-06-25 | Illinois | 17 | 140935 | 7024 |
6300 | 6300 | 2020-06-25 | Indiana | 18 | 44779 | 2586 |
6301 | 6301 | 2020-06-25 | Iowa | 19 | 27384 | 702 |
6302 | 6302 | 2020-06-25 | Kansas | 20 | 13207 | 263 |
6303 | 6303 | 2020-06-25 | Kentucky | 21 | 14793 | 569 |
6304 | 6304 | 2020-06-25 | Louisiana | 22 | 53528 | 3164 |
6305 | 6305 | 2020-06-25 | Maine | 23 | 3070 | 103 |
6306 | 6306 | 2020-06-25 | Maryland | 24 | 66397 | 3129 |
6307 | 6307 | 2020-06-25 | Massachusetts | 25 | 107837 | 7962 |
6308 | 6308 | 2020-06-25 | Michigan | 26 | 69159 | 6137 |
6309 | 6309 | 2020-06-25 | Minnesota | 27 | 34158 | 1441 |
6310 | 6310 | 2020-06-25 | Mississippi | 28 | 24516 | 1016 |
6311 | 6311 | 2020-06-25 | Missouri | 29 | 20076 | 1006 |
6312 | 6312 | 2020-06-25 | Montana | 30 | 803 | 21 |
6313 | 6313 | 2020-06-25 | Nebraska | 31 | 18346 | 266 |
6314 | 6314 | 2020-06-25 | Nevada | 32 | 14911 | 495 |
6315 | 6315 | 2020-06-25 | New Hampshire | 33 | 5638 | 357 |
6316 | 6316 | 2020-06-25 | New Jersey | 34 | 172050 | 14872 |
6317 | 6317 | 2020-06-25 | New Mexico | 35 | 11192 | 485 |
6318 | 6318 | 2020-06-25 | New York | 36 | 395168 | 31029 |
6319 | 6319 | 2020-06-25 | North Carolina | 37 | 57540 | 1305 |
6320 | 6320 | 2020-06-25 | North Dakota | 38 | 3402 | 87 |
6321 | 6321 | 2020-06-25 | Northern Mariana Islands | 69 | 30 | 2 |
6322 | 6322 | 2020-06-25 | Ohio | 39 | 47651 | 2772 |
6323 | 6323 | 2020-06-25 | Oklahoma | 40 | 11947 | 375 |
6324 | 6324 | 2020-06-25 | Oregon | 41 | 7605 | 199 |
6325 | 6325 | 2020-06-25 | Pennsylvania | 42 | 88230 | 6602 |
6326 | 6326 | 2020-06-25 | Puerto Rico | 72 | 6877 | 151 |
6327 | 6327 | 2020-06-25 | Rhode Island | 44 | 16640 | 920 |
6328 | 6328 | 2020-06-25 | South Carolina | 45 | 29022 | 693 |
6329 | 6329 | 2020-06-25 | South Dakota | 46 | 6479 | 87 |
6330 | 6330 | 2020-06-25 | Tennessee | 47 | 37695 | 558 |
6331 | 6331 | 2020-06-25 | Texas | 48 | 136783 | 2321 |
6332 | 6332 | 2020-06-25 | Utah | 49 | 19544 | 164 |
6333 | 6333 | 2020-06-25 | Vermont | 50 | 1191 | 56 |
6334 | 6334 | 2020-06-25 | Virgin Islands | 78 | 81 | 6 |
6335 | 6335 | 2020-06-25 | Virginia | 51 | 59946 | 1675 |
6336 | 6336 | 2020-06-25 | Washington | 53 | 31998 | 1301 |
6337 | 6337 | 2020-06-25 | West Virginia | 54 | 2693 | 92 |
6338 | 6338 | 2020-06-25 | Wisconsin | 55 | 29204 | 775 |
6339 | 6339 | 2020-06-25 | Wyoming | 56 | 1326 | 20 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );