ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where cases = 162 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2242015 | 2242015 | 2022-02-22 | Loving | Texas | 48301 | 162 | 0 |
2203008 | 2203008 | 2022-02-10 | McMullen | Texas | 48311 | 162 | 8 |
2199754 | 2199754 | 2022-02-09 | McMullen | Texas | 48311 | 162 | 8 |
2196500 | 2196500 | 2022-02-08 | McMullen | Texas | 48311 | 162 | 8 |
2193246 | 2193246 | 2022-02-07 | McMullen | Texas | 48311 | 162 | 8 |
2189992 | 2189992 | 2022-02-06 | McMullen | Texas | 48311 | 162 | 8 |
1780466 | 1780466 | 2021-10-03 | Sterling | Texas | 48431 | 162 | 5 |
1777216 | 1777216 | 2021-10-02 | Sterling | Texas | 48431 | 162 | 5 |
1773966 | 1773966 | 2021-10-01 | Sterling | Texas | 48431 | 162 | 5 |
1770716 | 1770716 | 2021-09-30 | Sterling | Texas | 48431 | 162 | 5 |
1767467 | 1767467 | 2021-09-29 | Sterling | Texas | 48431 | 162 | 5 |
1082302 | 1082302 | 2021-03-02 | Sherman | Texas | 48421 | 162 | 12 |
1079056 | 1079056 | 2021-03-01 | Sherman | Texas | 48421 | 162 | 12 |
1075811 | 1075811 | 2021-02-28 | Sherman | Texas | 48421 | 162 | 12 |
1072565 | 1072565 | 2021-02-27 | Sherman | Texas | 48421 | 162 | 12 |
1069319 | 1069319 | 2021-02-26 | Sherman | Texas | 48421 | 162 | 12 |
1066074 | 1066074 | 2021-02-25 | Sherman | Texas | 48421 | 162 | 12 |
1062829 | 1062829 | 2021-02-24 | Sherman | Texas | 48421 | 162 | 12 |
1059584 | 1059584 | 2021-02-23 | Sherman | Texas | 48421 | 162 | 12 |
919993 | 919993 | 2021-01-11 | Oldham | Texas | 48359 | 162 | 2 |
916748 | 916748 | 2021-01-10 | Oldham | Texas | 48359 | 162 | 2 |
913503 | 913503 | 2021-01-09 | Oldham | Texas | 48359 | 162 | 2 |
907042 | 907042 | 2021-01-07 | Shackelford | Texas | 48417 | 162 | 1 |
900480 | 900480 | 2021-01-05 | Knox | Texas | 48275 | 162 | 12 |
864807 | 864807 | 2020-12-25 | Menard | Texas | 48327 | 162 | 3 |
806263 | 806263 | 2020-12-07 | Cochran | Texas | 48079 | 162 | 5 |
803018 | 803018 | 2020-12-06 | Cochran | Texas | 48079 | 162 | 5 |
799773 | 799773 | 2020-12-05 | Cochran | Texas | 48079 | 162 | 5 |
786829 | 786829 | 2020-12-01 | Fisher | Texas | 48151 | 162 | 4 |
786838 | 786838 | 2020-12-01 | Garza | Texas | 48169 | 162 | 14 |
760844 | 760844 | 2020-11-23 | Crane | Texas | 48103 | 162 | 7 |
757739 | 757739 | 2020-11-22 | Reagan | Texas | 48383 | 162 | 6 |
754492 | 754492 | 2020-11-21 | Reagan | Texas | 48383 | 162 | 6 |
747964 | 747964 | 2020-11-19 | Martin | Texas | 48317 | 162 | 7 |
741369 | 741369 | 2020-11-17 | Crosby | Texas | 48107 | 162 | 13 |
715481 | 715481 | 2020-11-09 | Jack | Texas | 48237 | 162 | 3 |
712237 | 712237 | 2020-11-08 | Jack | Texas | 48237 | 162 | 3 |
708993 | 708993 | 2020-11-07 | Jack | Texas | 48237 | 162 | 3 |
705749 | 705749 | 2020-11-06 | Jack | Texas | 48237 | 162 | 3 |
696118 | 696118 | 2020-11-03 | Swisher | Texas | 48437 | 162 | 5 |
682942 | 682942 | 2020-10-30 | Blanco | Texas | 48031 | 162 | 6 |
679699 | 679699 | 2020-10-29 | Blanco | Texas | 48031 | 162 | 6 |
679872 | 679872 | 2020-10-29 | Rains | Texas | 48379 | 162 | 5 |
676456 | 676456 | 2020-10-28 | Blanco | Texas | 48031 | 162 | 6 |
660347 | 660347 | 2020-10-23 | Jim Hogg | Texas | 48247 | 162 | 5 |
657103 | 657103 | 2020-10-22 | Jim Hogg | Texas | 48247 | 162 | 5 |
653858 | 653858 | 2020-10-21 | Jim Hogg | Texas | 48247 | 162 | 5 |
637607 | 637607 | 2020-10-16 | Hartley | Texas | 48205 | 162 | 2 |
637658 | 637658 | 2020-10-16 | Marion | Texas | 48315 | 162 | 14 |
634413 | 634413 | 2020-10-15 | Marion | Texas | 48315 | 162 | 14 |
631168 | 631168 | 2020-10-14 | Marion | Texas | 48315 | 162 | 14 |
608414 | 608414 | 2020-10-07 | Hamilton | Texas | 48193 | 162 | 4 |
582575 | 582575 | 2020-09-29 | Red River | Texas | 48387 | 162 | 14 |
579336 | 579336 | 2020-09-28 | Red River | Texas | 48387 | 162 | 14 |
576095 | 576095 | 2020-09-27 | Red River | Texas | 48387 | 162 | 14 |
572851 | 572851 | 2020-09-26 | Red River | Texas | 48387 | 162 | 14 |
514554 | 514554 | 2020-09-08 | Morris | Texas | 48343 | 162 | 3 |
501505 | 501505 | 2020-09-04 | Crockett | Texas | 48105 | 162 | 6 |
498271 | 498271 | 2020-09-03 | Crockett | Texas | 48105 | 162 | 6 |
495038 | 495038 | 2020-09-02 | Crockett | Texas | 48105 | 162 | 6 |
491804 | 491804 | 2020-09-01 | Crockett | Texas | 48105 | 162 | 6 |
488571 | 488571 | 2020-08-31 | Crockett | Texas | 48105 | 162 | 6 |
488692 | 488692 | 2020-08-31 | Newton | Texas | 48351 | 162 | 6 |
485338 | 485338 | 2020-08-30 | Crockett | Texas | 48105 | 162 | 6 |
485459 | 485459 | 2020-08-30 | Newton | Texas | 48351 | 162 | 6 |
482103 | 482103 | 2020-08-29 | Crockett | Texas | 48105 | 162 | 6 |
482224 | 482224 | 2020-08-29 | Newton | Texas | 48351 | 162 | 6 |
478869 | 478869 | 2020-08-28 | Crockett | Texas | 48105 | 162 | 5 |
478990 | 478990 | 2020-08-28 | Newton | Texas | 48351 | 162 | 6 |
475636 | 475636 | 2020-08-27 | Crockett | Texas | 48105 | 162 | 5 |
475757 | 475757 | 2020-08-27 | Newton | Texas | 48351 | 162 | 6 |
472524 | 472524 | 2020-08-26 | Newton | Texas | 48351 | 162 | 6 |
469292 | 469292 | 2020-08-25 | Newton | Texas | 48351 | 162 | 6 |
466063 | 466063 | 2020-08-24 | Newton | Texas | 48351 | 162 | 6 |
462834 | 462834 | 2020-08-23 | Newton | Texas | 48351 | 162 | 6 |
459605 | 459605 | 2020-08-22 | Newton | Texas | 48351 | 162 | 6 |
456348 | 456348 | 2020-08-21 | Leon | Texas | 48289 | 162 | 4 |
456378 | 456378 | 2020-08-21 | Newton | Texas | 48351 | 162 | 6 |
433673 | 433673 | 2020-08-14 | Dawson | Texas | 48115 | 162 | 5 |
430616 | 430616 | 2020-08-13 | Trinity | Texas | 48455 | 162 | 4 |
424020 | 424020 | 2020-08-11 | Freestone | Texas | 48161 | 162 | 0 |
420736 | 420736 | 2020-08-10 | Bosque | Texas | 48035 | 162 | 2 |
404622 | 404622 | 2020-08-05 | Aransas | Texas | 48007 | 162 | 12 |
404731 | 404731 | 2020-08-05 | Howard | Texas | 48227 | 162 | 3 |
359641 | 359641 | 2020-07-22 | Brewster | Texas | 48043 | 162 | 1 |
356436 | 356436 | 2020-07-21 | Brewster | Texas | 48043 | 162 | 1 |
343641 | 343641 | 2020-07-17 | Camp | Texas | 48063 | 162 | 2 |
321301 | 321301 | 2020-07-10 | Brown | Texas | 48049 | 162 | 13 |
318123 | 318123 | 2020-07-09 | Brown | Texas | 48049 | 162 | 13 |
318208 | 318208 | 2020-07-09 | Hood | Texas | 48221 | 162 | 5 |
292883 | 292883 | 2020-07-01 | Houston | Texas | 48225 | 162 | 0 |
233433 | 233433 | 2020-06-12 | Hunt | Texas | 48231 | 162 | 5 |
205698 | 205698 | 2020-06-03 | Victoria | Texas | 48469 | 162 | 7 |
190179 | 190179 | 2020-05-29 | Deaf Smith | Texas | 48117 | 162 | 13 |
159856 | 159856 | 2020-05-19 | Panola | Texas | 48365 | 162 | 16 |
156833 | 156833 | 2020-05-18 | Panola | Texas | 48365 | 162 | 15 |
153816 | 153816 | 2020-05-17 | Panola | Texas | 48365 | 162 | 15 |
114841 | 114841 | 2020-05-04 | Coryell | Texas | 48099 | 162 | 2 |
111959 | 111959 | 2020-05-03 | Coryell | Texas | 48099 | 162 | 2 |
80840 | 80840 | 2020-04-22 | Moore | Texas | 48341 | 162 | 2 |
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);