us-states

Table actions

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

11,399 rows sorted by date

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid date ▼ state fips cases deaths
1 1 2020-01-21 Washington 53 1 0
2 2 2020-01-22 Washington 53 1 0
3 3 2020-01-23 Washington 53 1 0
4 4 2020-01-24 Illinois 17 1 0
5 5 2020-01-24 Washington 53 1 0
6 6 2020-01-25 California 6 1 0
7 7 2020-01-25 Illinois 17 1 0
8 8 2020-01-25 Washington 53 1 0
9 9 2020-01-26 Arizona 4 1 0
10 10 2020-01-26 California 6 2 0
11 11 2020-01-26 Illinois 17 1 0
12 12 2020-01-26 Washington 53 1 0
13 13 2020-01-27 Arizona 4 1 0
14 14 2020-01-27 California 6 2 0
15 15 2020-01-27 Illinois 17 1 0
16 16 2020-01-27 Washington 53 1 0
17 17 2020-01-28 Arizona 4 1 0
18 18 2020-01-28 California 6 2 0
19 19 2020-01-28 Illinois 17 1 0
20 20 2020-01-28 Washington 53 1 0
21 21 2020-01-29 Arizona 4 1 0
22 22 2020-01-29 California 6 2 0
23 23 2020-01-29 Illinois 17 1 0
24 24 2020-01-29 Washington 53 1 0
25 25 2020-01-30 Arizona 4 1 0
26 26 2020-01-30 California 6 2 0
27 27 2020-01-30 Illinois 17 2 0
28 28 2020-01-30 Washington 53 1 0
29 29 2020-01-31 Arizona 4 1 0
30 30 2020-01-31 California 6 3 0
31 31 2020-01-31 Illinois 17 2 0
32 32 2020-01-31 Washington 53 1 0
33 33 2020-02-01 Arizona 4 1 0
34 34 2020-02-01 California 6 3 0
35 35 2020-02-01 Illinois 17 2 0
36 36 2020-02-01 Massachusetts 25 1 0
37 37 2020-02-01 Washington 53 1 0
38 38 2020-02-02 Arizona 4 1 0
39 39 2020-02-02 California 6 6 0
40 40 2020-02-02 Illinois 17 2 0
41 41 2020-02-02 Massachusetts 25 1 0
42 42 2020-02-02 Washington 53 1 0
43 43 2020-02-03 Arizona 4 1 0
44 44 2020-02-03 California 6 6 0
45 45 2020-02-03 Illinois 17 2 0
46 46 2020-02-03 Massachusetts 25 1 0
47 47 2020-02-03 Washington 53 1 0
48 48 2020-02-04 Arizona 4 1 0
49 49 2020-02-04 California 6 6 0
50 50 2020-02-04 Illinois 17 2 0
51 51 2020-02-04 Massachusetts 25 1 0
52 52 2020-02-04 Washington 53 1 0
53 53 2020-02-05 Arizona 4 1 0
54 54 2020-02-05 California 6 6 0
55 55 2020-02-05 Illinois 17 2 0
56 56 2020-02-05 Massachusetts 25 1 0
57 57 2020-02-05 Washington 53 1 0
58 58 2020-02-05 Wisconsin 55 1 0
59 59 2020-02-06 Arizona 4 1 0
60 60 2020-02-06 California 6 6 0
61 61 2020-02-06 Illinois 17 2 0
62 62 2020-02-06 Massachusetts 25 1 0
63 63 2020-02-06 Washington 53 1 0
64 64 2020-02-06 Wisconsin 55 1 0
65 65 2020-02-07 Arizona 4 1 0
66 66 2020-02-07 California 6 6 0
67 67 2020-02-07 Illinois 17 2 0
68 68 2020-02-07 Massachusetts 25 1 0
69 69 2020-02-07 Washington 53 1 0
70 70 2020-02-07 Wisconsin 55 1 0
71 71 2020-02-08 Arizona 4 1 0
72 72 2020-02-08 California 6 6 0
73 73 2020-02-08 Illinois 17 2 0
74 74 2020-02-08 Massachusetts 25 1 0
75 75 2020-02-08 Washington 53 1 0
76 76 2020-02-08 Wisconsin 55 1 0
77 77 2020-02-09 Arizona 4 1 0
78 78 2020-02-09 California 6 6 0
79 79 2020-02-09 Illinois 17 2 0
80 80 2020-02-09 Massachusetts 25 1 0
81 81 2020-02-09 Washington 53 1 0
82 82 2020-02-09 Wisconsin 55 1 0
83 83 2020-02-10 Arizona 4 1 0
84 84 2020-02-10 California 6 7 0
85 85 2020-02-10 Illinois 17 2 0
86 86 2020-02-10 Massachusetts 25 1 0
87 87 2020-02-10 Washington 53 1 0
88 88 2020-02-10 Wisconsin 55 1 0
89 89 2020-02-11 Arizona 4 1 0
90 90 2020-02-11 California 6 7 0
91 91 2020-02-11 Illinois 17 2 0
92 92 2020-02-11 Massachusetts 25 1 0
93 93 2020-02-11 Washington 53 1 0
94 94 2020-02-11 Wisconsin 55 1 0
95 95 2020-02-12 Arizona 4 1 0
96 96 2020-02-12 California 6 7 0
97 97 2020-02-12 Illinois 17 2 0
98 98 2020-02-12 Massachusetts 25 1 0
99 99 2020-02-12 Texas 48 1 0
100 100 2020-02-12 Washington 53 1 0

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
);