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-10-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 |
---|---|---|---|---|---|---|
53655 | 53655 | 2022-10-27 | Alabama | 1 | 1534287 | 20558 |
53656 | 53656 | 2022-10-27 | Alaska | 2 | 298479 | 1369 |
53657 | 53657 | 2022-10-27 | American Samoa | 60 | 8251 | 34 |
53658 | 53658 | 2022-10-27 | Arizona | 4 | 2287886 | 31548 |
53659 | 53659 | 2022-10-27 | Arkansas | 5 | 959014 | 12462 |
53660 | 53660 | 2022-10-27 | California | 6 | 11361181 | 96928 |
53661 | 53661 | 2022-10-27 | Colorado | 8 | 1679515 | 13614 |
53662 | 53662 | 2022-10-27 | Connecticut | 9 | 910919 | 11462 |
53663 | 53663 | 2022-10-27 | Delaware | 10 | 312850 | 3136 |
53664 | 53664 | 2022-10-27 | District of Columbia | 11 | 169436 | 1392 |
53665 | 53665 | 2022-10-27 | Florida | 12 | 7149300 | 82176 |
53666 | 53666 | 2022-10-27 | Georgia | 13 | 2835571 | 39057 |
53667 | 53667 | 2022-10-27 | Guam | 66 | 59720 | 402 |
53668 | 53668 | 2022-10-27 | Hawaii | 15 | 353081 | 1701 |
53669 | 53669 | 2022-10-27 | Idaho | 16 | 499973 | 5219 |
53670 | 53670 | 2022-10-27 | Illinois | 17 | 3813025 | 39968 |
53671 | 53671 | 2022-10-27 | Indiana | 18 | 1937565 | 24864 |
53672 | 53672 | 2022-10-27 | Iowa | 19 | 862925 | 10177 |
53673 | 53673 | 2022-10-27 | Kansas | 20 | 888315 | 9628 |
53674 | 53674 | 2022-10-27 | Kentucky | 21 | 1611523 | 17261 |
53675 | 53675 | 2022-10-27 | Louisiana | 22 | 1461433 | 18168 |
53676 | 53676 | 2022-10-27 | Maine | 23 | 296746 | 2642 |
53677 | 53677 | 2022-10-27 | Maryland | 24 | 1267155 | 15539 |
53678 | 53678 | 2022-10-27 | Massachusetts | 25 | 2086638 | 22023 |
53679 | 53679 | 2022-10-27 | Michigan | 26 | 2877509 | 39199 |
53680 | 53680 | 2022-10-27 | Minnesota | 27 | 1686048 | 13825 |
53681 | 53681 | 2022-10-27 | Mississippi | 28 | 933065 | 12968 |
53682 | 53682 | 2022-10-27 | Missouri | 29 | 1683956 | 21845 |
53683 | 53683 | 2022-10-27 | Montana | 30 | 314068 | 3569 |
53684 | 53684 | 2022-10-27 | Nebraska | 31 | 540345 | 4559 |
53685 | 53685 | 2022-10-27 | Nevada | 32 | 850204 | 11555 |
53686 | 53686 | 2022-10-27 | New Hampshire | 33 | 356580 | 2737 |
53687 | 53687 | 2022-10-27 | New Jersey | 34 | 2789256 | 34898 |
53688 | 53688 | 2022-10-27 | New Mexico | 35 | 626714 | 8635 |
53689 | 53689 | 2022-10-27 | New York | 36 | 6223314 | 72424 |
53690 | 53690 | 2022-10-27 | North Carolina | 37 | 3237440 | 26963 |
53691 | 53691 | 2022-10-27 | North Dakota | 38 | 271913 | 2434 |
53692 | 53692 | 2022-10-27 | Northern Mariana Islands | 69 | 13171 | 40 |
53693 | 53693 | 2022-10-27 | Ohio | 39 | 3185038 | 40178 |
53694 | 53694 | 2022-10-27 | Oklahoma | 40 | 1208316 | 14961 |
53695 | 53695 | 2022-10-27 | Oregon | 41 | 908188 | 8680 |
53696 | 53696 | 2022-10-27 | Pennsylvania | 42 | 3304816 | 47705 |
53697 | 53697 | 2022-10-27 | Puerto Rico | 72 | 1011753 | 5248 |
53698 | 53698 | 2022-10-27 | Rhode Island | 44 | 432042 | 3696 |
53699 | 53699 | 2022-10-27 | South Carolina | 45 | 1721693 | 18578 |
53700 | 53700 | 2022-10-27 | South Dakota | 46 | 264187 | 3059 |
53701 | 53701 | 2022-10-27 | Tennessee | 47 | 2298594 | 27792 |
53702 | 53702 | 2022-10-27 | Texas | 48 | 7917515 | 91289 |
53703 | 53703 | 2022-10-27 | Utah | 49 | 1045758 | 5056 |
53704 | 53704 | 2022-10-27 | Vermont | 50 | 144895 | 740 |
53705 | 53705 | 2022-10-27 | Virgin Islands | 78 | 23311 | 124 |
53706 | 53706 | 2022-10-27 | Virginia | 51 | 2116060 | 22171 |
53707 | 53707 | 2022-10-27 | Washington | 53 | 1835720 | 14595 |
53708 | 53708 | 2022-10-27 | West Virginia | 54 | 607087 | 7513 |
53709 | 53709 | 2022-10-27 | Wisconsin | 55 | 1894346 | 15434 |
53710 | 53710 | 2022-10-27 | Wyoming | 56 | 178444 | 1908 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );