ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8014 and state = "Colorado" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5265 | 5265 | 2020-03-20 | Broomfield | Colorado | 8014 | 1 | 0 |
6188 | 6188 | 2020-03-21 | Broomfield | Colorado | 8014 | 1 | 0 |
7223 | 7223 | 2020-03-22 | Broomfield | Colorado | 8014 | 1 | 0 |
8366 | 8366 | 2020-03-23 | Broomfield | Colorado | 8014 | 2 | 0 |
9608 | 9608 | 2020-03-24 | Broomfield | Colorado | 8014 | 5 | 0 |
10981 | 10981 | 2020-03-25 | Broomfield | Colorado | 8014 | 8 | 0 |
12526 | 12526 | 2020-03-26 | Broomfield | Colorado | 8014 | 10 | 0 |
14193 | 14193 | 2020-03-27 | Broomfield | Colorado | 8014 | 13 | 0 |
15976 | 15976 | 2020-03-28 | Broomfield | Colorado | 8014 | 16 | 0 |
17866 | 17866 | 2020-03-29 | Broomfield | Colorado | 8014 | 17 | 0 |
19844 | 19844 | 2020-03-30 | Broomfield | Colorado | 8014 | 18 | 0 |
21919 | 21919 | 2020-03-31 | Broomfield | Colorado | 8014 | 20 | 1 |
24078 | 24078 | 2020-04-01 | Broomfield | Colorado | 8014 | 21 | 2 |
26307 | 26307 | 2020-04-02 | Broomfield | Colorado | 8014 | 30 | 2 |
28607 | 28607 | 2020-04-03 | Broomfield | Colorado | 8014 | 36 | 2 |
30964 | 30964 | 2020-04-04 | Broomfield | Colorado | 8014 | 44 | 2 |
33370 | 33370 | 2020-04-05 | Broomfield | Colorado | 8014 | 50 | 2 |
35815 | 35815 | 2020-04-06 | Broomfield | Colorado | 8014 | 50 | 2 |
38305 | 38305 | 2020-04-07 | Broomfield | Colorado | 8014 | 50 | 2 |
40848 | 40848 | 2020-04-08 | Broomfield | Colorado | 8014 | 52 | 2 |
43420 | 43420 | 2020-04-09 | Broomfield | Colorado | 8014 | 61 | 2 |
46020 | 46020 | 2020-04-10 | Broomfield | Colorado | 8014 | 68 | 2 |
48650 | 48650 | 2020-04-11 | Broomfield | Colorado | 8014 | 74 | 2 |
51312 | 51312 | 2020-04-12 | Broomfield | Colorado | 8014 | 81 | 2 |
53991 | 53991 | 2020-04-13 | Broomfield | Colorado | 8014 | 81 | 2 |
56683 | 56683 | 2020-04-14 | Broomfield | Colorado | 8014 | 88 | 2 |
59391 | 59391 | 2020-04-15 | Broomfield | Colorado | 8014 | 92 | 2 |
62110 | 62110 | 2020-04-16 | Broomfield | Colorado | 8014 | 95 | 2 |
64843 | 64843 | 2020-04-17 | Broomfield | Colorado | 8014 | 98 | 2 |
67591 | 67591 | 2020-04-18 | Broomfield | Colorado | 8014 | 101 | 2 |
70353 | 70353 | 2020-04-19 | Broomfield | Colorado | 8014 | 101 | 2 |
73122 | 73122 | 2020-04-20 | Broomfield | Colorado | 8014 | 103 | 2 |
75898 | 75898 | 2020-04-21 | Broomfield | Colorado | 8014 | 106 | 2 |
78682 | 78682 | 2020-04-22 | Broomfield | Colorado | 8014 | 110 | 3 |
81476 | 81476 | 2020-04-23 | Broomfield | Colorado | 8014 | 113 | 4 |
84276 | 84276 | 2020-04-24 | Broomfield | Colorado | 8014 | 126 | 5 |
87084 | 87084 | 2020-04-25 | Broomfield | Colorado | 8014 | 135 | 5 |
89901 | 89901 | 2020-04-26 | Broomfield | Colorado | 8014 | 139 | 5 |
92719 | 92719 | 2020-04-27 | Broomfield | Colorado | 8014 | 141 | 5 |
95551 | 95551 | 2020-04-28 | Broomfield | Colorado | 8014 | 145 | 9 |
98396 | 98396 | 2020-04-29 | Broomfield | Colorado | 8014 | 147 | 9 |
101246 | 101246 | 2020-04-30 | Broomfield | Colorado | 8014 | 150 | 9 |
104101 | 104101 | 2020-05-01 | Broomfield | Colorado | 8014 | 157 | 11 |
106966 | 106966 | 2020-05-02 | Broomfield | Colorado | 8014 | 163 | 12 |
109835 | 109835 | 2020-05-03 | Broomfield | Colorado | 8014 | 165 | 12 |
112710 | 112710 | 2020-05-04 | Broomfield | Colorado | 8014 | 167 | 12 |
115593 | 115593 | 2020-05-05 | Broomfield | Colorado | 8014 | 178 | 16 |
118552 | 118552 | 2020-05-06 | Broomfield | Colorado | 8014 | 180 | 16 |
121519 | 121519 | 2020-05-07 | Broomfield | Colorado | 8014 | 186 | 16 |
124499 | 124499 | 2020-05-08 | Broomfield | Colorado | 8014 | 191 | 16 |
127485 | 127485 | 2020-05-09 | Broomfield | Colorado | 8014 | 195 | 17 |
130476 | 130476 | 2020-05-10 | Broomfield | Colorado | 8014 | 198 | 17 |
133467 | 133467 | 2020-05-11 | Broomfield | Colorado | 8014 | 200 | 17 |
136456 | 136456 | 2020-05-12 | Broomfield | Colorado | 8014 | 201 | 20 |
139447 | 139447 | 2020-05-13 | Broomfield | Colorado | 8014 | 203 | 20 |
142443 | 142443 | 2020-05-14 | Broomfield | Colorado | 8014 | 204 | 22 |
145443 | 145443 | 2020-05-15 | Broomfield | Colorado | 8014 | 207 | 22 |
148446 | 148446 | 2020-05-16 | Broomfield | Colorado | 8014 | 209 | 22 |
151455 | 151455 | 2020-05-17 | Broomfield | Colorado | 8014 | 211 | 22 |
154467 | 154467 | 2020-05-18 | Broomfield | Colorado | 8014 | 213 | 22 |
157483 | 157483 | 2020-05-19 | Broomfield | Colorado | 8014 | 214 | 24 |
160509 | 160509 | 2020-05-20 | Broomfield | Colorado | 8014 | 215 | 24 |
163537 | 163537 | 2020-05-21 | Broomfield | Colorado | 8014 | 218 | 24 |
166570 | 166570 | 2020-05-22 | Broomfield | Colorado | 8014 | 220 | 25 |
169607 | 169607 | 2020-05-23 | Broomfield | Colorado | 8014 | 220 | 25 |
172648 | 172648 | 2020-05-24 | Broomfield | Colorado | 8014 | 220 | 25 |
175692 | 175692 | 2020-05-25 | Broomfield | Colorado | 8014 | 221 | 25 |
178736 | 178736 | 2020-05-26 | Broomfield | Colorado | 8014 | 224 | 26 |
181780 | 181780 | 2020-05-27 | Broomfield | Colorado | 8014 | 226 | 26 |
184834 | 184834 | 2020-05-28 | Broomfield | Colorado | 8014 | 227 | 26 |
187890 | 187890 | 2020-05-29 | Broomfield | Colorado | 8014 | 232 | 26 |
190955 | 190955 | 2020-05-30 | Broomfield | Colorado | 8014 | 236 | 26 |
194022 | 194022 | 2020-05-31 | Broomfield | Colorado | 8014 | 240 | 26 |
197092 | 197092 | 2020-06-01 | Broomfield | Colorado | 8014 | 242 | 27 |
200165 | 200165 | 2020-06-02 | Broomfield | Colorado | 8014 | 244 | 27 |
203241 | 203241 | 2020-06-03 | Broomfield | Colorado | 8014 | 245 | 27 |
206321 | 206321 | 2020-06-04 | Broomfield | Colorado | 8014 | 251 | 27 |
209402 | 209402 | 2020-06-05 | Broomfield | Colorado | 8014 | 252 | 27 |
212487 | 212487 | 2020-06-06 | Broomfield | Colorado | 8014 | 253 | 27 |
215574 | 215574 | 2020-06-07 | Broomfield | Colorado | 8014 | 255 | 27 |
218665 | 218665 | 2020-06-08 | Broomfield | Colorado | 8014 | 256 | 27 |
221760 | 221760 | 2020-06-09 | Broomfield | Colorado | 8014 | 258 | 27 |
224855 | 224855 | 2020-06-10 | Broomfield | Colorado | 8014 | 258 | 28 |
227957 | 227957 | 2020-06-11 | Broomfield | Colorado | 8014 | 259 | 28 |
231060 | 231060 | 2020-06-12 | Broomfield | Colorado | 8014 | 261 | 28 |
234166 | 234166 | 2020-06-13 | Broomfield | Colorado | 8014 | 264 | 28 |
237273 | 237273 | 2020-06-14 | Broomfield | Colorado | 8014 | 264 | 28 |
240381 | 240381 | 2020-06-15 | Broomfield | Colorado | 8014 | 265 | 28 |
243492 | 243492 | 2020-06-16 | Broomfield | Colorado | 8014 | 268 | 28 |
246605 | 246605 | 2020-06-17 | Broomfield | Colorado | 8014 | 270 | 28 |
249717 | 249717 | 2020-06-18 | Broomfield | Colorado | 8014 | 271 | 28 |
252832 | 252832 | 2020-06-19 | Broomfield | Colorado | 8014 | 274 | 28 |
255951 | 255951 | 2020-06-20 | Broomfield | Colorado | 8014 | 277 | 28 |
259078 | 259078 | 2020-06-21 | Broomfield | Colorado | 8014 | 278 | 28 |
262205 | 262205 | 2020-06-22 | Broomfield | Colorado | 8014 | 280 | 28 |
265333 | 265333 | 2020-06-23 | Broomfield | Colorado | 8014 | 282 | 29 |
268463 | 268463 | 2020-06-24 | Broomfield | Colorado | 8014 | 284 | 29 |
271598 | 271598 | 2020-06-25 | Broomfield | Colorado | 8014 | 287 | 29 |
274738 | 274738 | 2020-06-26 | Broomfield | Colorado | 8014 | 291 | 29 |
277886 | 277886 | 2020-06-27 | Broomfield | Colorado | 8014 | 291 | 29 |
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);