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

163 rows where cases = 40 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 · 163 ✖
Link rowid date ▲ county state fips cases deaths
2228995 2228995 2022-02-18 King Texas 48269 40 0
2225744 2225744 2022-02-17 King Texas 48269 40 0
2222493 2222493 2022-02-16 King Texas 48269 40 0
2219242 2219242 2022-02-15 King Texas 48269 40 0
2215991 2215991 2022-02-14 King Texas 48269 40 0
2212740 2212740 2022-02-13 King Texas 48269 40 0
2209487 2209487 2022-02-12 King Texas 48269 40 0
2206234 2206234 2022-02-11 King Texas 48269 40 0
2202981 2202981 2022-02-10 King Texas 48269 40 0
2199727 2199727 2022-02-09 King Texas 48269 40 0
2196473 2196473 2022-02-08 King Texas 48269 40 0
2193219 2193219 2022-02-07 King Texas 48269 40 0
2189965 2189965 2022-02-06 King Texas 48269 40 0
2186712 2186712 2022-02-05 King Texas 48269 40 0
2183460 2183460 2022-02-04 King Texas 48269 40 0
2180208 2180208 2022-02-03 King Texas 48269 40 0
2176957 2176957 2022-02-02 King Texas 48269 40 0
2173703 2173703 2022-02-01 King Texas 48269 40 0
2092397 2092397 2022-01-07 Loving Texas 48301 40 0
793266 793266 2020-12-03 Briscoe Texas 48045 40 1
790021 790021 2020-12-02 Briscoe Texas 48045 40 1
786776 786776 2020-12-01 Briscoe Texas 48045 40 1
783532 783532 2020-11-30 Briscoe Texas 48045 40 1
780287 780287 2020-11-29 Briscoe Texas 48045 40 1
777041 777041 2020-11-28 Briscoe Texas 48045 40 1
773796 773796 2020-11-27 Briscoe Texas 48045 40 1
773860 773860 2020-11-27 Glasscock Texas 48173 40 0
770551 770551 2020-11-26 Briscoe Texas 48045 40 1
741546 741546 2020-11-17 Upton Texas 48461 40 5
708935 708935 2020-11-07 Delta Texas 48119 40 0
705691 705691 2020-11-06 Delta Texas 48119 40 0
702448 702448 2020-11-05 Delta Texas 48119 40 0
699205 699205 2020-11-04 Delta Texas 48119 40 0
699352 699352 2020-11-04 Shackelford Texas 48417 40 0
696108 696108 2020-11-03 Shackelford Texas 48417 40 0
692709 692709 2020-11-02 Cottle Texas 48101 40 3
692866 692866 2020-11-02 Shackelford Texas 48417 40 0
689465 689465 2020-11-01 Cottle Texas 48101 40 3
689622 689622 2020-11-01 Shackelford Texas 48417 40 0
686220 686220 2020-10-31 Cottle Texas 48101 40 3
686377 686377 2020-10-31 Shackelford Texas 48417 40 0
682977 682977 2020-10-30 Cottle Texas 48101 40 3
683134 683134 2020-10-30 Shackelford Texas 48417 40 0
679734 679734 2020-10-29 Cottle Texas 48101 40 3
679891 679891 2020-10-29 Shackelford Texas 48417 40 0
676491 676491 2020-10-28 Cottle Texas 48101 40 3
650585 650585 2020-10-20 Hall Texas 48191 40 1
650652 650652 2020-10-20 Menard Texas 48327 40 0
637516 637516 2020-10-16 Baylor Texas 48023 40 2
637734 637734 2020-10-16 Upton Texas 48461 40 3
627803 627803 2020-10-13 Carson Texas 48065 40 0
624627 624627 2020-10-12 Hardeman Texas 48197 40 1
621384 621384 2020-10-11 Hardeman Texas 48197 40 1
618141 618141 2020-10-10 Hardeman Texas 48197 40 1
614899 614899 2020-10-09 Hardeman Texas 48197 40 1
521020 521020 2020-09-10 Mills Texas 48333 40 0
517784 517784 2020-09-09 Mills Texas 48333 40 0
501492 501492 2020-09-04 Cochran Texas 48079 40 1
501656 501656 2020-09-04 San Saba Texas 48411 40 0
469124 469124 2020-08-25 Archer Texas 48009 40 0
466129 466129 2020-08-24 Wheeler Texas 48483 40 0
462900 462900 2020-08-23 Wheeler Texas 48483 40 0
459671 459671 2020-08-22 Wheeler Texas 48483 40 0
456444 456444 2020-08-21 Wheeler Texas 48483 40 0
453216 453216 2020-08-20 Wheeler Texas 48483 40 0
420756 420756 2020-08-10 Childress Texas 48075 40 0
420757 420757 2020-08-10 Clay Texas 48077 40 1
420927 420927 2020-08-10 Sherman Texas 48421 40 0
417535 417535 2020-08-09 Childress Texas 48075 40 0
417536 417536 2020-08-09 Clay Texas 48077 40 1
417706 417706 2020-08-09 Sherman Texas 48421 40 0
414314 414314 2020-08-08 Childress Texas 48075 40 0
414315 414315 2020-08-08 Clay Texas 48077 40 1
414485 414485 2020-08-08 Sherman Texas 48421 40 0
411094 411094 2020-08-07 Childress Texas 48075 40 0
411095 411095 2020-08-07 Clay Texas 48077 40 1
411265 411265 2020-08-07 Sherman Texas 48421 40 0
407878 407878 2020-08-06 Coke Texas 48081 40 1
404658 404658 2020-08-05 Coke Texas 48081 40 1
401440 401440 2020-08-04 Coke Texas 48081 40 1
398302 398302 2020-08-03 Jack Texas 48237 40 0
398338 398338 2020-08-03 Mason Texas 48319 40 0
395086 395086 2020-08-02 Jack Texas 48237 40 0
395122 395122 2020-08-02 Mason Texas 48319 40 0
391870 391870 2020-08-01 Jack Texas 48237 40 0
391906 391906 2020-08-01 Mason Texas 48319 40 0
388564 388564 2020-07-31 Callahan Texas 48059 40 3
385423 385423 2020-07-30 Hemphill Texas 48211 40 0
379070 379070 2020-07-28 Rains Texas 48379 40 2
366232 366232 2020-07-24 Sabine Texas 48403 40 1
340474 340474 2020-07-16 Dimmit Texas 48127 40 0
337312 337312 2020-07-15 Hansford Texas 48195 40 2
334160 334160 2020-07-14 Lampasas Texas 48281 40 0
327794 327794 2020-07-12 Marion Texas 48315 40 1
327884 327884 2020-07-12 Winkler Texas 48495 40 0
324699 324699 2020-07-11 Winkler Texas 48495 40 0
321518 321518 2020-07-10 Winkler Texas 48495 40 0
321521 321521 2020-07-10 Yoakum Texas 48501 40 0
318339 318339 2020-07-09 Winkler Texas 48495 40 0
318342 318342 2020-07-09 Yoakum Texas 48501 40 0

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