us-states

Table actions
Big Local News snapshots this data daily from https://github.com/nytimes/covid-19-data. This is time series data for U.S. confirmed cases and deaths down to the county level. There are three CSV files released once a day: national-level data, state-level data and county-level data. Each file contains date, county/state name, FIPS code, number of confirmed cases, number of deaths going back to January 21. All data is gathered by New York Times reporters from state and local health departments or official government announcements. The data is updated once a day in the morning, usually around 8 a.m. EDT, with a full day’s worth of data from the day before. Please cite the New York Times as described in the README and check terms of use.

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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date (date)

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