ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Otero" and fips = 8089 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 |
---|---|---|---|---|---|---|---|
2499865 | 2499865 | 2022-05-13 | Otero | Colorado | 8089 | 4322 | 130 |
2496607 | 2496607 | 2022-05-12 | Otero | Colorado | 8089 | 4319 | 130 |
2493349 | 2493349 | 2022-05-11 | Otero | Colorado | 8089 | 4309 | 130 |
2490091 | 2490091 | 2022-05-10 | Otero | Colorado | 8089 | 4309 | 130 |
2486834 | 2486834 | 2022-05-09 | Otero | Colorado | 8089 | 4309 | 130 |
2483576 | 2483576 | 2022-05-08 | Otero | Colorado | 8089 | 4308 | 130 |
2480318 | 2480318 | 2022-05-07 | Otero | Colorado | 8089 | 4308 | 130 |
2477060 | 2477060 | 2022-05-06 | Otero | Colorado | 8089 | 4308 | 130 |
2473802 | 2473802 | 2022-05-05 | Otero | Colorado | 8089 | 4303 | 130 |
2470545 | 2470545 | 2022-05-04 | Otero | Colorado | 8089 | 4302 | 130 |
2467289 | 2467289 | 2022-05-03 | Otero | Colorado | 8089 | 4299 | 130 |
2464034 | 2464034 | 2022-05-02 | Otero | Colorado | 8089 | 4299 | 127 |
2460778 | 2460778 | 2022-05-01 | Otero | Colorado | 8089 | 4299 | 127 |
2457522 | 2457522 | 2022-04-30 | Otero | Colorado | 8089 | 4299 | 127 |
2454266 | 2454266 | 2022-04-29 | Otero | Colorado | 8089 | 4299 | 127 |
2451010 | 2451010 | 2022-04-28 | Otero | Colorado | 8089 | 4298 | 127 |
2447754 | 2447754 | 2022-04-27 | Otero | Colorado | 8089 | 4298 | 127 |
2444498 | 2444498 | 2022-04-26 | Otero | Colorado | 8089 | 4296 | 127 |
2441242 | 2441242 | 2022-04-25 | Otero | Colorado | 8089 | 4295 | 127 |
2437986 | 2437986 | 2022-04-24 | Otero | Colorado | 8089 | 4295 | 127 |
2434730 | 2434730 | 2022-04-23 | Otero | Colorado | 8089 | 4295 | 127 |
2431474 | 2431474 | 2022-04-22 | Otero | Colorado | 8089 | 4295 | 127 |
2428218 | 2428218 | 2022-04-21 | Otero | Colorado | 8089 | 4292 | 127 |
2424962 | 2424962 | 2022-04-20 | Otero | Colorado | 8089 | 4290 | 127 |
2421706 | 2421706 | 2022-04-19 | Otero | Colorado | 8089 | 4289 | 127 |
2418450 | 2418450 | 2022-04-18 | Otero | Colorado | 8089 | 4283 | 127 |
2415194 | 2415194 | 2022-04-17 | Otero | Colorado | 8089 | 4284 | 126 |
2411938 | 2411938 | 2022-04-16 | Otero | Colorado | 8089 | 4284 | 126 |
2408682 | 2408682 | 2022-04-15 | Otero | Colorado | 8089 | 4284 | 126 |
2405426 | 2405426 | 2022-04-14 | Otero | Colorado | 8089 | 4282 | 126 |
2402171 | 2402171 | 2022-04-13 | Otero | Colorado | 8089 | 4279 | 126 |
2398916 | 2398916 | 2022-04-12 | Otero | Colorado | 8089 | 4275 | 126 |
2395661 | 2395661 | 2022-04-11 | Otero | Colorado | 8089 | 4275 | 126 |
2392405 | 2392405 | 2022-04-10 | Otero | Colorado | 8089 | 4274 | 126 |
2389149 | 2389149 | 2022-04-09 | Otero | Colorado | 8089 | 4274 | 126 |
2385894 | 2385894 | 2022-04-08 | Otero | Colorado | 8089 | 4274 | 126 |
2382639 | 2382639 | 2022-04-07 | Otero | Colorado | 8089 | 4272 | 126 |
2379384 | 2379384 | 2022-04-06 | Otero | Colorado | 8089 | 4269 | 126 |
2376130 | 2376130 | 2022-04-05 | Otero | Colorado | 8089 | 4270 | 126 |
2372878 | 2372878 | 2022-04-04 | Otero | Colorado | 8089 | 4270 | 126 |
2369625 | 2369625 | 2022-04-03 | Otero | Colorado | 8089 | 4267 | 126 |
2366372 | 2366372 | 2022-04-02 | Otero | Colorado | 8089 | 4267 | 126 |
2363119 | 2363119 | 2022-04-01 | Otero | Colorado | 8089 | 4267 | 126 |
2359865 | 2359865 | 2022-03-31 | Otero | Colorado | 8089 | 4263 | 126 |
2356611 | 2356611 | 2022-03-30 | Otero | Colorado | 8089 | 4256 | 126 |
2353358 | 2353358 | 2022-03-29 | Otero | Colorado | 8089 | 4255 | 126 |
2350106 | 2350106 | 2022-03-28 | Otero | Colorado | 8089 | 4252 | 126 |
2346853 | 2346853 | 2022-03-27 | Otero | Colorado | 8089 | 4254 | 126 |
2343600 | 2343600 | 2022-03-26 | Otero | Colorado | 8089 | 4254 | 126 |
2340347 | 2340347 | 2022-03-25 | Otero | Colorado | 8089 | 4254 | 126 |
2337094 | 2337094 | 2022-03-24 | Otero | Colorado | 8089 | 4246 | 126 |
2333840 | 2333840 | 2022-03-23 | Otero | Colorado | 8089 | 4242 | 126 |
2330586 | 2330586 | 2022-03-22 | Otero | Colorado | 8089 | 4241 | 126 |
2327334 | 2327334 | 2022-03-21 | Otero | Colorado | 8089 | 4238 | 126 |
2324081 | 2324081 | 2022-03-20 | Otero | Colorado | 8089 | 4238 | 126 |
2320827 | 2320827 | 2022-03-19 | Otero | Colorado | 8089 | 4238 | 126 |
2317573 | 2317573 | 2022-03-18 | Otero | Colorado | 8089 | 4238 | 126 |
2314320 | 2314320 | 2022-03-17 | Otero | Colorado | 8089 | 4238 | 126 |
2311067 | 2311067 | 2022-03-16 | Otero | Colorado | 8089 | 4236 | 125 |
2307814 | 2307814 | 2022-03-15 | Otero | Colorado | 8089 | 4233 | 125 |
2304563 | 2304563 | 2022-03-14 | Otero | Colorado | 8089 | 4232 | 125 |
2301311 | 2301311 | 2022-03-13 | Otero | Colorado | 8089 | 4228 | 125 |
2298059 | 2298059 | 2022-03-12 | Otero | Colorado | 8089 | 4228 | 125 |
2294807 | 2294807 | 2022-03-11 | Otero | Colorado | 8089 | 4228 | 125 |
2291555 | 2291555 | 2022-03-10 | Otero | Colorado | 8089 | 4218 | 125 |
2288303 | 2288303 | 2022-03-09 | Otero | Colorado | 8089 | 4217 | 125 |
2285052 | 2285052 | 2022-03-08 | Otero | Colorado | 8089 | 4212 | 125 |
2281800 | 2281800 | 2022-03-07 | Otero | Colorado | 8089 | 4211 | 125 |
2278547 | 2278547 | 2022-03-06 | Otero | Colorado | 8089 | 4194 | 125 |
2275294 | 2275294 | 2022-03-05 | Otero | Colorado | 8089 | 4194 | 125 |
2272041 | 2272041 | 2022-03-04 | Otero | Colorado | 8089 | 4194 | 125 |
2268789 | 2268789 | 2022-03-03 | Otero | Colorado | 8089 | 4193 | 125 |
2265536 | 2265536 | 2022-03-02 | Otero | Colorado | 8089 | 4192 | 125 |
2262285 | 2262285 | 2022-03-01 | Otero | Colorado | 8089 | 4191 | 125 |
2259034 | 2259034 | 2022-02-28 | Otero | Colorado | 8089 | 4188 | 125 |
2255783 | 2255783 | 2022-02-27 | Otero | Colorado | 8089 | 4180 | 125 |
2252532 | 2252532 | 2022-02-26 | Otero | Colorado | 8089 | 4180 | 125 |
2249281 | 2249281 | 2022-02-25 | Otero | Colorado | 8089 | 4180 | 125 |
2246030 | 2246030 | 2022-02-24 | Otero | Colorado | 8089 | 4173 | 125 |
2242779 | 2242779 | 2022-02-23 | Otero | Colorado | 8089 | 4171 | 125 |
2239528 | 2239528 | 2022-02-22 | Otero | Colorado | 8089 | 4163 | 125 |
2236277 | 2236277 | 2022-02-21 | Otero | Colorado | 8089 | 4154 | 125 |
2233026 | 2233026 | 2022-02-20 | Otero | Colorado | 8089 | 4136 | 125 |
2229775 | 2229775 | 2022-02-19 | Otero | Colorado | 8089 | 4136 | 125 |
2226524 | 2226524 | 2022-02-18 | Otero | Colorado | 8089 | 4136 | 125 |
2223273 | 2223273 | 2022-02-17 | Otero | Colorado | 8089 | 4126 | 125 |
2220022 | 2220022 | 2022-02-16 | Otero | Colorado | 8089 | 4119 | 125 |
2216771 | 2216771 | 2022-02-15 | Otero | Colorado | 8089 | 4119 | 125 |
2213520 | 2213520 | 2022-02-14 | Otero | Colorado | 8089 | 4114 | 125 |
2210268 | 2210268 | 2022-02-13 | Otero | Colorado | 8089 | 4108 | 125 |
2207015 | 2207015 | 2022-02-12 | Otero | Colorado | 8089 | 4108 | 125 |
2203762 | 2203762 | 2022-02-11 | Otero | Colorado | 8089 | 4108 | 125 |
2200509 | 2200509 | 2022-02-10 | Otero | Colorado | 8089 | 4097 | 125 |
2197255 | 2197255 | 2022-02-09 | Otero | Colorado | 8089 | 4093 | 125 |
2194001 | 2194001 | 2022-02-08 | Otero | Colorado | 8089 | 4083 | 125 |
2190747 | 2190747 | 2022-02-07 | Otero | Colorado | 8089 | 4070 | 125 |
2187494 | 2187494 | 2022-02-06 | Otero | Colorado | 8089 | 4052 | 123 |
2184241 | 2184241 | 2022-02-05 | Otero | Colorado | 8089 | 4052 | 123 |
2180989 | 2180989 | 2022-02-04 | Otero | Colorado | 8089 | 4052 | 123 |
2177738 | 2177738 | 2022-02-03 | Otero | Colorado | 8089 | 4033 | 123 |
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);