From a 18-row sample across 7 columns.
building_class_category_number_of_sales__average_sale_price_+4building_class_category_number_of_sales__average_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 | 68 | 331500 | 8926012 | 5414549 | 49000000 |
| 1 | 02 TWO FAMILY HOMES | 61 | 200000 | 4671561 | 4150000 | 17000000 |
| 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 | — | 0% | 53Citywideof 6 |
building_class_category | categorical | — | 0% | 02 TWO FAMILY HOMES 01 ONE FAMILY HOMES 03 THREE FAMILY HOMESof 3 |
_number_of_sales_ | categorical | — | 0% | 2823912906of 18 |
_minimum_sale_price_ | categorical | — | 0% | 150000151117175000 |
GET /api/datasets/ugc2-6t2g GET /api/datasets/ugc2-6t2g/quality GET /api/datasets/ugc2-6t2g/related GET /api/columns?dataset=ugc2-6t2g
| 42 |
| 175000 |
| 3868956 |
| 3425000 |
| 13500000 |
| 2 | 01 ONE FAMILY HOMES | 606 | 150000 | 441962 | 391200 | 3956150 |
| 2 | 02 TWO FAMILY HOMES | 906 | 150000 | 482934 | 480000 | 975000 |
| 2 | 03 THREE FAMILY HOMES | 469 | 153000 | 558828 | 575000 | 1550000 |
| 3 | 01 ONE FAMILY HOMES | 1577 | 151117 | 642727 | 515000 | 8450000 |
| 3 | 02 TWO FAMILY HOMES | 2906 | 150000 | 656988 | 600000 | 10800000 |
| 3 | 03 THREE FAMILY HOMES | 1081 | 150000 | 733439 | 695000 | 3100000 |
| 4 | 01 ONE FAMILY HOMES | 5078 | 150000 | 513661 | 465000 | 5617500 |
_average_sale_price_ | categorical | — | 0% | 7092283868956513661of 18 |
_median_sale_price_ | categorical | — | 0% | 3425000465000391200of 18 |
_maximum_sale_price_ | categorical | — | 0% | 31000004900000013500000of 13 |