Rental bonds

Housing type:

  • - F: Flat/unit
  • - H: House
  • - T: Terrace/townhouse/semi-detached
  • - O: Other
  • - U Unknown. Dwelling Type of ‘Other’ may include rented rooms, garages and car spaces.

For the `Bedrooms` a 0 may indicate a bedsitter or studio apartment, or rented premises such as a garage or car space.

Data source: NSW Fair Trading

1 row where Bedrooms = 7, "Lodgement Date" is on date 2017-04-05 and Weekly Rent = 500

✎ View and edit SQL

This data as json, CSV (advanced)

Dwelling Type 1

  • H 1

Bedrooms 1

Link rowid ▼ Lodgement Date Postcode Dwelling Type Bedrooms Weekly Rent
1387312 1387312 2017-04-05 2163 H 7 500

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "rentals" (
   [Lodgement Date] TEXT,
   [Postcode] TEXT,
   [Dwelling Type] TEXT,
   [Bedrooms] INTEGER,
   [Weekly Rent] INTEGER
);
CREATE INDEX [idx_rentals_Bedrooms]
    ON [rentals] ([Bedrooms]);
CREATE INDEX [idx_rentals_Dwelling Type]
    ON [rentals] ([Dwelling Type]);