ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

101 rows where cases = 119 and state = "Texas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips >30

state 1

  • Texas · 101 ✖
Link rowid date ▲ county state fips cases deaths
2170467 2170467 2022-01-31 Loving Texas 48301 119 0
2076150 2076150 2022-01-02 McMullen Texas 48311 119 8
2072899 2072899 2022-01-01 McMullen Texas 48311 119 8
2069648 2069648 2021-12-31 McMullen Texas 48311 119 8
2066397 2066397 2021-12-30 McMullen Texas 48311 119 8
2063147 2063147 2021-12-29 McMullen Texas 48311 119 8
2059897 2059897 2021-12-28 McMullen Texas 48311 119 8
2056648 2056648 2021-12-27 McMullen Texas 48311 119 8
2053399 2053399 2021-12-26 McMullen Texas 48311 119 8
2050149 2050149 2021-12-25 McMullen Texas 48311 119 8
2046899 2046899 2021-12-24 McMullen Texas 48311 119 8
2043649 2043649 2021-12-23 McMullen Texas 48311 119 8
2040400 2040400 2021-12-22 McMullen Texas 48311 119 8
1744642 1744642 2021-09-22 Kent Texas 48263 119 3
1741393 1741393 2021-09-21 Kent Texas 48263 119 3
1559518 1559518 2021-07-27 Motley Texas 48345 119 8
1556271 1556271 2021-07-26 Motley Texas 48345 119 8
1553024 1553024 2021-07-25 Motley Texas 48345 119 8
1549777 1549777 2021-07-24 Motley Texas 48345 119 8
1104892 1104892 2021-03-09 Foard Texas 48155 119 9
1101646 1101646 2021-03-08 Foard Texas 48155 119 9
1098400 1098400 2021-03-07 Foard Texas 48155 119 9
1095152 1095152 2021-03-06 Foard Texas 48155 119 9
1091906 1091906 2021-03-05 Foard Texas 48155 119 9
1088660 1088660 2021-03-04 Foard Texas 48155 119 9
1085415 1085415 2021-03-03 Foard Texas 48155 119 8
1082169 1082169 2021-03-02 Foard Texas 48155 119 8
1078923 1078923 2021-03-01 Foard Texas 48155 119 8
1075678 1075678 2021-02-28 Foard Texas 48155 119 8
1072432 1072432 2021-02-27 Foard Texas 48155 119 8
965370 965370 2021-01-25 Jeff Davis Texas 48243 119 1
962125 962125 2021-01-24 Jeff Davis Texas 48243 119 1
958880 958880 2021-01-23 Jeff Davis Texas 48243 119 1
955634 955634 2021-01-22 Jeff Davis Texas 48243 119 1
835572 835572 2020-12-16 Kinney Texas 48271 119 3
816122 816122 2020-12-10 Menard Texas 48327 119 3
812876 812876 2020-12-09 Menard Texas 48327 119 3
809537 809537 2020-12-08 Edwards Texas 48137 119 2
809632 809632 2020-12-08 Menard Texas 48327 119 3
806288 806288 2020-12-07 Donley Texas 48129 119 2
806292 806292 2020-12-07 Edwards Texas 48137 119 2
806387 806387 2020-12-07 Menard Texas 48327 119 3
803043 803043 2020-12-06 Donley Texas 48129 119 2
803047 803047 2020-12-06 Edwards Texas 48137 119 2
799798 799798 2020-12-05 Donley Texas 48129 119 2
799802 799802 2020-12-05 Edwards Texas 48137 119 2
796557 796557 2020-12-04 Edwards Texas 48137 119 2
764175 764175 2020-11-24 Knox Texas 48275 119 9
722003 722003 2020-11-11 Martin Texas 48317 119 7
702502 702502 2020-11-05 Hudspeth Texas 48229 119 3
699259 699259 2020-11-04 Hudspeth Texas 48229 119 3
637581 637581 2020-10-16 Floyd Texas 48153 119 9
634336 634336 2020-10-15 Floyd Texas 48153 119 9
631202 631202 2020-10-14 Presidio Texas 48377 119 7
627922 627922 2020-10-13 Lynn Texas 48305 119 5
624745 624745 2020-10-12 Swisher Texas 48437 119 3
621502 621502 2020-10-11 Swisher Texas 48437 119 3
618259 618259 2020-10-10 Swisher Texas 48437 119 3
615017 615017 2020-10-09 Swisher Texas 48437 119 3
592350 592350 2020-10-02 Winkler Texas 48495 119 4
582481 582481 2020-09-29 Hansford Texas 48195 119 5
563032 563032 2020-09-23 Hamilton Texas 48193 119 4
559845 559845 2020-09-22 Llano Texas 48299 119 2
543744 543744 2020-09-17 Ward Texas 48475 119 1
540508 540508 2020-09-16 Ward Texas 48475 119 1
537212 537212 2020-09-15 Ochiltree Texas 48357 119 4
524171 524171 2020-09-11 Franklin Texas 48159 119 6
495196 495196 2020-09-02 Somervell Texas 48425 119 4
491962 491962 2020-09-01 Somervell Texas 48425 119 4
472469 472469 2020-08-26 Jack Texas 48237 119 0
443381 443381 2020-08-17 Goliad Texas 48175 119 6
440155 440155 2020-08-16 Goliad Texas 48175 119 6
436929 436929 2020-08-15 Goliad Texas 48175 119 6
433864 433864 2020-08-14 Yoakum Texas 48501 119 3
388617 388617 2020-07-31 Gaines Texas 48165 119 0
382163 382163 2020-07-29 Dimmit Texas 48127 119 0
382292 382292 2020-07-29 Reeves Texas 48389 119 2
379035 379035 2020-07-28 Marion Texas 48315 119 7
369307 369307 2020-07-25 Duval Texas 48131 119 0
362907 362907 2020-07-23 Freestone Texas 48161 119 0
363006 363006 2020-07-23 Palo Pinto Texas 48363 119 2
353351 353351 2020-07-20 Lamb Texas 48279 119 1
353355 353355 2020-07-20 Leon Texas 48289 119 0
350152 350152 2020-07-19 Lee Texas 48287 119 3
350155 350155 2020-07-19 Limestone Texas 48293 119 1
343619 343619 2020-07-17 Bailey Texas 48017 119 1
343721 343721 2020-07-17 Hopkins Texas 48223 119 0
324647 324647 2020-07-11 Red River Texas 48387 119 12
321466 321466 2020-07-10 Red River Texas 48387 119 12
315123 315123 2020-07-08 San Augustine Texas 48405 119 7
299175 299175 2020-07-03 Gray Texas 48179 119 4
267834 267834 2020-06-23 Waller Texas 48473 119 0
255178 255178 2020-06-19 Frio Texas 48163 119 0
242848 242848 2020-06-15 Starr Texas 48427 119 0
147689 147689 2020-05-15 Deaf Smith Texas 48117 119 2
144635 144635 2020-05-14 Angelina Texas 48005 119 1
56113 56113 2020-04-13 Williamson Texas 48491 119 4
30421 30421 2020-04-03 Montgomery Texas 48339 119 3
21404 21404 2020-03-30 Fort Bend Texas 48157 119 1
19345 19345 2020-03-29 Fort Bend Texas 48157 119 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);