resale_prices

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

8 rows where month = "2001-11" and street_name = "STIRLING RD"

✎ 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
601866 601866 2001-11 QUEENSTOWN 3 ROOM 171 STIRLING RD 13 TO 15 60.0 Improved 1970 140000.0 68   1.29073246202285 103.803846934678 171 STIRLING RD
601869 601869 2001-11 QUEENSTOWN 3 ROOM 164 STIRLING RD 10 TO 12 66.0 Improved 1970 136000.0 68   1.29151824833554 103.802513058468 164 STIRLING RD
602005 602005 2001-11 QUEENSTOWN 3 ROOM 163 STIRLING RD 10 TO 12 66.0 Improved 1970 137000.0 68   1.29187643649549 103.802632277067 163 STIRLING RD
602012 602012 2001-11 QUEENSTOWN 3 ROOM 168 STIRLING RD 04 TO 06 60.0 Improved 1971 139500.0 69   1.29002050735811 103.80318804437 168 STIRLING RD
602014 602014 2001-11 QUEENSTOWN 3 ROOM 168 STIRLING RD 07 TO 09 60.0 Improved 1971 143000.0 69   1.29002050735811 103.80318804437 168 STIRLING RD
602015 602015 2001-11 QUEENSTOWN 3 ROOM 168 STIRLING RD 10 TO 12 60.0 Improved 1971 135000.0 69   1.29002050735811 103.80318804437 168 STIRLING RD
602018 602018 2001-11 QUEENSTOWN 3 ROOM 163 STIRLING RD 10 TO 12 66.0 Improved 1970 136000.0 68   1.29187643649549 103.802632277067 163 STIRLING RD
602024 602024 2001-11 QUEENSTOWN 4 ROOM 42 STIRLING RD 01 TO 03 120.0 Terrace 1968 450000.0 66   1.29833288584402 103.802299987051 42 STIRLING RD

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