ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 48253 and state = "Texas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
42799 | 42799 | 2020-04-08 | Jones | Texas | 48253 | 1 | 0 |
45389 | 45389 | 2020-04-09 | Jones | Texas | 48253 | 1 | 0 |
48010 | 48010 | 2020-04-10 | Jones | Texas | 48253 | 2 | 0 |
50668 | 50668 | 2020-04-11 | Jones | Texas | 48253 | 2 | 0 |
53343 | 53343 | 2020-04-12 | Jones | Texas | 48253 | 2 | 0 |
56031 | 56031 | 2020-04-13 | Jones | Texas | 48253 | 2 | 0 |
58736 | 58736 | 2020-04-14 | Jones | Texas | 48253 | 2 | 0 |
61454 | 61454 | 2020-04-15 | Jones | Texas | 48253 | 2 | 0 |
64181 | 64181 | 2020-04-16 | Jones | Texas | 48253 | 3 | 0 |
66928 | 66928 | 2020-04-17 | Jones | Texas | 48253 | 3 | 0 |
69688 | 69688 | 2020-04-18 | Jones | Texas | 48253 | 3 | 0 |
72457 | 72457 | 2020-04-19 | Jones | Texas | 48253 | 3 | 0 |
75233 | 75233 | 2020-04-20 | Jones | Texas | 48253 | 3 | 0 |
78015 | 78015 | 2020-04-21 | Jones | Texas | 48253 | 3 | 0 |
80806 | 80806 | 2020-04-22 | Jones | Texas | 48253 | 3 | 0 |
83607 | 83607 | 2020-04-23 | Jones | Texas | 48253 | 4 | 0 |
86412 | 86412 | 2020-04-24 | Jones | Texas | 48253 | 7 | 0 |
89227 | 89227 | 2020-04-25 | Jones | Texas | 48253 | 13 | 0 |
92044 | 92044 | 2020-04-26 | Jones | Texas | 48253 | 13 | 0 |
94873 | 94873 | 2020-04-27 | Jones | Texas | 48253 | 13 | 0 |
97713 | 97713 | 2020-04-28 | Jones | Texas | 48253 | 13 | 0 |
100563 | 100563 | 2020-04-29 | Jones | Texas | 48253 | 37 | 0 |
103418 | 103418 | 2020-04-30 | Jones | Texas | 48253 | 37 | 0 |
106282 | 106282 | 2020-05-01 | Jones | Texas | 48253 | 37 | 0 |
109151 | 109151 | 2020-05-02 | Jones | Texas | 48253 | 62 | 0 |
112025 | 112025 | 2020-05-03 | Jones | Texas | 48253 | 62 | 0 |
114907 | 114907 | 2020-05-04 | Jones | Texas | 48253 | 78 | 0 |
117866 | 117866 | 2020-05-05 | Jones | Texas | 48253 | 78 | 0 |
120830 | 120830 | 2020-05-06 | Jones | Texas | 48253 | 84 | 0 |
123809 | 123809 | 2020-05-07 | Jones | Texas | 48253 | 84 | 0 |
126792 | 126792 | 2020-05-08 | Jones | Texas | 48253 | 87 | 0 |
129781 | 129781 | 2020-05-09 | Jones | Texas | 48253 | 92 | 0 |
132771 | 132771 | 2020-05-10 | Jones | Texas | 48253 | 92 | 0 |
135762 | 135762 | 2020-05-11 | Jones | Texas | 48253 | 95 | 0 |
138752 | 138752 | 2020-05-12 | Jones | Texas | 48253 | 96 | 0 |
141748 | 141748 | 2020-05-13 | Jones | Texas | 48253 | 101 | 0 |
144745 | 144745 | 2020-05-14 | Jones | Texas | 48253 | 110 | 0 |
147749 | 147749 | 2020-05-15 | Jones | Texas | 48253 | 110 | 0 |
150757 | 150757 | 2020-05-16 | Jones | Texas | 48253 | 112 | 0 |
153768 | 153768 | 2020-05-17 | Jones | Texas | 48253 | 112 | 0 |
156785 | 156785 | 2020-05-18 | Jones | Texas | 48253 | 112 | 0 |
159807 | 159807 | 2020-05-19 | Jones | Texas | 48253 | 115 | 0 |
162835 | 162835 | 2020-05-20 | Jones | Texas | 48253 | 117 | 0 |
165864 | 165864 | 2020-05-21 | Jones | Texas | 48253 | 134 | 0 |
168900 | 168900 | 2020-05-22 | Jones | Texas | 48253 | 134 | 0 |
171940 | 171940 | 2020-05-23 | Jones | Texas | 48253 | 135 | 0 |
174983 | 174983 | 2020-05-24 | Jones | Texas | 48253 | 135 | 0 |
178027 | 178027 | 2020-05-25 | Jones | Texas | 48253 | 135 | 0 |
181071 | 181071 | 2020-05-26 | Jones | Texas | 48253 | 135 | 0 |
184121 | 184121 | 2020-05-27 | Jones | Texas | 48253 | 135 | 0 |
187178 | 187178 | 2020-05-28 | Jones | Texas | 48253 | 323 | 0 |
190242 | 190242 | 2020-05-29 | Jones | Texas | 48253 | 354 | 0 |
193307 | 193307 | 2020-05-30 | Jones | Texas | 48253 | 401 | 0 |
196377 | 196377 | 2020-05-31 | Jones | Texas | 48253 | 401 | 0 |
199450 | 199450 | 2020-06-01 | Jones | Texas | 48253 | 401 | 0 |
527454 | 527454 | 2020-09-12 | Jones | Texas | 48253 | 562 | 0 |
530691 | 530691 | 2020-09-13 | Jones | Texas | 48253 | 562 | 0 |
533926 | 533926 | 2020-09-14 | Jones | Texas | 48253 | 562 | 0 |
588991 | 588991 | 2020-10-01 | Jones | Texas | 48253 | 565 | 0 |
608444 | 608444 | 2020-10-07 | Jones | Texas | 48253 | 565 | 0 |
537162 | 537162 | 2020-09-15 | Jones | Texas | 48253 | 566 | 0 |
592231 | 592231 | 2020-10-02 | Jones | Texas | 48253 | 567 | 0 |
611686 | 611686 | 2020-10-08 | Jones | Texas | 48253 | 567 | 0 |
595473 | 595473 | 2020-10-03 | Jones | Texas | 48253 | 568 | 0 |
598716 | 598716 | 2020-10-04 | Jones | Texas | 48253 | 568 | 0 |
601959 | 601959 | 2020-10-05 | Jones | Texas | 48253 | 568 | 0 |
618169 | 618169 | 2020-10-10 | Jones | Texas | 48253 | 568 | 0 |
621412 | 621412 | 2020-10-11 | Jones | Texas | 48253 | 568 | 0 |
624655 | 624655 | 2020-10-12 | Jones | Texas | 48253 | 568 | 0 |
524218 | 524218 | 2020-09-11 | Jones | Texas | 48253 | 569 | 0 |
614927 | 614927 | 2020-10-09 | Jones | Texas | 48253 | 569 | 0 |
540399 | 540399 | 2020-09-16 | Jones | Texas | 48253 | 571 | 0 |
631141 | 631141 | 2020-10-14 | Jones | Texas | 48253 | 572 | 1 |
627897 | 627897 | 2020-10-13 | Jones | Texas | 48253 | 573 | 1 |
634386 | 634386 | 2020-10-15 | Jones | Texas | 48253 | 574 | 1 |
572786 | 572786 | 2020-09-26 | Jones | Texas | 48253 | 575 | 0 |
576030 | 576030 | 2020-09-27 | Jones | Texas | 48253 | 575 | 0 |
579271 | 579271 | 2020-09-28 | Jones | Texas | 48253 | 575 | 0 |
563062 | 563062 | 2020-09-23 | Jones | Texas | 48253 | 577 | 0 |
582510 | 582510 | 2020-09-29 | Jones | Texas | 48253 | 577 | 0 |
585750 | 585750 | 2020-09-30 | Jones | Texas | 48253 | 577 | 0 |
605201 | 605201 | 2020-10-06 | Jones | Texas | 48253 | 577 | 0 |
637631 | 637631 | 2020-10-16 | Jones | Texas | 48253 | 577 | 1 |
543635 | 543635 | 2020-09-17 | Jones | Texas | 48253 | 578 | 0 |
559823 | 559823 | 2020-09-22 | Jones | Texas | 48253 | 580 | 0 |
517746 | 517746 | 2020-09-09 | Jones | Texas | 48253 | 583 | 0 |
520982 | 520982 | 2020-09-10 | Jones | Texas | 48253 | 583 | 0 |
566303 | 566303 | 2020-09-24 | Jones | Texas | 48253 | 583 | 0 |
569544 | 569544 | 2020-09-25 | Jones | Texas | 48253 | 583 | 0 |
546872 | 546872 | 2020-09-18 | Jones | Texas | 48253 | 584 | 0 |
550111 | 550111 | 2020-09-19 | Jones | Texas | 48253 | 584 | 0 |
553350 | 553350 | 2020-09-20 | Jones | Texas | 48253 | 584 | 0 |
556587 | 556587 | 2020-09-21 | Jones | Texas | 48253 | 584 | 0 |
663594 | 663594 | 2020-10-24 | Jones | Texas | 48253 | 585 | 1 |
666839 | 666839 | 2020-10-25 | Jones | Texas | 48253 | 585 | 2 |
670082 | 670082 | 2020-10-26 | Jones | Texas | 48253 | 585 | 2 |
640878 | 640878 | 2020-10-17 | Jones | Texas | 48253 | 586 | 2 |
644126 | 644126 | 2020-10-18 | Jones | Texas | 48253 | 586 | 2 |
647372 | 647372 | 2020-10-19 | Jones | Texas | 48253 | 586 | 2 |
650616 | 650616 | 2020-10-20 | Jones | Texas | 48253 | 586 | 2 |
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);