ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Osage" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333609 | 333609 | 2020-07-14 | Osage | Oklahoma | 40113 | 221 | 8 |
330417 | 330417 | 2020-07-13 | Osage | Oklahoma | 40113 | 218 | 8 |
327230 | 327230 | 2020-07-12 | Osage | Oklahoma | 40113 | 215 | 8 |
324045 | 324045 | 2020-07-11 | Osage | Oklahoma | 40113 | 214 | 8 |
320865 | 320865 | 2020-07-10 | Osage | Oklahoma | 40113 | 203 | 8 |
317688 | 317688 | 2020-07-09 | Osage | Oklahoma | 40113 | 194 | 8 |
314515 | 314515 | 2020-07-08 | Osage | Oklahoma | 40113 | 188 | 8 |
311343 | 311343 | 2020-07-07 | Osage | Oklahoma | 40113 | 187 | 8 |
308174 | 308174 | 2020-07-06 | Osage | Oklahoma | 40113 | 186 | 8 |
305007 | 305007 | 2020-07-05 | Osage | Oklahoma | 40113 | 185 | 8 |
301844 | 301844 | 2020-07-04 | Osage | Oklahoma | 40113 | 182 | 8 |
298681 | 298681 | 2020-07-03 | Osage | Oklahoma | 40113 | 176 | 8 |
295522 | 295522 | 2020-07-02 | Osage | Oklahoma | 40113 | 174 | 8 |
292366 | 292366 | 2020-07-01 | Osage | Oklahoma | 40113 | 168 | 8 |
289213 | 289213 | 2020-06-30 | Osage | Oklahoma | 40113 | 165 | 8 |
286063 | 286063 | 2020-06-29 | Osage | Oklahoma | 40113 | 160 | 8 |
282918 | 282918 | 2020-06-28 | Osage | Oklahoma | 40113 | 158 | 8 |
279772 | 279772 | 2020-06-27 | Osage | Oklahoma | 40113 | 156 | 8 |
276624 | 276624 | 2020-06-26 | Osage | Oklahoma | 40113 | 154 | 8 |
273477 | 273477 | 2020-06-25 | Osage | Oklahoma | 40113 | 154 | 8 |
270338 | 270338 | 2020-06-24 | Osage | Oklahoma | 40113 | 155 | 8 |
267204 | 267204 | 2020-06-23 | Osage | Oklahoma | 40113 | 146 | 8 |
264076 | 264076 | 2020-06-22 | Osage | Oklahoma | 40113 | 142 | 8 |
260948 | 260948 | 2020-06-21 | Osage | Oklahoma | 40113 | 140 | 8 |
257821 | 257821 | 2020-06-20 | Osage | Oklahoma | 40113 | 130 | 8 |
254695 | 254695 | 2020-06-19 | Osage | Oklahoma | 40113 | 125 | 8 |
251580 | 251580 | 2020-06-18 | Osage | Oklahoma | 40113 | 124 | 8 |
248465 | 248465 | 2020-06-17 | Osage | Oklahoma | 40113 | 116 | 8 |
245352 | 245352 | 2020-06-16 | Osage | Oklahoma | 40113 | 114 | 8 |
242240 | 242240 | 2020-06-15 | Osage | Oklahoma | 40113 | 114 | 8 |
239131 | 239131 | 2020-06-14 | Osage | Oklahoma | 40113 | 112 | 8 |
236023 | 236023 | 2020-06-13 | Osage | Oklahoma | 40113 | 106 | 8 |
232918 | 232918 | 2020-06-12 | Osage | Oklahoma | 40113 | 104 | 8 |
229813 | 229813 | 2020-06-11 | Osage | Oklahoma | 40113 | 104 | 8 |
226709 | 226709 | 2020-06-10 | Osage | Oklahoma | 40113 | 103 | 8 |
223609 | 223609 | 2020-06-09 | Osage | Oklahoma | 40113 | 102 | 8 |
220514 | 220514 | 2020-06-08 | Osage | Oklahoma | 40113 | 102 | 8 |
217422 | 217422 | 2020-06-07 | Osage | Oklahoma | 40113 | 101 | 8 |
214332 | 214332 | 2020-06-06 | Osage | Oklahoma | 40113 | 101 | 8 |
211246 | 211246 | 2020-06-05 | Osage | Oklahoma | 40113 | 101 | 8 |
208164 | 208164 | 2020-06-04 | Osage | Oklahoma | 40113 | 102 | 8 |
205083 | 205083 | 2020-06-03 | Osage | Oklahoma | 40113 | 96 | 8 |
202006 | 202006 | 2020-06-02 | Osage | Oklahoma | 40113 | 95 | 8 |
198931 | 198931 | 2020-06-01 | Osage | Oklahoma | 40113 | 95 | 8 |
195858 | 195858 | 2020-05-31 | Osage | Oklahoma | 40113 | 95 | 8 |
192789 | 192789 | 2020-05-30 | Osage | Oklahoma | 40113 | 95 | 8 |
189724 | 189724 | 2020-05-29 | Osage | Oklahoma | 40113 | 95 | 8 |
186663 | 186663 | 2020-05-28 | Osage | Oklahoma | 40113 | 94 | 8 |
183606 | 183606 | 2020-05-27 | Osage | Oklahoma | 40113 | 93 | 8 |
180557 | 180557 | 2020-05-26 | Osage | Oklahoma | 40113 | 94 | 8 |
177514 | 177514 | 2020-05-25 | Osage | Oklahoma | 40113 | 94 | 8 |
174470 | 174470 | 2020-05-24 | Osage | Oklahoma | 40113 | 94 | 8 |
171428 | 171428 | 2020-05-23 | Osage | Oklahoma | 40113 | 94 | 8 |
168389 | 168389 | 2020-05-22 | Osage | Oklahoma | 40113 | 93 | 8 |
165353 | 165353 | 2020-05-21 | Osage | Oklahoma | 40113 | 92 | 8 |
162324 | 162324 | 2020-05-20 | Osage | Oklahoma | 40113 | 92 | 8 |
159297 | 159297 | 2020-05-19 | Osage | Oklahoma | 40113 | 92 | 8 |
156276 | 156276 | 2020-05-18 | Osage | Oklahoma | 40113 | 91 | 8 |
153259 | 153259 | 2020-05-17 | Osage | Oklahoma | 40113 | 91 | 8 |
150248 | 150248 | 2020-05-16 | Osage | Oklahoma | 40113 | 91 | 8 |
147241 | 147241 | 2020-05-15 | Osage | Oklahoma | 40113 | 91 | 8 |
144240 | 144240 | 2020-05-14 | Osage | Oklahoma | 40113 | 90 | 8 |
141245 | 141245 | 2020-05-13 | Osage | Oklahoma | 40113 | 90 | 8 |
138249 | 138249 | 2020-05-12 | Osage | Oklahoma | 40113 | 90 | 8 |
135259 | 135259 | 2020-05-11 | Osage | Oklahoma | 40113 | 89 | 8 |
132268 | 132268 | 2020-05-10 | Osage | Oklahoma | 40113 | 88 | 8 |
129279 | 129279 | 2020-05-09 | Osage | Oklahoma | 40113 | 88 | 8 |
126290 | 126290 | 2020-05-08 | Osage | Oklahoma | 40113 | 85 | 8 |
123307 | 123307 | 2020-05-07 | Osage | Oklahoma | 40113 | 82 | 8 |
120330 | 120330 | 2020-05-06 | Osage | Oklahoma | 40113 | 77 | 8 |
117369 | 117369 | 2020-05-05 | Osage | Oklahoma | 40113 | 78 | 8 |
114488 | 114488 | 2020-05-04 | Osage | Oklahoma | 40113 | 78 | 8 |
111606 | 111606 | 2020-05-03 | Osage | Oklahoma | 40113 | 76 | 8 |
108732 | 108732 | 2020-05-02 | Osage | Oklahoma | 40113 | 76 | 8 |
105865 | 105865 | 2020-05-01 | Osage | Oklahoma | 40113 | 76 | 8 |
103002 | 103002 | 2020-04-30 | Osage | Oklahoma | 40113 | 75 | 8 |
100149 | 100149 | 2020-04-29 | Osage | Oklahoma | 40113 | 73 | 8 |
97300 | 97300 | 2020-04-28 | Osage | Oklahoma | 40113 | 72 | 8 |
94462 | 94462 | 2020-04-27 | Osage | Oklahoma | 40113 | 72 | 8 |
91636 | 91636 | 2020-04-26 | Osage | Oklahoma | 40113 | 72 | 8 |
88820 | 88820 | 2020-04-25 | Osage | Oklahoma | 40113 | 71 | 8 |
86006 | 86006 | 2020-04-24 | Osage | Oklahoma | 40113 | 71 | 8 |
83202 | 83202 | 2020-04-23 | Osage | Oklahoma | 40113 | 68 | 8 |
80403 | 80403 | 2020-04-22 | Osage | Oklahoma | 40113 | 65 | 8 |
77613 | 77613 | 2020-04-21 | Osage | Oklahoma | 40113 | 65 | 8 |
74831 | 74831 | 2020-04-20 | Osage | Oklahoma | 40113 | 65 | 8 |
72056 | 72056 | 2020-04-19 | Osage | Oklahoma | 40113 | 64 | 8 |
69289 | 69289 | 2020-04-18 | Osage | Oklahoma | 40113 | 64 | 8 |
66531 | 66531 | 2020-04-17 | Osage | Oklahoma | 40113 | 61 | 8 |
63786 | 63786 | 2020-04-16 | Osage | Oklahoma | 40113 | 61 | 8 |
61060 | 61060 | 2020-04-15 | Osage | Oklahoma | 40113 | 61 | 8 |
58345 | 58345 | 2020-04-14 | Osage | Oklahoma | 40113 | 59 | 8 |
55643 | 55643 | 2020-04-13 | Osage | Oklahoma | 40113 | 56 | 7 |
52958 | 52958 | 2020-04-12 | Osage | Oklahoma | 40113 | 50 | 7 |
50285 | 50285 | 2020-04-11 | Osage | Oklahoma | 40113 | 45 | 7 |
47629 | 47629 | 2020-04-10 | Osage | Oklahoma | 40113 | 45 | 7 |
45012 | 45012 | 2020-04-09 | Osage | Oklahoma | 40113 | 41 | 5 |
42426 | 42426 | 2020-04-08 | Osage | Oklahoma | 40113 | 33 | 5 |
39866 | 39866 | 2020-04-07 | Osage | Oklahoma | 40113 | 34 | 5 |
37345 | 37345 | 2020-04-06 | Osage | Oklahoma | 40113 | 31 | 3 |
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);