ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
217 rows where cases = 55 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Roberts 36
- Schleicher 19
- Donley 11
- Culberson 8
- Lynn 7
- Hamilton 6
- Rains 6
- Sherman 6
- Colorado 4
- Dickens 4
- Hartley 4
- Henderson 4
- Martin 4
- San Augustine 4
- Throckmorton 4
- Angelina 3
- Brown 3
- Calhoun 3
- Carson 3
- Hale 3
- Hemphill 3
- Reagan 3
- Stonewall 3
- Winkler 3
- Wise 3
- Armstrong 2
- Burnet 2
- Franklin 2
- McCulloch 2
- Oldham 2
- …
state 1
- Texas · 217 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1127735 | 1127735 | 2021-03-16 | Roberts | Texas | 48393 | 55 | 1 |
1124489 | 1124489 | 2021-03-15 | Roberts | Texas | 48393 | 55 | 1 |
1121243 | 1121243 | 2021-03-14 | Roberts | Texas | 48393 | 55 | 1 |
1117996 | 1117996 | 2021-03-13 | Roberts | Texas | 48393 | 55 | 1 |
1114749 | 1114749 | 2021-03-12 | Roberts | Texas | 48393 | 55 | 1 |
1111503 | 1111503 | 2021-03-11 | Roberts | Texas | 48393 | 55 | 1 |
1108257 | 1108257 | 2021-03-10 | Roberts | Texas | 48393 | 55 | 1 |
1105011 | 1105011 | 2021-03-09 | Roberts | Texas | 48393 | 55 | 1 |
1101765 | 1101765 | 2021-03-08 | Roberts | Texas | 48393 | 55 | 1 |
1098519 | 1098519 | 2021-03-07 | Roberts | Texas | 48393 | 55 | 1 |
1095271 | 1095271 | 2021-03-06 | Roberts | Texas | 48393 | 55 | 1 |
1092025 | 1092025 | 2021-03-05 | Roberts | Texas | 48393 | 55 | 1 |
1088779 | 1088779 | 2021-03-04 | Roberts | Texas | 48393 | 55 | 1 |
1085534 | 1085534 | 2021-03-03 | Roberts | Texas | 48393 | 55 | 1 |
1082288 | 1082288 | 2021-03-02 | Roberts | Texas | 48393 | 55 | 1 |
1079042 | 1079042 | 2021-03-01 | Roberts | Texas | 48393 | 55 | 1 |
1075797 | 1075797 | 2021-02-28 | Roberts | Texas | 48393 | 55 | 1 |
1072551 | 1072551 | 2021-02-27 | Roberts | Texas | 48393 | 55 | 1 |
1069305 | 1069305 | 2021-02-26 | Roberts | Texas | 48393 | 55 | 1 |
1066060 | 1066060 | 2021-02-25 | Roberts | Texas | 48393 | 55 | 1 |
1062815 | 1062815 | 2021-02-24 | Roberts | Texas | 48393 | 55 | 1 |
1059570 | 1059570 | 2021-02-23 | Roberts | Texas | 48393 | 55 | 1 |
1056324 | 1056324 | 2021-02-22 | Roberts | Texas | 48393 | 55 | 1 |
1053078 | 1053078 | 2021-02-21 | Roberts | Texas | 48393 | 55 | 1 |
1049831 | 1049831 | 2021-02-20 | Roberts | Texas | 48393 | 55 | 1 |
1046584 | 1046584 | 2021-02-19 | Roberts | Texas | 48393 | 55 | 1 |
1043339 | 1043339 | 2021-02-18 | Roberts | Texas | 48393 | 55 | 1 |
1040094 | 1040094 | 2021-02-17 | Roberts | Texas | 48393 | 55 | 1 |
1036849 | 1036849 | 2021-02-16 | Roberts | Texas | 48393 | 55 | 1 |
1033604 | 1033604 | 2021-02-15 | Roberts | Texas | 48393 | 55 | 1 |
1030358 | 1030358 | 2021-02-14 | Roberts | Texas | 48393 | 55 | 1 |
1027111 | 1027111 | 2021-02-13 | Roberts | Texas | 48393 | 55 | 1 |
1023866 | 1023866 | 2021-02-12 | Roberts | Texas | 48393 | 55 | 1 |
1020621 | 1020621 | 2021-02-11 | Roberts | Texas | 48393 | 55 | 1 |
1017376 | 1017376 | 2021-02-10 | Roberts | Texas | 48393 | 55 | 1 |
1014131 | 1014131 | 2021-02-09 | Roberts | Texas | 48393 | 55 | 1 |
923282 | 923282 | 2021-01-12 | Throckmorton | Texas | 48447 | 55 | 3 |
920037 | 920037 | 2021-01-11 | Throckmorton | Texas | 48447 | 55 | 3 |
916792 | 916792 | 2021-01-10 | Throckmorton | Texas | 48447 | 55 | 3 |
913547 | 913547 | 2021-01-09 | Throckmorton | Texas | 48447 | 55 | 3 |
903809 | 903809 | 2021-01-06 | Terrell | Texas | 48443 | 55 | 1 |
900564 | 900564 | 2021-01-05 | Terrell | Texas | 48443 | 55 | 1 |
861560 | 861560 | 2020-12-24 | McMullen | Texas | 48311 | 55 | 1 |
829160 | 829160 | 2020-12-14 | Stonewall | Texas | 48433 | 55 | 3 |
825914 | 825914 | 2020-12-13 | Stonewall | Texas | 48433 | 55 | 3 |
822667 | 822667 | 2020-12-12 | Stonewall | Texas | 48433 | 55 | 3 |
819377 | 819377 | 2020-12-11 | Motley | Texas | 48345 | 55 | 2 |
796668 | 796668 | 2020-12-04 | Oldham | Texas | 48359 | 55 | 2 |
793249 | 793249 | 2020-12-03 | Armstrong | Texas | 48011 | 55 | 3 |
793304 | 793304 | 2020-12-03 | Delta | Texas | 48119 | 55 | 2 |
793423 | 793423 | 2020-12-03 | Oldham | Texas | 48359 | 55 | 2 |
790004 | 790004 | 2020-12-02 | Armstrong | Texas | 48011 | 55 | 1 |
790207 | 790207 | 2020-12-02 | Shackelford | Texas | 48417 | 55 | 0 |
699350 | 699350 | 2020-11-04 | Schleicher | Texas | 48413 | 55 | 2 |
696106 | 696106 | 2020-11-03 | Schleicher | Texas | 48413 | 55 | 2 |
692691 | 692691 | 2020-11-02 | Carson | Texas | 48065 | 55 | 1 |
692721 | 692721 | 2020-11-02 | Dickens | Texas | 48125 | 55 | 2 |
692864 | 692864 | 2020-11-02 | Schleicher | Texas | 48413 | 55 | 2 |
689447 | 689447 | 2020-11-01 | Carson | Texas | 48065 | 55 | 1 |
689477 | 689477 | 2020-11-01 | Dickens | Texas | 48125 | 55 | 2 |
689620 | 689620 | 2020-11-01 | Schleicher | Texas | 48413 | 55 | 2 |
686202 | 686202 | 2020-10-31 | Carson | Texas | 48065 | 55 | 1 |
686232 | 686232 | 2020-10-31 | Dickens | Texas | 48125 | 55 | 2 |
686375 | 686375 | 2020-10-31 | Schleicher | Texas | 48413 | 55 | 2 |
682989 | 682989 | 2020-10-30 | Dickens | Texas | 48125 | 55 | 2 |
683132 | 683132 | 2020-10-30 | Schleicher | Texas | 48413 | 55 | 2 |
679889 | 679889 | 2020-10-29 | Schleicher | Texas | 48413 | 55 | 2 |
676646 | 676646 | 2020-10-28 | Schleicher | Texas | 48413 | 55 | 2 |
673403 | 673403 | 2020-10-27 | Schleicher | Texas | 48413 | 55 | 2 |
670161 | 670161 | 2020-10-26 | Schleicher | Texas | 48413 | 55 | 2 |
666918 | 666918 | 2020-10-25 | Schleicher | Texas | 48413 | 55 | 2 |
663673 | 663673 | 2020-10-24 | Schleicher | Texas | 48413 | 55 | 2 |
660429 | 660429 | 2020-10-23 | Schleicher | Texas | 48413 | 55 | 2 |
657185 | 657185 | 2020-10-22 | Schleicher | Texas | 48413 | 55 | 2 |
653940 | 653940 | 2020-10-21 | Schleicher | Texas | 48413 | 55 | 2 |
650695 | 650695 | 2020-10-20 | Schleicher | Texas | 48413 | 55 | 2 |
647451 | 647451 | 2020-10-19 | Schleicher | Texas | 48413 | 55 | 2 |
644205 | 644205 | 2020-10-18 | Schleicher | Texas | 48413 | 55 | 2 |
640957 | 640957 | 2020-10-17 | Schleicher | Texas | 48413 | 55 | 2 |
634500 | 634500 | 2020-10-15 | Wheeler | Texas | 48483 | 55 | 0 |
614841 | 614841 | 2020-10-09 | Coke | Texas | 48081 | 55 | 3 |
605129 | 605129 | 2020-10-06 | Culberson | Texas | 48109 | 55 | 2 |
601887 | 601887 | 2020-10-05 | Culberson | Texas | 48109 | 55 | 2 |
598644 | 598644 | 2020-10-04 | Culberson | Texas | 48109 | 55 | 2 |
595401 | 595401 | 2020-10-03 | Culberson | Texas | 48109 | 55 | 2 |
592159 | 592159 | 2020-10-02 | Culberson | Texas | 48109 | 55 | 2 |
588919 | 588919 | 2020-10-01 | Culberson | Texas | 48109 | 55 | 2 |
585678 | 585678 | 2020-09-30 | Culberson | Texas | 48109 | 55 | 2 |
582438 | 582438 | 2020-09-29 | Culberson | Texas | 48109 | 55 | 2 |
559861 | 559861 | 2020-09-22 | Mills | Texas | 48333 | 55 | 0 |
514449 | 514449 | 2020-09-08 | Donley | Texas | 48129 | 55 | 1 |
514593 | 514593 | 2020-09-08 | Sherman | Texas | 48421 | 55 | 0 |
511216 | 511216 | 2020-09-07 | Donley | Texas | 48129 | 55 | 1 |
511360 | 511360 | 2020-09-07 | Sherman | Texas | 48421 | 55 | 0 |
507983 | 507983 | 2020-09-06 | Donley | Texas | 48129 | 55 | 1 |
508127 | 508127 | 2020-09-06 | Sherman | Texas | 48421 | 55 | 0 |
504751 | 504751 | 2020-09-05 | Donley | Texas | 48129 | 55 | 1 |
504895 | 504895 | 2020-09-05 | Sherman | Texas | 48421 | 55 | 0 |
501517 | 501517 | 2020-09-04 | Donley | Texas | 48129 | 55 | 1 |
501661 | 501661 | 2020-09-04 | Sherman | Texas | 48421 | 55 | 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);