ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 22015 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387060 | 387060 | 2020-07-31 | Bossier | Louisiana | 22015 | 2054 | 67 |
383842 | 383842 | 2020-07-30 | Bossier | Louisiana | 22015 | 2017 | 66 |
380625 | 380625 | 2020-07-29 | Bossier | Louisiana | 22015 | 1978 | 64 |
377408 | 377408 | 2020-07-28 | Bossier | Louisiana | 22015 | 1926 | 63 |
374193 | 374193 | 2020-07-27 | Bossier | Louisiana | 22015 | 1894 | 60 |
370981 | 370981 | 2020-07-26 | Bossier | Louisiana | 22015 | 1855 | 60 |
367771 | 367771 | 2020-07-25 | Bossier | Louisiana | 22015 | 1776 | 58 |
364564 | 364564 | 2020-07-24 | Bossier | Louisiana | 22015 | 1776 | 58 |
361357 | 361357 | 2020-07-23 | Bossier | Louisiana | 22015 | 1742 | 53 |
358152 | 358152 | 2020-07-22 | Bossier | Louisiana | 22015 | 1701 | 53 |
354949 | 354949 | 2020-07-21 | Bossier | Louisiana | 22015 | 1655 | 52 |
351747 | 351747 | 2020-07-20 | Bossier | Louisiana | 22015 | 1602 | 47 |
348547 | 348547 | 2020-07-19 | Bossier | Louisiana | 22015 | 1564 | 45 |
345346 | 345346 | 2020-07-18 | Bossier | Louisiana | 22015 | 1474 | 43 |
342146 | 342146 | 2020-07-17 | Bossier | Louisiana | 22015 | 1474 | 43 |
338950 | 338950 | 2020-07-16 | Bossier | Louisiana | 22015 | 1432 | 41 |
335754 | 335754 | 2020-07-15 | Bossier | Louisiana | 22015 | 1403 | 39 |
332561 | 332561 | 2020-07-14 | Bossier | Louisiana | 22015 | 1370 | 39 |
329374 | 329374 | 2020-07-13 | Bossier | Louisiana | 22015 | 1315 | 39 |
326188 | 326188 | 2020-07-12 | Bossier | Louisiana | 22015 | 1274 | 39 |
323005 | 323005 | 2020-07-11 | Bossier | Louisiana | 22015 | 1254 | 38 |
319826 | 319826 | 2020-07-10 | Bossier | Louisiana | 22015 | 1219 | 37 |
316651 | 316651 | 2020-07-09 | Bossier | Louisiana | 22015 | 1177 | 36 |
313477 | 313477 | 2020-07-08 | Bossier | Louisiana | 22015 | 1142 | 36 |
310307 | 310307 | 2020-07-07 | Bossier | Louisiana | 22015 | 1099 | 36 |
307139 | 307139 | 2020-07-06 | Bossier | Louisiana | 22015 | 1030 | 35 |
303972 | 303972 | 2020-07-05 | Bossier | Louisiana | 22015 | 1007 | 35 |
300808 | 300808 | 2020-07-04 | Bossier | Louisiana | 22015 | 971 | 33 |
297646 | 297646 | 2020-07-03 | Bossier | Louisiana | 22015 | 971 | 33 |
294488 | 294488 | 2020-07-02 | Bossier | Louisiana | 22015 | 947 | 32 |
291334 | 291334 | 2020-07-01 | Bossier | Louisiana | 22015 | 906 | 31 |
288183 | 288183 | 2020-06-30 | Bossier | Louisiana | 22015 | 875 | 30 |
285034 | 285034 | 2020-06-29 | Bossier | Louisiana | 22015 | 836 | 29 |
281888 | 281888 | 2020-06-28 | Bossier | Louisiana | 22015 | 825 | 29 |
278740 | 278740 | 2020-06-27 | Bossier | Louisiana | 22015 | 780 | 29 |
275592 | 275592 | 2020-06-26 | Bossier | Louisiana | 22015 | 780 | 29 |
272449 | 272449 | 2020-06-25 | Bossier | Louisiana | 22015 | 751 | 28 |
269313 | 269313 | 2020-06-24 | Bossier | Louisiana | 22015 | 720 | 28 |
266180 | 266180 | 2020-06-23 | Bossier | Louisiana | 22015 | 697 | 28 |
263053 | 263053 | 2020-06-22 | Bossier | Louisiana | 22015 | 668 | 28 |
259924 | 259924 | 2020-06-21 | Bossier | Louisiana | 22015 | 665 | 28 |
256798 | 256798 | 2020-06-20 | Bossier | Louisiana | 22015 | 654 | 28 |
253678 | 253678 | 2020-06-19 | Bossier | Louisiana | 22015 | 643 | 28 |
250563 | 250563 | 2020-06-18 | Bossier | Louisiana | 22015 | 528 | 28 |
247451 | 247451 | 2020-06-17 | Bossier | Louisiana | 22015 | 528 | 28 |
244338 | 244338 | 2020-06-16 | Bossier | Louisiana | 22015 | 513 | 28 |
241227 | 241227 | 2020-06-15 | Bossier | Louisiana | 22015 | 510 | 28 |
238118 | 238118 | 2020-06-14 | Bossier | Louisiana | 22015 | 502 | 28 |
235011 | 235011 | 2020-06-13 | Bossier | Louisiana | 22015 | 494 | 27 |
231906 | 231906 | 2020-06-12 | Bossier | Louisiana | 22015 | 488 | 26 |
228802 | 228802 | 2020-06-11 | Bossier | Louisiana | 22015 | 484 | 26 |
225700 | 225700 | 2020-06-10 | Bossier | Louisiana | 22015 | 478 | 26 |
222604 | 222604 | 2020-06-09 | Bossier | Louisiana | 22015 | 473 | 26 |
219509 | 219509 | 2020-06-08 | Bossier | Louisiana | 22015 | 464 | 26 |
216417 | 216417 | 2020-06-07 | Bossier | Louisiana | 22015 | 463 | 26 |
213330 | 213330 | 2020-06-06 | Bossier | Louisiana | 22015 | 453 | 25 |
210245 | 210245 | 2020-06-05 | Bossier | Louisiana | 22015 | 450 | 25 |
207164 | 207164 | 2020-06-04 | Bossier | Louisiana | 22015 | 438 | 25 |
204083 | 204083 | 2020-06-03 | Bossier | Louisiana | 22015 | 425 | 25 |
201006 | 201006 | 2020-06-02 | Bossier | Louisiana | 22015 | 421 | 26 |
197934 | 197934 | 2020-06-01 | Bossier | Louisiana | 22015 | 416 | 26 |
194863 | 194863 | 2020-05-31 | Bossier | Louisiana | 22015 | 415 | 26 |
191795 | 191795 | 2020-05-30 | Bossier | Louisiana | 22015 | 412 | 26 |
188731 | 188731 | 2020-05-29 | Bossier | Louisiana | 22015 | 406 | 26 |
185673 | 185673 | 2020-05-28 | Bossier | Louisiana | 22015 | 406 | 25 |
182618 | 182618 | 2020-05-27 | Bossier | Louisiana | 22015 | 402 | 25 |
179573 | 179573 | 2020-05-26 | Bossier | Louisiana | 22015 | 398 | 25 |
176529 | 176529 | 2020-05-25 | Bossier | Louisiana | 22015 | 398 | 25 |
173485 | 173485 | 2020-05-24 | Bossier | Louisiana | 22015 | 382 | 25 |
170444 | 170444 | 2020-05-23 | Bossier | Louisiana | 22015 | 381 | 25 |
167406 | 167406 | 2020-05-22 | Bossier | Louisiana | 22015 | 380 | 25 |
164370 | 164370 | 2020-05-21 | Bossier | Louisiana | 22015 | 374 | 24 |
161341 | 161341 | 2020-05-20 | Bossier | Louisiana | 22015 | 353 | 24 |
158315 | 158315 | 2020-05-19 | Bossier | Louisiana | 22015 | 348 | 24 |
155297 | 155297 | 2020-05-18 | Bossier | Louisiana | 22015 | 346 | 24 |
152283 | 152283 | 2020-05-17 | Bossier | Louisiana | 22015 | 344 | 23 |
149272 | 149272 | 2020-05-16 | Bossier | Louisiana | 22015 | 342 | 23 |
146267 | 146267 | 2020-05-15 | Bossier | Louisiana | 22015 | 336 | 23 |
143267 | 143267 | 2020-05-14 | Bossier | Louisiana | 22015 | 327 | 22 |
140272 | 140272 | 2020-05-13 | Bossier | Louisiana | 22015 | 324 | 22 |
137278 | 137278 | 2020-05-12 | Bossier | Louisiana | 22015 | 313 | 22 |
134288 | 134288 | 2020-05-11 | Bossier | Louisiana | 22015 | 312 | 21 |
131297 | 131297 | 2020-05-10 | Bossier | Louisiana | 22015 | 310 | 20 |
128307 | 128307 | 2020-05-09 | Bossier | Louisiana | 22015 | 310 | 20 |
125320 | 125320 | 2020-05-08 | Bossier | Louisiana | 22015 | 308 | 19 |
122338 | 122338 | 2020-05-07 | Bossier | Louisiana | 22015 | 307 | 18 |
119367 | 119367 | 2020-05-06 | Bossier | Louisiana | 22015 | 303 | 18 |
116406 | 116406 | 2020-05-05 | Bossier | Louisiana | 22015 | 300 | 17 |
113524 | 113524 | 2020-05-04 | Bossier | Louisiana | 22015 | 300 | 17 |
110647 | 110647 | 2020-05-03 | Bossier | Louisiana | 22015 | 295 | 17 |
107775 | 107775 | 2020-05-02 | Bossier | Louisiana | 22015 | 292 | 17 |
104911 | 104911 | 2020-05-01 | Bossier | Louisiana | 22015 | 287 | 17 |
102050 | 102050 | 2020-04-30 | Bossier | Louisiana | 22015 | 286 | 17 |
99198 | 99198 | 2020-04-29 | Bossier | Louisiana | 22015 | 285 | 15 |
96352 | 96352 | 2020-04-28 | Bossier | Louisiana | 22015 | 277 | 14 |
93517 | 93517 | 2020-04-27 | Bossier | Louisiana | 22015 | 274 | 13 |
90696 | 90696 | 2020-04-26 | Bossier | Louisiana | 22015 | 270 | 13 |
87880 | 87880 | 2020-04-25 | Bossier | Louisiana | 22015 | 265 | 12 |
85071 | 85071 | 2020-04-24 | Bossier | Louisiana | 22015 | 258 | 12 |
82267 | 82267 | 2020-04-23 | Bossier | Louisiana | 22015 | 255 | 12 |
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);