ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 521 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2339639 | 2339639 | 2022-03-24 | Schleicher | Texas | 48413 | 521 | 9 |
2222538 | 2222538 | 2022-02-16 | Oldham | Texas | 48359 | 521 | 6 |
2219287 | 2219287 | 2022-02-15 | Oldham | Texas | 48359 | 521 | 6 |
2216036 | 2216036 | 2022-02-14 | Oldham | Texas | 48359 | 521 | 6 |
2212785 | 2212785 | 2022-02-13 | Oldham | Texas | 48359 | 521 | 6 |
2209532 | 2209532 | 2022-02-12 | Oldham | Texas | 48359 | 521 | 6 |
2137873 | 2137873 | 2022-01-21 | Hardeman | Texas | 48197 | 521 | 14 |
2059775 | 2059775 | 2021-12-28 | Cochran | Texas | 48079 | 521 | 20 |
1744702 | 1744702 | 2021-09-22 | Reagan | Texas | 48383 | 521 | 9 |
1741326 | 1741326 | 2021-09-21 | Donley | Texas | 48129 | 521 | 18 |
1289938 | 1289938 | 2021-05-05 | Carson | Texas | 48065 | 521 | 14 |
1286692 | 1286692 | 2021-05-04 | Carson | Texas | 48065 | 521 | 14 |
1221769 | 1221769 | 2021-04-14 | Crane | Texas | 48103 | 521 | 12 |
1218521 | 1218521 | 2021-04-13 | Crane | Texas | 48103 | 521 | 12 |
1215273 | 1215273 | 2021-04-12 | Crane | Texas | 48103 | 521 | 12 |
1215463 | 1215463 | 2021-04-12 | Wheeler | Texas | 48483 | 521 | 10 |
1212026 | 1212026 | 2021-04-11 | Crane | Texas | 48103 | 521 | 12 |
1212216 | 1212216 | 2021-04-11 | Wheeler | Texas | 48483 | 521 | 10 |
1208777 | 1208777 | 2021-04-10 | Crane | Texas | 48103 | 521 | 12 |
1208967 | 1208967 | 2021-04-10 | Wheeler | Texas | 48483 | 521 | 10 |
1205529 | 1205529 | 2021-04-09 | Crane | Texas | 48103 | 521 | 12 |
1202281 | 1202281 | 2021-04-08 | Crane | Texas | 48103 | 521 | 12 |
1199032 | 1199032 | 2021-04-07 | Crane | Texas | 48103 | 521 | 12 |
1124447 | 1124447 | 2021-03-15 | Marion | Texas | 48315 | 521 | 32 |
1121201 | 1121201 | 2021-03-14 | Marion | Texas | 48315 | 521 | 32 |
1117954 | 1117954 | 2021-03-13 | Marion | Texas | 48315 | 521 | 32 |
1111461 | 1111461 | 2021-03-11 | Marion | Texas | 48315 | 521 | 31 |
1108215 | 1108215 | 2021-03-10 | Marion | Texas | 48315 | 521 | 31 |
1104969 | 1104969 | 2021-03-09 | Marion | Texas | 48315 | 521 | 31 |
1101723 | 1101723 | 2021-03-08 | Marion | Texas | 48315 | 521 | 30 |
1098477 | 1098477 | 2021-03-07 | Marion | Texas | 48315 | 521 | 30 |
1095229 | 1095229 | 2021-03-06 | Marion | Texas | 48315 | 521 | 29 |
1091983 | 1091983 | 2021-03-05 | Marion | Texas | 48315 | 521 | 28 |
1023829 | 1023829 | 2021-02-12 | McCulloch | Texas | 48307 | 521 | 15 |
991266 | 991266 | 2021-02-02 | Crockett | Texas | 48105 | 521 | 15 |
988020 | 988020 | 2021-02-01 | Crockett | Texas | 48105 | 521 | 15 |
978342 | 978342 | 2021-01-29 | Hudspeth | Texas | 48229 | 521 | 9 |
929668 | 929668 | 2021-01-14 | Jack | Texas | 48237 | 521 | 12 |
874534 | 874534 | 2020-12-28 | Martin | Texas | 48317 | 521 | 13 |
871289 | 871289 | 2020-12-27 | Martin | Texas | 48317 | 521 | 13 |
747991 | 747991 | 2020-11-19 | Panola | Texas | 48365 | 521 | 34 |
699373 | 699373 | 2020-11-04 | Upshur | Texas | 48459 | 521 | 15 |
689422 | 689422 | 2020-11-01 | Austin | Texas | 48015 | 521 | 10 |
670030 | 670030 | 2020-10-26 | Fayette | Texas | 48149 | 521 | 22 |
666787 | 666787 | 2020-10-25 | Fayette | Texas | 48149 | 521 | 22 |
634443 | 634443 | 2020-10-15 | Parmer | Texas | 48369 | 521 | 15 |
498450 | 498450 | 2020-09-03 | Van Zandt | Texas | 48467 | 521 | 18 |
495217 | 495217 | 2020-09-02 | Van Zandt | Texas | 48467 | 521 | 18 |
437076 | 437076 | 2020-08-15 | Waller | Texas | 48473 | 521 | 5 |
267697 | 267697 | 2020-06-23 | Grayson | Texas | 48181 | 521 | 5 |
184218 | 184218 | 2020-05-27 | Webb | Texas | 48479 | 521 | 19 |
66862 | 66862 | 2020-04-17 | Collin | Texas | 48085 | 521 | 12 |
61403 | 61403 | 2020-04-15 | Denton | Texas | 48121 | 521 | 14 |
58686 | 58686 | 2020-04-14 | Denton | Texas | 48121 | 521 | 14 |
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);