ny_times_us_counties

⚠️ 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

2,150 rows where county = "Madison" sorted by date descending

View and edit SQL

state

fips

county

  • Madison · 2,150
Link rowid date ▲ county state fips cases deaths
316491 2020-07-11 Madison Alabama 1089 2150 10
316599 2020-07-11 Madison Arkansas 5087 222 1
316802 2020-07-11 Madison Florida 12079 320 4
316926 2020-07-11 Madison Georgia 13195 162 4
317026 2020-07-11 Madison Idaho 16065 67 0
317094 2020-07-11 Madison Illinois 17119 1167 70
317188 2020-07-11 Madison Indiana 18095 685 74
317293 2020-07-11 Madison Iowa 19121 55 2
317505 2020-07-11 Madison Kentucky 21151 183 1
317585 2020-07-11 Madison Louisiana 22065 415 4
317890 2020-07-11 Madison Mississippi 28089 1446 38
317990 2020-07-11 Madison Missouri 29123 7 0
318065 2020-07-11 Madison Montana 30057 29 1
318132 2020-07-11 Madison Nebraska 31119 390 4
318271 2020-07-11 Madison New York 36053 374 5
318361 2020-07-11 Madison North Carolina 37115 17 0
318504 2020-07-11 Madison Ohio 39097 216 9
318894 2020-07-11 Madison Tennessee 47113 352 2
319085 2020-07-11 Madison Texas 48313 107 0
319301 2020-07-11 Madison Virginia 51113 47 1
313393 2020-07-10 Madison Alabama 1089 2012 10
313501 2020-07-10 Madison Arkansas 5087 215 0
313704 2020-07-10 Madison Florida 12079 302 4
313828 2020-07-10 Madison Georgia 13195 158 4
313928 2020-07-10 Madison Idaho 16065 65 0
313996 2020-07-10 Madison Illinois 17119 1134 70
314090 2020-07-10 Madison Indiana 18095 683 74
314195 2020-07-10 Madison Iowa 19121 53 2
314407 2020-07-10 Madison Kentucky 21151 178 1
314487 2020-07-10 Madison Louisiana 22065 411 4
314792 2020-07-10 Madison Mississippi 28089 1419 36
314892 2020-07-10 Madison Missouri 29123 7 0
314967 2020-07-10 Madison Montana 30057 25 1
315034 2020-07-10 Madison Nebraska 31119 390 4
315171 2020-07-10 Madison New York 36053 371 5
315261 2020-07-10 Madison North Carolina 37115 15 0
315404 2020-07-10 Madison Ohio 39097 213 9
315793 2020-07-10 Madison Tennessee 47113 347 2
315984 2020-07-10 Madison Texas 48313 97 0
316200 2020-07-10 Madison Virginia 51113 46 1
310301 2020-07-09 Madison Alabama 1089 1934 9
310409 2020-07-09 Madison Arkansas 5087 214 0
310612 2020-07-09 Madison Florida 12079 283 4
310736 2020-07-09 Madison Georgia 13195 143 4
310836 2020-07-09 Madison Idaho 16065 54 0
310904 2020-07-09 Madison Illinois 17119 1111 70
310998 2020-07-09 Madison Indiana 18095 679 74
311103 2020-07-09 Madison Iowa 19121 51 2
311313 2020-07-09 Madison Kentucky 21151 169 1
311393 2020-07-09 Madison Louisiana 22065 406 3
311698 2020-07-09 Madison Mississippi 28089 1382 36
311798 2020-07-09 Madison Missouri 29123 7 0
311873 2020-07-09 Madison Montana 30057 22 1
311940 2020-07-09 Madison Nebraska 31119 390 4
312075 2020-07-09 Madison New York 36053 368 4
312165 2020-07-09 Madison North Carolina 37115 15 0
312308 2020-07-09 Madison Ohio 39097 206 9
312696 2020-07-09 Madison Tennessee 47113 340 2
312886 2020-07-09 Madison Texas 48313 96 0
313102 2020-07-09 Madison Virginia 51113 46 1
307206 2020-07-08 Madison Alabama 1089 1646 9
307314 2020-07-08 Madison Arkansas 5087 214 0
307517 2020-07-08 Madison Florida 12079 273 4
307641 2020-07-08 Madison Georgia 13195 136 4
307742 2020-07-08 Madison Idaho 16065 54 0
307810 2020-07-08 Madison Illinois 17119 1090 70
307904 2020-07-08 Madison Indiana 18095 678 74
308009 2020-07-08 Madison Iowa 19121 50 2
308219 2020-07-08 Madison Kentucky 21151 160 1
308299 2020-07-08 Madison Louisiana 22065 401 3
308604 2020-07-08 Madison Mississippi 28089 1355 36
308704 2020-07-08 Madison Missouri 29123 7 0
308779 2020-07-08 Madison Montana 30057 21 1
308846 2020-07-08 Madison Nebraska 31119 379 4
308981 2020-07-08 Madison New York 36053 368 4
309071 2020-07-08 Madison North Carolina 37115 15 0
309216 2020-07-08 Madison Ohio 39097 202 9
309604 2020-07-08 Madison Tennessee 47113 339 2
309794 2020-07-08 Madison Texas 48313 75 0
310010 2020-07-08 Madison Virginia 51113 46 1
304117 2020-07-07 Madison Alabama 1089 1579 9
304224 2020-07-07 Madison Arkansas 5087 211 0
304427 2020-07-07 Madison Florida 12079 265 4
304551 2020-07-07 Madison Georgia 13195 128 4
304652 2020-07-07 Madison Idaho 16065 48 0
304720 2020-07-07 Madison Illinois 17119 1062 70
304814 2020-07-07 Madison Indiana 18095 674 74
304919 2020-07-07 Madison Iowa 19121 48 2
305129 2020-07-07 Madison Kentucky 21151 152 1
305209 2020-07-07 Madison Louisiana 22065 393 3
305514 2020-07-07 Madison Mississippi 28089 1326 35
305613 2020-07-07 Madison Missouri 29123 7 0
305688 2020-07-07 Madison Montana 30057 19 1
305755 2020-07-07 Madison Nebraska 31119 378 4
305890 2020-07-07 Madison New York 36053 367 4
305980 2020-07-07 Madison North Carolina 37115 15 0
306124 2020-07-07 Madison Ohio 39097 199 9
306510 2020-07-07 Madison Tennessee 47113 318 2
306700 2020-07-07 Madison Texas 48313 45 0
306915 2020-07-07 Madison Virginia 51113 46 1

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
);
Powered by Datasette · Query took 1074.176ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette