ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 40017 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333561 | 333561 | 2020-07-14 | Canadian | Oklahoma | 40017 | 543 | 3 |
330369 | 330369 | 2020-07-13 | Canadian | Oklahoma | 40017 | 519 | 3 |
327182 | 327182 | 2020-07-12 | Canadian | Oklahoma | 40017 | 502 | 3 |
323997 | 323997 | 2020-07-11 | Canadian | Oklahoma | 40017 | 479 | 3 |
320817 | 320817 | 2020-07-10 | Canadian | Oklahoma | 40017 | 456 | 3 |
317640 | 317640 | 2020-07-09 | Canadian | Oklahoma | 40017 | 430 | 3 |
314467 | 314467 | 2020-07-08 | Canadian | Oklahoma | 40017 | 409 | 3 |
311295 | 311295 | 2020-07-07 | Canadian | Oklahoma | 40017 | 387 | 3 |
308126 | 308126 | 2020-07-06 | Canadian | Oklahoma | 40017 | 360 | 3 |
304959 | 304959 | 2020-07-05 | Canadian | Oklahoma | 40017 | 337 | 3 |
301796 | 301796 | 2020-07-04 | Canadian | Oklahoma | 40017 | 325 | 3 |
298633 | 298633 | 2020-07-03 | Canadian | Oklahoma | 40017 | 307 | 3 |
295474 | 295474 | 2020-07-02 | Canadian | Oklahoma | 40017 | 293 | 3 |
292318 | 292318 | 2020-07-01 | Canadian | Oklahoma | 40017 | 289 | 3 |
289166 | 289166 | 2020-06-30 | Canadian | Oklahoma | 40017 | 280 | 3 |
286016 | 286016 | 2020-06-29 | Canadian | Oklahoma | 40017 | 266 | 3 |
282871 | 282871 | 2020-06-28 | Canadian | Oklahoma | 40017 | 258 | 3 |
279725 | 279725 | 2020-06-27 | Canadian | Oklahoma | 40017 | 249 | 3 |
276577 | 276577 | 2020-06-26 | Canadian | Oklahoma | 40017 | 238 | 3 |
273430 | 273430 | 2020-06-25 | Canadian | Oklahoma | 40017 | 227 | 3 |
270291 | 270291 | 2020-06-24 | Canadian | Oklahoma | 40017 | 218 | 3 |
267157 | 267157 | 2020-06-23 | Canadian | Oklahoma | 40017 | 207 | 3 |
264029 | 264029 | 2020-06-22 | Canadian | Oklahoma | 40017 | 200 | 3 |
260901 | 260901 | 2020-06-21 | Canadian | Oklahoma | 40017 | 197 | 3 |
257775 | 257775 | 2020-06-20 | Canadian | Oklahoma | 40017 | 192 | 3 |
254649 | 254649 | 2020-06-19 | Canadian | Oklahoma | 40017 | 186 | 3 |
251534 | 251534 | 2020-06-18 | Canadian | Oklahoma | 40017 | 175 | 3 |
248419 | 248419 | 2020-06-17 | Canadian | Oklahoma | 40017 | 167 | 3 |
245306 | 245306 | 2020-06-16 | Canadian | Oklahoma | 40017 | 160 | 3 |
242194 | 242194 | 2020-06-15 | Canadian | Oklahoma | 40017 | 156 | 3 |
239085 | 239085 | 2020-06-14 | Canadian | Oklahoma | 40017 | 150 | 3 |
235977 | 235977 | 2020-06-13 | Canadian | Oklahoma | 40017 | 148 | 3 |
232872 | 232872 | 2020-06-12 | Canadian | Oklahoma | 40017 | 146 | 3 |
229767 | 229767 | 2020-06-11 | Canadian | Oklahoma | 40017 | 144 | 3 |
226663 | 226663 | 2020-06-10 | Canadian | Oklahoma | 40017 | 144 | 3 |
223563 | 223563 | 2020-06-09 | Canadian | Oklahoma | 40017 | 143 | 3 |
220468 | 220468 | 2020-06-08 | Canadian | Oklahoma | 40017 | 142 | 3 |
217376 | 217376 | 2020-06-07 | Canadian | Oklahoma | 40017 | 142 | 3 |
214286 | 214286 | 2020-06-06 | Canadian | Oklahoma | 40017 | 141 | 3 |
211200 | 211200 | 2020-06-05 | Canadian | Oklahoma | 40017 | 141 | 3 |
208118 | 208118 | 2020-06-04 | Canadian | Oklahoma | 40017 | 137 | 3 |
205037 | 205037 | 2020-06-03 | Canadian | Oklahoma | 40017 | 133 | 3 |
201960 | 201960 | 2020-06-02 | Canadian | Oklahoma | 40017 | 133 | 3 |
198885 | 198885 | 2020-06-01 | Canadian | Oklahoma | 40017 | 133 | 3 |
195812 | 195812 | 2020-05-31 | Canadian | Oklahoma | 40017 | 133 | 3 |
192743 | 192743 | 2020-05-30 | Canadian | Oklahoma | 40017 | 132 | 3 |
189678 | 189678 | 2020-05-29 | Canadian | Oklahoma | 40017 | 129 | 3 |
186618 | 186618 | 2020-05-28 | Canadian | Oklahoma | 40017 | 128 | 3 |
183561 | 183561 | 2020-05-27 | Canadian | Oklahoma | 40017 | 128 | 3 |
180512 | 180512 | 2020-05-26 | Canadian | Oklahoma | 40017 | 128 | 3 |
177469 | 177469 | 2020-05-25 | Canadian | Oklahoma | 40017 | 128 | 3 |
174425 | 174425 | 2020-05-24 | Canadian | Oklahoma | 40017 | 126 | 3 |
171383 | 171383 | 2020-05-23 | Canadian | Oklahoma | 40017 | 124 | 3 |
168344 | 168344 | 2020-05-22 | Canadian | Oklahoma | 40017 | 123 | 3 |
165308 | 165308 | 2020-05-21 | Canadian | Oklahoma | 40017 | 122 | 3 |
162279 | 162279 | 2020-05-20 | Canadian | Oklahoma | 40017 | 120 | 3 |
159252 | 159252 | 2020-05-19 | Canadian | Oklahoma | 40017 | 120 | 3 |
156232 | 156232 | 2020-05-18 | Canadian | Oklahoma | 40017 | 118 | 3 |
153215 | 153215 | 2020-05-17 | Canadian | Oklahoma | 40017 | 117 | 3 |
150204 | 150204 | 2020-05-16 | Canadian | Oklahoma | 40017 | 116 | 3 |
147197 | 147197 | 2020-05-15 | Canadian | Oklahoma | 40017 | 116 | 3 |
144196 | 144196 | 2020-05-14 | Canadian | Oklahoma | 40017 | 116 | 3 |
141201 | 141201 | 2020-05-13 | Canadian | Oklahoma | 40017 | 115 | 3 |
138205 | 138205 | 2020-05-12 | Canadian | Oklahoma | 40017 | 114 | 3 |
135215 | 135215 | 2020-05-11 | Canadian | Oklahoma | 40017 | 111 | 3 |
132224 | 132224 | 2020-05-10 | Canadian | Oklahoma | 40017 | 111 | 3 |
129235 | 129235 | 2020-05-09 | Canadian | Oklahoma | 40017 | 110 | 3 |
126246 | 126246 | 2020-05-08 | Canadian | Oklahoma | 40017 | 107 | 3 |
123263 | 123263 | 2020-05-07 | Canadian | Oklahoma | 40017 | 107 | 3 |
120286 | 120286 | 2020-05-06 | Canadian | Oklahoma | 40017 | 103 | 3 |
117325 | 117325 | 2020-05-05 | Canadian | Oklahoma | 40017 | 103 | 3 |
114444 | 114444 | 2020-05-04 | Canadian | Oklahoma | 40017 | 102 | 3 |
111562 | 111562 | 2020-05-03 | Canadian | Oklahoma | 40017 | 100 | 3 |
108688 | 108688 | 2020-05-02 | Canadian | Oklahoma | 40017 | 98 | 3 |
105821 | 105821 | 2020-05-01 | Canadian | Oklahoma | 40017 | 98 | 3 |
102958 | 102958 | 2020-04-30 | Canadian | Oklahoma | 40017 | 98 | 3 |
100105 | 100105 | 2020-04-29 | Canadian | Oklahoma | 40017 | 97 | 3 |
97256 | 97256 | 2020-04-28 | Canadian | Oklahoma | 40017 | 96 | 3 |
94418 | 94418 | 2020-04-27 | Canadian | Oklahoma | 40017 | 91 | 3 |
91592 | 91592 | 2020-04-26 | Canadian | Oklahoma | 40017 | 91 | 3 |
88776 | 88776 | 2020-04-25 | Canadian | Oklahoma | 40017 | 90 | 3 |
85962 | 85962 | 2020-04-24 | Canadian | Oklahoma | 40017 | 88 | 3 |
83158 | 83158 | 2020-04-23 | Canadian | Oklahoma | 40017 | 86 | 3 |
80359 | 80359 | 2020-04-22 | Canadian | Oklahoma | 40017 | 82 | 3 |
77569 | 77569 | 2020-04-21 | Canadian | Oklahoma | 40017 | 76 | 3 |
74788 | 74788 | 2020-04-20 | Canadian | Oklahoma | 40017 | 75 | 3 |
72013 | 72013 | 2020-04-19 | Canadian | Oklahoma | 40017 | 73 | 3 |
69246 | 69246 | 2020-04-18 | Canadian | Oklahoma | 40017 | 72 | 3 |
66489 | 66489 | 2020-04-17 | Canadian | Oklahoma | 40017 | 69 | 3 |
63746 | 63746 | 2020-04-16 | Canadian | Oklahoma | 40017 | 65 | 3 |
61020 | 61020 | 2020-04-15 | Canadian | Oklahoma | 40017 | 63 | 3 |
58305 | 58305 | 2020-04-14 | Canadian | Oklahoma | 40017 | 62 | 3 |
55604 | 55604 | 2020-04-13 | Canadian | Oklahoma | 40017 | 57 | 3 |
52919 | 52919 | 2020-04-12 | Canadian | Oklahoma | 40017 | 56 | 1 |
50246 | 50246 | 2020-04-11 | Canadian | Oklahoma | 40017 | 56 | 1 |
47590 | 47590 | 2020-04-10 | Canadian | Oklahoma | 40017 | 52 | 1 |
44975 | 44975 | 2020-04-09 | Canadian | Oklahoma | 40017 | 48 | 1 |
42389 | 42389 | 2020-04-08 | Canadian | Oklahoma | 40017 | 40 | 1 |
39829 | 39829 | 2020-04-07 | Canadian | Oklahoma | 40017 | 40 | 1 |
37310 | 37310 | 2020-04-06 | Canadian | Oklahoma | 40017 | 35 | 1 |
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);