ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 7, fips = 48127 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
692722 | 692722 | 2020-11-02 | Dimmit | Texas | 48127 | 294 | 7 |
689478 | 689478 | 2020-11-01 | Dimmit | Texas | 48127 | 294 | 7 |
686233 | 686233 | 2020-10-31 | Dimmit | Texas | 48127 | 294 | 7 |
682990 | 682990 | 2020-10-30 | Dimmit | Texas | 48127 | 294 | 7 |
679747 | 679747 | 2020-10-29 | Dimmit | Texas | 48127 | 293 | 7 |
676504 | 676504 | 2020-10-28 | Dimmit | Texas | 48127 | 292 | 7 |
673261 | 673261 | 2020-10-27 | Dimmit | Texas | 48127 | 290 | 7 |
670019 | 670019 | 2020-10-26 | Dimmit | Texas | 48127 | 289 | 7 |
666776 | 666776 | 2020-10-25 | Dimmit | Texas | 48127 | 287 | 7 |
663531 | 663531 | 2020-10-24 | Dimmit | Texas | 48127 | 287 | 7 |
660287 | 660287 | 2020-10-23 | Dimmit | Texas | 48127 | 284 | 7 |
657043 | 657043 | 2020-10-22 | Dimmit | Texas | 48127 | 283 | 7 |
653798 | 653798 | 2020-10-21 | Dimmit | Texas | 48127 | 283 | 7 |
650553 | 650553 | 2020-10-20 | Dimmit | Texas | 48127 | 277 | 7 |
647309 | 647309 | 2020-10-19 | Dimmit | Texas | 48127 | 276 | 7 |
644063 | 644063 | 2020-10-18 | Dimmit | Texas | 48127 | 275 | 7 |
640815 | 640815 | 2020-10-17 | Dimmit | Texas | 48127 | 275 | 7 |
637568 | 637568 | 2020-10-16 | Dimmit | Texas | 48127 | 272 | 7 |
634323 | 634323 | 2020-10-15 | Dimmit | Texas | 48127 | 278 | 7 |
631078 | 631078 | 2020-10-14 | Dimmit | Texas | 48127 | 277 | 7 |
627834 | 627834 | 2020-10-13 | Dimmit | Texas | 48127 | 274 | 7 |
624592 | 624592 | 2020-10-12 | Dimmit | Texas | 48127 | 275 | 7 |
621349 | 621349 | 2020-10-11 | Dimmit | Texas | 48127 | 266 | 7 |
618106 | 618106 | 2020-10-10 | Dimmit | Texas | 48127 | 266 | 7 |
614864 | 614864 | 2020-10-09 | Dimmit | Texas | 48127 | 266 | 7 |
611623 | 611623 | 2020-10-08 | Dimmit | Texas | 48127 | 267 | 7 |
608381 | 608381 | 2020-10-07 | Dimmit | Texas | 48127 | 266 | 7 |
605138 | 605138 | 2020-10-06 | Dimmit | Texas | 48127 | 263 | 7 |
601896 | 601896 | 2020-10-05 | Dimmit | Texas | 48127 | 259 | 7 |
598653 | 598653 | 2020-10-04 | Dimmit | Texas | 48127 | 258 | 7 |
595410 | 595410 | 2020-10-03 | Dimmit | Texas | 48127 | 258 | 7 |
592168 | 592168 | 2020-10-02 | Dimmit | Texas | 48127 | 258 | 7 |
588928 | 588928 | 2020-10-01 | Dimmit | Texas | 48127 | 257 | 7 |
585687 | 585687 | 2020-09-30 | Dimmit | Texas | 48127 | 257 | 7 |
582447 | 582447 | 2020-09-29 | Dimmit | Texas | 48127 | 256 | 7 |
579208 | 579208 | 2020-09-28 | Dimmit | Texas | 48127 | 256 | 7 |
575967 | 575967 | 2020-09-27 | Dimmit | Texas | 48127 | 256 | 7 |
572723 | 572723 | 2020-09-26 | Dimmit | Texas | 48127 | 256 | 7 |
569481 | 569481 | 2020-09-25 | Dimmit | Texas | 48127 | 254 | 7 |
566240 | 566240 | 2020-09-24 | Dimmit | Texas | 48127 | 254 | 7 |
562999 | 562999 | 2020-09-23 | Dimmit | Texas | 48127 | 254 | 7 |
559760 | 559760 | 2020-09-22 | Dimmit | Texas | 48127 | 253 | 7 |
556524 | 556524 | 2020-09-21 | Dimmit | Texas | 48127 | 248 | 7 |
553287 | 553287 | 2020-09-20 | Dimmit | Texas | 48127 | 195 | 7 |
550048 | 550048 | 2020-09-19 | Dimmit | Texas | 48127 | 195 | 7 |
546809 | 546809 | 2020-09-18 | Dimmit | Texas | 48127 | 192 | 7 |
543572 | 543572 | 2020-09-17 | Dimmit | Texas | 48127 | 191 | 7 |
540336 | 540336 | 2020-09-16 | Dimmit | Texas | 48127 | 191 | 7 |
537099 | 537099 | 2020-09-15 | Dimmit | Texas | 48127 | 190 | 7 |
533863 | 533863 | 2020-09-14 | Dimmit | Texas | 48127 | 190 | 7 |
530628 | 530628 | 2020-09-13 | Dimmit | Texas | 48127 | 190 | 7 |
527391 | 527391 | 2020-09-12 | Dimmit | Texas | 48127 | 190 | 7 |
524155 | 524155 | 2020-09-11 | Dimmit | Texas | 48127 | 189 | 7 |
520919 | 520919 | 2020-09-10 | Dimmit | Texas | 48127 | 188 | 7 |
517683 | 517683 | 2020-09-09 | Dimmit | Texas | 48127 | 188 | 7 |
514448 | 514448 | 2020-09-08 | Dimmit | Texas | 48127 | 187 | 7 |
511215 | 511215 | 2020-09-07 | Dimmit | Texas | 48127 | 186 | 7 |
507982 | 507982 | 2020-09-06 | Dimmit | Texas | 48127 | 186 | 7 |
504750 | 504750 | 2020-09-05 | Dimmit | Texas | 48127 | 186 | 7 |
501516 | 501516 | 2020-09-04 | Dimmit | Texas | 48127 | 186 | 7 |
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);