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-08-28 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- 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 ▼ |
---|---|---|---|---|---|---|
29916 | 29916 | 2021-08-28 | Northern Mariana Islands | 69 | 234 | 2 |
29929 | 29929 | 2021-08-28 | Virgin Islands | 78 | 5760 | 53 |
29891 | 29891 | 2021-08-28 | Guam | 66 | 11015 | 146 |
29928 | 29928 | 2021-08-28 | Vermont | 50 | 27835 | 275 |
29881 | 29881 | 2021-08-28 | Alaska | 2 | 86055 | 421 |
29892 | 29892 | 2021-08-28 | Hawaii | 15 | 58436 | 584 |
29934 | 29934 | 2021-08-28 | Wyoming | 56 | 73467 | 835 |
29900 | 29900 | 2021-08-28 | Maine | 23 | 75381 | 930 |
29888 | 29888 | 2021-08-28 | District of Columbia | 11 | 54556 | 1159 |
29910 | 29910 | 2021-08-28 | New Hampshire | 33 | 106525 | 1415 |
29915 | 29915 | 2021-08-28 | North Dakota | 38 | 116698 | 1592 |
29907 | 29907 | 2021-08-28 | Montana | 30 | 125730 | 1783 |
29887 | 29887 | 2021-08-28 | Delaware | 10 | 118926 | 1877 |
29924 | 29924 | 2021-08-28 | South Dakota | 46 | 130776 | 2062 |
29893 | 29893 | 2021-08-28 | Idaho | 16 | 217961 | 2328 |
29908 | 29908 | 2021-08-28 | Nebraska | 31 | 241671 | 2584 |
29927 | 29927 | 2021-08-28 | Utah | 49 | 459953 | 2623 |
29922 | 29922 | 2021-08-28 | Rhode Island | 44 | 161701 | 2764 |
29921 | 29921 | 2021-08-28 | Puerto Rico | 72 | 202503 | 2823 |
29932 | 29932 | 2021-08-28 | West Virginia | 54 | 184682 | 3054 |
29919 | 29919 | 2021-08-28 | Oregon | 41 | 268401 | 3130 |
29912 | 29912 | 2021-08-28 | New Mexico | 35 | 229509 | 4507 |
29897 | 29897 | 2021-08-28 | Kansas | 20 | 366848 | 5575 |
29896 | 29896 | 2021-08-28 | Iowa | 19 | 402725 | 6268 |
29909 | 29909 | 2021-08-28 | Nevada | 32 | 386559 | 6433 |
29931 | 29931 | 2021-08-28 | Washington | 53 | 553077 | 6567 |
29883 | 29883 | 2021-08-28 | Arkansas | 5 | 448596 | 6854 |
29885 | 29885 | 2021-08-28 | Colorado | 8 | 613903 | 7288 |
29898 | 29898 | 2021-08-28 | Kentucky | 21 | 564815 | 7743 |
29918 | 29918 | 2021-08-28 | Oklahoma | 40 | 542412 | 7812 |
29904 | 29904 | 2021-08-28 | Minnesota | 27 | 644283 | 7892 |
29905 | 29905 | 2021-08-28 | Mississippi | 28 | 427640 | 8279 |
29886 | 29886 | 2021-08-28 | Connecticut | 9 | 370708 | 8358 |
29933 | 29933 | 2021-08-28 | Wisconsin | 55 | 727515 | 8438 |
29901 | 29901 | 2021-08-28 | Maryland | 24 | 494138 | 9983 |
29923 | 29923 | 2021-08-28 | South Carolina | 45 | 714265 | 10452 |
29906 | 29906 | 2021-08-28 | Missouri | 29 | 769507 | 11123 |
29930 | 29930 | 2021-08-28 | Virginia | 51 | 754652 | 11769 |
29880 | 29880 | 2021-08-28 | Alabama | 1 | 688018 | 12219 |
29899 | 29899 | 2021-08-28 | Louisiana | 22 | 679796 | 12359 |
29925 | 29925 | 2021-08-28 | Tennessee | 47 | 1003638 | 13241 |
29914 | 29914 | 2021-08-28 | North Carolina | 37 | 1191456 | 14334 |
29895 | 29895 | 2021-08-28 | Indiana | 18 | 847057 | 14373 |
29902 | 29902 | 2021-08-28 | Massachusetts | 25 | 753795 | 18219 |
29882 | 29882 | 2021-08-28 | Arizona | 4 | 1005764 | 18779 |
29917 | 29917 | 2021-08-28 | Ohio | 39 | 1207932 | 20799 |
29903 | 29903 | 2021-08-28 | Michigan | 26 | 1053009 | 21509 |
29890 | 29890 | 2021-08-28 | Georgia | 13 | 1339537 | 21826 |
29894 | 29894 | 2021-08-28 | Illinois | 17 | 1512387 | 26420 |
29911 | 29911 | 2021-08-28 | New Jersey | 34 | 1086480 | 26844 |
29920 | 29920 | 2021-08-28 | Pennsylvania | 42 | 1291831 | 28208 |
29889 | 29889 | 2021-08-28 | Florida | 12 | 3200682 | 43979 |
29913 | 29913 | 2021-08-28 | New York | 36 | 2263726 | 53769 |
29926 | 29926 | 2021-08-28 | Texas | 48 | 3558939 | 56741 |
29884 | 29884 | 2021-08-28 | California | 6 | 4410353 | 65676 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );