ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 1069 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382756 | 382756 | 2020-07-30 | Houston | Alabama | 1069 | 1251 | 14 |
379539 | 379539 | 2020-07-29 | Houston | Alabama | 1069 | 1217 | 14 |
376323 | 376323 | 2020-07-28 | Houston | Alabama | 1069 | 1190 | 14 |
373109 | 373109 | 2020-07-27 | Houston | Alabama | 1069 | 1168 | 14 |
369897 | 369897 | 2020-07-26 | Houston | Alabama | 1069 | 1102 | 14 |
366687 | 366687 | 2020-07-25 | Houston | Alabama | 1069 | 1087 | 14 |
363480 | 363480 | 2020-07-24 | Houston | Alabama | 1069 | 1045 | 12 |
360274 | 360274 | 2020-07-23 | Houston | Alabama | 1069 | 1020 | 10 |
357069 | 357069 | 2020-07-22 | Houston | Alabama | 1069 | 968 | 10 |
353866 | 353866 | 2020-07-21 | Houston | Alabama | 1069 | 941 | 10 |
350664 | 350664 | 2020-07-20 | Houston | Alabama | 1069 | 908 | 10 |
347463 | 347463 | 2020-07-19 | Houston | Alabama | 1069 | 850 | 10 |
344263 | 344263 | 2020-07-18 | Houston | Alabama | 1069 | 788 | 10 |
341064 | 341064 | 2020-07-17 | Houston | Alabama | 1069 | 752 | 10 |
337868 | 337868 | 2020-07-16 | Houston | Alabama | 1069 | 723 | 10 |
334673 | 334673 | 2020-07-15 | Houston | Alabama | 1069 | 699 | 10 |
331480 | 331480 | 2020-07-14 | Houston | Alabama | 1069 | 673 | 9 |
328294 | 328294 | 2020-07-13 | Houston | Alabama | 1069 | 656 | 9 |
325108 | 325108 | 2020-07-12 | Houston | Alabama | 1069 | 622 | 9 |
321927 | 321927 | 2020-07-11 | Houston | Alabama | 1069 | 600 | 9 |
318748 | 318748 | 2020-07-10 | Houston | Alabama | 1069 | 576 | 8 |
315575 | 315575 | 2020-07-09 | Houston | Alabama | 1069 | 567 | 8 |
312400 | 312400 | 2020-07-08 | Houston | Alabama | 1069 | 551 | 8 |
309231 | 309231 | 2020-07-07 | Houston | Alabama | 1069 | 525 | 8 |
306062 | 306062 | 2020-07-06 | Houston | Alabama | 1069 | 522 | 6 |
302898 | 302898 | 2020-07-05 | Houston | Alabama | 1069 | 511 | 6 |
299734 | 299734 | 2020-07-04 | Houston | Alabama | 1069 | 494 | 6 |
296572 | 296572 | 2020-07-03 | Houston | Alabama | 1069 | 476 | 6 |
293417 | 293417 | 2020-07-02 | Houston | Alabama | 1069 | 461 | 6 |
290264 | 290264 | 2020-07-01 | Houston | Alabama | 1069 | 449 | 6 |
287114 | 287114 | 2020-06-30 | Houston | Alabama | 1069 | 439 | 6 |
283968 | 283968 | 2020-06-29 | Houston | Alabama | 1069 | 435 | 6 |
280822 | 280822 | 2020-06-28 | Houston | Alabama | 1069 | 438 | 6 |
277674 | 277674 | 2020-06-27 | Houston | Alabama | 1069 | 433 | 6 |
274526 | 274526 | 2020-06-26 | Houston | Alabama | 1069 | 409 | 5 |
271386 | 271386 | 2020-06-25 | Houston | Alabama | 1069 | 385 | 5 |
268252 | 268252 | 2020-06-24 | Houston | Alabama | 1069 | 384 | 5 |
265123 | 265123 | 2020-06-23 | Houston | Alabama | 1069 | 366 | 5 |
261994 | 261994 | 2020-06-22 | Houston | Alabama | 1069 | 360 | 5 |
258867 | 258867 | 2020-06-21 | Houston | Alabama | 1069 | 357 | 5 |
255740 | 255740 | 2020-06-20 | Houston | Alabama | 1069 | 356 | 5 |
252621 | 252621 | 2020-06-19 | Houston | Alabama | 1069 | 352 | 5 |
249506 | 249506 | 2020-06-18 | Houston | Alabama | 1069 | 343 | 5 |
246394 | 246394 | 2020-06-17 | Houston | Alabama | 1069 | 338 | 5 |
243281 | 243281 | 2020-06-16 | Houston | Alabama | 1069 | 329 | 5 |
240170 | 240170 | 2020-06-15 | Houston | Alabama | 1069 | 325 | 5 |
237062 | 237062 | 2020-06-14 | Houston | Alabama | 1069 | 317 | 5 |
233955 | 233955 | 2020-06-13 | Houston | Alabama | 1069 | 303 | 5 |
230850 | 230850 | 2020-06-12 | Houston | Alabama | 1069 | 289 | 5 |
227746 | 227746 | 2020-06-11 | Houston | Alabama | 1069 | 280 | 5 |
224645 | 224645 | 2020-06-10 | Houston | Alabama | 1069 | 269 | 5 |
221549 | 221549 | 2020-06-09 | Houston | Alabama | 1069 | 263 | 5 |
218457 | 218457 | 2020-06-08 | Houston | Alabama | 1069 | 256 | 5 |
215367 | 215367 | 2020-06-07 | Houston | Alabama | 1069 | 255 | 5 |
212280 | 212280 | 2020-06-06 | Houston | Alabama | 1069 | 247 | 5 |
209195 | 209195 | 2020-06-05 | Houston | Alabama | 1069 | 237 | 5 |
206113 | 206113 | 2020-06-04 | Houston | Alabama | 1069 | 236 | 5 |
203034 | 203034 | 2020-06-03 | Houston | Alabama | 1069 | 236 | 5 |
199958 | 199958 | 2020-06-02 | Houston | Alabama | 1069 | 233 | 5 |
196885 | 196885 | 2020-06-01 | Houston | Alabama | 1069 | 231 | 4 |
193815 | 193815 | 2020-05-31 | Houston | Alabama | 1069 | 220 | 4 |
190749 | 190749 | 2020-05-30 | Houston | Alabama | 1069 | 209 | 4 |
187685 | 187685 | 2020-05-29 | Houston | Alabama | 1069 | 204 | 4 |
184628 | 184628 | 2020-05-28 | Houston | Alabama | 1069 | 188 | 4 |
181576 | 181576 | 2020-05-27 | Houston | Alabama | 1069 | 185 | 4 |
178532 | 178532 | 2020-05-26 | Houston | Alabama | 1069 | 183 | 4 |
175487 | 175487 | 2020-05-25 | Houston | Alabama | 1069 | 172 | 4 |
172444 | 172444 | 2020-05-24 | Houston | Alabama | 1069 | 164 | 4 |
169403 | 169403 | 2020-05-23 | Houston | Alabama | 1069 | 161 | 4 |
166367 | 166367 | 2020-05-22 | Houston | Alabama | 1069 | 156 | 3 |
163335 | 163335 | 2020-05-21 | Houston | Alabama | 1069 | 154 | 3 |
160307 | 160307 | 2020-05-20 | Houston | Alabama | 1069 | 149 | 3 |
157283 | 157283 | 2020-05-19 | Houston | Alabama | 1069 | 141 | 4 |
154267 | 154267 | 2020-05-18 | Houston | Alabama | 1069 | 137 | 4 |
151255 | 151255 | 2020-05-17 | Houston | Alabama | 1069 | 132 | 4 |
148246 | 148246 | 2020-05-16 | Houston | Alabama | 1069 | 132 | 4 |
145243 | 145243 | 2020-05-15 | Houston | Alabama | 1069 | 129 | 4 |
142244 | 142244 | 2020-05-14 | Houston | Alabama | 1069 | 125 | 4 |
139248 | 139248 | 2020-05-13 | Houston | Alabama | 1069 | 115 | 4 |
136257 | 136257 | 2020-05-12 | Houston | Alabama | 1069 | 114 | 4 |
133267 | 133267 | 2020-05-11 | Houston | Alabama | 1069 | 107 | 4 |
130277 | 130277 | 2020-05-10 | Houston | Alabama | 1069 | 107 | 4 |
127287 | 127287 | 2020-05-09 | Houston | Alabama | 1069 | 104 | 4 |
124302 | 124302 | 2020-05-08 | Houston | Alabama | 1069 | 102 | 4 |
121322 | 121322 | 2020-05-07 | Houston | Alabama | 1069 | 100 | 4 |
118356 | 118356 | 2020-05-06 | Houston | Alabama | 1069 | 99 | 4 |
115397 | 115397 | 2020-05-05 | Houston | Alabama | 1069 | 98 | 4 |
112514 | 112514 | 2020-05-04 | Houston | Alabama | 1069 | 97 | 4 |
109639 | 109639 | 2020-05-03 | Houston | Alabama | 1069 | 95 | 4 |
106770 | 106770 | 2020-05-02 | Houston | Alabama | 1069 | 93 | 4 |
103905 | 103905 | 2020-05-01 | Houston | Alabama | 1069 | 90 | 4 |
101050 | 101050 | 2020-04-30 | Houston | Alabama | 1069 | 90 | 4 |
98200 | 98200 | 2020-04-29 | Houston | Alabama | 1069 | 87 | 3 |
95355 | 95355 | 2020-04-28 | Houston | Alabama | 1069 | 84 | 3 |
92525 | 92525 | 2020-04-27 | Houston | Alabama | 1069 | 79 | 3 |
89707 | 89707 | 2020-04-26 | Houston | Alabama | 1069 | 77 | 3 |
86891 | 86891 | 2020-04-25 | Houston | Alabama | 1069 | 76 | 3 |
84083 | 84083 | 2020-04-24 | Houston | Alabama | 1069 | 76 | 3 |
81282 | 81282 | 2020-04-23 | Houston | Alabama | 1069 | 78 | 3 |
78489 | 78489 | 2020-04-22 | Houston | Alabama | 1069 | 75 | 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);