ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,446 rows where county = "Logan" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Oklahoma 786
- Colorado 782
- Kentucky 782
- Ohio 782
- West Virginia 780
- Illinois 772
- Kansas 689
- North Dakota 672
- Arkansas 668
- Nebraska 633
fips 10
county 1
- Logan · 7,346 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
334788 | 334788 | 2020-07-15 | Logan | Arkansas | 5083 | 91 | 0 |
337983 | 337983 | 2020-07-16 | Logan | Arkansas | 5083 | 97 | 0 |
341179 | 341179 | 2020-07-17 | Logan | Arkansas | 5083 | 100 | 0 |
344378 | 344378 | 2020-07-18 | Logan | Arkansas | 5083 | 103 | 0 |
347578 | 347578 | 2020-07-19 | Logan | Arkansas | 5083 | 103 | 0 |
350779 | 350779 | 2020-07-20 | Logan | Arkansas | 5083 | 110 | 0 |
353981 | 353981 | 2020-07-21 | Logan | Arkansas | 5083 | 112 | 0 |
357184 | 357184 | 2020-07-22 | Logan | Arkansas | 5083 | 112 | 0 |
360389 | 360389 | 2020-07-23 | Logan | Arkansas | 5083 | 117 | 0 |
363596 | 363596 | 2020-07-24 | Logan | Arkansas | 5083 | 118 | 0 |
366803 | 366803 | 2020-07-25 | Logan | Arkansas | 5083 | 120 | 0 |
370013 | 370013 | 2020-07-26 | Logan | Arkansas | 5083 | 122 | 0 |
373225 | 373225 | 2020-07-27 | Logan | Arkansas | 5083 | 127 | 0 |
376439 | 376439 | 2020-07-28 | Logan | Arkansas | 5083 | 129 | 0 |
379655 | 379655 | 2020-07-29 | Logan | Arkansas | 5083 | 130 | 0 |
382872 | 382872 | 2020-07-30 | Logan | Arkansas | 5083 | 134 | 0 |
386090 | 386090 | 2020-07-31 | Logan | Arkansas | 5083 | 139 | 0 |
389307 | 389307 | 2020-08-01 | Logan | Arkansas | 5083 | 141 | 0 |
392524 | 392524 | 2020-08-02 | Logan | Arkansas | 5083 | 158 | 1 |
395740 | 395740 | 2020-08-03 | Logan | Arkansas | 5083 | 195 | 1 |
398956 | 398956 | 2020-08-04 | Logan | Arkansas | 5083 | 196 | 1 |
402172 | 402172 | 2020-08-05 | Logan | Arkansas | 5083 | 208 | 1 |
405390 | 405390 | 2020-08-06 | Logan | Arkansas | 5083 | 225 | 1 |
408610 | 408610 | 2020-08-07 | Logan | Arkansas | 5083 | 233 | 1 |
411829 | 411829 | 2020-08-08 | Logan | Arkansas | 5083 | 252 | 1 |
415049 | 415049 | 2020-08-09 | Logan | Arkansas | 5083 | 261 | 1 |
418270 | 418270 | 2020-08-10 | Logan | Arkansas | 5083 | 273 | 1 |
421491 | 421491 | 2020-08-11 | Logan | Arkansas | 5083 | 277 | 1 |
424712 | 424712 | 2020-08-12 | Logan | Arkansas | 5083 | 323 | 1 |
427936 | 427936 | 2020-08-13 | Logan | Arkansas | 5083 | 321 | 1 |
431164 | 431164 | 2020-08-14 | Logan | Arkansas | 5083 | 331 | 1 |
434389 | 434389 | 2020-08-15 | Logan | Arkansas | 5083 | 334 | 1 |
437615 | 437615 | 2020-08-16 | Logan | Arkansas | 5083 | 337 | 1 |
440841 | 440841 | 2020-08-17 | Logan | Arkansas | 5083 | 338 | 1 |
444067 | 444067 | 2020-08-18 | Logan | Arkansas | 5083 | 337 | 1 |
447294 | 447294 | 2020-08-19 | Logan | Arkansas | 5083 | 339 | 1 |
450522 | 450522 | 2020-08-20 | Logan | Arkansas | 5083 | 343 | 1 |
453750 | 453750 | 2020-08-21 | Logan | Arkansas | 5083 | 344 | 1 |
456978 | 456978 | 2020-08-22 | Logan | Arkansas | 5083 | 347 | 1 |
460205 | 460205 | 2020-08-23 | Logan | Arkansas | 5083 | 347 | 1 |
463434 | 463434 | 2020-08-24 | Logan | Arkansas | 5083 | 351 | 1 |
466663 | 466663 | 2020-08-25 | Logan | Arkansas | 5083 | 351 | 1 |
469892 | 469892 | 2020-08-26 | Logan | Arkansas | 5083 | 355 | 1 |
473124 | 473124 | 2020-08-27 | Logan | Arkansas | 5083 | 359 | 1 |
476357 | 476357 | 2020-08-28 | Logan | Arkansas | 5083 | 360 | 1 |
479590 | 479590 | 2020-08-29 | Logan | Arkansas | 5083 | 362 | 1 |
482824 | 482824 | 2020-08-30 | Logan | Arkansas | 5083 | 364 | 1 |
486059 | 486059 | 2020-08-31 | Logan | Arkansas | 5083 | 365 | 1 |
489292 | 489292 | 2020-09-01 | Logan | Arkansas | 5083 | 365 | 1 |
492525 | 492525 | 2020-09-02 | Logan | Arkansas | 5083 | 365 | 1 |
495759 | 495759 | 2020-09-03 | Logan | Arkansas | 5083 | 367 | 1 |
498992 | 498992 | 2020-09-04 | Logan | Arkansas | 5083 | 367 | 1 |
502226 | 502226 | 2020-09-05 | Logan | Arkansas | 5083 | 367 | 1 |
505460 | 505460 | 2020-09-06 | Logan | Arkansas | 5083 | 369 | 1 |
508692 | 508692 | 2020-09-07 | Logan | Arkansas | 5083 | 370 | 1 |
511925 | 511925 | 2020-09-08 | Logan | Arkansas | 5083 | 370 | 1 |
515158 | 515158 | 2020-09-09 | Logan | Arkansas | 5083 | 372 | 1 |
518393 | 518393 | 2020-09-10 | Logan | Arkansas | 5083 | 375 | 1 |
521630 | 521630 | 2020-09-11 | Logan | Arkansas | 5083 | 376 | 1 |
524866 | 524866 | 2020-09-12 | Logan | Arkansas | 5083 | 380 | 1 |
528102 | 528102 | 2020-09-13 | Logan | Arkansas | 5083 | 381 | 1 |
531339 | 531339 | 2020-09-14 | Logan | Arkansas | 5083 | 381 | 1 |
534574 | 534574 | 2020-09-15 | Logan | Arkansas | 5083 | 383 | 1 |
537810 | 537810 | 2020-09-16 | Logan | Arkansas | 5083 | 383 | 1 |
541047 | 541047 | 2020-09-17 | Logan | Arkansas | 5083 | 385 | 1 |
544283 | 544283 | 2020-09-18 | Logan | Arkansas | 5083 | 386 | 1 |
547521 | 547521 | 2020-09-19 | Logan | Arkansas | 5083 | 389 | 1 |
550760 | 550760 | 2020-09-20 | Logan | Arkansas | 5083 | 391 | 1 |
553999 | 553999 | 2020-09-21 | Logan | Arkansas | 5083 | 393 | 1 |
557236 | 557236 | 2020-09-22 | Logan | Arkansas | 5083 | 394 | 1 |
560472 | 560472 | 2020-09-23 | Logan | Arkansas | 5083 | 398 | 1 |
563711 | 563711 | 2020-09-24 | Logan | Arkansas | 5083 | 401 | 1 |
566951 | 566951 | 2020-09-25 | Logan | Arkansas | 5083 | 403 | 1 |
570193 | 570193 | 2020-09-26 | Logan | Arkansas | 5083 | 406 | 1 |
573435 | 573435 | 2020-09-27 | Logan | Arkansas | 5083 | 407 | 1 |
576678 | 576678 | 2020-09-28 | Logan | Arkansas | 5083 | 411 | 1 |
579919 | 579919 | 2020-09-29 | Logan | Arkansas | 5083 | 415 | 1 |
583158 | 583158 | 2020-09-30 | Logan | Arkansas | 5083 | 421 | 1 |
586398 | 586398 | 2020-10-01 | Logan | Arkansas | 5083 | 425 | 1 |
589639 | 589639 | 2020-10-02 | Logan | Arkansas | 5083 | 441 | 1 |
592879 | 592879 | 2020-10-03 | Logan | Arkansas | 5083 | 443 | 1 |
596121 | 596121 | 2020-10-04 | Logan | Arkansas | 5083 | 446 | 1 |
599364 | 599364 | 2020-10-05 | Logan | Arkansas | 5083 | 446 | 1 |
602607 | 602607 | 2020-10-06 | Logan | Arkansas | 5083 | 451 | 2 |
605849 | 605849 | 2020-10-07 | Logan | Arkansas | 5083 | 458 | 2 |
609092 | 609092 | 2020-10-08 | Logan | Arkansas | 5083 | 480 | 2 |
612334 | 612334 | 2020-10-09 | Logan | Arkansas | 5083 | 487 | 2 |
615575 | 615575 | 2020-10-10 | Logan | Arkansas | 5083 | 495 | 2 |
618817 | 618817 | 2020-10-11 | Logan | Arkansas | 5083 | 498 | 2 |
622060 | 622060 | 2020-10-12 | Logan | Arkansas | 5083 | 504 | 2 |
625303 | 625303 | 2020-10-13 | Logan | Arkansas | 5083 | 508 | 2 |
628546 | 628546 | 2020-10-14 | Logan | Arkansas | 5083 | 516 | 2 |
631790 | 631790 | 2020-10-15 | Logan | Arkansas | 5083 | 520 | 2 |
635036 | 635036 | 2020-10-16 | Logan | Arkansas | 5083 | 531 | 2 |
638281 | 638281 | 2020-10-17 | Logan | Arkansas | 5083 | 539 | 2 |
641528 | 641528 | 2020-10-18 | Logan | Arkansas | 5083 | 542 | 2 |
644776 | 644776 | 2020-10-19 | Logan | Arkansas | 5083 | 549 | 2 |
648021 | 648021 | 2020-10-20 | Logan | Arkansas | 5083 | 556 | 2 |
651265 | 651265 | 2020-10-21 | Logan | Arkansas | 5083 | 562 | 2 |
654510 | 654510 | 2020-10-22 | Logan | Arkansas | 5083 | 567 | 3 |
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);