ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,100 rows where cases = 4 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Jack 69
- Cottle 68
- Young 51
- Oldham 45
- La Salle 34
- Jim Hogg 33
- Karnes 32
- Throckmorton 31
- Hopkins 27
- Newton 24
- Sterling 24
- Dickens 23
- Hardeman 21
- Terrell 20
- Haskell 18
- Stephens 18
- Stonewall 18
- Collingsworth 16
- Gillespie 15
- Blanco 14
- Floyd 14
- Jackson 14
- Lavaca 14
- Motley 13
- Coke 11
- Garza 11
- Howard 11
- Crosby 10
- Rains 10
- San Saba 10
- …
state 1
- Texas · 1,100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
751071 | 751071 | 2020-11-20 | Borden | Texas | 48033 | 4 | 0 |
747825 | 747825 | 2020-11-19 | Borden | Texas | 48033 | 4 | 0 |
744579 | 744579 | 2020-11-18 | Borden | Texas | 48033 | 4 | 0 |
741332 | 741332 | 2020-11-17 | Borden | Texas | 48033 | 4 | 0 |
738086 | 738086 | 2020-11-16 | Borden | Texas | 48033 | 4 | 0 |
734842 | 734842 | 2020-11-15 | Borden | Texas | 48033 | 4 | 0 |
731596 | 731596 | 2020-11-14 | Borden | Texas | 48033 | 4 | 0 |
728351 | 728351 | 2020-11-13 | Borden | Texas | 48033 | 4 | 0 |
699365 | 699365 | 2020-11-04 | Terrell | Texas | 48443 | 4 | 0 |
696121 | 696121 | 2020-11-03 | Terrell | Texas | 48443 | 4 | 0 |
692879 | 692879 | 2020-11-02 | Terrell | Texas | 48443 | 4 | 0 |
689635 | 689635 | 2020-11-01 | Terrell | Texas | 48443 | 4 | 0 |
686390 | 686390 | 2020-10-31 | Terrell | Texas | 48443 | 4 | 0 |
683147 | 683147 | 2020-10-30 | Terrell | Texas | 48443 | 4 | 0 |
679904 | 679904 | 2020-10-29 | Terrell | Texas | 48443 | 4 | 0 |
676661 | 676661 | 2020-10-28 | Terrell | Texas | 48443 | 4 | 0 |
673418 | 673418 | 2020-10-27 | Terrell | Texas | 48443 | 4 | 0 |
670176 | 670176 | 2020-10-26 | Terrell | Texas | 48443 | 4 | 0 |
666933 | 666933 | 2020-10-25 | Terrell | Texas | 48443 | 4 | 0 |
663688 | 663688 | 2020-10-24 | Terrell | Texas | 48443 | 4 | 0 |
660444 | 660444 | 2020-10-23 | Terrell | Texas | 48443 | 4 | 0 |
657200 | 657200 | 2020-10-22 | Terrell | Texas | 48443 | 4 | 0 |
653955 | 653955 | 2020-10-21 | Terrell | Texas | 48443 | 4 | 0 |
650710 | 650710 | 2020-10-20 | Terrell | Texas | 48443 | 4 | 0 |
647466 | 647466 | 2020-10-19 | Terrell | Texas | 48443 | 4 | 0 |
644220 | 644220 | 2020-10-18 | Terrell | Texas | 48443 | 4 | 0 |
640972 | 640972 | 2020-10-17 | Terrell | Texas | 48443 | 4 | 0 |
637725 | 637725 | 2020-10-16 | Terrell | Texas | 48443 | 4 | 0 |
569631 | 569631 | 2020-09-25 | Sterling | Texas | 48431 | 4 | 0 |
566390 | 566390 | 2020-09-24 | Sterling | Texas | 48431 | 4 | 0 |
563149 | 563149 | 2020-09-23 | Sterling | Texas | 48431 | 4 | 0 |
559910 | 559910 | 2020-09-22 | Sterling | Texas | 48431 | 4 | 0 |
556674 | 556674 | 2020-09-21 | Sterling | Texas | 48431 | 4 | 0 |
553437 | 553437 | 2020-09-20 | Sterling | Texas | 48431 | 4 | 0 |
550198 | 550198 | 2020-09-19 | Sterling | Texas | 48431 | 4 | 0 |
546959 | 546959 | 2020-09-18 | Sterling | Texas | 48431 | 4 | 0 |
543722 | 543722 | 2020-09-17 | Sterling | Texas | 48431 | 4 | 0 |
540486 | 540486 | 2020-09-16 | Sterling | Texas | 48431 | 4 | 0 |
537249 | 537249 | 2020-09-15 | Sterling | Texas | 48431 | 4 | 0 |
534013 | 534013 | 2020-09-14 | Sterling | Texas | 48431 | 4 | 0 |
530778 | 530778 | 2020-09-13 | Sterling | Texas | 48431 | 4 | 0 |
527541 | 527541 | 2020-09-12 | Sterling | Texas | 48431 | 4 | 0 |
524305 | 524305 | 2020-09-11 | Sterling | Texas | 48431 | 4 | 0 |
521069 | 521069 | 2020-09-10 | Sterling | Texas | 48431 | 4 | 0 |
517833 | 517833 | 2020-09-09 | Sterling | Texas | 48431 | 4 | 0 |
514598 | 514598 | 2020-09-08 | Sterling | Texas | 48431 | 4 | 0 |
511365 | 511365 | 2020-09-07 | Sterling | Texas | 48431 | 4 | 0 |
508132 | 508132 | 2020-09-06 | Sterling | Texas | 48431 | 4 | 0 |
504900 | 504900 | 2020-09-05 | Sterling | Texas | 48431 | 4 | 0 |
501666 | 501666 | 2020-09-04 | Sterling | Texas | 48431 | 4 | 0 |
498432 | 498432 | 2020-09-03 | Sterling | Texas | 48431 | 4 | 0 |
495199 | 495199 | 2020-09-02 | Sterling | Texas | 48431 | 4 | 0 |
488740 | 488740 | 2020-08-31 | Throckmorton | Texas | 48447 | 4 | 2 |
485507 | 485507 | 2020-08-30 | Throckmorton | Texas | 48447 | 4 | 2 |
482272 | 482272 | 2020-08-29 | Throckmorton | Texas | 48447 | 4 | 2 |
479038 | 479038 | 2020-08-28 | Throckmorton | Texas | 48447 | 4 | 2 |
475805 | 475805 | 2020-08-27 | Throckmorton | Texas | 48447 | 4 | 2 |
472572 | 472572 | 2020-08-26 | Throckmorton | Texas | 48447 | 4 | 2 |
469340 | 469340 | 2020-08-25 | Throckmorton | Texas | 48447 | 4 | 2 |
466111 | 466111 | 2020-08-24 | Throckmorton | Texas | 48447 | 4 | 2 |
462882 | 462882 | 2020-08-23 | Throckmorton | Texas | 48447 | 4 | 2 |
459653 | 459653 | 2020-08-22 | Throckmorton | Texas | 48447 | 4 | 2 |
456426 | 456426 | 2020-08-21 | Throckmorton | Texas | 48447 | 4 | 2 |
453108 | 453108 | 2020-08-20 | Kent | Texas | 48263 | 4 | 0 |
453198 | 453198 | 2020-08-20 | Throckmorton | Texas | 48447 | 4 | 2 |
449880 | 449880 | 2020-08-19 | Kent | Texas | 48263 | 4 | 0 |
449970 | 449970 | 2020-08-19 | Throckmorton | Texas | 48447 | 4 | 2 |
446652 | 446652 | 2020-08-18 | Kent | Texas | 48263 | 4 | 0 |
446742 | 446742 | 2020-08-18 | Throckmorton | Texas | 48447 | 4 | 2 |
443515 | 443515 | 2020-08-17 | Throckmorton | Texas | 48447 | 4 | 2 |
440289 | 440289 | 2020-08-16 | Throckmorton | Texas | 48447 | 4 | 2 |
437063 | 437063 | 2020-08-15 | Throckmorton | Texas | 48447 | 4 | 2 |
433837 | 433837 | 2020-08-14 | Throckmorton | Texas | 48447 | 4 | 2 |
430612 | 430612 | 2020-08-13 | Throckmorton | Texas | 48447 | 4 | 2 |
427384 | 427384 | 2020-08-12 | Throckmorton | Texas | 48447 | 4 | 2 |
424160 | 424160 | 2020-08-11 | Throckmorton | Texas | 48447 | 4 | 2 |
420939 | 420939 | 2020-08-10 | Throckmorton | Texas | 48447 | 4 | 2 |
417718 | 417718 | 2020-08-09 | Throckmorton | Texas | 48447 | 4 | 2 |
414497 | 414497 | 2020-08-08 | Throckmorton | Texas | 48447 | 4 | 2 |
411119 | 411119 | 2020-08-07 | Dickens | Texas | 48125 | 4 | 1 |
411277 | 411277 | 2020-08-07 | Throckmorton | Texas | 48447 | 4 | 2 |
407900 | 407900 | 2020-08-06 | Dickens | Texas | 48125 | 4 | 1 |
408008 | 408008 | 2020-08-06 | Motley | Texas | 48345 | 4 | 0 |
408058 | 408058 | 2020-08-06 | Throckmorton | Texas | 48447 | 4 | 2 |
404680 | 404680 | 2020-08-05 | Dickens | Texas | 48125 | 4 | 1 |
404788 | 404788 | 2020-08-05 | Motley | Texas | 48345 | 4 | 0 |
404838 | 404838 | 2020-08-05 | Throckmorton | Texas | 48447 | 4 | 0 |
401462 | 401462 | 2020-08-04 | Dickens | Texas | 48125 | 4 | 1 |
401570 | 401570 | 2020-08-04 | Motley | Texas | 48345 | 4 | 0 |
401613 | 401613 | 2020-08-04 | Stonewall | Texas | 48433 | 4 | 0 |
401620 | 401620 | 2020-08-04 | Throckmorton | Texas | 48447 | 4 | 0 |
398246 | 398246 | 2020-08-03 | Dickens | Texas | 48125 | 4 | 1 |
398354 | 398354 | 2020-08-03 | Motley | Texas | 48345 | 4 | 0 |
398397 | 398397 | 2020-08-03 | Stonewall | Texas | 48433 | 4 | 0 |
398404 | 398404 | 2020-08-03 | Throckmorton | Texas | 48447 | 4 | 0 |
395030 | 395030 | 2020-08-02 | Dickens | Texas | 48125 | 4 | 1 |
395138 | 395138 | 2020-08-02 | Motley | Texas | 48345 | 4 | 0 |
395181 | 395181 | 2020-08-02 | Stonewall | Texas | 48433 | 4 | 0 |
395188 | 395188 | 2020-08-02 | Throckmorton | Texas | 48447 | 4 | 0 |
391814 | 391814 | 2020-08-01 | Dickens | Texas | 48125 | 4 | 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);