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

165 rows where cases = 82 and state = "Texas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips >30

state 1

  • Texas · 165 ✖
Link rowid date ▲ county state fips cases deaths
2339563 2339563 2022-03-24 Kenedy Texas 48261 82 2
2336309 2336309 2022-03-23 Kenedy Texas 48261 82 2
2333055 2333055 2022-03-22 Kenedy Texas 48261 82 2
2329802 2329802 2022-03-21 Kenedy Texas 48261 82 2
2326550 2326550 2022-03-20 Kenedy Texas 48261 82 2
2323297 2323297 2022-03-19 Kenedy Texas 48261 82 2
2320043 2320043 2022-03-18 Kenedy Texas 48261 82 2
2316789 2316789 2022-03-17 Kenedy Texas 48261 82 2
2313536 2313536 2022-03-16 Kenedy Texas 48261 82 2
2310283 2310283 2022-03-15 Kenedy Texas 48261 82 2
2307030 2307030 2022-03-14 Kenedy Texas 48261 82 2
2303779 2303779 2022-03-13 Kenedy Texas 48261 82 2
2300527 2300527 2022-03-12 Kenedy Texas 48261 82 2
2297275 2297275 2022-03-11 Kenedy Texas 48261 82 2
2294023 2294023 2022-03-10 Kenedy Texas 48261 82 2
2290771 2290771 2022-03-09 Kenedy Texas 48261 82 2
2287519 2287519 2022-03-08 Kenedy Texas 48261 82 2
2284267 2284267 2022-03-07 Kenedy Texas 48261 82 2
2281015 2281015 2022-03-06 Kenedy Texas 48261 82 2
2277762 2277762 2022-03-05 Kenedy Texas 48261 82 2
2274509 2274509 2022-03-04 Kenedy Texas 48261 82 2
2271256 2271256 2022-03-03 Kenedy Texas 48261 82 2
2268004 2268004 2022-03-02 Kenedy Texas 48261 82 2
1721961 1721961 2021-09-15 Roberts Texas 48393 82 1
1718713 1718713 2021-09-14 Roberts Texas 48393 82 1
1715465 1715465 2021-09-13 Roberts Texas 48393 82 1
1712219 1712219 2021-09-12 Roberts Texas 48393 82 1
1708972 1708972 2021-09-11 Roberts Texas 48393 82 1
1705725 1705725 2021-09-10 Roberts Texas 48393 82 1
1676507 1676507 2021-09-01 Terrell Texas 48443 82 3
1673260 1673260 2021-08-31 Terrell Texas 48443 82 3
1670012 1670012 2021-08-30 Terrell Texas 48443 82 3
1666765 1666765 2021-08-29 Terrell Texas 48443 82 3
1663517 1663517 2021-08-28 Terrell Texas 48443 82 3
1660269 1660269 2021-08-27 Terrell Texas 48443 82 3
1653773 1653773 2021-08-25 Terrell Texas 48443 82 3
1650526 1650526 2021-08-24 Terrell Texas 48443 82 3
1647277 1647277 2021-08-23 Terrell Texas 48443 82 3
1644028 1644028 2021-08-22 Terrell Texas 48443 82 3
1640778 1640778 2021-08-21 Terrell Texas 48443 82 3
1637528 1637528 2021-08-20 Terrell Texas 48443 82 3
1634278 1634278 2021-08-19 Terrell Texas 48443 82 3
1631031 1631031 2021-08-18 Terrell Texas 48443 82 3
1134195 1134195 2021-03-18 McMullen Texas 48311 82 5
1130947 1130947 2021-03-17 McMullen Texas 48311 82 5
1127700 1127700 2021-03-16 McMullen Texas 48311 82 5
1124454 1124454 2021-03-15 McMullen Texas 48311 82 5
1121208 1121208 2021-03-14 McMullen Texas 48311 82 5
1117961 1117961 2021-03-13 McMullen Texas 48311 82 5
1114714 1114714 2021-03-12 McMullen Texas 48311 82 5
1111468 1111468 2021-03-11 McMullen Texas 48311 82 5
1108222 1108222 2021-03-10 McMullen Texas 48311 82 5
1104976 1104976 2021-03-09 McMullen Texas 48311 82 5
1101730 1101730 2021-03-08 McMullen Texas 48311 82 5
1098484 1098484 2021-03-07 McMullen Texas 48311 82 5
1095236 1095236 2021-03-06 McMullen Texas 48311 82 5
1091990 1091990 2021-03-05 McMullen Texas 48311 82 5
1088744 1088744 2021-03-04 McMullen Texas 48311 82 5
1085499 1085499 2021-03-03 McMullen Texas 48311 82 5
1082253 1082253 2021-03-02 McMullen Texas 48311 82 5
1079007 1079007 2021-03-01 McMullen Texas 48311 82 5
1075762 1075762 2021-02-28 McMullen Texas 48311 82 5
1072516 1072516 2021-02-27 McMullen Texas 48311 82 5
848505 848505 2020-12-20 Glasscock Texas 48173 82 1
838705 838705 2020-12-17 Briscoe Texas 48045 82 2
829159 829159 2020-12-14 Sterling Texas 48431 82 1
822572 822572 2020-12-12 Jeff Davis Texas 48243 82 1
819326 819326 2020-12-11 Jeff Davis Texas 48243 82 1
744595 744595 2020-11-18 Carson Texas 48065 82 2
679839 679839 2020-10-29 Mason Texas 48319 82 2
676596 676596 2020-10-28 Mason Texas 48319 82 2
673353 673353 2020-10-27 Mason Texas 48319 82 2
647310 647310 2020-10-19 Donley Texas 48129 82 1
644064 644064 2020-10-18 Donley Texas 48129 82 1
640816 640816 2020-10-17 Donley Texas 48129 82 1
637546 637546 2020-10-16 Coleman Texas 48083 82 4
634301 634301 2020-10-15 Coleman Texas 48083 82 4
631056 631056 2020-10-14 Coleman Texas 48083 82 4
627812 627812 2020-10-13 Coleman Texas 48083 82 4
624570 624570 2020-10-12 Coleman Texas 48083 82 4
621327 621327 2020-10-11 Coleman Texas 48083 82 4
618084 618084 2020-10-10 Coleman Texas 48083 82 4
614842 614842 2020-10-09 Coleman Texas 48083 82 4
611759 611759 2020-10-08 Sabine Texas 48403 82 8
608517 608517 2020-10-07 Sabine Texas 48403 82 8
605274 605274 2020-10-06 Sabine Texas 48403 82 8
602032 602032 2020-10-05 Sabine Texas 48403 82 8
598789 598789 2020-10-04 Sabine Texas 48403 82 8
595546 595546 2020-10-03 Sabine Texas 48403 82 8
592304 592304 2020-10-02 Sabine Texas 48403 82 8
589064 589064 2020-10-01 Sabine Texas 48403 82 8
569422 569422 2020-09-25 Archer Texas 48009 82 1
566181 566181 2020-09-24 Archer Texas 48009 82 1
540438 540438 2020-09-16 Mitchell Texas 48335 82 1
537201 537201 2020-09-15 Mitchell Texas 48335 82 1
498369 498369 2020-09-03 Lynn Texas 48305 82 4
495136 495136 2020-09-02 Lynn Texas 48305 82 4
479006 479006 2020-08-28 Reagan Texas 48383 82 6
472508 472508 2020-08-26 McCulloch Texas 48307 82 1
433832 433832 2020-08-14 Swisher Texas 48437 82 2

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