ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1101 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382772 | 382772 | 2020-07-30 | Montgomery | Alabama | 1101 | 6045 | 142 |
379555 | 379555 | 2020-07-29 | Montgomery | Alabama | 1101 | 5971 | 141 |
376339 | 376339 | 2020-07-28 | Montgomery | Alabama | 1101 | 5921 | 141 |
373125 | 373125 | 2020-07-27 | Montgomery | Alabama | 1101 | 5850 | 141 |
369913 | 369913 | 2020-07-26 | Montgomery | Alabama | 1101 | 5724 | 140 |
366703 | 366703 | 2020-07-25 | Montgomery | Alabama | 1101 | 5684 | 138 |
363496 | 363496 | 2020-07-24 | Montgomery | Alabama | 1101 | 5599 | 137 |
360290 | 360290 | 2020-07-23 | Montgomery | Alabama | 1101 | 5499 | 133 |
357085 | 357085 | 2020-07-22 | Montgomery | Alabama | 1101 | 5397 | 130 |
353882 | 353882 | 2020-07-21 | Montgomery | Alabama | 1101 | 5310 | 128 |
350680 | 350680 | 2020-07-20 | Montgomery | Alabama | 1101 | 5241 | 127 |
347479 | 347479 | 2020-07-19 | Montgomery | Alabama | 1101 | 5120 | 127 |
344279 | 344279 | 2020-07-18 | Montgomery | Alabama | 1101 | 5045 | 126 |
341080 | 341080 | 2020-07-17 | Montgomery | Alabama | 1101 | 4913 | 124 |
337884 | 337884 | 2020-07-16 | Montgomery | Alabama | 1101 | 4864 | 121 |
334689 | 334689 | 2020-07-15 | Montgomery | Alabama | 1101 | 4783 | 120 |
331496 | 331496 | 2020-07-14 | Montgomery | Alabama | 1101 | 4739 | 116 |
328310 | 328310 | 2020-07-13 | Montgomery | Alabama | 1101 | 4649 | 114 |
325124 | 325124 | 2020-07-12 | Montgomery | Alabama | 1101 | 4595 | 114 |
321943 | 321943 | 2020-07-11 | Montgomery | Alabama | 1101 | 4478 | 114 |
318764 | 318764 | 2020-07-10 | Montgomery | Alabama | 1101 | 4445 | 113 |
315591 | 315591 | 2020-07-09 | Montgomery | Alabama | 1101 | 4386 | 111 |
312416 | 312416 | 2020-07-08 | Montgomery | Alabama | 1101 | 4321 | 111 |
309247 | 309247 | 2020-07-07 | Montgomery | Alabama | 1101 | 4293 | 107 |
306078 | 306078 | 2020-07-06 | Montgomery | Alabama | 1101 | 4205 | 105 |
302914 | 302914 | 2020-07-05 | Montgomery | Alabama | 1101 | 4174 | 105 |
299750 | 299750 | 2020-07-04 | Montgomery | Alabama | 1101 | 4068 | 105 |
296588 | 296588 | 2020-07-03 | Montgomery | Alabama | 1101 | 3994 | 105 |
293433 | 293433 | 2020-07-02 | Montgomery | Alabama | 1101 | 3925 | 104 |
290280 | 290280 | 2020-07-01 | Montgomery | Alabama | 1101 | 3890 | 102 |
287130 | 287130 | 2020-06-30 | Montgomery | Alabama | 1101 | 3839 | 97 |
283984 | 283984 | 2020-06-29 | Montgomery | Alabama | 1101 | 3777 | 96 |
280838 | 280838 | 2020-06-28 | Montgomery | Alabama | 1101 | 3630 | 95 |
277690 | 277690 | 2020-06-27 | Montgomery | Alabama | 1101 | 3624 | 95 |
274542 | 274542 | 2020-06-26 | Montgomery | Alabama | 1101 | 3569 | 94 |
271402 | 271402 | 2020-06-25 | Montgomery | Alabama | 1101 | 3514 | 91 |
268268 | 268268 | 2020-06-24 | Montgomery | Alabama | 1101 | 3441 | 90 |
265139 | 265139 | 2020-06-23 | Montgomery | Alabama | 1101 | 3351 | 87 |
262010 | 262010 | 2020-06-22 | Montgomery | Alabama | 1101 | 3297 | 81 |
258883 | 258883 | 2020-06-21 | Montgomery | Alabama | 1101 | 3258 | 81 |
255756 | 255756 | 2020-06-20 | Montgomery | Alabama | 1101 | 3222 | 81 |
252637 | 252637 | 2020-06-19 | Montgomery | Alabama | 1101 | 3149 | 77 |
249522 | 249522 | 2020-06-18 | Montgomery | Alabama | 1101 | 3101 | 75 |
246410 | 246410 | 2020-06-17 | Montgomery | Alabama | 1101 | 2996 | 72 |
243297 | 243297 | 2020-06-16 | Montgomery | Alabama | 1101 | 2961 | 71 |
240186 | 240186 | 2020-06-15 | Montgomery | Alabama | 1101 | 2910 | 69 |
237078 | 237078 | 2020-06-14 | Montgomery | Alabama | 1101 | 2830 | 69 |
233971 | 233971 | 2020-06-13 | Montgomery | Alabama | 1101 | 2683 | 69 |
230866 | 230866 | 2020-06-12 | Montgomery | Alabama | 1101 | 2581 | 69 |
227762 | 227762 | 2020-06-11 | Montgomery | Alabama | 1101 | 2472 | 66 |
224661 | 224661 | 2020-06-10 | Montgomery | Alabama | 1101 | 2326 | 62 |
221565 | 221565 | 2020-06-09 | Montgomery | Alabama | 1101 | 2256 | 57 |
218473 | 218473 | 2020-06-08 | Montgomery | Alabama | 1101 | 2158 | 55 |
215383 | 215383 | 2020-06-07 | Montgomery | Alabama | 1101 | 2084 | 49 |
212296 | 212296 | 2020-06-06 | Montgomery | Alabama | 1101 | 2023 | 48 |
209211 | 209211 | 2020-06-05 | Montgomery | Alabama | 1101 | 1929 | 45 |
206129 | 206129 | 2020-06-04 | Montgomery | Alabama | 1101 | 1881 | 44 |
203050 | 203050 | 2020-06-03 | Montgomery | Alabama | 1101 | 1845 | 44 |
199974 | 199974 | 2020-06-02 | Montgomery | Alabama | 1101 | 1824 | 44 |
196901 | 196901 | 2020-06-01 | Montgomery | Alabama | 1101 | 1778 | 44 |
193831 | 193831 | 2020-05-31 | Montgomery | Alabama | 1101 | 1710 | 40 |
190765 | 190765 | 2020-05-30 | Montgomery | Alabama | 1101 | 1632 | 38 |
187701 | 187701 | 2020-05-29 | Montgomery | Alabama | 1101 | 1590 | 38 |
184644 | 184644 | 2020-05-28 | Montgomery | Alabama | 1101 | 1541 | 34 |
181592 | 181592 | 2020-05-27 | Montgomery | Alabama | 1101 | 1446 | 34 |
178548 | 178548 | 2020-05-26 | Montgomery | Alabama | 1101 | 1384 | 34 |
175503 | 175503 | 2020-05-25 | Montgomery | Alabama | 1101 | 1274 | 33 |
172460 | 172460 | 2020-05-24 | Montgomery | Alabama | 1101 | 1186 | 30 |
169419 | 169419 | 2020-05-23 | Montgomery | Alabama | 1101 | 1147 | 30 |
166383 | 166383 | 2020-05-22 | Montgomery | Alabama | 1101 | 1096 | 29 |
163351 | 163351 | 2020-05-21 | Montgomery | Alabama | 1101 | 1052 | 28 |
160323 | 160323 | 2020-05-20 | Montgomery | Alabama | 1101 | 994 | 27 |
157299 | 157299 | 2020-05-19 | Montgomery | Alabama | 1101 | 907 | 24 |
154283 | 154283 | 2020-05-18 | Montgomery | Alabama | 1101 | 863 | 20 |
151271 | 151271 | 2020-05-17 | Montgomery | Alabama | 1101 | 823 | 20 |
148262 | 148262 | 2020-05-16 | Montgomery | Alabama | 1101 | 816 | 20 |
145259 | 145259 | 2020-05-15 | Montgomery | Alabama | 1101 | 787 | 20 |
142260 | 142260 | 2020-05-14 | Montgomery | Alabama | 1101 | 753 | 20 |
139264 | 139264 | 2020-05-13 | Montgomery | Alabama | 1101 | 705 | 19 |
136273 | 136273 | 2020-05-12 | Montgomery | Alabama | 1101 | 684 | 18 |
133283 | 133283 | 2020-05-11 | Montgomery | Alabama | 1101 | 642 | 15 |
130293 | 130293 | 2020-05-10 | Montgomery | Alabama | 1101 | 608 | 15 |
127303 | 127303 | 2020-05-09 | Montgomery | Alabama | 1101 | 576 | 15 |
124318 | 124318 | 2020-05-08 | Montgomery | Alabama | 1101 | 533 | 15 |
121338 | 121338 | 2020-05-07 | Montgomery | Alabama | 1101 | 515 | 13 |
118372 | 118372 | 2020-05-06 | Montgomery | Alabama | 1101 | 477 | 12 |
115413 | 115413 | 2020-05-05 | Montgomery | Alabama | 1101 | 456 | 8 |
112530 | 112530 | 2020-05-04 | Montgomery | Alabama | 1101 | 438 | 8 |
109655 | 109655 | 2020-05-03 | Montgomery | Alabama | 1101 | 409 | 7 |
106786 | 106786 | 2020-05-02 | Montgomery | Alabama | 1101 | 379 | 6 |
103921 | 103921 | 2020-05-01 | Montgomery | Alabama | 1101 | 355 | 6 |
101066 | 101066 | 2020-04-30 | Montgomery | Alabama | 1101 | 337 | 6 |
98216 | 98216 | 2020-04-29 | Montgomery | Alabama | 1101 | 318 | 6 |
95371 | 95371 | 2020-04-28 | Montgomery | Alabama | 1101 | 302 | 5 |
92541 | 92541 | 2020-04-27 | Montgomery | Alabama | 1101 | 292 | 5 |
89723 | 89723 | 2020-04-26 | Montgomery | Alabama | 1101 | 289 | 4 |
86907 | 86907 | 2020-04-25 | Montgomery | Alabama | 1101 | 284 | 4 |
84099 | 84099 | 2020-04-24 | Montgomery | Alabama | 1101 | 274 | 4 |
81298 | 81298 | 2020-04-23 | Montgomery | Alabama | 1101 | 263 | 3 |
78505 | 78505 | 2020-04-22 | Montgomery | Alabama | 1101 | 253 | 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);