ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49,527 rows where state = "Colorado" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Weld 790
- Adams 789
- Arapahoe 789
- Boulder 789
- Clear Creek 789
- Denver 789
- Douglas 789
- Eagle 789
- El Paso 789
- Garfield 789
- Gunnison 789
- Jefferson 789
- Larimer 789
- Mesa 789
- Pitkin 789
- Pueblo 789
- Routt 789
- Summit 789
- Yuma 787
- Crowley 786
- Grand 786
- Morgan 786
- Broomfield 785
- Park 785
- San Miguel 785
- Chaffee 784
- Elbert 784
- Hinsdale 784
- Montrose 784
- La Plata 782
- …
state 1
- Colorado · 49,427 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2373 | 2373 | 2020-03-15 | Weld | Colorado | 8123 | 4 | 0 |
2791 | 2791 | 2020-03-16 | Adams | Colorado | 8001 | 8 | 0 |
2792 | 2792 | 2020-03-16 | Arapahoe | Colorado | 8005 | 15 | 0 |
2793 | 2793 | 2020-03-16 | Boulder | Colorado | 8013 | 7 | 0 |
2794 | 2794 | 2020-03-16 | Clear Creek | Colorado | 8019 | 1 | 0 |
2795 | 2795 | 2020-03-16 | Denver | Colorado | 8031 | 28 | 0 |
2796 | 2796 | 2020-03-16 | Douglas | Colorado | 8035 | 8 | 0 |
2797 | 2797 | 2020-03-16 | Eagle | Colorado | 8037 | 34 | 0 |
2798 | 2798 | 2020-03-16 | El Paso | Colorado | 8041 | 6 | 2 |
2799 | 2799 | 2020-03-16 | Garfield | Colorado | 8045 | 2 | 0 |
2800 | 2800 | 2020-03-16 | Gunnison | Colorado | 8051 | 11 | 0 |
2801 | 2801 | 2020-03-16 | Jefferson | Colorado | 8059 | 17 | 0 |
2802 | 2802 | 2020-03-16 | Larimer | Colorado | 8069 | 2 | 0 |
2803 | 2803 | 2020-03-16 | Mesa | Colorado | 8077 | 1 | 0 |
2804 | 2804 | 2020-03-16 | Pitkin | Colorado | 8097 | 11 | 0 |
2805 | 2805 | 2020-03-16 | Pueblo | Colorado | 8101 | 1 | 0 |
2806 | 2806 | 2020-03-16 | Routt | Colorado | 8107 | 2 | 0 |
2807 | 2807 | 2020-03-16 | Summit | Colorado | 8117 | 3 | 0 |
2808 | 2808 | 2020-03-16 | Weld | Colorado | 8123 | 4 | 0 |
3273 | 3273 | 2020-03-17 | Adams | Colorado | 8001 | 10 | 0 |
3274 | 3274 | 2020-03-17 | Arapahoe | Colorado | 8005 | 18 | 0 |
3275 | 3275 | 2020-03-17 | Boulder | Colorado | 8013 | 8 | 0 |
3276 | 3276 | 2020-03-17 | Clear Creek | Colorado | 8019 | 2 | 0 |
3277 | 3277 | 2020-03-17 | Denver | Colorado | 8031 | 41 | 0 |
3278 | 3278 | 2020-03-17 | Douglas | Colorado | 8035 | 9 | 0 |
3279 | 3279 | 2020-03-17 | Eagle | Colorado | 8037 | 34 | 0 |
3280 | 3280 | 2020-03-17 | El Paso | Colorado | 8041 | 6 | 2 |
3281 | 3281 | 2020-03-17 | Garfield | Colorado | 8045 | 2 | 0 |
3282 | 3282 | 2020-03-17 | Gunnison | Colorado | 8051 | 11 | 0 |
3283 | 3283 | 2020-03-17 | Jefferson | Colorado | 8059 | 17 | 0 |
3284 | 3284 | 2020-03-17 | Larimer | Colorado | 8069 | 2 | 0 |
3285 | 3285 | 2020-03-17 | Mesa | Colorado | 8077 | 1 | 0 |
3286 | 3286 | 2020-03-17 | Pitkin | Colorado | 8097 | 11 | 0 |
3287 | 3287 | 2020-03-17 | Pueblo | Colorado | 8101 | 1 | 0 |
3288 | 3288 | 2020-03-17 | Routt | Colorado | 8107 | 2 | 0 |
3289 | 3289 | 2020-03-17 | Summit | Colorado | 8117 | 3 | 0 |
3290 | 3290 | 2020-03-17 | Weld | Colorado | 8123 | 5 | 1 |
3827 | 3827 | 2020-03-18 | Adams | Colorado | 8001 | 10 | 0 |
3828 | 3828 | 2020-03-18 | Arapahoe | Colorado | 8005 | 22 | 0 |
3829 | 3829 | 2020-03-18 | Boulder | Colorado | 8013 | 8 | 0 |
3830 | 3830 | 2020-03-18 | Clear Creek | Colorado | 8019 | 2 | 0 |
3831 | 3831 | 2020-03-18 | Denver | Colorado | 8031 | 45 | 0 |
3832 | 3832 | 2020-03-18 | Douglas | Colorado | 8035 | 11 | 0 |
3833 | 3833 | 2020-03-18 | Eagle | Colorado | 8037 | 39 | 0 |
3834 | 3834 | 2020-03-18 | El Paso | Colorado | 8041 | 8 | 2 |
3835 | 3835 | 2020-03-18 | Garfield | Colorado | 8045 | 2 | 0 |
3836 | 3836 | 2020-03-18 | Gunnison | Colorado | 8051 | 11 | 0 |
3837 | 3837 | 2020-03-18 | Jefferson | Colorado | 8059 | 25 | 0 |
3838 | 3838 | 2020-03-18 | Larimer | Colorado | 8069 | 4 | 0 |
3839 | 3839 | 2020-03-18 | Mesa | Colorado | 8077 | 1 | 0 |
3840 | 3840 | 2020-03-18 | Pitkin | Colorado | 8097 | 11 | 0 |
3841 | 3841 | 2020-03-18 | Pueblo | Colorado | 8101 | 1 | 0 |
3842 | 3842 | 2020-03-18 | Routt | Colorado | 8107 | 2 | 0 |
3843 | 3843 | 2020-03-18 | Summit | Colorado | 8117 | 4 | 0 |
3844 | 3844 | 2020-03-18 | Weld | Colorado | 8123 | 9 | 1 |
3845 | 3845 | 2020-03-18 | Yuma | Colorado | 8125 | 1 | 0 |
4487 | 4487 | 2020-03-19 | Adams | Colorado | 8001 | 10 | 0 |
4488 | 4488 | 2020-03-19 | Arapahoe | Colorado | 8005 | 22 | 0 |
4489 | 4489 | 2020-03-19 | Boulder | Colorado | 8013 | 11 | 0 |
4490 | 4490 | 2020-03-19 | Clear Creek | Colorado | 8019 | 2 | 0 |
4491 | 4491 | 2020-03-19 | Crowley | Colorado | 8025 | 1 | 1 |
4492 | 4492 | 2020-03-19 | Denver | Colorado | 8031 | 61 | 0 |
4493 | 4493 | 2020-03-19 | Douglas | Colorado | 8035 | 14 | 0 |
4494 | 4494 | 2020-03-19 | Eagle | Colorado | 8037 | 51 | 0 |
4495 | 4495 | 2020-03-19 | El Paso | Colorado | 8041 | 15 | 3 |
4496 | 4496 | 2020-03-19 | Garfield | Colorado | 8045 | 3 | 0 |
4497 | 4497 | 2020-03-19 | Grand | Colorado | 8049 | 1 | 0 |
4498 | 4498 | 2020-03-19 | Gunnison | Colorado | 8051 | 13 | 0 |
4499 | 4499 | 2020-03-19 | Jefferson | Colorado | 8059 | 36 | 0 |
4500 | 4500 | 2020-03-19 | Larimer | Colorado | 8069 | 5 | 0 |
4501 | 4501 | 2020-03-19 | Mesa | Colorado | 8077 | 1 | 0 |
4502 | 4502 | 2020-03-19 | Morgan | Colorado | 8087 | 1 | 0 |
4503 | 4503 | 2020-03-19 | Pitkin | Colorado | 8097 | 12 | 0 |
4504 | 4504 | 2020-03-19 | Pueblo | Colorado | 8101 | 2 | 0 |
4505 | 4505 | 2020-03-19 | Routt | Colorado | 8107 | 2 | 0 |
4506 | 4506 | 2020-03-19 | Summit | Colorado | 8117 | 5 | 0 |
4507 | 4507 | 2020-03-19 | Weld | Colorado | 8123 | 9 | 1 |
4508 | 4508 | 2020-03-19 | Yuma | Colorado | 8125 | 1 | 0 |
5262 | 5262 | 2020-03-20 | Adams | Colorado | 8001 | 12 | 0 |
5263 | 5263 | 2020-03-20 | Arapahoe | Colorado | 8005 | 29 | 0 |
5264 | 5264 | 2020-03-20 | Boulder | Colorado | 8013 | 24 | 0 |
5265 | 5265 | 2020-03-20 | Broomfield | Colorado | 8014 | 1 | 0 |
5266 | 5266 | 2020-03-20 | Clear Creek | Colorado | 8019 | 2 | 0 |
5267 | 5267 | 2020-03-20 | Crowley | Colorado | 8025 | 1 | 1 |
5268 | 5268 | 2020-03-20 | Denver | Colorado | 8031 | 79 | 0 |
5269 | 5269 | 2020-03-20 | Douglas | Colorado | 8035 | 17 | 0 |
5270 | 5270 | 2020-03-20 | Eagle | Colorado | 8037 | 61 | 0 |
5271 | 5271 | 2020-03-20 | El Paso | Colorado | 8041 | 27 | 3 |
5272 | 5272 | 2020-03-20 | Garfield | Colorado | 8045 | 4 | 0 |
5273 | 5273 | 2020-03-20 | Grand | Colorado | 8049 | 2 | 0 |
5274 | 5274 | 2020-03-20 | Gunnison | Colorado | 8051 | 13 | 0 |
5275 | 5275 | 2020-03-20 | Jefferson | Colorado | 8059 | 37 | 0 |
5276 | 5276 | 2020-03-20 | Larimer | Colorado | 8069 | 7 | 0 |
5277 | 5277 | 2020-03-20 | Mesa | Colorado | 8077 | 1 | 0 |
5278 | 5278 | 2020-03-20 | Morgan | Colorado | 8087 | 2 | 0 |
5279 | 5279 | 2020-03-20 | Park | Colorado | 8093 | 1 | 0 |
5280 | 5280 | 2020-03-20 | Pitkin | Colorado | 8097 | 15 | 0 |
5281 | 5281 | 2020-03-20 | Pueblo | Colorado | 8101 | 3 | 0 |
5282 | 5282 | 2020-03-20 | Routt | Colorado | 8107 | 2 | 0 |
5283 | 5283 | 2020-03-20 | San Miguel | Colorado | 8113 | 1 | 0 |
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);