ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where county = "Unknown" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
172698 | 172698 | 2020-05-24 | Unknown | Colorado | 91 | 0 | |
169657 | 169657 | 2020-05-23 | Unknown | Colorado | 94 | 0 | |
166620 | 166620 | 2020-05-22 | Unknown | Colorado | 63 | 1 | |
163587 | 163587 | 2020-05-21 | Unknown | Colorado | 61 | 1 | |
160559 | 160559 | 2020-05-20 | Unknown | Colorado | 39 | 1 | |
157533 | 157533 | 2020-05-19 | Unknown | Colorado | 37 | 1 | |
154517 | 154517 | 2020-05-18 | Unknown | Colorado | 50 | 0 | |
151505 | 151505 | 2020-05-17 | Unknown | Colorado | 54 | 0 | |
148496 | 148496 | 2020-05-16 | Unknown | Colorado | 48 | 0 | |
145493 | 145493 | 2020-05-15 | Unknown | Colorado | 36 | 0 | |
142493 | 142493 | 2020-05-14 | Unknown | Colorado | 46 | 0 | |
139497 | 139497 | 2020-05-13 | Unknown | Colorado | 52 | 2 | |
136506 | 136506 | 2020-05-12 | Unknown | Colorado | 47 | 2 | |
133517 | 133517 | 2020-05-11 | Unknown | Colorado | 67 | 2 | |
130526 | 130526 | 2020-05-10 | Unknown | Colorado | 114 | 1 | |
127535 | 127535 | 2020-05-09 | Unknown | Colorado | 71 | 1 | |
124549 | 124549 | 2020-05-08 | Unknown | Colorado | 32 | 1 | |
121569 | 121569 | 2020-05-07 | Unknown | Colorado | 46 | 1 | |
118600 | 118600 | 2020-05-06 | Unknown | Colorado | 54 | 1 | |
115640 | 115640 | 2020-05-05 | Unknown | Colorado | 81 | 1 | |
112757 | 112757 | 2020-05-04 | Unknown | Colorado | 130 | 0 | |
109882 | 109882 | 2020-05-03 | Unknown | Colorado | 134 | 0 | |
107013 | 107013 | 2020-05-02 | Unknown | Colorado | 119 | 0 | |
104148 | 104148 | 2020-05-01 | Unknown | Colorado | 94 | 0 | |
101293 | 101293 | 2020-04-30 | Unknown | Colorado | 81 | 0 | |
98443 | 98443 | 2020-04-29 | Unknown | Colorado | 67 | 0 | |
95598 | 95598 | 2020-04-28 | Unknown | Colorado | 88 | 0 | |
92766 | 92766 | 2020-04-27 | Unknown | Colorado | 101 | 0 | |
89948 | 89948 | 2020-04-26 | Unknown | Colorado | 172 | 0 | |
87131 | 87131 | 2020-04-25 | Unknown | Colorado | 131 | 2 | |
84323 | 84323 | 2020-04-24 | Unknown | Colorado | 103 | 0 | |
81523 | 81523 | 2020-04-23 | Unknown | Colorado | 108 | 0 | |
78729 | 78729 | 2020-04-22 | Unknown | Colorado | 95 | 0 | |
75945 | 75945 | 2020-04-21 | Unknown | Colorado | 105 | 1 | |
73169 | 73169 | 2020-04-20 | Unknown | Colorado | 126 | 1 | |
70400 | 70400 | 2020-04-19 | Unknown | Colorado | 114 | 1 | |
67638 | 67638 | 2020-04-18 | Unknown | Colorado | 80 | 1 | |
64890 | 64890 | 2020-04-17 | Unknown | Colorado | 78 | 1 | |
62157 | 62157 | 2020-04-16 | Unknown | Colorado | 96 | 3 | |
59438 | 59438 | 2020-04-15 | Unknown | Colorado | 111 | 1 | |
56730 | 56730 | 2020-04-14 | Unknown | Colorado | 110 | 0 | |
54038 | 54038 | 2020-04-13 | Unknown | Colorado | 145 | 0 | |
51359 | 51359 | 2020-04-12 | Unknown | Colorado | 156 | 0 | |
48697 | 48697 | 2020-04-11 | Unknown | Colorado | 175 | 0 | |
46067 | 46067 | 2020-04-10 | Unknown | Colorado | 145 | 1 | |
43467 | 43467 | 2020-04-09 | Unknown | Colorado | 233 | 0 | |
40893 | 40893 | 2020-04-08 | Unknown | Colorado | 237 | 0 | |
38350 | 38350 | 2020-04-07 | Unknown | Colorado | 249 | 0 | |
35860 | 35860 | 2020-04-06 | Unknown | Colorado | 273 | 0 | |
33415 | 33415 | 2020-04-05 | Unknown | Colorado | 246 | 0 | |
31009 | 31009 | 2020-04-04 | Unknown | Colorado | 211 | 0 | |
28651 | 28651 | 2020-04-03 | Unknown | Colorado | 158 | 0 | |
26349 | 26349 | 2020-04-02 | Unknown | Colorado | 142 | 0 | |
24119 | 24119 | 2020-04-01 | Unknown | Colorado | 135 | 1 | |
21960 | 21960 | 2020-03-31 | Unknown | Colorado | 129 | 1 | |
19883 | 19883 | 2020-03-30 | Unknown | Colorado | 132 | 1 | |
17904 | 17904 | 2020-03-29 | Unknown | Colorado | 186 | 1 | |
16012 | 16012 | 2020-03-28 | Unknown | Colorado | 165 | 1 | |
14228 | 14228 | 2020-03-27 | Unknown | Colorado | 136 | 1 | |
12559 | 12559 | 2020-03-26 | Unknown | Colorado | 102 | 0 | |
11012 | 11012 | 2020-03-25 | Unknown | Colorado | 18 | 0 | |
9638 | 9638 | 2020-03-24 | Unknown | Colorado | 18 | 1 | |
8393 | 8393 | 2020-03-23 | Unknown | Colorado | 5 | 0 | |
7247 | 7247 | 2020-03-22 | Unknown | Colorado | 1 | 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);