ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
192 rows where cases = 38 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Mason 13
- Wilson 12
- Kenedy 11
- Schleicher 9
- Brown 8
- Collingsworth 8
- Callahan 7
- Waller 7
- Fayette 6
- San Saba 6
- Navarro 5
- Dawson 4
- Donley 4
- Hudspeth 4
- Wharton 4
- Culberson 3
- Dimmit 3
- Liberty 3
- Palo Pinto 3
- San Augustine 3
- Swisher 3
- Yoakum 3
- Cass 2
- Ellis 2
- Hunt 2
- Lynn 2
- Morris 2
- San Patricio 2
- Sterling 2
- Walker 2
- …
state 1
- Texas · 192 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1306268 | 1306268 | 2021-05-10 | Kenedy | Texas | 48261 | 38 | 2 |
1303022 | 1303022 | 2021-05-09 | Kenedy | Texas | 48261 | 38 | 2 |
1299775 | 1299775 | 2021-05-08 | Kenedy | Texas | 48261 | 38 | 2 |
1296528 | 1296528 | 2021-05-07 | Kenedy | Texas | 48261 | 38 | 2 |
1293282 | 1293282 | 2021-05-06 | Kenedy | Texas | 48261 | 38 | 2 |
1290036 | 1290036 | 2021-05-05 | Kenedy | Texas | 48261 | 38 | 2 |
1286790 | 1286790 | 2021-05-04 | Kenedy | Texas | 48261 | 38 | 2 |
1283544 | 1283544 | 2021-05-03 | Kenedy | Texas | 48261 | 38 | 2 |
1280297 | 1280297 | 2021-05-02 | Kenedy | Texas | 48261 | 38 | 2 |
1277050 | 1277050 | 2021-05-01 | Kenedy | Texas | 48261 | 38 | 2 |
1273803 | 1273803 | 2021-04-30 | Kenedy | Texas | 48261 | 38 | 2 |
819366 | 819366 | 2020-12-11 | McMullen | Texas | 48311 | 38 | 1 |
786969 | 786969 | 2020-12-01 | Sterling | Texas | 48431 | 38 | 1 |
783725 | 783725 | 2020-11-30 | Sterling | Texas | 48431 | 38 | 1 |
773817 | 773817 | 2020-11-27 | Collingsworth | Texas | 48087 | 38 | 1 |
770572 | 770572 | 2020-11-26 | Collingsworth | Texas | 48087 | 38 | 1 |
767326 | 767326 | 2020-11-25 | Collingsworth | Texas | 48087 | 38 | 1 |
764081 | 764081 | 2020-11-24 | Collingsworth | Texas | 48087 | 38 | 1 |
760836 | 760836 | 2020-11-23 | Collingsworth | Texas | 48087 | 38 | 0 |
757591 | 757591 | 2020-11-22 | Collingsworth | Texas | 48087 | 38 | 0 |
754344 | 754344 | 2020-11-21 | Collingsworth | Texas | 48087 | 38 | 0 |
751098 | 751098 | 2020-11-20 | Collingsworth | Texas | 48087 | 38 | 0 |
747814 | 747814 | 2020-11-19 | Armstrong | Texas | 48011 | 38 | 1 |
695961 | 695961 | 2020-11-03 | Delta | Texas | 48119 | 38 | 0 |
631177 | 631177 | 2020-10-14 | Menard | Texas | 48327 | 38 | 0 |
611658 | 611658 | 2020-10-08 | Hardeman | Texas | 48197 | 38 | 1 |
524146 | 524146 | 2020-09-11 | Culberson | Texas | 48109 | 38 | 2 |
520910 | 520910 | 2020-09-10 | Culberson | Texas | 48109 | 38 | 2 |
517674 | 517674 | 2020-09-09 | Culberson | Texas | 48109 | 38 | 2 |
495189 | 495189 | 2020-09-02 | San Saba | Texas | 48411 | 38 | 0 |
495190 | 495190 | 2020-09-02 | Schleicher | Texas | 48413 | 38 | 2 |
491955 | 491955 | 2020-09-01 | San Saba | Texas | 48411 | 38 | 0 |
491956 | 491956 | 2020-09-01 | Schleicher | Texas | 48413 | 38 | 2 |
488633 | 488633 | 2020-08-31 | Hudspeth | Texas | 48229 | 38 | 2 |
488722 | 488722 | 2020-08-31 | San Saba | Texas | 48411 | 38 | 0 |
488723 | 488723 | 2020-08-31 | Schleicher | Texas | 48413 | 38 | 2 |
485400 | 485400 | 2020-08-30 | Hudspeth | Texas | 48229 | 38 | 2 |
485489 | 485489 | 2020-08-30 | San Saba | Texas | 48411 | 38 | 0 |
485490 | 485490 | 2020-08-30 | Schleicher | Texas | 48413 | 38 | 2 |
482165 | 482165 | 2020-08-29 | Hudspeth | Texas | 48229 | 38 | 2 |
482254 | 482254 | 2020-08-29 | San Saba | Texas | 48411 | 38 | 0 |
482255 | 482255 | 2020-08-29 | Schleicher | Texas | 48413 | 38 | 2 |
478931 | 478931 | 2020-08-28 | Hudspeth | Texas | 48229 | 38 | 2 |
479020 | 479020 | 2020-08-28 | San Saba | Texas | 48411 | 38 | 0 |
479021 | 479021 | 2020-08-28 | Schleicher | Texas | 48413 | 38 | 2 |
475788 | 475788 | 2020-08-27 | Schleicher | Texas | 48413 | 38 | 2 |
472555 | 472555 | 2020-08-26 | Schleicher | Texas | 48413 | 38 | 2 |
469323 | 469323 | 2020-08-25 | Schleicher | Texas | 48413 | 38 | 1 |
407876 | 407876 | 2020-08-06 | Clay | Texas | 48077 | 38 | 1 |
388692 | 388692 | 2020-07-31 | McCulloch | Texas | 48307 | 38 | 1 |
385347 | 385347 | 2020-07-30 | Callahan | Texas | 48059 | 38 | 3 |
382129 | 382129 | 2020-07-29 | Callahan | Texas | 48059 | 38 | 3 |
382205 | 382205 | 2020-07-29 | Hemphill | Texas | 48211 | 38 | 0 |
378912 | 378912 | 2020-07-28 | Callahan | Texas | 48059 | 38 | 3 |
379037 | 379037 | 2020-07-28 | Mason | Texas | 48319 | 38 | 0 |
375696 | 375696 | 2020-07-27 | Callahan | Texas | 48059 | 38 | 3 |
375731 | 375731 | 2020-07-27 | Donley | Texas | 48129 | 38 | 0 |
375821 | 375821 | 2020-07-27 | Mason | Texas | 48319 | 38 | 0 |
372483 | 372483 | 2020-07-26 | Callahan | Texas | 48059 | 38 | 2 |
372518 | 372518 | 2020-07-26 | Donley | Texas | 48129 | 38 | 0 |
372608 | 372608 | 2020-07-26 | Mason | Texas | 48319 | 38 | 0 |
369271 | 369271 | 2020-07-25 | Callahan | Texas | 48059 | 38 | 2 |
369306 | 369306 | 2020-07-25 | Donley | Texas | 48129 | 38 | 0 |
369396 | 369396 | 2020-07-25 | Mason | Texas | 48319 | 38 | 0 |
366062 | 366062 | 2020-07-24 | Callahan | Texas | 48059 | 38 | 2 |
366097 | 366097 | 2020-07-24 | Donley | Texas | 48129 | 38 | 0 |
366099 | 366099 | 2020-07-24 | Eastland | Texas | 48133 | 38 | 0 |
366187 | 366187 | 2020-07-24 | Mason | Texas | 48319 | 38 | 0 |
366198 | 366198 | 2020-07-24 | Mitchell | Texas | 48335 | 38 | 0 |
362980 | 362980 | 2020-07-23 | Martin | Texas | 48317 | 38 | 1 |
362981 | 362981 | 2020-07-23 | Mason | Texas | 48319 | 38 | 0 |
359774 | 359774 | 2020-07-22 | Mason | Texas | 48319 | 38 | 0 |
356569 | 356569 | 2020-07-21 | Mason | Texas | 48319 | 38 | 0 |
353366 | 353366 | 2020-07-20 | Mason | Texas | 48319 | 38 | 0 |
350164 | 350164 | 2020-07-19 | Mason | Texas | 48319 | 38 | 0 |
346964 | 346964 | 2020-07-18 | Mason | Texas | 48319 | 38 | 0 |
343764 | 343764 | 2020-07-17 | Mason | Texas | 48319 | 38 | 0 |
340565 | 340565 | 2020-07-16 | Mason | Texas | 48319 | 38 | 0 |
334083 | 334083 | 2020-07-14 | Dimmit | Texas | 48127 | 38 | 0 |
334117 | 334117 | 2020-07-14 | Hansford | Texas | 48195 | 38 | 2 |
330881 | 330881 | 2020-07-13 | Crockett | Texas | 48105 | 38 | 1 |
330892 | 330892 | 2020-07-13 | Dimmit | Texas | 48127 | 38 | 0 |
327706 | 327706 | 2020-07-12 | Dimmit | Texas | 48127 | 38 | 0 |
321287 | 321287 | 2020-07-10 | Bandera | Texas | 48019 | 38 | 0 |
315166 | 315166 | 2020-07-08 | Winkler | Texas | 48495 | 38 | 0 |
315170 | 315170 | 2020-07-08 | Young | Texas | 48503 | 38 | 1 |
308759 | 308759 | 2020-07-06 | Palo Pinto | Texas | 48363 | 38 | 2 |
308794 | 308794 | 2020-07-06 | Swisher | Texas | 48437 | 38 | 1 |
308826 | 308826 | 2020-07-06 | Yoakum | Texas | 48501 | 38 | 0 |
305591 | 305591 | 2020-07-05 | Palo Pinto | Texas | 48363 | 38 | 2 |
305626 | 305626 | 2020-07-05 | Swisher | Texas | 48437 | 38 | 1 |
305658 | 305658 | 2020-07-05 | Yoakum | Texas | 48501 | 38 | 0 |
302427 | 302427 | 2020-07-04 | Palo Pinto | Texas | 48363 | 38 | 2 |
302462 | 302462 | 2020-07-04 | Swisher | Texas | 48437 | 38 | 1 |
302494 | 302494 | 2020-07-04 | Yoakum | Texas | 48501 | 38 | 0 |
299235 | 299235 | 2020-07-03 | Lynn | Texas | 48305 | 38 | 1 |
299236 | 299236 | 2020-07-03 | Madison | Texas | 48313 | 38 | 0 |
296074 | 296074 | 2020-07-02 | Lynn | Texas | 48305 | 38 | 1 |
289652 | 289652 | 2020-06-30 | Cass | Texas | 48067 | 38 | 2 |
289727 | 289727 | 2020-06-30 | Hockley | Texas | 48219 | 38 | 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);