ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lamar" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382759 | 382759 | 2020-07-30 | Lamar | Alabama | 1075 | 194 | 2 |
379542 | 379542 | 2020-07-29 | Lamar | Alabama | 1075 | 182 | 2 |
376326 | 376326 | 2020-07-28 | Lamar | Alabama | 1075 | 178 | 1 |
373112 | 373112 | 2020-07-27 | Lamar | Alabama | 1075 | 171 | 1 |
369900 | 369900 | 2020-07-26 | Lamar | Alabama | 1075 | 165 | 1 |
366690 | 366690 | 2020-07-25 | Lamar | Alabama | 1075 | 165 | 1 |
363483 | 363483 | 2020-07-24 | Lamar | Alabama | 1075 | 162 | 1 |
360277 | 360277 | 2020-07-23 | Lamar | Alabama | 1075 | 156 | 1 |
357072 | 357072 | 2020-07-22 | Lamar | Alabama | 1075 | 147 | 1 |
353869 | 353869 | 2020-07-21 | Lamar | Alabama | 1075 | 141 | 1 |
350667 | 350667 | 2020-07-20 | Lamar | Alabama | 1075 | 135 | 1 |
347466 | 347466 | 2020-07-19 | Lamar | Alabama | 1075 | 130 | 1 |
344266 | 344266 | 2020-07-18 | Lamar | Alabama | 1075 | 118 | 1 |
341067 | 341067 | 2020-07-17 | Lamar | Alabama | 1075 | 115 | 1 |
337871 | 337871 | 2020-07-16 | Lamar | Alabama | 1075 | 102 | 1 |
334676 | 334676 | 2020-07-15 | Lamar | Alabama | 1075 | 97 | 1 |
331483 | 331483 | 2020-07-14 | Lamar | Alabama | 1075 | 96 | 1 |
328297 | 328297 | 2020-07-13 | Lamar | Alabama | 1075 | 90 | 1 |
325111 | 325111 | 2020-07-12 | Lamar | Alabama | 1075 | 90 | 1 |
321930 | 321930 | 2020-07-11 | Lamar | Alabama | 1075 | 88 | 1 |
318751 | 318751 | 2020-07-10 | Lamar | Alabama | 1075 | 88 | 1 |
315578 | 315578 | 2020-07-09 | Lamar | Alabama | 1075 | 82 | 1 |
312403 | 312403 | 2020-07-08 | Lamar | Alabama | 1075 | 81 | 1 |
309234 | 309234 | 2020-07-07 | Lamar | Alabama | 1075 | 81 | 1 |
306065 | 306065 | 2020-07-06 | Lamar | Alabama | 1075 | 79 | 1 |
302901 | 302901 | 2020-07-05 | Lamar | Alabama | 1075 | 78 | 1 |
299737 | 299737 | 2020-07-04 | Lamar | Alabama | 1075 | 76 | 1 |
296575 | 296575 | 2020-07-03 | Lamar | Alabama | 1075 | 76 | 1 |
293420 | 293420 | 2020-07-02 | Lamar | Alabama | 1075 | 72 | 1 |
290267 | 290267 | 2020-07-01 | Lamar | Alabama | 1075 | 72 | 1 |
287117 | 287117 | 2020-06-30 | Lamar | Alabama | 1075 | 72 | 1 |
283971 | 283971 | 2020-06-29 | Lamar | Alabama | 1075 | 71 | 1 |
280825 | 280825 | 2020-06-28 | Lamar | Alabama | 1075 | 69 | 1 |
277677 | 277677 | 2020-06-27 | Lamar | Alabama | 1075 | 65 | 1 |
274529 | 274529 | 2020-06-26 | Lamar | Alabama | 1075 | 64 | 1 |
271389 | 271389 | 2020-06-25 | Lamar | Alabama | 1075 | 63 | 0 |
268255 | 268255 | 2020-06-24 | Lamar | Alabama | 1075 | 60 | 0 |
265126 | 265126 | 2020-06-23 | Lamar | Alabama | 1075 | 58 | 0 |
261997 | 261997 | 2020-06-22 | Lamar | Alabama | 1075 | 56 | 0 |
258870 | 258870 | 2020-06-21 | Lamar | Alabama | 1075 | 55 | 0 |
255743 | 255743 | 2020-06-20 | Lamar | Alabama | 1075 | 55 | 0 |
252624 | 252624 | 2020-06-19 | Lamar | Alabama | 1075 | 55 | 0 |
249509 | 249509 | 2020-06-18 | Lamar | Alabama | 1075 | 53 | 0 |
246397 | 246397 | 2020-06-17 | Lamar | Alabama | 1075 | 51 | 0 |
243284 | 243284 | 2020-06-16 | Lamar | Alabama | 1075 | 50 | 0 |
240173 | 240173 | 2020-06-15 | Lamar | Alabama | 1075 | 46 | 0 |
237065 | 237065 | 2020-06-14 | Lamar | Alabama | 1075 | 44 | 0 |
233958 | 233958 | 2020-06-13 | Lamar | Alabama | 1075 | 36 | 0 |
230853 | 230853 | 2020-06-12 | Lamar | Alabama | 1075 | 35 | 0 |
227749 | 227749 | 2020-06-11 | Lamar | Alabama | 1075 | 31 | 0 |
224648 | 224648 | 2020-06-10 | Lamar | Alabama | 1075 | 31 | 0 |
221552 | 221552 | 2020-06-09 | Lamar | Alabama | 1075 | 30 | 0 |
218460 | 218460 | 2020-06-08 | Lamar | Alabama | 1075 | 30 | 0 |
215370 | 215370 | 2020-06-07 | Lamar | Alabama | 1075 | 30 | 1 |
212283 | 212283 | 2020-06-06 | Lamar | Alabama | 1075 | 29 | 1 |
209198 | 209198 | 2020-06-05 | Lamar | Alabama | 1075 | 29 | 1 |
206116 | 206116 | 2020-06-04 | Lamar | Alabama | 1075 | 28 | 0 |
203037 | 203037 | 2020-06-03 | Lamar | Alabama | 1075 | 26 | 0 |
199961 | 199961 | 2020-06-02 | Lamar | Alabama | 1075 | 26 | 0 |
196888 | 196888 | 2020-06-01 | Lamar | Alabama | 1075 | 26 | 0 |
193818 | 193818 | 2020-05-31 | Lamar | Alabama | 1075 | 26 | 0 |
190752 | 190752 | 2020-05-30 | Lamar | Alabama | 1075 | 23 | 0 |
187688 | 187688 | 2020-05-29 | Lamar | Alabama | 1075 | 23 | 0 |
184631 | 184631 | 2020-05-28 | Lamar | Alabama | 1075 | 21 | 0 |
181579 | 181579 | 2020-05-27 | Lamar | Alabama | 1075 | 21 | 0 |
178535 | 178535 | 2020-05-26 | Lamar | Alabama | 1075 | 21 | 0 |
175490 | 175490 | 2020-05-25 | Lamar | Alabama | 1075 | 20 | 0 |
172447 | 172447 | 2020-05-24 | Lamar | Alabama | 1075 | 20 | 0 |
169406 | 169406 | 2020-05-23 | Lamar | Alabama | 1075 | 18 | 0 |
166370 | 166370 | 2020-05-22 | Lamar | Alabama | 1075 | 17 | 0 |
163338 | 163338 | 2020-05-21 | Lamar | Alabama | 1075 | 18 | 0 |
160310 | 160310 | 2020-05-20 | Lamar | Alabama | 1075 | 15 | 0 |
157286 | 157286 | 2020-05-19 | Lamar | Alabama | 1075 | 15 | 0 |
154270 | 154270 | 2020-05-18 | Lamar | Alabama | 1075 | 15 | 0 |
151258 | 151258 | 2020-05-17 | Lamar | Alabama | 1075 | 15 | 0 |
148249 | 148249 | 2020-05-16 | Lamar | Alabama | 1075 | 15 | 0 |
145246 | 145246 | 2020-05-15 | Lamar | Alabama | 1075 | 14 | 0 |
142247 | 142247 | 2020-05-14 | Lamar | Alabama | 1075 | 14 | 0 |
139251 | 139251 | 2020-05-13 | Lamar | Alabama | 1075 | 14 | 0 |
136260 | 136260 | 2020-05-12 | Lamar | Alabama | 1075 | 13 | 0 |
133270 | 133270 | 2020-05-11 | Lamar | Alabama | 1075 | 13 | 0 |
130280 | 130280 | 2020-05-10 | Lamar | Alabama | 1075 | 13 | 0 |
127290 | 127290 | 2020-05-09 | Lamar | Alabama | 1075 | 13 | 0 |
124305 | 124305 | 2020-05-08 | Lamar | Alabama | 1075 | 13 | 0 |
121325 | 121325 | 2020-05-07 | Lamar | Alabama | 1075 | 13 | 0 |
118359 | 118359 | 2020-05-06 | Lamar | Alabama | 1075 | 13 | 0 |
115400 | 115400 | 2020-05-05 | Lamar | Alabama | 1075 | 13 | 0 |
112517 | 112517 | 2020-05-04 | Lamar | Alabama | 1075 | 12 | 0 |
109642 | 109642 | 2020-05-03 | Lamar | Alabama | 1075 | 11 | 0 |
106773 | 106773 | 2020-05-02 | Lamar | Alabama | 1075 | 11 | 0 |
103908 | 103908 | 2020-05-01 | Lamar | Alabama | 1075 | 11 | 0 |
101053 | 101053 | 2020-04-30 | Lamar | Alabama | 1075 | 11 | 0 |
98203 | 98203 | 2020-04-29 | Lamar | Alabama | 1075 | 10 | 0 |
95358 | 95358 | 2020-04-28 | Lamar | Alabama | 1075 | 10 | 0 |
92528 | 92528 | 2020-04-27 | Lamar | Alabama | 1075 | 10 | 0 |
89710 | 89710 | 2020-04-26 | Lamar | Alabama | 1075 | 10 | 0 |
86894 | 86894 | 2020-04-25 | Lamar | Alabama | 1075 | 10 | 0 |
84086 | 84086 | 2020-04-24 | Lamar | Alabama | 1075 | 10 | 0 |
81285 | 81285 | 2020-04-23 | Lamar | Alabama | 1075 | 9 | 0 |
78492 | 78492 | 2020-04-22 | Lamar | Alabama | 1075 | 8 | 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);