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 2022-01-31 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 |
---|---|---|---|---|---|---|
38591 | 38591 | 2022-01-31 | Alabama | 1 | 1218257 | 17086 |
38592 | 38592 | 2022-01-31 | Alaska | 2 | 215643 | 1057 |
38593 | 38593 | 2022-01-31 | American Samoa | 60 | 18 | 0 |
38594 | 38594 | 2022-01-31 | Arizona | 4 | 1870644 | 26205 |
38595 | 38595 | 2022-01-31 | Arkansas | 5 | 776759 | 9634 |
38596 | 38596 | 2022-01-31 | California | 6 | 8411819 | 80267 |
38597 | 38597 | 2022-01-31 | Colorado | 8 | 1258871 | 11339 |
38598 | 38598 | 2022-01-31 | Connecticut | 9 | 699400 | 10010 |
38599 | 38599 | 2022-01-31 | Delaware | 10 | 248111 | 2531 |
38600 | 38600 | 2022-01-31 | District of Columbia | 11 | 130888 | 1289 |
38601 | 38601 | 2022-01-31 | Florida | 12 | 5535803 | 65265 |
38602 | 38602 | 2022-01-31 | Georgia | 13 | 2302164 | 31697 |
38603 | 38603 | 2022-01-31 | Guam | 66 | 33300 | 291 |
38604 | 38604 | 2022-01-31 | Hawaii | 15 | 214249 | 1178 |
38605 | 38605 | 2022-01-31 | Idaho | 16 | 380402 | 4423 |
38606 | 38606 | 2022-01-31 | Illinois | 17 | 2925690 | 34704 |
38607 | 38607 | 2022-01-31 | Indiana | 18 | 1627324 | 21356 |
38608 | 38608 | 2022-01-31 | Iowa | 19 | 712288 | 8501 |
38609 | 38609 | 2022-01-31 | Kansas | 20 | 731036 | 7565 |
38610 | 38610 | 2022-01-31 | Kentucky | 21 | 1172511 | 12974 |
38611 | 38611 | 2022-01-31 | Louisiana | 22 | 1170212 | 15674 |
38612 | 38612 | 2022-01-31 | Maine | 23 | 174225 | 1738 |
38613 | 38613 | 2022-01-31 | Maryland | 24 | 955537 | 13484 |
38614 | 38614 | 2022-01-31 | Massachusetts | 25 | 1611594 | 22034 |
38615 | 38615 | 2022-01-31 | Michigan | 26 | 2252688 | 32225 |
38616 | 38616 | 2022-01-31 | Minnesota | 27 | 1321903 | 11561 |
38617 | 38617 | 2022-01-31 | Mississippi | 28 | 727418 | 10935 |
38618 | 38618 | 2022-01-31 | Missouri | 29 | 1345787 | 17421 |
38619 | 38619 | 2022-01-31 | Montana | 30 | 242930 | 3004 |
38620 | 38620 | 2022-01-31 | Nebraska | 31 | 439326 | 3666 |
38621 | 38621 | 2022-01-31 | Nevada | 32 | 656898 | 8951 |
38622 | 38622 | 2022-01-31 | New Hampshire | 33 | 276856 | 2209 |
38623 | 38623 | 2022-01-31 | New Jersey | 34 | 2111856 | 31442 |
38624 | 38624 | 2022-01-31 | New Mexico | 35 | 480087 | 6456 |
38625 | 38625 | 2022-01-31 | New York | 36 | 4789532 | 64247 |
38626 | 38626 | 2022-01-31 | North Carolina | 37 | 2421306 | 20767 |
38627 | 38627 | 2022-01-31 | North Dakota | 38 | 223767 | 2140 |
38628 | 38628 | 2022-01-31 | Northern Mariana Islands | 69 | 4795 | 23 |
38629 | 38629 | 2022-01-31 | Ohio | 39 | 2580405 | 33071 |
38630 | 38630 | 2022-01-31 | Oklahoma | 40 | 976914 | 12044 |
38631 | 38631 | 2022-01-31 | Oregon | 41 | 633876 | 6100 |
38632 | 38632 | 2022-01-31 | Pennsylvania | 42 | 2661481 | 40581 |
38633 | 38633 | 2022-01-31 | Puerto Rico | 72 | 491116 | 3855 |
38634 | 38634 | 2022-01-31 | Rhode Island | 44 | 343779 | 3316 |
38635 | 38635 | 2022-01-31 | South Carolina | 45 | 1385019 | 15480 |
38636 | 38636 | 2022-01-31 | South Dakota | 46 | 226413 | 2650 |
38637 | 38637 | 2022-01-31 | Tennessee | 47 | 1802927 | 22231 |
38638 | 38638 | 2022-01-31 | Texas | 48 | 6219346 | 79694 |
38639 | 38639 | 2022-01-31 | Utah | 49 | 885686 | 4118 |
38640 | 38640 | 2022-01-31 | Vermont | 50 | 104472 | 536 |
38641 | 38641 | 2022-01-31 | Virgin Islands | 78 | 14870 | 101 |
38642 | 38642 | 2022-01-31 | Virginia | 51 | 1545650 | 16217 |
38643 | 38643 | 2022-01-31 | Washington | 53 | 1335737 | 10838 |
38644 | 38644 | 2022-01-31 | West Virginia | 54 | 446771 | 5763 |
38645 | 38645 | 2022-01-31 | Wisconsin | 55 | 1516634 | 12374 |
38646 | 38646 | 2022-01-31 | Wyoming | 56 | 146505 | 1625 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );