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

9,229 rows where county = "Lake" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 12

fips 12

county 1

  • Lake · 9,229 ✖
Link rowid date ▲ county state fips cases deaths
2499778 2499778 2022-05-13 Lake California 6033 11699 137
2499854 2499854 2022-05-13 Lake Colorado 8065 1843 2
2499931 2499931 2022-05-13 Lake Florida 12069 86320 1501
2500226 2500226 2022-05-13 Lake Illinois 17097 159179 1466
2500325 2500325 2022-05-13 Lake Indiana 18089 108660 1834
2500863 2500863 2022-05-13 Lake Michigan 26085 1893 37
2500942 2500942 2022-05-13 Lake Minnesota 27075 2138 28
2501216 2501216 2022-05-13 Lake Montana 30047 6634 100
2501686 2501686 2022-05-13 Lake Ohio 39085 49961 737
2501829 2501829 2022-05-13 Lake Oregon 41037 1429 29
2502083 2502083 2022-05-13 Lake South Dakota 46079 2335 28
2502158 2502158 2022-05-13 Lake Tennessee 47095 2749 43
2496520 2496520 2022-05-12 Lake California 6033 11693 137
2496596 2496596 2022-05-12 Lake Colorado 8065 1842 2
2496673 2496673 2022-05-12 Lake Florida 12069 86320 1501
2496968 2496968 2022-05-12 Lake Illinois 17097 158607 1466
2497067 2497067 2022-05-12 Lake Indiana 18089 108373 1833
2497605 2497605 2022-05-12 Lake Michigan 26085 1893 37
2497684 2497684 2022-05-12 Lake Minnesota 27075 2135 28
2497958 2497958 2022-05-12 Lake Montana 30047 6621 100
2498428 2498428 2022-05-12 Lake Ohio 39085 49961 737
2498571 2498571 2022-05-12 Lake Oregon 41037 1428 29
2498825 2498825 2022-05-12 Lake South Dakota 46079 2335 28
2498900 2498900 2022-05-12 Lake Tennessee 47095 2749 43
2493262 2493262 2022-05-11 Lake California 6033 11693 137
2493338 2493338 2022-05-11 Lake Colorado 8065 1826 2
2493415 2493415 2022-05-11 Lake Florida 12069 86320 1501
2493710 2493710 2022-05-11 Lake Illinois 17097 158299 1466
2493809 2493809 2022-05-11 Lake Indiana 18089 108373 1833
2494347 2494347 2022-05-11 Lake Michigan 26085 1893 37
2494426 2494426 2022-05-11 Lake Minnesota 27075 2127 28
2494700 2494700 2022-05-11 Lake Montana 30047 6621 100
2495170 2495170 2022-05-11 Lake Ohio 39085 49672 737
2495313 2495313 2022-05-11 Lake Oregon 41037 1426 29
2495567 2495567 2022-05-11 Lake South Dakota 46079 2335 28
2495642 2495642 2022-05-11 Lake Tennessee 47095 2749 43
2490004 2490004 2022-05-10 Lake California 6033 11693 137
2490080 2490080 2022-05-10 Lake Colorado 8065 1825 2
2490157 2490157 2022-05-10 Lake Florida 12069 86320 1503
2490452 2490452 2022-05-10 Lake Illinois 17097 157777 1466
2490551 2490551 2022-05-10 Lake Indiana 18089 108094 1830
2491089 2491089 2022-05-10 Lake Michigan 26085 1870 37
2491168 2491168 2022-05-10 Lake Minnesota 27075 2123 28
2491442 2491442 2022-05-10 Lake Montana 30047 6621 100
2491912 2491912 2022-05-10 Lake Ohio 39085 49672 737
2492055 2492055 2022-05-10 Lake Oregon 41037 1425 29
2492309 2492309 2022-05-10 Lake South Dakota 46079 2333 28
2492384 2492384 2022-05-10 Lake Tennessee 47095 2749 43
2486747 2486747 2022-05-09 Lake California 6033 11673 137
2486823 2486823 2022-05-09 Lake Colorado 8065 1824 2
2486900 2486900 2022-05-09 Lake Florida 12069 86320 1503
2487195 2487195 2022-05-09 Lake Illinois 17097 157445 1464
2487294 2487294 2022-05-09 Lake Indiana 18089 108094 1830
2487832 2487832 2022-05-09 Lake Michigan 26085 1870 37
2487911 2487911 2022-05-09 Lake Minnesota 27075 2108 28
2488184 2488184 2022-05-09 Lake Montana 30047 6621 100
2488654 2488654 2022-05-09 Lake Ohio 39085 49672 737
2488797 2488797 2022-05-09 Lake Oregon 41037 1423 29
2489051 2489051 2022-05-09 Lake South Dakota 46079 2333 28
2489126 2489126 2022-05-09 Lake Tennessee 47095 2749 43
2483489 2483489 2022-05-08 Lake California 6033 11673 137
2483565 2483565 2022-05-08 Lake Colorado 8065 1820 2
2483642 2483642 2022-05-08 Lake Florida 12069 86320 1503
2483937 2483937 2022-05-08 Lake Illinois 17097 156391 1463
2484036 2484036 2022-05-08 Lake Indiana 18089 107616 1826
2484574 2484574 2022-05-08 Lake Michigan 26085 1870 37
2484653 2484653 2022-05-08 Lake Minnesota 27075 2101 28
2484927 2484927 2022-05-08 Lake Montana 30047 6621 100
2485397 2485397 2022-05-08 Lake Ohio 39085 49672 737
2485540 2485540 2022-05-08 Lake Oregon 41037 1423 29
2485794 2485794 2022-05-08 Lake South Dakota 46079 2333 28
2485869 2485869 2022-05-08 Lake Tennessee 47095 2749 43
2480231 2480231 2022-05-07 Lake California 6033 11673 137
2480307 2480307 2022-05-07 Lake Colorado 8065 1820 2
2480384 2480384 2022-05-07 Lake Florida 12069 86320 1503
2480679 2480679 2022-05-07 Lake Illinois 17097 156391 1463
2480778 2480778 2022-05-07 Lake Indiana 18089 107616 1826
2481316 2481316 2022-05-07 Lake Michigan 26085 1870 37
2481395 2481395 2022-05-07 Lake Minnesota 27075 2101 28
2481669 2481669 2022-05-07 Lake Montana 30047 6621 100
2482139 2482139 2022-05-07 Lake Ohio 39085 49672 737
2482282 2482282 2022-05-07 Lake Oregon 41037 1423 29
2482536 2482536 2022-05-07 Lake South Dakota 46079 2333 28
2482611 2482611 2022-05-07 Lake Tennessee 47095 2749 43
2476973 2476973 2022-05-06 Lake California 6033 11673 137
2477049 2477049 2022-05-06 Lake Colorado 8065 1820 2
2477126 2477126 2022-05-06 Lake Florida 12069 86320 1503
2477421 2477421 2022-05-06 Lake Illinois 17097 156391 1463
2477520 2477520 2022-05-06 Lake Indiana 18089 107616 1826
2478058 2478058 2022-05-06 Lake Michigan 26085 1870 37
2478137 2478137 2022-05-06 Lake Minnesota 27075 2101 28
2478411 2478411 2022-05-06 Lake Montana 30047 6621 100
2478881 2478881 2022-05-06 Lake Ohio 39085 49672 737
2479024 2479024 2022-05-06 Lake Oregon 41037 1423 29
2479278 2479278 2022-05-06 Lake South Dakota 46079 2333 28
2479353 2479353 2022-05-06 Lake Tennessee 47095 2749 43
2473715 2473715 2022-05-05 Lake California 6033 11665 137
2473791 2473791 2022-05-05 Lake Colorado 8065 1820 2
2473868 2473868 2022-05-05 Lake Florida 12069 85479 1503
2474163 2474163 2022-05-05 Lake Illinois 17097 155786 1463

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