ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1073 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382758 | 382758 | 2020-07-30 | Jefferson | Alabama | 1073 | 11111 | 222 |
379541 | 379541 | 2020-07-29 | Jefferson | Alabama | 1073 | 10847 | 210 |
376325 | 376325 | 2020-07-28 | Jefferson | Alabama | 1073 | 10715 | 205 |
373111 | 373111 | 2020-07-27 | Jefferson | Alabama | 1073 | 10567 | 205 |
369899 | 369899 | 2020-07-26 | Jefferson | Alabama | 1073 | 10405 | 204 |
366689 | 366689 | 2020-07-25 | Jefferson | Alabama | 1073 | 10236 | 202 |
363482 | 363482 | 2020-07-24 | Jefferson | Alabama | 1073 | 9940 | 199 |
360276 | 360276 | 2020-07-23 | Jefferson | Alabama | 1073 | 9676 | 199 |
357071 | 357071 | 2020-07-22 | Jefferson | Alabama | 1073 | 9400 | 192 |
353868 | 353868 | 2020-07-21 | Jefferson | Alabama | 1073 | 9190 | 190 |
350666 | 350666 | 2020-07-20 | Jefferson | Alabama | 1073 | 9003 | 187 |
347465 | 347465 | 2020-07-19 | Jefferson | Alabama | 1073 | 8742 | 185 |
344265 | 344265 | 2020-07-18 | Jefferson | Alabama | 1073 | 8499 | 185 |
341066 | 341066 | 2020-07-17 | Jefferson | Alabama | 1073 | 8201 | 184 |
337870 | 337870 | 2020-07-16 | Jefferson | Alabama | 1073 | 7900 | 183 |
334675 | 334675 | 2020-07-15 | Jefferson | Alabama | 1073 | 7540 | 178 |
331482 | 331482 | 2020-07-14 | Jefferson | Alabama | 1073 | 7265 | 176 |
328296 | 328296 | 2020-07-13 | Jefferson | Alabama | 1073 | 7091 | 172 |
325110 | 325110 | 2020-07-12 | Jefferson | Alabama | 1073 | 6823 | 172 |
321929 | 321929 | 2020-07-11 | Jefferson | Alabama | 1073 | 6504 | 172 |
318750 | 318750 | 2020-07-10 | Jefferson | Alabama | 1073 | 6283 | 169 |
315577 | 315577 | 2020-07-09 | Jefferson | Alabama | 1073 | 6092 | 164 |
312402 | 312402 | 2020-07-08 | Jefferson | Alabama | 1073 | 5741 | 163 |
309233 | 309233 | 2020-07-07 | Jefferson | Alabama | 1073 | 5538 | 157 |
306064 | 306064 | 2020-07-06 | Jefferson | Alabama | 1073 | 5461 | 154 |
302900 | 302900 | 2020-07-05 | Jefferson | Alabama | 1073 | 5272 | 154 |
299736 | 299736 | 2020-07-04 | Jefferson | Alabama | 1073 | 4995 | 154 |
296574 | 296574 | 2020-07-03 | Jefferson | Alabama | 1073 | 4853 | 154 |
293419 | 293419 | 2020-07-02 | Jefferson | Alabama | 1073 | 4581 | 145 |
290266 | 290266 | 2020-07-01 | Jefferson | Alabama | 1073 | 4436 | 144 |
287116 | 287116 | 2020-06-30 | Jefferson | Alabama | 1073 | 4258 | 142 |
283970 | 283970 | 2020-06-29 | Jefferson | Alabama | 1073 | 4099 | 136 |
280824 | 280824 | 2020-06-28 | Jefferson | Alabama | 1073 | 3729 | 135 |
277676 | 277676 | 2020-06-27 | Jefferson | Alabama | 1073 | 3651 | 135 |
274528 | 274528 | 2020-06-26 | Jefferson | Alabama | 1073 | 3528 | 131 |
271388 | 271388 | 2020-06-25 | Jefferson | Alabama | 1073 | 3378 | 131 |
268254 | 268254 | 2020-06-24 | Jefferson | Alabama | 1073 | 3232 | 130 |
265125 | 265125 | 2020-06-23 | Jefferson | Alabama | 1073 | 3144 | 127 |
261996 | 261996 | 2020-06-22 | Jefferson | Alabama | 1073 | 3069 | 126 |
258869 | 258869 | 2020-06-21 | Jefferson | Alabama | 1073 | 2987 | 126 |
255742 | 255742 | 2020-06-20 | Jefferson | Alabama | 1073 | 2903 | 126 |
252623 | 252623 | 2020-06-19 | Jefferson | Alabama | 1073 | 2835 | 124 |
249508 | 249508 | 2020-06-18 | Jefferson | Alabama | 1073 | 2749 | 125 |
246396 | 246396 | 2020-06-17 | Jefferson | Alabama | 1073 | 2687 | 121 |
243283 | 243283 | 2020-06-16 | Jefferson | Alabama | 1073 | 2636 | 119 |
240172 | 240172 | 2020-06-15 | Jefferson | Alabama | 1073 | 2571 | 118 |
237064 | 237064 | 2020-06-14 | Jefferson | Alabama | 1073 | 2509 | 118 |
233957 | 233957 | 2020-06-13 | Jefferson | Alabama | 1073 | 2444 | 118 |
230852 | 230852 | 2020-06-12 | Jefferson | Alabama | 1073 | 2373 | 118 |
227748 | 227748 | 2020-06-11 | Jefferson | Alabama | 1073 | 2282 | 117 |
224647 | 224647 | 2020-06-10 | Jefferson | Alabama | 1073 | 2219 | 113 |
221551 | 221551 | 2020-06-09 | Jefferson | Alabama | 1073 | 2162 | 111 |
218459 | 218459 | 2020-06-08 | Jefferson | Alabama | 1073 | 2109 | 110 |
215369 | 215369 | 2020-06-07 | Jefferson | Alabama | 1073 | 2070 | 107 |
212282 | 212282 | 2020-06-06 | Jefferson | Alabama | 1073 | 2011 | 106 |
209197 | 209197 | 2020-06-05 | Jefferson | Alabama | 1073 | 1957 | 106 |
206115 | 206115 | 2020-06-04 | Jefferson | Alabama | 1073 | 1931 | 105 |
203036 | 203036 | 2020-06-03 | Jefferson | Alabama | 1073 | 1913 | 104 |
199960 | 199960 | 2020-06-02 | Jefferson | Alabama | 1073 | 1911 | 104 |
196887 | 196887 | 2020-06-01 | Jefferson | Alabama | 1073 | 1886 | 104 |
193817 | 193817 | 2020-05-31 | Jefferson | Alabama | 1073 | 1837 | 102 |
190751 | 190751 | 2020-05-30 | Jefferson | Alabama | 1073 | 1780 | 102 |
187687 | 187687 | 2020-05-29 | Jefferson | Alabama | 1073 | 1744 | 102 |
184630 | 184630 | 2020-05-28 | Jefferson | Alabama | 1073 | 1712 | 100 |
181578 | 181578 | 2020-05-27 | Jefferson | Alabama | 1073 | 1673 | 97 |
178534 | 178534 | 2020-05-26 | Jefferson | Alabama | 1073 | 1645 | 96 |
175489 | 175489 | 2020-05-25 | Jefferson | Alabama | 1073 | 1630 | 91 |
172446 | 172446 | 2020-05-24 | Jefferson | Alabama | 1073 | 1614 | 88 |
169405 | 169405 | 2020-05-23 | Jefferson | Alabama | 1073 | 1575 | 88 |
166369 | 166369 | 2020-05-22 | Jefferson | Alabama | 1073 | 1498 | 88 |
163337 | 163337 | 2020-05-21 | Jefferson | Alabama | 1073 | 1469 | 85 |
160309 | 160309 | 2020-05-20 | Jefferson | Alabama | 1073 | 1433 | 83 |
157285 | 157285 | 2020-05-19 | Jefferson | Alabama | 1073 | 1367 | 78 |
154269 | 154269 | 2020-05-18 | Jefferson | Alabama | 1073 | 1355 | 74 |
151257 | 151257 | 2020-05-17 | Jefferson | Alabama | 1073 | 1333 | 74 |
148248 | 148248 | 2020-05-16 | Jefferson | Alabama | 1073 | 1299 | 73 |
145245 | 145245 | 2020-05-15 | Jefferson | Alabama | 1073 | 1258 | 71 |
142246 | 142246 | 2020-05-14 | Jefferson | Alabama | 1073 | 1237 | 69 |
139250 | 139250 | 2020-05-13 | Jefferson | Alabama | 1073 | 1199 | 64 |
136259 | 136259 | 2020-05-12 | Jefferson | Alabama | 1073 | 1153 | 62 |
133269 | 133269 | 2020-05-11 | Jefferson | Alabama | 1073 | 1131 | 61 |
130279 | 130279 | 2020-05-10 | Jefferson | Alabama | 1073 | 1121 | 60 |
127289 | 127289 | 2020-05-09 | Jefferson | Alabama | 1073 | 1109 | 60 |
124304 | 124304 | 2020-05-08 | Jefferson | Alabama | 1073 | 1094 | 59 |
121324 | 121324 | 2020-05-07 | Jefferson | Alabama | 1073 | 1065 | 57 |
118358 | 118358 | 2020-05-06 | Jefferson | Alabama | 1073 | 1048 | 53 |
115399 | 115399 | 2020-05-05 | Jefferson | Alabama | 1073 | 1020 | 49 |
112516 | 112516 | 2020-05-04 | Jefferson | Alabama | 1073 | 992 | 48 |
109641 | 109641 | 2020-05-03 | Jefferson | Alabama | 1073 | 969 | 48 |
106772 | 106772 | 2020-05-02 | Jefferson | Alabama | 1073 | 946 | 48 |
103907 | 103907 | 2020-05-01 | Jefferson | Alabama | 1073 | 929 | 48 |
101052 | 101052 | 2020-04-30 | Jefferson | Alabama | 1073 | 886 | 46 |
98202 | 98202 | 2020-04-29 | Jefferson | Alabama | 1073 | 881 | 44 |
95357 | 95357 | 2020-04-28 | Jefferson | Alabama | 1073 | 861 | 41 |
92527 | 92527 | 2020-04-27 | Jefferson | Alabama | 1073 | 839 | 36 |
89709 | 89709 | 2020-04-26 | Jefferson | Alabama | 1073 | 839 | 33 |
86893 | 86893 | 2020-04-25 | Jefferson | Alabama | 1073 | 828 | 33 |
84085 | 84085 | 2020-04-24 | Jefferson | Alabama | 1073 | 797 | 33 |
81284 | 81284 | 2020-04-23 | Jefferson | Alabama | 1073 | 778 | 31 |
78491 | 78491 | 2020-04-22 | Jefferson | Alabama | 1073 | 744 | 31 |
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);