ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 48039 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 411 ✖
- 983 24
- 0 17
- 12 14
- 3 13
- 979 13
- 535 10
- 1 9
- 864 9
- 9 8
- 173 7
- 179 7
- 526 7
- 976 7
- 982 7
- 6 6
- 19 6
- 22 6
- 200 6
- 851 6
- 855 6
- 2 5
- 11 5
- 18 5
- 21 5
- 155 5
- 190 5
- 528 5
- 530 5
- 836 5
- 878 5
- 972 5
- 16 4
- 28 4
- 167 4
- 185 4
- 210 4
- 224 4
- 488 4
- 518 4
- 522 4
- 537 4
- 539 4
- 850 4
- 860 4
- 869 4
- 957 4
- 978 4
- 7 3
- 13 3
- 34 3
- 124 3
- 138 3
- 146 3
- 158 3
- 169 3
- 182 3
- 188 3
- 189 3
- 229 3
- 243 3
- 351 3
- 411 3
- 445 3
- 454 3
- 465 3
- 508 3
- 512 3
- 538 3
- 541 3
- 546 3
- 551 3
- 649 3
- 815 3
- 867 3
- 974 3
- 975 3
- 980 3
- 14 2
- 24 2
- 25 2
- 72 2
- 93 2
- 105 2
- 111 2
- 148 2
- 163 2
- 171 2
- 184 2
- 187 2
- 192 2
- 194 2
- 206 2
- 207 2
- 208 2
- 209 2
- 250 2
- 255 2
- 275 2
- 288 2
- 349 2
- 380 2
- 397 2
- 424 2
- 453 2
- 468 2
- 473 2
- 482 2
- 487 2
- 497 2
- 509 2
- 514 2
- 527 2
- 542 2
- 566 2
- 612 2
- 705 2
- 763 2
- 786 2
- 803 2
- 804 2
- 814 2
- 821 2
- 824 2
- 835 2
- 842 2
- 843 2
- 845 2
- 862 2
- 876 2
- 877 2
- 879 2
- 882 2
- 912 2
- 928 2
- 946 2
- 960 2
- 962 2
- 5 1
- 8 1
- 10 1
- 17 1
- 20 1
- 23 1
- 29 1
- 31 1
- 32 1
- 35 1
- 36 1
- 37 1
- 38 1
- 50 1
- 52 1
- 60 1
- 62 1
- 67 1
- 73 1
- 78 1
- 84 1
- 85 1
- 88 1
- 92 1
- 96 1
- 100 1
- 110 1
- 114 1
- 118 1
- 121 1
- 122 1
- 127 1
- 130 1
- 131 1
- 134 1
- 137 1
- 139 1
- 143 1
- 145 1
- 147 1
- 154 1
- 156 1
- 157 1
- 159 1
- 161 1
- 165 1
- 172 1
- 175 1
- 177 1
- 181 1
- 183 1
- 186 1
- 193 1
- 195 1
- 196 1
- 199 1
- 202 1
- 204 1
- 212 1
- 214 1
- 218 1
- 222 1
- 226 1
- 228 1
- 230 1
- 232 1
- 234 1
- 238 1
- 242 1
- 245 1
- 246 1
- 254 1
- 257 1
- 260 1
- 266 1
- 269 1
- 273 1
- 277 1
- 280 1
- 281 1
- 284 1
- 287 1
- 292 1
- 299 1
- 303 1
- 304 1
- 306 1
- 308 1
- 309 1
- 311 1
- 318 1
- 323 1
- 328 1
- 331 1
- 332 1
- 333 1
- 335 1
- 339 1
- 342 1
- 344 1
- 350 1
- 353 1
- 357 1
- 359 1
- 360 1
- 361 1
- 368 1
- 371 1
- 375 1
- 377 1
- 383 1
- 387 1
- 391 1
- 394 1
- 396 1
- 399 1
- 402 1
- 405 1
- 406 1
- 415 1
- 421 1
- 427 1
- 428 1
- 429 1
- 434 1
- 438 1
- 443 1
- 444 1
- 447 1
- 449 1
- 457 1
- 458 1
- 460 1
- 463 1
- 467 1
- 469 1
- 472 1
- 474 1
- 477 1
- 478 1
- 480 1
- 481 1
- 483 1
- 486 1
- 492 1
- 493 1
- 495 1
- 496 1
- 498 1
- 500 1
- 504 1
- 506 1
- 510 1
- 511 1
- 513 1
- 515 1
- 519 1
- 521 1
- 524 1
- 529 1
- 531 1
- 532 1
- 533 1
- 534 1
- 540 1
- 545 1
- 548 1
- 549 1
- 550 1
- 552 1
- 553 1
- 558 1
- 561 1
- 565 1
- 567 1
- 568 1
- 574 1
- 579 1
- 581 1
- 585 1
- 588 1
- 589 1
- 593 1
- 598 1
- 602 1
- 609 1
- 613 1
- 619 1
- 627 1
- 636 1
- 644 1
- 647 1
- 654 1
- 662 1
- 670 1
- 677 1
- 678 1
- 680 1
- 681 1
- 687 1
- 693 1
- 701 1
- 704 1
- 707 1
- 712 1
- 723 1
- 732 1
- 737 1
- 739 1
- 740 1
- 750 1
- 755 1
- 756 1
- 760 1
- 764 1
- 771 1
- 777 1
- 778 1
- 782 1
- 785 1
- 793 1
- 796 1
- 800 1
- 808 1
- 809 1
- 817 1
- 825 1
- 826 1
- 828 1
- 833 1
- 841 1
- 846 1
- 848 1
- 854 1
- 856 1
- 857 1
- 858 1
- 859 1
- 863 1
- 873 1
- 881 1
- 885 1
- 887 1
- 890 1
- 891 1
- 896 1
- 897 1
- 898 1
- 900 1
- 904 1
- 906 1
- 909 1
- 911 1
- 914 1
- 918 1
- 923 1
- 925 1
- 927 1
- 930 1
- 933 1
- 938 1
- 942 1
- 944 1
- 951 1
- 952 1
- 953 1
- 954 1
- 959 1
- 963 1
- 965 1
- 968 1
- 970 1
- 977 1
- 981 1
state 1
- Texas 791
fips 1
- 48039 · 791 ✖
county 1
- Brazoria 791
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2246 | 2246 | 2020-03-14 | Brazoria | Texas | 48039 | 2 | 0 |
2671 | 2671 | 2020-03-15 | Brazoria | Texas | 48039 | 2 | 0 |
3139 | 3139 | 2020-03-16 | Brazoria | Texas | 48039 | 2 | 0 |
3672 | 3672 | 2020-03-17 | Brazoria | Texas | 48039 | 2 | 0 |
4295 | 4295 | 2020-03-18 | Brazoria | Texas | 48039 | 4 | 0 |
5046 | 5046 | 2020-03-19 | Brazoria | Texas | 48039 | 4 | 0 |
5935 | 5935 | 2020-03-20 | Brazoria | Texas | 48039 | 10 | 0 |
6953 | 6953 | 2020-03-21 | Brazoria | Texas | 48039 | 14 | 0 |
8083 | 8083 | 2020-03-22 | Brazoria | Texas | 48039 | 14 | 0 |
9301 | 9301 | 2020-03-23 | Brazoria | Texas | 48039 | 16 | 0 |
10635 | 10635 | 2020-03-24 | Brazoria | Texas | 48039 | 18 | 0 |
12118 | 12118 | 2020-03-25 | Brazoria | Texas | 48039 | 19 | 0 |
13746 | 13746 | 2020-03-26 | Brazoria | Texas | 48039 | 33 | 0 |
15499 | 15499 | 2020-03-27 | Brazoria | Texas | 48039 | 39 | 0 |
17366 | 17366 | 2020-03-28 | Brazoria | Texas | 48039 | 52 | 0 |
19316 | 19316 | 2020-03-29 | Brazoria | Texas | 48039 | 61 | 0 |
21375 | 21375 | 2020-03-30 | Brazoria | Texas | 48039 | 61 | 0 |
23514 | 23514 | 2020-03-31 | Brazoria | Texas | 48039 | 95 | 1 |
25718 | 25718 | 2020-04-01 | Brazoria | Texas | 48039 | 95 | 1 |
27998 | 27998 | 2020-04-02 | Brazoria | Texas | 48039 | 109 | 1 |
30333 | 30333 | 2020-04-03 | Brazoria | Texas | 48039 | 123 | 1 |
32726 | 32726 | 2020-04-04 | Brazoria | Texas | 48039 | 136 | 1 |
35164 | 35164 | 2020-04-05 | Brazoria | Texas | 48039 | 144 | 1 |
37640 | 37640 | 2020-04-06 | Brazoria | Texas | 48039 | 151 | 1 |
40162 | 40162 | 2020-04-07 | Brazoria | Texas | 48039 | 167 | 1 |
42725 | 42725 | 2020-04-08 | Brazoria | Texas | 48039 | 184 | 1 |
45314 | 45314 | 2020-04-09 | Brazoria | Texas | 48039 | 199 | 2 |
47932 | 47932 | 2020-04-10 | Brazoria | Texas | 48039 | 199 | 2 |
50589 | 50589 | 2020-04-11 | Brazoria | Texas | 48039 | 225 | 2 |
53264 | 53264 | 2020-04-12 | Brazoria | Texas | 48039 | 225 | 2 |
55952 | 55952 | 2020-04-13 | Brazoria | Texas | 48039 | 250 | 2 |
58656 | 58656 | 2020-04-14 | Brazoria | Texas | 48039 | 259 | 3 |
61373 | 61373 | 2020-04-15 | Brazoria | Texas | 48039 | 272 | 3 |
64100 | 64100 | 2020-04-16 | Brazoria | Texas | 48039 | 272 | 3 |
66847 | 66847 | 2020-04-17 | Brazoria | Texas | 48039 | 302 | 3 |
69606 | 69606 | 2020-04-18 | Brazoria | Texas | 48039 | 304 | 3 |
72373 | 72373 | 2020-04-19 | Brazoria | Texas | 48039 | 315 | 3 |
75148 | 75148 | 2020-04-20 | Brazoria | Texas | 48039 | 333 | 3 |
77930 | 77930 | 2020-04-21 | Brazoria | Texas | 48039 | 345 | 3 |
80720 | 80720 | 2020-04-22 | Brazoria | Texas | 48039 | 382 | 3 |
83519 | 83519 | 2020-04-23 | Brazoria | Texas | 48039 | 392 | 3 |
86324 | 86324 | 2020-04-24 | Brazoria | Texas | 48039 | 417 | 3 |
89139 | 89139 | 2020-04-25 | Brazoria | Texas | 48039 | 445 | 3 |
91956 | 91956 | 2020-04-26 | Brazoria | Texas | 48039 | 449 | 3 |
94784 | 94784 | 2020-04-27 | Brazoria | Texas | 48039 | 464 | 5 |
97624 | 97624 | 2020-04-28 | Brazoria | Texas | 48039 | 476 | 6 |
100474 | 100474 | 2020-04-29 | Brazoria | Texas | 48039 | 485 | 6 |
103327 | 103327 | 2020-04-30 | Brazoria | Texas | 48039 | 509 | 6 |
106190 | 106190 | 2020-05-01 | Brazoria | Texas | 48039 | 537 | 6 |
109057 | 109057 | 2020-05-02 | Brazoria | Texas | 48039 | 542 | 6 |
111931 | 111931 | 2020-05-03 | Brazoria | Texas | 48039 | 551 | 6 |
114813 | 114813 | 2020-05-04 | Brazoria | Texas | 48039 | 566 | 7 |
117770 | 117770 | 2020-05-05 | Brazoria | Texas | 48039 | 570 | 7 |
120734 | 120734 | 2020-05-06 | Brazoria | Texas | 48039 | 588 | 7 |
123713 | 123713 | 2020-05-07 | Brazoria | Texas | 48039 | 613 | 8 |
126696 | 126696 | 2020-05-08 | Brazoria | Texas | 48039 | 644 | 9 |
129685 | 129685 | 2020-05-09 | Brazoria | Texas | 48039 | 656 | 9 |
132675 | 132675 | 2020-05-10 | Brazoria | Texas | 48039 | 661 | 9 |
135666 | 135666 | 2020-05-11 | Brazoria | Texas | 48039 | 673 | 9 |
138656 | 138656 | 2020-05-12 | Brazoria | Texas | 48039 | 686 | 9 |
141652 | 141652 | 2020-05-13 | Brazoria | Texas | 48039 | 710 | 9 |
144649 | 144649 | 2020-05-14 | Brazoria | Texas | 48039 | 712 | 9 |
147651 | 147651 | 2020-05-15 | Brazoria | Texas | 48039 | 721 | 9 |
150659 | 150659 | 2020-05-16 | Brazoria | Texas | 48039 | 727 | 10 |
153670 | 153670 | 2020-05-17 | Brazoria | Texas | 48039 | 767 | 11 |
156687 | 156687 | 2020-05-18 | Brazoria | Texas | 48039 | 786 | 11 |
159709 | 159709 | 2020-05-19 | Brazoria | Texas | 48039 | 795 | 11 |
162736 | 162736 | 2020-05-20 | Brazoria | Texas | 48039 | 805 | 11 |
165765 | 165765 | 2020-05-21 | Brazoria | Texas | 48039 | 816 | 11 |
168801 | 168801 | 2020-05-22 | Brazoria | Texas | 48039 | 825 | 12 |
171840 | 171840 | 2020-05-23 | Brazoria | Texas | 48039 | 835 | 12 |
174883 | 174883 | 2020-05-24 | Brazoria | Texas | 48039 | 838 | 12 |
177927 | 177927 | 2020-05-25 | Brazoria | Texas | 48039 | 843 | 12 |
180970 | 180970 | 2020-05-26 | Brazoria | Texas | 48039 | 853 | 12 |
184020 | 184020 | 2020-05-27 | Brazoria | Texas | 48039 | 861 | 12 |
187077 | 187077 | 2020-05-28 | Brazoria | Texas | 48039 | 882 | 12 |
190141 | 190141 | 2020-05-29 | Brazoria | Texas | 48039 | 894 | 12 |
193206 | 193206 | 2020-05-30 | Brazoria | Texas | 48039 | 907 | 12 |
196276 | 196276 | 2020-05-31 | Brazoria | Texas | 48039 | 917 | 12 |
199349 | 199349 | 2020-06-01 | Brazoria | Texas | 48039 | 929 | 12 |
202424 | 202424 | 2020-06-02 | Brazoria | Texas | 48039 | 941 | 12 |
205503 | 205503 | 2020-06-03 | Brazoria | Texas | 48039 | 957 | 12 |
208585 | 208585 | 2020-06-04 | Brazoria | Texas | 48039 | 967 | 12 |
211668 | 211668 | 2020-06-05 | Brazoria | Texas | 48039 | 990 | 13 |
214755 | 214755 | 2020-06-06 | Brazoria | Texas | 48039 | 990 | 13 |
220937 | 220937 | 2020-06-08 | Brazoria | Texas | 48039 | 990 | 13 |
217845 | 217845 | 2020-06-07 | Brazoria | Texas | 48039 | 1003 | 14 |
224032 | 224032 | 2020-06-09 | Brazoria | Texas | 48039 | 1015 | 14 |
227132 | 227132 | 2020-06-10 | Brazoria | Texas | 48039 | 1035 | 16 |
230236 | 230236 | 2020-06-11 | Brazoria | Texas | 48039 | 1058 | 16 |
233340 | 233340 | 2020-06-12 | Brazoria | Texas | 48039 | 1095 | 16 |
236446 | 236446 | 2020-06-13 | Brazoria | Texas | 48039 | 1109 | 16 |
239554 | 239554 | 2020-06-14 | Brazoria | Texas | 48039 | 1151 | 17 |
242664 | 242664 | 2020-06-15 | Brazoria | Texas | 48039 | 1184 | 18 |
245776 | 245776 | 2020-06-16 | Brazoria | Texas | 48039 | 1495 | 18 |
248889 | 248889 | 2020-06-17 | Brazoria | Texas | 48039 | 1525 | 18 |
252004 | 252004 | 2020-06-18 | Brazoria | Texas | 48039 | 1558 | 18 |
255119 | 255119 | 2020-06-19 | Brazoria | Texas | 48039 | 1609 | 18 |
258245 | 258245 | 2020-06-20 | Brazoria | Texas | 48039 | 1669 | 19 |
261372 | 261372 | 2020-06-21 | Brazoria | Texas | 48039 | 1728 | 19 |
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);