ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48167 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 378 ✖
- 0 22
- 40 20
- 169 13
- 849 11
- 448 10
- 852 10
- 707 9
- 851 9
- 38 8
- 28 7
- 31 7
- 32 7
- 153 7
- 166 7
- 443 7
- 459 7
- 165 6
- 397 6
- 722 6
- 840 6
- 29 5
- 37 5
- 171 5
- 180 5
- 389 5
- 400 5
- 417 5
- 423 5
- 456 5
- 692 5
- 704 5
- 729 5
- 46 4
- 50 4
- 54 4
- 58 4
- 68 4
- 158 4
- 168 4
- 211 4
- 392 4
- 415 4
- 422 4
- 469 4
- 697 4
- 701 4
- 712 4
- 717 4
- 725 4
- 734 4
- 818 4
- 831 4
- 842 4
- 844 4
- 846 4
- 853 4
- 1 3
- 8 3
- 21 3
- 24 3
- 113 3
- 140 3
- 144 3
- 151 3
- 164 3
- 174 3
- 178 3
- 195 3
- 196 3
- 221 3
- 248 3
- 301 3
- 322 3
- 406 3
- 414 3
- 418 3
- 430 3
- 439 3
- 447 3
- 476 3
- 705 3
- 728 3
- 731 3
- 797 3
- 812 3
- 825 3
- 5 2
- 14 2
- 22 2
- 30 2
- 65 2
- 66 2
- 92 2
- 97 2
- 106 2
- 125 2
- 132 2
- 135 2
- 137 2
- 143 2
- 147 2
- 154 2
- 159 2
- 170 2
- 172 2
- 177 2
- 179 2
- 188 2
- 198 2
- 200 2
- 205 2
- 231 2
- 268 2
- 290 2
- 296 2
- 331 2
- 337 2
- 341 2
- 357 2
- 382 2
- 383 2
- 384 2
- 386 2
- 404 2
- 411 2
- 424 2
- 429 2
- 433 2
- 435 2
- 436 2
- 440 2
- 441 2
- 452 2
- 453 2
- 489 2
- 523 2
- 637 2
- 674 2
- 676 2
- 680 2
- 690 2
- 696 2
- 698 2
- 699 2
- 708 2
- 749 2
- 769 2
- 780 2
- 786 2
- 815 2
- 830 2
- 832 2
- 838 2
- 841 2
- 847 2
- 7 1
- 9 1
- 11 1
- 13 1
- 15 1
- 17 1
- 19 1
- 20 1
- 26 1
- 27 1
- 45 1
- 89 1
- 90 1
- 95 1
- 103 1
- 110 1
- 111 1
- 114 1
- 116 1
- 117 1
- 122 1
- 123 1
- 126 1
- 128 1
- 129 1
- 130 1
- 131 1
- 136 1
- 142 1
- 145 1
- 148 1
- 150 1
- 152 1
- 160 1
- 163 1
- 176 1
- 181 1
- 183 1
- 185 1
- 186 1
- 187 1
- 189 1
- 191 1
- 193 1
- 194 1
- 204 1
- 214 1
- 216 1
- 217 1
- 220 1
- 222 1
- 225 1
- 226 1
- 227 1
- 230 1
- 234 1
- 237 1
- 241 1
- 245 1
- 251 1
- 257 1
- 258 1
- 264 1
- 267 1
- 270 1
- 275 1
- 280 1
- 285 1
- 287 1
- 292 1
- 298 1
- 304 1
- 309 1
- 313 1
- 317 1
- 320 1
- 321 1
- 324 1
- 327 1
- 328 1
- 332 1
- 335 1
- 336 1
- 344 1
- 347 1
- 354 1
- 355 1
- 356 1
- 361 1
- 367 1
- 369 1
- 370 1
- 372 1
- 373 1
- 374 1
- 377 1
- 381 1
- 385 1
- 391 1
- 393 1
- 394 1
- 398 1
- 399 1
- 401 1
- 402 1
- 403 1
- 407 1
- 409 1
- 410 1
- 412 1
- 419 1
- 425 1
- 427 1
- 432 1
- 442 1
- 444 1
- 445 1
- 446 1
- 450 1
- 451 1
- 455 1
- 463 1
- 465 1
- 466 1
- 470 1
- 473 1
- 474 1
- 478 1
- 483 1
- 491 1
- 494 1
- 495 1
- 496 1
- 503 1
- 507 1
- 511 1
- 520 1
- 526 1
- 531 1
- 532 1
- 534 1
- 537 1
- 541 1
- 542 1
- 547 1
- 554 1
- 563 1
- 567 1
- 575 1
- 577 1
- 579 1
- 586 1
- 589 1
- 592 1
- 597 1
- 603 1
- 606 1
- 607 1
- 611 1
- 617 1
- 623 1
- 631 1
- 634 1
- 640 1
- 644 1
- 646 1
- 650 1
- 652 1
- 655 1
- 657 1
- 658 1
- 664 1
- 665 1
- 668 1
- 671 1
- 679 1
- 683 1
- 685 1
- 688 1
- 700 1
- 703 1
- 709 1
- 710 1
- 711 1
- 713 1
- 715 1
- 719 1
- 720 1
- 721 1
- 735 1
- 738 1
- 741 1
- 743 1
- 748 1
- 753 1
- 756 1
- 759 1
- 762 1
- 771 1
- 775 1
- 778 1
- 784 1
- 787 1
- 788 1
- 790 1
- 794 1
- 800 1
- 801 1
- 806 1
- 810 1
- 811 1
- 820 1
- 821 1
- 823 1
- 824 1
- 827 1
- 833 1
- 836 1
- 837 1
- 839 1
- 843 1
- 845 1
- 850 1
state 1
- Texas 792
fips 1
- 48167 · 792 ✖
county 1
- Galveston 792
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1885 | 1885 | 2020-03-13 | Galveston | Texas | 48167 | 1 | 0 |
2251 | 2251 | 2020-03-14 | Galveston | Texas | 48167 | 1 | 0 |
2677 | 2677 | 2020-03-15 | Galveston | Texas | 48167 | 1 | 0 |
3145 | 3145 | 2020-03-16 | Galveston | Texas | 48167 | 1 | 0 |
3680 | 3680 | 2020-03-17 | Galveston | Texas | 48167 | 1 | 0 |
4303 | 4303 | 2020-03-18 | Galveston | Texas | 48167 | 4 | 0 |
5057 | 5057 | 2020-03-19 | Galveston | Texas | 48167 | 4 | 0 |
5949 | 5949 | 2020-03-20 | Galveston | Texas | 48167 | 6 | 0 |
6969 | 6969 | 2020-03-21 | Galveston | Texas | 48167 | 8 | 0 |
8099 | 8099 | 2020-03-22 | Galveston | Texas | 48167 | 11 | 0 |
9317 | 9317 | 2020-03-23 | Galveston | Texas | 48167 | 17 | 0 |
10654 | 10654 | 2020-03-24 | Galveston | Texas | 48167 | 18 | 0 |
12143 | 12143 | 2020-03-25 | Galveston | Texas | 48167 | 22 | 0 |
13772 | 13772 | 2020-03-26 | Galveston | Texas | 48167 | 27 | 0 |
15526 | 15526 | 2020-03-27 | Galveston | Texas | 48167 | 49 | 0 |
17395 | 17395 | 2020-03-28 | Galveston | Texas | 48167 | 60 | 0 |
19348 | 19348 | 2020-03-29 | Galveston | Texas | 48167 | 70 | 0 |
21407 | 21407 | 2020-03-30 | Galveston | Texas | 48167 | 92 | 0 |
23546 | 23546 | 2020-03-31 | Galveston | Texas | 48167 | 106 | 0 |
25754 | 25754 | 2020-04-01 | Galveston | Texas | 48167 | 118 | 0 |
28035 | 28035 | 2020-04-02 | Galveston | Texas | 48167 | 130 | 0 |
30370 | 30370 | 2020-04-03 | Galveston | Texas | 48167 | 206 | 0 |
32763 | 32763 | 2020-04-04 | Galveston | Texas | 48167 | 222 | 1 |
35201 | 35201 | 2020-04-05 | Galveston | Texas | 48167 | 240 | 1 |
37677 | 37677 | 2020-04-06 | Galveston | Texas | 48167 | 256 | 1 |
40202 | 40202 | 2020-04-07 | Galveston | Texas | 48167 | 272 | 5 |
42769 | 42769 | 2020-04-08 | Galveston | Texas | 48167 | 287 | 5 |
45358 | 45358 | 2020-04-09 | Galveston | Texas | 48167 | 308 | 7 |
47978 | 47978 | 2020-04-10 | Galveston | Texas | 48167 | 341 | 8 |
50636 | 50636 | 2020-04-11 | Galveston | Texas | 48167 | 355 | 8 |
53311 | 53311 | 2020-04-12 | Galveston | Texas | 48167 | 355 | 8 |
55999 | 55999 | 2020-04-13 | Galveston | Texas | 48167 | 377 | 9 |
58704 | 58704 | 2020-04-14 | Galveston | Texas | 48167 | 392 | 11 |
61422 | 61422 | 2020-04-15 | Galveston | Texas | 48167 | 401 | 13 |
64149 | 64149 | 2020-04-16 | Galveston | Texas | 48167 | 421 | 14 |
66896 | 66896 | 2020-04-17 | Galveston | Texas | 48167 | 438 | 14 |
69656 | 69656 | 2020-04-18 | Galveston | Texas | 48167 | 450 | 15 |
72424 | 72424 | 2020-04-19 | Galveston | Texas | 48167 | 455 | 17 |
75199 | 75199 | 2020-04-20 | Galveston | Texas | 48167 | 468 | 19 |
77981 | 77981 | 2020-04-21 | Galveston | Texas | 48167 | 479 | 20 |
80772 | 80772 | 2020-04-22 | Galveston | Texas | 48167 | 491 | 21 |
83572 | 83572 | 2020-04-23 | Galveston | Texas | 48167 | 507 | 21 |
86377 | 86377 | 2020-04-24 | Galveston | Texas | 48167 | 522 | 21 |
89192 | 89192 | 2020-04-25 | Galveston | Texas | 48167 | 539 | 22 |
92009 | 92009 | 2020-04-26 | Galveston | Texas | 48167 | 541 | 22 |
94838 | 94838 | 2020-04-27 | Galveston | Texas | 48167 | 548 | 24 |
97678 | 97678 | 2020-04-28 | Galveston | Texas | 48167 | 554 | 24 |
100528 | 100528 | 2020-04-29 | Galveston | Texas | 48167 | 572 | 24 |
103381 | 103381 | 2020-04-30 | Galveston | Texas | 48167 | 595 | 26 |
106245 | 106245 | 2020-05-01 | Galveston | Texas | 48167 | 614 | 27 |
109114 | 109114 | 2020-05-02 | Galveston | Texas | 48167 | 629 | 28 |
111988 | 111988 | 2020-05-03 | Galveston | Texas | 48167 | 636 | 28 |
114870 | 114870 | 2020-05-04 | Galveston | Texas | 48167 | 648 | 28 |
117829 | 117829 | 2020-05-05 | Galveston | Texas | 48167 | 659 | 28 |
120793 | 120793 | 2020-05-06 | Galveston | Texas | 48167 | 669 | 28 |
123772 | 123772 | 2020-05-07 | Galveston | Texas | 48167 | 672 | 28 |
126755 | 126755 | 2020-05-08 | Galveston | Texas | 48167 | 676 | 28 |
129744 | 129744 | 2020-05-09 | Galveston | Texas | 48167 | 680 | 29 |
132734 | 132734 | 2020-05-10 | Galveston | Texas | 48167 | 685 | 29 |
135725 | 135725 | 2020-05-11 | Galveston | Texas | 48167 | 686 | 29 |
138715 | 138715 | 2020-05-12 | Galveston | Texas | 48167 | 688 | 29 |
141711 | 141711 | 2020-05-13 | Galveston | Texas | 48167 | 691 | 29 |
144708 | 144708 | 2020-05-14 | Galveston | Texas | 48167 | 693 | 30 |
147711 | 147711 | 2020-05-15 | Galveston | Texas | 48167 | 696 | 30 |
150719 | 150719 | 2020-05-16 | Galveston | Texas | 48167 | 701 | 31 |
153730 | 153730 | 2020-05-17 | Galveston | Texas | 48167 | 702 | 31 |
156747 | 156747 | 2020-05-18 | Galveston | Texas | 48167 | 706 | 31 |
159769 | 159769 | 2020-05-19 | Galveston | Texas | 48167 | 706 | 31 |
162796 | 162796 | 2020-05-20 | Galveston | Texas | 48167 | 715 | 31 |
165825 | 165825 | 2020-05-21 | Galveston | Texas | 48167 | 732 | 31 |
168861 | 168861 | 2020-05-22 | Galveston | Texas | 48167 | 740 | 31 |
171900 | 171900 | 2020-05-23 | Galveston | Texas | 48167 | 749 | 32 |
174943 | 174943 | 2020-05-24 | Galveston | Texas | 48167 | 752 | 32 |
177987 | 177987 | 2020-05-25 | Galveston | Texas | 48167 | 753 | 32 |
181030 | 181030 | 2020-05-26 | Galveston | Texas | 48167 | 763 | 32 |
184080 | 184080 | 2020-05-27 | Galveston | Texas | 48167 | 779 | 32 |
187137 | 187137 | 2020-05-28 | Galveston | Texas | 48167 | 788 | 32 |
190201 | 190201 | 2020-05-29 | Galveston | Texas | 48167 | 795 | 32 |
193266 | 193266 | 2020-05-30 | Galveston | Texas | 48167 | 807 | 37 |
196336 | 196336 | 2020-05-31 | Galveston | Texas | 48167 | 817 | 37 |
199409 | 199409 | 2020-06-01 | Galveston | Texas | 48167 | 847 | 37 |
202484 | 202484 | 2020-06-02 | Galveston | Texas | 48167 | 857 | 37 |
205563 | 205563 | 2020-06-03 | Galveston | Texas | 48167 | 876 | 37 |
208645 | 208645 | 2020-06-04 | Galveston | Texas | 48167 | 906 | 38 |
211729 | 211729 | 2020-06-05 | Galveston | Texas | 48167 | 906 | 38 |
214816 | 214816 | 2020-06-06 | Galveston | Texas | 48167 | 972 | 38 |
217906 | 217906 | 2020-06-07 | Galveston | Texas | 48167 | 994 | 38 |
220998 | 220998 | 2020-06-08 | Galveston | Texas | 48167 | 1026 | 38 |
224093 | 224093 | 2020-06-09 | Galveston | Texas | 48167 | 1051 | 38 |
227193 | 227193 | 2020-06-10 | Galveston | Texas | 48167 | 1084 | 38 |
230297 | 230297 | 2020-06-11 | Galveston | Texas | 48167 | 1114 | 38 |
233401 | 233401 | 2020-06-12 | Galveston | Texas | 48167 | 1166 | 40 |
236507 | 236507 | 2020-06-13 | Galveston | Texas | 48167 | 1237 | 40 |
239615 | 239615 | 2020-06-14 | Galveston | Texas | 48167 | 1255 | 40 |
242725 | 242725 | 2020-06-15 | Galveston | Texas | 48167 | 1312 | 40 |
245837 | 245837 | 2020-06-16 | Galveston | Texas | 48167 | 1378 | 40 |
248950 | 248950 | 2020-06-17 | Galveston | Texas | 48167 | 1486 | 40 |
252065 | 252065 | 2020-06-18 | Galveston | Texas | 48167 | 1535 | 40 |
255180 | 255180 | 2020-06-19 | Galveston | Texas | 48167 | 1642 | 40 |
258307 | 258307 | 2020-06-20 | Galveston | Texas | 48167 | 1784 | 40 |
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);