ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
684 rows where county = "Rush" and fips = 20165 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337783 | 2337783 | 2022-03-24 | Rush | Kansas | 20165 | 806 | 18 |
2334529 | 2334529 | 2022-03-23 | Rush | Kansas | 20165 | 806 | 18 |
2331275 | 2331275 | 2022-03-22 | Rush | Kansas | 20165 | 806 | 18 |
2328023 | 2328023 | 2022-03-21 | Rush | Kansas | 20165 | 806 | 18 |
2324770 | 2324770 | 2022-03-20 | Rush | Kansas | 20165 | 806 | 18 |
2321516 | 2321516 | 2022-03-19 | Rush | Kansas | 20165 | 806 | 18 |
2318262 | 2318262 | 2022-03-18 | Rush | Kansas | 20165 | 806 | 18 |
2315009 | 2315009 | 2022-03-17 | Rush | Kansas | 20165 | 806 | 18 |
2311756 | 2311756 | 2022-03-16 | Rush | Kansas | 20165 | 806 | 18 |
2308503 | 2308503 | 2022-03-15 | Rush | Kansas | 20165 | 807 | 18 |
2305252 | 2305252 | 2022-03-14 | Rush | Kansas | 20165 | 807 | 18 |
2302000 | 2302000 | 2022-03-13 | Rush | Kansas | 20165 | 807 | 18 |
2298748 | 2298748 | 2022-03-12 | Rush | Kansas | 20165 | 807 | 18 |
2295496 | 2295496 | 2022-03-11 | Rush | Kansas | 20165 | 807 | 18 |
2292244 | 2292244 | 2022-03-10 | Rush | Kansas | 20165 | 808 | 18 |
2288992 | 2288992 | 2022-03-09 | Rush | Kansas | 20165 | 808 | 18 |
2285741 | 2285741 | 2022-03-08 | Rush | Kansas | 20165 | 808 | 18 |
2282489 | 2282489 | 2022-03-07 | Rush | Kansas | 20165 | 808 | 18 |
2279236 | 2279236 | 2022-03-06 | Rush | Kansas | 20165 | 808 | 18 |
2275983 | 2275983 | 2022-03-05 | Rush | Kansas | 20165 | 808 | 18 |
2272730 | 2272730 | 2022-03-04 | Rush | Kansas | 20165 | 808 | 18 |
2269478 | 2269478 | 2022-03-03 | Rush | Kansas | 20165 | 810 | 18 |
2266225 | 2266225 | 2022-03-02 | Rush | Kansas | 20165 | 810 | 18 |
2262974 | 2262974 | 2022-03-01 | Rush | Kansas | 20165 | 809 | 18 |
2259723 | 2259723 | 2022-02-28 | Rush | Kansas | 20165 | 809 | 18 |
2256472 | 2256472 | 2022-02-27 | Rush | Kansas | 20165 | 807 | 18 |
2253221 | 2253221 | 2022-02-26 | Rush | Kansas | 20165 | 807 | 18 |
2249970 | 2249970 | 2022-02-25 | Rush | Kansas | 20165 | 807 | 18 |
2246719 | 2246719 | 2022-02-24 | Rush | Kansas | 20165 | 807 | 18 |
2243468 | 2243468 | 2022-02-23 | Rush | Kansas | 20165 | 807 | 18 |
2240217 | 2240217 | 2022-02-22 | Rush | Kansas | 20165 | 806 | 18 |
2236966 | 2236966 | 2022-02-21 | Rush | Kansas | 20165 | 806 | 18 |
2233715 | 2233715 | 2022-02-20 | Rush | Kansas | 20165 | 806 | 18 |
2230464 | 2230464 | 2022-02-19 | Rush | Kansas | 20165 | 806 | 18 |
2227213 | 2227213 | 2022-02-18 | Rush | Kansas | 20165 | 806 | 18 |
2223962 | 2223962 | 2022-02-17 | Rush | Kansas | 20165 | 804 | 18 |
2220711 | 2220711 | 2022-02-16 | Rush | Kansas | 20165 | 804 | 18 |
2217460 | 2217460 | 2022-02-15 | Rush | Kansas | 20165 | 801 | 18 |
2214209 | 2214209 | 2022-02-14 | Rush | Kansas | 20165 | 801 | 18 |
2210957 | 2210957 | 2022-02-13 | Rush | Kansas | 20165 | 798 | 18 |
2207704 | 2207704 | 2022-02-12 | Rush | Kansas | 20165 | 798 | 18 |
2204451 | 2204451 | 2022-02-11 | Rush | Kansas | 20165 | 798 | 18 |
2201198 | 2201198 | 2022-02-10 | Rush | Kansas | 20165 | 798 | 18 |
2197944 | 2197944 | 2022-02-09 | Rush | Kansas | 20165 | 798 | 18 |
2194690 | 2194690 | 2022-02-08 | Rush | Kansas | 20165 | 796 | 17 |
2191436 | 2191436 | 2022-02-07 | Rush | Kansas | 20165 | 796 | 17 |
2188183 | 2188183 | 2022-02-06 | Rush | Kansas | 20165 | 786 | 17 |
2184930 | 2184930 | 2022-02-05 | Rush | Kansas | 20165 | 786 | 17 |
2181678 | 2181678 | 2022-02-04 | Rush | Kansas | 20165 | 786 | 17 |
2178427 | 2178427 | 2022-02-03 | Rush | Kansas | 20165 | 780 | 17 |
2175174 | 2175174 | 2022-02-02 | Rush | Kansas | 20165 | 780 | 17 |
2171921 | 2171921 | 2022-02-01 | Rush | Kansas | 20165 | 774 | 17 |
2168668 | 2168668 | 2022-01-31 | Rush | Kansas | 20165 | 774 | 17 |
2165413 | 2165413 | 2022-01-30 | Rush | Kansas | 20165 | 764 | 17 |
2162158 | 2162158 | 2022-01-29 | Rush | Kansas | 20165 | 764 | 17 |
2158903 | 2158903 | 2022-01-28 | Rush | Kansas | 20165 | 764 | 17 |
2155649 | 2155649 | 2022-01-27 | Rush | Kansas | 20165 | 754 | 17 |
2152396 | 2152396 | 2022-01-26 | Rush | Kansas | 20165 | 754 | 17 |
2149144 | 2149144 | 2022-01-25 | Rush | Kansas | 20165 | 744 | 17 |
2145892 | 2145892 | 2022-01-24 | Rush | Kansas | 20165 | 744 | 17 |
2142637 | 2142637 | 2022-01-23 | Rush | Kansas | 20165 | 737 | 17 |
2139382 | 2139382 | 2022-01-22 | Rush | Kansas | 20165 | 737 | 17 |
2136126 | 2136126 | 2022-01-21 | Rush | Kansas | 20165 | 737 | 17 |
2132874 | 2132874 | 2022-01-20 | Rush | Kansas | 20165 | 726 | 17 |
2129621 | 2129621 | 2022-01-19 | Rush | Kansas | 20165 | 726 | 17 |
2126367 | 2126367 | 2022-01-18 | Rush | Kansas | 20165 | 672 | 16 |
2123115 | 2123115 | 2022-01-17 | Rush | Kansas | 20165 | 672 | 16 |
2119863 | 2119863 | 2022-01-16 | Rush | Kansas | 20165 | 672 | 16 |
2116611 | 2116611 | 2022-01-15 | Rush | Kansas | 20165 | 672 | 16 |
2113360 | 2113360 | 2022-01-14 | Rush | Kansas | 20165 | 672 | 16 |
2110108 | 2110108 | 2022-01-13 | Rush | Kansas | 20165 | 653 | 16 |
2106857 | 2106857 | 2022-01-12 | Rush | Kansas | 20165 | 653 | 16 |
2103606 | 2103606 | 2022-01-11 | Rush | Kansas | 20165 | 639 | 16 |
2100355 | 2100355 | 2022-01-10 | Rush | Kansas | 20165 | 639 | 16 |
2097104 | 2097104 | 2022-01-09 | Rush | Kansas | 20165 | 632 | 16 |
2093852 | 2093852 | 2022-01-08 | Rush | Kansas | 20165 | 632 | 16 |
2090600 | 2090600 | 2022-01-07 | Rush | Kansas | 20165 | 632 | 16 |
2087349 | 2087349 | 2022-01-06 | Rush | Kansas | 20165 | 619 | 16 |
2084097 | 2084097 | 2022-01-05 | Rush | Kansas | 20165 | 619 | 16 |
2080845 | 2080845 | 2022-01-04 | Rush | Kansas | 20165 | 612 | 16 |
2077593 | 2077593 | 2022-01-03 | Rush | Kansas | 20165 | 612 | 16 |
2074342 | 2074342 | 2022-01-02 | Rush | Kansas | 20165 | 608 | 16 |
2071091 | 2071091 | 2022-01-01 | Rush | Kansas | 20165 | 608 | 16 |
2067840 | 2067840 | 2021-12-31 | Rush | Kansas | 20165 | 608 | 16 |
2064589 | 2064589 | 2021-12-30 | Rush | Kansas | 20165 | 608 | 16 |
2061339 | 2061339 | 2021-12-29 | Rush | Kansas | 20165 | 608 | 16 |
2058090 | 2058090 | 2021-12-28 | Rush | Kansas | 20165 | 601 | 16 |
2054841 | 2054841 | 2021-12-27 | Rush | Kansas | 20165 | 601 | 16 |
2051591 | 2051591 | 2021-12-26 | Rush | Kansas | 20165 | 594 | 16 |
2048341 | 2048341 | 2021-12-25 | Rush | Kansas | 20165 | 594 | 16 |
2045091 | 2045091 | 2021-12-24 | Rush | Kansas | 20165 | 594 | 16 |
2041842 | 2041842 | 2021-12-23 | Rush | Kansas | 20165 | 594 | 16 |
2038592 | 2038592 | 2021-12-22 | Rush | Kansas | 20165 | 594 | 16 |
2035342 | 2035342 | 2021-12-21 | Rush | Kansas | 20165 | 589 | 16 |
2032092 | 2032092 | 2021-12-20 | Rush | Kansas | 20165 | 589 | 16 |
2028841 | 2028841 | 2021-12-19 | Rush | Kansas | 20165 | 586 | 16 |
2025590 | 2025590 | 2021-12-18 | Rush | Kansas | 20165 | 586 | 16 |
2022339 | 2022339 | 2021-12-17 | Rush | Kansas | 20165 | 586 | 16 |
2019088 | 2019088 | 2021-12-16 | Rush | Kansas | 20165 | 582 | 16 |
2015838 | 2015838 | 2021-12-15 | Rush | Kansas | 20165 | 582 | 16 |
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);