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-08-20 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 |
---|---|---|---|---|---|---|
9365 | 9365 | 2020-08-20 | Alabama | 1 | 112449 | 1974 |
9366 | 9366 | 2020-08-20 | Alaska | 2 | 5330 | 27 |
9367 | 9367 | 2020-08-20 | Arizona | 4 | 196305 | 4688 |
9368 | 9368 | 2020-08-20 | Arkansas | 5 | 54765 | 641 |
9369 | 9369 | 2020-08-20 | California | 6 | 653401 | 11801 |
9370 | 9370 | 2020-08-20 | Colorado | 8 | 54285 | 1909 |
9371 | 9371 | 2020-08-20 | Connecticut | 9 | 51432 | 4458 |
9372 | 9372 | 2020-08-20 | Delaware | 10 | 16718 | 595 |
9373 | 9373 | 2020-08-20 | District of Columbia | 11 | 13409 | 601 |
9374 | 9374 | 2020-08-20 | Florida | 12 | 588594 | 10048 |
9375 | 9375 | 2020-08-20 | Georgia | 13 | 230288 | 4797 |
9376 | 9376 | 2020-08-20 | Guam | 66 | 1673 | 7 |
9377 | 9377 | 2020-08-20 | Hawaii | 15 | 5821 | 44 |
9378 | 9378 | 2020-08-20 | Idaho | 16 | 29252 | 299 |
9379 | 9379 | 2020-08-20 | Illinois | 17 | 215889 | 8064 |
9380 | 9380 | 2020-08-20 | Indiana | 18 | 85257 | 3191 |
9381 | 9381 | 2020-08-20 | Iowa | 19 | 54533 | 1016 |
9382 | 9382 | 2020-08-20 | Kansas | 20 | 36445 | 423 |
9383 | 9383 | 2020-08-20 | Kentucky | 21 | 43700 | 881 |
9384 | 9384 | 2020-08-20 | Louisiana | 22 | 140962 | 4637 |
9385 | 9385 | 2020-08-20 | Maine | 23 | 4252 | 128 |
9386 | 9386 | 2020-08-20 | Maryland | 24 | 102783 | 3669 |
9387 | 9387 | 2020-08-20 | Massachusetts | 25 | 124728 | 8888 |
9388 | 9388 | 2020-08-20 | Michigan | 26 | 104771 | 6636 |
9389 | 9389 | 2020-08-20 | Minnesota | 27 | 67354 | 1791 |
9390 | 9390 | 2020-08-20 | Mississippi | 28 | 75449 | 2190 |
9391 | 9391 | 2020-08-20 | Missouri | 29 | 72912 | 1508 |
9392 | 9392 | 2020-08-20 | Montana | 30 | 6095 | 89 |
9393 | 9393 | 2020-08-20 | Nebraska | 31 | 31348 | 377 |
9394 | 9394 | 2020-08-20 | Nevada | 32 | 63699 | 1175 |
9395 | 9395 | 2020-08-20 | New Hampshire | 33 | 7050 | 428 |
9396 | 9396 | 2020-08-20 | New Jersey | 34 | 190356 | 15932 |
9397 | 9397 | 2020-08-20 | New Mexico | 35 | 23951 | 734 |
9398 | 9398 | 2020-08-20 | New York | 36 | 432523 | 32451 |
9399 | 9399 | 2020-08-20 | North Carolina | 37 | 150422 | 2496 |
9400 | 9400 | 2020-08-20 | North Dakota | 38 | 9246 | 134 |
9401 | 9401 | 2020-08-20 | Northern Mariana Islands | 69 | 54 | 2 |
9402 | 9402 | 2020-08-20 | Ohio | 39 | 112003 | 3929 |
9403 | 9403 | 2020-08-20 | Oklahoma | 40 | 50669 | 709 |
9404 | 9404 | 2020-08-20 | Oregon | 41 | 24176 | 412 |
9405 | 9405 | 2020-08-20 | Pennsylvania | 42 | 131736 | 7606 |
9406 | 9406 | 2020-08-20 | Puerto Rico | 72 | 28143 | 367 |
9407 | 9407 | 2020-08-20 | Rhode Island | 44 | 20871 | 1028 |
9408 | 9408 | 2020-08-20 | South Carolina | 45 | 109320 | 2401 |
9409 | 9409 | 2020-08-20 | South Dakota | 46 | 10691 | 157 |
9410 | 9410 | 2020-08-20 | Tennessee | 47 | 136260 | 1470 |
9411 | 9411 | 2020-08-20 | Texas | 48 | 587900 | 11248 |
9412 | 9412 | 2020-08-20 | Utah | 49 | 48103 | 384 |
9413 | 9413 | 2020-08-20 | Vermont | 50 | 1537 | 58 |
9414 | 9414 | 2020-08-20 | Virgin Islands | 78 | 869 | 10 |
9415 | 9415 | 2020-08-20 | Virginia | 51 | 109895 | 2427 |
9416 | 9416 | 2020-08-20 | Washington | 53 | 72284 | 1924 |
9417 | 9417 | 2020-08-20 | West Virginia | 54 | 8982 | 166 |
9418 | 9418 | 2020-08-20 | Wisconsin | 55 | 73067 | 1077 |
9419 | 9419 | 2020-08-20 | Wyoming | 56 | 3468 | 34 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );