resale_prices

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

13 rows where month = "2021-04", 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
112194 112194 2021-04 PASIR RIS 5 ROOM 526D PASIR RIS ST 51 01 TO 03 113.0 Improved 2015 615000.0 93 93 years 03 months 1.36866830502329 103.947274003279 526D PASIR RIS ST 51
112234 112234 2021-04 PASIR RIS 5 ROOM 525B PASIR RIS ST 51 10 TO 12 113.0 Improved 2015 675000.0 93 93 years 03 months 1.3695904828869 103.947455951519 525B PASIR RIS ST 51
112240 112240 2021-04 PASIR RIS 5 ROOM 526D PASIR RIS ST 51 04 TO 06 113.0 Improved 2015 643888.0 93 93 years 04 months 1.36866830502329 103.947274003279 526D PASIR RIS ST 51
112248 112248 2021-04 PASIR RIS 5 ROOM 524A PASIR RIS ST 51 13 TO 15 113.0 Improved 2015 694000.0 93 93 years 04 months 1.37127969347365 103.94771493702 524A PASIR RIS ST 51
112253 112253 2021-04 PASIR RIS 5 ROOM 553 PASIR RIS ST 51 13 TO 15 122.0 Improved 1992 555000.0 70 70 years 09 months 1.36797542087548 103.952769233953 553 PASIR RIS ST 51
112255 112255 2021-04 PASIR RIS 4 ROOM 527A PASIR RIS ST 51 04 TO 06 93.0 Model A 2015 540000.0 93 93 years 03 months 1.36842293498041 103.947593701801 527A PASIR RIS ST 51
112258 112258 2021-04 PASIR RIS 4 ROOM 528B PASIR RIS ST 51 04 TO 06 93.0 Model A 2015 535000.0 93 93 years 04 months 1.37062340418468 103.948163757719 528B PASIR RIS ST 51
112259 112259 2021-04 PASIR RIS 5 ROOM 557 PASIR RIS ST 51 04 TO 06 123.0 Improved 1993 565000.0 71 71 years 04 months 1.36702531507779 103.952134572584 557 PASIR RIS ST 51
112260 112260 2021-04 PASIR RIS 4 ROOM 526C PASIR RIS ST 51 07 TO 09 93.0 Model A 2015 517000.0 93 93 years 03 months 1.36829430551953 103.947266008776 526C PASIR RIS ST 51
112261 112261 2021-04 PASIR RIS 4 ROOM 526A PASIR RIS ST 51 07 TO 09 93.0 Model A 2015 515000.0 93 93 years 03 months 1.36754162355292 103.947105433712 526A PASIR RIS ST 51
112269 112269 2021-04 PASIR RIS 4 ROOM 526A PASIR RIS ST 51 04 TO 06 93.0 Model A 2015 485000.0 93 93 years 03 months 1.36754162355292 103.947105433712 526A PASIR RIS ST 51
112275 112275 2021-04 PASIR RIS 4 ROOM 569 PASIR RIS ST 51 07 TO 09 104.0 Model A 1992 488000.0 70 70 years 08 months 1.36965312318782 103.949169331019 569 PASIR RIS ST 51
112282 112282 2021-04 PASIR RIS 4 ROOM 558 PASIR RIS ST 51 04 TO 06 104.0 Model A 1993 440000.0 71 71 years 04 months 1.3668025831206 103.951713028603 558 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]);