ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,231 rows where county = "Scott" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Scott · 3,231 ✖
Link rowid date ▲ county state fips cases deaths
949899 949899 2021-01-21 Scott Arkansas 5127 815 14
950411 950411 2021-01-21 Scott Illinois 17171 396 1
950499 950499 2021-01-21 Scott Indiana 18143 2225 40
950602 950602 2021-01-21 Scott Iowa 19163 15694 167
950706 950706 2021-01-21 Scott Kansas 20171 576 16
950831 950831 2021-01-21 Scott Kentucky 21209 3229 24
951121 951121 2021-01-21 Scott Minnesota 27139 12035 97
951202 951202 2021-01-21 Scott Mississippi 28123 2534 48
951319 951319 2021-01-21 Scott Missouri 29201 3608 68
952327 952327 2021-01-21 Scott Tennessee 47151 2278 31
952762 952762 2021-01-21 Scott Virginia 51169 1441 40
946653 946653 2021-01-20 Scott Arkansas 5127 796 14
947165 947165 2021-01-20 Scott Illinois 17171 386 1
947253 947253 2021-01-20 Scott Indiana 18143 2202 40
947356 947356 2021-01-20 Scott Iowa 19163 15566 166
947460 947460 2021-01-20 Scott Kansas 20171 575 16
947585 947585 2021-01-20 Scott Kentucky 21209 3178 24
947875 947875 2021-01-20 Scott Minnesota 27139 11994 96
947956 947956 2021-01-20 Scott Mississippi 28123 2508 47
948073 948073 2021-01-20 Scott Missouri 29201 3592 68
949082 949082 2021-01-20 Scott Tennessee 47151 2273 31
949517 949517 2021-01-20 Scott Virginia 51169 1425 40
943406 943406 2021-01-19 Scott Arkansas 5127 788 14
943918 943918 2021-01-19 Scott Illinois 17171 385 1
944006 944006 2021-01-19 Scott Indiana 18143 2192 40
944109 944109 2021-01-19 Scott Iowa 19163 15444 163
944213 944213 2021-01-19 Scott Kansas 20171 575 16
944338 944338 2021-01-19 Scott Kentucky 21209 3130 24
944628 944628 2021-01-19 Scott Minnesota 27139 11954 96
944709 944709 2021-01-19 Scott Mississippi 28123 2480 46
944826 944826 2021-01-19 Scott Missouri 29201 3587 68
945836 945836 2021-01-19 Scott Tennessee 47151 2262 31
946271 946271 2021-01-19 Scott Virginia 51169 1405 40
940161 940161 2021-01-18 Scott Arkansas 5127 786 14
940673 940673 2021-01-18 Scott Illinois 17171 375 1
940761 940761 2021-01-18 Scott Indiana 18143 2180 39
940864 940864 2021-01-18 Scott Iowa 19163 15414 163
940968 940968 2021-01-18 Scott Kansas 20171 573 16
941093 941093 2021-01-18 Scott Kentucky 21209 3116 24
941383 941383 2021-01-18 Scott Minnesota 27139 11932 96
941464 941464 2021-01-18 Scott Mississippi 28123 2466 45
941581 941581 2021-01-18 Scott Missouri 29201 3584 68
942589 942589 2021-01-18 Scott Tennessee 47151 2254 31
943024 943024 2021-01-18 Scott Virginia 51169 1405 40
936916 936916 2021-01-17 Scott Arkansas 5127 783 14
937428 937428 2021-01-17 Scott Illinois 17171 373 1
937516 937516 2021-01-17 Scott Indiana 18143 2176 39
937619 937619 2021-01-17 Scott Iowa 19163 15387 163
937723 937723 2021-01-17 Scott Kansas 20171 570 16
937848 937848 2021-01-17 Scott Kentucky 21209 3093 24
938138 938138 2021-01-17 Scott Minnesota 27139 11917 96
938219 938219 2021-01-17 Scott Mississippi 28123 2462 45
938336 938336 2021-01-17 Scott Missouri 29201 3583 68
939344 939344 2021-01-17 Scott Tennessee 47151 2252 31
939779 939779 2021-01-17 Scott Virginia 51169 1399 40
933671 933671 2021-01-16 Scott Arkansas 5127 779 14
934183 934183 2021-01-16 Scott Illinois 17171 373 1
934271 934271 2021-01-16 Scott Indiana 18143 2171 39
934374 934374 2021-01-16 Scott Iowa 19163 15355 163
934478 934478 2021-01-16 Scott Kansas 20171 570 16
934603 934603 2021-01-16 Scott Kentucky 21209 3068 24
934893 934893 2021-01-16 Scott Minnesota 27139 11899 96
934974 934974 2021-01-16 Scott Mississippi 28123 2447 45
935091 935091 2021-01-16 Scott Missouri 29201 3579 68
936099 936099 2021-01-16 Scott Tennessee 47151 2236 31
936534 936534 2021-01-16 Scott Virginia 51169 1385 40
930426 930426 2021-01-15 Scott Arkansas 5127 770 14
930938 930938 2021-01-15 Scott Illinois 17171 367 1
931026 931026 2021-01-15 Scott Indiana 18143 2157 39
931129 931129 2021-01-15 Scott Iowa 19163 15300 161
931233 931233 2021-01-15 Scott Kansas 20171 570 16
931358 931358 2021-01-15 Scott Kentucky 21209 3030 24
931648 931648 2021-01-15 Scott Minnesota 27139 11853 94
931729 931729 2021-01-15 Scott Mississippi 28123 2410 43
931846 931846 2021-01-15 Scott Missouri 29201 3574 68
932854 932854 2021-01-15 Scott Tennessee 47151 2224 31
933289 933289 2021-01-15 Scott Virginia 51169 1380 40
927181 927181 2021-01-14 Scott Arkansas 5127 758 14
927693 927693 2021-01-14 Scott Illinois 17171 366 1
927781 927781 2021-01-14 Scott Indiana 18143 2135 39
927884 927884 2021-01-14 Scott Iowa 19163 15228 161
927988 927988 2021-01-14 Scott Kansas 20171 569 16
928113 928113 2021-01-14 Scott Kentucky 21209 2978 24
928403 928403 2021-01-14 Scott Minnesota 27139 11786 93
928484 928484 2021-01-14 Scott Mississippi 28123 2387 43
928601 928601 2021-01-14 Scott Missouri 29201 3547 68
929609 929609 2021-01-14 Scott Tennessee 47151 2197 31
930044 930044 2021-01-14 Scott Virginia 51169 1371 40
923935 923935 2021-01-13 Scott Arkansas 5127 747 14
924447 924447 2021-01-13 Scott Illinois 17171 362 1
924535 924535 2021-01-13 Scott Indiana 18143 2118 39
924638 924638 2021-01-13 Scott Iowa 19163 15133 158
924742 924742 2021-01-13 Scott Kansas 20171 567 16
924867 924867 2021-01-13 Scott Kentucky 21209 2941 24
925157 925157 2021-01-13 Scott Minnesota 27139 11741 93
925238 925238 2021-01-13 Scott Mississippi 28123 2362 43
925355 925355 2021-01-13 Scott Missouri 29201 3531 68
926364 926364 2021-01-13 Scott Tennessee 47151 2186 32
926799 926799 2021-01-13 Scott Virginia 51169 1365 39
920690 920690 2021-01-12 Scott Arkansas 5127 743 14

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);