ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Collingsworth" 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 |
---|---|---|---|---|---|---|---|
117794 | 117794 | 2020-05-05 | Collingsworth | Texas | 48087 | 1 | 0 |
120758 | 120758 | 2020-05-06 | Collingsworth | Texas | 48087 | 1 | 0 |
123737 | 123737 | 2020-05-07 | Collingsworth | Texas | 48087 | 1 | 0 |
126720 | 126720 | 2020-05-08 | Collingsworth | Texas | 48087 | 1 | 0 |
129709 | 129709 | 2020-05-09 | Collingsworth | Texas | 48087 | 1 | 0 |
132699 | 132699 | 2020-05-10 | Collingsworth | Texas | 48087 | 4 | 0 |
135690 | 135690 | 2020-05-11 | Collingsworth | Texas | 48087 | 4 | 0 |
138680 | 138680 | 2020-05-12 | Collingsworth | Texas | 48087 | 4 | 0 |
141676 | 141676 | 2020-05-13 | Collingsworth | Texas | 48087 | 4 | 0 |
144673 | 144673 | 2020-05-14 | Collingsworth | Texas | 48087 | 4 | 0 |
147675 | 147675 | 2020-05-15 | Collingsworth | Texas | 48087 | 4 | 0 |
150683 | 150683 | 2020-05-16 | Collingsworth | Texas | 48087 | 4 | 0 |
153694 | 153694 | 2020-05-17 | Collingsworth | Texas | 48087 | 4 | 0 |
156711 | 156711 | 2020-05-18 | Collingsworth | Texas | 48087 | 4 | 0 |
159733 | 159733 | 2020-05-19 | Collingsworth | Texas | 48087 | 4 | 0 |
162760 | 162760 | 2020-05-20 | Collingsworth | Texas | 48087 | 4 | 0 |
165789 | 165789 | 2020-05-21 | Collingsworth | Texas | 48087 | 4 | 0 |
168825 | 168825 | 2020-05-22 | Collingsworth | Texas | 48087 | 4 | 0 |
171864 | 171864 | 2020-05-23 | Collingsworth | Texas | 48087 | 4 | 0 |
174907 | 174907 | 2020-05-24 | Collingsworth | Texas | 48087 | 4 | 0 |
177951 | 177951 | 2020-05-25 | Collingsworth | Texas | 48087 | 4 | 0 |
180994 | 180994 | 2020-05-26 | Collingsworth | Texas | 48087 | 5 | 0 |
184044 | 184044 | 2020-05-27 | Collingsworth | Texas | 48087 | 5 | 0 |
187101 | 187101 | 2020-05-28 | Collingsworth | Texas | 48087 | 5 | 0 |
190165 | 190165 | 2020-05-29 | Collingsworth | Texas | 48087 | 5 | 0 |
193230 | 193230 | 2020-05-30 | Collingsworth | Texas | 48087 | 5 | 0 |
196300 | 196300 | 2020-05-31 | Collingsworth | Texas | 48087 | 5 | 0 |
199373 | 199373 | 2020-06-01 | Collingsworth | Texas | 48087 | 5 | 0 |
202448 | 202448 | 2020-06-02 | Collingsworth | Texas | 48087 | 5 | 0 |
205527 | 205527 | 2020-06-03 | Collingsworth | Texas | 48087 | 5 | 0 |
208609 | 208609 | 2020-06-04 | Collingsworth | Texas | 48087 | 5 | 0 |
211692 | 211692 | 2020-06-05 | Collingsworth | Texas | 48087 | 5 | 0 |
214779 | 214779 | 2020-06-06 | Collingsworth | Texas | 48087 | 5 | 0 |
217869 | 217869 | 2020-06-07 | Collingsworth | Texas | 48087 | 5 | 0 |
220961 | 220961 | 2020-06-08 | Collingsworth | Texas | 48087 | 5 | 0 |
224056 | 224056 | 2020-06-09 | Collingsworth | Texas | 48087 | 5 | 0 |
227156 | 227156 | 2020-06-10 | Collingsworth | Texas | 48087 | 5 | 0 |
230260 | 230260 | 2020-06-11 | Collingsworth | Texas | 48087 | 5 | 0 |
233364 | 233364 | 2020-06-12 | Collingsworth | Texas | 48087 | 5 | 0 |
236470 | 236470 | 2020-06-13 | Collingsworth | Texas | 48087 | 5 | 0 |
239578 | 239578 | 2020-06-14 | Collingsworth | Texas | 48087 | 5 | 0 |
242688 | 242688 | 2020-06-15 | Collingsworth | Texas | 48087 | 5 | 0 |
245800 | 245800 | 2020-06-16 | Collingsworth | Texas | 48087 | 5 | 0 |
248913 | 248913 | 2020-06-17 | Collingsworth | Texas | 48087 | 5 | 0 |
252028 | 252028 | 2020-06-18 | Collingsworth | Texas | 48087 | 5 | 0 |
255143 | 255143 | 2020-06-19 | Collingsworth | Texas | 48087 | 5 | 0 |
258269 | 258269 | 2020-06-20 | Collingsworth | Texas | 48087 | 5 | 0 |
261396 | 261396 | 2020-06-21 | Collingsworth | Texas | 48087 | 5 | 0 |
264524 | 264524 | 2020-06-22 | Collingsworth | Texas | 48087 | 5 | 0 |
267652 | 267652 | 2020-06-23 | Collingsworth | Texas | 48087 | 5 | 0 |
270786 | 270786 | 2020-06-24 | Collingsworth | Texas | 48087 | 5 | 0 |
273925 | 273925 | 2020-06-25 | Collingsworth | Texas | 48087 | 5 | 0 |
277072 | 277072 | 2020-06-26 | Collingsworth | Texas | 48087 | 5 | 0 |
280220 | 280220 | 2020-06-27 | Collingsworth | Texas | 48087 | 6 | 0 |
283366 | 283366 | 2020-06-28 | Collingsworth | Texas | 48087 | 6 | 0 |
286512 | 286512 | 2020-06-29 | Collingsworth | Texas | 48087 | 6 | 0 |
289662 | 289662 | 2020-06-30 | Collingsworth | Texas | 48087 | 6 | 0 |
292815 | 292815 | 2020-07-01 | Collingsworth | Texas | 48087 | 6 | 0 |
295970 | 295970 | 2020-07-02 | Collingsworth | Texas | 48087 | 6 | 0 |
299130 | 299130 | 2020-07-03 | Collingsworth | Texas | 48087 | 6 | 0 |
302294 | 302294 | 2020-07-04 | Collingsworth | Texas | 48087 | 6 | 0 |
305458 | 305458 | 2020-07-05 | Collingsworth | Texas | 48087 | 6 | 0 |
308626 | 308626 | 2020-07-06 | Collingsworth | Texas | 48087 | 6 | 0 |
311795 | 311795 | 2020-07-07 | Collingsworth | Texas | 48087 | 6 | 0 |
314969 | 314969 | 2020-07-08 | Collingsworth | Texas | 48087 | 6 | 0 |
318142 | 318142 | 2020-07-09 | Collingsworth | Texas | 48087 | 6 | 0 |
321320 | 321320 | 2020-07-10 | Collingsworth | Texas | 48087 | 6 | 0 |
324501 | 324501 | 2020-07-11 | Collingsworth | Texas | 48087 | 6 | 0 |
327686 | 327686 | 2020-07-12 | Collingsworth | Texas | 48087 | 6 | 0 |
330872 | 330872 | 2020-07-13 | Collingsworth | Texas | 48087 | 6 | 0 |
334063 | 334063 | 2020-07-14 | Collingsworth | Texas | 48087 | 6 | 0 |
337258 | 337258 | 2020-07-15 | Collingsworth | Texas | 48087 | 6 | 0 |
340454 | 340454 | 2020-07-16 | Collingsworth | Texas | 48087 | 6 | 0 |
343653 | 343653 | 2020-07-17 | Collingsworth | Texas | 48087 | 6 | 0 |
346853 | 346853 | 2020-07-18 | Collingsworth | Texas | 48087 | 6 | 0 |
350053 | 350053 | 2020-07-19 | Collingsworth | Texas | 48087 | 6 | 0 |
353255 | 353255 | 2020-07-20 | Collingsworth | Texas | 48087 | 6 | 0 |
356458 | 356458 | 2020-07-21 | Collingsworth | Texas | 48087 | 6 | 0 |
359663 | 359663 | 2020-07-22 | Collingsworth | Texas | 48087 | 6 | 0 |
362870 | 362870 | 2020-07-23 | Collingsworth | Texas | 48087 | 6 | 0 |
366076 | 366076 | 2020-07-24 | Collingsworth | Texas | 48087 | 6 | 0 |
369285 | 369285 | 2020-07-25 | Collingsworth | Texas | 48087 | 6 | 0 |
372497 | 372497 | 2020-07-26 | Collingsworth | Texas | 48087 | 6 | 0 |
375710 | 375710 | 2020-07-27 | Collingsworth | Texas | 48087 | 6 | 0 |
378926 | 378926 | 2020-07-28 | Collingsworth | Texas | 48087 | 6 | 0 |
382143 | 382143 | 2020-07-29 | Collingsworth | Texas | 48087 | 6 | 0 |
385361 | 385361 | 2020-07-30 | Collingsworth | Texas | 48087 | 7 | 0 |
388578 | 388578 | 2020-07-31 | Collingsworth | Texas | 48087 | 7 | 0 |
391795 | 391795 | 2020-08-01 | Collingsworth | Texas | 48087 | 7 | 0 |
395011 | 395011 | 2020-08-02 | Collingsworth | Texas | 48087 | 7 | 0 |
398227 | 398227 | 2020-08-03 | Collingsworth | Texas | 48087 | 7 | 0 |
401443 | 401443 | 2020-08-04 | Collingsworth | Texas | 48087 | 7 | 0 |
404661 | 404661 | 2020-08-05 | Collingsworth | Texas | 48087 | 7 | 0 |
407881 | 407881 | 2020-08-06 | Collingsworth | Texas | 48087 | 8 | 0 |
411100 | 411100 | 2020-08-07 | Collingsworth | Texas | 48087 | 11 | 0 |
414320 | 414320 | 2020-08-08 | Collingsworth | Texas | 48087 | 11 | 0 |
417541 | 417541 | 2020-08-09 | Collingsworth | Texas | 48087 | 11 | 0 |
420762 | 420762 | 2020-08-10 | Collingsworth | Texas | 48087 | 11 | 0 |
423983 | 423983 | 2020-08-11 | Collingsworth | Texas | 48087 | 12 | 0 |
427207 | 427207 | 2020-08-12 | Collingsworth | Texas | 48087 | 12 | 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);