ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Fremont" and state = "Colorado" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9618 | 9618 | 2020-03-24 | Fremont | Colorado | 8043 | 1 | 0 |
10991 | 10991 | 2020-03-25 | Fremont | Colorado | 8043 | 1 | 0 |
12536 | 12536 | 2020-03-26 | Fremont | Colorado | 8043 | 1 | 0 |
14204 | 14204 | 2020-03-27 | Fremont | Colorado | 8043 | 1 | 0 |
15987 | 15987 | 2020-03-28 | Fremont | Colorado | 8043 | 1 | 0 |
17877 | 17877 | 2020-03-29 | Fremont | Colorado | 8043 | 1 | 0 |
19855 | 19855 | 2020-03-30 | Fremont | Colorado | 8043 | 2 | 0 |
21930 | 21930 | 2020-03-31 | Fremont | Colorado | 8043 | 2 | 0 |
24089 | 24089 | 2020-04-01 | Fremont | Colorado | 8043 | 2 | 0 |
26319 | 26319 | 2020-04-02 | Fremont | Colorado | 8043 | 2 | 0 |
28619 | 28619 | 2020-04-03 | Fremont | Colorado | 8043 | 2 | 0 |
30976 | 30976 | 2020-04-04 | Fremont | Colorado | 8043 | 3 | 0 |
33382 | 33382 | 2020-04-05 | Fremont | Colorado | 8043 | 3 | 0 |
35827 | 35827 | 2020-04-06 | Fremont | Colorado | 8043 | 3 | 0 |
38317 | 38317 | 2020-04-07 | Fremont | Colorado | 8043 | 4 | 0 |
40860 | 40860 | 2020-04-08 | Fremont | Colorado | 8043 | 4 | 0 |
43432 | 43432 | 2020-04-09 | Fremont | Colorado | 8043 | 5 | 0 |
46032 | 46032 | 2020-04-10 | Fremont | Colorado | 8043 | 5 | 0 |
48662 | 48662 | 2020-04-11 | Fremont | Colorado | 8043 | 6 | 0 |
51324 | 51324 | 2020-04-12 | Fremont | Colorado | 8043 | 7 | 0 |
54003 | 54003 | 2020-04-13 | Fremont | Colorado | 8043 | 8 | 0 |
56695 | 56695 | 2020-04-14 | Fremont | Colorado | 8043 | 8 | 0 |
59403 | 59403 | 2020-04-15 | Fremont | Colorado | 8043 | 9 | 0 |
62122 | 62122 | 2020-04-16 | Fremont | Colorado | 8043 | 9 | 0 |
64855 | 64855 | 2020-04-17 | Fremont | Colorado | 8043 | 9 | 0 |
67603 | 67603 | 2020-04-18 | Fremont | Colorado | 8043 | 9 | 0 |
70365 | 70365 | 2020-04-19 | Fremont | Colorado | 8043 | 10 | 0 |
73134 | 73134 | 2020-04-20 | Fremont | Colorado | 8043 | 11 | 0 |
75910 | 75910 | 2020-04-21 | Fremont | Colorado | 8043 | 11 | 0 |
78694 | 78694 | 2020-04-22 | Fremont | Colorado | 8043 | 19 | 0 |
81488 | 81488 | 2020-04-23 | Fremont | Colorado | 8043 | 19 | 0 |
84288 | 84288 | 2020-04-24 | Fremont | Colorado | 8043 | 19 | 0 |
87096 | 87096 | 2020-04-25 | Fremont | Colorado | 8043 | 20 | 0 |
89913 | 89913 | 2020-04-26 | Fremont | Colorado | 8043 | 22 | 0 |
92731 | 92731 | 2020-04-27 | Fremont | Colorado | 8043 | 22 | 0 |
95563 | 95563 | 2020-04-28 | Fremont | Colorado | 8043 | 22 | 0 |
98408 | 98408 | 2020-04-29 | Fremont | Colorado | 8043 | 22 | 0 |
101258 | 101258 | 2020-04-30 | Fremont | Colorado | 8043 | 22 | 0 |
104113 | 104113 | 2020-05-01 | Fremont | Colorado | 8043 | 22 | 0 |
106978 | 106978 | 2020-05-02 | Fremont | Colorado | 8043 | 22 | 0 |
109847 | 109847 | 2020-05-03 | Fremont | Colorado | 8043 | 22 | 0 |
112722 | 112722 | 2020-05-04 | Fremont | Colorado | 8043 | 22 | 0 |
115605 | 115605 | 2020-05-05 | Fremont | Colorado | 8043 | 22 | 0 |
118564 | 118564 | 2020-05-06 | Fremont | Colorado | 8043 | 22 | 0 |
121533 | 121533 | 2020-05-07 | Fremont | Colorado | 8043 | 23 | 0 |
124513 | 124513 | 2020-05-08 | Fremont | Colorado | 8043 | 23 | 0 |
127499 | 127499 | 2020-05-09 | Fremont | Colorado | 8043 | 23 | 0 |
130490 | 130490 | 2020-05-10 | Fremont | Colorado | 8043 | 23 | 0 |
133481 | 133481 | 2020-05-11 | Fremont | Colorado | 8043 | 23 | 0 |
136470 | 136470 | 2020-05-12 | Fremont | Colorado | 8043 | 23 | 0 |
139461 | 139461 | 2020-05-13 | Fremont | Colorado | 8043 | 23 | 0 |
142457 | 142457 | 2020-05-14 | Fremont | Colorado | 8043 | 25 | 0 |
145457 | 145457 | 2020-05-15 | Fremont | Colorado | 8043 | 25 | 0 |
148460 | 148460 | 2020-05-16 | Fremont | Colorado | 8043 | 25 | 0 |
151469 | 151469 | 2020-05-17 | Fremont | Colorado | 8043 | 25 | 0 |
154481 | 154481 | 2020-05-18 | Fremont | Colorado | 8043 | 25 | 0 |
157497 | 157497 | 2020-05-19 | Fremont | Colorado | 8043 | 25 | 0 |
160523 | 160523 | 2020-05-20 | Fremont | Colorado | 8043 | 25 | 0 |
163551 | 163551 | 2020-05-21 | Fremont | Colorado | 8043 | 26 | 0 |
166584 | 166584 | 2020-05-22 | Fremont | Colorado | 8043 | 26 | 0 |
169621 | 169621 | 2020-05-23 | Fremont | Colorado | 8043 | 26 | 0 |
172662 | 172662 | 2020-05-24 | Fremont | Colorado | 8043 | 26 | 0 |
175706 | 175706 | 2020-05-25 | Fremont | Colorado | 8043 | 26 | 0 |
178750 | 178750 | 2020-05-26 | Fremont | Colorado | 8043 | 26 | 0 |
181794 | 181794 | 2020-05-27 | Fremont | Colorado | 8043 | 26 | 0 |
184848 | 184848 | 2020-05-28 | Fremont | Colorado | 8043 | 26 | 0 |
187904 | 187904 | 2020-05-29 | Fremont | Colorado | 8043 | 26 | 0 |
190969 | 190969 | 2020-05-30 | Fremont | Colorado | 8043 | 26 | 0 |
194036 | 194036 | 2020-05-31 | Fremont | Colorado | 8043 | 26 | 0 |
197106 | 197106 | 2020-06-01 | Fremont | Colorado | 8043 | 26 | 0 |
200179 | 200179 | 2020-06-02 | Fremont | Colorado | 8043 | 27 | 0 |
203255 | 203255 | 2020-06-03 | Fremont | Colorado | 8043 | 26 | 0 |
206335 | 206335 | 2020-06-04 | Fremont | Colorado | 8043 | 26 | 0 |
209416 | 209416 | 2020-06-05 | Fremont | Colorado | 8043 | 26 | 0 |
212501 | 212501 | 2020-06-06 | Fremont | Colorado | 8043 | 26 | 0 |
215588 | 215588 | 2020-06-07 | Fremont | Colorado | 8043 | 26 | 0 |
218679 | 218679 | 2020-06-08 | Fremont | Colorado | 8043 | 26 | 0 |
221774 | 221774 | 2020-06-09 | Fremont | Colorado | 8043 | 26 | 0 |
224869 | 224869 | 2020-06-10 | Fremont | Colorado | 8043 | 26 | 0 |
227971 | 227971 | 2020-06-11 | Fremont | Colorado | 8043 | 26 | 0 |
231074 | 231074 | 2020-06-12 | Fremont | Colorado | 8043 | 26 | 0 |
234180 | 234180 | 2020-06-13 | Fremont | Colorado | 8043 | 29 | 0 |
237287 | 237287 | 2020-06-14 | Fremont | Colorado | 8043 | 29 | 0 |
240395 | 240395 | 2020-06-15 | Fremont | Colorado | 8043 | 29 | 0 |
243506 | 243506 | 2020-06-16 | Fremont | Colorado | 8043 | 29 | 0 |
246619 | 246619 | 2020-06-17 | Fremont | Colorado | 8043 | 30 | 0 |
249731 | 249731 | 2020-06-18 | Fremont | Colorado | 8043 | 30 | 0 |
252846 | 252846 | 2020-06-19 | Fremont | Colorado | 8043 | 30 | 0 |
255965 | 255965 | 2020-06-20 | Fremont | Colorado | 8043 | 30 | 0 |
259092 | 259092 | 2020-06-21 | Fremont | Colorado | 8043 | 31 | 0 |
262219 | 262219 | 2020-06-22 | Fremont | Colorado | 8043 | 31 | 0 |
265347 | 265347 | 2020-06-23 | Fremont | Colorado | 8043 | 31 | 0 |
268477 | 268477 | 2020-06-24 | Fremont | Colorado | 8043 | 31 | 0 |
271612 | 271612 | 2020-06-25 | Fremont | Colorado | 8043 | 32 | 0 |
274752 | 274752 | 2020-06-26 | Fremont | Colorado | 8043 | 33 | 0 |
277900 | 277900 | 2020-06-27 | Fremont | Colorado | 8043 | 34 | 0 |
281047 | 281047 | 2020-06-28 | Fremont | Colorado | 8043 | 36 | 0 |
284193 | 284193 | 2020-06-29 | Fremont | Colorado | 8043 | 36 | 0 |
287339 | 287339 | 2020-06-30 | Fremont | Colorado | 8043 | 36 | 0 |
290490 | 290490 | 2020-07-01 | Fremont | Colorado | 8043 | 37 | 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);