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-06-14 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 |
---|---|---|---|---|---|---|
25755 | 25755 | 2021-06-14 | Alabama | 1 | 547873 | 11274 |
25756 | 25756 | 2021-06-14 | Alaska | 2 | 70132 | 356 |
25757 | 25757 | 2021-06-14 | Arizona | 4 | 887146 | 17768 |
25758 | 25758 | 2021-06-14 | Arkansas | 5 | 344067 | 5863 |
25759 | 25759 | 2021-06-14 | California | 6 | 3803495 | 63150 |
25760 | 25760 | 2021-06-14 | Colorado | 8 | 554283 | 6833 |
25761 | 25761 | 2021-06-14 | Connecticut | 9 | 348465 | 8263 |
25762 | 25762 | 2021-06-14 | Delaware | 10 | 109379 | 1679 |
25763 | 25763 | 2021-06-14 | District of Columbia | 11 | 49179 | 1138 |
25764 | 25764 | 2021-06-14 | Florida | 12 | 2304918 | 37330 |
25765 | 25765 | 2021-06-14 | Georgia | 13 | 1104417 | 20481 |
25766 | 25766 | 2021-06-14 | Guam | 66 | 9213 | 140 |
25767 | 25767 | 2021-06-14 | Hawaii | 15 | 35769 | 503 |
25768 | 25768 | 2021-06-14 | Idaho | 16 | 193821 | 2119 |
25769 | 25769 | 2021-06-14 | Illinois | 17 | 1391785 | 25490 |
25770 | 25770 | 2021-06-14 | Indiana | 18 | 752871 | 13746 |
25771 | 25771 | 2021-06-14 | Iowa | 19 | 372649 | 6102 |
25772 | 25772 | 2021-06-14 | Kansas | 20 | 317613 | 5158 |
25773 | 25773 | 2021-06-14 | Kentucky | 21 | 463531 | 7210 |
25774 | 25774 | 2021-06-14 | Louisiana | 22 | 475908 | 10655 |
25775 | 25775 | 2021-06-14 | Maine | 23 | 68603 | 845 |
25776 | 25776 | 2021-06-14 | Maryland | 24 | 461545 | 9688 |
25777 | 25777 | 2021-06-14 | Massachusetts | 25 | 708933 | 17947 |
25778 | 25778 | 2021-06-14 | Michigan | 26 | 995837 | 20773 |
25779 | 25779 | 2021-06-14 | Minnesota | 27 | 603969 | 7610 |
25780 | 25780 | 2021-06-14 | Mississippi | 28 | 319381 | 7354 |
25781 | 25781 | 2021-06-14 | Missouri | 29 | 622197 | 9806 |
25782 | 25782 | 2021-06-14 | Montana | 30 | 112959 | 1643 |
25783 | 25783 | 2021-06-14 | Nebraska | 31 | 224216 | 2517 |
25784 | 25784 | 2021-06-14 | Nevada | 32 | 327579 | 5626 |
25785 | 25785 | 2021-06-14 | New Hampshire | 33 | 99143 | 1363 |
25786 | 25786 | 2021-06-14 | New Jersey | 34 | 1019794 | 26334 |
25787 | 25787 | 2021-06-14 | New Mexico | 35 | 204271 | 4304 |
25788 | 25788 | 2021-06-14 | New York | 36 | 2107912 | 52977 |
25789 | 25789 | 2021-06-14 | North Carolina | 37 | 1009630 | 13311 |
25790 | 25790 | 2021-06-14 | North Dakota | 38 | 110471 | 1551 |
25791 | 25791 | 2021-06-14 | Northern Mariana Islands | 69 | 183 | 2 |
25792 | 25792 | 2021-06-14 | Ohio | 39 | 1107225 | 20091 |
25793 | 25793 | 2021-06-14 | Oklahoma | 40 | 454884 | 7325 |
25794 | 25794 | 2021-06-14 | Oregon | 41 | 205154 | 2759 |
25795 | 25795 | 2021-06-14 | Pennsylvania | 42 | 1213350 | 27543 |
25796 | 25796 | 2021-06-14 | Puerto Rico | 72 | 173038 | 2530 |
25797 | 25797 | 2021-06-14 | Rhode Island | 44 | 152273 | 2722 |
25798 | 25798 | 2021-06-14 | South Carolina | 45 | 595201 | 9790 |
25799 | 25799 | 2021-06-14 | South Dakota | 46 | 124356 | 2026 |
25800 | 25800 | 2021-06-14 | Tennessee | 47 | 852237 | 12398 |
25801 | 25801 | 2021-06-14 | Texas | 48 | 2972381 | 52116 |
25802 | 25802 | 2021-06-14 | Utah | 49 | 409798 | 2323 |
25803 | 25803 | 2021-06-14 | Vermont | 50 | 24331 | 256 |
25804 | 25804 | 2021-06-14 | Virgin Islands | 78 | 3702 | 28 |
25805 | 25805 | 2021-06-14 | Virginia | 51 | 677812 | 11318 |
25806 | 25806 | 2021-06-14 | Washington | 53 | 446778 | 5825 |
25807 | 25807 | 2021-06-14 | West Virginia | 54 | 163144 | 2853 |
25808 | 25808 | 2021-06-14 | Wisconsin | 55 | 676489 | 8015 |
25809 | 25809 | 2021-06-14 | Wyoming | 56 | 61235 | 725 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );