ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where cases = 70 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 |
---|---|---|---|---|---|---|---|
2163938 | 2163938 | 2022-01-29 | Kenedy | Texas | 48261 | 70 | 2 |
978359 | 978359 | 2021-01-29 | Kent | Texas | 48263 | 70 | 1 |
975114 | 975114 | 2021-01-28 | Kent | Texas | 48263 | 70 | 1 |
949184 | 949184 | 2021-01-20 | McMullen | Texas | 48311 | 70 | 2 |
945938 | 945938 | 2021-01-19 | McMullen | Texas | 48311 | 70 | 2 |
942691 | 942691 | 2021-01-18 | McMullen | Texas | 48311 | 70 | 2 |
939446 | 939446 | 2021-01-17 | McMullen | Texas | 48311 | 70 | 2 |
916790 | 916790 | 2021-01-10 | Terrell | Texas | 48443 | 70 | 1 |
900420 | 900420 | 2021-01-05 | Foard | Texas | 48155 | 70 | 5 |
897175 | 897175 | 2021-01-04 | Foard | Texas | 48155 | 70 | 4 |
893929 | 893929 | 2021-01-03 | Foard | Texas | 48155 | 70 | 4 |
890683 | 890683 | 2021-01-02 | Foard | Texas | 48155 | 70 | 4 |
887436 | 887436 | 2021-01-01 | Foard | Texas | 48155 | 70 | 4 |
884191 | 884191 | 2020-12-31 | Foard | Texas | 48155 | 70 | 4 |
884231 | 884231 | 2020-12-31 | Irion | Texas | 48235 | 70 | 0 |
858370 | 858370 | 2020-12-23 | Stonewall | Texas | 48433 | 70 | 3 |
829030 | 829030 | 2020-12-14 | Glasscock | Texas | 48173 | 70 | 1 |
816009 | 816009 | 2020-12-10 | Cottle | Texas | 48101 | 70 | 5 |
812763 | 812763 | 2020-12-09 | Cottle | Texas | 48101 | 70 | 5 |
809519 | 809519 | 2020-12-08 | Cottle | Texas | 48101 | 70 | 4 |
683074 | 683074 | 2020-10-30 | Lipscomb | Texas | 48295 | 70 | 1 |
637619 | 637619 | 2020-10-16 | Hudspeth | Texas | 48229 | 70 | 3 |
637670 | 637670 | 2020-10-16 | Mills | Texas | 48333 | 70 | 0 |
634425 | 634425 | 2020-10-15 | Mills | Texas | 48333 | 70 | 0 |
631180 | 631180 | 2020-10-14 | Mills | Texas | 48333 | 70 | 0 |
611635 | 611635 | 2020-10-08 | Fisher | Texas | 48151 | 70 | 3 |
608393 | 608393 | 2020-10-07 | Fisher | Texas | 48151 | 70 | 3 |
605139 | 605139 | 2020-10-06 | Donley | Texas | 48129 | 70 | 1 |
605150 | 605150 | 2020-10-06 | Fisher | Texas | 48151 | 70 | 3 |
592208 | 592208 | 2020-10-02 | Haskell | Texas | 48207 | 70 | 3 |
569459 | 569459 | 2020-09-25 | Coleman | Texas | 48083 | 70 | 4 |
566218 | 566218 | 2020-09-24 | Coleman | Texas | 48083 | 70 | 4 |
562977 | 562977 | 2020-09-23 | Coleman | Texas | 48083 | 70 | 3 |
559738 | 559738 | 2020-09-22 | Coleman | Texas | 48083 | 70 | 3 |
501491 | 501491 | 2020-09-04 | Clay | Texas | 48077 | 70 | 1 |
491781 | 491781 | 2020-09-01 | Callahan | Texas | 48059 | 70 | 3 |
488570 | 488570 | 2020-08-31 | Crane | Texas | 48103 | 70 | 2 |
485337 | 485337 | 2020-08-30 | Crane | Texas | 48103 | 70 | 2 |
482102 | 482102 | 2020-08-29 | Crane | Texas | 48103 | 70 | 2 |
478868 | 478868 | 2020-08-28 | Crane | Texas | 48103 | 70 | 2 |
475635 | 475635 | 2020-08-27 | Crane | Texas | 48103 | 70 | 2 |
475737 | 475737 | 2020-08-27 | Martin | Texas | 48317 | 70 | 5 |
472402 | 472402 | 2020-08-26 | Crane | Texas | 48103 | 70 | 2 |
472504 | 472504 | 2020-08-26 | Martin | Texas | 48317 | 70 | 5 |
469170 | 469170 | 2020-08-25 | Crane | Texas | 48103 | 70 | 2 |
469272 | 469272 | 2020-08-25 | Martin | Texas | 48317 | 70 | 5 |
465941 | 465941 | 2020-08-24 | Crane | Texas | 48103 | 70 | 2 |
466043 | 466043 | 2020-08-24 | Martin | Texas | 48317 | 70 | 5 |
462712 | 462712 | 2020-08-23 | Crane | Texas | 48103 | 70 | 2 |
462814 | 462814 | 2020-08-23 | Martin | Texas | 48317 | 70 | 5 |
459483 | 459483 | 2020-08-22 | Crane | Texas | 48103 | 70 | 2 |
459585 | 459585 | 2020-08-22 | Martin | Texas | 48317 | 70 | 5 |
456256 | 456256 | 2020-08-21 | Crane | Texas | 48103 | 70 | 2 |
453166 | 453166 | 2020-08-20 | Reagan | Texas | 48383 | 70 | 5 |
449800 | 449800 | 2020-08-19 | Crane | Texas | 48103 | 70 | 2 |
446572 | 446572 | 2020-08-18 | Crane | Texas | 48103 | 70 | 2 |
446686 | 446686 | 2020-08-18 | Mitchell | Texas | 48335 | 70 | 1 |
446736 | 446736 | 2020-08-18 | Sutton | Texas | 48435 | 70 | 1 |
443345 | 443345 | 2020-08-17 | Crane | Texas | 48103 | 70 | 2 |
443459 | 443459 | 2020-08-17 | Mitchell | Texas | 48335 | 70 | 1 |
440119 | 440119 | 2020-08-16 | Crane | Texas | 48103 | 70 | 2 |
440233 | 440233 | 2020-08-16 | Mitchell | Texas | 48335 | 70 | 1 |
436893 | 436893 | 2020-08-15 | Crane | Texas | 48103 | 70 | 2 |
437007 | 437007 | 2020-08-15 | Mitchell | Texas | 48335 | 70 | 1 |
433667 | 433667 | 2020-08-14 | Crane | Texas | 48103 | 70 | 2 |
433781 | 433781 | 2020-08-14 | Mitchell | Texas | 48335 | 70 | 1 |
430442 | 430442 | 2020-08-13 | Crane | Texas | 48103 | 70 | 2 |
430509 | 430509 | 2020-08-13 | Jack | Texas | 48237 | 70 | 0 |
423991 | 423991 | 2020-08-11 | Crane | Texas | 48103 | 70 | 2 |
420770 | 420770 | 2020-08-10 | Crane | Texas | 48103 | 70 | 2 |
420885 | 420885 | 2020-08-10 | Montague | Texas | 48337 | 70 | 1 |
417549 | 417549 | 2020-08-09 | Crane | Texas | 48103 | 70 | 2 |
417664 | 417664 | 2020-08-09 | Montague | Texas | 48337 | 70 | 1 |
414328 | 414328 | 2020-08-08 | Crane | Texas | 48103 | 70 | 2 |
414443 | 414443 | 2020-08-08 | Montague | Texas | 48337 | 70 | 1 |
411108 | 411108 | 2020-08-07 | Crane | Texas | 48103 | 70 | 2 |
411123 | 411123 | 2020-08-07 | Eastland | Texas | 48133 | 70 | 1 |
404669 | 404669 | 2020-08-05 | Crane | Texas | 48103 | 70 | 2 |
404862 | 404862 | 2020-08-05 | Winkler | Texas | 48495 | 70 | 1 |
366079 | 366079 | 2020-07-24 | Comanche | Texas | 48093 | 70 | 1 |
366202 | 366202 | 2020-07-24 | Morris | Texas | 48343 | 70 | 0 |
366223 | 366223 | 2020-07-24 | Real | Texas | 48385 | 70 | 0 |
362996 | 362996 | 2020-07-23 | Morris | Texas | 48343 | 70 | 0 |
359699 | 359699 | 2020-07-22 | Franklin | Texas | 48159 | 70 | 1 |
353314 | 353314 | 2020-07-20 | Hartley | Texas | 48205 | 70 | 2 |
337300 | 337300 | 2020-07-15 | Gillespie | Texas | 48171 | 70 | 0 |
334053 | 334053 | 2020-07-14 | Cass | Texas | 48067 | 70 | 3 |
334194 | 334194 | 2020-07-14 | Nolan | Texas | 48353 | 70 | 0 |
324578 | 324578 | 2020-07-11 | Jasper | Texas | 48241 | 70 | 2 |
324630 | 324630 | 2020-07-11 | Nolan | Texas | 48353 | 70 | 0 |
321397 | 321397 | 2020-07-10 | Jasper | Texas | 48241 | 70 | 2 |
318164 | 318164 | 2020-07-09 | Duval | Texas | 48131 | 70 | 0 |
318218 | 318218 | 2020-07-09 | Jasper | Texas | 48241 | 70 | 2 |
314983 | 314983 | 2020-07-08 | Dawson | Texas | 48115 | 70 | 1 |
315041 | 315041 | 2020-07-08 | Hutchinson | Texas | 48233 | 70 | 0 |
311809 | 311809 | 2020-07-07 | Dawson | Texas | 48115 | 70 | 1 |
311867 | 311867 | 2020-07-07 | Hutchinson | Texas | 48233 | 70 | 0 |
308640 | 308640 | 2020-07-06 | Dawson | Texas | 48115 | 70 | 1 |
308693 | 308693 | 2020-07-06 | Hopkins | Texas | 48223 | 70 | 1 |
308698 | 308698 | 2020-07-06 | Hutchinson | Texas | 48233 | 70 | 0 |
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);