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 2020-07-04 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 |
---|---|---|---|---|---|---|
6780 | 6780 | 2020-07-04 | Alabama | 1 | 42862 | 1007 |
6781 | 6781 | 2020-07-04 | Alaska | 2 | 1339 | 14 |
6782 | 6782 | 2020-07-04 | Arizona | 4 | 94616 | 1821 |
6783 | 6783 | 2020-07-04 | Arkansas | 5 | 23209 | 286 |
6784 | 6784 | 2020-07-04 | California | 6 | 265176 | 6329 |
6785 | 6785 | 2020-07-04 | Colorado | 8 | 33900 | 1703 |
6786 | 6786 | 2020-07-04 | Connecticut | 9 | 46717 | 4335 |
6787 | 6787 | 2020-07-04 | Delaware | 10 | 11996 | 512 |
6788 | 6788 | 2020-07-04 | District of Columbia | 11 | 10447 | 557 |
6789 | 6789 | 2020-07-04 | Florida | 12 | 190044 | 3701 |
6790 | 6790 | 2020-07-04 | Georgia | 13 | 87592 | 2809 |
6791 | 6791 | 2020-07-04 | Guam | 66 | 1257 | 6 |
6792 | 6792 | 2020-07-04 | Hawaii | 15 | 981 | 19 |
6793 | 6793 | 2020-07-04 | Idaho | 16 | 7431 | 94 |
6794 | 6794 | 2020-07-04 | Illinois | 17 | 148151 | 7234 |
6795 | 6795 | 2020-07-04 | Indiana | 18 | 48628 | 2687 |
6796 | 6796 | 2020-07-04 | Iowa | 19 | 31167 | 721 |
6797 | 6797 | 2020-07-04 | Kansas | 20 | 16165 | 284 |
6798 | 6798 | 2020-07-04 | Kentucky | 21 | 16709 | 608 |
6799 | 6799 | 2020-07-04 | Louisiana | 22 | 63397 | 3278 |
6800 | 6800 | 2020-07-04 | Maine | 23 | 3397 | 107 |
6801 | 6801 | 2020-07-04 | Maryland | 24 | 69724 | 3236 |
6802 | 6802 | 2020-07-04 | Massachusetts | 25 | 109838 | 8172 |
6803 | 6803 | 2020-07-04 | Michigan | 26 | 72702 | 6222 |
6804 | 6804 | 2020-07-04 | Minnesota | 27 | 37661 | 1503 |
6805 | 6805 | 2020-07-04 | Mississippi | 28 | 30674 | 1107 |
6806 | 6806 | 2020-07-04 | Missouri | 29 | 24061 | 1062 |
6807 | 6807 | 2020-07-04 | Montana | 30 | 1167 | 23 |
6808 | 6808 | 2020-07-04 | Nebraska | 31 | 19826 | 285 |
6809 | 6809 | 2020-07-04 | Nevada | 32 | 21671 | 530 |
6810 | 6810 | 2020-07-04 | New Hampshire | 33 | 5871 | 380 |
6811 | 6811 | 2020-07-04 | New Jersey | 34 | 174889 | 15189 |
6812 | 6812 | 2020-07-04 | New Mexico | 35 | 13063 | 513 |
6813 | 6813 | 2020-07-04 | New York | 36 | 401286 | 31860 |
6814 | 6814 | 2020-07-04 | North Carolina | 37 | 71735 | 1414 |
6815 | 6815 | 2020-07-04 | North Dakota | 38 | 3788 | 89 |
6816 | 6816 | 2020-07-04 | Northern Mariana Islands | 69 | 31 | 2 |
6817 | 6817 | 2020-07-04 | Ohio | 39 | 56183 | 2907 |
6818 | 6818 | 2020-07-04 | Oklahoma | 40 | 15645 | 398 |
6819 | 6819 | 2020-07-04 | Oregon | 41 | 9937 | 216 |
6820 | 6820 | 2020-07-04 | Pennsylvania | 42 | 93922 | 6793 |
6821 | 6821 | 2020-07-04 | Puerto Rico | 72 | 7787 | 155 |
6822 | 6822 | 2020-07-04 | Rhode Island | 44 | 16991 | 960 |
6823 | 6823 | 2020-07-04 | South Carolina | 45 | 43386 | 813 |
6824 | 6824 | 2020-07-04 | South Dakota | 46 | 7028 | 97 |
6825 | 6825 | 2020-07-04 | Tennessee | 47 | 49232 | 630 |
6826 | 6826 | 2020-07-04 | Texas | 48 | 195707 | 2646 |
6827 | 6827 | 2020-07-04 | Utah | 49 | 24717 | 181 |
6828 | 6828 | 2020-07-04 | Vermont | 50 | 1238 | 56 |
6829 | 6829 | 2020-07-04 | Virgin Islands | 78 | 112 | 6 |
6830 | 6830 | 2020-07-04 | Virginia | 51 | 65109 | 1849 |
6831 | 6831 | 2020-07-04 | Washington | 53 | 36799 | 1355 |
6832 | 6832 | 2020-07-04 | West Virginia | 54 | 3205 | 94 |
6833 | 6833 | 2020-07-04 | Wisconsin | 55 | 34243 | 804 |
6834 | 6834 | 2020-07-04 | Wyoming | 56 | 1606 | 20 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );