ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 546 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2180172 | 2180172 | 2022-02-03 | Hardeman | Texas | 48197 | 546 | 14 |
1998189 | 1998189 | 2021-12-09 | Shackelford | Texas | 48417 | 546 | 7 |
1864823 | 1864823 | 2021-10-29 | Hall | Texas | 48191 | 546 | 15 |
1582197 | 1582197 | 2021-08-03 | Hudspeth | Texas | 48229 | 546 | 12 |
1578948 | 1578948 | 2021-08-02 | Hudspeth | Texas | 48229 | 546 | 12 |
1416660 | 1416660 | 2021-06-13 | Marion | Texas | 48315 | 546 | 33 |
1413414 | 1413414 | 2021-06-12 | Marion | Texas | 48315 | 546 | 33 |
1156814 | 1156814 | 2021-03-25 | Crosby | Texas | 48107 | 546 | 28 |
1153567 | 1153567 | 2021-03-24 | Crosby | Texas | 48107 | 546 | 28 |
1147125 | 1147125 | 2021-03-22 | Hemphill | Texas | 48211 | 546 | 2 |
1147222 | 1147222 | 2021-03-22 | San Augustine | Texas | 48405 | 546 | 30 |
1143878 | 1143878 | 2021-03-21 | Hemphill | Texas | 48211 | 546 | 2 |
1143975 | 1143975 | 2021-03-21 | San Augustine | Texas | 48405 | 546 | 30 |
1140631 | 1140631 | 2021-03-20 | Hemphill | Texas | 48211 | 546 | 2 |
1140728 | 1140728 | 2021-03-20 | San Augustine | Texas | 48405 | 546 | 30 |
1137385 | 1137385 | 2021-03-19 | Hemphill | Texas | 48211 | 546 | 2 |
1137482 | 1137482 | 2021-03-19 | San Augustine | Texas | 48405 | 546 | 30 |
1134139 | 1134139 | 2021-03-18 | Hemphill | Texas | 48211 | 546 | 2 |
1134236 | 1134236 | 2021-03-18 | San Augustine | Texas | 48405 | 546 | 30 |
1130891 | 1130891 | 2021-03-17 | Hemphill | Texas | 48211 | 546 | 2 |
1130988 | 1130988 | 2021-03-17 | San Augustine | Texas | 48405 | 546 | 30 |
1127644 | 1127644 | 2021-03-16 | Hemphill | Texas | 48211 | 546 | 2 |
1127741 | 1127741 | 2021-03-16 | San Augustine | Texas | 48405 | 546 | 30 |
1124398 | 1124398 | 2021-03-15 | Hemphill | Texas | 48211 | 546 | 2 |
1121152 | 1121152 | 2021-03-14 | Hemphill | Texas | 48211 | 546 | 2 |
1117905 | 1117905 | 2021-03-13 | Hemphill | Texas | 48211 | 546 | 2 |
1114658 | 1114658 | 2021-03-12 | Hemphill | Texas | 48211 | 546 | 2 |
1111412 | 1111412 | 2021-03-11 | Hemphill | Texas | 48211 | 546 | 2 |
1108166 | 1108166 | 2021-03-10 | Hemphill | Texas | 48211 | 546 | 2 |
1104920 | 1104920 | 2021-03-09 | Hemphill | Texas | 48211 | 546 | 2 |
1101674 | 1101674 | 2021-03-08 | Hemphill | Texas | 48211 | 546 | 2 |
1098428 | 1098428 | 2021-03-07 | Hemphill | Texas | 48211 | 546 | 2 |
1095180 | 1095180 | 2021-03-06 | Hemphill | Texas | 48211 | 546 | 2 |
1091934 | 1091934 | 2021-03-05 | Hemphill | Texas | 48211 | 546 | 2 |
1088688 | 1088688 | 2021-03-04 | Hemphill | Texas | 48211 | 546 | 2 |
981597 | 981597 | 2021-01-30 | Jim Hogg | Texas | 48247 | 546 | 13 |
945873 | 945873 | 2021-01-19 | Hamilton | Texas | 48193 | 546 | 21 |
942626 | 942626 | 2021-01-18 | Hamilton | Texas | 48193 | 546 | 21 |
939381 | 939381 | 2021-01-17 | Hamilton | Texas | 48193 | 546 | 21 |
926356 | 926356 | 2021-01-13 | Crane | Texas | 48103 | 546 | 10 |
923100 | 923100 | 2021-01-12 | Coleman | Texas | 48083 | 546 | 16 |
887606 | 887606 | 2021-01-01 | Winkler | Texas | 48495 | 546 | 15 |
799931 | 799931 | 2020-12-05 | Robertson | Texas | 48395 | 546 | 9 |
793496 | 793496 | 2020-12-03 | Zapata | Texas | 48505 | 546 | 9 |
790045 | 790045 | 2020-12-02 | Comanche | Texas | 48093 | 546 | 6 |
767403 | 767403 | 2020-11-25 | Jasper | Texas | 48241 | 546 | 35 |
764158 | 764158 | 2020-11-24 | Jasper | Texas | 48241 | 546 | 35 |
760905 | 760905 | 2020-11-23 | Houston | Texas | 48225 | 546 | 15 |
757660 | 757660 | 2020-11-22 | Houston | Texas | 48225 | 546 | 15 |
747874 | 747874 | 2020-11-19 | Duval | Texas | 48131 | 546 | 22 |
744570 | 744570 | 2020-11-18 | Austin | Texas | 48015 | 546 | 11 |
741323 | 741323 | 2020-11-17 | Austin | Texas | 48015 | 546 | 11 |
491957 | 491957 | 2020-09-01 | Scurry | Texas | 48415 | 546 | 2 |
488724 | 488724 | 2020-08-31 | Scurry | Texas | 48415 | 546 | 2 |
485491 | 485491 | 2020-08-30 | Scurry | Texas | 48415 | 546 | 2 |
482256 | 482256 | 2020-08-29 | Scurry | Texas | 48415 | 546 | 2 |
459567 | 459567 | 2020-08-22 | Kleberg | Texas | 48273 | 546 | 21 |
423968 | 423968 | 2020-08-11 | Calhoun | Texas | 48057 | 546 | 5 |
375827 | 375827 | 2020-07-27 | Medina | Texas | 48325 | 546 | 16 |
372614 | 372614 | 2020-07-26 | Medina | Texas | 48325 | 546 | 8 |
369402 | 369402 | 2020-07-25 | Medina | Texas | 48325 | 546 | 8 |
196475 | 196475 | 2020-05-31 | Webb | Texas | 48479 | 546 | 19 |
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);