ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-02-01 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
18440 | 18440 | 2021-02-01 | Alabama | 1 | 460860 | 7688 |
18441 | 18441 | 2021-02-01 | Alaska | 2 | 54091 | 253 |
18442 | 18442 | 2021-02-01 | Arizona | 4 | 762458 | 13124 |
18443 | 18443 | 2021-02-01 | Arkansas | 5 | 296494 | 4895 |
18444 | 18444 | 2021-02-01 | California | 6 | 3341656 | 41284 |
18445 | 18445 | 2021-02-01 | Colorado | 8 | 399384 | 5737 |
18446 | 18446 | 2021-02-01 | Connecticut | 9 | 253954 | 7119 |
18447 | 18447 | 2021-02-01 | Delaware | 10 | 78495 | 1101 |
18448 | 18448 | 2021-02-01 | District of Columbia | 11 | 37008 | 916 |
18449 | 18449 | 2021-02-01 | Florida | 12 | 1727099 | 26684 |
18450 | 18450 | 2021-02-01 | Georgia | 13 | 888462 | 13821 |
18451 | 18451 | 2021-02-01 | Guam | 66 | 8577 | 130 |
18452 | 18452 | 2021-02-01 | Hawaii | 15 | 25870 | 407 |
18453 | 18453 | 2021-02-01 | Idaho | 16 | 163291 | 1737 |
18454 | 18454 | 2021-02-01 | Illinois | 17 | 1131212 | 21273 |
18455 | 18455 | 2021-02-01 | Indiana | 18 | 631502 | 9989 |
18456 | 18456 | 2021-02-01 | Iowa | 19 | 320187 | 4906 |
18457 | 18457 | 2021-02-01 | Kansas | 20 | 279587 | 3809 |
18458 | 18458 | 2021-02-01 | Kentucky | 21 | 368623 | 3995 |
18459 | 18459 | 2021-02-01 | Louisiana | 22 | 401591 | 8912 |
18460 | 18460 | 2021-02-01 | Maine | 23 | 39543 | 595 |
18461 | 18461 | 2021-02-01 | Maryland | 24 | 355812 | 7154 |
18462 | 18462 | 2021-02-01 | Massachusetts | 25 | 526423 | 14607 |
18463 | 18463 | 2021-02-01 | Michigan | 26 | 610524 | 15527 |
18464 | 18464 | 2021-02-01 | Minnesota | 27 | 462596 | 6270 |
18465 | 18465 | 2021-02-01 | Mississippi | 28 | 275706 | 6056 |
18466 | 18466 | 2021-02-01 | Missouri | 29 | 501226 | 7182 |
18467 | 18467 | 2021-02-01 | Montana | 30 | 94146 | 1235 |
18468 | 18468 | 2021-02-01 | Nebraska | 31 | 192112 | 2031 |
18469 | 18469 | 2021-02-01 | Nevada | 32 | 279228 | 4281 |
18470 | 18470 | 2021-02-01 | New Hampshire | 33 | 66058 | 1059 |
18471 | 18471 | 2021-02-01 | New Jersey | 34 | 700346 | 21513 |
18472 | 18472 | 2021-02-01 | New Mexico | 35 | 174550 | 3297 |
18473 | 18473 | 2021-02-01 | New York | 36 | 1429096 | 43354 |
18474 | 18474 | 2021-02-01 | North Carolina | 37 | 763358 | 9397 |
18475 | 18475 | 2021-02-01 | North Dakota | 38 | 97708 | 1447 |
18476 | 18476 | 2021-02-01 | Northern Mariana Islands | 69 | 131 | 2 |
18477 | 18477 | 2021-02-01 | Ohio | 39 | 899079 | 11233 |
18478 | 18478 | 2021-02-01 | Oklahoma | 40 | 390868 | 3564 |
18479 | 18479 | 2021-02-01 | Oregon | 41 | 143373 | 1980 |
18480 | 18480 | 2021-02-01 | Pennsylvania | 42 | 851911 | 21741 |
18481 | 18481 | 2021-02-01 | Puerto Rico | 72 | 127853 | 1836 |
18482 | 18482 | 2021-02-01 | Rhode Island | 44 | 115956 | 2173 |
18483 | 18483 | 2021-02-01 | South Carolina | 45 | 445916 | 7283 |
18484 | 18484 | 2021-02-01 | South Dakota | 46 | 108315 | 1778 |
18485 | 18485 | 2021-02-01 | Tennessee | 47 | 715439 | 9660 |
18486 | 18486 | 2021-02-01 | Texas | 48 | 2412150 | 37405 |
18487 | 18487 | 2021-02-01 | Utah | 49 | 347210 | 1669 |
18488 | 18488 | 2021-02-01 | Vermont | 50 | 12083 | 175 |
18489 | 18489 | 2021-02-01 | Virgin Islands | 78 | 2421 | 24 |
18490 | 18490 | 2021-02-01 | Virginia | 51 | 507640 | 6474 |
18491 | 18491 | 2021-02-01 | Washington | 53 | 317703 | 4404 |
18492 | 18492 | 2021-02-01 | West Virginia | 54 | 121425 | 2028 |
18493 | 18493 | 2021-02-01 | Wisconsin | 55 | 592921 | 6439 |
18494 | 18494 | 2021-02-01 | Wyoming | 56 | 52057 | 596 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );