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-05-18 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 |
---|---|---|---|---|---|---|
44583 | 44583 | 2022-05-18 | Alabama | 1 | 1306662 | 19633 |
44584 | 44584 | 2022-05-18 | Alaska | 2 | 256415 | 1246 |
44585 | 44585 | 2022-05-18 | American Samoa | 60 | 5938 | 30 |
44586 | 44586 | 2022-05-18 | Arizona | 4 | 2038129 | 30259 |
44587 | 44587 | 2022-05-18 | Arkansas | 5 | 839433 | 11426 |
44588 | 44588 | 2022-05-18 | California | 6 | 9402566 | 91067 |
44589 | 44589 | 2022-05-18 | Colorado | 8 | 1421004 | 12709 |
44590 | 44590 | 2022-05-18 | Connecticut | 9 | 793615 | 10922 |
44591 | 44591 | 2022-05-18 | Delaware | 10 | 269818 | 2936 |
44592 | 44592 | 2022-05-18 | District of Columbia | 11 | 146163 | 1342 |
44593 | 44593 | 2022-05-18 | Florida | 12 | 6039475 | 74272 |
44594 | 44594 | 2022-05-18 | Georgia | 13 | 2471438 | 36674 |
44595 | 44595 | 2022-05-18 | Guam | 66 | 49580 | 362 |
44596 | 44596 | 2022-05-18 | Hawaii | 15 | 258781 | 1443 |
44597 | 44597 | 2022-05-18 | Idaho | 16 | 448864 | 4939 |
44598 | 44598 | 2022-05-18 | Illinois | 17 | 3242954 | 38041 |
44599 | 44599 | 2022-05-18 | Indiana | 18 | 1718495 | 23640 |
44600 | 44600 | 2022-05-18 | Iowa | 19 | 772205 | 9572 |
44601 | 44601 | 2022-05-18 | Kansas | 20 | 783641 | 8802 |
44602 | 44602 | 2022-05-18 | Kentucky | 21 | 1351450 | 15830 |
44603 | 44603 | 2022-05-18 | Louisiana | 22 | 1247925 | 17307 |
44604 | 44604 | 2022-05-18 | Maine | 23 | 256958 | 2337 |
44605 | 44605 | 2022-05-18 | Maryland | 24 | 1062500 | 14545 |
44606 | 44606 | 2022-05-18 | Massachusetts | 25 | 1830028 | 20453 |
44607 | 44607 | 2022-05-18 | Michigan | 26 | 2495740 | 36176 |
44608 | 44608 | 2022-05-18 | Minnesota | 27 | 1488625 | 12875 |
44609 | 44609 | 2022-05-18 | Mississippi | 28 | 803311 | 12461 |
44610 | 44610 | 2022-05-18 | Missouri | 29 | 1455275 | 20589 |
44611 | 44611 | 2022-05-18 | Montana | 30 | 275681 | 3381 |
44612 | 44612 | 2022-05-18 | Nebraska | 31 | 483133 | 4240 |
44613 | 44613 | 2022-05-18 | Nevada | 32 | 728159 | 10824 |
44614 | 44614 | 2022-05-18 | New Hampshire | 33 | 319827 | 2515 |
44615 | 44615 | 2022-05-18 | New Jersey | 34 | 2335255 | 33586 |
44616 | 44616 | 2022-05-18 | New Mexico | 35 | 528146 | 7652 |
44617 | 44617 | 2022-05-18 | New York | 36 | 5320730 | 68055 |
44618 | 44618 | 2022-05-18 | North Carolina | 37 | 2717011 | 24637 |
44619 | 44619 | 2022-05-18 | North Dakota | 38 | 242893 | 2322 |
44620 | 44620 | 2022-05-18 | Northern Mariana Islands | 69 | 11315 | 34 |
44621 | 44621 | 2022-05-18 | Ohio | 39 | 2724041 | 38550 |
44622 | 44622 | 2022-05-18 | Oklahoma | 40 | 1044868 | 14380 |
44623 | 44623 | 2022-05-18 | Oregon | 41 | 745723 | 7568 |
44624 | 44624 | 2022-05-18 | Pennsylvania | 42 | 2877660 | 44898 |
44625 | 44625 | 2022-05-18 | Puerto Rico | 72 | 646982 | 4277 |
44626 | 44626 | 2022-05-18 | Rhode Island | 44 | 385153 | 3561 |
44627 | 44627 | 2022-05-18 | South Carolina | 45 | 1487728 | 17869 |
44628 | 44628 | 2022-05-18 | South Dakota | 46 | 239110 | 2919 |
44629 | 44629 | 2022-05-18 | Tennessee | 47 | 1995501 | 25997 |
44630 | 44630 | 2022-05-18 | Texas | 48 | 6807050 | 88477 |
44631 | 44631 | 2022-05-18 | Utah | 49 | 939092 | 4761 |
44632 | 44632 | 2022-05-18 | Vermont | 50 | 129854 | 654 |
44633 | 44633 | 2022-05-18 | Virgin Islands | 78 | 18551 | 113 |
44634 | 44634 | 2022-05-18 | Virginia | 51 | 1747607 | 20328 |
44635 | 44635 | 2022-05-18 | Washington | 53 | 1544522 | 12882 |
44636 | 44636 | 2022-05-18 | West Virginia | 54 | 507678 | 6905 |
44637 | 44637 | 2022-05-18 | Wisconsin | 55 | 1649621 | 14514 |
44638 | 44638 | 2022-05-18 | Wyoming | 56 | 157409 | 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 );