ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,556 rows where county = "Spencer" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337581 | 2337581 | 2022-03-24 | Spencer | Indiana | 18147 | 5219 | 60 |
2337913 | 2337913 | 2022-03-24 | Spencer | Kentucky | 21215 | 5307 | 53 |
2334327 | 2334327 | 2022-03-23 | Spencer | Indiana | 18147 | 5218 | 60 |
2334659 | 2334659 | 2022-03-23 | Spencer | Kentucky | 21215 | 5307 | 53 |
2331073 | 2331073 | 2022-03-22 | Spencer | Indiana | 18147 | 5218 | 60 |
2331405 | 2331405 | 2022-03-22 | Spencer | Kentucky | 21215 | 5307 | 53 |
2327821 | 2327821 | 2022-03-21 | Spencer | Indiana | 18147 | 5217 | 60 |
2328153 | 2328153 | 2022-03-21 | Spencer | Kentucky | 21215 | 5307 | 53 |
2324568 | 2324568 | 2022-03-20 | Spencer | Indiana | 18147 | 5215 | 60 |
2324900 | 2324900 | 2022-03-20 | Spencer | Kentucky | 21215 | 5289 | 51 |
2321314 | 2321314 | 2022-03-19 | Spencer | Indiana | 18147 | 5215 | 60 |
2321646 | 2321646 | 2022-03-19 | Spencer | Kentucky | 21215 | 5289 | 51 |
2318060 | 2318060 | 2022-03-18 | Spencer | Indiana | 18147 | 5215 | 60 |
2318392 | 2318392 | 2022-03-18 | Spencer | Kentucky | 21215 | 5289 | 51 |
2314807 | 2314807 | 2022-03-17 | Spencer | Indiana | 18147 | 5214 | 60 |
2315139 | 2315139 | 2022-03-17 | Spencer | Kentucky | 21215 | 5289 | 51 |
2311554 | 2311554 | 2022-03-16 | Spencer | Indiana | 18147 | 5213 | 60 |
2311886 | 2311886 | 2022-03-16 | Spencer | Kentucky | 21215 | 5289 | 51 |
2308301 | 2308301 | 2022-03-15 | Spencer | Indiana | 18147 | 5213 | 60 |
2308633 | 2308633 | 2022-03-15 | Spencer | Kentucky | 21215 | 5289 | 51 |
2305050 | 2305050 | 2022-03-14 | Spencer | Indiana | 18147 | 5213 | 60 |
2305382 | 2305382 | 2022-03-14 | Spencer | Kentucky | 21215 | 5289 | 51 |
2301798 | 2301798 | 2022-03-13 | Spencer | Indiana | 18147 | 5213 | 60 |
2302130 | 2302130 | 2022-03-13 | Spencer | Kentucky | 21215 | 5264 | 50 |
2298546 | 2298546 | 2022-03-12 | Spencer | Indiana | 18147 | 5213 | 60 |
2298878 | 2298878 | 2022-03-12 | Spencer | Kentucky | 21215 | 5264 | 50 |
2295294 | 2295294 | 2022-03-11 | Spencer | Indiana | 18147 | 5213 | 60 |
2295626 | 2295626 | 2022-03-11 | Spencer | Kentucky | 21215 | 5264 | 50 |
2292042 | 2292042 | 2022-03-10 | Spencer | Indiana | 18147 | 5213 | 60 |
2292374 | 2292374 | 2022-03-10 | Spencer | Kentucky | 21215 | 5264 | 50 |
2288790 | 2288790 | 2022-03-09 | Spencer | Indiana | 18147 | 5213 | 60 |
2289122 | 2289122 | 2022-03-09 | Spencer | Kentucky | 21215 | 5264 | 50 |
2285539 | 2285539 | 2022-03-08 | Spencer | Indiana | 18147 | 5212 | 60 |
2285871 | 2285871 | 2022-03-08 | Spencer | Kentucky | 21215 | 5264 | 50 |
2282287 | 2282287 | 2022-03-07 | Spencer | Indiana | 18147 | 5209 | 60 |
2282619 | 2282619 | 2022-03-07 | Spencer | Kentucky | 21215 | 5264 | 50 |
2279034 | 2279034 | 2022-03-06 | Spencer | Indiana | 18147 | 5211 | 60 |
2279366 | 2279366 | 2022-03-06 | Spencer | Kentucky | 21215 | 5261 | 50 |
2275781 | 2275781 | 2022-03-05 | Spencer | Indiana | 18147 | 5211 | 60 |
2276113 | 2276113 | 2022-03-05 | Spencer | Kentucky | 21215 | 5261 | 50 |
2272528 | 2272528 | 2022-03-04 | Spencer | Indiana | 18147 | 5211 | 60 |
2272860 | 2272860 | 2022-03-04 | Spencer | Kentucky | 21215 | 5261 | 50 |
2269276 | 2269276 | 2022-03-03 | Spencer | Indiana | 18147 | 5210 | 59 |
2269608 | 2269608 | 2022-03-03 | Spencer | Kentucky | 21215 | 5256 | 50 |
2266023 | 2266023 | 2022-03-02 | Spencer | Indiana | 18147 | 5207 | 59 |
2266355 | 2266355 | 2022-03-02 | Spencer | Kentucky | 21215 | 5250 | 50 |
2262772 | 2262772 | 2022-03-01 | Spencer | Indiana | 18147 | 5201 | 59 |
2263104 | 2263104 | 2022-03-01 | Spencer | Kentucky | 21215 | 5245 | 50 |
2259521 | 2259521 | 2022-02-28 | Spencer | Indiana | 18147 | 5196 | 58 |
2259853 | 2259853 | 2022-02-28 | Spencer | Kentucky | 21215 | 5242 | 50 |
2256270 | 2256270 | 2022-02-27 | Spencer | Indiana | 18147 | 5192 | 58 |
2256602 | 2256602 | 2022-02-27 | Spencer | Kentucky | 21215 | 5226 | 50 |
2253019 | 2253019 | 2022-02-26 | Spencer | Indiana | 18147 | 5192 | 58 |
2253351 | 2253351 | 2022-02-26 | Spencer | Kentucky | 21215 | 5226 | 50 |
2249768 | 2249768 | 2022-02-25 | Spencer | Indiana | 18147 | 5192 | 58 |
2250100 | 2250100 | 2022-02-25 | Spencer | Kentucky | 21215 | 5226 | 50 |
2246517 | 2246517 | 2022-02-24 | Spencer | Indiana | 18147 | 5189 | 58 |
2246849 | 2246849 | 2022-02-24 | Spencer | Kentucky | 21215 | 5222 | 50 |
2243266 | 2243266 | 2022-02-23 | Spencer | Indiana | 18147 | 5184 | 58 |
2243598 | 2243598 | 2022-02-23 | Spencer | Kentucky | 21215 | 5222 | 50 |
2240015 | 2240015 | 2022-02-22 | Spencer | Indiana | 18147 | 5178 | 58 |
2240347 | 2240347 | 2022-02-22 | Spencer | Kentucky | 21215 | 5216 | 49 |
2236764 | 2236764 | 2022-02-21 | Spencer | Indiana | 18147 | 5176 | 58 |
2237096 | 2237096 | 2022-02-21 | Spencer | Kentucky | 21215 | 5210 | 49 |
2233513 | 2233513 | 2022-02-20 | Spencer | Indiana | 18147 | 5166 | 58 |
2233845 | 2233845 | 2022-02-20 | Spencer | Kentucky | 21215 | 5191 | 49 |
2230262 | 2230262 | 2022-02-19 | Spencer | Indiana | 18147 | 5166 | 58 |
2230594 | 2230594 | 2022-02-19 | Spencer | Kentucky | 21215 | 5191 | 49 |
2227011 | 2227011 | 2022-02-18 | Spencer | Indiana | 18147 | 5166 | 58 |
2227343 | 2227343 | 2022-02-18 | Spencer | Kentucky | 21215 | 5191 | 49 |
2223760 | 2223760 | 2022-02-17 | Spencer | Indiana | 18147 | 5165 | 58 |
2224092 | 2224092 | 2022-02-17 | Spencer | Kentucky | 21215 | 5179 | 48 |
2220509 | 2220509 | 2022-02-16 | Spencer | Indiana | 18147 | 5157 | 58 |
2220841 | 2220841 | 2022-02-16 | Spencer | Kentucky | 21215 | 5171 | 48 |
2217258 | 2217258 | 2022-02-15 | Spencer | Indiana | 18147 | 5153 | 58 |
2217590 | 2217590 | 2022-02-15 | Spencer | Kentucky | 21215 | 5159 | 48 |
2214007 | 2214007 | 2022-02-14 | Spencer | Indiana | 18147 | 5146 | 58 |
2214339 | 2214339 | 2022-02-14 | Spencer | Kentucky | 21215 | 5152 | 48 |
2210755 | 2210755 | 2022-02-13 | Spencer | Indiana | 18147 | 5118 | 58 |
2211087 | 2211087 | 2022-02-13 | Spencer | Kentucky | 21215 | 5096 | 48 |
2207502 | 2207502 | 2022-02-12 | Spencer | Indiana | 18147 | 5118 | 58 |
2207834 | 2207834 | 2022-02-12 | Spencer | Kentucky | 21215 | 5096 | 48 |
2204249 | 2204249 | 2022-02-11 | Spencer | Indiana | 18147 | 5118 | 58 |
2204581 | 2204581 | 2022-02-11 | Spencer | Kentucky | 21215 | 5096 | 48 |
2200996 | 2200996 | 2022-02-10 | Spencer | Indiana | 18147 | 5104 | 58 |
2201328 | 2201328 | 2022-02-10 | Spencer | Kentucky | 21215 | 5086 | 48 |
2197742 | 2197742 | 2022-02-09 | Spencer | Indiana | 18147 | 5079 | 58 |
2198074 | 2198074 | 2022-02-09 | Spencer | Kentucky | 21215 | 5069 | 48 |
2194488 | 2194488 | 2022-02-08 | Spencer | Indiana | 18147 | 5079 | 58 |
2194820 | 2194820 | 2022-02-08 | Spencer | Kentucky | 21215 | 5050 | 48 |
2191234 | 2191234 | 2022-02-07 | Spencer | Indiana | 18147 | 5072 | 58 |
2191566 | 2191566 | 2022-02-07 | Spencer | Kentucky | 21215 | 5035 | 48 |
2187981 | 2187981 | 2022-02-06 | Spencer | Indiana | 18147 | 5051 | 58 |
2188313 | 2188313 | 2022-02-06 | Spencer | Kentucky | 21215 | 5003 | 48 |
2184728 | 2184728 | 2022-02-05 | Spencer | Indiana | 18147 | 5051 | 58 |
2185060 | 2185060 | 2022-02-05 | Spencer | Kentucky | 21215 | 5003 | 48 |
2181476 | 2181476 | 2022-02-04 | Spencer | Indiana | 18147 | 5051 | 58 |
2181808 | 2181808 | 2022-02-04 | Spencer | Kentucky | 21215 | 5003 | 48 |
2178225 | 2178225 | 2022-02-03 | Spencer | Indiana | 18147 | 5022 | 58 |
2178557 | 2178557 | 2022-02-03 | Spencer | Kentucky | 21215 | 4989 | 48 |
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);