ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Allen" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387054 | 387054 | 2020-07-31 | Allen | Louisiana | 22003 | 1036 | 19 |
383836 | 383836 | 2020-07-30 | Allen | Louisiana | 22003 | 1029 | 19 |
380619 | 380619 | 2020-07-29 | Allen | Louisiana | 22003 | 1021 | 18 |
377402 | 377402 | 2020-07-28 | Allen | Louisiana | 22003 | 1001 | 17 |
374187 | 374187 | 2020-07-27 | Allen | Louisiana | 22003 | 993 | 16 |
370975 | 370975 | 2020-07-26 | Allen | Louisiana | 22003 | 986 | 16 |
367765 | 367765 | 2020-07-25 | Allen | Louisiana | 22003 | 917 | 16 |
364558 | 364558 | 2020-07-24 | Allen | Louisiana | 22003 | 917 | 16 |
361351 | 361351 | 2020-07-23 | Allen | Louisiana | 22003 | 847 | 16 |
358146 | 358146 | 2020-07-22 | Allen | Louisiana | 22003 | 777 | 16 |
354943 | 354943 | 2020-07-21 | Allen | Louisiana | 22003 | 753 | 14 |
351741 | 351741 | 2020-07-20 | Allen | Louisiana | 22003 | 727 | 14 |
348541 | 348541 | 2020-07-19 | Allen | Louisiana | 22003 | 628 | 14 |
345340 | 345340 | 2020-07-18 | Allen | Louisiana | 22003 | 573 | 14 |
342140 | 342140 | 2020-07-17 | Allen | Louisiana | 22003 | 573 | 14 |
338944 | 338944 | 2020-07-16 | Allen | Louisiana | 22003 | 554 | 14 |
335748 | 335748 | 2020-07-15 | Allen | Louisiana | 22003 | 514 | 14 |
332555 | 332555 | 2020-07-14 | Allen | Louisiana | 22003 | 497 | 14 |
329368 | 329368 | 2020-07-13 | Allen | Louisiana | 22003 | 480 | 12 |
326182 | 326182 | 2020-07-12 | Allen | Louisiana | 22003 | 467 | 12 |
322999 | 322999 | 2020-07-11 | Allen | Louisiana | 22003 | 444 | 12 |
319820 | 319820 | 2020-07-10 | Allen | Louisiana | 22003 | 432 | 12 |
316645 | 316645 | 2020-07-09 | Allen | Louisiana | 22003 | 410 | 12 |
313471 | 313471 | 2020-07-08 | Allen | Louisiana | 22003 | 387 | 11 |
310301 | 310301 | 2020-07-07 | Allen | Louisiana | 22003 | 368 | 11 |
307133 | 307133 | 2020-07-06 | Allen | Louisiana | 22003 | 354 | 11 |
303966 | 303966 | 2020-07-05 | Allen | Louisiana | 22003 | 344 | 11 |
300802 | 300802 | 2020-07-04 | Allen | Louisiana | 22003 | 321 | 11 |
297640 | 297640 | 2020-07-03 | Allen | Louisiana | 22003 | 321 | 11 |
294482 | 294482 | 2020-07-02 | Allen | Louisiana | 22003 | 316 | 11 |
291328 | 291328 | 2020-07-01 | Allen | Louisiana | 22003 | 310 | 10 |
288177 | 288177 | 2020-06-30 | Allen | Louisiana | 22003 | 304 | 10 |
285028 | 285028 | 2020-06-29 | Allen | Louisiana | 22003 | 287 | 10 |
281882 | 281882 | 2020-06-28 | Allen | Louisiana | 22003 | 284 | 10 |
278734 | 278734 | 2020-06-27 | Allen | Louisiana | 22003 | 274 | 10 |
275586 | 275586 | 2020-06-26 | Allen | Louisiana | 22003 | 274 | 10 |
272443 | 272443 | 2020-06-25 | Allen | Louisiana | 22003 | 257 | 10 |
269307 | 269307 | 2020-06-24 | Allen | Louisiana | 22003 | 257 | 10 |
266174 | 266174 | 2020-06-23 | Allen | Louisiana | 22003 | 256 | 10 |
263047 | 263047 | 2020-06-22 | Allen | Louisiana | 22003 | 228 | 10 |
259918 | 259918 | 2020-06-21 | Allen | Louisiana | 22003 | 226 | 10 |
256792 | 256792 | 2020-06-20 | Allen | Louisiana | 22003 | 224 | 10 |
253672 | 253672 | 2020-06-19 | Allen | Louisiana | 22003 | 223 | 10 |
250557 | 250557 | 2020-06-18 | Allen | Louisiana | 22003 | 243 | 10 |
247445 | 247445 | 2020-06-17 | Allen | Louisiana | 22003 | 243 | 10 |
244332 | 244332 | 2020-06-16 | Allen | Louisiana | 22003 | 230 | 10 |
241221 | 241221 | 2020-06-15 | Allen | Louisiana | 22003 | 226 | 10 |
238112 | 238112 | 2020-06-14 | Allen | Louisiana | 22003 | 222 | 10 |
235005 | 235005 | 2020-06-13 | Allen | Louisiana | 22003 | 210 | 10 |
231900 | 231900 | 2020-06-12 | Allen | Louisiana | 22003 | 193 | 10 |
228796 | 228796 | 2020-06-11 | Allen | Louisiana | 22003 | 189 | 10 |
225694 | 225694 | 2020-06-10 | Allen | Louisiana | 22003 | 189 | 10 |
222598 | 222598 | 2020-06-09 | Allen | Louisiana | 22003 | 189 | 10 |
219503 | 219503 | 2020-06-08 | Allen | Louisiana | 22003 | 188 | 10 |
216411 | 216411 | 2020-06-07 | Allen | Louisiana | 22003 | 186 | 10 |
213324 | 213324 | 2020-06-06 | Allen | Louisiana | 22003 | 186 | 10 |
210239 | 210239 | 2020-06-05 | Allen | Louisiana | 22003 | 186 | 10 |
207158 | 207158 | 2020-06-04 | Allen | Louisiana | 22003 | 186 | 10 |
204077 | 204077 | 2020-06-03 | Allen | Louisiana | 22003 | 185 | 10 |
201000 | 201000 | 2020-06-02 | Allen | Louisiana | 22003 | 184 | 10 |
197928 | 197928 | 2020-06-01 | Allen | Louisiana | 22003 | 184 | 10 |
194857 | 194857 | 2020-05-31 | Allen | Louisiana | 22003 | 184 | 10 |
191789 | 191789 | 2020-05-30 | Allen | Louisiana | 22003 | 184 | 10 |
188725 | 188725 | 2020-05-29 | Allen | Louisiana | 22003 | 184 | 10 |
185667 | 185667 | 2020-05-28 | Allen | Louisiana | 22003 | 184 | 10 |
182612 | 182612 | 2020-05-27 | Allen | Louisiana | 22003 | 184 | 10 |
179567 | 179567 | 2020-05-26 | Allen | Louisiana | 22003 | 184 | 10 |
176523 | 176523 | 2020-05-25 | Allen | Louisiana | 22003 | 182 | 10 |
173479 | 173479 | 2020-05-24 | Allen | Louisiana | 22003 | 182 | 10 |
170438 | 170438 | 2020-05-23 | Allen | Louisiana | 22003 | 182 | 10 |
167400 | 167400 | 2020-05-22 | Allen | Louisiana | 22003 | 182 | 10 |
164364 | 164364 | 2020-05-21 | Allen | Louisiana | 22003 | 172 | 10 |
161335 | 161335 | 2020-05-20 | Allen | Louisiana | 22003 | 157 | 10 |
158309 | 158309 | 2020-05-19 | Allen | Louisiana | 22003 | 131 | 10 |
155291 | 155291 | 2020-05-18 | Allen | Louisiana | 22003 | 118 | 10 |
152277 | 152277 | 2020-05-17 | Allen | Louisiana | 22003 | 100 | 10 |
149266 | 149266 | 2020-05-16 | Allen | Louisiana | 22003 | 99 | 10 |
146261 | 146261 | 2020-05-15 | Allen | Louisiana | 22003 | 94 | 10 |
143261 | 143261 | 2020-05-14 | Allen | Louisiana | 22003 | 94 | 10 |
140266 | 140266 | 2020-05-13 | Allen | Louisiana | 22003 | 94 | 10 |
137272 | 137272 | 2020-05-12 | Allen | Louisiana | 22003 | 90 | 10 |
134282 | 134282 | 2020-05-11 | Allen | Louisiana | 22003 | 90 | 9 |
131291 | 131291 | 2020-05-10 | Allen | Louisiana | 22003 | 90 | 9 |
128301 | 128301 | 2020-05-09 | Allen | Louisiana | 22003 | 90 | 9 |
125314 | 125314 | 2020-05-08 | Allen | Louisiana | 22003 | 90 | 9 |
122332 | 122332 | 2020-05-07 | Allen | Louisiana | 22003 | 90 | 9 |
119361 | 119361 | 2020-05-06 | Allen | Louisiana | 22003 | 90 | 9 |
116400 | 116400 | 2020-05-05 | Allen | Louisiana | 22003 | 90 | 9 |
113518 | 113518 | 2020-05-04 | Allen | Louisiana | 22003 | 90 | 9 |
110641 | 110641 | 2020-05-03 | Allen | Louisiana | 22003 | 90 | 9 |
107769 | 107769 | 2020-05-02 | Allen | Louisiana | 22003 | 90 | 9 |
104905 | 104905 | 2020-05-01 | Allen | Louisiana | 22003 | 90 | 9 |
102044 | 102044 | 2020-04-30 | Allen | Louisiana | 22003 | 90 | 9 |
99192 | 99192 | 2020-04-29 | Allen | Louisiana | 22003 | 90 | 9 |
96346 | 96346 | 2020-04-28 | Allen | Louisiana | 22003 | 90 | 9 |
93511 | 93511 | 2020-04-27 | Allen | Louisiana | 22003 | 87 | 9 |
90690 | 90690 | 2020-04-26 | Allen | Louisiana | 22003 | 82 | 9 |
87874 | 87874 | 2020-04-25 | Allen | Louisiana | 22003 | 82 | 9 |
85065 | 85065 | 2020-04-24 | Allen | Louisiana | 22003 | 81 | 9 |
82261 | 82261 | 2020-04-23 | Allen | Louisiana | 22003 | 81 | 9 |
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);