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-30 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 |
---|---|---|---|---|---|---|
46991 | 46991 | 2022-06-30 | Alabama | 1 | 1357266 | 19755 |
46992 | 46992 | 2022-06-30 | Alaska | 2 | 270747 | 1246 |
46993 | 46993 | 2022-06-30 | American Samoa | 60 | 6414 | 31 |
46994 | 46994 | 2022-06-30 | Arizona | 4 | 2125567 | 30515 |
46995 | 46995 | 2022-06-30 | Arkansas | 5 | 865592 | 11581 |
46996 | 46996 | 2022-06-30 | California | 6 | 10101062 | 92418 |
46997 | 46997 | 2022-06-30 | Colorado | 8 | 1541065 | 12968 |
46998 | 46998 | 2022-06-30 | Connecticut | 9 | 828968 | 11045 |
46999 | 46999 | 2022-06-30 | Delaware | 10 | 285046 | 2984 |
47000 | 47000 | 2022-06-30 | District of Columbia | 11 | 156802 | 1349 |
47001 | 47001 | 2022-06-30 | Florida | 12 | 6482295 | 75800 |
47002 | 47002 | 2022-06-30 | Georgia | 13 | 2573368 | 37075 |
47003 | 47003 | 2022-06-30 | Guam | 66 | 52867 | 373 |
47004 | 47004 | 2022-06-30 | Hawaii | 15 | 301246 | 1501 |
47005 | 47005 | 2022-06-30 | Idaho | 16 | 463136 | 4975 |
47006 | 47006 | 2022-06-30 | Illinois | 17 | 3436799 | 38588 |
47007 | 47007 | 2022-06-30 | Indiana | 18 | 1772183 | 23877 |
47008 | 47008 | 2022-06-30 | Iowa | 19 | 796611 | 9688 |
47009 | 47009 | 2022-06-30 | Kansas | 20 | 807562 | 8977 |
47010 | 47010 | 2022-06-30 | Kentucky | 21 | 1413121 | 16144 |
47011 | 47011 | 2022-06-30 | Louisiana | 22 | 1308592 | 17412 |
47012 | 47012 | 2022-06-30 | Maine | 23 | 269926 | 2415 |
47013 | 47013 | 2022-06-30 | Maryland | 24 | 1134788 | 14789 |
47014 | 47014 | 2022-06-30 | Massachusetts | 25 | 1924702 | 20944 |
47015 | 47015 | 2022-06-30 | Michigan | 26 | 2606431 | 36918 |
47016 | 47016 | 2022-06-30 | Minnesota | 27 | 1553161 | 13127 |
47017 | 47017 | 2022-06-30 | Mississippi | 28 | 835120 | 12525 |
47018 | 47018 | 2022-06-30 | Missouri | 29 | 1517234 | 20893 |
47019 | 47019 | 2022-06-30 | Montana | 30 | 285619 | 3444 |
47020 | 47020 | 2022-06-30 | Nebraska | 31 | 500056 | 4334 |
47021 | 47021 | 2022-06-30 | Nevada | 32 | 773841 | 11039 |
47022 | 47022 | 2022-06-30 | New Hampshire | 33 | 332120 | 2585 |
47023 | 47023 | 2022-06-30 | New Jersey | 34 | 2488751 | 34049 |
47024 | 47024 | 2022-06-30 | New Mexico | 35 | 563848 | 7943 |
47025 | 47025 | 2022-06-30 | New York | 36 | 5596869 | 68988 |
47026 | 47026 | 2022-06-30 | North Carolina | 37 | 2868188 | 25219 |
47027 | 47027 | 2022-06-30 | North Dakota | 38 | 249770 | 2343 |
47028 | 47028 | 2022-06-30 | Northern Mariana Islands | 69 | 11829 | 35 |
47029 | 47029 | 2022-06-30 | Ohio | 39 | 2848453 | 38852 |
47030 | 47030 | 2022-06-30 | Oklahoma | 40 | 1076350 | 14472 |
47031 | 47031 | 2022-06-30 | Oregon | 41 | 811693 | 7813 |
47032 | 47032 | 2022-06-30 | Pennsylvania | 42 | 3006257 | 45766 |
47033 | 47033 | 2022-06-30 | Puerto Rico | 72 | 806830 | 4571 |
47034 | 47034 | 2022-06-30 | Rhode Island | 44 | 402769 | 3609 |
47035 | 47035 | 2022-06-30 | South Carolina | 45 | 1546406 | 18033 |
47036 | 47036 | 2022-06-30 | South Dakota | 46 | 244523 | 2938 |
47037 | 47037 | 2022-06-30 | Tennessee | 47 | 2069469 | 26400 |
47038 | 47038 | 2022-06-30 | Texas | 48 | 7105390 | 88901 |
47039 | 47039 | 2022-06-30 | Utah | 49 | 983139 | 4834 |
47040 | 47040 | 2022-06-30 | Vermont | 50 | 135668 | 683 |
47041 | 47041 | 2022-06-30 | Virgin Islands | 78 | 20928 | 118 |
47042 | 47042 | 2022-06-30 | Virginia | 51 | 1869231 | 20598 |
47043 | 47043 | 2022-06-30 | Washington | 53 | 1659804 | 13277 |
47044 | 47044 | 2022-06-30 | West Virginia | 54 | 532503 | 7064 |
47045 | 47045 | 2022-06-30 | Wisconsin | 55 | 1726646 | 14797 |
47046 | 47046 | 2022-06-30 | Wyoming | 56 | 164456 | 1834 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );