resale_prices

Data license: Singapore Open Data Licence · Data source: Housing and Development Board · About: hdb-resale-prices-datasette

9 rows where month = "2019-06" and street_name = "LOR 8 TOA PAYOH"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ month town flat_type block street_name storey_range floor_area_sqm flat_model lease_commence_date resale_price remaining_lease_years remaining_lease latitude longitude block_street_name
159767 159767 2019-06 TOA PAYOH 5 ROOM 217 LOR 8 TOA PAYOH 07 TO 09 119.0 Standard 1976 480000.0 55 55 years 11 months 1.34265870846085 103.854665608196 217 LOR 8 TOA PAYOH
159809 159809 2019-06 TOA PAYOH 5 ROOM 216 LOR 8 TOA PAYOH 13 TO 15 114.0 Standard 1975 500000.0 55 55 years 03 months 1.3424720602594 103.854178690288 216 LOR 8 TOA PAYOH
159823 159823 2019-06 TOA PAYOH 5 ROOM 218 LOR 8 TOA PAYOH 01 TO 03 119.0 Standard 1978 488000.0 57 57 years 07 months 1.34272583549089 103.855151579728 218 LOR 8 TOA PAYOH
159825 159825 2019-06 TOA PAYOH 4 ROOM 227 LOR 8 TOA PAYOH 07 TO 09 82.0 Improved 1976 335000.0 55 55 years 11 months 1.33951514445795 103.857970837281 227 LOR 8 TOA PAYOH
159826 159826 2019-06 TOA PAYOH 3 ROOM 235 LOR 8 TOA PAYOH 04 TO 06 65.0 Improved 1976 240000.0 56 56 years 01 month 1.33894969177117 103.857138926344 235 LOR 8 TOA PAYOH
159827 159827 2019-06 TOA PAYOH 4 ROOM 219 LOR 8 TOA PAYOH 07 TO 09 82.0 Improved 1978 318000.0 57 57 years 08 months 1.3427643319014 103.855872559307 219 LOR 8 TOA PAYOH
159840 159840 2019-06 TOA PAYOH 5 ROOM 223 LOR 8 TOA PAYOH 07 TO 09 114.0 Standard 1976 460000.0 55 55 years 09 months 1.34126479712806 103.855552754659 223 LOR 8 TOA PAYOH
159845 159845 2019-06 TOA PAYOH 3 ROOM 225 LOR 8 TOA PAYOH 01 TO 03 65.0 Improved 1976 230000.0 55 55 years 11 months 1.33950922302573 103.85564679729 225 LOR 8 TOA PAYOH
159846 159846 2019-06 TOA PAYOH 3 ROOM 233 LOR 8 TOA PAYOH 04 TO 06 66.0 Improved 1981 228000.0 61 61 years 04 months 1.33828365922679 103.858467966719 233 LOR 8 TOA PAYOH

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [resale_prices] (
   [month] TEXT,
   [town] TEXT,
   [flat_type] TEXT,
   [block] TEXT,
   [street_name] TEXT,
   [storey_range] TEXT,
   [floor_area_sqm] TEXT,
   [flat_model] TEXT,
   [lease_commence_date] TEXT,
   [resale_price] TEXT,
   [remaining_lease_years] TEXT,
   [remaining_lease] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [block_street_name] TEXT
);
CREATE INDEX [idx_resale_prices_month]
    ON [resale_prices] ([month]);
CREATE INDEX [idx_resale_prices_town]
    ON [resale_prices] ([town]);
CREATE INDEX [idx_resale_prices_flat_type]
    ON [resale_prices] ([flat_type]);
CREATE INDEX [idx_resale_prices_flat_model]
    ON [resale_prices] ([flat_model]);
CREATE INDEX [idx_resale_prices_block]
    ON [resale_prices] ([block]);
CREATE INDEX [idx_resale_prices_street_name]
    ON [resale_prices] ([street_name]);