ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Elmore" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2336829 | 2336829 | 2022-03-24 | Elmore | Alabama | 1051 | 22963 | 340 |
2337381 | 2337381 | 2022-03-24 | Elmore | Idaho | 16039 | 7160 | 70 |
2333575 | 2333575 | 2022-03-23 | Elmore | Alabama | 1051 | 22953 | 340 |
2334127 | 2334127 | 2022-03-23 | Elmore | Idaho | 16039 | 7158 | 70 |
2330321 | 2330321 | 2022-03-22 | Elmore | Alabama | 1051 | 22951 | 340 |
2330873 | 2330873 | 2022-03-22 | Elmore | Idaho | 16039 | 7159 | 70 |
2327069 | 2327069 | 2022-03-21 | Elmore | Alabama | 1051 | 22947 | 339 |
2327621 | 2327621 | 2022-03-21 | Elmore | Idaho | 16039 | 7157 | 70 |
2323816 | 2323816 | 2022-03-20 | Elmore | Alabama | 1051 | 22939 | 337 |
2324368 | 2324368 | 2022-03-20 | Elmore | Idaho | 16039 | 7143 | 70 |
2320562 | 2320562 | 2022-03-19 | Elmore | Alabama | 1051 | 22939 | 337 |
2321114 | 2321114 | 2022-03-19 | Elmore | Idaho | 16039 | 7143 | 70 |
2317308 | 2317308 | 2022-03-18 | Elmore | Alabama | 1051 | 22939 | 337 |
2317860 | 2317860 | 2022-03-18 | Elmore | Idaho | 16039 | 7143 | 70 |
2314055 | 2314055 | 2022-03-17 | Elmore | Alabama | 1051 | 22936 | 337 |
2314607 | 2314607 | 2022-03-17 | Elmore | Idaho | 16039 | 7140 | 70 |
2310802 | 2310802 | 2022-03-16 | Elmore | Alabama | 1051 | 22934 | 335 |
2311354 | 2311354 | 2022-03-16 | Elmore | Idaho | 16039 | 7140 | 70 |
2307549 | 2307549 | 2022-03-15 | Elmore | Alabama | 1051 | 22931 | 335 |
2308101 | 2308101 | 2022-03-15 | Elmore | Idaho | 16039 | 7133 | 70 |
2304298 | 2304298 | 2022-03-14 | Elmore | Alabama | 1051 | 22930 | 335 |
2304850 | 2304850 | 2022-03-14 | Elmore | Idaho | 16039 | 7126 | 70 |
2301046 | 2301046 | 2022-03-13 | Elmore | Alabama | 1051 | 22929 | 336 |
2301598 | 2301598 | 2022-03-13 | Elmore | Idaho | 16039 | 7061 | 70 |
2297794 | 2297794 | 2022-03-12 | Elmore | Alabama | 1051 | 22929 | 336 |
2298346 | 2298346 | 2022-03-12 | Elmore | Idaho | 16039 | 7061 | 70 |
2294542 | 2294542 | 2022-03-11 | Elmore | Alabama | 1051 | 22929 | 336 |
2295094 | 2295094 | 2022-03-11 | Elmore | Idaho | 16039 | 7061 | 70 |
2291290 | 2291290 | 2022-03-10 | Elmore | Alabama | 1051 | 22926 | 335 |
2291842 | 2291842 | 2022-03-10 | Elmore | Idaho | 16039 | 6978 | 69 |
2288038 | 2288038 | 2022-03-09 | Elmore | Alabama | 1051 | 22920 | 335 |
2288590 | 2288590 | 2022-03-09 | Elmore | Idaho | 16039 | 6945 | 69 |
2284786 | 2284786 | 2022-03-08 | Elmore | Alabama | 1051 | 22912 | 334 |
2285339 | 2285339 | 2022-03-08 | Elmore | Idaho | 16039 | 6927 | 69 |
2281534 | 2281534 | 2022-03-07 | Elmore | Alabama | 1051 | 22907 | 332 |
2282087 | 2282087 | 2022-03-07 | Elmore | Idaho | 16039 | 6889 | 69 |
2278281 | 2278281 | 2022-03-06 | Elmore | Alabama | 1051 | 22898 | 330 |
2278834 | 2278834 | 2022-03-06 | Elmore | Idaho | 16039 | 6837 | 69 |
2275028 | 2275028 | 2022-03-05 | Elmore | Alabama | 1051 | 22898 | 330 |
2275581 | 2275581 | 2022-03-05 | Elmore | Idaho | 16039 | 6837 | 69 |
2271775 | 2271775 | 2022-03-04 | Elmore | Alabama | 1051 | 22898 | 330 |
2272328 | 2272328 | 2022-03-04 | Elmore | Idaho | 16039 | 6837 | 69 |
2268523 | 2268523 | 2022-03-03 | Elmore | Alabama | 1051 | 22889 | 330 |
2269076 | 2269076 | 2022-03-03 | Elmore | Idaho | 16039 | 6812 | 67 |
2265270 | 2265270 | 2022-03-02 | Elmore | Alabama | 1051 | 22881 | 329 |
2265823 | 2265823 | 2022-03-02 | Elmore | Idaho | 16039 | 6789 | 67 |
2262020 | 2262020 | 2022-03-01 | Elmore | Alabama | 1051 | 22872 | 327 |
2262572 | 2262572 | 2022-03-01 | Elmore | Idaho | 16039 | 6773 | 66 |
2258769 | 2258769 | 2022-02-28 | Elmore | Alabama | 1051 | 22862 | 327 |
2259321 | 2259321 | 2022-02-28 | Elmore | Idaho | 16039 | 6734 | 65 |
2255518 | 2255518 | 2022-02-27 | Elmore | Alabama | 1051 | 22855 | 327 |
2256070 | 2256070 | 2022-02-27 | Elmore | Idaho | 16039 | 6660 | 64 |
2252267 | 2252267 | 2022-02-26 | Elmore | Alabama | 1051 | 22848 | 327 |
2252819 | 2252819 | 2022-02-26 | Elmore | Idaho | 16039 | 6660 | 64 |
2249016 | 2249016 | 2022-02-25 | Elmore | Alabama | 1051 | 22834 | 325 |
2249568 | 2249568 | 2022-02-25 | Elmore | Idaho | 16039 | 6660 | 64 |
2245765 | 2245765 | 2022-02-24 | Elmore | Alabama | 1051 | 22824 | 325 |
2246317 | 2246317 | 2022-02-24 | Elmore | Idaho | 16039 | 6598 | 63 |
2242514 | 2242514 | 2022-02-23 | Elmore | Alabama | 1051 | 22819 | 324 |
2243066 | 2243066 | 2022-02-23 | Elmore | Idaho | 16039 | 6494 | 63 |
2239263 | 2239263 | 2022-02-22 | Elmore | Alabama | 1051 | 22804 | 324 |
2239815 | 2239815 | 2022-02-22 | Elmore | Idaho | 16039 | 6396 | 63 |
2236012 | 2236012 | 2022-02-21 | Elmore | Alabama | 1051 | 22785 | 324 |
2236564 | 2236564 | 2022-02-21 | Elmore | Idaho | 16039 | 6320 | 63 |
2232761 | 2232761 | 2022-02-20 | Elmore | Alabama | 1051 | 22777 | 324 |
2233313 | 2233313 | 2022-02-20 | Elmore | Idaho | 16039 | 6320 | 63 |
2229510 | 2229510 | 2022-02-19 | Elmore | Alabama | 1051 | 22777 | 324 |
2230062 | 2230062 | 2022-02-19 | Elmore | Idaho | 16039 | 6320 | 63 |
2226259 | 2226259 | 2022-02-18 | Elmore | Alabama | 1051 | 22760 | 324 |
2226811 | 2226811 | 2022-02-18 | Elmore | Idaho | 16039 | 6261 | 63 |
2223008 | 2223008 | 2022-02-17 | Elmore | Alabama | 1051 | 22754 | 320 |
2223560 | 2223560 | 2022-02-17 | Elmore | Idaho | 16039 | 6192 | 62 |
2219757 | 2219757 | 2022-02-16 | Elmore | Alabama | 1051 | 22736 | 320 |
2220309 | 2220309 | 2022-02-16 | Elmore | Idaho | 16039 | 6122 | 61 |
2216507 | 2216507 | 2022-02-15 | Elmore | Alabama | 1051 | 22732 | 319 |
2217058 | 2217058 | 2022-02-15 | Elmore | Idaho | 16039 | 6047 | 61 |
2213256 | 2213256 | 2022-02-14 | Elmore | Alabama | 1051 | 22713 | 317 |
2213807 | 2213807 | 2022-02-14 | Elmore | Idaho | 16039 | 5979 | 61 |
2210003 | 2210003 | 2022-02-13 | Elmore | Alabama | 1051 | 22693 | 317 |
2210555 | 2210555 | 2022-02-13 | Elmore | Idaho | 16039 | 5940 | 58 |
2206750 | 2206750 | 2022-02-12 | Elmore | Alabama | 1051 | 22688 | 317 |
2207302 | 2207302 | 2022-02-12 | Elmore | Idaho | 16039 | 5940 | 58 |
2203497 | 2203497 | 2022-02-11 | Elmore | Alabama | 1051 | 22646 | 315 |
2204049 | 2204049 | 2022-02-11 | Elmore | Idaho | 16039 | 5898 | 58 |
2200243 | 2200243 | 2022-02-10 | Elmore | Alabama | 1051 | 22625 | 315 |
2200796 | 2200796 | 2022-02-10 | Elmore | Idaho | 16039 | 5867 | 58 |
2196989 | 2196989 | 2022-02-09 | Elmore | Alabama | 1051 | 22591 | 315 |
2197542 | 2197542 | 2022-02-09 | Elmore | Idaho | 16039 | 5785 | 58 |
2193734 | 2193734 | 2022-02-08 | Elmore | Alabama | 1051 | 22547 | 314 |
2194288 | 2194288 | 2022-02-08 | Elmore | Idaho | 16039 | 5697 | 58 |
2190481 | 2190481 | 2022-02-07 | Elmore | Alabama | 1051 | 22491 | 314 |
2191034 | 2191034 | 2022-02-07 | Elmore | Idaho | 16039 | 5643 | 58 |
2187228 | 2187228 | 2022-02-06 | Elmore | Alabama | 1051 | 22450 | 314 |
2187781 | 2187781 | 2022-02-06 | Elmore | Idaho | 16039 | 5602 | 58 |
2183975 | 2183975 | 2022-02-05 | Elmore | Alabama | 1051 | 22450 | 314 |
2184528 | 2184528 | 2022-02-05 | Elmore | Idaho | 16039 | 5602 | 58 |
2180723 | 2180723 | 2022-02-04 | Elmore | Alabama | 1051 | 22428 | 314 |
2181276 | 2181276 | 2022-02-04 | Elmore | Idaho | 16039 | 5560 | 58 |
2177472 | 2177472 | 2022-02-03 | Elmore | Alabama | 1051 | 22220 | 311 |
2178025 | 2178025 | 2022-02-03 | Elmore | Idaho | 16039 | 5475 | 58 |
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);