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 state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, 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 |
102976 | 102976 | 2020-04-30 | Harper | Oklahoma | 40059 | 1 | 0 |
105839 | 105839 | 2020-05-01 | Harper | Oklahoma | 40059 | 1 | 0 |
108706 | 108706 | 2020-05-02 | Harper | Oklahoma | 40059 | 1 | 0 |
111580 | 111580 | 2020-05-03 | Harper | Oklahoma | 40059 | 1 | 0 |
114462 | 114462 | 2020-05-04 | Harper | Oklahoma | 40059 | 1 | 0 |
117343 | 117343 | 2020-05-05 | Harper | Oklahoma | 40059 | 1 | 0 |
120304 | 120304 | 2020-05-06 | Harper | Oklahoma | 40059 | 1 | 0 |
123281 | 123281 | 2020-05-07 | Harper | Oklahoma | 40059 | 1 | 0 |
126264 | 126264 | 2020-05-08 | Harper | Oklahoma | 40059 | 1 | 0 |
129253 | 129253 | 2020-05-09 | Harper | Oklahoma | 40059 | 1 | 0 |
132242 | 132242 | 2020-05-10 | Harper | Oklahoma | 40059 | 1 | 0 |
135233 | 135233 | 2020-05-11 | Harper | Oklahoma | 40059 | 1 | 0 |
138223 | 138223 | 2020-05-12 | Harper | Oklahoma | 40059 | 1 | 0 |
141219 | 141219 | 2020-05-13 | Harper | Oklahoma | 40059 | 1 | 0 |
144214 | 144214 | 2020-05-14 | Harper | Oklahoma | 40059 | 1 | 0 |
147215 | 147215 | 2020-05-15 | Harper | Oklahoma | 40059 | 1 | 0 |
150222 | 150222 | 2020-05-16 | Harper | Oklahoma | 40059 | 1 | 0 |
153233 | 153233 | 2020-05-17 | Harper | Oklahoma | 40059 | 1 | 0 |
156250 | 156250 | 2020-05-18 | Harper | Oklahoma | 40059 | 1 | 0 |
159271 | 159271 | 2020-05-19 | Harper | Oklahoma | 40059 | 1 | 0 |
162298 | 162298 | 2020-05-20 | Harper | Oklahoma | 40059 | 1 | 0 |
165327 | 165327 | 2020-05-21 | Harper | Oklahoma | 40059 | 1 | 0 |
168363 | 168363 | 2020-05-22 | Harper | Oklahoma | 40059 | 1 | 0 |
171402 | 171402 | 2020-05-23 | Harper | Oklahoma | 40059 | 1 | 0 |
174444 | 174444 | 2020-05-24 | Harper | Oklahoma | 40059 | 1 | 0 |
177488 | 177488 | 2020-05-25 | Harper | Oklahoma | 40059 | 1 | 0 |
180531 | 180531 | 2020-05-26 | Harper | Oklahoma | 40059 | 1 | 0 |
183580 | 183580 | 2020-05-27 | Harper | Oklahoma | 40059 | 1 | 0 |
186637 | 186637 | 2020-05-28 | Harper | Oklahoma | 40059 | 1 | 0 |
189697 | 189697 | 2020-05-29 | Harper | Oklahoma | 40059 | 1 | 0 |
192762 | 192762 | 2020-05-30 | Harper | Oklahoma | 40059 | 1 | 0 |
195831 | 195831 | 2020-05-31 | Harper | Oklahoma | 40059 | 1 | 0 |
198904 | 198904 | 2020-06-01 | Harper | Oklahoma | 40059 | 1 | 0 |
201979 | 201979 | 2020-06-02 | Harper | Oklahoma | 40059 | 1 | 0 |
205056 | 205056 | 2020-06-03 | Harper | Oklahoma | 40059 | 1 | 0 |
208137 | 208137 | 2020-06-04 | Harper | Oklahoma | 40059 | 1 | 0 |
211219 | 211219 | 2020-06-05 | Harper | Oklahoma | 40059 | 1 | 0 |
214305 | 214305 | 2020-06-06 | Harper | Oklahoma | 40059 | 1 | 0 |
217395 | 217395 | 2020-06-07 | Harper | Oklahoma | 40059 | 1 | 0 |
220487 | 220487 | 2020-06-08 | Harper | Oklahoma | 40059 | 1 | 0 |
223582 | 223582 | 2020-06-09 | Harper | Oklahoma | 40059 | 1 | 0 |
226682 | 226682 | 2020-06-10 | Harper | Oklahoma | 40059 | 1 | 0 |
229786 | 229786 | 2020-06-11 | Harper | Oklahoma | 40059 | 1 | 0 |
232891 | 232891 | 2020-06-12 | Harper | Oklahoma | 40059 | 1 | 0 |
235996 | 235996 | 2020-06-13 | Harper | Oklahoma | 40059 | 1 | 0 |
239104 | 239104 | 2020-06-14 | Harper | Oklahoma | 40059 | 1 | 0 |
242213 | 242213 | 2020-06-15 | Harper | Oklahoma | 40059 | 1 | 0 |
245325 | 245325 | 2020-06-16 | Harper | Oklahoma | 40059 | 1 | 0 |
248438 | 248438 | 2020-06-17 | Harper | Oklahoma | 40059 | 1 | 0 |
251553 | 251553 | 2020-06-18 | Harper | Oklahoma | 40059 | 1 | 0 |
254668 | 254668 | 2020-06-19 | Harper | Oklahoma | 40059 | 1 | 0 |
257794 | 257794 | 2020-06-20 | Harper | Oklahoma | 40059 | 1 | 0 |
260921 | 260921 | 2020-06-21 | Harper | Oklahoma | 40059 | 1 | 0 |
264049 | 264049 | 2020-06-22 | Harper | Oklahoma | 40059 | 1 | 0 |
267177 | 267177 | 2020-06-23 | Harper | Oklahoma | 40059 | 1 | 0 |
270311 | 270311 | 2020-06-24 | Harper | Oklahoma | 40059 | 1 | 0 |
273450 | 273450 | 2020-06-25 | Harper | Oklahoma | 40059 | 1 | 0 |
276597 | 276597 | 2020-06-26 | Harper | Oklahoma | 40059 | 1 | 0 |
279745 | 279745 | 2020-06-27 | Harper | Oklahoma | 40059 | 1 | 0 |
282891 | 282891 | 2020-06-28 | Harper | Oklahoma | 40059 | 1 | 0 |
286036 | 286036 | 2020-06-29 | Harper | Oklahoma | 40059 | 1 | 0 |
289186 | 289186 | 2020-06-30 | Harper | Oklahoma | 40059 | 1 | 0 |
292339 | 292339 | 2020-07-01 | Harper | Oklahoma | 40059 | 1 | 0 |
295495 | 295495 | 2020-07-02 | Harper | Oklahoma | 40059 | 1 | 0 |
298654 | 298654 | 2020-07-03 | Harper | Oklahoma | 40059 | 1 | 0 |
301817 | 301817 | 2020-07-04 | Harper | Oklahoma | 40059 | 1 | 0 |
304980 | 304980 | 2020-07-05 | Harper | Oklahoma | 40059 | 1 | 0 |
308147 | 308147 | 2020-07-06 | Harper | Oklahoma | 40059 | 1 | 0 |
311316 | 311316 | 2020-07-07 | Harper | Oklahoma | 40059 | 1 | 0 |
314488 | 314488 | 2020-07-08 | Harper | Oklahoma | 40059 | 1 | 0 |
317661 | 317661 | 2020-07-09 | Harper | Oklahoma | 40059 | 1 | 0 |
320838 | 320838 | 2020-07-10 | Harper | Oklahoma | 40059 | 1 | 0 |
324018 | 324018 | 2020-07-11 | Harper | Oklahoma | 40059 | 1 | 0 |
327203 | 327203 | 2020-07-12 | Harper | Oklahoma | 40059 | 1 | 0 |
330390 | 330390 | 2020-07-13 | Harper | Oklahoma | 40059 | 1 | 0 |
333582 | 333582 | 2020-07-14 | Harper | Oklahoma | 40059 | 2 | 0 |
336776 | 336776 | 2020-07-15 | Harper | Oklahoma | 40059 | 2 | 0 |
339972 | 339972 | 2020-07-16 | Harper | Oklahoma | 40059 | 2 | 0 |
343170 | 343170 | 2020-07-17 | Harper | Oklahoma | 40059 | 2 | 0 |
346370 | 346370 | 2020-07-18 | Harper | Oklahoma | 40059 | 2 | 0 |
349570 | 349570 | 2020-07-19 | Harper | Oklahoma | 40059 | 2 | 0 |
352773 | 352773 | 2020-07-20 | Harper | Oklahoma | 40059 | 2 | 0 |
355976 | 355976 | 2020-07-21 | Harper | Oklahoma | 40059 | 2 | 0 |
359180 | 359180 | 2020-07-22 | Harper | Oklahoma | 40059 | 2 | 0 |
362386 | 362386 | 2020-07-23 | Harper | Oklahoma | 40059 | 2 | 0 |
365592 | 365592 | 2020-07-24 | Harper | Oklahoma | 40059 | 2 | 0 |
368801 | 368801 | 2020-07-25 | Harper | Oklahoma | 40059 | 4 | 0 |
372013 | 372013 | 2020-07-26 | Harper | Oklahoma | 40059 | 4 | 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);