resale_prices

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

7 rows where month = "2022-02", street_name = "PASIR RIS ST 51" and town = "PASIR RIS"

✎ 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
89763 89763 2022-02 PASIR RIS 4 ROOM 526B PASIR RIS ST 51 10 TO 12 93.0 Model A 2015 580000.0 92 92 years 06 months 1.36789275657772 103.947032722415 526B PASIR RIS ST 51
89776 89776 2022-02 PASIR RIS 5 ROOM 554 PASIR RIS ST 51 07 TO 09 123.0 Improved 1992 585000.0 69 69 years 10 months 1.36821459742728 103.953145772884 554 PASIR RIS ST 51
89907 89907 2022-02 PASIR RIS 5 ROOM 567 PASIR RIS ST 51 07 TO 09 123.0 Improved 1992 625000.0 69 69 years 11 months 1.36899342078075 103.949117873932 567 PASIR RIS ST 51
89912 89912 2022-02 PASIR RIS 4 ROOM 524B PASIR RIS ST 51 10 TO 12 93.0 Model A 2015 595000.0 92 92 years 05 months 1.37093178459665 103.947562573809 524B PASIR RIS ST 51
89917 89917 2022-02 PASIR RIS 5 ROOM 564 PASIR RIS ST 51 07 TO 09 122.0 Improved 1992 610000.0 69 69 years 10 months 1.36848441086802 103.949822073989 564 PASIR RIS ST 51
89951 89951 2022-02 PASIR RIS 2 ROOM 527C PASIR RIS ST 51 13 TO 15 47.0 Model A 2015 315000.0 92 92 years 06 months 1.36937329925111 103.947970231713 527C PASIR RIS ST 51
90116 90116 2022-02 PASIR RIS EXECUTIVE 544 PASIR RIS ST 51 04 TO 06 144.0 Apartment 1992 868000.0 69 69 years 11 months 1.36898105704567 103.952193730257 544 PASIR RIS ST 51

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