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-10-29 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 |
---|---|---|---|---|---|---|
33327 | 33327 | 2021-10-29 | Alabama | 1 | 831165 | 15532 |
33328 | 33328 | 2021-10-29 | Alaska | 2 | 136975 | 707 |
33329 | 33329 | 2021-10-29 | American Samoa | 60 | 4 | 0 |
33330 | 33330 | 2021-10-29 | Arizona | 4 | 1163217 | 21100 |
33331 | 33331 | 2021-10-29 | Arkansas | 5 | 512530 | 8353 |
33332 | 33332 | 2021-10-29 | California | 6 | 4915206 | 72140 |
33333 | 33333 | 2021-10-29 | Colorado | 8 | 744657 | 8370 |
33334 | 33334 | 2021-10-29 | Connecticut | 9 | 402583 | 8764 |
33335 | 33335 | 2021-10-29 | Delaware | 10 | 143563 | 2089 |
33336 | 33336 | 2021-10-29 | District of Columbia | 11 | 64240 | 1190 |
33337 | 33337 | 2021-10-29 | Florida | 12 | 3647277 | 59670 |
33338 | 33338 | 2021-10-29 | Georgia | 13 | 1598021 | 28038 |
33339 | 33339 | 2021-10-29 | Guam | 66 | 19120 | 239 |
33340 | 33340 | 2021-10-29 | Hawaii | 15 | 81311 | 893 |
33341 | 33341 | 2021-10-29 | Idaho | 16 | 290927 | 3535 |
33342 | 33342 | 2021-10-29 | Illinois | 17 | 1700907 | 28620 |
33343 | 33343 | 2021-10-29 | Indiana | 18 | 1022202 | 16683 |
33344 | 33344 | 2021-10-29 | Iowa | 19 | 483736 | 6965 |
33345 | 33345 | 2021-10-29 | Kansas | 20 | 435701 | 6438 |
33346 | 33346 | 2021-10-29 | Kentucky | 21 | 748786 | 9852 |
33347 | 33347 | 2021-10-29 | Louisiana | 22 | 758471 | 14547 |
33348 | 33348 | 2021-10-29 | Maine | 23 | 103671 | 1163 |
33349 | 33349 | 2021-10-29 | Maryland | 24 | 559994 | 10865 |
33350 | 33350 | 2021-10-29 | Massachusetts | 25 | 851922 | 18996 |
33351 | 33351 | 2021-10-29 | Michigan | 26 | 1272713 | 23638 |
33352 | 33352 | 2021-10-29 | Minnesota | 27 | 787674 | 8793 |
33353 | 33353 | 2021-10-29 | Mississippi | 28 | 504318 | 10075 |
33354 | 33354 | 2021-10-29 | Missouri | 29 | 870554 | 12768 |
33355 | 33355 | 2021-10-29 | Montana | 30 | 176040 | 2346 |
33356 | 33356 | 2021-10-29 | Nebraska | 31 | 283813 | 2954 |
33357 | 33357 | 2021-10-29 | Nevada | 32 | 449322 | 7631 |
33358 | 33358 | 2021-10-29 | New Hampshire | 33 | 134517 | 1565 |
33359 | 33359 | 2021-10-29 | New Jersey | 34 | 1196472 | 27961 |
33360 | 33360 | 2021-10-29 | New Mexico | 35 | 275209 | 5051 |
33361 | 33361 | 2021-10-29 | New York | 36 | 2552009 | 55942 |
33362 | 33362 | 2021-10-29 | North Carolina | 37 | 1479634 | 18068 |
33363 | 33363 | 2021-10-29 | North Dakota | 38 | 147607 | 1792 |
33364 | 33364 | 2021-10-29 | Northern Mariana Islands | 69 | 291 | 3 |
33365 | 33365 | 2021-10-29 | Ohio | 39 | 1539490 | 24527 |
33366 | 33366 | 2021-10-29 | Oklahoma | 40 | 643978 | 10710 |
33367 | 33367 | 2021-10-29 | Oregon | 41 | 365053 | 4372 |
33368 | 33368 | 2021-10-29 | Pennsylvania | 42 | 1557459 | 31377 |
33369 | 33369 | 2021-10-29 | Puerto Rico | 72 | 218217 | 3229 |
33370 | 33370 | 2021-10-29 | Rhode Island | 44 | 179405 | 2878 |
33371 | 33371 | 2021-10-29 | South Carolina | 45 | 897152 | 13716 |
33372 | 33372 | 2021-10-29 | South Dakota | 46 | 154482 | 2235 |
33373 | 33373 | 2021-10-29 | Tennessee | 47 | 1251111 | 16216 |
33374 | 33374 | 2021-10-29 | Texas | 48 | 4227048 | 71404 |
33375 | 33375 | 2021-10-29 | Utah | 49 | 549998 | 3208 |
33376 | 33376 | 2021-10-29 | Vermont | 50 | 39788 | 364 |
33377 | 33377 | 2021-10-29 | Virgin Islands | 78 | 7204 | 81 |
33378 | 33378 | 2021-10-29 | Virginia | 51 | 924771 | 13907 |
33379 | 33379 | 2021-10-29 | Washington | 53 | 727761 | 8686 |
33380 | 33380 | 2021-10-29 | West Virginia | 54 | 270984 | 4426 |
33381 | 33381 | 2021-10-29 | Wisconsin | 55 | 882618 | 9416 |
33382 | 33382 | 2021-10-29 | Wyoming | 56 | 102926 | 1174 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );