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-29 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 |
---|---|---|---|---|---|---|
50351 | 50351 | 2022-08-29 | Alabama | 1 | 1479605 | 20048 |
50352 | 50352 | 2022-08-29 | Alaska | 2 | 291395 | 1297 |
50353 | 50353 | 2022-08-29 | American Samoa | 60 | 7471 | 33 |
50354 | 50354 | 2022-08-29 | Arizona | 4 | 2245713 | 31047 |
50355 | 50355 | 2022-08-29 | Arkansas | 5 | 930076 | 11905 |
50356 | 50356 | 2022-08-29 | California | 6 | 11060838 | 94947 |
50357 | 50357 | 2022-08-29 | Colorado | 8 | 1635675 | 13349 |
50358 | 50358 | 2022-08-29 | Connecticut | 9 | 873420 | 11197 |
50359 | 50359 | 2022-08-29 | Delaware | 10 | 302387 | 3042 |
50360 | 50360 | 2022-08-29 | District of Columbia | 11 | 165774 | 1381 |
50361 | 50361 | 2022-08-29 | Florida | 12 | 7012997 | 79782 |
50362 | 50362 | 2022-08-29 | Georgia | 13 | 2770924 | 38080 |
50363 | 50363 | 2022-08-29 | Guam | 66 | 58784 | 390 |
50364 | 50364 | 2022-08-29 | Hawaii | 15 | 329351 | 1629 |
50365 | 50365 | 2022-08-29 | Idaho | 16 | 488657 | 5112 |
50366 | 50366 | 2022-08-29 | Illinois | 17 | 3684755 | 39296 |
50367 | 50367 | 2022-08-29 | Indiana | 18 | 1891405 | 24411 |
50368 | 50368 | 2022-08-29 | Iowa | 19 | 839808 | 9907 |
50369 | 50369 | 2022-08-29 | Kansas | 20 | 859190 | 8976 |
50370 | 50370 | 2022-08-29 | Kentucky | 21 | 1551233 | 16679 |
50371 | 50371 | 2022-08-29 | Louisiana | 22 | 1426314 | 17854 |
50372 | 50372 | 2022-08-29 | Maine | 23 | 282106 | 2508 |
50373 | 50373 | 2022-08-29 | Maryland | 24 | 1219871 | 15159 |
50374 | 50374 | 2022-08-29 | Massachusetts | 25 | 2005250 | 21390 |
50375 | 50375 | 2022-08-29 | Michigan | 26 | 2751201 | 37909 |
50376 | 50376 | 2022-08-29 | Minnesota | 27 | 1630819 | 13429 |
50377 | 50377 | 2022-08-29 | Mississippi | 28 | 904905 | 12766 |
50378 | 50378 | 2022-08-29 | Missouri | 29 | 1626774 | 21428 |
50379 | 50379 | 2022-08-29 | Montana | 30 | 304449 | 3504 |
50380 | 50380 | 2022-08-29 | Nebraska | 31 | 527989 | 4455 |
50381 | 50381 | 2022-08-29 | Nevada | 32 | 839977 | 11379 |
50382 | 50382 | 2022-08-29 | New Hampshire | 33 | 344070 | 2657 |
50383 | 50383 | 2022-08-29 | New Jersey | 34 | 2673997 | 34532 |
50384 | 50384 | 2022-08-29 | New Mexico | 35 | 610439 | 8421 |
50385 | 50385 | 2022-08-29 | New York | 36 | 5968639 | 70330 |
50386 | 50386 | 2022-08-29 | North Carolina | 37 | 3098923 | 25853 |
50387 | 50387 | 2022-08-29 | North Dakota | 38 | 264130 | 2395 |
50388 | 50388 | 2022-08-29 | Northern Mariana Islands | 69 | 13120 | 40 |
50389 | 50389 | 2022-08-29 | Ohio | 39 | 3049546 | 39406 |
50390 | 50390 | 2022-08-29 | Oklahoma | 40 | 1166900 | 14670 |
50391 | 50391 | 2022-08-29 | Oregon | 41 | 876798 | 8392 |
50392 | 50392 | 2022-08-29 | Pennsylvania | 42 | 3167638 | 46596 |
50393 | 50393 | 2022-08-29 | Puerto Rico | 72 | 954798 | 4955 |
50394 | 50394 | 2022-08-29 | Rhode Island | 44 | 416638 | 3643 |
50395 | 50395 | 2022-08-29 | South Carolina | 45 | 1661020 | 18245 |
50396 | 50396 | 2022-08-29 | South Dakota | 46 | 256255 | 2984 |
50397 | 50397 | 2022-08-29 | Tennessee | 47 | 2231415 | 27145 |
50398 | 50398 | 2022-08-29 | Texas | 48 | 7719024 | 90312 |
50399 | 50399 | 2022-08-29 | Utah | 49 | 1027083 | 4968 |
50400 | 50400 | 2022-08-29 | Vermont | 50 | 139769 | 707 |
50401 | 50401 | 2022-08-29 | Virgin Islands | 78 | 22622 | 122 |
50402 | 50402 | 2022-08-29 | Virginia | 51 | 2034647 | 21374 |
50403 | 50403 | 2022-08-29 | Washington | 53 | 1783142 | 14051 |
50404 | 50404 | 2022-08-29 | West Virginia | 54 | 580697 | 7274 |
50405 | 50405 | 2022-08-29 | Wisconsin | 55 | 1829230 | 15059 |
50406 | 50406 | 2022-08-29 | Wyoming | 56 | 174213 | 1877 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );