From a 434-row sample across 70 columns.
comparable_rental_3_net_operating_incomecomparable_rental_1_estimated_expensecomparable_rental_1_net_operating_income+52Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| queens_condominiums_comparable_properties_boro_block_lot | queens_condominiums_comparable_properties_condo_section | queens_condominiums_comparable_properties_address | borough | queens_condominiums_comparable_properties_neighborhood | queens_condominiums_comparable_properties_building_classification | queens_condominiums_comparable_properties_total_units | queens_condominiums_comparable_properties_year_built | queens_condominiums_comparable_properties_gross_sqft | queens_condominiums_comparable_properties_estimated_gross_income | queens_condominiums_comparable_properties_gross_income_per_sqft | queens_condominiums_comparable_properties_estimated_expense |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4-00015-7501 | 0608-R1 | 2 51 AVENUE | 4 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
queens_condominiums_comparable_properties_boro_block_lot | text | — | 0% | 4-00946-75014-05598-75014-05893-7501 |
queens_condominiums_comparable_properties_condo_section | text | — | 0% | 0001-R10002-R10003-R1 |
queens_condominiums_comparable_properties_address | address | — | 0% | 132 41 ROAD140 34 AVENUE209 23 AVENUE |
borough | integer | — | 0% | 4 |
GET /api/datasets/jcih-dj9q GET /api/datasets/jcih-dj9q/quality GET /api/datasets/jcih-dj9q/related GET /api/columns?dataset=jcih-dj9q
comparable_rental_3_net_operating_incomecomparable_rental_1_estimated_expensecomparable_rental_1_net_operating_income+52bblcensus_tractcouncil_district+6boroughbinlatitude+1borough| LONG ISLAND CITY |
| R4-CONDOMINIUM |
| 57 |
| 2007 |
| 53685 |
| 1368968 |
| 25.5 |
| 416059 |
| 4-00016-7501 | 0597-R1 | 50 2 STREET | 4 | LONG ISLAND CITY | R4-CONDOMINIUM | 177 | 1909 | 187845 | 3381210 | 18 | 1292374 |
| 4-00021-7501 | 0639-R1 | 46 CENTER BOULEVARD | 4 | LONG ISLAND CITY | R4-CONDOMINIUM | 184 | 2008 | 249920 | 6185520 | 24.75 | 1936880 |
| 4-00030-7501 | 0558-R1 | 5 48 AVENUE | 4 | LONG ISLAND CITY | R4-CONDOMINIUM | 121 | 2007 | 113450 | 2892975 | 25.5 | 933694 |
| 4-00030-7501 | 0558-R2 | 5 48 AVENUE | 4 | LONG ISLAND CITY | R4-CONDOMINIUM | 3 | 2007 | 3360 | 94618 | 28.16 | 27653 |
| 4-00030-7502 | 0677-R1 | 5 47 ROAD | 4 | LONG ISLAND CITY | R4-CONDOMINIUM | 35 | 1955 | 55421 | 798617 | 14.41 | 387947 |
| 4-00031-7501 | 0478-R1 | 5 49 AVENUE | 4 | LONG ISLAND CITY | R2-CONDOMINIUM | 47 | 2005 | 62866 | 1572279 | 25.01 | 534361 |
| 4-00032-7501 | 0487-R1 | 5 50 AVENUE | 4 | LONG ISLAND CITY | R4-CONDOMINIUM | 13 | 2006 | 18375 | 459559 | 25.01 | 147000 |
| 4-00034-7501 | 0604-R1 | 5 BORDEN AVENUE | 4 | LONG ISLAND CITY | R4-CONDOMINIUM | 132 | 2008 | 140166 | 3505552 | 25.01 | 1121328 |
| 4-00040-7501 | 0594-R1 | 10 JACKSON AVENUE | 4 | LONG ISLAND CITY | R4-CONDOMINIUM | 48 | 2007 | 58876 | 1472489 | 25.01 | 471008 |
Showing 12 of 61 columns. All of them are listed below.
postcode | categorical | — | 91% | 113631169411385of 12 |
latitude | float | — | 91% | 40.77562140.77498640.570817 |
longitude | float | — | 91% | -73.75128-73.750975-73.854379 |
community_board | categorical | — | 91% | 11145of 7 |
council_district | categorical | — | 91% | 193231of 8 |
census_tract | categorical | — | 91% | 1483928884of 17 |
bin | categorical | — | 97% | 407970440803494082583of 15 |
bbl | categorical | — | 97% | 403337004840337175014034567501of 15 |
nta | categorical | — | 91% | Douglas Manor-Douglaston…Hammels-Arverne-Edgemere…Breezy Point-Belle Harbo…of 11 |
queens_condominiums_comparable_properties_neighborhood | text | — | 0% | FLUSHING-NORTHELMHURSTASTORIA |
queens_condominiums_comparable_properties_building_classification | categorical | — | 0% | R4-CONDOMINIUMR2-CONDOMINIUMR9-CONDOMINIUMof 4 |
queens_condominiums_comparable_properties_total_units | integer | — | 0% | 162024 |
queens_condominiums_comparable_properties_year_built | integer | — | 0% | 200620072008 |
queens_condominiums_comparable_properties_gross_sqft | integer | — | 0% | 14400530004900 |
queens_condominiums_comparable_properties_estimated_gross_income | integer | — | 0% | 808208330063048 |
queens_condominiums_comparable_properties_gross_income_per_sqft | float | — | 0% | 161721.44 |
queens_condominiums_comparable_properties_estimated_expense | integer | — | 0% | 6000035581112710 |
queens_condominiums_comparable_properties_expense_per_sqft | float | — | 0% | 787.5 |
queens_condominiums_comparable_properties_net_operating_income | integer | — | 0% | 45239226225212030 |
queens_condominiums_comparable_properties_full_market_value | integer | — | 0% | 363000043310001568000 |
queens_condominiums_comparable_properties_market_value_per_sqft | float | — | 0% | 55.7957.84123.54 |
comparable_rental_1_boro_block_lot | text | — | 0% | 4-01584-00134-02474-00104-04977-0021 |
comparable_rental_1_address | address | — | 0% | 46 88 STREET51 VAN KLEECK STREET137 NORTHERN BOULEVARD |
comparable_rental_1_neighborhood | text | — | 0% | FLUSHING-NORTHELMHURSTASTORIA |
comparable_rental_1_building_classification | categorical | — | 0% | D1-ELEVATORC1-WALK-UPD7-ELEVATORof 11 |
comparable_rental_1_total_units | integer | — | 0% | 171677 |
comparable_rental_1_year_built | integer | — | 0% | 200419632006 |
comparable_rental_1_gross_sqft | integer | — | 0% | 150506844067324 |
comparable_rental_1_estimated_gross_income | integer | — | 0% | 3390389874031423576 |
comparable_rental_1_gross_income_per_sqft | float | — | 0% | 22.5314.4321.15 |
comparable_rental_1_estimated_expense | integer | — | 1% | 125621358765373583 |
comparable_rental_1_expense_per_sqft | float | — | 1% | 8.355.247.5 |
comparable_rental_1_net_operating_income | integer | — | 0% | 2134176286381049993 |
comparable_rental_1_full_market_value | integer | — | 0% | 156000032780007590000 |
comparable_rental_1_market_value_per_sqft | float | — | 0% | 103.6547.9112.74 |
comparable_rental_1_distance_from_condo_in_miles | float | — | 0% | 00.050.13 |
comparable_rental_2_boro_block_lot | text | — | 1% | 4-02474-00104-03169-00214-01584-0013 |
comparable_rental_2_address | address | — | 0% | 51 VAN KLEECK STREET99 67 ROAD46 88 STREET |
comparable_rental_2_neighborhood | text | — | 0% | FLUSHING-NORTHELMHURSTREGO PARK |
comparable_rental_2_building_classification | categorical | — | 0% | D1-ELEVATORC1-WALK-UPD3-ELEVATORof 11 |
comparable_rental_2_total_units | integer | — | 1% | 77168 |
comparable_rental_2_year_built | integer | — | 1% | 196320042001 |
comparable_rental_2_gross_sqft | integer | — | 1% | 684402266215050 |
comparable_rental_2_estimated_gross_income | integer | — | 1% | 987403637733339038 |
comparable_rental_2_gross_income_per_sqft | float | — | 1% | 14.4328.1422.53 |
comparable_rental_2_estimated_expense | integer | — | 1% | 358765168204125621 |
comparable_rental_2_expense_per_sqft | float | — | 1% | 7.55.247.42 |
comparable_rental_2_net_operating_income | integer | — | 1% | 628638469529213417 |
comparable_rental_2_full_market_value | integer | — | 1% | 327800033790001560000 |
comparable_rental_2_market_value_per_sqft | float | — | 1% | 47.9149.1103.65 |
comparable_rental_2_distance_from_condo_in_miles | float | — | 1% | 0.10.180.19 |
comparable_rental_3_boro_block_lot | text | — | 71% | 4-02716-00014-02265-01144-05026-0024 |
comparable_rental_3_address | address | — | 0% | 64 GRAND AVENUE147 38 AVENUE |
comparable_rental_3_neighborhood | categorical | — | 0% | FLUSHING-NORTHELMHURSTof 19 |
comparable_rental_3_building_classification | categorical | — | 0% | D1-ELEVATORC1-WALK-UPof 10 |
comparable_rental_3_total_units | text | — | 0% | 1621 |
comparable_rental_3_year_built | text | — | 0% | 20061928 |
comparable_rental_3_gross_sqft | text | — | 0% | 28,5007,112 |
comparable_rental_3_estimated_gross_income | text | — | 0% | 381,330948,082 |
comparable_rental_3_gross_income_per_sqft | coordinate | — | 0% | 13.3815.82 |
comparable_rental_3_estimated_expense | text | — | 0% | 202,06570,676 |
comparable_rental_3_expense_per_sqft | coordinate | — | 0% | 7.096.76 |
comparable_rental_3_net_operating_income | text | — | 0% | 179,26541,837 |
comparable_rental_3_full_market_value | text | — | 0% | 1,189,0001,181,000 |
comparable_rental_3_market_value_per_sqft | coordinate | — | 0% | 41.7270.61 |
comparable_rental_3_distance_from_condo_in_miles | coordinate | — | 0% | 0.12.2 |