ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 22105 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 281 ✖
- 598 17
- 43 16
- 42 13
- 533 13
- 0 12
- 286 12
- 122 11
- 291 10
- 520 9
- 299 8
- 596 8
- 30 7
- 39 7
- 126 7
- 288 7
- 305 7
- 306 7
- 511 7
- 583 7
- 588 7
- 593 7
- 21 6
- 120 6
- 127 6
- 139 6
- 153 6
- 294 6
- 298 6
- 302 6
- 314 6
- 531 6
- 538 6
- 18 5
- 23 5
- 44 5
- 107 5
- 121 5
- 142 5
- 170 5
- 236 5
- 317 5
- 418 5
- 453 5
- 518 5
- 522 5
- 552 5
- 590 5
- 592 5
- 599 5
- 2 4
- 32 4
- 88 4
- 117 4
- 119 4
- 129 4
- 147 4
- 184 4
- 206 4
- 254 4
- 274 4
- 277 4
- 285 4
- 290 4
- 292 4
- 296 4
- 300 4
- 307 4
- 432 4
- 447 4
- 502 4
- 514 4
- 526 4
- 530 4
- 536 4
- 543 4
- 570 4
- 585 4
- 595 4
- 35 3
- 46 3
- 47 3
- 63 3
- 78 3
- 118 3
- 123 3
- 137 3
- 145 3
- 196 3
- 261 3
- 281 3
- 295 3
- 308 3
- 310 3
- 328 3
- 348 3
- 366 3
- 393 3
- 467 3
- 483 3
- 488 3
- 497 3
- 560 3
- 577 3
- 594 3
- 597 3
- 1 2
- 11 2
- 19 2
- 27 2
- 28 2
- 31 2
- 33 2
- 34 2
- 53 2
- 54 2
- 56 2
- 58 2
- 62 2
- 69 2
- 72 2
- 80 2
- 83 2
- 87 2
- 90 2
- 94 2
- 98 2
- 104 2
- 108 2
- 111 2
- 116 2
- 135 2
- 143 2
- 152 2
- 155 2
- 188 2
- 208 2
- 211 2
- 220 2
- 244 2
- 255 2
- 262 2
- 266 2
- 272 2
- 273 2
- 278 2
- 289 2
- 297 2
- 301 2
- 304 2
- 313 2
- 362 2
- 381 2
- 425 2
- 481 2
- 492 2
- 501 2
- 505 2
- 524 2
- 525 2
- 529 2
- 535 2
- 537 2
- 549 2
- 571 2
- 574 2
- 582 2
- 586 2
- 3 1
- 4 1
- 5 1
- 6 1
- 7 1
- 8 1
- 15 1
- 16 1
- 22 1
- 25 1
- 26 1
- 29 1
- 37 1
- 41 1
- 45 1
- 61 1
- 75 1
- 77 1
- 85 1
- 91 1
- 97 1
- 102 1
- 103 1
- 109 1
- 113 1
- 115 1
- 130 1
- 141 1
- 144 1
- 156 1
- 162 1
- 165 1
- 169 1
- 172 1
- 181 1
- 183 1
- 187 1
- 197 1
- 198 1
- 218 1
- 225 1
- 229 1
- 231 1
- 232 1
- 234 1
- 239 1
- 241 1
- 247 1
- 249 1
- 250 1
- 253 1
- 256 1
- 257 1
- 264 1
- 265 1
- 268 1
- 269 1
- 270 1
- 275 1
- 280 1
- 293 1
- 303 1
- 311 1
- 316 1
- 318 1
- 321 1
- 322 1
- 335 1
- 339 1
- 345 1
- 347 1
- 349 1
- 358 1
- 372 1
- 390 1
- 396 1
- 401 1
- 413 1
- 415 1
- 434 1
- 443 1
- 444 1
- 452 1
- 455 1
- 460 1
- 463 1
- 465 1
- 474 1
- 475 1
- 484 1
- 485 1
- 486 1
- 487 1
- 493 1
- 496 1
- 499 1
- 504 1
- 512 1
- 517 1
- 527 1
- 532 1
- 534 1
- 540 1
- 542 1
- 544 1
- 547 1
- 556 1
- 557 1
- 562 1
- 565 1
- 567 1
- 581 1
- 587 1
- 591 1
state 1
- Louisiana 785
fips 1
- 22105 · 785 ✖
county 1
- Tangipahoa 785
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5520 | 5520 | 2020-03-20 | Tangipahoa | Louisiana | 22105 | 1 | 0 |
6475 | 6475 | 2020-03-21 | Tangipahoa | Louisiana | 22105 | 3 | 0 |
7550 | 7550 | 2020-03-22 | Tangipahoa | Louisiana | 22105 | 3 | 0 |
8719 | 8719 | 2020-03-23 | Tangipahoa | Louisiana | 22105 | 3 | 0 |
10007 | 10007 | 2020-03-24 | Tangipahoa | Louisiana | 22105 | 4 | 0 |
11414 | 11414 | 2020-03-25 | Tangipahoa | Louisiana | 22105 | 5 | 0 |
12993 | 12993 | 2020-03-26 | Tangipahoa | Louisiana | 22105 | 7 | 0 |
14700 | 14700 | 2020-03-27 | Tangipahoa | Louisiana | 22105 | 7 | 0 |
16520 | 16520 | 2020-03-28 | Tangipahoa | Louisiana | 22105 | 10 | 0 |
18434 | 18434 | 2020-03-29 | Tangipahoa | Louisiana | 22105 | 10 | 0 |
20450 | 20450 | 2020-03-30 | Tangipahoa | Louisiana | 22105 | 18 | 0 |
22559 | 22559 | 2020-03-31 | Tangipahoa | Louisiana | 22105 | 25 | 0 |
24735 | 24735 | 2020-04-01 | Tangipahoa | Louisiana | 22105 | 33 | 2 |
26986 | 26986 | 2020-04-02 | Tangipahoa | Louisiana | 22105 | 42 | 1 |
29303 | 29303 | 2020-04-03 | Tangipahoa | Louisiana | 22105 | 55 | 1 |
31681 | 31681 | 2020-04-04 | Tangipahoa | Louisiana | 22105 | 131 | 2 |
34106 | 34106 | 2020-04-05 | Tangipahoa | Louisiana | 22105 | 171 | 2 |
36564 | 36564 | 2020-04-06 | Tangipahoa | Louisiana | 22105 | 186 | 2 |
39072 | 39072 | 2020-04-07 | Tangipahoa | Louisiana | 22105 | 238 | 3 |
41624 | 41624 | 2020-04-08 | Tangipahoa | Louisiana | 22105 | 269 | 4 |
44200 | 44200 | 2020-04-09 | Tangipahoa | Louisiana | 22105 | 283 | 5 |
46808 | 46808 | 2020-04-10 | Tangipahoa | Louisiana | 22105 | 305 | 6 |
49449 | 49449 | 2020-04-11 | Tangipahoa | Louisiana | 22105 | 318 | 7 |
52119 | 52119 | 2020-04-12 | Tangipahoa | Louisiana | 22105 | 344 | 8 |
54800 | 54800 | 2020-04-13 | Tangipahoa | Louisiana | 22105 | 352 | 11 |
57498 | 57498 | 2020-04-14 | Tangipahoa | Louisiana | 22105 | 391 | 11 |
60206 | 60206 | 2020-04-15 | Tangipahoa | Louisiana | 22105 | 418 | 15 |
62927 | 62927 | 2020-04-16 | Tangipahoa | Louisiana | 22105 | 422 | 16 |
65666 | 65666 | 2020-04-17 | Tangipahoa | Louisiana | 22105 | 435 | 18 |
68415 | 68415 | 2020-04-18 | Tangipahoa | Louisiana | 22105 | 440 | 18 |
71178 | 71178 | 2020-04-19 | Tangipahoa | Louisiana | 22105 | 442 | 18 |
73950 | 73950 | 2020-04-20 | Tangipahoa | Louisiana | 22105 | 452 | 19 |
76730 | 76730 | 2020-04-21 | Tangipahoa | Louisiana | 22105 | 489 | 19 |
79516 | 79516 | 2020-04-22 | Tangipahoa | Louisiana | 22105 | 494 | 18 |
82312 | 82312 | 2020-04-23 | Tangipahoa | Louisiana | 22105 | 501 | 18 |
85116 | 85116 | 2020-04-24 | Tangipahoa | Louisiana | 22105 | 508 | 21 |
87925 | 87925 | 2020-04-25 | Tangipahoa | Louisiana | 22105 | 526 | 21 |
90741 | 90741 | 2020-04-26 | Tangipahoa | Louisiana | 22105 | 528 | 21 |
93562 | 93562 | 2020-04-27 | Tangipahoa | Louisiana | 22105 | 535 | 21 |
96397 | 96397 | 2020-04-28 | Tangipahoa | Louisiana | 22105 | 540 | 21 |
99243 | 99243 | 2020-04-29 | Tangipahoa | Louisiana | 22105 | 549 | 21 |
102095 | 102095 | 2020-04-30 | Tangipahoa | Louisiana | 22105 | 553 | 22 |
104956 | 104956 | 2020-05-01 | Tangipahoa | Louisiana | 22105 | 565 | 23 |
107820 | 107820 | 2020-05-02 | Tangipahoa | Louisiana | 22105 | 584 | 23 |
110692 | 110692 | 2020-05-03 | Tangipahoa | Louisiana | 22105 | 584 | 23 |
113569 | 113569 | 2020-05-04 | Tangipahoa | Louisiana | 22105 | 588 | 23 |
116451 | 116451 | 2020-05-05 | Tangipahoa | Louisiana | 22105 | 605 | 23 |
119412 | 119412 | 2020-05-06 | Tangipahoa | Louisiana | 22105 | 631 | 25 |
122383 | 122383 | 2020-05-07 | Tangipahoa | Louisiana | 22105 | 635 | 26 |
125365 | 125365 | 2020-05-08 | Tangipahoa | Louisiana | 22105 | 645 | 27 |
128352 | 128352 | 2020-05-09 | Tangipahoa | Louisiana | 22105 | 652 | 27 |
131342 | 131342 | 2020-05-10 | Tangipahoa | Louisiana | 22105 | 654 | 28 |
134333 | 134333 | 2020-05-11 | Tangipahoa | Louisiana | 22105 | 670 | 28 |
137323 | 137323 | 2020-05-12 | Tangipahoa | Louisiana | 22105 | 679 | 29 |
140317 | 140317 | 2020-05-13 | Tangipahoa | Louisiana | 22105 | 687 | 30 |
143312 | 143312 | 2020-05-14 | Tangipahoa | Louisiana | 22105 | 696 | 30 |
146312 | 146312 | 2020-05-15 | Tangipahoa | Louisiana | 22105 | 707 | 30 |
149317 | 149317 | 2020-05-16 | Tangipahoa | Louisiana | 22105 | 719 | 31 |
152328 | 152328 | 2020-05-17 | Tangipahoa | Louisiana | 22105 | 729 | 30 |
155342 | 155342 | 2020-05-18 | Tangipahoa | Louisiana | 22105 | 732 | 30 |
158360 | 158360 | 2020-05-19 | Tangipahoa | Louisiana | 22105 | 742 | 30 |
161386 | 161386 | 2020-05-20 | Tangipahoa | Louisiana | 22105 | 752 | 30 |
164415 | 164415 | 2020-05-21 | Tangipahoa | Louisiana | 22105 | 767 | 31 |
167451 | 167451 | 2020-05-22 | Tangipahoa | Louisiana | 22105 | 782 | 32 |
170489 | 170489 | 2020-05-23 | Tangipahoa | Louisiana | 22105 | 784 | 32 |
173530 | 173530 | 2020-05-24 | Tangipahoa | Louisiana | 22105 | 784 | 32 |
176574 | 176574 | 2020-05-25 | Tangipahoa | Louisiana | 22105 | 802 | 32 |
179618 | 179618 | 2020-05-26 | Tangipahoa | Louisiana | 22105 | 810 | 33 |
182663 | 182663 | 2020-05-27 | Tangipahoa | Louisiana | 22105 | 826 | 33 |
185718 | 185718 | 2020-05-28 | Tangipahoa | Louisiana | 22105 | 831 | 34 |
188776 | 188776 | 2020-05-29 | Tangipahoa | Louisiana | 22105 | 831 | 34 |
191840 | 191840 | 2020-05-30 | Tangipahoa | Louisiana | 22105 | 854 | 35 |
194908 | 194908 | 2020-05-31 | Tangipahoa | Louisiana | 22105 | 858 | 35 |
197979 | 197979 | 2020-06-01 | Tangipahoa | Louisiana | 22105 | 868 | 35 |
201051 | 201051 | 2020-06-02 | Tangipahoa | Louisiana | 22105 | 883 | 37 |
204128 | 204128 | 2020-06-03 | Tangipahoa | Louisiana | 22105 | 891 | 39 |
207209 | 207209 | 2020-06-04 | Tangipahoa | Louisiana | 22105 | 898 | 39 |
210290 | 210290 | 2020-06-05 | Tangipahoa | Louisiana | 22105 | 916 | 39 |
213375 | 213375 | 2020-06-06 | Tangipahoa | Louisiana | 22105 | 935 | 39 |
216462 | 216462 | 2020-06-07 | Tangipahoa | Louisiana | 22105 | 944 | 39 |
219554 | 219554 | 2020-06-08 | Tangipahoa | Louisiana | 22105 | 944 | 39 |
222649 | 222649 | 2020-06-09 | Tangipahoa | Louisiana | 22105 | 965 | 39 |
225745 | 225745 | 2020-06-10 | Tangipahoa | Louisiana | 22105 | 973 | 41 |
228847 | 228847 | 2020-06-11 | Tangipahoa | Louisiana | 22105 | 984 | 42 |
231951 | 231951 | 2020-06-12 | Tangipahoa | Louisiana | 22105 | 1001 | 42 |
235056 | 235056 | 2020-06-13 | Tangipahoa | Louisiana | 22105 | 1039 | 42 |
238163 | 238163 | 2020-06-14 | Tangipahoa | Louisiana | 22105 | 1042 | 42 |
241272 | 241272 | 2020-06-15 | Tangipahoa | Louisiana | 22105 | 1048 | 42 |
244383 | 244383 | 2020-06-16 | Tangipahoa | Louisiana | 22105 | 1062 | 42 |
247496 | 247496 | 2020-06-17 | Tangipahoa | Louisiana | 22105 | 1082 | 42 |
250608 | 250608 | 2020-06-18 | Tangipahoa | Louisiana | 22105 | 1082 | 42 |
253723 | 253723 | 2020-06-19 | Tangipahoa | Louisiana | 22105 | 1078 | 42 |
256843 | 256843 | 2020-06-20 | Tangipahoa | Louisiana | 22105 | 1112 | 42 |
259969 | 259969 | 2020-06-21 | Tangipahoa | Louisiana | 22105 | 1120 | 42 |
263098 | 263098 | 2020-06-22 | Tangipahoa | Louisiana | 22105 | 1123 | 42 |
266225 | 266225 | 2020-06-23 | Tangipahoa | Louisiana | 22105 | 1163 | 42 |
269358 | 269358 | 2020-06-24 | Tangipahoa | Louisiana | 22105 | 1184 | 43 |
272494 | 272494 | 2020-06-25 | Tangipahoa | Louisiana | 22105 | 1218 | 43 |
275637 | 275637 | 2020-06-26 | Tangipahoa | Louisiana | 22105 | 1248 | 43 |
278785 | 278785 | 2020-06-27 | Tangipahoa | Louisiana | 22105 | 1248 | 43 |
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);