ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "St. Charles" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387528 | 387528 | 2020-07-31 | St. Charles | Missouri | 29183 | 3543 | 96 |
384310 | 384310 | 2020-07-30 | St. Charles | Missouri | 29183 | 3456 | 96 |
381094 | 381094 | 2020-07-29 | St. Charles | Missouri | 29183 | 3360 | 93 |
377877 | 377877 | 2020-07-28 | St. Charles | Missouri | 29183 | 3263 | 93 |
374662 | 374662 | 2020-07-27 | St. Charles | Missouri | 29183 | 3134 | 90 |
371450 | 371450 | 2020-07-26 | St. Charles | Missouri | 29183 | 2998 | 86 |
368239 | 368239 | 2020-07-25 | St. Charles | Missouri | 29183 | 2866 | 86 |
365031 | 365031 | 2020-07-24 | St. Charles | Missouri | 29183 | 2843 | 86 |
361824 | 361824 | 2020-07-23 | St. Charles | Missouri | 29183 | 2761 | 85 |
358619 | 358619 | 2020-07-22 | St. Charles | Missouri | 29183 | 2693 | 84 |
355416 | 355416 | 2020-07-21 | St. Charles | Missouri | 29183 | 2612 | 81 |
352214 | 352214 | 2020-07-20 | St. Charles | Missouri | 29183 | 2468 | 81 |
349014 | 349014 | 2020-07-19 | St. Charles | Missouri | 29183 | 2296 | 80 |
345813 | 345813 | 2020-07-18 | St. Charles | Missouri | 29183 | 2223 | 80 |
342613 | 342613 | 2020-07-17 | St. Charles | Missouri | 29183 | 2137 | 80 |
339417 | 339417 | 2020-07-16 | St. Charles | Missouri | 29183 | 2070 | 80 |
336221 | 336221 | 2020-07-15 | St. Charles | Missouri | 29183 | 1988 | 80 |
333028 | 333028 | 2020-07-14 | St. Charles | Missouri | 29183 | 1882 | 80 |
329841 | 329841 | 2020-07-13 | St. Charles | Missouri | 29183 | 1760 | 80 |
326655 | 326655 | 2020-07-12 | St. Charles | Missouri | 29183 | 1691 | 77 |
323472 | 323472 | 2020-07-11 | St. Charles | Missouri | 29183 | 1599 | 77 |
320293 | 320293 | 2020-07-10 | St. Charles | Missouri | 29183 | 1526 | 77 |
317118 | 317118 | 2020-07-09 | St. Charles | Missouri | 29183 | 1456 | 77 |
313944 | 313944 | 2020-07-08 | St. Charles | Missouri | 29183 | 1355 | 77 |
310773 | 310773 | 2020-07-07 | St. Charles | Missouri | 29183 | 1288 | 77 |
307605 | 307605 | 2020-07-06 | St. Charles | Missouri | 29183 | 1239 | 77 |
304438 | 304438 | 2020-07-05 | St. Charles | Missouri | 29183 | 1204 | 76 |
301274 | 301274 | 2020-07-04 | St. Charles | Missouri | 29183 | 1183 | 76 |
298111 | 298111 | 2020-07-03 | St. Charles | Missouri | 29183 | 1163 | 76 |
294953 | 294953 | 2020-07-02 | St. Charles | Missouri | 29183 | 1135 | 76 |
291799 | 291799 | 2020-07-01 | St. Charles | Missouri | 29183 | 1095 | 76 |
288648 | 288648 | 2020-06-30 | St. Charles | Missouri | 29183 | 1078 | 74 |
285498 | 285498 | 2020-06-29 | St. Charles | Missouri | 29183 | 1073 | 74 |
282353 | 282353 | 2020-06-28 | St. Charles | Missouri | 29183 | 1045 | 73 |
279205 | 279205 | 2020-06-27 | St. Charles | Missouri | 29183 | 1020 | 73 |
276057 | 276057 | 2020-06-26 | St. Charles | Missouri | 29183 | 1020 | 73 |
272914 | 272914 | 2020-06-25 | St. Charles | Missouri | 29183 | 1011 | 73 |
269775 | 269775 | 2020-06-24 | St. Charles | Missouri | 29183 | 997 | 73 |
266642 | 266642 | 2020-06-23 | St. Charles | Missouri | 29183 | 974 | 73 |
263516 | 263516 | 2020-06-22 | St. Charles | Missouri | 29183 | 959 | 72 |
260388 | 260388 | 2020-06-21 | St. Charles | Missouri | 29183 | 954 | 72 |
257262 | 257262 | 2020-06-20 | St. Charles | Missouri | 29183 | 951 | 72 |
254141 | 254141 | 2020-06-19 | St. Charles | Missouri | 29183 | 945 | 72 |
251026 | 251026 | 2020-06-18 | St. Charles | Missouri | 29183 | 939 | 72 |
247913 | 247913 | 2020-06-17 | St. Charles | Missouri | 29183 | 934 | 67 |
244800 | 244800 | 2020-06-16 | St. Charles | Missouri | 29183 | 924 | 67 |
241689 | 241689 | 2020-06-15 | St. Charles | Missouri | 29183 | 918 | 67 |
238579 | 238579 | 2020-06-14 | St. Charles | Missouri | 29183 | 909 | 67 |
235472 | 235472 | 2020-06-13 | St. Charles | Missouri | 29183 | 895 | 67 |
232366 | 232366 | 2020-06-12 | St. Charles | Missouri | 29183 | 888 | 64 |
229262 | 229262 | 2020-06-11 | St. Charles | Missouri | 29183 | 879 | 63 |
226159 | 226159 | 2020-06-10 | St. Charles | Missouri | 29183 | 879 | 63 |
223060 | 223060 | 2020-06-09 | St. Charles | Missouri | 29183 | 867 | 63 |
219965 | 219965 | 2020-06-08 | St. Charles | Missouri | 29183 | 851 | 63 |
216873 | 216873 | 2020-06-07 | St. Charles | Missouri | 29183 | 844 | 62 |
213784 | 213784 | 2020-06-06 | St. Charles | Missouri | 29183 | 838 | 62 |
210700 | 210700 | 2020-06-05 | St. Charles | Missouri | 29183 | 835 | 62 |
207619 | 207619 | 2020-06-04 | St. Charles | Missouri | 29183 | 821 | 62 |
204538 | 204538 | 2020-06-03 | St. Charles | Missouri | 29183 | 809 | 61 |
201461 | 201461 | 2020-06-02 | St. Charles | Missouri | 29183 | 799 | 61 |
198388 | 198388 | 2020-06-01 | St. Charles | Missouri | 29183 | 787 | 60 |
195317 | 195317 | 2020-05-31 | St. Charles | Missouri | 29183 | 780 | 59 |
192247 | 192247 | 2020-05-30 | St. Charles | Missouri | 29183 | 775 | 58 |
189183 | 189183 | 2020-05-29 | St. Charles | Missouri | 29183 | 768 | 57 |
186125 | 186125 | 2020-05-28 | St. Charles | Missouri | 29183 | 763 | 55 |
183069 | 183069 | 2020-05-27 | St. Charles | Missouri | 29183 | 755 | 55 |
180021 | 180021 | 2020-05-26 | St. Charles | Missouri | 29183 | 748 | 54 |
176977 | 176977 | 2020-05-25 | St. Charles | Missouri | 29183 | 743 | 54 |
173934 | 173934 | 2020-05-24 | St. Charles | Missouri | 29183 | 741 | 54 |
170892 | 170892 | 2020-05-23 | St. Charles | Missouri | 29183 | 730 | 54 |
167853 | 167853 | 2020-05-22 | St. Charles | Missouri | 29183 | 726 | 54 |
164817 | 164817 | 2020-05-21 | St. Charles | Missouri | 29183 | 714 | 54 |
161788 | 161788 | 2020-05-20 | St. Charles | Missouri | 29183 | 715 | 55 |
158762 | 158762 | 2020-05-19 | St. Charles | Missouri | 29183 | 712 | 53 |
155744 | 155744 | 2020-05-18 | St. Charles | Missouri | 29183 | 705 | 53 |
152730 | 152730 | 2020-05-17 | St. Charles | Missouri | 29183 | 701 | 52 |
149719 | 149719 | 2020-05-16 | St. Charles | Missouri | 29183 | 695 | 52 |
146713 | 146713 | 2020-05-15 | St. Charles | Missouri | 29183 | 688 | 52 |
143712 | 143712 | 2020-05-14 | St. Charles | Missouri | 29183 | 688 | 52 |
140717 | 140717 | 2020-05-13 | St. Charles | Missouri | 29183 | 681 | 50 |
137723 | 137723 | 2020-05-12 | St. Charles | Missouri | 29183 | 680 | 50 |
134733 | 134733 | 2020-05-11 | St. Charles | Missouri | 29183 | 684 | 50 |
131742 | 131742 | 2020-05-10 | St. Charles | Missouri | 29183 | 670 | 47 |
128752 | 128752 | 2020-05-09 | St. Charles | Missouri | 29183 | 668 | 46 |
125764 | 125764 | 2020-05-08 | St. Charles | Missouri | 29183 | 663 | 46 |
122782 | 122782 | 2020-05-07 | St. Charles | Missouri | 29183 | 646 | 46 |
119808 | 119808 | 2020-05-06 | St. Charles | Missouri | 29183 | 639 | 45 |
116848 | 116848 | 2020-05-05 | St. Charles | Missouri | 29183 | 626 | 43 |
113966 | 113966 | 2020-05-04 | St. Charles | Missouri | 29183 | 624 | 42 |
111087 | 111087 | 2020-05-03 | St. Charles | Missouri | 29183 | 612 | 41 |
108215 | 108215 | 2020-05-02 | St. Charles | Missouri | 29183 | 596 | 41 |
105350 | 105350 | 2020-05-01 | St. Charles | Missouri | 29183 | 577 | 35 |
102489 | 102489 | 2020-04-30 | St. Charles | Missouri | 29183 | 566 | 34 |
99637 | 99637 | 2020-04-29 | St. Charles | Missouri | 29183 | 560 | 34 |
96791 | 96791 | 2020-04-28 | St. Charles | Missouri | 29183 | 555 | 34 |
93955 | 93955 | 2020-04-27 | St. Charles | Missouri | 29183 | 543 | 31 |
91134 | 91134 | 2020-04-26 | St. Charles | Missouri | 29183 | 526 | 31 |
88318 | 88318 | 2020-04-25 | St. Charles | Missouri | 29183 | 513 | 29 |
85508 | 85508 | 2020-04-24 | St. Charles | Missouri | 29183 | 502 | 26 |
82704 | 82704 | 2020-04-23 | St. Charles | Missouri | 29183 | 476 | 26 |
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);