us-states

Table actions

Data source: Big Local News · About: big-local-datasette

55 rows where "date" is on date 2020-04-23

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-23 · 55 ✖
Link rowid ▼ date state fips cases deaths
2820 2820 2020-04-23 Alabama 1 5832 197
2821 2821 2020-04-23 Alaska 2 335 7
2822 2822 2020-04-23 Arizona 4 5769 257
2823 2823 2020-04-23 Arkansas 5 2599 45
2824 2824 2020-04-23 California 6 39534 1548
2825 2825 2020-04-23 Colorado 8 11262 557
2826 2826 2020-04-23 Connecticut 9 23100 1639
2827 2827 2020-04-23 Delaware 10 3308 92
2828 2828 2020-04-23 District of Columbia 11 3361 139
2829 2829 2020-04-23 Florida 12 29640 986
2830 2830 2020-04-23 Georgia 13 20905 871
2831 2831 2020-04-23 Guam 66 979 6
2832 2832 2020-04-23 Hawaii 15 590 12
2833 2833 2020-04-23 Idaho 16 1836 54
2834 2834 2020-04-23 Illinois 17 36935 1696
2835 2835 2020-04-23 Indiana 18 13196 811
2836 2836 2020-04-23 Iowa 19 3939 96
2837 2837 2020-04-23 Kansas 20 2626 112
2838 2838 2020-04-23 Kentucky 21 3548 194
2839 2839 2020-04-23 Louisiana 22 25798 1599
2840 2840 2020-04-23 Maine 23 937 44
2841 2841 2020-04-23 Maryland 24 15805 748
2842 2842 2020-04-23 Massachusetts 25 46023 2360
2843 2843 2020-04-23 Michigan 26 35253 2977
2844 2844 2020-04-23 Minnesota 27 2942 200
2845 2845 2020-04-23 Mississippi 28 5153 201
2846 2846 2020-04-23 Missouri 29 6321 248
2847 2847 2020-04-23 Montana 30 442 14
2848 2848 2020-04-23 Nebraska 31 2190 46
2849 2849 2020-04-23 Nevada 32 4208 195
2850 2850 2020-04-23 New Hampshire 33 1670 51
2851 2851 2020-04-23 New Jersey 34 99989 5368
2852 2852 2020-04-23 New Mexico 35 2379 78
2853 2853 2020-04-23 New York 36 267932 20212
2854 2854 2020-04-23 North Carolina 37 7608 253
2855 2855 2020-04-23 North Dakota 38 709 15
2856 2856 2020-04-23 Northern Mariana Islands 69 14 2
2857 2857 2020-04-23 Ohio 39 14694 656
2858 2858 2020-04-23 Oklahoma 40 3017 179
2859 2859 2020-04-23 Oregon 41 2127 83
2860 2860 2020-04-23 Pennsylvania 42 38334 1723
2861 2861 2020-04-23 Puerto Rico 72 1230 69
2862 2862 2020-04-23 Rhode Island 44 6256 189
2863 2863 2020-04-23 South Carolina 45 4917 150
2864 2864 2020-04-23 South Dakota 46 1956 9
2865 2865 2020-04-23 Tennessee 47 8169 172
2866 2866 2020-04-23 Texas 48 22706 601
2867 2867 2020-04-23 Utah 49 3621 35
2868 2868 2020-04-23 Vermont 50 825 42
2869 2869 2020-04-23 Virgin Islands 78 54 3
2870 2870 2020-04-23 Virginia 51 10999 375
2871 2871 2020-04-23 Washington 53 12981 717
2872 2872 2020-04-23 West Virginia 54 981 31
2873 2873 2020-04-23 Wisconsin 55 5125 257
2874 2874 2020-04-23 Wyoming 56 453 7

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);