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-09-12 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 |
---|---|---|---|---|---|---|
51135 | 51135 | 2022-09-12 | Alabama | 1 | 1508308 | 20288 |
51136 | 51136 | 2022-09-12 | Alaska | 2 | 293914 | 1297 |
51137 | 51137 | 2022-09-12 | American Samoa | 60 | 8217 | 34 |
51138 | 51138 | 2022-09-12 | Arizona | 4 | 2258040 | 31162 |
51139 | 51139 | 2022-09-12 | Arkansas | 5 | 942084 | 11961 |
51140 | 51140 | 2022-09-12 | California | 6 | 11168261 | 95459 |
51141 | 51141 | 2022-09-12 | Colorado | 8 | 1647638 | 13414 |
51142 | 51142 | 2022-09-12 | Connecticut | 9 | 881831 | 11299 |
51143 | 51143 | 2022-09-12 | Delaware | 10 | 304962 | 3080 |
51144 | 51144 | 2022-09-12 | District of Columbia | 11 | 166893 | 1382 |
51145 | 51145 | 2022-09-12 | Florida | 12 | 7075348 | 80562 |
51146 | 51146 | 2022-09-12 | Georgia | 13 | 2800323 | 38318 |
51147 | 51147 | 2022-09-12 | Guam | 66 | 59238 | 395 |
51148 | 51148 | 2022-09-12 | Hawaii | 15 | 332278 | 1652 |
51149 | 51149 | 2022-09-12 | Idaho | 16 | 492127 | 5134 |
51150 | 51150 | 2022-09-12 | Illinois | 17 | 3729492 | 39461 |
51151 | 51151 | 2022-09-12 | Indiana | 18 | 1910442 | 24549 |
51152 | 51152 | 2022-09-12 | Iowa | 19 | 848811 | 9968 |
51153 | 51153 | 2022-09-12 | Kansas | 20 | 869362 | 9051 |
51154 | 51154 | 2022-09-12 | Kentucky | 21 | 1574603 | 16822 |
51155 | 51155 | 2022-09-12 | Louisiana | 22 | 1444771 | 17931 |
51156 | 51156 | 2022-09-12 | Maine | 23 | 284881 | 2551 |
51157 | 51157 | 2022-09-12 | Maryland | 24 | 1233359 | 15257 |
51158 | 51158 | 2022-09-12 | Massachusetts | 25 | 2021331 | 21536 |
51159 | 51159 | 2022-09-12 | Michigan | 26 | 2786213 | 38121 |
51160 | 51160 | 2022-09-12 | Minnesota | 27 | 1645653 | 13509 |
51161 | 51161 | 2022-09-12 | Mississippi | 28 | 918874 | 12821 |
51162 | 51162 | 2022-09-12 | Missouri | 29 | 1646441 | 21549 |
51163 | 51163 | 2022-09-12 | Montana | 30 | 306981 | 3509 |
51164 | 51164 | 2022-09-12 | Nebraska | 31 | 533046 | 4488 |
51165 | 51165 | 2022-09-12 | Nevada | 32 | 844029 | 11426 |
51166 | 51166 | 2022-09-12 | New Hampshire | 33 | 346496 | 2671 |
51167 | 51167 | 2022-09-12 | New Jersey | 34 | 2698348 | 34632 |
51168 | 51168 | 2022-09-12 | New Mexico | 35 | 614669 | 8487 |
51169 | 51169 | 2022-09-12 | New York | 36 | 6023808 | 70643 |
51170 | 51170 | 2022-09-12 | North Carolina | 37 | 3141302 | 26375 |
51171 | 51171 | 2022-09-12 | North Dakota | 38 | 266273 | 2401 |
51172 | 51172 | 2022-09-12 | Northern Mariana Islands | 69 | 13155 | 40 |
51173 | 51173 | 2022-09-12 | Ohio | 39 | 3096557 | 39576 |
51174 | 51174 | 2022-09-12 | Oklahoma | 40 | 1184662 | 14765 |
51175 | 51175 | 2022-09-12 | Oregon | 41 | 884547 | 8479 |
51176 | 51176 | 2022-09-12 | Pennsylvania | 42 | 3203488 | 46831 |
51177 | 51177 | 2022-09-12 | Puerto Rico | 72 | 976163 | 5034 |
51178 | 51178 | 2022-09-12 | Rhode Island | 44 | 420175 | 3652 |
51179 | 51179 | 2022-09-12 | South Carolina | 45 | 1687640 | 18299 |
51180 | 51180 | 2022-09-12 | South Dakota | 46 | 258510 | 3002 |
51181 | 51181 | 2022-09-12 | Tennessee | 47 | 2259376 | 27257 |
51182 | 51182 | 2022-09-12 | Texas | 48 | 7815931 | 90615 |
51183 | 51183 | 2022-09-12 | Utah | 49 | 1032402 | 4989 |
51184 | 51184 | 2022-09-12 | Vermont | 50 | 140740 | 715 |
51185 | 51185 | 2022-09-12 | Virgin Islands | 78 | 22970 | 123 |
51186 | 51186 | 2022-09-12 | Virginia | 51 | 2062984 | 21610 |
51187 | 51187 | 2022-09-12 | Washington | 53 | 1796343 | 14195 |
51188 | 51188 | 2022-09-12 | West Virginia | 54 | 592324 | 7334 |
51189 | 51189 | 2022-09-12 | Wisconsin | 55 | 1846100 | 15138 |
51190 | 51190 | 2022-09-12 | Wyoming | 56 | 175290 | 1884 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );