ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where deaths = 14, fips = 48287 and state = "Texas" 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 |
---|---|---|---|---|---|---|---|
699288 | 699288 | 2020-11-04 | Lee | Texas | 48287 | 249 | 14 |
686313 | 686313 | 2020-10-31 | Lee | Texas | 48287 | 245 | 14 |
683070 | 683070 | 2020-10-30 | Lee | Texas | 48287 | 245 | 14 |
679827 | 679827 | 2020-10-29 | Lee | Texas | 48287 | 243 | 14 |
676584 | 676584 | 2020-10-28 | Lee | Texas | 48287 | 242 | 14 |
673341 | 673341 | 2020-10-27 | Lee | Texas | 48287 | 241 | 14 |
670099 | 670099 | 2020-10-26 | Lee | Texas | 48287 | 239 | 14 |
666856 | 666856 | 2020-10-25 | Lee | Texas | 48287 | 239 | 14 |
663611 | 663611 | 2020-10-24 | Lee | Texas | 48287 | 239 | 14 |
660367 | 660367 | 2020-10-23 | Lee | Texas | 48287 | 236 | 14 |
657123 | 657123 | 2020-10-22 | Lee | Texas | 48287 | 235 | 14 |
653878 | 653878 | 2020-10-21 | Lee | Texas | 48287 | 235 | 14 |
650633 | 650633 | 2020-10-20 | Lee | Texas | 48287 | 235 | 14 |
647389 | 647389 | 2020-10-19 | Lee | Texas | 48287 | 235 | 14 |
644143 | 644143 | 2020-10-18 | Lee | Texas | 48287 | 235 | 14 |
640895 | 640895 | 2020-10-17 | Lee | Texas | 48287 | 235 | 14 |
637648 | 637648 | 2020-10-16 | Lee | Texas | 48287 | 235 | 14 |
634403 | 634403 | 2020-10-15 | Lee | Texas | 48287 | 235 | 14 |
631158 | 631158 | 2020-10-14 | Lee | Texas | 48287 | 234 | 14 |
627914 | 627914 | 2020-10-13 | Lee | Texas | 48287 | 234 | 14 |
624671 | 624671 | 2020-10-12 | Lee | Texas | 48287 | 234 | 14 |
621428 | 621428 | 2020-10-11 | Lee | Texas | 48287 | 234 | 14 |
618185 | 618185 | 2020-10-10 | Lee | Texas | 48287 | 234 | 14 |
614943 | 614943 | 2020-10-09 | Lee | Texas | 48287 | 233 | 14 |
611702 | 611702 | 2020-10-08 | Lee | Texas | 48287 | 233 | 14 |
608460 | 608460 | 2020-10-07 | Lee | Texas | 48287 | 232 | 14 |
605217 | 605217 | 2020-10-06 | Lee | Texas | 48287 | 231 | 14 |
601975 | 601975 | 2020-10-05 | Lee | Texas | 48287 | 230 | 14 |
598732 | 598732 | 2020-10-04 | Lee | Texas | 48287 | 230 | 14 |
595489 | 595489 | 2020-10-03 | Lee | Texas | 48287 | 230 | 14 |
592247 | 592247 | 2020-10-02 | Lee | Texas | 48287 | 231 | 14 |
589007 | 589007 | 2020-10-01 | Lee | Texas | 48287 | 231 | 14 |
585766 | 585766 | 2020-09-30 | Lee | Texas | 48287 | 228 | 14 |
582526 | 582526 | 2020-09-29 | Lee | Texas | 48287 | 226 | 14 |
579287 | 579287 | 2020-09-28 | Lee | Texas | 48287 | 221 | 14 |
576046 | 576046 | 2020-09-27 | Lee | Texas | 48287 | 221 | 14 |
572802 | 572802 | 2020-09-26 | Lee | Texas | 48287 | 221 | 14 |
569560 | 569560 | 2020-09-25 | Lee | Texas | 48287 | 219 | 14 |
566319 | 566319 | 2020-09-24 | Lee | Texas | 48287 | 219 | 14 |
563078 | 563078 | 2020-09-23 | Lee | Texas | 48287 | 219 | 14 |
559839 | 559839 | 2020-09-22 | Lee | Texas | 48287 | 218 | 14 |
556603 | 556603 | 2020-09-21 | Lee | Texas | 48287 | 217 | 14 |
553366 | 553366 | 2020-09-20 | Lee | Texas | 48287 | 217 | 14 |
550127 | 550127 | 2020-09-19 | Lee | Texas | 48287 | 217 | 14 |
546888 | 546888 | 2020-09-18 | Lee | Texas | 48287 | 217 | 14 |
543651 | 543651 | 2020-09-17 | Lee | Texas | 48287 | 213 | 14 |
540415 | 540415 | 2020-09-16 | Lee | Texas | 48287 | 211 | 14 |
537178 | 537178 | 2020-09-15 | Lee | Texas | 48287 | 211 | 14 |
533942 | 533942 | 2020-09-14 | Lee | Texas | 48287 | 208 | 14 |
530707 | 530707 | 2020-09-13 | Lee | Texas | 48287 | 208 | 14 |
527470 | 527470 | 2020-09-12 | Lee | Texas | 48287 | 208 | 14 |
524234 | 524234 | 2020-09-11 | Lee | Texas | 48287 | 208 | 14 |
520998 | 520998 | 2020-09-10 | Lee | Texas | 48287 | 208 | 14 |
517762 | 517762 | 2020-09-09 | Lee | Texas | 48287 | 208 | 14 |
514527 | 514527 | 2020-09-08 | Lee | Texas | 48287 | 202 | 14 |
511294 | 511294 | 2020-09-07 | Lee | Texas | 48287 | 202 | 14 |
508061 | 508061 | 2020-09-06 | Lee | Texas | 48287 | 202 | 14 |
504829 | 504829 | 2020-09-05 | Lee | Texas | 48287 | 202 | 14 |
501595 | 501595 | 2020-09-04 | Lee | Texas | 48287 | 197 | 14 |
498361 | 498361 | 2020-09-03 | Lee | Texas | 48287 | 197 | 14 |
495128 | 495128 | 2020-09-02 | Lee | Texas | 48287 | 196 | 14 |
491894 | 491894 | 2020-09-01 | Lee | Texas | 48287 | 196 | 14 |
488661 | 488661 | 2020-08-31 | Lee | Texas | 48287 | 196 | 14 |
485428 | 485428 | 2020-08-30 | Lee | Texas | 48287 | 197 | 14 |
482193 | 482193 | 2020-08-29 | Lee | Texas | 48287 | 196 | 14 |
478959 | 478959 | 2020-08-28 | Lee | Texas | 48287 | 194 | 14 |
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);