ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Lavaca" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388676 | 388676 | 2020-07-31 | Lavaca | Texas | 48285 | 593 | 14 |
385459 | 385459 | 2020-07-30 | Lavaca | Texas | 48285 | 593 | 13 |
382241 | 382241 | 2020-07-29 | Lavaca | Texas | 48285 | 582 | 11 |
379024 | 379024 | 2020-07-28 | Lavaca | Texas | 48285 | 569 | 11 |
375808 | 375808 | 2020-07-27 | Lavaca | Texas | 48285 | 545 | 10 |
372595 | 372595 | 2020-07-26 | Lavaca | Texas | 48285 | 545 | 1 |
369383 | 369383 | 2020-07-25 | Lavaca | Texas | 48285 | 545 | 1 |
366174 | 366174 | 2020-07-24 | Lavaca | Texas | 48285 | 538 | 1 |
362968 | 362968 | 2020-07-23 | Lavaca | Texas | 48285 | 525 | 1 |
359761 | 359761 | 2020-07-22 | Lavaca | Texas | 48285 | 510 | 1 |
356556 | 356556 | 2020-07-21 | Lavaca | Texas | 48285 | 495 | 1 |
353353 | 353353 | 2020-07-20 | Lavaca | Texas | 48285 | 464 | 1 |
350151 | 350151 | 2020-07-19 | Lavaca | Texas | 48285 | 464 | 1 |
346951 | 346951 | 2020-07-18 | Lavaca | Texas | 48285 | 464 | 1 |
343751 | 343751 | 2020-07-17 | Lavaca | Texas | 48285 | 367 | 1 |
340552 | 340552 | 2020-07-16 | Lavaca | Texas | 48285 | 363 | 1 |
337356 | 337356 | 2020-07-15 | Lavaca | Texas | 48285 | 351 | 1 |
334161 | 334161 | 2020-07-14 | Lavaca | Texas | 48285 | 340 | 1 |
330969 | 330969 | 2020-07-13 | Lavaca | Texas | 48285 | 337 | 1 |
327783 | 327783 | 2020-07-12 | Lavaca | Texas | 48285 | 337 | 1 |
324598 | 324598 | 2020-07-11 | Lavaca | Texas | 48285 | 238 | 1 |
321417 | 321417 | 2020-07-10 | Lavaca | Texas | 48285 | 228 | 1 |
318238 | 318238 | 2020-07-09 | Lavaca | Texas | 48285 | 212 | 1 |
315065 | 315065 | 2020-07-08 | Lavaca | Texas | 48285 | 198 | 1 |
311891 | 311891 | 2020-07-07 | Lavaca | Texas | 48285 | 197 | 1 |
308722 | 308722 | 2020-07-06 | Lavaca | Texas | 48285 | 184 | 1 |
305554 | 305554 | 2020-07-05 | Lavaca | Texas | 48285 | 184 | 1 |
302390 | 302390 | 2020-07-04 | Lavaca | Texas | 48285 | 184 | 1 |
299226 | 299226 | 2020-07-03 | Lavaca | Texas | 48285 | 175 | 1 |
296065 | 296065 | 2020-07-02 | Lavaca | Texas | 48285 | 150 | 1 |
292910 | 292910 | 2020-07-01 | Lavaca | Texas | 48285 | 134 | 1 |
289757 | 289757 | 2020-06-30 | Lavaca | Texas | 48285 | 131 | 1 |
286607 | 286607 | 2020-06-29 | Lavaca | Texas | 48285 | 123 | 1 |
283461 | 283461 | 2020-06-28 | Lavaca | Texas | 48285 | 123 | 1 |
280315 | 280315 | 2020-06-27 | Lavaca | Texas | 48285 | 122 | 1 |
277167 | 277167 | 2020-06-26 | Lavaca | Texas | 48285 | 117 | 1 |
274019 | 274019 | 2020-06-25 | Lavaca | Texas | 48285 | 108 | 1 |
270879 | 270879 | 2020-06-24 | Lavaca | Texas | 48285 | 99 | 1 |
267745 | 267745 | 2020-06-23 | Lavaca | Texas | 48285 | 86 | 1 |
264617 | 264617 | 2020-06-22 | Lavaca | Texas | 48285 | 85 | 1 |
261489 | 261489 | 2020-06-21 | Lavaca | Texas | 48285 | 85 | 1 |
258362 | 258362 | 2020-06-20 | Lavaca | Texas | 48285 | 68 | 1 |
255235 | 255235 | 2020-06-19 | Lavaca | Texas | 48285 | 43 | 1 |
252120 | 252120 | 2020-06-18 | Lavaca | Texas | 48285 | 22 | 1 |
249005 | 249005 | 2020-06-17 | Lavaca | Texas | 48285 | 22 | 1 |
245892 | 245892 | 2020-06-16 | Lavaca | Texas | 48285 | 22 | 1 |
242780 | 242780 | 2020-06-15 | Lavaca | Texas | 48285 | 22 | 1 |
239670 | 239670 | 2020-06-14 | Lavaca | Texas | 48285 | 22 | 1 |
236562 | 236562 | 2020-06-13 | Lavaca | Texas | 48285 | 22 | 1 |
233456 | 233456 | 2020-06-12 | Lavaca | Texas | 48285 | 21 | 1 |
230352 | 230352 | 2020-06-11 | Lavaca | Texas | 48285 | 21 | 1 |
227248 | 227248 | 2020-06-10 | Lavaca | Texas | 48285 | 20 | 1 |
224148 | 224148 | 2020-06-09 | Lavaca | Texas | 48285 | 19 | 1 |
221053 | 221053 | 2020-06-08 | Lavaca | Texas | 48285 | 19 | 1 |
217961 | 217961 | 2020-06-07 | Lavaca | Texas | 48285 | 19 | 1 |
214871 | 214871 | 2020-06-06 | Lavaca | Texas | 48285 | 19 | 1 |
211784 | 211784 | 2020-06-05 | Lavaca | Texas | 48285 | 18 | 1 |
208700 | 208700 | 2020-06-04 | Lavaca | Texas | 48285 | 17 | 1 |
205618 | 205618 | 2020-06-03 | Lavaca | Texas | 48285 | 14 | 1 |
202539 | 202539 | 2020-06-02 | Lavaca | Texas | 48285 | 13 | 1 |
199463 | 199463 | 2020-06-01 | Lavaca | Texas | 48285 | 12 | 1 |
196390 | 196390 | 2020-05-31 | Lavaca | Texas | 48285 | 12 | 1 |
193320 | 193320 | 2020-05-30 | Lavaca | Texas | 48285 | 12 | 1 |
190254 | 190254 | 2020-05-29 | Lavaca | Texas | 48285 | 11 | 1 |
187190 | 187190 | 2020-05-28 | Lavaca | Texas | 48285 | 11 | 1 |
184133 | 184133 | 2020-05-27 | Lavaca | Texas | 48285 | 11 | 1 |
181083 | 181083 | 2020-05-26 | Lavaca | Texas | 48285 | 9 | 1 |
178039 | 178039 | 2020-05-25 | Lavaca | Texas | 48285 | 9 | 1 |
174995 | 174995 | 2020-05-24 | Lavaca | Texas | 48285 | 9 | 1 |
171952 | 171952 | 2020-05-23 | Lavaca | Texas | 48285 | 8 | 1 |
168912 | 168912 | 2020-05-22 | Lavaca | Texas | 48285 | 8 | 1 |
165876 | 165876 | 2020-05-21 | Lavaca | Texas | 48285 | 8 | 1 |
162847 | 162847 | 2020-05-20 | Lavaca | Texas | 48285 | 8 | 1 |
159819 | 159819 | 2020-05-19 | Lavaca | Texas | 48285 | 8 | 1 |
156797 | 156797 | 2020-05-18 | Lavaca | Texas | 48285 | 8 | 1 |
153780 | 153780 | 2020-05-17 | Lavaca | Texas | 48285 | 8 | 1 |
150769 | 150769 | 2020-05-16 | Lavaca | Texas | 48285 | 8 | 1 |
147761 | 147761 | 2020-05-15 | Lavaca | Texas | 48285 | 7 | 1 |
144757 | 144757 | 2020-05-14 | Lavaca | Texas | 48285 | 7 | 1 |
141760 | 141760 | 2020-05-13 | Lavaca | Texas | 48285 | 7 | 1 |
138764 | 138764 | 2020-05-12 | Lavaca | Texas | 48285 | 6 | 1 |
135774 | 135774 | 2020-05-11 | Lavaca | Texas | 48285 | 6 | 1 |
132783 | 132783 | 2020-05-10 | Lavaca | Texas | 48285 | 6 | 1 |
129793 | 129793 | 2020-05-09 | Lavaca | Texas | 48285 | 6 | 1 |
126804 | 126804 | 2020-05-08 | Lavaca | Texas | 48285 | 6 | 1 |
123820 | 123820 | 2020-05-07 | Lavaca | Texas | 48285 | 6 | 1 |
120841 | 120841 | 2020-05-06 | Lavaca | Texas | 48285 | 6 | 1 |
117877 | 117877 | 2020-05-05 | Lavaca | Texas | 48285 | 6 | 1 |
114918 | 114918 | 2020-05-04 | Lavaca | Texas | 48285 | 6 | 1 |
112036 | 112036 | 2020-05-03 | Lavaca | Texas | 48285 | 6 | 1 |
109162 | 109162 | 2020-05-02 | Lavaca | Texas | 48285 | 6 | 1 |
106293 | 106293 | 2020-05-01 | Lavaca | Texas | 48285 | 6 | 1 |
103429 | 103429 | 2020-04-30 | Lavaca | Texas | 48285 | 6 | 1 |
100574 | 100574 | 2020-04-29 | Lavaca | Texas | 48285 | 5 | 1 |
97724 | 97724 | 2020-04-28 | Lavaca | Texas | 48285 | 5 | 1 |
94884 | 94884 | 2020-04-27 | Lavaca | Texas | 48285 | 5 | 1 |
92055 | 92055 | 2020-04-26 | Lavaca | Texas | 48285 | 5 | 1 |
89238 | 89238 | 2020-04-25 | Lavaca | Texas | 48285 | 5 | 1 |
86423 | 86423 | 2020-04-24 | Lavaca | Texas | 48285 | 5 | 0 |
83618 | 83618 | 2020-04-23 | Lavaca | Texas | 48285 | 5 | 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);