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-02

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-02 · 55 ✖
Link rowid ▼ date state fips cases deaths
1665 1665 2020-04-02 Alabama 1 1270 32
1666 1666 2020-04-02 Alaska 2 146 2
1667 1667 2020-04-02 Arizona 4 1600 35
1668 1668 2020-04-02 Arkansas 5 683 12
1669 1669 2020-04-02 California 6 11190 247
1670 1670 2020-04-02 Colorado 8 3728 96
1671 1671 2020-04-02 Connecticut 9 3824 112
1672 1672 2020-04-02 Delaware 10 393 12
1673 1673 2020-04-02 District of Columbia 11 653 12
1674 1674 2020-04-02 Florida 12 9000 144
1675 1675 2020-04-02 Georgia 13 5444 176
1676 1676 2020-04-02 Guam 66 152 3
1677 1677 2020-04-02 Hawaii 15 283 2
1678 1678 2020-04-02 Idaho 16 891 9
1679 1679 2020-04-02 Illinois 17 7695 165
1680 1680 2020-04-02 Indiana 18 3056 94
1681 1681 2020-04-02 Iowa 19 614 11
1682 1682 2020-04-02 Kansas 20 554 14
1683 1683 2020-04-02 Kentucky 21 747 34
1684 1684 2020-04-02 Louisiana 22 9152 310
1685 1685 2020-04-02 Maine 23 376 7
1686 1686 2020-04-02 Maryland 24 2331 36
1687 1687 2020-04-02 Massachusetts 25 8966 154
1688 1688 2020-04-02 Michigan 26 10791 417
1689 1689 2020-04-02 Minnesota 27 742 18
1690 1690 2020-04-02 Mississippi 28 1177 26
1691 1691 2020-04-02 Missouri 29 1834 28
1692 1692 2020-04-02 Montana 30 241 5
1693 1693 2020-04-02 Nebraska 31 273 6
1694 1694 2020-04-02 Nevada 32 1458 38
1695 1695 2020-04-02 New Hampshire 33 479 5
1696 1696 2020-04-02 New Jersey 34 25590 539
1697 1697 2020-04-02 New Mexico 35 403 7
1698 1698 2020-04-02 New York 36 93360 2963
1699 1699 2020-04-02 North Carolina 37 1858 17
1700 1700 2020-04-02 North Dakota 38 159 3
1701 1701 2020-04-02 Northern Mariana Islands 69 8 1
1702 1702 2020-04-02 Ohio 39 2903 81
1703 1703 2020-04-02 Oklahoma 40 879 34
1704 1704 2020-04-02 Oregon 41 827 21
1705 1705 2020-04-02 Pennsylvania 42 7021 91
1706 1706 2020-04-02 Puerto Rico 72 316 12
1707 1707 2020-04-02 Rhode Island 44 657 12
1708 1708 2020-04-02 South Carolina 45 1554 31
1709 1709 2020-04-02 South Dakota 46 165 2
1710 1710 2020-04-02 Tennessee 47 2868 32
1711 1711 2020-04-02 Texas 48 4952 80
1712 1712 2020-04-02 Utah 49 1077 7
1713 1713 2020-04-02 Vermont 50 338 17
1714 1714 2020-04-02 Virgin Islands 78 37 0
1715 1715 2020-04-02 Virginia 51 1706 18
1716 1716 2020-04-02 Washington 53 6586 272
1717 1717 2020-04-02 West Virginia 54 217 2
1718 1718 2020-04-02 Wisconsin 55 1730 37
1719 1719 2020-04-02 Wyoming 56 154 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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