ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where deaths = 2, fips = 48101 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
562986 | 562986 | 2020-09-23 | Cottle | Texas | 48101 | 25 | 2 |
559747 | 559747 | 2020-09-22 | Cottle | Texas | 48101 | 25 | 2 |
556511 | 556511 | 2020-09-21 | Cottle | Texas | 48101 | 25 | 2 |
553274 | 553274 | 2020-09-20 | Cottle | Texas | 48101 | 25 | 2 |
550035 | 550035 | 2020-09-19 | Cottle | Texas | 48101 | 25 | 2 |
546796 | 546796 | 2020-09-18 | Cottle | Texas | 48101 | 25 | 2 |
543559 | 543559 | 2020-09-17 | Cottle | Texas | 48101 | 25 | 2 |
540323 | 540323 | 2020-09-16 | Cottle | Texas | 48101 | 25 | 2 |
537086 | 537086 | 2020-09-15 | Cottle | Texas | 48101 | 25 | 2 |
533850 | 533850 | 2020-09-14 | Cottle | Texas | 48101 | 20 | 2 |
530615 | 530615 | 2020-09-13 | Cottle | Texas | 48101 | 20 | 2 |
527378 | 527378 | 2020-09-12 | Cottle | Texas | 48101 | 20 | 2 |
524142 | 524142 | 2020-09-11 | Cottle | Texas | 48101 | 20 | 2 |
520906 | 520906 | 2020-09-10 | Cottle | Texas | 48101 | 18 | 2 |
517670 | 517670 | 2020-09-09 | Cottle | Texas | 48101 | 18 | 2 |
514435 | 514435 | 2020-09-08 | Cottle | Texas | 48101 | 18 | 2 |
511202 | 511202 | 2020-09-07 | Cottle | Texas | 48101 | 18 | 2 |
507969 | 507969 | 2020-09-06 | Cottle | Texas | 48101 | 18 | 2 |
504737 | 504737 | 2020-09-05 | Cottle | Texas | 48101 | 18 | 2 |
501503 | 501503 | 2020-09-04 | Cottle | Texas | 48101 | 18 | 2 |
498269 | 498269 | 2020-09-03 | Cottle | Texas | 48101 | 18 | 2 |
495036 | 495036 | 2020-09-02 | Cottle | Texas | 48101 | 18 | 2 |
491802 | 491802 | 2020-09-01 | Cottle | Texas | 48101 | 18 | 2 |
488569 | 488569 | 2020-08-31 | Cottle | Texas | 48101 | 18 | 2 |
485336 | 485336 | 2020-08-30 | Cottle | Texas | 48101 | 18 | 2 |
482101 | 482101 | 2020-08-29 | Cottle | Texas | 48101 | 18 | 2 |
478867 | 478867 | 2020-08-28 | Cottle | Texas | 48101 | 18 | 2 |
475634 | 475634 | 2020-08-27 | Cottle | Texas | 48101 | 18 | 2 |
472401 | 472401 | 2020-08-26 | Cottle | Texas | 48101 | 18 | 2 |
469169 | 469169 | 2020-08-25 | Cottle | Texas | 48101 | 18 | 2 |
465940 | 465940 | 2020-08-24 | Cottle | Texas | 48101 | 18 | 2 |
462711 | 462711 | 2020-08-23 | Cottle | Texas | 48101 | 18 | 2 |
459482 | 459482 | 2020-08-22 | Cottle | Texas | 48101 | 18 | 2 |
456255 | 456255 | 2020-08-21 | Cottle | Texas | 48101 | 18 | 2 |
453027 | 453027 | 2020-08-20 | Cottle | Texas | 48101 | 18 | 2 |
449799 | 449799 | 2020-08-19 | Cottle | Texas | 48101 | 18 | 2 |
446571 | 446571 | 2020-08-18 | Cottle | Texas | 48101 | 18 | 2 |
443344 | 443344 | 2020-08-17 | Cottle | Texas | 48101 | 18 | 2 |
440118 | 440118 | 2020-08-16 | Cottle | Texas | 48101 | 18 | 2 |
436892 | 436892 | 2020-08-15 | Cottle | Texas | 48101 | 18 | 2 |
433666 | 433666 | 2020-08-14 | Cottle | Texas | 48101 | 18 | 2 |
430441 | 430441 | 2020-08-13 | Cottle | Texas | 48101 | 18 | 2 |
427214 | 427214 | 2020-08-12 | Cottle | Texas | 48101 | 18 | 2 |
423990 | 423990 | 2020-08-11 | Cottle | Texas | 48101 | 18 | 2 |
420769 | 420769 | 2020-08-10 | Cottle | Texas | 48101 | 18 | 2 |
417548 | 417548 | 2020-08-09 | Cottle | Texas | 48101 | 18 | 2 |
414327 | 414327 | 2020-08-08 | Cottle | Texas | 48101 | 18 | 2 |
411107 | 411107 | 2020-08-07 | Cottle | Texas | 48101 | 16 | 2 |
407888 | 407888 | 2020-08-06 | Cottle | Texas | 48101 | 14 | 2 |
404668 | 404668 | 2020-08-05 | Cottle | Texas | 48101 | 14 | 2 |
401450 | 401450 | 2020-08-04 | Cottle | Texas | 48101 | 14 | 2 |
398234 | 398234 | 2020-08-03 | Cottle | Texas | 48101 | 14 | 2 |
395018 | 395018 | 2020-08-02 | Cottle | Texas | 48101 | 14 | 2 |
391802 | 391802 | 2020-08-01 | Cottle | Texas | 48101 | 14 | 2 |
388585 | 388585 | 2020-07-31 | Cottle | Texas | 48101 | 14 | 2 |
385368 | 385368 | 2020-07-30 | Cottle | Texas | 48101 | 11 | 2 |
382150 | 382150 | 2020-07-29 | Cottle | Texas | 48101 | 9 | 2 |
378933 | 378933 | 2020-07-28 | Cottle | Texas | 48101 | 9 | 2 |
375717 | 375717 | 2020-07-27 | Cottle | Texas | 48101 | 7 | 2 |
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);