us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-22
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
2765 | 2765 | 2020-04-22 | Alabama | 1 | 5610 | 201 |
2766 | 2766 | 2020-04-22 | Alaska | 2 | 333 | 7 |
2767 | 2767 | 2020-04-22 | Arizona | 4 | 5459 | 236 |
2768 | 2768 | 2020-04-22 | Arkansas | 5 | 2392 | 44 |
2769 | 2769 | 2020-04-22 | California | 6 | 37573 | 1425 |
2770 | 2770 | 2020-04-22 | Colorado | 8 | 10878 | 526 |
2771 | 2771 | 2020-04-22 | Connecticut | 9 | 22469 | 1544 |
2772 | 2772 | 2020-04-22 | Delaware | 10 | 3200 | 89 |
2773 | 2773 | 2020-04-22 | District of Columbia | 11 | 3206 | 127 |
2774 | 2774 | 2020-04-22 | Florida | 12 | 28301 | 926 |
2775 | 2775 | 2020-04-22 | Georgia | 13 | 20099 | 837 |
2776 | 2776 | 2020-04-22 | Guam | 66 | 911 | 6 |
2777 | 2777 | 2020-04-22 | Hawaii | 15 | 586 | 12 |
2778 | 2778 | 2020-04-22 | Idaho | 16 | 1802 | 54 |
2779 | 2779 | 2020-04-22 | Illinois | 17 | 35108 | 1577 |
2780 | 2780 | 2020-04-22 | Indiana | 18 | 12575 | 764 |
2781 | 2781 | 2020-04-22 | Iowa | 19 | 3764 | 90 |
2782 | 2782 | 2020-04-22 | Kansas | 20 | 2291 | 111 |
2783 | 2783 | 2020-04-22 | Kentucky | 21 | 3373 | 185 |
2784 | 2784 | 2020-04-22 | Louisiana | 22 | 25317 | 1532 |
2785 | 2785 | 2020-04-22 | Maine | 23 | 907 | 39 |
2786 | 2786 | 2020-04-22 | Maryland | 24 | 14842 | 698 |
2787 | 2787 | 2020-04-22 | Massachusetts | 25 | 42944 | 2182 |
2788 | 2788 | 2020-04-22 | Michigan | 26 | 33973 | 2813 |
2789 | 2789 | 2020-04-22 | Minnesota | 27 | 2721 | 179 |
2790 | 2790 | 2020-04-22 | Mississippi | 28 | 4894 | 193 |
2791 | 2791 | 2020-04-22 | Missouri | 29 | 6137 | 236 |
2792 | 2792 | 2020-04-22 | Montana | 30 | 439 | 14 |
2793 | 2793 | 2020-04-22 | Nebraska | 31 | 1826 | 42 |
2794 | 2794 | 2020-04-22 | Nevada | 32 | 4081 | 187 |
2795 | 2795 | 2020-04-22 | New Hampshire | 33 | 1588 | 48 |
2796 | 2796 | 2020-04-22 | New Jersey | 34 | 95865 | 5063 |
2797 | 2797 | 2020-04-22 | New Mexico | 35 | 2210 | 71 |
2798 | 2798 | 2020-04-22 | New York | 36 | 261591 | 19647 |
2799 | 2799 | 2020-04-22 | North Carolina | 37 | 7220 | 242 |
2800 | 2800 | 2020-04-22 | North Dakota | 38 | 679 | 14 |
2801 | 2801 | 2020-04-22 | Northern Mariana Islands | 69 | 14 | 2 |
2802 | 2802 | 2020-04-22 | Ohio | 39 | 14117 | 610 |
2803 | 2803 | 2020-04-22 | Oklahoma | 40 | 2894 | 169 |
2804 | 2804 | 2020-04-22 | Oregon | 41 | 2059 | 78 |
2805 | 2805 | 2020-04-22 | Pennsylvania | 42 | 36763 | 1720 |
2806 | 2806 | 2020-04-22 | Puerto Rico | 72 | 915 | 46 |
2807 | 2807 | 2020-04-22 | Rhode Island | 44 | 5841 | 181 |
2808 | 2808 | 2020-04-22 | South Carolina | 45 | 4761 | 140 |
2809 | 2809 | 2020-04-22 | South Dakota | 46 | 1858 | 9 |
2810 | 2810 | 2020-04-22 | Tennessee | 47 | 7681 | 169 |
2811 | 2811 | 2020-04-22 | Texas | 48 | 21769 | 571 |
2812 | 2812 | 2020-04-22 | Utah | 49 | 3451 | 34 |
2813 | 2813 | 2020-04-22 | Vermont | 50 | 823 | 39 |
2814 | 2814 | 2020-04-22 | Virgin Islands | 78 | 54 | 3 |
2815 | 2815 | 2020-04-22 | Virginia | 51 | 10265 | 349 |
2816 | 2816 | 2020-04-22 | Washington | 53 | 12606 | 696 |
2817 | 2817 | 2020-04-22 | West Virginia | 54 | 939 | 29 |
2818 | 2818 | 2020-04-22 | Wisconsin | 55 | 4915 | 247 |
2819 | 2819 | 2020-04-22 | Wyoming | 56 | 447 | 6 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );