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-11-07 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 |
---|---|---|---|---|---|---|
33831 | 33831 | 2021-11-07 | Alabama | 1 | 836032 | 15834 |
33832 | 33832 | 2021-11-07 | Alaska | 2 | 141182 | 723 |
33833 | 33833 | 2021-11-07 | American Samoa | 60 | 4 | 0 |
33834 | 33834 | 2021-11-07 | Arizona | 4 | 1189708 | 21409 |
33835 | 33835 | 2021-11-07 | Arkansas | 5 | 516245 | 8497 |
33836 | 33836 | 2021-11-07 | California | 6 | 4961782 | 72698 |
33837 | 33837 | 2021-11-07 | Colorado | 8 | 765572 | 8598 |
33838 | 33838 | 2021-11-07 | Connecticut | 9 | 404969 | 8790 |
33839 | 33839 | 2021-11-07 | Delaware | 10 | 145903 | 2119 |
33840 | 33840 | 2021-11-07 | District of Columbia | 11 | 64799 | 1193 |
33841 | 33841 | 2021-11-07 | Florida | 12 | 3659255 | 60334 |
33842 | 33842 | 2021-11-07 | Georgia | 13 | 1605752 | 28430 |
33843 | 33843 | 2021-11-07 | Guam | 66 | 19608 | 249 |
33844 | 33844 | 2021-11-07 | Hawaii | 15 | 82282 | 959 |
33845 | 33845 | 2021-11-07 | Idaho | 16 | 296348 | 3647 |
33846 | 33846 | 2021-11-07 | Illinois | 17 | 1718384 | 28832 |
33847 | 33847 | 2021-11-07 | Indiana | 18 | 1033866 | 16898 |
33848 | 33848 | 2021-11-07 | Iowa | 19 | 494407 | 7069 |
33849 | 33849 | 2021-11-07 | Kansas | 20 | 441278 | 6524 |
33850 | 33850 | 2021-11-07 | Kentucky | 21 | 756576 | 10017 |
33851 | 33851 | 2021-11-07 | Louisiana | 22 | 761849 | 14615 |
33852 | 33852 | 2021-11-07 | Maine | 23 | 107772 | 1207 |
33853 | 33853 | 2021-11-07 | Maryland | 24 | 566313 | 10974 |
33854 | 33854 | 2021-11-07 | Massachusetts | 25 | 861480 | 19087 |
33855 | 33855 | 2021-11-07 | Michigan | 26 | 1307187 | 23951 |
33856 | 33856 | 2021-11-07 | Minnesota | 27 | 815132 | 8952 |
33857 | 33857 | 2021-11-07 | Mississippi | 28 | 506556 | 10148 |
33858 | 33858 | 2021-11-07 | Missouri | 29 | 879627 | 12932 |
33859 | 33859 | 2021-11-07 | Montana | 30 | 180649 | 2417 |
33860 | 33860 | 2021-11-07 | Nebraska | 31 | 289282 | 3001 |
33861 | 33861 | 2021-11-07 | Nevada | 32 | 455163 | 7713 |
33862 | 33862 | 2021-11-07 | New Hampshire | 33 | 139324 | 1597 |
33863 | 33863 | 2021-11-07 | New Jersey | 34 | 1207469 | 28085 |
33864 | 33864 | 2021-11-07 | New Mexico | 35 | 282742 | 5115 |
33865 | 33865 | 2021-11-07 | New York | 36 | 2587606 | 56245 |
33866 | 33866 | 2021-11-07 | North Carolina | 37 | 1491130 | 18264 |
33867 | 33867 | 2021-11-07 | North Dakota | 38 | 151876 | 1827 |
33868 | 33868 | 2021-11-07 | Northern Mariana Islands | 69 | 343 | 3 |
33869 | 33869 | 2021-11-07 | Ohio | 39 | 1572197 | 25067 |
33870 | 33870 | 2021-11-07 | Oklahoma | 40 | 648209 | 10879 |
33871 | 33871 | 2021-11-07 | Oregon | 41 | 372137 | 4562 |
33872 | 33872 | 2021-11-07 | Pennsylvania | 42 | 1593811 | 31898 |
33873 | 33873 | 2021-11-07 | Puerto Rico | 72 | 219221 | 3245 |
33874 | 33874 | 2021-11-07 | Rhode Island | 44 | 181079 | 2881 |
33875 | 33875 | 2021-11-07 | South Carolina | 45 | 902329 | 13841 |
33876 | 33876 | 2021-11-07 | South Dakota | 46 | 156995 | 2267 |
33877 | 33877 | 2021-11-07 | Tennessee | 47 | 1257642 | 16372 |
33878 | 33878 | 2021-11-07 | Texas | 48 | 4252903 | 72278 |
33879 | 33879 | 2021-11-07 | Utah | 49 | 560717 | 3286 |
33880 | 33880 | 2021-11-07 | Vermont | 50 | 42313 | 384 |
33881 | 33881 | 2021-11-07 | Virgin Islands | 78 | 7275 | 83 |
33882 | 33882 | 2021-11-07 | Virginia | 51 | 933542 | 14125 |
33883 | 33883 | 2021-11-07 | Washington | 53 | 740219 | 8844 |
33884 | 33884 | 2021-11-07 | West Virginia | 54 | 278171 | 4518 |
33885 | 33885 | 2021-11-07 | Wisconsin | 55 | 899804 | 9542 |
33886 | 33886 | 2021-11-07 | Wyoming | 56 | 105318 | 1243 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );