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 |
---|---|---|---|---|---|---|---|
536019 | 536019 | 2020-09-15 | St. Louis city | Missouri | 29510 | 6667 | 196 |
532784 | 532784 | 2020-09-14 | St. Louis city | Missouri | 29510 | 6624 | 196 |
529548 | 529548 | 2020-09-13 | St. Louis city | Missouri | 29510 | 6608 | 196 |
526312 | 526312 | 2020-09-12 | St. Louis city | Missouri | 29510 | 6568 | 196 |
523076 | 523076 | 2020-09-11 | St. Louis city | Missouri | 29510 | 6527 | 196 |
519839 | 519839 | 2020-09-10 | St. Louis city | Missouri | 29510 | 6505 | 196 |
516604 | 516604 | 2020-09-09 | St. Louis city | Missouri | 29510 | 6486 | 195 |
513370 | 513370 | 2020-09-08 | St. Louis city | Missouri | 29510 | 6452 | 195 |
510138 | 510138 | 2020-09-07 | St. Louis city | Missouri | 29510 | 6439 | 195 |
506905 | 506905 | 2020-09-06 | St. Louis city | Missouri | 29510 | 6405 | 195 |
503672 | 503672 | 2020-09-05 | St. Louis city | Missouri | 29510 | 6369 | 195 |
500438 | 500438 | 2020-09-04 | St. Louis city | Missouri | 29510 | 6335 | 189 |
497204 | 497204 | 2020-09-03 | St. Louis city | Missouri | 29510 | 6304 | 188 |
493971 | 493971 | 2020-09-02 | St. Louis city | Missouri | 29510 | 6271 | 188 |
490737 | 490737 | 2020-09-01 | St. Louis city | Missouri | 29510 | 6216 | 188 |
487504 | 487504 | 2020-08-31 | St. Louis city | Missouri | 29510 | 6174 | 188 |
484270 | 484270 | 2020-08-30 | St. Louis city | Missouri | 29510 | 6147 | 188 |
481035 | 481035 | 2020-08-29 | St. Louis city | Missouri | 29510 | 6086 | 188 |
477803 | 477803 | 2020-08-28 | St. Louis city | Missouri | 29510 | 6059 | 188 |
474570 | 474570 | 2020-08-27 | St. Louis city | Missouri | 29510 | 6032 | 188 |
471338 | 471338 | 2020-08-26 | St. Louis city | Missouri | 29510 | 6015 | 188 |
468108 | 468108 | 2020-08-25 | St. Louis city | Missouri | 29510 | 5978 | 187 |
464879 | 464879 | 2020-08-24 | St. Louis city | Missouri | 29510 | 5951 | 184 |
461648 | 461648 | 2020-08-23 | St. Louis city | Missouri | 29510 | 5907 | 184 |
458421 | 458421 | 2020-08-22 | St. Louis city | Missouri | 29510 | 5861 | 184 |
455193 | 455193 | 2020-08-21 | St. Louis city | Missouri | 29510 | 5816 | 182 |
451965 | 451965 | 2020-08-20 | St. Louis city | Missouri | 29510 | 5773 | 181 |
448737 | 448737 | 2020-08-19 | St. Louis city | Missouri | 29510 | 5728 | 181 |
445511 | 445511 | 2020-08-18 | St. Louis city | Missouri | 29510 | 5693 | 181 |
442285 | 442285 | 2020-08-17 | St. Louis city | Missouri | 29510 | 5652 | 181 |
439058 | 439058 | 2020-08-16 | St. Louis city | Missouri | 29510 | 5614 | 181 |
435833 | 435833 | 2020-08-15 | St. Louis city | Missouri | 29510 | 5553 | 181 |
432607 | 432607 | 2020-08-14 | St. Louis city | Missouri | 29510 | 5479 | 178 |
429380 | 429380 | 2020-08-13 | St. Louis city | Missouri | 29510 | 5430 | 178 |
426156 | 426156 | 2020-08-12 | St. Louis city | Missouri | 29510 | 5364 | 178 |
422934 | 422934 | 2020-08-11 | St. Louis city | Missouri | 29510 | 5295 | 177 |
419712 | 419712 | 2020-08-10 | St. Louis city | Missouri | 29510 | 5235 | 176 |
416491 | 416491 | 2020-08-09 | St. Louis city | Missouri | 29510 | 5200 | 174 |
413271 | 413271 | 2020-08-08 | St. Louis city | Missouri | 29510 | 5139 | 174 |
410051 | 410051 | 2020-08-07 | St. Louis city | Missouri | 29510 | 5058 | 172 |
406831 | 406831 | 2020-08-06 | St. Louis city | Missouri | 29510 | 5002 | 171 |
403613 | 403613 | 2020-08-05 | St. Louis city | Missouri | 29510 | 4857 | 171 |
400396 | 400396 | 2020-08-04 | St. Louis city | Missouri | 29510 | 4740 | 171 |
397182 | 397182 | 2020-08-03 | St. Louis city | Missouri | 29510 | 4667 | 171 |
393966 | 393966 | 2020-08-02 | St. Louis city | Missouri | 29510 | 4621 | 169 |
390749 | 390749 | 2020-08-01 | St. Louis city | Missouri | 29510 | 4579 | 169 |
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 |
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);