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-03 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 |
---|---|---|---|---|---|---|
43743 | 43743 | 2022-05-03 | Alabama | 1 | 1301463 | 19585 |
43744 | 43744 | 2022-05-03 | Alaska | 2 | 251388 | 1212 |
43745 | 43745 | 2022-05-03 | American Samoa | 60 | 5793 | 26 |
43746 | 43746 | 2022-05-03 | Arizona | 4 | 2021524 | 29951 |
43747 | 43747 | 2022-05-03 | Arkansas | 5 | 836117 | 11398 |
43748 | 43748 | 2022-05-03 | California | 6 | 9261139 | 90541 |
43749 | 43749 | 2022-05-03 | Colorado | 8 | 1393109 | 12602 |
43750 | 43750 | 2022-05-03 | Connecticut | 9 | 762097 | 10855 |
43751 | 43751 | 2022-05-03 | Delaware | 10 | 263269 | 2919 |
43752 | 43752 | 2022-05-03 | District of Columbia | 11 | 141943 | 1340 |
43753 | 43753 | 2022-05-03 | Florida | 12 | 5941724 | 74010 |
43754 | 43754 | 2022-05-03 | Georgia | 13 | 2445607 | 36349 |
43755 | 43755 | 2022-05-03 | Guam | 66 | 49223 | 355 |
43756 | 43756 | 2022-05-03 | Hawaii | 15 | 241955 | 1415 |
43757 | 43757 | 2022-05-03 | Idaho | 16 | 446330 | 4930 |
43758 | 43758 | 2022-05-03 | Illinois | 17 | 3157387 | 37919 |
43759 | 43759 | 2022-05-03 | Indiana | 18 | 1703579 | 23591 |
43760 | 43760 | 2022-05-03 | Iowa | 19 | 764451 | 9529 |
43761 | 43761 | 2022-05-03 | Kansas | 20 | 776917 | 8635 |
43762 | 43762 | 2022-05-03 | Kentucky | 21 | 1339430 | 15571 |
43763 | 43763 | 2022-05-03 | Louisiana | 22 | 1239063 | 17268 |
43764 | 43764 | 2022-05-03 | Maine | 23 | 247069 | 2291 |
43765 | 43765 | 2022-05-03 | Maryland | 24 | 1035272 | 14477 |
43766 | 43766 | 2022-05-03 | Massachusetts | 25 | 1766821 | 20292 |
43767 | 43767 | 2022-05-03 | Michigan | 26 | 2425946 | 36002 |
43768 | 43768 | 2022-05-03 | Minnesota | 27 | 1457048 | 12782 |
43769 | 43769 | 2022-05-03 | Mississippi | 28 | 798065 | 12450 |
43770 | 43770 | 2022-05-03 | Missouri | 29 | 1435912 | 20215 |
43771 | 43771 | 2022-05-03 | Montana | 30 | 274506 | 3375 |
43772 | 43772 | 2022-05-03 | Nebraska | 31 | 480422 | 4201 |
43773 | 43773 | 2022-05-03 | Nevada | 32 | 719817 | 10777 |
43774 | 43774 | 2022-05-03 | New Hampshire | 33 | 311625 | 2486 |
43775 | 43775 | 2022-05-03 | New Jersey | 34 | 2269649 | 33455 |
43776 | 43776 | 2022-05-03 | New Mexico | 35 | 523023 | 7530 |
43777 | 43777 | 2022-05-03 | New York | 36 | 5172487 | 67727 |
43778 | 43778 | 2022-05-03 | North Carolina | 37 | 2661765 | 23415 |
43779 | 43779 | 2022-05-03 | North Dakota | 38 | 241271 | 2315 |
43780 | 43780 | 2022-05-03 | Northern Mariana Islands | 69 | 11263 | 34 |
43781 | 43781 | 2022-05-03 | Ohio | 39 | 2697058 | 38428 |
43782 | 43782 | 2022-05-03 | Oklahoma | 40 | 1041397 | 14271 |
43783 | 43783 | 2022-05-03 | Oregon | 41 | 725150 | 7511 |
43784 | 43784 | 2022-05-03 | Pennsylvania | 42 | 2825267 | 44713 |
43785 | 43785 | 2022-05-03 | Puerto Rico | 72 | 579607 | 4215 |
43786 | 43786 | 2022-05-03 | Rhode Island | 44 | 373437 | 3541 |
43787 | 43787 | 2022-05-03 | South Carolina | 45 | 1477345 | 17847 |
43788 | 43788 | 2022-05-03 | South Dakota | 46 | 237812 | 2912 |
43789 | 43789 | 2022-05-03 | Tennessee | 47 | 1983100 | 25899 |
43790 | 43790 | 2022-05-03 | Texas | 48 | 6758486 | 88324 |
43791 | 43791 | 2022-05-03 | Utah | 49 | 932480 | 4747 |
43792 | 43792 | 2022-05-03 | Vermont | 50 | 124830 | 639 |
43793 | 43793 | 2022-05-03 | Virgin Islands | 78 | 16391 | 111 |
43794 | 43794 | 2022-05-03 | Virginia | 51 | 1707085 | 20247 |
43795 | 43795 | 2022-05-03 | Washington | 53 | 1510618 | 12750 |
43796 | 43796 | 2022-05-03 | West Virginia | 54 | 501968 | 6870 |
43797 | 43797 | 2022-05-03 | Wisconsin | 55 | 1615334 | 14424 |
43798 | 43798 | 2022-05-03 | Wyoming | 56 | 156745 | 1814 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );