resale_prices

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

6 rows where month = "2014-04" and street_name = "WOODLANDS CIRCLE"

✎ 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
258743 258743 2014-04 WOODLANDS 4 ROOM 744 WOODLANDS CIRCLE 10 TO 12 102.0 Model A 1998 360000.0 83   1.44283428410961 103.795936955398 744 WOODLANDS CIRCLE
258980 258980 2014-04 WOODLANDS 5 ROOM 764A WOODLANDS CIRCLE 07 TO 09 110.0 Improved 2003 425000.0 88   1.44561064808723 103.796780614168 764A WOODLANDS CIRCLE
258986 258986 2014-04 WOODLANDS 5 ROOM 747 WOODLANDS CIRCLE 01 TO 03 121.0 Improved 1998 430000.0 83   1.44317276054403 103.795008213524 747 WOODLANDS CIRCLE
258991 258991 2014-04 WOODLANDS 4 ROOM 745 WOODLANDS CIRCLE 04 TO 06 103.0 Model A 1998 405000.0 83   1.4421581766394 103.795608530175 745 WOODLANDS CIRCLE
258994 258994 2014-04 WOODLANDS 4 ROOM 743 WOODLANDS CIRCLE 01 TO 03 100.0 Model A2 1997 368000.0 82   1.44373361822384 103.79631194039 743 WOODLANDS CIRCLE
259011 259011 2014-04 WOODLANDS 4 ROOM 765 WOODLANDS CIRCLE 10 TO 12 91.0 Model A 2003 396888.0 88   1.44589975238319 103.796914037556 765 WOODLANDS CIRCLE

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