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-05-06 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 ▼ |
---|---|---|---|---|---|---|
3571 | 3571 | 2020-05-06 | Northern Mariana Islands | 69 | 15 | 2 |
3584 | 3584 | 2020-05-06 | Virgin Islands | 78 | 66 | 4 |
3546 | 3546 | 2020-05-06 | Guam | 66 | 1118 | 6 |
3589 | 3589 | 2020-05-06 | Wyoming | 56 | 631 | 7 |
3536 | 3536 | 2020-05-06 | Alaska | 2 | 370 | 8 |
3562 | 3562 | 2020-05-06 | Montana | 30 | 456 | 16 |
3547 | 3547 | 2020-05-06 | Hawaii | 15 | 616 | 17 |
3579 | 3579 | 2020-05-06 | South Dakota | 46 | 2779 | 29 |
3570 | 3570 | 2020-05-06 | North Dakota | 38 | 1323 | 31 |
3587 | 3587 | 2020-05-06 | West Virginia | 54 | 1277 | 51 |
3583 | 3583 | 2020-05-06 | Vermont | 50 | 908 | 52 |
3582 | 3582 | 2020-05-06 | Utah | 49 | 5605 | 59 |
3555 | 3555 | 2020-05-06 | Maine | 23 | 1254 | 62 |
3548 | 3548 | 2020-05-06 | Idaho | 16 | 2158 | 67 |
3563 | 3563 | 2020-05-06 | Nebraska | 31 | 6771 | 85 |
3538 | 3538 | 2020-05-06 | Arkansas | 5 | 3611 | 87 |
3576 | 3576 | 2020-05-06 | Puerto Rico | 72 | 1968 | 99 |
3565 | 3565 | 2020-05-06 | New Hampshire | 33 | 2741 | 111 |
3574 | 3574 | 2020-05-06 | Oregon | 41 | 2916 | 115 |
3552 | 3552 | 2020-05-06 | Kansas | 20 | 5893 | 163 |
3567 | 3567 | 2020-05-06 | New Mexico | 35 | 4290 | 169 |
3542 | 3542 | 2020-05-06 | Delaware | 10 | 5778 | 193 |
3551 | 3551 | 2020-05-06 | Iowa | 19 | 10404 | 219 |
3580 | 3580 | 2020-05-06 | Tennessee | 47 | 13737 | 237 |
3573 | 3573 | 2020-05-06 | Oklahoma | 40 | 4201 | 253 |
3543 | 3543 | 2020-05-06 | District of Columbia | 11 | 5461 | 277 |
3553 | 3553 | 2020-05-06 | Kentucky | 21 | 5946 | 286 |
3564 | 3564 | 2020-05-06 | Nevada | 32 | 5744 | 286 |
3578 | 3578 | 2020-05-06 | South Carolina | 45 | 6936 | 305 |
3535 | 3535 | 2020-05-06 | Alabama | 1 | 8691 | 343 |
3588 | 3588 | 2020-05-06 | Wisconsin | 55 | 9052 | 362 |
3577 | 3577 | 2020-05-06 | Rhode Island | 44 | 10205 | 370 |
3560 | 3560 | 2020-05-06 | Mississippi | 28 | 8424 | 374 |
3537 | 3537 | 2020-05-06 | Arizona | 4 | 9707 | 426 |
3561 | 3561 | 2020-05-06 | Missouri | 29 | 9164 | 429 |
3559 | 3559 | 2020-05-06 | Minnesota | 27 | 8579 | 485 |
3569 | 3569 | 2020-05-06 | North Carolina | 37 | 12783 | 497 |
3585 | 3585 | 2020-05-06 | Virginia | 51 | 20258 | 713 |
3586 | 3586 | 2020-05-06 | Washington | 53 | 16873 | 881 |
3540 | 3540 | 2020-05-06 | Colorado | 8 | 17720 | 919 |
3581 | 3581 | 2020-05-06 | Texas | 48 | 35441 | 985 |
3572 | 3572 | 2020-05-06 | Ohio | 39 | 21576 | 1225 |
3545 | 3545 | 2020-05-06 | Georgia | 13 | 29724 | 1309 |
3550 | 3550 | 2020-05-06 | Indiana | 18 | 22286 | 1377 |
3556 | 3556 | 2020-05-06 | Maryland | 24 | 28263 | 1443 |
3544 | 3544 | 2020-05-06 | Florida | 12 | 37994 | 1538 |
3554 | 3554 | 2020-05-06 | Louisiana | 22 | 30472 | 2167 |
3539 | 3539 | 2020-05-06 | California | 6 | 60787 | 2478 |
3541 | 3541 | 2020-05-06 | Connecticut | 9 | 30995 | 2718 |
3549 | 3549 | 2020-05-06 | Illinois | 17 | 68164 | 2977 |
3575 | 3575 | 2020-05-06 | Pennsylvania | 42 | 54989 | 3360 |
3558 | 3558 | 2020-05-06 | Michigan | 26 | 45079 | 4250 |
3557 | 3557 | 2020-05-06 | Massachusetts | 25 | 72025 | 4420 |
3566 | 3566 | 2020-05-06 | New Jersey | 34 | 131890 | 8549 |
3568 | 3568 | 2020-05-06 | New York | 36 | 329405 | 25956 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );