⚠️ 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,930 rows where county = "Madison" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

  • Madison · 6,930
Link rowid date ▲ county state fips cases deaths
1095743 2021-03-07 Madison Alabama 1089 32708 469
1095852 2021-03-07 Madison Arkansas 5087 1411 21
1096059 2021-03-07 Madison Florida 12079 2014 43
1096183 2021-03-07 Madison Georgia 13195 3112 50
1096287 2021-03-07 Madison Idaho 16065 6440 22
1096355 2021-03-07 Madison Illinois 17119 28259 539
1096449 2021-03-07 Madison Indiana 18095 11841 344
1096554 2021-03-07 Madison Iowa 19121 1379 18
1096772 2021-03-07 Madison Kentucky 21151 8745 90
1096852 2021-03-07 Madison Louisiana 22065 1552 34
1097158 2021-03-07 Madison Mississippi 28089 9522 204
1097258 2021-03-07 Madison Missouri 29123 1348 16
1097340 2021-03-07 Madison Montana 30057 710 7
1097427 2021-03-07 Madison Nebraska 31119 4297 44
1097570 2021-03-07 Madison New York 36053 3896 85
1097660 2021-03-07 Madison North Carolina 37115 1373 39
1097808 2021-03-07 Madison Ohio 39097 3957 55
1098281 2021-03-07 Madison Tennessee 47113 10143 232
1098476 2021-03-07 Madison Texas 48313 1892 27
1098699 2021-03-07 Madison Virginia 51113 536 14
1092497 2021-03-06 Madison Alabama 1089 32674 469
1092606 2021-03-06 Madison Arkansas 5087 1410 21
1092813 2021-03-06 Madison Florida 12079 2012 43
1092937 2021-03-06 Madison Georgia 13195 3110 50
1093041 2021-03-06 Madison Idaho 16065 6440 22
1093109 2021-03-06 Madison Illinois 17119 28231 537
1093203 2021-03-06 Madison Indiana 18095 11830 344
1093308 2021-03-06 Madison Iowa 19121 1379 18
1093526 2021-03-06 Madison Kentucky 21151 8740 90
1093606 2021-03-06 Madison Louisiana 22065 1555 34
1093911 2021-03-06 Madison Mississippi 28089 9516 204
1094011 2021-03-06 Madison Missouri 29123 1348 16
1094093 2021-03-06 Madison Montana 30057 710 7
1094180 2021-03-06 Madison Nebraska 31119 4297 44
1094322 2021-03-06 Madison New York 36053 3893 85
1094412 2021-03-06 Madison North Carolina 37115 1373 39
1094560 2021-03-06 Madison Ohio 39097 3954 55
1095033 2021-03-06 Madison Tennessee 47113 10136 232
1095228 2021-03-06 Madison Texas 48313 1892 27
1095451 2021-03-06 Madison Virginia 51113 536 14
1089251 2021-03-05 Madison Alabama 1089 32639 469
1089360 2021-03-05 Madison Arkansas 5087 1408 21
1089567 2021-03-05 Madison Florida 12079 2011 43
1089691 2021-03-05 Madison Georgia 13195 3105 50
1089795 2021-03-05 Madison Idaho 16065 6427 22
1089863 2021-03-05 Madison Illinois 17119 28186 534
1089957 2021-03-05 Madison Indiana 18095 11812 344
1090062 2021-03-05 Madison Iowa 19121 1379 18
1090280 2021-03-05 Madison Kentucky 21151 8724 90
1090360 2021-03-05 Madison Louisiana 22065 1555 34
1090665 2021-03-05 Madison Mississippi 28089 9499 204
1090765 2021-03-05 Madison Missouri 29123 1348 16
1090847 2021-03-05 Madison Montana 30057 710 7
1090934 2021-03-05 Madison Nebraska 31119 4297 44
1091076 2021-03-05 Madison New York 36053 3882 85
1091166 2021-03-05 Madison North Carolina 37115 1369 39
1091314 2021-03-05 Madison Ohio 39097 3947 55
1091787 2021-03-05 Madison Tennessee 47113 10130 231
1091982 2021-03-05 Madison Texas 48313 1886 27
1092205 2021-03-05 Madison Virginia 51113 536 14
1086006 2021-03-04 Madison Alabama 1089 32616 468
1086115 2021-03-04 Madison Arkansas 5087 1407 21
1086322 2021-03-04 Madison Florida 12079 2008 43
1086446 2021-03-04 Madison Georgia 13195 3101 50
1086550 2021-03-04 Madison Idaho 16065 6406 22
1086618 2021-03-04 Madison Illinois 17119 28163 533
1086712 2021-03-04 Madison Indiana 18095 11809 342
1086817 2021-03-04 Madison Iowa 19121 1379 18
1087035 2021-03-04 Madison Kentucky 21151 8708 90
1087115 2021-03-04 Madison Louisiana 22065 1552 34
1087420 2021-03-04 Madison Mississippi 28089 9484 203
1087520 2021-03-04 Madison Missouri 29123 1348 16
1087602 2021-03-04 Madison Montana 30057 708 7
1087689 2021-03-04 Madison Nebraska 31119 4297 44
1087831 2021-03-04 Madison New York 36053 3869 85
1087921 2021-03-04 Madison North Carolina 37115 1359 39
1088069 2021-03-04 Madison Ohio 39097 3942 53
1088541 2021-03-04 Madison Tennessee 47113 10123 230
1088736 2021-03-04 Madison Texas 48313 1880 27
1088959 2021-03-04 Madison Virginia 51113 535 13
1082760 2021-03-03 Madison Alabama 1089 32573 462
1082869 2021-03-03 Madison Arkansas 5087 1407 21
1083076 2021-03-03 Madison Florida 12079 2003 43
1083200 2021-03-03 Madison Georgia 13195 3094 47
1083304 2021-03-03 Madison Idaho 16065 6391 22
1083372 2021-03-03 Madison Illinois 17119 28108 531
1083466 2021-03-03 Madison Indiana 18095 11797 342
1083571 2021-03-03 Madison Iowa 19121 1379 18
1083789 2021-03-03 Madison Kentucky 21151 8695 89
1083869 2021-03-03 Madison Louisiana 22065 1553 34
1084175 2021-03-03 Madison Mississippi 28089 9480 203
1084275 2021-03-03 Madison Missouri 29123 1346 16
1084357 2021-03-03 Madison Montana 30057 708 7
1084444 2021-03-03 Madison Nebraska 31119 4297 44
1084586 2021-03-03 Madison New York 36053 3863 85
1084676 2021-03-03 Madison North Carolina 37115 1356 39
1084824 2021-03-03 Madison Ohio 39097 3935 53
1085296 2021-03-03 Madison Tennessee 47113 10109 229
1085491 2021-03-03 Madison Texas 48313 1878 27
1085714 2021-03-03 Madison Virginia 51113 536 13

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