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-11-24 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 |
---|---|---|---|---|---|---|
55223 | 55223 | 2022-11-24 | Alabama | 1 | 1545099 | 21112 |
55224 | 55224 | 2022-11-24 | Alaska | 2 | 299841 | 1390 |
55225 | 55225 | 2022-11-24 | American Samoa | 60 | 8262 | 34 |
55226 | 55226 | 2022-11-24 | Arizona | 4 | 2324560 | 31710 |
55227 | 55227 | 2022-11-24 | Arkansas | 5 | 966797 | 12559 |
55228 | 55228 | 2022-11-24 | California | 6 | 11484761 | 99800 |
55229 | 55229 | 2022-11-24 | Colorado | 8 | 1700918 | 13591 |
55230 | 55230 | 2022-11-24 | Connecticut | 9 | 923912 | 11572 |
55231 | 55231 | 2022-11-24 | Delaware | 10 | 316046 | 3172 |
55232 | 55232 | 2022-11-24 | District of Columbia | 11 | 170750 | 1403 |
55233 | 55233 | 2022-11-24 | Florida | 12 | 7195943 | 82875 |
55234 | 55234 | 2022-11-24 | Georgia | 13 | 2851525 | 39596 |
55235 | 55235 | 2022-11-24 | Guam | 66 | 60158 | 408 |
55236 | 55236 | 2022-11-24 | Hawaii | 15 | 357469 | 1729 |
55237 | 55237 | 2022-11-24 | Idaho | 16 | 504887 | 5264 |
55238 | 55238 | 2022-11-24 | Illinois | 17 | 3867743 | 40247 |
55239 | 55239 | 2022-11-24 | Indiana | 18 | 1959422 | 25079 |
55240 | 55240 | 2022-11-24 | Iowa | 19 | 868595 | 10255 |
55241 | 55241 | 2022-11-24 | Kansas | 20 | 898646 | 9794 |
55242 | 55242 | 2022-11-24 | Kentucky | 21 | 1635213 | 17555 |
55243 | 55243 | 2022-11-24 | Louisiana | 22 | 1470441 | 18261 |
55244 | 55244 | 2022-11-24 | Maine | 23 | 300847 | 2750 |
55245 | 55245 | 2022-11-24 | Maryland | 24 | 1284450 | 15786 |
55246 | 55246 | 2022-11-24 | Massachusetts | 25 | 2109719 | 22397 |
55247 | 55247 | 2022-11-24 | Michigan | 26 | 2929612 | 39920 |
55248 | 55248 | 2022-11-24 | Minnesota | 27 | 1707968 | 14039 |
55249 | 55249 | 2022-11-24 | Mississippi | 28 | 936814 | 13047 |
55250 | 55250 | 2022-11-24 | Missouri | 29 | 1705036 | 23037 |
55251 | 55251 | 2022-11-24 | Montana | 30 | 317381 | 3605 |
55252 | 55252 | 2022-11-24 | Nebraska | 31 | 540858 | 4774 |
55253 | 55253 | 2022-11-24 | Nevada | 32 | 859537 | 11749 |
55254 | 55254 | 2022-11-24 | New Hampshire | 33 | 360478 | 2806 |
55255 | 55255 | 2022-11-24 | New Jersey | 34 | 2835549 | 35093 |
55256 | 55256 | 2022-11-24 | New Mexico | 35 | 642634 | 8721 |
55257 | 55257 | 2022-11-24 | New York | 36 | 6340383 | 76618 |
55258 | 55258 | 2022-11-24 | North Carolina | 37 | 3268501 | 28546 |
55259 | 55259 | 2022-11-24 | North Dakota | 38 | 275510 | 2434 |
55260 | 55260 | 2022-11-24 | Northern Mariana Islands | 69 | 13212 | 41 |
55261 | 55261 | 2022-11-24 | Ohio | 39 | 3227759 | 40588 |
55262 | 55262 | 2022-11-24 | Oklahoma | 40 | 1219820 | 15798 |
55263 | 55263 | 2022-11-24 | Oregon | 41 | 920718 | 8831 |
55264 | 55264 | 2022-11-24 | Pennsylvania | 42 | 3350067 | 48355 |
55265 | 55265 | 2022-11-24 | Puerto Rico | 72 | 1039249 | 5350 |
55266 | 55266 | 2022-11-24 | Rhode Island | 44 | 436904 | 3771 |
55267 | 55267 | 2022-11-24 | South Carolina | 45 | 1735351 | 19271 |
55268 | 55268 | 2022-11-24 | South Dakota | 46 | 267689 | 3114 |
55269 | 55269 | 2022-11-24 | Tennessee | 47 | 2324539 | 28011 |
55270 | 55270 | 2022-11-24 | Texas | 48 | 7969340 | 92294 |
55271 | 55271 | 2022-11-24 | Utah | 49 | 1054340 | 5089 |
55272 | 55272 | 2022-11-24 | Vermont | 50 | 146442 | 770 |
55273 | 55273 | 2022-11-24 | Virgin Islands | 78 | 23445 | 124 |
55274 | 55274 | 2022-11-24 | Virginia | 51 | 2143026 | 22468 |
55275 | 55275 | 2022-11-24 | Washington | 53 | 1854190 | 14775 |
55276 | 55276 | 2022-11-24 | West Virginia | 54 | 613165 | 7714 |
55277 | 55277 | 2022-11-24 | Wisconsin | 55 | 1920764 | 15651 |
55278 | 55278 | 2022-11-24 | Wyoming | 56 | 180426 | 1931 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );