ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
690 rows where county = "Terrell" and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
267820 | 267820 | 2020-06-23 | Terrell | Texas | 48443 | 1 | 0 |
270954 | 270954 | 2020-06-24 | Terrell | Texas | 48443 | 1 | 0 |
274094 | 274094 | 2020-06-25 | Terrell | Texas | 48443 | 1 | 0 |
277242 | 277242 | 2020-06-26 | Terrell | Texas | 48443 | 1 | 0 |
280390 | 280390 | 2020-06-27 | Terrell | Texas | 48443 | 1 | 0 |
283536 | 283536 | 2020-06-28 | Terrell | Texas | 48443 | 1 | 0 |
286682 | 286682 | 2020-06-29 | Terrell | Texas | 48443 | 1 | 0 |
289832 | 289832 | 2020-06-30 | Terrell | Texas | 48443 | 2 | 0 |
292985 | 292985 | 2020-07-01 | Terrell | Texas | 48443 | 3 | 0 |
296140 | 296140 | 2020-07-02 | Terrell | Texas | 48443 | 2 | 0 |
299301 | 299301 | 2020-07-03 | Terrell | Texas | 48443 | 2 | 0 |
302465 | 302465 | 2020-07-04 | Terrell | Texas | 48443 | 2 | 0 |
305629 | 305629 | 2020-07-05 | Terrell | Texas | 48443 | 2 | 0 |
308797 | 308797 | 2020-07-06 | Terrell | Texas | 48443 | 2 | 0 |
311966 | 311966 | 2020-07-07 | Terrell | Texas | 48443 | 2 | 0 |
315140 | 315140 | 2020-07-08 | Terrell | Texas | 48443 | 2 | 0 |
318313 | 318313 | 2020-07-09 | Terrell | Texas | 48443 | 2 | 0 |
321492 | 321492 | 2020-07-10 | Terrell | Texas | 48443 | 2 | 0 |
324673 | 324673 | 2020-07-11 | Terrell | Texas | 48443 | 2 | 0 |
327858 | 327858 | 2020-07-12 | Terrell | Texas | 48443 | 2 | 0 |
331044 | 331044 | 2020-07-13 | Terrell | Texas | 48443 | 2 | 0 |
334237 | 334237 | 2020-07-14 | Terrell | Texas | 48443 | 2 | 0 |
337432 | 337432 | 2020-07-15 | Terrell | Texas | 48443 | 2 | 0 |
340628 | 340628 | 2020-07-16 | Terrell | Texas | 48443 | 2 | 0 |
343827 | 343827 | 2020-07-17 | Terrell | Texas | 48443 | 2 | 0 |
347028 | 347028 | 2020-07-18 | Terrell | Texas | 48443 | 2 | 0 |
350228 | 350228 | 2020-07-19 | Terrell | Texas | 48443 | 2 | 0 |
353430 | 353430 | 2020-07-20 | Terrell | Texas | 48443 | 2 | 0 |
356633 | 356633 | 2020-07-21 | Terrell | Texas | 48443 | 2 | 0 |
359838 | 359838 | 2020-07-22 | Terrell | Texas | 48443 | 2 | 0 |
363045 | 363045 | 2020-07-23 | Terrell | Texas | 48443 | 2 | 0 |
366251 | 366251 | 2020-07-24 | Terrell | Texas | 48443 | 2 | 0 |
369460 | 369460 | 2020-07-25 | Terrell | Texas | 48443 | 2 | 0 |
372672 | 372672 | 2020-07-26 | Terrell | Texas | 48443 | 2 | 0 |
375885 | 375885 | 2020-07-27 | Terrell | Texas | 48443 | 2 | 0 |
379101 | 379101 | 2020-07-28 | Terrell | Texas | 48443 | 2 | 0 |
382318 | 382318 | 2020-07-29 | Terrell | Texas | 48443 | 2 | 0 |
385536 | 385536 | 2020-07-30 | Terrell | Texas | 48443 | 2 | 0 |
388753 | 388753 | 2020-07-31 | Terrell | Texas | 48443 | 2 | 0 |
391970 | 391970 | 2020-08-01 | Terrell | Texas | 48443 | 2 | 0 |
395186 | 395186 | 2020-08-02 | Terrell | Texas | 48443 | 2 | 0 |
398402 | 398402 | 2020-08-03 | Terrell | Texas | 48443 | 2 | 0 |
401618 | 401618 | 2020-08-04 | Terrell | Texas | 48443 | 2 | 0 |
404836 | 404836 | 2020-08-05 | Terrell | Texas | 48443 | 2 | 0 |
408056 | 408056 | 2020-08-06 | Terrell | Texas | 48443 | 2 | 0 |
411275 | 411275 | 2020-08-07 | Terrell | Texas | 48443 | 2 | 0 |
414495 | 414495 | 2020-08-08 | Terrell | Texas | 48443 | 2 | 0 |
417716 | 417716 | 2020-08-09 | Terrell | Texas | 48443 | 2 | 0 |
420937 | 420937 | 2020-08-10 | Terrell | Texas | 48443 | 2 | 0 |
424158 | 424158 | 2020-08-11 | Terrell | Texas | 48443 | 2 | 0 |
427382 | 427382 | 2020-08-12 | Terrell | Texas | 48443 | 2 | 0 |
430610 | 430610 | 2020-08-13 | Terrell | Texas | 48443 | 2 | 0 |
433835 | 433835 | 2020-08-14 | Terrell | Texas | 48443 | 2 | 0 |
437061 | 437061 | 2020-08-15 | Terrell | Texas | 48443 | 2 | 0 |
440287 | 440287 | 2020-08-16 | Terrell | Texas | 48443 | 2 | 0 |
443513 | 443513 | 2020-08-17 | Terrell | Texas | 48443 | 2 | 0 |
446740 | 446740 | 2020-08-18 | Terrell | Texas | 48443 | 3 | 0 |
449968 | 449968 | 2020-08-19 | Terrell | Texas | 48443 | 3 | 0 |
453196 | 453196 | 2020-08-20 | Terrell | Texas | 48443 | 3 | 0 |
456424 | 456424 | 2020-08-21 | Terrell | Texas | 48443 | 3 | 0 |
459651 | 459651 | 2020-08-22 | Terrell | Texas | 48443 | 3 | 0 |
462880 | 462880 | 2020-08-23 | Terrell | Texas | 48443 | 3 | 0 |
466109 | 466109 | 2020-08-24 | Terrell | Texas | 48443 | 3 | 0 |
469338 | 469338 | 2020-08-25 | Terrell | Texas | 48443 | 3 | 0 |
472570 | 472570 | 2020-08-26 | Terrell | Texas | 48443 | 3 | 0 |
475803 | 475803 | 2020-08-27 | Terrell | Texas | 48443 | 3 | 0 |
479036 | 479036 | 2020-08-28 | Terrell | Texas | 48443 | 3 | 0 |
482270 | 482270 | 2020-08-29 | Terrell | Texas | 48443 | 3 | 0 |
485505 | 485505 | 2020-08-30 | Terrell | Texas | 48443 | 3 | 0 |
488738 | 488738 | 2020-08-31 | Terrell | Texas | 48443 | 3 | 0 |
491971 | 491971 | 2020-09-01 | Terrell | Texas | 48443 | 3 | 0 |
495205 | 495205 | 2020-09-02 | Terrell | Texas | 48443 | 3 | 0 |
498438 | 498438 | 2020-09-03 | Terrell | Texas | 48443 | 3 | 0 |
501672 | 501672 | 2020-09-04 | Terrell | Texas | 48443 | 3 | 0 |
504906 | 504906 | 2020-09-05 | Terrell | Texas | 48443 | 3 | 0 |
508138 | 508138 | 2020-09-06 | Terrell | Texas | 48443 | 3 | 0 |
511371 | 511371 | 2020-09-07 | Terrell | Texas | 48443 | 3 | 0 |
514604 | 514604 | 2020-09-08 | Terrell | Texas | 48443 | 3 | 0 |
517839 | 517839 | 2020-09-09 | Terrell | Texas | 48443 | 3 | 0 |
521075 | 521075 | 2020-09-10 | Terrell | Texas | 48443 | 3 | 0 |
524311 | 524311 | 2020-09-11 | Terrell | Texas | 48443 | 3 | 0 |
527547 | 527547 | 2020-09-12 | Terrell | Texas | 48443 | 3 | 0 |
530784 | 530784 | 2020-09-13 | Terrell | Texas | 48443 | 3 | 0 |
534019 | 534019 | 2020-09-14 | Terrell | Texas | 48443 | 3 | 0 |
537255 | 537255 | 2020-09-15 | Terrell | Texas | 48443 | 3 | 0 |
540492 | 540492 | 2020-09-16 | Terrell | Texas | 48443 | 3 | 0 |
543728 | 543728 | 2020-09-17 | Terrell | Texas | 48443 | 3 | 0 |
546965 | 546965 | 2020-09-18 | Terrell | Texas | 48443 | 3 | 0 |
550204 | 550204 | 2020-09-19 | Terrell | Texas | 48443 | 3 | 0 |
553443 | 553443 | 2020-09-20 | Terrell | Texas | 48443 | 3 | 0 |
556680 | 556680 | 2020-09-21 | Terrell | Texas | 48443 | 3 | 0 |
559916 | 559916 | 2020-09-22 | Terrell | Texas | 48443 | 3 | 0 |
563155 | 563155 | 2020-09-23 | Terrell | Texas | 48443 | 3 | 0 |
566396 | 566396 | 2020-09-24 | Terrell | Texas | 48443 | 3 | 0 |
569637 | 569637 | 2020-09-25 | Terrell | Texas | 48443 | 3 | 0 |
572879 | 572879 | 2020-09-26 | Terrell | Texas | 48443 | 3 | 0 |
576123 | 576123 | 2020-09-27 | Terrell | Texas | 48443 | 3 | 0 |
579364 | 579364 | 2020-09-28 | Terrell | Texas | 48443 | 3 | 0 |
582603 | 582603 | 2020-09-29 | Terrell | Texas | 48443 | 3 | 0 |
585843 | 585843 | 2020-09-30 | Terrell | Texas | 48443 | 3 | 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);