resale_prices

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

8 rows where month = "2020-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
124638 124638 2020-12 TOA PAYOH 5 ROOM 229 LOR 8 TOA PAYOH 16 TO 18 114.0 Standard 1976 515000.0 54 54 years 09 months 1.3387183120625 103.85919463592 229 LOR 8 TOA PAYOH
124644 124644 2020-12 TOA PAYOH 5 ROOM 229 LOR 8 TOA PAYOH 13 TO 15 117.0 Standard 1976 510000.0 54 54 years 09 months 1.3387183120625 103.85919463592 229 LOR 8 TOA PAYOH
124647 124647 2020-12 TOA PAYOH 4 ROOM 219 LOR 8 TOA PAYOH 04 TO 06 82.0 Improved 1978 330000.0 56 56 years 02 months 1.3427643319014 103.855872559307 219 LOR 8 TOA PAYOH
124648 124648 2020-12 TOA PAYOH 4 ROOM 219 LOR 8 TOA PAYOH 16 TO 18 82.0 Improved 1978 350000.0 56 56 years 02 months 1.3427643319014 103.855872559307 219 LOR 8 TOA PAYOH
124655 124655 2020-12 TOA PAYOH 5 ROOM 224 LOR 8 TOA PAYOH 10 TO 12 114.0 Standard 1976 520000.0 54 54 years 04 months 1.34117607884148 103.85606624411 224 LOR 8 TOA PAYOH
124663 124663 2020-12 TOA PAYOH 4 ROOM 222 LOR 8 TOA PAYOH 10 TO 12 82.0 Improved 1976 339000.0 54 54 years 04 months 1.34177310664554 103.856039796964 222 LOR 8 TOA PAYOH
124669 124669 2020-12 TOA PAYOH 4 ROOM 226 LOR 8 TOA PAYOH 16 TO 18 82.0 Improved 1976 360000.0 54 54 years 06 months 1.33951566601807 103.857051021906 226 LOR 8 TOA PAYOH
124692 124692 2020-12 TOA PAYOH 3 ROOM 232 LOR 8 TOA PAYOH 07 TO 09 65.0 Improved 1976 252000.0 55 55 years 1.3375718690811 103.858843935428 232 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]);