ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
669 rows where fips = 48311 and state = "Texas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
334179 | 334179 | 2020-07-14 | McMullen | Texas | 48311 | 1 | 0 |
337374 | 337374 | 2020-07-15 | McMullen | Texas | 48311 | 1 | 0 |
340570 | 340570 | 2020-07-16 | McMullen | Texas | 48311 | 1 | 0 |
343769 | 343769 | 2020-07-17 | McMullen | Texas | 48311 | 1 | 0 |
346969 | 346969 | 2020-07-18 | McMullen | Texas | 48311 | 1 | 0 |
350169 | 350169 | 2020-07-19 | McMullen | Texas | 48311 | 4 | 0 |
353371 | 353371 | 2020-07-20 | McMullen | Texas | 48311 | 4 | 0 |
356574 | 356574 | 2020-07-21 | McMullen | Texas | 48311 | 4 | 0 |
359779 | 359779 | 2020-07-22 | McMullen | Texas | 48311 | 4 | 0 |
362986 | 362986 | 2020-07-23 | McMullen | Texas | 48311 | 6 | 0 |
366192 | 366192 | 2020-07-24 | McMullen | Texas | 48311 | 6 | 0 |
369401 | 369401 | 2020-07-25 | McMullen | Texas | 48311 | 6 | 0 |
372613 | 372613 | 2020-07-26 | McMullen | Texas | 48311 | 7 | 0 |
375826 | 375826 | 2020-07-27 | McMullen | Texas | 48311 | 7 | 0 |
379042 | 379042 | 2020-07-28 | McMullen | Texas | 48311 | 7 | 0 |
382259 | 382259 | 2020-07-29 | McMullen | Texas | 48311 | 7 | 0 |
385477 | 385477 | 2020-07-30 | McMullen | Texas | 48311 | 7 | 0 |
388694 | 388694 | 2020-07-31 | McMullen | Texas | 48311 | 7 | 0 |
391911 | 391911 | 2020-08-01 | McMullen | Texas | 48311 | 8 | 0 |
395127 | 395127 | 2020-08-02 | McMullen | Texas | 48311 | 8 | 0 |
398343 | 398343 | 2020-08-03 | McMullen | Texas | 48311 | 8 | 0 |
401559 | 401559 | 2020-08-04 | McMullen | Texas | 48311 | 8 | 0 |
404777 | 404777 | 2020-08-05 | McMullen | Texas | 48311 | 8 | 0 |
407997 | 407997 | 2020-08-06 | McMullen | Texas | 48311 | 8 | 0 |
411216 | 411216 | 2020-08-07 | McMullen | Texas | 48311 | 9 | 0 |
414436 | 414436 | 2020-08-08 | McMullen | Texas | 48311 | 9 | 0 |
417657 | 417657 | 2020-08-09 | McMullen | Texas | 48311 | 9 | 0 |
420878 | 420878 | 2020-08-10 | McMullen | Texas | 48311 | 9 | 0 |
424099 | 424099 | 2020-08-11 | McMullen | Texas | 48311 | 9 | 0 |
427323 | 427323 | 2020-08-12 | McMullen | Texas | 48311 | 10 | 0 |
430550 | 430550 | 2020-08-13 | McMullen | Texas | 48311 | 10 | 0 |
433775 | 433775 | 2020-08-14 | McMullen | Texas | 48311 | 10 | 0 |
437001 | 437001 | 2020-08-15 | McMullen | Texas | 48311 | 10 | 0 |
440227 | 440227 | 2020-08-16 | McMullen | Texas | 48311 | 10 | 0 |
443453 | 443453 | 2020-08-17 | McMullen | Texas | 48311 | 10 | 0 |
446680 | 446680 | 2020-08-18 | McMullen | Texas | 48311 | 10 | 0 |
449908 | 449908 | 2020-08-19 | McMullen | Texas | 48311 | 10 | 0 |
453136 | 453136 | 2020-08-20 | McMullen | Texas | 48311 | 10 | 0 |
456364 | 456364 | 2020-08-21 | McMullen | Texas | 48311 | 10 | 0 |
459591 | 459591 | 2020-08-22 | McMullen | Texas | 48311 | 10 | 0 |
462820 | 462820 | 2020-08-23 | McMullen | Texas | 48311 | 11 | 0 |
466049 | 466049 | 2020-08-24 | McMullen | Texas | 48311 | 11 | 0 |
469278 | 469278 | 2020-08-25 | McMullen | Texas | 48311 | 11 | 0 |
472510 | 472510 | 2020-08-26 | McMullen | Texas | 48311 | 11 | 0 |
475743 | 475743 | 2020-08-27 | McMullen | Texas | 48311 | 11 | 0 |
478976 | 478976 | 2020-08-28 | McMullen | Texas | 48311 | 11 | 0 |
482210 | 482210 | 2020-08-29 | McMullen | Texas | 48311 | 11 | 0 |
485445 | 485445 | 2020-08-30 | McMullen | Texas | 48311 | 15 | 0 |
488678 | 488678 | 2020-08-31 | McMullen | Texas | 48311 | 15 | 0 |
491911 | 491911 | 2020-09-01 | McMullen | Texas | 48311 | 15 | 0 |
495145 | 495145 | 2020-09-02 | McMullen | Texas | 48311 | 16 | 0 |
498378 | 498378 | 2020-09-03 | McMullen | Texas | 48311 | 16 | 0 |
501612 | 501612 | 2020-09-04 | McMullen | Texas | 48311 | 18 | 0 |
504846 | 504846 | 2020-09-05 | McMullen | Texas | 48311 | 18 | 0 |
508078 | 508078 | 2020-09-06 | McMullen | Texas | 48311 | 18 | 0 |
511311 | 511311 | 2020-09-07 | McMullen | Texas | 48311 | 18 | 0 |
514544 | 514544 | 2020-09-08 | McMullen | Texas | 48311 | 18 | 0 |
517779 | 517779 | 2020-09-09 | McMullen | Texas | 48311 | 19 | 0 |
521015 | 521015 | 2020-09-10 | McMullen | Texas | 48311 | 19 | 0 |
524251 | 524251 | 2020-09-11 | McMullen | Texas | 48311 | 19 | 0 |
527487 | 527487 | 2020-09-12 | McMullen | Texas | 48311 | 19 | 0 |
530724 | 530724 | 2020-09-13 | McMullen | Texas | 48311 | 19 | 0 |
533959 | 533959 | 2020-09-14 | McMullen | Texas | 48311 | 19 | 0 |
537195 | 537195 | 2020-09-15 | McMullen | Texas | 48311 | 21 | 0 |
540432 | 540432 | 2020-09-16 | McMullen | Texas | 48311 | 21 | 0 |
543668 | 543668 | 2020-09-17 | McMullen | Texas | 48311 | 21 | 0 |
546905 | 546905 | 2020-09-18 | McMullen | Texas | 48311 | 21 | 0 |
550144 | 550144 | 2020-09-19 | McMullen | Texas | 48311 | 21 | 0 |
553383 | 553383 | 2020-09-20 | McMullen | Texas | 48311 | 21 | 0 |
556620 | 556620 | 2020-09-21 | McMullen | Texas | 48311 | 21 | 0 |
559856 | 559856 | 2020-09-22 | McMullen | Texas | 48311 | 21 | 0 |
563095 | 563095 | 2020-09-23 | McMullen | Texas | 48311 | 23 | 0 |
566336 | 566336 | 2020-09-24 | McMullen | Texas | 48311 | 24 | 0 |
569577 | 569577 | 2020-09-25 | McMullen | Texas | 48311 | 24 | 0 |
572819 | 572819 | 2020-09-26 | McMullen | Texas | 48311 | 24 | 1 |
576063 | 576063 | 2020-09-27 | McMullen | Texas | 48311 | 24 | 1 |
579304 | 579304 | 2020-09-28 | McMullen | Texas | 48311 | 24 | 1 |
582543 | 582543 | 2020-09-29 | McMullen | Texas | 48311 | 24 | 1 |
585783 | 585783 | 2020-09-30 | McMullen | Texas | 48311 | 24 | 1 |
589024 | 589024 | 2020-10-01 | McMullen | Texas | 48311 | 24 | 1 |
592264 | 592264 | 2020-10-02 | McMullen | Texas | 48311 | 24 | 1 |
595506 | 595506 | 2020-10-03 | McMullen | Texas | 48311 | 24 | 1 |
598749 | 598749 | 2020-10-04 | McMullen | Texas | 48311 | 24 | 1 |
601992 | 601992 | 2020-10-05 | McMullen | Texas | 48311 | 24 | 1 |
605234 | 605234 | 2020-10-06 | McMullen | Texas | 48311 | 24 | 1 |
608477 | 608477 | 2020-10-07 | McMullen | Texas | 48311 | 24 | 1 |
611719 | 611719 | 2020-10-08 | McMullen | Texas | 48311 | 24 | 1 |
614960 | 614960 | 2020-10-09 | McMullen | Texas | 48311 | 24 | 1 |
618202 | 618202 | 2020-10-10 | McMullen | Texas | 48311 | 24 | 1 |
621445 | 621445 | 2020-10-11 | McMullen | Texas | 48311 | 24 | 1 |
624688 | 624688 | 2020-10-12 | McMullen | Texas | 48311 | 24 | 1 |
627931 | 627931 | 2020-10-13 | McMullen | Texas | 48311 | 24 | 1 |
631175 | 631175 | 2020-10-14 | McMullen | Texas | 48311 | 24 | 1 |
634420 | 634420 | 2020-10-15 | McMullen | Texas | 48311 | 24 | 1 |
637665 | 637665 | 2020-10-16 | McMullen | Texas | 48311 | 24 | 1 |
640912 | 640912 | 2020-10-17 | McMullen | Texas | 48311 | 24 | 1 |
644160 | 644160 | 2020-10-18 | McMullen | Texas | 48311 | 24 | 1 |
647406 | 647406 | 2020-10-19 | McMullen | Texas | 48311 | 24 | 1 |
650650 | 650650 | 2020-10-20 | McMullen | Texas | 48311 | 24 | 1 |
653895 | 653895 | 2020-10-21 | McMullen | Texas | 48311 | 24 | 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);