resale_prices

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

10 rows where month = "2010-09" and street_name = "TAMPINES ST 71"

✎ 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
335157 335157 2010-09 TAMPINES 4 ROOM 713 TAMPINES ST 71 07 TO 09 99.0 Model A 1997 415000.0 86   1.35923911935801 103.937651630413 713 TAMPINES ST 71
335178 335178 2010-09 TAMPINES 4 ROOM 702 TAMPINES ST 71 13 TO 15 100.0 Model A 1997 460000.0 86   1.3561725371375 103.937479923002 702 TAMPINES ST 71
335204 335204 2010-09 TAMPINES 4 ROOM 708 TAMPINES ST 71 10 TO 12 100.0 Model A 1997 433000.0 86   1.35799200738946 103.936892456311 708 TAMPINES ST 71
335243 335243 2010-09 TAMPINES 4 ROOM 707 TAMPINES ST 71 10 TO 12 100.0 Model A 1997 421000.0 86   1.35764787544338 103.936890975709 707 TAMPINES ST 71
335296 335296 2010-09 TAMPINES 4 ROOM 714 TAMPINES ST 71 13 TO 15 100.0 Model A 1997 427000.0 86   1.36005190110954 103.937142900774 714 TAMPINES ST 71
335300 335300 2010-09 TAMPINES 5 ROOM 715 TAMPINES ST 71 13 TO 15 119.0 Improved 1997 486000.0 86   1.35955696952682 103.937031845348 715 TAMPINES ST 71
335301 335301 2010-09 TAMPINES 5 ROOM 715 TAMPINES ST 71 01 TO 03 120.0 Improved 1997 458000.0 86   1.35955696952682 103.937031845348 715 TAMPINES ST 71
335302 335302 2010-09 TAMPINES 5 ROOM 706 TAMPINES ST 71 04 TO 06 120.0 Improved 1997 490000.0 86   1.35750385698395 103.937559746526 706 TAMPINES ST 71
335303 335303 2010-09 TAMPINES 5 ROOM 729 TAMPINES ST 71 10 TO 12 124.0 Improved 1997 525000.0 86   1.35644099036712 103.934139023776 729 TAMPINES ST 71
335304 335304 2010-09 TAMPINES 5 ROOM 733 TAMPINES ST 71 01 TO 03 123.0 Improved 1997 490000.0 86   1.3578245820795 103.933874048097 733 TAMPINES ST 71

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