ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Montezuma" and state = "Colorado" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
17892 | 17892 | 2020-03-29 | Montezuma | Colorado | 8083 | 1 | 0 |
19870 | 19870 | 2020-03-30 | Montezuma | Colorado | 8083 | 1 | 0 |
21946 | 21946 | 2020-03-31 | Montezuma | Colorado | 8083 | 1 | 0 |
24105 | 24105 | 2020-04-01 | Montezuma | Colorado | 8083 | 1 | 0 |
26335 | 26335 | 2020-04-02 | Montezuma | Colorado | 8083 | 3 | 1 |
28636 | 28636 | 2020-04-03 | Montezuma | Colorado | 8083 | 3 | 1 |
30993 | 30993 | 2020-04-04 | Montezuma | Colorado | 8083 | 6 | 1 |
33399 | 33399 | 2020-04-05 | Montezuma | Colorado | 8083 | 8 | 1 |
35844 | 35844 | 2020-04-06 | Montezuma | Colorado | 8083 | 8 | 1 |
38334 | 38334 | 2020-04-07 | Montezuma | Colorado | 8083 | 8 | 1 |
40877 | 40877 | 2020-04-08 | Montezuma | Colorado | 8083 | 8 | 1 |
43450 | 43450 | 2020-04-09 | Montezuma | Colorado | 8083 | 8 | 1 |
46050 | 46050 | 2020-04-10 | Montezuma | Colorado | 8083 | 12 | 2 |
48680 | 48680 | 2020-04-11 | Montezuma | Colorado | 8083 | 11 | 2 |
51342 | 51342 | 2020-04-12 | Montezuma | Colorado | 8083 | 12 | 2 |
54021 | 54021 | 2020-04-13 | Montezuma | Colorado | 8083 | 12 | 2 |
56713 | 56713 | 2020-04-14 | Montezuma | Colorado | 8083 | 12 | 2 |
59421 | 59421 | 2020-04-15 | Montezuma | Colorado | 8083 | 12 | 2 |
62140 | 62140 | 2020-04-16 | Montezuma | Colorado | 8083 | 13 | 2 |
64873 | 64873 | 2020-04-17 | Montezuma | Colorado | 8083 | 13 | 2 |
67621 | 67621 | 2020-04-18 | Montezuma | Colorado | 8083 | 13 | 2 |
70383 | 70383 | 2020-04-19 | Montezuma | Colorado | 8083 | 13 | 2 |
73152 | 73152 | 2020-04-20 | Montezuma | Colorado | 8083 | 13 | 2 |
75928 | 75928 | 2020-04-21 | Montezuma | Colorado | 8083 | 13 | 2 |
78712 | 78712 | 2020-04-22 | Montezuma | Colorado | 8083 | 13 | 2 |
81506 | 81506 | 2020-04-23 | Montezuma | Colorado | 8083 | 15 | 2 |
84306 | 84306 | 2020-04-24 | Montezuma | Colorado | 8083 | 15 | 2 |
87114 | 87114 | 2020-04-25 | Montezuma | Colorado | 8083 | 15 | 2 |
89931 | 89931 | 2020-04-26 | Montezuma | Colorado | 8083 | 15 | 2 |
92749 | 92749 | 2020-04-27 | Montezuma | Colorado | 8083 | 15 | 2 |
95581 | 95581 | 2020-04-28 | Montezuma | Colorado | 8083 | 15 | 2 |
98426 | 98426 | 2020-04-29 | Montezuma | Colorado | 8083 | 16 | 2 |
101276 | 101276 | 2020-04-30 | Montezuma | Colorado | 8083 | 16 | 2 |
104131 | 104131 | 2020-05-01 | Montezuma | Colorado | 8083 | 16 | 2 |
106996 | 106996 | 2020-05-02 | Montezuma | Colorado | 8083 | 16 | 2 |
109865 | 109865 | 2020-05-03 | Montezuma | Colorado | 8083 | 17 | 2 |
112740 | 112740 | 2020-05-04 | Montezuma | Colorado | 8083 | 18 | 2 |
115623 | 115623 | 2020-05-05 | Montezuma | Colorado | 8083 | 18 | 2 |
118582 | 118582 | 2020-05-06 | Montezuma | Colorado | 8083 | 19 | 2 |
121551 | 121551 | 2020-05-07 | Montezuma | Colorado | 8083 | 21 | 2 |
124531 | 124531 | 2020-05-08 | Montezuma | Colorado | 8083 | 23 | 2 |
127517 | 127517 | 2020-05-09 | Montezuma | Colorado | 8083 | 23 | 2 |
130508 | 130508 | 2020-05-10 | Montezuma | Colorado | 8083 | 23 | 2 |
133499 | 133499 | 2020-05-11 | Montezuma | Colorado | 8083 | 24 | 3 |
136488 | 136488 | 2020-05-12 | Montezuma | Colorado | 8083 | 25 | 3 |
139479 | 139479 | 2020-05-13 | Montezuma | Colorado | 8083 | 25 | 3 |
142475 | 142475 | 2020-05-14 | Montezuma | Colorado | 8083 | 25 | 3 |
145475 | 145475 | 2020-05-15 | Montezuma | Colorado | 8083 | 26 | 3 |
148478 | 148478 | 2020-05-16 | Montezuma | Colorado | 8083 | 27 | 3 |
151487 | 151487 | 2020-05-17 | Montezuma | Colorado | 8083 | 27 | 3 |
154499 | 154499 | 2020-05-18 | Montezuma | Colorado | 8083 | 27 | 3 |
157515 | 157515 | 2020-05-19 | Montezuma | Colorado | 8083 | 29 | 3 |
160541 | 160541 | 2020-05-20 | Montezuma | Colorado | 8083 | 30 | 3 |
163569 | 163569 | 2020-05-21 | Montezuma | Colorado | 8083 | 30 | 3 |
166602 | 166602 | 2020-05-22 | Montezuma | Colorado | 8083 | 35 | 3 |
169639 | 169639 | 2020-05-23 | Montezuma | Colorado | 8083 | 35 | 3 |
172680 | 172680 | 2020-05-24 | Montezuma | Colorado | 8083 | 35 | 3 |
175724 | 175724 | 2020-05-25 | Montezuma | Colorado | 8083 | 36 | 3 |
178768 | 178768 | 2020-05-26 | Montezuma | Colorado | 8083 | 36 | 3 |
181812 | 181812 | 2020-05-27 | Montezuma | Colorado | 8083 | 36 | 3 |
184866 | 184866 | 2020-05-28 | Montezuma | Colorado | 8083 | 37 | 3 |
187922 | 187922 | 2020-05-29 | Montezuma | Colorado | 8083 | 39 | 3 |
190987 | 190987 | 2020-05-30 | Montezuma | Colorado | 8083 | 43 | 3 |
194054 | 194054 | 2020-05-31 | Montezuma | Colorado | 8083 | 45 | 3 |
197124 | 197124 | 2020-06-01 | Montezuma | Colorado | 8083 | 46 | 3 |
200197 | 200197 | 2020-06-02 | Montezuma | Colorado | 8083 | 46 | 3 |
203273 | 203273 | 2020-06-03 | Montezuma | Colorado | 8083 | 46 | 3 |
206353 | 206353 | 2020-06-04 | Montezuma | Colorado | 8083 | 46 | 3 |
209434 | 209434 | 2020-06-05 | Montezuma | Colorado | 8083 | 46 | 3 |
212519 | 212519 | 2020-06-06 | Montezuma | Colorado | 8083 | 50 | 3 |
215606 | 215606 | 2020-06-07 | Montezuma | Colorado | 8083 | 57 | 3 |
218697 | 218697 | 2020-06-08 | Montezuma | Colorado | 8083 | 57 | 3 |
221792 | 221792 | 2020-06-09 | Montezuma | Colorado | 8083 | 58 | 3 |
224887 | 224887 | 2020-06-10 | Montezuma | Colorado | 8083 | 58 | 3 |
227989 | 227989 | 2020-06-11 | Montezuma | Colorado | 8083 | 58 | 3 |
231092 | 231092 | 2020-06-12 | Montezuma | Colorado | 8083 | 59 | 3 |
234198 | 234198 | 2020-06-13 | Montezuma | Colorado | 8083 | 59 | 3 |
237305 | 237305 | 2020-06-14 | Montezuma | Colorado | 8083 | 60 | 3 |
240413 | 240413 | 2020-06-15 | Montezuma | Colorado | 8083 | 62 | 3 |
243524 | 243524 | 2020-06-16 | Montezuma | Colorado | 8083 | 65 | 3 |
246637 | 246637 | 2020-06-17 | Montezuma | Colorado | 8083 | 65 | 3 |
249749 | 249749 | 2020-06-18 | Montezuma | Colorado | 8083 | 66 | 3 |
252864 | 252864 | 2020-06-19 | Montezuma | Colorado | 8083 | 67 | 3 |
255983 | 255983 | 2020-06-20 | Montezuma | Colorado | 8083 | 67 | 3 |
259110 | 259110 | 2020-06-21 | Montezuma | Colorado | 8083 | 67 | 3 |
262237 | 262237 | 2020-06-22 | Montezuma | Colorado | 8083 | 68 | 3 |
265365 | 265365 | 2020-06-23 | Montezuma | Colorado | 8083 | 68 | 3 |
268495 | 268495 | 2020-06-24 | Montezuma | Colorado | 8083 | 68 | 3 |
271631 | 271631 | 2020-06-25 | Montezuma | Colorado | 8083 | 69 | 3 |
274771 | 274771 | 2020-06-26 | Montezuma | Colorado | 8083 | 69 | 3 |
277919 | 277919 | 2020-06-27 | Montezuma | Colorado | 8083 | 70 | 3 |
281066 | 281066 | 2020-06-28 | Montezuma | Colorado | 8083 | 70 | 3 |
284212 | 284212 | 2020-06-29 | Montezuma | Colorado | 8083 | 71 | 3 |
287358 | 287358 | 2020-06-30 | Montezuma | Colorado | 8083 | 72 | 3 |
290509 | 290509 | 2020-07-01 | Montezuma | Colorado | 8083 | 72 | 3 |
293663 | 293663 | 2020-07-02 | Montezuma | Colorado | 8083 | 71 | 3 |
296819 | 296819 | 2020-07-03 | Montezuma | Colorado | 8083 | 72 | 3 |
299981 | 299981 | 2020-07-04 | Montezuma | Colorado | 8083 | 73 | 3 |
303145 | 303145 | 2020-07-05 | Montezuma | Colorado | 8083 | 73 | 3 |
306309 | 306309 | 2020-07-06 | Montezuma | Colorado | 8083 | 74 | 3 |
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);