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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534595 | 534595 | 2020-09-15 | Scott | Arkansas | 5127 | 93 | 1 |
535105 | 535105 | 2020-09-15 | Scott | Illinois | 17171 | 62 | 0 |
535194 | 535194 | 2020-09-15 | Scott | Indiana | 18143 | 349 | 12 |
535297 | 535297 | 2020-09-15 | Scott | Iowa | 19163 | 2550 | 26 |
535401 | 535401 | 2020-09-15 | Scott | Kansas | 20171 | 113 | 1 |
535525 | 535525 | 2020-09-15 | Scott | Kentucky | 21209 | 695 | 8 |
535814 | 535814 | 2020-09-15 | Scott | Minnesota | 27139 | 2291 | 32 |
535895 | 535895 | 2020-09-15 | Scott | Mississippi | 28123 | 1147 | 25 |
536012 | 536012 | 2020-09-15 | Scott | Missouri | 29201 | 756 | 15 |
537016 | 537016 | 2020-09-15 | Scott | Tennessee | 47151 | 183 | 2 |
537448 | 537448 | 2020-09-15 | Scott | Virginia | 51169 | 176 | 4 |
531360 | 531360 | 2020-09-14 | Scott | Arkansas | 5127 | 93 | 1 |
531870 | 531870 | 2020-09-14 | Scott | Illinois | 17171 | 62 | 0 |
531959 | 531959 | 2020-09-14 | Scott | Indiana | 18143 | 346 | 12 |
532062 | 532062 | 2020-09-14 | Scott | Iowa | 19163 | 2534 | 26 |
532166 | 532166 | 2020-09-14 | Scott | Kansas | 20171 | 113 | 1 |
532290 | 532290 | 2020-09-14 | Scott | Kentucky | 21209 | 689 | 8 |
532579 | 532579 | 2020-09-14 | Scott | Minnesota | 27139 | 2279 | 32 |
532660 | 532660 | 2020-09-14 | Scott | Mississippi | 28123 | 1141 | 24 |
532777 | 532777 | 2020-09-14 | Scott | Missouri | 29201 | 752 | 15 |
533780 | 533780 | 2020-09-14 | Scott | Tennessee | 47151 | 183 | 2 |
534212 | 534212 | 2020-09-14 | Scott | Virginia | 51169 | 174 | 4 |
528123 | 528123 | 2020-09-13 | Scott | Arkansas | 5127 | 92 | 1 |
528633 | 528633 | 2020-09-13 | Scott | Illinois | 17171 | 62 | 0 |
528722 | 528722 | 2020-09-13 | Scott | Indiana | 18143 | 344 | 12 |
528825 | 528825 | 2020-09-13 | Scott | Iowa | 19163 | 2525 | 25 |
528929 | 528929 | 2020-09-13 | Scott | Kansas | 20171 | 113 | 1 |
529053 | 529053 | 2020-09-13 | Scott | Kentucky | 21209 | 683 | 8 |
529343 | 529343 | 2020-09-13 | Scott | Minnesota | 27139 | 2254 | 32 |
529424 | 529424 | 2020-09-13 | Scott | Mississippi | 28123 | 1141 | 23 |
529541 | 529541 | 2020-09-13 | Scott | Missouri | 29201 | 746 | 15 |
530545 | 530545 | 2020-09-13 | Scott | Tennessee | 47151 | 182 | 2 |
530977 | 530977 | 2020-09-13 | Scott | Virginia | 51169 | 174 | 4 |
524887 | 524887 | 2020-09-12 | Scott | Arkansas | 5127 | 92 | 1 |
525397 | 525397 | 2020-09-12 | Scott | Illinois | 17171 | 59 | 0 |
525486 | 525486 | 2020-09-12 | Scott | Indiana | 18143 | 342 | 12 |
525589 | 525589 | 2020-09-12 | Scott | Iowa | 19163 | 2512 | 25 |
525693 | 525693 | 2020-09-12 | Scott | Kansas | 20171 | 113 | 1 |
525817 | 525817 | 2020-09-12 | Scott | Kentucky | 21209 | 676 | 8 |
526107 | 526107 | 2020-09-12 | Scott | Minnesota | 27139 | 2246 | 32 |
526188 | 526188 | 2020-09-12 | Scott | Mississippi | 28123 | 1138 | 23 |
526305 | 526305 | 2020-09-12 | Scott | Missouri | 29201 | 732 | 15 |
527308 | 527308 | 2020-09-12 | Scott | Tennessee | 47151 | 182 | 2 |
527740 | 527740 | 2020-09-12 | Scott | Virginia | 51169 | 172 | 4 |
521651 | 521651 | 2020-09-11 | Scott | Arkansas | 5127 | 91 | 1 |
522161 | 522161 | 2020-09-11 | Scott | Illinois | 17171 | 58 | 0 |
522250 | 522250 | 2020-09-11 | Scott | Indiana | 18143 | 341 | 12 |
522353 | 522353 | 2020-09-11 | Scott | Iowa | 19163 | 2490 | 25 |
522457 | 522457 | 2020-09-11 | Scott | Kansas | 20171 | 113 | 1 |
522581 | 522581 | 2020-09-11 | Scott | Kentucky | 21209 | 668 | 8 |
522871 | 522871 | 2020-09-11 | Scott | Minnesota | 27139 | 2238 | 32 |
522952 | 522952 | 2020-09-11 | Scott | Mississippi | 28123 | 1134 | 23 |
523069 | 523069 | 2020-09-11 | Scott | Missouri | 29201 | 725 | 15 |
524072 | 524072 | 2020-09-11 | Scott | Tennessee | 47151 | 176 | 2 |
524504 | 524504 | 2020-09-11 | Scott | Virginia | 51169 | 172 | 4 |
518414 | 518414 | 2020-09-10 | Scott | Arkansas | 5127 | 90 | 1 |
518924 | 518924 | 2020-09-10 | Scott | Illinois | 17171 | 53 | 0 |
519013 | 519013 | 2020-09-10 | Scott | Indiana | 18143 | 334 | 12 |
519116 | 519116 | 2020-09-10 | Scott | Iowa | 19163 | 2447 | 25 |
519220 | 519220 | 2020-09-10 | Scott | Kansas | 20171 | 108 | 1 |
519344 | 519344 | 2020-09-10 | Scott | Kentucky | 21209 | 658 | 8 |
519634 | 519634 | 2020-09-10 | Scott | Minnesota | 27139 | 2217 | 32 |
519715 | 519715 | 2020-09-10 | Scott | Mississippi | 28123 | 1130 | 23 |
519832 | 519832 | 2020-09-10 | Scott | Missouri | 29201 | 713 | 15 |
520836 | 520836 | 2020-09-10 | Scott | Tennessee | 47151 | 173 | 2 |
521268 | 521268 | 2020-09-10 | Scott | Virginia | 51169 | 170 | 4 |
515179 | 515179 | 2020-09-09 | Scott | Arkansas | 5127 | 90 | 0 |
515689 | 515689 | 2020-09-09 | Scott | Illinois | 17171 | 53 | 0 |
515778 | 515778 | 2020-09-09 | Scott | Indiana | 18143 | 333 | 12 |
515881 | 515881 | 2020-09-09 | Scott | Iowa | 19163 | 2409 | 24 |
515985 | 515985 | 2020-09-09 | Scott | Kansas | 20171 | 108 | 1 |
516109 | 516109 | 2020-09-09 | Scott | Kentucky | 21209 | 649 | 8 |
516399 | 516399 | 2020-09-09 | Scott | Minnesota | 27139 | 2205 | 32 |
516480 | 516480 | 2020-09-09 | Scott | Mississippi | 28123 | 1126 | 23 |
516597 | 516597 | 2020-09-09 | Scott | Missouri | 29201 | 708 | 15 |
517600 | 517600 | 2020-09-09 | Scott | Tennessee | 47151 | 170 | 2 |
518031 | 518031 | 2020-09-09 | Scott | Virginia | 51169 | 168 | 4 |
511946 | 511946 | 2020-09-08 | Scott | Arkansas | 5127 | 90 | 0 |
512456 | 512456 | 2020-09-08 | Scott | Illinois | 17171 | 52 | 0 |
512545 | 512545 | 2020-09-08 | Scott | Indiana | 18143 | 332 | 12 |
512648 | 512648 | 2020-09-08 | Scott | Iowa | 19163 | 2392 | 23 |
512752 | 512752 | 2020-09-08 | Scott | Kansas | 20171 | 108 | 1 |
512876 | 512876 | 2020-09-08 | Scott | Kentucky | 21209 | 634 | 6 |
513165 | 513165 | 2020-09-08 | Scott | Minnesota | 27139 | 2203 | 32 |
513246 | 513246 | 2020-09-08 | Scott | Mississippi | 28123 | 1125 | 22 |
513363 | 513363 | 2020-09-08 | Scott | Missouri | 29201 | 692 | 14 |
514365 | 514365 | 2020-09-08 | Scott | Tennessee | 47151 | 167 | 2 |
514796 | 514796 | 2020-09-08 | Scott | Virginia | 51169 | 167 | 4 |
508713 | 508713 | 2020-09-07 | Scott | Arkansas | 5127 | 90 | 0 |
509223 | 509223 | 2020-09-07 | Scott | Illinois | 17171 | 52 | 0 |
509312 | 509312 | 2020-09-07 | Scott | Indiana | 18143 | 330 | 12 |
509415 | 509415 | 2020-09-07 | Scott | Iowa | 19163 | 2383 | 23 |
509519 | 509519 | 2020-09-07 | Scott | Kansas | 20171 | 107 | 1 |
509644 | 509644 | 2020-09-07 | Scott | Kentucky | 21209 | 630 | 6 |
509933 | 509933 | 2020-09-07 | Scott | Minnesota | 27139 | 2198 | 32 |
510014 | 510014 | 2020-09-07 | Scott | Mississippi | 28123 | 1125 | 22 |
510131 | 510131 | 2020-09-07 | Scott | Missouri | 29201 | 690 | 14 |
511132 | 511132 | 2020-09-07 | Scott | Tennessee | 47151 | 167 | 2 |
511563 | 511563 | 2020-09-07 | Scott | Virginia | 51169 | 166 | 4 |
505481 | 505481 | 2020-09-06 | Scott | Arkansas | 5127 | 90 | 0 |
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);