ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where county = "Scott" and deaths = 13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Scott · 77 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
914120 | 914120 | 2021-01-10 | Scott | Arkansas | 5127 | 718 | 13 |
910875 | 910875 | 2021-01-09 | Scott | Arkansas | 5127 | 704 | 13 |
907630 | 907630 | 2021-01-08 | Scott | Arkansas | 5127 | 686 | 13 |
904384 | 904384 | 2021-01-07 | Scott | Arkansas | 5127 | 675 | 13 |
869492 | 869492 | 2020-12-27 | Scott | Kansas | 20171 | 537 | 13 |
866247 | 866247 | 2020-12-26 | Scott | Kansas | 20171 | 537 | 13 |
863002 | 863002 | 2020-12-25 | Scott | Kansas | 20171 | 537 | 13 |
859757 | 859757 | 2020-12-24 | Scott | Kansas | 20171 | 537 | 13 |
856512 | 856512 | 2020-12-23 | Scott | Kansas | 20171 | 537 | 13 |
853267 | 853267 | 2020-12-22 | Scott | Kansas | 20171 | 537 | 13 |
764452 | 764452 | 2020-11-24 | Scott | Virginia | 51169 | 727 | 13 |
622682 | 622682 | 2020-10-12 | Scott | Indiana | 18143 | 484 | 13 |
619438 | 619438 | 2020-10-11 | Scott | Indiana | 18143 | 475 | 13 |
616196 | 616196 | 2020-10-10 | Scott | Indiana | 18143 | 466 | 13 |
612955 | 612955 | 2020-10-09 | Scott | Indiana | 18143 | 460 | 13 |
609713 | 609713 | 2020-10-08 | Scott | Indiana | 18143 | 449 | 13 |
606470 | 606470 | 2020-10-07 | Scott | Indiana | 18143 | 447 | 13 |
603228 | 603228 | 2020-10-06 | Scott | Indiana | 18143 | 442 | 13 |
599985 | 599985 | 2020-10-05 | Scott | Indiana | 18143 | 439 | 13 |
596743 | 596743 | 2020-10-04 | Scott | Indiana | 18143 | 430 | 13 |
593501 | 593501 | 2020-10-03 | Scott | Indiana | 18143 | 421 | 13 |
590260 | 590260 | 2020-10-02 | Scott | Indiana | 18143 | 415 | 13 |
587019 | 587019 | 2020-10-01 | Scott | Indiana | 18143 | 406 | 13 |
583779 | 583779 | 2020-09-30 | Scott | Indiana | 18143 | 402 | 13 |
580540 | 580540 | 2020-09-29 | Scott | Indiana | 18143 | 399 | 13 |
577299 | 577299 | 2020-09-28 | Scott | Indiana | 18143 | 396 | 13 |
574057 | 574057 | 2020-09-27 | Scott | Indiana | 18143 | 387 | 13 |
570814 | 570814 | 2020-09-26 | Scott | Indiana | 18143 | 383 | 13 |
567572 | 567572 | 2020-09-25 | Scott | Indiana | 18143 | 379 | 13 |
564332 | 564332 | 2020-09-24 | Scott | Indiana | 18143 | 373 | 13 |
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 |
402893 | 402893 | 2020-08-05 | Scott | Iowa | 19163 | 1636 | 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 |
390544 | 390544 | 2020-08-01 | Scott | Minnesota | 27139 | 1339 | 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 |
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);