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-08-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
49679 | 49679 | 2022-08-17 | Alabama | 1 | 1449812 | 20026 |
49680 | 49680 | 2022-08-17 | Alaska | 2 | 289203 | 1290 |
49681 | 49681 | 2022-08-17 | American Samoa | 60 | 7471 | 33 |
49682 | 49682 | 2022-08-17 | Arizona | 4 | 2237208 | 30982 |
49683 | 49683 | 2022-08-17 | Arkansas | 5 | 919632 | 11841 |
49684 | 49684 | 2022-08-17 | California | 6 | 10944159 | 94424 |
49685 | 49685 | 2022-08-17 | Colorado | 8 | 1624999 | 13298 |
49686 | 49686 | 2022-08-17 | Connecticut | 9 | 866537 | 11180 |
49687 | 49687 | 2022-08-17 | Delaware | 10 | 299463 | 3036 |
49688 | 49688 | 2022-08-17 | District of Columbia | 11 | 164724 | 1374 |
49689 | 49689 | 2022-08-17 | Florida | 12 | 6939253 | 78845 |
49690 | 49690 | 2022-08-17 | Georgia | 13 | 2748195 | 37923 |
49691 | 49691 | 2022-08-17 | Guam | 66 | 58009 | 391 |
49692 | 49692 | 2022-08-17 | Hawaii | 15 | 327175 | 1616 |
49693 | 49693 | 2022-08-17 | Idaho | 16 | 485601 | 5084 |
49694 | 49694 | 2022-08-17 | Illinois | 17 | 3642465 | 39145 |
49695 | 49695 | 2022-08-17 | Indiana | 18 | 1867509 | 24271 |
49696 | 49696 | 2022-08-17 | Iowa | 19 | 832937 | 9882 |
49697 | 49697 | 2022-08-17 | Kansas | 20 | 854105 | 8959 |
49698 | 49698 | 2022-08-17 | Kentucky | 21 | 1521310 | 16540 |
49699 | 49699 | 2022-08-17 | Louisiana | 22 | 1407047 | 17743 |
49700 | 49700 | 2022-08-17 | Maine | 23 | 279644 | 2496 |
49701 | 49701 | 2022-08-17 | Maryland | 24 | 1207283 | 15093 |
49702 | 49702 | 2022-08-17 | Massachusetts | 25 | 1987385 | 21285 |
49703 | 49703 | 2022-08-17 | Michigan | 26 | 2731787 | 37774 |
49704 | 49704 | 2022-08-17 | Minnesota | 27 | 1611246 | 13362 |
49705 | 49705 | 2022-08-17 | Mississippi | 28 | 897715 | 12750 |
49706 | 49706 | 2022-08-17 | Missouri | 29 | 1608264 | 21273 |
49707 | 49707 | 2022-08-17 | Montana | 30 | 300959 | 3481 |
49708 | 49708 | 2022-08-17 | Nebraska | 31 | 524339 | 4432 |
49709 | 49709 | 2022-08-17 | Nevada | 32 | 836774 | 11353 |
49710 | 49710 | 2022-08-17 | New Hampshire | 33 | 342037 | 2646 |
49711 | 49711 | 2022-08-17 | New Jersey | 34 | 2645729 | 34425 |
49712 | 49712 | 2022-08-17 | New Mexico | 35 | 604185 | 8336 |
49713 | 49713 | 2022-08-17 | New York | 36 | 5911816 | 70079 |
49714 | 49714 | 2022-08-17 | North Carolina | 37 | 3074964 | 25770 |
49715 | 49715 | 2022-08-17 | North Dakota | 38 | 261790 | 2376 |
49716 | 49716 | 2022-08-17 | Northern Mariana Islands | 69 | 12948 | 39 |
49717 | 49717 | 2022-08-17 | Ohio | 39 | 3002043 | 39220 |
49718 | 49718 | 2022-08-17 | Oklahoma | 40 | 1147408 | 14623 |
49719 | 49719 | 2022-08-17 | Oregon | 41 | 868905 | 8326 |
49720 | 49720 | 2022-08-17 | Pennsylvania | 42 | 3147474 | 46494 |
49721 | 49721 | 2022-08-17 | Puerto Rico | 72 | 929586 | 4880 |
49722 | 49722 | 2022-08-17 | Rhode Island | 44 | 413259 | 3632 |
49723 | 49723 | 2022-08-17 | South Carolina | 45 | 1650748 | 18227 |
49724 | 49724 | 2022-08-17 | South Dakota | 46 | 254670 | 2979 |
49725 | 49725 | 2022-08-17 | Tennessee | 47 | 2191688 | 26975 |
49726 | 49726 | 2022-08-17 | Texas | 48 | 7627988 | 89995 |
49727 | 49727 | 2022-08-17 | Utah | 49 | 1020399 | 4940 |
49728 | 49728 | 2022-08-17 | Vermont | 50 | 139226 | 702 |
49729 | 49729 | 2022-08-17 | Virgin Islands | 78 | 22278 | 122 |
49730 | 49730 | 2022-08-17 | Virginia | 51 | 2005336 | 21203 |
49731 | 49731 | 2022-08-17 | Washington | 53 | 1767315 | 13933 |
49732 | 49732 | 2022-08-17 | West Virginia | 54 | 571075 | 7223 |
49733 | 49733 | 2022-08-17 | Wisconsin | 55 | 1810758 | 14996 |
49734 | 49734 | 2022-08-17 | Wyoming | 56 | 173487 | 1871 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );