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

5,870 rows where county = "Madison" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Madison · 5,870 ✖
Link rowid date ▲ county state fips cases deaths
923807 923807 2021-01-13 Madison Alabama 1089 26190 182
923916 923916 2021-01-13 Madison Arkansas 5087 1168 14
924123 924123 2021-01-13 Madison Florida 12079 1662 34
924247 924247 2021-01-13 Madison Georgia 13195 2293 27
924351 924351 2021-01-13 Madison Idaho 16065 5540 21
924419 924419 2021-01-13 Madison Illinois 17119 23450 445
924512 924512 2021-01-13 Madison Indiana 18095 10284 224
924617 924617 2021-01-13 Madison Iowa 19121 1150 9
924835 924835 2021-01-13 Madison Kentucky 21151 6594 43
924915 924915 2021-01-13 Madison Louisiana 22065 1438 25
925221 925221 2021-01-13 Madison Mississippi 28089 7937 156
925321 925321 2021-01-13 Madison Missouri 29123 1284 11
925403 925403 2021-01-13 Madison Montana 30057 576 3
925490 925490 2021-01-13 Madison Nebraska 31119 3915 40
925633 925633 2021-01-13 Madison New York 36053 2911 73
925723 925723 2021-01-13 Madison North Carolina 37115 996 22
925871 925871 2021-01-13 Madison Ohio 39097 3294 28
926343 926343 2021-01-13 Madison Tennessee 47113 8917 172
926538 926538 2021-01-13 Madison Texas 48313 1145 18
926761 926761 2021-01-13 Madison Virginia 51113 370 5
920562 920562 2021-01-12 Madison Alabama 1089 26012 181
920671 920671 2021-01-12 Madison Arkansas 5087 1163 14
920878 920878 2021-01-12 Madison Florida 12079 1654 34
921002 921002 2021-01-12 Madison Georgia 13195 2266 26
921106 921106 2021-01-12 Madison Idaho 16065 5490 21
921174 921174 2021-01-12 Madison Illinois 17119 23239 444
921267 921267 2021-01-12 Madison Indiana 18095 10196 223
921372 921372 2021-01-12 Madison Iowa 19121 1131 9
921590 921590 2021-01-12 Madison Kentucky 21151 6531 42
921670 921670 2021-01-12 Madison Louisiana 22065 1436 25
921976 921976 2021-01-12 Madison Mississippi 28089 7893 153
922076 922076 2021-01-12 Madison Missouri 29123 1279 11
922158 922158 2021-01-12 Madison Montana 30057 559 3
922245 922245 2021-01-12 Madison Nebraska 31119 3897 40
922387 922387 2021-01-12 Madison New York 36053 2885 73
922477 922477 2021-01-12 Madison North Carolina 37115 983 21
922625 922625 2021-01-12 Madison Ohio 39097 3269 28
923097 923097 2021-01-12 Madison Tennessee 47113 8866 168
923292 923292 2021-01-12 Madison Texas 48313 1147 18
923515 923515 2021-01-12 Madison Virginia 51113 364 5
917317 917317 2021-01-11 Madison Alabama 1089 25643 178
917426 917426 2021-01-11 Madison Arkansas 5087 1152 14
917633 917633 2021-01-11 Madison Florida 12079 1650 34
917757 917757 2021-01-11 Madison Georgia 13195 2223 26
917861 917861 2021-01-11 Madison Idaho 16065 5467 21
917929 917929 2021-01-11 Madison Illinois 17119 23063 433
918022 918022 2021-01-11 Madison Indiana 18095 10113 221
918127 918127 2021-01-11 Madison Iowa 19121 1116 9
918345 918345 2021-01-11 Madison Kentucky 21151 6385 40
918425 918425 2021-01-11 Madison Louisiana 22065 1423 25
918731 918731 2021-01-11 Madison Mississippi 28089 7868 152
918831 918831 2021-01-11 Madison Missouri 29123 1278 11
918913 918913 2021-01-11 Madison Montana 30057 558 3
919000 919000 2021-01-11 Madison Nebraska 31119 3886 40
919142 919142 2021-01-11 Madison New York 36053 2849 73
919232 919232 2021-01-11 Madison North Carolina 37115 977 20
919380 919380 2021-01-11 Madison Ohio 39097 3244 27
919852 919852 2021-01-11 Madison Tennessee 47113 8805 166
920047 920047 2021-01-11 Madison Texas 48313 1147 18
920270 920270 2021-01-11 Madison Virginia 51113 362 5
914072 914072 2021-01-10 Madison Alabama 1089 25463 178
914181 914181 2021-01-10 Madison Arkansas 5087 1144 14
914388 914388 2021-01-10 Madison Florida 12079 1647 34
914512 914512 2021-01-10 Madison Georgia 13195 2194 26
914616 914616 2021-01-10 Madison Idaho 16065 5461 21
914684 914684 2021-01-10 Madison Illinois 17119 22953 433
914777 914777 2021-01-10 Madison Indiana 18095 10043 217
914882 914882 2021-01-10 Madison Iowa 19121 1095 9
915100 915100 2021-01-10 Madison Kentucky 21151 6320 42
915180 915180 2021-01-10 Madison Louisiana 22065 1413 24
915486 915486 2021-01-10 Madison Mississippi 28089 7853 152
915586 915586 2021-01-10 Madison Missouri 29123 1276 11
915668 915668 2021-01-10 Madison Montana 30057 557 3
915755 915755 2021-01-10 Madison Nebraska 31119 3880 40
915897 915897 2021-01-10 Madison New York 36053 2807 73
915987 915987 2021-01-10 Madison North Carolina 37115 968 20
916135 916135 2021-01-10 Madison Ohio 39097 3214 27
916607 916607 2021-01-10 Madison Tennessee 47113 8769 162
916802 916802 2021-01-10 Madison Texas 48313 1147 18
917025 917025 2021-01-10 Madison Virginia 51113 356 5
910827 910827 2021-01-09 Madison Alabama 1089 25219 177
910936 910936 2021-01-09 Madison Arkansas 5087 1136 14
911143 911143 2021-01-09 Madison Florida 12079 1639 34
911267 911267 2021-01-09 Madison Georgia 13195 2160 26
911371 911371 2021-01-09 Madison Idaho 16065 5444 21
911439 911439 2021-01-09 Madison Illinois 17119 22785 429
911532 911532 2021-01-09 Madison Indiana 18095 9958 217
911637 911637 2021-01-09 Madison Iowa 19121 1093 9
911855 911855 2021-01-09 Madison Kentucky 21151 6246 40
911935 911935 2021-01-09 Madison Louisiana 22065 1403 24
912241 912241 2021-01-09 Madison Mississippi 28089 7796 151
912341 912341 2021-01-09 Madison Missouri 29123 1266 11
912423 912423 2021-01-09 Madison Montana 30057 552 3
912510 912510 2021-01-09 Madison Nebraska 31119 3875 40
912652 912652 2021-01-09 Madison New York 36053 2746 72
912742 912742 2021-01-09 Madison North Carolina 37115 949 20
912890 912890 2021-01-09 Madison Ohio 39097 3199 27
913362 913362 2021-01-09 Madison Tennessee 47113 8706 162
913557 913557 2021-01-09 Madison Texas 48313 1147 18
913780 913780 2021-01-09 Madison Virginia 51113 347 5

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