ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where cases = 139 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Briscoe 14
- Armstrong 8
- Marion 7
- Throckmorton 6
- Cottle 5
- San Augustine 5
- Glasscock 4
- Angelina 3
- Hutchinson 3
- Martin 3
- McCulloch 3
- McMullen 3
- Menard 3
- Pecos 3
- Victoria 3
- Wheeler 3
- Yoakum 3
- Young 3
- Concho 2
- Dickens 2
- Freestone 2
- Frio 2
- Garza 2
- Gray 2
- Hale 2
- Kendall 2
- Mills 2
- Smith 2
- Tarrant 2
- Blanco 1
- …
state 1
- Texas · 121 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2186728 | 2186728 | 2022-02-05 | Loving | Texas | 48301 | 139 | 0 |
2124924 | 2124924 | 2022-01-17 | McMullen | Texas | 48311 | 139 | 8 |
2121672 | 2121672 | 2022-01-16 | McMullen | Texas | 48311 | 139 | 8 |
2118420 | 2118420 | 2022-01-15 | McMullen | Texas | 48311 | 139 | 8 |
1946194 | 1946194 | 2021-11-23 | Throckmorton | Texas | 48447 | 139 | 7 |
1942943 | 1942943 | 2021-11-22 | Throckmorton | Texas | 48447 | 139 | 7 |
1939693 | 1939693 | 2021-11-21 | Throckmorton | Texas | 48447 | 139 | 7 |
1936443 | 1936443 | 2021-11-20 | Throckmorton | Texas | 48447 | 139 | 7 |
1933193 | 1933193 | 2021-11-19 | Throckmorton | Texas | 48447 | 139 | 7 |
1929942 | 1929942 | 2021-11-18 | Throckmorton | Texas | 48447 | 139 | 7 |
1738099 | 1738099 | 2021-09-20 | Glasscock | Texas | 48173 | 139 | 3 |
1734849 | 1734849 | 2021-09-19 | Glasscock | Texas | 48173 | 139 | 3 |
1731599 | 1731599 | 2021-09-18 | Glasscock | Texas | 48173 | 139 | 3 |
1686121 | 1686121 | 2021-09-04 | Glasscock | Texas | 48173 | 139 | 3 |
1604944 | 1604944 | 2021-08-10 | Irion | Texas | 48235 | 139 | 1 |
1195754 | 1195754 | 2021-04-06 | Briscoe | Texas | 48045 | 139 | 5 |
1192506 | 1192506 | 2021-04-05 | Briscoe | Texas | 48045 | 139 | 5 |
1189257 | 1189257 | 2021-04-04 | Briscoe | Texas | 48045 | 139 | 5 |
1186010 | 1186010 | 2021-04-03 | Briscoe | Texas | 48045 | 139 | 5 |
1182763 | 1182763 | 2021-04-02 | Briscoe | Texas | 48045 | 139 | 5 |
1179516 | 1179516 | 2021-04-01 | Briscoe | Texas | 48045 | 139 | 5 |
1176269 | 1176269 | 2021-03-31 | Briscoe | Texas | 48045 | 139 | 5 |
1173022 | 1173022 | 2021-03-30 | Briscoe | Texas | 48045 | 139 | 5 |
1169775 | 1169775 | 2021-03-29 | Briscoe | Texas | 48045 | 139 | 5 |
1166527 | 1166527 | 2021-03-28 | Briscoe | Texas | 48045 | 139 | 5 |
1163279 | 1163279 | 2021-03-27 | Briscoe | Texas | 48045 | 139 | 5 |
1160030 | 1160030 | 2021-03-26 | Briscoe | Texas | 48045 | 139 | 5 |
1156783 | 1156783 | 2021-03-25 | Briscoe | Texas | 48045 | 139 | 5 |
1153536 | 1153536 | 2021-03-24 | Briscoe | Texas | 48045 | 139 | 5 |
994465 | 994465 | 2021-02-03 | Armstrong | Texas | 48011 | 139 | 6 |
994522 | 994522 | 2021-02-03 | Dickens | Texas | 48125 | 139 | 8 |
991219 | 991219 | 2021-02-02 | Armstrong | Texas | 48011 | 139 | 6 |
991276 | 991276 | 2021-02-02 | Dickens | Texas | 48125 | 139 | 8 |
987973 | 987973 | 2021-02-01 | Armstrong | Texas | 48011 | 139 | 6 |
984726 | 984726 | 2021-01-31 | Armstrong | Texas | 48011 | 139 | 6 |
981479 | 981479 | 2021-01-30 | Armstrong | Texas | 48011 | 139 | 6 |
978233 | 978233 | 2021-01-29 | Armstrong | Texas | 48011 | 139 | 6 |
974988 | 974988 | 2021-01-28 | Armstrong | Texas | 48011 | 139 | 6 |
971743 | 971743 | 2021-01-27 | Armstrong | Texas | 48011 | 139 | 6 |
867939 | 867939 | 2020-12-26 | Cottle | Texas | 48101 | 139 | 5 |
867949 | 867949 | 2020-12-26 | Delta | Texas | 48119 | 139 | 3 |
864694 | 864694 | 2020-12-25 | Cottle | Texas | 48101 | 139 | 5 |
861449 | 861449 | 2020-12-24 | Cottle | Texas | 48101 | 139 | 5 |
858204 | 858204 | 2020-12-23 | Cottle | Texas | 48101 | 139 | 5 |
854959 | 854959 | 2020-12-22 | Cottle | Texas | 48101 | 139 | 5 |
825861 | 825861 | 2020-12-13 | Menard | Texas | 48327 | 139 | 3 |
822614 | 822614 | 2020-12-12 | Menard | Texas | 48327 | 139 | 3 |
819368 | 819368 | 2020-12-11 | Menard | Texas | 48327 | 139 | 3 |
815991 | 815991 | 2020-12-10 | Carson | Texas | 48065 | 139 | 3 |
816092 | 816092 | 2020-12-10 | Kimble | Texas | 48267 | 139 | 5 |
809564 | 809564 | 2020-12-08 | Hall | Texas | 48191 | 139 | 3 |
773940 | 773940 | 2020-11-27 | Mills | Texas | 48333 | 139 | 4 |
770695 | 770695 | 2020-11-26 | Mills | Texas | 48333 | 139 | 4 |
738224 | 738224 | 2020-11-16 | Martin | Texas | 48317 | 139 | 7 |
734980 | 734980 | 2020-11-15 | Martin | Texas | 48317 | 139 | 7 |
731734 | 731734 | 2020-11-14 | Martin | Texas | 48317 | 139 | 7 |
728389 | 728389 | 2020-11-13 | Culberson | Texas | 48109 | 139 | 3 |
715603 | 715603 | 2020-11-09 | Wheeler | Texas | 48483 | 139 | 0 |
712359 | 712359 | 2020-11-08 | Wheeler | Texas | 48483 | 139 | 0 |
709115 | 709115 | 2020-11-07 | Wheeler | Texas | 48483 | 139 | 0 |
705715 | 705715 | 2020-11-06 | Garza | Texas | 48169 | 139 | 10 |
702472 | 702472 | 2020-11-05 | Garza | Texas | 48169 | 139 | 10 |
637552 | 637552 | 2020-10-16 | Concho | Texas | 48095 | 139 | 2 |
634307 | 634307 | 2020-10-15 | Concho | Texas | 48095 | 139 | 2 |
556618 | 556618 | 2020-09-21 | McCulloch | Texas | 48307 | 139 | 3 |
553381 | 553381 | 2020-09-20 | McCulloch | Texas | 48307 | 139 | 3 |
550142 | 550142 | 2020-09-19 | McCulloch | Texas | 48307 | 139 | 3 |
546762 | 546762 | 2020-09-18 | Blanco | Texas | 48031 | 139 | 5 |
475736 | 475736 | 2020-08-27 | Marion | Texas | 48315 | 139 | 10 |
472503 | 472503 | 2020-08-26 | Marion | Texas | 48315 | 139 | 10 |
469271 | 469271 | 2020-08-25 | Marion | Texas | 48315 | 139 | 10 |
466006 | 466006 | 2020-08-24 | Hutchinson | Texas | 48233 | 139 | 3 |
466042 | 466042 | 2020-08-24 | Marion | Texas | 48315 | 139 | 10 |
466138 | 466138 | 2020-08-24 | Yoakum | Texas | 48501 | 139 | 4 |
462777 | 462777 | 2020-08-23 | Hutchinson | Texas | 48233 | 139 | 3 |
462813 | 462813 | 2020-08-23 | Marion | Texas | 48315 | 139 | 10 |
462909 | 462909 | 2020-08-23 | Yoakum | Texas | 48501 | 139 | 4 |
459548 | 459548 | 2020-08-22 | Hutchinson | Texas | 48233 | 139 | 3 |
459584 | 459584 | 2020-08-22 | Marion | Texas | 48315 | 139 | 10 |
459680 | 459680 | 2020-08-22 | Yoakum | Texas | 48501 | 139 | 4 |
456357 | 456357 | 2020-08-21 | Marion | Texas | 48315 | 139 | 10 |
427236 | 427236 | 2020-08-12 | Falls | Texas | 48145 | 139 | 3 |
401480 | 401480 | 2020-08-04 | Freestone | Texas | 48161 | 139 | 0 |
398264 | 398264 | 2020-08-03 | Freestone | Texas | 48161 | 139 | 0 |
398432 | 398432 | 2020-08-03 | Young | Texas | 48503 | 139 | 4 |
395216 | 395216 | 2020-08-02 | Young | Texas | 48503 | 139 | 4 |
392000 | 392000 | 2020-08-01 | Young | Texas | 48503 | 139 | 4 |
382229 | 382229 | 2020-07-29 | Kendall | Texas | 48259 | 139 | 1 |
379012 | 379012 | 2020-07-28 | Kendall | Texas | 48259 | 139 | 1 |
362972 | 362972 | 2020-07-23 | Limestone | Texas | 48293 | 139 | 1 |
353412 | 353412 | 2020-07-20 | San Augustine | Texas | 48405 | 139 | 12 |
350099 | 350099 | 2020-07-19 | Gray | Texas | 48179 | 139 | 4 |
350210 | 350210 | 2020-07-19 | San Augustine | Texas | 48405 | 139 | 12 |
346899 | 346899 | 2020-07-18 | Gray | Texas | 48179 | 139 | 4 |
347010 | 347010 | 2020-07-18 | San Augustine | Texas | 48405 | 139 | 12 |
343810 | 343810 | 2020-07-17 | San Augustine | Texas | 48405 | 139 | 12 |
340611 | 340611 | 2020-07-16 | San Augustine | Texas | 48405 | 139 | 12 |
331010 | 331010 | 2020-07-13 | Pecos | Texas | 48371 | 139 | 1 |
327824 | 327824 | 2020-07-12 | Pecos | Texas | 48371 | 139 | 1 |
324639 | 324639 | 2020-07-11 | Pecos | Texas | 48371 | 139 | 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);