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 2021-01-17 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 |
---|---|---|---|---|---|---|
17615 | 17615 | 2021-01-17 | Alabama | 1 | 422598 | 6120 |
17616 | 17616 | 2021-01-17 | Alaska | 2 | 51630 | 220 |
17617 | 17617 | 2021-01-17 | Arizona | 4 | 673882 | 11266 |
17618 | 17618 | 2021-01-17 | Arkansas | 5 | 271154 | 4311 |
17619 | 17619 | 2021-01-17 | California | 6 | 3006966 | 33593 |
17620 | 17620 | 2021-01-17 | Colorado | 8 | 376921 | 5454 |
17621 | 17621 | 2021-01-17 | Connecticut | 9 | 223422 | 6594 |
17622 | 17622 | 2021-01-17 | Delaware | 10 | 70294 | 1016 |
17623 | 17623 | 2021-01-17 | District of Columbia | 11 | 33851 | 850 |
17624 | 17624 | 2021-01-17 | Florida | 12 | 1571271 | 24136 |
17625 | 17625 | 2021-01-17 | Georgia | 13 | 791322 | 11906 |
17626 | 17626 | 2021-01-17 | Guam | 66 | 8453 | 128 |
17627 | 17627 | 2021-01-17 | Hawaii | 15 | 24309 | 319 |
17628 | 17628 | 2021-01-17 | Idaho | 16 | 155617 | 1609 |
17629 | 17629 | 2021-01-17 | Illinois | 17 | 1071307 | 20052 |
17630 | 17630 | 2021-01-17 | Indiana | 18 | 593262 | 9310 |
17631 | 17631 | 2021-01-17 | Iowa | 19 | 305151 | 4323 |
17632 | 17632 | 2021-01-17 | Kansas | 20 | 259226 | 3502 |
17633 | 17633 | 2021-01-17 | Kentucky | 21 | 329816 | 3428 |
17634 | 17634 | 2021-01-17 | Louisiana | 22 | 368980 | 8203 |
17635 | 17635 | 2021-01-17 | Maine | 23 | 33559 | 511 |
17636 | 17636 | 2021-01-17 | Maryland | 24 | 326648 | 6567 |
17637 | 17637 | 2021-01-17 | Massachusetts | 25 | 470140 | 13652 |
17638 | 17638 | 2021-01-17 | Michigan | 26 | 579767 | 14658 |
17639 | 17639 | 2021-01-17 | Minnesota | 27 | 446448 | 5995 |
17640 | 17640 | 2021-01-17 | Mississippi | 28 | 252475 | 5521 |
17641 | 17641 | 2021-01-17 | Missouri | 29 | 473268 | 6647 |
17642 | 17642 | 2021-01-17 | Montana | 30 | 89393 | 1092 |
17643 | 17643 | 2021-01-17 | Nebraska | 31 | 182914 | 1905 |
17644 | 17644 | 2021-01-17 | Nevada | 32 | 261847 | 3784 |
17645 | 17645 | 2021-01-17 | New Hampshire | 33 | 56864 | 933 |
17646 | 17646 | 2021-01-17 | New Jersey | 34 | 627221 | 20439 |
17647 | 17647 | 2021-01-17 | New Mexico | 35 | 163637 | 2934 |
17648 | 17648 | 2021-01-17 | New York | 36 | 1242818 | 40570 |
17649 | 17649 | 2021-01-17 | North Carolina | 37 | 674771 | 8125 |
17650 | 17650 | 2021-01-17 | North Dakota | 38 | 95886 | 1406 |
17651 | 17651 | 2021-01-17 | Northern Mariana Islands | 69 | 128 | 2 |
17652 | 17652 | 2021-01-17 | Ohio | 39 | 826754 | 10200 |
17653 | 17653 | 2021-01-17 | Oklahoma | 40 | 354979 | 2987 |
17654 | 17654 | 2021-01-17 | Oregon | 41 | 133205 | 1801 |
17655 | 17655 | 2021-01-17 | Pennsylvania | 42 | 772747 | 19310 |
17656 | 17656 | 2021-01-17 | Puerto Rico | 72 | 120996 | 1703 |
17657 | 17657 | 2021-01-17 | Rhode Island | 44 | 104443 | 2005 |
17658 | 17658 | 2021-01-17 | South Carolina | 45 | 388184 | 6237 |
17659 | 17659 | 2021-01-17 | South Dakota | 46 | 105544 | 1656 |
17660 | 17660 | 2021-01-17 | Tennessee | 47 | 672292 | 8312 |
17661 | 17661 | 2021-01-17 | Texas | 48 | 2125391 | 32747 |
17662 | 17662 | 2021-01-17 | Utah | 49 | 323837 | 1493 |
17663 | 17663 | 2021-01-17 | Vermont | 50 | 10057 | 163 |
17664 | 17664 | 2021-01-17 | Virgin Islands | 78 | 2260 | 24 |
17665 | 17665 | 2021-01-17 | Virginia | 51 | 439305 | 5729 |
17666 | 17666 | 2021-01-17 | Washington | 53 | 293296 | 3971 |
17667 | 17667 | 2021-01-17 | West Virginia | 54 | 108821 | 1776 |
17668 | 17668 | 2021-01-17 | Wisconsin | 55 | 568166 | 5907 |
17669 | 17669 | 2021-01-17 | Wyoming | 56 | 49363 | 522 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );