ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,478 rows where county = "Scott" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
315711 | 315711 | 2020-07-09 | Scott | Arkansas | 5127 | 16 | 0 |
318884 | 318884 | 2020-07-10 | Scott | Arkansas | 5127 | 16 | 0 |
322063 | 322063 | 2020-07-11 | Scott | Arkansas | 5127 | 16 | 0 |
325244 | 325244 | 2020-07-12 | Scott | Arkansas | 5127 | 16 | 0 |
328430 | 328430 | 2020-07-13 | Scott | Arkansas | 5127 | 17 | 0 |
331616 | 331616 | 2020-07-14 | Scott | Arkansas | 5127 | 17 | 0 |
334809 | 334809 | 2020-07-15 | Scott | Arkansas | 5127 | 18 | 0 |
338004 | 338004 | 2020-07-16 | Scott | Arkansas | 5127 | 18 | 0 |
341200 | 341200 | 2020-07-17 | Scott | Arkansas | 5127 | 18 | 0 |
344399 | 344399 | 2020-07-18 | Scott | Arkansas | 5127 | 19 | 0 |
347599 | 347599 | 2020-07-19 | Scott | Arkansas | 5127 | 20 | 0 |
350800 | 350800 | 2020-07-20 | Scott | Arkansas | 5127 | 21 | 0 |
354002 | 354002 | 2020-07-21 | Scott | Arkansas | 5127 | 21 | 0 |
357205 | 357205 | 2020-07-22 | Scott | Arkansas | 5127 | 21 | 0 |
360410 | 360410 | 2020-07-23 | Scott | Arkansas | 5127 | 26 | 0 |
363617 | 363617 | 2020-07-24 | Scott | Arkansas | 5127 | 26 | 0 |
366824 | 366824 | 2020-07-25 | Scott | Arkansas | 5127 | 30 | 0 |
370034 | 370034 | 2020-07-26 | Scott | Arkansas | 5127 | 31 | 0 |
373246 | 373246 | 2020-07-27 | Scott | Arkansas | 5127 | 31 | 0 |
376460 | 376460 | 2020-07-28 | Scott | Arkansas | 5127 | 33 | 0 |
379676 | 379676 | 2020-07-29 | Scott | Arkansas | 5127 | 34 | 0 |
382893 | 382893 | 2020-07-30 | Scott | Arkansas | 5127 | 35 | 0 |
386111 | 386111 | 2020-07-31 | Scott | Arkansas | 5127 | 41 | 0 |
389328 | 389328 | 2020-08-01 | Scott | Arkansas | 5127 | 41 | 0 |
392545 | 392545 | 2020-08-02 | Scott | Arkansas | 5127 | 42 | 0 |
395761 | 395761 | 2020-08-03 | Scott | Arkansas | 5127 | 44 | 0 |
398977 | 398977 | 2020-08-04 | Scott | Arkansas | 5127 | 45 | 0 |
402193 | 402193 | 2020-08-05 | Scott | Arkansas | 5127 | 46 | 0 |
405411 | 405411 | 2020-08-06 | Scott | Arkansas | 5127 | 51 | 0 |
408631 | 408631 | 2020-08-07 | Scott | Arkansas | 5127 | 55 | 0 |
411850 | 411850 | 2020-08-08 | Scott | Arkansas | 5127 | 58 | 0 |
415070 | 415070 | 2020-08-09 | Scott | Arkansas | 5127 | 61 | 0 |
418291 | 418291 | 2020-08-10 | Scott | Arkansas | 5127 | 61 | 0 |
421512 | 421512 | 2020-08-11 | Scott | Arkansas | 5127 | 66 | 0 |
424733 | 424733 | 2020-08-12 | Scott | Arkansas | 5127 | 68 | 0 |
427957 | 427957 | 2020-08-13 | Scott | Arkansas | 5127 | 70 | 0 |
431185 | 431185 | 2020-08-14 | Scott | Arkansas | 5127 | 72 | 0 |
434410 | 434410 | 2020-08-15 | Scott | Arkansas | 5127 | 77 | 0 |
437636 | 437636 | 2020-08-16 | Scott | Arkansas | 5127 | 78 | 0 |
440862 | 440862 | 2020-08-17 | Scott | Arkansas | 5127 | 78 | 0 |
444088 | 444088 | 2020-08-18 | Scott | Arkansas | 5127 | 79 | 0 |
447315 | 447315 | 2020-08-19 | Scott | Arkansas | 5127 | 80 | 0 |
450543 | 450543 | 2020-08-20 | Scott | Arkansas | 5127 | 84 | 0 |
453771 | 453771 | 2020-08-21 | Scott | Arkansas | 5127 | 84 | 0 |
456999 | 456999 | 2020-08-22 | Scott | Arkansas | 5127 | 84 | 0 |
460226 | 460226 | 2020-08-23 | Scott | Arkansas | 5127 | 84 | 0 |
463455 | 463455 | 2020-08-24 | Scott | Arkansas | 5127 | 84 | 0 |
466684 | 466684 | 2020-08-25 | Scott | Arkansas | 5127 | 84 | 0 |
469913 | 469913 | 2020-08-26 | Scott | Arkansas | 5127 | 84 | 0 |
473145 | 473145 | 2020-08-27 | Scott | Arkansas | 5127 | 84 | 0 |
476378 | 476378 | 2020-08-28 | Scott | Arkansas | 5127 | 86 | 0 |
479611 | 479611 | 2020-08-29 | Scott | Arkansas | 5127 | 86 | 0 |
482845 | 482845 | 2020-08-30 | Scott | Arkansas | 5127 | 86 | 0 |
486080 | 486080 | 2020-08-31 | Scott | Arkansas | 5127 | 86 | 0 |
489313 | 489313 | 2020-09-01 | Scott | Arkansas | 5127 | 86 | 0 |
492546 | 492546 | 2020-09-02 | Scott | Arkansas | 5127 | 87 | 0 |
495780 | 495780 | 2020-09-03 | Scott | Arkansas | 5127 | 88 | 0 |
499013 | 499013 | 2020-09-04 | Scott | Arkansas | 5127 | 89 | 0 |
502247 | 502247 | 2020-09-05 | Scott | Arkansas | 5127 | 89 | 0 |
505481 | 505481 | 2020-09-06 | Scott | Arkansas | 5127 | 90 | 0 |
508713 | 508713 | 2020-09-07 | Scott | Arkansas | 5127 | 90 | 0 |
511946 | 511946 | 2020-09-08 | Scott | Arkansas | 5127 | 90 | 0 |
515179 | 515179 | 2020-09-09 | Scott | Arkansas | 5127 | 90 | 0 |
518414 | 518414 | 2020-09-10 | Scott | Arkansas | 5127 | 90 | 1 |
521651 | 521651 | 2020-09-11 | Scott | Arkansas | 5127 | 91 | 1 |
524887 | 524887 | 2020-09-12 | Scott | Arkansas | 5127 | 92 | 1 |
528123 | 528123 | 2020-09-13 | Scott | Arkansas | 5127 | 92 | 1 |
531360 | 531360 | 2020-09-14 | Scott | Arkansas | 5127 | 93 | 1 |
534595 | 534595 | 2020-09-15 | Scott | Arkansas | 5127 | 93 | 1 |
537831 | 537831 | 2020-09-16 | Scott | Arkansas | 5127 | 94 | 1 |
541068 | 541068 | 2020-09-17 | Scott | Arkansas | 5127 | 94 | 1 |
544304 | 544304 | 2020-09-18 | Scott | Arkansas | 5127 | 94 | 1 |
547542 | 547542 | 2020-09-19 | Scott | Arkansas | 5127 | 95 | 1 |
550781 | 550781 | 2020-09-20 | Scott | Arkansas | 5127 | 95 | 1 |
554020 | 554020 | 2020-09-21 | Scott | Arkansas | 5127 | 95 | 1 |
557257 | 557257 | 2020-09-22 | Scott | Arkansas | 5127 | 96 | 1 |
560493 | 560493 | 2020-09-23 | Scott | Arkansas | 5127 | 97 | 1 |
563732 | 563732 | 2020-09-24 | Scott | Arkansas | 5127 | 97 | 1 |
566972 | 566972 | 2020-09-25 | Scott | Arkansas | 5127 | 100 | 1 |
570214 | 570214 | 2020-09-26 | Scott | Arkansas | 5127 | 100 | 1 |
573456 | 573456 | 2020-09-27 | Scott | Arkansas | 5127 | 101 | 1 |
576699 | 576699 | 2020-09-28 | Scott | Arkansas | 5127 | 101 | 1 |
579940 | 579940 | 2020-09-29 | Scott | Arkansas | 5127 | 106 | 1 |
583179 | 583179 | 2020-09-30 | Scott | Arkansas | 5127 | 106 | 1 |
586419 | 586419 | 2020-10-01 | Scott | Arkansas | 5127 | 111 | 1 |
589660 | 589660 | 2020-10-02 | Scott | Arkansas | 5127 | 111 | 1 |
592900 | 592900 | 2020-10-03 | Scott | Arkansas | 5127 | 112 | 1 |
596142 | 596142 | 2020-10-04 | Scott | Arkansas | 5127 | 112 | 1 |
599385 | 599385 | 2020-10-05 | Scott | Arkansas | 5127 | 115 | 1 |
602628 | 602628 | 2020-10-06 | Scott | Arkansas | 5127 | 117 | 1 |
605870 | 605870 | 2020-10-07 | Scott | Arkansas | 5127 | 119 | 1 |
609113 | 609113 | 2020-10-08 | Scott | Arkansas | 5127 | 127 | 1 |
612355 | 612355 | 2020-10-09 | Scott | Arkansas | 5127 | 128 | 1 |
615596 | 615596 | 2020-10-10 | Scott | Arkansas | 5127 | 128 | 1 |
618838 | 618838 | 2020-10-11 | Scott | Arkansas | 5127 | 128 | 1 |
622081 | 622081 | 2020-10-12 | Scott | Arkansas | 5127 | 128 | 1 |
625324 | 625324 | 2020-10-13 | Scott | Arkansas | 5127 | 129 | 1 |
628567 | 628567 | 2020-10-14 | Scott | Arkansas | 5127 | 132 | 1 |
631811 | 631811 | 2020-10-15 | Scott | Arkansas | 5127 | 141 | 1 |
635057 | 635057 | 2020-10-16 | Scott | Arkansas | 5127 | 146 | 1 |
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);