ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
729 rows where county = "Haskell" and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
147729 | 147729 | 2020-05-15 | Haskell | Texas | 48207 | 1 | 0 |
150737 | 150737 | 2020-05-16 | Haskell | Texas | 48207 | 1 | 0 |
153748 | 153748 | 2020-05-17 | Haskell | Texas | 48207 | 1 | 0 |
156765 | 156765 | 2020-05-18 | Haskell | Texas | 48207 | 1 | 0 |
159787 | 159787 | 2020-05-19 | Haskell | Texas | 48207 | 2 | 0 |
162815 | 162815 | 2020-05-20 | Haskell | Texas | 48207 | 2 | 0 |
165844 | 165844 | 2020-05-21 | Haskell | Texas | 48207 | 2 | 0 |
168880 | 168880 | 2020-05-22 | Haskell | Texas | 48207 | 2 | 0 |
171920 | 171920 | 2020-05-23 | Haskell | Texas | 48207 | 2 | 0 |
174963 | 174963 | 2020-05-24 | Haskell | Texas | 48207 | 2 | 0 |
178007 | 178007 | 2020-05-25 | Haskell | Texas | 48207 | 2 | 0 |
181050 | 181050 | 2020-05-26 | Haskell | Texas | 48207 | 2 | 0 |
184100 | 184100 | 2020-05-27 | Haskell | Texas | 48207 | 2 | 0 |
187157 | 187157 | 2020-05-28 | Haskell | Texas | 48207 | 2 | 0 |
190221 | 190221 | 2020-05-29 | Haskell | Texas | 48207 | 3 | 0 |
193286 | 193286 | 2020-05-30 | Haskell | Texas | 48207 | 3 | 0 |
196356 | 196356 | 2020-05-31 | Haskell | Texas | 48207 | 3 | 0 |
199429 | 199429 | 2020-06-01 | Haskell | Texas | 48207 | 3 | 0 |
202504 | 202504 | 2020-06-02 | Haskell | Texas | 48207 | 3 | 0 |
205583 | 205583 | 2020-06-03 | Haskell | Texas | 48207 | 3 | 0 |
208665 | 208665 | 2020-06-04 | Haskell | Texas | 48207 | 3 | 0 |
211749 | 211749 | 2020-06-05 | Haskell | Texas | 48207 | 3 | 0 |
214836 | 214836 | 2020-06-06 | Haskell | Texas | 48207 | 3 | 0 |
217926 | 217926 | 2020-06-07 | Haskell | Texas | 48207 | 3 | 0 |
221018 | 221018 | 2020-06-08 | Haskell | Texas | 48207 | 3 | 0 |
224113 | 224113 | 2020-06-09 | Haskell | Texas | 48207 | 3 | 0 |
227213 | 227213 | 2020-06-10 | Haskell | Texas | 48207 | 3 | 0 |
230317 | 230317 | 2020-06-11 | Haskell | Texas | 48207 | 3 | 0 |
233421 | 233421 | 2020-06-12 | Haskell | Texas | 48207 | 4 | 0 |
236527 | 236527 | 2020-06-13 | Haskell | Texas | 48207 | 4 | 0 |
239635 | 239635 | 2020-06-14 | Haskell | Texas | 48207 | 4 | 0 |
242745 | 242745 | 2020-06-15 | Haskell | Texas | 48207 | 4 | 0 |
245857 | 245857 | 2020-06-16 | Haskell | Texas | 48207 | 4 | 0 |
248970 | 248970 | 2020-06-17 | Haskell | Texas | 48207 | 4 | 0 |
252085 | 252085 | 2020-06-18 | Haskell | Texas | 48207 | 4 | 0 |
255200 | 255200 | 2020-06-19 | Haskell | Texas | 48207 | 4 | 0 |
258327 | 258327 | 2020-06-20 | Haskell | Texas | 48207 | 4 | 0 |
261454 | 261454 | 2020-06-21 | Haskell | Texas | 48207 | 4 | 0 |
264582 | 264582 | 2020-06-22 | Haskell | Texas | 48207 | 4 | 0 |
267710 | 267710 | 2020-06-23 | Haskell | Texas | 48207 | 4 | 0 |
270844 | 270844 | 2020-06-24 | Haskell | Texas | 48207 | 4 | 0 |
273984 | 273984 | 2020-06-25 | Haskell | Texas | 48207 | 4 | 0 |
277131 | 277131 | 2020-06-26 | Haskell | Texas | 48207 | 4 | 0 |
280279 | 280279 | 2020-06-27 | Haskell | Texas | 48207 | 4 | 0 |
283425 | 283425 | 2020-06-28 | Haskell | Texas | 48207 | 4 | 0 |
286571 | 286571 | 2020-06-29 | Haskell | Texas | 48207 | 4 | 0 |
289721 | 289721 | 2020-06-30 | Haskell | Texas | 48207 | 5 | 0 |
292874 | 292874 | 2020-07-01 | Haskell | Texas | 48207 | 5 | 0 |
296029 | 296029 | 2020-07-02 | Haskell | Texas | 48207 | 5 | 0 |
299189 | 299189 | 2020-07-03 | Haskell | Texas | 48207 | 5 | 0 |
302353 | 302353 | 2020-07-04 | Haskell | Texas | 48207 | 5 | 0 |
305517 | 305517 | 2020-07-05 | Haskell | Texas | 48207 | 5 | 0 |
308685 | 308685 | 2020-07-06 | Haskell | Texas | 48207 | 5 | 0 |
311854 | 311854 | 2020-07-07 | Haskell | Texas | 48207 | 6 | 0 |
315028 | 315028 | 2020-07-08 | Haskell | Texas | 48207 | 6 | 0 |
318201 | 318201 | 2020-07-09 | Haskell | Texas | 48207 | 7 | 0 |
321380 | 321380 | 2020-07-10 | Haskell | Texas | 48207 | 6 | 0 |
324561 | 324561 | 2020-07-11 | Haskell | Texas | 48207 | 6 | 0 |
327746 | 327746 | 2020-07-12 | Haskell | Texas | 48207 | 6 | 0 |
330932 | 330932 | 2020-07-13 | Haskell | Texas | 48207 | 6 | 0 |
334123 | 334123 | 2020-07-14 | Haskell | Texas | 48207 | 8 | 0 |
337318 | 337318 | 2020-07-15 | Haskell | Texas | 48207 | 17 | 0 |
340514 | 340514 | 2020-07-16 | Haskell | Texas | 48207 | 19 | 0 |
343713 | 343713 | 2020-07-17 | Haskell | Texas | 48207 | 32 | 0 |
346913 | 346913 | 2020-07-18 | Haskell | Texas | 48207 | 24 | 0 |
350113 | 350113 | 2020-07-19 | Haskell | Texas | 48207 | 24 | 0 |
353315 | 353315 | 2020-07-20 | Haskell | Texas | 48207 | 24 | 0 |
356518 | 356518 | 2020-07-21 | Haskell | Texas | 48207 | 25 | 0 |
359723 | 359723 | 2020-07-22 | Haskell | Texas | 48207 | 25 | 0 |
362930 | 362930 | 2020-07-23 | Haskell | Texas | 48207 | 25 | 0 |
366136 | 366136 | 2020-07-24 | Haskell | Texas | 48207 | 28 | 0 |
369345 | 369345 | 2020-07-25 | Haskell | Texas | 48207 | 30 | 0 |
372557 | 372557 | 2020-07-26 | Haskell | Texas | 48207 | 30 | 0 |
375770 | 375770 | 2020-07-27 | Haskell | Texas | 48207 | 30 | 0 |
378986 | 378986 | 2020-07-28 | Haskell | Texas | 48207 | 30 | 0 |
382203 | 382203 | 2020-07-29 | Haskell | Texas | 48207 | 30 | 0 |
385421 | 385421 | 2020-07-30 | Haskell | Texas | 48207 | 33 | 0 |
388638 | 388638 | 2020-07-31 | Haskell | Texas | 48207 | 34 | 0 |
391855 | 391855 | 2020-08-01 | Haskell | Texas | 48207 | 35 | 0 |
395071 | 395071 | 2020-08-02 | Haskell | Texas | 48207 | 35 | 0 |
398287 | 398287 | 2020-08-03 | Haskell | Texas | 48207 | 35 | 0 |
401503 | 401503 | 2020-08-04 | Haskell | Texas | 48207 | 39 | 0 |
404721 | 404721 | 2020-08-05 | Haskell | Texas | 48207 | 39 | 0 |
407941 | 407941 | 2020-08-06 | Haskell | Texas | 48207 | 39 | 0 |
411160 | 411160 | 2020-08-07 | Haskell | Texas | 48207 | 42 | 0 |
414380 | 414380 | 2020-08-08 | Haskell | Texas | 48207 | 42 | 0 |
417601 | 417601 | 2020-08-09 | Haskell | Texas | 48207 | 42 | 0 |
420822 | 420822 | 2020-08-10 | Haskell | Texas | 48207 | 42 | 0 |
424043 | 424043 | 2020-08-11 | Haskell | Texas | 48207 | 43 | 0 |
427267 | 427267 | 2020-08-12 | Haskell | Texas | 48207 | 43 | 0 |
430494 | 430494 | 2020-08-13 | Haskell | Texas | 48207 | 44 | 0 |
433719 | 433719 | 2020-08-14 | Haskell | Texas | 48207 | 51 | 0 |
436945 | 436945 | 2020-08-15 | Haskell | Texas | 48207 | 52 | 0 |
440171 | 440171 | 2020-08-16 | Haskell | Texas | 48207 | 52 | 0 |
443397 | 443397 | 2020-08-17 | Haskell | Texas | 48207 | 52 | 0 |
446624 | 446624 | 2020-08-18 | Haskell | Texas | 48207 | 53 | 0 |
449852 | 449852 | 2020-08-19 | Haskell | Texas | 48207 | 53 | 0 |
453080 | 453080 | 2020-08-20 | Haskell | Texas | 48207 | 51 | 0 |
456308 | 456308 | 2020-08-21 | Haskell | Texas | 48207 | 51 | 1 |
459535 | 459535 | 2020-08-22 | Haskell | Texas | 48207 | 50 | 1 |
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);