ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "St. Louis city" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387532 | 387532 | 2020-07-31 | St. Louis city | Missouri | 29510 | 4491 | 169 |
384314 | 384314 | 2020-07-30 | St. Louis city | Missouri | 29510 | 4411 | 169 |
381098 | 381098 | 2020-07-29 | St. Louis city | Missouri | 29510 | 4236 | 167 |
377881 | 377881 | 2020-07-28 | St. Louis city | Missouri | 29510 | 4125 | 167 |
374666 | 374666 | 2020-07-27 | St. Louis city | Missouri | 29510 | 4042 | 165 |
371454 | 371454 | 2020-07-26 | St. Louis city | Missouri | 29510 | 3998 | 164 |
368243 | 368243 | 2020-07-25 | St. Louis city | Missouri | 29510 | 3895 | 164 |
365035 | 365035 | 2020-07-24 | St. Louis city | Missouri | 29510 | 3806 | 164 |
361828 | 361828 | 2020-07-23 | St. Louis city | Missouri | 29510 | 3733 | 164 |
358623 | 358623 | 2020-07-22 | St. Louis city | Missouri | 29510 | 3635 | 164 |
355420 | 355420 | 2020-07-21 | St. Louis city | Missouri | 29510 | 3518 | 161 |
352218 | 352218 | 2020-07-20 | St. Louis city | Missouri | 29510 | 3447 | 161 |
349018 | 349018 | 2020-07-19 | St. Louis city | Missouri | 29510 | 3403 | 161 |
345817 | 345817 | 2020-07-18 | St. Louis city | Missouri | 29510 | 3339 | 161 |
342617 | 342617 | 2020-07-17 | St. Louis city | Missouri | 29510 | 3256 | 161 |
339421 | 339421 | 2020-07-16 | St. Louis city | Missouri | 29510 | 3194 | 161 |
336225 | 336225 | 2020-07-15 | St. Louis city | Missouri | 29510 | 3134 | 161 |
333032 | 333032 | 2020-07-14 | St. Louis city | Missouri | 29510 | 3044 | 161 |
329845 | 329845 | 2020-07-13 | St. Louis city | Missouri | 29510 | 2970 | 159 |
326659 | 326659 | 2020-07-12 | St. Louis city | Missouri | 29510 | 2946 | 158 |
323476 | 323476 | 2020-07-11 | St. Louis city | Missouri | 29510 | 2916 | 158 |
320297 | 320297 | 2020-07-10 | St. Louis city | Missouri | 29510 | 2884 | 158 |
317122 | 317122 | 2020-07-09 | St. Louis city | Missouri | 29510 | 2811 | 158 |
313948 | 313948 | 2020-07-08 | St. Louis city | Missouri | 29510 | 2692 | 158 |
310777 | 310777 | 2020-07-07 | St. Louis city | Missouri | 29510 | 2657 | 158 |
307609 | 307609 | 2020-07-06 | St. Louis city | Missouri | 29510 | 2621 | 158 |
304442 | 304442 | 2020-07-05 | St. Louis city | Missouri | 29510 | 2587 | 158 |
301278 | 301278 | 2020-07-04 | St. Louis city | Missouri | 29510 | 2580 | 158 |
298115 | 298115 | 2020-07-03 | St. Louis city | Missouri | 29510 | 2565 | 158 |
294957 | 294957 | 2020-07-02 | St. Louis city | Missouri | 29510 | 2545 | 157 |
291803 | 291803 | 2020-07-01 | St. Louis city | Missouri | 29510 | 2493 | 156 |
288652 | 288652 | 2020-06-30 | St. Louis city | Missouri | 29510 | 2493 | 156 |
285502 | 285502 | 2020-06-29 | St. Louis city | Missouri | 29510 | 2453 | 155 |
282357 | 282357 | 2020-06-28 | St. Louis city | Missouri | 29510 | 2406 | 155 |
279209 | 279209 | 2020-06-27 | St. Louis city | Missouri | 29510 | 2353 | 155 |
276061 | 276061 | 2020-06-26 | St. Louis city | Missouri | 29510 | 2323 | 155 |
272918 | 272918 | 2020-06-25 | St. Louis city | Missouri | 29510 | 2310 | 155 |
269779 | 269779 | 2020-06-24 | St. Louis city | Missouri | 29510 | 2319 | 154 |
266646 | 266646 | 2020-06-23 | St. Louis city | Missouri | 29510 | 2319 | 154 |
263520 | 263520 | 2020-06-22 | St. Louis city | Missouri | 29510 | 2319 | 154 |
260392 | 260392 | 2020-06-21 | St. Louis city | Missouri | 29510 | 2319 | 154 |
257266 | 257266 | 2020-06-20 | St. Louis city | Missouri | 29510 | 2319 | 154 |
254145 | 254145 | 2020-06-19 | St. Louis city | Missouri | 29510 | 2319 | 154 |
251030 | 251030 | 2020-06-18 | St. Louis city | Missouri | 29510 | 2292 | 148 |
247917 | 247917 | 2020-06-17 | St. Louis city | Missouri | 29510 | 2234 | 142 |
244804 | 244804 | 2020-06-16 | St. Louis city | Missouri | 29510 | 2219 | 141 |
241693 | 241693 | 2020-06-15 | St. Louis city | Missouri | 29510 | 2219 | 141 |
238583 | 238583 | 2020-06-14 | St. Louis city | Missouri | 29510 | 2206 | 141 |
235476 | 235476 | 2020-06-13 | St. Louis city | Missouri | 29510 | 2195 | 141 |
232370 | 232370 | 2020-06-12 | St. Louis city | Missouri | 29510 | 2179 | 141 |
229266 | 229266 | 2020-06-11 | St. Louis city | Missouri | 29510 | 2162 | 139 |
226163 | 226163 | 2020-06-10 | St. Louis city | Missouri | 29510 | 2145 | 139 |
223064 | 223064 | 2020-06-09 | St. Louis city | Missouri | 29510 | 2132 | 139 |
219969 | 219969 | 2020-06-08 | St. Louis city | Missouri | 29510 | 2071 | 135 |
216877 | 216877 | 2020-06-07 | St. Louis city | Missouri | 29510 | 2071 | 135 |
213788 | 213788 | 2020-06-06 | St. Louis city | Missouri | 29510 | 2068 | 135 |
210704 | 210704 | 2020-06-05 | St. Louis city | Missouri | 29510 | 2053 | 134 |
207623 | 207623 | 2020-06-04 | St. Louis city | Missouri | 29510 | 2034 | 132 |
204542 | 204542 | 2020-06-03 | St. Louis city | Missouri | 29510 | 2006 | 132 |
201465 | 201465 | 2020-06-02 | St. Louis city | Missouri | 29510 | 1990 | 131 |
198392 | 198392 | 2020-06-01 | St. Louis city | Missouri | 29510 | 1974 | 130 |
195321 | 195321 | 2020-05-31 | St. Louis city | Missouri | 29510 | 1955 | 130 |
192251 | 192251 | 2020-05-30 | St. Louis city | Missouri | 29510 | 1930 | 130 |
189187 | 189187 | 2020-05-29 | St. Louis city | Missouri | 29510 | 1916 | 118 |
186129 | 186129 | 2020-05-28 | St. Louis city | Missouri | 29510 | 1906 | 118 |
183073 | 183073 | 2020-05-27 | St. Louis city | Missouri | 29510 | 1884 | 117 |
180025 | 180025 | 2020-05-26 | St. Louis city | Missouri | 29510 | 1867 | 116 |
176981 | 176981 | 2020-05-25 | St. Louis city | Missouri | 29510 | 1849 | 112 |
173938 | 173938 | 2020-05-24 | St. Louis city | Missouri | 29510 | 1815 | 112 |
170896 | 170896 | 2020-05-23 | St. Louis city | Missouri | 29510 | 1789 | 110 |
167857 | 167857 | 2020-05-22 | St. Louis city | Missouri | 29510 | 1763 | 110 |
164821 | 164821 | 2020-05-21 | St. Louis city | Missouri | 29510 | 1744 | 109 |
161792 | 161792 | 2020-05-20 | St. Louis city | Missouri | 29510 | 1717 | 109 |
158766 | 158766 | 2020-05-19 | St. Louis city | Missouri | 29510 | 1705 | 108 |
155748 | 155748 | 2020-05-18 | St. Louis city | Missouri | 29510 | 1682 | 100 |
152734 | 152734 | 2020-05-17 | St. Louis city | Missouri | 29510 | 1654 | 97 |
149723 | 149723 | 2020-05-16 | St. Louis city | Missouri | 29510 | 1631 | 96 |
146717 | 146717 | 2020-05-15 | St. Louis city | Missouri | 29510 | 1602 | 95 |
143716 | 143716 | 2020-05-14 | St. Louis city | Missouri | 29510 | 1596 | 95 |
140721 | 140721 | 2020-05-13 | St. Louis city | Missouri | 29510 | 1571 | 95 |
137727 | 137727 | 2020-05-12 | St. Louis city | Missouri | 29510 | 1549 | 91 |
134737 | 134737 | 2020-05-11 | St. Louis city | Missouri | 29510 | 1526 | 90 |
131746 | 131746 | 2020-05-10 | St. Louis city | Missouri | 29510 | 1513 | 88 |
128756 | 128756 | 2020-05-09 | St. Louis city | Missouri | 29510 | 1484 | 86 |
125768 | 125768 | 2020-05-08 | St. Louis city | Missouri | 29510 | 1474 | 85 |
122786 | 122786 | 2020-05-07 | St. Louis city | Missouri | 29510 | 1450 | 83 |
119812 | 119812 | 2020-05-06 | St. Louis city | Missouri | 29510 | 1384 | 82 |
116852 | 116852 | 2020-05-05 | St. Louis city | Missouri | 29510 | 1315 | 78 |
113970 | 113970 | 2020-05-04 | St. Louis city | Missouri | 29510 | 1304 | 71 |
111091 | 111091 | 2020-05-03 | St. Louis city | Missouri | 29510 | 1304 | 70 |
108219 | 108219 | 2020-05-02 | St. Louis city | Missouri | 29510 | 1186 | 65 |
105354 | 105354 | 2020-05-01 | St. Louis city | Missouri | 29510 | 1105 | 64 |
102493 | 102493 | 2020-04-30 | St. Louis city | Missouri | 29510 | 1077 | 60 |
99641 | 99641 | 2020-04-29 | St. Louis city | Missouri | 29510 | 1067 | 60 |
96795 | 96795 | 2020-04-28 | St. Louis city | Missouri | 29510 | 1054 | 55 |
93959 | 93959 | 2020-04-27 | St. Louis city | Missouri | 29510 | 1027 | 54 |
91138 | 91138 | 2020-04-26 | St. Louis city | Missouri | 29510 | 1007 | 50 |
88322 | 88322 | 2020-04-25 | St. Louis city | Missouri | 29510 | 985 | 50 |
85512 | 85512 | 2020-04-24 | St. Louis city | Missouri | 29510 | 950 | 48 |
82708 | 82708 | 2020-04-23 | St. Louis city | Missouri | 29510 | 909 | 46 |
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);