ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Tuscaloosa" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382784 | 382784 | 2020-07-30 | Tuscaloosa | Alabama | 1125 | 3822 | 63 |
379567 | 379567 | 2020-07-29 | Tuscaloosa | Alabama | 1125 | 3759 | 63 |
376351 | 376351 | 2020-07-28 | Tuscaloosa | Alabama | 1125 | 3731 | 60 |
373137 | 373137 | 2020-07-27 | Tuscaloosa | Alabama | 1125 | 3686 | 60 |
369925 | 369925 | 2020-07-26 | Tuscaloosa | Alabama | 1125 | 3576 | 60 |
366715 | 366715 | 2020-07-25 | Tuscaloosa | Alabama | 1125 | 3542 | 60 |
363508 | 363508 | 2020-07-24 | Tuscaloosa | Alabama | 1125 | 3440 | 59 |
360302 | 360302 | 2020-07-23 | Tuscaloosa | Alabama | 1125 | 3356 | 59 |
357097 | 357097 | 2020-07-22 | Tuscaloosa | Alabama | 1125 | 3308 | 59 |
353894 | 353894 | 2020-07-21 | Tuscaloosa | Alabama | 1125 | 3273 | 57 |
350692 | 350692 | 2020-07-20 | Tuscaloosa | Alabama | 1125 | 3240 | 57 |
347491 | 347491 | 2020-07-19 | Tuscaloosa | Alabama | 1125 | 3177 | 57 |
344291 | 344291 | 2020-07-18 | Tuscaloosa | Alabama | 1125 | 3092 | 57 |
341092 | 341092 | 2020-07-17 | Tuscaloosa | Alabama | 1125 | 3018 | 57 |
337896 | 337896 | 2020-07-16 | Tuscaloosa | Alabama | 1125 | 2955 | 56 |
334701 | 334701 | 2020-07-15 | Tuscaloosa | Alabama | 1125 | 2861 | 56 |
331508 | 331508 | 2020-07-14 | Tuscaloosa | Alabama | 1125 | 2799 | 56 |
328322 | 328322 | 2020-07-13 | Tuscaloosa | Alabama | 1125 | 2765 | 55 |
325136 | 325136 | 2020-07-12 | Tuscaloosa | Alabama | 1125 | 2712 | 55 |
321955 | 321955 | 2020-07-11 | Tuscaloosa | Alabama | 1125 | 2654 | 55 |
318776 | 318776 | 2020-07-10 | Tuscaloosa | Alabama | 1125 | 2608 | 54 |
315603 | 315603 | 2020-07-09 | Tuscaloosa | Alabama | 1125 | 2566 | 50 |
312428 | 312428 | 2020-07-08 | Tuscaloosa | Alabama | 1125 | 2405 | 50 |
309259 | 309259 | 2020-07-07 | Tuscaloosa | Alabama | 1125 | 2368 | 46 |
306090 | 306090 | 2020-07-06 | Tuscaloosa | Alabama | 1125 | 2342 | 44 |
302926 | 302926 | 2020-07-05 | Tuscaloosa | Alabama | 1125 | 2309 | 44 |
299762 | 299762 | 2020-07-04 | Tuscaloosa | Alabama | 1125 | 2247 | 44 |
296600 | 296600 | 2020-07-03 | Tuscaloosa | Alabama | 1125 | 2209 | 44 |
293445 | 293445 | 2020-07-02 | Tuscaloosa | Alabama | 1125 | 2129 | 41 |
290292 | 290292 | 2020-07-01 | Tuscaloosa | Alabama | 1125 | 2071 | 40 |
287142 | 287142 | 2020-06-30 | Tuscaloosa | Alabama | 1125 | 1986 | 38 |
283996 | 283996 | 2020-06-29 | Tuscaloosa | Alabama | 1125 | 1946 | 38 |
280850 | 280850 | 2020-06-28 | Tuscaloosa | Alabama | 1125 | 1866 | 38 |
277702 | 277702 | 2020-06-27 | Tuscaloosa | Alabama | 1125 | 1860 | 38 |
274554 | 274554 | 2020-06-26 | Tuscaloosa | Alabama | 1125 | 1814 | 37 |
271414 | 271414 | 2020-06-25 | Tuscaloosa | Alabama | 1125 | 1758 | 37 |
268280 | 268280 | 2020-06-24 | Tuscaloosa | Alabama | 1125 | 1680 | 35 |
265151 | 265151 | 2020-06-23 | Tuscaloosa | Alabama | 1125 | 1652 | 35 |
262022 | 262022 | 2020-06-22 | Tuscaloosa | Alabama | 1125 | 1619 | 31 |
258895 | 258895 | 2020-06-21 | Tuscaloosa | Alabama | 1125 | 1596 | 31 |
255768 | 255768 | 2020-06-20 | Tuscaloosa | Alabama | 1125 | 1559 | 31 |
252649 | 252649 | 2020-06-19 | Tuscaloosa | Alabama | 1125 | 1541 | 29 |
249534 | 249534 | 2020-06-18 | Tuscaloosa | Alabama | 1125 | 1481 | 28 |
246422 | 246422 | 2020-06-17 | Tuscaloosa | Alabama | 1125 | 1432 | 25 |
243309 | 243309 | 2020-06-16 | Tuscaloosa | Alabama | 1125 | 1419 | 25 |
240198 | 240198 | 2020-06-15 | Tuscaloosa | Alabama | 1125 | 1356 | 25 |
237090 | 237090 | 2020-06-14 | Tuscaloosa | Alabama | 1125 | 1305 | 25 |
233983 | 233983 | 2020-06-13 | Tuscaloosa | Alabama | 1125 | 1253 | 25 |
230878 | 230878 | 2020-06-12 | Tuscaloosa | Alabama | 1125 | 1169 | 24 |
227774 | 227774 | 2020-06-11 | Tuscaloosa | Alabama | 1125 | 1083 | 23 |
224673 | 224673 | 2020-06-10 | Tuscaloosa | Alabama | 1125 | 1022 | 23 |
221577 | 221577 | 2020-06-09 | Tuscaloosa | Alabama | 1125 | 989 | 23 |
218485 | 218485 | 2020-06-08 | Tuscaloosa | Alabama | 1125 | 948 | 23 |
215395 | 215395 | 2020-06-07 | Tuscaloosa | Alabama | 1125 | 927 | 18 |
212308 | 212308 | 2020-06-06 | Tuscaloosa | Alabama | 1125 | 908 | 17 |
209223 | 209223 | 2020-06-05 | Tuscaloosa | Alabama | 1125 | 864 | 16 |
206141 | 206141 | 2020-06-04 | Tuscaloosa | Alabama | 1125 | 846 | 16 |
203062 | 203062 | 2020-06-03 | Tuscaloosa | Alabama | 1125 | 831 | 16 |
199986 | 199986 | 2020-06-02 | Tuscaloosa | Alabama | 1125 | 825 | 16 |
196913 | 196913 | 2020-06-01 | Tuscaloosa | Alabama | 1125 | 808 | 16 |
193843 | 193843 | 2020-05-31 | Tuscaloosa | Alabama | 1125 | 783 | 15 |
190777 | 190777 | 2020-05-30 | Tuscaloosa | Alabama | 1125 | 738 | 14 |
187713 | 187713 | 2020-05-29 | Tuscaloosa | Alabama | 1125 | 720 | 14 |
184656 | 184656 | 2020-05-28 | Tuscaloosa | Alabama | 1125 | 678 | 13 |
181604 | 181604 | 2020-05-27 | Tuscaloosa | Alabama | 1125 | 632 | 12 |
178560 | 178560 | 2020-05-26 | Tuscaloosa | Alabama | 1125 | 607 | 12 |
175515 | 175515 | 2020-05-25 | Tuscaloosa | Alabama | 1125 | 558 | 12 |
172472 | 172472 | 2020-05-24 | Tuscaloosa | Alabama | 1125 | 505 | 12 |
169431 | 169431 | 2020-05-23 | Tuscaloosa | Alabama | 1125 | 480 | 11 |
166395 | 166395 | 2020-05-22 | Tuscaloosa | Alabama | 1125 | 464 | 9 |
163363 | 163363 | 2020-05-21 | Tuscaloosa | Alabama | 1125 | 454 | 9 |
160335 | 160335 | 2020-05-20 | Tuscaloosa | Alabama | 1125 | 431 | 8 |
157311 | 157311 | 2020-05-19 | Tuscaloosa | Alabama | 1125 | 387 | 8 |
154295 | 154295 | 2020-05-18 | Tuscaloosa | Alabama | 1125 | 368 | 8 |
151283 | 151283 | 2020-05-17 | Tuscaloosa | Alabama | 1125 | 345 | 8 |
148274 | 148274 | 2020-05-16 | Tuscaloosa | Alabama | 1125 | 345 | 8 |
145271 | 145271 | 2020-05-15 | Tuscaloosa | Alabama | 1125 | 332 | 8 |
142272 | 142272 | 2020-05-14 | Tuscaloosa | Alabama | 1125 | 319 | 8 |
139276 | 139276 | 2020-05-13 | Tuscaloosa | Alabama | 1125 | 302 | 8 |
136285 | 136285 | 2020-05-12 | Tuscaloosa | Alabama | 1125 | 291 | 7 |
133295 | 133295 | 2020-05-11 | Tuscaloosa | Alabama | 1125 | 284 | 4 |
130305 | 130305 | 2020-05-10 | Tuscaloosa | Alabama | 1125 | 278 | 4 |
127315 | 127315 | 2020-05-09 | Tuscaloosa | Alabama | 1125 | 274 | 4 |
124330 | 124330 | 2020-05-08 | Tuscaloosa | Alabama | 1125 | 269 | 4 |
121350 | 121350 | 2020-05-07 | Tuscaloosa | Alabama | 1125 | 259 | 4 |
118384 | 118384 | 2020-05-06 | Tuscaloosa | Alabama | 1125 | 248 | 4 |
115425 | 115425 | 2020-05-05 | Tuscaloosa | Alabama | 1125 | 243 | 3 |
112542 | 112542 | 2020-05-04 | Tuscaloosa | Alabama | 1125 | 237 | 2 |
109667 | 109667 | 2020-05-03 | Tuscaloosa | Alabama | 1125 | 218 | 2 |
106798 | 106798 | 2020-05-02 | Tuscaloosa | Alabama | 1125 | 216 | 2 |
103933 | 103933 | 2020-05-01 | Tuscaloosa | Alabama | 1125 | 210 | 2 |
101078 | 101078 | 2020-04-30 | Tuscaloosa | Alabama | 1125 | 208 | 1 |
98228 | 98228 | 2020-04-29 | Tuscaloosa | Alabama | 1125 | 203 | 1 |
95383 | 95383 | 2020-04-28 | Tuscaloosa | Alabama | 1125 | 199 | 0 |
92553 | 92553 | 2020-04-27 | Tuscaloosa | Alabama | 1125 | 195 | 0 |
89735 | 89735 | 2020-04-26 | Tuscaloosa | Alabama | 1125 | 192 | 0 |
86919 | 86919 | 2020-04-25 | Tuscaloosa | Alabama | 1125 | 185 | 0 |
84111 | 84111 | 2020-04-24 | Tuscaloosa | Alabama | 1125 | 182 | 0 |
81310 | 81310 | 2020-04-23 | Tuscaloosa | Alabama | 1125 | 173 | 0 |
78517 | 78517 | 2020-04-22 | Tuscaloosa | Alabama | 1125 | 165 | 1 |
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);