resale_prices

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

14 rows where month = "1997-03" 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
803322 803322 1997-03 TOA PAYOH 4 ROOM 219 LOR 8 TOA PAYOH 07 TO 09 82.0 IMPROVED 1978 320000.0 80   1.3427643319014 103.855872559307 219 LOR 8 TOA PAYOH
803323 803323 1997-03 TOA PAYOH 4 ROOM 219 LOR 8 TOA PAYOH 13 TO 15 82.0 IMPROVED 1978 294000.0 80   1.3427643319014 103.855872559307 219 LOR 8 TOA PAYOH
803324 803324 1997-03 TOA PAYOH 4 ROOM 219 LOR 8 TOA PAYOH 10 TO 12 82.0 IMPROVED 1978 318000.0 80   1.3427643319014 103.855872559307 219 LOR 8 TOA PAYOH
803325 803325 1997-03 TOA PAYOH 4 ROOM 228 LOR 8 TOA PAYOH 13 TO 15 82.0 IMPROVED 1976 300000.0 78   1.33914880025231 103.858779661838 228 LOR 8 TOA PAYOH
803326 803326 1997-03 TOA PAYOH 4 ROOM 227 LOR 8 TOA PAYOH 13 TO 15 82.0 IMPROVED 1976 335000.0 78   1.33951514445795 103.857970837281 227 LOR 8 TOA PAYOH
803327 803327 1997-03 TOA PAYOH 4 ROOM 221 LOR 8 TOA PAYOH 13 TO 15 82.0 IMPROVED 1976 300000.0 78   1.34262180790845 103.856971772685 221 LOR 8 TOA PAYOH
803328 803328 1997-03 TOA PAYOH 4 ROOM 220 LOR 8 TOA PAYOH 01 TO 03 82.0 IMPROVED 1976 293000.0 78   1.34261673404284 103.856454868244 220 LOR 8 TOA PAYOH
803370 803370 1997-03 TOA PAYOH 3 ROOM 232 LOR 8 TOA PAYOH 04 TO 06 65.0 IMPROVED 1976 200000.0 78   1.3375718690811 103.858843935428 232 LOR 8 TOA PAYOH
803372 803372 1997-03 TOA PAYOH 3 ROOM 231 LOR 8 TOA PAYOH 07 TO 09 76.0 IMPROVED 1976 230000.0 78   1.33696011414514 103.859489719839 231 LOR 8 TOA PAYOH
803373 803373 1997-03 TOA PAYOH 3 ROOM 225 LOR 8 TOA PAYOH 10 TO 12 65.0 IMPROVED 1976 200000.0 78   1.33950922302573 103.85564679729 225 LOR 8 TOA PAYOH
803438 803438 1997-03 TOA PAYOH 4 ROOM 213 LOR 8 TOA PAYOH 10 TO 12 82.0 IMPROVED 1975 300000.0 77   1.34100493622927 103.85441254396 213 LOR 8 TOA PAYOH
803443 803443 1997-03 TOA PAYOH 5 ROOM 224 LOR 8 TOA PAYOH 25 TO 27 114.0 STANDARD 1976 420000.0 78   1.34117607884148 103.85606624411 224 LOR 8 TOA PAYOH
803444 803444 1997-03 TOA PAYOH 5 ROOM 218 LOR 8 TOA PAYOH 16 TO 18 119.0 STANDARD 1978 465000.0 80   1.34272583549089 103.855151579728 218 LOR 8 TOA PAYOH
803453 803453 1997-03 TOA PAYOH 5 ROOM 215 LOR 8 TOA PAYOH 10 TO 12 117.0 STANDARD 1975 440000.0 77   1.34182813684783 103.855107925609 215 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]);