resale_prices

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

13 rows where month = "1997-12" and street_name = "LOR 8 TOA PAYOH"

✎ 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
777367 777367 1997-12 TOA PAYOH 4 ROOM 214 LOR 8 TOA PAYOH 07 TO 09 82.0 IMPROVED 1975 287000.0 77   1.34183370695987 103.854370726041 214 LOR 8 TOA PAYOH
777380 777380 1997-12 TOA PAYOH 4 ROOM 219 LOR 8 TOA PAYOH 19 TO 21 82.0 IMPROVED 1978 285000.0 80   1.3427643319014 103.855872559307 219 LOR 8 TOA PAYOH
777381 777381 1997-12 TOA PAYOH 4 ROOM 219 LOR 8 TOA PAYOH 04 TO 06 82.0 IMPROVED 1978 270000.0 80   1.3427643319014 103.855872559307 219 LOR 8 TOA PAYOH
777382 777382 1997-12 TOA PAYOH 4 ROOM 227 LOR 8 TOA PAYOH 07 TO 09 82.0 IMPROVED 1976 260000.0 78   1.33951514445795 103.857970837281 227 LOR 8 TOA PAYOH
777383 777383 1997-12 TOA PAYOH 4 ROOM 222 LOR 8 TOA PAYOH 10 TO 12 82.0 IMPROVED 1976 267000.0 78   1.34177310664554 103.856039796964 222 LOR 8 TOA PAYOH
777384 777384 1997-12 TOA PAYOH 4 ROOM 222 LOR 8 TOA PAYOH 16 TO 18 82.0 IMPROVED 1976 270000.0 78   1.34177310664554 103.856039796964 222 LOR 8 TOA PAYOH
777399 777399 1997-12 TOA PAYOH 3 ROOM 232 LOR 8 TOA PAYOH 04 TO 06 65.0 IMPROVED 1976 185000.0 78   1.3375718690811 103.858843935428 232 LOR 8 TOA PAYOH
777418 777418 1997-12 TOA PAYOH 3 ROOM 234 LOR 8 TOA PAYOH 04 TO 06 65.0 IMPROVED 1976 195000.0 78   1.33860148626926 103.857914069837 234 LOR 8 TOA PAYOH
777438 777438 1997-12 TOA PAYOH 4 ROOM 219 LOR 8 TOA PAYOH 13 TO 15 82.0 IMPROVED 1978 273000.0 80   1.3427643319014 103.855872559307 219 LOR 8 TOA PAYOH
777472 777472 1997-12 TOA PAYOH 4 ROOM 214 LOR 8 TOA PAYOH 01 TO 03 82.0 IMPROVED 1975 265000.0 77   1.34183370695987 103.854370726041 214 LOR 8 TOA PAYOH
777498 777498 1997-12 TOA PAYOH 4 ROOM 213 LOR 8 TOA PAYOH 16 TO 18 82.0 IMPROVED 1975 275000.0 77   1.34100493622927 103.85441254396 213 LOR 8 TOA PAYOH
777516 777516 1997-12 TOA PAYOH 5 ROOM 215 LOR 8 TOA PAYOH 19 TO 21 114.0 STANDARD 1975 388000.0 77   1.34182813684783 103.855107925609 215 LOR 8 TOA PAYOH
777517 777517 1997-12 TOA PAYOH 5 ROOM 217 LOR 8 TOA PAYOH 13 TO 15 119.0 STANDARD 1976 405000.0 78   1.34265870846085 103.854665608196 217 LOR 8 TOA PAYOH

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