ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Logan" and state = "Kentucky" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
291277 | 291277 | 2020-07-01 | Logan | Kentucky | 21141 | 223 | 15 |
294431 | 294431 | 2020-07-02 | Logan | Kentucky | 21141 | 222 | 15 |
297589 | 297589 | 2020-07-03 | Logan | Kentucky | 21141 | 227 | 15 |
300751 | 300751 | 2020-07-04 | Logan | Kentucky | 21141 | 227 | 15 |
303915 | 303915 | 2020-07-05 | Logan | Kentucky | 21141 | 227 | 15 |
307082 | 307082 | 2020-07-06 | Logan | Kentucky | 21141 | 242 | 17 |
310250 | 310250 | 2020-07-07 | Logan | Kentucky | 21141 | 244 | 17 |
313420 | 313420 | 2020-07-08 | Logan | Kentucky | 21141 | 248 | 17 |
316594 | 316594 | 2020-07-09 | Logan | Kentucky | 21141 | 250 | 17 |
319769 | 319769 | 2020-07-10 | Logan | Kentucky | 21141 | 249 | 17 |
322948 | 322948 | 2020-07-11 | Logan | Kentucky | 21141 | 249 | 17 |
326131 | 326131 | 2020-07-12 | Logan | Kentucky | 21141 | 249 | 17 |
329317 | 329317 | 2020-07-13 | Logan | Kentucky | 21141 | 251 | 17 |
332504 | 332504 | 2020-07-14 | Logan | Kentucky | 21141 | 257 | 16 |
335697 | 335697 | 2020-07-15 | Logan | Kentucky | 21141 | 267 | 16 |
338893 | 338893 | 2020-07-16 | Logan | Kentucky | 21141 | 267 | 16 |
342089 | 342089 | 2020-07-17 | Logan | Kentucky | 21141 | 269 | 21 |
345289 | 345289 | 2020-07-18 | Logan | Kentucky | 21141 | 269 | 21 |
348490 | 348490 | 2020-07-19 | Logan | Kentucky | 21141 | 269 | 21 |
351690 | 351690 | 2020-07-20 | Logan | Kentucky | 21141 | 276 | 21 |
354892 | 354892 | 2020-07-21 | Logan | Kentucky | 21141 | 280 | 21 |
358095 | 358095 | 2020-07-22 | Logan | Kentucky | 21141 | 285 | 21 |
361300 | 361300 | 2020-07-23 | Logan | Kentucky | 21141 | 287 | 21 |
364507 | 364507 | 2020-07-24 | Logan | Kentucky | 21141 | 289 | 21 |
367714 | 367714 | 2020-07-25 | Logan | Kentucky | 21141 | 289 | 21 |
370924 | 370924 | 2020-07-26 | Logan | Kentucky | 21141 | 289 | 21 |
374136 | 374136 | 2020-07-27 | Logan | Kentucky | 21141 | 295 | 22 |
377351 | 377351 | 2020-07-28 | Logan | Kentucky | 21141 | 299 | 22 |
380568 | 380568 | 2020-07-29 | Logan | Kentucky | 21141 | 302 | 22 |
383785 | 383785 | 2020-07-30 | Logan | Kentucky | 21141 | 301 | 22 |
387003 | 387003 | 2020-07-31 | Logan | Kentucky | 21141 | 305 | 22 |
390220 | 390220 | 2020-08-01 | Logan | Kentucky | 21141 | 305 | 22 |
393437 | 393437 | 2020-08-02 | Logan | Kentucky | 21141 | 305 | 22 |
396653 | 396653 | 2020-08-03 | Logan | Kentucky | 21141 | 307 | 22 |
399868 | 399868 | 2020-08-04 | Logan | Kentucky | 21141 | 314 | 23 |
403085 | 403085 | 2020-08-05 | Logan | Kentucky | 21141 | 318 | 23 |
406303 | 406303 | 2020-08-06 | Logan | Kentucky | 21141 | 318 | 23 |
409523 | 409523 | 2020-08-07 | Logan | Kentucky | 21141 | 324 | 23 |
412743 | 412743 | 2020-08-08 | Logan | Kentucky | 21141 | 327 | 23 |
415963 | 415963 | 2020-08-09 | Logan | Kentucky | 21141 | 328 | 23 |
419184 | 419184 | 2020-08-10 | Logan | Kentucky | 21141 | 333 | 23 |
422406 | 422406 | 2020-08-11 | Logan | Kentucky | 21141 | 339 | 23 |
425627 | 425627 | 2020-08-12 | Logan | Kentucky | 21141 | 350 | 23 |
428851 | 428851 | 2020-08-13 | Logan | Kentucky | 21141 | 360 | 23 |
432079 | 432079 | 2020-08-14 | Logan | Kentucky | 21141 | 364 | 23 |
435304 | 435304 | 2020-08-15 | Logan | Kentucky | 21141 | 364 | 23 |
438529 | 438529 | 2020-08-16 | Logan | Kentucky | 21141 | 364 | 23 |
441756 | 441756 | 2020-08-17 | Logan | Kentucky | 21141 | 373 | 23 |
444982 | 444982 | 2020-08-18 | Logan | Kentucky | 21141 | 374 | 26 |
448209 | 448209 | 2020-08-19 | Logan | Kentucky | 21141 | 382 | 26 |
451437 | 451437 | 2020-08-20 | Logan | Kentucky | 21141 | 385 | 26 |
454665 | 454665 | 2020-08-21 | Logan | Kentucky | 21141 | 385 | 26 |
457893 | 457893 | 2020-08-22 | Logan | Kentucky | 21141 | 385 | 26 |
461120 | 461120 | 2020-08-23 | Logan | Kentucky | 21141 | 385 | 26 |
464351 | 464351 | 2020-08-24 | Logan | Kentucky | 21141 | 385 | 26 |
467580 | 467580 | 2020-08-25 | Logan | Kentucky | 21141 | 391 | 26 |
470809 | 470809 | 2020-08-26 | Logan | Kentucky | 21141 | 413 | 26 |
474041 | 474041 | 2020-08-27 | Logan | Kentucky | 21141 | 422 | 26 |
477274 | 477274 | 2020-08-28 | Logan | Kentucky | 21141 | 430 | 26 |
480507 | 480507 | 2020-08-29 | Logan | Kentucky | 21141 | 430 | 26 |
483741 | 483741 | 2020-08-30 | Logan | Kentucky | 21141 | 430 | 26 |
486976 | 486976 | 2020-08-31 | Logan | Kentucky | 21141 | 440 | 26 |
490209 | 490209 | 2020-09-01 | Logan | Kentucky | 21141 | 444 | 26 |
493443 | 493443 | 2020-09-02 | Logan | Kentucky | 21141 | 451 | 26 |
496676 | 496676 | 2020-09-03 | Logan | Kentucky | 21141 | 461 | 26 |
499910 | 499910 | 2020-09-04 | Logan | Kentucky | 21141 | 465 | 26 |
503143 | 503143 | 2020-09-05 | Logan | Kentucky | 21141 | 465 | 26 |
506377 | 506377 | 2020-09-06 | Logan | Kentucky | 21141 | 465 | 26 |
509610 | 509610 | 2020-09-07 | Logan | Kentucky | 21141 | 465 | 26 |
512842 | 512842 | 2020-09-08 | Logan | Kentucky | 21141 | 471 | 26 |
516075 | 516075 | 2020-09-09 | Logan | Kentucky | 21141 | 481 | 26 |
519310 | 519310 | 2020-09-10 | Logan | Kentucky | 21141 | 488 | 26 |
522547 | 522547 | 2020-09-11 | Logan | Kentucky | 21141 | 490 | 27 |
525783 | 525783 | 2020-09-12 | Logan | Kentucky | 21141 | 490 | 27 |
529019 | 529019 | 2020-09-13 | Logan | Kentucky | 21141 | 490 | 27 |
532256 | 532256 | 2020-09-14 | Logan | Kentucky | 21141 | 490 | 27 |
535491 | 535491 | 2020-09-15 | Logan | Kentucky | 21141 | 531 | 27 |
538728 | 538728 | 2020-09-16 | Logan | Kentucky | 21141 | 547 | 27 |
541964 | 541964 | 2020-09-17 | Logan | Kentucky | 21141 | 552 | 27 |
545200 | 545200 | 2020-09-18 | Logan | Kentucky | 21141 | 549 | 27 |
548438 | 548438 | 2020-09-19 | Logan | Kentucky | 21141 | 545 | 27 |
551677 | 551677 | 2020-09-20 | Logan | Kentucky | 21141 | 548 | 27 |
554916 | 554916 | 2020-09-21 | Logan | Kentucky | 21141 | 528 | 27 |
558153 | 558153 | 2020-09-22 | Logan | Kentucky | 21141 | 532 | 27 |
561389 | 561389 | 2020-09-23 | Logan | Kentucky | 21141 | 558 | 27 |
564629 | 564629 | 2020-09-24 | Logan | Kentucky | 21141 | 567 | 27 |
567869 | 567869 | 2020-09-25 | Logan | Kentucky | 21141 | 571 | 28 |
571111 | 571111 | 2020-09-26 | Logan | Kentucky | 21141 | 571 | 28 |
574354 | 574354 | 2020-09-27 | Logan | Kentucky | 21141 | 571 | 28 |
577596 | 577596 | 2020-09-28 | Logan | Kentucky | 21141 | 575 | 28 |
580837 | 580837 | 2020-09-29 | Logan | Kentucky | 21141 | 582 | 28 |
584077 | 584077 | 2020-09-30 | Logan | Kentucky | 21141 | 589 | 28 |
587317 | 587317 | 2020-10-01 | Logan | Kentucky | 21141 | 591 | 28 |
590558 | 590558 | 2020-10-02 | Logan | Kentucky | 21141 | 594 | 28 |
593799 | 593799 | 2020-10-03 | Logan | Kentucky | 21141 | 594 | 28 |
597041 | 597041 | 2020-10-04 | Logan | Kentucky | 21141 | 594 | 29 |
600283 | 600283 | 2020-10-05 | Logan | Kentucky | 21141 | 608 | 29 |
603526 | 603526 | 2020-10-06 | Logan | Kentucky | 21141 | 614 | 29 |
606768 | 606768 | 2020-10-07 | Logan | Kentucky | 21141 | 622 | 29 |
610010 | 610010 | 2020-10-08 | Logan | Kentucky | 21141 | 630 | 30 |
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);