ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 29510 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 329 ✖
- 772 37
- 230 14
- 1 11
- 158 10
- 225 10
- 613 10
- 188 9
- 196 9
- 213 9
- 538 9
- 620 9
- 161 8
- 531 8
- 218 7
- 460 7
- 534 7
- 586 7
- 752 7
- 765 7
- 770 7
- 779 7
- 154 6
- 181 6
- 496 6
- 504 6
- 635 6
- 0 5
- 141 5
- 155 5
- 164 5
- 195 5
- 217 5
- 221 5
- 458 5
- 533 5
- 548 5
- 578 5
- 602 5
- 636 5
- 710 5
- 30 4
- 169 4
- 171 4
- 215 4
- 238 4
- 302 4
- 440 4
- 477 4
- 529 4
- 530 4
- 541 4
- 552 4
- 600 4
- 612 4
- 619 4
- 628 4
- 668 4
- 737 4
- 739 4
- 742 4
- 17 3
- 95 3
- 130 3
- 135 3
- 139 3
- 178 3
- 184 3
- 197 3
- 207 3
- 270 3
- 343 3
- 425 3
- 454 3
- 488 3
- 509 3
- 514 3
- 528 3
- 553 3
- 563 3
- 572 3
- 577 3
- 594 3
- 597 3
- 610 3
- 638 3
- 716 3
- 718 3
- 732 3
- 733 3
- 8 2
- 12 2
- 27 2
- 50 2
- 60 2
- 109 2
- 110 2
- 112 2
- 118 2
- 132 2
- 156 2
- 167 2
- 174 2
- 216 2
- 222 2
- 240 2
- 257 2
- 282 2
- 291 2
- 292 2
- 311 2
- 319 2
- 325 2
- 348 2
- 351 2
- 363 2
- 376 2
- 412 2
- 416 2
- 437 2
- 438 2
- 441 2
- 443 2
- 445 2
- 452 2
- 459 2
- 467 2
- 471 2
- 490 2
- 513 2
- 515 2
- 516 2
- 524 2
- 525 2
- 537 2
- 544 2
- 554 2
- 555 2
- 557 2
- 558 2
- 561 2
- 570 2
- 581 2
- 595 2
- 599 2
- 601 2
- 604 2
- 624 2
- 625 2
- 626 2
- 634 2
- 660 2
- 661 2
- 664 2
- 673 2
- 687 2
- 698 2
- 702 2
- 703 2
- 715 2
- 725 2
- 5 1
- 6 1
- 13 1
- 24 1
- 26 1
- 40 1
- 45 1
- 46 1
- 48 1
- 54 1
- 55 1
- 64 1
- 65 1
- 70 1
- 71 1
- 78 1
- 82 1
- 83 1
- 85 1
- 86 1
- 88 1
- 90 1
- 91 1
- 96 1
- 97 1
- 100 1
- 108 1
- 116 1
- 117 1
- 131 1
- 134 1
- 142 1
- 148 1
- 157 1
- 159 1
- 165 1
- 172 1
- 176 1
- 177 1
- 182 1
- 187 1
- 189 1
- 208 1
- 232 1
- 235 1
- 237 1
- 239 1
- 246 1
- 255 1
- 260 1
- 263 1
- 265 1
- 267 1
- 271 1
- 275 1
- 276 1
- 279 1
- 281 1
- 283 1
- 286 1
- 289 1
- 294 1
- 297 1
- 300 1
- 308 1
- 309 1
- 314 1
- 316 1
- 323 1
- 324 1
- 328 1
- 330 1
- 332 1
- 337 1
- 340 1
- 341 1
- 345 1
- 346 1
- 349 1
- 350 1
- 353 1
- 360 1
- 367 1
- 371 1
- 374 1
- 382 1
- 387 1
- 390 1
- 393 1
- 397 1
- 400 1
- 403 1
- 406 1
- 409 1
- 415 1
- 420 1
- 421 1
- 422 1
- 423 1
- 424 1
- 428 1
- 431 1
- 433 1
- 435 1
- 436 1
- 439 1
- 444 1
- 447 1
- 449 1
- 450 1
- 455 1
- 461 1
- 465 1
- 475 1
- 476 1
- 480 1
- 481 1
- 482 1
- 484 1
- 491 1
- 494 1
- 497 1
- 498 1
- 500 1
- 502 1
- 511 1
- 518 1
- 532 1
- 535 1
- 542 1
- 546 1
- 550 1
- 551 1
- 562 1
- 565 1
- 566 1
- 567 1
- 571 1
- 574 1
- 575 1
- 576 1
- 582 1
- 584 1
- 588 1
- 590 1
- 592 1
- 598 1
- 606 1
- 609 1
- 611 1
- 617 1
- 622 1
- 631 1
- 637 1
- 642 1
- 645 1
- 646 1
- 650 1
- 652 1
- 653 1
- 657 1
- 685 1
- 688 1
- 689 1
- 694 1
- 707 1
- 736 1
- 778 1
- 780 1
state 1
- Missouri 787
fips 1
- 29510 · 787 ✖
county 1
- St. Louis city 787
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4090 | 4090 | 2020-03-18 | St. Louis city | Missouri | 29510 | 1 | 0 |
4809 | 4809 | 2020-03-19 | St. Louis city | Missouri | 29510 | 5 | 0 |
5647 | 5647 | 2020-03-20 | St. Louis city | Missouri | 29510 | 6 | 0 |
6637 | 6637 | 2020-03-21 | St. Louis city | Missouri | 29510 | 10 | 0 |
7726 | 7726 | 2020-03-22 | St. Louis city | Missouri | 29510 | 14 | 0 |
8918 | 8918 | 2020-03-23 | St. Louis city | Missouri | 29510 | 15 | 1 |
10220 | 10220 | 2020-03-24 | St. Louis city | Missouri | 29510 | 15 | 1 |
11649 | 11649 | 2020-03-25 | St. Louis city | Missouri | 29510 | 53 | 1 |
13247 | 13247 | 2020-03-26 | St. Louis city | Missouri | 29510 | 69 | 1 |
14975 | 14975 | 2020-03-27 | St. Louis city | Missouri | 29510 | 72 | 1 |
16800 | 16800 | 2020-03-28 | St. Louis city | Missouri | 29510 | 93 | 1 |
18722 | 18722 | 2020-03-29 | St. Louis city | Missouri | 29510 | 97 | 1 |
20755 | 20755 | 2020-03-30 | St. Louis city | Missouri | 29510 | 102 | 1 |
22874 | 22874 | 2020-03-31 | St. Louis city | Missouri | 29510 | 136 | 1 |
25062 | 25062 | 2020-04-01 | St. Louis city | Missouri | 29510 | 136 | 1 |
27319 | 27319 | 2020-04-02 | St. Louis city | Missouri | 29510 | 216 | 1 |
29641 | 29641 | 2020-04-03 | St. Louis city | Missouri | 29510 | 275 | 5 |
32022 | 32022 | 2020-04-04 | St. Louis city | Missouri | 29510 | 287 | 6 |
34450 | 34450 | 2020-04-05 | St. Louis city | Missouri | 29510 | 298 | 8 |
36916 | 36916 | 2020-04-06 | St. Louis city | Missouri | 29510 | 357 | 8 |
39432 | 39432 | 2020-04-07 | St. Louis city | Missouri | 29510 | 399 | 12 |
41986 | 41986 | 2020-04-08 | St. Louis city | Missouri | 29510 | 444 | 12 |
44564 | 44564 | 2020-04-09 | St. Louis city | Missouri | 29510 | 498 | 13 |
47173 | 47173 | 2020-04-10 | St. Louis city | Missouri | 29510 | 536 | 17 |
49821 | 49821 | 2020-04-11 | St. Louis city | Missouri | 29510 | 585 | 17 |
52494 | 52494 | 2020-04-12 | St. Louis city | Missouri | 29510 | 614 | 17 |
55176 | 55176 | 2020-04-13 | St. Louis city | Missouri | 29510 | 639 | 24 |
57874 | 57874 | 2020-04-14 | St. Louis city | Missouri | 29510 | 695 | 26 |
60588 | 60588 | 2020-04-15 | St. Louis city | Missouri | 29510 | 700 | 27 |
63310 | 63310 | 2020-04-16 | St. Louis city | Missouri | 29510 | 706 | 27 |
66050 | 66050 | 2020-04-17 | St. Louis city | Missouri | 29510 | 711 | 30 |
68804 | 68804 | 2020-04-18 | St. Louis city | Missouri | 29510 | 808 | 30 |
71571 | 71571 | 2020-04-19 | St. Louis city | Missouri | 29510 | 831 | 30 |
74344 | 74344 | 2020-04-20 | St. Louis city | Missouri | 29510 | 859 | 30 |
77125 | 77125 | 2020-04-21 | St. Louis city | Missouri | 29510 | 877 | 40 |
79912 | 79912 | 2020-04-22 | St. Louis city | Missouri | 29510 | 893 | 45 |
82708 | 82708 | 2020-04-23 | St. Louis city | Missouri | 29510 | 909 | 46 |
85512 | 85512 | 2020-04-24 | St. Louis city | Missouri | 29510 | 950 | 48 |
88322 | 88322 | 2020-04-25 | St. Louis city | Missouri | 29510 | 985 | 50 |
91138 | 91138 | 2020-04-26 | St. Louis city | Missouri | 29510 | 1007 | 50 |
93959 | 93959 | 2020-04-27 | St. Louis city | Missouri | 29510 | 1027 | 54 |
96795 | 96795 | 2020-04-28 | St. Louis city | Missouri | 29510 | 1054 | 55 |
99641 | 99641 | 2020-04-29 | St. Louis city | Missouri | 29510 | 1067 | 60 |
102493 | 102493 | 2020-04-30 | St. Louis city | Missouri | 29510 | 1077 | 60 |
105354 | 105354 | 2020-05-01 | St. Louis city | Missouri | 29510 | 1105 | 64 |
108219 | 108219 | 2020-05-02 | St. Louis city | Missouri | 29510 | 1186 | 65 |
111091 | 111091 | 2020-05-03 | St. Louis city | Missouri | 29510 | 1304 | 70 |
113970 | 113970 | 2020-05-04 | St. Louis city | Missouri | 29510 | 1304 | 71 |
116852 | 116852 | 2020-05-05 | St. Louis city | Missouri | 29510 | 1315 | 78 |
119812 | 119812 | 2020-05-06 | St. Louis city | Missouri | 29510 | 1384 | 82 |
122786 | 122786 | 2020-05-07 | St. Louis city | Missouri | 29510 | 1450 | 83 |
125768 | 125768 | 2020-05-08 | St. Louis city | Missouri | 29510 | 1474 | 85 |
128756 | 128756 | 2020-05-09 | St. Louis city | Missouri | 29510 | 1484 | 86 |
131746 | 131746 | 2020-05-10 | St. Louis city | Missouri | 29510 | 1513 | 88 |
134737 | 134737 | 2020-05-11 | St. Louis city | Missouri | 29510 | 1526 | 90 |
137727 | 137727 | 2020-05-12 | St. Louis city | Missouri | 29510 | 1549 | 91 |
140721 | 140721 | 2020-05-13 | St. Louis city | Missouri | 29510 | 1571 | 95 |
143716 | 143716 | 2020-05-14 | St. Louis city | Missouri | 29510 | 1596 | 95 |
146717 | 146717 | 2020-05-15 | St. Louis city | Missouri | 29510 | 1602 | 95 |
149723 | 149723 | 2020-05-16 | St. Louis city | Missouri | 29510 | 1631 | 96 |
152734 | 152734 | 2020-05-17 | St. Louis city | Missouri | 29510 | 1654 | 97 |
155748 | 155748 | 2020-05-18 | St. Louis city | Missouri | 29510 | 1682 | 100 |
158766 | 158766 | 2020-05-19 | St. Louis city | Missouri | 29510 | 1705 | 108 |
161792 | 161792 | 2020-05-20 | St. Louis city | Missouri | 29510 | 1717 | 109 |
164821 | 164821 | 2020-05-21 | St. Louis city | Missouri | 29510 | 1744 | 109 |
167857 | 167857 | 2020-05-22 | St. Louis city | Missouri | 29510 | 1763 | 110 |
170896 | 170896 | 2020-05-23 | St. Louis city | Missouri | 29510 | 1789 | 110 |
173938 | 173938 | 2020-05-24 | St. Louis city | Missouri | 29510 | 1815 | 112 |
176981 | 176981 | 2020-05-25 | St. Louis city | Missouri | 29510 | 1849 | 112 |
180025 | 180025 | 2020-05-26 | St. Louis city | Missouri | 29510 | 1867 | 116 |
183073 | 183073 | 2020-05-27 | St. Louis city | Missouri | 29510 | 1884 | 117 |
186129 | 186129 | 2020-05-28 | St. Louis city | Missouri | 29510 | 1906 | 118 |
189187 | 189187 | 2020-05-29 | St. Louis city | Missouri | 29510 | 1916 | 118 |
192251 | 192251 | 2020-05-30 | St. Louis city | Missouri | 29510 | 1930 | 130 |
195321 | 195321 | 2020-05-31 | St. Louis city | Missouri | 29510 | 1955 | 130 |
198392 | 198392 | 2020-06-01 | St. Louis city | Missouri | 29510 | 1974 | 130 |
201465 | 201465 | 2020-06-02 | St. Louis city | Missouri | 29510 | 1990 | 131 |
204542 | 204542 | 2020-06-03 | St. Louis city | Missouri | 29510 | 2006 | 132 |
207623 | 207623 | 2020-06-04 | St. Louis city | Missouri | 29510 | 2034 | 132 |
210704 | 210704 | 2020-06-05 | St. Louis city | Missouri | 29510 | 2053 | 134 |
213788 | 213788 | 2020-06-06 | St. Louis city | Missouri | 29510 | 2068 | 135 |
216877 | 216877 | 2020-06-07 | St. Louis city | Missouri | 29510 | 2071 | 135 |
219969 | 219969 | 2020-06-08 | St. Louis city | Missouri | 29510 | 2071 | 135 |
223064 | 223064 | 2020-06-09 | St. Louis city | Missouri | 29510 | 2132 | 139 |
226163 | 226163 | 2020-06-10 | St. Louis city | Missouri | 29510 | 2145 | 139 |
229266 | 229266 | 2020-06-11 | St. Louis city | Missouri | 29510 | 2162 | 139 |
232370 | 232370 | 2020-06-12 | St. Louis city | Missouri | 29510 | 2179 | 141 |
235476 | 235476 | 2020-06-13 | St. Louis city | Missouri | 29510 | 2195 | 141 |
238583 | 238583 | 2020-06-14 | St. Louis city | Missouri | 29510 | 2206 | 141 |
241693 | 241693 | 2020-06-15 | St. Louis city | Missouri | 29510 | 2219 | 141 |
244804 | 244804 | 2020-06-16 | St. Louis city | Missouri | 29510 | 2219 | 141 |
247917 | 247917 | 2020-06-17 | St. Louis city | Missouri | 29510 | 2234 | 142 |
251030 | 251030 | 2020-06-18 | St. Louis city | Missouri | 29510 | 2292 | 148 |
254145 | 254145 | 2020-06-19 | St. Louis city | Missouri | 29510 | 2319 | 154 |
257266 | 257266 | 2020-06-20 | St. Louis city | Missouri | 29510 | 2319 | 154 |
260392 | 260392 | 2020-06-21 | St. Louis city | Missouri | 29510 | 2319 | 154 |
263520 | 263520 | 2020-06-22 | St. Louis city | Missouri | 29510 | 2319 | 154 |
266646 | 266646 | 2020-06-23 | St. Louis city | Missouri | 29510 | 2319 | 154 |
269779 | 269779 | 2020-06-24 | St. Louis city | Missouri | 29510 | 2319 | 154 |
272918 | 272918 | 2020-06-25 | St. Louis city | Missouri | 29510 | 2310 | 155 |
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);