ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
732 rows where county = "Ida", fips = 19093 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500419 | 2500419 | 2022-05-13 | Ida | Iowa | 19093 | 1831 | 49 |
2497161 | 2497161 | 2022-05-12 | Ida | Iowa | 19093 | 1831 | 49 |
2493903 | 2493903 | 2022-05-11 | Ida | Iowa | 19093 | 1831 | 49 |
2490645 | 2490645 | 2022-05-10 | Ida | Iowa | 19093 | 1826 | 49 |
2487388 | 2487388 | 2022-05-09 | Ida | Iowa | 19093 | 1826 | 49 |
2484130 | 2484130 | 2022-05-08 | Ida | Iowa | 19093 | 1826 | 49 |
2480872 | 2480872 | 2022-05-07 | Ida | Iowa | 19093 | 1826 | 49 |
2477614 | 2477614 | 2022-05-06 | Ida | Iowa | 19093 | 1826 | 49 |
2474356 | 2474356 | 2022-05-05 | Ida | Iowa | 19093 | 1826 | 49 |
2471099 | 2471099 | 2022-05-04 | Ida | Iowa | 19093 | 1826 | 49 |
2467843 | 2467843 | 2022-05-03 | Ida | Iowa | 19093 | 1829 | 49 |
2464588 | 2464588 | 2022-05-02 | Ida | Iowa | 19093 | 1829 | 49 |
2461332 | 2461332 | 2022-05-01 | Ida | Iowa | 19093 | 1829 | 49 |
2458076 | 2458076 | 2022-04-30 | Ida | Iowa | 19093 | 1829 | 49 |
2454820 | 2454820 | 2022-04-29 | Ida | Iowa | 19093 | 1829 | 49 |
2451564 | 2451564 | 2022-04-28 | Ida | Iowa | 19093 | 1829 | 49 |
2448308 | 2448308 | 2022-04-27 | Ida | Iowa | 19093 | 1829 | 49 |
2445052 | 2445052 | 2022-04-26 | Ida | Iowa | 19093 | 1821 | 49 |
2441796 | 2441796 | 2022-04-25 | Ida | Iowa | 19093 | 1821 | 49 |
2438540 | 2438540 | 2022-04-24 | Ida | Iowa | 19093 | 1821 | 49 |
2435284 | 2435284 | 2022-04-23 | Ida | Iowa | 19093 | 1821 | 49 |
2432028 | 2432028 | 2022-04-22 | Ida | Iowa | 19093 | 1821 | 49 |
2428772 | 2428772 | 2022-04-21 | Ida | Iowa | 19093 | 1821 | 49 |
2425516 | 2425516 | 2022-04-20 | Ida | Iowa | 19093 | 1821 | 49 |
2422260 | 2422260 | 2022-04-19 | Ida | Iowa | 19093 | 1810 | 49 |
2419004 | 2419004 | 2022-04-18 | Ida | Iowa | 19093 | 1810 | 49 |
2415748 | 2415748 | 2022-04-17 | Ida | Iowa | 19093 | 1810 | 49 |
2412492 | 2412492 | 2022-04-16 | Ida | Iowa | 19093 | 1810 | 49 |
2409236 | 2409236 | 2022-04-15 | Ida | Iowa | 19093 | 1810 | 49 |
2405980 | 2405980 | 2022-04-14 | Ida | Iowa | 19093 | 1810 | 49 |
2402724 | 2402724 | 2022-04-13 | Ida | Iowa | 19093 | 1810 | 49 |
2399470 | 2399470 | 2022-04-12 | Ida | Iowa | 19093 | 1803 | 49 |
2396214 | 2396214 | 2022-04-11 | Ida | Iowa | 19093 | 1803 | 49 |
2392959 | 2392959 | 2022-04-10 | Ida | Iowa | 19093 | 1803 | 49 |
2389703 | 2389703 | 2022-04-09 | Ida | Iowa | 19093 | 1803 | 49 |
2386447 | 2386447 | 2022-04-08 | Ida | Iowa | 19093 | 1803 | 49 |
2383193 | 2383193 | 2022-04-07 | Ida | Iowa | 19093 | 1803 | 49 |
2379938 | 2379938 | 2022-04-06 | Ida | Iowa | 19093 | 1803 | 49 |
2376683 | 2376683 | 2022-04-05 | Ida | Iowa | 19093 | 1800 | 48 |
2373431 | 2373431 | 2022-04-04 | Ida | Iowa | 19093 | 1800 | 48 |
2370178 | 2370178 | 2022-04-03 | Ida | Iowa | 19093 | 1800 | 48 |
2366925 | 2366925 | 2022-04-02 | Ida | Iowa | 19093 | 1800 | 48 |
2363672 | 2363672 | 2022-04-01 | Ida | Iowa | 19093 | 1800 | 48 |
2360418 | 2360418 | 2022-03-31 | Ida | Iowa | 19093 | 1800 | 48 |
2357164 | 2357164 | 2022-03-30 | Ida | Iowa | 19093 | 1800 | 48 |
2353911 | 2353911 | 2022-03-29 | Ida | Iowa | 19093 | 1799 | 48 |
2350659 | 2350659 | 2022-03-28 | Ida | Iowa | 19093 | 1799 | 48 |
2347406 | 2347406 | 2022-03-27 | Ida | Iowa | 19093 | 1799 | 48 |
2344153 | 2344153 | 2022-03-26 | Ida | Iowa | 19093 | 1799 | 48 |
2340900 | 2340900 | 2022-03-25 | Ida | Iowa | 19093 | 1799 | 48 |
2337647 | 2337647 | 2022-03-24 | Ida | Iowa | 19093 | 1799 | 48 |
2334393 | 2334393 | 2022-03-23 | Ida | Iowa | 19093 | 1799 | 48 |
2331139 | 2331139 | 2022-03-22 | Ida | Iowa | 19093 | 1798 | 48 |
2327887 | 2327887 | 2022-03-21 | Ida | Iowa | 19093 | 1798 | 48 |
2324634 | 2324634 | 2022-03-20 | Ida | Iowa | 19093 | 1798 | 48 |
2321380 | 2321380 | 2022-03-19 | Ida | Iowa | 19093 | 1798 | 48 |
2318126 | 2318126 | 2022-03-18 | Ida | Iowa | 19093 | 1798 | 48 |
2314873 | 2314873 | 2022-03-17 | Ida | Iowa | 19093 | 1798 | 48 |
2311620 | 2311620 | 2022-03-16 | Ida | Iowa | 19093 | 1798 | 48 |
2308367 | 2308367 | 2022-03-15 | Ida | Iowa | 19093 | 1796 | 48 |
2305116 | 2305116 | 2022-03-14 | Ida | Iowa | 19093 | 1796 | 48 |
2301864 | 2301864 | 2022-03-13 | Ida | Iowa | 19093 | 1796 | 48 |
2298612 | 2298612 | 2022-03-12 | Ida | Iowa | 19093 | 1796 | 48 |
2295360 | 2295360 | 2022-03-11 | Ida | Iowa | 19093 | 1796 | 48 |
2292108 | 2292108 | 2022-03-10 | Ida | Iowa | 19093 | 1796 | 48 |
2288856 | 2288856 | 2022-03-09 | Ida | Iowa | 19093 | 1796 | 48 |
2285605 | 2285605 | 2022-03-08 | Ida | Iowa | 19093 | 1797 | 47 |
2282353 | 2282353 | 2022-03-07 | Ida | Iowa | 19093 | 1797 | 47 |
2279100 | 2279100 | 2022-03-06 | Ida | Iowa | 19093 | 1797 | 47 |
2275847 | 2275847 | 2022-03-05 | Ida | Iowa | 19093 | 1797 | 47 |
2272594 | 2272594 | 2022-03-04 | Ida | Iowa | 19093 | 1797 | 47 |
2269342 | 2269342 | 2022-03-03 | Ida | Iowa | 19093 | 1797 | 47 |
2266089 | 2266089 | 2022-03-02 | Ida | Iowa | 19093 | 1797 | 47 |
2262838 | 2262838 | 2022-03-01 | Ida | Iowa | 19093 | 1792 | 47 |
2259587 | 2259587 | 2022-02-28 | Ida | Iowa | 19093 | 1792 | 47 |
2256336 | 2256336 | 2022-02-27 | Ida | Iowa | 19093 | 1792 | 47 |
2253085 | 2253085 | 2022-02-26 | Ida | Iowa | 19093 | 1792 | 47 |
2249834 | 2249834 | 2022-02-25 | Ida | Iowa | 19093 | 1792 | 47 |
2246583 | 2246583 | 2022-02-24 | Ida | Iowa | 19093 | 1792 | 47 |
2243332 | 2243332 | 2022-02-23 | Ida | Iowa | 19093 | 1792 | 47 |
2240081 | 2240081 | 2022-02-22 | Ida | Iowa | 19093 | 1785 | 47 |
2236830 | 2236830 | 2022-02-21 | Ida | Iowa | 19093 | 1785 | 47 |
2233579 | 2233579 | 2022-02-20 | Ida | Iowa | 19093 | 1785 | 47 |
2230328 | 2230328 | 2022-02-19 | Ida | Iowa | 19093 | 1785 | 47 |
2227077 | 2227077 | 2022-02-18 | Ida | Iowa | 19093 | 1785 | 47 |
2223826 | 2223826 | 2022-02-17 | Ida | Iowa | 19093 | 1785 | 47 |
2220575 | 2220575 | 2022-02-16 | Ida | Iowa | 19093 | 1785 | 47 |
2217324 | 2217324 | 2022-02-15 | Ida | Iowa | 19093 | 1770 | 47 |
2214073 | 2214073 | 2022-02-14 | Ida | Iowa | 19093 | 1770 | 47 |
2210821 | 2210821 | 2022-02-13 | Ida | Iowa | 19093 | 1770 | 47 |
2207568 | 2207568 | 2022-02-12 | Ida | Iowa | 19093 | 1770 | 47 |
2204315 | 2204315 | 2022-02-11 | Ida | Iowa | 19093 | 1770 | 47 |
2201062 | 2201062 | 2022-02-10 | Ida | Iowa | 19093 | 1770 | 47 |
2197808 | 2197808 | 2022-02-09 | Ida | Iowa | 19093 | 1770 | 47 |
2194554 | 2194554 | 2022-02-08 | Ida | Iowa | 19093 | 1751 | 47 |
2191300 | 2191300 | 2022-02-07 | Ida | Iowa | 19093 | 1751 | 47 |
2188047 | 2188047 | 2022-02-06 | Ida | Iowa | 19093 | 1751 | 47 |
2184794 | 2184794 | 2022-02-05 | Ida | Iowa | 19093 | 1751 | 47 |
2181542 | 2181542 | 2022-02-04 | Ida | Iowa | 19093 | 1751 | 47 |
2178291 | 2178291 | 2022-02-03 | Ida | Iowa | 19093 | 1751 | 47 |
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);