ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Baldwin" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382723 | 382723 | 2020-07-30 | Baldwin | Alabama | 1003 | 3028 | 21 |
379506 | 379506 | 2020-07-29 | Baldwin | Alabama | 1003 | 2908 | 21 |
376290 | 376290 | 2020-07-28 | Baldwin | Alabama | 1003 | 2835 | 18 |
373076 | 373076 | 2020-07-27 | Baldwin | Alabama | 1003 | 2770 | 18 |
369864 | 369864 | 2020-07-26 | Baldwin | Alabama | 1003 | 2708 | 18 |
366654 | 366654 | 2020-07-25 | Baldwin | Alabama | 1003 | 2662 | 18 |
363447 | 363447 | 2020-07-24 | Baldwin | Alabama | 1003 | 2513 | 18 |
360241 | 360241 | 2020-07-23 | Baldwin | Alabama | 1003 | 2461 | 17 |
357036 | 357036 | 2020-07-22 | Baldwin | Alabama | 1003 | 2196 | 16 |
353833 | 353833 | 2020-07-21 | Baldwin | Alabama | 1003 | 2102 | 16 |
350631 | 350631 | 2020-07-20 | Baldwin | Alabama | 1003 | 2013 | 15 |
347430 | 347430 | 2020-07-19 | Baldwin | Alabama | 1003 | 1937 | 15 |
344230 | 344230 | 2020-07-18 | Baldwin | Alabama | 1003 | 1819 | 15 |
341031 | 341031 | 2020-07-17 | Baldwin | Alabama | 1003 | 1689 | 14 |
337835 | 337835 | 2020-07-16 | Baldwin | Alabama | 1003 | 1599 | 14 |
334640 | 334640 | 2020-07-15 | Baldwin | Alabama | 1003 | 1518 | 13 |
331447 | 331447 | 2020-07-14 | Baldwin | Alabama | 1003 | 1414 | 12 |
328261 | 328261 | 2020-07-13 | Baldwin | Alabama | 1003 | 1359 | 12 |
325075 | 325075 | 2020-07-12 | Baldwin | Alabama | 1003 | 1294 | 12 |
321894 | 321894 | 2020-07-11 | Baldwin | Alabama | 1003 | 1224 | 12 |
318715 | 318715 | 2020-07-10 | Baldwin | Alabama | 1003 | 1187 | 12 |
315542 | 315542 | 2020-07-09 | Baldwin | Alabama | 1003 | 1131 | 11 |
312367 | 312367 | 2020-07-08 | Baldwin | Alabama | 1003 | 1056 | 10 |
309198 | 309198 | 2020-07-07 | Baldwin | Alabama | 1003 | 997 | 10 |
306029 | 306029 | 2020-07-06 | Baldwin | Alabama | 1003 | 911 | 10 |
302865 | 302865 | 2020-07-05 | Baldwin | Alabama | 1003 | 881 | 10 |
299701 | 299701 | 2020-07-04 | Baldwin | Alabama | 1003 | 863 | 10 |
296539 | 296539 | 2020-07-03 | Baldwin | Alabama | 1003 | 845 | 10 |
293384 | 293384 | 2020-07-02 | Baldwin | Alabama | 1003 | 751 | 10 |
290231 | 290231 | 2020-07-01 | Baldwin | Alabama | 1003 | 703 | 10 |
287081 | 287081 | 2020-06-30 | Baldwin | Alabama | 1003 | 680 | 10 |
283935 | 283935 | 2020-06-29 | Baldwin | Alabama | 1003 | 643 | 10 |
280789 | 280789 | 2020-06-28 | Baldwin | Alabama | 1003 | 575 | 10 |
277641 | 277641 | 2020-06-27 | Baldwin | Alabama | 1003 | 555 | 10 |
274493 | 274493 | 2020-06-26 | Baldwin | Alabama | 1003 | 515 | 9 |
271353 | 271353 | 2020-06-25 | Baldwin | Alabama | 1003 | 477 | 9 |
268219 | 268219 | 2020-06-24 | Baldwin | Alabama | 1003 | 464 | 9 |
265090 | 265090 | 2020-06-23 | Baldwin | Alabama | 1003 | 450 | 9 |
261961 | 261961 | 2020-06-22 | Baldwin | Alabama | 1003 | 437 | 9 |
258834 | 258834 | 2020-06-21 | Baldwin | Alabama | 1003 | 430 | 9 |
255707 | 255707 | 2020-06-20 | Baldwin | Alabama | 1003 | 420 | 9 |
252588 | 252588 | 2020-06-19 | Baldwin | Alabama | 1003 | 413 | 9 |
249473 | 249473 | 2020-06-18 | Baldwin | Alabama | 1003 | 401 | 9 |
246361 | 246361 | 2020-06-17 | Baldwin | Alabama | 1003 | 392 | 9 |
243248 | 243248 | 2020-06-16 | Baldwin | Alabama | 1003 | 389 | 9 |
240137 | 240137 | 2020-06-15 | Baldwin | Alabama | 1003 | 383 | 9 |
237029 | 237029 | 2020-06-14 | Baldwin | Alabama | 1003 | 379 | 9 |
233922 | 233922 | 2020-06-13 | Baldwin | Alabama | 1003 | 376 | 9 |
230817 | 230817 | 2020-06-12 | Baldwin | Alabama | 1003 | 368 | 9 |
227713 | 227713 | 2020-06-11 | Baldwin | Alabama | 1003 | 358 | 9 |
224612 | 224612 | 2020-06-10 | Baldwin | Alabama | 1003 | 346 | 9 |
221516 | 221516 | 2020-06-09 | Baldwin | Alabama | 1003 | 340 | 9 |
218424 | 218424 | 2020-06-08 | Baldwin | Alabama | 1003 | 335 | 9 |
215334 | 215334 | 2020-06-07 | Baldwin | Alabama | 1003 | 329 | 9 |
212247 | 212247 | 2020-06-06 | Baldwin | Alabama | 1003 | 320 | 9 |
209162 | 209162 | 2020-06-05 | Baldwin | Alabama | 1003 | 312 | 9 |
206080 | 206080 | 2020-06-04 | Baldwin | Alabama | 1003 | 309 | 9 |
203001 | 203001 | 2020-06-03 | Baldwin | Alabama | 1003 | 308 | 9 |
199925 | 199925 | 2020-06-02 | Baldwin | Alabama | 1003 | 308 | 9 |
196852 | 196852 | 2020-06-01 | Baldwin | Alabama | 1003 | 306 | 9 |
193782 | 193782 | 2020-05-31 | Baldwin | Alabama | 1003 | 290 | 9 |
190716 | 190716 | 2020-05-30 | Baldwin | Alabama | 1003 | 283 | 9 |
187652 | 187652 | 2020-05-29 | Baldwin | Alabama | 1003 | 282 | 9 |
184595 | 184595 | 2020-05-28 | Baldwin | Alabama | 1003 | 281 | 9 |
181543 | 181543 | 2020-05-27 | Baldwin | Alabama | 1003 | 282 | 9 |
178499 | 178499 | 2020-05-26 | Baldwin | Alabama | 1003 | 277 | 9 |
175454 | 175454 | 2020-05-25 | Baldwin | Alabama | 1003 | 274 | 9 |
172411 | 172411 | 2020-05-24 | Baldwin | Alabama | 1003 | 274 | 9 |
169370 | 169370 | 2020-05-23 | Baldwin | Alabama | 1003 | 273 | 9 |
166334 | 166334 | 2020-05-22 | Baldwin | Alabama | 1003 | 271 | 9 |
163302 | 163302 | 2020-05-21 | Baldwin | Alabama | 1003 | 270 | 8 |
160274 | 160274 | 2020-05-20 | Baldwin | Alabama | 1003 | 270 | 8 |
157250 | 157250 | 2020-05-19 | Baldwin | Alabama | 1003 | 262 | 8 |
154234 | 154234 | 2020-05-18 | Baldwin | Alabama | 1003 | 260 | 8 |
151222 | 151222 | 2020-05-17 | Baldwin | Alabama | 1003 | 254 | 8 |
148213 | 148213 | 2020-05-16 | Baldwin | Alabama | 1003 | 254 | 8 |
145210 | 145210 | 2020-05-15 | Baldwin | Alabama | 1003 | 244 | 8 |
142211 | 142211 | 2020-05-14 | Baldwin | Alabama | 1003 | 243 | 8 |
139215 | 139215 | 2020-05-13 | Baldwin | Alabama | 1003 | 231 | 7 |
136224 | 136224 | 2020-05-12 | Baldwin | Alabama | 1003 | 227 | 7 |
133234 | 133234 | 2020-05-11 | Baldwin | Alabama | 1003 | 224 | 6 |
130244 | 130244 | 2020-05-10 | Baldwin | Alabama | 1003 | 222 | 5 |
127254 | 127254 | 2020-05-09 | Baldwin | Alabama | 1003 | 216 | 5 |
124269 | 124269 | 2020-05-08 | Baldwin | Alabama | 1003 | 208 | 5 |
121289 | 121289 | 2020-05-07 | Baldwin | Alabama | 1003 | 205 | 5 |
118323 | 118323 | 2020-05-06 | Baldwin | Alabama | 1003 | 196 | 5 |
115364 | 115364 | 2020-05-05 | Baldwin | Alabama | 1003 | 189 | 5 |
112481 | 112481 | 2020-05-04 | Baldwin | Alabama | 1003 | 188 | 4 |
109606 | 109606 | 2020-05-03 | Baldwin | Alabama | 1003 | 187 | 4 |
106737 | 106737 | 2020-05-02 | Baldwin | Alabama | 1003 | 181 | 4 |
103872 | 103872 | 2020-05-01 | Baldwin | Alabama | 1003 | 175 | 4 |
101017 | 101017 | 2020-04-30 | Baldwin | Alabama | 1003 | 174 | 3 |
98167 | 98167 | 2020-04-29 | Baldwin | Alabama | 1003 | 173 | 2 |
95322 | 95322 | 2020-04-28 | Baldwin | Alabama | 1003 | 171 | 3 |
92492 | 92492 | 2020-04-27 | Baldwin | Alabama | 1003 | 168 | 3 |
89674 | 89674 | 2020-04-26 | Baldwin | Alabama | 1003 | 161 | 3 |
86858 | 86858 | 2020-04-25 | Baldwin | Alabama | 1003 | 154 | 3 |
84050 | 84050 | 2020-04-24 | Baldwin | Alabama | 1003 | 147 | 3 |
81249 | 81249 | 2020-04-23 | Baldwin | Alabama | 1003 | 143 | 3 |
78456 | 78456 | 2020-04-22 | Baldwin | Alabama | 1003 | 132 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);