ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
148 rows where cases = 49 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 |
---|---|---|---|---|---|---|---|
2102152 | 2102152 | 2022-01-10 | Loving | Texas | 48301 | 49 | 0 |
945973 | 945973 | 2021-01-19 | Roberts | Texas | 48393 | 49 | 1 |
845335 | 845335 | 2020-12-19 | McMullen | Texas | 48311 | 49 | 1 |
790178 | 790178 | 2020-12-02 | Oldham | Texas | 48359 | 49 | 2 |
773834 | 773834 | 2020-11-27 | Delta | Texas | 48119 | 49 | 2 |
770589 | 770589 | 2020-11-26 | Delta | Texas | 48119 | 49 | 2 |
764246 | 764246 | 2020-11-24 | Shackelford | Texas | 48417 | 49 | 0 |
747859 | 747859 | 2020-11-19 | Cottle | Texas | 48101 | 49 | 4 |
738081 | 738081 | 2020-11-16 | Baylor | Texas | 48023 | 49 | 4 |
734837 | 734837 | 2020-11-15 | Baylor | Texas | 48023 | 49 | 4 |
731591 | 731591 | 2020-11-14 | Baylor | Texas | 48023 | 49 | 4 |
657142 | 657142 | 2020-10-22 | Menard | Texas | 48327 | 49 | 0 |
653897 | 653897 | 2020-10-21 | Menard | Texas | 48327 | 49 | 0 |
647278 | 647278 | 2020-10-19 | Carson | Texas | 48065 | 49 | 0 |
644032 | 644032 | 2020-10-18 | Carson | Texas | 48065 | 49 | 0 |
640784 | 640784 | 2020-10-17 | Carson | Texas | 48065 | 49 | 0 |
631113 | 631113 | 2020-10-14 | Hardeman | Texas | 48197 | 49 | 1 |
582498 | 582498 | 2020-09-29 | Hudspeth | Texas | 48229 | 49 | 3 |
579207 | 579207 | 2020-09-28 | Dickens | Texas | 48125 | 49 | 2 |
575966 | 575966 | 2020-09-27 | Dickens | Texas | 48125 | 49 | 2 |
572722 | 572722 | 2020-09-26 | Dickens | Texas | 48125 | 49 | 2 |
559736 | 559736 | 2020-09-22 | Cochran | Texas | 48079 | 49 | 1 |
546785 | 546785 | 2020-09-18 | Cochran | Texas | 48079 | 49 | 1 |
520896 | 520896 | 2020-09-10 | Coke | Texas | 48081 | 49 | 3 |
517660 | 517660 | 2020-09-09 | Coke | Texas | 48081 | 49 | 3 |
514425 | 514425 | 2020-09-08 | Coke | Texas | 48081 | 49 | 3 |
511192 | 511192 | 2020-09-07 | Coke | Texas | 48081 | 49 | 3 |
507959 | 507959 | 2020-09-06 | Coke | Texas | 48081 | 49 | 3 |
504727 | 504727 | 2020-09-05 | Coke | Texas | 48081 | 49 | 3 |
501493 | 501493 | 2020-09-04 | Coke | Texas | 48081 | 49 | 3 |
498259 | 498259 | 2020-09-03 | Coke | Texas | 48081 | 49 | 3 |
495026 | 495026 | 2020-09-02 | Coke | Texas | 48081 | 49 | 3 |
491792 | 491792 | 2020-09-01 | Coke | Texas | 48081 | 49 | 3 |
488524 | 488524 | 2020-08-31 | Archer | Texas | 48009 | 49 | 0 |
488559 | 488559 | 2020-08-31 | Coke | Texas | 48081 | 49 | 3 |
485291 | 485291 | 2020-08-30 | Archer | Texas | 48009 | 49 | 0 |
485326 | 485326 | 2020-08-30 | Coke | Texas | 48081 | 49 | 3 |
482056 | 482056 | 2020-08-29 | Archer | Texas | 48009 | 49 | 0 |
472537 | 472537 | 2020-08-26 | Presidio | Texas | 48377 | 49 | 4 |
469305 | 469305 | 2020-08-25 | Presidio | Texas | 48377 | 49 | 4 |
469327 | 469327 | 2020-08-25 | Sherman | Texas | 48421 | 49 | 0 |
466076 | 466076 | 2020-08-24 | Presidio | Texas | 48377 | 49 | 4 |
462847 | 462847 | 2020-08-23 | Presidio | Texas | 48377 | 49 | 4 |
459618 | 459618 | 2020-08-22 | Presidio | Texas | 48377 | 49 | 4 |
456391 | 456391 | 2020-08-21 | Presidio | Texas | 48377 | 49 | 4 |
456413 | 456413 | 2020-08-21 | Sherman | Texas | 48421 | 49 | 0 |
449813 | 449813 | 2020-08-19 | Donley | Texas | 48129 | 49 | 1 |
446585 | 446585 | 2020-08-18 | Donley | Texas | 48129 | 49 | 0 |
446707 | 446707 | 2020-08-18 | Presidio | Texas | 48377 | 49 | 4 |
443358 | 443358 | 2020-08-17 | Donley | Texas | 48129 | 49 | 0 |
443480 | 443480 | 2020-08-17 | Presidio | Texas | 48377 | 49 | 4 |
440132 | 440132 | 2020-08-16 | Donley | Texas | 48129 | 49 | 0 |
440254 | 440254 | 2020-08-16 | Presidio | Texas | 48377 | 49 | 4 |
436906 | 436906 | 2020-08-15 | Donley | Texas | 48129 | 49 | 0 |
437028 | 437028 | 2020-08-15 | Presidio | Texas | 48377 | 49 | 4 |
433680 | 433680 | 2020-08-14 | Donley | Texas | 48129 | 49 | 0 |
433802 | 433802 | 2020-08-14 | Presidio | Texas | 48377 | 49 | 4 |
430455 | 430455 | 2020-08-13 | Donley | Texas | 48129 | 49 | 0 |
430577 | 430577 | 2020-08-13 | Presidio | Texas | 48377 | 49 | 3 |
427228 | 427228 | 2020-08-12 | Donley | Texas | 48129 | 49 | 0 |
427376 | 427376 | 2020-08-12 | Stephens | Texas | 48429 | 49 | 3 |
424004 | 424004 | 2020-08-11 | Donley | Texas | 48129 | 49 | 0 |
424152 | 424152 | 2020-08-11 | Stephens | Texas | 48429 | 49 | 3 |
401599 | 401599 | 2020-08-04 | Sabine | Texas | 48403 | 49 | 6 |
388700 | 388700 | 2020-07-31 | Mitchell | Texas | 48335 | 49 | 0 |
388775 | 388775 | 2020-07-31 | Wilbarger | Texas | 48487 | 49 | 1 |
385384 | 385384 | 2020-07-30 | Eastland | Texas | 48133 | 49 | 1 |
385484 | 385484 | 2020-07-30 | Montague | Texas | 48337 | 49 | 1 |
382223 | 382223 | 2020-07-29 | Jim Hogg | Texas | 48247 | 49 | 1 |
382310 | 382310 | 2020-07-29 | Somervell | Texas | 48425 | 49 | 0 |
378980 | 378980 | 2020-07-28 | Hansford | Texas | 48195 | 49 | 2 |
379006 | 379006 | 2020-07-28 | Jim Hogg | Texas | 48247 | 49 | 1 |
366247 | 366247 | 2020-07-24 | Sutton | Texas | 48435 | 49 | 0 |
362923 | 362923 | 2020-07-23 | Hamilton | Texas | 48193 | 49 | 1 |
359716 | 359716 | 2020-07-22 | Hamilton | Texas | 48193 | 49 | 1 |
356640 | 356640 | 2020-07-21 | Tyler | Texas | 48457 | 49 | 0 |
353401 | 353401 | 2020-07-20 | Reagan | Texas | 48383 | 49 | 1 |
353437 | 353437 | 2020-07-20 | Tyler | Texas | 48457 | 49 | 0 |
350235 | 350235 | 2020-07-19 | Tyler | Texas | 48457 | 49 | 0 |
343673 | 343673 | 2020-07-17 | Dimmit | Texas | 48127 | 49 | 0 |
340493 | 340493 | 2020-07-16 | Gaines | Texas | 48165 | 49 | 0 |
340654 | 340654 | 2020-07-16 | Winkler | Texas | 48495 | 49 | 0 |
334036 | 334036 | 2020-07-14 | Blanco | Texas | 48031 | 49 | 1 |
330845 | 330845 | 2020-07-13 | Blanco | Texas | 48031 | 49 | 1 |
327659 | 327659 | 2020-07-12 | Blanco | Texas | 48031 | 49 | 1 |
324474 | 324474 | 2020-07-11 | Blanco | Texas | 48031 | 49 | 1 |
321293 | 321293 | 2020-07-10 | Blanco | Texas | 48031 | 49 | 1 |
321426 | 321426 | 2020-07-10 | Lynn | Texas | 48305 | 49 | 1 |
318103 | 318103 | 2020-07-09 | Aransas | Texas | 48007 | 49 | 0 |
318175 | 318175 | 2020-07-09 | Floyd | Texas | 48153 | 49 | 0 |
318247 | 318247 | 2020-07-09 | Lynn | Texas | 48305 | 49 | 1 |
314942 | 314942 | 2020-07-08 | Blanco | Texas | 48031 | 49 | 1 |
315002 | 315002 | 2020-07-08 | Floyd | Texas | 48153 | 49 | 0 |
315092 | 315092 | 2020-07-08 | Morris | Texas | 48343 | 49 | 0 |
315097 | 315097 | 2020-07-08 | Nolan | Texas | 48353 | 49 | 0 |
311836 | 311836 | 2020-07-07 | Gillespie | Texas | 48171 | 49 | 0 |
311918 | 311918 | 2020-07-07 | Morris | Texas | 48343 | 49 | 0 |
289761 | 289761 | 2020-06-30 | Limestone | Texas | 48293 | 49 | 1 |
273933 | 273933 | 2020-06-25 | Crane | Texas | 48103 | 49 | 7 |
264587 | 264587 | 2020-06-22 | Hill | Texas | 48217 | 49 | 1 |
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);