ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 3, fips = 5109 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
794033 | 794033 | 2020-12-04 | Pike | Arkansas | 5109 | 427 | 3 |
790788 | 790788 | 2020-12-03 | Pike | Arkansas | 5109 | 403 | 3 |
787543 | 787543 | 2020-12-02 | Pike | Arkansas | 5109 | 397 | 3 |
784299 | 784299 | 2020-12-01 | Pike | Arkansas | 5109 | 390 | 3 |
781054 | 781054 | 2020-11-30 | Pike | Arkansas | 5109 | 387 | 3 |
631803 | 631803 | 2020-10-15 | Pike | Arkansas | 5109 | 253 | 3 |
628559 | 628559 | 2020-10-14 | Pike | Arkansas | 5109 | 251 | 3 |
625316 | 625316 | 2020-10-13 | Pike | Arkansas | 5109 | 250 | 3 |
622073 | 622073 | 2020-10-12 | Pike | Arkansas | 5109 | 249 | 3 |
618830 | 618830 | 2020-10-11 | Pike | Arkansas | 5109 | 247 | 3 |
615588 | 615588 | 2020-10-10 | Pike | Arkansas | 5109 | 247 | 3 |
612347 | 612347 | 2020-10-09 | Pike | Arkansas | 5109 | 246 | 3 |
609105 | 609105 | 2020-10-08 | Pike | Arkansas | 5109 | 243 | 3 |
605862 | 605862 | 2020-10-07 | Pike | Arkansas | 5109 | 240 | 3 |
602620 | 602620 | 2020-10-06 | Pike | Arkansas | 5109 | 239 | 3 |
599377 | 599377 | 2020-10-05 | Pike | Arkansas | 5109 | 237 | 3 |
596134 | 596134 | 2020-10-04 | Pike | Arkansas | 5109 | 237 | 3 |
592892 | 592892 | 2020-10-03 | Pike | Arkansas | 5109 | 237 | 3 |
589652 | 589652 | 2020-10-02 | Pike | Arkansas | 5109 | 234 | 3 |
586411 | 586411 | 2020-10-01 | Pike | Arkansas | 5109 | 234 | 3 |
583171 | 583171 | 2020-09-30 | Pike | Arkansas | 5109 | 234 | 3 |
579932 | 579932 | 2020-09-29 | Pike | Arkansas | 5109 | 231 | 3 |
576691 | 576691 | 2020-09-28 | Pike | Arkansas | 5109 | 230 | 3 |
573448 | 573448 | 2020-09-27 | Pike | Arkansas | 5109 | 227 | 3 |
570206 | 570206 | 2020-09-26 | Pike | Arkansas | 5109 | 227 | 3 |
566964 | 566964 | 2020-09-25 | Pike | Arkansas | 5109 | 226 | 3 |
563724 | 563724 | 2020-09-24 | Pike | Arkansas | 5109 | 225 | 3 |
560485 | 560485 | 2020-09-23 | Pike | Arkansas | 5109 | 223 | 3 |
557249 | 557249 | 2020-09-22 | Pike | Arkansas | 5109 | 223 | 3 |
554012 | 554012 | 2020-09-21 | Pike | Arkansas | 5109 | 221 | 3 |
550773 | 550773 | 2020-09-20 | Pike | Arkansas | 5109 | 218 | 3 |
547534 | 547534 | 2020-09-19 | Pike | Arkansas | 5109 | 218 | 3 |
544296 | 544296 | 2020-09-18 | Pike | Arkansas | 5109 | 215 | 3 |
541060 | 541060 | 2020-09-17 | Pike | Arkansas | 5109 | 215 | 3 |
537823 | 537823 | 2020-09-16 | Pike | Arkansas | 5109 | 215 | 3 |
534587 | 534587 | 2020-09-15 | Pike | Arkansas | 5109 | 215 | 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);