ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Mobile" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382770 | 382770 | 2020-07-30 | Mobile | Alabama | 1097 | 7915 | 186 |
379553 | 379553 | 2020-07-29 | Mobile | Alabama | 1097 | 7717 | 185 |
376337 | 376337 | 2020-07-28 | Mobile | Alabama | 1097 | 7528 | 182 |
373123 | 373123 | 2020-07-27 | Mobile | Alabama | 1097 | 7394 | 181 |
369911 | 369911 | 2020-07-26 | Mobile | Alabama | 1097 | 7226 | 180 |
366701 | 366701 | 2020-07-25 | Mobile | Alabama | 1097 | 7129 | 180 |
363494 | 363494 | 2020-07-24 | Mobile | Alabama | 1097 | 6932 | 175 |
360288 | 360288 | 2020-07-23 | Mobile | Alabama | 1097 | 6829 | 176 |
357083 | 357083 | 2020-07-22 | Mobile | Alabama | 1097 | 6473 | 174 |
353880 | 353880 | 2020-07-21 | Mobile | Alabama | 1097 | 6308 | 166 |
350678 | 350678 | 2020-07-20 | Mobile | Alabama | 1097 | 6178 | 166 |
347477 | 347477 | 2020-07-19 | Mobile | Alabama | 1097 | 6045 | 166 |
344277 | 344277 | 2020-07-18 | Mobile | Alabama | 1097 | 5927 | 166 |
341078 | 341078 | 2020-07-17 | Mobile | Alabama | 1097 | 5740 | 166 |
337882 | 337882 | 2020-07-16 | Mobile | Alabama | 1097 | 5540 | 163 |
334687 | 334687 | 2020-07-15 | Mobile | Alabama | 1097 | 5375 | 162 |
331494 | 331494 | 2020-07-14 | Mobile | Alabama | 1097 | 5231 | 152 |
328308 | 328308 | 2020-07-13 | Mobile | Alabama | 1097 | 5086 | 145 |
325122 | 325122 | 2020-07-12 | Mobile | Alabama | 1097 | 4929 | 145 |
321941 | 321941 | 2020-07-11 | Mobile | Alabama | 1097 | 4778 | 144 |
318762 | 318762 | 2020-07-10 | Mobile | Alabama | 1097 | 4649 | 142 |
315589 | 315589 | 2020-07-09 | Mobile | Alabama | 1097 | 4442 | 141 |
312414 | 312414 | 2020-07-08 | Mobile | Alabama | 1097 | 4339 | 140 |
309245 | 309245 | 2020-07-07 | Mobile | Alabama | 1097 | 4243 | 140 |
306076 | 306076 | 2020-07-06 | Mobile | Alabama | 1097 | 4153 | 138 |
302912 | 302912 | 2020-07-05 | Mobile | Alabama | 1097 | 4104 | 138 |
299748 | 299748 | 2020-07-04 | Mobile | Alabama | 1097 | 4029 | 138 |
296586 | 296586 | 2020-07-03 | Mobile | Alabama | 1097 | 3928 | 138 |
293431 | 293431 | 2020-07-02 | Mobile | Alabama | 1097 | 3823 | 138 |
290278 | 290278 | 2020-07-01 | Mobile | Alabama | 1097 | 3724 | 138 |
287128 | 287128 | 2020-06-30 | Mobile | Alabama | 1097 | 3660 | 138 |
283982 | 283982 | 2020-06-29 | Mobile | Alabama | 1097 | 3562 | 137 |
280836 | 280836 | 2020-06-28 | Mobile | Alabama | 1097 | 3441 | 135 |
277688 | 277688 | 2020-06-27 | Mobile | Alabama | 1097 | 3385 | 135 |
274540 | 274540 | 2020-06-26 | Mobile | Alabama | 1097 | 3294 | 135 |
271400 | 271400 | 2020-06-25 | Mobile | Alabama | 1097 | 3241 | 135 |
268266 | 268266 | 2020-06-24 | Mobile | Alabama | 1097 | 3186 | 135 |
265137 | 265137 | 2020-06-23 | Mobile | Alabama | 1097 | 3074 | 133 |
262008 | 262008 | 2020-06-22 | Mobile | Alabama | 1097 | 3036 | 133 |
258881 | 258881 | 2020-06-21 | Mobile | Alabama | 1097 | 3016 | 133 |
255754 | 255754 | 2020-06-20 | Mobile | Alabama | 1097 | 2954 | 133 |
252635 | 252635 | 2020-06-19 | Mobile | Alabama | 1097 | 2921 | 132 |
249520 | 249520 | 2020-06-18 | Mobile | Alabama | 1097 | 2856 | 131 |
246408 | 246408 | 2020-06-17 | Mobile | Alabama | 1097 | 2808 | 130 |
243295 | 243295 | 2020-06-16 | Mobile | Alabama | 1097 | 2790 | 129 |
240184 | 240184 | 2020-06-15 | Mobile | Alabama | 1097 | 2742 | 129 |
237076 | 237076 | 2020-06-14 | Mobile | Alabama | 1097 | 2716 | 129 |
233969 | 233969 | 2020-06-13 | Mobile | Alabama | 1097 | 2679 | 129 |
230864 | 230864 | 2020-06-12 | Mobile | Alabama | 1097 | 2642 | 129 |
227760 | 227760 | 2020-06-11 | Mobile | Alabama | 1097 | 2612 | 128 |
224659 | 224659 | 2020-06-10 | Mobile | Alabama | 1097 | 2563 | 127 |
221563 | 221563 | 2020-06-09 | Mobile | Alabama | 1097 | 2504 | 126 |
218471 | 218471 | 2020-06-08 | Mobile | Alabama | 1097 | 2478 | 124 |
215381 | 215381 | 2020-06-07 | Mobile | Alabama | 1097 | 2450 | 125 |
212294 | 212294 | 2020-06-06 | Mobile | Alabama | 1097 | 2394 | 125 |
209209 | 209209 | 2020-06-05 | Mobile | Alabama | 1097 | 2352 | 124 |
206127 | 206127 | 2020-06-04 | Mobile | Alabama | 1097 | 2330 | 118 |
203048 | 203048 | 2020-06-03 | Mobile | Alabama | 1097 | 2293 | 118 |
199972 | 199972 | 2020-06-02 | Mobile | Alabama | 1097 | 2292 | 118 |
196899 | 196899 | 2020-06-01 | Mobile | Alabama | 1097 | 2280 | 118 |
193829 | 193829 | 2020-05-31 | Mobile | Alabama | 1097 | 2239 | 116 |
190763 | 190763 | 2020-05-30 | Mobile | Alabama | 1097 | 2191 | 115 |
187699 | 187699 | 2020-05-29 | Mobile | Alabama | 1097 | 2162 | 114 |
184642 | 184642 | 2020-05-28 | Mobile | Alabama | 1097 | 2124 | 112 |
181590 | 181590 | 2020-05-27 | Mobile | Alabama | 1097 | 2085 | 112 |
178546 | 178546 | 2020-05-26 | Mobile | Alabama | 1097 | 2054 | 112 |
175501 | 175501 | 2020-05-25 | Mobile | Alabama | 1097 | 2033 | 111 |
172458 | 172458 | 2020-05-24 | Mobile | Alabama | 1097 | 1996 | 109 |
169417 | 169417 | 2020-05-23 | Mobile | Alabama | 1097 | 1982 | 109 |
166381 | 166381 | 2020-05-22 | Mobile | Alabama | 1097 | 1916 | 107 |
163349 | 163349 | 2020-05-21 | Mobile | Alabama | 1097 | 1874 | 107 |
160321 | 160321 | 2020-05-20 | Mobile | Alabama | 1097 | 1822 | 106 |
157297 | 157297 | 2020-05-19 | Mobile | Alabama | 1097 | 1751 | 103 |
154281 | 154281 | 2020-05-18 | Mobile | Alabama | 1097 | 1735 | 101 |
151269 | 151269 | 2020-05-17 | Mobile | Alabama | 1097 | 1701 | 101 |
148260 | 148260 | 2020-05-16 | Mobile | Alabama | 1097 | 1681 | 100 |
145257 | 145257 | 2020-05-15 | Mobile | Alabama | 1097 | 1653 | 100 |
142258 | 142258 | 2020-05-14 | Mobile | Alabama | 1097 | 1608 | 98 |
139262 | 139262 | 2020-05-13 | Mobile | Alabama | 1097 | 1545 | 96 |
136271 | 136271 | 2020-05-12 | Mobile | Alabama | 1097 | 1507 | 95 |
133281 | 133281 | 2020-05-11 | Mobile | Alabama | 1097 | 1474 | 90 |
130291 | 130291 | 2020-05-10 | Mobile | Alabama | 1097 | 1461 | 85 |
127301 | 127301 | 2020-05-09 | Mobile | Alabama | 1097 | 1452 | 83 |
124316 | 124316 | 2020-05-08 | Mobile | Alabama | 1097 | 1407 | 81 |
121336 | 121336 | 2020-05-07 | Mobile | Alabama | 1097 | 1355 | 78 |
118370 | 118370 | 2020-05-06 | Mobile | Alabama | 1097 | 1311 | 76 |
115411 | 115411 | 2020-05-05 | Mobile | Alabama | 1097 | 1265 | 71 |
112528 | 112528 | 2020-05-04 | Mobile | Alabama | 1097 | 1222 | 66 |
109653 | 109653 | 2020-05-03 | Mobile | Alabama | 1097 | 1198 | 62 |
106784 | 106784 | 2020-05-02 | Mobile | Alabama | 1097 | 1172 | 61 |
103919 | 103919 | 2020-05-01 | Mobile | Alabama | 1097 | 1099 | 61 |
101064 | 101064 | 2020-04-30 | Mobile | Alabama | 1097 | 1057 | 55 |
98214 | 98214 | 2020-04-29 | Mobile | Alabama | 1097 | 1041 | 53 |
95369 | 95369 | 2020-04-28 | Mobile | Alabama | 1097 | 994 | 46 |
92539 | 92539 | 2020-04-27 | Mobile | Alabama | 1097 | 942 | 43 |
89721 | 89721 | 2020-04-26 | Mobile | Alabama | 1097 | 917 | 41 |
86905 | 86905 | 2020-04-25 | Mobile | Alabama | 1097 | 888 | 40 |
84097 | 84097 | 2020-04-24 | Mobile | Alabama | 1097 | 845 | 40 |
81296 | 81296 | 2020-04-23 | Mobile | Alabama | 1097 | 810 | 38 |
78503 | 78503 | 2020-04-22 | Mobile | Alabama | 1097 | 759 | 39 |
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);