ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Scott" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536012 | 536012 | 2020-09-15 | Scott | Missouri | 29201 | 756 | 15 |
532777 | 532777 | 2020-09-14 | Scott | Missouri | 29201 | 752 | 15 |
529541 | 529541 | 2020-09-13 | Scott | Missouri | 29201 | 746 | 15 |
526305 | 526305 | 2020-09-12 | Scott | Missouri | 29201 | 732 | 15 |
523069 | 523069 | 2020-09-11 | Scott | Missouri | 29201 | 725 | 15 |
519832 | 519832 | 2020-09-10 | Scott | Missouri | 29201 | 713 | 15 |
516597 | 516597 | 2020-09-09 | Scott | Missouri | 29201 | 708 | 15 |
513363 | 513363 | 2020-09-08 | Scott | Missouri | 29201 | 692 | 14 |
510131 | 510131 | 2020-09-07 | Scott | Missouri | 29201 | 690 | 14 |
506898 | 506898 | 2020-09-06 | Scott | Missouri | 29201 | 684 | 14 |
503665 | 503665 | 2020-09-05 | Scott | Missouri | 29201 | 679 | 14 |
500431 | 500431 | 2020-09-04 | Scott | Missouri | 29201 | 662 | 14 |
497197 | 497197 | 2020-09-03 | Scott | Missouri | 29201 | 655 | 14 |
493964 | 493964 | 2020-09-02 | Scott | Missouri | 29201 | 652 | 14 |
490730 | 490730 | 2020-09-01 | Scott | Missouri | 29201 | 632 | 14 |
487497 | 487497 | 2020-08-31 | Scott | Missouri | 29201 | 625 | 14 |
484263 | 484263 | 2020-08-30 | Scott | Missouri | 29201 | 619 | 14 |
481028 | 481028 | 2020-08-29 | Scott | Missouri | 29201 | 606 | 14 |
477796 | 477796 | 2020-08-28 | Scott | Missouri | 29201 | 582 | 13 |
474563 | 474563 | 2020-08-27 | Scott | Missouri | 29201 | 581 | 13 |
471331 | 471331 | 2020-08-26 | Scott | Missouri | 29201 | 565 | 13 |
468101 | 468101 | 2020-08-25 | Scott | Missouri | 29201 | 551 | 13 |
464872 | 464872 | 2020-08-24 | Scott | Missouri | 29201 | 548 | 13 |
461641 | 461641 | 2020-08-23 | Scott | Missouri | 29201 | 544 | 13 |
458414 | 458414 | 2020-08-22 | Scott | Missouri | 29201 | 544 | 13 |
455186 | 455186 | 2020-08-21 | Scott | Missouri | 29201 | 535 | 13 |
451958 | 451958 | 2020-08-20 | Scott | Missouri | 29201 | 519 | 13 |
448730 | 448730 | 2020-08-19 | Scott | Missouri | 29201 | 515 | 13 |
445504 | 445504 | 2020-08-18 | Scott | Missouri | 29201 | 492 | 13 |
442278 | 442278 | 2020-08-17 | Scott | Missouri | 29201 | 492 | 13 |
439051 | 439051 | 2020-08-16 | Scott | Missouri | 29201 | 476 | 13 |
435826 | 435826 | 2020-08-15 | Scott | Missouri | 29201 | 461 | 13 |
432600 | 432600 | 2020-08-14 | Scott | Missouri | 29201 | 449 | 13 |
429373 | 429373 | 2020-08-13 | Scott | Missouri | 29201 | 429 | 13 |
426149 | 426149 | 2020-08-12 | Scott | Missouri | 29201 | 421 | 13 |
422927 | 422927 | 2020-08-11 | Scott | Missouri | 29201 | 406 | 13 |
419705 | 419705 | 2020-08-10 | Scott | Missouri | 29201 | 400 | 13 |
416484 | 416484 | 2020-08-09 | Scott | Missouri | 29201 | 395 | 13 |
413264 | 413264 | 2020-08-08 | Scott | Missouri | 29201 | 381 | 13 |
410044 | 410044 | 2020-08-07 | Scott | Missouri | 29201 | 381 | 13 |
406824 | 406824 | 2020-08-06 | Scott | Missouri | 29201 | 368 | 13 |
403606 | 403606 | 2020-08-05 | Scott | Missouri | 29201 | 358 | 13 |
400389 | 400389 | 2020-08-04 | Scott | Missouri | 29201 | 356 | 13 |
397175 | 397175 | 2020-08-03 | Scott | Missouri | 29201 | 352 | 13 |
393959 | 393959 | 2020-08-02 | Scott | Missouri | 29201 | 345 | 13 |
390742 | 390742 | 2020-08-01 | Scott | Missouri | 29201 | 341 | 13 |
387525 | 387525 | 2020-07-31 | Scott | Missouri | 29201 | 342 | 13 |
384307 | 384307 | 2020-07-30 | Scott | Missouri | 29201 | 330 | 13 |
381091 | 381091 | 2020-07-29 | Scott | Missouri | 29201 | 313 | 13 |
377874 | 377874 | 2020-07-28 | Scott | Missouri | 29201 | 311 | 13 |
374659 | 374659 | 2020-07-27 | Scott | Missouri | 29201 | 294 | 13 |
371447 | 371447 | 2020-07-26 | Scott | Missouri | 29201 | 285 | 13 |
368236 | 368236 | 2020-07-25 | Scott | Missouri | 29201 | 286 | 13 |
365028 | 365028 | 2020-07-24 | Scott | Missouri | 29201 | 282 | 13 |
361821 | 361821 | 2020-07-23 | Scott | Missouri | 29201 | 272 | 13 |
358616 | 358616 | 2020-07-22 | Scott | Missouri | 29201 | 266 | 13 |
355413 | 355413 | 2020-07-21 | Scott | Missouri | 29201 | 250 | 13 |
352211 | 352211 | 2020-07-20 | Scott | Missouri | 29201 | 244 | 13 |
349011 | 349011 | 2020-07-19 | Scott | Missouri | 29201 | 244 | 13 |
345810 | 345810 | 2020-07-18 | Scott | Missouri | 29201 | 242 | 13 |
342610 | 342610 | 2020-07-17 | Scott | Missouri | 29201 | 240 | 13 |
339414 | 339414 | 2020-07-16 | Scott | Missouri | 29201 | 237 | 13 |
336218 | 336218 | 2020-07-15 | Scott | Missouri | 29201 | 235 | 13 |
333025 | 333025 | 2020-07-14 | Scott | Missouri | 29201 | 219 | 12 |
329838 | 329838 | 2020-07-13 | Scott | Missouri | 29201 | 209 | 12 |
326652 | 326652 | 2020-07-12 | Scott | Missouri | 29201 | 207 | 12 |
323469 | 323469 | 2020-07-11 | Scott | Missouri | 29201 | 206 | 12 |
320290 | 320290 | 2020-07-10 | Scott | Missouri | 29201 | 198 | 12 |
317115 | 317115 | 2020-07-09 | Scott | Missouri | 29201 | 192 | 11 |
313941 | 313941 | 2020-07-08 | Scott | Missouri | 29201 | 191 | 11 |
310770 | 310770 | 2020-07-07 | Scott | Missouri | 29201 | 188 | 11 |
307602 | 307602 | 2020-07-06 | Scott | Missouri | 29201 | 185 | 11 |
304435 | 304435 | 2020-07-05 | Scott | Missouri | 29201 | 181 | 11 |
301271 | 301271 | 2020-07-04 | Scott | Missouri | 29201 | 173 | 11 |
298108 | 298108 | 2020-07-03 | Scott | Missouri | 29201 | 172 | 11 |
294950 | 294950 | 2020-07-02 | Scott | Missouri | 29201 | 170 | 11 |
291796 | 291796 | 2020-07-01 | Scott | Missouri | 29201 | 169 | 11 |
288645 | 288645 | 2020-06-30 | Scott | Missouri | 29201 | 168 | 11 |
285495 | 285495 | 2020-06-29 | Scott | Missouri | 29201 | 164 | 11 |
282350 | 282350 | 2020-06-28 | Scott | Missouri | 29201 | 162 | 11 |
279202 | 279202 | 2020-06-27 | Scott | Missouri | 29201 | 161 | 11 |
276054 | 276054 | 2020-06-26 | Scott | Missouri | 29201 | 161 | 11 |
272911 | 272911 | 2020-06-25 | Scott | Missouri | 29201 | 159 | 11 |
269772 | 269772 | 2020-06-24 | Scott | Missouri | 29201 | 159 | 11 |
266639 | 266639 | 2020-06-23 | Scott | Missouri | 29201 | 159 | 11 |
263513 | 263513 | 2020-06-22 | Scott | Missouri | 29201 | 160 | 11 |
260385 | 260385 | 2020-06-21 | Scott | Missouri | 29201 | 159 | 10 |
257259 | 257259 | 2020-06-20 | Scott | Missouri | 29201 | 157 | 10 |
254138 | 254138 | 2020-06-19 | Scott | Missouri | 29201 | 155 | 10 |
251023 | 251023 | 2020-06-18 | Scott | Missouri | 29201 | 149 | 10 |
247910 | 247910 | 2020-06-17 | Scott | Missouri | 29201 | 149 | 10 |
244797 | 244797 | 2020-06-16 | Scott | Missouri | 29201 | 145 | 10 |
241686 | 241686 | 2020-06-15 | Scott | Missouri | 29201 | 145 | 10 |
238576 | 238576 | 2020-06-14 | Scott | Missouri | 29201 | 139 | 10 |
235469 | 235469 | 2020-06-13 | Scott | Missouri | 29201 | 139 | 10 |
232363 | 232363 | 2020-06-12 | Scott | Missouri | 29201 | 134 | 10 |
229259 | 229259 | 2020-06-11 | Scott | Missouri | 29201 | 132 | 10 |
226156 | 226156 | 2020-06-10 | Scott | Missouri | 29201 | 128 | 10 |
223057 | 223057 | 2020-06-09 | Scott | Missouri | 29201 | 127 | 10 |
219962 | 219962 | 2020-06-08 | Scott | Missouri | 29201 | 123 | 10 |
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);