ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,464 rows where county = "Rush" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337578 | 2337578 | 2022-03-24 | Rush | Indiana | 18139 | 4906 | 58 |
2337783 | 2337783 | 2022-03-24 | Rush | Kansas | 20165 | 806 | 18 |
2334324 | 2334324 | 2022-03-23 | Rush | Indiana | 18139 | 4906 | 58 |
2334529 | 2334529 | 2022-03-23 | Rush | Kansas | 20165 | 806 | 18 |
2331070 | 2331070 | 2022-03-22 | Rush | Indiana | 18139 | 4905 | 58 |
2331275 | 2331275 | 2022-03-22 | Rush | Kansas | 20165 | 806 | 18 |
2327818 | 2327818 | 2022-03-21 | Rush | Indiana | 18139 | 4907 | 58 |
2328023 | 2328023 | 2022-03-21 | Rush | Kansas | 20165 | 806 | 18 |
2324565 | 2324565 | 2022-03-20 | Rush | Indiana | 18139 | 4903 | 58 |
2324770 | 2324770 | 2022-03-20 | Rush | Kansas | 20165 | 806 | 18 |
2321311 | 2321311 | 2022-03-19 | Rush | Indiana | 18139 | 4903 | 58 |
2321516 | 2321516 | 2022-03-19 | Rush | Kansas | 20165 | 806 | 18 |
2318057 | 2318057 | 2022-03-18 | Rush | Indiana | 18139 | 4903 | 58 |
2318262 | 2318262 | 2022-03-18 | Rush | Kansas | 20165 | 806 | 18 |
2314804 | 2314804 | 2022-03-17 | Rush | Indiana | 18139 | 4902 | 58 |
2315009 | 2315009 | 2022-03-17 | Rush | Kansas | 20165 | 806 | 18 |
2311551 | 2311551 | 2022-03-16 | Rush | Indiana | 18139 | 4900 | 58 |
2311756 | 2311756 | 2022-03-16 | Rush | Kansas | 20165 | 806 | 18 |
2308298 | 2308298 | 2022-03-15 | Rush | Indiana | 18139 | 4900 | 59 |
2308503 | 2308503 | 2022-03-15 | Rush | Kansas | 20165 | 807 | 18 |
2305047 | 2305047 | 2022-03-14 | Rush | Indiana | 18139 | 4899 | 59 |
2305252 | 2305252 | 2022-03-14 | Rush | Kansas | 20165 | 807 | 18 |
2301795 | 2301795 | 2022-03-13 | Rush | Indiana | 18139 | 4898 | 59 |
2302000 | 2302000 | 2022-03-13 | Rush | Kansas | 20165 | 807 | 18 |
2298543 | 2298543 | 2022-03-12 | Rush | Indiana | 18139 | 4898 | 59 |
2298748 | 2298748 | 2022-03-12 | Rush | Kansas | 20165 | 807 | 18 |
2295291 | 2295291 | 2022-03-11 | Rush | Indiana | 18139 | 4898 | 59 |
2295496 | 2295496 | 2022-03-11 | Rush | Kansas | 20165 | 807 | 18 |
2292039 | 2292039 | 2022-03-10 | Rush | Indiana | 18139 | 4898 | 58 |
2292244 | 2292244 | 2022-03-10 | Rush | Kansas | 20165 | 808 | 18 |
2288787 | 2288787 | 2022-03-09 | Rush | Indiana | 18139 | 4897 | 58 |
2288992 | 2288992 | 2022-03-09 | Rush | Kansas | 20165 | 808 | 18 |
2285536 | 2285536 | 2022-03-08 | Rush | Indiana | 18139 | 4896 | 58 |
2285741 | 2285741 | 2022-03-08 | Rush | Kansas | 20165 | 808 | 18 |
2282284 | 2282284 | 2022-03-07 | Rush | Indiana | 18139 | 4897 | 58 |
2282489 | 2282489 | 2022-03-07 | Rush | Kansas | 20165 | 808 | 18 |
2279031 | 2279031 | 2022-03-06 | Rush | Indiana | 18139 | 4894 | 57 |
2279236 | 2279236 | 2022-03-06 | Rush | Kansas | 20165 | 808 | 18 |
2275778 | 2275778 | 2022-03-05 | Rush | Indiana | 18139 | 4894 | 57 |
2275983 | 2275983 | 2022-03-05 | Rush | Kansas | 20165 | 808 | 18 |
2272525 | 2272525 | 2022-03-04 | Rush | Indiana | 18139 | 4894 | 57 |
2272730 | 2272730 | 2022-03-04 | Rush | Kansas | 20165 | 808 | 18 |
2269273 | 2269273 | 2022-03-03 | Rush | Indiana | 18139 | 4891 | 56 |
2269478 | 2269478 | 2022-03-03 | Rush | Kansas | 20165 | 810 | 18 |
2266020 | 2266020 | 2022-03-02 | Rush | Indiana | 18139 | 4887 | 56 |
2266225 | 2266225 | 2022-03-02 | Rush | Kansas | 20165 | 810 | 18 |
2262769 | 2262769 | 2022-03-01 | Rush | Indiana | 18139 | 4886 | 56 |
2262974 | 2262974 | 2022-03-01 | Rush | Kansas | 20165 | 809 | 18 |
2259518 | 2259518 | 2022-02-28 | Rush | Indiana | 18139 | 4885 | 56 |
2259723 | 2259723 | 2022-02-28 | Rush | Kansas | 20165 | 809 | 18 |
2256267 | 2256267 | 2022-02-27 | Rush | Indiana | 18139 | 4872 | 56 |
2256472 | 2256472 | 2022-02-27 | Rush | Kansas | 20165 | 807 | 18 |
2253016 | 2253016 | 2022-02-26 | Rush | Indiana | 18139 | 4872 | 56 |
2253221 | 2253221 | 2022-02-26 | Rush | Kansas | 20165 | 807 | 18 |
2249765 | 2249765 | 2022-02-25 | Rush | Indiana | 18139 | 4872 | 56 |
2249970 | 2249970 | 2022-02-25 | Rush | Kansas | 20165 | 807 | 18 |
2246514 | 2246514 | 2022-02-24 | Rush | Indiana | 18139 | 4871 | 55 |
2246719 | 2246719 | 2022-02-24 | Rush | Kansas | 20165 | 807 | 18 |
2243263 | 2243263 | 2022-02-23 | Rush | Indiana | 18139 | 4870 | 55 |
2243468 | 2243468 | 2022-02-23 | Rush | Kansas | 20165 | 807 | 18 |
2240012 | 2240012 | 2022-02-22 | Rush | Indiana | 18139 | 4864 | 55 |
2240217 | 2240217 | 2022-02-22 | Rush | Kansas | 20165 | 806 | 18 |
2236761 | 2236761 | 2022-02-21 | Rush | Indiana | 18139 | 4858 | 55 |
2236966 | 2236966 | 2022-02-21 | Rush | Kansas | 20165 | 806 | 18 |
2233510 | 2233510 | 2022-02-20 | Rush | Indiana | 18139 | 4852 | 54 |
2233715 | 2233715 | 2022-02-20 | Rush | Kansas | 20165 | 806 | 18 |
2230259 | 2230259 | 2022-02-19 | Rush | Indiana | 18139 | 4852 | 54 |
2230464 | 2230464 | 2022-02-19 | Rush | Kansas | 20165 | 806 | 18 |
2227008 | 2227008 | 2022-02-18 | Rush | Indiana | 18139 | 4852 | 54 |
2227213 | 2227213 | 2022-02-18 | Rush | Kansas | 20165 | 806 | 18 |
2223757 | 2223757 | 2022-02-17 | Rush | Indiana | 18139 | 4846 | 52 |
2223962 | 2223962 | 2022-02-17 | Rush | Kansas | 20165 | 804 | 18 |
2220506 | 2220506 | 2022-02-16 | Rush | Indiana | 18139 | 4840 | 52 |
2220711 | 2220711 | 2022-02-16 | Rush | Kansas | 20165 | 804 | 18 |
2217255 | 2217255 | 2022-02-15 | Rush | Indiana | 18139 | 4837 | 51 |
2217460 | 2217460 | 2022-02-15 | Rush | Kansas | 20165 | 801 | 18 |
2214004 | 2214004 | 2022-02-14 | Rush | Indiana | 18139 | 4830 | 50 |
2214209 | 2214209 | 2022-02-14 | Rush | Kansas | 20165 | 801 | 18 |
2210752 | 2210752 | 2022-02-13 | Rush | Indiana | 18139 | 4815 | 50 |
2210957 | 2210957 | 2022-02-13 | Rush | Kansas | 20165 | 798 | 18 |
2207499 | 2207499 | 2022-02-12 | Rush | Indiana | 18139 | 4815 | 50 |
2207704 | 2207704 | 2022-02-12 | Rush | Kansas | 20165 | 798 | 18 |
2204246 | 2204246 | 2022-02-11 | Rush | Indiana | 18139 | 4815 | 50 |
2204451 | 2204451 | 2022-02-11 | Rush | Kansas | 20165 | 798 | 18 |
2200993 | 2200993 | 2022-02-10 | Rush | Indiana | 18139 | 4814 | 50 |
2201198 | 2201198 | 2022-02-10 | Rush | Kansas | 20165 | 798 | 18 |
2197739 | 2197739 | 2022-02-09 | Rush | Indiana | 18139 | 4781 | 50 |
2197944 | 2197944 | 2022-02-09 | Rush | Kansas | 20165 | 798 | 18 |
2194485 | 2194485 | 2022-02-08 | Rush | Indiana | 18139 | 4781 | 50 |
2194690 | 2194690 | 2022-02-08 | Rush | Kansas | 20165 | 796 | 17 |
2191231 | 2191231 | 2022-02-07 | Rush | Indiana | 18139 | 4768 | 49 |
2191436 | 2191436 | 2022-02-07 | Rush | Kansas | 20165 | 796 | 17 |
2187978 | 2187978 | 2022-02-06 | Rush | Indiana | 18139 | 4750 | 47 |
2188183 | 2188183 | 2022-02-06 | Rush | Kansas | 20165 | 786 | 17 |
2184725 | 2184725 | 2022-02-05 | Rush | Indiana | 18139 | 4750 | 47 |
2184930 | 2184930 | 2022-02-05 | Rush | Kansas | 20165 | 786 | 17 |
2181473 | 2181473 | 2022-02-04 | Rush | Indiana | 18139 | 4750 | 47 |
2181678 | 2181678 | 2022-02-04 | Rush | Kansas | 20165 | 786 | 17 |
2178222 | 2178222 | 2022-02-03 | Rush | Indiana | 18139 | 4717 | 46 |
2178427 | 2178427 | 2022-02-03 | Rush | Kansas | 20165 | 780 | 17 |
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);