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

6,805 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

fips

county

  • Lake · 6,805 ✖
Link rowid date ▲ county state fips cases deaths
1842810 1842810 2021-10-23 Lake California 6033 6631 105
1842886 1842886 2021-10-23 Lake Colorado 8065 1023 1
1842963 1842963 2021-10-23 Lake Florida 12069 54129 1181
1843258 1843258 2021-10-23 Lake Illinois 17097 80287 1161
1843357 1843357 2021-10-23 Lake Indiana 18089 66502 1214
1843893 1843893 2021-10-23 Lake Michigan 26085 940 21
1843972 1843972 2021-10-23 Lake Minnesota 27075 1095 21
1844245 1844245 2021-10-23 Lake Montana 30047 3993 61
1844711 1844711 2021-10-23 Lake Ohio 39085 27063 448
1844854 1844854 2021-10-23 Lake Oregon 41037 939 12
1845108 1845108 2021-10-23 Lake South Dakota 46079 1552 20
1845183 1845183 2021-10-23 Lake Tennessee 47095 2015 31
1839560 1839560 2021-10-22 Lake California 6033 6631 105
1839636 1839636 2021-10-22 Lake Colorado 8065 1023 1
1839713 1839713 2021-10-22 Lake Florida 12069 54129 1181
1840008 1840008 2021-10-22 Lake Illinois 17097 80287 1161
1840107 1840107 2021-10-22 Lake Indiana 18089 66502 1214
1840643 1840643 2021-10-22 Lake Michigan 26085 940 21
1840722 1840722 2021-10-22 Lake Minnesota 27075 1095 21
1840995 1840995 2021-10-22 Lake Montana 30047 3993 61
1841461 1841461 2021-10-22 Lake Ohio 39085 26979 448
1841604 1841604 2021-10-22 Lake Oregon 41037 939 12
1841858 1841858 2021-10-22 Lake South Dakota 46079 1552 20
1841933 1841933 2021-10-22 Lake Tennessee 47095 2015 31
1836311 1836311 2021-10-21 Lake California 6033 6605 104
1836387 1836387 2021-10-21 Lake Colorado 8065 1017 1
1836464 1836464 2021-10-21 Lake Florida 12069 53868 1181
1836759 1836759 2021-10-21 Lake Illinois 17097 80107 1159
1836858 1836858 2021-10-21 Lake Indiana 18089 66392 1212
1837394 1837394 2021-10-21 Lake Michigan 26085 930 20
1837473 1837473 2021-10-21 Lake Minnesota 27075 1091 21
1837746 1837746 2021-10-21 Lake Montana 30047 3937 61
1838212 1838212 2021-10-21 Lake Ohio 39085 26907 443
1838355 1838355 2021-10-21 Lake Oregon 41037 924 12
1838609 1838609 2021-10-21 Lake South Dakota 46079 1551 20
1838684 1838684 2021-10-21 Lake Tennessee 47095 2015 31
1833062 1833062 2021-10-20 Lake California 6033 6593 104
1833138 1833138 2021-10-20 Lake Colorado 8065 1012 1
1833215 1833215 2021-10-20 Lake Florida 12069 53868 1181
1833510 1833510 2021-10-20 Lake Illinois 17097 80010 1156
1833609 1833609 2021-10-20 Lake Indiana 18089 66276 1207
1834145 1834145 2021-10-20 Lake Michigan 26085 930 20
1834224 1834224 2021-10-20 Lake Minnesota 27075 1083 21
1834497 1834497 2021-10-20 Lake Montana 30047 3921 60
1834963 1834963 2021-10-20 Lake Ohio 39085 26812 443
1835106 1835106 2021-10-20 Lake Oregon 41037 918 12
1835360 1835360 2021-10-20 Lake South Dakota 46079 1551 20
1835435 1835435 2021-10-20 Lake Tennessee 47095 2012 31
1829813 1829813 2021-10-19 Lake California 6033 6583 104
1829889 1829889 2021-10-19 Lake Colorado 8065 1009 1
1829966 1829966 2021-10-19 Lake Florida 12069 53868 1181
1830261 1830261 2021-10-19 Lake Illinois 17097 79892 1153
1830360 1830360 2021-10-19 Lake Indiana 18089 66185 1205
1830896 1830896 2021-10-19 Lake Michigan 26085 920 20
1830975 1830975 2021-10-19 Lake Minnesota 27075 1081 21
1831248 1831248 2021-10-19 Lake Montana 30047 3889 58
1831714 1831714 2021-10-19 Lake Ohio 39085 26743 443
1831857 1831857 2021-10-19 Lake Oregon 41037 910 12
1832111 1832111 2021-10-19 Lake South Dakota 46079 1549 20
1832186 1832186 2021-10-19 Lake Tennessee 47095 2009 31
1826564 1826564 2021-10-18 Lake California 6033 6565 104
1826640 1826640 2021-10-18 Lake Colorado 8065 1002 1
1826717 1826717 2021-10-18 Lake Florida 12069 53868 1181
1827012 1827012 2021-10-18 Lake Illinois 17097 79793 1153
1827111 1827111 2021-10-18 Lake Indiana 18089 66095 1204
1827647 1827647 2021-10-18 Lake Michigan 26085 920 20
1827726 1827726 2021-10-18 Lake Minnesota 27075 1065 21
1827999 1827999 2021-10-18 Lake Montana 30047 3867 58
1828465 1828465 2021-10-18 Lake Ohio 39085 26669 434
1828608 1828608 2021-10-18 Lake Oregon 41037 897 11
1828862 1828862 2021-10-18 Lake South Dakota 46079 1546 20
1828937 1828937 2021-10-18 Lake Tennessee 47095 2007 31
1823315 1823315 2021-10-17 Lake California 6033 6506 104
1823391 1823391 2021-10-17 Lake Colorado 8065 997 1
1823468 1823468 2021-10-17 Lake Florida 12069 53868 1137
1823763 1823763 2021-10-17 Lake Illinois 17097 79526 1147
1823862 1823862 2021-10-17 Lake Indiana 18089 65914 1199
1824398 1824398 2021-10-17 Lake Michigan 26085 911 20
1824477 1824477 2021-10-17 Lake Minnesota 27075 1062 21
1824750 1824750 2021-10-17 Lake Montana 30047 3822 58
1825216 1825216 2021-10-17 Lake Ohio 39085 26609 434
1825359 1825359 2021-10-17 Lake Oregon 41037 890 11
1825613 1825613 2021-10-17 Lake South Dakota 46079 1545 20
1825688 1825688 2021-10-17 Lake Tennessee 47095 2004 31
1820066 1820066 2021-10-16 Lake California 6033 6506 104
1820142 1820142 2021-10-16 Lake Colorado 8065 997 1
1820219 1820219 2021-10-16 Lake Florida 12069 53868 1137
1820514 1820514 2021-10-16 Lake Illinois 17097 79526 1147
1820613 1820613 2021-10-16 Lake Indiana 18089 65914 1199
1821149 1821149 2021-10-16 Lake Michigan 26085 911 20
1821228 1821228 2021-10-16 Lake Minnesota 27075 1062 21
1821501 1821501 2021-10-16 Lake Montana 30047 3822 58
1821967 1821967 2021-10-16 Lake Ohio 39085 26543 434
1822110 1822110 2021-10-16 Lake Oregon 41037 890 11
1822364 1822364 2021-10-16 Lake South Dakota 46079 1545 20
1822439 1822439 2021-10-16 Lake Tennessee 47095 2004 31
1816817 1816817 2021-10-15 Lake California 6033 6506 104
1816893 1816893 2021-10-15 Lake Colorado 8065 997 1
1816970 1816970 2021-10-15 Lake Florida 12069 53868 1137
1817265 1817265 2021-10-15 Lake Illinois 17097 79526 1147

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