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-03-22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
41391 | 41391 | 2022-03-22 | Alabama | 1 | 1291761 | 19139 |
41392 | 41392 | 2022-03-22 | Alaska | 2 | 243672 | 1166 |
41393 | 41393 | 2022-03-22 | American Samoa | 60 | 1565 | 0 |
41394 | 41394 | 2022-03-22 | Arizona | 4 | 1992471 | 28547 |
41395 | 41395 | 2022-03-22 | Arkansas | 5 | 831698 | 11127 |
41396 | 41396 | 2022-03-22 | California | 6 | 9074703 | 88367 |
41397 | 41397 | 2022-03-22 | Colorado | 8 | 1341385 | 12174 |
41398 | 41398 | 2022-03-22 | Connecticut | 9 | 732932 | 10742 |
41399 | 41399 | 2022-03-22 | Delaware | 10 | 258737 | 2835 |
41400 | 41400 | 2022-03-22 | District of Columbia | 11 | 135884 | 1329 |
41401 | 41401 | 2022-03-22 | Florida | 12 | 5836493 | 72828 |
41402 | 41402 | 2022-03-22 | Georgia | 13 | 2414069 | 35212 |
41403 | 41403 | 2022-03-22 | Guam | 66 | 47862 | 341 |
41404 | 41404 | 2022-03-22 | Hawaii | 15 | 232845 | 1365 |
41405 | 41405 | 2022-03-22 | Idaho | 16 | 443124 | 4864 |
41406 | 41406 | 2022-03-22 | Illinois | 17 | 3062600 | 37534 |
41407 | 41407 | 2022-03-22 | Indiana | 18 | 1693377 | 23309 |
41408 | 41408 | 2022-03-22 | Iowa | 19 | 757807 | 9349 |
41409 | 41409 | 2022-03-22 | Kansas | 20 | 770271 | 8179 |
41410 | 41410 | 2022-03-22 | Kentucky | 21 | 1316722 | 14666 |
41411 | 41411 | 2022-03-22 | Louisiana | 22 | 1231393 | 17034 |
41412 | 41412 | 2022-03-22 | Maine | 23 | 233968 | 2188 |
41413 | 41413 | 2022-03-22 | Maryland | 24 | 1009361 | 14303 |
41414 | 41414 | 2022-03-22 | Massachusetts | 25 | 1688534 | 20056 |
41415 | 41415 | 2022-03-22 | Michigan | 26 | 2374455 | 35386 |
41416 | 41416 | 2022-03-22 | Minnesota | 27 | 1426266 | 12550 |
41417 | 41417 | 2022-03-22 | Mississippi | 28 | 793741 | 12368 |
41418 | 41418 | 2022-03-22 | Missouri | 29 | 1424118 | 20034 |
41419 | 41419 | 2022-03-22 | Montana | 30 | 272500 | 3237 |
41420 | 41420 | 2022-03-22 | Nebraska | 31 | 477227 | 4050 |
41421 | 41421 | 2022-03-22 | Nevada | 32 | 711451 | 10016 |
41422 | 41422 | 2022-03-22 | New Hampshire | 33 | 301385 | 2442 |
41423 | 41423 | 2022-03-22 | New Jersey | 34 | 2189639 | 33186 |
41424 | 41424 | 2022-03-22 | New Mexico | 35 | 516661 | 7173 |
41425 | 41425 | 2022-03-22 | New York | 36 | 4949516 | 67218 |
41426 | 41426 | 2022-03-22 | North Carolina | 37 | 2621973 | 23101 |
41427 | 41427 | 2022-03-22 | North Dakota | 38 | 239442 | 2279 |
41428 | 41428 | 2022-03-22 | Northern Mariana Islands | 69 | 10777 | 31 |
41429 | 41429 | 2022-03-22 | Ohio | 39 | 2666030 | 37608 |
41430 | 41430 | 2022-03-22 | Oklahoma | 40 | 1031145 | 13730 |
41431 | 41431 | 2022-03-22 | Oregon | 41 | 701992 | 6983 |
41432 | 41432 | 2022-03-22 | Pennsylvania | 42 | 2775728 | 44091 |
41433 | 41433 | 2022-03-22 | Puerto Rico | 72 | 511403 | 4155 |
41434 | 41434 | 2022-03-22 | Rhode Island | 44 | 359610 | 3431 |
41435 | 41435 | 2022-03-22 | South Carolina | 45 | 1467115 | 17493 |
41436 | 41436 | 2022-03-22 | South Dakota | 46 | 236845 | 2875 |
41437 | 41437 | 2022-03-22 | Tennessee | 47 | 1969898 | 25196 |
41438 | 41438 | 2022-03-22 | Texas | 48 | 6640527 | 87045 |
41439 | 41439 | 2022-03-22 | Utah | 49 | 927098 | 4610 |
41440 | 41440 | 2022-03-22 | Vermont | 50 | 115312 | 613 |
41441 | 41441 | 2022-03-22 | Virgin Islands | 78 | 15589 | 110 |
41442 | 41442 | 2022-03-22 | Virginia | 51 | 1662140 | 19543 |
41443 | 41443 | 2022-03-22 | Washington | 53 | 1447594 | 12421 |
41444 | 41444 | 2022-03-22 | West Virginia | 54 | 496838 | 6660 |
41445 | 41445 | 2022-03-22 | Wisconsin | 55 | 1581742 | 14032 |
41446 | 41446 | 2022-03-22 | Wyoming | 56 | 155988 | 1783 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );