ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2021-09-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- American Samoa 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
31535 | 31535 | 2021-09-27 | Alabama | 1 | 790648 | 14025 |
31536 | 31536 | 2021-09-27 | Alaska | 2 | 110887 | 535 |
31537 | 31537 | 2021-09-27 | American Samoa | 60 | 1 | 0 |
31538 | 31538 | 2021-09-27 | Arizona | 4 | 1086328 | 19812 |
31539 | 31539 | 2021-09-27 | Arkansas | 5 | 493120 | 7630 |
31540 | 31540 | 2021-09-27 | California | 6 | 4717357 | 68917 |
31541 | 31541 | 2021-09-27 | Colorado | 8 | 668635 | 7683 |
31542 | 31542 | 2021-09-27 | Connecticut | 9 | 389177 | 8593 |
31543 | 31543 | 2021-09-27 | Delaware | 10 | 131848 | 1942 |
31544 | 31544 | 2021-09-27 | District of Columbia | 11 | 60772 | 1174 |
31545 | 31545 | 2021-09-27 | Florida | 12 | 3555096 | 54063 |
31546 | 31546 | 2021-09-27 | Georgia | 13 | 1532011 | 24766 |
31547 | 31547 | 2021-09-27 | Guam | 66 | 15505 | 193 |
31548 | 31548 | 2021-09-27 | Hawaii | 15 | 76006 | 754 |
31549 | 31549 | 2021-09-27 | Idaho | 16 | 252426 | 2791 |
31550 | 31550 | 2021-09-27 | Illinois | 17 | 1623863 | 27529 |
31551 | 31551 | 2021-09-27 | Indiana | 18 | 957632 | 15474 |
31552 | 31552 | 2021-09-27 | Iowa | 19 | 445668 | 6482 |
31553 | 31553 | 2021-09-27 | Kansas | 20 | 407436 | 6050 |
31554 | 31554 | 2021-09-27 | Kentucky | 21 | 685740 | 8667 |
31555 | 31555 | 2021-09-27 | Louisiana | 22 | 737582 | 13796 |
31556 | 31556 | 2021-09-27 | Maine | 23 | 87189 | 1014 |
31557 | 31557 | 2021-09-27 | Maryland | 24 | 528993 | 10395 |
31558 | 31558 | 2021-09-27 | Massachusetts | 25 | 807182 | 18555 |
31559 | 31559 | 2021-09-27 | Michigan | 26 | 1139295 | 22227 |
31560 | 31560 | 2021-09-27 | Minnesota | 27 | 700059 | 8191 |
31561 | 31561 | 2021-09-27 | Mississippi | 28 | 484675 | 9480 |
31562 | 31562 | 2021-09-27 | Missouri | 29 | 831356 | 12032 |
31563 | 31563 | 2021-09-27 | Montana | 30 | 147436 | 1973 |
31564 | 31564 | 2021-09-27 | Nebraska | 31 | 263783 | 2653 |
31565 | 31565 | 2021-09-27 | Nevada | 32 | 418477 | 7045 |
31566 | 31566 | 2021-09-27 | New Hampshire | 33 | 118706 | 1476 |
31567 | 31567 | 2021-09-27 | New Jersey | 34 | 1148358 | 27346 |
31568 | 31568 | 2021-09-27 | New Mexico | 35 | 250774 | 4766 |
31569 | 31569 | 2021-09-27 | New York | 36 | 2409292 | 54785 |
31570 | 31570 | 2021-09-27 | North Carolina | 37 | 1384599 | 16253 |
31571 | 31571 | 2021-09-27 | North Dakota | 38 | 129724 | 1638 |
31572 | 31572 | 2021-09-27 | Northern Mariana Islands | 69 | 267 | 2 |
31573 | 31573 | 2021-09-27 | Ohio | 39 | 1393696 | 21820 |
31574 | 31574 | 2021-09-27 | Oklahoma | 40 | 609737 | 8715 |
31575 | 31575 | 2021-09-27 | Oregon | 41 | 324571 | 3709 |
31576 | 31576 | 2021-09-27 | Pennsylvania | 42 | 1415049 | 29151 |
31577 | 31577 | 2021-09-27 | Puerto Rico | 72 | 214335 | 3133 |
31578 | 31578 | 2021-09-27 | Rhode Island | 44 | 171451 | 2832 |
31579 | 31579 | 2021-09-27 | South Carolina | 45 | 850188 | 12213 |
31580 | 31580 | 2021-09-27 | South Dakota | 46 | 143183 | 2129 |
31581 | 31581 | 2021-09-27 | Tennessee | 47 | 1189429 | 14834 |
31582 | 31582 | 2021-09-27 | Texas | 48 | 4021667 | 64538 |
31583 | 31583 | 2021-09-27 | Utah | 49 | 503968 | 2892 |
31584 | 31584 | 2021-09-27 | Vermont | 50 | 33231 | 310 |
31585 | 31585 | 2021-09-27 | Virgin Islands | 78 | 6679 | 70 |
31586 | 31586 | 2021-09-27 | Virginia | 51 | 857852 | 12592 |
31587 | 31587 | 2021-09-27 | Washington | 53 | 651511 | 7578 |
31588 | 31588 | 2021-09-27 | West Virginia | 54 | 235965 | 3568 |
31589 | 31589 | 2021-09-27 | Wisconsin | 55 | 800621 | 8813 |
31590 | 31590 | 2021-09-27 | Wyoming | 56 | 88935 | 955 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );