ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,500 rows where county = "Harper" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
69263 | 69263 | 2020-04-18 | Harper | Oklahoma | 40059 | 1 | 0 |
72030 | 72030 | 2020-04-19 | Harper | Oklahoma | 40059 | 1 | 0 |
74805 | 74805 | 2020-04-20 | Harper | Oklahoma | 40059 | 1 | 0 |
77587 | 77587 | 2020-04-21 | Harper | Oklahoma | 40059 | 1 | 0 |
80377 | 80377 | 2020-04-22 | Harper | Oklahoma | 40059 | 1 | 0 |
83176 | 83176 | 2020-04-23 | Harper | Oklahoma | 40059 | 1 | 0 |
85980 | 85980 | 2020-04-24 | Harper | Oklahoma | 40059 | 1 | 0 |
88794 | 88794 | 2020-04-25 | Harper | Oklahoma | 40059 | 1 | 0 |
91610 | 91610 | 2020-04-26 | Harper | Oklahoma | 40059 | 1 | 0 |
94436 | 94436 | 2020-04-27 | Harper | Oklahoma | 40059 | 1 | 0 |
97274 | 97274 | 2020-04-28 | Harper | Oklahoma | 40059 | 1 | 0 |
100123 | 100123 | 2020-04-29 | Harper | Oklahoma | 40059 | 1 | 0 |
101880 | 101880 | 2020-04-30 | Harper | Kansas | 20077 | 1 | 0 |
102976 | 102976 | 2020-04-30 | Harper | Oklahoma | 40059 | 1 | 0 |
104740 | 104740 | 2020-05-01 | Harper | Kansas | 20077 | 1 | 0 |
105839 | 105839 | 2020-05-01 | Harper | Oklahoma | 40059 | 1 | 0 |
107605 | 107605 | 2020-05-02 | Harper | Kansas | 20077 | 1 | 0 |
108706 | 108706 | 2020-05-02 | Harper | Oklahoma | 40059 | 1 | 0 |
110476 | 110476 | 2020-05-03 | Harper | Kansas | 20077 | 1 | 0 |
111580 | 111580 | 2020-05-03 | Harper | Oklahoma | 40059 | 1 | 0 |
113353 | 113353 | 2020-05-04 | Harper | Kansas | 20077 | 1 | 0 |
114462 | 114462 | 2020-05-04 | Harper | Oklahoma | 40059 | 1 | 0 |
116235 | 116235 | 2020-05-05 | Harper | Kansas | 20077 | 1 | 0 |
117343 | 117343 | 2020-05-05 | Harper | Oklahoma | 40059 | 1 | 0 |
119196 | 119196 | 2020-05-06 | Harper | Kansas | 20077 | 1 | 0 |
120304 | 120304 | 2020-05-06 | Harper | Oklahoma | 40059 | 1 | 0 |
122166 | 122166 | 2020-05-07 | Harper | Kansas | 20077 | 1 | 0 |
123281 | 123281 | 2020-05-07 | Harper | Oklahoma | 40059 | 1 | 0 |
125148 | 125148 | 2020-05-08 | Harper | Kansas | 20077 | 1 | 0 |
126264 | 126264 | 2020-05-08 | Harper | Oklahoma | 40059 | 1 | 0 |
128136 | 128136 | 2020-05-09 | Harper | Kansas | 20077 | 1 | 0 |
129253 | 129253 | 2020-05-09 | Harper | Oklahoma | 40059 | 1 | 0 |
131126 | 131126 | 2020-05-10 | Harper | Kansas | 20077 | 1 | 0 |
132242 | 132242 | 2020-05-10 | Harper | Oklahoma | 40059 | 1 | 0 |
134117 | 134117 | 2020-05-11 | Harper | Kansas | 20077 | 1 | 0 |
135233 | 135233 | 2020-05-11 | Harper | Oklahoma | 40059 | 1 | 0 |
137107 | 137107 | 2020-05-12 | Harper | Kansas | 20077 | 1 | 0 |
138223 | 138223 | 2020-05-12 | Harper | Oklahoma | 40059 | 1 | 0 |
140100 | 140100 | 2020-05-13 | Harper | Kansas | 20077 | 1 | 0 |
141219 | 141219 | 2020-05-13 | Harper | Oklahoma | 40059 | 1 | 0 |
143096 | 143096 | 2020-05-14 | Harper | Kansas | 20077 | 1 | 0 |
144214 | 144214 | 2020-05-14 | Harper | Oklahoma | 40059 | 1 | 0 |
146096 | 146096 | 2020-05-15 | Harper | Kansas | 20077 | 1 | 0 |
147215 | 147215 | 2020-05-15 | Harper | Oklahoma | 40059 | 1 | 0 |
149100 | 149100 | 2020-05-16 | Harper | Kansas | 20077 | 1 | 0 |
150222 | 150222 | 2020-05-16 | Harper | Oklahoma | 40059 | 1 | 0 |
152111 | 152111 | 2020-05-17 | Harper | Kansas | 20077 | 1 | 0 |
153233 | 153233 | 2020-05-17 | Harper | Oklahoma | 40059 | 1 | 0 |
155123 | 155123 | 2020-05-18 | Harper | Kansas | 20077 | 1 | 0 |
156250 | 156250 | 2020-05-18 | Harper | Oklahoma | 40059 | 1 | 0 |
158140 | 158140 | 2020-05-19 | Harper | Kansas | 20077 | 1 | 0 |
159271 | 159271 | 2020-05-19 | Harper | Oklahoma | 40059 | 1 | 0 |
161165 | 161165 | 2020-05-20 | Harper | Kansas | 20077 | 1 | 0 |
162298 | 162298 | 2020-05-20 | Harper | Oklahoma | 40059 | 1 | 0 |
164194 | 164194 | 2020-05-21 | Harper | Kansas | 20077 | 1 | 0 |
165327 | 165327 | 2020-05-21 | Harper | Oklahoma | 40059 | 1 | 0 |
167227 | 167227 | 2020-05-22 | Harper | Kansas | 20077 | 1 | 0 |
168363 | 168363 | 2020-05-22 | Harper | Oklahoma | 40059 | 1 | 0 |
170265 | 170265 | 2020-05-23 | Harper | Kansas | 20077 | 1 | 0 |
171402 | 171402 | 2020-05-23 | Harper | Oklahoma | 40059 | 1 | 0 |
173306 | 173306 | 2020-05-24 | Harper | Kansas | 20077 | 1 | 0 |
174444 | 174444 | 2020-05-24 | Harper | Oklahoma | 40059 | 1 | 0 |
176350 | 176350 | 2020-05-25 | Harper | Kansas | 20077 | 1 | 0 |
177488 | 177488 | 2020-05-25 | Harper | Oklahoma | 40059 | 1 | 0 |
179394 | 179394 | 2020-05-26 | Harper | Kansas | 20077 | 1 | 0 |
180531 | 180531 | 2020-05-26 | Harper | Oklahoma | 40059 | 1 | 0 |
182439 | 182439 | 2020-05-27 | Harper | Kansas | 20077 | 2 | 0 |
183580 | 183580 | 2020-05-27 | Harper | Oklahoma | 40059 | 1 | 0 |
185493 | 185493 | 2020-05-28 | Harper | Kansas | 20077 | 2 | 0 |
186637 | 186637 | 2020-05-28 | Harper | Oklahoma | 40059 | 1 | 0 |
188551 | 188551 | 2020-05-29 | Harper | Kansas | 20077 | 2 | 0 |
189697 | 189697 | 2020-05-29 | Harper | Oklahoma | 40059 | 1 | 0 |
191615 | 191615 | 2020-05-30 | Harper | Kansas | 20077 | 2 | 0 |
192762 | 192762 | 2020-05-30 | Harper | Oklahoma | 40059 | 1 | 0 |
194683 | 194683 | 2020-05-31 | Harper | Kansas | 20077 | 2 | 0 |
195831 | 195831 | 2020-05-31 | Harper | Oklahoma | 40059 | 1 | 0 |
197753 | 197753 | 2020-06-01 | Harper | Kansas | 20077 | 2 | 0 |
198904 | 198904 | 2020-06-01 | Harper | Oklahoma | 40059 | 1 | 0 |
200825 | 200825 | 2020-06-02 | Harper | Kansas | 20077 | 2 | 0 |
201979 | 201979 | 2020-06-02 | Harper | Oklahoma | 40059 | 1 | 0 |
203901 | 203901 | 2020-06-03 | Harper | Kansas | 20077 | 2 | 0 |
205056 | 205056 | 2020-06-03 | Harper | Oklahoma | 40059 | 1 | 0 |
206982 | 206982 | 2020-06-04 | Harper | Kansas | 20077 | 2 | 0 |
208137 | 208137 | 2020-06-04 | Harper | Oklahoma | 40059 | 1 | 0 |
210063 | 210063 | 2020-06-05 | Harper | Kansas | 20077 | 2 | 0 |
211219 | 211219 | 2020-06-05 | Harper | Oklahoma | 40059 | 1 | 0 |
213148 | 213148 | 2020-06-06 | Harper | Kansas | 20077 | 2 | 0 |
214305 | 214305 | 2020-06-06 | Harper | Oklahoma | 40059 | 1 | 0 |
216235 | 216235 | 2020-06-07 | Harper | Kansas | 20077 | 2 | 0 |
217395 | 217395 | 2020-06-07 | Harper | Oklahoma | 40059 | 1 | 0 |
219327 | 219327 | 2020-06-08 | Harper | Kansas | 20077 | 2 | 0 |
220487 | 220487 | 2020-06-08 | Harper | Oklahoma | 40059 | 1 | 0 |
222422 | 222422 | 2020-06-09 | Harper | Kansas | 20077 | 2 | 0 |
223582 | 223582 | 2020-06-09 | Harper | Oklahoma | 40059 | 1 | 0 |
225517 | 225517 | 2020-06-10 | Harper | Kansas | 20077 | 2 | 0 |
226682 | 226682 | 2020-06-10 | Harper | Oklahoma | 40059 | 1 | 0 |
228619 | 228619 | 2020-06-11 | Harper | Kansas | 20077 | 2 | 0 |
229786 | 229786 | 2020-06-11 | Harper | Oklahoma | 40059 | 1 | 0 |
231722 | 231722 | 2020-06-12 | Harper | Kansas | 20077 | 2 | 0 |
232891 | 232891 | 2020-06-12 | Harper | Oklahoma | 40059 | 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);