resale_prices

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

5 rows where month = "1993-09" and street_name = "ST. GEORGE'S 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
905892 905892 1993-09 KALLANG/WHAMPOA 3 ROOM 2 ST. GEORGE'S RD 10 TO 12 59.0 IMPROVED 1976 70000.0 82   1.3234256745592 103.860686612229 2 ST. GEORGE'S RD
905893 905893 1993-09 KALLANG/WHAMPOA 3 ROOM 3 ST. GEORGE'S RD 13 TO 15 59.0 IMPROVED 1976 73500.0 82   1.3225873518737 103.861107276991 3 ST. GEORGE'S RD
905898 905898 1993-09 KALLANG/WHAMPOA 3 ROOM 3 ST. GEORGE'S RD 10 TO 12 59.0 IMPROVED 1976 75000.0 82   1.3225873518737 103.861107276991 3 ST. GEORGE'S RD
906217 906217 1993-09 KALLANG/WHAMPOA 3 ROOM 14 ST. GEORGE'S RD 01 TO 03 67.0 NEW GENERATION 1984 85000.0 90   1.32369795683614 103.86209172719 14 ST. GEORGE'S RD
906234 906234 1993-09 KALLANG/WHAMPOA 5 ROOM 22 ST. GEORGE'S RD 13 TO 15 118.0 IMPROVED 1984 270000.0 90   1.32520475650307 103.862445341683 22 ST. GEORGE'S 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]);