From a 500-row sample across 61 columns.
Has street addresses (`address`) — needs geocoding before it can be drawn.
| boro_block_lot | condo_section | address | neighborhood | building_classification | total_units | year_built | gross_sqft | estimated_gross_income | gross_income_per_sqft | estimated_expense | expense_per_sqft |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4-02119-7501 | 0183-R1 | 100 QUEENS BOULEVARD | REGO PARK | R4-CONDOMINIUM | 157 | 1959 | 148800 | 2242416 | 15.07 | 1053504 | 7.08 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
boro_block_lot | text | The Borough-Block-Lot location of the subject condominium. The lot identifies the condominium billing lot generally associated with the condominium management organization. | 0% | 4-00946-75014-05598-75013-01734-7504 |
condo_section | text | The subject condominium is identified using a combination of a condominium number assigned by DoF followed by the condominium suffix. The condominium number is assigned by the Department of Finance for each condominium in New York City. The condominium suffix is a partition of the condominium. A condominium may have multiple residential or commercial suffixes each of which contains individual condominium lots. | 0% | 0100-R10144-R10097-R1 |
address | text | The Street Address of the property | 0% | 209-90 23 AVENUE84-10 101 STREET140-55 34 AVENUE |
GET /api/datasets/9ck6-2jew GET /api/datasets/9ck6-2jew/quality GET /api/datasets/9ck6-2jew/related GET /api/columns?dataset=9ck6-2jew
| 4-03547-7501 |
| 0675-R1 |
| 852 CYPRESS AVENUE |
| RIDGEWOOD |
| R2-CONDOMINIUM |
| 19 |
| 2010 |
| 19400 |
| 764610 |
| 39.41 |
| 282906 |
| 14.58 |
| 1-01263-7501 | 1655-R1 | 16 WEST 48 STREET | MIDTOWN WEST | R4 -ELEVATOR | 152 | 2005 | 148385 | 8791811 | 59.25 | 2298484 | 15.49 |
| 1-01292-7501 | 0086-R1 | 721 5 AVENUE | MIDTOWN CBD | R4 -ELEVATOR | 232 | 1983 | 499668 | 38129665 | 76.31 | 11912085 | 23.84 |
| 4-03637-7501 | 0350-R1 | 71 FRESH POND ROAD | GLENDALE | R2-CONDOMINIUM | 64 | 1990 | 58586 | 891679 | 15.22 | 370849 | 6.33 |
| 4-03667-7501 | 0226-R1 | 72 METROPOLITAN AVENUE | GLENDALE | R2-CONDOMINIUM | 12 | 1988 | 9969 | 144152 | 14.46 | 54231 | 5.44 |
| 4-03727-7501 | 0378-R1 | 56 CLOVER PLACE | GLENDALE | R2-CONDOMINIUM | 28 | — | 20320 | 248920 | 12.25 | 104038 | 5.12 |
| 4-04044-7501 | 0534-R1 | 14 110 STREET | COLLEGE POINT | R4-CONDOMINIUM | 33 | 2002 | 30185 | 613057 | 20.31 | 208439 | 6.91 |
| 4-04981-7501 | 0010-R2 | 140 34 AVENUE | FLUSHING-NORTH | R4-CONDOMINIUM | 3 | 1967 | 4493 | 68968 | 15.35 | 32439 | 7.22 |
| 4-04981-7501 | 0010-R3 | 140 34 AVENUE | FLUSHING-NORTH | R4-CONDOMINIUM | 1 | 1967 | 1075 | 16501 | 15.35 | 7762 | 7.22 |
Showing 12 of 46 columns. All of them are listed below.
neighborhood |
| text |
| Department of Finance determines the neighborhood name in the course of valuing properties. The common name of the neighborhood is generally the same as the name Finance designates. However, there may be slight differences in neighborhood boundary lines. |
| 0% |
FLUSHING-NORTHHARLEM-CENTRALUPPER EAST SIDE (59-79) |
building_classification | text | The Building Class code is used to describe a property’s use. This report includes the two character code as well as the description of the building class. | 0% | R4-ELEVATORR4 -ELEVATORR4-CONDOMINIUM |
total_units | integer | Total number of units in the building | 0% | 121610 |
year_built | text | The year the building was built | 0% | 200620072005 |
gross_sqft | integer | Gross square footage of the building | 0% | 242004788035212 |
estimated_gross_income | integer | Estimated Income per SquareFoot * Gross SquareFoot | 0% | 743576513282611985 |
gross_income_per_sqft | float | Estimated income per squarefoot of median comparable | 0% | 21.2121.0221.23 |
estimated_expense | integer | Estimated Expense per SquareFoot * Gross SquareFoot | 0% | 11979038021255287 |
expense_per_sqft | float | Estimated expense per squarefoot of median comparable | 0% | 4.9511.029.76 |
net_operating_income | integer | Estimated Gross Income-Estimated Expense | 0% | 60640258456463188 |
full_market_value | integer | Current year’s total market value of the land and building | 0% | 111800017680002322000 |
market_value_per_sqft | float | Full Market Value/ Gross SquareFoot | 0% | 118.89118.9118.88 |
boro_block_lot_1 | text | The Borough-Block-Lot location of the comparable rental property. | 0% | 1-00220-00273-01914-00361-00797-0074 |
address_1 | text | The Street Address of the property | 0% | 36 LAIGHT STREET908 BEDFORD AVENUE160 WEST 22 STREET |
neighborhood_1 | text | Department of Finance determines the neighborhood name in the course of valuing properties. The common name of the neighborhood is generally the same as the name Finance designates. However, there may be slight differences in neighborhood boundary lines. | 0% | FLUSHING-NORTHUPPER EAST SIDE (59-79)CHELSEA |
building_classification_1 | text | The Building Class code is used to describe a property’s use. This report includes the two character code as well as the description of the building class. | 0% | D1-ELEVATORD1 -ELEVATORC1-WALK-UP |
total_units_1 | integer | — | 0% | 162012 |
year_built_1 | integer | — | 0% | 192019001910 |
gross_sqft_1 | integer | — | 0% | 260002671218000 |
estimated_gross_income_1 | integer | — | 0% | 2733198623802398351 |
gross_income_per_sqft_1 | float | — | 0% | 21.0224.7522.82 |
estimated_expense_1 | integer | — | 0% | 806142725690133910 |
expense_per_sqft_1 | float | — | 0% | 6.28.328.04 |
net_operating_income_1 | integer | — | 0% | 1927055898112264441 |
full_market_value_1 | integer | — | 0% | 598400013770002378000 |
market_value_per_sqft_1 | float | — | 0% | 224.02105.92120.23 |
distance_from_condo_in_miles | float | — | 0% | 00.050.1 |
boro_block_lot_2 | text | — | 1% | 3-01914-01354-05013-00313-01914-0036 |
address_2 | address | — | 1% | 904 BEDFORD AVENUE908 BEDFORD AVENUE190 ROSS STREET |
neighborhood_2 | text | — | 1% | FLUSHING-NORTHUPPER EAST SIDE (59-79)BEDFORD STUYVESANT |
building_classification_2 | text | — | 1% | D1-ELEVATORD1 -ELEVATORC1-WALK-UP |
total_units_2 | integer | — | 1% | 162012 |
year_built_2 | text | — | 1% | 192019001931 |
gross_sqft_2 | integer | — | 1% | 260002250043000 |
estimated_gross_income_2 | integer | — | 1% | 5515703061602165306 |
gross_income_per_sqft_2 | float | — | 1% | 21.2117.8630.37 |
estimated_expense_2 | integer | — | 1% | 12875590619783162 |
expense_per_sqft_2 | float | — | 1% | 4.9510.6210.87 |
net_operating_income_2 | integer | — | 1% | 422815215540582144 |
full_market_value_2 | integer | — | 1% | 10529500031260002860000 |
market_value_per_sqft_2 | float | — | 1% | 203.26120.23110 |
distance_from_condo_in_miles_1 | float | — | 1% | 0.0500.15 |
boro_block_lot_3 | text | — | 19% | 1-01401-00333-02188-00164-05013-0031 |
address_3 | text | — | 19% | 1130 3 AVENUE200 ROSS STREET904 BEDFORD AVENUE |
neighborhood_3 | text | — | 19% | FLUSHING-NORTHUPPER EAST SIDE (59-79)CHELSEA |
building_classification_3 | text | — | 19% | D1 -ELEVATORD1-ELEVATORC1-WALK-UP |
total_units_3 | integer | — | 19% | 162024 |
year_built_3 | text | — | 19% | 192019001910 |
gross_sqft_3 | integer | — | 19% | 2500028675526000 |
estimated_gross_income_3 | integer | — | 19% | 55157070512004008271 |
gross_income_per_sqft_3 | float | — | 19% | 21.2144.0721.02 |
estimated_expense_3 | integer | — | 19% | 12875525776001908404 |
expense_per_sqft_3 | float | — | 19% | 4.9510.158.14 |
net_operating_income_3 | integer | — | 19% | 4228154473600381659 |
full_market_value_3 | integer | — | 19% | 7682800028870001304000 |
market_value_per_sqft_3 | float | — | 19% | 267.92111.0452.16 |
distance_from_condo_in_miles_2 | float | — | 20% | 0.150.050.1 |
report_year | categorical | — | 0% | 202120232016of 11 |