ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jefferson" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
627893 | 627893 | 2020-10-13 | Jefferson | Texas | 48245 | 7855 | 144 |
624651 | 624651 | 2020-10-12 | Jefferson | Texas | 48245 | 7775 | 142 |
621408 | 621408 | 2020-10-11 | Jefferson | Texas | 48245 | 7775 | 142 |
618165 | 618165 | 2020-10-10 | Jefferson | Texas | 48245 | 7775 | 142 |
614923 | 614923 | 2020-10-09 | Jefferson | Texas | 48245 | 7763 | 140 |
611682 | 611682 | 2020-10-08 | Jefferson | Texas | 48245 | 7753 | 138 |
608440 | 608440 | 2020-10-07 | Jefferson | Texas | 48245 | 7708 | 138 |
605197 | 605197 | 2020-10-06 | Jefferson | Texas | 48245 | 7669 | 137 |
601955 | 601955 | 2020-10-05 | Jefferson | Texas | 48245 | 7585 | 136 |
598712 | 598712 | 2020-10-04 | Jefferson | Texas | 48245 | 7585 | 136 |
595469 | 595469 | 2020-10-03 | Jefferson | Texas | 48245 | 7585 | 136 |
592227 | 592227 | 2020-10-02 | Jefferson | Texas | 48245 | 7560 | 135 |
588987 | 588987 | 2020-10-01 | Jefferson | Texas | 48245 | 7540 | 134 |
585746 | 585746 | 2020-09-30 | Jefferson | Texas | 48245 | 7511 | 134 |
582506 | 582506 | 2020-09-29 | Jefferson | Texas | 48245 | 7459 | 133 |
579267 | 579267 | 2020-09-28 | Jefferson | Texas | 48245 | 7402 | 133 |
576026 | 576026 | 2020-09-27 | Jefferson | Texas | 48245 | 7402 | 133 |
572782 | 572782 | 2020-09-26 | Jefferson | Texas | 48245 | 7402 | 133 |
569540 | 569540 | 2020-09-25 | Jefferson | Texas | 48245 | 7325 | 132 |
566299 | 566299 | 2020-09-24 | Jefferson | Texas | 48245 | 7325 | 132 |
563058 | 563058 | 2020-09-23 | Jefferson | Texas | 48245 | 7293 | 132 |
559819 | 559819 | 2020-09-22 | Jefferson | Texas | 48245 | 7241 | 129 |
556583 | 556583 | 2020-09-21 | Jefferson | Texas | 48245 | 7182 | 128 |
553346 | 553346 | 2020-09-20 | Jefferson | Texas | 48245 | 7182 | 128 |
550107 | 550107 | 2020-09-19 | Jefferson | Texas | 48245 | 7152 | 128 |
546868 | 546868 | 2020-09-18 | Jefferson | Texas | 48245 | 7109 | 126 |
543631 | 543631 | 2020-09-17 | Jefferson | Texas | 48245 | 7061 | 126 |
540395 | 540395 | 2020-09-16 | Jefferson | Texas | 48245 | 7028 | 125 |
537158 | 537158 | 2020-09-15 | Jefferson | Texas | 48245 | 6995 | 125 |
533922 | 533922 | 2020-09-14 | Jefferson | Texas | 48245 | 6956 | 125 |
530687 | 530687 | 2020-09-13 | Jefferson | Texas | 48245 | 6956 | 125 |
527450 | 527450 | 2020-09-12 | Jefferson | Texas | 48245 | 6951 | 125 |
524214 | 524214 | 2020-09-11 | Jefferson | Texas | 48245 | 6912 | 122 |
520978 | 520978 | 2020-09-10 | Jefferson | Texas | 48245 | 6841 | 114 |
517742 | 517742 | 2020-09-09 | Jefferson | Texas | 48245 | 6841 | 114 |
514507 | 514507 | 2020-09-08 | Jefferson | Texas | 48245 | 6811 | 113 |
511274 | 511274 | 2020-09-07 | Jefferson | Texas | 48245 | 6772 | 112 |
508041 | 508041 | 2020-09-06 | Jefferson | Texas | 48245 | 6772 | 112 |
504809 | 504809 | 2020-09-05 | Jefferson | Texas | 48245 | 6772 | 111 |
501575 | 501575 | 2020-09-04 | Jefferson | Texas | 48245 | 6722 | 109 |
498341 | 498341 | 2020-09-03 | Jefferson | Texas | 48245 | 6680 | 107 |
495108 | 495108 | 2020-09-02 | Jefferson | Texas | 48245 | 6659 | 107 |
491874 | 491874 | 2020-09-01 | Jefferson | Texas | 48245 | 6642 | 107 |
488641 | 488641 | 2020-08-31 | Jefferson | Texas | 48245 | 6615 | 107 |
485408 | 485408 | 2020-08-30 | Jefferson | Texas | 48245 | 6615 | 107 |
482173 | 482173 | 2020-08-29 | Jefferson | Texas | 48245 | 6610 | 106 |
478939 | 478939 | 2020-08-28 | Jefferson | Texas | 48245 | 6590 | 106 |
475706 | 475706 | 2020-08-27 | Jefferson | Texas | 48245 | 6586 | 106 |
472473 | 472473 | 2020-08-26 | Jefferson | Texas | 48245 | 6569 | 104 |
469241 | 469241 | 2020-08-25 | Jefferson | Texas | 48245 | 6559 | 104 |
466012 | 466012 | 2020-08-24 | Jefferson | Texas | 48245 | 6499 | 103 |
462783 | 462783 | 2020-08-23 | Jefferson | Texas | 48245 | 6499 | 103 |
459554 | 459554 | 2020-08-22 | Jefferson | Texas | 48245 | 6489 | 101 |
456327 | 456327 | 2020-08-21 | Jefferson | Texas | 48245 | 6456 | 98 |
453099 | 453099 | 2020-08-20 | Jefferson | Texas | 48245 | 6388 | 97 |
449871 | 449871 | 2020-08-19 | Jefferson | Texas | 48245 | 6360 | 96 |
446643 | 446643 | 2020-08-18 | Jefferson | Texas | 48245 | 6316 | 96 |
443416 | 443416 | 2020-08-17 | Jefferson | Texas | 48245 | 6247 | 95 |
440190 | 440190 | 2020-08-16 | Jefferson | Texas | 48245 | 6247 | 94 |
436964 | 436964 | 2020-08-15 | Jefferson | Texas | 48245 | 6237 | 92 |
433738 | 433738 | 2020-08-14 | Jefferson | Texas | 48245 | 6165 | 91 |
430513 | 430513 | 2020-08-13 | Jefferson | Texas | 48245 | 6126 | 88 |
427286 | 427286 | 2020-08-12 | Jefferson | Texas | 48245 | 6067 | 88 |
424062 | 424062 | 2020-08-11 | Jefferson | Texas | 48245 | 5977 | 84 |
420841 | 420841 | 2020-08-10 | Jefferson | Texas | 48245 | 5880 | 84 |
417620 | 417620 | 2020-08-09 | Jefferson | Texas | 48245 | 5880 | 84 |
414399 | 414399 | 2020-08-08 | Jefferson | Texas | 48245 | 5870 | 80 |
411179 | 411179 | 2020-08-07 | Jefferson | Texas | 48245 | 5828 | 77 |
407960 | 407960 | 2020-08-06 | Jefferson | Texas | 48245 | 5771 | 76 |
404740 | 404740 | 2020-08-05 | Jefferson | Texas | 48245 | 5721 | 74 |
401522 | 401522 | 2020-08-04 | Jefferson | Texas | 48245 | 5609 | 73 |
398306 | 398306 | 2020-08-03 | Jefferson | Texas | 48245 | 5506 | 73 |
395090 | 395090 | 2020-08-02 | Jefferson | Texas | 48245 | 5506 | 67 |
391874 | 391874 | 2020-08-01 | Jefferson | Texas | 48245 | 5491 | 67 |
388657 | 388657 | 2020-07-31 | Jefferson | Texas | 48245 | 5431 | 65 |
385440 | 385440 | 2020-07-30 | Jefferson | Texas | 48245 | 5369 | 64 |
382222 | 382222 | 2020-07-29 | Jefferson | Texas | 48245 | 5321 | 61 |
379005 | 379005 | 2020-07-28 | Jefferson | Texas | 48245 | 5220 | 58 |
375789 | 375789 | 2020-07-27 | Jefferson | Texas | 48245 | 5064 | 57 |
372576 | 372576 | 2020-07-26 | Jefferson | Texas | 48245 | 4895 | 57 |
369364 | 369364 | 2020-07-25 | Jefferson | Texas | 48245 | 4880 | 57 |
366155 | 366155 | 2020-07-24 | Jefferson | Texas | 48245 | 4772 | 55 |
362949 | 362949 | 2020-07-23 | Jefferson | Texas | 48245 | 4697 | 49 |
359742 | 359742 | 2020-07-22 | Jefferson | Texas | 48245 | 4622 | 49 |
356537 | 356537 | 2020-07-21 | Jefferson | Texas | 48245 | 4493 | 48 |
353334 | 353334 | 2020-07-20 | Jefferson | Texas | 48245 | 4260 | 47 |
350132 | 350132 | 2020-07-19 | Jefferson | Texas | 48245 | 4260 | 47 |
346932 | 346932 | 2020-07-18 | Jefferson | Texas | 48245 | 4255 | 47 |
343732 | 343732 | 2020-07-17 | Jefferson | Texas | 48245 | 4148 | 47 |
340533 | 340533 | 2020-07-16 | Jefferson | Texas | 48245 | 4031 | 44 |
337337 | 337337 | 2020-07-15 | Jefferson | Texas | 48245 | 3868 | 43 |
334142 | 334142 | 2020-07-14 | Jefferson | Texas | 48245 | 3665 | 42 |
330951 | 330951 | 2020-07-13 | Jefferson | Texas | 48245 | 3548 | 39 |
327765 | 327765 | 2020-07-12 | Jefferson | Texas | 48245 | 3548 | 39 |
324580 | 324580 | 2020-07-11 | Jefferson | Texas | 48245 | 3532 | 39 |
321399 | 321399 | 2020-07-10 | Jefferson | Texas | 48245 | 3438 | 37 |
318220 | 318220 | 2020-07-09 | Jefferson | Texas | 48245 | 3235 | 36 |
315047 | 315047 | 2020-07-08 | Jefferson | Texas | 48245 | 3094 | 36 |
311873 | 311873 | 2020-07-07 | Jefferson | Texas | 48245 | 2959 | 36 |
308704 | 308704 | 2020-07-06 | Jefferson | Texas | 48245 | 2727 | 35 |
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);