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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14190 | 14190 | 2020-03-27 | Alamosa | Colorado | 8003 | 1 | 0 |
15972 | 15972 | 2020-03-28 | Alamosa | Colorado | 8003 | 1 | 0 |
17862 | 17862 | 2020-03-29 | Alamosa | Colorado | 8003 | 1 | 0 |
19839 | 19839 | 2020-03-30 | Alamosa | Colorado | 8003 | 1 | 0 |
21914 | 21914 | 2020-03-31 | Alamosa | Colorado | 8003 | 1 | 0 |
24073 | 24073 | 2020-04-01 | Alamosa | Colorado | 8003 | 4 | 0 |
26302 | 26302 | 2020-04-02 | Alamosa | Colorado | 8003 | 4 | 0 |
28602 | 28602 | 2020-04-03 | Alamosa | Colorado | 8003 | 4 | 0 |
30959 | 30959 | 2020-04-04 | Alamosa | Colorado | 8003 | 4 | 0 |
33365 | 33365 | 2020-04-05 | Alamosa | Colorado | 8003 | 4 | 0 |
35810 | 35810 | 2020-04-06 | Alamosa | Colorado | 8003 | 4 | 0 |
38300 | 38300 | 2020-04-07 | Alamosa | Colorado | 8003 | 4 | 0 |
40843 | 40843 | 2020-04-08 | Alamosa | Colorado | 8003 | 5 | 0 |
43415 | 43415 | 2020-04-09 | Alamosa | Colorado | 8003 | 7 | 2 |
46015 | 46015 | 2020-04-10 | Alamosa | Colorado | 8003 | 7 | 2 |
48645 | 48645 | 2020-04-11 | Alamosa | Colorado | 8003 | 7 | 2 |
51307 | 51307 | 2020-04-12 | Alamosa | Colorado | 8003 | 7 | 2 |
53986 | 53986 | 2020-04-13 | Alamosa | Colorado | 8003 | 7 | 2 |
56678 | 56678 | 2020-04-14 | Alamosa | Colorado | 8003 | 7 | 2 |
59386 | 59386 | 2020-04-15 | Alamosa | Colorado | 8003 | 7 | 2 |
62105 | 62105 | 2020-04-16 | Alamosa | Colorado | 8003 | 7 | 2 |
64838 | 64838 | 2020-04-17 | Alamosa | Colorado | 8003 | 7 | 2 |
67586 | 67586 | 2020-04-18 | Alamosa | Colorado | 8003 | 7 | 2 |
70348 | 70348 | 2020-04-19 | Alamosa | Colorado | 8003 | 7 | 2 |
73117 | 73117 | 2020-04-20 | Alamosa | Colorado | 8003 | 9 | 2 |
75893 | 75893 | 2020-04-21 | Alamosa | Colorado | 8003 | 9 | 2 |
78677 | 78677 | 2020-04-22 | Alamosa | Colorado | 8003 | 9 | 2 |
81471 | 81471 | 2020-04-23 | Alamosa | Colorado | 8003 | 9 | 2 |
84271 | 84271 | 2020-04-24 | Alamosa | Colorado | 8003 | 10 | 2 |
87079 | 87079 | 2020-04-25 | Alamosa | Colorado | 8003 | 10 | 2 |
89896 | 89896 | 2020-04-26 | Alamosa | Colorado | 8003 | 10 | 2 |
92714 | 92714 | 2020-04-27 | Alamosa | Colorado | 8003 | 10 | 2 |
95546 | 95546 | 2020-04-28 | Alamosa | Colorado | 8003 | 10 | 2 |
98391 | 98391 | 2020-04-29 | Alamosa | Colorado | 8003 | 10 | 2 |
101241 | 101241 | 2020-04-30 | Alamosa | Colorado | 8003 | 10 | 2 |
104096 | 104096 | 2020-05-01 | Alamosa | Colorado | 8003 | 10 | 2 |
106961 | 106961 | 2020-05-02 | Alamosa | Colorado | 8003 | 11 | 2 |
109830 | 109830 | 2020-05-03 | Alamosa | Colorado | 8003 | 12 | 2 |
112705 | 112705 | 2020-05-04 | Alamosa | Colorado | 8003 | 14 | 2 |
115588 | 115588 | 2020-05-05 | Alamosa | Colorado | 8003 | 14 | 2 |
118547 | 118547 | 2020-05-06 | Alamosa | Colorado | 8003 | 22 | 2 |
121514 | 121514 | 2020-05-07 | Alamosa | Colorado | 8003 | 25 | 2 |
124494 | 124494 | 2020-05-08 | Alamosa | Colorado | 8003 | 25 | 2 |
127480 | 127480 | 2020-05-09 | Alamosa | Colorado | 8003 | 25 | 2 |
130470 | 130470 | 2020-05-10 | Alamosa | Colorado | 8003 | 25 | 2 |
133461 | 133461 | 2020-05-11 | Alamosa | Colorado | 8003 | 32 | 2 |
136450 | 136450 | 2020-05-12 | Alamosa | Colorado | 8003 | 33 | 2 |
139441 | 139441 | 2020-05-13 | Alamosa | Colorado | 8003 | 33 | 2 |
142437 | 142437 | 2020-05-14 | Alamosa | Colorado | 8003 | 37 | 2 |
145437 | 145437 | 2020-05-15 | Alamosa | Colorado | 8003 | 38 | 2 |
148440 | 148440 | 2020-05-16 | Alamosa | Colorado | 8003 | 39 | 2 |
151449 | 151449 | 2020-05-17 | Alamosa | Colorado | 8003 | 41 | 2 |
154461 | 154461 | 2020-05-18 | Alamosa | Colorado | 8003 | 42 | 2 |
157477 | 157477 | 2020-05-19 | Alamosa | Colorado | 8003 | 43 | 2 |
160503 | 160503 | 2020-05-20 | Alamosa | Colorado | 8003 | 43 | 2 |
163531 | 163531 | 2020-05-21 | Alamosa | Colorado | 8003 | 51 | 2 |
166564 | 166564 | 2020-05-22 | Alamosa | Colorado | 8003 | 51 | 2 |
169601 | 169601 | 2020-05-23 | Alamosa | Colorado | 8003 | 55 | 2 |
172642 | 172642 | 2020-05-24 | Alamosa | Colorado | 8003 | 58 | 2 |
175686 | 175686 | 2020-05-25 | Alamosa | Colorado | 8003 | 58 | 2 |
178730 | 178730 | 2020-05-26 | Alamosa | Colorado | 8003 | 58 | 2 |
181774 | 181774 | 2020-05-27 | Alamosa | Colorado | 8003 | 58 | 2 |
184828 | 184828 | 2020-05-28 | Alamosa | Colorado | 8003 | 60 | 2 |
187884 | 187884 | 2020-05-29 | Alamosa | Colorado | 8003 | 65 | 2 |
190949 | 190949 | 2020-05-30 | Alamosa | Colorado | 8003 | 74 | 2 |
194016 | 194016 | 2020-05-31 | Alamosa | Colorado | 8003 | 76 | 2 |
197086 | 197086 | 2020-06-01 | Alamosa | Colorado | 8003 | 78 | 2 |
200159 | 200159 | 2020-06-02 | Alamosa | Colorado | 8003 | 82 | 2 |
203235 | 203235 | 2020-06-03 | Alamosa | Colorado | 8003 | 84 | 2 |
206315 | 206315 | 2020-06-04 | Alamosa | Colorado | 8003 | 84 | 2 |
209396 | 209396 | 2020-06-05 | Alamosa | Colorado | 8003 | 87 | 2 |
212481 | 212481 | 2020-06-06 | Alamosa | Colorado | 8003 | 90 | 2 |
215568 | 215568 | 2020-06-07 | Alamosa | Colorado | 8003 | 94 | 2 |
218659 | 218659 | 2020-06-08 | Alamosa | Colorado | 8003 | 95 | 2 |
221754 | 221754 | 2020-06-09 | Alamosa | Colorado | 8003 | 101 | 2 |
224849 | 224849 | 2020-06-10 | Alamosa | Colorado | 8003 | 107 | 3 |
227951 | 227951 | 2020-06-11 | Alamosa | Colorado | 8003 | 112 | 3 |
231054 | 231054 | 2020-06-12 | Alamosa | Colorado | 8003 | 114 | 3 |
234160 | 234160 | 2020-06-13 | Alamosa | Colorado | 8003 | 116 | 3 |
237267 | 237267 | 2020-06-14 | Alamosa | Colorado | 8003 | 118 | 3 |
240375 | 240375 | 2020-06-15 | Alamosa | Colorado | 8003 | 127 | 3 |
243486 | 243486 | 2020-06-16 | Alamosa | Colorado | 8003 | 129 | 3 |
246599 | 246599 | 2020-06-17 | Alamosa | Colorado | 8003 | 130 | 3 |
249711 | 249711 | 2020-06-18 | Alamosa | Colorado | 8003 | 140 | 3 |
252826 | 252826 | 2020-06-19 | Alamosa | Colorado | 8003 | 150 | 3 |
255945 | 255945 | 2020-06-20 | Alamosa | Colorado | 8003 | 159 | 3 |
259072 | 259072 | 2020-06-21 | Alamosa | Colorado | 8003 | 168 | 3 |
262199 | 262199 | 2020-06-22 | Alamosa | Colorado | 8003 | 169 | 3 |
265327 | 265327 | 2020-06-23 | Alamosa | Colorado | 8003 | 175 | 3 |
268457 | 268457 | 2020-06-24 | Alamosa | Colorado | 8003 | 177 | 3 |
271592 | 271592 | 2020-06-25 | Alamosa | Colorado | 8003 | 178 | 3 |
274732 | 274732 | 2020-06-26 | Alamosa | Colorado | 8003 | 181 | 3 |
277880 | 277880 | 2020-06-27 | Alamosa | Colorado | 8003 | 184 | 3 |
281027 | 281027 | 2020-06-28 | Alamosa | Colorado | 8003 | 187 | 3 |
284173 | 284173 | 2020-06-29 | Alamosa | Colorado | 8003 | 188 | 3 |
287319 | 287319 | 2020-06-30 | Alamosa | Colorado | 8003 | 191 | 3 |
290470 | 290470 | 2020-07-01 | Alamosa | Colorado | 8003 | 197 | 4 |
293624 | 293624 | 2020-07-02 | Alamosa | Colorado | 8003 | 199 | 4 |
296780 | 296780 | 2020-07-03 | Alamosa | Colorado | 8003 | 199 | 4 |
299942 | 299942 | 2020-07-04 | Alamosa | Colorado | 8003 | 200 | 4 |
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);