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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-20 · 55 ✖
Link rowid ▼ date state fips cases deaths
2655 2655 2020-04-20 Alabama 1 5078 164
2656 2656 2020-04-20 Alaska 2 319 7
2657 2657 2020-04-20 Arizona 4 5064 191
2658 2658 2020-04-20 Arkansas 5 1971 42
2659 2659 2020-04-20 California 6 33862 1223
2660 2660 2020-04-20 Colorado 8 10106 448
2661 2661 2020-04-20 Connecticut 9 19815 1331
2662 2662 2020-04-20 Delaware 10 2745 72
2663 2663 2020-04-20 District of Columbia 11 2927 105
2664 2664 2020-04-20 Florida 12 27050 822
2665 2665 2020-04-20 Georgia 13 18447 767
2666 2666 2020-04-20 Guam 66 811 6
2667 2667 2020-04-20 Hawaii 15 578 10
2668 2668 2020-04-20 Idaho 16 1736 48
2669 2669 2020-04-20 Illinois 17 31508 1359
2670 2670 2020-04-20 Indiana 18 11784 666
2671 2671 2020-04-20 Iowa 19 3175 79
2672 2672 2020-04-20 Kansas 20 2030 101
2673 2673 2020-04-20 Kentucky 21 3050 155
2674 2674 2020-04-20 Louisiana 22 24523 1328
2675 2675 2020-04-20 Maine 23 875 35
2676 2676 2020-04-20 Maryland 24 13750 582
2677 2677 2020-04-20 Massachusetts 25 39643 1809
2678 2678 2020-04-20 Michigan 26 31929 2466
2679 2679 2020-04-20 Minnesota 27 2470 143
2680 2680 2020-04-20 Mississippi 28 4512 169
2681 2681 2020-04-20 Missouri 29 5807 201
2682 2682 2020-04-20 Montana 30 433 12
2683 2683 2020-04-20 Nebraska 31 1646 33
2684 2684 2020-04-20 Nevada 32 3830 163
2685 2685 2020-04-20 New Hampshire 33 1447 42
2686 2686 2020-04-20 New Jersey 34 88806 4377
2687 2687 2020-04-20 New Mexico 35 1971 58
2688 2688 2020-04-20 New York 36 251608 18412
2689 2689 2020-04-20 North Carolina 37 6764 187
2690 2690 2020-04-20 North Dakota 38 627 13
2691 2691 2020-04-20 Northern Mariana Islands 69 14 2
2692 2692 2020-04-20 Ohio 39 12919 509
2693 2693 2020-04-20 Oklahoma 40 2680 143
2694 2694 2020-04-20 Oregon 41 1956 75
2695 2695 2020-04-20 Pennsylvania 42 34005 1366
2696 2696 2020-04-20 Puerto Rico 72 1252 42
2697 2697 2020-04-20 Rhode Island 44 5090 155
2698 2698 2020-04-20 South Carolina 45 4439 124
2699 2699 2020-04-20 South Dakota 46 1685 7
2700 2700 2020-04-20 Tennessee 47 6994 156
2701 2701 2020-04-20 Texas 48 20035 523
2702 2702 2020-04-20 Utah 49 3213 28
2703 2703 2020-04-20 Vermont 50 816 37
2704 2704 2020-04-20 Virgin Islands 78 54 3
2705 2705 2020-04-20 Virginia 51 8989 300
2706 2706 2020-04-20 Washington 53 12255 661
2707 2707 2020-04-20 West Virginia 54 908 26
2708 2708 2020-04-20 Wisconsin 55 4564 231
2709 2709 2020-04-20 Wyoming 56 426 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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