From a 19-row sample across 7 columns.
building_class_category_minimum_sale_price__maximum_sale_price_+4building_class_category_minimum_sale_price__maximum_sale_price_+4Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | building_class_category | _number_of_sales_ | _minimum_sale_price_ | _average_sale_price_ | _median_sale_price_ | _maximum_sale_price_ |
|---|---|---|---|---|---|---|
| 1 | 01 ONE FAMILY HOMES | 55 | 408771 | 6812888 | 5075000 | 25000000 |
| 1 | 02 TWO FAMILY HOMES | 47 | 320000 | 3736718 | 3085000 | 15400000 |
| 1 | 03 THREE FAMILY HOMES |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | — | 5% | 53Citywideof 6 |
building_class_category | categorical | — | 5% | 02 TWO FAMILY HOMES 01 ONE FAMILY HOMES 03 THREE FAMILY HOMESof 3 |
_number_of_sales_ | categorical | — | 0% | 2214181608893of 19 |
_minimum_sale_price_ | categorical | — | 5% | 150000408771449249 |
GET /api/datasets/5ps9-yuef GET /api/datasets/5ps9-yuef/quality GET /api/datasets/5ps9-yuef/related GET /api/columns?dataset=5ps9-yuef
| 33 |
| 449249 |
| 2857128 |
| 1100000 |
| 19500000 |
| 2 | 01 ONE FAMILY HOMES | 516 | 150000 | 405594 | 349995 | 5000000 |
| 2 | 02 TWO FAMILY HOMES | 771 | 150000 | 421473 | 428786 | 1000000 |
| 2 | 03 THREE FAMILY HOMES | 276 | 150000 | 477090 | 496240 | 943750 |
| 3 | 01 ONE FAMILY HOMES | 1394 | 150000 | 580687 | 475000 | 10260000 |
| 3 | 02 TWO FAMILY HOMES | 2375 | 150000 | 591108 | 538888 | 10979100 |
| 3 | 03 THREE FAMILY HOMES | 841 | 150000 | 618201 | 586354 | 3310000 |
| 4 | 01 ONE FAMILY HOMES | 4714 | 150000 | 461437 | 425000 | 3775000 |
_average_sale_price_ | categorical | — | 5% | 635926591108496094of 18 |
_median_sale_price_ | categorical | — | 5% | 1100000496240410000of 18 |
_maximum_sale_price_ | categorical | — | 5% | 195000002500000015400000of 15 |