ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 29183 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 244 ✖
- 924 29
- 475 24
- 643 14
- 729 14
- 587 13
- 666 13
- 462 12
- 601 9
- 701 9
- 648 8
- 764 8
- 913 8
- 0 7
- 77 7
- 80 7
- 105 7
- 112 7
- 129 7
- 477 7
- 540 7
- 593 7
- 614 7
- 671 7
- 685 7
- 692 7
- 732 7
- 748 7
- 760 7
- 937 7
- 54 6
- 73 6
- 104 6
- 128 6
- 173 6
- 334 6
- 404 6
- 479 6
- 550 6
- 679 6
- 722 6
- 741 6
- 860 6
- 923 6
- 67 5
- 72 5
- 76 5
- 108 5
- 138 5
- 228 5
- 426 5
- 562 5
- 774 5
- 906 5
- 11 4
- 52 4
- 62 4
- 63 4
- 123 4
- 127 4
- 149 4
- 307 4
- 330 4
- 342 4
- 347 4
- 362 4
- 397 4
- 405 4
- 442 4
- 469 4
- 485 4
- 501 4
- 573 4
- 597 4
- 602 4
- 607 4
- 620 4
- 653 4
- 819 4
- 834 4
- 886 4
- 896 4
- 1 3
- 2 3
- 7 3
- 17 3
- 34 3
- 46 3
- 50 3
- 55 3
- 86 3
- 103 3
- 106 3
- 113 3
- 148 3
- 162 3
- 180 3
- 205 3
- 224 3
- 232 3
- 299 3
- 321 3
- 344 3
- 356 3
- 384 3
- 430 3
- 448 3
- 513 3
- 563 3
- 609 3
- 624 3
- 728 3
- 859 3
- 882 3
- 890 3
- 3 2
- 5 2
- 26 2
- 31 2
- 41 2
- 53 2
- 61 2
- 74 2
- 81 2
- 93 2
- 96 2
- 97 2
- 100 2
- 134 2
- 182 2
- 190 2
- 222 2
- 240 2
- 253 2
- 261 2
- 335 2
- 376 2
- 416 2
- 482 2
- 519 2
- 606 2
- 629 2
- 634 2
- 767 2
- 773 2
- 776 2
- 887 2
- 9 1
- 10 1
- 14 1
- 16 1
- 18 1
- 19 1
- 23 1
- 24 1
- 25 1
- 29 1
- 35 1
- 42 1
- 43 1
- 45 1
- 47 1
- 57 1
- 58 1
- 59 1
- 60 1
- 64 1
- 84 1
- 85 1
- 90 1
- 99 1
- 101 1
- 102 1
- 114 1
- 117 1
- 124 1
- 132 1
- 136 1
- 141 1
- 142 1
- 145 1
- 146 1
- 147 1
- 150 1
- 153 1
- 156 1
- 157 1
- 163 1
- 165 1
- 167 1
- 172 1
- 178 1
- 206 1
- 211 1
- 244 1
- 251 1
- 267 1
- 274 1
- 290 1
- 306 1
- 320 1
- 331 1
- 336 1
- 350 1
- 375 1
- 427 1
- 450 1
- 490 1
- 494 1
- 498 1
- 503 1
- 509 1
- 510 1
- 535 1
- 536 1
- 552 1
- 576 1
- 577 1
- 589 1
- 592 1
- 600 1
- 625 1
- 639 1
- 658 1
- 662 1
- 716 1
- 719 1
- 723 1
- 737 1
- 777 1
- 783 1
- 803 1
- 813 1
- 815 1
- 823 1
- 829 1
- 831 1
- 880 1
- 883 1
- 888 1
- 904 1
- 918 1
- 934 1
- 935 1
- 938 1
state 1
- Missouri 787
fips 1
- 29183 · 787 ✖
county 1
- St. Charles 787
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4088 | 4088 | 2020-03-18 | St. Charles | Missouri | 29183 | 1 | 0 |
4807 | 4807 | 2020-03-19 | St. Charles | Missouri | 29183 | 1 | 0 |
5645 | 5645 | 2020-03-20 | St. Charles | Missouri | 29183 | 3 | 0 |
6635 | 6635 | 2020-03-21 | St. Charles | Missouri | 29183 | 3 | 0 |
7724 | 7724 | 2020-03-22 | St. Charles | Missouri | 29183 | 3 | 0 |
8915 | 8915 | 2020-03-23 | St. Charles | Missouri | 29183 | 4 | 0 |
10217 | 10217 | 2020-03-24 | St. Charles | Missouri | 29183 | 4 | 0 |
11646 | 11646 | 2020-03-25 | St. Charles | Missouri | 29183 | 18 | 1 |
13244 | 13244 | 2020-03-26 | St. Charles | Missouri | 29183 | 22 | 1 |
14972 | 14972 | 2020-03-27 | St. Charles | Missouri | 29183 | 32 | 1 |
16797 | 16797 | 2020-03-28 | St. Charles | Missouri | 29183 | 37 | 2 |
18719 | 18719 | 2020-03-29 | St. Charles | Missouri | 29183 | 43 | 2 |
20752 | 20752 | 2020-03-30 | St. Charles | Missouri | 29183 | 56 | 2 |
22871 | 22871 | 2020-03-31 | St. Charles | Missouri | 29183 | 95 | 3 |
25059 | 25059 | 2020-04-01 | St. Charles | Missouri | 29183 | 95 | 3 |
27316 | 27316 | 2020-04-02 | St. Charles | Missouri | 29183 | 105 | 5 |
29638 | 29638 | 2020-04-03 | St. Charles | Missouri | 29183 | 132 | 5 |
32019 | 32019 | 2020-04-04 | St. Charles | Missouri | 29183 | 143 | 7 |
34447 | 34447 | 2020-04-05 | St. Charles | Missouri | 29183 | 157 | 7 |
36913 | 36913 | 2020-04-06 | St. Charles | Missouri | 29183 | 188 | 7 |
39429 | 39429 | 2020-04-07 | St. Charles | Missouri | 29183 | 221 | 9 |
41983 | 41983 | 2020-04-08 | St. Charles | Missouri | 29183 | 254 | 10 |
44560 | 44560 | 2020-04-09 | St. Charles | Missouri | 29183 | 274 | 11 |
47169 | 47169 | 2020-04-10 | St. Charles | Missouri | 29183 | 298 | 11 |
49817 | 49817 | 2020-04-11 | St. Charles | Missouri | 29183 | 320 | 11 |
52490 | 52490 | 2020-04-12 | St. Charles | Missouri | 29183 | 328 | 11 |
55172 | 55172 | 2020-04-13 | St. Charles | Missouri | 29183 | 346 | 14 |
57870 | 57870 | 2020-04-14 | St. Charles | Missouri | 29183 | 368 | 16 |
60584 | 60584 | 2020-04-15 | St. Charles | Missouri | 29183 | 392 | 17 |
63306 | 63306 | 2020-04-16 | St. Charles | Missouri | 29183 | 405 | 17 |
66046 | 66046 | 2020-04-17 | St. Charles | Missouri | 29183 | 417 | 17 |
68800 | 68800 | 2020-04-18 | St. Charles | Missouri | 29183 | 426 | 18 |
71567 | 71567 | 2020-04-19 | St. Charles | Missouri | 29183 | 435 | 19 |
74340 | 74340 | 2020-04-20 | St. Charles | Missouri | 29183 | 447 | 23 |
77121 | 77121 | 2020-04-21 | St. Charles | Missouri | 29183 | 458 | 24 |
79908 | 79908 | 2020-04-22 | St. Charles | Missouri | 29183 | 467 | 25 |
82704 | 82704 | 2020-04-23 | St. Charles | Missouri | 29183 | 476 | 26 |
85508 | 85508 | 2020-04-24 | St. Charles | Missouri | 29183 | 502 | 26 |
88318 | 88318 | 2020-04-25 | St. Charles | Missouri | 29183 | 513 | 29 |
91134 | 91134 | 2020-04-26 | St. Charles | Missouri | 29183 | 526 | 31 |
93955 | 93955 | 2020-04-27 | St. Charles | Missouri | 29183 | 543 | 31 |
96791 | 96791 | 2020-04-28 | St. Charles | Missouri | 29183 | 555 | 34 |
99637 | 99637 | 2020-04-29 | St. Charles | Missouri | 29183 | 560 | 34 |
102489 | 102489 | 2020-04-30 | St. Charles | Missouri | 29183 | 566 | 34 |
105350 | 105350 | 2020-05-01 | St. Charles | Missouri | 29183 | 577 | 35 |
108215 | 108215 | 2020-05-02 | St. Charles | Missouri | 29183 | 596 | 41 |
111087 | 111087 | 2020-05-03 | St. Charles | Missouri | 29183 | 612 | 41 |
113966 | 113966 | 2020-05-04 | St. Charles | Missouri | 29183 | 624 | 42 |
116848 | 116848 | 2020-05-05 | St. Charles | Missouri | 29183 | 626 | 43 |
119808 | 119808 | 2020-05-06 | St. Charles | Missouri | 29183 | 639 | 45 |
122782 | 122782 | 2020-05-07 | St. Charles | Missouri | 29183 | 646 | 46 |
125764 | 125764 | 2020-05-08 | St. Charles | Missouri | 29183 | 663 | 46 |
128752 | 128752 | 2020-05-09 | St. Charles | Missouri | 29183 | 668 | 46 |
131742 | 131742 | 2020-05-10 | St. Charles | Missouri | 29183 | 670 | 47 |
134733 | 134733 | 2020-05-11 | St. Charles | Missouri | 29183 | 684 | 50 |
137723 | 137723 | 2020-05-12 | St. Charles | Missouri | 29183 | 680 | 50 |
140717 | 140717 | 2020-05-13 | St. Charles | Missouri | 29183 | 681 | 50 |
143712 | 143712 | 2020-05-14 | St. Charles | Missouri | 29183 | 688 | 52 |
146713 | 146713 | 2020-05-15 | St. Charles | Missouri | 29183 | 688 | 52 |
149719 | 149719 | 2020-05-16 | St. Charles | Missouri | 29183 | 695 | 52 |
152730 | 152730 | 2020-05-17 | St. Charles | Missouri | 29183 | 701 | 52 |
155744 | 155744 | 2020-05-18 | St. Charles | Missouri | 29183 | 705 | 53 |
158762 | 158762 | 2020-05-19 | St. Charles | Missouri | 29183 | 712 | 53 |
161788 | 161788 | 2020-05-20 | St. Charles | Missouri | 29183 | 715 | 55 |
164817 | 164817 | 2020-05-21 | St. Charles | Missouri | 29183 | 714 | 54 |
167853 | 167853 | 2020-05-22 | St. Charles | Missouri | 29183 | 726 | 54 |
170892 | 170892 | 2020-05-23 | St. Charles | Missouri | 29183 | 730 | 54 |
173934 | 173934 | 2020-05-24 | St. Charles | Missouri | 29183 | 741 | 54 |
176977 | 176977 | 2020-05-25 | St. Charles | Missouri | 29183 | 743 | 54 |
180021 | 180021 | 2020-05-26 | St. Charles | Missouri | 29183 | 748 | 54 |
183069 | 183069 | 2020-05-27 | St. Charles | Missouri | 29183 | 755 | 55 |
186125 | 186125 | 2020-05-28 | St. Charles | Missouri | 29183 | 763 | 55 |
189183 | 189183 | 2020-05-29 | St. Charles | Missouri | 29183 | 768 | 57 |
192247 | 192247 | 2020-05-30 | St. Charles | Missouri | 29183 | 775 | 58 |
195317 | 195317 | 2020-05-31 | St. Charles | Missouri | 29183 | 780 | 59 |
198388 | 198388 | 2020-06-01 | St. Charles | Missouri | 29183 | 787 | 60 |
201461 | 201461 | 2020-06-02 | St. Charles | Missouri | 29183 | 799 | 61 |
204538 | 204538 | 2020-06-03 | St. Charles | Missouri | 29183 | 809 | 61 |
207619 | 207619 | 2020-06-04 | St. Charles | Missouri | 29183 | 821 | 62 |
210700 | 210700 | 2020-06-05 | St. Charles | Missouri | 29183 | 835 | 62 |
213784 | 213784 | 2020-06-06 | St. Charles | Missouri | 29183 | 838 | 62 |
216873 | 216873 | 2020-06-07 | St. Charles | Missouri | 29183 | 844 | 62 |
219965 | 219965 | 2020-06-08 | St. Charles | Missouri | 29183 | 851 | 63 |
223060 | 223060 | 2020-06-09 | St. Charles | Missouri | 29183 | 867 | 63 |
226159 | 226159 | 2020-06-10 | St. Charles | Missouri | 29183 | 879 | 63 |
229262 | 229262 | 2020-06-11 | St. Charles | Missouri | 29183 | 879 | 63 |
232366 | 232366 | 2020-06-12 | St. Charles | Missouri | 29183 | 888 | 64 |
235472 | 235472 | 2020-06-13 | St. Charles | Missouri | 29183 | 895 | 67 |
238579 | 238579 | 2020-06-14 | St. Charles | Missouri | 29183 | 909 | 67 |
241689 | 241689 | 2020-06-15 | St. Charles | Missouri | 29183 | 918 | 67 |
244800 | 244800 | 2020-06-16 | St. Charles | Missouri | 29183 | 924 | 67 |
247913 | 247913 | 2020-06-17 | St. Charles | Missouri | 29183 | 934 | 67 |
251026 | 251026 | 2020-06-18 | St. Charles | Missouri | 29183 | 939 | 72 |
254141 | 254141 | 2020-06-19 | St. Charles | Missouri | 29183 | 945 | 72 |
257262 | 257262 | 2020-06-20 | St. Charles | Missouri | 29183 | 951 | 72 |
260388 | 260388 | 2020-06-21 | St. Charles | Missouri | 29183 | 954 | 72 |
263516 | 263516 | 2020-06-22 | St. Charles | Missouri | 29183 | 959 | 72 |
266642 | 266642 | 2020-06-23 | St. Charles | Missouri | 29183 | 974 | 73 |
269775 | 269775 | 2020-06-24 | St. Charles | Missouri | 29183 | 997 | 73 |
272914 | 272914 | 2020-06-25 | St. Charles | Missouri | 29183 | 1011 | 73 |
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);