ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Crowley" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174453 | 2174453 | 2022-02-02 | Crowley | Colorado | 8025 | 2951 | 28 |
2171200 | 2171200 | 2022-02-01 | Crowley | Colorado | 8025 | 2935 | 28 |
2167947 | 2167947 | 2022-01-31 | Crowley | Colorado | 8025 | 2879 | 28 |
2164692 | 2164692 | 2022-01-30 | Crowley | Colorado | 8025 | 2877 | 28 |
2161437 | 2161437 | 2022-01-29 | Crowley | Colorado | 8025 | 2874 | 28 |
2158181 | 2158181 | 2022-01-28 | Crowley | Colorado | 8025 | 2877 | 28 |
2154928 | 2154928 | 2022-01-27 | Crowley | Colorado | 8025 | 2874 | 28 |
2151675 | 2151675 | 2022-01-26 | Crowley | Colorado | 8025 | 2848 | 27 |
2148423 | 2148423 | 2022-01-25 | Crowley | Colorado | 8025 | 2768 | 27 |
2145171 | 2145171 | 2022-01-24 | Crowley | Colorado | 8025 | 2750 | 27 |
2141916 | 2141916 | 2022-01-23 | Crowley | Colorado | 8025 | 2741 | 27 |
2138661 | 2138661 | 2022-01-22 | Crowley | Colorado | 8025 | 2741 | 27 |
2135405 | 2135405 | 2022-01-21 | Crowley | Colorado | 8025 | 2741 | 27 |
2132153 | 2132153 | 2022-01-20 | Crowley | Colorado | 8025 | 2730 | 27 |
2128900 | 2128900 | 2022-01-19 | Crowley | Colorado | 8025 | 2719 | 27 |
2125646 | 2125646 | 2022-01-18 | Crowley | Colorado | 8025 | 2710 | 27 |
2122394 | 2122394 | 2022-01-17 | Crowley | Colorado | 8025 | 2621 | 27 |
2119142 | 2119142 | 2022-01-16 | Crowley | Colorado | 8025 | 2600 | 27 |
2115890 | 2115890 | 2022-01-15 | Crowley | Colorado | 8025 | 2600 | 27 |
2112639 | 2112639 | 2022-01-14 | Crowley | Colorado | 8025 | 2600 | 27 |
2109387 | 2109387 | 2022-01-13 | Crowley | Colorado | 8025 | 2597 | 27 |
2106136 | 2106136 | 2022-01-12 | Crowley | Colorado | 8025 | 2586 | 27 |
2102885 | 2102885 | 2022-01-11 | Crowley | Colorado | 8025 | 2584 | 27 |
2099634 | 2099634 | 2022-01-10 | Crowley | Colorado | 8025 | 2563 | 27 |
2096383 | 2096383 | 2022-01-09 | Crowley | Colorado | 8025 | 2529 | 27 |
2093131 | 2093131 | 2022-01-08 | Crowley | Colorado | 8025 | 2529 | 27 |
2089879 | 2089879 | 2022-01-07 | Crowley | Colorado | 8025 | 2529 | 27 |
2086628 | 2086628 | 2022-01-06 | Crowley | Colorado | 8025 | 2524 | 27 |
2083376 | 2083376 | 2022-01-05 | Crowley | Colorado | 8025 | 2524 | 27 |
2080124 | 2080124 | 2022-01-04 | Crowley | Colorado | 8025 | 2521 | 27 |
2076872 | 2076872 | 2022-01-03 | Crowley | Colorado | 8025 | 2509 | 27 |
2073621 | 2073621 | 2022-01-02 | Crowley | Colorado | 8025 | 2499 | 27 |
2070370 | 2070370 | 2022-01-01 | Crowley | Colorado | 8025 | 2499 | 27 |
2067119 | 2067119 | 2021-12-31 | Crowley | Colorado | 8025 | 2499 | 27 |
2063868 | 2063868 | 2021-12-30 | Crowley | Colorado | 8025 | 2497 | 27 |
2060618 | 2060618 | 2021-12-29 | Crowley | Colorado | 8025 | 2495 | 27 |
2057369 | 2057369 | 2021-12-28 | Crowley | Colorado | 8025 | 2494 | 27 |
2054120 | 2054120 | 2021-12-27 | Crowley | Colorado | 8025 | 2493 | 27 |
2050870 | 2050870 | 2021-12-26 | Crowley | Colorado | 8025 | 2492 | 27 |
2047620 | 2047620 | 2021-12-25 | Crowley | Colorado | 8025 | 2492 | 27 |
2044370 | 2044370 | 2021-12-24 | Crowley | Colorado | 8025 | 2492 | 27 |
2041121 | 2041121 | 2021-12-23 | Crowley | Colorado | 8025 | 2492 | 27 |
2037871 | 2037871 | 2021-12-22 | Crowley | Colorado | 8025 | 2492 | 27 |
2034621 | 2034621 | 2021-12-21 | Crowley | Colorado | 8025 | 2492 | 27 |
2031371 | 2031371 | 2021-12-20 | Crowley | Colorado | 8025 | 2491 | 27 |
2028120 | 2028120 | 2021-12-19 | Crowley | Colorado | 8025 | 2489 | 27 |
2024869 | 2024869 | 2021-12-18 | Crowley | Colorado | 8025 | 2489 | 27 |
2021618 | 2021618 | 2021-12-17 | Crowley | Colorado | 8025 | 2489 | 27 |
2018367 | 2018367 | 2021-12-16 | Crowley | Colorado | 8025 | 2488 | 27 |
2015117 | 2015117 | 2021-12-15 | Crowley | Colorado | 8025 | 2488 | 27 |
2011866 | 2011866 | 2021-12-14 | Crowley | Colorado | 8025 | 2488 | 27 |
2008615 | 2008615 | 2021-12-13 | Crowley | Colorado | 8025 | 2486 | 27 |
2005364 | 2005364 | 2021-12-12 | Crowley | Colorado | 8025 | 2484 | 27 |
2002113 | 2002113 | 2021-12-11 | Crowley | Colorado | 8025 | 2484 | 27 |
1998863 | 1998863 | 2021-12-10 | Crowley | Colorado | 8025 | 2484 | 27 |
1995612 | 1995612 | 2021-12-09 | Crowley | Colorado | 8025 | 2483 | 27 |
1992361 | 1992361 | 2021-12-08 | Crowley | Colorado | 8025 | 2482 | 27 |
1989110 | 1989110 | 2021-12-07 | Crowley | Colorado | 8025 | 2482 | 27 |
1985860 | 1985860 | 2021-12-06 | Crowley | Colorado | 8025 | 2480 | 27 |
1982610 | 1982610 | 2021-12-05 | Crowley | Colorado | 8025 | 2480 | 27 |
1979360 | 1979360 | 2021-12-04 | Crowley | Colorado | 8025 | 2480 | 27 |
1976110 | 1976110 | 2021-12-03 | Crowley | Colorado | 8025 | 2480 | 27 |
1972861 | 1972861 | 2021-12-02 | Crowley | Colorado | 8025 | 2474 | 27 |
1969611 | 1969611 | 2021-12-01 | Crowley | Colorado | 8025 | 2473 | 27 |
1966361 | 1966361 | 2021-11-30 | Crowley | Colorado | 8025 | 2471 | 27 |
1963109 | 1963109 | 2021-11-29 | Crowley | Colorado | 8025 | 2470 | 26 |
1959858 | 1959858 | 2021-11-28 | Crowley | Colorado | 8025 | 2466 | 26 |
1956607 | 1956607 | 2021-11-27 | Crowley | Colorado | 8025 | 2466 | 26 |
1953356 | 1953356 | 2021-11-26 | Crowley | Colorado | 8025 | 2466 | 26 |
1950105 | 1950105 | 2021-11-25 | Crowley | Colorado | 8025 | 2466 | 26 |
1946854 | 1946854 | 2021-11-24 | Crowley | Colorado | 8025 | 2461 | 26 |
1943603 | 1943603 | 2021-11-23 | Crowley | Colorado | 8025 | 2461 | 26 |
1940353 | 1940353 | 2021-11-22 | Crowley | Colorado | 8025 | 2457 | 26 |
1937103 | 1937103 | 2021-11-21 | Crowley | Colorado | 8025 | 2453 | 25 |
1933853 | 1933853 | 2021-11-20 | Crowley | Colorado | 8025 | 2453 | 25 |
1930601 | 1930601 | 2021-11-19 | Crowley | Colorado | 8025 | 2453 | 25 |
1927351 | 1927351 | 2021-11-18 | Crowley | Colorado | 8025 | 2448 | 25 |
1924101 | 1924101 | 2021-11-17 | Crowley | Colorado | 8025 | 2446 | 25 |
1920852 | 1920852 | 2021-11-16 | Crowley | Colorado | 8025 | 2445 | 25 |
1917602 | 1917602 | 2021-11-15 | Crowley | Colorado | 8025 | 2441 | 24 |
1914352 | 1914352 | 2021-11-14 | Crowley | Colorado | 8025 | 2436 | 24 |
1911102 | 1911102 | 2021-11-13 | Crowley | Colorado | 8025 | 2436 | 24 |
1907853 | 1907853 | 2021-11-12 | Crowley | Colorado | 8025 | 2436 | 24 |
1904604 | 1904604 | 2021-11-11 | Crowley | Colorado | 8025 | 2433 | 24 |
1901354 | 1901354 | 2021-11-10 | Crowley | Colorado | 8025 | 2428 | 24 |
1898104 | 1898104 | 2021-11-09 | Crowley | Colorado | 8025 | 2422 | 24 |
1894854 | 1894854 | 2021-11-08 | Crowley | Colorado | 8025 | 2417 | 24 |
1891604 | 1891604 | 2021-11-07 | Crowley | Colorado | 8025 | 2407 | 24 |
1888354 | 1888354 | 2021-11-06 | Crowley | Colorado | 8025 | 2407 | 24 |
1885104 | 1885104 | 2021-11-05 | Crowley | Colorado | 8025 | 2407 | 24 |
1881855 | 1881855 | 2021-11-04 | Crowley | Colorado | 8025 | 2406 | 24 |
1878606 | 1878606 | 2021-11-03 | Crowley | Colorado | 8025 | 2400 | 24 |
1875357 | 1875357 | 2021-11-02 | Crowley | Colorado | 8025 | 2399 | 24 |
1872108 | 1872108 | 2021-11-01 | Crowley | Colorado | 8025 | 2396 | 24 |
1868859 | 1868859 | 2021-10-31 | Crowley | Colorado | 8025 | 2392 | 24 |
1865610 | 1865610 | 2021-10-30 | Crowley | Colorado | 8025 | 2392 | 24 |
1862361 | 1862361 | 2021-10-29 | Crowley | Colorado | 8025 | 2392 | 24 |
1859112 | 1859112 | 2021-10-28 | Crowley | Colorado | 8025 | 2386 | 24 |
1855863 | 1855863 | 2021-10-27 | Crowley | Colorado | 8025 | 2383 | 23 |
1852614 | 1852614 | 2021-10-26 | Crowley | Colorado | 8025 | 2382 | 23 |
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);