ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 479 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2189968 | 2189968 | 2022-02-06 | Knox | Texas | 48275 | 479 | 22 |
2180079 | 2180079 | 2022-02-03 | Armstrong | Texas | 48011 | 479 | 8 |
2147594 | 2147594 | 2022-01-24 | Culberson | Texas | 48109 | 479 | 13 |
1933009 | 1933009 | 2021-11-19 | Cochran | Texas | 48079 | 479 | 19 |
1686095 | 1686095 | 2021-09-04 | Delta | Texas | 48119 | 479 | 15 |
1540080 | 1540080 | 2021-07-21 | Sutton | Texas | 48435 | 479 | 8 |
1267396 | 1267396 | 2021-04-28 | Sutton | Texas | 48435 | 479 | 8 |
1264149 | 1264149 | 2021-04-27 | Sutton | Texas | 48435 | 479 | 8 |
1260902 | 1260902 | 2021-04-26 | Sutton | Texas | 48435 | 479 | 8 |
1257655 | 1257655 | 2021-04-25 | Sutton | Texas | 48435 | 479 | 8 |
1254408 | 1254408 | 2021-04-24 | Sutton | Texas | 48435 | 479 | 8 |
1251161 | 1251161 | 2021-04-23 | Sutton | Texas | 48435 | 479 | 8 |
1247914 | 1247914 | 2021-04-22 | Sutton | Texas | 48435 | 479 | 8 |
1244667 | 1244667 | 2021-04-21 | Sutton | Texas | 48435 | 479 | 8 |
1241420 | 1241420 | 2021-04-20 | Sutton | Texas | 48435 | 479 | 8 |
1238173 | 1238173 | 2021-04-19 | Sutton | Texas | 48435 | 479 | 8 |
1234926 | 1234926 | 2021-04-18 | Sutton | Texas | 48435 | 479 | 8 |
1231678 | 1231678 | 2021-04-17 | Sutton | Texas | 48435 | 479 | 8 |
1228430 | 1228430 | 2021-04-16 | Sutton | Texas | 48435 | 479 | 8 |
1225182 | 1225182 | 2021-04-15 | Sutton | Texas | 48435 | 479 | 8 |
1221935 | 1221935 | 2021-04-14 | Sutton | Texas | 48435 | 479 | 8 |
1218687 | 1218687 | 2021-04-13 | Sutton | Texas | 48435 | 479 | 8 |
1215439 | 1215439 | 2021-04-12 | Sutton | Texas | 48435 | 479 | 8 |
1212192 | 1212192 | 2021-04-11 | Sutton | Texas | 48435 | 479 | 8 |
1208943 | 1208943 | 2021-04-10 | Sutton | Texas | 48435 | 479 | 8 |
1205510 | 1205510 | 2021-04-09 | Carson | Texas | 48065 | 479 | 14 |
1205695 | 1205695 | 2021-04-09 | Sutton | Texas | 48435 | 479 | 8 |
1101810 | 1101810 | 2021-03-08 | Wheeler | Texas | 48483 | 479 | 10 |
1098564 | 1098564 | 2021-03-07 | Wheeler | Texas | 48483 | 479 | 10 |
1095316 | 1095316 | 2021-03-06 | Wheeler | Texas | 48483 | 479 | 10 |
1092070 | 1092070 | 2021-03-05 | Wheeler | Texas | 48483 | 479 | 10 |
1085579 | 1085579 | 2021-03-03 | Wheeler | Texas | 48483 | 479 | 10 |
1082333 | 1082333 | 2021-03-02 | Wheeler | Texas | 48483 | 479 | 10 |
1017381 | 1017381 | 2021-02-10 | Sabine | Texas | 48403 | 479 | 37 |
1014049 | 1014049 | 2021-02-09 | Hudspeth | Texas | 48229 | 479 | 11 |
936163 | 936163 | 2021-01-16 | Jim Hogg | Texas | 48247 | 479 | 11 |
932846 | 932846 | 2021-01-15 | Crane | Texas | 48103 | 479 | 11 |
933000 | 933000 | 2021-01-15 | San Saba | Texas | 48411 | 479 | 15 |
923173 | 923173 | 2021-01-12 | Hudspeth | Texas | 48229 | 479 | 8 |
855061 | 855061 | 2020-12-22 | Lynn | Texas | 48305 | 479 | 11 |
829041 | 829041 | 2020-12-14 | Hansford | Texas | 48195 | 479 | 12 |
825795 | 825795 | 2020-12-13 | Hansford | Texas | 48195 | 479 | 11 |
822548 | 822548 | 2020-12-12 | Hansford | Texas | 48195 | 479 | 11 |
816103 | 816103 | 2020-12-10 | Leon | Texas | 48289 | 479 | 18 |
725172 | 725172 | 2020-11-12 | Freestone | Texas | 48161 | 479 | 6 |
715538 | 715538 | 2020-11-09 | Nolan | Texas | 48353 | 479 | 7 |
712294 | 712294 | 2020-11-08 | Nolan | Texas | 48353 | 479 | 7 |
709050 | 709050 | 2020-11-07 | Nolan | Texas | 48353 | 479 | 7 |
660452 | 660452 | 2020-10-23 | Upshur | Texas | 48459 | 479 | 12 |
550148 | 550148 | 2020-09-19 | Milam | Texas | 48331 | 479 | 5 |
514530 | 514530 | 2020-09-08 | Limestone | Texas | 48293 | 479 | 8 |
511297 | 511297 | 2020-09-07 | Limestone | Texas | 48293 | 479 | 8 |
508064 | 508064 | 2020-09-06 | Limestone | Texas | 48293 | 479 | 8 |
315094 | 315094 | 2020-07-08 | Nacogdoches | Texas | 48347 | 479 | 29 |
159901 | 159901 | 2020-05-19 | Webb | Texas | 48479 | 479 | 18 |
77981 | 77981 | 2020-04-21 | Galveston | Texas | 48167 | 479 | 20 |
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);