ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Crawford" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175110 | 2175110 | 2022-02-02 | Crawford | Kansas | 20037 | 11294 | 122 |
2171857 | 2171857 | 2022-02-01 | Crawford | Kansas | 20037 | 11119 | 122 |
2168604 | 2168604 | 2022-01-31 | Crawford | Kansas | 20037 | 11119 | 122 |
2165349 | 2165349 | 2022-01-30 | Crawford | Kansas | 20037 | 10999 | 122 |
2162094 | 2162094 | 2022-01-29 | Crawford | Kansas | 20037 | 10999 | 122 |
2158839 | 2158839 | 2022-01-28 | Crawford | Kansas | 20037 | 10999 | 122 |
2155585 | 2155585 | 2022-01-27 | Crawford | Kansas | 20037 | 10797 | 122 |
2152332 | 2152332 | 2022-01-26 | Crawford | Kansas | 20037 | 10797 | 122 |
2149080 | 2149080 | 2022-01-25 | Crawford | Kansas | 20037 | 10584 | 122 |
2145828 | 2145828 | 2022-01-24 | Crawford | Kansas | 20037 | 10584 | 122 |
2142573 | 2142573 | 2022-01-23 | Crawford | Kansas | 20037 | 10383 | 122 |
2139318 | 2139318 | 2022-01-22 | Crawford | Kansas | 20037 | 10383 | 122 |
2136062 | 2136062 | 2022-01-21 | Crawford | Kansas | 20037 | 10383 | 122 |
2132810 | 2132810 | 2022-01-20 | Crawford | Kansas | 20037 | 10021 | 122 |
2129557 | 2129557 | 2022-01-19 | Crawford | Kansas | 20037 | 10021 | 122 |
2126303 | 2126303 | 2022-01-18 | Crawford | Kansas | 20037 | 9329 | 122 |
2123051 | 2123051 | 2022-01-17 | Crawford | Kansas | 20037 | 9329 | 120 |
2119799 | 2119799 | 2022-01-16 | Crawford | Kansas | 20037 | 9329 | 120 |
2116547 | 2116547 | 2022-01-15 | Crawford | Kansas | 20037 | 9329 | 120 |
2113296 | 2113296 | 2022-01-14 | Crawford | Kansas | 20037 | 9329 | 120 |
2110044 | 2110044 | 2022-01-13 | Crawford | Kansas | 20037 | 9014 | 120 |
2106793 | 2106793 | 2022-01-12 | Crawford | Kansas | 20037 | 9014 | 120 |
2103542 | 2103542 | 2022-01-11 | Crawford | Kansas | 20037 | 8582 | 120 |
2100291 | 2100291 | 2022-01-10 | Crawford | Kansas | 20037 | 8582 | 120 |
2097040 | 2097040 | 2022-01-09 | Crawford | Kansas | 20037 | 8393 | 120 |
2093788 | 2093788 | 2022-01-08 | Crawford | Kansas | 20037 | 8393 | 120 |
2090536 | 2090536 | 2022-01-07 | Crawford | Kansas | 20037 | 8393 | 120 |
2087285 | 2087285 | 2022-01-06 | Crawford | Kansas | 20037 | 8227 | 120 |
2084033 | 2084033 | 2022-01-05 | Crawford | Kansas | 20037 | 8227 | 120 |
2080781 | 2080781 | 2022-01-04 | Crawford | Kansas | 20037 | 8031 | 117 |
2077529 | 2077529 | 2022-01-03 | Crawford | Kansas | 20037 | 8031 | 117 |
2074278 | 2074278 | 2022-01-02 | Crawford | Kansas | 20037 | 7876 | 117 |
2071027 | 2071027 | 2022-01-01 | Crawford | Kansas | 20037 | 7876 | 117 |
2067776 | 2067776 | 2021-12-31 | Crawford | Kansas | 20037 | 7876 | 117 |
2064525 | 2064525 | 2021-12-30 | Crawford | Kansas | 20037 | 7876 | 117 |
2061275 | 2061275 | 2021-12-29 | Crawford | Kansas | 20037 | 7876 | 117 |
2058026 | 2058026 | 2021-12-28 | Crawford | Kansas | 20037 | 7745 | 117 |
2054777 | 2054777 | 2021-12-27 | Crawford | Kansas | 20037 | 7745 | 117 |
2051527 | 2051527 | 2021-12-26 | Crawford | Kansas | 20037 | 7643 | 117 |
2048277 | 2048277 | 2021-12-25 | Crawford | Kansas | 20037 | 7643 | 117 |
2045027 | 2045027 | 2021-12-24 | Crawford | Kansas | 20037 | 7643 | 117 |
2041778 | 2041778 | 2021-12-23 | Crawford | Kansas | 20037 | 7643 | 117 |
2038528 | 2038528 | 2021-12-22 | Crawford | Kansas | 20037 | 7643 | 117 |
2035278 | 2035278 | 2021-12-21 | Crawford | Kansas | 20037 | 7553 | 117 |
2032028 | 2032028 | 2021-12-20 | Crawford | Kansas | 20037 | 7553 | 117 |
2028777 | 2028777 | 2021-12-19 | Crawford | Kansas | 20037 | 7523 | 117 |
2025526 | 2025526 | 2021-12-18 | Crawford | Kansas | 20037 | 7523 | 117 |
2022275 | 2022275 | 2021-12-17 | Crawford | Kansas | 20037 | 7523 | 117 |
2019024 | 2019024 | 2021-12-16 | Crawford | Kansas | 20037 | 7463 | 117 |
2015774 | 2015774 | 2021-12-15 | Crawford | Kansas | 20037 | 7463 | 117 |
2012523 | 2012523 | 2021-12-14 | Crawford | Kansas | 20037 | 7418 | 117 |
2009272 | 2009272 | 2021-12-13 | Crawford | Kansas | 20037 | 7418 | 117 |
2006021 | 2006021 | 2021-12-12 | Crawford | Kansas | 20037 | 7380 | 117 |
2002770 | 2002770 | 2021-12-11 | Crawford | Kansas | 20037 | 7380 | 117 |
1999520 | 1999520 | 2021-12-10 | Crawford | Kansas | 20037 | 7380 | 117 |
1996269 | 1996269 | 2021-12-09 | Crawford | Kansas | 20037 | 7342 | 117 |
1993018 | 1993018 | 2021-12-08 | Crawford | Kansas | 20037 | 7342 | 117 |
1989767 | 1989767 | 2021-12-07 | Crawford | Kansas | 20037 | 7286 | 117 |
1986517 | 1986517 | 2021-12-06 | Crawford | Kansas | 20037 | 7286 | 116 |
1983267 | 1983267 | 2021-12-05 | Crawford | Kansas | 20037 | 7246 | 116 |
1980017 | 1980017 | 2021-12-04 | Crawford | Kansas | 20037 | 7246 | 116 |
1976767 | 1976767 | 2021-12-03 | Crawford | Kansas | 20037 | 7246 | 116 |
1973518 | 1973518 | 2021-12-02 | Crawford | Kansas | 20037 | 7164 | 116 |
1970268 | 1970268 | 2021-12-01 | Crawford | Kansas | 20037 | 7164 | 116 |
1967018 | 1967018 | 2021-11-30 | Crawford | Kansas | 20037 | 7086 | 116 |
1963766 | 1963766 | 2021-11-29 | Crawford | Kansas | 20037 | 7086 | 115 |
1960515 | 1960515 | 2021-11-28 | Crawford | Kansas | 20037 | 7039 | 115 |
1957264 | 1957264 | 2021-11-27 | Crawford | Kansas | 20037 | 7039 | 115 |
1954013 | 1954013 | 2021-11-26 | Crawford | Kansas | 20037 | 7039 | 115 |
1950762 | 1950762 | 2021-11-25 | Crawford | Kansas | 20037 | 7039 | 115 |
1947511 | 1947511 | 2021-11-24 | Crawford | Kansas | 20037 | 7039 | 115 |
1944260 | 1944260 | 2021-11-23 | Crawford | Kansas | 20037 | 6992 | 115 |
1941010 | 1941010 | 2021-11-22 | Crawford | Kansas | 20037 | 6992 | 115 |
1937760 | 1937760 | 2021-11-21 | Crawford | Kansas | 20037 | 6946 | 115 |
1934510 | 1934510 | 2021-11-20 | Crawford | Kansas | 20037 | 6946 | 115 |
1931259 | 1931259 | 2021-11-19 | Crawford | Kansas | 20037 | 6946 | 115 |
1928008 | 1928008 | 2021-11-18 | Crawford | Kansas | 20037 | 6906 | 115 |
1924758 | 1924758 | 2021-11-17 | Crawford | Kansas | 20037 | 6906 | 115 |
1921509 | 1921509 | 2021-11-16 | Crawford | Kansas | 20037 | 6870 | 115 |
1918259 | 1918259 | 2021-11-15 | Crawford | Kansas | 20037 | 6870 | 113 |
1915009 | 1915009 | 2021-11-14 | Crawford | Kansas | 20037 | 6854 | 113 |
1911759 | 1911759 | 2021-11-13 | Crawford | Kansas | 20037 | 6854 | 113 |
1908510 | 1908510 | 2021-11-12 | Crawford | Kansas | 20037 | 6854 | 113 |
1905261 | 1905261 | 2021-11-11 | Crawford | Kansas | 20037 | 6830 | 113 |
1902011 | 1902011 | 2021-11-10 | Crawford | Kansas | 20037 | 6830 | 113 |
1898761 | 1898761 | 2021-11-09 | Crawford | Kansas | 20037 | 6806 | 113 |
1895511 | 1895511 | 2021-11-08 | Crawford | Kansas | 20037 | 6806 | 113 |
1892261 | 1892261 | 2021-11-07 | Crawford | Kansas | 20037 | 6780 | 113 |
1889011 | 1889011 | 2021-11-06 | Crawford | Kansas | 20037 | 6780 | 113 |
1885761 | 1885761 | 2021-11-05 | Crawford | Kansas | 20037 | 6780 | 113 |
1882512 | 1882512 | 2021-11-04 | Crawford | Kansas | 20037 | 6763 | 113 |
1879263 | 1879263 | 2021-11-03 | Crawford | Kansas | 20037 | 6763 | 113 |
1876014 | 1876014 | 2021-11-02 | Crawford | Kansas | 20037 | 6742 | 113 |
1872765 | 1872765 | 2021-11-01 | Crawford | Kansas | 20037 | 6742 | 111 |
1869516 | 1869516 | 2021-10-31 | Crawford | Kansas | 20037 | 6731 | 111 |
1866267 | 1866267 | 2021-10-30 | Crawford | Kansas | 20037 | 6731 | 111 |
1863018 | 1863018 | 2021-10-29 | Crawford | Kansas | 20037 | 6731 | 111 |
1859769 | 1859769 | 2021-10-28 | Crawford | Kansas | 20037 | 6723 | 111 |
1856520 | 1856520 | 2021-10-27 | Crawford | Kansas | 20037 | 6723 | 111 |
1853271 | 1853271 | 2021-10-26 | Crawford | Kansas | 20037 | 6705 | 111 |
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);