resale_prices

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

17 rows where month = "2010-09" and street_name = "TAMPINES ST 21"

✎ 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
331774 331774 2010-09 TAMPINES EXECUTIVE 230J TAMPINES ST 21 01 TO 03 150.0 Apartment 1993 518000.0 82   1.3561953607168 103.949663054432 230J TAMPINES ST 21
332359 332359 2010-09 TAMPINES 4 ROOM 239 TAMPINES ST 21 01 TO 03 96.0 New Generation 1984 405000.0 73   1.35477157041693 103.946584056018 239 TAMPINES ST 21
332471 332471 2010-09 TAMPINES 4 ROOM 234 TAMPINES ST 21 04 TO 06 108.0 Model A 1984 431000.0 73   1.35590413566011 103.948024616734 234 TAMPINES ST 21
332472 332472 2010-09 TAMPINES 4 ROOM 265 TAMPINES ST 21 04 TO 06 105.0 Model A 1984 416750.0 73   1.35245349194636 103.950238896388 265 TAMPINES ST 21
332490 332490 2010-09 TAMPINES 4 ROOM 205 TAMPINES ST 21 01 TO 03 104.0 Model A 1983 390000.0 72   1.35171765014011 103.951963085466 205 TAMPINES ST 21
332493 332493 2010-09 TAMPINES 4 ROOM 235 TAMPINES ST 21 04 TO 06 103.0 Model A 1993 406000.0 82   1.35549080919861 103.948259265817 235 TAMPINES ST 21
332512 332512 2010-09 TAMPINES 5 ROOM 256 TAMPINES ST 21 10 TO 12 121.0 Improved 1984 498000.0 73   1.35323572708512 103.949946614899 256 TAMPINES ST 21
332634 332634 2010-09 TAMPINES 3 ROOM 262 TAMPINES ST 21 01 TO 03 74.0 Model A 1984 297000.0 73   1.35375664901938 103.950970398919 262 TAMPINES ST 21
332635 332635 2010-09 TAMPINES 3 ROOM 262 TAMPINES ST 21 04 TO 06 74.0 Model A 1984 320000.0 73   1.35375664901938 103.950970398919 262 TAMPINES ST 21
332647 332647 2010-09 TAMPINES 3 ROOM 206 TAMPINES ST 21 07 TO 09 75.0 Model A 1982 335000.0 71   1.35086005592172 103.952352388168 206 TAMPINES ST 21
332663 332663 2010-09 TAMPINES 3 ROOM 258 TAMPINES ST 21 01 TO 03 72.0 New Generation 1985 302000.0 74   1.35433851523618 103.950029531311 258 TAMPINES ST 21
332664 332664 2010-09 TAMPINES 3 ROOM 231 TAMPINES ST 21 01 TO 03 67.0 New Generation 1985 305000.0 74   1.35594124704072 103.94917043237 231 TAMPINES ST 21
332674 332674 2010-09 TAMPINES 3 ROOM 271 TAMPINES ST 21 04 TO 06 79.0 Model A 1984 330000.0 73   1.34980832347153 103.949577963482 271 TAMPINES ST 21
332675 332675 2010-09 TAMPINES 3 ROOM 234 TAMPINES ST 21 04 TO 06 73.0 Model A 1984 353000.0 73   1.35590413566011 103.948024616734 234 TAMPINES ST 21
332686 332686 2010-09 TAMPINES 3 ROOM 261 TAMPINES ST 21 01 TO 03 74.0 Model A 1984 315000.0 73   1.35430349301699 103.950965476662 261 TAMPINES ST 21
332692 332692 2010-09 TAMPINES 3 ROOM 251 TAMPINES ST 21 10 TO 12 74.0 Model A 1985 335000.0 74   1.35275541922653 103.948119177521 251 TAMPINES ST 21
332702 332702 2010-09 TAMPINES 3 ROOM 207 TAMPINES ST 21 01 TO 03 75.0 Model A 1982 322000.0 71   1.35136271207896 103.952226216363 207 TAMPINES ST 21

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