ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175326 | 2175326 | 2022-02-02 | Calcasieu | Louisiana | 22019 | 50804 | 659 |
2172073 | 2172073 | 2022-02-01 | Calcasieu | Louisiana | 22019 | 50596 | 659 |
2168820 | 2168820 | 2022-01-31 | Calcasieu | Louisiana | 22019 | 50378 | 655 |
2165565 | 2165565 | 2022-01-30 | Calcasieu | Louisiana | 22019 | 50008 | 655 |
2162310 | 2162310 | 2022-01-29 | Calcasieu | Louisiana | 22019 | 50008 | 655 |
2159055 | 2159055 | 2022-01-28 | Calcasieu | Louisiana | 22019 | 50008 | 655 |
2155801 | 2155801 | 2022-01-27 | Calcasieu | Louisiana | 22019 | 49746 | 654 |
2152548 | 2152548 | 2022-01-26 | Calcasieu | Louisiana | 22019 | 49466 | 654 |
2149296 | 2149296 | 2022-01-25 | Calcasieu | Louisiana | 22019 | 46983 | 654 |
2146044 | 2146044 | 2022-01-24 | Calcasieu | Louisiana | 22019 | 46676 | 645 |
2142789 | 2142789 | 2022-01-23 | Calcasieu | Louisiana | 22019 | 45999 | 644 |
2139534 | 2139534 | 2022-01-22 | Calcasieu | Louisiana | 22019 | 45999 | 644 |
2136278 | 2136278 | 2022-01-21 | Calcasieu | Louisiana | 22019 | 45999 | 644 |
2133026 | 2133026 | 2022-01-20 | Calcasieu | Louisiana | 22019 | 45635 | 644 |
2129773 | 2129773 | 2022-01-19 | Calcasieu | Louisiana | 22019 | 45121 | 643 |
2126519 | 2126519 | 2022-01-18 | Calcasieu | Louisiana | 22019 | 44686 | 641 |
2123267 | 2123267 | 2022-01-17 | Calcasieu | Louisiana | 22019 | 43421 | 641 |
2120015 | 2120015 | 2022-01-16 | Calcasieu | Louisiana | 22019 | 43421 | 641 |
2116763 | 2116763 | 2022-01-15 | Calcasieu | Louisiana | 22019 | 43421 | 641 |
2113512 | 2113512 | 2022-01-14 | Calcasieu | Louisiana | 22019 | 43421 | 641 |
2110260 | 2110260 | 2022-01-13 | Calcasieu | Louisiana | 22019 | 41198 | 641 |
2107009 | 2107009 | 2022-01-12 | Calcasieu | Louisiana | 22019 | 41198 | 641 |
2103758 | 2103758 | 2022-01-11 | Calcasieu | Louisiana | 22019 | 41198 | 641 |
2100507 | 2100507 | 2022-01-10 | Calcasieu | Louisiana | 22019 | 40822 | 640 |
2097256 | 2097256 | 2022-01-09 | Calcasieu | Louisiana | 22019 | 39813 | 640 |
2094004 | 2094004 | 2022-01-08 | Calcasieu | Louisiana | 22019 | 39813 | 640 |
2090752 | 2090752 | 2022-01-07 | Calcasieu | Louisiana | 22019 | 39813 | 640 |
2087501 | 2087501 | 2022-01-06 | Calcasieu | Louisiana | 22019 | 39312 | 639 |
2084249 | 2084249 | 2022-01-05 | Calcasieu | Louisiana | 22019 | 38741 | 639 |
2080997 | 2080997 | 2022-01-04 | Calcasieu | Louisiana | 22019 | 38363 | 639 |
2077745 | 2077745 | 2022-01-03 | Calcasieu | Louisiana | 22019 | 37985 | 639 |
2074494 | 2074494 | 2022-01-02 | Calcasieu | Louisiana | 22019 | 36906 | 637 |
2071243 | 2071243 | 2022-01-01 | Calcasieu | Louisiana | 22019 | 36906 | 637 |
2067992 | 2067992 | 2021-12-31 | Calcasieu | Louisiana | 22019 | 36906 | 637 |
2064741 | 2064741 | 2021-12-30 | Calcasieu | Louisiana | 22019 | 36906 | 637 |
2061491 | 2061491 | 2021-12-29 | Calcasieu | Louisiana | 22019 | 36490 | 637 |
2058242 | 2058242 | 2021-12-28 | Calcasieu | Louisiana | 22019 | 36180 | 637 |
2054993 | 2054993 | 2021-12-27 | Calcasieu | Louisiana | 22019 | 36008 | 637 |
2051743 | 2051743 | 2021-12-26 | Calcasieu | Louisiana | 22019 | 35616 | 637 |
2048493 | 2048493 | 2021-12-25 | Calcasieu | Louisiana | 22019 | 35616 | 637 |
2045243 | 2045243 | 2021-12-24 | Calcasieu | Louisiana | 22019 | 35616 | 637 |
2041994 | 2041994 | 2021-12-23 | Calcasieu | Louisiana | 22019 | 35616 | 637 |
2038744 | 2038744 | 2021-12-22 | Calcasieu | Louisiana | 22019 | 35540 | 637 |
2035494 | 2035494 | 2021-12-21 | Calcasieu | Louisiana | 22019 | 35468 | 637 |
2032244 | 2032244 | 2021-12-20 | Calcasieu | Louisiana | 22019 | 35400 | 637 |
2028993 | 2028993 | 2021-12-19 | Calcasieu | Louisiana | 22019 | 35297 | 637 |
2025742 | 2025742 | 2021-12-18 | Calcasieu | Louisiana | 22019 | 35297 | 637 |
2022491 | 2022491 | 2021-12-17 | Calcasieu | Louisiana | 22019 | 35297 | 637 |
2019240 | 2019240 | 2021-12-16 | Calcasieu | Louisiana | 22019 | 35261 | 636 |
2015990 | 2015990 | 2021-12-15 | Calcasieu | Louisiana | 22019 | 35232 | 635 |
2012739 | 2012739 | 2021-12-14 | Calcasieu | Louisiana | 22019 | 35203 | 635 |
2009488 | 2009488 | 2021-12-13 | Calcasieu | Louisiana | 22019 | 35182 | 633 |
2006237 | 2006237 | 2021-12-12 | Calcasieu | Louisiana | 22019 | 35137 | 633 |
2002986 | 2002986 | 2021-12-11 | Calcasieu | Louisiana | 22019 | 35137 | 633 |
1999736 | 1999736 | 2021-12-10 | Calcasieu | Louisiana | 22019 | 35137 | 633 |
1996485 | 1996485 | 2021-12-09 | Calcasieu | Louisiana | 22019 | 35128 | 631 |
1993234 | 1993234 | 2021-12-08 | Calcasieu | Louisiana | 22019 | 35106 | 628 |
1989983 | 1989983 | 2021-12-07 | Calcasieu | Louisiana | 22019 | 35068 | 628 |
1986733 | 1986733 | 2021-12-06 | Calcasieu | Louisiana | 22019 | 35045 | 628 |
1983483 | 1983483 | 2021-12-05 | Calcasieu | Louisiana | 22019 | 35010 | 627 |
1980233 | 1980233 | 2021-12-04 | Calcasieu | Louisiana | 22019 | 35010 | 627 |
1976983 | 1976983 | 2021-12-03 | Calcasieu | Louisiana | 22019 | 35010 | 627 |
1973734 | 1973734 | 2021-12-02 | Calcasieu | Louisiana | 22019 | 34988 | 626 |
1970484 | 1970484 | 2021-12-01 | Calcasieu | Louisiana | 22019 | 34981 | 626 |
1967234 | 1967234 | 2021-11-30 | Calcasieu | Louisiana | 22019 | 34953 | 626 |
1963982 | 1963982 | 2021-11-29 | Calcasieu | Louisiana | 22019 | 34942 | 625 |
1960731 | 1960731 | 2021-11-28 | Calcasieu | Louisiana | 22019 | 34894 | 624 |
1957480 | 1957480 | 2021-11-27 | Calcasieu | Louisiana | 22019 | 34894 | 624 |
1954229 | 1954229 | 2021-11-26 | Calcasieu | Louisiana | 22019 | 34894 | 624 |
1950978 | 1950978 | 2021-11-25 | Calcasieu | Louisiana | 22019 | 34894 | 624 |
1947727 | 1947727 | 2021-11-24 | Calcasieu | Louisiana | 22019 | 34894 | 624 |
1944476 | 1944476 | 2021-11-23 | Calcasieu | Louisiana | 22019 | 34875 | 623 |
1941226 | 1941226 | 2021-11-22 | Calcasieu | Louisiana | 22019 | 34846 | 623 |
1937976 | 1937976 | 2021-11-21 | Calcasieu | Louisiana | 22019 | 34803 | 623 |
1934726 | 1934726 | 2021-11-20 | Calcasieu | Louisiana | 22019 | 34803 | 623 |
1931475 | 1931475 | 2021-11-19 | Calcasieu | Louisiana | 22019 | 34803 | 623 |
1928224 | 1928224 | 2021-11-18 | Calcasieu | Louisiana | 22019 | 34780 | 622 |
1924974 | 1924974 | 2021-11-17 | Calcasieu | Louisiana | 22019 | 34759 | 622 |
1921725 | 1921725 | 2021-11-16 | Calcasieu | Louisiana | 22019 | 34732 | 622 |
1918475 | 1918475 | 2021-11-15 | Calcasieu | Louisiana | 22019 | 34709 | 622 |
1915225 | 1915225 | 2021-11-14 | Calcasieu | Louisiana | 22019 | 34666 | 622 |
1911975 | 1911975 | 2021-11-13 | Calcasieu | Louisiana | 22019 | 34666 | 622 |
1908726 | 1908726 | 2021-11-12 | Calcasieu | Louisiana | 22019 | 34666 | 622 |
1905477 | 1905477 | 2021-11-11 | Calcasieu | Louisiana | 22019 | 34644 | 619 |
1902227 | 1902227 | 2021-11-10 | Calcasieu | Louisiana | 22019 | 34644 | 619 |
1898977 | 1898977 | 2021-11-09 | Calcasieu | Louisiana | 22019 | 34620 | 618 |
1895727 | 1895727 | 2021-11-08 | Calcasieu | Louisiana | 22019 | 34598 | 616 |
1892477 | 1892477 | 2021-11-07 | Calcasieu | Louisiana | 22019 | 34556 | 614 |
1889227 | 1889227 | 2021-11-06 | Calcasieu | Louisiana | 22019 | 34556 | 614 |
1885977 | 1885977 | 2021-11-05 | Calcasieu | Louisiana | 22019 | 34556 | 614 |
1882728 | 1882728 | 2021-11-04 | Calcasieu | Louisiana | 22019 | 34548 | 614 |
1879479 | 1879479 | 2021-11-03 | Calcasieu | Louisiana | 22019 | 34520 | 613 |
1876230 | 1876230 | 2021-11-02 | Calcasieu | Louisiana | 22019 | 34507 | 613 |
1872981 | 1872981 | 2021-11-01 | Calcasieu | Louisiana | 22019 | 34494 | 613 |
1869732 | 1869732 | 2021-10-31 | Calcasieu | Louisiana | 22019 | 34467 | 613 |
1866483 | 1866483 | 2021-10-30 | Calcasieu | Louisiana | 22019 | 34467 | 613 |
1863234 | 1863234 | 2021-10-29 | Calcasieu | Louisiana | 22019 | 34467 | 613 |
1859985 | 1859985 | 2021-10-28 | Calcasieu | Louisiana | 22019 | 34454 | 612 |
1856736 | 1856736 | 2021-10-27 | Calcasieu | Louisiana | 22019 | 34439 | 612 |
1853487 | 1853487 | 2021-10-26 | Calcasieu | Louisiana | 22019 | 34395 | 610 |
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);