ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Rush" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500349 | 2500349 | 2022-05-13 | Rush | Indiana | 18139 | 4866 | 58 |
2497091 | 2497091 | 2022-05-12 | Rush | Indiana | 18139 | 4857 | 58 |
2493833 | 2493833 | 2022-05-11 | Rush | Indiana | 18139 | 4857 | 58 |
2490575 | 2490575 | 2022-05-10 | Rush | Indiana | 18139 | 4854 | 58 |
2487318 | 2487318 | 2022-05-09 | Rush | Indiana | 18139 | 4854 | 58 |
2484060 | 2484060 | 2022-05-08 | Rush | Indiana | 18139 | 4849 | 58 |
2480802 | 2480802 | 2022-05-07 | Rush | Indiana | 18139 | 4849 | 58 |
2477544 | 2477544 | 2022-05-06 | Rush | Indiana | 18139 | 4849 | 58 |
2474286 | 2474286 | 2022-05-05 | Rush | Indiana | 18139 | 4849 | 58 |
2471029 | 2471029 | 2022-05-04 | Rush | Indiana | 18139 | 4849 | 58 |
2467773 | 2467773 | 2022-05-03 | Rush | Indiana | 18139 | 4847 | 58 |
2464518 | 2464518 | 2022-05-02 | Rush | Indiana | 18139 | 4847 | 58 |
2461262 | 2461262 | 2022-05-01 | Rush | Indiana | 18139 | 4845 | 58 |
2458006 | 2458006 | 2022-04-30 | Rush | Indiana | 18139 | 4845 | 58 |
2454750 | 2454750 | 2022-04-29 | Rush | Indiana | 18139 | 4845 | 58 |
2451494 | 2451494 | 2022-04-28 | Rush | Indiana | 18139 | 4845 | 58 |
2448238 | 2448238 | 2022-04-27 | Rush | Indiana | 18139 | 4845 | 58 |
2444982 | 2444982 | 2022-04-26 | Rush | Indiana | 18139 | 4844 | 58 |
2441726 | 2441726 | 2022-04-25 | Rush | Indiana | 18139 | 4844 | 58 |
2438470 | 2438470 | 2022-04-24 | Rush | Indiana | 18139 | 4840 | 58 |
2435214 | 2435214 | 2022-04-23 | Rush | Indiana | 18139 | 4840 | 58 |
2431958 | 2431958 | 2022-04-22 | Rush | Indiana | 18139 | 4840 | 58 |
2428702 | 2428702 | 2022-04-21 | Rush | Indiana | 18139 | 4842 | 58 |
2425446 | 2425446 | 2022-04-20 | Rush | Indiana | 18139 | 4842 | 58 |
2422190 | 2422190 | 2022-04-19 | Rush | Indiana | 18139 | 4840 | 58 |
2418934 | 2418934 | 2022-04-18 | Rush | Indiana | 18139 | 4840 | 58 |
2415678 | 2415678 | 2022-04-17 | Rush | Indiana | 18139 | 4835 | 58 |
2412422 | 2412422 | 2022-04-16 | Rush | Indiana | 18139 | 4835 | 58 |
2409166 | 2409166 | 2022-04-15 | Rush | Indiana | 18139 | 4835 | 58 |
2405910 | 2405910 | 2022-04-14 | Rush | Indiana | 18139 | 4835 | 58 |
2402655 | 2402655 | 2022-04-13 | Rush | Indiana | 18139 | 4835 | 58 |
2399400 | 2399400 | 2022-04-12 | Rush | Indiana | 18139 | 4835 | 58 |
2396145 | 2396145 | 2022-04-11 | Rush | Indiana | 18139 | 4835 | 58 |
2392889 | 2392889 | 2022-04-10 | Rush | Indiana | 18139 | 4835 | 58 |
2389633 | 2389633 | 2022-04-09 | Rush | Indiana | 18139 | 4835 | 58 |
2386378 | 2386378 | 2022-04-08 | Rush | Indiana | 18139 | 4835 | 58 |
2383123 | 2383123 | 2022-04-07 | Rush | Indiana | 18139 | 4835 | 58 |
2379868 | 2379868 | 2022-04-06 | Rush | Indiana | 18139 | 4835 | 58 |
2376614 | 2376614 | 2022-04-05 | Rush | Indiana | 18139 | 4835 | 58 |
2373362 | 2373362 | 2022-04-04 | Rush | Indiana | 18139 | 4835 | 58 |
2370109 | 2370109 | 2022-04-03 | Rush | Indiana | 18139 | 4835 | 58 |
2366856 | 2366856 | 2022-04-02 | Rush | Indiana | 18139 | 4835 | 58 |
2363603 | 2363603 | 2022-04-01 | Rush | Indiana | 18139 | 4835 | 58 |
2360349 | 2360349 | 2022-03-31 | Rush | Indiana | 18139 | 4834 | 58 |
2357095 | 2357095 | 2022-03-30 | Rush | Indiana | 18139 | 4834 | 58 |
2353842 | 2353842 | 2022-03-29 | Rush | Indiana | 18139 | 4906 | 58 |
2350590 | 2350590 | 2022-03-28 | Rush | Indiana | 18139 | 4906 | 58 |
2347337 | 2347337 | 2022-03-27 | Rush | Indiana | 18139 | 4906 | 58 |
2344084 | 2344084 | 2022-03-26 | Rush | Indiana | 18139 | 4906 | 58 |
2340831 | 2340831 | 2022-03-25 | Rush | Indiana | 18139 | 4906 | 58 |
2337578 | 2337578 | 2022-03-24 | Rush | Indiana | 18139 | 4906 | 58 |
2334324 | 2334324 | 2022-03-23 | Rush | Indiana | 18139 | 4906 | 58 |
2331070 | 2331070 | 2022-03-22 | Rush | Indiana | 18139 | 4905 | 58 |
2327818 | 2327818 | 2022-03-21 | Rush | Indiana | 18139 | 4907 | 58 |
2324565 | 2324565 | 2022-03-20 | Rush | Indiana | 18139 | 4903 | 58 |
2321311 | 2321311 | 2022-03-19 | Rush | Indiana | 18139 | 4903 | 58 |
2318057 | 2318057 | 2022-03-18 | Rush | Indiana | 18139 | 4903 | 58 |
2314804 | 2314804 | 2022-03-17 | Rush | Indiana | 18139 | 4902 | 58 |
2311551 | 2311551 | 2022-03-16 | Rush | Indiana | 18139 | 4900 | 58 |
2308298 | 2308298 | 2022-03-15 | Rush | Indiana | 18139 | 4900 | 59 |
2305047 | 2305047 | 2022-03-14 | Rush | Indiana | 18139 | 4899 | 59 |
2301795 | 2301795 | 2022-03-13 | Rush | Indiana | 18139 | 4898 | 59 |
2298543 | 2298543 | 2022-03-12 | Rush | Indiana | 18139 | 4898 | 59 |
2295291 | 2295291 | 2022-03-11 | Rush | Indiana | 18139 | 4898 | 59 |
2292039 | 2292039 | 2022-03-10 | Rush | Indiana | 18139 | 4898 | 58 |
2288787 | 2288787 | 2022-03-09 | Rush | Indiana | 18139 | 4897 | 58 |
2285536 | 2285536 | 2022-03-08 | Rush | Indiana | 18139 | 4896 | 58 |
2282284 | 2282284 | 2022-03-07 | Rush | Indiana | 18139 | 4897 | 58 |
2279031 | 2279031 | 2022-03-06 | Rush | Indiana | 18139 | 4894 | 57 |
2275778 | 2275778 | 2022-03-05 | Rush | Indiana | 18139 | 4894 | 57 |
2272525 | 2272525 | 2022-03-04 | Rush | Indiana | 18139 | 4894 | 57 |
2269273 | 2269273 | 2022-03-03 | Rush | Indiana | 18139 | 4891 | 56 |
2266020 | 2266020 | 2022-03-02 | Rush | Indiana | 18139 | 4887 | 56 |
2262769 | 2262769 | 2022-03-01 | Rush | Indiana | 18139 | 4886 | 56 |
2259518 | 2259518 | 2022-02-28 | Rush | Indiana | 18139 | 4885 | 56 |
2256267 | 2256267 | 2022-02-27 | Rush | Indiana | 18139 | 4872 | 56 |
2253016 | 2253016 | 2022-02-26 | Rush | Indiana | 18139 | 4872 | 56 |
2249765 | 2249765 | 2022-02-25 | Rush | Indiana | 18139 | 4872 | 56 |
2246514 | 2246514 | 2022-02-24 | Rush | Indiana | 18139 | 4871 | 55 |
2243263 | 2243263 | 2022-02-23 | Rush | Indiana | 18139 | 4870 | 55 |
2240012 | 2240012 | 2022-02-22 | Rush | Indiana | 18139 | 4864 | 55 |
2236761 | 2236761 | 2022-02-21 | Rush | Indiana | 18139 | 4858 | 55 |
2233510 | 2233510 | 2022-02-20 | Rush | Indiana | 18139 | 4852 | 54 |
2230259 | 2230259 | 2022-02-19 | Rush | Indiana | 18139 | 4852 | 54 |
2227008 | 2227008 | 2022-02-18 | Rush | Indiana | 18139 | 4852 | 54 |
2223757 | 2223757 | 2022-02-17 | Rush | Indiana | 18139 | 4846 | 52 |
2220506 | 2220506 | 2022-02-16 | Rush | Indiana | 18139 | 4840 | 52 |
2217255 | 2217255 | 2022-02-15 | Rush | Indiana | 18139 | 4837 | 51 |
2214004 | 2214004 | 2022-02-14 | Rush | Indiana | 18139 | 4830 | 50 |
2210752 | 2210752 | 2022-02-13 | Rush | Indiana | 18139 | 4815 | 50 |
2207499 | 2207499 | 2022-02-12 | Rush | Indiana | 18139 | 4815 | 50 |
2204246 | 2204246 | 2022-02-11 | Rush | Indiana | 18139 | 4815 | 50 |
2200993 | 2200993 | 2022-02-10 | Rush | Indiana | 18139 | 4814 | 50 |
2197739 | 2197739 | 2022-02-09 | Rush | Indiana | 18139 | 4781 | 50 |
2194485 | 2194485 | 2022-02-08 | Rush | Indiana | 18139 | 4781 | 50 |
2191231 | 2191231 | 2022-02-07 | Rush | Indiana | 18139 | 4768 | 49 |
2187978 | 2187978 | 2022-02-06 | Rush | Indiana | 18139 | 4750 | 47 |
2184725 | 2184725 | 2022-02-05 | Rush | Indiana | 18139 | 4750 | 47 |
2181473 | 2181473 | 2022-02-04 | Rush | Indiana | 18139 | 4750 | 47 |
2178222 | 2178222 | 2022-02-03 | Rush | Indiana | 18139 | 4717 | 46 |
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);