ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "West Baton Rouge" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636066 | 636066 | 2020-10-16 | West Baton Rouge | Louisiana | 22121 | 942 | 42 |
632820 | 632820 | 2020-10-15 | West Baton Rouge | Louisiana | 22121 | 941 | 42 |
629576 | 629576 | 2020-10-14 | West Baton Rouge | Louisiana | 22121 | 934 | 42 |
626332 | 626332 | 2020-10-13 | West Baton Rouge | Louisiana | 22121 | 936 | 42 |
623090 | 623090 | 2020-10-12 | West Baton Rouge | Louisiana | 22121 | 933 | 42 |
619846 | 619846 | 2020-10-11 | West Baton Rouge | Louisiana | 22121 | 934 | 42 |
616604 | 616604 | 2020-10-10 | West Baton Rouge | Louisiana | 22121 | 933 | 42 |
613363 | 613363 | 2020-10-09 | West Baton Rouge | Louisiana | 22121 | 933 | 42 |
610121 | 610121 | 2020-10-08 | West Baton Rouge | Louisiana | 22121 | 928 | 42 |
606879 | 606879 | 2020-10-07 | West Baton Rouge | Louisiana | 22121 | 927 | 42 |
603637 | 603637 | 2020-10-06 | West Baton Rouge | Louisiana | 22121 | 920 | 42 |
600394 | 600394 | 2020-10-05 | West Baton Rouge | Louisiana | 22121 | 922 | 42 |
597152 | 597152 | 2020-10-04 | West Baton Rouge | Louisiana | 22121 | 922 | 42 |
593910 | 593910 | 2020-10-03 | West Baton Rouge | Louisiana | 22121 | 915 | 42 |
590669 | 590669 | 2020-10-02 | West Baton Rouge | Louisiana | 22121 | 915 | 42 |
587428 | 587428 | 2020-10-01 | West Baton Rouge | Louisiana | 22121 | 915 | 41 |
584188 | 584188 | 2020-09-30 | West Baton Rouge | Louisiana | 22121 | 912 | 41 |
580948 | 580948 | 2020-09-29 | West Baton Rouge | Louisiana | 22121 | 915 | 41 |
577707 | 577707 | 2020-09-28 | West Baton Rouge | Louisiana | 22121 | 906 | 41 |
574465 | 574465 | 2020-09-27 | West Baton Rouge | Louisiana | 22121 | 908 | 41 |
571222 | 571222 | 2020-09-26 | West Baton Rouge | Louisiana | 22121 | 903 | 41 |
567980 | 567980 | 2020-09-25 | West Baton Rouge | Louisiana | 22121 | 903 | 41 |
564740 | 564740 | 2020-09-24 | West Baton Rouge | Louisiana | 22121 | 900 | 41 |
561500 | 561500 | 2020-09-23 | West Baton Rouge | Louisiana | 22121 | 900 | 41 |
558264 | 558264 | 2020-09-22 | West Baton Rouge | Louisiana | 22121 | 895 | 41 |
555027 | 555027 | 2020-09-21 | West Baton Rouge | Louisiana | 22121 | 889 | 41 |
551788 | 551788 | 2020-09-20 | West Baton Rouge | Louisiana | 22121 | 886 | 41 |
548549 | 548549 | 2020-09-19 | West Baton Rouge | Louisiana | 22121 | 878 | 41 |
545311 | 545311 | 2020-09-18 | West Baton Rouge | Louisiana | 22121 | 878 | 41 |
542075 | 542075 | 2020-09-17 | West Baton Rouge | Louisiana | 22121 | 875 | 41 |
538839 | 538839 | 2020-09-16 | West Baton Rouge | Louisiana | 22121 | 875 | 41 |
535602 | 535602 | 2020-09-15 | West Baton Rouge | Louisiana | 22121 | 873 | 41 |
532367 | 532367 | 2020-09-14 | West Baton Rouge | Louisiana | 22121 | 872 | 41 |
529130 | 529130 | 2020-09-13 | West Baton Rouge | Louisiana | 22121 | 873 | 41 |
525894 | 525894 | 2020-09-12 | West Baton Rouge | Louisiana | 22121 | 871 | 41 |
522658 | 522658 | 2020-09-11 | West Baton Rouge | Louisiana | 22121 | 871 | 41 |
519421 | 519421 | 2020-09-10 | West Baton Rouge | Louisiana | 22121 | 864 | 40 |
516186 | 516186 | 2020-09-09 | West Baton Rouge | Louisiana | 22121 | 855 | 40 |
512953 | 512953 | 2020-09-08 | West Baton Rouge | Louisiana | 22121 | 852 | 40 |
509721 | 509721 | 2020-09-07 | West Baton Rouge | Louisiana | 22121 | 851 | 40 |
506488 | 506488 | 2020-09-06 | West Baton Rouge | Louisiana | 22121 | 852 | 39 |
503254 | 503254 | 2020-09-05 | West Baton Rouge | Louisiana | 22121 | 841 | 39 |
500021 | 500021 | 2020-09-04 | West Baton Rouge | Louisiana | 22121 | 841 | 39 |
496787 | 496787 | 2020-09-03 | West Baton Rouge | Louisiana | 22121 | 839 | 39 |
493554 | 493554 | 2020-09-02 | West Baton Rouge | Louisiana | 22121 | 838 | 39 |
490320 | 490320 | 2020-09-01 | West Baton Rouge | Louisiana | 22121 | 829 | 39 |
487087 | 487087 | 2020-08-31 | West Baton Rouge | Louisiana | 22121 | 833 | 39 |
483852 | 483852 | 2020-08-30 | West Baton Rouge | Louisiana | 22121 | 832 | 39 |
480618 | 480618 | 2020-08-29 | West Baton Rouge | Louisiana | 22121 | 826 | 39 |
477385 | 477385 | 2020-08-28 | West Baton Rouge | Louisiana | 22121 | 826 | 39 |
474152 | 474152 | 2020-08-27 | West Baton Rouge | Louisiana | 22121 | 820 | 38 |
470920 | 470920 | 2020-08-26 | West Baton Rouge | Louisiana | 22121 | 814 | 38 |
467691 | 467691 | 2020-08-25 | West Baton Rouge | Louisiana | 22121 | 809 | 38 |
464462 | 464462 | 2020-08-24 | West Baton Rouge | Louisiana | 22121 | 787 | 38 |
461231 | 461231 | 2020-08-23 | West Baton Rouge | Louisiana | 22121 | 787 | 38 |
458004 | 458004 | 2020-08-22 | West Baton Rouge | Louisiana | 22121 | 771 | 38 |
454776 | 454776 | 2020-08-21 | West Baton Rouge | Louisiana | 22121 | 771 | 38 |
451548 | 451548 | 2020-08-20 | West Baton Rouge | Louisiana | 22121 | 766 | 38 |
448320 | 448320 | 2020-08-19 | West Baton Rouge | Louisiana | 22121 | 766 | 37 |
445093 | 445093 | 2020-08-18 | West Baton Rouge | Louisiana | 22121 | 761 | 37 |
441867 | 441867 | 2020-08-17 | West Baton Rouge | Louisiana | 22121 | 757 | 37 |
438640 | 438640 | 2020-08-16 | West Baton Rouge | Louisiana | 22121 | 756 | 37 |
435415 | 435415 | 2020-08-15 | West Baton Rouge | Louisiana | 22121 | 754 | 37 |
432190 | 432190 | 2020-08-14 | West Baton Rouge | Louisiana | 22121 | 754 | 37 |
428962 | 428962 | 2020-08-13 | West Baton Rouge | Louisiana | 22121 | 745 | 37 |
425738 | 425738 | 2020-08-12 | West Baton Rouge | Louisiana | 22121 | 734 | 37 |
422517 | 422517 | 2020-08-11 | West Baton Rouge | Louisiana | 22121 | 727 | 37 |
419295 | 419295 | 2020-08-10 | West Baton Rouge | Louisiana | 22121 | 722 | 37 |
416074 | 416074 | 2020-08-09 | West Baton Rouge | Louisiana | 22121 | 720 | 37 |
412854 | 412854 | 2020-08-08 | West Baton Rouge | Louisiana | 22121 | 701 | 37 |
409634 | 409634 | 2020-08-07 | West Baton Rouge | Louisiana | 22121 | 701 | 37 |
406414 | 406414 | 2020-08-06 | West Baton Rouge | Louisiana | 22121 | 689 | 36 |
403196 | 403196 | 2020-08-05 | West Baton Rouge | Louisiana | 22121 | 678 | 36 |
399979 | 399979 | 2020-08-04 | West Baton Rouge | Louisiana | 22121 | 675 | 36 |
396764 | 396764 | 2020-08-03 | West Baton Rouge | Louisiana | 22121 | 661 | 36 |
393548 | 393548 | 2020-08-02 | West Baton Rouge | Louisiana | 22121 | 655 | 36 |
390331 | 390331 | 2020-08-01 | West Baton Rouge | Louisiana | 22121 | 613 | 36 |
387114 | 387114 | 2020-07-31 | West Baton Rouge | Louisiana | 22121 | 613 | 36 |
383896 | 383896 | 2020-07-30 | West Baton Rouge | Louisiana | 22121 | 609 | 35 |
380679 | 380679 | 2020-07-29 | West Baton Rouge | Louisiana | 22121 | 593 | 34 |
377462 | 377462 | 2020-07-28 | West Baton Rouge | Louisiana | 22121 | 582 | 33 |
374247 | 374247 | 2020-07-27 | West Baton Rouge | Louisiana | 22121 | 573 | 33 |
371035 | 371035 | 2020-07-26 | West Baton Rouge | Louisiana | 22121 | 545 | 33 |
367825 | 367825 | 2020-07-25 | West Baton Rouge | Louisiana | 22121 | 524 | 33 |
364618 | 364618 | 2020-07-24 | West Baton Rouge | Louisiana | 22121 | 524 | 33 |
361411 | 361411 | 2020-07-23 | West Baton Rouge | Louisiana | 22121 | 502 | 33 |
358206 | 358206 | 2020-07-22 | West Baton Rouge | Louisiana | 22121 | 490 | 33 |
355003 | 355003 | 2020-07-21 | West Baton Rouge | Louisiana | 22121 | 484 | 33 |
351801 | 351801 | 2020-07-20 | West Baton Rouge | Louisiana | 22121 | 479 | 32 |
348601 | 348601 | 2020-07-19 | West Baton Rouge | Louisiana | 22121 | 467 | 32 |
345400 | 345400 | 2020-07-18 | West Baton Rouge | Louisiana | 22121 | 455 | 32 |
342200 | 342200 | 2020-07-17 | West Baton Rouge | Louisiana | 22121 | 455 | 32 |
339004 | 339004 | 2020-07-16 | West Baton Rouge | Louisiana | 22121 | 439 | 32 |
335808 | 335808 | 2020-07-15 | West Baton Rouge | Louisiana | 22121 | 427 | 32 |
332615 | 332615 | 2020-07-14 | West Baton Rouge | Louisiana | 22121 | 415 | 32 |
329428 | 329428 | 2020-07-13 | West Baton Rouge | Louisiana | 22121 | 392 | 31 |
326242 | 326242 | 2020-07-12 | West Baton Rouge | Louisiana | 22121 | 378 | 31 |
323059 | 323059 | 2020-07-11 | West Baton Rouge | Louisiana | 22121 | 371 | 31 |
319880 | 319880 | 2020-07-10 | West Baton Rouge | Louisiana | 22121 | 356 | 31 |
316705 | 316705 | 2020-07-09 | West Baton Rouge | Louisiana | 22121 | 342 | 31 |
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);