ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48479 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 266 ✖
- 992 41
- 841 22
- 844 21
- 847 20
- 980 17
- 19 15
- 859 15
- 936 13
- 1033 13
- 0 12
- 17 12
- 907 12
- 983 12
- 1036 10
- 18 9
- 835 9
- 6 8
- 20 8
- 802 8
- 894 8
- 1030 8
- 829 7
- 833 7
- 834 7
- 866 7
- 974 7
- 1034 7
- 11 6
- 22 6
- 780 6
- 788 6
- 820 6
- 959 6
- 969 6
- 971 6
- 978 6
- 16 5
- 765 5
- 883 5
- 926 5
- 968 5
- 973 5
- 986 5
- 1009 5
- 1024 5
- 1028 5
- 23 4
- 337 4
- 356 4
- 361 4
- 509 4
- 657 4
- 811 4
- 813 4
- 880 4
- 965 4
- 989 4
- 1020 4
- 12 3
- 15 3
- 244 3
- 329 3
- 385 3
- 398 3
- 485 3
- 526 3
- 528 3
- 563 3
- 569 3
- 592 3
- 609 3
- 688 3
- 731 3
- 736 3
- 816 3
- 827 3
- 837 3
- 882 3
- 967 3
- 988 3
- 1002 3
- 1031 3
- 2 2
- 5 2
- 8 2
- 25 2
- 27 2
- 28 2
- 43 2
- 128 2
- 242 2
- 250 2
- 281 2
- 289 2
- 290 2
- 297 2
- 305 2
- 348 2
- 349 2
- 355 2
- 397 2
- 411 2
- 417 2
- 420 2
- 441 2
- 468 2
- 473 2
- 480 2
- 496 2
- 505 2
- 523 2
- 543 2
- 631 2
- 632 2
- 682 2
- 800 2
- 818 2
- 826 2
- 831 2
- 840 2
- 923 2
- 934 2
- 960 2
- 975 2
- 990 2
- 1005 2
- 1 1
- 3 1
- 10 1
- 13 1
- 21 1
- 24 1
- 26 1
- 29 1
- 32 1
- 36 1
- 39 1
- 40 1
- 46 1
- 49 1
- 51 1
- 55 1
- 59 1
- 62 1
- 65 1
- 66 1
- 71 1
- 77 1
- 90 1
- 97 1
- 99 1
- 104 1
- 114 1
- 118 1
- 121 1
- 122 1
- 127 1
- 136 1
- 140 1
- 144 1
- 149 1
- 155 1
- 163 1
- 169 1
- 174 1
- 175 1
- 179 1
- 184 1
- 185 1
- 191 1
- 193 1
- 202 1
- 207 1
- 212 1
- 215 1
- 218 1
- 219 1
- 223 1
- 227 1
- 229 1
- 232 1
- 236 1
- 243 1
- 247 1
- 252 1
- 255 1
- 259 1
- 260 1
- 261 1
- 266 1
- 267 1
- 268 1
- 272 1
- 273 1
- 275 1
- 280 1
- 282 1
- 284 1
- 288 1
- 292 1
- 295 1
- 302 1
- 310 1
- 315 1
- 321 1
- 326 1
- 328 1
- 331 1
- 333 1
- 336 1
- 343 1
- 345 1
- 352 1
- 353 1
- 357 1
- 358 1
- 363 1
- 366 1
- 367 1
- 368 1
- 371 1
- 373 1
- 374 1
- 375 1
- 379 1
- 386 1
- 387 1
- 388 1
- 389 1
- 394 1
- 396 1
- 418 1
- 419 1
- 431 1
- 438 1
- 443 1
- 452 1
- 458 1
- 462 1
- 466 1
- 491 1
- 516 1
- 565 1
- 628 1
- 717 1
- 819 1
- 877 1
- 963 1
- 970 1
- 972 1
- 985 1
- 994 1
- 999 1
- 1001 1
- 1003 1
- 1010 1
- 1011 1
- 1014 1
- 1016 1
- 1023 1
- 1025 1
- 1026 1
- 1027 1
- 1029 1
- 1032 1
- 1035 1
state 1
- Texas 787
fips 1
- 48479 · 787 ✖
county 1
- Webb 787
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4317 | 4317 | 2020-03-18 | Webb | Texas | 48479 | 1 | 0 |
5073 | 5073 | 2020-03-19 | Webb | Texas | 48479 | 1 | 0 |
5967 | 5967 | 2020-03-20 | Webb | Texas | 48479 | 1 | 0 |
6990 | 6990 | 2020-03-21 | Webb | Texas | 48479 | 2 | 0 |
8120 | 8120 | 2020-03-22 | Webb | Texas | 48479 | 2 | 0 |
9339 | 9339 | 2020-03-23 | Webb | Texas | 48479 | 4 | 0 |
10683 | 10683 | 2020-03-24 | Webb | Texas | 48479 | 5 | 0 |
12191 | 12191 | 2020-03-25 | Webb | Texas | 48479 | 8 | 0 |
13826 | 13826 | 2020-03-26 | Webb | Texas | 48479 | 10 | 0 |
15589 | 15589 | 2020-03-27 | Webb | Texas | 48479 | 22 | 0 |
17461 | 17461 | 2020-03-28 | Webb | Texas | 48479 | 25 | 0 |
19420 | 19420 | 2020-03-29 | Webb | Texas | 48479 | 30 | 0 |
21482 | 21482 | 2020-03-30 | Webb | Texas | 48479 | 32 | 1 |
23621 | 23621 | 2020-03-31 | Webb | Texas | 48479 | 37 | 2 |
25835 | 25835 | 2020-04-01 | Webb | Texas | 48479 | 45 | 2 |
28123 | 28123 | 2020-04-02 | Webb | Texas | 48479 | 57 | 3 |
30460 | 30460 | 2020-04-03 | Webb | Texas | 48479 | 65 | 5 |
32858 | 32858 | 2020-04-04 | Webb | Texas | 48479 | 65 | 5 |
35296 | 35296 | 2020-04-05 | Webb | Texas | 48479 | 102 | 6 |
37773 | 37773 | 2020-04-06 | Webb | Texas | 48479 | 110 | 6 |
40302 | 40302 | 2020-04-07 | Webb | Texas | 48479 | 125 | 6 |
42870 | 42870 | 2020-04-08 | Webb | Texas | 48479 | 135 | 6 |
45464 | 45464 | 2020-04-09 | Webb | Texas | 48479 | 163 | 6 |
48087 | 48087 | 2020-04-10 | Webb | Texas | 48479 | 166 | 6 |
50745 | 50745 | 2020-04-11 | Webb | Texas | 48479 | 171 | 6 |
53420 | 53420 | 2020-04-12 | Webb | Texas | 48479 | 191 | 6 |
56109 | 56109 | 2020-04-13 | Webb | Texas | 48479 | 206 | 8 |
58814 | 58814 | 2020-04-14 | Webb | Texas | 48479 | 223 | 8 |
61532 | 61532 | 2020-04-15 | Webb | Texas | 48479 | 239 | 10 |
64264 | 64264 | 2020-04-16 | Webb | Texas | 48479 | 245 | 11 |
67011 | 67011 | 2020-04-17 | Webb | Texas | 48479 | 253 | 11 |
69771 | 69771 | 2020-04-18 | Webb | Texas | 48479 | 267 | 11 |
72541 | 72541 | 2020-04-19 | Webb | Texas | 48479 | 280 | 11 |
75317 | 75317 | 2020-04-20 | Webb | Texas | 48479 | 281 | 11 |
78099 | 78099 | 2020-04-21 | Webb | Texas | 48479 | 295 | 11 |
80890 | 80890 | 2020-04-22 | Webb | Texas | 48479 | 302 | 12 |
83691 | 83691 | 2020-04-23 | Webb | Texas | 48479 | 321 | 12 |
86498 | 86498 | 2020-04-24 | Webb | Texas | 48479 | 338 | 12 |
89313 | 89313 | 2020-04-25 | Webb | Texas | 48479 | 340 | 13 |
92130 | 92130 | 2020-04-26 | Webb | Texas | 48479 | 345 | 15 |
94959 | 94959 | 2020-04-27 | Webb | Texas | 48479 | 346 | 15 |
97801 | 97801 | 2020-04-28 | Webb | Texas | 48479 | 349 | 15 |
100651 | 100651 | 2020-04-29 | Webb | Texas | 48479 | 358 | 16 |
103506 | 103506 | 2020-04-30 | Webb | Texas | 48479 | 363 | 16 |
106370 | 106370 | 2020-05-01 | Webb | Texas | 48479 | 368 | 16 |
109239 | 109239 | 2020-05-02 | Webb | Texas | 48479 | 385 | 16 |
112113 | 112113 | 2020-05-03 | Webb | Texas | 48479 | 391 | 16 |
114996 | 114996 | 2020-05-04 | Webb | Texas | 48479 | 396 | 17 |
117955 | 117955 | 2020-05-05 | Webb | Texas | 48479 | 400 | 17 |
120919 | 120919 | 2020-05-06 | Webb | Texas | 48479 | 410 | 17 |
123899 | 123899 | 2020-05-07 | Webb | Texas | 48479 | 414 | 17 |
126884 | 126884 | 2020-05-08 | Webb | Texas | 48479 | 424 | 17 |
129873 | 129873 | 2020-05-09 | Webb | Texas | 48479 | 434 | 17 |
132863 | 132863 | 2020-05-10 | Webb | Texas | 48479 | 435 | 17 |
135854 | 135854 | 2020-05-11 | Webb | Texas | 48479 | 437 | 17 |
138844 | 138844 | 2020-05-12 | Webb | Texas | 48479 | 444 | 17 |
141840 | 141840 | 2020-05-13 | Webb | Texas | 48479 | 445 | 17 |
144837 | 144837 | 2020-05-14 | Webb | Texas | 48479 | 451 | 17 |
147841 | 147841 | 2020-05-15 | Webb | Texas | 48479 | 469 | 17 |
150849 | 150849 | 2020-05-16 | Webb | Texas | 48479 | 477 | 18 |
153860 | 153860 | 2020-05-17 | Webb | Texas | 48479 | 477 | 18 |
156877 | 156877 | 2020-05-18 | Webb | Texas | 48479 | 477 | 18 |
159901 | 159901 | 2020-05-19 | Webb | Texas | 48479 | 479 | 18 |
162929 | 162929 | 2020-05-20 | Webb | Texas | 48479 | 492 | 18 |
165958 | 165958 | 2020-05-21 | Webb | Texas | 48479 | 498 | 18 |
168994 | 168994 | 2020-05-22 | Webb | Texas | 48479 | 498 | 18 |
172035 | 172035 | 2020-05-23 | Webb | Texas | 48479 | 502 | 18 |
175078 | 175078 | 2020-05-24 | Webb | Texas | 48479 | 511 | 18 |
178123 | 178123 | 2020-05-25 | Webb | Texas | 48479 | 516 | 19 |
181167 | 181167 | 2020-05-26 | Webb | Texas | 48479 | 516 | 19 |
184218 | 184218 | 2020-05-27 | Webb | Texas | 48479 | 521 | 19 |
187275 | 187275 | 2020-05-28 | Webb | Texas | 48479 | 524 | 19 |
190339 | 190339 | 2020-05-29 | Webb | Texas | 48479 | 535 | 19 |
193405 | 193405 | 2020-05-30 | Webb | Texas | 48479 | 540 | 19 |
196475 | 196475 | 2020-05-31 | Webb | Texas | 48479 | 546 | 19 |
199548 | 199548 | 2020-06-01 | Webb | Texas | 48479 | 548 | 19 |
202624 | 202624 | 2020-06-02 | Webb | Texas | 48479 | 551 | 19 |
205703 | 205703 | 2020-06-03 | Webb | Texas | 48479 | 552 | 19 |
208785 | 208785 | 2020-06-04 | Webb | Texas | 48479 | 565 | 19 |
211870 | 211870 | 2020-06-05 | Webb | Texas | 48479 | 574 | 19 |
214957 | 214957 | 2020-06-06 | Webb | Texas | 48479 | 594 | 19 |
218047 | 218047 | 2020-06-07 | Webb | Texas | 48479 | 594 | 19 |
221139 | 221139 | 2020-06-08 | Webb | Texas | 48479 | 594 | 19 |
224235 | 224235 | 2020-06-09 | Webb | Texas | 48479 | 608 | 20 |
227335 | 227335 | 2020-06-10 | Webb | Texas | 48479 | 634 | 20 |
230439 | 230439 | 2020-06-11 | Webb | Texas | 48479 | 652 | 20 |
233543 | 233543 | 2020-06-12 | Webb | Texas | 48479 | 661 | 20 |
236650 | 236650 | 2020-06-13 | Webb | Texas | 48479 | 675 | 20 |
239758 | 239758 | 2020-06-14 | Webb | Texas | 48479 | 675 | 20 |
242868 | 242868 | 2020-06-15 | Webb | Texas | 48479 | 675 | 20 |
245980 | 245980 | 2020-06-16 | Webb | Texas | 48479 | 718 | 20 |
249093 | 249093 | 2020-06-17 | Webb | Texas | 48479 | 756 | 21 |
252208 | 252208 | 2020-06-18 | Webb | Texas | 48479 | 803 | 22 |
255325 | 255325 | 2020-06-19 | Webb | Texas | 48479 | 854 | 22 |
258452 | 258452 | 2020-06-20 | Webb | Texas | 48479 | 874 | 22 |
261579 | 261579 | 2020-06-21 | Webb | Texas | 48479 | 874 | 22 |
264708 | 264708 | 2020-06-22 | Webb | Texas | 48479 | 929 | 22 |
267837 | 267837 | 2020-06-23 | Webb | Texas | 48479 | 948 | 22 |
270971 | 270971 | 2020-06-24 | Webb | Texas | 48479 | 1003 | 23 |
274111 | 274111 | 2020-06-25 | Webb | Texas | 48479 | 1045 | 23 |
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);