ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Baca" 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 |
---|---|---|---|---|---|---|---|
15974 | 15974 | 2020-03-28 | Baca | Colorado | 8009 | 1 | 0 |
17864 | 17864 | 2020-03-29 | Baca | Colorado | 8009 | 1 | 0 |
19842 | 19842 | 2020-03-30 | Baca | Colorado | 8009 | 1 | 0 |
21917 | 21917 | 2020-03-31 | Baca | Colorado | 8009 | 3 | 0 |
24076 | 24076 | 2020-04-01 | Baca | Colorado | 8009 | 3 | 0 |
26305 | 26305 | 2020-04-02 | Baca | Colorado | 8009 | 9 | 0 |
28605 | 28605 | 2020-04-03 | Baca | Colorado | 8009 | 9 | 0 |
30962 | 30962 | 2020-04-04 | Baca | Colorado | 8009 | 9 | 0 |
33368 | 33368 | 2020-04-05 | Baca | Colorado | 8009 | 9 | 0 |
35813 | 35813 | 2020-04-06 | Baca | Colorado | 8009 | 9 | 0 |
38303 | 38303 | 2020-04-07 | Baca | Colorado | 8009 | 9 | 0 |
40846 | 40846 | 2020-04-08 | Baca | Colorado | 8009 | 9 | 0 |
43418 | 43418 | 2020-04-09 | Baca | Colorado | 8009 | 9 | 0 |
46018 | 46018 | 2020-04-10 | Baca | Colorado | 8009 | 9 | 0 |
48648 | 48648 | 2020-04-11 | Baca | Colorado | 8009 | 10 | 0 |
51310 | 51310 | 2020-04-12 | Baca | Colorado | 8009 | 10 | 0 |
53989 | 53989 | 2020-04-13 | Baca | Colorado | 8009 | 10 | 0 |
56681 | 56681 | 2020-04-14 | Baca | Colorado | 8009 | 10 | 0 |
59389 | 59389 | 2020-04-15 | Baca | Colorado | 8009 | 10 | 0 |
62108 | 62108 | 2020-04-16 | Baca | Colorado | 8009 | 10 | 0 |
64841 | 64841 | 2020-04-17 | Baca | Colorado | 8009 | 10 | 0 |
67589 | 67589 | 2020-04-18 | Baca | Colorado | 8009 | 10 | 0 |
70351 | 70351 | 2020-04-19 | Baca | Colorado | 8009 | 10 | 0 |
73120 | 73120 | 2020-04-20 | Baca | Colorado | 8009 | 10 | 0 |
75896 | 75896 | 2020-04-21 | Baca | Colorado | 8009 | 10 | 0 |
78680 | 78680 | 2020-04-22 | Baca | Colorado | 8009 | 10 | 0 |
81474 | 81474 | 2020-04-23 | Baca | Colorado | 8009 | 10 | 0 |
84274 | 84274 | 2020-04-24 | Baca | Colorado | 8009 | 10 | 0 |
87082 | 87082 | 2020-04-25 | Baca | Colorado | 8009 | 10 | 0 |
89899 | 89899 | 2020-04-26 | Baca | Colorado | 8009 | 10 | 0 |
92717 | 92717 | 2020-04-27 | Baca | Colorado | 8009 | 10 | 0 |
95549 | 95549 | 2020-04-28 | Baca | Colorado | 8009 | 10 | 0 |
98394 | 98394 | 2020-04-29 | Baca | Colorado | 8009 | 10 | 0 |
101244 | 101244 | 2020-04-30 | Baca | Colorado | 8009 | 10 | 0 |
104099 | 104099 | 2020-05-01 | Baca | Colorado | 8009 | 10 | 0 |
106964 | 106964 | 2020-05-02 | Baca | Colorado | 8009 | 10 | 0 |
109833 | 109833 | 2020-05-03 | Baca | Colorado | 8009 | 12 | 0 |
112708 | 112708 | 2020-05-04 | Baca | Colorado | 8009 | 12 | 0 |
115591 | 115591 | 2020-05-05 | Baca | Colorado | 8009 | 12 | 0 |
118550 | 118550 | 2020-05-06 | Baca | Colorado | 8009 | 12 | 0 |
121517 | 121517 | 2020-05-07 | Baca | Colorado | 8009 | 12 | 0 |
124497 | 124497 | 2020-05-08 | Baca | Colorado | 8009 | 12 | 0 |
127483 | 127483 | 2020-05-09 | Baca | Colorado | 8009 | 12 | 0 |
130473 | 130473 | 2020-05-10 | Baca | Colorado | 8009 | 12 | 0 |
133464 | 133464 | 2020-05-11 | Baca | Colorado | 8009 | 12 | 0 |
136453 | 136453 | 2020-05-12 | Baca | Colorado | 8009 | 12 | 0 |
139444 | 139444 | 2020-05-13 | Baca | Colorado | 8009 | 12 | 0 |
142440 | 142440 | 2020-05-14 | Baca | Colorado | 8009 | 12 | 0 |
145440 | 145440 | 2020-05-15 | Baca | Colorado | 8009 | 12 | 0 |
148443 | 148443 | 2020-05-16 | Baca | Colorado | 8009 | 12 | 0 |
151452 | 151452 | 2020-05-17 | Baca | Colorado | 8009 | 12 | 0 |
154464 | 154464 | 2020-05-18 | Baca | Colorado | 8009 | 12 | 0 |
157480 | 157480 | 2020-05-19 | Baca | Colorado | 8009 | 12 | 0 |
160506 | 160506 | 2020-05-20 | Baca | Colorado | 8009 | 12 | 0 |
163534 | 163534 | 2020-05-21 | Baca | Colorado | 8009 | 12 | 0 |
166567 | 166567 | 2020-05-22 | Baca | Colorado | 8009 | 12 | 0 |
169604 | 169604 | 2020-05-23 | Baca | Colorado | 8009 | 12 | 0 |
172645 | 172645 | 2020-05-24 | Baca | Colorado | 8009 | 12 | 0 |
175689 | 175689 | 2020-05-25 | Baca | Colorado | 8009 | 12 | 0 |
178733 | 178733 | 2020-05-26 | Baca | Colorado | 8009 | 12 | 0 |
181777 | 181777 | 2020-05-27 | Baca | Colorado | 8009 | 12 | 0 |
184831 | 184831 | 2020-05-28 | Baca | Colorado | 8009 | 12 | 0 |
187887 | 187887 | 2020-05-29 | Baca | Colorado | 8009 | 12 | 0 |
190952 | 190952 | 2020-05-30 | Baca | Colorado | 8009 | 12 | 0 |
194019 | 194019 | 2020-05-31 | Baca | Colorado | 8009 | 12 | 0 |
197089 | 197089 | 2020-06-01 | Baca | Colorado | 8009 | 12 | 0 |
200162 | 200162 | 2020-06-02 | Baca | Colorado | 8009 | 12 | 0 |
203238 | 203238 | 2020-06-03 | Baca | Colorado | 8009 | 12 | 0 |
206318 | 206318 | 2020-06-04 | Baca | Colorado | 8009 | 12 | 0 |
209399 | 209399 | 2020-06-05 | Baca | Colorado | 8009 | 12 | 0 |
212484 | 212484 | 2020-06-06 | Baca | Colorado | 8009 | 12 | 0 |
215571 | 215571 | 2020-06-07 | Baca | Colorado | 8009 | 12 | 0 |
218662 | 218662 | 2020-06-08 | Baca | Colorado | 8009 | 12 | 0 |
221757 | 221757 | 2020-06-09 | Baca | Colorado | 8009 | 12 | 0 |
224852 | 224852 | 2020-06-10 | Baca | Colorado | 8009 | 12 | 0 |
227954 | 227954 | 2020-06-11 | Baca | Colorado | 8009 | 12 | 0 |
231057 | 231057 | 2020-06-12 | Baca | Colorado | 8009 | 12 | 0 |
234163 | 234163 | 2020-06-13 | Baca | Colorado | 8009 | 12 | 0 |
237270 | 237270 | 2020-06-14 | Baca | Colorado | 8009 | 12 | 0 |
240378 | 240378 | 2020-06-15 | Baca | Colorado | 8009 | 12 | 0 |
243489 | 243489 | 2020-06-16 | Baca | Colorado | 8009 | 12 | 0 |
246602 | 246602 | 2020-06-17 | Baca | Colorado | 8009 | 12 | 0 |
249714 | 249714 | 2020-06-18 | Baca | Colorado | 8009 | 12 | 0 |
252829 | 252829 | 2020-06-19 | Baca | Colorado | 8009 | 12 | 0 |
255948 | 255948 | 2020-06-20 | Baca | Colorado | 8009 | 12 | 0 |
259075 | 259075 | 2020-06-21 | Baca | Colorado | 8009 | 12 | 0 |
262202 | 262202 | 2020-06-22 | Baca | Colorado | 8009 | 12 | 0 |
265330 | 265330 | 2020-06-23 | Baca | Colorado | 8009 | 12 | 0 |
268460 | 268460 | 2020-06-24 | Baca | Colorado | 8009 | 12 | 0 |
271595 | 271595 | 2020-06-25 | Baca | Colorado | 8009 | 13 | 0 |
274735 | 274735 | 2020-06-26 | Baca | Colorado | 8009 | 13 | 0 |
277883 | 277883 | 2020-06-27 | Baca | Colorado | 8009 | 13 | 0 |
281030 | 281030 | 2020-06-28 | Baca | Colorado | 8009 | 13 | 0 |
284176 | 284176 | 2020-06-29 | Baca | Colorado | 8009 | 14 | 0 |
287322 | 287322 | 2020-06-30 | Baca | Colorado | 8009 | 14 | 0 |
290473 | 290473 | 2020-07-01 | Baca | Colorado | 8009 | 14 | 0 |
293627 | 293627 | 2020-07-02 | Baca | Colorado | 8009 | 14 | 0 |
296783 | 296783 | 2020-07-03 | Baca | Colorado | 8009 | 14 | 0 |
299945 | 299945 | 2020-07-04 | Baca | Colorado | 8009 | 14 | 0 |
303109 | 303109 | 2020-07-05 | Baca | Colorado | 8009 | 14 | 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);