ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 1103 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382773 | 382773 | 2020-07-30 | Morgan | Alabama | 1103 | 2125 | 15 |
379556 | 379556 | 2020-07-29 | Morgan | Alabama | 1103 | 2057 | 15 |
376340 | 376340 | 2020-07-28 | Morgan | Alabama | 1103 | 2023 | 14 |
373126 | 373126 | 2020-07-27 | Morgan | Alabama | 1103 | 1997 | 14 |
369914 | 369914 | 2020-07-26 | Morgan | Alabama | 1103 | 1957 | 13 |
366704 | 366704 | 2020-07-25 | Morgan | Alabama | 1103 | 1936 | 12 |
363497 | 363497 | 2020-07-24 | Morgan | Alabama | 1103 | 1885 | 12 |
360291 | 360291 | 2020-07-23 | Morgan | Alabama | 1103 | 1853 | 11 |
357086 | 357086 | 2020-07-22 | Morgan | Alabama | 1103 | 1808 | 11 |
353883 | 353883 | 2020-07-21 | Morgan | Alabama | 1103 | 1767 | 10 |
350681 | 350681 | 2020-07-20 | Morgan | Alabama | 1103 | 1744 | 10 |
347480 | 347480 | 2020-07-19 | Morgan | Alabama | 1103 | 1685 | 10 |
344280 | 344280 | 2020-07-18 | Morgan | Alabama | 1103 | 1641 | 10 |
341081 | 341081 | 2020-07-17 | Morgan | Alabama | 1103 | 1596 | 10 |
337885 | 337885 | 2020-07-16 | Morgan | Alabama | 1103 | 1534 | 7 |
334690 | 334690 | 2020-07-15 | Morgan | Alabama | 1103 | 1506 | 7 |
331497 | 331497 | 2020-07-14 | Morgan | Alabama | 1103 | 1446 | 6 |
328311 | 328311 | 2020-07-13 | Morgan | Alabama | 1103 | 1413 | 5 |
325125 | 325125 | 2020-07-12 | Morgan | Alabama | 1103 | 1352 | 5 |
321944 | 321944 | 2020-07-11 | Morgan | Alabama | 1103 | 1283 | 5 |
318765 | 318765 | 2020-07-10 | Morgan | Alabama | 1103 | 1255 | 5 |
315592 | 315592 | 2020-07-09 | Morgan | Alabama | 1103 | 1234 | 5 |
312417 | 312417 | 2020-07-08 | Morgan | Alabama | 1103 | 1171 | 5 |
309248 | 309248 | 2020-07-07 | Morgan | Alabama | 1103 | 1142 | 5 |
306079 | 306079 | 2020-07-06 | Morgan | Alabama | 1103 | 1134 | 5 |
302915 | 302915 | 2020-07-05 | Morgan | Alabama | 1103 | 1115 | 5 |
299751 | 299751 | 2020-07-04 | Morgan | Alabama | 1103 | 1084 | 5 |
296589 | 296589 | 2020-07-03 | Morgan | Alabama | 1103 | 1060 | 5 |
293434 | 293434 | 2020-07-02 | Morgan | Alabama | 1103 | 1032 | 3 |
290281 | 290281 | 2020-07-01 | Morgan | Alabama | 1103 | 993 | 3 |
287131 | 287131 | 2020-06-30 | Morgan | Alabama | 1103 | 966 | 3 |
283985 | 283985 | 2020-06-29 | Morgan | Alabama | 1103 | 948 | 3 |
280839 | 280839 | 2020-06-28 | Morgan | Alabama | 1103 | 925 | 3 |
277691 | 277691 | 2020-06-27 | Morgan | Alabama | 1103 | 916 | 3 |
274543 | 274543 | 2020-06-26 | Morgan | Alabama | 1103 | 895 | 3 |
271403 | 271403 | 2020-06-25 | Morgan | Alabama | 1103 | 866 | 2 |
268269 | 268269 | 2020-06-24 | Morgan | Alabama | 1103 | 825 | 2 |
265140 | 265140 | 2020-06-23 | Morgan | Alabama | 1103 | 782 | 2 |
262011 | 262011 | 2020-06-22 | Morgan | Alabama | 1103 | 766 | 2 |
258884 | 258884 | 2020-06-21 | Morgan | Alabama | 1103 | 754 | 2 |
255757 | 255757 | 2020-06-20 | Morgan | Alabama | 1103 | 733 | 2 |
252638 | 252638 | 2020-06-19 | Morgan | Alabama | 1103 | 717 | 2 |
249523 | 249523 | 2020-06-18 | Morgan | Alabama | 1103 | 708 | 2 |
246411 | 246411 | 2020-06-17 | Morgan | Alabama | 1103 | 682 | 2 |
243298 | 243298 | 2020-06-16 | Morgan | Alabama | 1103 | 670 | 2 |
240187 | 240187 | 2020-06-15 | Morgan | Alabama | 1103 | 644 | 2 |
237079 | 237079 | 2020-06-14 | Morgan | Alabama | 1103 | 606 | 2 |
233972 | 233972 | 2020-06-13 | Morgan | Alabama | 1103 | 559 | 2 |
230867 | 230867 | 2020-06-12 | Morgan | Alabama | 1103 | 522 | 2 |
227763 | 227763 | 2020-06-11 | Morgan | Alabama | 1103 | 483 | 1 |
224662 | 224662 | 2020-06-10 | Morgan | Alabama | 1103 | 462 | 1 |
221566 | 221566 | 2020-06-09 | Morgan | Alabama | 1103 | 435 | 1 |
218474 | 218474 | 2020-06-08 | Morgan | Alabama | 1103 | 401 | 1 |
215384 | 215384 | 2020-06-07 | Morgan | Alabama | 1103 | 384 | 1 |
212297 | 212297 | 2020-06-06 | Morgan | Alabama | 1103 | 367 | 1 |
209212 | 209212 | 2020-06-05 | Morgan | Alabama | 1103 | 319 | 1 |
206130 | 206130 | 2020-06-04 | Morgan | Alabama | 1103 | 307 | 1 |
203051 | 203051 | 2020-06-03 | Morgan | Alabama | 1103 | 303 | 1 |
199975 | 199975 | 2020-06-02 | Morgan | Alabama | 1103 | 302 | 1 |
196902 | 196902 | 2020-06-01 | Morgan | Alabama | 1103 | 292 | 1 |
193832 | 193832 | 2020-05-31 | Morgan | Alabama | 1103 | 280 | 1 |
190766 | 190766 | 2020-05-30 | Morgan | Alabama | 1103 | 251 | 1 |
187702 | 187702 | 2020-05-29 | Morgan | Alabama | 1103 | 244 | 1 |
184645 | 184645 | 2020-05-28 | Morgan | Alabama | 1103 | 231 | 1 |
181593 | 181593 | 2020-05-27 | Morgan | Alabama | 1103 | 211 | 1 |
178549 | 178549 | 2020-05-26 | Morgan | Alabama | 1103 | 204 | 1 |
175504 | 175504 | 2020-05-25 | Morgan | Alabama | 1103 | 176 | 1 |
172461 | 172461 | 2020-05-24 | Morgan | Alabama | 1103 | 162 | 1 |
169420 | 169420 | 2020-05-23 | Morgan | Alabama | 1103 | 157 | 1 |
166384 | 166384 | 2020-05-22 | Morgan | Alabama | 1103 | 144 | 1 |
163352 | 163352 | 2020-05-21 | Morgan | Alabama | 1103 | 142 | 1 |
160324 | 160324 | 2020-05-20 | Morgan | Alabama | 1103 | 132 | 1 |
157300 | 157300 | 2020-05-19 | Morgan | Alabama | 1103 | 119 | 1 |
154284 | 154284 | 2020-05-18 | Morgan | Alabama | 1103 | 116 | 1 |
151272 | 151272 | 2020-05-17 | Morgan | Alabama | 1103 | 111 | 1 |
148263 | 148263 | 2020-05-16 | Morgan | Alabama | 1103 | 110 | 1 |
145260 | 145260 | 2020-05-15 | Morgan | Alabama | 1103 | 109 | 1 |
142261 | 142261 | 2020-05-14 | Morgan | Alabama | 1103 | 104 | 1 |
139265 | 139265 | 2020-05-13 | Morgan | Alabama | 1103 | 99 | 1 |
136274 | 136274 | 2020-05-12 | Morgan | Alabama | 1103 | 98 | 1 |
133284 | 133284 | 2020-05-11 | Morgan | Alabama | 1103 | 95 | 0 |
130294 | 130294 | 2020-05-10 | Morgan | Alabama | 1103 | 93 | 0 |
127304 | 127304 | 2020-05-09 | Morgan | Alabama | 1103 | 92 | 0 |
124319 | 124319 | 2020-05-08 | Morgan | Alabama | 1103 | 87 | 0 |
121339 | 121339 | 2020-05-07 | Morgan | Alabama | 1103 | 84 | 0 |
118373 | 118373 | 2020-05-06 | Morgan | Alabama | 1103 | 81 | 0 |
115414 | 115414 | 2020-05-05 | Morgan | Alabama | 1103 | 78 | 0 |
112531 | 112531 | 2020-05-04 | Morgan | Alabama | 1103 | 76 | 0 |
109656 | 109656 | 2020-05-03 | Morgan | Alabama | 1103 | 74 | 0 |
106787 | 106787 | 2020-05-02 | Morgan | Alabama | 1103 | 73 | 0 |
103922 | 103922 | 2020-05-01 | Morgan | Alabama | 1103 | 71 | 0 |
101067 | 101067 | 2020-04-30 | Morgan | Alabama | 1103 | 68 | 0 |
98217 | 98217 | 2020-04-29 | Morgan | Alabama | 1103 | 67 | 0 |
95372 | 95372 | 2020-04-28 | Morgan | Alabama | 1103 | 68 | 0 |
92542 | 92542 | 2020-04-27 | Morgan | Alabama | 1103 | 65 | 0 |
89724 | 89724 | 2020-04-26 | Morgan | Alabama | 1103 | 64 | 0 |
86908 | 86908 | 2020-04-25 | Morgan | Alabama | 1103 | 57 | 0 |
84100 | 84100 | 2020-04-24 | Morgan | Alabama | 1103 | 55 | 0 |
81299 | 81299 | 2020-04-23 | Morgan | Alabama | 1103 | 50 | 0 |
78506 | 78506 | 2020-04-22 | Morgan | Alabama | 1103 | 50 | 0 |
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);