ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Teller" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8392 | 8392 | 2020-03-23 | Teller | Colorado | 8119 | 3 | 1 |
9637 | 9637 | 2020-03-24 | Teller | Colorado | 8119 | 3 | 1 |
11011 | 11011 | 2020-03-25 | Teller | Colorado | 8119 | 5 | 1 |
12558 | 12558 | 2020-03-26 | Teller | Colorado | 8119 | 7 | 1 |
14227 | 14227 | 2020-03-27 | Teller | Colorado | 8119 | 7 | 1 |
16011 | 16011 | 2020-03-28 | Teller | Colorado | 8119 | 7 | 1 |
17903 | 17903 | 2020-03-29 | Teller | Colorado | 8119 | 7 | 1 |
19882 | 19882 | 2020-03-30 | Teller | Colorado | 8119 | 8 | 1 |
21959 | 21959 | 2020-03-31 | Teller | Colorado | 8119 | 7 | 1 |
24118 | 24118 | 2020-04-01 | Teller | Colorado | 8119 | 7 | 1 |
26348 | 26348 | 2020-04-02 | Teller | Colorado | 8119 | 7 | 1 |
28650 | 28650 | 2020-04-03 | Teller | Colorado | 8119 | 11 | 1 |
31008 | 31008 | 2020-04-04 | Teller | Colorado | 8119 | 11 | 1 |
33414 | 33414 | 2020-04-05 | Teller | Colorado | 8119 | 11 | 1 |
35859 | 35859 | 2020-04-06 | Teller | Colorado | 8119 | 11 | 1 |
38349 | 38349 | 2020-04-07 | Teller | Colorado | 8119 | 12 | 1 |
40892 | 40892 | 2020-04-08 | Teller | Colorado | 8119 | 12 | 1 |
43466 | 43466 | 2020-04-09 | Teller | Colorado | 8119 | 12 | 1 |
46066 | 46066 | 2020-04-10 | Teller | Colorado | 8119 | 12 | 2 |
48696 | 48696 | 2020-04-11 | Teller | Colorado | 8119 | 12 | 2 |
51358 | 51358 | 2020-04-12 | Teller | Colorado | 8119 | 16 | 2 |
54037 | 54037 | 2020-04-13 | Teller | Colorado | 8119 | 15 | 2 |
56729 | 56729 | 2020-04-14 | Teller | Colorado | 8119 | 16 | 2 |
59437 | 59437 | 2020-04-15 | Teller | Colorado | 8119 | 16 | 2 |
62156 | 62156 | 2020-04-16 | Teller | Colorado | 8119 | 17 | 2 |
64889 | 64889 | 2020-04-17 | Teller | Colorado | 8119 | 18 | 2 |
67637 | 67637 | 2020-04-18 | Teller | Colorado | 8119 | 18 | 2 |
70399 | 70399 | 2020-04-19 | Teller | Colorado | 8119 | 24 | 2 |
73168 | 73168 | 2020-04-20 | Teller | Colorado | 8119 | 24 | 2 |
75944 | 75944 | 2020-04-21 | Teller | Colorado | 8119 | 25 | 2 |
78728 | 78728 | 2020-04-22 | Teller | Colorado | 8119 | 25 | 2 |
81522 | 81522 | 2020-04-23 | Teller | Colorado | 8119 | 25 | 2 |
84322 | 84322 | 2020-04-24 | Teller | Colorado | 8119 | 26 | 2 |
87130 | 87130 | 2020-04-25 | Teller | Colorado | 8119 | 27 | 2 |
89947 | 89947 | 2020-04-26 | Teller | Colorado | 8119 | 27 | 2 |
92765 | 92765 | 2020-04-27 | Teller | Colorado | 8119 | 27 | 2 |
95597 | 95597 | 2020-04-28 | Teller | Colorado | 8119 | 28 | 2 |
98442 | 98442 | 2020-04-29 | Teller | Colorado | 8119 | 28 | 2 |
101292 | 101292 | 2020-04-30 | Teller | Colorado | 8119 | 28 | 2 |
104147 | 104147 | 2020-05-01 | Teller | Colorado | 8119 | 28 | 2 |
107012 | 107012 | 2020-05-02 | Teller | Colorado | 8119 | 28 | 2 |
109881 | 109881 | 2020-05-03 | Teller | Colorado | 8119 | 28 | 2 |
112756 | 112756 | 2020-05-04 | Teller | Colorado | 8119 | 28 | 2 |
115639 | 115639 | 2020-05-05 | Teller | Colorado | 8119 | 29 | 2 |
118599 | 118599 | 2020-05-06 | Teller | Colorado | 8119 | 30 | 2 |
121568 | 121568 | 2020-05-07 | Teller | Colorado | 8119 | 30 | 2 |
124548 | 124548 | 2020-05-08 | Teller | Colorado | 8119 | 30 | 2 |
127534 | 127534 | 2020-05-09 | Teller | Colorado | 8119 | 30 | 2 |
130525 | 130525 | 2020-05-10 | Teller | Colorado | 8119 | 31 | 2 |
133516 | 133516 | 2020-05-11 | Teller | Colorado | 8119 | 31 | 2 |
136505 | 136505 | 2020-05-12 | Teller | Colorado | 8119 | 31 | 2 |
139496 | 139496 | 2020-05-13 | Teller | Colorado | 8119 | 31 | 2 |
142492 | 142492 | 2020-05-14 | Teller | Colorado | 8119 | 31 | 2 |
145492 | 145492 | 2020-05-15 | Teller | Colorado | 8119 | 31 | 2 |
148495 | 148495 | 2020-05-16 | Teller | Colorado | 8119 | 31 | 2 |
151504 | 151504 | 2020-05-17 | Teller | Colorado | 8119 | 31 | 2 |
154516 | 154516 | 2020-05-18 | Teller | Colorado | 8119 | 31 | 2 |
157532 | 157532 | 2020-05-19 | Teller | Colorado | 8119 | 31 | 2 |
160558 | 160558 | 2020-05-20 | Teller | Colorado | 8119 | 32 | 2 |
163586 | 163586 | 2020-05-21 | Teller | Colorado | 8119 | 33 | 2 |
166619 | 166619 | 2020-05-22 | Teller | Colorado | 8119 | 32 | 2 |
169656 | 169656 | 2020-05-23 | Teller | Colorado | 8119 | 32 | 2 |
172697 | 172697 | 2020-05-24 | Teller | Colorado | 8119 | 32 | 2 |
175741 | 175741 | 2020-05-25 | Teller | Colorado | 8119 | 32 | 2 |
178785 | 178785 | 2020-05-26 | Teller | Colorado | 8119 | 32 | 2 |
181829 | 181829 | 2020-05-27 | Teller | Colorado | 8119 | 32 | 2 |
184883 | 184883 | 2020-05-28 | Teller | Colorado | 8119 | 32 | 2 |
187939 | 187939 | 2020-05-29 | Teller | Colorado | 8119 | 32 | 2 |
191004 | 191004 | 2020-05-30 | Teller | Colorado | 8119 | 32 | 2 |
194071 | 194071 | 2020-05-31 | Teller | Colorado | 8119 | 32 | 2 |
197141 | 197141 | 2020-06-01 | Teller | Colorado | 8119 | 33 | 2 |
200214 | 200214 | 2020-06-02 | Teller | Colorado | 8119 | 33 | 2 |
203290 | 203290 | 2020-06-03 | Teller | Colorado | 8119 | 33 | 2 |
206370 | 206370 | 2020-06-04 | Teller | Colorado | 8119 | 33 | 2 |
209451 | 209451 | 2020-06-05 | Teller | Colorado | 8119 | 33 | 2 |
212536 | 212536 | 2020-06-06 | Teller | Colorado | 8119 | 34 | 2 |
215623 | 215623 | 2020-06-07 | Teller | Colorado | 8119 | 34 | 2 |
218714 | 218714 | 2020-06-08 | Teller | Colorado | 8119 | 36 | 2 |
221809 | 221809 | 2020-06-09 | Teller | Colorado | 8119 | 37 | 2 |
224904 | 224904 | 2020-06-10 | Teller | Colorado | 8119 | 37 | 2 |
228006 | 228006 | 2020-06-11 | Teller | Colorado | 8119 | 37 | 2 |
231109 | 231109 | 2020-06-12 | Teller | Colorado | 8119 | 38 | 2 |
234215 | 234215 | 2020-06-13 | Teller | Colorado | 8119 | 38 | 2 |
237322 | 237322 | 2020-06-14 | Teller | Colorado | 8119 | 38 | 2 |
240430 | 240430 | 2020-06-15 | Teller | Colorado | 8119 | 38 | 2 |
243541 | 243541 | 2020-06-16 | Teller | Colorado | 8119 | 39 | 2 |
246654 | 246654 | 2020-06-17 | Teller | Colorado | 8119 | 39 | 2 |
249766 | 249766 | 2020-06-18 | Teller | Colorado | 8119 | 39 | 2 |
252881 | 252881 | 2020-06-19 | Teller | Colorado | 8119 | 39 | 2 |
256000 | 256000 | 2020-06-20 | Teller | Colorado | 8119 | 39 | 2 |
259127 | 259127 | 2020-06-21 | Teller | Colorado | 8119 | 39 | 2 |
262254 | 262254 | 2020-06-22 | Teller | Colorado | 8119 | 40 | 2 |
265382 | 265382 | 2020-06-23 | Teller | Colorado | 8119 | 40 | 2 |
268512 | 268512 | 2020-06-24 | Teller | Colorado | 8119 | 40 | 2 |
271648 | 271648 | 2020-06-25 | Teller | Colorado | 8119 | 41 | 2 |
274788 | 274788 | 2020-06-26 | Teller | Colorado | 8119 | 41 | 2 |
277936 | 277936 | 2020-06-27 | Teller | Colorado | 8119 | 41 | 2 |
281083 | 281083 | 2020-06-28 | Teller | Colorado | 8119 | 41 | 2 |
284229 | 284229 | 2020-06-29 | Teller | Colorado | 8119 | 41 | 2 |
287375 | 287375 | 2020-06-30 | Teller | Colorado | 8119 | 41 | 2 |
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);