us-states

Table actions

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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-05 · 55 ✖
Link rowid ▼ date state fips cases deaths
1830 1830 2020-04-05 Alabama 1 1840 45
1831 1831 2020-04-05 Alaska 2 183 4
1832 1832 2020-04-05 Arizona 4 2269 64
1833 1833 2020-04-05 Arkansas 5 853 16
1834 1834 2020-04-05 California 6 15202 351
1835 1835 2020-04-05 Colorado 8 4950 140
1836 1836 2020-04-05 Connecticut 9 5675 189
1837 1837 2020-04-05 Delaware 10 673 14
1838 1838 2020-04-05 District of Columbia 11 998 22
1839 1839 2020-04-05 Florida 12 12342 220
1840 1840 2020-04-05 Georgia 13 6742 219
1841 1841 2020-04-05 Guam 66 265 4
1842 1842 2020-04-05 Hawaii 15 369 4
1843 1843 2020-04-05 Idaho 16 1100 10
1844 1844 2020-04-05 Illinois 17 11276 283
1845 1845 2020-04-05 Indiana 18 4437 151
1846 1846 2020-04-05 Iowa 19 868 22
1847 1847 2020-04-05 Kansas 20 769 23
1848 1848 2020-04-05 Kentucky 21 1048 44
1849 1849 2020-04-05 Louisiana 22 13014 477
1850 1850 2020-04-05 Maine 23 470 10
1851 1851 2020-04-05 Maryland 24 3609 68
1852 1852 2020-04-05 Massachusetts 25 12500 231
1853 1853 2020-04-05 Michigan 26 15633 617
1854 1854 2020-04-05 Minnesota 27 935 29
1855 1855 2020-04-05 Mississippi 28 1638 43
1856 1856 2020-04-05 Missouri 29 2367 52
1857 1857 2020-04-05 Montana 30 298 6
1858 1858 2020-04-05 Nebraska 31 377 8
1859 1859 2020-04-05 Nevada 32 1880 46
1860 1860 2020-04-05 New Hampshire 33 669 9
1861 1861 2020-04-05 New Jersey 34 37505 917
1862 1862 2020-04-05 New Mexico 35 624 12
1863 1863 2020-04-05 New York 36 124085 5335
1864 1864 2020-04-05 North Carolina 37 2585 37
1865 1865 2020-04-05 North Dakota 38 207 3
1866 1866 2020-04-05 Northern Mariana Islands 69 8 1
1867 1867 2020-04-05 Ohio 39 4043 119
1868 1868 2020-04-05 Oklahoma 40 1251 46
1869 1869 2020-04-05 Oregon 41 1068 27
1870 1870 2020-04-05 Pennsylvania 42 11590 159
1871 1871 2020-04-05 Puerto Rico 72 475 20
1872 1872 2020-04-05 Rhode Island 44 922 25
1873 1873 2020-04-05 South Carolina 45 2049 44
1874 1874 2020-04-05 South Dakota 46 240 2
1875 1875 2020-04-05 Tennessee 47 3538 50
1876 1876 2020-04-05 Texas 48 7117 136
1877 1877 2020-04-05 Utah 49 1618 8
1878 1878 2020-04-05 Vermont 50 512 22
1879 1879 2020-04-05 Virgin Islands 78 42 0
1880 1880 2020-04-05 Virginia 51 2636 52
1881 1881 2020-04-05 Washington 53 7985 344
1882 1882 2020-04-05 West Virginia 54 325 3
1883 1883 2020-04-05 Wisconsin 55 2267 73
1884 1884 2020-04-05 Wyoming 56 200 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
);