us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-08
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
1995 | 1995 | 2020-04-08 | Alabama | 1 | 2498 | 67 |
1996 | 1996 | 2020-04-08 | Alaska | 2 | 224 | 5 |
1997 | 1997 | 2020-04-08 | Arizona | 4 | 2726 | 80 |
1998 | 1998 | 2020-04-08 | Arkansas | 5 | 1077 | 18 |
1999 | 1999 | 2020-04-08 | California | 6 | 19043 | 506 |
2000 | 2000 | 2020-04-08 | Colorado | 8 | 5655 | 192 |
2001 | 2001 | 2020-04-08 | Connecticut | 9 | 8781 | 335 |
2002 | 2002 | 2020-04-08 | Delaware | 10 | 1116 | 19 |
2003 | 2003 | 2020-04-08 | District of Columbia | 11 | 1440 | 27 |
2004 | 2004 | 2020-04-08 | Florida | 12 | 15690 | 322 |
2005 | 2005 | 2020-04-08 | Georgia | 13 | 10204 | 370 |
2006 | 2006 | 2020-04-08 | Guam | 66 | 409 | 4 |
2007 | 2007 | 2020-04-08 | Hawaii | 15 | 433 | 5 |
2008 | 2008 | 2020-04-08 | Idaho | 16 | 1232 | 19 |
2009 | 2009 | 2020-04-08 | Illinois | 17 | 15078 | 464 |
2010 | 2010 | 2020-04-08 | Indiana | 18 | 5986 | 246 |
2011 | 2011 | 2020-04-08 | Iowa | 19 | 1145 | 27 |
2012 | 2012 | 2020-04-08 | Kansas | 20 | 1055 | 38 |
2013 | 2013 | 2020-04-08 | Kentucky | 21 | 1393 | 73 |
2014 | 2014 | 2020-04-08 | Louisiana | 22 | 17030 | 652 |
2015 | 2015 | 2020-04-08 | Maine | 23 | 537 | 14 |
2016 | 2016 | 2020-04-08 | Maryland | 24 | 5529 | 124 |
2017 | 2017 | 2020-04-08 | Massachusetts | 25 | 16790 | 433 |
2018 | 2018 | 2020-04-08 | Michigan | 26 | 20220 | 959 |
2019 | 2019 | 2020-04-08 | Minnesota | 27 | 1154 | 39 |
2020 | 2020 | 2020-04-08 | Mississippi | 28 | 2003 | 67 |
2021 | 2021 | 2020-04-08 | Missouri | 29 | 3327 | 86 |
2022 | 2022 | 2020-04-08 | Montana | 30 | 332 | 6 |
2023 | 2023 | 2020-04-08 | Nebraska | 31 | 538 | 14 |
2024 | 2024 | 2020-04-08 | Nevada | 32 | 2318 | 80 |
2025 | 2025 | 2020-04-08 | New Hampshire | 33 | 788 | 18 |
2026 | 2026 | 2020-04-08 | New Jersey | 34 | 47437 | 1504 |
2027 | 2027 | 2020-04-08 | New Mexico | 35 | 865 | 16 |
2028 | 2028 | 2020-04-08 | New York | 36 | 151271 | 8138 |
2029 | 2029 | 2020-04-08 | North Carolina | 37 | 3423 | 61 |
2030 | 2030 | 2020-04-08 | North Dakota | 38 | 251 | 4 |
2031 | 2031 | 2020-04-08 | Northern Mariana Islands | 69 | 11 | 2 |
2032 | 2032 | 2020-04-08 | Ohio | 39 | 5149 | 193 |
2033 | 2033 | 2020-04-08 | Oklahoma | 40 | 1523 | 79 |
2034 | 2034 | 2020-04-08 | Oregon | 41 | 1239 | 38 |
2035 | 2035 | 2020-04-08 | Pennsylvania | 42 | 16414 | 313 |
2036 | 2036 | 2020-04-08 | Puerto Rico | 72 | 620 | 24 |
2037 | 2037 | 2020-04-08 | Rhode Island | 44 | 1450 | 35 |
2038 | 2038 | 2020-04-08 | South Carolina | 45 | 2552 | 63 |
2039 | 2039 | 2020-04-08 | South Dakota | 46 | 393 | 6 |
2040 | 2040 | 2020-04-08 | Tennessee | 47 | 4246 | 83 |
2041 | 2041 | 2020-04-08 | Texas | 48 | 9897 | 195 |
2042 | 2042 | 2020-04-08 | Utah | 49 | 1860 | 13 |
2043 | 2043 | 2020-04-08 | Vermont | 50 | 605 | 23 |
2044 | 2044 | 2020-04-08 | Virgin Islands | 78 | 46 | 1 |
2045 | 2045 | 2020-04-08 | Virginia | 51 | 3644 | 60 |
2046 | 2046 | 2020-04-08 | Washington | 53 | 9098 | 430 |
2047 | 2047 | 2020-04-08 | West Virginia | 54 | 483 | 4 |
2048 | 2048 | 2020-04-08 | Wisconsin | 55 | 2756 | 107 |
2049 | 2049 | 2020-04-08 | Wyoming | 56 | 230 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );