ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Crawford" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917319 | 917319 | 2021-01-11 | Crawford | Arkansas | 5033 | 5201 | 68 |
914074 | 914074 | 2021-01-10 | Crawford | Arkansas | 5033 | 5145 | 66 |
910829 | 910829 | 2021-01-09 | Crawford | Arkansas | 5033 | 5033 | 66 |
907584 | 907584 | 2021-01-08 | Crawford | Arkansas | 5033 | 4987 | 66 |
904338 | 904338 | 2021-01-07 | Crawford | Arkansas | 5033 | 4917 | 66 |
901093 | 901093 | 2021-01-06 | Crawford | Arkansas | 5033 | 4869 | 66 |
897848 | 897848 | 2021-01-05 | Crawford | Arkansas | 5033 | 4799 | 64 |
894603 | 894603 | 2021-01-04 | Crawford | Arkansas | 5033 | 4681 | 62 |
891356 | 891356 | 2021-01-03 | Crawford | Arkansas | 5033 | 4648 | 61 |
888109 | 888109 | 2021-01-02 | Crawford | Arkansas | 5033 | 4601 | 60 |
884864 | 884864 | 2021-01-01 | Crawford | Arkansas | 5033 | 4542 | 59 |
881619 | 881619 | 2020-12-31 | Crawford | Arkansas | 5033 | 4451 | 58 |
878374 | 878374 | 2020-12-30 | Crawford | Arkansas | 5033 | 4402 | 58 |
875129 | 875129 | 2020-12-29 | Crawford | Arkansas | 5033 | 4323 | 58 |
871884 | 871884 | 2020-12-28 | Crawford | Arkansas | 5033 | 4285 | 58 |
868639 | 868639 | 2020-12-27 | Crawford | Arkansas | 5033 | 4241 | 58 |
865394 | 865394 | 2020-12-26 | Crawford | Arkansas | 5033 | 4223 | 58 |
862149 | 862149 | 2020-12-25 | Crawford | Arkansas | 5033 | 4214 | 58 |
858904 | 858904 | 2020-12-24 | Crawford | Arkansas | 5033 | 4171 | 58 |
855659 | 855659 | 2020-12-23 | Crawford | Arkansas | 5033 | 4121 | 58 |
852414 | 852414 | 2020-12-22 | Crawford | Arkansas | 5033 | 4093 | 57 |
849169 | 849169 | 2020-12-21 | Crawford | Arkansas | 5033 | 4056 | 57 |
845924 | 845924 | 2020-12-20 | Crawford | Arkansas | 5033 | 4016 | 56 |
842678 | 842678 | 2020-12-19 | Crawford | Arkansas | 5033 | 3973 | 53 |
839433 | 839433 | 2020-12-18 | Crawford | Arkansas | 5033 | 3921 | 50 |
836188 | 836188 | 2020-12-17 | Crawford | Arkansas | 5033 | 3858 | 50 |
832942 | 832942 | 2020-12-16 | Crawford | Arkansas | 5033 | 3812 | 50 |
829695 | 829695 | 2020-12-15 | Crawford | Arkansas | 5033 | 3768 | 48 |
826449 | 826449 | 2020-12-14 | Crawford | Arkansas | 5033 | 3717 | 48 |
823202 | 823202 | 2020-12-13 | Crawford | Arkansas | 5033 | 3678 | 47 |
819956 | 819956 | 2020-12-12 | Crawford | Arkansas | 5033 | 3653 | 46 |
816710 | 816710 | 2020-12-11 | Crawford | Arkansas | 5033 | 3591 | 45 |
813464 | 813464 | 2020-12-10 | Crawford | Arkansas | 5033 | 3546 | 45 |
810220 | 810220 | 2020-12-09 | Crawford | Arkansas | 5033 | 3498 | 44 |
806975 | 806975 | 2020-12-08 | Crawford | Arkansas | 5033 | 3431 | 44 |
803730 | 803730 | 2020-12-07 | Crawford | Arkansas | 5033 | 3389 | 44 |
800485 | 800485 | 2020-12-06 | Crawford | Arkansas | 5033 | 3367 | 41 |
797240 | 797240 | 2020-12-05 | Crawford | Arkansas | 5033 | 3331 | 40 |
793995 | 793995 | 2020-12-04 | Crawford | Arkansas | 5033 | 3267 | 40 |
790750 | 790750 | 2020-12-03 | Crawford | Arkansas | 5033 | 3237 | 39 |
787505 | 787505 | 2020-12-02 | Crawford | Arkansas | 5033 | 3163 | 38 |
784261 | 784261 | 2020-12-01 | Crawford | Arkansas | 5033 | 3126 | 38 |
781016 | 781016 | 2020-11-30 | Crawford | Arkansas | 5033 | 3081 | 38 |
777770 | 777770 | 2020-11-29 | Crawford | Arkansas | 5033 | 3066 | 37 |
774525 | 774525 | 2020-11-28 | Crawford | Arkansas | 5033 | 3052 | 36 |
771280 | 771280 | 2020-11-27 | Crawford | Arkansas | 5033 | 3010 | 36 |
768035 | 768035 | 2020-11-26 | Crawford | Arkansas | 5033 | 3001 | 36 |
764789 | 764789 | 2020-11-25 | Crawford | Arkansas | 5033 | 2974 | 36 |
761544 | 761544 | 2020-11-24 | Crawford | Arkansas | 5033 | 2945 | 35 |
758299 | 758299 | 2020-11-23 | Crawford | Arkansas | 5033 | 2914 | 35 |
755052 | 755052 | 2020-11-22 | Crawford | Arkansas | 5033 | 2888 | 35 |
751806 | 751806 | 2020-11-21 | Crawford | Arkansas | 5033 | 2860 | 35 |
748560 | 748560 | 2020-11-20 | Crawford | Arkansas | 5033 | 2818 | 35 |
745314 | 745314 | 2020-11-19 | Crawford | Arkansas | 5033 | 2785 | 35 |
742067 | 742067 | 2020-11-18 | Crawford | Arkansas | 5033 | 2731 | 34 |
738820 | 738820 | 2020-11-17 | Crawford | Arkansas | 5033 | 2711 | 34 |
735576 | 735576 | 2020-11-16 | Crawford | Arkansas | 5033 | 2677 | 34 |
732330 | 732330 | 2020-11-15 | Crawford | Arkansas | 5033 | 2646 | 33 |
729085 | 729085 | 2020-11-14 | Crawford | Arkansas | 5033 | 2613 | 33 |
725842 | 725842 | 2020-11-13 | Crawford | Arkansas | 5033 | 2579 | 33 |
722599 | 722599 | 2020-11-12 | Crawford | Arkansas | 5033 | 2519 | 33 |
719356 | 719356 | 2020-11-11 | Crawford | Arkansas | 5033 | 2477 | 33 |
716113 | 716113 | 2020-11-10 | Crawford | Arkansas | 5033 | 2432 | 33 |
712869 | 712869 | 2020-11-09 | Crawford | Arkansas | 5033 | 2401 | 33 |
709625 | 709625 | 2020-11-08 | Crawford | Arkansas | 5033 | 2376 | 33 |
706381 | 706381 | 2020-11-07 | Crawford | Arkansas | 5033 | 2357 | 32 |
703138 | 703138 | 2020-11-06 | Crawford | Arkansas | 5033 | 2334 | 31 |
699895 | 699895 | 2020-11-05 | Crawford | Arkansas | 5033 | 2291 | 31 |
696651 | 696651 | 2020-11-04 | Crawford | Arkansas | 5033 | 2250 | 31 |
693409 | 693409 | 2020-11-03 | Crawford | Arkansas | 5033 | 2224 | 30 |
690166 | 690166 | 2020-11-02 | Crawford | Arkansas | 5033 | 2204 | 30 |
686921 | 686921 | 2020-11-01 | Crawford | Arkansas | 5033 | 2189 | 30 |
683677 | 683677 | 2020-10-31 | Crawford | Arkansas | 5033 | 2148 | 29 |
680434 | 680434 | 2020-10-30 | Crawford | Arkansas | 5033 | 2119 | 27 |
677191 | 677191 | 2020-10-29 | Crawford | Arkansas | 5033 | 2086 | 27 |
673948 | 673948 | 2020-10-28 | Crawford | Arkansas | 5033 | 2063 | 26 |
670706 | 670706 | 2020-10-27 | Crawford | Arkansas | 5033 | 2035 | 26 |
667463 | 667463 | 2020-10-26 | Crawford | Arkansas | 5033 | 2018 | 25 |
664218 | 664218 | 2020-10-25 | Crawford | Arkansas | 5033 | 2007 | 25 |
660974 | 660974 | 2020-10-24 | Crawford | Arkansas | 5033 | 1996 | 24 |
657730 | 657730 | 2020-10-23 | Crawford | Arkansas | 5033 | 1980 | 25 |
654485 | 654485 | 2020-10-22 | Crawford | Arkansas | 5033 | 1936 | 25 |
651240 | 651240 | 2020-10-21 | Crawford | Arkansas | 5033 | 1920 | 25 |
647996 | 647996 | 2020-10-20 | Crawford | Arkansas | 5033 | 1904 | 24 |
644751 | 644751 | 2020-10-19 | Crawford | Arkansas | 5033 | 1877 | 25 |
641503 | 641503 | 2020-10-18 | Crawford | Arkansas | 5033 | 1867 | 25 |
638256 | 638256 | 2020-10-17 | Crawford | Arkansas | 5033 | 1855 | 24 |
635011 | 635011 | 2020-10-16 | Crawford | Arkansas | 5033 | 1821 | 24 |
631765 | 631765 | 2020-10-15 | Crawford | Arkansas | 5033 | 1803 | 22 |
628521 | 628521 | 2020-10-14 | Crawford | Arkansas | 5033 | 1778 | 22 |
625278 | 625278 | 2020-10-13 | Crawford | Arkansas | 5033 | 1758 | 22 |
622035 | 622035 | 2020-10-12 | Crawford | Arkansas | 5033 | 1750 | 21 |
618792 | 618792 | 2020-10-11 | Crawford | Arkansas | 5033 | 1736 | 21 |
615550 | 615550 | 2020-10-10 | Crawford | Arkansas | 5033 | 1704 | 20 |
612309 | 612309 | 2020-10-09 | Crawford | Arkansas | 5033 | 1683 | 20 |
609067 | 609067 | 2020-10-08 | Crawford | Arkansas | 5033 | 1655 | 20 |
605824 | 605824 | 2020-10-07 | Crawford | Arkansas | 5033 | 1603 | 20 |
602582 | 602582 | 2020-10-06 | Crawford | Arkansas | 5033 | 1589 | 20 |
599339 | 599339 | 2020-10-05 | Crawford | Arkansas | 5033 | 1575 | 17 |
596096 | 596096 | 2020-10-04 | Crawford | Arkansas | 5033 | 1560 | 16 |
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);