us-states

Table actions

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

11,399 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ date state fips cases deaths
101 101 2020-02-12 Wisconsin 55 1 0
102 102 2020-02-13 Arizona 4 1 0
103 103 2020-02-13 California 6 7 0
104 104 2020-02-13 Illinois 17 2 0
105 105 2020-02-13 Massachusetts 25 1 0
106 106 2020-02-13 Texas 48 2 0
107 107 2020-02-13 Washington 53 1 0
108 108 2020-02-13 Wisconsin 55 1 0
109 109 2020-02-14 Arizona 4 1 0
110 110 2020-02-14 California 6 7 0
111 111 2020-02-14 Illinois 17 2 0
112 112 2020-02-14 Massachusetts 25 1 0
113 113 2020-02-14 Texas 48 2 0
114 114 2020-02-14 Washington 53 1 0
115 115 2020-02-14 Wisconsin 55 1 0
116 116 2020-02-15 Arizona 4 1 0
117 117 2020-02-15 California 6 7 0
118 118 2020-02-15 Illinois 17 2 0
119 119 2020-02-15 Massachusetts 25 1 0
120 120 2020-02-15 Texas 48 2 0
121 121 2020-02-15 Washington 53 1 0
122 122 2020-02-15 Wisconsin 55 1 0
123 123 2020-02-16 Arizona 4 1 0
124 124 2020-02-16 California 6 7 0
125 125 2020-02-16 Illinois 17 2 0
126 126 2020-02-16 Massachusetts 25 1 0
127 127 2020-02-16 Texas 48 2 0
128 128 2020-02-16 Washington 53 1 0
129 129 2020-02-16 Wisconsin 55 1 0
130 130 2020-02-17 Arizona 4 1 0
131 131 2020-02-17 California 6 7 0
132 132 2020-02-17 Illinois 17 2 0
133 133 2020-02-17 Massachusetts 25 1 0
134 134 2020-02-17 Nebraska 31 10 0
135 135 2020-02-17 Texas 48 2 0
136 136 2020-02-17 Washington 53 1 0
137 137 2020-02-17 Wisconsin 55 1 0
138 138 2020-02-18 Arizona 4 1 0
139 139 2020-02-18 California 6 7 0
140 140 2020-02-18 Illinois 17 2 0
141 141 2020-02-18 Massachusetts 25 1 0
142 142 2020-02-18 Nebraska 31 10 0
143 143 2020-02-18 Texas 48 2 0
144 144 2020-02-18 Washington 53 1 0
145 145 2020-02-18 Wisconsin 55 1 0
146 146 2020-02-19 Arizona 4 1 0
147 147 2020-02-19 California 6 7 0
148 148 2020-02-19 Illinois 17 2 0
149 149 2020-02-19 Massachusetts 25 1 0
150 150 2020-02-19 Nebraska 31 10 0
151 151 2020-02-19 Texas 48 2 0
152 152 2020-02-19 Washington 53 1 0
153 153 2020-02-19 Wisconsin 55 1 0
154 154 2020-02-20 Arizona 4 1 0
155 155 2020-02-20 California 6 8 0
156 156 2020-02-20 Illinois 17 2 0
157 157 2020-02-20 Massachusetts 25 1 0
158 158 2020-02-20 Nebraska 31 11 0
159 159 2020-02-20 Texas 48 2 0
160 160 2020-02-20 Washington 53 1 0
161 161 2020-02-20 Wisconsin 55 1 0
162 162 2020-02-21 Arizona 4 1 0
163 163 2020-02-21 California 6 9 0
164 164 2020-02-21 Illinois 17 2 0
165 165 2020-02-21 Massachusetts 25 1 0
166 166 2020-02-21 Nebraska 31 11 0
167 167 2020-02-21 Texas 48 4 0
168 168 2020-02-21 Washington 53 1 0
169 169 2020-02-21 Wisconsin 55 1 0
170 170 2020-02-22 Arizona 4 1 0
171 171 2020-02-22 California 6 9 0
172 172 2020-02-22 Illinois 17 2 0
173 173 2020-02-22 Massachusetts 25 1 0
174 174 2020-02-22 Nebraska 31 11 0
175 175 2020-02-22 Texas 48 4 0
176 176 2020-02-22 Washington 53 1 0
177 177 2020-02-22 Wisconsin 55 1 0
178 178 2020-02-23 Arizona 4 1 0
179 179 2020-02-23 California 6 9 0
180 180 2020-02-23 Illinois 17 2 0
181 181 2020-02-23 Massachusetts 25 1 0
182 182 2020-02-23 Nebraska 31 11 0
183 183 2020-02-23 Texas 48 4 0
184 184 2020-02-23 Washington 53 1 0
185 185 2020-02-23 Wisconsin 55 1 0
186 186 2020-02-24 Arizona 4 1 0
187 187 2020-02-24 California 6 11 0
188 188 2020-02-24 Illinois 17 2 0
189 189 2020-02-24 Massachusetts 25 1 0
190 190 2020-02-24 Nebraska 31 12 0
191 191 2020-02-24 Texas 48 10 0
192 192 2020-02-24 Washington 53 5 0
193 193 2020-02-24 Wisconsin 55 1 0
194 194 2020-02-25 Arizona 4 1 0
195 195 2020-02-25 California 6 11 0
196 196 2020-02-25 Illinois 17 2 0
197 197 2020-02-25 Massachusetts 25 1 0
198 198 2020-02-25 Nebraska 31 13 0
199 199 2020-02-25 Texas 48 10 0
200 200 2020-02-25 Utah 49 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
);