ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22119 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947581 | 947581 | 2021-01-20 | Webster | Louisiana | 22119 | 3449 | 78 |
944334 | 944334 | 2021-01-19 | Webster | Louisiana | 22119 | 3431 | 78 |
941089 | 941089 | 2021-01-18 | Webster | Louisiana | 22119 | 3409 | 77 |
937844 | 937844 | 2021-01-17 | Webster | Louisiana | 22119 | 3401 | 77 |
934599 | 934599 | 2021-01-16 | Webster | Louisiana | 22119 | 3361 | 74 |
931354 | 931354 | 2021-01-15 | Webster | Louisiana | 22119 | 3361 | 74 |
928109 | 928109 | 2021-01-14 | Webster | Louisiana | 22119 | 3334 | 74 |
924863 | 924863 | 2021-01-13 | Webster | Louisiana | 22119 | 3307 | 73 |
921618 | 921618 | 2021-01-12 | Webster | Louisiana | 22119 | 3274 | 71 |
918373 | 918373 | 2021-01-11 | Webster | Louisiana | 22119 | 3232 | 71 |
915128 | 915128 | 2021-01-10 | Webster | Louisiana | 22119 | 3222 | 71 |
911883 | 911883 | 2021-01-09 | Webster | Louisiana | 22119 | 3120 | 71 |
908638 | 908638 | 2021-01-08 | Webster | Louisiana | 22119 | 3120 | 71 |
905392 | 905392 | 2021-01-07 | Webster | Louisiana | 22119 | 3105 | 70 |
902147 | 902147 | 2021-01-06 | Webster | Louisiana | 22119 | 3041 | 69 |
898902 | 898902 | 2021-01-05 | Webster | Louisiana | 22119 | 2975 | 69 |
895657 | 895657 | 2021-01-04 | Webster | Louisiana | 22119 | 2891 | 69 |
892410 | 892410 | 2021-01-03 | Webster | Louisiana | 22119 | 2885 | 69 |
889164 | 889164 | 2021-01-02 | Webster | Louisiana | 22119 | 2822 | 68 |
885918 | 885918 | 2021-01-01 | Webster | Louisiana | 22119 | 2822 | 68 |
882673 | 882673 | 2020-12-31 | Webster | Louisiana | 22119 | 2822 | 68 |
879428 | 879428 | 2020-12-30 | Webster | Louisiana | 22119 | 2774 | 68 |
876183 | 876183 | 2020-12-29 | Webster | Louisiana | 22119 | 2637 | 68 |
872938 | 872938 | 2020-12-28 | Webster | Louisiana | 22119 | 2622 | 68 |
869693 | 869693 | 2020-12-27 | Webster | Louisiana | 22119 | 2612 | 67 |
866448 | 866448 | 2020-12-26 | Webster | Louisiana | 22119 | 2598 | 65 |
863203 | 863203 | 2020-12-25 | Webster | Louisiana | 22119 | 2598 | 65 |
859958 | 859958 | 2020-12-24 | Webster | Louisiana | 22119 | 2598 | 65 |
856713 | 856713 | 2020-12-23 | Webster | Louisiana | 22119 | 2582 | 65 |
853468 | 853468 | 2020-12-22 | Webster | Louisiana | 22119 | 2550 | 63 |
850223 | 850223 | 2020-12-21 | Webster | Louisiana | 22119 | 2511 | 63 |
846978 | 846978 | 2020-12-20 | Webster | Louisiana | 22119 | 2508 | 63 |
843732 | 843732 | 2020-12-19 | Webster | Louisiana | 22119 | 2459 | 62 |
840487 | 840487 | 2020-12-18 | Webster | Louisiana | 22119 | 2459 | 62 |
837242 | 837242 | 2020-12-17 | Webster | Louisiana | 22119 | 2440 | 61 |
833996 | 833996 | 2020-12-16 | Webster | Louisiana | 22119 | 2418 | 61 |
830749 | 830749 | 2020-12-15 | Webster | Louisiana | 22119 | 2351 | 61 |
827503 | 827503 | 2020-12-14 | Webster | Louisiana | 22119 | 2330 | 61 |
824256 | 824256 | 2020-12-13 | Webster | Louisiana | 22119 | 2328 | 60 |
821010 | 821010 | 2020-12-12 | Webster | Louisiana | 22119 | 2296 | 60 |
817764 | 817764 | 2020-12-11 | Webster | Louisiana | 22119 | 2296 | 60 |
814518 | 814518 | 2020-12-10 | Webster | Louisiana | 22119 | 2264 | 60 |
811273 | 811273 | 2020-12-09 | Webster | Louisiana | 22119 | 2231 | 59 |
808028 | 808028 | 2020-12-08 | Webster | Louisiana | 22119 | 2228 | 59 |
804783 | 804783 | 2020-12-07 | Webster | Louisiana | 22119 | 2203 | 59 |
801538 | 801538 | 2020-12-06 | Webster | Louisiana | 22119 | 2194 | 59 |
798293 | 798293 | 2020-12-05 | Webster | Louisiana | 22119 | 2138 | 59 |
795048 | 795048 | 2020-12-04 | Webster | Louisiana | 22119 | 2138 | 59 |
791803 | 791803 | 2020-12-03 | Webster | Louisiana | 22119 | 2097 | 56 |
788558 | 788558 | 2020-12-02 | Webster | Louisiana | 22119 | 2069 | 56 |
785314 | 785314 | 2020-12-01 | Webster | Louisiana | 22119 | 2044 | 56 |
782069 | 782069 | 2020-11-30 | Webster | Louisiana | 22119 | 2017 | 56 |
778823 | 778823 | 2020-11-29 | Webster | Louisiana | 22119 | 2013 | 56 |
775578 | 775578 | 2020-11-28 | Webster | Louisiana | 22119 | 2001 | 54 |
772333 | 772333 | 2020-11-27 | Webster | Louisiana | 22119 | 2001 | 54 |
769088 | 769088 | 2020-11-26 | Webster | Louisiana | 22119 | 1950 | 52 |
765842 | 765842 | 2020-11-25 | Webster | Louisiana | 22119 | 1950 | 52 |
762597 | 762597 | 2020-11-24 | Webster | Louisiana | 22119 | 1922 | 52 |
759352 | 759352 | 2020-11-23 | Webster | Louisiana | 22119 | 1895 | 50 |
756105 | 756105 | 2020-11-22 | Webster | Louisiana | 22119 | 1889 | 50 |
752859 | 752859 | 2020-11-21 | Webster | Louisiana | 22119 | 1844 | 50 |
749613 | 749613 | 2020-11-20 | Webster | Louisiana | 22119 | 1844 | 50 |
746367 | 746367 | 2020-11-19 | Webster | Louisiana | 22119 | 1768 | 49 |
743120 | 743120 | 2020-11-18 | Webster | Louisiana | 22119 | 1746 | 49 |
739873 | 739873 | 2020-11-17 | Webster | Louisiana | 22119 | 1715 | 48 |
736629 | 736629 | 2020-11-16 | Webster | Louisiana | 22119 | 1692 | 47 |
733383 | 733383 | 2020-11-15 | Webster | Louisiana | 22119 | 1689 | 47 |
730138 | 730138 | 2020-11-14 | Webster | Louisiana | 22119 | 1671 | 47 |
726895 | 726895 | 2020-11-13 | Webster | Louisiana | 22119 | 1671 | 47 |
723652 | 723652 | 2020-11-12 | Webster | Louisiana | 22119 | 1588 | 45 |
720409 | 720409 | 2020-11-11 | Webster | Louisiana | 22119 | 1570 | 42 |
717166 | 717166 | 2020-11-10 | Webster | Louisiana | 22119 | 1570 | 42 |
713922 | 713922 | 2020-11-09 | Webster | Louisiana | 22119 | 1556 | 42 |
710678 | 710678 | 2020-11-08 | Webster | Louisiana | 22119 | 1555 | 42 |
707434 | 707434 | 2020-11-07 | Webster | Louisiana | 22119 | 1546 | 42 |
704191 | 704191 | 2020-11-06 | Webster | Louisiana | 22119 | 1546 | 42 |
700949 | 700949 | 2020-11-05 | Webster | Louisiana | 22119 | 1540 | 41 |
697705 | 697705 | 2020-11-04 | Webster | Louisiana | 22119 | 1532 | 41 |
694462 | 694462 | 2020-11-03 | Webster | Louisiana | 22119 | 1530 | 41 |
691220 | 691220 | 2020-11-02 | Webster | Louisiana | 22119 | 1498 | 41 |
687975 | 687975 | 2020-11-01 | Webster | Louisiana | 22119 | 1495 | 41 |
684731 | 684731 | 2020-10-31 | Webster | Louisiana | 22119 | 1490 | 41 |
681488 | 681488 | 2020-10-30 | Webster | Louisiana | 22119 | 1490 | 41 |
678244 | 678244 | 2020-10-29 | Webster | Louisiana | 22119 | 1491 | 41 |
675002 | 675002 | 2020-10-28 | Webster | Louisiana | 22119 | 1483 | 40 |
671759 | 671759 | 2020-10-27 | Webster | Louisiana | 22119 | 1481 | 40 |
668517 | 668517 | 2020-10-26 | Webster | Louisiana | 22119 | 1466 | 40 |
665273 | 665273 | 2020-10-25 | Webster | Louisiana | 22119 | 1465 | 40 |
662028 | 662028 | 2020-10-24 | Webster | Louisiana | 22119 | 1452 | 40 |
658784 | 658784 | 2020-10-23 | Webster | Louisiana | 22119 | 1452 | 40 |
655539 | 655539 | 2020-10-22 | Webster | Louisiana | 22119 | 1445 | 38 |
652294 | 652294 | 2020-10-21 | Webster | Louisiana | 22119 | 1430 | 38 |
649049 | 649049 | 2020-10-20 | Webster | Louisiana | 22119 | 1429 | 38 |
645805 | 645805 | 2020-10-19 | Webster | Louisiana | 22119 | 1418 | 37 |
642558 | 642558 | 2020-10-18 | Webster | Louisiana | 22119 | 1417 | 37 |
639311 | 639311 | 2020-10-17 | Webster | Louisiana | 22119 | 1412 | 34 |
636065 | 636065 | 2020-10-16 | Webster | Louisiana | 22119 | 1412 | 34 |
632819 | 632819 | 2020-10-15 | Webster | Louisiana | 22119 | 1406 | 34 |
629575 | 629575 | 2020-10-14 | Webster | Louisiana | 22119 | 1392 | 32 |
626331 | 626331 | 2020-10-13 | Webster | Louisiana | 22119 | 1381 | 32 |
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);