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

11,399 rows

View and edit SQL

Suggested facets: date (date)

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