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" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
276061 | 276061 | 2020-06-26 | St. Louis city | Missouri | 29510 | 2323 | 155 |
279209 | 279209 | 2020-06-27 | St. Louis city | Missouri | 29510 | 2353 | 155 |
282357 | 282357 | 2020-06-28 | St. Louis city | Missouri | 29510 | 2406 | 155 |
285502 | 285502 | 2020-06-29 | St. Louis city | Missouri | 29510 | 2453 | 155 |
288652 | 288652 | 2020-06-30 | St. Louis city | Missouri | 29510 | 2493 | 156 |
291803 | 291803 | 2020-07-01 | St. Louis city | Missouri | 29510 | 2493 | 156 |
294957 | 294957 | 2020-07-02 | St. Louis city | Missouri | 29510 | 2545 | 157 |
298115 | 298115 | 2020-07-03 | St. Louis city | Missouri | 29510 | 2565 | 158 |
301278 | 301278 | 2020-07-04 | St. Louis city | Missouri | 29510 | 2580 | 158 |
304442 | 304442 | 2020-07-05 | St. Louis city | Missouri | 29510 | 2587 | 158 |
307609 | 307609 | 2020-07-06 | St. Louis city | Missouri | 29510 | 2621 | 158 |
310777 | 310777 | 2020-07-07 | St. Louis city | Missouri | 29510 | 2657 | 158 |
313948 | 313948 | 2020-07-08 | St. Louis city | Missouri | 29510 | 2692 | 158 |
317122 | 317122 | 2020-07-09 | St. Louis city | Missouri | 29510 | 2811 | 158 |
320297 | 320297 | 2020-07-10 | St. Louis city | Missouri | 29510 | 2884 | 158 |
323476 | 323476 | 2020-07-11 | St. Louis city | Missouri | 29510 | 2916 | 158 |
326659 | 326659 | 2020-07-12 | St. Louis city | Missouri | 29510 | 2946 | 158 |
329845 | 329845 | 2020-07-13 | St. Louis city | Missouri | 29510 | 2970 | 159 |
333032 | 333032 | 2020-07-14 | St. Louis city | Missouri | 29510 | 3044 | 161 |
336225 | 336225 | 2020-07-15 | St. Louis city | Missouri | 29510 | 3134 | 161 |
339421 | 339421 | 2020-07-16 | St. Louis city | Missouri | 29510 | 3194 | 161 |
342617 | 342617 | 2020-07-17 | St. Louis city | Missouri | 29510 | 3256 | 161 |
345817 | 345817 | 2020-07-18 | St. Louis city | Missouri | 29510 | 3339 | 161 |
349018 | 349018 | 2020-07-19 | St. Louis city | Missouri | 29510 | 3403 | 161 |
352218 | 352218 | 2020-07-20 | St. Louis city | Missouri | 29510 | 3447 | 161 |
355420 | 355420 | 2020-07-21 | St. Louis city | Missouri | 29510 | 3518 | 161 |
358623 | 358623 | 2020-07-22 | St. Louis city | Missouri | 29510 | 3635 | 164 |
361828 | 361828 | 2020-07-23 | St. Louis city | Missouri | 29510 | 3733 | 164 |
365035 | 365035 | 2020-07-24 | St. Louis city | Missouri | 29510 | 3806 | 164 |
368243 | 368243 | 2020-07-25 | St. Louis city | Missouri | 29510 | 3895 | 164 |
371454 | 371454 | 2020-07-26 | St. Louis city | Missouri | 29510 | 3998 | 164 |
374666 | 374666 | 2020-07-27 | St. Louis city | Missouri | 29510 | 4042 | 165 |
377881 | 377881 | 2020-07-28 | St. Louis city | Missouri | 29510 | 4125 | 167 |
381098 | 381098 | 2020-07-29 | St. Louis city | Missouri | 29510 | 4236 | 167 |
384314 | 384314 | 2020-07-30 | St. Louis city | Missouri | 29510 | 4411 | 169 |
387532 | 387532 | 2020-07-31 | St. Louis city | Missouri | 29510 | 4491 | 169 |
390749 | 390749 | 2020-08-01 | St. Louis city | Missouri | 29510 | 4579 | 169 |
393966 | 393966 | 2020-08-02 | St. Louis city | Missouri | 29510 | 4621 | 169 |
397182 | 397182 | 2020-08-03 | St. Louis city | Missouri | 29510 | 4667 | 171 |
400396 | 400396 | 2020-08-04 | St. Louis city | Missouri | 29510 | 4740 | 171 |
403613 | 403613 | 2020-08-05 | St. Louis city | Missouri | 29510 | 4857 | 171 |
406831 | 406831 | 2020-08-06 | St. Louis city | Missouri | 29510 | 5002 | 171 |
410051 | 410051 | 2020-08-07 | St. Louis city | Missouri | 29510 | 5058 | 172 |
413271 | 413271 | 2020-08-08 | St. Louis city | Missouri | 29510 | 5139 | 174 |
416491 | 416491 | 2020-08-09 | St. Louis city | Missouri | 29510 | 5200 | 174 |
419712 | 419712 | 2020-08-10 | St. Louis city | Missouri | 29510 | 5235 | 176 |
422934 | 422934 | 2020-08-11 | St. Louis city | Missouri | 29510 | 5295 | 177 |
426156 | 426156 | 2020-08-12 | St. Louis city | Missouri | 29510 | 5364 | 178 |
429380 | 429380 | 2020-08-13 | St. Louis city | Missouri | 29510 | 5430 | 178 |
432607 | 432607 | 2020-08-14 | St. Louis city | Missouri | 29510 | 5479 | 178 |
435833 | 435833 | 2020-08-15 | St. Louis city | Missouri | 29510 | 5553 | 181 |
439058 | 439058 | 2020-08-16 | St. Louis city | Missouri | 29510 | 5614 | 181 |
442285 | 442285 | 2020-08-17 | St. Louis city | Missouri | 29510 | 5652 | 181 |
445511 | 445511 | 2020-08-18 | St. Louis city | Missouri | 29510 | 5693 | 181 |
448737 | 448737 | 2020-08-19 | St. Louis city | Missouri | 29510 | 5728 | 181 |
451965 | 451965 | 2020-08-20 | St. Louis city | Missouri | 29510 | 5773 | 181 |
455193 | 455193 | 2020-08-21 | St. Louis city | Missouri | 29510 | 5816 | 182 |
458421 | 458421 | 2020-08-22 | St. Louis city | Missouri | 29510 | 5861 | 184 |
461648 | 461648 | 2020-08-23 | St. Louis city | Missouri | 29510 | 5907 | 184 |
464879 | 464879 | 2020-08-24 | St. Louis city | Missouri | 29510 | 5951 | 184 |
468108 | 468108 | 2020-08-25 | St. Louis city | Missouri | 29510 | 5978 | 187 |
471338 | 471338 | 2020-08-26 | St. Louis city | Missouri | 29510 | 6015 | 188 |
474570 | 474570 | 2020-08-27 | St. Louis city | Missouri | 29510 | 6032 | 188 |
477803 | 477803 | 2020-08-28 | St. Louis city | Missouri | 29510 | 6059 | 188 |
481035 | 481035 | 2020-08-29 | St. Louis city | Missouri | 29510 | 6086 | 188 |
484270 | 484270 | 2020-08-30 | St. Louis city | Missouri | 29510 | 6147 | 188 |
487504 | 487504 | 2020-08-31 | St. Louis city | Missouri | 29510 | 6174 | 188 |
490737 | 490737 | 2020-09-01 | St. Louis city | Missouri | 29510 | 6216 | 188 |
493971 | 493971 | 2020-09-02 | St. Louis city | Missouri | 29510 | 6271 | 188 |
497204 | 497204 | 2020-09-03 | St. Louis city | Missouri | 29510 | 6304 | 188 |
500438 | 500438 | 2020-09-04 | St. Louis city | Missouri | 29510 | 6335 | 189 |
503672 | 503672 | 2020-09-05 | St. Louis city | Missouri | 29510 | 6369 | 195 |
506905 | 506905 | 2020-09-06 | St. Louis city | Missouri | 29510 | 6405 | 195 |
510138 | 510138 | 2020-09-07 | St. Louis city | Missouri | 29510 | 6439 | 195 |
513370 | 513370 | 2020-09-08 | St. Louis city | Missouri | 29510 | 6452 | 195 |
516604 | 516604 | 2020-09-09 | St. Louis city | Missouri | 29510 | 6486 | 195 |
519839 | 519839 | 2020-09-10 | St. Louis city | Missouri | 29510 | 6505 | 196 |
523076 | 523076 | 2020-09-11 | St. Louis city | Missouri | 29510 | 6527 | 196 |
526312 | 526312 | 2020-09-12 | St. Louis city | Missouri | 29510 | 6568 | 196 |
529548 | 529548 | 2020-09-13 | St. Louis city | Missouri | 29510 | 6608 | 196 |
532784 | 532784 | 2020-09-14 | St. Louis city | Missouri | 29510 | 6624 | 196 |
536019 | 536019 | 2020-09-15 | St. Louis city | Missouri | 29510 | 6667 | 196 |
539256 | 539256 | 2020-09-16 | St. Louis city | Missouri | 29510 | 6686 | 196 |
542492 | 542492 | 2020-09-17 | St. Louis city | Missouri | 29510 | 6722 | 196 |
545729 | 545729 | 2020-09-18 | St. Louis city | Missouri | 29510 | 6750 | 196 |
548967 | 548967 | 2020-09-19 | St. Louis city | Missouri | 29510 | 6797 | 197 |
552206 | 552206 | 2020-09-20 | St. Louis city | Missouri | 29510 | 6830 | 197 |
555444 | 555444 | 2020-09-21 | St. Louis city | Missouri | 29510 | 6858 | 197 |
558681 | 558681 | 2020-09-22 | St. Louis city | Missouri | 29510 | 6886 | 207 |
561918 | 561918 | 2020-09-23 | St. Louis city | Missouri | 29510 | 6934 | 208 |
565158 | 565158 | 2020-09-24 | St. Louis city | Missouri | 29510 | 6964 | 207 |
568398 | 568398 | 2020-09-25 | St. Louis city | Missouri | 29510 | 7003 | 207 |
571640 | 571640 | 2020-09-26 | St. Louis city | Missouri | 29510 | 7031 | 215 |
574883 | 574883 | 2020-09-27 | St. Louis city | Missouri | 29510 | 7067 | 215 |
578124 | 578124 | 2020-09-28 | St. Louis city | Missouri | 29510 | 7089 | 215 |
581365 | 581365 | 2020-09-29 | St. Louis city | Missouri | 29510 | 7125 | 215 |
584606 | 584606 | 2020-09-30 | St. Louis city | Missouri | 29510 | 7148 | 213 |
587846 | 587846 | 2020-10-01 | St. Louis city | Missouri | 29510 | 7197 | 213 |
591087 | 591087 | 2020-10-02 | St. Louis city | Missouri | 29510 | 7226 | 213 |
594328 | 594328 | 2020-10-03 | St. Louis city | Missouri | 29510 | 7254 | 213 |
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);