ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,572 rows where county = "Caddo" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535549 | 535549 | 2020-09-15 | Caddo | Louisiana | 22017 | 7929 | 337 |
536571 | 536571 | 2020-09-15 | Caddo | Oklahoma | 40015 | 654 | 20 |
532314 | 532314 | 2020-09-14 | Caddo | Louisiana | 22017 | 7926 | 334 |
533335 | 533335 | 2020-09-14 | Caddo | Oklahoma | 40015 | 646 | 20 |
529077 | 529077 | 2020-09-13 | Caddo | Louisiana | 22017 | 7908 | 334 |
530100 | 530100 | 2020-09-13 | Caddo | Oklahoma | 40015 | 639 | 20 |
525841 | 525841 | 2020-09-12 | Caddo | Louisiana | 22017 | 7843 | 334 |
526863 | 526863 | 2020-09-12 | Caddo | Oklahoma | 40015 | 633 | 20 |
522605 | 522605 | 2020-09-11 | Caddo | Louisiana | 22017 | 7843 | 334 |
523627 | 523627 | 2020-09-11 | Caddo | Oklahoma | 40015 | 626 | 20 |
519368 | 519368 | 2020-09-10 | Caddo | Louisiana | 22017 | 7762 | 333 |
520391 | 520391 | 2020-09-10 | Caddo | Oklahoma | 40015 | 619 | 20 |
516133 | 516133 | 2020-09-09 | Caddo | Louisiana | 22017 | 7729 | 333 |
517155 | 517155 | 2020-09-09 | Caddo | Oklahoma | 40015 | 613 | 20 |
512900 | 512900 | 2020-09-08 | Caddo | Louisiana | 22017 | 7687 | 332 |
513920 | 513920 | 2020-09-08 | Caddo | Oklahoma | 40015 | 606 | 20 |
509668 | 509668 | 2020-09-07 | Caddo | Louisiana | 22017 | 7679 | 332 |
510687 | 510687 | 2020-09-07 | Caddo | Oklahoma | 40015 | 598 | 20 |
506435 | 506435 | 2020-09-06 | Caddo | Louisiana | 22017 | 7662 | 331 |
507454 | 507454 | 2020-09-06 | Caddo | Oklahoma | 40015 | 596 | 20 |
503201 | 503201 | 2020-09-05 | Caddo | Louisiana | 22017 | 7581 | 328 |
504222 | 504222 | 2020-09-05 | Caddo | Oklahoma | 40015 | 593 | 20 |
499968 | 499968 | 2020-09-04 | Caddo | Louisiana | 22017 | 7581 | 328 |
500988 | 500988 | 2020-09-04 | Caddo | Oklahoma | 40015 | 587 | 20 |
496734 | 496734 | 2020-09-03 | Caddo | Louisiana | 22017 | 7546 | 326 |
497754 | 497754 | 2020-09-03 | Caddo | Oklahoma | 40015 | 580 | 20 |
493501 | 493501 | 2020-09-02 | Caddo | Louisiana | 22017 | 7482 | 323 |
494521 | 494521 | 2020-09-02 | Caddo | Oklahoma | 40015 | 568 | 20 |
490267 | 490267 | 2020-09-01 | Caddo | Louisiana | 22017 | 7452 | 322 |
491287 | 491287 | 2020-09-01 | Caddo | Oklahoma | 40015 | 571 | 20 |
487034 | 487034 | 2020-08-31 | Caddo | Louisiana | 22017 | 7417 | 320 |
488054 | 488054 | 2020-08-31 | Caddo | Oklahoma | 40015 | 562 | 20 |
483799 | 483799 | 2020-08-30 | Caddo | Louisiana | 22017 | 7407 | 318 |
484821 | 484821 | 2020-08-30 | Caddo | Oklahoma | 40015 | 561 | 20 |
480565 | 480565 | 2020-08-29 | Caddo | Louisiana | 22017 | 7320 | 314 |
481586 | 481586 | 2020-08-29 | Caddo | Oklahoma | 40015 | 560 | 20 |
477332 | 477332 | 2020-08-28 | Caddo | Louisiana | 22017 | 7320 | 314 |
478352 | 478352 | 2020-08-28 | Caddo | Oklahoma | 40015 | 539 | 20 |
474099 | 474099 | 2020-08-27 | Caddo | Louisiana | 22017 | 7278 | 313 |
475119 | 475119 | 2020-08-27 | Caddo | Oklahoma | 40015 | 529 | 20 |
470867 | 470867 | 2020-08-26 | Caddo | Louisiana | 22017 | 7225 | 312 |
471885 | 471885 | 2020-08-26 | Caddo | Oklahoma | 40015 | 522 | 20 |
467638 | 467638 | 2020-08-25 | Caddo | Louisiana | 22017 | 7117 | 311 |
468653 | 468653 | 2020-08-25 | Caddo | Oklahoma | 40015 | 513 | 20 |
464409 | 464409 | 2020-08-24 | Caddo | Louisiana | 22017 | 7180 | 310 |
465425 | 465425 | 2020-08-24 | Caddo | Oklahoma | 40015 | 509 | 20 |
461178 | 461178 | 2020-08-23 | Caddo | Louisiana | 22017 | 7156 | 310 |
462196 | 462196 | 2020-08-23 | Caddo | Oklahoma | 40015 | 506 | 20 |
457951 | 457951 | 2020-08-22 | Caddo | Louisiana | 22017 | 7112 | 306 |
458968 | 458968 | 2020-08-22 | Caddo | Oklahoma | 40015 | 504 | 20 |
454723 | 454723 | 2020-08-21 | Caddo | Louisiana | 22017 | 7112 | 306 |
455740 | 455740 | 2020-08-21 | Caddo | Oklahoma | 40015 | 499 | 20 |
451495 | 451495 | 2020-08-20 | Caddo | Louisiana | 22017 | 7060 | 304 |
452512 | 452512 | 2020-08-20 | Caddo | Oklahoma | 40015 | 492 | 20 |
448267 | 448267 | 2020-08-19 | Caddo | Louisiana | 22017 | 7012 | 304 |
449284 | 449284 | 2020-08-19 | Caddo | Oklahoma | 40015 | 483 | 20 |
445040 | 445040 | 2020-08-18 | Caddo | Louisiana | 22017 | 6980 | 304 |
446056 | 446056 | 2020-08-18 | Caddo | Oklahoma | 40015 | 474 | 20 |
441814 | 441814 | 2020-08-17 | Caddo | Louisiana | 22017 | 6949 | 300 |
442830 | 442830 | 2020-08-17 | Caddo | Oklahoma | 40015 | 470 | 19 |
438587 | 438587 | 2020-08-16 | Caddo | Louisiana | 22017 | 6936 | 299 |
439603 | 439603 | 2020-08-16 | Caddo | Oklahoma | 40015 | 464 | 19 |
435362 | 435362 | 2020-08-15 | Caddo | Louisiana | 22017 | 6887 | 297 |
436378 | 436378 | 2020-08-15 | Caddo | Oklahoma | 40015 | 463 | 18 |
432137 | 432137 | 2020-08-14 | Caddo | Louisiana | 22017 | 6887 | 297 |
433152 | 433152 | 2020-08-14 | Caddo | Oklahoma | 40015 | 456 | 18 |
428909 | 428909 | 2020-08-13 | Caddo | Louisiana | 22017 | 6851 | 296 |
429926 | 429926 | 2020-08-13 | Caddo | Oklahoma | 40015 | 436 | 18 |
425685 | 425685 | 2020-08-12 | Caddo | Louisiana | 22017 | 6771 | 296 |
426701 | 426701 | 2020-08-12 | Caddo | Oklahoma | 40015 | 434 | 17 |
422464 | 422464 | 2020-08-11 | Caddo | Louisiana | 22017 | 6739 | 296 |
423478 | 423478 | 2020-08-11 | Caddo | Oklahoma | 40015 | 427 | 17 |
419242 | 419242 | 2020-08-10 | Caddo | Louisiana | 22017 | 6688 | 295 |
420255 | 420255 | 2020-08-10 | Caddo | Oklahoma | 40015 | 425 | 16 |
416021 | 416021 | 2020-08-09 | Caddo | Louisiana | 22017 | 6668 | 295 |
417035 | 417035 | 2020-08-09 | Caddo | Oklahoma | 40015 | 417 | 16 |
412801 | 412801 | 2020-08-08 | Caddo | Louisiana | 22017 | 6610 | 293 |
413814 | 413814 | 2020-08-08 | Caddo | Oklahoma | 40015 | 413 | 16 |
409581 | 409581 | 2020-08-07 | Caddo | Louisiana | 22017 | 6610 | 293 |
410594 | 410594 | 2020-08-07 | Caddo | Oklahoma | 40015 | 404 | 16 |
406361 | 406361 | 2020-08-06 | Caddo | Louisiana | 22017 | 6566 | 289 |
407374 | 407374 | 2020-08-06 | Caddo | Oklahoma | 40015 | 392 | 16 |
403143 | 403143 | 2020-08-05 | Caddo | Louisiana | 22017 | 6516 | 286 |
404155 | 404155 | 2020-08-05 | Caddo | Oklahoma | 40015 | 384 | 16 |
399926 | 399926 | 2020-08-04 | Caddo | Louisiana | 22017 | 6324 | 285 |
400937 | 400937 | 2020-08-04 | Caddo | Oklahoma | 40015 | 383 | 14 |
396711 | 396711 | 2020-08-03 | Caddo | Louisiana | 22017 | 6299 | 281 |
397722 | 397722 | 2020-08-03 | Caddo | Oklahoma | 40015 | 373 | 14 |
393495 | 393495 | 2020-08-02 | Caddo | Louisiana | 22017 | 6261 | 281 |
394505 | 394505 | 2020-08-02 | Caddo | Oklahoma | 40015 | 358 | 14 |
390278 | 390278 | 2020-08-01 | Caddo | Louisiana | 22017 | 6144 | 277 |
391289 | 391289 | 2020-08-01 | Caddo | Oklahoma | 40015 | 359 | 14 |
387061 | 387061 | 2020-07-31 | Caddo | Louisiana | 22017 | 6144 | 277 |
388072 | 388072 | 2020-07-31 | Caddo | Oklahoma | 40015 | 348 | 14 |
383843 | 383843 | 2020-07-30 | Caddo | Louisiana | 22017 | 6007 | 276 |
384855 | 384855 | 2020-07-30 | Caddo | Oklahoma | 40015 | 332 | 14 |
380626 | 380626 | 2020-07-29 | Caddo | Louisiana | 22017 | 5933 | 274 |
381637 | 381637 | 2020-07-29 | Caddo | Oklahoma | 40015 | 328 | 13 |
377409 | 377409 | 2020-07-28 | Caddo | Louisiana | 22017 | 5809 | 267 |
378420 | 378420 | 2020-07-28 | Caddo | Oklahoma | 40015 | 304 | 12 |
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);