ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,553 rows where county = "Otero" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337094 | 2337094 | 2022-03-24 | Otero | Colorado | 8089 | 4246 | 126 |
2338640 | 2338640 | 2022-03-24 | Otero | New Mexico | 35035 | 15473 | 181 |
2333840 | 2333840 | 2022-03-23 | Otero | Colorado | 8089 | 4242 | 126 |
2335386 | 2335386 | 2022-03-23 | Otero | New Mexico | 35035 | 15473 | 181 |
2330586 | 2330586 | 2022-03-22 | Otero | Colorado | 8089 | 4241 | 126 |
2332132 | 2332132 | 2022-03-22 | Otero | New Mexico | 35035 | 15472 | 181 |
2327334 | 2327334 | 2022-03-21 | Otero | Colorado | 8089 | 4238 | 126 |
2328879 | 2328879 | 2022-03-21 | Otero | New Mexico | 35035 | 15473 | 181 |
2324081 | 2324081 | 2022-03-20 | Otero | Colorado | 8089 | 4238 | 126 |
2325627 | 2325627 | 2022-03-20 | Otero | New Mexico | 35035 | 15462 | 181 |
2320827 | 2320827 | 2022-03-19 | Otero | Colorado | 8089 | 4238 | 126 |
2322373 | 2322373 | 2022-03-19 | Otero | New Mexico | 35035 | 15460 | 181 |
2317573 | 2317573 | 2022-03-18 | Otero | Colorado | 8089 | 4238 | 126 |
2319119 | 2319119 | 2022-03-18 | Otero | New Mexico | 35035 | 15460 | 181 |
2314320 | 2314320 | 2022-03-17 | Otero | Colorado | 8089 | 4238 | 126 |
2315866 | 2315866 | 2022-03-17 | Otero | New Mexico | 35035 | 15460 | 181 |
2311067 | 2311067 | 2022-03-16 | Otero | Colorado | 8089 | 4236 | 125 |
2312613 | 2312613 | 2022-03-16 | Otero | New Mexico | 35035 | 15458 | 180 |
2307814 | 2307814 | 2022-03-15 | Otero | Colorado | 8089 | 4233 | 125 |
2309360 | 2309360 | 2022-03-15 | Otero | New Mexico | 35035 | 15453 | 180 |
2304563 | 2304563 | 2022-03-14 | Otero | Colorado | 8089 | 4232 | 125 |
2306107 | 2306107 | 2022-03-14 | Otero | New Mexico | 35035 | 15451 | 180 |
2301311 | 2301311 | 2022-03-13 | Otero | Colorado | 8089 | 4228 | 125 |
2302856 | 2302856 | 2022-03-13 | Otero | New Mexico | 35035 | 15445 | 180 |
2298059 | 2298059 | 2022-03-12 | Otero | Colorado | 8089 | 4228 | 125 |
2299604 | 2299604 | 2022-03-12 | Otero | New Mexico | 35035 | 15445 | 180 |
2294807 | 2294807 | 2022-03-11 | Otero | Colorado | 8089 | 4228 | 125 |
2296352 | 2296352 | 2022-03-11 | Otero | New Mexico | 35035 | 15445 | 180 |
2291555 | 2291555 | 2022-03-10 | Otero | Colorado | 8089 | 4218 | 125 |
2293100 | 2293100 | 2022-03-10 | Otero | New Mexico | 35035 | 15436 | 180 |
2288303 | 2288303 | 2022-03-09 | Otero | Colorado | 8089 | 4217 | 125 |
2289848 | 2289848 | 2022-03-09 | Otero | New Mexico | 35035 | 15428 | 180 |
2285052 | 2285052 | 2022-03-08 | Otero | Colorado | 8089 | 4212 | 125 |
2286596 | 2286596 | 2022-03-08 | Otero | New Mexico | 35035 | 15418 | 180 |
2281800 | 2281800 | 2022-03-07 | Otero | Colorado | 8089 | 4211 | 125 |
2283344 | 2283344 | 2022-03-07 | Otero | New Mexico | 35035 | 15411 | 179 |
2278547 | 2278547 | 2022-03-06 | Otero | Colorado | 8089 | 4194 | 125 |
2280091 | 2280091 | 2022-03-06 | Otero | New Mexico | 35035 | 15371 | 179 |
2275294 | 2275294 | 2022-03-05 | Otero | Colorado | 8089 | 4194 | 125 |
2276838 | 2276838 | 2022-03-05 | Otero | New Mexico | 35035 | 15371 | 179 |
2272041 | 2272041 | 2022-03-04 | Otero | Colorado | 8089 | 4194 | 125 |
2273585 | 2273585 | 2022-03-04 | Otero | New Mexico | 35035 | 15371 | 179 |
2268789 | 2268789 | 2022-03-03 | Otero | Colorado | 8089 | 4193 | 125 |
2270333 | 2270333 | 2022-03-03 | Otero | New Mexico | 35035 | 15360 | 179 |
2265536 | 2265536 | 2022-03-02 | Otero | Colorado | 8089 | 4192 | 125 |
2267080 | 2267080 | 2022-03-02 | Otero | New Mexico | 35035 | 15352 | 179 |
2262285 | 2262285 | 2022-03-01 | Otero | Colorado | 8089 | 4191 | 125 |
2263829 | 2263829 | 2022-03-01 | Otero | New Mexico | 35035 | 15327 | 179 |
2259034 | 2259034 | 2022-02-28 | Otero | Colorado | 8089 | 4188 | 125 |
2260578 | 2260578 | 2022-02-28 | Otero | New Mexico | 35035 | 15294 | 178 |
2255783 | 2255783 | 2022-02-27 | Otero | Colorado | 8089 | 4180 | 125 |
2257327 | 2257327 | 2022-02-27 | Otero | New Mexico | 35035 | 15277 | 177 |
2252532 | 2252532 | 2022-02-26 | Otero | Colorado | 8089 | 4180 | 125 |
2254076 | 2254076 | 2022-02-26 | Otero | New Mexico | 35035 | 15277 | 177 |
2249281 | 2249281 | 2022-02-25 | Otero | Colorado | 8089 | 4180 | 125 |
2250825 | 2250825 | 2022-02-25 | Otero | New Mexico | 35035 | 15277 | 177 |
2246030 | 2246030 | 2022-02-24 | Otero | Colorado | 8089 | 4173 | 125 |
2247574 | 2247574 | 2022-02-24 | Otero | New Mexico | 35035 | 15265 | 176 |
2242779 | 2242779 | 2022-02-23 | Otero | Colorado | 8089 | 4171 | 125 |
2244323 | 2244323 | 2022-02-23 | Otero | New Mexico | 35035 | 15254 | 175 |
2239528 | 2239528 | 2022-02-22 | Otero | Colorado | 8089 | 4163 | 125 |
2241072 | 2241072 | 2022-02-22 | Otero | New Mexico | 35035 | 15240 | 173 |
2236277 | 2236277 | 2022-02-21 | Otero | Colorado | 8089 | 4154 | 125 |
2237821 | 2237821 | 2022-02-21 | Otero | New Mexico | 35035 | 15234 | 172 |
2233026 | 2233026 | 2022-02-20 | Otero | Colorado | 8089 | 4136 | 125 |
2234570 | 2234570 | 2022-02-20 | Otero | New Mexico | 35035 | 15192 | 169 |
2229775 | 2229775 | 2022-02-19 | Otero | Colorado | 8089 | 4136 | 125 |
2231319 | 2231319 | 2022-02-19 | Otero | New Mexico | 35035 | 15192 | 169 |
2226524 | 2226524 | 2022-02-18 | Otero | Colorado | 8089 | 4136 | 125 |
2228068 | 2228068 | 2022-02-18 | Otero | New Mexico | 35035 | 15192 | 169 |
2223273 | 2223273 | 2022-02-17 | Otero | Colorado | 8089 | 4126 | 125 |
2224817 | 2224817 | 2022-02-17 | Otero | New Mexico | 35035 | 15179 | 167 |
2220022 | 2220022 | 2022-02-16 | Otero | Colorado | 8089 | 4119 | 125 |
2221566 | 2221566 | 2022-02-16 | Otero | New Mexico | 35035 | 15164 | 167 |
2216771 | 2216771 | 2022-02-15 | Otero | Colorado | 8089 | 4119 | 125 |
2218315 | 2218315 | 2022-02-15 | Otero | New Mexico | 35035 | 15128 | 165 |
2213520 | 2213520 | 2022-02-14 | Otero | Colorado | 8089 | 4114 | 125 |
2215064 | 2215064 | 2022-02-14 | Otero | New Mexico | 35035 | 15118 | 165 |
2210268 | 2210268 | 2022-02-13 | Otero | Colorado | 8089 | 4108 | 125 |
2211812 | 2211812 | 2022-02-13 | Otero | New Mexico | 35035 | 15019 | 164 |
2207015 | 2207015 | 2022-02-12 | Otero | Colorado | 8089 | 4108 | 125 |
2208559 | 2208559 | 2022-02-12 | Otero | New Mexico | 35035 | 15019 | 164 |
2203762 | 2203762 | 2022-02-11 | Otero | Colorado | 8089 | 4108 | 125 |
2205306 | 2205306 | 2022-02-11 | Otero | New Mexico | 35035 | 15019 | 164 |
2200509 | 2200509 | 2022-02-10 | Otero | Colorado | 8089 | 4097 | 125 |
2202053 | 2202053 | 2022-02-10 | Otero | New Mexico | 35035 | 14939 | 164 |
2197255 | 2197255 | 2022-02-09 | Otero | Colorado | 8089 | 4093 | 125 |
2198799 | 2198799 | 2022-02-09 | Otero | New Mexico | 35035 | 14885 | 164 |
2194001 | 2194001 | 2022-02-08 | Otero | Colorado | 8089 | 4083 | 125 |
2195545 | 2195545 | 2022-02-08 | Otero | New Mexico | 35035 | 14795 | 162 |
2190747 | 2190747 | 2022-02-07 | Otero | Colorado | 8089 | 4070 | 125 |
2192291 | 2192291 | 2022-02-07 | Otero | New Mexico | 35035 | 14748 | 162 |
2187494 | 2187494 | 2022-02-06 | Otero | Colorado | 8089 | 4052 | 123 |
2189038 | 2189038 | 2022-02-06 | Otero | New Mexico | 35035 | 14540 | 160 |
2184241 | 2184241 | 2022-02-05 | Otero | Colorado | 8089 | 4052 | 123 |
2185785 | 2185785 | 2022-02-05 | Otero | New Mexico | 35035 | 14540 | 160 |
2180989 | 2180989 | 2022-02-04 | Otero | Colorado | 8089 | 4052 | 123 |
2182533 | 2182533 | 2022-02-04 | Otero | New Mexico | 35035 | 14540 | 160 |
2177738 | 2177738 | 2022-02-03 | Otero | Colorado | 8089 | 4033 | 123 |
2179281 | 2179281 | 2022-02-03 | Otero | New Mexico | 35035 | 14489 | 159 |
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);