ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

53 rows where deaths = 133 and state = "Arkansas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips 13

state 1

  • Arkansas · 53 ✖
Link rowid date ▲ county state fips cases deaths
2398766 2398766 2022-04-12 Hot Spring Arkansas 5059 11172 133
2395511 2395511 2022-04-11 Hot Spring Arkansas 5059 11170 133
2242656 2242656 2022-02-23 Polk Arkansas 5113 4053 133
2239405 2239405 2022-02-22 Polk Arkansas 5113 4051 133
2236154 2236154 2022-02-21 Polk Arkansas 5113 4044 133
2232903 2232903 2022-02-20 Polk Arkansas 5113 4042 133
2229652 2229652 2022-02-19 Polk Arkansas 5113 4036 133
2226401 2226401 2022-02-18 Polk Arkansas 5113 4031 133
2223150 2223150 2022-02-17 Polk Arkansas 5113 4020 133
2219899 2219899 2022-02-16 Polk Arkansas 5113 4017 133
2216648 2216648 2022-02-15 Polk Arkansas 5113 4011 133
2213397 2213397 2022-02-14 Polk Arkansas 5113 4005 133
2210145 2210145 2022-02-13 Polk Arkansas 5113 3993 133
2206892 2206892 2022-02-12 Polk Arkansas 5113 3989 133
2203639 2203639 2022-02-11 Polk Arkansas 5113 3984 133
2200386 2200386 2022-02-10 Polk Arkansas 5113 3973 133
2197132 2197132 2022-02-09 Polk Arkansas 5113 3961 133
2193877 2193877 2022-02-08 Polk Arkansas 5113 3946 133
2190624 2190624 2022-02-07 Polk Arkansas 5113 3926 133
2066999 2066999 2021-12-31 Greene Arkansas 5055 11173 133
2063748 2063748 2021-12-30 Greene Arkansas 5055 11086 133
2060498 2060498 2021-12-29 Greene Arkansas 5055 11003 133
2027977 2027977 2021-12-19 Boone Arkansas 5009 6783 133
2024726 2024726 2021-12-18 Boone Arkansas 5009 6779 133
2021475 2021475 2021-12-17 Boone Arkansas 5009 6766 133
2018224 2018224 2021-12-16 Boone Arkansas 5009 6749 133
2014974 2014974 2021-12-15 Boone Arkansas 5009 6740 133
2011723 2011723 2021-12-14 Boone Arkansas 5009 6712 133
2008472 2008472 2021-12-13 Boone Arkansas 5009 6698 133
1803797 1803797 2021-10-11 Union Arkansas 5139 5633 133
1800548 1800548 2021-10-10 Union Arkansas 5139 5632 133
1673830 1673830 2021-09-01 Pope Arkansas 5115 10682 133
1631560 1631560 2021-08-19 Crawford Arkansas 5033 8445 133
1621805 1621805 2021-08-16 Baxter Arkansas 5005 5079 133
1618558 1618558 2021-08-15 Baxter Arkansas 5005 5062 133
1615310 1615310 2021-08-14 Baxter Arkansas 5005 5025 133
1612061 1612061 2021-08-13 Baxter Arkansas 5005 5003 133
1566649 1566649 2021-07-30 White Arkansas 5145 9570 133
1556875 1556875 2021-07-27 Lonoke Arkansas 5085 8630 133
1553628 1553628 2021-07-26 Lonoke Arkansas 5085 8577 133
1550381 1550381 2021-07-25 Lonoke Arkansas 5085 8563 133
1534144 1534144 2021-07-20 Lonoke Arkansas 5085 8332 133
1530897 1530897 2021-07-19 Lonoke Arkansas 5085 8252 133
910847 910847 2021-01-09 Jefferson Arkansas 5069 7144 133
907602 907602 2021-01-08 Jefferson Arkansas 5069 7093 133
904356 904356 2021-01-07 Jefferson Arkansas 5069 7043 133
901111 901111 2021-01-06 Jefferson Arkansas 5069 6992 133
823250 823250 2020-12-13 Sebastian Arkansas 5131 8079 133
725829 725829 2020-11-13 Benton Arkansas 5007 10127 133
722586 722586 2020-11-12 Benton Arkansas 5007 9977 133
719343 719343 2020-11-11 Benton Arkansas 5007 9838 133
716100 716100 2020-11-10 Benton Arkansas 5007 9677 133
712856 712856 2020-11-09 Benton Arkansas 5007 9561 133

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);