ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Lincoln" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637072 | 637072 | 2020-10-16 | Lincoln | Oklahoma | 40081 | 687 | 10 |
633826 | 633826 | 2020-10-15 | Lincoln | Oklahoma | 40081 | 670 | 10 |
630581 | 630581 | 2020-10-14 | Lincoln | Oklahoma | 40081 | 655 | 10 |
627337 | 627337 | 2020-10-13 | Lincoln | Oklahoma | 40081 | 648 | 10 |
624095 | 624095 | 2020-10-12 | Lincoln | Oklahoma | 40081 | 648 | 10 |
620852 | 620852 | 2020-10-11 | Lincoln | Oklahoma | 40081 | 628 | 10 |
617610 | 617610 | 2020-10-10 | Lincoln | Oklahoma | 40081 | 619 | 10 |
614368 | 614368 | 2020-10-09 | Lincoln | Oklahoma | 40081 | 598 | 10 |
611127 | 611127 | 2020-10-08 | Lincoln | Oklahoma | 40081 | 574 | 10 |
607885 | 607885 | 2020-10-07 | Lincoln | Oklahoma | 40081 | 566 | 10 |
604642 | 604642 | 2020-10-06 | Lincoln | Oklahoma | 40081 | 563 | 10 |
601400 | 601400 | 2020-10-05 | Lincoln | Oklahoma | 40081 | 541 | 10 |
598157 | 598157 | 2020-10-04 | Lincoln | Oklahoma | 40081 | 541 | 10 |
594914 | 594914 | 2020-10-03 | Lincoln | Oklahoma | 40081 | 537 | 10 |
591673 | 591673 | 2020-10-02 | Lincoln | Oklahoma | 40081 | 524 | 10 |
588432 | 588432 | 2020-10-01 | Lincoln | Oklahoma | 40081 | 486 | 10 |
585192 | 585192 | 2020-09-30 | Lincoln | Oklahoma | 40081 | 476 | 10 |
581952 | 581952 | 2020-09-29 | Lincoln | Oklahoma | 40081 | 460 | 10 |
578712 | 578712 | 2020-09-28 | Lincoln | Oklahoma | 40081 | 452 | 10 |
575471 | 575471 | 2020-09-27 | Lincoln | Oklahoma | 40081 | 446 | 10 |
572227 | 572227 | 2020-09-26 | Lincoln | Oklahoma | 40081 | 441 | 10 |
568985 | 568985 | 2020-09-25 | Lincoln | Oklahoma | 40081 | 435 | 10 |
565744 | 565744 | 2020-09-24 | Lincoln | Oklahoma | 40081 | 420 | 10 |
562503 | 562503 | 2020-09-23 | Lincoln | Oklahoma | 40081 | 408 | 10 |
559266 | 559266 | 2020-09-22 | Lincoln | Oklahoma | 40081 | 398 | 10 |
556029 | 556029 | 2020-09-21 | Lincoln | Oklahoma | 40081 | 394 | 10 |
552792 | 552792 | 2020-09-20 | Lincoln | Oklahoma | 40081 | 392 | 10 |
549553 | 549553 | 2020-09-19 | Lincoln | Oklahoma | 40081 | 388 | 10 |
546314 | 546314 | 2020-09-18 | Lincoln | Oklahoma | 40081 | 379 | 10 |
543077 | 543077 | 2020-09-17 | Lincoln | Oklahoma | 40081 | 375 | 10 |
539841 | 539841 | 2020-09-16 | Lincoln | Oklahoma | 40081 | 371 | 9 |
536604 | 536604 | 2020-09-15 | Lincoln | Oklahoma | 40081 | 358 | 9 |
533368 | 533368 | 2020-09-14 | Lincoln | Oklahoma | 40081 | 354 | 9 |
530133 | 530133 | 2020-09-13 | Lincoln | Oklahoma | 40081 | 351 | 9 |
526896 | 526896 | 2020-09-12 | Lincoln | Oklahoma | 40081 | 348 | 9 |
523660 | 523660 | 2020-09-11 | Lincoln | Oklahoma | 40081 | 344 | 9 |
520424 | 520424 | 2020-09-10 | Lincoln | Oklahoma | 40081 | 338 | 9 |
517188 | 517188 | 2020-09-09 | Lincoln | Oklahoma | 40081 | 339 | 9 |
513953 | 513953 | 2020-09-08 | Lincoln | Oklahoma | 40081 | 334 | 9 |
510720 | 510720 | 2020-09-07 | Lincoln | Oklahoma | 40081 | 328 | 9 |
507487 | 507487 | 2020-09-06 | Lincoln | Oklahoma | 40081 | 326 | 9 |
504255 | 504255 | 2020-09-05 | Lincoln | Oklahoma | 40081 | 324 | 9 |
501021 | 501021 | 2020-09-04 | Lincoln | Oklahoma | 40081 | 319 | 9 |
497787 | 497787 | 2020-09-03 | Lincoln | Oklahoma | 40081 | 314 | 9 |
494554 | 494554 | 2020-09-02 | Lincoln | Oklahoma | 40081 | 305 | 8 |
491320 | 491320 | 2020-09-01 | Lincoln | Oklahoma | 40081 | 303 | 8 |
488087 | 488087 | 2020-08-31 | Lincoln | Oklahoma | 40081 | 296 | 8 |
484854 | 484854 | 2020-08-30 | Lincoln | Oklahoma | 40081 | 294 | 8 |
481619 | 481619 | 2020-08-29 | Lincoln | Oklahoma | 40081 | 292 | 8 |
478385 | 478385 | 2020-08-28 | Lincoln | Oklahoma | 40081 | 289 | 8 |
475152 | 475152 | 2020-08-27 | Lincoln | Oklahoma | 40081 | 283 | 8 |
471918 | 471918 | 2020-08-26 | Lincoln | Oklahoma | 40081 | 279 | 5 |
468686 | 468686 | 2020-08-25 | Lincoln | Oklahoma | 40081 | 276 | 5 |
465458 | 465458 | 2020-08-24 | Lincoln | Oklahoma | 40081 | 272 | 5 |
462229 | 462229 | 2020-08-23 | Lincoln | Oklahoma | 40081 | 271 | 5 |
459001 | 459001 | 2020-08-22 | Lincoln | Oklahoma | 40081 | 266 | 5 |
455773 | 455773 | 2020-08-21 | Lincoln | Oklahoma | 40081 | 261 | 5 |
452545 | 452545 | 2020-08-20 | Lincoln | Oklahoma | 40081 | 250 | 5 |
449317 | 449317 | 2020-08-19 | Lincoln | Oklahoma | 40081 | 250 | 3 |
446089 | 446089 | 2020-08-18 | Lincoln | Oklahoma | 40081 | 250 | 3 |
442863 | 442863 | 2020-08-17 | Lincoln | Oklahoma | 40081 | 248 | 3 |
439636 | 439636 | 2020-08-16 | Lincoln | Oklahoma | 40081 | 243 | 3 |
436411 | 436411 | 2020-08-15 | Lincoln | Oklahoma | 40081 | 242 | 3 |
433185 | 433185 | 2020-08-14 | Lincoln | Oklahoma | 40081 | 224 | 3 |
429959 | 429959 | 2020-08-13 | Lincoln | Oklahoma | 40081 | 190 | 3 |
426734 | 426734 | 2020-08-12 | Lincoln | Oklahoma | 40081 | 180 | 2 |
423511 | 423511 | 2020-08-11 | Lincoln | Oklahoma | 40081 | 174 | 2 |
420288 | 420288 | 2020-08-10 | Lincoln | Oklahoma | 40081 | 167 | 2 |
417068 | 417068 | 2020-08-09 | Lincoln | Oklahoma | 40081 | 164 | 2 |
413847 | 413847 | 2020-08-08 | Lincoln | Oklahoma | 40081 | 165 | 2 |
410627 | 410627 | 2020-08-07 | Lincoln | Oklahoma | 40081 | 156 | 2 |
407407 | 407407 | 2020-08-06 | Lincoln | Oklahoma | 40081 | 152 | 2 |
404188 | 404188 | 2020-08-05 | Lincoln | Oklahoma | 40081 | 147 | 2 |
400970 | 400970 | 2020-08-04 | Lincoln | Oklahoma | 40081 | 142 | 2 |
397755 | 397755 | 2020-08-03 | Lincoln | Oklahoma | 40081 | 132 | 2 |
394538 | 394538 | 2020-08-02 | Lincoln | Oklahoma | 40081 | 130 | 2 |
391322 | 391322 | 2020-08-01 | Lincoln | Oklahoma | 40081 | 125 | 2 |
388105 | 388105 | 2020-07-31 | Lincoln | Oklahoma | 40081 | 118 | 2 |
384888 | 384888 | 2020-07-30 | Lincoln | Oklahoma | 40081 | 112 | 2 |
381670 | 381670 | 2020-07-29 | Lincoln | Oklahoma | 40081 | 106 | 2 |
378453 | 378453 | 2020-07-28 | Lincoln | Oklahoma | 40081 | 104 | 2 |
375236 | 375236 | 2020-07-27 | Lincoln | Oklahoma | 40081 | 97 | 2 |
372024 | 372024 | 2020-07-26 | Lincoln | Oklahoma | 40081 | 92 | 2 |
368812 | 368812 | 2020-07-25 | Lincoln | Oklahoma | 40081 | 74 | 2 |
365603 | 365603 | 2020-07-24 | Lincoln | Oklahoma | 40081 | 71 | 2 |
362397 | 362397 | 2020-07-23 | Lincoln | Oklahoma | 40081 | 66 | 2 |
359191 | 359191 | 2020-07-22 | Lincoln | Oklahoma | 40081 | 63 | 2 |
355987 | 355987 | 2020-07-21 | Lincoln | Oklahoma | 40081 | 60 | 2 |
352784 | 352784 | 2020-07-20 | Lincoln | Oklahoma | 40081 | 58 | 2 |
349581 | 349581 | 2020-07-19 | Lincoln | Oklahoma | 40081 | 58 | 2 |
346381 | 346381 | 2020-07-18 | Lincoln | Oklahoma | 40081 | 58 | 2 |
343181 | 343181 | 2020-07-17 | Lincoln | Oklahoma | 40081 | 54 | 2 |
339983 | 339983 | 2020-07-16 | Lincoln | Oklahoma | 40081 | 53 | 2 |
336787 | 336787 | 2020-07-15 | Lincoln | Oklahoma | 40081 | 49 | 2 |
333593 | 333593 | 2020-07-14 | Lincoln | Oklahoma | 40081 | 47 | 2 |
330401 | 330401 | 2020-07-13 | Lincoln | Oklahoma | 40081 | 46 | 2 |
327214 | 327214 | 2020-07-12 | Lincoln | Oklahoma | 40081 | 44 | 2 |
324029 | 324029 | 2020-07-11 | Lincoln | Oklahoma | 40081 | 43 | 2 |
320849 | 320849 | 2020-07-10 | Lincoln | Oklahoma | 40081 | 41 | 2 |
317672 | 317672 | 2020-07-09 | Lincoln | Oklahoma | 40081 | 40 | 2 |
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);