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

8,478 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 11

fips 11

county 1

  • Scott · 8,478 ✖
Link rowid date ▲ county state fips cases deaths
2499748 2499748 2022-05-13 Scott Arkansas 5127 2299 43
2500261 2500261 2022-05-13 Scott Illinois 17171 1276 12
2500350 2500350 2022-05-13 Scott Indiana 18143 7943 106
2500454 2500454 2022-05-13 Scott Iowa 19163 41418 395
2500558 2500558 2022-05-13 Scott Kansas 20171 1277 34
2500683 2500683 2022-05-13 Scott Kentucky 21209 17723 109
2500973 2500973 2022-05-13 Scott Minnesota 27139 41236 261
2501054 2501054 2022-05-13 Scott Mississippi 28123 6559 119
2501172 2501172 2022-05-13 Scott Missouri 29201 11133 161
2502186 2502186 2022-05-13 Scott Tennessee 47151 9097 117
2502622 2502622 2022-05-13 Scott Virginia 51169 5845 111
2496490 2496490 2022-05-12 Scott Arkansas 5127 2298 43
2497003 2497003 2022-05-12 Scott Illinois 17171 1275 12
2497092 2497092 2022-05-12 Scott Indiana 18143 7929 106
2497196 2497196 2022-05-12 Scott Iowa 19163 41418 395
2497300 2497300 2022-05-12 Scott Kansas 20171 1275 34
2497425 2497425 2022-05-12 Scott Kentucky 21209 17723 109
2497715 2497715 2022-05-12 Scott Minnesota 27139 41156 261
2497796 2497796 2022-05-12 Scott Mississippi 28123 6559 119
2497914 2497914 2022-05-12 Scott Missouri 29201 11122 161
2498928 2498928 2022-05-12 Scott Tennessee 47151 9097 117
2499364 2499364 2022-05-12 Scott Virginia 51169 5846 111
2493232 2493232 2022-05-11 Scott Arkansas 5127 2298 43
2493745 2493745 2022-05-11 Scott Illinois 17171 1275 12
2493834 2493834 2022-05-11 Scott Indiana 18143 7929 106
2493938 2493938 2022-05-11 Scott Iowa 19163 41418 395
2494042 2494042 2022-05-11 Scott Kansas 20171 1275 34
2494167 2494167 2022-05-11 Scott Kentucky 21209 17723 109
2494457 2494457 2022-05-11 Scott Minnesota 27139 41100 260
2494538 2494538 2022-05-11 Scott Mississippi 28123 6559 119
2494656 2494656 2022-05-11 Scott Missouri 29201 11122 161
2495670 2495670 2022-05-11 Scott Tennessee 47151 9097 117
2496106 2496106 2022-05-11 Scott Virginia 51169 5847 111
2489974 2489974 2022-05-10 Scott Arkansas 5127 2298 43
2490487 2490487 2022-05-10 Scott Illinois 17171 1275 12
2490576 2490576 2022-05-10 Scott Indiana 18143 7914 106
2490680 2490680 2022-05-10 Scott Iowa 19163 41281 395
2490784 2490784 2022-05-10 Scott Kansas 20171 1275 34
2490909 2490909 2022-05-10 Scott Kentucky 21209 17723 109
2491199 2491199 2022-05-10 Scott Minnesota 27139 41053 260
2491280 2491280 2022-05-10 Scott Mississippi 28123 6559 119
2491398 2491398 2022-05-10 Scott Missouri 29201 11122 161
2492412 2492412 2022-05-10 Scott Tennessee 47151 9078 117
2492848 2492848 2022-05-10 Scott Virginia 51169 5843 111
2486717 2486717 2022-05-09 Scott Arkansas 5127 2297 43
2487230 2487230 2022-05-09 Scott Illinois 17171 1271 12
2487319 2487319 2022-05-09 Scott Indiana 18143 7914 106
2487423 2487423 2022-05-09 Scott Iowa 19163 41281 395
2487527 2487527 2022-05-09 Scott Kansas 20171 1275 34
2487652 2487652 2022-05-09 Scott Kentucky 21209 17723 109
2487942 2487942 2022-05-09 Scott Minnesota 27139 40932 260
2488023 2488023 2022-05-09 Scott Mississippi 28123 6559 119
2488140 2488140 2022-05-09 Scott Missouri 29201 11122 161
2489154 2489154 2022-05-09 Scott Tennessee 47151 9078 117
2489590 2489590 2022-05-09 Scott Virginia 51169 5839 111
2483459 2483459 2022-05-08 Scott Arkansas 5127 2297 43
2483972 2483972 2022-05-08 Scott Illinois 17171 1269 12
2484061 2484061 2022-05-08 Scott Indiana 18143 7885 106
2484165 2484165 2022-05-08 Scott Iowa 19163 41281 395
2484269 2484269 2022-05-08 Scott Kansas 20171 1275 34
2484394 2484394 2022-05-08 Scott Kentucky 21209 17630 109
2484684 2484684 2022-05-08 Scott Minnesota 27139 40862 260
2484765 2484765 2022-05-08 Scott Mississippi 28123 6540 118
2484883 2484883 2022-05-08 Scott Missouri 29201 11122 161
2485897 2485897 2022-05-08 Scott Tennessee 47151 9078 117
2486333 2486333 2022-05-08 Scott Virginia 51169 5836 111
2480201 2480201 2022-05-07 Scott Arkansas 5127 2296 43
2480714 2480714 2022-05-07 Scott Illinois 17171 1269 12
2480803 2480803 2022-05-07 Scott Indiana 18143 7885 106
2480907 2480907 2022-05-07 Scott Iowa 19163 41281 395
2481011 2481011 2022-05-07 Scott Kansas 20171 1275 34
2481136 2481136 2022-05-07 Scott Kentucky 21209 17630 109
2481426 2481426 2022-05-07 Scott Minnesota 27139 40862 260
2481507 2481507 2022-05-07 Scott Mississippi 28123 6540 118
2481625 2481625 2022-05-07 Scott Missouri 29201 11122 161
2482639 2482639 2022-05-07 Scott Tennessee 47151 9078 117
2483075 2483075 2022-05-07 Scott Virginia 51169 5836 111
2476943 2476943 2022-05-06 Scott Arkansas 5127 2295 43
2477456 2477456 2022-05-06 Scott Illinois 17171 1269 12
2477545 2477545 2022-05-06 Scott Indiana 18143 7885 106
2477649 2477649 2022-05-06 Scott Iowa 19163 41281 395
2477753 2477753 2022-05-06 Scott Kansas 20171 1275 34
2477878 2477878 2022-05-06 Scott Kentucky 21209 17630 109
2478168 2478168 2022-05-06 Scott Minnesota 27139 40862 260
2478249 2478249 2022-05-06 Scott Mississippi 28123 6540 118
2478367 2478367 2022-05-06 Scott Missouri 29201 11122 161
2479381 2479381 2022-05-06 Scott Tennessee 47151 9078 117
2479817 2479817 2022-05-06 Scott Virginia 51169 5836 111
2473685 2473685 2022-05-05 Scott Arkansas 5127 2295 43
2474198 2474198 2022-05-05 Scott Illinois 17171 1269 12
2474287 2474287 2022-05-05 Scott Indiana 18143 7885 106
2474391 2474391 2022-05-05 Scott Iowa 19163 41281 395
2474495 2474495 2022-05-05 Scott Kansas 20171 1275 34
2474620 2474620 2022-05-05 Scott Kentucky 21209 17630 109
2474910 2474910 2022-05-05 Scott Minnesota 27139 40815 260
2474991 2474991 2022-05-05 Scott Mississippi 28123 6540 118
2475109 2475109 2022-05-05 Scott Missouri 29201 11113 161
2476123 2476123 2022-05-05 Scott Tennessee 47151 9078 117
2476559 2476559 2022-05-05 Scott Virginia 51169 5837 111
2470428 2470428 2022-05-04 Scott Arkansas 5127 2295 43

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