ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 40049 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536588 | 536588 | 2020-09-15 | Garvin | Oklahoma | 40049 | 315 | 4 |
533352 | 533352 | 2020-09-14 | Garvin | Oklahoma | 40049 | 311 | 4 |
530117 | 530117 | 2020-09-13 | Garvin | Oklahoma | 40049 | 311 | 4 |
526880 | 526880 | 2020-09-12 | Garvin | Oklahoma | 40049 | 308 | 4 |
523644 | 523644 | 2020-09-11 | Garvin | Oklahoma | 40049 | 295 | 4 |
520408 | 520408 | 2020-09-10 | Garvin | Oklahoma | 40049 | 290 | 4 |
517172 | 517172 | 2020-09-09 | Garvin | Oklahoma | 40049 | 288 | 4 |
513937 | 513937 | 2020-09-08 | Garvin | Oklahoma | 40049 | 284 | 4 |
510704 | 510704 | 2020-09-07 | Garvin | Oklahoma | 40049 | 279 | 4 |
507471 | 507471 | 2020-09-06 | Garvin | Oklahoma | 40049 | 274 | 4 |
504239 | 504239 | 2020-09-05 | Garvin | Oklahoma | 40049 | 274 | 4 |
501005 | 501005 | 2020-09-04 | Garvin | Oklahoma | 40049 | 269 | 4 |
497771 | 497771 | 2020-09-03 | Garvin | Oklahoma | 40049 | 266 | 4 |
494538 | 494538 | 2020-09-02 | Garvin | Oklahoma | 40049 | 264 | 4 |
491304 | 491304 | 2020-09-01 | Garvin | Oklahoma | 40049 | 261 | 4 |
488071 | 488071 | 2020-08-31 | Garvin | Oklahoma | 40049 | 261 | 4 |
484838 | 484838 | 2020-08-30 | Garvin | Oklahoma | 40049 | 264 | 4 |
481603 | 481603 | 2020-08-29 | Garvin | Oklahoma | 40049 | 263 | 4 |
478369 | 478369 | 2020-08-28 | Garvin | Oklahoma | 40049 | 262 | 4 |
475136 | 475136 | 2020-08-27 | Garvin | Oklahoma | 40049 | 258 | 4 |
471902 | 471902 | 2020-08-26 | Garvin | Oklahoma | 40049 | 258 | 4 |
468670 | 468670 | 2020-08-25 | Garvin | Oklahoma | 40049 | 255 | 4 |
465442 | 465442 | 2020-08-24 | Garvin | Oklahoma | 40049 | 257 | 4 |
462213 | 462213 | 2020-08-23 | Garvin | Oklahoma | 40049 | 252 | 4 |
458985 | 458985 | 2020-08-22 | Garvin | Oklahoma | 40049 | 253 | 4 |
455757 | 455757 | 2020-08-21 | Garvin | Oklahoma | 40049 | 250 | 4 |
452529 | 452529 | 2020-08-20 | Garvin | Oklahoma | 40049 | 250 | 4 |
449301 | 449301 | 2020-08-19 | Garvin | Oklahoma | 40049 | 248 | 4 |
446073 | 446073 | 2020-08-18 | Garvin | Oklahoma | 40049 | 244 | 4 |
442847 | 442847 | 2020-08-17 | Garvin | Oklahoma | 40049 | 242 | 4 |
439620 | 439620 | 2020-08-16 | Garvin | Oklahoma | 40049 | 242 | 4 |
436395 | 436395 | 2020-08-15 | Garvin | Oklahoma | 40049 | 241 | 4 |
433169 | 433169 | 2020-08-14 | Garvin | Oklahoma | 40049 | 238 | 4 |
429943 | 429943 | 2020-08-13 | Garvin | Oklahoma | 40049 | 235 | 4 |
426718 | 426718 | 2020-08-12 | Garvin | Oklahoma | 40049 | 236 | 4 |
423495 | 423495 | 2020-08-11 | Garvin | Oklahoma | 40049 | 235 | 4 |
420272 | 420272 | 2020-08-10 | Garvin | Oklahoma | 40049 | 227 | 4 |
417052 | 417052 | 2020-08-09 | Garvin | Oklahoma | 40049 | 226 | 4 |
413831 | 413831 | 2020-08-08 | Garvin | Oklahoma | 40049 | 225 | 4 |
410611 | 410611 | 2020-08-07 | Garvin | Oklahoma | 40049 | 221 | 4 |
407391 | 407391 | 2020-08-06 | Garvin | Oklahoma | 40049 | 220 | 4 |
404172 | 404172 | 2020-08-05 | Garvin | Oklahoma | 40049 | 215 | 4 |
400954 | 400954 | 2020-08-04 | Garvin | Oklahoma | 40049 | 218 | 4 |
397739 | 397739 | 2020-08-03 | Garvin | Oklahoma | 40049 | 208 | 4 |
394522 | 394522 | 2020-08-02 | Garvin | Oklahoma | 40049 | 206 | 4 |
391306 | 391306 | 2020-08-01 | Garvin | Oklahoma | 40049 | 202 | 4 |
388089 | 388089 | 2020-07-31 | Garvin | Oklahoma | 40049 | 197 | 4 |
384872 | 384872 | 2020-07-30 | Garvin | Oklahoma | 40049 | 196 | 4 |
381654 | 381654 | 2020-07-29 | Garvin | Oklahoma | 40049 | 190 | 4 |
378437 | 378437 | 2020-07-28 | Garvin | Oklahoma | 40049 | 184 | 4 |
375220 | 375220 | 2020-07-27 | Garvin | Oklahoma | 40049 | 176 | 4 |
372008 | 372008 | 2020-07-26 | Garvin | Oklahoma | 40049 | 173 | 4 |
368796 | 368796 | 2020-07-25 | Garvin | Oklahoma | 40049 | 172 | 4 |
365587 | 365587 | 2020-07-24 | Garvin | Oklahoma | 40049 | 166 | 3 |
362381 | 362381 | 2020-07-23 | Garvin | Oklahoma | 40049 | 154 | 3 |
359175 | 359175 | 2020-07-22 | Garvin | Oklahoma | 40049 | 152 | 3 |
355971 | 355971 | 2020-07-21 | Garvin | Oklahoma | 40049 | 151 | 3 |
352768 | 352768 | 2020-07-20 | Garvin | Oklahoma | 40049 | 146 | 3 |
349565 | 349565 | 2020-07-19 | Garvin | Oklahoma | 40049 | 145 | 3 |
346365 | 346365 | 2020-07-18 | Garvin | Oklahoma | 40049 | 145 | 3 |
343165 | 343165 | 2020-07-17 | Garvin | Oklahoma | 40049 | 143 | 3 |
339967 | 339967 | 2020-07-16 | Garvin | Oklahoma | 40049 | 143 | 3 |
336771 | 336771 | 2020-07-15 | Garvin | Oklahoma | 40049 | 140 | 3 |
333577 | 333577 | 2020-07-14 | Garvin | Oklahoma | 40049 | 133 | 3 |
330385 | 330385 | 2020-07-13 | Garvin | Oklahoma | 40049 | 123 | 3 |
327198 | 327198 | 2020-07-12 | Garvin | Oklahoma | 40049 | 122 | 3 |
324013 | 324013 | 2020-07-11 | Garvin | Oklahoma | 40049 | 122 | 3 |
320833 | 320833 | 2020-07-10 | Garvin | Oklahoma | 40049 | 111 | 3 |
317656 | 317656 | 2020-07-09 | Garvin | Oklahoma | 40049 | 106 | 2 |
314483 | 314483 | 2020-07-08 | Garvin | Oklahoma | 40049 | 98 | 2 |
311311 | 311311 | 2020-07-07 | Garvin | Oklahoma | 40049 | 94 | 2 |
308142 | 308142 | 2020-07-06 | Garvin | Oklahoma | 40049 | 91 | 1 |
304975 | 304975 | 2020-07-05 | Garvin | Oklahoma | 40049 | 91 | 1 |
301812 | 301812 | 2020-07-04 | Garvin | Oklahoma | 40049 | 89 | 1 |
298649 | 298649 | 2020-07-03 | Garvin | Oklahoma | 40049 | 81 | 1 |
295490 | 295490 | 2020-07-02 | Garvin | Oklahoma | 40049 | 73 | 1 |
292334 | 292334 | 2020-07-01 | Garvin | Oklahoma | 40049 | 73 | 1 |
289182 | 289182 | 2020-06-30 | Garvin | Oklahoma | 40049 | 70 | 1 |
286032 | 286032 | 2020-06-29 | Garvin | Oklahoma | 40049 | 69 | 1 |
282887 | 282887 | 2020-06-28 | Garvin | Oklahoma | 40049 | 68 | 1 |
279741 | 279741 | 2020-06-27 | Garvin | Oklahoma | 40049 | 62 | 1 |
276593 | 276593 | 2020-06-26 | Garvin | Oklahoma | 40049 | 58 | 1 |
273446 | 273446 | 2020-06-25 | Garvin | Oklahoma | 40049 | 54 | 1 |
270307 | 270307 | 2020-06-24 | Garvin | Oklahoma | 40049 | 52 | 1 |
267173 | 267173 | 2020-06-23 | Garvin | Oklahoma | 40049 | 51 | 1 |
264045 | 264045 | 2020-06-22 | Garvin | Oklahoma | 40049 | 49 | 1 |
260917 | 260917 | 2020-06-21 | Garvin | Oklahoma | 40049 | 45 | 1 |
257790 | 257790 | 2020-06-20 | Garvin | Oklahoma | 40049 | 43 | 1 |
254664 | 254664 | 2020-06-19 | Garvin | Oklahoma | 40049 | 41 | 1 |
251549 | 251549 | 2020-06-18 | Garvin | Oklahoma | 40049 | 39 | 1 |
248434 | 248434 | 2020-06-17 | Garvin | Oklahoma | 40049 | 33 | 1 |
245321 | 245321 | 2020-06-16 | Garvin | Oklahoma | 40049 | 33 | 1 |
242209 | 242209 | 2020-06-15 | Garvin | Oklahoma | 40049 | 30 | 1 |
239100 | 239100 | 2020-06-14 | Garvin | Oklahoma | 40049 | 28 | 1 |
235992 | 235992 | 2020-06-13 | Garvin | Oklahoma | 40049 | 20 | 1 |
232887 | 232887 | 2020-06-12 | Garvin | Oklahoma | 40049 | 20 | 1 |
229782 | 229782 | 2020-06-11 | Garvin | Oklahoma | 40049 | 20 | 1 |
226678 | 226678 | 2020-06-10 | Garvin | Oklahoma | 40049 | 20 | 1 |
223578 | 223578 | 2020-06-09 | Garvin | Oklahoma | 40049 | 20 | 1 |
220483 | 220483 | 2020-06-08 | Garvin | Oklahoma | 40049 | 20 | 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);