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

19,979 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▲ date state fips cases deaths
19879 19879 2021-02-27 Florida 12 1903674 30733
19878 19878 2021-02-27 District of Columbia 11 40478 1010
19877 19877 2021-02-27 Delaware 10 86517 1418
19876 19876 2021-02-27 Connecticut 9 279946 7622
19875 19875 2021-02-27 Colorado 8 430129 6038
19874 19874 2021-02-27 California 6 3565496 51979
19873 19873 2021-02-27 Arkansas 5 319195 5417
19872 19872 2021-02-27 Arizona 4 816334 15967
19871 19871 2021-02-27 Alaska 2 57846 279
19870 19870 2021-02-27 Alabama 1 492683 9930
19869 19869 2021-02-26 Wyoming 56 54350 671
19868 19868 2021-02-26 Wisconsin 55 616029 7004
19867 19867 2021-02-26 West Virginia 54 131234 2291
19866 19866 2021-02-26 Washington 53 341941 5024
19865 19865 2021-02-26 Virginia 51 572639 8197
19864 19864 2021-02-26 Virgin Islands 78 2636 25
19863 19863 2021-02-26 Vermont 50 14963 204
19862 19862 2021-02-26 Utah 49 370084 1907
19861 19861 2021-02-26 Texas 48 2644221 43633
19860 19860 2021-02-26 Tennessee 47 759124 11284
19859 19859 2021-02-26 South Dakota 46 112107 1879
19858 19858 2021-02-26 South Carolina 45 513295 8477
19857 19857 2021-02-26 Rhode Island 44 125622 2502
19856 19856 2021-02-26 Puerto Rico 72 133475 2023
19855 19855 2021-02-26 Pennsylvania 42 931099 23979
19854 19854 2021-02-26 Oregon 41 154902 2216
19853 19853 2021-02-26 Oklahoma 40 423023 4320
19852 19852 2021-02-26 Ohio 39 964380 17185
19851 19851 2021-02-26 Northern Mariana Islands 69 143 2
19850 19850 2021-02-26 North Dakota 38 99741 1472
19849 19849 2021-02-26 North Carolina 37 860311 11216
19848 19848 2021-02-26 New York 36 1628255 46914
19847 19847 2021-02-26 New Mexico 35 184736 3687
19846 19846 2021-02-26 New Jersey 34 782829 23192
19845 19845 2021-02-26 New Hampshire 33 74893 1167
19844 19844 2021-02-26 Nevada 32 293165 4942
19843 19843 2021-02-26 Nebraska 31 200866 2195
19842 19842 2021-02-26 Montana 30 99732 1357
19841 19841 2021-02-26 Missouri 29 516429 8371
19840 19840 2021-02-26 Mississippi 28 293542 6638
19839 19839 2021-02-26 Minnesota 27 483046 6530
19838 19838 2021-02-26 Michigan 26 644046 16429
19837 19837 2021-02-26 Massachusetts 25 577980 16024
19836 19836 2021-02-26 Maryland 24 380618 7838
19835 19835 2021-02-26 Maine 23 44295 701
19834 19834 2021-02-26 Louisiana 22 428592 9587
19833 19833 2021-02-26 Kentucky 21 406795 4746
19832 19832 2021-02-26 Kansas 20 296798 4735
19831 19831 2021-02-26 Iowa 19 335840 5463
19830 19830 2021-02-26 Indiana 18 663282 12531
19829 19829 2021-02-26 Illinois 17 1186993 22675
19828 19828 2021-02-26 Idaho 16 171071 1862
19827 19827 2021-02-26 Hawaii 15 27320 434
19826 19826 2021-02-26 Guam 66 8703 131
19825 19825 2021-02-26 Georgia 13 976400 16682
19824 19824 2021-02-26 Florida 12 1898215 30623
19823 19823 2021-02-26 District of Columbia 11 40284 1009
19822 19822 2021-02-26 Delaware 10 86098 1418
19821 19821 2021-02-26 Connecticut 9 279946 7622
19820 19820 2021-02-26 Colorado 8 428475 6023
19819 19819 2021-02-26 California 6 3561086 51794
19818 19818 2021-02-26 Arkansas 5 318638 5407
19817 19817 2021-02-26 Arizona 4 815345 15897
19816 19816 2021-02-26 Alaska 2 57846 279
19815 19815 2021-02-26 Alabama 1 491849 9869
19814 19814 2021-02-25 Wyoming 56 54202 671
19813 19813 2021-02-25 Wisconsin 55 615233 6998
19812 19812 2021-02-25 West Virginia 54 130813 2290
19811 19811 2021-02-25 Washington 53 340997 5015
19810 19810 2021-02-25 Virginia 51 570982 7963
19809 19809 2021-02-25 Virgin Islands 78 2636 25
19808 19808 2021-02-25 Vermont 50 14840 203
19807 19807 2021-02-25 Utah 49 369433 1890
19806 19806 2021-02-25 Texas 48 2633310 43350
19805 19805 2021-02-25 Tennessee 47 757505 11228
19804 19804 2021-02-25 South Dakota 46 111964 1872
19803 19803 2021-02-25 South Carolina 45 511546 8443
19802 19802 2021-02-25 Rhode Island 44 125185 2496
19801 19801 2021-02-25 Puerto Rico 72 133234 2016
19800 19800 2021-02-25 Pennsylvania 42 928029 23910
19799 19799 2021-02-25 Oregon 41 154581 2214
19798 19798 2021-02-25 Oklahoma 40 422156 4302
19797 19797 2021-02-25 Ohio 39 962404 17128
19796 19796 2021-02-25 Northern Mariana Islands 69 143 2
19795 19795 2021-02-25 North Dakota 38 99651 1471
19794 19794 2021-02-25 North Carolina 37 857557 11162
19793 19793 2021-02-25 New York 36 1620181 46790
19792 19792 2021-02-25 New Mexico 35 184080 3673
19791 19791 2021-02-25 New Jersey 34 778960 23105
19790 19790 2021-02-25 New Hampshire 33 74568 1163
19789 19789 2021-02-25 Nevada 32 292702 4934
19788 19788 2021-02-25 Nebraska 31 200663 2183
19787 19787 2021-02-25 Montana 30 99566 1351
19786 19786 2021-02-25 Missouri 29 515808 8355
19785 19785 2021-02-25 Mississippi 28 292811 6613
19784 19784 2021-02-25 Minnesota 27 481899 6518
19783 19783 2021-02-25 Michigan 26 642768 16428
19782 19782 2021-02-25 Massachusetts 25 575993 15978
19781 19781 2021-02-25 Maryland 24 379648 7805
19780 19780 2021-02-25 Maine 23 44117 701

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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