us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-24
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | date | state | fips | cases | deaths |
|---|---|---|---|---|---|---|
| 2875 | 2875 | 2020-04-24 | Alabama | 1 | 6026 | 209 |
| 2876 | 2876 | 2020-04-24 | Alaska | 2 | 337 | 7 |
| 2877 | 2877 | 2020-04-24 | Arizona | 4 | 6045 | 268 |
| 2878 | 2878 | 2020-04-24 | Arkansas | 5 | 2810 | 47 |
| 2879 | 2879 | 2020-04-24 | California | 6 | 41368 | 1619 |
| 2880 | 2880 | 2020-04-24 | Colorado | 8 | 12255 | 672 |
| 2881 | 2881 | 2020-04-24 | Connecticut | 9 | 23921 | 1764 |
| 2882 | 2882 | 2020-04-24 | Delaware | 10 | 3442 | 100 |
| 2883 | 2883 | 2020-04-24 | District of Columbia | 11 | 3528 | 153 |
| 2884 | 2884 | 2020-04-24 | Florida | 12 | 30525 | 1045 |
| 2885 | 2885 | 2020-04-24 | Georgia | 13 | 21575 | 889 |
| 2886 | 2886 | 2020-04-24 | Guam | 66 | 997 | 6 |
| 2887 | 2887 | 2020-04-24 | Hawaii | 15 | 595 | 13 |
| 2888 | 2888 | 2020-04-24 | Idaho | 16 | 1870 | 54 |
| 2889 | 2889 | 2020-04-24 | Illinois | 17 | 39658 | 1804 |
| 2890 | 2890 | 2020-04-24 | Indiana | 18 | 13848 | 851 |
| 2891 | 2891 | 2020-04-24 | Iowa | 19 | 4459 | 107 |
| 2892 | 2892 | 2020-04-24 | Kansas | 20 | 2842 | 117 |
| 2893 | 2893 | 2020-04-24 | Kentucky | 21 | 3779 | 203 |
| 2894 | 2894 | 2020-04-24 | Louisiana | 22 | 26199 | 1660 |
| 2895 | 2895 | 2020-04-24 | Maine | 23 | 965 | 47 |
| 2896 | 2896 | 2020-04-24 | Maryland | 24 | 16693 | 798 |
| 2897 | 2897 | 2020-04-24 | Massachusetts | 25 | 50969 | 2556 |
| 2898 | 2898 | 2020-04-24 | Michigan | 26 | 36628 | 3084 |
| 2899 | 2899 | 2020-04-24 | Minnesota | 27 | 3185 | 221 |
| 2900 | 2900 | 2020-04-24 | Mississippi | 28 | 5434 | 209 |
| 2901 | 2901 | 2020-04-24 | Missouri | 29 | 6625 | 267 |
| 2902 | 2902 | 2020-04-24 | Montana | 30 | 444 | 14 |
| 2903 | 2903 | 2020-04-24 | Nebraska | 31 | 2474 | 50 |
| 2904 | 2904 | 2020-04-24 | Nevada | 32 | 4398 | 203 |
| 2905 | 2905 | 2020-04-24 | New Hampshire | 33 | 1720 | 53 |
| 2906 | 2906 | 2020-04-24 | New Jersey | 34 | 102196 | 5617 |
| 2907 | 2907 | 2020-04-24 | New Mexico | 35 | 2524 | 84 |
| 2908 | 2908 | 2020-04-24 | New York | 36 | 276218 | 20759 |
| 2909 | 2909 | 2020-04-24 | North Carolina | 37 | 8052 | 270 |
| 2910 | 2910 | 2020-04-24 | North Dakota | 38 | 748 | 15 |
| 2911 | 2911 | 2020-04-24 | Northern Mariana Islands | 69 | 14 | 2 |
| 2912 | 2912 | 2020-04-24 | Ohio | 39 | 15169 | 690 |
| 2913 | 2913 | 2020-04-24 | Oklahoma | 40 | 3120 | 188 |
| 2914 | 2914 | 2020-04-24 | Oregon | 41 | 2177 | 86 |
| 2915 | 2915 | 2020-04-24 | Pennsylvania | 42 | 40298 | 1786 |
| 2916 | 2916 | 2020-04-24 | Puerto Rico | 72 | 1276 | 77 |
| 2917 | 2917 | 2020-04-24 | Rhode Island | 44 | 6699 | 202 |
| 2918 | 2918 | 2020-04-24 | South Carolina | 45 | 5070 | 157 |
| 2919 | 2919 | 2020-04-24 | South Dakota | 46 | 2040 | 10 |
| 2920 | 2920 | 2020-04-24 | Tennessee | 47 | 8618 | 172 |
| 2921 | 2921 | 2020-04-24 | Texas | 48 | 23650 | 625 |
| 2922 | 2922 | 2020-04-24 | Utah | 49 | 3782 | 39 |
| 2923 | 2923 | 2020-04-24 | Vermont | 50 | 827 | 43 |
| 2924 | 2924 | 2020-04-24 | Virgin Islands | 78 | 55 | 3 |
| 2925 | 2925 | 2020-04-24 | Virginia | 51 | 11595 | 413 |
| 2926 | 2926 | 2020-04-24 | Washington | 53 | 13197 | 731 |
| 2927 | 2927 | 2020-04-24 | West Virginia | 54 | 1010 | 32 |
| 2928 | 2928 | 2020-04-24 | Wisconsin | 55 | 5431 | 262 |
| 2929 | 2929 | 2020-04-24 | Wyoming | 56 | 473 | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );