ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
744 rows where county = "Garza" and state = "Texas" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
103382 | 103382 | 2020-04-30 | Garza | Texas | 48169 | 1 | 0 |
106246 | 106246 | 2020-05-01 | Garza | Texas | 48169 | 1 | 0 |
109115 | 109115 | 2020-05-02 | Garza | Texas | 48169 | 3 | 0 |
111989 | 111989 | 2020-05-03 | Garza | Texas | 48169 | 3 | 0 |
114871 | 114871 | 2020-05-04 | Garza | Texas | 48169 | 3 | 0 |
117830 | 117830 | 2020-05-05 | Garza | Texas | 48169 | 3 | 0 |
120794 | 120794 | 2020-05-06 | Garza | Texas | 48169 | 3 | 0 |
123773 | 123773 | 2020-05-07 | Garza | Texas | 48169 | 3 | 0 |
126756 | 126756 | 2020-05-08 | Garza | Texas | 48169 | 3 | 0 |
129745 | 129745 | 2020-05-09 | Garza | Texas | 48169 | 3 | 0 |
132735 | 132735 | 2020-05-10 | Garza | Texas | 48169 | 3 | 0 |
135726 | 135726 | 2020-05-11 | Garza | Texas | 48169 | 3 | 0 |
138716 | 138716 | 2020-05-12 | Garza | Texas | 48169 | 4 | 0 |
141712 | 141712 | 2020-05-13 | Garza | Texas | 48169 | 4 | 0 |
144709 | 144709 | 2020-05-14 | Garza | Texas | 48169 | 4 | 0 |
147712 | 147712 | 2020-05-15 | Garza | Texas | 48169 | 4 | 0 |
150720 | 150720 | 2020-05-16 | Garza | Texas | 48169 | 4 | 0 |
153731 | 153731 | 2020-05-17 | Garza | Texas | 48169 | 4 | 0 |
156748 | 156748 | 2020-05-18 | Garza | Texas | 48169 | 4 | 0 |
159770 | 159770 | 2020-05-19 | Garza | Texas | 48169 | 4 | 0 |
162797 | 162797 | 2020-05-20 | Garza | Texas | 48169 | 4 | 0 |
165826 | 165826 | 2020-05-21 | Garza | Texas | 48169 | 4 | 0 |
168862 | 168862 | 2020-05-22 | Garza | Texas | 48169 | 4 | 0 |
171901 | 171901 | 2020-05-23 | Garza | Texas | 48169 | 5 | 0 |
174944 | 174944 | 2020-05-24 | Garza | Texas | 48169 | 5 | 0 |
177988 | 177988 | 2020-05-25 | Garza | Texas | 48169 | 5 | 0 |
181031 | 181031 | 2020-05-26 | Garza | Texas | 48169 | 5 | 0 |
184081 | 184081 | 2020-05-27 | Garza | Texas | 48169 | 5 | 0 |
187138 | 187138 | 2020-05-28 | Garza | Texas | 48169 | 5 | 0 |
190202 | 190202 | 2020-05-29 | Garza | Texas | 48169 | 5 | 0 |
193267 | 193267 | 2020-05-30 | Garza | Texas | 48169 | 5 | 0 |
196337 | 196337 | 2020-05-31 | Garza | Texas | 48169 | 5 | 0 |
199410 | 199410 | 2020-06-01 | Garza | Texas | 48169 | 5 | 0 |
202485 | 202485 | 2020-06-02 | Garza | Texas | 48169 | 5 | 0 |
205564 | 205564 | 2020-06-03 | Garza | Texas | 48169 | 6 | 0 |
208646 | 208646 | 2020-06-04 | Garza | Texas | 48169 | 6 | 0 |
211730 | 211730 | 2020-06-05 | Garza | Texas | 48169 | 6 | 0 |
214817 | 214817 | 2020-06-06 | Garza | Texas | 48169 | 6 | 0 |
217907 | 217907 | 2020-06-07 | Garza | Texas | 48169 | 6 | 0 |
220999 | 220999 | 2020-06-08 | Garza | Texas | 48169 | 6 | 0 |
224094 | 224094 | 2020-06-09 | Garza | Texas | 48169 | 6 | 0 |
227194 | 227194 | 2020-06-10 | Garza | Texas | 48169 | 7 | 0 |
230298 | 230298 | 2020-06-11 | Garza | Texas | 48169 | 6 | 0 |
233402 | 233402 | 2020-06-12 | Garza | Texas | 48169 | 6 | 0 |
236508 | 236508 | 2020-06-13 | Garza | Texas | 48169 | 6 | 0 |
239616 | 239616 | 2020-06-14 | Garza | Texas | 48169 | 6 | 0 |
242726 | 242726 | 2020-06-15 | Garza | Texas | 48169 | 6 | 0 |
245838 | 245838 | 2020-06-16 | Garza | Texas | 48169 | 7 | 0 |
248951 | 248951 | 2020-06-17 | Garza | Texas | 48169 | 7 | 0 |
252066 | 252066 | 2020-06-18 | Garza | Texas | 48169 | 7 | 0 |
255181 | 255181 | 2020-06-19 | Garza | Texas | 48169 | 7 | 0 |
258308 | 258308 | 2020-06-20 | Garza | Texas | 48169 | 7 | 0 |
261435 | 261435 | 2020-06-21 | Garza | Texas | 48169 | 7 | 0 |
264563 | 264563 | 2020-06-22 | Garza | Texas | 48169 | 7 | 0 |
267691 | 267691 | 2020-06-23 | Garza | Texas | 48169 | 7 | 0 |
270825 | 270825 | 2020-06-24 | Garza | Texas | 48169 | 7 | 0 |
273965 | 273965 | 2020-06-25 | Garza | Texas | 48169 | 11 | 0 |
277112 | 277112 | 2020-06-26 | Garza | Texas | 48169 | 11 | 0 |
280260 | 280260 | 2020-06-27 | Garza | Texas | 48169 | 12 | 0 |
283406 | 283406 | 2020-06-28 | Garza | Texas | 48169 | 12 | 0 |
286552 | 286552 | 2020-06-29 | Garza | Texas | 48169 | 12 | 0 |
289702 | 289702 | 2020-06-30 | Garza | Texas | 48169 | 12 | 0 |
292855 | 292855 | 2020-07-01 | Garza | Texas | 48169 | 12 | 0 |
296010 | 296010 | 2020-07-02 | Garza | Texas | 48169 | 12 | 0 |
299170 | 299170 | 2020-07-03 | Garza | Texas | 48169 | 12 | 0 |
302334 | 302334 | 2020-07-04 | Garza | Texas | 48169 | 12 | 0 |
305498 | 305498 | 2020-07-05 | Garza | Texas | 48169 | 12 | 0 |
308666 | 308666 | 2020-07-06 | Garza | Texas | 48169 | 12 | 0 |
311835 | 311835 | 2020-07-07 | Garza | Texas | 48169 | 14 | 0 |
315009 | 315009 | 2020-07-08 | Garza | Texas | 48169 | 18 | 0 |
318182 | 318182 | 2020-07-09 | Garza | Texas | 48169 | 19 | 0 |
321361 | 321361 | 2020-07-10 | Garza | Texas | 48169 | 20 | 1 |
324542 | 324542 | 2020-07-11 | Garza | Texas | 48169 | 21 | 1 |
327727 | 327727 | 2020-07-12 | Garza | Texas | 48169 | 21 | 1 |
330913 | 330913 | 2020-07-13 | Garza | Texas | 48169 | 21 | 1 |
334104 | 334104 | 2020-07-14 | Garza | Texas | 48169 | 22 | 1 |
337299 | 337299 | 2020-07-15 | Garza | Texas | 48169 | 39 | 1 |
340495 | 340495 | 2020-07-16 | Garza | Texas | 48169 | 58 | 1 |
343694 | 343694 | 2020-07-17 | Garza | Texas | 48169 | 58 | 1 |
346894 | 346894 | 2020-07-18 | Garza | Texas | 48169 | 60 | 1 |
350094 | 350094 | 2020-07-19 | Garza | Texas | 48169 | 60 | 1 |
353296 | 353296 | 2020-07-20 | Garza | Texas | 48169 | 60 | 1 |
356499 | 356499 | 2020-07-21 | Garza | Texas | 48169 | 82 | 1 |
359704 | 359704 | 2020-07-22 | Garza | Texas | 48169 | 82 | 1 |
362911 | 362911 | 2020-07-23 | Garza | Texas | 48169 | 88 | 1 |
366117 | 366117 | 2020-07-24 | Garza | Texas | 48169 | 90 | 2 |
369326 | 369326 | 2020-07-25 | Garza | Texas | 48169 | 94 | 2 |
372538 | 372538 | 2020-07-26 | Garza | Texas | 48169 | 94 | 2 |
375751 | 375751 | 2020-07-27 | Garza | Texas | 48169 | 94 | 1 |
378967 | 378967 | 2020-07-28 | Garza | Texas | 48169 | 94 | 1 |
382184 | 382184 | 2020-07-29 | Garza | Texas | 48169 | 95 | 1 |
385402 | 385402 | 2020-07-30 | Garza | Texas | 48169 | 95 | 2 |
388619 | 388619 | 2020-07-31 | Garza | Texas | 48169 | 96 | 2 |
391836 | 391836 | 2020-08-01 | Garza | Texas | 48169 | 97 | 2 |
395052 | 395052 | 2020-08-02 | Garza | Texas | 48169 | 97 | 2 |
398268 | 398268 | 2020-08-03 | Garza | Texas | 48169 | 97 | 2 |
401484 | 401484 | 2020-08-04 | Garza | Texas | 48169 | 97 | 2 |
404702 | 404702 | 2020-08-05 | Garza | Texas | 48169 | 99 | 2 |
407922 | 407922 | 2020-08-06 | Garza | Texas | 48169 | 99 | 3 |
411141 | 411141 | 2020-08-07 | Garza | Texas | 48169 | 99 | 3 |
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);