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

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

View and edit SQL

date (date)

  • 2020-04-26 · 55
Link rowid ▼ date state fips cases deaths
2985 2020-04-26 Alabama 1 6421 219
2986 2020-04-26 Alaska 2 339 7
2987 2020-04-26 Arizona 4 6526 277
2988 2020-04-26 Arkansas 5 3001 50
2989 2020-04-26 California 6 43691 1716
2990 2020-04-26 Colorado 8 13440 678
2991 2020-04-26 Connecticut 9 25269 1925
2992 2020-04-26 Delaware 10 4034 120
2993 2020-04-26 District of Columbia 11 3841 178
2994 2020-04-26 Florida 12 31520 1073
2995 2020-04-26 Georgia 13 22459 907
2996 2020-04-26 Guam 66 997 6
2997 2020-04-26 Hawaii 15 599 14
2998 2020-04-26 Idaho 16 1897 56
2999 2020-04-26 Illinois 17 43903 1943
3000 2020-04-26 Indiana 18 15187 928
3001 2020-04-26 Iowa 19 5490 118
3002 2020-04-26 Kansas 20 3198 120
3003 2020-04-26 Kentucky 21 4074 211
3004 2020-04-26 Louisiana 22 26832 1729
3005 2020-04-26 Maine 23 1015 50
3006 2020-04-26 Maryland 24 18664 910
3007 2020-04-26 Massachusetts 25 54938 2899
3008 2020-04-26 Michigan 26 38003 3314
3009 2020-04-26 Minnesota 27 3602 272
3010 2020-04-26 Mississippi 28 5911 227
3011 2020-04-26 Missouri 29 6997 282
3012 2020-04-26 Montana 30 448 14
3013 2020-04-26 Nebraska 31 3126 54
3014 2020-04-26 Nevada 32 4638 206
3015 2020-04-26 New Hampshire 33 1864 60
3016 2020-04-26 New Jersey 34 109038 5938
3017 2020-04-26 New Mexico 35 2728 99
3018 2020-04-26 New York 36 292914 21804
3019 2020-04-26 North Carolina 37 8830 309
3020 2020-04-26 North Dakota 38 867 17
3021 2020-04-26 Northern Mariana Islands 69 14 2
3022 2020-04-26 Ohio 39 15963 728
3023 2020-04-26 Oklahoma 40 3253 195
3024 2020-04-26 Oregon 41 2311 91
3025 2020-04-26 Pennsylvania 42 42709 1871
3026 2020-04-26 Puerto Rico 72 1371 84
3027 2020-04-26 Rhode Island 44 7439 226
3028 2020-04-26 South Carolina 45 5490 174
3029 2020-04-26 South Dakota 46 2213 11
3030 2020-04-26 Tennessee 47 9435 182
3031 2020-04-26 Texas 48 25209 676
3032 2020-04-26 Utah 49 4123 41
3033 2020-04-26 Vermont 50 851 45
3034 2020-04-26 Virgin Islands 78 59 4
3035 2020-04-26 Virginia 51 12969 448
3036 2020-04-26 Washington 53 13744 757
3037 2020-04-26 West Virginia 54 1054 34
3038 2020-04-26 Wisconsin 55 5986 274
3039 2020-04-26 Wyoming 56 502 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
);