2c:null 2d:["$","title",null,{"children":"Spending By Iowa Cities (Police vs other services) | Jose Jimenez | Observable"}] 32:T9a2,chart2 = { const root = pack2(higher); let focus = root; let view; const svg = d3.create("svg") .attr("viewBox", `-${width / 2} -${height / 2} ${width} ${height}`) .style("display", "block") .style("margin", "0 -14px") .style("background", color2(0)) .style("cursor", "pointer") .on("click", () => zoom(root)); const node = svg.append("g") .selectAll("circle") .data(root.descendants().slice(1)) .join("circle") .attr("fill", d => d.children ? color2(d.depth) : "white") .attr('stroke-width', d => d.data.name === 'Police' ? 2 : 1) .attr('stroke', d => d.data.name === 'Police' ? 'red' : 'white') .attr("pointer-events", d => !d.children ? "none" : null) .attr('title', d => `${format(d.value)}`) .on("mouseover", function() { d3.select(this).attr("stroke", "#000"); }) .on("mouseout", function() { d3.select(this).attr("stroke", null); }) .on("click", d => focus !== d && (zoom(d), d3.event.stopPropagation())); const label = svg.append("g") .style("font", "10px sans-serif") .attr("pointer-events", "none") .attr("text-anchor", "middle") .selectAll("text") .data(root.descendants()) .join("text") .style("fill-opacity", d => d.parent === root ? 1 : 0) .style("display", d => d.parent === root ? "inline" : "none") .text(d => `${d.data.name} - ${format(d.value)}`); zoomTo([root.x, root.y, root.r * 2]); function zoomTo(v) { const k = width / v[2]; view = v; label.attr("transform", d => `translate(${(d.x - v[0]) * k},${(d.y - v[1]) * k})`); node.attr("transform", d => `translate(${(d.x - v[0]) * k},${(d.y - v[1]) * k})`); node.attr("r", d => d.r * k); } function zoom(d) { const focus0 = focus; focus = d; const transition = svg.transition() .duration(d3.event.altKey ? 7500 : 750) .tween("zoom", d => { const i = d3.interpolateZoom(view, [focus.x, focus.y, focus.r * 2]); return t => zoomTo(i(t)); }); label .filter(function(d) { return d.parent === focus || this.style.display === "inline"; }) .transition(transition) .style("fill-opacity", d => d.parent === focus ? 1 : 0) .on("start", function(d) { if (d.parent === focus) this.style.display = "inline"; }) .on("end", function(d) { if (d.parent !== focus) this.style.display = "none"; }); } return svg.node(); }33:Taa15,census_population_data = d3.tsvParse(`SUMLEV STATE COUNTY PLACE COUSUB CONCIT PRIMGEO_FLAG FUNCSTAT NAME STNAME POPESTIMATE2019 162 19 0 190 0 0 0 A Ackley city Iowa 1498 162 19 0 235 0 0 0 A Ackworth city Iowa 105 162 19 0 370 0 0 0 A Adair city Iowa 713 162 19 0 505 0 0 0 A Adel city Iowa 5455 162 19 0 595 0 0 0 A Afton city Iowa 815 162 19 0 640 0 0 0 A Agency city Iowa 643 162 19 0 730 0 0 0 A Ainsworth city Iowa 579 162 19 0 775 0 0 0 A Akron city Iowa 1463 162 19 0 865 0 0 0 A Albert City city Iowa 665 162 19 0 910 0 0 0 A Albia city Iowa 3681 162 19 0 955 0 0 0 A Albion city Iowa 490 162 19 0 1000 0 0 0 A Alburnett city Iowa 699 162 19 0 1045 0 0 0 A Alden city Iowa 738 162 19 0 1090 0 0 0 A Alexander city Iowa 161 162 19 0 1135 0 0 0 A Algona city Iowa 5397 162 19 0 1180 0 0 0 A Alleman city Iowa 452 162 19 0 1270 0 0 0 A Allerton city Iowa 507 162 19 0 1315 0 0 0 A Allison city Iowa 973 162 19 0 1495 0 0 0 A Alta city Iowa 1903 162 19 0 1540 0 0 0 A Alta Vista city Iowa 252 162 19 0 1585 0 0 0 A Alton city Iowa 1248 162 19 0 1630 0 0 0 A Altoona city Iowa 19221 162 19 0 1675 0 0 0 A Alvord city Iowa 201 162 19 0 1855 0 0 0 A Ames city Iowa 66258 162 19 0 1990 0 0 0 A Anamosa city Iowa 5537 162 19 0 2080 0 0 0 A Andover city Iowa 98 162 19 0 2125 0 0 0 A Andrew city Iowa 408 162 19 0 2260 0 0 0 A Anita city Iowa 900 162 19 0 2305 0 0 0 A Ankeny city Iowa 67355 162 19 0 2350 0 0 0 A Anthon city Iowa 561 162 19 0 2395 0 0 0 A Aplington city Iowa 1050 162 19 0 2485 0 0 0 A Arcadia city Iowa 520 162 19 0 2530 0 0 0 A Archer city Iowa 124 162 19 0 2620 0 0 0 A Aredale city Iowa 69 162 19 0 2755 0 0 0 A Arion city Iowa 107 162 19 0 2800 0 0 0 A Arispe city Iowa 97 162 19 0 2845 0 0 0 A Arlington city Iowa 399 162 19 0 2935 0 0 0 A Armstrong city Iowa 840 162 19 0 3025 0 0 0 A Arnolds Park city Iowa 1313 162 19 0 3115 0 0 0 A Arthur city Iowa 194 162 19 0 3160 0 0 0 A Asbury city Iowa 5747 162 19 0 3295 0 0 0 A Ashton city Iowa 420 162 19 0 3340 0 0 0 A Aspinwall city Iowa 39 162 19 0 3385 0 0 0 A Atalissa city Iowa 308 162 19 0 3475 0 0 0 A Atkins city Iowa 1970 162 19 0 3520 0 0 0 A Atlantic city Iowa 6526 162 19 0 3610 0 0 0 A Auburn city Iowa 305 162 19 0 3655 0 0 0 A Audubon city Iowa 1898 162 19 0 3745 0 0 0 A Aurelia city Iowa 958 162 19 0 3835 0 0 0 A Aurora city Iowa 161 162 19 0 3970 0 0 0 A Avoca city Iowa 1521 162 19 0 4105 0 0 0 A Ayrshire city Iowa 134 162 19 0 4195 0 0 0 A Badger city Iowa 532 162 19 0 4240 0 0 0 A Bagley city Iowa 286 162 19 0 4330 0 0 0 A Baldwin city Iowa 108 162 19 0 4375 0 0 0 A Balltown city Iowa 69 162 19 0 4420 0 0 0 A Bancroft city Iowa 696 162 19 0 4510 0 0 0 A Bankston city Iowa 27 162 19 0 4555 0 0 0 A Barnes City city Iowa 169 162 19 0 4645 0 0 0 A Barnum city Iowa 181 162 19 0 4780 0 0 0 A Bassett city Iowa 63 162 19 0 4825 0 0 0 A Batavia city Iowa 549 162 19 0 4870 0 0 0 A Battle Creek city Iowa 693 162 19 0 4915 0 0 0 A Baxter city Iowa 1132 162 19 0 4960 0 0 0 A Bayard city Iowa 451 162 19 0 5050 0 0 0 A Beacon city Iowa 487 162 19 0 5095 0 0 0 A Beaconsfield city Iowa 14 162 19 0 5140 0 0 0 A Beaman city Iowa 183 162 19 0 5185 0 0 0 A Beaver city Iowa 50 162 19 0 5365 0 0 0 A Bedford city Iowa 1384 162 19 0 5590 0 0 0 A Belle Plaine city Iowa 2440 162 19 0 5635 0 0 0 A Bellevue city Iowa 2209 162 19 0 5680 0 0 0 A Belmond city Iowa 2263 162 19 0 5770 0 0 0 A Bennett city Iowa 378 162 19 0 5905 0 0 0 A Benton city Iowa 41 162 19 0 6040 0 0 0 A Berkley city Iowa 33 162 19 0 6085 0 0 0 A Bernard city Iowa 118 162 19 0 6175 0 0 0 A Bertram city Iowa 290 162 19 0 6355 0 0 0 A Bettendorf city Iowa 36543 162 19 0 6490 0 0 0 A Bevington city Iowa 69 162 19 0 6625 0 0 0 A Birmingham city Iowa 421 162 19 0 6760 0 0 0 A Blairsburg city Iowa 200 162 19 0 6805 0 0 0 A Blairstown city Iowa 659 162 19 0 6850 0 0 0 A Blakesburg city Iowa 285 162 19 0 6895 0 0 0 A Blanchard city Iowa 36 162 19 0 6940 0 0 0 A Blencoe city Iowa 197 162 19 0 6985 0 0 0 A Blockton city Iowa 185 162 19 0 7030 0 0 0 A Bloomfield city Iowa 2679 162 19 0 7075 0 0 0 A Blue Grass city Iowa 1661 162 19 0 7210 0 0 0 A Bode city Iowa 290 162 19 0 7345 0 0 0 A Bonaparte city Iowa 403 162 19 0 7390 0 0 0 A Bondurant city Iowa 6958 162 19 0 7480 0 0 0 A Boone city Iowa 12384 162 19 0 7660 0 0 0 A Bouton city Iowa 122 162 19 0 7750 0 0 0 A Boxholm city Iowa 186 162 19 0 7840 0 0 0 A Boyden city Iowa 679 162 19 0 7930 0 0 0 A Braddyville city Iowa 152 162 19 0 8065 0 0 0 A Bradgate city Iowa 83 162 19 0 8155 0 0 0 A Brandon city Iowa 320 162 19 0 8200 0 0 0 A Brayton city Iowa 110 162 19 0 8290 0 0 0 A Breda city Iowa 476 162 19 0 8425 0 0 0 A Bridgewater city Iowa 151 162 19 0 8470 0 0 0 A Brighton city Iowa 640 162 19 0 8560 0 0 0 A Bristow city Iowa 149 162 19 0 8605 0 0 0 A Britt city Iowa 1955 162 19 0 8650 0 0 0 A Bronson city Iowa 320 162 19 0 8695 0 0 0 A Brooklyn city Iowa 1400 162 19 0 8875 0 0 0 A Brunsville city Iowa 153 162 19 0 9100 0 0 0 A Buckeye city Iowa 108 162 19 0 9145 0 0 0 A Buck Grove city Iowa 41 162 19 0 9235 0 0 0 A Buffalo city Iowa 1272 162 19 0 9280 0 0 0 A Buffalo Center city Iowa 855 162 19 0 9550 0 0 0 A Burlington city Iowa 24713 162 19 0 9685 0 0 0 A Burt city Iowa 498 162 19 0 9730 0 0 0 A Bussey city Iowa 413 162 19 0 9820 0 0 0 A Calamus city Iowa 401 162 19 0 9955 0 0 0 A Callender city Iowa 346 162 19 0 10045 0 0 0 A Calmar city Iowa 917 162 19 0 10090 0 0 0 A Calumet city Iowa 157 162 19 0 10135 0 0 0 A Camanche city Iowa 4365 162 19 0 10225 0 0 0 A Cambridge city Iowa 796 162 19 0 10450 0 0 0 A Cantril city Iowa 207 162 19 0 10585 0 0 0 A Carbon city Iowa 30 162 19 0 10765 0 0 0 A Carlisle city Iowa 4294 162 19 0 11035 0 0 0 A Carpenter city Iowa 106 162 19 0 11080 0 0 0 A Carroll city Iowa 9833 162 19 0 11170 0 0 0 A Carson city Iowa 809 162 19 0 11215 0 0 0 A Carter Lake city Iowa 3785 162 19 0 11305 0 0 0 A Cascade city Iowa 2329 162 19 0 11395 0 0 0 A Casey city Iowa 401 162 19 0 11485 0 0 0 A Castalia city Iowa 158 162 19 0 11530 0 0 0 A Castana city Iowa 133 162 19 0 11755 0 0 0 A Cedar Falls city Iowa 40536 162 19 0 12000 0 0 0 A Cedar Rapids city Iowa 133562 162 19 0 12270 0 0 0 A Center Point city Iowa 2555 162 19 0 12315 0 0 0 A Centerville city Iowa 5445 162 19 0 12495 0 0 0 A Central City city Iowa 1296 162 19 0 12630 0 0 0 A Centralia city Iowa 128 162 19 0 12720 0 0 0 A Chariton city Iowa 4141 162 19 0 12765 0 0 0 A Charles City city Iowa 7307 162 19 0 12855 0 0 0 A Charlotte city Iowa 361 162 19 0 12900 0 0 0 A Charter Oak city Iowa 478 162 19 0 12945 0 0 0 A Chatsworth city Iowa 81 162 19 0 12990 0 0 0 A Chelsea city Iowa 249 162 19 0 13080 0 0 0 A Cherokee city Iowa 4869 162 19 0 13125 0 0 0 A Chester city Iowa 120 162 19 0 13215 0 0 0 A Chillicothe city Iowa 97 162 19 0 13350 0 0 0 A Churdan city Iowa 364 162 19 0 13395 0 0 0 A Cincinnati city Iowa 344 162 19 0 13485 0 0 0 A Clare city Iowa 135 162 19 0 13530 0 0 0 A Clarence city Iowa 975 162 19 0 13575 0 0 0 A Clarinda city Iowa 5366 162 19 0 13620 0 0 0 A Clarion city Iowa 2709 162 19 0 13755 0 0 0 A Clarksville city Iowa 1346 162 19 0 13845 0 0 0 A Clayton city Iowa 39 162 19 0 13980 0 0 0 A Clearfield city Iowa 343 162 19 0 14025 0 0 0 A Clear Lake city Iowa 7550 162 19 0 14115 0 0 0 A Cleghorn city Iowa 216 162 19 0 14160 0 0 0 A Clemons city Iowa 141 162 19 0 14250 0 0 0 A Clermont city Iowa 583 162 19 0 14430 0 0 0 A Clinton city Iowa 25093 162 19 0 14475 0 0 0 A Clio city Iowa 74 162 19 0 14520 0 0 0 A Clive city Iowa 17242 162 19 0 14655 0 0 0 A Clutier city Iowa 204 162 19 0 14880 0 0 0 A Coburg city Iowa 39 162 19 0 14925 0 0 0 A Coggon city Iowa 667 162 19 0 14970 0 0 0 A Coin city Iowa 174 162 19 0 15015 0 0 0 A Colesburg city Iowa 377 162 19 0 15060 0 0 0 A Colfax city Iowa 2064 162 19 0 15105 0 0 0 A College Springs city Iowa 203 162 19 0 15195 0 0 0 A Collins city Iowa 467 162 19 0 15240 0 0 0 A Colo city Iowa 820 162 19 0 15375 0 0 0 A Columbus City city Iowa 372 162 19 0 15420 0 0 0 A Columbus Junction city Iowa 1837 162 19 0 15465 0 0 0 A Colwell city Iowa 70 162 19 0 15645 0 0 0 A Conesville city Iowa 427 162 19 0 15825 0 0 0 A Conrad city Iowa 1077 162 19 0 15960 0 0 0 A Conway city Iowa 40 162 19 0 16050 0 0 0 A Coon Rapids city Iowa 1232 162 19 0 16140 0 0 0 A Coppock city Iowa 48 162 19 0 16230 0 0 0 A Coralville city Iowa 22290 162 19 0 16500 0 0 0 A Corning city Iowa 1433 162 19 0 16545 0 0 0 A Correctionville city Iowa 806 162 19 0 16590 0 0 0 A Corwith city Iowa 254 162 19 0 16635 0 0 0 A Corydon city Iowa 1600 162 19 0 16725 0 0 0 A Cotter city Iowa 46 162 19 0 16815 0 0 0 A Coulter city Iowa 263 162 19 0 16860 0 0 0 A Council Bluffs city Iowa 62166 162 19 0 16950 0 0 0 A Craig city Iowa 92 162 19 0 17130 0 0 0 A Crawfordsville city Iowa 265 162 19 0 17175 0 0 0 A Crescent city Iowa 616 162 19 0 17220 0 0 0 A Cresco city Iowa 3739 162 19 0 17265 0 0 0 A Creston city Iowa 7713 162 19 0 17490 0 0 0 A Cromwell city Iowa 108 162 19 0 17670 0 0 0 A Crystal Lake city Iowa 232 162 19 0 17760 0 0 0 A Cumberland city Iowa 247 162 19 0 17850 0 0 0 A Cumming city Iowa 405 162 19 0 17895 0 0 0 A Curlew city Iowa 55 162 19 0 17940 0 0 0 A Cushing city Iowa 217 162 19 0 17985 0 0 0 A Cylinder city Iowa 82 162 19 0 18075 0 0 0 A Dakota City city Iowa 825 162 19 0 18255 0 0 0 A Dallas Center city Iowa 1776 162 19 0 18345 0 0 0 A Dana city Iowa 68 162 19 0 18390 0 0 0 A Danbury city Iowa 340 162 19 0 18435 0 0 0 A Danville city Iowa 899 162 19 0 19000 0 0 0 A Davenport city Iowa 101590 162 19 0 19090 0 0 0 A Davis City city Iowa 184 162 19 0 19135 0 0 0 A Dawson city Iowa 126 162 19 0 19180 0 0 0 A Dayton city Iowa 775 162 19 0 19360 0 0 0 A Decatur City city Iowa 184 162 19 0 19405 0 0 0 A Decorah city Iowa 7576 162 19 0 19450 0 0 0 A Dedham city Iowa 256 162 19 0 19495 0 0 0 A Deep River city Iowa 270 162 19 0 19585 0 0 0 A Defiance city Iowa 263 162 19 0 19630 0 0 0 A Delaware city Iowa 151 162 19 0 19675 0 0 0 A Delhi city Iowa 469 162 19 0 19720 0 0 0 A Delmar city Iowa 483 162 19 0 19765 0 0 0 A Deloit city Iowa 255 162 19 0 19810 0 0 0 A Delphos city Iowa 24 162 19 0 19855 0 0 0 A Delta city Iowa 318 162 19 0 19945 0 0 0 A Denison city Iowa 8244 162 19 0 20035 0 0 0 A Denver city Iowa 1856 162 19 0 20125 0 0 0 A Derby city Iowa 112 162 19 0 21000 0 0 0 A Des Moines city Iowa 214237 162 19 0 21045 0 0 0 A De Soto city Iowa 1025 162 19 0 21180 0 0 0 A DeWitt city Iowa 5192 162 19 0 21225 0 0 0 A Dexter city Iowa 585 162 19 0 21270 0 0 0 A Diagonal city Iowa 317 162 19 0 21360 0 0 0 A Dickens city Iowa 171 162 19 0 21405 0 0 0 A Dike city Iowa 1272 162 19 0 21540 0 0 0 A Dixon city Iowa 251 162 19 0 21675 0 0 0 A Dolliver city Iowa 59 162 19 0 21720 0 0 0 A Donahue city Iowa 368 162 19 0 21810 0 0 0 A Donnellson city Iowa 854 162 19 0 21900 0 0 0 A Doon city Iowa 601 162 19 0 22080 0 0 0 A Dougherty city Iowa 57 162 19 0 22215 0 0 0 A Dow City city Iowa 497 162 19 0 22305 0 0 0 A Dows city Iowa 504 162 19 0 22350 0 0 0 A Drakesville city Iowa 190 162 19 0 22395 0 0 0 A Dubuque city Iowa 57882 162 19 0 22620 0 0 0 A Dumont city Iowa 602 162 19 0 22755 0 0 0 A Duncombe city Iowa 383 162 19 0 22800 0 0 0 A Dundee city Iowa 163 162 19 0 22845 0 0 0 A Dunkerton city Iowa 849 162 19 0 22890 0 0 0 A Dunlap city Iowa 973 162 19 0 22935 0 0 0 A Durango city Iowa 19 162 19 0 22980 0 0 0 A Durant city Iowa 1864 162 19 0 23115 0 0 0 A Dyersville city Iowa 4329 162 19 0 23160 0 0 0 A Dysart city Iowa 1313 162 19 0 23250 0 0 0 A Eagle Grove city Iowa 3406 162 19 0 23340 0 0 0 A Earlham city Iowa 1410 162 19 0 23385 0 0 0 A Earling city Iowa 409 162 19 0 23430 0 0 0 A Earlville city Iowa 772 162 19 0 23475 0 0 0 A Early city Iowa 515 162 19 0 23790 0 0 0 A East Peru city Iowa 131 162 19 0 23970 0 0 0 A Eddyville city Iowa 1008 162 19 0 24060 0 0 0 A Edgewood city Iowa 861 162 19 0 24375 0 0 0 A Elberon city Iowa 188 162 19 0 24420 0 0 0 A Eldon city Iowa 915 162 19 0 24465 0 0 0 A Eldora city Iowa 2612 162 19 0 24600 0 0 0 A Eldridge city Iowa 6846 162 19 0 24645 0 0 0 A Elgin city Iowa 634 162 19 0 24690 0 0 0 A Elkader city Iowa 1217 162 19 0 24735 0 0 0 A Elkhart city Iowa 918 162 19 0 24780 0 0 0 A Elk Horn city Iowa 610 162 19 0 24825 0 0 0 A Elkport city Iowa 36 162 19 0 24870 0 0 0 A Elk Run Heights city Iowa 1144 162 19 0 24915 0 0 0 A Elliott city Iowa 318 162 19 0 25005 0 0 0 A Ellston city Iowa 39 162 19 0 25050 0 0 0 A Ellsworth city Iowa 489 162 19 0 25095 0 0 0 A Elma city Iowa 527 162 19 0 25365 0 0 0 A Ely city Iowa 2343 162 19 0 25500 0 0 0 A Emerson city Iowa 449 162 19 0 25590 0 0 0 A Emmetsburg city Iowa 3684 162 19 0 25725 0 0 0 A Epworth city Iowa 1978 162 19 0 25815 0 0 0 A Essex city Iowa 739 162 19 0 25860 0 0 0 A Estherville city Iowa 5666 162 19 0 25995 0 0 0 A Evansdale city Iowa 4743 162 19 0 26175 0 0 0 A Everly city Iowa 550 162 19 0 26265 0 0 0 A Exira city Iowa 769 162 19 0 26310 0 0 0 A Exline city Iowa 154 162 19 0 26355 0 0 0 A Fairbank city Iowa 1133 162 19 0 26400 0 0 0 A Fairfax city Iowa 2856 162 19 0 26445 0 0 0 A Fairfield city Iowa 10425 162 19 0 26760 0 0 0 A Farley city Iowa 1750 162 19 0 26850 0 0 0 A Farmersburg city Iowa 268 162 19 0 26895 0 0 0 A Farmington city Iowa 622 162 19 0 26940 0 0 0 A Farnhamville city Iowa 344 162 19 0 26985 0 0 0 A Farragut city Iowa 446 162 19 0 27165 0 0 0 A Fayette city Iowa 1441 162 19 0 27210 0 0 0 A Fenton city Iowa 233 162 19 0 27255 0 0 0 A Ferguson city Iowa 122 162 19 0 27390 0 0 0 A Fertile city Iowa 360 162 19 0 27975 0 0 0 A Floris city Iowa 143 162 19 0 28020 0 0 0 A Floyd city Iowa 315 162 19 0 28245 0 0 0 A Fonda city Iowa 575 162 19 0 28290 0 0 0 A Fontanelle city Iowa 622 162 19 0 28380 0 0 0 A Forest City city Iowa 4025 162 19 0 28425 0 0 0 A Fort Atkinson city Iowa 320 162 19 0 28515 0 0 0 A Fort Dodge city Iowa 23888 162 19 0 28605 0 0 0 A Fort Madison city Iowa 10321 162 19 0 28650 0 0 0 A Fostoria city Iowa 223 162 19 0 28740 0 0 0 A Franklin city Iowa 132 162 19 0 28920 0 0 0 A Fraser city Iowa 103 162 19 0 28965 0 0 0 A Fredericksburg city Iowa 923 162 19 0 29010 0 0 0 A Frederika city Iowa 203 162 19 0 29055 0 0 0 A Fredonia city Iowa 235 162 19 0 29190 0 0 0 A Fremont city Iowa 721 162 19 0 29280 0 0 0 A Fruitland city Iowa 982 162 19 0 29550 0 0 0 A Galt city Iowa 31 162 19 0 29595 0 0 0 A Galva city Iowa 419 162 19 0 29685 0 0 0 A Garber city Iowa 85 162 19 0 29775 0 0 0 A Garden Grove city Iowa 197 162 19 0 29910 0 0 0 A Garnavillo city Iowa 724 162 19 0 29955 0 0 0 A Garner city Iowa 3033 162 19 0 30000 0 0 0 A Garrison city Iowa 360 162 19 0 30045 0 0 0 A Garwin city Iowa 493 162 19 0 30135 0 0 0 A Geneva city Iowa 153 162 19 0 30225 0 0 0 A George city Iowa 1042 162 19 0 30540 0 0 0 A Gibson city Iowa 60 162 19 0 30630 0 0 0 A Gilbert city Iowa 1147 162 19 0 30675 0 0 0 A Gilbertville city Iowa 728 162 19 0 30810 0 0 0 A Gillett Grove city Iowa 47 162 19 0 30900 0 0 0 A Gilman city Iowa 484 162 19 0 30945 0 0 0 A Gilmore City city Iowa 469 162 19 0 31035 0 0 0 A Gladbrook city Iowa 858 162 19 0 31350 0 0 0 A Glenwood city Iowa 5389 162 19 0 31395 0 0 0 A Glidden city Iowa 1106 162 19 0 31530 0 0 0 A Goldfield city Iowa 593 162 19 0 31575 0 0 0 A Goodell city Iowa 128 162 19 0 31665 0 0 0 A Goose Lake city Iowa 220 162 19 0 31710 0 0 0 A Gowrie city Iowa 953 162 19 0 31800 0 0 0 A Graettinger city Iowa 795 162 19 0 31845 0 0 0 A Graf city Iowa 81 162 19 0 31890 0 0 0 A Grafton city Iowa 244 162 19 0 31980 0 0 0 A Grand Junction city Iowa 773 162 19 0 32025 0 0 0 A Grand Mound city Iowa 593 162 19 0 32070 0 0 0 A Grand River city Iowa 215 162 19 0 32115 0 0 0 A Grandview city Iowa 526 162 19 0 32160 0 0 0 A Granger city Iowa 1508 162 19 0 32295 0 0 0 A Grant city Iowa 83 162 19 0 32475 0 0 0 A Granville city Iowa 304 162 19 0 32520 0 0 0 A Gravity city Iowa 181 162 19 0 32565 0 0 0 A Gray city Iowa 57 162 19 0 32610 0 0 0 A Greeley city Iowa 242 162 19 0 32745 0 0 0 A Greene city Iowa 1063 162 19 0 32790 0 0 0 A Greenfield city Iowa 1838 162 19 0 32970 0 0 0 A Greenville city Iowa 68 162 19 0 33060 0 0 0 A Grimes city Iowa 14804 162 19 0 33105 0 0 0 A Grinnell city Iowa 9116 162 19 0 33150 0 0 0 A Griswold city Iowa 944 162 19 0 33195 0 0 0 A Grundy Center city Iowa 2670 162 19 0 33240 0 0 0 A Gruver city Iowa 83 162 19 0 33285 0 0 0 A Guernsey city Iowa 60 162 19 0 33420 0 0 0 A Guthrie Center city Iowa 1494 162 19 0 33465 0 0 0 A Guttenberg city Iowa 1804 162 19 0 33645 0 0 0 A Halbur city Iowa 256 162 19 0 33780 0 0 0 A Hamburg city Iowa 1060 162 19 0 33870 0 0 0 A Hamilton city Iowa 134 162 19 0 33960 0 0 0 A Hampton city Iowa 4205 162 19 0 34005 0 0 0 A Hancock city Iowa 196 162 19 0 34185 0 0 0 A Hanlontown city Iowa 220 162 19 0 34365 0 0 0 A Hansell city Iowa 90 162 19 0 34410 0 0 0 A Harcourt city Iowa 278 162 19 0 34455 0 0 0 A Hardy city Iowa 42 162 19 0 34500 0 0 0 A Harlan city Iowa 4766 162 19 0 34545 0 0 0 A Harper city Iowa 110 162 19 0 34590 0 0 0 A Harpers Ferry city Iowa 323 162 19 0 34635 0 0 0 A Harris city Iowa 157 162 19 0 34680 0 0 0 A Hartford city Iowa 777 162 19 0 34725 0 0 0 A Hartley city Iowa 1574 162 19 0 34770 0 0 0 A Hartwick city Iowa 80 162 19 0 34860 0 0 0 A Harvey city Iowa 244 162 19 0 34995 0 0 0 A Hastings city Iowa 152 162 19 0 35130 0 0 0 A Havelock city Iowa 124 162 19 0 35220 0 0 0 A Haverhill city Iowa 167 162 19 0 35265 0 0 0 A Hawarden city Iowa 2444 162 19 0 35310 0 0 0 A Hawkeye city Iowa 408 162 19 0 35445 0 0 0 A Hayesville city Iowa 49 162 19 0 35580 0 0 0 A Hazleton city Iowa 833 162 19 0 35670 0 0 0 A Hedrick city Iowa 754 162 19 0 35715 0 0 0 A Henderson city Iowa 185 162 19 0 35760 0 0 0 A Hepburn city Iowa 17 162 19 0 35940 0 0 0 A Hiawatha city Iowa 7420 162 19 0 36345 0 0 0 A Hills city Iowa 804 162 19 0 36390 0 0 0 A Hillsboro city Iowa 177 162 19 0 36480 0 0 0 A Hinton city Iowa 948 162 19 0 36705 0 0 0 A Holland city Iowa 277 162 19 0 36840 0 0 0 A Holstein city Iowa 1370 162 19 0 36885 0 0 0 A Holy Cross city Iowa 368 162 19 0 37155 0 0 0 A Hopkinton city Iowa 597 162 19 0 37200 0 0 0 A Hornick city Iowa 218 162 19 0 37290 0 0 0 A Hospers city Iowa 696 162 19 0 37335 0 0 0 A Houghton city Iowa 136 162 19 0 37425 0 0 0 A Hubbard city Iowa 801 162 19 0 37470 0 0 0 A Hudson city Iowa 2468 162 19 0 37515 0 0 0 A Hull city Iowa 2299 162 19 0 37560 0 0 0 A Humboldt city Iowa 4587 162 19 0 37605 0 0 0 A Humeston city Iowa 484 162 19 0 37920 0 0 0 A Huxley city Iowa 4036 162 19 0 38010 0 0 0 A Ida Grove city Iowa 2052 162 19 0 38055 0 0 0 A Imogene city Iowa 70 162 19 0 38100 0 0 0 A Independence city Iowa 6124 162 19 0 38280 0 0 0 A Indianola city Iowa 16015 162 19 0 38415 0 0 0 A Inwood city Iowa 849 162 19 0 38460 0 0 0 A Ionia city Iowa 275 162 19 0 38595 0 0 0 A Iowa City city Iowa 75130 162 19 0 38640 0 0 0 A Iowa Falls city Iowa 5059 162 19 0 38820 0 0 0 A Ireton city Iowa 599 162 19 0 39000 0 0 0 A Irwin city Iowa 311 162 19 0 39135 0 0 0 A Jackson Junction city Iowa 54 162 19 0 39225 0 0 0 A Jamaica city Iowa 218 162 19 0 39405 0 0 0 A Janesville city Iowa 986 162 19 0 39450 0 0 0 A Jefferson city Iowa 4102 162 19 0 39585 0 0 0 A Jesup city Iowa 2703 162 19 0 39675 0 0 0 A Jewell Junction city Iowa 1139 162 19 0 39765 0 0 0 A Johnston city Iowa 22582 162 19 0 39855 0 0 0 A Joice city Iowa 210 162 19 0 39900 0 0 0 A Jolley city Iowa 37 162 19 0 40170 0 0 0 A Kalona city Iowa 2537 162 19 0 40215 0 0 0 A Kamrar city Iowa 190 162 19 0 40260 0 0 0 A Kanawha city Iowa 595 162 19 0 40350 0 0 0 A Kellerton city Iowa 297 162 19 0 40395 0 0 0 A Kelley city Iowa 300 162 19 0 40440 0 0 0 A Kellogg city Iowa 588 162 19 0 40665 0 0 0 A Kensett city Iowa 256 162 19 0 40845 0 0 0 A Keokuk city Iowa 10157 162 19 0 40890 0 0 0 A Keomah Village city Iowa 97 162 19 0 40935 0 0 0 A Keosauqua city Iowa 908 162 19 0 40980 0 0 0 A Keota city Iowa 971 162 19 0 41070 0 0 0 A Keswick city Iowa 241 162 19 0 41115 0 0 0 A Keystone city Iowa 612 162 19 0 41295 0 0 0 A Kimballton city Iowa 280 162 19 0 41385 0 0 0 A Kingsley city Iowa 1402 162 19 0 41475 0 0 0 A Kinross city Iowa 72 162 19 0 41520 0 0 0 A Kirkman city Iowa 61 162 19 0 41565 0 0 0 A Kirkville city Iowa 175 162 19 0 41610 0 0 0 A Kiron city Iowa 266 162 19 0 41655 0 0 0 A Klemme city Iowa 463 162 19 0 41790 0 0 0 A Knierim city Iowa 58 162 19 0 42015 0 0 0 A Knoxville city Iowa 7168 162 19 0 42285 0 0 0 A Lacona city Iowa 352 162 19 0 42330 0 0 0 A Ladora city Iowa 274 162 19 0 42465 0 0 0 A Lake City city Iowa 1642 162 19 0 42555 0 0 0 A Lake Mills city Iowa 1984 162 19 0 42600 0 0 0 A Lake Park city Iowa 1123 162 19 0 42645 0 0 0 A Lakeside city Iowa 689 162 19 0 42690 0 0 0 A Lake View city Iowa 1084 162 19 0 42825 0 0 0 A Lakota city Iowa 279 162 19 0 42870 0 0 0 A Lambs Grove city Iowa 169 162 19 0 42960 0 0 0 A Lamoni city Iowa 2249 162 19 0 43005 0 0 0 A Lamont city Iowa 457 162 19 0 43050 0 0 0 A La Motte city Iowa 254 162 19 0 43140 0 0 0 A Lanesboro city Iowa 109 162 19 0 43275 0 0 0 A Lansing city Iowa 935 162 19 0 43365 0 0 0 A La Porte City city Iowa 2240 162 19 0 43410 0 0 0 A Larchwood city Iowa 891 162 19 0 43500 0 0 0 A Larrabee city Iowa 131 162 19 0 43590 0 0 0 A Latimer city Iowa 470 162 19 0 43680 0 0 0 A Laurel city Iowa 231 162 19 0 43725 0 0 0 A Laurens city Iowa 1120 162 19 0 43815 0 0 0 A Lawler city Iowa 419 162 19 0 43905 0 0 0 A Lawton city Iowa 980 162 19 0 44085 0 0 0 A Le Claire city Iowa 3965 162 19 0 44130 0 0 0 A Ledyard city Iowa 120 162 19 0 44220 0 0 0 A Le Grand city Iowa 914 162 19 0 44265 0 0 0 A Lehigh city Iowa 392 162 19 0 44310 0 0 0 A Leighton city Iowa 158 162 19 0 44355 0 0 0 A Leland city Iowa 271 162 19 0 44400 0 0 0 A Le Mars city Iowa 10081 162 19 0 44490 0 0 0 A Lenox city Iowa 1389 162 19 0 44535 0 0 0 A Leon city Iowa 1823 162 19 0 44580 0 0 0 A Le Roy city Iowa 14 162 19 0 44670 0 0 0 A Lester city Iowa 302 162 19 0 44715 0 0 0 A Letts city Iowa 373 162 19 0 44805 0 0 0 A Lewis city Iowa 399 162 19 0 44985 0 0 0 A Libertyville city Iowa 341 162 19 0 45030 0 0 0 A Lidderdale city Iowa 171 162 19 0 45165 0 0 0 A Lime Springs city Iowa 474 162 19 0 45255 0 0 0 A Lincoln city Iowa 148 162 19 0 45390 0 0 0 A Linden city Iowa 208 162 19 0 45435 0 0 0 A Lineville city Iowa 220 162 19 0 45480 0 0 0 A Linn Grove city Iowa 146 162 19 0 45615 0 0 0 A Lisbon city Iowa 2247 162 19 0 45660 0 0 0 A Liscomb city Iowa 293 162 19 0 45795 0 0 0 A Little Rock city Iowa 433 162 19 0 45840 0 0 0 A Little Sioux city Iowa 161 162 19 0 45975 0 0 0 A Livermore city Iowa 362 162 19 0 46065 0 0 0 A Lockridge city Iowa 290 162 19 0 46155 0 0 0 A Logan city Iowa 1418 162 19 0 46245 0 0 0 A Lohrville city Iowa 345 162 19 0 46290 0 0 0 A Lone Rock city Iowa 139 162 19 0 46335 0 0 0 A Lone Tree city Iowa 1381 162 19 0 46425 0 0 0 A Long Grove city Iowa 872 162 19 0 46515 0 0 0 A Lorimor city Iowa 343 162 19 0 46605 0 0 0 A Lost Nation city Iowa 406 162 19 0 46830 0 0 0 A Lovilia city Iowa 509 162 19 0 46920 0 0 0 A Lowden city Iowa 773 162 19 0 47010 0 0 0 A Low Moor city Iowa 247 162 19 0 47055 0 0 0 A Luana city Iowa 279 162 19 0 47100 0 0 0 A Lucas city Iowa 209 162 19 0 47280 0 0 0 A Luther city Iowa 133 162 19 0 47370 0 0 0 A Lu Verne city Iowa 249 162 19 0 47460 0 0 0 A Luxemburg city Iowa 247 162 19 0 47505 0 0 0 A Luzerne city Iowa 93 162 19 0 47595 0 0 0 A Lynnville city Iowa 393 162 19 0 47730 0 0 0 A Lytton city Iowa 289 162 19 0 47775 0 0 0 A McCallsburg city Iowa 320 162 19 0 47820 0 0 0 A McCausland city Iowa 311 162 19 0 47865 0 0 0 A McClelland city Iowa 155 162 19 0 47955 0 0 0 A Macedonia city Iowa 243 162 19 0 48000 0 0 0 A McGregor city Iowa 838 162 19 0 48045 0 0 0 A McIntire city Iowa 125 162 19 0 48180 0 0 0 A Macksburg city Iowa 118 162 19 0 48450 0 0 0 A Madrid city Iowa 2549 162 19 0 48495 0 0 0 A Magnolia city Iowa 176 162 19 0 48500 0 0 0 A Maharishi Vedic City city Iowa 1295 162 19 0 48540 0 0 0 A Malcom city Iowa 272 162 19 0 48585 0 0 0 A Mallard city Iowa 258 162 19 0 48675 0 0 0 A Maloy city Iowa 28 162 19 0 48720 0 0 0 A Malvern city Iowa 1115 162 19 0 48810 0 0 0 A Manchester city Iowa 4986 162 19 0 48855 0 0 0 A Manilla city Iowa 746 162 19 0 48900 0 0 0 A Manly city Iowa 1278 162 19 0 48945 0 0 0 A Manning city Iowa 1422 162 19 0 48990 0 0 0 A Manson city Iowa 1566 162 19 0 49170 0 0 0 A Mapleton city Iowa 1157 162 19 0 49215 0 0 0 A Maquoketa city Iowa 5990 162 19 0 49260 0 0 0 A Marathon city Iowa 227 162 19 0 49305 0 0 0 A Marble Rock city Iowa 287 162 19 0 49350 0 0 0 A Marcus city Iowa 1054 162 19 0 49395 0 0 0 A Marengo city Iowa 2466 162 19 0 49485 0 0 0 A Marion city Iowa 40359 162 19 0 49575 0 0 0 A Marne city Iowa 112 162 19 0 49620 0 0 0 A Marquette city Iowa 433 162 19 0 49755 0 0 0 A Marshalltown city Iowa 26666 162 19 0 49845 0 0 0 A Martelle city Iowa 250 162 19 0 49890 0 0 0 A Martensdale city Iowa 461 162 19 0 49935 0 0 0 A Martinsburg city Iowa 109 162 19 0 50070 0 0 0 A Marysville city Iowa 69 162 19 0 50160 0 0 0 A Mason City city Iowa 26931 162 19 0 50205 0 0 0 A Masonville city Iowa 120 162 19 0 50250 0 0 0 A Massena city Iowa 336 162 19 0 50385 0 0 0 A Matlock city Iowa 87 162 19 0 50430 0 0 0 A Maurice city Iowa 271 162 19 0 50520 0 0 0 A Maxwell city Iowa 903 162 19 0 50610 0 0 0 A Maynard city Iowa 488 162 19 0 50655 0 0 0 A Maysville city Iowa 185 162 19 0 50700 0 0 0 A Mechanicsville city Iowa 1129 162 19 0 50790 0 0 0 A Mediapolis city Iowa 1517 162 19 0 50880 0 0 0 A Melbourne city Iowa 794 162 19 0 50935 0 0 0 A Melcher-Dallas city Iowa 1244 162 19 0 50970 0 0 0 A Melrose city Iowa 104 162 19 0 51060 0 0 0 A Melvin city Iowa 198 162 19 0 51105 0 0 0 A Menlo city Iowa 347 162 19 0 51150 0 0 0 A Meriden city Iowa 148 162 19 0 51375 0 0 0 A Merrill city Iowa 731 162 19 0 51420 0 0 0 A Meservey city Iowa 238 162 19 0 51735 0 0 0 A Middletown city Iowa 335 162 19 0 52050 0 0 0 A Miles city Iowa 437 162 19 0 52095 0 0 0 A Milford city Iowa 2997 162 19 0 52230 0 0 0 A Millersburg city Iowa 142 162 19 0 52275 0 0 0 A Millerton city Iowa 42 162 19 0 52455 0 0 0 A Milo city Iowa 761 162 19 0 52500 0 0 0 A Milton city Iowa 398 162 19 0 52545 0 0 0 A Minburn city Iowa 352 162 19 0 52590 0 0 0 A Minden city Iowa 598 162 19 0 52815 0 0 0 A Mingo city Iowa 309 162 19 0 52860 0 0 0 A Missouri Valley city Iowa 2615 162 19 0 52905 0 0 0 A Mitchell city Iowa 130 162 19 0 52950 0 0 0 A Mitchellville city Iowa 2258 162 19 0 52995 0 0 0 A Modale city Iowa 264 162 19 0 53175 0 0 0 A Mondamin city Iowa 374 162 19 0 53265 0 0 0 A Monmouth city Iowa 154 162 19 0 53310 0 0 0 A Monona city Iowa 1471 162 19 0 53355 0 0 0 A Monroe city Iowa 1894 162 19 0 53490 0 0 0 A Montezuma city Iowa 1412 162 19 0 53625 0 0 0 A Monticello city Iowa 3880 162 19 0 53670 0 0 0 A Montour city Iowa 243 162 19 0 53760 0 0 0 A Montrose city Iowa 778 162 19 0 53850 0 0 0 A Moorhead city Iowa 204 162 19 0 53895 0 0 0 A Moorland city Iowa 156 162 19 0 53985 0 0 0 A Moravia city Iowa 636 162 19 0 54030 0 0 0 A Morley city Iowa 113 162 19 0 54120 0 0 0 A Morning Sun city Iowa 796 162 19 0 54165 0 0 0 A Morrison city Iowa 91 162 19 0 54390 0 0 0 A Moulton city Iowa 578 162 19 0 54435 0 0 0 A Mount Auburn city Iowa 144 162 19 0 54480 0 0 0 A Mount Ayr city Iowa 1619 162 19 0 54705 0 0 0 A Mount Pleasant city Iowa 8668 162 19 0 54840 0 0 0 A Mount Vernon city Iowa 4466 162 19 0 54930 0 0 0 A Moville city Iowa 1635 162 19 0 55065 0 0 0 A Murray city Iowa 702 162 19 0 55110 0 0 0 A Muscatine city Iowa 23631 162 19 0 55200 0 0 0 A Mystic city Iowa 409 162 19 0 55335 0 0 0 A Nashua city Iowa 1589 162 19 0 55515 0 0 0 A Nemaha city Iowa 81 162 19 0 55560 0 0 0 A Neola city Iowa 891 162 19 0 55695 0 0 0 A Nevada city Iowa 6677 162 19 0 55785 0 0 0 A New Albin city Iowa 499 162 19 0 55965 0 0 0 A Newell city Iowa 852 162 19 0 56055 0 0 0 A Newhall city Iowa 858 162 19 0 56100 0 0 0 A New Hampton city Iowa 3406 162 19 0 56145 0 0 0 A New Hartford city Iowa 488 162 19 0 56280 0 0 0 A New Liberty city Iowa 144 162 19 0 56325 0 0 0 A New London city Iowa 1839 162 19 0 56370 0 0 0 A New Market city Iowa 401 162 19 0 56415 0 0 0 A New Providence city Iowa 223 162 19 0 56460 0 0 0 A New Sharon city Iowa 1293 162 19 0 56505 0 0 0 A Newton city Iowa 15182 162 19 0 56550 0 0 0 A New Vienna city Iowa 411 162 19 0 56595 0 0 0 A New Virginia city Iowa 491 162 19 0 56685 0 0 0 A Nichols city Iowa 362 162 19 0 56865 0 0 0 A Nodaway city Iowa 103 162 19 0 56910 0 0 0 A Nora Springs city Iowa 1354 162 19 0 57045 0 0 0 A Northboro city Iowa 56 162 19 0 57135 0 0 0 A North Buena Vista city Iowa 121 162 19 0 57225 0 0 0 A North English city Iowa 1007 162 19 0 57360 0 0 0 A North Liberty city Iowa 19501 162 19 0 57495 0 0 0 A North Washington city Iowa 138 162 19 0 57630 0 0 0 A Northwood city Iowa 1955 162 19 0 57675 0 0 0 A Norwalk city Iowa 11938 162 19 0 57720 0 0 0 A Norway city Iowa 528 162 19 0 57945 0 0 0 A Numa city Iowa 89 162 19 0 58080 0 0 0 A Oakland city Iowa 1501 162 19 0 58170 0 0 0 A Oakland Acres city Iowa 159 162 19 0 58395 0 0 0 A Oakville city Iowa 169 162 19 0 58530 0 0 0 A Ocheyedan city Iowa 459 162 19 0 58575 0 0 0 A Odebolt city Iowa 943 162 19 0 58620 0 0 0 A Oelwein city Iowa 5900 162 19 0 58665 0 0 0 A Ogden city Iowa 1979 162 19 0 58710 0 0 0 A Okoboji city Iowa 792 162 19 0 58890 0 0 0 A Olds city Iowa 223 162 19 0 58980 0 0 0 A Olin city Iowa 687 162 19 0 59070 0 0 0 A Ollie city Iowa 210 162 19 0 59115 0 0 0 A Onawa city Iowa 2764 162 19 0 59250 0 0 0 A Onslow city Iowa 193 162 19 0 59475 0 0 0 A Orange City city Iowa 6182 162 19 0 59520 0 0 0 A Orchard city Iowa 71 162 19 0 59565 0 0 0 A Orient city Iowa 377 162 19 0 59655 0 0 0 A Orleans city Iowa 587 162 19 0 59745 0 0 0 A Osage city Iowa 3555 162 19 0 59835 0 0 0 A Osceola city Iowa 5242 162 19 0 59925 0 0 0 A Oskaloosa city Iowa 11506 162 19 0 59970 0 0 0 A Ossian city Iowa 778 162 19 0 60015 0 0 0 A Osterdock city Iowa 56 162 19 0 60105 0 0 0 A Otho city Iowa 507 162 19 0 60240 0 0 0 A Oto city Iowa 103 162 19 0 60420 0 0 0 A Ottosen city Iowa 37 162 19 0 60465 0 0 0 A Ottumwa city Iowa 24368 162 19 0 60555 0 0 0 A Owasa city Iowa 42 162 19 0 60645 0 0 0 A Oxford city Iowa 792 162 19 0 60690 0 0 0 A Oxford Junction city Iowa 483 162 19 0 60780 0 0 0 A Oyens city Iowa 102 162 19 0 60825 0 0 0 A Pacific Junction city Iowa 342 162 19 0 60915 0 0 0 A Packwood city Iowa 227 162 19 0 61050 0 0 0 A Palmer city Iowa 149 162 19 0 61230 0 0 0 A Palo city Iowa 1066 162 19 0 61275 0 0 0 A Panama city Iowa 208 162 19 0 61320 0 0 0 A Panora city Iowa 1067 162 19 0 61365 0 0 0 A Panorama Park city Iowa 319 162 19 0 61590 0 0 0 A Parkersburg city Iowa 1928 162 19 0 61770 0 0 0 A Parnell city Iowa 264 162 19 0 61815 0 0 0 A Paton city Iowa 230 162 19 0 61860 0 0 0 A Patterson city Iowa 161 162 19 0 61905 0 0 0 A Paullina city Iowa 977 162 19 0 62040 0 0 0 A Pella city Iowa 10237 162 19 0 62130 0 0 0 A Peosta city Iowa 1857 162 19 0 62355 0 0 0 A Perry city Iowa 7676 162 19 0 62445 0 0 0 A Persia city Iowa 287 162 19 0 62625 0 0 0 A Peterson city Iowa 309 162 19 0 62760 0 0 0 A Pierson city Iowa 354 162 19 0 62850 0 0 0 A Pilot Mound city Iowa 168 162 19 0 62985 0 0 0 A Pioneer city Iowa 22 162 19 0 63075 0 0 0 A Pisgah city Iowa 240 162 19 0 63210 0 0 0 A Plainfield city Iowa 414 162 19 0 63345 0 0 0 A Plano city Iowa 67 162 19 0 63525 0 0 0 A Pleasant Hill city Iowa 10019 162 19 0 63570 0 0 0 A Pleasanton city Iowa 44 162 19 0 63615 0 0 0 A Pleasant Plain city Iowa 98 162 19 0 63750 0 0 0 A Pleasantville city Iowa 1696 162 19 0 63840 0 0 0 A Plover city Iowa 69 162 19 0 63885 0 0 0 A Plymouth city Iowa 362 162 19 0 63975 0 0 0 A Pocahontas city Iowa 1634 162 19 0 64020 0 0 0 A Polk City city Iowa 4961 162 19 0 64065 0 0 0 A Pomeroy city Iowa 613 162 19 0 64110 0 0 0 A Popejoy city Iowa 75 162 19 0 64200 0 0 0 A Portsmouth city Iowa 178 162 19 0 64290 0 0 0 A Postville city Iowa 2053 162 19 0 64425 0 0 0 A Prairieburg city Iowa 188 162 19 0 64470 0 0 0 A Prairie City city Iowa 1718 162 19 0 64560 0 0 0 A Prescott city Iowa 237 162 19 0 64605 0 0 0 A Preston city Iowa 959 162 19 0 64650 0 0 0 A Primghar city Iowa 856 162 19 0 64740 0 0 0 A Princeton city Iowa 946 162 19 0 64875 0 0 0 A Promise City city Iowa 108 162 19 0 65010 0 0 0 A Protivin city Iowa 270 162 19 0 65055 0 0 0 A Pulaski city Iowa 289 162 19 0 65235 0 0 0 A Quasqueton city Iowa 564 162 19 0 65280 0 0 0 A Quimby city Iowa 292 162 19 0 65370 0 0 0 A Radcliffe city Iowa 524 162 19 0 65415 0 0 0 A Rake city Iowa 209 162 19 0 65505 0 0 0 A Ralston city Iowa 73 162 19 0 65550 0 0 0 A Randalia city Iowa 56 162 19 0 65595 0 0 0 A Randall city Iowa 163 162 19 0 65640 0 0 0 A Randolph city Iowa 155 162 19 0 65730 0 0 0 A Rathbun city Iowa 86 162 19 0 65820 0 0 0 A Raymond city Iowa 793 162 19 0 65910 0 0 0 A Readlyn city Iowa 846 162 19 0 65955 0 0 0 A Reasnor city Iowa 155 162 19 0 66000 0 0 0 A Redding city Iowa 78 162 19 0 66045 0 0 0 A Redfield city Iowa 816 162 19 0 66135 0 0 0 A Red Oak city Iowa 5276 162 19 0 66315 0 0 0 A Reinbeck city Iowa 1626 162 19 0 66360 0 0 0 A Rembrandt city Iowa 194 162 19 0 66405 0 0 0 A Remsen city Iowa 1617 162 19 0 66450 0 0 0 A Renwick city Iowa 262 162 19 0 66540 0 0 0 A Rhodes city Iowa 297 162 19 0 66585 0 0 0 A Riceville city Iowa 764 162 19 0 66720 0 0 0 A Richland city Iowa 574 162 19 0 66810 0 0 0 A Rickardsville city Iowa 176 162 19 0 66855 0 0 0 A Ricketts city Iowa 135 162 19 0 67035 0 0 0 A Ridgeway city Iowa 287 162 19 0 67125 0 0 0 A Rinard city Iowa 50 162 19 0 67170 0 0 0 A Ringsted city Iowa 370 162 19 0 67215 0 0 0 A Rippey city Iowa 273 162 19 0 67350 0 0 0 A Riverdale city Iowa 435 162 19 0 67440 0 0 0 A Riverside city Iowa 1022 162 19 0 67575 0 0 0 A Riverton city Iowa 279 162 19 0 67800 0 0 0 A Robins city Iowa 3537 162 19 0 68025 0 0 0 A Rock Falls city Iowa 143 162 19 0 68070 0 0 0 A Rockford city Iowa 822 162 19 0 68160 0 0 0 A Rock Rapids city Iowa 2522 162 19 0 68205 0 0 0 A Rock Valley city Iowa 3854 162 19 0 68250 0 0 0 A Rockwell city Iowa 990 162 19 0 68295 0 0 0 A Rockwell City city Iowa 2082 162 19 0 68340 0 0 0 A Rodman city Iowa 41 162 19 0 68385 0 0 0 A Rodney city Iowa 57 162 19 0 68475 0 0 0 A Roland city Iowa 1254 162 19 0 68520 0 0 0 A Rolfe city Iowa 532 162 19 0 68565 0 0 0 A Rome city Iowa 116 162 19 0 68700 0 0 0 A Rose Hill city Iowa 163 162 19 0 68925 0 0 0 A Rossie city Iowa 68 162 19 0 69015 0 0 0 A Rowan city Iowa 150 162 19 0 69060 0 0 0 A Rowley city Iowa 270 162 19 0 69105 0 0 0 A Royal city Iowa 409 162 19 0 69195 0 0 0 A Rudd city Iowa 346 162 19 0 69240 0 0 0 A Runnells city Iowa 504 162 19 0 69285 0 0 0 A Russell city Iowa 536 162 19 0 69330 0 0 0 A Ruthven city Iowa 682 162 19 0 69375 0 0 0 A Rutland city Iowa 122 162 19 0 69465 0 0 0 A Ryan city Iowa 346 162 19 0 69510 0 0 0 A Sabula city Iowa 554 162 19 0 69645 0 0 0 A Sac City city Iowa 2068 162 19 0 69690 0 0 0 A Sageville city Iowa 101 162 19 0 69735 0 0 0 A St. Ansgar city Iowa 1120 162 19 0 69780 0 0 0 A St. Anthony city Iowa 99 162 19 0 69915 0 0 0 A St. Charles city Iowa 619 162 19 0 69960 0 0 0 A St. Donatus city Iowa 129 162 19 0 70050 0 0 0 A St. Lucas city Iowa 136 162 19 0 70095 0 0 0 A St. Marys city Iowa 127 162 19 0 70140 0 0 0 A St. Olaf city Iowa 101 162 19 0 70185 0 0 0 A St. Paul city Iowa 124 162 19 0 70230 0 0 0 A Salem city Iowa 384 162 19 0 70320 0 0 0 A Salix city Iowa 387 162 19 0 70410 0 0 0 A Sanborn city Iowa 1381 162 19 0 70590 0 0 0 A Sandyville city Iowa 53 162 19 0 71040 0 0 0 A Scarville city Iowa 67 162 19 0 71085 0 0 0 A Schaller city Iowa 723 162 19 0 71130 0 0 0 A Schleswig city Iowa 857 162 19 0 71310 0 0 0 A Scranton city Iowa 524 162 19 0 71355 0 0 0 A Searsboro city Iowa 147 162 19 0 71625 0 0 0 A Sergeant Bluff city Iowa 5127 162 19 0 71760 0 0 0 A Seymour city Iowa 701 162 19 0 71895 0 0 0 A Shambaugh city Iowa 179 162 19 0 71940 0 0 0 A Shannon City city Iowa 69 162 19 0 72075 0 0 0 A Sharpsburg city Iowa 85 162 19 0 72210 0 0 0 A Sheffield city Iowa 1106 162 19 0 72300 0 0 0 A Shelby city Iowa 612 162 19 0 72345 0 0 0 A Sheldahl city Iowa 321 162 19 0 72390 0 0 0 A Sheldon city Iowa 5082 162 19 0 72435 0 0 0 A Shell Rock city Iowa 1275 162 19 0 72480 0 0 0 A Shellsburg city Iowa 972 162 19 0 72525 0 0 0 A Shenandoah city Iowa 4820 162 19 0 72660 0 0 0 A Sherrill city Iowa 178 162 19 0 72840 0 0 0 A Shueyville city Iowa 655 162 19 0 72975 0 0 0 A Sibley city Iowa 2574 162 19 0 73065 0 0 0 A Sidney city Iowa 1047 162 19 0 73110 0 0 0 A Sigourney city Iowa 2017 162 19 0 73155 0 0 0 A Silver City city Iowa 246 162 19 0 73290 0 0 0 A Sioux Center city Iowa 7605 162 19 0 73335 0 0 0 A Sioux City city Iowa 82651 162 19 0 73425 0 0 0 A Sioux Rapids city Iowa 744 162 19 0 73515 0 0 0 A Slater city Iowa 1458 162 19 0 73605 0 0 0 A Sloan city Iowa 987 162 19 0 73650 0 0 0 A Smithland city Iowa 227 162 19 0 73785 0 0 0 A Soldier city Iowa 164 162 19 0 73875 0 0 0 A Solon city Iowa 2690 162 19 0 73920 0 0 0 A Somers city Iowa 106 162 19 0 74055 0 0 0 A South English city Iowa 207 162 19 0 74280 0 0 0 A Spencer city Iowa 10952 162 19 0 74370 0 0 0 A Spillville city Iowa 344 162 19 0 74415 0 0 0 A Spirit Lake city Iowa 5155 162 19 0 74460 0 0 0 A Spragueville city Iowa 77 162 19 0 74505 0 0 0 A Springbrook city Iowa 146 162 19 0 74685 0 0 0 A Spring Hill city Iowa 65 162 19 0 74775 0 0 0 A Springville city Iowa 1137 162 19 0 74820 0 0 0 A Stacyville city Iowa 463 162 19 0 74910 0 0 0 A Stanhope city Iowa 396 162 19 0 74955 0 0 0 A Stanley city Iowa 120 162 19 0 75000 0 0 0 A Stanton city Iowa 643 162 19 0 75045 0 0 0 A Stanwood city Iowa 658 162 19 0 75135 0 0 0 A State Center city Iowa 1436 162 19 0 75180 0 0 0 A Steamboat Rock city Iowa 302 162 19 0 75405 0 0 0 A Stockport city Iowa 276 162 19 0 75450 0 0 0 A Stockton city Iowa 191 162 19 0 75630 0 0 0 A Storm Lake city Iowa 10322 162 19 0 75675 0 0 0 A Story City city Iowa 3320 162 19 0 75720 0 0 0 A Stout city Iowa 212 162 19 0 75810 0 0 0 A Stratford city Iowa 699 162 19 0 75855 0 0 0 A Strawberry Point city Iowa 1218 162 19 0 75945 0 0 0 A Struble city Iowa 80 162 19 0 75990 0 0 0 A Stuart city Iowa 1728 162 19 0 76035 0 0 0 A Sully city Iowa 831 162 19 0 76260 0 0 0 A Sumner city Iowa 1962 162 19 0 76440 0 0 0 A Superior city Iowa 119 162 19 0 76485 0 0 0 A Sutherland city Iowa 596 162 19 0 76620 0 0 0 A Swaledale city Iowa 158 162 19 0 76665 0 0 0 A Swan city Iowa 75 162 19 0 76755 0 0 0 A Swea City city Iowa 507 162 19 0 76890 0 0 0 A Swisher city Iowa 953 162 19 0 76935 0 0 0 A Tabor city Iowa 989 162 19 0 77115 0 0 0 A Tama city Iowa 2732 162 19 0 77340 0 0 0 A Templeton city Iowa 334 162 19 0 77430 0 0 0 A Tennant city Iowa 62 162 19 0 77520 0 0 0 A Terril city Iowa 336 162 19 0 77565 0 0 0 A Thayer city Iowa 55 162 19 0 77745 0 0 0 A Thompson city Iowa 469 162 19 0 77790 0 0 0 A Thor city Iowa 181 162 19 0 77835 0 0 0 A Thornburg city Iowa 62 162 19 0 77880 0 0 0 A Thornton city Iowa 402 162 19 0 77970 0 0 0 A Thurman city Iowa 214 162 19 0 78060 0 0 0 A Tiffin city Iowa 4157 162 19 0 78195 0 0 0 A Tingley city Iowa 173 162 19 0 78285 0 0 0 A Tipton city Iowa 3223 162 19 0 78330 0 0 0 A Titonka city Iowa 443 162 19 0 78510 0 0 0 A Toledo city Iowa 2143 162 19 0 78600 0 0 0 A Toronto city Iowa 117 162 19 0 78735 0 0 0 A Traer city Iowa 1596 162 19 0 78825 0 0 0 A Treynor city Iowa 965 162 19 0 78915 0 0 0 A Tripoli city Iowa 1360 162 19 0 79095 0 0 0 A Truesdale city Iowa 77 162 19 0 79140 0 0 0 A Truro city Iowa 491 162 19 0 79185 0 0 0 A Turin city Iowa 63 162 19 0 79410 0 0 0 A Udell city Iowa 43 162 19 0 79500 0 0 0 A Underwood city Iowa 956 162 19 0 79545 0 0 0 A Union city Iowa 381 162 19 0 79680 0 0 0 A Unionville city Iowa 95 162 19 0 79770 0 0 0 A University Heights city Iowa 1026 162 19 0 79815 0 0 0 A University Park city Iowa 469 162 19 0 79905 0 0 0 A Urbana city Iowa 1494 162 19 0 79950 0 0 0 A Urbandale city Iowa 44379 162 19 0 79995 0 0 0 A Ute city Iowa 339 162 19 0 80130 0 0 0 A Vail city Iowa 417 162 19 0 80175 0 0 0 A Valeria city Iowa 59 162 19 0 80400 0 0 0 A Van Horne city Iowa 656 162 19 0 80445 0 0 0 A Van Meter city Iowa 1292 162 19 0 80490 0 0 0 A Van Wert city Iowa 204 162 19 0 80535 0 0 0 A Varina city Iowa 65 162 19 0 80580 0 0 0 A Ventura city Iowa 713 162 19 0 80805 0 0 0 A Victor city Iowa 868 162 19 0 80985 0 0 0 A Villisca city Iowa 1142 162 19 0 81075 0 0 0 A Vincent city Iowa 161 162 19 0 81120 0 0 0 A Vining city Iowa 48 162 19 0 81210 0 0 0 A Vinton city Iowa 5075 162 19 0 81345 0 0 0 A Volga city Iowa 196 162 19 0 81570 0 0 0 A Wadena city Iowa 240 162 19 0 81615 0 0 0 A Wahpeton city Iowa 345 162 19 0 81705 0 0 0 A Walcott city Iowa 1634 162 19 0 81840 0 0 0 A Walford city Iowa 1445 162 19 0 81885 0 0 0 A Walker city Iowa 789 162 19 0 81975 0 0 0 A Wallingford city Iowa 173 162 19 0 82020 0 0 0 A Wall Lake city Iowa 769 162 19 0 82065 0 0 0 A Walnut city Iowa 769 162 19 0 82200 0 0 0 A Wapello city Iowa 1999 162 19 0 82335 0 0 0 A Washington city Iowa 7230 162 19 0 82380 0 0 0 A Washta city Iowa 223 162 19 0 82425 0 0 0 A Waterloo city Iowa 67328 162 19 0 82470 0 0 0 A Waterville city Iowa 144 162 19 0 82650 0 0 0 A Waucoma city Iowa 245 162 19 0 82695 0 0 0 A Waukee city Iowa 24089 162 19 0 82740 0 0 0 A Waukon city Iowa 3625 162 19 0 82875 0 0 0 A Waverly city Iowa 10198 162 19 0 82965 0 0 0 A Wayland city Iowa 943 162 19 0 83010 0 0 0 A Webb city Iowa 128 162 19 0 83055 0 0 0 A Webster city Iowa 71 162 19 0 83145 0 0 0 A Webster City city Iowa 7671 162 19 0 83190 0 0 0 A Weldon city Iowa 115 162 19 0 83280 0 0 0 A Wellman city Iowa 1395 162 19 0 83325 0 0 0 A Wellsburg city Iowa 687 162 19 0 83370 0 0 0 A Welton city Iowa 148 162 19 0 83415 0 0 0 A Wesley city Iowa 365 162 19 0 83550 0 0 0 A West Bend city Iowa 748 162 19 0 83595 0 0 0 A West Branch city Iowa 2492 162 19 0 83685 0 0 0 A West Burlington city Iowa 2890 162 19 0 83775 0 0 0 A West Chester city Iowa 147 162 19 0 83910 0 0 0 A West Des Moines city Iowa 67899 162 19 0 84090 0 0 0 A Westfield city Iowa 128 162 19 0 84180 0 0 0 A Westgate city Iowa 198 162 19 0 84315 0 0 0 A West Liberty city Iowa 3766 162 19 0 84450 0 0 0 A West Okoboji city Iowa 291 162 19 0 84540 0 0 0 A Westphalia city Iowa 118 162 19 0 84585 0 0 0 A West Point city Iowa 930 162 19 0 84630 0 0 0 A Westside city Iowa 289 162 19 0 84765 0 0 0 A West Union city Iowa 2305 162 19 0 84835 0 0 0 A Westwood city Iowa 110 162 19 0 84900 0 0 0 A What Cheer city Iowa 624 162 19 0 84945 0 0 0 A Wheatland city Iowa 723 162 19 0 85215 0 0 0 A Whiting city Iowa 723 162 19 0 85260 0 0 0 A Whittemore city Iowa 476 162 19 0 85305 0 0 0 A Whitten city Iowa 145 162 19 0 85710 0 0 0 A Willey city Iowa 98 162 19 0 85800 0 0 0 A Williams city Iowa 320 162 19 0 85845 0 0 0 A Williamsburg city Iowa 3164 162 19 0 85935 0 0 0 A Williamson city Iowa 154 162 19 0 86070 0 0 0 A Wilton city Iowa 2824 162 19 0 86250 0 0 0 A Windsor Heights city Iowa 4809 162 19 0 86385 0 0 0 A Winfield city Iowa 1088 162 19 0 86520 0 0 0 A Winterset city Iowa 5383 162 19 0 86565 0 0 0 A Winthrop city Iowa 849 162 19 0 86610 0 0 0 A Wiota city Iowa 107 162 19 0 86700 0 0 0 A Woden city Iowa 206 162 19 0 86835 0 0 0 A Woodbine city Iowa 1385 162 19 0 86880 0 0 0 A Woodburn city Iowa 194 162 19 0 86970 0 0 0 A Woodward city Iowa 1448 162 19 0 87015 0 0 0 A Woolstock city Iowa 161 162 19 0 87060 0 0 0 A Worthington city Iowa 395 162 19 0 87240 0 0 0 A Wyoming city Iowa 515 162 19 0 87285 0 0 0 A Yale city Iowa 239 162 19 0 87375 0 0 0 A Yetter city Iowa 32 162 19 0 87420 0 0 0 A Yorktown city Iowa 86 162 19 0 87555 0 0 0 A Zearing city Iowa 518 162 19 0 87690 0 0 0 A Zwingle city Iowa 92`)34:T7af,rollup = { let city_data = {} program_expenditures.forEach( item => { if (city_data[item.city_name]) { if (is_police(item)) { city_data[item.city_name].police_value += parseFloat(item.value+ '.0') } else { city_data[item.city_name].other_value += parseFloat(item.value + '.0') } } else { city_data[item.city_name] = city_details(item) city_data[item.city_name].latitude = city_data[item.city_name].primary_point_coordinates.coordinates[1] city_data[item.city_name].longitude = city_data[item.city_name].primary_point_coordinates.coordinates[0] city_data[item.city_name].police_value = 0.0 city_data[item.city_name].other_value = 0.0 if (is_police(item)) { city_data[item.city_name].police_value += parseFloat(item.value+ '.0') } else { city_data[item.city_name].other_value += parseFloat(item.value + '.0') } } }) let rollup = Object.values(city_data) debugger rollup.forEach(city => { city.total_budget = city.police_value + city.other_value city.county = city_counties[city.city_name] if (city.total_budget > 0) { city.police_percent = Math.floor(city.police_value / city.total_budget * 10000.0) / 100 } else { city.police_percent = 0.0 } city.display_police_percent = city.police_percent / 100 console.log(city.city_name + " " + populations[city.city_name]) city.population = populations[city.city_name].iowa_population city.census_population = populations[city.city_name].census_population if (city.population === 0) { city.per_capita_police = 0.0 } else { city.per_capita_police = Math.floor(city.police_value / city.population * 100)/100 } if (city.census_population === 0) { city.per_capita_police_census = 0.0 } else { city.per_capita_police_census = Math.floor(city.police_value / city.census_population * 100)/100 } }) return rollup }35:T523,higher = { let root = { name: 'Iowa', children: [] } program_expenditures.forEach( row => { let county = city_counties[row.city_name] let county_match = child_by_name(county, root) let city = row.city_name let service = row.expense_line_item let value = parseFloat(row.value) if (raw_city_match(city)) { if( !county_match ) { // county is not in the state yet let child = { name: county, children: [{ name: city, children: [{ name: service, value: value }] }] } root.children.push(child) } else { let city_match = child_by_name(city, county_match) if (!city_match) { // city is not in the county yet let child = { name: city, children: [{ name: service, value: value }] } county_match.children.push(child) } else { let service_match = child_by_name(service, city_match) if (!service_match) { let child = { name: service, value: value } city_match.children.push(child) } else { service_match.value = service_match.value + value } } } } }) return root }36:T56d,generate_map = (data, value_field, legend) => { const chart = vl.markSquare({filled: true, size: square_width, opacity: .8}) .data(data) .transform( vl.calculate(`datum.police_percent / 100.00`).as('display_percent'), ) .project( vl.projection('albersUsa') ) .encode( vl.longitude().fieldQ('longitude'), vl.latitude().fieldQ('latitude'), vl.color().fieldQ(value_field).scale({scheme: 'goldred'}).legend({title: legend}), vl.tooltip([ {field: 'city_name', type: 'Ordinal', title: 'City'}, {field: 'display_percent', type:'Quantitative', format: '.2%', title: 'Police Expenditures as % of Budget'}, {field: 'total_budget', type: 'Quantitative', format: '$,.2f', title: 'Total Budget'}, {field: 'population', type: 'Quantitative', format: ',', title: 'Population (from data.iowa.gov)'}, {field: 'per_capita_police', type: 'Quantitative', format: '$,.2f', title: 'Per Capita Police (iowa population)'}, {field: 'census_population', type: 'Quantitative', format: ',', title: 'Population (Census.gov)'}, {field: 'per_capita_police_census', type: 'Quantitative', format: '$,.2f', title: 'Per Capita Police (census population)'}, ]) ) .width(width-200) .autosize({type: 'fit-x', contains: 'padding'}) .height(Math.floor(width / 1.75)) .config({view: {stroke: null}}); return vl.layer(map,chart); }37:T52d,html` `38:[] 30:{"id":"9ba05b71178f960f","slug":"spending-by-iowa-cities-police-vs-other-services","title":"Spending By Iowa Cities (Police vs other services)","thumbnail":"9ba7994db9a3ef6bc8ea4a3a3d3d5d32285c1630b7be57c43b73cf415fda5fc6","access_level":"public","create_time":"$D2020-06-08T20:27:19.910Z","update_time":"$D2021-04-15T13:58:38.731Z","view_time":null,"first_public_time":"$D2020-06-09T23:14:43.546Z","fork":false,"stars":2,"starred":false,"owner":{"type":"team","id":"11eff763c21b0530","login":"jjimenez","name":"Jose Jimenez","avatar_url":"https://avatars-next.observableusercontent.com/5d28ac3054c420a200dcd8a0bd3367e2263d2f168c4aa5eaa0c89640622d6088","tier":"starter_2024"},"version":1652,"publish_version":1652,"role":null,"authored":false,"authors":[{"type":"individual","id":"214adfe1a708eb31","login":"jjimenez","name":"Jose Jimenez","avatar_url":"https://avatars-next.observableusercontent.com/5d28ac3054c420a200dcd8a0bd3367e2263d2f168c4aa5eaa0c89640622d6088","tier":null}],"members":[{"type":"individual","id":"214adfe1a708eb31","login":"jjimenez","name":"Jose Jimenez","avatar_url":"https://avatars-next.observableusercontent.com/5d28ac3054c420a200dcd8a0bd3367e2263d2f168c4aa5eaa0c89640622d6088","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":3,"collection":{"id":"dadf1970703a73a7","slug":"racial-awareness-2020","title":"Racial Awareness 2020","owner":{"id":"11eff763c21b0530","login":"jjimenez","name":"Jose Jimenez"}},"type":"notebook","body":{"title":"Spending By Iowa Cities (Police vs other services)","cells":[{"id":0,"value":"md`# Spending By Iowa Cities (Police vs other services)\n\nI've been hearing alot about defunding the police lately, and I wanted to look at what that would mean to city budgets in Iowa. Iowa provides some city budget information on data.iowa.gov so I set to visualizing the data for myself. \n\nThe first question I asked of the data was: __\"What percent of city budgets goes to Police?\"__\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":734,"value":"md`## Percentage of city budget allocated to Police\n\nHere is a map of the cities in the data colored so more intense colors (red) are cities where a higher percent of their budgets go to Police. \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":150,"value":"generate_map(map_cities, 'police_percent', 'Percent of Budget').render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":213,"value":"viewof min_percent = slider({\n title: 'Minimum Percent to show',\n min: 0, \n max: max_percent, \n step: 5, \n value: 0,\n description: \"Hide cities spending less than this percentage on Police\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":534,"value":"viewof city_filter = text({\n title: \"Filter\", \n value: 'Johnson',\n placeholder: \"City or County Name\", \n description: \"Enter the name of a city or county to filter the data below\"}\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1351,"value":"viewof map_cities_filter = radio({\n title: 'Cities to show',\n description: 'Please select the set of cities to show',\n options: [\n { label: 'Only cities that meet minimum percent and city / county filter', value: 'all_filters' },\n { label: 'Only cities that meet minimum percent regardless of name / county', value: 'only_minimum' },\n { label: 'All Cities', value: 'rollup' },\n ],\n value: 'only_minimum'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1594,"value":"md`One question that I don't have the answer to yet is the question of what expenditures are discretionary. There are a number of funds in the data and they might be able to be used to determine this. I think that comparing expenditures on police to similar programs might be useful. The programs represented in the data can be filtered by checking or un-checking the boxes below.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1572,"value":"viewof programs = checkbox({\n title: \"Programs\",\n description: \"Please select the expenditure programs to include\",\n options: unique_programs,\n value: [\"Business Type/Enterprise\", \"Capital Projects\", \"Community & Economic Development\", \"Culture & Recreation\", \"Debt Service\", \"General Government\", \"Health & Social Services\", \"Public Safety\", \"Public Works\"]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1083,"value":"md`\nThe next question I asked of the data was, __\"How much do cities spend per person in their population?\"__\n\nThis was complicated by the fact that some of the populations in the data.iowa.gov dataset were very different from what a google search (or common sense) would say. I found a data set at the federal census site that seemed to have better data, so I have that incorporated. You can switch to the iowa data if you prefer that.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":509,"value":"viewof population_selection = radio({\n title: 'Population source to use',\n description: 'Please select the source of population data to use',\n options: [\n { label: 'data.iowa.gov', value: 'per_capita_police' },\n { label: 'census.gov', value: 'per_capita_police_census' },\n ],\n value: 'per_capita_police_census'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":737,"value":"md`## Per Capita allocations for Police`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":456,"value":"generate_map(map_cities,population_selection,'Per Capita Expenditure').render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":741,"value":"md`## Percent of city budget allocated to Police\n\nAnother way of looking at the data is to use a simple bar chart. However, there are almost 1000 cities in Iowa so I added a filter by county or by city name to help focus the data to a set small enough to discern the values. See the controls above the previous map to filter down to a reasonable number of cities.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1087,"value":"md`Here is the bar chart for the filtered cities showing percent the percent of city budgets allocated to Police`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":25,"value":"generate_bar_plot('police_percent', 'Percent Police Expenditures',format_percent_string, 'display_police_percent').render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1056,"value":"md`## Per Capita Police Expenditures\n\nHere is the per person of population (Per Capita) Police budget for each city listed.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1053,"value":"generate_bar_plot(population_selection, 'Per Capita Police Expenditures',format_dollar_string, population_selection).render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1060,"value":"md`## Table view\n\nHere is the same data formatted as a table. Sorted by the percent of the city budget allocated to Police.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":320,"value":"table(simplified_filtered,{\n columns: {\n city_name: {title: 'City'},\n county: {title: 'County'},\n police_value: {title: 'Police Expenditures', formatter: d3.format('$,.2f')},\n total_budget: {title: 'Total Budget', formatter: d3.format('$,.2f')},\n police_percent: {title: 'Police Expenditure %', formatter(val, i) {\n return html`

${d3.format('.2%')(Math.floor(val * 10000)/10000)}\n

`;\n }},\n population: {formatter: d3.format(',')},\n per_capita_police: {title: 'Police Expenditure Per Capita', formatter: d3.format('$,.2f')}\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1063,"value":"md`## Relative size of budgets\n\nHere is an interactive visualization of city budgets where you can see the Police expenditures highlighed as red circles. You can interact with this visual by clicking on any circle. Once you are at the closest zoom level, if you click again, you will return to the level above. The outer square represents Iowa with each of the following levels represented:\n\n* County (Such as Johnson, Grundy, etc.)\n* City (Such as Iowa City, LeClaire, etc.)\n* Service (Including Police, Water, Airport, etc.)\n\n*Note: this visualization only filters based on the city or county name and ignores the minimum percent filter.*\n\n__(click a region to zoom in or out)__\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":948,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":543,"value":"md`## References`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":546,"value":"html`\n

\n\n`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1597,"value":"md`## Updates\n\n(all times US Central)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1598,"value":"html`\n\n

June 10, 2020 - 1:54pm: Added program filtering to help with the quesiton of discretionary funding. Does anyone know what funds are discretionary in Iowa? See unique_funds.; \n
June 10, 2020 - 2:27pm: Fixed lagends for maps
April 14 - 9:00pm: Updated for new data source

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1099,"value":"md`## Data, Imports, and Resources`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1102,"value":"md`### Raw Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1647,"value":"fiscal_year = (new Date()).getFullYear() - 1","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":8,"value":"raw_data = fetch(`https://data.iowa.gov/resource/k7cp-hq8y.json?$where=fiscal_year='${fiscal_year}'&$limit=500000`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":365,"value":"raw_population_data = fetch(`https://data.iowa.gov/resource/acem-thbp.json?$where=year = '2018-07-01T00:00:00.000'&$limit=500000`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":464,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":678,"value":"raw_county_data = fetch(`https://data.iowa.gov/resource/y8va-rhk9.json?$select=county,geo_name&$where=year = '2018-07-01T00:00:00.000'&$limit=500000`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1114,"value":"md`### Data Processing`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1581,"value":"program_expenditures = raw_data.filter(row => programs.includes(row.expenditure_program))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":332,"value":"simplified = map_cities.map( row => ({city_name: row.city_name,\n county: row.county,\n police_value: row.police_value,\n total_budget: row.total_budget,\n police_percent: row.police_percent / 100,\n population: population_selection === 'per_capita_police' ? row.population : row.census_population,\n per_capita_police: population_selection === 'per_capita_police' ? row.per_capita_police : row.per_capita_police_census,\n })\n ).sort( (a,b) => a.police_percent < b.police_percent ? 1 : -1 )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":538,"value":"simplified_filtered = simplified","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":690,"value":"city_counties = {\n let city_county = {}\n raw_county_data.forEach(row => {\n let name = row.geo_name.toUpperCase().replace(' (PT.)','')\n if (city_map_invert[name]) {\n name = city_map_invert[name]\n }\n city_county[name] = row.county\n })\n city_county['MORLEY'] = 'Jones'\n return city_county\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":491,"value":"census_by_name = {\n let census = {}\n census_population_data.forEach(row => {\n let name = row.NAME.toUpperCase().replace(new RegExp(' CITY$'), '');\n \n if (city_map_invert[name]) {\n name = city_map_invert[name]\n }\n let population = row.POPESTIMATE2019\n census[name] = parseInt(population)\n })\n return census\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":400,"value":"populations = {\n let pops = {}\n raw_population_data.forEach(row => {\n let pops_key = row.geographicname.toUpperCase()\n let fips = row.fips\n if (city_map_invert[pops_key]) {\n pops_key = city_map_invert[pops_key]\n }\n pops[pops_key] = {}\n pops[pops_key].fips = parseInt(fips)\n pops[pops_key].iowa_population = parseInt(row.population)\n pops[pops_key].census_population = census_by_name[pops_key]\n })\n return pops\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":374,"value":"unique_population_cities = [...(new Set(raw_population_data.map(row => row.geographicname.toUpperCase())))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":856,"value":"unique_services = [...(new Set(raw_data.map(row => row.expense_line_item)))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":387,"value":"city_map = ({\n \"JEWELL\": \"JEWELL JUNCTION\",\n \"SAINT ANTHONY\": \"ST. ANTHONY\",\n \"SAINT CHARLES\": \"ST. CHARLES\",\n \"ST ANSGAR\": \"ST. ANSGAR\",\n \"ST DONATUS\": \"ST. DONATUS\",\n \"ST LUCAS\": \"ST. LUCAS\",\n \"ST MARYS\": \"ST. MARYS\",\n \"ST OLAF\": \"ST. OLAF\",\n \"ST PAUL\": \"ST. PAUL\",\n \"SAINT ANSGAR\": \"ST. ANSGAR\",\n \"SAINT DONATUS\": \"ST. DONATUS\",\n \"SAINT LUCAS\": \"ST. LUCAS\",\n \"SAINT MARYS\": \"ST. MARYS\",\n \"SAINT OLAF\": \"ST. OLAF\",\n \"SAINT PAUL\": \"ST. PAUL\",\n \"DE WITT\": \"DEWITT\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":394,"value":"city_map_invert = {\n let map = new Object()\n Object.keys(city_map).forEach(key => {\n let val = city_map[key]\n map[val] = key\n })\n return map\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":381,"value":"missing_cities = unique_cities.filter( city => (!unique_population_cities.includes(city)) && !unique_population_cities.includes(city_map[city]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":383,"value":"extra_cities = unique_population_cities.filter(city => !unique_cities.includes(city) && !Object.keys(city_map_invert).includes(city))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":95,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1373,"value":"map_cities = filter_cities(map_cities_filter)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1359,"value":"filter_cities = (filter_type) => {\n let filtered_set = program_expenditures\n if (filter_type != 'rollup') {\n filtered_set = rollup.filter( row => {\n let match_percent = row.police_percent >= min_percent\n\n let match_county = row.county.toLowerCase().includes(city_filter.toLowerCase())\n let match_city = row.city_name.toLowerCase().includes(city_filter.toLowerCase())\n \n let condition = filter_type === 'only_minimum' ? ( match_percent) : (\n match_percent && ( match_county || match_city)\n )\n return condition\n })\n }\n return filtered_set\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":58,"value":"unique_cities = [...(new Set(raw_data.map(row => row.city_name)))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1552,"value":"unique_funds = [...(new Set(raw_data.map(row => row.fund)))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1560,"value":"unique_programs = [...(new Set(raw_data.map(row => row.expenditure_program)))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1642,"value":"unique_line_items = [...(new Set(raw_data.map(row => row.expense_line_item)))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1641,"value":"police_line_items = ['Jail','Police Department/Crime Prevention']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":929,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":216,"value":"max_percent = Math.floor(Math.max.apply(Math, rollup.map(row => row.police_percent))+ 10)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":748,"value":"height=width","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1437,"value":"square_width = Math.floor(width / 4.765)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1123,"value":"md`### Utility functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":89,"value":"is_police = (item) => police_line_items.includes(item.expense_line_item)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1639,"value":"make_coordinates = (point_value) => point_value.split('(')[1].split(')')[0].split(' ')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":92,"value":"city_details = (item) => ({city_name: item.city_name, primary_point_coordinates: {coordinates: make_coordinates(item.primary_point_coordinates) }})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":22,"value":"generate_bar_plot = (field, label, format_string, tooltip_field) => { \n const chart = vl.markBar({filled: true})\n .width((width - 200))\n .height(250)\n .data(map_cities)\n .encode(\n vl.x().fieldN('city_name').axis({title: 'City'}),\n vl.y({sort: 'ascending'}).fieldQ(field).axis({title: label}),\n vl.tooltip([\n {field: 'city_name', type: 'Nominal', title: 'City'},\n {field: tooltip_field, type: 'Quantitative', title: label, format: format_string }\n ])\n )\n ;\n \n return chart;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":148,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":578,"value":"map = vl.markGeoshape({stroke: 'black', fill:'ghostwhite', strokeWidth: 2})\n .data(vl.topojson('https://raw.githubusercontent.com/deldersveld/topojson/master/countries/us-states/IA-19-iowa-counties.json').feature('cb_2015_iowa_county_20m'))\n .width(width-200)\n .autosize({type: 'fit-x', contains: 'padding'})\n .height(Math.floor(width / 1.75))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":754,"value":"format = d3.format(format_dollar_string)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1459,"value":"format_dollar_string = '$,.2f'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1451,"value":"format_percent_string = '.2%'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":817,"value":"raw_city_match = (city) => {\n const match_name = city.toLowerCase().includes(city_filter.toLowerCase())\n const county = city_counties[city]\n const match_county = county.toLowerCase().includes(city_filter.toLowerCase())\n return match_name || match_county\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":957,"value":"color2 = d3.scaleLinear()\n .domain([0, 5])\n .range([\"hsl(152,80%,80%)\", \"hsl(228,30%,40%)\"])\n .interpolate(d3.interpolateHcl)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":933,"value":"child_by_name = (name, parent) => parent.children.filter(child => child.name === name)[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":952,"value":"pack2 = data => d3.pack()\n .size([width - 2, height - 2])\n .padding(3)\n (d3.hierarchy(data)\n .sum(d => d.value)\n .sort((a, b) => b.value - a.value))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1547,"value":"md`### Responsive table styles`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1472,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1131,"value":"md`### Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":9,"value":"import {vl} from \"@jjimenez/ui-salary-data-using-data-iowa-gov-api\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":66,"value":"import {select} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":203,"value":"import {autoSelect} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":209,"value":"import {slider} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":318,"value":"import {table} from \"@tmcw/tables\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":511,"value":"import {radio} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":533,"value":"import {text} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1568,"value":"import {checkbox} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1239,"value":"md`### Requires`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":325,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W38","stdlib":"1","titling":"auto"}} 31:"$30:body"