resale_prices

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

5 rows where month = "2014-05" and street_name = "TAMPINES ST 45"

✎ 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
240428 240428 2014-05 TAMPINES 4 ROOM 497G TAMPINES ST 45 04 TO 06 102.0 Premium Apartment 1996 466000.0 81   1.36034648036577 103.959716831981
240430 240430 2014-05 TAMPINES 4 ROOM 497B TAMPINES ST 45 07 TO 09 102.0 Premium Apartment 1996 476000.0 81   1.3586829965139 103.958024469204
240469 240469 2014-05 TAMPINES 5 ROOM 498H TAMPINES ST 45 07 TO 09 124.0 Premium Apartment 1997 530000.0 82   1.36295791496804 103.957515257339
240494 240494 2014-05 TAMPINES 4 ROOM 498L TAMPINES ST 45 04 TO 06 106.0 Premium Apartment 1997 515000.0 82   1.36240933130332 103.957197483189
240506 240506 2014-05 TAMPINES 5 ROOM 497B TAMPINES ST 45 07 TO 09 130.0 Premium Apartment 1996 545000.0 81   1.3586829965139 103.958024469204

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
);
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]);