resale_prices

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

10 rows where month = "2014-04" and street_name = "WOODLANDS ST 13"

✎ 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
257141 257141 2014-04 WOODLANDS 3 ROOM 160 WOODLANDS ST 13 01 TO 03 73.0 Model A 1990 320000.0 75   1.43333328424957 103.774921567416 160 WOODLANDS ST 13
257142 257142 2014-04 WOODLANDS 3 ROOM 102 WOODLANDS ST 13 10 TO 12 67.0 New Generation 1985 325000.0 70   1.43608294925148 103.781199565987 102 WOODLANDS ST 13
257146 257146 2014-04 WOODLANDS 3 ROOM 158 WOODLANDS ST 13 10 TO 12 73.0 Model A 1990 338000.0 75   1.43403215729146 103.77477997616 158 WOODLANDS ST 13
257147 257147 2014-04 WOODLANDS 3 ROOM 159 WOODLANDS ST 13 01 TO 03 73.0 Model A 1990 340000.0 75   1.43367896261278 103.774587099483 159 WOODLANDS ST 13
257148 257148 2014-04 WOODLANDS 4 ROOM 156 WOODLANDS ST 13 04 TO 06 91.0 New Generation 1986 340000.0 71   1.43421027208486 103.774283872761 156 WOODLANDS ST 13
257154 257154 2014-04 WOODLANDS 4 ROOM 150 WOODLANDS ST 13 01 TO 03 97.0 New Generation 1986 355000.0 71   1.43532609574492 103.773740682395 150 WOODLANDS ST 13
257407 257407 2014-04 WOODLANDS 4 ROOM 101 WOODLANDS ST 13 07 TO 09 91.0 New Generation 1985 383000.0 70   1.43598159724925 103.781929846478 101 WOODLANDS ST 13
257410 257410 2014-04 WOODLANDS 4 ROOM 172 WOODLANDS ST 13 10 TO 12 91.0 New Generation 1985 368888.0 70   1.43397247465557 103.777516916131 172 WOODLANDS ST 13
257413 257413 2014-04 WOODLANDS 4 ROOM 177 WOODLANDS ST 13 01 TO 03 91.0 New Generation 1986 375000.0 71   1.43435791362603 103.778088434368 177 WOODLANDS ST 13
257471 257471 2014-04 WOODLANDS 4 ROOM 113 WOODLANDS ST 13 04 TO 06 93.0 New Generation 1987 365000.0 72   1.43801404529215 103.78122891909 113 WOODLANDS ST 13

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