Housing Database by 2020 NTA

kyz5-72x5Housing & Development29 columns

Net change in housing units arising from new buildings, demolitions, or alterations for NYC NTAs since 2010. The NYC Department of City Planning's (DCP) Housing Database provide the 2010 census count of housing units, the net change in Class A housing units since the census, and the count of units pending completion for commonly used political and statistical boundaries. These tables are aggregated from the DCP Housing Database, which is derived from Department of Buildings (DOB)-approved housing construction and demolition jobs filed or completed in NYC since January 1, 2010. Net housing unit change is calculated as the sum of all three construction job types that add or remove residential units: new buildings, major alterations, and demolitions, and can be used to determine the change in legal housing units across time and space. All previously released versions of this data are available on the DCP Website: BYTES of the BIG APPLE . Current version: 26q2.1

View on NYC Open Data

Quality

B86.5 / 100

From a 262-row sample across 29 columns.

completeness100/ 25% weight

consistency55/ 20% weight

accuracy88/ 20% weight

timeliness100/ 15% weight

usability90/ 20% weight

· No obvious temporal column — limits time-series joins
· Has geographic keys — joinable to other NYC datasets

Related datasets

Housing Database by 2020 Census Block0.92
joins oncomp2014comp2016approved+23
Housing Database by Community District0.92
joins oncomp2014comp2016approved+24
Housing Database by 2024 City Council0.89
joins oncomp2014comp2016approved+24
Housing Database by 2020 CDTA

Sample rows

the_geom	nta2010	ntaname2010	comp2010ap	comp2010	comp2011	comp2012	comp2013	comp2014	comp2015	comp2016	comp2017
{"type":"MultiPolygon","coordinates":[[[[1003059.9974365236,204572.02539062474],[1002991.3671875009,204510.55499267465],[1002956.7838134766,204480.4031982485],[1002508.9660034175,204096.46899413635],[1002156.0989990213,203750.60040282886],[1001777.6452026366,203361.23718261888],[1001752.9335902923,203326.67353497425],[1001726.3875152487,203293.49801051928],[1001698.0847954764,203261.80786100877],[1001668.1083984365,203231.69598388634],[1001636.5460966383,203203.25066497503],[1001603.4905136728,203176.5552815201],[1001569.0385498127,203151.68808930885],[1001533.2911987287,203128.7219848622],[1001299.8475952159,202985.63122558422],[1001182.584411623,202901.72399902067],[1001071.7247924815,202817.51159667986],[1000819.812438964,202651.0615844724],[1000577.9855957017,202438.76239013765],[1000464.521240236,202322.73199462966],[1000339.1669921884,202199.26458740767],[1000100.7651977529,202013.77319335798],[999862.8688354477,201837.41198730515],[999660.6448364226,201684.42340087978],[999328.6539916999,201438.97399902556],[998999.360412597,201167.09838867385],[998882.6314086905,201072.07519531035],[998755.1511840809,201057.31079101606],[998549.1871948242,201033.4567871107],[998516.818603514,201292.7114257792],[998421.5660400402,202066.94219970636],[998364.8734130871,202521.55059814555],[998146.572998047,202389.97302245605],[997930.4777832017,202217.23382568304],[997652.8240356438,202865.64758300746],[997417.3749999949,202767.83319091168],[997188.9146118162,202663.8635864296],[997049.1770019534,202600.7731933571],[996949.7775878924,202555.79638672402],[996785.3489990233,202491.25219727098],[996370.3728027329,202830.00500488072],[995969.192810059,203155.91339111503],[995851.9160156236,203199.3317871086],[995880.6708374021,203207.7819824217],[995907.6105956994,203288.58959961194],[995905.0130004896,203429.6705932628],[995814.9299926755,203477.36138915835],[995793.8901977543,203488.4999999956],[995773.2478027304,203562.25939941575],[995302.3814086904,203532.56658935768],[995257.7969970709,203761.52282715164],[995042.1771850599,203723.81878662162],[994889.2427978497,203731.27978515506],[994878.7618408216,203854.5513916062],[994888.5665893556,204021.23559570272],[994921.2496337896,204053.91918945045],[994943.5844116216,204274.38159180162],[995020.1489868147,204546.76959228705],[995054.6171874991,204765.64398193246],[995017.328796385,205068.66558837864],[994980.7463989225,205259.85760497724],[994980.2073974606,205295.57519531078],[994975.5001831042,205329.7767944276],[994940.1901855429,205582.40679931693],[994871.9169921875,205777.24359130792],[994865.2532348644,205795.85339355277],[994861.2536010752,205808.1561889635],[994849.5802001958,205844.0607910206],[994771.9688110356,206104.77618407996],[994708.4682006849,206299.7319946334],[994697.2088012684,206371.90460205462],[994686.9934081999,206472.29742431475],[994695.9075927746,206524.43640136562],[994689.4082031212,206557.4783935549],[994690.2949829116,206605.32159423773],[994702.2492065413,206712.2048339843],[994729.8410034195,206785.56439209162],[994756.1793823235,206879.9307861267],[994785.4150390581,206927.3193969721],[994806.218994139,206968.41503905613],[994847.0916137686,207019.7341918884],[994898.9089965804,207124.6843872088],[995005.5130004892,207278.9097900408],[995191.3099975556,207548.37799072478],[995193.4194335932,207551.4451904294],[995205.6242065406,207569.31604004125],[995218.0485839796,207585.68438720494],[995253.2390136726,207628.82379150364],[995269.0100097667,207647.35418701105],[995273.3699951171,207655.69738769147],[995275.3388061526,207658.80419921645],[995283.1271972631,207669.84399414744],[995294.2984008746,207684.5029907232],[995308.7308349615,207700.12298583923],[995313.7376098626,207707.41619873518],[995325.7290039023,207727.73419189648],[995334.8035888645,207740.42443847828],[995358.199401855,207771.3729858384],[995364.1735839858,207780.48699951632],[995376.4146118176,207801.54998779082],[995382.3693847673,207810.31298828023],[995386.1027832043,207814.6271972563],[995390.7452392591,207818.87579346352],[995396.0996093713,207822.98339843654],[995411.9755859358,207834.1578369123],[995416.5686035171,207837.99999999907],[995420.3381957995,207841.79260252812],[995427.7659912119,207850.87078857218],[995445.2233886735,207874.48278808806],[995450.5646362301,207880.75579833926],[995455.7712402341,207886.04418945214],[995481.870239257,207910.14202880725],[995500.9056396495,207926.99578857207],[995509.950988766,207935.49304199396],[995527.3984374967,207952.89459227436],[995559.160400389,207984.62359619729],[995566.7355957032,207991.14599609573],[995581.6470336876,208001.72979735787],[995587.2900390635,208006.09320068895],[995604.3439941409,208020.43719482073],[995615.2593994128,208030.41400145815],[995643.0607910169,208058.27484130865],[995658.2609863274,208074.42340088202],[995660.6365966783,208076.36859130854],[995663.523437501,208078.2026367178],[995673.5956420907,208083.16699218866],[995677.0700073227,208085.12219238334],[995686.7846069348,208092.02484131043],[995701.2891845654,208103.96398926814],[995711.7290039014,208116.15539550627],[995719.176391603,208123.9046020525],[995754.0646362309,208158.70819091925],[995762.0369873049,208166.91638183818],[995769.4581909186,208174.00299072644],[995785.1965942391,208187.9661865208],[995802.5718383786,208202.57598876941],[995822.0238037122,208218.21240235041],[995845.9182128896,208236.77203369804],[995900.2160034173,208279.62939453023],[995918.3952026357,208293.48779296875],[995929.4219970717,208302.12939453605],[995954.2318115236,208321.90618897078],[995967.5682373048,208332.4639892565],[995990.4617919921,208348.79638672498],[996014.5794067377,208364.88519287578],[996050.2615966816,208389.31103516073],[996123.2434082045,208435.64599609192],[996140.2810058541,208446.46319580224],[996177.6202392572,208471.21398925927],[996180.9732055677,208473.14959716977],[996185.5108032197,208476.02679443307],[996188.7883911118,208476.69940185916],[996192.869384767,208477.08319091905],[996227.5906372037,208482.79498291216],[996542.9606323258,208533.49383544788],[996544.3157958961,208533.6351928662],[996545.7330322257,208533.6351928662],[996550.0275878903,208534.04199218936],[996558.6691894545,208531.9552001938],[996573.2723999,208529.27459717012],[996665.8375854497,208548.21179198212],[996741.7102050782,208555.08538818435],[996773.6394042979,208560.76403808006],[996785.9523925799,208562.48004149695],[996799.2001953123,208563.5823974695],[996813.6426391591,208564.10418702255],[996830.1813964829,208564.074401855],[996846.001403809,208563.01458740383],[996875.154785156,208560.3837890607],[996887.8187866217,208559.34039306987],[996918.963806152,208556.65979003688],[996932.9696044906,208556.65979004616],[996943.8098144522,208556.52203369437],[996954.1278076175,208556.51239013832],[996963.6654052683,208554.27783204147],[996989.741394042,208547.87078857567],[997005.088989253,208544.89160156372],[997048.5700073229,208536.96478271324],[997070.0986328113,208534.13684081705],[997113.5925903332,208529.65838623],[997131.9589843767,208527.46398926692],[997172.7463989258,208521.50579833973],[997210.0100097659,208515.0292358386],[997295.7709960929,208494.0383911145],[997312.7434082031,208489.1719970737],[997323.6376342761,208485.86920166248],[997333.5986328094,208482.84918212797],[997352.7949829072,208478.09039307327],[997369.6422119142,208473.65142822196],[997397.843994141,208465.94464111712],[997445.1799926754,208452.3851928696],[997499.9993896459,208439.6127929693],[997502.5978393541,208439.00579834462],[997511.5382080075,208437.07019042948],[997522.5256347634,208434.42584228236],[997542.4927978495,208429.43579102107],[997546.8890380865,208428.16583251703],[997550.3178100596,208427.3489990255],[997555.0845947257,208425.93164062293],[997558.0339965835,208419.98339843776],[997559.2709960948,208418.57958984378],[997564.3070068335,208411.84399414403],[997565.8098144521,208410.34478759966],[997567.3583984391,208409.21258544744],[997569.5203857408,208408.05139160107],[997571.820007324,208407.09643554565],[997576.538208007,208405.9316406234],[997578.8115844739,208405.7546386726],[997580.986999511,208405.84643554248],[997583.0274047843,208406.20739745907],[997584.9105834967,208406.83398438184],[997584.9960327132,208406.87322998088],[997585.0745849627,208406.92279053395],[997585.1502075196,208406.97839355332],[997585.2160034163,208407.03759765785],[997585.2781982406,208407.10943603617],[997585.3374023422,208407.1849975564],[997585.4321899393,208407.3591919001],[997585.5043945316,208407.55938720625],[997585.5535888657,208407.79199219504],[997585.589782714,208408.34643554417],[997585.4913940434,208409.34698486014],[997584.8944091809,208412.20458983927],[997584.8156127939,208412.7723999003],[997584.8121948239,208413.1921997047],[997584.8384399432,208413.35302734582],[997584.8810424808,208413.4841918947],[997584.910583495,208413.54003906006],[997584.9436035143,208413.58923339183],[997584.9797973626,208413.62860107547],[997585.0223999015,208413.66479492135],[997585.0715942378,208413.69079589777],[997585.1238403314,208413.71398924847],[997585.1798095715,208413.7269897483],[997585.2420043962,208413.7333984359],[997585.380004882,208413.7269897483],[997585.5405883787,208413.69439696893],[997591.1343994158,208411.62438965042],[997603.6605834956,208406.489440921],[997630.1434326145,208395.95159912217],[997678.6835937487,208376.3187866208],[997927.2590332023,208286.54559326128],[997964.8115844735,208271.34204101522],[997977.3280029306,208266.57519530936],[997998.6994018542,208257.57238769342],[998045.2803955089,208234.53479003685],[998092.6690063427,208211.43438720927],[998115.7659912123,208199.21618652137],[998203.7644042922,208153.08758544258],[998249.0628051742,208129.84320068161],[998273.2615966785,208117.39898682182],[998311.9531860367,208097.50079345566],[998426.6215820292,208039.60363770093],[998490.8699951175,208006.6904296869],[998498.609802242,208002.72399902155],[998548.1929931602,207976.98919677958],[998626.4508056624,207934.52539062474],[998630.9222412064,207947.8453979485],[998635.0790405277,207960.2341918996],[998787.4313964794,207891.5430297853],[998881.8504028269,207850.62438965205],[998887.4212036125,207848.7348022449],[998892.8576049816,207846.43499755865],[998899.9111938457,207842.6946411145],[998911.2138061536,207835.48999022463],[998924.0288085905,207826.4249877957],[998927.6802368166,207823.45263672335],[998928.2839965796,207822.9014282287],[998936.1315917983,207815.74279785145],[998940.8693847662,207812.26483154506],[998946.5057983403,207809.1843872039],[998962.5292358401,207801.59259033823],[998976.5484008782,207792.73083495925],[998982.1292114244,207789.73223876915],[998987.1748046867,207787.77343750332],[998999.1860351562,207784.2305908289],[999004.4486083995,207782.3043823238],[999021.0986328115,207774.67340088054],[999044.1893920898,207762.5932006905],[999053.9921875006,207769.78143310605],[999069.7861938489,207763.4462280279],[999092.3317871077,207710.18499755292],[999031.6062011721,207558.9634399411],[999027.8967895505,207549.838989257],[998964.6351928723,207394.2430419991],[998937.6090087838,207322.54559325564],[998882.7088012713,207190.72180176596],[998886.3173828119,207145.40258788568],[998894.4401855422,207073.0932006874],[998914.3135986336,206895.90100097642],[998920.1943969721,206843.46899413937],[999049.681396485,206858.20520019424],[999042.851989747,206900.4025878881],[999010.4150390642,207164.39099120963],[999021.4862060549,207191.13519286882],[999059.9624023456,207281.14160156125],[999061.4558105478,207284.7651977599],[999063.4458007799,207289.38000488587],[999065.0184326163,207293.15460204962],[999068.6105956985,207301.62762451533],[999072.9667968755,207311.89398193842],[999079.3156127936,207326.8757934586],[999086.3998413099,207343.7543945284],[999092.3229980442,207357.71502684767],[999095.8066406242,207365.79638672236],[999104.1104125992,207385.36938476114],[999129.9306030278,207446.75720215],[999146.4559936494,207486.35058593654],[999167.3778076138,207499.74279785535],[999250.2218017573,207462.97558593543],[999333.9718017569,207649.00878906046],[999344.4725952144,207646.38323974272],[999347.9728393563,207641.13262939925],[999340.9724121076,207621.88079833673],[999376.850585936,207608.7546386715],[999381.2261962881,207621.88079833673],[999392.6022338839,207626.25659179562],[999434.6062011716,207611.3801879846],[999436.3563842745,207603.5040283234],[999431.105834961,207587.75299072455],[999470.4848022456,207569.37579345918],[999475.7354125968,207586.00244141134],[999482.735839843,207589.50299072434],[999492.3619995122,207585.12719727008],[999492.3619995087,207578.12658691287],[999421.5867919909,207386.9213867224],[999441.0390014665,207236.23278808928],[999483.1973876922,207217.846801758],[999484.6148071246,207225.8290405264],[999486.2882080071,207234.71398926075],[999490.5368041982,207255.31439209133],[999494.9168090804,207269.47723388768],[999503.0333862321,207292.77783203076],[999513.5910034174,207317.75518798706],[999524.0209960922,207340.92718505627],[999530.4580078105,207357.02319335876],[999537.5411987308,207377.8826293926],[999551.6588134771,207413.1452026367],[999555.1987915046,207420.8779907226],[999558.9387817399,207427.56439209526],[999564.3851928693,207434.90344238383],[999577.9609985314,207449.447387699],[999583.381042482,207456.23223877055],[999593.8864135732,207471.21240234582],[999599.4999999995,207479.7955932634],[999609.3193969725,207495.75299072397],[999611.97680664,207499.99523925103],[999616.9703979506,207507.9545898455],[999617.1343994145,207508.18438720854],[999617.3179931632,207508.3973999085],[999617.75439453,207508.7811889684],[999618.2825927725,207509.10278320138],[999618.9125976547,207509.37500000116],[999619.8671875019,207509.65399170067],[999623.1972045889,207510.2739868205],[999623.9877929683,207510.4808349603],[999624.6473999033,207510.72698975302],[999625.159240724,207510.9957885737],[999625.592407226,207511.30419922408],[999625.9500122059,207511.6655883741],[999626.238586422,207512.07238769726],[999626.3829956016,207512.3707885749],[999626.4682006837,207512.65924072434],[999626.4877929669,207512.80358886515],[999626.4943847671,207512.94464111608],[999626.4848022466,207513.0889892615],[999626.4584350573,207513.22698974074],[999626.4190063472,207513.36779785497],[999626.3663940378,207513.50579834348],[999626.2124023434,207513.78479003368],[999625.9957885748,207514.0602416973],[999625.7167968717,207514.3425903359],[999625.1525878899,207514.79199218788],[999624.3981933603,207515.2739868146],[999620.4871826158,207517.43280028985],[999619.6343994134,207518.04638672213],[999619.2998046849,207518.34478760435],[999619.0208129882,207518.64343261867],[999618.8041992203,207518.93218994024],[999618.6235961919,207519.24060058594],[999618.4796142592,207519.56878662182],[999618.3710327152,207519.92303466945],[999618.3021850573,207520.29418945085],[999618.2659912115,207520.6807861225],[999618.312194826,207521.51458740645],[999618.508789063,207522.40679932147],[999618.850036616,207523.34478759844],[999619.3323974613,207524.30279541158],[999619.9428100535,207525.25762940093],[999621.5043945306,207527.08843994173],[999622.393432615,207527.87902831548],[999623.3186035152,207528.54840087311],[999625.1426391609,207529.4537963847],[999626.4356079093,207529.72283935608],[999632.8099975599,207529.24719238165],[999635.8677978518,207528.67303467303],[999640.6646118152,207527.66839599382],[999650.5628051764,207524.59680175857],[999660.9509887693,207520.39843749322],[999679.6206054686,207510.88439941037],[999707.6387939465,207494.5543823202],[999963.462402344,207362.06243896115],[999987.3599853528,207350.02539062727],[1000000.0007934578,207341.6459960917],[1000017.4155883783,207330.10418701643],[1000044.6300048843,207312.9451904297],[1000062.0317993149,207302.58740235338],[1000079.6923828082,207292.67279052432],[1000090.3779907223,207286.95458984358],[1000214.4298095703,207217.272583014],[1000289.8496093749,207147.37463378342],[1000294.5903930676,207142.01379394345],[1000332.4280395523,207105.5831909226],[1000386.9487915054,207055.74420166397],[1000396.4110107408,207044.3237915062],[1000381.5390014603,207030.53424072353],[1000383.1300048815,207023.99218750562],[1000389.5408325148,207011.04278564983],[1000408.7896118119,206978.26403808844],[1000432.9495849599,206948.52319336546],[1000449.8196411149,206965.52459717487],[1000518.5397949223,206835.12438965077],[1000560.3179931652,206753.77319335565],[1000601.9782104507,206621.75219726368],[1000558.0082397476,206606.57519531206],[1000563.7891845716,206589.78399658154],[1000590.6986083942,206511.63439941304],[1000617.3981933612,206519.08178710722],[1000620.9805908218,206520.08239746315],[1000624.1928100585,206510.1221923828],[1000629.3193969739,206494.2170410211],[1000651.8008422849,206424.47259521388],[1000677.4406127919,206439.8923950191],[1000700.0256347653,206395.94238281043],[1000714.7636108366,206367.26300048814],[1000720.9902343764,206355.14520263468],[1000688.7890014647,206340.03363036917],[1000777.2106323243,206046.99279784833],[1000910.120605469,205713.00402831874],[1000930.8388061507,205660.94378661652],[1000949.4710083005,205629.1821899421],[1001179.968994142,205380.98419189375],[1001278.0986328133,205289.9144287143],[1001405.0997924797,205142.40478515657],[1001409.0696411096,205149.0845947263],[1001629.220031738,204986.64398193435],[1001678.1307983395,204946.37500000396],[1001730.1188354507,204916.5950317387],[1001755.410583498,204909.26239014234],[1001833.3303833004,204883.78338623056],[1001965.429992675,204834.65283203183],[1002089.2290039067,204787.1041870187],[1002095.1542358393,204784.93438720523],[1002189.4584350588,204750.40460205718],[1002262.220642086,204721.82519531265],[1002285.1408081041,204711.45422363054],[1002318.6279907223,204705.90319824783],[1002427.0244140581,204685.5744018544],[1002484.6633911143,204675.15759277498],[1002481.1907958973,204655.71319580072],[1002499.9992065432,204652.49780273347],[1002607.4003906265,204635.1946411166],[1002673.6896362277,204625.5751953106],[1002681.4884033178,204624.39398193732],[1002685.3497924812,204620.85418701137],[1002686.1404418951,204616.1724243158],[1002748.6304321294,204601.3331909161],[1002815.3554077152,204590.32263183463],[1002844.5686035162,204598.71502686074],[1002923.390808104,204579.5745849662],[1002984.0794067372,204566.9827880879],[1002989.8702392593,204567.6323852507],[1002997.0978393556,204574.95202637048],[1003001.2283935542,204580.28338623352],[1003059.9974365236,204572.02539062474]]]]}

Columns

29 queryable · 28 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`the_geom`	unknown	Geometry of the NTA	—	—
`nta2010`	text	—	0%	`BK0802BK1893SI9593`
`ntaname2010`	text	—	0%	`Pelham Bay-Country Club-…Cypress HillsUniversity Heights (Sout…`
`comp2010ap`	integer	Net number of class A housing units completed between April 1, 2010 and December 31, 2010, accounting for new buildings, alterations, and demolitions	0%	`0.0-1.012.0`
`comp2010`	integer

Query this from your own app

GET /api/datasets/kyz5-72x5
GET /api/datasets/kyz5-72x5/quality
GET /api/datasets/kyz5-72x5/related
GET /api/columns?dataset=kyz5-72x5