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

11,370 rows where county = "Madison" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Madison · 11,370 ✖
Link rowid date ▲ county state fips cases deaths
1816658 1816658 2021-10-15 Madison Alabama 1089 51923 685
1816768 1816768 2021-10-15 Madison Arkansas 5087 2455 37
1816975 1816975 2021-10-15 Madison Florida 12079 3572 54
1817099 1817099 2021-10-15 Madison Georgia 13195 4927 72
1817204 1817204 2021-10-15 Madison Idaho 16065 8410 35
1817272 1817272 2021-10-15 Madison Illinois 17119 39883 663
1817366 1817366 2021-10-15 Madison Indiana 18095 18571 427
1817471 1817471 2021-10-15 Madison Iowa 19121 2147 25
1817688 1817688 2021-10-15 Madison Kentucky 21151 15532 145
1817768 1817768 2021-10-15 Madison Louisiana 22065 2219 52
1818074 1818074 2021-10-15 Madison Mississippi 28089 14525 279
1818174 1818174 2021-10-15 Madison Missouri 29123 2298 24
1818256 1818256 2021-10-15 Madison Montana 30057 1197 11
1818343 1818343 2021-10-15 Madison Nebraska 31119 5548 44
1818486 1818486 2021-10-15 Madison New York 36053 6036 101
1818576 1818576 2021-10-15 Madison North Carolina 37115 2718 57
1818724 1818724 2021-10-15 Madison Ohio 39097 5849 76
1819197 1819197 2021-10-15 Madison Tennessee 47113 17432 304
1819392 1819392 2021-10-15 Madison Texas 48313 2453 43
1819615 1819615 2021-10-15 Madison Virginia 51113 960 20
1813410 1813410 2021-10-14 Madison Alabama 1089 51829 685
1813520 1813520 2021-10-14 Madison Arkansas 5087 2454 37
1813727 1813727 2021-10-14 Madison Florida 12079 3553 54
1813851 1813851 2021-10-14 Madison Georgia 13195 4921 72
1813956 1813956 2021-10-14 Madison Idaho 16065 8393 35
1814024 1814024 2021-10-14 Madison Illinois 17119 39811 663
1814118 1814118 2021-10-14 Madison Indiana 18095 18521 427
1814223 1814223 2021-10-14 Madison Iowa 19121 2147 25
1814440 1814440 2021-10-14 Madison Kentucky 21151 15493 145
1814520 1814520 2021-10-14 Madison Louisiana 22065 2216 52
1814825 1814825 2021-10-14 Madison Mississippi 28089 14513 278
1814925 1814925 2021-10-14 Madison Missouri 29123 2294 24
1815007 1815007 2021-10-14 Madison Montana 30057 1192 9
1815094 1815094 2021-10-14 Madison Nebraska 31119 5523 44
1815237 1815237 2021-10-14 Madison New York 36053 5994 101
1815327 1815327 2021-10-14 Madison North Carolina 37115 2711 57
1815475 1815475 2021-10-14 Madison Ohio 39097 5830 75
1815948 1815948 2021-10-14 Madison Tennessee 47113 17400 297
1816143 1816143 2021-10-14 Madison Texas 48313 2443 43
1816366 1816366 2021-10-14 Madison Virginia 51113 958 20
1810161 1810161 2021-10-13 Madison Alabama 1089 51721 676
1810271 1810271 2021-10-13 Madison Arkansas 5087 2450 37
1810478 1810478 2021-10-13 Madison Florida 12079 3553 54
1810602 1810602 2021-10-13 Madison Georgia 13195 4913 71
1810707 1810707 2021-10-13 Madison Idaho 16065 8364 36
1810775 1810775 2021-10-13 Madison Illinois 17119 39758 660
1810869 1810869 2021-10-13 Madison Indiana 18095 18464 423
1810974 1810974 2021-10-13 Madison Iowa 19121 2147 25
1811191 1811191 2021-10-13 Madison Kentucky 21151 15455 145
1811271 1811271 2021-10-13 Madison Louisiana 22065 2214 52
1811577 1811577 2021-10-13 Madison Mississippi 28089 14507 278
1811677 1811677 2021-10-13 Madison Missouri 29123 2288 25
1811759 1811759 2021-10-13 Madison Montana 30057 1185 8
1811846 1811846 2021-10-13 Madison Nebraska 31119 5511 44
1811989 1811989 2021-10-13 Madison New York 36053 5957 101
1812079 1812079 2021-10-13 Madison North Carolina 37115 2694 56
1812227 1812227 2021-10-13 Madison Ohio 39097 5817 75
1812700 1812700 2021-10-13 Madison Tennessee 47113 17382 297
1812895 1812895 2021-10-13 Madison Texas 48313 2437 43
1813118 1813118 2021-10-13 Madison Virginia 51113 954 20
1806912 1806912 2021-10-12 Madison Alabama 1089 51655 666
1807022 1807022 2021-10-12 Madison Arkansas 5087 2446 37
1807229 1807229 2021-10-12 Madison Florida 12079 3553 54
1807353 1807353 2021-10-12 Madison Georgia 13195 4905 70
1807458 1807458 2021-10-12 Madison Idaho 16065 8337 36
1807526 1807526 2021-10-12 Madison Illinois 17119 39698 659
1807620 1807620 2021-10-12 Madison Indiana 18095 18380 423
1807725 1807725 2021-10-12 Madison Iowa 19121 2099 23
1807942 1807942 2021-10-12 Madison Kentucky 21151 15416 144
1808022 1808022 2021-10-12 Madison Louisiana 22065 2214 52
1808328 1808328 2021-10-12 Madison Mississippi 28089 14497 277
1808428 1808428 2021-10-12 Madison Missouri 29123 2285 24
1808510 1808510 2021-10-12 Madison Montana 30057 1178 8
1808597 1808597 2021-10-12 Madison Nebraska 31119 5496 44
1808740 1808740 2021-10-12 Madison New York 36053 5922 100
1808830 1808830 2021-10-12 Madison North Carolina 37115 2688 56
1808978 1808978 2021-10-12 Madison Ohio 39097 5796 75
1809451 1809451 2021-10-12 Madison Tennessee 47113 17348 297
1809646 1809646 2021-10-12 Madison Texas 48313 2434 43
1809869 1809869 2021-10-12 Madison Virginia 51113 950 20
1803661 1803661 2021-10-11 Madison Alabama 1089 51605 666
1803771 1803771 2021-10-11 Madison Arkansas 5087 2440 37
1803978 1803978 2021-10-11 Madison Florida 12079 3553 54
1804102 1804102 2021-10-11 Madison Georgia 13195 4882 67
1804207 1804207 2021-10-11 Madison Idaho 16065 8301 36
1804275 1804275 2021-10-11 Madison Illinois 17119 39499 658
1804369 1804369 2021-10-11 Madison Indiana 18095 18341 423
1804474 1804474 2021-10-11 Madison Iowa 19121 2099 23
1804691 1804691 2021-10-11 Madison Kentucky 21151 15339 144
1804771 1804771 2021-10-11 Madison Louisiana 22065 2204 52
1805077 1805077 2021-10-11 Madison Mississippi 28089 14478 277
1805177 1805177 2021-10-11 Madison Missouri 29123 2284 24
1805259 1805259 2021-10-11 Madison Montana 30057 1165 8
1805346 1805346 2021-10-11 Madison Nebraska 31119 5460 44
1805489 1805489 2021-10-11 Madison New York 36053 5909 99
1805579 1805579 2021-10-11 Madison North Carolina 37115 2684 56
1805728 1805728 2021-10-11 Madison Ohio 39097 5771 74
1806201 1806201 2021-10-11 Madison Tennessee 47113 17303 297
1806396 1806396 2021-10-11 Madison Texas 48313 2431 43
1806619 1806619 2021-10-11 Madison Virginia 51113 940 20

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