ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48423 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
cases 365 ✖
- 37076 6
- 3908 5
- 9393 5
- 19868 5
- 20024 5
- 20765 5
- 28187 5
- 32559 5
- 36127 5
- 36884 5
- 189 4
- 198 4
- 223 4
- 12844 4
- 13854 4
- 15407 4
- 16335 4
- 18366 4
- 19454 4
- 19573 4
- 19696 4
- 20149 4
- 20334 4
- 20389 4
- 20452 4
- 20520 4
- 20588 4
- 20663 4
- 20732 4
- 20927 4
- 21115 4
- 21471 4
- 22634 4
- 23060 4
- 23643 4
- 24855 4
- 26363 4
- 30322 4
- 33974 4
- 34714 4
- 35383 4
- 36039 4
- 36535 4
- 36719 4
- 37702 4
- 38011 4
- 4 3
- 10 3
- 146 3
- 174 3
- 204 3
- 271 3
- 340 3
- 500 3
- 772 3
- 1300 3
- 1763 3
- 2310 3
- 2822 3
- 3053 3
- 3371 3
- 4074 3
- 4303 3
- 4625 3
- 4969 3
- 5350 3
- 5765 3
- 6258 3
- 6685 3
- 7225 3
- 8038 3
- 9000 3
- 10366 3
- 11225 3
- 11733 3
- 12138 3
- 17952 3
- 18555 3
- 18634 3
- 18831 3
- 18989 3
- 19029 3
- 19107 3
- 19308 3
- 19368 3
- 19524 3
- 19624 3
- 19789 3
- 20078 3
- 20206 3
- 20253 3
- 20287 3
- 20368 3
- 20424 3
- 20492 3
- 20564 3
- 20608 3
- 20645 3
- 20698 3
- 20859 3
- 21268 3
- 22316 3
- 24025 3
- 24609 3
- 25678 3
- 27284 3
- 31302 3
- 34432 3
- 35092 3
- 35848 3
- 36437 3
- 36627 3
- 36804 3
- 36952 3
- 37023 3
- 3 2
- 5 2
- 8 2
- 27 2
- 32 2
- 57 2
- 82 2
- 93 2
- 108 2
- 121 2
- 134 2
- 139 2
- 192 2
- 195 2
- 244 2
- 310 2
- 2107 2
- 3088 2
- 3241 2
- 3646 2
- 6786 2
- 12137 2
- 16247 2
- 16779 2
- 17206 2
- 17292 2
- 17553 2
- 17764 2
- 18100 2
- 18230 2
- 18535 2
- 18896 2
- 18944 2
- 19248 2
- 19927 2
- 20812 2
- 21020 2
- 29822 2
- 33040 2
- 36283 2
- 14 1
- 21 1
- 31 1
- 43 1
- 47 1
- 53 1
- 62 1
- 63 1
- 96 1
- 101 1
- 103 1
- 116 1
- 123 1
- 124 1
- 125 1
- 131 1
- 132 1
- 142 1
- 144 1
- 155 1
- 156 1
- 165 1
- 170 1
- 178 1
- 185 1
- 186 1
- 199 1
- 200 1
- 202 1
- 210 1
- 212 1
- 215 1
- 216 1
- 238 1
- 283 1
- 297 1
- 318 1
- 392 1
- 422 1
- 455 1
- 567 1
- 619 1
- 657 1
- 702 1
- 849 1
- 1099 1
- 1164 1
- 1221 1
- 1442 1
- 1500 1
- 1569 1
- 1717 1
- 1908 1
- 1961 1
- 2007 1
- 2058 1
- 2106 1
- 2190 1
- 2223 1
- 2252 1
- 2293 1
- 2369 1
- 2416 1
- 2446 1
- 2470 1
- 2893 1
- 2928 1
- 2996 1
- 3322 1
- 3451 1
- 3562 1
- 3588 1
- 3609 1
- 3645 1
- 3786 1
- 3829 1
- 3981 1
- 4023 1
- 4051 1
- 4056 1
- 4117 1
- 4179 1
- 4260 1
- 4341 1
- 4436 1
- 4493 1
- 4542 1
- 4586 1
- 4722 1
- 4763 1
- 4826 1
- 4901 1
- 5067 1
- 5127 1
- 5234 1
- 5290 1
- 5477 1
- 5559 1
- 5665 1
- 5714 1
- 5910 1
- 5980 1
- 6058 1
- 6114 1
- 6383 1
- 6458 1
- 6563 1
- 6622 1
- 6981 1
- 7063 1
- 7501 1
- 7608 1
- 7708 1
- 7901 1
- 8389 1
- 8540 1
- 8777 1
- 8862 1
- 9139 1
- 9273 1
- 9685 1
- 9790 1
- 9900 1
- 10162 1
- 10650 1
- 10822 1
- 10939 1
- 11059 1
- 11399 1
- 11503 1
- 11595 1
- 11659 1
- 11900 1
- 12024 1
- 12482 1
- 12614 1
- 12749 1
- 13161 1
- 13340 1
- 13544 1
- 13545 1
- 14526 1
- 14806 1
- 15248 1
- 15874 1
- 18476 1
- 18743 1
- 19080 1
- 19119 1
- 19188 1
- 20252 1
- 21019 1
- 37172 1
- 37223 1
- 37230 1
- 37235 1
- 37249 1
- 37260 1
- 37263 1
- 37283 1
- 37306 1
- 37309 1
- 37316 1
- 37408 1
- 37428 1
- 37442 1
- 37475 1
- 37488 1
- 37498 1
- 37525 1
- 37534 1
- 37555 1
- 37606 1
- 37624 1
- 37644 1
- 37679 1
- 37689 1
- 37878 1
- 37929 1
- 37967 1
- 38016 1
- 38142 1
- 38455 1
- 38654 1
- 38892 1
- 38900 1
- 39195 1
- 39200 1
- 39364 1
- 39588 1
- 39594 1
- 39716 1
- 39902 1
- 39975 1
- 40169 1
- 40217 1
- 40402 1
- 40518 1
- 40659 1
- 41044 1
- 41236 1
- 41431 1
- 41514 1
- 41653 1
- 41844 1
- 42044 1
- 42212 1
- 42423 1
- 42565 1
- 42689 1
state 1
- Texas 692
fips 1
- 48423 · 692 ✖
county 1
- Smith 692
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177034 | 2177034 | 2022-02-02 | Smith | Texas | 48423 | 42689 | 872 |
2173780 | 2173780 | 2022-02-01 | Smith | Texas | 48423 | 42565 | 870 |
2170528 | 2170528 | 2022-01-31 | Smith | Texas | 48423 | 42423 | 869 |
2167274 | 2167274 | 2022-01-30 | Smith | Texas | 48423 | 42212 | 868 |
2164019 | 2164019 | 2022-01-29 | Smith | Texas | 48423 | 42044 | 867 |
2160764 | 2160764 | 2022-01-28 | Smith | Texas | 48423 | 41844 | 864 |
2157508 | 2157508 | 2022-01-27 | Smith | Texas | 48423 | 41653 | 864 |
2154255 | 2154255 | 2022-01-26 | Smith | Texas | 48423 | 41431 | 860 |
2151003 | 2151003 | 2022-01-25 | Smith | Texas | 48423 | 41236 | 856 |
2147751 | 2147751 | 2022-01-24 | Smith | Texas | 48423 | 40402 | 855 |
2144497 | 2144497 | 2022-01-23 | Smith | Texas | 48423 | 40169 | 855 |
2141242 | 2141242 | 2022-01-22 | Smith | Texas | 48423 | 39902 | 855 |
2137986 | 2137986 | 2022-01-21 | Smith | Texas | 48423 | 39588 | 854 |
2134732 | 2134732 | 2022-01-20 | Smith | Texas | 48423 | 39195 | 852 |
2131480 | 2131480 | 2022-01-19 | Smith | Texas | 48423 | 38892 | 850 |
2128226 | 2128226 | 2022-01-18 | Smith | Texas | 48423 | 38654 | 848 |
2124974 | 2124974 | 2022-01-17 | Smith | Texas | 48423 | 38455 | 846 |
2121722 | 2121722 | 2022-01-16 | Smith | Texas | 48423 | 38142 | 846 |
2118470 | 2118470 | 2022-01-15 | Smith | Texas | 48423 | 38016 | 843 |
2115219 | 2115219 | 2022-01-14 | Smith | Texas | 48423 | 37624 | 842 |
2111967 | 2111967 | 2022-01-13 | Smith | Texas | 48423 | 41514 | 841 |
2108715 | 2108715 | 2022-01-12 | Smith | Texas | 48423 | 41044 | 841 |
2105464 | 2105464 | 2022-01-11 | Smith | Texas | 48423 | 40659 | 840 |
2102213 | 2102213 | 2022-01-10 | Smith | Texas | 48423 | 40518 | 839 |
2098962 | 2098962 | 2022-01-09 | Smith | Texas | 48423 | 40217 | 839 |
2095710 | 2095710 | 2022-01-08 | Smith | Texas | 48423 | 39975 | 839 |
2092458 | 2092458 | 2022-01-07 | Smith | Texas | 48423 | 39716 | 839 |
2089206 | 2089206 | 2022-01-06 | Smith | Texas | 48423 | 39594 | 839 |
2085955 | 2085955 | 2022-01-05 | Smith | Texas | 48423 | 39364 | 839 |
2082703 | 2082703 | 2022-01-04 | Smith | Texas | 48423 | 39200 | 839 |
2079451 | 2079451 | 2022-01-03 | Smith | Texas | 48423 | 38900 | 839 |
2076200 | 2076200 | 2022-01-02 | Smith | Texas | 48423 | 38011 | 837 |
2072949 | 2072949 | 2022-01-01 | Smith | Texas | 48423 | 38011 | 837 |
2069698 | 2069698 | 2021-12-31 | Smith | Texas | 48423 | 38011 | 837 |
2066447 | 2066447 | 2021-12-30 | Smith | Texas | 48423 | 38011 | 837 |
2063197 | 2063197 | 2021-12-29 | Smith | Texas | 48423 | 37967 | 837 |
2059947 | 2059947 | 2021-12-28 | Smith | Texas | 48423 | 37929 | 837 |
2056698 | 2056698 | 2021-12-27 | Smith | Texas | 48423 | 37878 | 837 |
2053449 | 2053449 | 2021-12-26 | Smith | Texas | 48423 | 37702 | 835 |
2050199 | 2050199 | 2021-12-25 | Smith | Texas | 48423 | 37702 | 835 |
2046949 | 2046949 | 2021-12-24 | Smith | Texas | 48423 | 37702 | 835 |
2043699 | 2043699 | 2021-12-23 | Smith | Texas | 48423 | 37702 | 835 |
2040450 | 2040450 | 2021-12-22 | Smith | Texas | 48423 | 37689 | 835 |
2037200 | 2037200 | 2021-12-21 | Smith | Texas | 48423 | 37679 | 835 |
2033950 | 2033950 | 2021-12-20 | Smith | Texas | 48423 | 37644 | 835 |
2030700 | 2030700 | 2021-12-19 | Smith | Texas | 48423 | 37606 | 835 |
2027449 | 2027449 | 2021-12-18 | Smith | Texas | 48423 | 37555 | 835 |
2024198 | 2024198 | 2021-12-17 | Smith | Texas | 48423 | 37534 | 833 |
2020947 | 2020947 | 2021-12-16 | Smith | Texas | 48423 | 37525 | 831 |
2017696 | 2017696 | 2021-12-15 | Smith | Texas | 48423 | 37498 | 831 |
2014446 | 2014446 | 2021-12-14 | Smith | Texas | 48423 | 37488 | 830 |
2011195 | 2011195 | 2021-12-13 | Smith | Texas | 48423 | 37475 | 830 |
2007944 | 2007944 | 2021-12-12 | Smith | Texas | 48423 | 37442 | 830 |
2004693 | 2004693 | 2021-12-11 | Smith | Texas | 48423 | 37428 | 829 |
2001442 | 2001442 | 2021-12-10 | Smith | Texas | 48423 | 37408 | 829 |
1998192 | 1998192 | 2021-12-09 | Smith | Texas | 48423 | 37316 | 829 |
1994941 | 1994941 | 2021-12-08 | Smith | Texas | 48423 | 37309 | 827 |
1991690 | 1991690 | 2021-12-07 | Smith | Texas | 48423 | 37306 | 827 |
1988439 | 1988439 | 2021-12-06 | Smith | Texas | 48423 | 37283 | 827 |
1985189 | 1985189 | 2021-12-05 | Smith | Texas | 48423 | 37263 | 827 |
1981939 | 1981939 | 2021-12-04 | Smith | Texas | 48423 | 37260 | 827 |
1978689 | 1978689 | 2021-12-03 | Smith | Texas | 48423 | 37249 | 826 |
1975439 | 1975439 | 2021-12-02 | Smith | Texas | 48423 | 37235 | 826 |
1972190 | 1972190 | 2021-12-01 | Smith | Texas | 48423 | 37230 | 826 |
1968940 | 1968940 | 2021-11-30 | Smith | Texas | 48423 | 37223 | 825 |
1965689 | 1965689 | 2021-11-29 | Smith | Texas | 48423 | 37172 | 824 |
1962437 | 1962437 | 2021-11-28 | Smith | Texas | 48423 | 37076 | 821 |
1959186 | 1959186 | 2021-11-27 | Smith | Texas | 48423 | 37076 | 821 |
1955935 | 1955935 | 2021-11-26 | Smith | Texas | 48423 | 37076 | 821 |
1952684 | 1952684 | 2021-11-25 | Smith | Texas | 48423 | 37076 | 821 |
1949433 | 1949433 | 2021-11-24 | Smith | Texas | 48423 | 37076 | 821 |
1946182 | 1946182 | 2021-11-23 | Smith | Texas | 48423 | 37076 | 819 |
1942931 | 1942931 | 2021-11-22 | Smith | Texas | 48423 | 37023 | 819 |
1939681 | 1939681 | 2021-11-21 | Smith | Texas | 48423 | 37023 | 819 |
1936431 | 1936431 | 2021-11-20 | Smith | Texas | 48423 | 37023 | 819 |
1933181 | 1933181 | 2021-11-19 | Smith | Texas | 48423 | 36952 | 818 |
1929930 | 1929930 | 2021-11-18 | Smith | Texas | 48423 | 36952 | 817 |
1926680 | 1926680 | 2021-11-17 | Smith | Texas | 48423 | 36952 | 811 |
1923430 | 1923430 | 2021-11-16 | Smith | Texas | 48423 | 36884 | 811 |
1920181 | 1920181 | 2021-11-15 | Smith | Texas | 48423 | 36884 | 809 |
1916931 | 1916931 | 2021-11-14 | Smith | Texas | 48423 | 36884 | 809 |
1913681 | 1913681 | 2021-11-13 | Smith | Texas | 48423 | 36884 | 809 |
1910431 | 1910431 | 2021-11-12 | Smith | Texas | 48423 | 36884 | 807 |
1907182 | 1907182 | 2021-11-11 | Smith | Texas | 48423 | 36804 | 804 |
1903933 | 1903933 | 2021-11-10 | Smith | Texas | 48423 | 36804 | 797 |
1900683 | 1900683 | 2021-11-09 | Smith | Texas | 48423 | 36804 | 797 |
1897433 | 1897433 | 2021-11-08 | Smith | Texas | 48423 | 36719 | 797 |
1894183 | 1894183 | 2021-11-07 | Smith | Texas | 48423 | 36719 | 797 |
1890933 | 1890933 | 2021-11-06 | Smith | Texas | 48423 | 36719 | 797 |
1887683 | 1887683 | 2021-11-05 | Smith | Texas | 48423 | 36719 | 791 |
1884433 | 1884433 | 2021-11-04 | Smith | Texas | 48423 | 36627 | 790 |
1881184 | 1881184 | 2021-11-03 | Smith | Texas | 48423 | 36627 | 790 |
1877935 | 1877935 | 2021-11-02 | Smith | Texas | 48423 | 36627 | 787 |
1874686 | 1874686 | 2021-11-01 | Smith | Texas | 48423 | 36535 | 787 |
1871437 | 1871437 | 2021-10-31 | Smith | Texas | 48423 | 36535 | 786 |
1868188 | 1868188 | 2021-10-30 | Smith | Texas | 48423 | 36535 | 785 |
1864939 | 1864939 | 2021-10-29 | Smith | Texas | 48423 | 36535 | 782 |
1861690 | 1861690 | 2021-10-28 | Smith | Texas | 48423 | 36437 | 780 |
1858441 | 1858441 | 2021-10-27 | Smith | Texas | 48423 | 36437 | 777 |
1855192 | 1855192 | 2021-10-26 | Smith | Texas | 48423 | 36437 | 776 |
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);