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-09-29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
11565 | 11565 | 2020-09-29 | Alabama | 1 | 153554 | 2517 |
11566 | 11566 | 2020-09-29 | Alaska | 2 | 8602 | 52 |
11567 | 11567 | 2020-09-29 | Arizona | 4 | 218185 | 5632 |
11568 | 11568 | 2020-09-29 | Arkansas | 5 | 82755 | 1350 |
11569 | 11569 | 2020-09-29 | California | 6 | 817940 | 15791 |
11570 | 11570 | 2020-09-29 | Colorado | 8 | 70458 | 2058 |
11571 | 11571 | 2020-09-29 | Connecticut | 9 | 57329 | 4505 |
11572 | 11572 | 2020-09-29 | Delaware | 10 | 20531 | 635 |
11573 | 11573 | 2020-09-29 | District of Columbia | 11 | 15300 | 626 |
11574 | 11574 | 2020-09-29 | Florida | 12 | 704560 | 14142 |
11575 | 11575 | 2020-09-29 | Georgia | 13 | 300019 | 6836 |
11576 | 11576 | 2020-09-29 | Guam | 66 | 3412 | 48 |
11577 | 11577 | 2020-09-29 | Hawaii | 15 | 12436 | 133 |
11578 | 11578 | 2020-09-29 | Idaho | 16 | 41854 | 466 |
11579 | 11579 | 2020-09-29 | Illinois | 17 | 294673 | 8901 |
11580 | 11580 | 2020-09-29 | Indiana | 18 | 121327 | 3612 |
11581 | 11581 | 2020-09-29 | Iowa | 19 | 88234 | 1341 |
11582 | 11582 | 2020-09-29 | Kansas | 20 | 59951 | 650 |
11583 | 11583 | 2020-09-29 | Kentucky | 21 | 71921 | 1205 |
11584 | 11584 | 2020-09-29 | Louisiana | 22 | 166848 | 5490 |
11585 | 11585 | 2020-09-29 | Maine | 23 | 5337 | 141 |
11586 | 11586 | 2020-09-29 | Maryland | 24 | 124805 | 3946 |
11587 | 11587 | 2020-09-29 | Massachusetts | 25 | 131584 | 9423 |
11588 | 11588 | 2020-09-29 | Michigan | 26 | 136899 | 7073 |
11589 | 11589 | 2020-09-29 | Minnesota | 27 | 98499 | 2072 |
11590 | 11590 | 2020-09-29 | Mississippi | 28 | 97638 | 2957 |
11591 | 11591 | 2020-09-29 | Missouri | 29 | 128816 | 2148 |
11592 | 11592 | 2020-09-29 | Montana | 30 | 12825 | 177 |
11593 | 11593 | 2020-09-29 | Nebraska | 31 | 45044 | 493 |
11594 | 11594 | 2020-09-29 | Nevada | 32 | 79691 | 1594 |
11595 | 11595 | 2020-09-29 | New Hampshire | 33 | 8233 | 439 |
11596 | 11596 | 2020-09-29 | New Jersey | 34 | 206354 | 16117 |
11597 | 11597 | 2020-09-29 | New Mexico | 35 | 29157 | 875 |
11598 | 11598 | 2020-09-29 | New York | 36 | 462364 | 32743 |
11599 | 11599 | 2020-09-29 | North Carolina | 37 | 209384 | 3511 |
11600 | 11600 | 2020-09-29 | North Dakota | 38 | 21404 | 242 |
11601 | 11601 | 2020-09-29 | Northern Mariana Islands | 69 | 69 | 2 |
11602 | 11602 | 2020-09-29 | Ohio | 39 | 152907 | 4783 |
11603 | 11603 | 2020-09-29 | Oklahoma | 40 | 86219 | 1018 |
11604 | 11604 | 2020-09-29 | Oregon | 41 | 33297 | 555 |
11605 | 11605 | 2020-09-29 | Pennsylvania | 42 | 163219 | 8196 |
11606 | 11606 | 2020-09-29 | Puerto Rico | 72 | 48467 | 654 |
11607 | 11607 | 2020-09-29 | Rhode Island | 44 | 24556 | 1113 |
11608 | 11608 | 2020-09-29 | South Carolina | 45 | 147634 | 3359 |
11609 | 11609 | 2020-09-29 | South Dakota | 46 | 21997 | 223 |
11610 | 11610 | 2020-09-29 | Tennessee | 47 | 191859 | 2393 |
11611 | 11611 | 2020-09-29 | Texas | 48 | 780543 | 15994 |
11612 | 11612 | 2020-09-29 | Utah | 49 | 72136 | 457 |
11613 | 11613 | 2020-09-29 | Vermont | 50 | 1749 | 58 |
11614 | 11614 | 2020-09-29 | Virgin Islands | 78 | 1318 | 20 |
11615 | 11615 | 2020-09-29 | Virginia | 51 | 147516 | 3187 |
11616 | 11616 | 2020-09-29 | Washington | 53 | 91011 | 2218 |
11617 | 11617 | 2020-09-29 | West Virginia | 54 | 15692 | 345 |
11618 | 11618 | 2020-09-29 | Wisconsin | 55 | 126744 | 1312 |
11619 | 11619 | 2020-09-29 | Wyoming | 56 | 5821 | 50 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );