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-06-03 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
45479 | 45479 | 2022-06-03 | Alabama | 1 | 1317029 | 19664 |
45480 | 45480 | 2022-06-03 | Alaska | 2 | 260440 | 1246 |
45481 | 45481 | 2022-06-03 | American Samoa | 60 | 6192 | 31 |
45482 | 45482 | 2022-06-03 | Arizona | 4 | 2062669 | 30332 |
45483 | 45483 | 2022-06-03 | Arkansas | 5 | 845175 | 11498 |
45484 | 45484 | 2022-06-03 | California | 6 | 9661160 | 91660 |
45485 | 45485 | 2022-06-03 | Colorado | 8 | 1462079 | 12770 |
45486 | 45486 | 2022-06-03 | Connecticut | 9 | 811932 | 10973 |
45487 | 45487 | 2022-06-03 | Delaware | 10 | 277666 | 2961 |
45488 | 45488 | 2022-06-03 | District of Columbia | 11 | 150783 | 1346 |
45489 | 45489 | 2022-06-03 | Florida | 12 | 6196905 | 74588 |
45490 | 45490 | 2022-06-03 | Georgia | 13 | 2499711 | 36758 |
45491 | 45491 | 2022-06-03 | Guam | 66 | 50293 | 365 |
45492 | 45492 | 2022-06-03 | Hawaii | 15 | 275631 | 1454 |
45493 | 45493 | 2022-06-03 | Idaho | 16 | 453019 | 4944 |
45494 | 45494 | 2022-06-03 | Illinois | 17 | 3324779 | 38188 |
45495 | 45495 | 2022-06-03 | Indiana | 18 | 1738843 | 23712 |
45496 | 45496 | 2022-06-03 | Iowa | 19 | 780447 | 9603 |
45497 | 45497 | 2022-06-03 | Kansas | 20 | 789962 | 8963 |
45498 | 45498 | 2022-06-03 | Kentucky | 21 | 1368497 | 15945 |
45499 | 45499 | 2022-06-03 | Louisiana | 22 | 1265225 | 17341 |
45500 | 45500 | 2022-06-03 | Maine | 23 | 264051 | 2366 |
45501 | 45501 | 2022-06-03 | Maryland | 24 | 1096170 | 14629 |
45502 | 45502 | 2022-06-03 | Massachusetts | 25 | 1879517 | 20663 |
45503 | 45503 | 2022-06-03 | Michigan | 26 | 2547366 | 36407 |
45504 | 45504 | 2022-06-03 | Minnesota | 27 | 1516034 | 12974 |
45505 | 45505 | 2022-06-03 | Mississippi | 28 | 810484 | 12470 |
45506 | 45506 | 2022-06-03 | Missouri | 29 | 1479074 | 20791 |
45507 | 45507 | 2022-06-03 | Montana | 30 | 279390 | 3423 |
45508 | 45508 | 2022-06-03 | Nebraska | 31 | 488110 | 4294 |
45509 | 45509 | 2022-06-03 | Nevada | 32 | 743031 | 10906 |
45510 | 45510 | 2022-06-03 | New Hampshire | 33 | 326610 | 2543 |
45511 | 45511 | 2022-06-03 | New Jersey | 34 | 2407649 | 33755 |
45512 | 45512 | 2022-06-03 | New Mexico | 35 | 538629 | 7825 |
45513 | 45513 | 2022-06-03 | New York | 36 | 5448458 | 68440 |
45514 | 45514 | 2022-06-03 | North Carolina | 37 | 2774365 | 24663 |
45515 | 45515 | 2022-06-03 | North Dakota | 38 | 245476 | 2330 |
45516 | 45516 | 2022-06-03 | Northern Mariana Islands | 69 | 11366 | 34 |
45517 | 45517 | 2022-06-03 | Ohio | 39 | 2780653 | 38657 |
45518 | 45518 | 2022-06-03 | Oklahoma | 40 | 1052091 | 14437 |
45519 | 45519 | 2022-06-03 | Oregon | 41 | 770194 | 7657 |
45520 | 45520 | 2022-06-03 | Pennsylvania | 42 | 2936121 | 45283 |
45521 | 45521 | 2022-06-03 | Puerto Rico | 72 | 716355 | 4390 |
45522 | 45522 | 2022-06-03 | Rhode Island | 44 | 394573 | 3583 |
45523 | 45523 | 2022-06-03 | South Carolina | 45 | 1504967 | 17907 |
45524 | 45524 | 2022-06-03 | South Dakota | 46 | 240357 | 2928 |
45525 | 45525 | 2022-06-03 | Tennessee | 47 | 2018350 | 26220 |
45526 | 45526 | 2022-06-03 | Texas | 48 | 6887992 | 88591 |
45527 | 45527 | 2022-06-03 | Utah | 49 | 954938 | 4781 |
45528 | 45528 | 2022-06-03 | Vermont | 50 | 132676 | 670 |
45529 | 45529 | 2022-06-03 | Virgin Islands | 78 | 20039 | 113 |
45530 | 45530 | 2022-06-03 | Virginia | 51 | 1797700 | 20424 |
45531 | 45531 | 2022-06-03 | Washington | 53 | 1592579 | 13012 |
45532 | 45532 | 2022-06-03 | West Virginia | 54 | 518061 | 6974 |
45533 | 45533 | 2022-06-03 | Wisconsin | 55 | 1683270 | 14639 |
45534 | 45534 | 2022-06-03 | Wyoming | 56 | 158472 | 1820 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );