ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48167 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176906 | 2176906 | 2022-02-02 | Galveston | Texas | 48167 | 91079 | 788 |
2173652 | 2173652 | 2022-02-01 | Galveston | Texas | 48167 | 90743 | 787 |
2170400 | 2170400 | 2022-01-31 | Galveston | Texas | 48167 | 90377 | 786 |
2167146 | 2167146 | 2022-01-30 | Galveston | Texas | 48167 | 90105 | 786 |
2163891 | 2163891 | 2022-01-29 | Galveston | Texas | 48167 | 89770 | 784 |
2160636 | 2160636 | 2022-01-28 | Galveston | Texas | 48167 | 89452 | 780 |
2157380 | 2157380 | 2022-01-27 | Galveston | Texas | 48167 | 89067 | 780 |
2154127 | 2154127 | 2022-01-26 | Galveston | Texas | 48167 | 88636 | 778 |
2150875 | 2150875 | 2022-01-25 | Galveston | Texas | 48167 | 88274 | 775 |
2147623 | 2147623 | 2022-01-24 | Galveston | Texas | 48167 | 87846 | 771 |
2144369 | 2144369 | 2022-01-23 | Galveston | Texas | 48167 | 87448 | 769 |
2141114 | 2141114 | 2022-01-22 | Galveston | Texas | 48167 | 86865 | 769 |
2137858 | 2137858 | 2022-01-21 | Galveston | Texas | 48167 | 86182 | 762 |
2134604 | 2134604 | 2022-01-20 | Galveston | Texas | 48167 | 85366 | 759 |
2131352 | 2131352 | 2022-01-19 | Galveston | Texas | 48167 | 85047 | 756 |
2128098 | 2128098 | 2022-01-18 | Galveston | Texas | 48167 | 84572 | 753 |
2124846 | 2124846 | 2022-01-17 | Galveston | Texas | 48167 | 84022 | 749 |
2121594 | 2121594 | 2022-01-16 | Galveston | Texas | 48167 | 83305 | 749 |
2118342 | 2118342 | 2022-01-15 | Galveston | Texas | 48167 | 82654 | 748 |
2115091 | 2115091 | 2022-01-14 | Galveston | Texas | 48167 | 81808 | 743 |
2111839 | 2111839 | 2022-01-13 | Galveston | Texas | 48167 | 82931 | 741 |
2108587 | 2108587 | 2022-01-12 | Galveston | Texas | 48167 | 81938 | 738 |
2105336 | 2105336 | 2022-01-11 | Galveston | Texas | 48167 | 80969 | 735 |
2102085 | 2102085 | 2022-01-10 | Galveston | Texas | 48167 | 80124 | 734 |
2098834 | 2098834 | 2022-01-09 | Galveston | Texas | 48167 | 79208 | 734 |
2095582 | 2095582 | 2022-01-08 | Galveston | Texas | 48167 | 78481 | 734 |
2092330 | 2092330 | 2022-01-07 | Galveston | Texas | 48167 | 77655 | 734 |
2089078 | 2089078 | 2022-01-06 | Galveston | Texas | 48167 | 76694 | 731 |
2085827 | 2085827 | 2022-01-05 | Galveston | Texas | 48167 | 76071 | 731 |
2082575 | 2082575 | 2022-01-04 | Galveston | Texas | 48167 | 74970 | 731 |
2079323 | 2079323 | 2022-01-03 | Galveston | Texas | 48167 | 73748 | 729 |
2076072 | 2076072 | 2022-01-02 | Galveston | Texas | 48167 | 69471 | 729 |
2072821 | 2072821 | 2022-01-01 | Galveston | Texas | 48167 | 69471 | 729 |
2069570 | 2069570 | 2021-12-31 | Galveston | Texas | 48167 | 69471 | 729 |
2066319 | 2066319 | 2021-12-30 | Galveston | Texas | 48167 | 69471 | 729 |
2063069 | 2063069 | 2021-12-29 | Galveston | Texas | 48167 | 69284 | 728 |
2059819 | 2059819 | 2021-12-28 | Galveston | Texas | 48167 | 68896 | 728 |
2056570 | 2056570 | 2021-12-27 | Galveston | Texas | 48167 | 68718 | 728 |
2053321 | 2053321 | 2021-12-26 | Galveston | Texas | 48167 | 67252 | 725 |
2050071 | 2050071 | 2021-12-25 | Galveston | Texas | 48167 | 67252 | 725 |
2046821 | 2046821 | 2021-12-24 | Galveston | Texas | 48167 | 67252 | 725 |
2043571 | 2043571 | 2021-12-23 | Galveston | Texas | 48167 | 67252 | 725 |
2040322 | 2040322 | 2021-12-22 | Galveston | Texas | 48167 | 67005 | 722 |
2037072 | 2037072 | 2021-12-21 | Galveston | Texas | 48167 | 66776 | 722 |
2033822 | 2033822 | 2021-12-20 | Galveston | Texas | 48167 | 66628 | 722 |
2030572 | 2030572 | 2021-12-19 | Galveston | Texas | 48167 | 66373 | 722 |
2027321 | 2027321 | 2021-12-18 | Galveston | Texas | 48167 | 66271 | 722 |
2024070 | 2024070 | 2021-12-17 | Galveston | Texas | 48167 | 66156 | 722 |
2020819 | 2020819 | 2021-12-16 | Galveston | Texas | 48167 | 66063 | 721 |
2017568 | 2017568 | 2021-12-15 | Galveston | Texas | 48167 | 65984 | 720 |
2014318 | 2014318 | 2021-12-14 | Galveston | Texas | 48167 | 65926 | 719 |
2011067 | 2011067 | 2021-12-13 | Galveston | Texas | 48167 | 65878 | 717 |
2007816 | 2007816 | 2021-12-12 | Galveston | Texas | 48167 | 65793 | 717 |
2004565 | 2004565 | 2021-12-11 | Galveston | Texas | 48167 | 65752 | 717 |
2001314 | 2001314 | 2021-12-10 | Galveston | Texas | 48167 | 65727 | 717 |
1998064 | 1998064 | 2021-12-09 | Galveston | Texas | 48167 | 65463 | 715 |
1994813 | 1994813 | 2021-12-08 | Galveston | Texas | 48167 | 65450 | 713 |
1991562 | 1991562 | 2021-12-07 | Galveston | Texas | 48167 | 65437 | 712 |
1988311 | 1988311 | 2021-12-06 | Galveston | Texas | 48167 | 65405 | 712 |
1985061 | 1985061 | 2021-12-05 | Galveston | Texas | 48167 | 65385 | 712 |
1981811 | 1981811 | 2021-12-04 | Galveston | Texas | 48167 | 65367 | 712 |
1978561 | 1978561 | 2021-12-03 | Galveston | Texas | 48167 | 65356 | 711 |
1975311 | 1975311 | 2021-12-02 | Galveston | Texas | 48167 | 65336 | 710 |
1972062 | 1972062 | 2021-12-01 | Galveston | Texas | 48167 | 65328 | 709 |
1968812 | 1968812 | 2021-11-30 | Galveston | Texas | 48167 | 65315 | 708 |
1965561 | 1965561 | 2021-11-29 | Galveston | Texas | 48167 | 65195 | 708 |
1962309 | 1962309 | 2021-11-28 | Galveston | Texas | 48167 | 65148 | 707 |
1959058 | 1959058 | 2021-11-27 | Galveston | Texas | 48167 | 65148 | 707 |
1955807 | 1955807 | 2021-11-26 | Galveston | Texas | 48167 | 65148 | 707 |
1952556 | 1952556 | 2021-11-25 | Galveston | Texas | 48167 | 65148 | 707 |
1949305 | 1949305 | 2021-11-24 | Galveston | Texas | 48167 | 65148 | 707 |
1946054 | 1946054 | 2021-11-23 | Galveston | Texas | 48167 | 65078 | 707 |
1942803 | 1942803 | 2021-11-22 | Galveston | Texas | 48167 | 64999 | 707 |
1939553 | 1939553 | 2021-11-21 | Galveston | Texas | 48167 | 64999 | 707 |
1936303 | 1936303 | 2021-11-20 | Galveston | Texas | 48167 | 64999 | 707 |
1933053 | 1933053 | 2021-11-19 | Galveston | Texas | 48167 | 64948 | 705 |
1929802 | 1929802 | 2021-11-18 | Galveston | Texas | 48167 | 64907 | 705 |
1926552 | 1926552 | 2021-11-17 | Galveston | Texas | 48167 | 64883 | 705 |
1923302 | 1923302 | 2021-11-16 | Galveston | Texas | 48167 | 64823 | 704 |
1920053 | 1920053 | 2021-11-15 | Galveston | Texas | 48167 | 64728 | 704 |
1916803 | 1916803 | 2021-11-14 | Galveston | Texas | 48167 | 64728 | 704 |
1913553 | 1913553 | 2021-11-13 | Galveston | Texas | 48167 | 64728 | 704 |
1910303 | 1910303 | 2021-11-12 | Galveston | Texas | 48167 | 64642 | 704 |
1907054 | 1907054 | 2021-11-11 | Galveston | Texas | 48167 | 64642 | 703 |
1903805 | 1903805 | 2021-11-10 | Galveston | Texas | 48167 | 64546 | 701 |
1900555 | 1900555 | 2021-11-09 | Galveston | Texas | 48167 | 64546 | 701 |
1897305 | 1897305 | 2021-11-08 | Galveston | Texas | 48167 | 64428 | 701 |
1894055 | 1894055 | 2021-11-07 | Galveston | Texas | 48167 | 64428 | 701 |
1890805 | 1890805 | 2021-11-06 | Galveston | Texas | 48167 | 64428 | 700 |
1887555 | 1887555 | 2021-11-05 | Galveston | Texas | 48167 | 64407 | 699 |
1884305 | 1884305 | 2021-11-04 | Galveston | Texas | 48167 | 64371 | 699 |
1881056 | 1881056 | 2021-11-03 | Galveston | Texas | 48167 | 64343 | 698 |
1877807 | 1877807 | 2021-11-02 | Galveston | Texas | 48167 | 64291 | 698 |
1874558 | 1874558 | 2021-11-01 | Galveston | Texas | 48167 | 64200 | 697 |
1871309 | 1871309 | 2021-10-31 | Galveston | Texas | 48167 | 64200 | 697 |
1868060 | 1868060 | 2021-10-30 | Galveston | Texas | 48167 | 64200 | 697 |
1864811 | 1864811 | 2021-10-29 | Galveston | Texas | 48167 | 64134 | 697 |
1861562 | 1861562 | 2021-10-28 | Galveston | Texas | 48167 | 64101 | 696 |
1858313 | 1858313 | 2021-10-27 | Galveston | Texas | 48167 | 64067 | 696 |
1855064 | 1855064 | 2021-10-26 | Galveston | Texas | 48167 | 63942 | 692 |
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);