ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 8025 and state = "Colorado" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4491 | 4491 | 2020-03-19 | Crowley | Colorado | 8025 | 1 | 1 |
5267 | 5267 | 2020-03-20 | Crowley | Colorado | 8025 | 1 | 1 |
6191 | 6191 | 2020-03-21 | Crowley | Colorado | 8025 | 1 | 1 |
7226 | 7226 | 2020-03-22 | Crowley | Colorado | 8025 | 1 | 1 |
8369 | 8369 | 2020-03-23 | Crowley | Colorado | 8025 | 1 | 1 |
9611 | 9611 | 2020-03-24 | Crowley | Colorado | 8025 | 1 | 1 |
10984 | 10984 | 2020-03-25 | Crowley | Colorado | 8025 | 1 | 1 |
12529 | 12529 | 2020-03-26 | Crowley | Colorado | 8025 | 1 | 1 |
14197 | 14197 | 2020-03-27 | Crowley | Colorado | 8025 | 1 | 1 |
15980 | 15980 | 2020-03-28 | Crowley | Colorado | 8025 | 1 | 1 |
17870 | 17870 | 2020-03-29 | Crowley | Colorado | 8025 | 1 | 1 |
19848 | 19848 | 2020-03-30 | Crowley | Colorado | 8025 | 1 | 1 |
21923 | 21923 | 2020-03-31 | Crowley | Colorado | 8025 | 1 | 1 |
24082 | 24082 | 2020-04-01 | Crowley | Colorado | 8025 | 1 | 1 |
26311 | 26311 | 2020-04-02 | Crowley | Colorado | 8025 | 1 | 1 |
28611 | 28611 | 2020-04-03 | Crowley | Colorado | 8025 | 1 | 1 |
30968 | 30968 | 2020-04-04 | Crowley | Colorado | 8025 | 1 | 1 |
33374 | 33374 | 2020-04-05 | Crowley | Colorado | 8025 | 1 | 1 |
35819 | 35819 | 2020-04-06 | Crowley | Colorado | 8025 | 1 | 1 |
38309 | 38309 | 2020-04-07 | Crowley | Colorado | 8025 | 1 | 1 |
40852 | 40852 | 2020-04-08 | Crowley | Colorado | 8025 | 1 | 1 |
43424 | 43424 | 2020-04-09 | Crowley | Colorado | 8025 | 1 | 1 |
46024 | 46024 | 2020-04-10 | Crowley | Colorado | 8025 | 1 | 1 |
48654 | 48654 | 2020-04-11 | Crowley | Colorado | 8025 | 2 | 1 |
51316 | 51316 | 2020-04-12 | Crowley | Colorado | 8025 | 2 | 1 |
53995 | 53995 | 2020-04-13 | Crowley | Colorado | 8025 | 2 | 1 |
56687 | 56687 | 2020-04-14 | Crowley | Colorado | 8025 | 2 | 1 |
59395 | 59395 | 2020-04-15 | Crowley | Colorado | 8025 | 2 | 1 |
62114 | 62114 | 2020-04-16 | Crowley | Colorado | 8025 | 2 | 1 |
64847 | 64847 | 2020-04-17 | Crowley | Colorado | 8025 | 2 | 1 |
67595 | 67595 | 2020-04-18 | Crowley | Colorado | 8025 | 2 | 1 |
70357 | 70357 | 2020-04-19 | Crowley | Colorado | 8025 | 2 | 1 |
73126 | 73126 | 2020-04-20 | Crowley | Colorado | 8025 | 2 | 1 |
75902 | 75902 | 2020-04-21 | Crowley | Colorado | 8025 | 2 | 1 |
78686 | 78686 | 2020-04-22 | Crowley | Colorado | 8025 | 2 | 1 |
81480 | 81480 | 2020-04-23 | Crowley | Colorado | 8025 | 2 | 1 |
84280 | 84280 | 2020-04-24 | Crowley | Colorado | 8025 | 2 | 1 |
87088 | 87088 | 2020-04-25 | Crowley | Colorado | 8025 | 2 | 1 |
89905 | 89905 | 2020-04-26 | Crowley | Colorado | 8025 | 2 | 1 |
92723 | 92723 | 2020-04-27 | Crowley | Colorado | 8025 | 2 | 1 |
95555 | 95555 | 2020-04-28 | Crowley | Colorado | 8025 | 2 | 1 |
98400 | 98400 | 2020-04-29 | Crowley | Colorado | 8025 | 2 | 1 |
101250 | 101250 | 2020-04-30 | Crowley | Colorado | 8025 | 2 | 1 |
104105 | 104105 | 2020-05-01 | Crowley | Colorado | 8025 | 3 | 1 |
106970 | 106970 | 2020-05-02 | Crowley | Colorado | 8025 | 3 | 1 |
109839 | 109839 | 2020-05-03 | Crowley | Colorado | 8025 | 4 | 1 |
112714 | 112714 | 2020-05-04 | Crowley | Colorado | 8025 | 4 | 1 |
115597 | 115597 | 2020-05-05 | Crowley | Colorado | 8025 | 4 | 1 |
118556 | 118556 | 2020-05-06 | Crowley | Colorado | 8025 | 4 | 1 |
121525 | 121525 | 2020-05-07 | Crowley | Colorado | 8025 | 4 | 1 |
124505 | 124505 | 2020-05-08 | Crowley | Colorado | 8025 | 25 | 1 |
127491 | 127491 | 2020-05-09 | Crowley | Colorado | 8025 | 39 | 1 |
130482 | 130482 | 2020-05-10 | Crowley | Colorado | 8025 | 39 | 1 |
133473 | 133473 | 2020-05-11 | Crowley | Colorado | 8025 | 39 | 1 |
136462 | 136462 | 2020-05-12 | Crowley | Colorado | 8025 | 39 | 1 |
139453 | 139453 | 2020-05-13 | Crowley | Colorado | 8025 | 39 | 1 |
142449 | 142449 | 2020-05-14 | Crowley | Colorado | 8025 | 39 | 1 |
145449 | 145449 | 2020-05-15 | Crowley | Colorado | 8025 | 39 | 1 |
148452 | 148452 | 2020-05-16 | Crowley | Colorado | 8025 | 39 | 1 |
151461 | 151461 | 2020-05-17 | Crowley | Colorado | 8025 | 39 | 1 |
154473 | 154473 | 2020-05-18 | Crowley | Colorado | 8025 | 39 | 1 |
157489 | 157489 | 2020-05-19 | Crowley | Colorado | 8025 | 39 | 1 |
160515 | 160515 | 2020-05-20 | Crowley | Colorado | 8025 | 42 | 1 |
163543 | 163543 | 2020-05-21 | Crowley | Colorado | 8025 | 43 | 1 |
166576 | 166576 | 2020-05-22 | Crowley | Colorado | 8025 | 44 | 1 |
169613 | 169613 | 2020-05-23 | Crowley | Colorado | 8025 | 57 | 1 |
172654 | 172654 | 2020-05-24 | Crowley | Colorado | 8025 | 62 | 1 |
175698 | 175698 | 2020-05-25 | Crowley | Colorado | 8025 | 63 | 1 |
178742 | 178742 | 2020-05-26 | Crowley | Colorado | 8025 | 63 | 1 |
181786 | 181786 | 2020-05-27 | Crowley | Colorado | 8025 | 63 | 1 |
184840 | 184840 | 2020-05-28 | Crowley | Colorado | 8025 | 63 | 1 |
187896 | 187896 | 2020-05-29 | Crowley | Colorado | 8025 | 63 | 1 |
190961 | 190961 | 2020-05-30 | Crowley | Colorado | 8025 | 64 | 1 |
194028 | 194028 | 2020-05-31 | Crowley | Colorado | 8025 | 64 | 1 |
197098 | 197098 | 2020-06-01 | Crowley | Colorado | 8025 | 64 | 1 |
200171 | 200171 | 2020-06-02 | Crowley | Colorado | 8025 | 64 | 1 |
203247 | 203247 | 2020-06-03 | Crowley | Colorado | 8025 | 64 | 1 |
206327 | 206327 | 2020-06-04 | Crowley | Colorado | 8025 | 64 | 1 |
209408 | 209408 | 2020-06-05 | Crowley | Colorado | 8025 | 66 | 1 |
212493 | 212493 | 2020-06-06 | Crowley | Colorado | 8025 | 66 | 1 |
215580 | 215580 | 2020-06-07 | Crowley | Colorado | 8025 | 66 | 1 |
218671 | 218671 | 2020-06-08 | Crowley | Colorado | 8025 | 66 | 1 |
221766 | 221766 | 2020-06-09 | Crowley | Colorado | 8025 | 66 | 1 |
224861 | 224861 | 2020-06-10 | Crowley | Colorado | 8025 | 66 | 1 |
227963 | 227963 | 2020-06-11 | Crowley | Colorado | 8025 | 66 | 1 |
231066 | 231066 | 2020-06-12 | Crowley | Colorado | 8025 | 66 | 1 |
234172 | 234172 | 2020-06-13 | Crowley | Colorado | 8025 | 66 | 1 |
237279 | 237279 | 2020-06-14 | Crowley | Colorado | 8025 | 67 | 1 |
240387 | 240387 | 2020-06-15 | Crowley | Colorado | 8025 | 68 | 1 |
243498 | 243498 | 2020-06-16 | Crowley | Colorado | 8025 | 68 | 1 |
246611 | 246611 | 2020-06-17 | Crowley | Colorado | 8025 | 68 | 1 |
249723 | 249723 | 2020-06-18 | Crowley | Colorado | 8025 | 68 | 1 |
252838 | 252838 | 2020-06-19 | Crowley | Colorado | 8025 | 68 | 1 |
255957 | 255957 | 2020-06-20 | Crowley | Colorado | 8025 | 68 | 1 |
259084 | 259084 | 2020-06-21 | Crowley | Colorado | 8025 | 68 | 1 |
262211 | 262211 | 2020-06-22 | Crowley | Colorado | 8025 | 69 | 1 |
265339 | 265339 | 2020-06-23 | Crowley | Colorado | 8025 | 69 | 1 |
268469 | 268469 | 2020-06-24 | Crowley | Colorado | 8025 | 69 | 1 |
271604 | 271604 | 2020-06-25 | Crowley | Colorado | 8025 | 69 | 1 |
274744 | 274744 | 2020-06-26 | Crowley | Colorado | 8025 | 70 | 1 |
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);