ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Alamosa" and state = "Colorado" 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 |
---|---|---|---|---|---|---|---|
2499821 | 2499821 | 2022-05-13 | Alamosa | Colorado | 8003 | 4560 | 62 |
2496563 | 2496563 | 2022-05-12 | Alamosa | Colorado | 8003 | 4559 | 62 |
2493305 | 2493305 | 2022-05-11 | Alamosa | Colorado | 8003 | 4549 | 62 |
2490047 | 2490047 | 2022-05-10 | Alamosa | Colorado | 8003 | 4549 | 62 |
2486790 | 2486790 | 2022-05-09 | Alamosa | Colorado | 8003 | 4547 | 62 |
2483532 | 2483532 | 2022-05-08 | Alamosa | Colorado | 8003 | 4547 | 62 |
2480274 | 2480274 | 2022-05-07 | Alamosa | Colorado | 8003 | 4547 | 62 |
2477016 | 2477016 | 2022-05-06 | Alamosa | Colorado | 8003 | 4547 | 62 |
2473758 | 2473758 | 2022-05-05 | Alamosa | Colorado | 8003 | 4546 | 62 |
2470501 | 2470501 | 2022-05-04 | Alamosa | Colorado | 8003 | 4540 | 62 |
2467245 | 2467245 | 2022-05-03 | Alamosa | Colorado | 8003 | 4538 | 62 |
2463990 | 2463990 | 2022-05-02 | Alamosa | Colorado | 8003 | 4538 | 61 |
2460734 | 2460734 | 2022-05-01 | Alamosa | Colorado | 8003 | 4538 | 61 |
2457478 | 2457478 | 2022-04-30 | Alamosa | Colorado | 8003 | 4538 | 61 |
2454222 | 2454222 | 2022-04-29 | Alamosa | Colorado | 8003 | 4538 | 61 |
2450966 | 2450966 | 2022-04-28 | Alamosa | Colorado | 8003 | 4538 | 61 |
2447710 | 2447710 | 2022-04-27 | Alamosa | Colorado | 8003 | 4538 | 61 |
2444454 | 2444454 | 2022-04-26 | Alamosa | Colorado | 8003 | 4534 | 61 |
2441198 | 2441198 | 2022-04-25 | Alamosa | Colorado | 8003 | 4533 | 61 |
2437942 | 2437942 | 2022-04-24 | Alamosa | Colorado | 8003 | 4527 | 61 |
2434686 | 2434686 | 2022-04-23 | Alamosa | Colorado | 8003 | 4527 | 61 |
2431430 | 2431430 | 2022-04-22 | Alamosa | Colorado | 8003 | 4527 | 61 |
2428174 | 2428174 | 2022-04-21 | Alamosa | Colorado | 8003 | 4526 | 61 |
2424918 | 2424918 | 2022-04-20 | Alamosa | Colorado | 8003 | 4527 | 61 |
2421662 | 2421662 | 2022-04-19 | Alamosa | Colorado | 8003 | 4523 | 61 |
2418406 | 2418406 | 2022-04-18 | Alamosa | Colorado | 8003 | 4516 | 61 |
2415150 | 2415150 | 2022-04-17 | Alamosa | Colorado | 8003 | 4508 | 61 |
2411894 | 2411894 | 2022-04-16 | Alamosa | Colorado | 8003 | 4508 | 61 |
2408638 | 2408638 | 2022-04-15 | Alamosa | Colorado | 8003 | 4508 | 61 |
2405382 | 2405382 | 2022-04-14 | Alamosa | Colorado | 8003 | 4508 | 60 |
2402127 | 2402127 | 2022-04-13 | Alamosa | Colorado | 8003 | 4505 | 60 |
2398872 | 2398872 | 2022-04-12 | Alamosa | Colorado | 8003 | 4504 | 60 |
2395617 | 2395617 | 2022-04-11 | Alamosa | Colorado | 8003 | 4499 | 60 |
2392361 | 2392361 | 2022-04-10 | Alamosa | Colorado | 8003 | 4498 | 60 |
2389105 | 2389105 | 2022-04-09 | Alamosa | Colorado | 8003 | 4498 | 60 |
2385850 | 2385850 | 2022-04-08 | Alamosa | Colorado | 8003 | 4498 | 60 |
2382595 | 2382595 | 2022-04-07 | Alamosa | Colorado | 8003 | 4497 | 60 |
2379340 | 2379340 | 2022-04-06 | Alamosa | Colorado | 8003 | 4505 | 60 |
2376086 | 2376086 | 2022-04-05 | Alamosa | Colorado | 8003 | 4505 | 60 |
2372834 | 2372834 | 2022-04-04 | Alamosa | Colorado | 8003 | 4505 | 60 |
2369581 | 2369581 | 2022-04-03 | Alamosa | Colorado | 8003 | 4505 | 60 |
2366328 | 2366328 | 2022-04-02 | Alamosa | Colorado | 8003 | 4506 | 60 |
2363075 | 2363075 | 2022-04-01 | Alamosa | Colorado | 8003 | 4506 | 60 |
2359821 | 2359821 | 2022-03-31 | Alamosa | Colorado | 8003 | 4506 | 60 |
2356567 | 2356567 | 2022-03-30 | Alamosa | Colorado | 8003 | 4505 | 60 |
2353314 | 2353314 | 2022-03-29 | Alamosa | Colorado | 8003 | 4505 | 61 |
2350062 | 2350062 | 2022-03-28 | Alamosa | Colorado | 8003 | 4501 | 61 |
2346809 | 2346809 | 2022-03-27 | Alamosa | Colorado | 8003 | 4493 | 61 |
2343556 | 2343556 | 2022-03-26 | Alamosa | Colorado | 8003 | 4493 | 61 |
2340303 | 2340303 | 2022-03-25 | Alamosa | Colorado | 8003 | 4493 | 61 |
2337050 | 2337050 | 2022-03-24 | Alamosa | Colorado | 8003 | 4489 | 61 |
2333796 | 2333796 | 2022-03-23 | Alamosa | Colorado | 8003 | 4489 | 61 |
2330542 | 2330542 | 2022-03-22 | Alamosa | Colorado | 8003 | 4490 | 61 |
2327290 | 2327290 | 2022-03-21 | Alamosa | Colorado | 8003 | 4483 | 61 |
2324037 | 2324037 | 2022-03-20 | Alamosa | Colorado | 8003 | 4480 | 60 |
2320783 | 2320783 | 2022-03-19 | Alamosa | Colorado | 8003 | 4480 | 60 |
2317529 | 2317529 | 2022-03-18 | Alamosa | Colorado | 8003 | 4480 | 60 |
2314276 | 2314276 | 2022-03-17 | Alamosa | Colorado | 8003 | 4480 | 60 |
2311023 | 2311023 | 2022-03-16 | Alamosa | Colorado | 8003 | 4478 | 60 |
2307770 | 2307770 | 2022-03-15 | Alamosa | Colorado | 8003 | 4477 | 60 |
2304519 | 2304519 | 2022-03-14 | Alamosa | Colorado | 8003 | 4471 | 60 |
2301267 | 2301267 | 2022-03-13 | Alamosa | Colorado | 8003 | 4469 | 60 |
2298015 | 2298015 | 2022-03-12 | Alamosa | Colorado | 8003 | 4469 | 60 |
2294763 | 2294763 | 2022-03-11 | Alamosa | Colorado | 8003 | 4469 | 60 |
2291511 | 2291511 | 2022-03-10 | Alamosa | Colorado | 8003 | 4453 | 60 |
2288259 | 2288259 | 2022-03-09 | Alamosa | Colorado | 8003 | 4446 | 60 |
2285008 | 2285008 | 2022-03-08 | Alamosa | Colorado | 8003 | 4439 | 60 |
2281756 | 2281756 | 2022-03-07 | Alamosa | Colorado | 8003 | 4437 | 60 |
2278503 | 2278503 | 2022-03-06 | Alamosa | Colorado | 8003 | 4413 | 60 |
2275250 | 2275250 | 2022-03-05 | Alamosa | Colorado | 8003 | 4413 | 60 |
2271997 | 2271997 | 2022-03-04 | Alamosa | Colorado | 8003 | 4413 | 60 |
2268745 | 2268745 | 2022-03-03 | Alamosa | Colorado | 8003 | 4407 | 60 |
2265492 | 2265492 | 2022-03-02 | Alamosa | Colorado | 8003 | 4402 | 60 |
2262241 | 2262241 | 2022-03-01 | Alamosa | Colorado | 8003 | 4400 | 60 |
2258990 | 2258990 | 2022-02-28 | Alamosa | Colorado | 8003 | 4396 | 60 |
2255739 | 2255739 | 2022-02-27 | Alamosa | Colorado | 8003 | 4383 | 60 |
2252488 | 2252488 | 2022-02-26 | Alamosa | Colorado | 8003 | 4383 | 60 |
2249237 | 2249237 | 2022-02-25 | Alamosa | Colorado | 8003 | 4383 | 60 |
2245986 | 2245986 | 2022-02-24 | Alamosa | Colorado | 8003 | 4384 | 60 |
2242735 | 2242735 | 2022-02-23 | Alamosa | Colorado | 8003 | 4371 | 60 |
2239484 | 2239484 | 2022-02-22 | Alamosa | Colorado | 8003 | 4359 | 59 |
2236233 | 2236233 | 2022-02-21 | Alamosa | Colorado | 8003 | 4354 | 59 |
2232982 | 2232982 | 2022-02-20 | Alamosa | Colorado | 8003 | 4344 | 59 |
2229731 | 2229731 | 2022-02-19 | Alamosa | Colorado | 8003 | 4344 | 59 |
2226480 | 2226480 | 2022-02-18 | Alamosa | Colorado | 8003 | 4344 | 59 |
2223229 | 2223229 | 2022-02-17 | Alamosa | Colorado | 8003 | 4337 | 59 |
2219978 | 2219978 | 2022-02-16 | Alamosa | Colorado | 8003 | 4326 | 59 |
2216727 | 2216727 | 2022-02-15 | Alamosa | Colorado | 8003 | 4313 | 58 |
2213476 | 2213476 | 2022-02-14 | Alamosa | Colorado | 8003 | 4298 | 58 |
2210224 | 2210224 | 2022-02-13 | Alamosa | Colorado | 8003 | 4290 | 58 |
2206971 | 2206971 | 2022-02-12 | Alamosa | Colorado | 8003 | 4290 | 58 |
2203718 | 2203718 | 2022-02-11 | Alamosa | Colorado | 8003 | 4290 | 58 |
2200465 | 2200465 | 2022-02-10 | Alamosa | Colorado | 8003 | 4270 | 58 |
2197211 | 2197211 | 2022-02-09 | Alamosa | Colorado | 8003 | 4248 | 58 |
2193957 | 2193957 | 2022-02-08 | Alamosa | Colorado | 8003 | 4240 | 58 |
2190703 | 2190703 | 2022-02-07 | Alamosa | Colorado | 8003 | 4220 | 58 |
2187450 | 2187450 | 2022-02-06 | Alamosa | Colorado | 8003 | 4188 | 58 |
2184197 | 2184197 | 2022-02-05 | Alamosa | Colorado | 8003 | 4188 | 58 |
2180945 | 2180945 | 2022-02-04 | Alamosa | Colorado | 8003 | 4188 | 58 |
2177694 | 2177694 | 2022-02-03 | Alamosa | Colorado | 8003 | 4176 | 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);