us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-25
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | date | state | fips | cases | deaths |
|---|---|---|---|---|---|---|
| 2930 | 2930 | 2020-04-25 | Alabama | 1 | 6213 | 213 |
| 2931 | 2931 | 2020-04-25 | Alaska | 2 | 337 | 7 |
| 2932 | 2932 | 2020-04-25 | Arizona | 4 | 6280 | 275 |
| 2933 | 2933 | 2020-04-25 | Arkansas | 5 | 2909 | 48 |
| 2934 | 2934 | 2020-04-25 | California | 6 | 42590 | 1692 |
| 2935 | 2935 | 2020-04-25 | Colorado | 8 | 12967 | 670 |
| 2936 | 2936 | 2020-04-25 | Connecticut | 9 | 24582 | 1862 |
| 2937 | 2937 | 2020-04-25 | Delaware | 10 | 3576 | 112 |
| 2938 | 2938 | 2020-04-25 | District of Columbia | 11 | 3699 | 165 |
| 2939 | 2939 | 2020-04-25 | Florida | 12 | 30831 | 1054 |
| 2940 | 2940 | 2020-04-25 | Georgia | 13 | 22225 | 897 |
| 2941 | 2941 | 2020-04-25 | Guam | 66 | 997 | 6 |
| 2942 | 2942 | 2020-04-25 | Hawaii | 15 | 597 | 14 |
| 2943 | 2943 | 2020-04-25 | Idaho | 16 | 1887 | 56 |
| 2944 | 2944 | 2020-04-25 | Illinois | 17 | 41777 | 1884 |
| 2945 | 2945 | 2020-04-25 | Indiana | 18 | 14567 | 897 |
| 2946 | 2946 | 2020-04-25 | Iowa | 19 | 5109 | 112 |
| 2947 | 2947 | 2020-04-25 | Kansas | 20 | 3091 | 119 |
| 2948 | 2948 | 2020-04-25 | Kentucky | 21 | 3905 | 208 |
| 2949 | 2949 | 2020-04-25 | Louisiana | 22 | 26571 | 1703 |
| 2950 | 2950 | 2020-04-25 | Maine | 23 | 990 | 50 |
| 2951 | 2951 | 2020-04-25 | Maryland | 24 | 17844 | 875 |
| 2952 | 2952 | 2020-04-25 | Massachusetts | 25 | 53348 | 2730 |
| 2953 | 2953 | 2020-04-25 | Michigan | 26 | 37302 | 3273 |
| 2954 | 2954 | 2020-04-25 | Minnesota | 27 | 3446 | 244 |
| 2955 | 2955 | 2020-04-25 | Mississippi | 28 | 5718 | 221 |
| 2956 | 2956 | 2020-04-25 | Missouri | 29 | 6826 | 280 |
| 2957 | 2957 | 2020-04-25 | Montana | 30 | 445 | 14 |
| 2958 | 2958 | 2020-04-25 | Nebraska | 31 | 2898 | 52 |
| 2959 | 2959 | 2020-04-25 | Nevada | 32 | 4539 | 206 |
| 2960 | 2960 | 2020-04-25 | New Hampshire | 33 | 1793 | 60 |
| 2961 | 2961 | 2020-04-25 | New Jersey | 34 | 105523 | 5863 |
| 2962 | 2962 | 2020-04-25 | New Mexico | 35 | 2662 | 93 |
| 2963 | 2963 | 2020-04-25 | New York | 36 | 286901 | 21326 |
| 2964 | 2964 | 2020-04-25 | North Carolina | 37 | 8548 | 304 |
| 2965 | 2965 | 2020-04-25 | North Dakota | 38 | 803 | 16 |
| 2966 | 2966 | 2020-04-25 | Northern Mariana Islands | 69 | 14 | 2 |
| 2967 | 2967 | 2020-04-25 | Ohio | 39 | 15587 | 711 |
| 2968 | 2968 | 2020-04-25 | Oklahoma | 40 | 3193 | 194 |
| 2969 | 2969 | 2020-04-25 | Oregon | 41 | 2253 | 87 |
| 2970 | 2970 | 2020-04-25 | Pennsylvania | 42 | 41626 | 1842 |
| 2971 | 2971 | 2020-04-25 | Puerto Rico | 72 | 1307 | 83 |
| 2972 | 2972 | 2020-04-25 | Rhode Island | 44 | 7129 | 215 |
| 2973 | 2973 | 2020-04-25 | South Carolina | 45 | 5253 | 166 |
| 2974 | 2974 | 2020-04-25 | South Dakota | 46 | 2147 | 10 |
| 2975 | 2975 | 2020-04-25 | Tennessee | 47 | 8918 | 179 |
| 2976 | 2976 | 2020-04-25 | Texas | 48 | 24494 | 662 |
| 2977 | 2977 | 2020-04-25 | Utah | 49 | 3950 | 41 |
| 2978 | 2978 | 2020-04-25 | Vermont | 50 | 843 | 45 |
| 2979 | 2979 | 2020-04-25 | Virgin Islands | 78 | 57 | 4 |
| 2980 | 2980 | 2020-04-25 | Virginia | 51 | 12365 | 436 |
| 2981 | 2981 | 2020-04-25 | Washington | 53 | 13565 | 743 |
| 2982 | 2982 | 2020-04-25 | West Virginia | 54 | 1025 | 33 |
| 2983 | 2983 | 2020-04-25 | Wisconsin | 55 | 5762 | 266 |
| 2984 | 2984 | 2020-04-25 | Wyoming | 56 | 477 | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );