ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Union" and fips = 5139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635064 | 635064 | 2020-10-16 | Union | Arkansas | 5139 | 1057 | 47 |
631818 | 631818 | 2020-10-15 | Union | Arkansas | 5139 | 1049 | 47 |
628574 | 628574 | 2020-10-14 | Union | Arkansas | 5139 | 1028 | 47 |
625331 | 625331 | 2020-10-13 | Union | Arkansas | 5139 | 1024 | 47 |
622088 | 622088 | 2020-10-12 | Union | Arkansas | 5139 | 1010 | 47 |
618845 | 618845 | 2020-10-11 | Union | Arkansas | 5139 | 1009 | 47 |
615603 | 615603 | 2020-10-10 | Union | Arkansas | 5139 | 1007 | 47 |
612362 | 612362 | 2020-10-09 | Union | Arkansas | 5139 | 1002 | 47 |
609120 | 609120 | 2020-10-08 | Union | Arkansas | 5139 | 983 | 47 |
605877 | 605877 | 2020-10-07 | Union | Arkansas | 5139 | 960 | 47 |
602635 | 602635 | 2020-10-06 | Union | Arkansas | 5139 | 948 | 47 |
599392 | 599392 | 2020-10-05 | Union | Arkansas | 5139 | 945 | 47 |
596149 | 596149 | 2020-10-04 | Union | Arkansas | 5139 | 943 | 47 |
592907 | 592907 | 2020-10-03 | Union | Arkansas | 5139 | 942 | 46 |
589667 | 589667 | 2020-10-02 | Union | Arkansas | 5139 | 935 | 46 |
586426 | 586426 | 2020-10-01 | Union | Arkansas | 5139 | 924 | 46 |
583186 | 583186 | 2020-09-30 | Union | Arkansas | 5139 | 911 | 40 |
579947 | 579947 | 2020-09-29 | Union | Arkansas | 5139 | 901 | 38 |
576706 | 576706 | 2020-09-28 | Union | Arkansas | 5139 | 894 | 37 |
573463 | 573463 | 2020-09-27 | Union | Arkansas | 5139 | 892 | 36 |
570221 | 570221 | 2020-09-26 | Union | Arkansas | 5139 | 891 | 36 |
566979 | 566979 | 2020-09-25 | Union | Arkansas | 5139 | 880 | 34 |
563739 | 563739 | 2020-09-24 | Union | Arkansas | 5139 | 874 | 32 |
560500 | 560500 | 2020-09-23 | Union | Arkansas | 5139 | 858 | 32 |
557264 | 557264 | 2020-09-22 | Union | Arkansas | 5139 | 849 | 31 |
554027 | 554027 | 2020-09-21 | Union | Arkansas | 5139 | 841 | 31 |
550788 | 550788 | 2020-09-20 | Union | Arkansas | 5139 | 840 | 31 |
547549 | 547549 | 2020-09-19 | Union | Arkansas | 5139 | 839 | 31 |
544311 | 544311 | 2020-09-18 | Union | Arkansas | 5139 | 836 | 31 |
541075 | 541075 | 2020-09-17 | Union | Arkansas | 5139 | 833 | 31 |
537838 | 537838 | 2020-09-16 | Union | Arkansas | 5139 | 827 | 31 |
534602 | 534602 | 2020-09-15 | Union | Arkansas | 5139 | 816 | 31 |
531367 | 531367 | 2020-09-14 | Union | Arkansas | 5139 | 801 | 25 |
528130 | 528130 | 2020-09-13 | Union | Arkansas | 5139 | 796 | 25 |
524894 | 524894 | 2020-09-12 | Union | Arkansas | 5139 | 785 | 25 |
521658 | 521658 | 2020-09-11 | Union | Arkansas | 5139 | 770 | 25 |
518421 | 518421 | 2020-09-10 | Union | Arkansas | 5139 | 755 | 25 |
515186 | 515186 | 2020-09-09 | Union | Arkansas | 5139 | 748 | 25 |
511953 | 511953 | 2020-09-08 | Union | Arkansas | 5139 | 740 | 22 |
508720 | 508720 | 2020-09-07 | Union | Arkansas | 5139 | 731 | 22 |
505488 | 505488 | 2020-09-06 | Union | Arkansas | 5139 | 725 | 22 |
502254 | 502254 | 2020-09-05 | Union | Arkansas | 5139 | 724 | 21 |
499020 | 499020 | 2020-09-04 | Union | Arkansas | 5139 | 721 | 21 |
495787 | 495787 | 2020-09-03 | Union | Arkansas | 5139 | 707 | 21 |
492553 | 492553 | 2020-09-02 | Union | Arkansas | 5139 | 698 | 20 |
489320 | 489320 | 2020-09-01 | Union | Arkansas | 5139 | 692 | 20 |
486087 | 486087 | 2020-08-31 | Union | Arkansas | 5139 | 691 | 20 |
482852 | 482852 | 2020-08-30 | Union | Arkansas | 5139 | 690 | 19 |
479618 | 479618 | 2020-08-29 | Union | Arkansas | 5139 | 689 | 20 |
476385 | 476385 | 2020-08-28 | Union | Arkansas | 5139 | 683 | 20 |
473152 | 473152 | 2020-08-27 | Union | Arkansas | 5139 | 670 | 20 |
469920 | 469920 | 2020-08-26 | Union | Arkansas | 5139 | 653 | 20 |
466691 | 466691 | 2020-08-25 | Union | Arkansas | 5139 | 650 | 21 |
463462 | 463462 | 2020-08-24 | Union | Arkansas | 5139 | 634 | 21 |
460233 | 460233 | 2020-08-23 | Union | Arkansas | 5139 | 627 | 21 |
457006 | 457006 | 2020-08-22 | Union | Arkansas | 5139 | 624 | 21 |
453778 | 453778 | 2020-08-21 | Union | Arkansas | 5139 | 612 | 21 |
450550 | 450550 | 2020-08-20 | Union | Arkansas | 5139 | 597 | 21 |
447322 | 447322 | 2020-08-19 | Union | Arkansas | 5139 | 589 | 21 |
444095 | 444095 | 2020-08-18 | Union | Arkansas | 5139 | 578 | 21 |
440869 | 440869 | 2020-08-17 | Union | Arkansas | 5139 | 561 | 20 |
437643 | 437643 | 2020-08-16 | Union | Arkansas | 5139 | 556 | 20 |
434417 | 434417 | 2020-08-15 | Union | Arkansas | 5139 | 553 | 20 |
431192 | 431192 | 2020-08-14 | Union | Arkansas | 5139 | 539 | 20 |
427964 | 427964 | 2020-08-13 | Union | Arkansas | 5139 | 532 | 19 |
424740 | 424740 | 2020-08-12 | Union | Arkansas | 5139 | 523 | 19 |
421519 | 421519 | 2020-08-11 | Union | Arkansas | 5139 | 508 | 18 |
418298 | 418298 | 2020-08-10 | Union | Arkansas | 5139 | 504 | 18 |
415077 | 415077 | 2020-08-09 | Union | Arkansas | 5139 | 499 | 17 |
411857 | 411857 | 2020-08-08 | Union | Arkansas | 5139 | 478 | 17 |
408638 | 408638 | 2020-08-07 | Union | Arkansas | 5139 | 472 | 17 |
405418 | 405418 | 2020-08-06 | Union | Arkansas | 5139 | 464 | 17 |
402200 | 402200 | 2020-08-05 | Union | Arkansas | 5139 | 458 | 17 |
398984 | 398984 | 2020-08-04 | Union | Arkansas | 5139 | 452 | 17 |
395768 | 395768 | 2020-08-03 | Union | Arkansas | 5139 | 435 | 16 |
392552 | 392552 | 2020-08-02 | Union | Arkansas | 5139 | 433 | 16 |
389335 | 389335 | 2020-08-01 | Union | Arkansas | 5139 | 430 | 16 |
386118 | 386118 | 2020-07-31 | Union | Arkansas | 5139 | 428 | 16 |
382900 | 382900 | 2020-07-30 | Union | Arkansas | 5139 | 396 | 16 |
379683 | 379683 | 2020-07-29 | Union | Arkansas | 5139 | 379 | 16 |
376467 | 376467 | 2020-07-28 | Union | Arkansas | 5139 | 376 | 15 |
373253 | 373253 | 2020-07-27 | Union | Arkansas | 5139 | 373 | 15 |
370041 | 370041 | 2020-07-26 | Union | Arkansas | 5139 | 369 | 15 |
366831 | 366831 | 2020-07-25 | Union | Arkansas | 5139 | 361 | 15 |
363624 | 363624 | 2020-07-24 | Union | Arkansas | 5139 | 350 | 15 |
360417 | 360417 | 2020-07-23 | Union | Arkansas | 5139 | 345 | 15 |
357212 | 357212 | 2020-07-22 | Union | Arkansas | 5139 | 335 | 14 |
354009 | 354009 | 2020-07-21 | Union | Arkansas | 5139 | 333 | 14 |
350807 | 350807 | 2020-07-20 | Union | Arkansas | 5139 | 313 | 14 |
347606 | 347606 | 2020-07-19 | Union | Arkansas | 5139 | 306 | 14 |
344406 | 344406 | 2020-07-18 | Union | Arkansas | 5139 | 305 | 14 |
341207 | 341207 | 2020-07-17 | Union | Arkansas | 5139 | 292 | 14 |
338011 | 338011 | 2020-07-16 | Union | Arkansas | 5139 | 287 | 14 |
334816 | 334816 | 2020-07-15 | Union | Arkansas | 5139 | 284 | 14 |
331623 | 331623 | 2020-07-14 | Union | Arkansas | 5139 | 282 | 14 |
328437 | 328437 | 2020-07-13 | Union | Arkansas | 5139 | 275 | 14 |
325251 | 325251 | 2020-07-12 | Union | Arkansas | 5139 | 274 | 14 |
322070 | 322070 | 2020-07-11 | Union | Arkansas | 5139 | 273 | 14 |
318891 | 318891 | 2020-07-10 | Union | Arkansas | 5139 | 267 | 13 |
315718 | 315718 | 2020-07-09 | Union | Arkansas | 5139 | 266 | 13 |
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);