ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Bossier" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535548 | 535548 | 2020-09-15 | Bossier | Louisiana | 22015 | 2952 | 103 |
532313 | 532313 | 2020-09-14 | Bossier | Louisiana | 22015 | 2942 | 102 |
529076 | 529076 | 2020-09-13 | Bossier | Louisiana | 22015 | 2926 | 102 |
525840 | 525840 | 2020-09-12 | Bossier | Louisiana | 22015 | 2894 | 101 |
522604 | 522604 | 2020-09-11 | Bossier | Louisiana | 22015 | 2894 | 101 |
519367 | 519367 | 2020-09-10 | Bossier | Louisiana | 22015 | 2861 | 100 |
516132 | 516132 | 2020-09-09 | Bossier | Louisiana | 22015 | 2849 | 98 |
512899 | 512899 | 2020-09-08 | Bossier | Louisiana | 22015 | 2836 | 98 |
509667 | 509667 | 2020-09-07 | Bossier | Louisiana | 22015 | 2826 | 97 |
506434 | 506434 | 2020-09-06 | Bossier | Louisiana | 22015 | 2814 | 97 |
503200 | 503200 | 2020-09-05 | Bossier | Louisiana | 22015 | 2776 | 94 |
499967 | 499967 | 2020-09-04 | Bossier | Louisiana | 22015 | 2776 | 94 |
496733 | 496733 | 2020-09-03 | Bossier | Louisiana | 22015 | 2749 | 94 |
493500 | 493500 | 2020-09-02 | Bossier | Louisiana | 22015 | 2732 | 93 |
490266 | 490266 | 2020-09-01 | Bossier | Louisiana | 22015 | 2728 | 92 |
487033 | 487033 | 2020-08-31 | Bossier | Louisiana | 22015 | 2703 | 92 |
483798 | 483798 | 2020-08-30 | Bossier | Louisiana | 22015 | 2693 | 92 |
480564 | 480564 | 2020-08-29 | Bossier | Louisiana | 22015 | 2674 | 92 |
477331 | 477331 | 2020-08-28 | Bossier | Louisiana | 22015 | 2674 | 92 |
474098 | 474098 | 2020-08-27 | Bossier | Louisiana | 22015 | 2667 | 92 |
470866 | 470866 | 2020-08-26 | Bossier | Louisiana | 22015 | 2653 | 92 |
467637 | 467637 | 2020-08-25 | Bossier | Louisiana | 22015 | 2619 | 92 |
464408 | 464408 | 2020-08-24 | Bossier | Louisiana | 22015 | 2557 | 91 |
461177 | 461177 | 2020-08-23 | Bossier | Louisiana | 22015 | 2549 | 90 |
457950 | 457950 | 2020-08-22 | Bossier | Louisiana | 22015 | 2520 | 87 |
454722 | 454722 | 2020-08-21 | Bossier | Louisiana | 22015 | 2520 | 87 |
451494 | 451494 | 2020-08-20 | Bossier | Louisiana | 22015 | 2508 | 86 |
448266 | 448266 | 2020-08-19 | Bossier | Louisiana | 22015 | 2499 | 85 |
445039 | 445039 | 2020-08-18 | Bossier | Louisiana | 22015 | 2488 | 84 |
441813 | 441813 | 2020-08-17 | Bossier | Louisiana | 22015 | 2471 | 84 |
438586 | 438586 | 2020-08-16 | Bossier | Louisiana | 22015 | 2464 | 84 |
435361 | 435361 | 2020-08-15 | Bossier | Louisiana | 22015 | 2445 | 82 |
432136 | 432136 | 2020-08-14 | Bossier | Louisiana | 22015 | 2445 | 82 |
428908 | 428908 | 2020-08-13 | Bossier | Louisiana | 22015 | 2428 | 82 |
425684 | 425684 | 2020-08-12 | Bossier | Louisiana | 22015 | 2390 | 82 |
422463 | 422463 | 2020-08-11 | Bossier | Louisiana | 22015 | 2374 | 82 |
419241 | 419241 | 2020-08-10 | Bossier | Louisiana | 22015 | 2339 | 81 |
416020 | 416020 | 2020-08-09 | Bossier | Louisiana | 22015 | 2333 | 81 |
412800 | 412800 | 2020-08-08 | Bossier | Louisiana | 22015 | 2311 | 79 |
409580 | 409580 | 2020-08-07 | Bossier | Louisiana | 22015 | 2311 | 79 |
406360 | 406360 | 2020-08-06 | Bossier | Louisiana | 22015 | 2295 | 75 |
403142 | 403142 | 2020-08-05 | Bossier | Louisiana | 22015 | 2275 | 75 |
399925 | 399925 | 2020-08-04 | Bossier | Louisiana | 22015 | 2192 | 73 |
396710 | 396710 | 2020-08-03 | Bossier | Louisiana | 22015 | 2118 | 73 |
393494 | 393494 | 2020-08-02 | Bossier | Louisiana | 22015 | 2111 | 73 |
390277 | 390277 | 2020-08-01 | Bossier | Louisiana | 22015 | 2054 | 67 |
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 |
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);