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,715 rows where county = "Scott" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Scott · 3,715 ✖
Link rowid date ▲ county state fips cases deaths
1092625 1092625 2021-03-06 Scott Arkansas 5127 921 14
1093137 1093137 2021-03-06 Scott Illinois 17171 449 1
1093226 1093226 2021-03-06 Scott Indiana 18143 2525 52
1093329 1093329 2021-03-06 Scott Iowa 19163 16852 212
1093433 1093433 2021-03-06 Scott Kansas 20171 605 21
1093558 1093558 2021-03-06 Scott Kentucky 21209 4199 26
1093847 1093847 2021-03-06 Scott Minnesota 27139 13403 107
1093928 1093928 2021-03-06 Scott Mississippi 28123 2961 71
1094045 1094045 2021-03-06 Scott Missouri 29201 3846 77
1095054 1095054 2021-03-06 Scott Tennessee 47151 2886 44
1095489 1095489 2021-03-06 Scott Virginia 51169 1603 49
1089379 1089379 2021-03-05 Scott Arkansas 5127 921 14
1089891 1089891 2021-03-05 Scott Illinois 17171 449 1
1089980 1089980 2021-03-05 Scott Indiana 18143 2521 52
1090083 1090083 2021-03-05 Scott Iowa 19163 16852 212
1090187 1090187 2021-03-05 Scott Kansas 20171 604 21
1090312 1090312 2021-03-05 Scott Kentucky 21209 4164 26
1090601 1090601 2021-03-05 Scott Minnesota 27139 13381 107
1090682 1090682 2021-03-05 Scott Mississippi 28123 2957 71
1090799 1090799 2021-03-05 Scott Missouri 29201 3845 77
1091808 1091808 2021-03-05 Scott Tennessee 47151 2883 44
1092243 1092243 2021-03-05 Scott Virginia 51169 1602 49
1086134 1086134 2021-03-04 Scott Arkansas 5127 921 14
1086646 1086646 2021-03-04 Scott Illinois 17171 449 1
1086735 1086735 2021-03-04 Scott Indiana 18143 2520 52
1086838 1086838 2021-03-04 Scott Iowa 19163 16852 211
1086942 1086942 2021-03-04 Scott Kansas 20171 604 21
1087067 1087067 2021-03-04 Scott Kentucky 21209 4135 26
1087356 1087356 2021-03-04 Scott Minnesota 27139 13354 107
1087437 1087437 2021-03-04 Scott Mississippi 28123 2952 71
1087554 1087554 2021-03-04 Scott Missouri 29201 3844 77
1088562 1088562 2021-03-04 Scott Tennessee 47151 2881 44
1088997 1088997 2021-03-04 Scott Virginia 51169 1601 49
1082888 1082888 2021-03-03 Scott Arkansas 5127 921 14
1083400 1083400 2021-03-03 Scott Illinois 17171 449 1
1083489 1083489 2021-03-03 Scott Indiana 18143 2519 52
1083592 1083592 2021-03-03 Scott Iowa 19163 16852 210
1083696 1083696 2021-03-03 Scott Kansas 20171 604 21
1083821 1083821 2021-03-03 Scott Kentucky 21209 4115 26
1084111 1084111 2021-03-03 Scott Minnesota 27139 13308 107
1084192 1084192 2021-03-03 Scott Mississippi 28123 2945 70
1084309 1084309 2021-03-03 Scott Missouri 29201 3840 77
1085317 1085317 2021-03-03 Scott Tennessee 47151 2877 44
1085752 1085752 2021-03-03 Scott Virginia 51169 1591 49
1079642 1079642 2021-03-02 Scott Arkansas 5127 921 14
1080154 1080154 2021-03-02 Scott Illinois 17171 449 1
1080243 1080243 2021-03-02 Scott Indiana 18143 2515 52
1080346 1080346 2021-03-02 Scott Iowa 19163 16852 210
1080450 1080450 2021-03-02 Scott Kansas 20171 604 21
1080575 1080575 2021-03-02 Scott Kentucky 21209 4082 26
1080865 1080865 2021-03-02 Scott Minnesota 27139 13290 107
1080946 1080946 2021-03-02 Scott Mississippi 28123 2939 70
1081063 1081063 2021-03-02 Scott Missouri 29201 3837 77
1082071 1082071 2021-03-02 Scott Tennessee 47151 2876 44
1082506 1082506 2021-03-02 Scott Virginia 51169 1586 49
1076397 1076397 2021-03-01 Scott Arkansas 5127 918 14
1076909 1076909 2021-03-01 Scott Illinois 17171 449 1
1076998 1076998 2021-03-01 Scott Indiana 18143 2510 52
1077101 1077101 2021-03-01 Scott Iowa 19163 16852 207
1077205 1077205 2021-03-01 Scott Kansas 20171 604 21
1077330 1077330 2021-03-01 Scott Kentucky 21209 4057 26
1077619 1077619 2021-03-01 Scott Minnesota 27139 13273 107
1077700 1077700 2021-03-01 Scott Mississippi 28123 2938 70
1077817 1077817 2021-03-01 Scott Missouri 29201 3833 76
1078825 1078825 2021-03-01 Scott Tennessee 47151 2870 43
1079260 1079260 2021-03-01 Scott Virginia 51169 1583 49
1073151 1073151 2021-02-28 Scott Arkansas 5127 918 14
1073663 1073663 2021-02-28 Scott Illinois 17171 449 1
1073752 1073752 2021-02-28 Scott Indiana 18143 2510 52
1073855 1073855 2021-02-28 Scott Iowa 19163 16852 207
1073959 1073959 2021-02-28 Scott Kansas 20171 604 21
1074084 1074084 2021-02-28 Scott Kentucky 21209 4050 26
1074373 1074373 2021-02-28 Scott Minnesota 27139 13241 107
1074454 1074454 2021-02-28 Scott Mississippi 28123 2936 70
1074571 1074571 2021-02-28 Scott Missouri 29201 3833 76
1075580 1075580 2021-02-28 Scott Tennessee 47151 2868 43
1076015 1076015 2021-02-28 Scott Virginia 51169 1583 48
1069905 1069905 2021-02-27 Scott Arkansas 5127 927 14
1070417 1070417 2021-02-27 Scott Illinois 17171 449 1
1070506 1070506 2021-02-27 Scott Indiana 18143 2506 52
1070609 1070609 2021-02-27 Scott Iowa 19163 16852 207
1070713 1070713 2021-02-27 Scott Kansas 20171 604 21
1070838 1070838 2021-02-27 Scott Kentucky 21209 4039 26
1071127 1071127 2021-02-27 Scott Minnesota 27139 13209 107
1071208 1071208 2021-02-27 Scott Mississippi 28123 2931 70
1071325 1071325 2021-02-27 Scott Missouri 29201 3830 76
1072334 1072334 2021-02-27 Scott Tennessee 47151 2863 43
1072769 1072769 2021-02-27 Scott Virginia 51169 1580 48
1066660 1066660 2021-02-26 Scott Arkansas 5127 927 14
1067172 1067172 2021-02-26 Scott Illinois 17171 448 1
1067261 1067261 2021-02-26 Scott Indiana 18143 2507 52
1067364 1067364 2021-02-26 Scott Iowa 19163 16852 206
1067468 1067468 2021-02-26 Scott Kansas 20171 604 21
1067593 1067593 2021-02-26 Scott Kentucky 21209 4013 26
1067882 1067882 2021-02-26 Scott Minnesota 27139 13186 107
1067963 1067963 2021-02-26 Scott Mississippi 28123 2928 68
1068080 1068080 2021-02-26 Scott Missouri 29201 3816 76
1069088 1069088 2021-02-26 Scott Tennessee 47151 2858 42
1069523 1069523 2021-02-26 Scott Virginia 51169 1577 47
1063415 1063415 2021-02-25 Scott Arkansas 5127 926 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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);