ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 8067 and state = "Colorado" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
8380 | 8380 | 2020-03-23 | La Plata | Colorado | 8067 | 1 | 0 |
9625 | 9625 | 2020-03-24 | La Plata | Colorado | 8067 | 1 | 0 |
10998 | 10998 | 2020-03-25 | La Plata | Colorado | 8067 | 1 | 0 |
12544 | 12544 | 2020-03-26 | La Plata | Colorado | 8067 | 5 | 0 |
14212 | 14212 | 2020-03-27 | La Plata | Colorado | 8067 | 13 | 0 |
15995 | 15995 | 2020-03-28 | La Plata | Colorado | 8067 | 17 | 0 |
17885 | 17885 | 2020-03-29 | La Plata | Colorado | 8067 | 21 | 0 |
19863 | 19863 | 2020-03-30 | La Plata | Colorado | 8067 | 21 | 0 |
21938 | 21938 | 2020-03-31 | La Plata | Colorado | 8067 | 23 | 0 |
24097 | 24097 | 2020-04-01 | La Plata | Colorado | 8067 | 23 | 0 |
26327 | 26327 | 2020-04-02 | La Plata | Colorado | 8067 | 24 | 0 |
28627 | 28627 | 2020-04-03 | La Plata | Colorado | 8067 | 25 | 0 |
30984 | 30984 | 2020-04-04 | La Plata | Colorado | 8067 | 25 | 0 |
33390 | 33390 | 2020-04-05 | La Plata | Colorado | 8067 | 31 | 0 |
35835 | 35835 | 2020-04-06 | La Plata | Colorado | 8067 | 32 | 0 |
38325 | 38325 | 2020-04-07 | La Plata | Colorado | 8067 | 34 | 0 |
40868 | 40868 | 2020-04-08 | La Plata | Colorado | 8067 | 34 | 0 |
43441 | 43441 | 2020-04-09 | La Plata | Colorado | 8067 | 37 | 0 |
46041 | 46041 | 2020-04-10 | La Plata | Colorado | 8067 | 44 | 0 |
48671 | 48671 | 2020-04-11 | La Plata | Colorado | 8067 | 43 | 0 |
51333 | 51333 | 2020-04-12 | La Plata | Colorado | 8067 | 44 | 0 |
54012 | 54012 | 2020-04-13 | La Plata | Colorado | 8067 | 44 | 0 |
56704 | 56704 | 2020-04-14 | La Plata | Colorado | 8067 | 44 | 0 |
59412 | 59412 | 2020-04-15 | La Plata | Colorado | 8067 | 46 | 0 |
62131 | 62131 | 2020-04-16 | La Plata | Colorado | 8067 | 47 | 0 |
64864 | 64864 | 2020-04-17 | La Plata | Colorado | 8067 | 51 | 0 |
67612 | 67612 | 2020-04-18 | La Plata | Colorado | 8067 | 52 | 0 |
70374 | 70374 | 2020-04-19 | La Plata | Colorado | 8067 | 52 | 0 |
73143 | 73143 | 2020-04-20 | La Plata | Colorado | 8067 | 51 | 0 |
75919 | 75919 | 2020-04-21 | La Plata | Colorado | 8067 | 51 | 0 |
78703 | 78703 | 2020-04-22 | La Plata | Colorado | 8067 | 53 | 0 |
81497 | 81497 | 2020-04-23 | La Plata | Colorado | 8067 | 55 | 0 |
84297 | 84297 | 2020-04-24 | La Plata | Colorado | 8067 | 56 | 0 |
87105 | 87105 | 2020-04-25 | La Plata | Colorado | 8067 | 59 | 0 |
89922 | 89922 | 2020-04-26 | La Plata | Colorado | 8067 | 59 | 0 |
92740 | 92740 | 2020-04-27 | La Plata | Colorado | 8067 | 59 | 0 |
95572 | 95572 | 2020-04-28 | La Plata | Colorado | 8067 | 59 | 0 |
98417 | 98417 | 2020-04-29 | La Plata | Colorado | 8067 | 62 | 0 |
101267 | 101267 | 2020-04-30 | La Plata | Colorado | 8067 | 62 | 0 |
104122 | 104122 | 2020-05-01 | La Plata | Colorado | 8067 | 63 | 0 |
106987 | 106987 | 2020-05-02 | La Plata | Colorado | 8067 | 63 | 0 |
109856 | 109856 | 2020-05-03 | La Plata | Colorado | 8067 | 63 | 0 |
112731 | 112731 | 2020-05-04 | La Plata | Colorado | 8067 | 63 | 0 |
115614 | 115614 | 2020-05-05 | La Plata | Colorado | 8067 | 63 | 0 |
118573 | 118573 | 2020-05-06 | La Plata | Colorado | 8067 | 63 | 0 |
121542 | 121542 | 2020-05-07 | La Plata | Colorado | 8067 | 63 | 0 |
124522 | 124522 | 2020-05-08 | La Plata | Colorado | 8067 | 64 | 0 |
127508 | 127508 | 2020-05-09 | La Plata | Colorado | 8067 | 65 | 1 |
130499 | 130499 | 2020-05-10 | La Plata | Colorado | 8067 | 65 | 1 |
133490 | 133490 | 2020-05-11 | La Plata | Colorado | 8067 | 65 | 1 |
136479 | 136479 | 2020-05-12 | La Plata | Colorado | 8067 | 66 | 1 |
139470 | 139470 | 2020-05-13 | La Plata | Colorado | 8067 | 66 | 1 |
142466 | 142466 | 2020-05-14 | La Plata | Colorado | 8067 | 66 | 1 |
145466 | 145466 | 2020-05-15 | La Plata | Colorado | 8067 | 66 | 1 |
148469 | 148469 | 2020-05-16 | La Plata | Colorado | 8067 | 68 | 1 |
151478 | 151478 | 2020-05-17 | La Plata | Colorado | 8067 | 68 | 1 |
154490 | 154490 | 2020-05-18 | La Plata | Colorado | 8067 | 68 | 1 |
157506 | 157506 | 2020-05-19 | La Plata | Colorado | 8067 | 72 | 1 |
160532 | 160532 | 2020-05-20 | La Plata | Colorado | 8067 | 72 | 1 |
163560 | 163560 | 2020-05-21 | La Plata | Colorado | 8067 | 83 | 1 |
166593 | 166593 | 2020-05-22 | La Plata | Colorado | 8067 | 73 | 1 |
169630 | 169630 | 2020-05-23 | La Plata | Colorado | 8067 | 76 | 1 |
172671 | 172671 | 2020-05-24 | La Plata | Colorado | 8067 | 77 | 1 |
175715 | 175715 | 2020-05-25 | La Plata | Colorado | 8067 | 77 | 1 |
178759 | 178759 | 2020-05-26 | La Plata | Colorado | 8067 | 79 | 1 |
181803 | 181803 | 2020-05-27 | La Plata | Colorado | 8067 | 77 | 1 |
184857 | 184857 | 2020-05-28 | La Plata | Colorado | 8067 | 77 | 1 |
187913 | 187913 | 2020-05-29 | La Plata | Colorado | 8067 | 80 | 1 |
190978 | 190978 | 2020-05-30 | La Plata | Colorado | 8067 | 80 | 1 |
194045 | 194045 | 2020-05-31 | La Plata | Colorado | 8067 | 81 | 1 |
197115 | 197115 | 2020-06-01 | La Plata | Colorado | 8067 | 82 | 1 |
200188 | 200188 | 2020-06-02 | La Plata | Colorado | 8067 | 82 | 1 |
203264 | 203264 | 2020-06-03 | La Plata | Colorado | 8067 | 82 | 1 |
206344 | 206344 | 2020-06-04 | La Plata | Colorado | 8067 | 82 | 1 |
209425 | 209425 | 2020-06-05 | La Plata | Colorado | 8067 | 82 | 1 |
212510 | 212510 | 2020-06-06 | La Plata | Colorado | 8067 | 82 | 1 |
215597 | 215597 | 2020-06-07 | La Plata | Colorado | 8067 | 82 | 1 |
218688 | 218688 | 2020-06-08 | La Plata | Colorado | 8067 | 82 | 1 |
221783 | 221783 | 2020-06-09 | La Plata | Colorado | 8067 | 84 | 1 |
224878 | 224878 | 2020-06-10 | La Plata | Colorado | 8067 | 84 | 1 |
227980 | 227980 | 2020-06-11 | La Plata | Colorado | 8067 | 84 | 1 |
231083 | 231083 | 2020-06-12 | La Plata | Colorado | 8067 | 84 | 1 |
234189 | 234189 | 2020-06-13 | La Plata | Colorado | 8067 | 84 | 1 |
237296 | 237296 | 2020-06-14 | La Plata | Colorado | 8067 | 84 | 1 |
240404 | 240404 | 2020-06-15 | La Plata | Colorado | 8067 | 85 | 1 |
243515 | 243515 | 2020-06-16 | La Plata | Colorado | 8067 | 86 | 1 |
246628 | 246628 | 2020-06-17 | La Plata | Colorado | 8067 | 85 | 1 |
249740 | 249740 | 2020-06-18 | La Plata | Colorado | 8067 | 86 | 1 |
252855 | 252855 | 2020-06-19 | La Plata | Colorado | 8067 | 85 | 1 |
255974 | 255974 | 2020-06-20 | La Plata | Colorado | 8067 | 86 | 1 |
259101 | 259101 | 2020-06-21 | La Plata | Colorado | 8067 | 86 | 1 |
262228 | 262228 | 2020-06-22 | La Plata | Colorado | 8067 | 86 | 1 |
265356 | 265356 | 2020-06-23 | La Plata | Colorado | 8067 | 88 | 1 |
268486 | 268486 | 2020-06-24 | La Plata | Colorado | 8067 | 89 | 1 |
271622 | 271622 | 2020-06-25 | La Plata | Colorado | 8067 | 90 | 1 |
274762 | 274762 | 2020-06-26 | La Plata | Colorado | 8067 | 94 | 1 |
277910 | 277910 | 2020-06-27 | La Plata | Colorado | 8067 | 94 | 1 |
281057 | 281057 | 2020-06-28 | La Plata | Colorado | 8067 | 101 | 1 |
284203 | 284203 | 2020-06-29 | La Plata | Colorado | 8067 | 106 | 1 |
287349 | 287349 | 2020-06-30 | La Plata | Colorado | 8067 | 112 | 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);