ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Galveston" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637588 | 637588 | 2020-10-16 | Galveston | Texas | 48167 | 12046 | 166 |
634343 | 634343 | 2020-10-15 | Galveston | Texas | 48167 | 12015 | 166 |
631098 | 631098 | 2020-10-14 | Galveston | Texas | 48167 | 12005 | 166 |
627854 | 627854 | 2020-10-13 | Galveston | Texas | 48167 | 11979 | 166 |
624612 | 624612 | 2020-10-12 | Galveston | Texas | 48167 | 11954 | 165 |
621369 | 621369 | 2020-10-11 | Galveston | Texas | 48167 | 11930 | 165 |
618126 | 618126 | 2020-10-10 | Galveston | Texas | 48167 | 11930 | 165 |
614884 | 614884 | 2020-10-09 | Galveston | Texas | 48167 | 11901 | 165 |
611643 | 611643 | 2020-10-08 | Galveston | Texas | 48167 | 11878 | 165 |
608401 | 608401 | 2020-10-07 | Galveston | Texas | 48167 | 11851 | 165 |
605158 | 605158 | 2020-10-06 | Galveston | Texas | 48167 | 11833 | 164 |
601916 | 601916 | 2020-10-05 | Galveston | Texas | 48167 | 11807 | 164 |
598673 | 598673 | 2020-10-04 | Galveston | Texas | 48167 | 11788 | 164 |
595430 | 595430 | 2020-10-03 | Galveston | Texas | 48167 | 11788 | 163 |
592188 | 592188 | 2020-10-02 | Galveston | Texas | 48167 | 11757 | 160 |
588948 | 588948 | 2020-10-01 | Galveston | Texas | 48167 | 11715 | 159 |
585707 | 585707 | 2020-09-30 | Galveston | Texas | 48167 | 11697 | 159 |
582467 | 582467 | 2020-09-29 | Galveston | Texas | 48167 | 11670 | 158 |
579228 | 579228 | 2020-09-28 | Galveston | Texas | 48167 | 11636 | 158 |
575987 | 575987 | 2020-09-27 | Galveston | Texas | 48167 | 11604 | 158 |
572743 | 572743 | 2020-09-26 | Galveston | Texas | 48167 | 11604 | 158 |
569501 | 569501 | 2020-09-25 | Galveston | Texas | 48167 | 11575 | 154 |
566260 | 566260 | 2020-09-24 | Galveston | Texas | 48167 | 11536 | 154 |
563019 | 563019 | 2020-09-23 | Galveston | Texas | 48167 | 11519 | 153 |
559780 | 559780 | 2020-09-22 | Galveston | Texas | 48167 | 11497 | 153 |
556544 | 556544 | 2020-09-21 | Galveston | Texas | 48167 | 11473 | 153 |
553307 | 553307 | 2020-09-20 | Galveston | Texas | 48167 | 11450 | 153 |
550068 | 550068 | 2020-09-19 | Galveston | Texas | 48167 | 11450 | 153 |
546829 | 546829 | 2020-09-18 | Galveston | Texas | 48167 | 11402 | 153 |
543592 | 543592 | 2020-09-17 | Galveston | Texas | 48167 | 11402 | 153 |
540356 | 540356 | 2020-09-16 | Galveston | Texas | 48167 | 11360 | 152 |
537119 | 537119 | 2020-09-15 | Galveston | Texas | 48167 | 11337 | 151 |
533883 | 533883 | 2020-09-14 | Galveston | Texas | 48167 | 11301 | 151 |
530648 | 530648 | 2020-09-13 | Galveston | Texas | 48167 | 11280 | 151 |
527411 | 527411 | 2020-09-12 | Galveston | Texas | 48167 | 11280 | 150 |
524175 | 524175 | 2020-09-11 | Galveston | Texas | 48167 | 11249 | 148 |
520939 | 520939 | 2020-09-10 | Galveston | Texas | 48167 | 11177 | 147 |
517703 | 517703 | 2020-09-09 | Galveston | Texas | 48167 | 11101 | 147 |
514468 | 514468 | 2020-09-08 | Galveston | Texas | 48167 | 11007 | 145 |
511235 | 511235 | 2020-09-07 | Galveston | Texas | 48167 | 10808 | 144 |
508002 | 508002 | 2020-09-06 | Galveston | Texas | 48167 | 10808 | 144 |
504770 | 504770 | 2020-09-05 | Galveston | Texas | 48167 | 10808 | 144 |
501536 | 501536 | 2020-09-04 | Galveston | Texas | 48167 | 10780 | 143 |
498302 | 498302 | 2020-09-03 | Galveston | Texas | 48167 | 10715 | 143 |
495069 | 495069 | 2020-09-02 | Galveston | Texas | 48167 | 10646 | 142 |
491835 | 491835 | 2020-09-01 | Galveston | Texas | 48167 | 10613 | 140 |
488602 | 488602 | 2020-08-31 | Galveston | Texas | 48167 | 10575 | 140 |
485369 | 485369 | 2020-08-30 | Galveston | Texas | 48167 | 10543 | 140 |
482134 | 482134 | 2020-08-29 | Galveston | Texas | 48167 | 10543 | 137 |
478900 | 478900 | 2020-08-28 | Galveston | Texas | 48167 | 10509 | 137 |
475667 | 475667 | 2020-08-27 | Galveston | Texas | 48167 | 10430 | 136 |
472434 | 472434 | 2020-08-26 | Galveston | Texas | 48167 | 10430 | 135 |
469202 | 469202 | 2020-08-25 | Galveston | Texas | 48167 | 10430 | 135 |
465973 | 465973 | 2020-08-24 | Galveston | Texas | 48167 | 10400 | 132 |
462744 | 462744 | 2020-08-23 | Galveston | Texas | 48167 | 10350 | 132 |
459515 | 459515 | 2020-08-22 | Galveston | Texas | 48167 | 10350 | 131 |
456288 | 456288 | 2020-08-21 | Galveston | Texas | 48167 | 10308 | 130 |
453060 | 453060 | 2020-08-20 | Galveston | Texas | 48167 | 10283 | 129 |
449832 | 449832 | 2020-08-19 | Galveston | Texas | 48167 | 10212 | 128 |
446604 | 446604 | 2020-08-18 | Galveston | Texas | 48167 | 10135 | 126 |
443377 | 443377 | 2020-08-17 | Galveston | Texas | 48167 | 10033 | 125 |
440151 | 440151 | 2020-08-16 | Galveston | Texas | 48167 | 9937 | 125 |
436925 | 436925 | 2020-08-15 | Galveston | Texas | 48167 | 9937 | 123 |
433699 | 433699 | 2020-08-14 | Galveston | Texas | 48167 | 9888 | 122 |
430474 | 430474 | 2020-08-13 | Galveston | Texas | 48167 | 9800 | 117 |
427247 | 427247 | 2020-08-12 | Galveston | Texas | 48167 | 9707 | 116 |
424023 | 424023 | 2020-08-11 | Galveston | Texas | 48167 | 9605 | 114 |
420802 | 420802 | 2020-08-10 | Galveston | Texas | 48167 | 9514 | 113 |
417581 | 417581 | 2020-08-09 | Galveston | Texas | 48167 | 9376 | 113 |
414360 | 414360 | 2020-08-08 | Galveston | Texas | 48167 | 9376 | 113 |
411140 | 411140 | 2020-08-07 | Galveston | Texas | 48167 | 9291 | 111 |
407921 | 407921 | 2020-08-06 | Galveston | Texas | 48167 | 9230 | 110 |
404701 | 404701 | 2020-08-05 | Galveston | Texas | 48167 | 9168 | 106 |
401483 | 401483 | 2020-08-04 | Galveston | Texas | 48167 | 9106 | 106 |
398267 | 398267 | 2020-08-03 | Galveston | Texas | 48167 | 8999 | 103 |
395051 | 395051 | 2020-08-02 | Galveston | Texas | 48167 | 8825 | 97 |
391835 | 391835 | 2020-08-01 | Galveston | Texas | 48167 | 8825 | 97 |
388618 | 388618 | 2020-07-31 | Galveston | Texas | 48167 | 8721 | 95 |
385401 | 385401 | 2020-07-30 | Galveston | Texas | 48167 | 8605 | 92 |
382183 | 382183 | 2020-07-29 | Galveston | Texas | 48167 | 8494 | 92 |
378966 | 378966 | 2020-07-28 | Galveston | Texas | 48167 | 8367 | 90 |
375750 | 375750 | 2020-07-27 | Galveston | Texas | 48167 | 8205 | 89 |
372537 | 372537 | 2020-07-26 | Galveston | Texas | 48167 | 8046 | 68 |
369325 | 369325 | 2020-07-25 | Galveston | Texas | 48167 | 8046 | 68 |
366116 | 366116 | 2020-07-24 | Galveston | Texas | 48167 | 7914 | 68 |
362910 | 362910 | 2020-07-23 | Galveston | Texas | 48167 | 7794 | 68 |
359703 | 359703 | 2020-07-22 | Galveston | Texas | 48167 | 7663 | 66 |
356498 | 356498 | 2020-07-21 | Galveston | Texas | 48167 | 7479 | 66 |
353295 | 353295 | 2020-07-20 | Galveston | Texas | 48167 | 7354 | 65 |
350093 | 350093 | 2020-07-19 | Galveston | Texas | 48167 | 7125 | 65 |
346893 | 346893 | 2020-07-18 | Galveston | Texas | 48167 | 7125 | 58 |
343693 | 343693 | 2020-07-17 | Galveston | Texas | 48167 | 6911 | 58 |
340494 | 340494 | 2020-07-16 | Galveston | Texas | 48167 | 6627 | 58 |
337298 | 337298 | 2020-07-15 | Galveston | Texas | 48167 | 6452 | 58 |
334103 | 334103 | 2020-07-14 | Galveston | Texas | 48167 | 6307 | 54 |
330912 | 330912 | 2020-07-13 | Galveston | Texas | 48167 | 6201 | 54 |
327726 | 327726 | 2020-07-12 | Galveston | Texas | 48167 | 5873 | 54 |
324541 | 324541 | 2020-07-11 | Galveston | Texas | 48167 | 5873 | 54 |
321360 | 321360 | 2020-07-10 | Galveston | Texas | 48167 | 5630 | 50 |
318181 | 318181 | 2020-07-09 | Galveston | Texas | 48167 | 5320 | 50 |
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);