ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 522 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2362411 | 2362411 | 2022-03-31 | Schleicher | Texas | 48413 | 522 | 9 |
2359157 | 2359157 | 2022-03-30 | Schleicher | Texas | 48413 | 522 | 9 |
2355903 | 2355903 | 2022-03-29 | Schleicher | Texas | 48413 | 522 | 9 |
2352650 | 2352650 | 2022-03-28 | Schleicher | Texas | 48413 | 522 | 9 |
2349398 | 2349398 | 2022-03-27 | Schleicher | Texas | 48413 | 522 | 9 |
2346145 | 2346145 | 2022-03-26 | Schleicher | Texas | 48413 | 522 | 9 |
2342892 | 2342892 | 2022-03-25 | Schleicher | Texas | 48413 | 522 | 9 |
2225789 | 2225789 | 2022-02-17 | Oldham | Texas | 48359 | 522 | 6 |
1998116 | 1998116 | 2021-12-09 | Kinney | Texas | 48271 | 522 | 10 |
1994865 | 1994865 | 2021-12-08 | Kinney | Texas | 48271 | 522 | 10 |
1786760 | 1786760 | 2021-10-05 | Baylor | Texas | 48023 | 522 | 18 |
1738108 | 1738108 | 2021-09-20 | Hall | Texas | 48191 | 522 | 15 |
1734858 | 1734858 | 2021-09-19 | Hall | Texas | 48191 | 522 | 15 |
1731608 | 1731608 | 2021-09-18 | Hall | Texas | 48191 | 522 | 15 |
1611541 | 1611541 | 2021-08-12 | Sutton | Texas | 48435 | 522 | 8 |
1267293 | 1267293 | 2021-04-28 | Hudspeth | Texas | 48229 | 522 | 11 |
1228264 | 1228264 | 2021-04-16 | Crane | Texas | 48103 | 522 | 12 |
1225016 | 1225016 | 2021-04-15 | Crane | Texas | 48103 | 522 | 12 |
1134188 | 1134188 | 2021-03-18 | Marion | Texas | 48315 | 522 | 32 |
1130940 | 1130940 | 2021-03-17 | Marion | Texas | 48315 | 522 | 32 |
1127693 | 1127693 | 2021-03-16 | Marion | Texas | 48315 | 522 | 32 |
1114707 | 1114707 | 2021-03-12 | Marion | Texas | 48315 | 522 | 31 |
1033567 | 1033567 | 2021-02-15 | McCulloch | Texas | 48307 | 522 | 15 |
1030321 | 1030321 | 2021-02-14 | McCulloch | Texas | 48307 | 522 | 15 |
1027074 | 1027074 | 2021-02-13 | McCulloch | Texas | 48307 | 522 | 15 |
952495 | 952495 | 2021-01-21 | Trinity | Texas | 48455 | 522 | 13 |
923226 | 923226 | 2021-01-12 | Mitchell | Texas | 48335 | 522 | 17 |
919981 | 919981 | 2021-01-11 | Mitchell | Texas | 48335 | 522 | 17 |
916736 | 916736 | 2021-01-10 | Mitchell | Texas | 48335 | 522 | 17 |
913491 | 913491 | 2021-01-09 | Mitchell | Texas | 48335 | 522 | 17 |
903640 | 903640 | 2021-01-06 | Crockett | Texas | 48105 | 522 | 10 |
881024 | 881024 | 2020-12-30 | Martin | Texas | 48317 | 522 | 13 |
877779 | 877779 | 2020-12-29 | Martin | Texas | 48317 | 522 | 13 |
851911 | 851911 | 2020-12-21 | Winkler | Texas | 48495 | 522 | 10 |
790079 | 790079 | 2020-12-02 | Freestone | Texas | 48161 | 522 | 13 |
751237 | 751237 | 2020-11-20 | Panola | Texas | 48365 | 522 | 34 |
718650 | 718650 | 2020-11-10 | Colorado | Texas | 48089 | 522 | 4 |
695908 | 695908 | 2020-11-03 | Austin | Texas | 48015 | 522 | 10 |
696021 | 696021 | 2020-11-03 | Jasper | Texas | 48241 | 522 | 34 |
537155 | 537155 | 2020-09-15 | Jackson | Texas | 48239 | 522 | 15 |
411167 | 411167 | 2020-08-07 | Hood | Texas | 48221 | 522 | 9 |
385376 | 385376 | 2020-07-30 | DeWitt | Texas | 48123 | 522 | 13 |
382158 | 382158 | 2020-07-29 | DeWitt | Texas | 48123 | 522 | 12 |
327786 | 327786 | 2020-07-12 | Liberty | Texas | 48291 | 522 | 3 |
311763 | 311763 | 2020-07-07 | Bastrop | Texas | 48021 | 522 | 6 |
308594 | 308594 | 2020-07-06 | Bastrop | Texas | 48021 | 522 | 6 |
86377 | 86377 | 2020-04-24 | Galveston | Texas | 48167 | 522 | 21 |
69622 | 69622 | 2020-04-18 | Collin | Texas | 48085 | 522 | 13 |
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);