ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Jones" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324584 | 324584 | 2020-07-11 | Jones | Texas | 48253 | 604 | 0 |
321403 | 321403 | 2020-07-10 | Jones | Texas | 48253 | 604 | 0 |
318224 | 318224 | 2020-07-09 | Jones | Texas | 48253 | 607 | 0 |
315051 | 315051 | 2020-07-08 | Jones | Texas | 48253 | 611 | 0 |
311877 | 311877 | 2020-07-07 | Jones | Texas | 48253 | 609 | 0 |
308708 | 308708 | 2020-07-06 | Jones | Texas | 48253 | 610 | 0 |
305540 | 305540 | 2020-07-05 | Jones | Texas | 48253 | 610 | 0 |
302376 | 302376 | 2020-07-04 | Jones | Texas | 48253 | 610 | 0 |
299212 | 299212 | 2020-07-03 | Jones | Texas | 48253 | 610 | 0 |
296052 | 296052 | 2020-07-02 | Jones | Texas | 48253 | 610 | 0 |
292897 | 292897 | 2020-07-01 | Jones | Texas | 48253 | 613 | 0 |
289744 | 289744 | 2020-06-30 | Jones | Texas | 48253 | 611 | 0 |
286594 | 286594 | 2020-06-29 | Jones | Texas | 48253 | 607 | 0 |
283448 | 283448 | 2020-06-28 | Jones | Texas | 48253 | 607 | 0 |
280302 | 280302 | 2020-06-27 | Jones | Texas | 48253 | 607 | 0 |
277154 | 277154 | 2020-06-26 | Jones | Texas | 48253 | 604 | 0 |
274006 | 274006 | 2020-06-25 | Jones | Texas | 48253 | 604 | 0 |
270866 | 270866 | 2020-06-24 | Jones | Texas | 48253 | 604 | 0 |
267732 | 267732 | 2020-06-23 | Jones | Texas | 48253 | 604 | 0 |
264604 | 264604 | 2020-06-22 | Jones | Texas | 48253 | 650 | 0 |
261476 | 261476 | 2020-06-21 | Jones | Texas | 48253 | 650 | 0 |
258349 | 258349 | 2020-06-20 | Jones | Texas | 48253 | 650 | 0 |
255222 | 255222 | 2020-06-19 | Jones | Texas | 48253 | 610 | 0 |
252107 | 252107 | 2020-06-18 | Jones | Texas | 48253 | 614 | 0 |
248992 | 248992 | 2020-06-17 | Jones | Texas | 48253 | 615 | 0 |
245879 | 245879 | 2020-06-16 | Jones | Texas | 48253 | 630 | 0 |
242767 | 242767 | 2020-06-15 | Jones | Texas | 48253 | 631 | 0 |
239657 | 239657 | 2020-06-14 | Jones | Texas | 48253 | 631 | 0 |
236549 | 236549 | 2020-06-13 | Jones | Texas | 48253 | 631 | 0 |
233443 | 233443 | 2020-06-12 | Jones | Texas | 48253 | 632 | 0 |
230339 | 230339 | 2020-06-11 | Jones | Texas | 48253 | 633 | 0 |
227235 | 227235 | 2020-06-10 | Jones | Texas | 48253 | 636 | 0 |
224135 | 224135 | 2020-06-09 | Jones | Texas | 48253 | 636 | 0 |
221040 | 221040 | 2020-06-08 | Jones | Texas | 48253 | 637 | 0 |
217948 | 217948 | 2020-06-07 | Jones | Texas | 48253 | 637 | 0 |
214858 | 214858 | 2020-06-06 | Jones | Texas | 48253 | 637 | 0 |
211771 | 211771 | 2020-06-05 | Jones | Texas | 48253 | 637 | 0 |
208687 | 208687 | 2020-06-04 | Jones | Texas | 48253 | 636 | 0 |
205605 | 205605 | 2020-06-03 | Jones | Texas | 48253 | 637 | 0 |
202526 | 202526 | 2020-06-02 | Jones | Texas | 48253 | 606 | 0 |
199450 | 199450 | 2020-06-01 | Jones | Texas | 48253 | 401 | 0 |
196377 | 196377 | 2020-05-31 | Jones | Texas | 48253 | 401 | 0 |
193307 | 193307 | 2020-05-30 | Jones | Texas | 48253 | 401 | 0 |
190242 | 190242 | 2020-05-29 | Jones | Texas | 48253 | 354 | 0 |
187178 | 187178 | 2020-05-28 | Jones | Texas | 48253 | 323 | 0 |
184121 | 184121 | 2020-05-27 | Jones | Texas | 48253 | 135 | 0 |
181071 | 181071 | 2020-05-26 | Jones | Texas | 48253 | 135 | 0 |
178027 | 178027 | 2020-05-25 | Jones | Texas | 48253 | 135 | 0 |
174983 | 174983 | 2020-05-24 | Jones | Texas | 48253 | 135 | 0 |
171940 | 171940 | 2020-05-23 | Jones | Texas | 48253 | 135 | 0 |
168900 | 168900 | 2020-05-22 | Jones | Texas | 48253 | 134 | 0 |
165864 | 165864 | 2020-05-21 | Jones | Texas | 48253 | 134 | 0 |
162835 | 162835 | 2020-05-20 | Jones | Texas | 48253 | 117 | 0 |
159807 | 159807 | 2020-05-19 | Jones | Texas | 48253 | 115 | 0 |
156785 | 156785 | 2020-05-18 | Jones | Texas | 48253 | 112 | 0 |
153768 | 153768 | 2020-05-17 | Jones | Texas | 48253 | 112 | 0 |
150757 | 150757 | 2020-05-16 | Jones | Texas | 48253 | 112 | 0 |
147749 | 147749 | 2020-05-15 | Jones | Texas | 48253 | 110 | 0 |
144745 | 144745 | 2020-05-14 | Jones | Texas | 48253 | 110 | 0 |
141748 | 141748 | 2020-05-13 | Jones | Texas | 48253 | 101 | 0 |
138752 | 138752 | 2020-05-12 | Jones | Texas | 48253 | 96 | 0 |
135762 | 135762 | 2020-05-11 | Jones | Texas | 48253 | 95 | 0 |
132771 | 132771 | 2020-05-10 | Jones | Texas | 48253 | 92 | 0 |
129781 | 129781 | 2020-05-09 | Jones | Texas | 48253 | 92 | 0 |
126792 | 126792 | 2020-05-08 | Jones | Texas | 48253 | 87 | 0 |
123809 | 123809 | 2020-05-07 | Jones | Texas | 48253 | 84 | 0 |
120830 | 120830 | 2020-05-06 | Jones | Texas | 48253 | 84 | 0 |
117866 | 117866 | 2020-05-05 | Jones | Texas | 48253 | 78 | 0 |
114907 | 114907 | 2020-05-04 | Jones | Texas | 48253 | 78 | 0 |
112025 | 112025 | 2020-05-03 | Jones | Texas | 48253 | 62 | 0 |
109151 | 109151 | 2020-05-02 | Jones | Texas | 48253 | 62 | 0 |
106282 | 106282 | 2020-05-01 | Jones | Texas | 48253 | 37 | 0 |
103418 | 103418 | 2020-04-30 | Jones | Texas | 48253 | 37 | 0 |
100563 | 100563 | 2020-04-29 | Jones | Texas | 48253 | 37 | 0 |
97713 | 97713 | 2020-04-28 | Jones | Texas | 48253 | 13 | 0 |
94873 | 94873 | 2020-04-27 | Jones | Texas | 48253 | 13 | 0 |
92044 | 92044 | 2020-04-26 | Jones | Texas | 48253 | 13 | 0 |
89227 | 89227 | 2020-04-25 | Jones | Texas | 48253 | 13 | 0 |
86412 | 86412 | 2020-04-24 | Jones | Texas | 48253 | 7 | 0 |
83607 | 83607 | 2020-04-23 | Jones | Texas | 48253 | 4 | 0 |
80806 | 80806 | 2020-04-22 | Jones | Texas | 48253 | 3 | 0 |
78015 | 78015 | 2020-04-21 | Jones | Texas | 48253 | 3 | 0 |
75233 | 75233 | 2020-04-20 | Jones | Texas | 48253 | 3 | 0 |
72457 | 72457 | 2020-04-19 | Jones | Texas | 48253 | 3 | 0 |
69688 | 69688 | 2020-04-18 | Jones | Texas | 48253 | 3 | 0 |
66928 | 66928 | 2020-04-17 | Jones | Texas | 48253 | 3 | 0 |
64181 | 64181 | 2020-04-16 | Jones | Texas | 48253 | 3 | 0 |
61454 | 61454 | 2020-04-15 | Jones | Texas | 48253 | 2 | 0 |
58736 | 58736 | 2020-04-14 | Jones | Texas | 48253 | 2 | 0 |
56031 | 56031 | 2020-04-13 | Jones | Texas | 48253 | 2 | 0 |
53343 | 53343 | 2020-04-12 | Jones | Texas | 48253 | 2 | 0 |
50668 | 50668 | 2020-04-11 | Jones | Texas | 48253 | 2 | 0 |
48010 | 48010 | 2020-04-10 | Jones | Texas | 48253 | 2 | 0 |
45389 | 45389 | 2020-04-09 | Jones | Texas | 48253 | 1 | 0 |
42799 | 42799 | 2020-04-08 | Jones | Texas | 48253 | 1 | 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);