Attribute und Fakten / Attributes and Facts
| variable | german | english |
|---|---|---|
| te305o_tenure_id | Besitz (id und desc) | tenure |
| te302_objecttype_main_id | Hauptobjektkategorie | main type of surface |
| te302_objecttype_id | Objektkategorie | Object category |
| s_zip | Postleitzahl | Postal code |
| s_city | Ort | City |
| s_street | Strasse | Street |
| s_stnr | Nummer | Number |
| s_nbrooms | Anzahl Zimmer | Number of rooms |
| s_surface_living | Wohnfläche (m2) | Living area (m²) |
| s_surface_usuable | Nutzfläche (m2) | Usable area (m²) |
| s_surface_property | Fläche des Grundstücks (m2) | Plot area (m²) |
| s_floor | Stockwerk | Floor |
| te307o_floor_id | Stockwerk (Kategorie) | Floor (category) |
| s_construction_year | Baujahr | Year of construction |
| te303o_availability_id | Verfügbarkeit (wenn kein Datum) | Availability (when no date) |
| s_availability | Verfügbarkeitsdatum | Availability date |
| s_grossrent | Bruttomiete / Monat | Gross rent / month |
| s_netrent | Nettomiete / Monat | Net rent / month |
| s_rent | Brutto- oder Nettomiete pro Monat (Typ unbekannt) | Gross or net rent per month (type unknown) |
| s_rentextra | Nebenkosten / Monat | Additional costs / month |
| s_salesprice | Verkaufspreise | Sales price |
| te304o_currency_id_salesprice | Währung (analog für “rents”) | Currency (same for "rents") |
| te306o_typeofprice_id_salesprice | Art des Verkaufspreises (analog für “rents”) | Type of sales price (same for "rents") |
| s_lon, | longitude (WGS 84) | Longitude (WGS 84) |
| s_lat | latitude (WGS 84) | Latitude (WGS 84) |
| url | Marktplatz URL | Marketplace URL |
| bfscode | Gemeinde-Code BFS | Municipality Code OFS |
| id | Inserat_id | Ad ID |
| double1group_id | Doppeltengruppe | Duplicate group |
| mpname | Marktplatzname | Marketplace name |
| found_date | erstmals gefunden Datum | First found date |
| last_found_date | aktuellstes gefundenes Datum | Most recent found date |
| double1group_startday | Beginn der Doppeltengruppe | Start of duplicate group |
| double1group_endday | Ende der Doppeltengruppe | End of duplicate group |
| te308o_geoprecision_id | Genauigkeit der Geocodierung | Geocoding accuracy |
| checked_today | Verfügbarkeit an dem Tag überprüft? | Checked on that day? |
| insperiod | Insertionsdauer | Insertion duration |
| metasysid | interner Hash Meta-Sys | Internal hash Meta-Sys |
| m_commercial_json | korrigierte kommerzielle Objekte | Corrected commercial objects |
| fbegin | Beginn der Doppeltengruppe (neue Exporte) | Start of duplicate group (new exports) |
| fend | Ende der Doppeltengruppe (neue Exporte) | End of duplicate group (new exports) |
| info_level | Statuscode des Inserats (siehe Lookup) | Ad status code (see lookup) |
| info_update | Zeitpunkt der letzten Statusänderung | Timestamp of last status change |
Ausstattungsmerkmale (alt) / Features (old)
| characteristic | german | english |
|---|---|---|
| te_a_lift_oc | Lift | Lift |
| te_a_minergie_oc | Minergie | Minergie |
| te_a_neu_stand_oc | Erstbezug | First Occupancy |
| te_a_ofen_oc | Schwedenofen | Swedish Stove |
| te_a_rollst_oc | rollstuhlgängig | Wheelchair accessible |
| te_a_sicht_oc | Sicht | View |
| te_a_balkon_oc | Balkon | Balcony |
| te_a_wintergarten_oc | Wintergarten | Winter garden |
| te_a_garten_oc | Garten | Garden |
| te_a_wasch_oc | Waschmaschine | Washing machine |
| te_a_neu_stand_oc | Erstbezug | First occupancy |
Ausstattungsmerkmale (neu) / Features (new)
| Merkmal | Bezeichnung | english |
|---|---|---|
| buildingLease | Baurecht | Building right |
| buildingVolume | Kubatur | Cubature |
| buildingVolumeType | Kubatur Messgrundlage | Cubature measurement basis |
| elevator | Aufzug | Elevator |
| heatingType | Heizsystem | Heating system |
| minergie | Minergie / Niedrigenergie | Minergie / Low energy |
| newlyBuilt | Neubau | New building |
| numberOfBathrooms | Anzahl Badezimmer | Number of bathrooms |
| numberOfFloors | Anzahl Stockwerke | Number of floors |
| outSideSpace | Aussenraum | Outdoor space |
| parkingInside | Innenparkplatz | Indoor parking |
| parkingOutside | Aussenparkplatz | Outdoor parking |
| photovoltaic | Photovoltaik | Photovoltaics |
| renovationYear | Renovationsjahr | Year of renovation |
| wheelchairSuitable | behindertengerecht | Handicap accessible |
| wintergarden | Wintergarten | Winter garden |
| worthyOfProtection | lookup | Lookup |
| view | lookup | Lookup |
| fireplace | Chemnée / Ofen | Chimney / Stove |
| numberofappartments | Anzahl Wohnungen | Number of apartments |
| numberoftoilets | Anzahl Toiletten | Number of toilets |
| firstuse | Erstbezug | First occupancy |
| swimminpool | Schwimmbad / Schwimmbecken | Swimming pool |
Kontaktdaten
| Merkmal | Beschrieb | english |
|---|---|---|
| agent_name | Agenturname | Agent name |
| agent_zip | Postleitzahl | Postal code |
| agent_place | Ort | City |
| agent_street | Strasse | Street |
| contact_name | Kontaktname | Contact name |
| contact_tel | Kontaktnummer | Contact number |
| viewing_name | Besichtigungsname | Viewing name |
| viewing_tel | Besichtigungsnummer | Viewing number |
Lookups
info_level
| id | description | english |
|---|---|---|
| NULL | Keine Beanstandung | No objection |
| 1 | möglicherweise Fake-Inserat (falscher Preis, Zimmerzahl, Flächen) | Possibly fake ad (implausible price, number of rooms, areas) |
te302_objecttype_main_id and te302_objecttype_id
objecttype_main_id and objecttype_id use the same ids and descriptions. main uses the generic type of a category (in bold).
| id | description | main_id | english |
|---|---|---|---|
| 427 | Bauland | 427 | Building plot |
| 428 | Gewerbebauland | 427 | Commercial building plot |
| 429 | Wohnbauland | 427 | Residential building plot |
| 430 | Haus | 430 | House |
| 431 | Einfamilienhaus | 430 | Single-family house |
| 432 | Schloss | 430 | Castle |
| 433 | Villa | 430 | Villa |
| 434 | freistehendes Einfamilienhaus | 430 | Detached single-family house |
| 435 | Doppeleinfamilienhaus | 430 | Semi-detached house |
| 436 | Reihen-Eckhaus | 430 | Row corner house |
| 437 | Reiheineinfamilienhaus | 430 | Terraced house |
| 438 | Terrassenhaus | 430 | Terrace house |
| 439 | Bauernhaus | 430 | Farmhouse |
| 440 | Stöckli | 430 | Small farmhouse |
| 441 | Chalet | 430 | Chalet |
| 442 | Rustico | 430 | Rustic house |
| 443 | Mehrfamilienhaus | 430 | Multi-family house |
| 444 | Wohn- und Geschäftshaus | 430 | Residential and commercial building |
| 445 | Wohnung | 445 | Apartment |
| 446 | Attikawohnung | 445 | Penthouse apartment |
| 447 | Maisonettewohnung | 445 | Duplex apartment |
| 448 | Terrassenwohnung | 445 | Terrace apartment |
| 449 | Loft | 445 | Loft |
| 450 | Dachwohnung | 445 | Attic apartment |
| 451 | Mansarde | 445 | Attic room |
| 452 | Einliegerwohnung | 445 | Granny flat |
| 453 | Studio | 445 | Studio |
| 454 | Einzimmerwohnung | 445 | One-room apartment |
| 455 | WG-Zimmer | 445 | Shared flat room |
| 456 | Einzelzimmer | 445 | Single room |
| 457 | Möblierte Wohnung | 445 | Furnished apartment |
| 459 | Heim | 445 | Home |
| 460 | Altersheim | 445 | Retirement home |
| 461 | Pflegeheim | 445 | Nursing home |
| 462 | Gewerbe | 462 | Commercial |
| 463 | Werkstatt | 462 | Workshop |
| 464 | Atelier | 462 | Studio |
| 465 | Fabrik | 462 | Factory |
| 466 | Industriegebäude | 462 | Industrial building |
| 467 | Büro | 462 | Office |
| 468 | Kaufhaus | 462 | Department store |
| 469 | Laden | 462 | Shop |
| 470 | Arkade | 462 | Arcade |
| 471 | Lager | 462 | Warehouse |
| 472 | Praxis | 462 | Practice |
| 473 | Labor | 462 | Laboratory |
| 474 | Kiosk | 462 | Kiosk |
| 475 | Käserei | 462 | Cheese dairy |
| 476 | Coiffeursalon | 462 | Hair salon |
| 477 | Schreinerei | 462 | Carpentry |
| 478 | Bäckerei | 462 | Bakery |
| 479 | Gärtnerei | 462 | Nursery |
| 480 | Metzgerei | 462 | Butchery |
| 481 | Autowerkstatt | 462 | Car workshop |
| 482 | Tankstelle | 462 | Gas station |
| 483 | Schulung | 462 | Training center |
| 484 | Unterhaltungsstätte | 462 | Entertainment venue |
| 485 | Restaurant | 462 | Restaurant |
| 486 | Café | 462 | Café |
| 487 | Bar | 462 | Bar |
| 488 | Club | 462 | Club |
| 489 | Hotel | 462 | Hotel |
| 490 | Camping | 462 | Camping |
| 491 | Sauna | 462 | Sauna |
| 492 | Solarium | 462 | Solarium |
| 493 | Landwirtschaft | 462 | Agriculture |
| 494 | Büro und Gewerbe in einem Inserat | 462 | Office and commercial in one listing |
| 495 | Büro; Gewerbe und Lager in einem Inserat | 462 | Office, commercial, and warehouse in one listing |
| 496 | Büro und Laden in einem Inserat | 462 | Office and shop in one listing |
| 497 | Büro; Laden und Gewerbe in einem Inserat | 462 | Office, shop, and commercial in one listing |
| 498 | Büro; Laden; Gewerbe und Lager in einem Inserat | 462 | Office, shop, commercial, and warehouse in one listing |
| 499 | Büro; Laden und Lager in einem Inserat | 462 | Office, shop, and warehouse in one listing |
| 500 | Büro und Lager in einem Inserat | 462 | Office and warehouse in one listing |
| 501 | Büro und Praxis in einem Inserat | 462 | Office and practice in one listing |
| 502 | Gewerbe und Lager in einem Inserat | 462 | Commercial and warehouse in one listing |
| 503 | Laden und Gewerbe in einem Inserat | 462 | Shop and commercial in one listing |
| 504 | Laden und Lager in einem Inserat | 462 | Shop and warehouse in one listing |
| 505 | Parkplatz | 505 | Parking space |
| 506 | Garage mit zwei Stellplätzen | 505 | Garage with two spaces |
| 507 | Garage mit einem Stellplatz | 505 | Garage with one space |
| 508 | Parkplatz für Motorrad, ungedeckt | 505 | Uncovered motorcycle parking |
| 509 | Garage | 505 | Garage |
| 510 | gedeckter Parkplatz | 505 | Covered parking |
| 511 | parkplatz für Motorrad in einer Halle | 505 | Motorcycle parking in a hall |
| 512 | ungedeckter Parkplatz | 505 | Uncovered parking |
| 513 | Parkplatz in Tiefgarage | 505 | Parking in underground garage |
| 514 | diverse | 514 | Miscellaneous |
| 515 | Estrichabteil | 514 | Attic compartment |
| 516 | Hobbyraum | 514 | Hobby room |
| 517 | Kellerabteil | 514 | Cellar compartment |
| 518 | Partyraum | 514 | Party room |
| 519 | Schaufenster | 514 | Showcase window |
| 520 | Schrebergarten | 514 | Allotment garden |
| 521 | Stallbox | 514 | Stable box |
| 522 | Tennisplatz | 514 | Tennis court |
| 523 | Sportanlage | 514 | Sports facility |
| 524 | Unterstand | 514 | Shed |
| 525 | Werbefläche | 514 | Advertising space |
| 526 | Reithalle | 514 | Riding hall |
te305o_tenure_id
| id | description | english |
|---|---|---|
| 413 | Miete | rent |
| 414 | Kauf | sale |
te303o_availability_id
| id | description | english |
|---|---|---|
| 89 | sofort | immediately |
| 90 | nach Vereinbarung | by arrangement |
| 91 | festgelegtes Datum | fixed data |
te304o_currency_id_salesprice
| id | description | english |
|---|---|---|
| 415 | Franken | Swiss Francs |
| 416 | Anfrage | upon request |
| 417 | Dollar | US Dollar |
| 418 | Euro | Euro |
te306o_typeofprice_id_salesprice
| id | description | english |
|---|---|---|
| 407 | übrige | Other |
| 408 | jährlich | Annually |
| 409 | jährlich pro Quadratmeter | Annually per square meter |
| 410 | monatlich | Monthly |
| 411 | auf Anfrage | On request |
| 412 | einmalig | One-time |
| 414 | Verkaufspreis / m2 | Sales price / m² |
te307o_floor_id
| id | description | english |
|---|---|---|
| 200 | Untergeschoss | Basement |
| 211 | unteres Erdgeschoss | Lower ground floor |
| 212 | oberes Erdgeschoss | Upper ground floor |
| 404 | Dachgeschoss | Attic |
| 405 | Attika | Penthouse |
| 406 | Hochparterre | Raised ground floor |
| 403 | Obergeschoss (allgemein) | Upper floor (general) |
te308o_geoprecision_id
| id | description | english |
|---|---|---|
| 177 | exakte Adresse | Exact address |
| 178 | Adresse, interpoliert | Address, interpolated |
| 179 | Strasse | Street |
| 180 | spezifisches Objekt | Specific object |
| 181 | Postleitzahl | Postal code |
| 182 | Gemeinde | Municipality |
| 183 | übrige | Other |
| 184 | Error | Error |
| 185 | exakte Adresse2 (The google API result we got is not exactly the same as our street name or house number, but it could still be the same house or nearby) | Exact address2 (The Google API result we got is not exactly the same as our street name or house number, but it could still be the same house or nearby) |
Ausstattungsmerkmale (ab 2004) / Features (since 2004)
-1, 0: Merkmal nicht vorhanden; > 0: Merkmal vorhanden
| Merkmal | Code | Description | english |
|---|---|---|---|
| te_a_autoab1_oc | -1 / 99 | unbekannt | Unknown |
| te_a_autoab1_oc | 0 | nicht vorhanden | Not available |
| te_a_autoab1_oc | 1 | Parkplatz vorhanden | Parking available |
| te_a_autoab1_oc | 2 | ged. Aus.plz nicht in Bruttomiete | Covered parking not included in gross rent |
| te_a_autoab1_oc | 3 | ged. Aus.plz in Bruttomiete | Covered parking included in gross rent |
| te_a_autoab1_oc | 4 | unged. Aus.plz nicht in Bruttomiete | Uncovered parking not included in gross rent |
| te_a_autoab1_oc | 5 | unged. Aus.plz in Bruttomiete | Uncovered parking included in gross rent |
| te_a_autoab1_oc | 6 | ged. vorh. nicht verfügbar | Covered parking available but not usable |
| te_a_autoab1_oc | 7 | unged. vorh. nicht verfügbar | Uncovered parking available but not usable |
| te_a_autoab2_oc | -1 / 99 | unbekannt | Unknown |
| te_a_autoab2_oc | 0 | nicht vorhanden | Not available |
| te_a_autoab2_oc | 1 | Garagenplatz vorhanden | Garage space available |
| te_a_autoab2_oc | 2 | Gar.plz nicht in Bruttomiete | Garage space not included in gross rent |
| te_a_autoab2_oc | 3 | Gar.plz in Bruttomiete | Garage space included in gross rent |
| te_a_autoab2_oc | 4 | G'platz vorh. nicht verfügbar | Garage space available but not usable |
| te_a_balkon_oc | 1 | allgemein | General |
| te_a_balkon_oc | 3 | grosser Balkon | Large balcony |
| te_a_balkon_oc | 0 | keine | None |
| te_a_balkon_oc | 5 | Dachterrasse | Roof terrace |
| te_a_balkon_oc | 2 | kleiner Balkon (< 2m) | Small balcony (< 2m) |
| te_a_balkon_oc | 4 | Terrasse | Terrace |
| te_a_balkon_oc | -1 / 99 | unbekannt | Unknown |
| te_a_garten_oc | 0 | nicht vorhanden | Not available |
| te_a_garten_oc | -1 / 99 | unbekannt | Unknown |
| te_a_garten_oc | 1 | vorhanden, privat nutzbar | Available, privately usable |
| te_a_garten_oc | 2 | vorhanden, gemeinsam nutzbar | Available, shared use |
| te_a_garten_oc | 3 | Gartensitzplatz | Garden seating area |
| te_a_lift_oc | 0 | nicht vorhanden | Not available |
| te_a_lift_oc | -1 / 99 | unbekannt | Unknown |
| te_a_lift_oc | 1 | vorhanden | Available |
| te_a_minergie_oc | 1 | ja | Yes |
| te_a_minergie_oc | -1 / 99 | unbekannt | Unknown |
| te_a_minergie_oc | 0 | nein | No |
| te_a_minergie_oc | 1 | ja | Yes |
| te_a_neu_stand_oc | -1 / 99 | kein Neubau, Sanierung | Not a new building, renovation |
| te_a_neu_stand_oc | 5 | Erstvermietung | First rental |
| te_a_ofen_oc | 0 | nicht vorhanden | Not available |
| te_a_ofen_oc | -1 / 99 | unbekannt | Unknown |
| te_a_ofen_oc | 1 | vorhanden | Available |
| te_a_ofen_oc | 2 | Anschluss vorhanden | Connection available |
| te_a_rollst_oc | 1 | ja | Yes |
| te_a_rollst_oc | 0 | nein | No |
| te_a_rollst_oc | -1 / 99 | unbekannt | Unknown |
| te_a_sicht_oc | 1 | allgemein | General |
| te_a_sicht_oc | 5 | Andere (nicht See / Berg) | Other (not lake / mountain) |
| te_a_sicht_oc | 3 | auf den See | View of the lake |
| te_a_sicht_oc | 4 | Berg und See | Mountain and lake view |
| te_a_sicht_oc | 2 | in die Berge | Mountain view |
| te_a_sicht_oc | 0 | keine | None |
| te_a_sicht_oc | -1 / 99 | unbekannt | Unknown |
| te_a_wasch_oc | 1 | vorhanden | Available |
| te_a_wasch_oc | 0 | nicht vorhanden | Not available |
| te_a_wasch_oc | -1 / 99 | unbekannt | Unknown |
| te_a_wasch_oc | 2 | nur Anschluss in Wohnung | Connection only in apartment |
| te_a_wintergarten_oc | 0 | nicht vorhanden | Not available |
| te_a_wintergarten_oc | -1 / 99 | unbekannt | Unknown |
| te_a_wintergarten_oc | 1 | vorhanden | Available |
Ausstattungsmerkmale (ab Mitte 2021) / Features (after mid 2021)
| Merkmal | Description | english |
|---|---|---|
| buildingVolumeType | Gebäudeversicherung | Building insurance |
| buildingVolumeType | SIA | SIA |
| elevator | vorhanden | Available |
| elevator | Personenlift | Passenger lift |
| elevator | Warenlift | Goods lift |
| elevator | Personen- und Warenlift | Passenger and goods lift |
| heatingType | Öl | Oil |
| heatingType | Gas | Gas |
| heatingType | Wärmepumpe | Heat pump |
| heatingType | Wärmepumpe Luft | Air-source heat pump |
| heatingType | Wärmepumpe Boden | Ground-source heat pump |
| heatingType | Fernwärme | District heating |
| heatingType | Pellets | Pellets |
| heatingType | Holz | Wood |
| heatingType | Kombination | Combination |
| heatingType | other | Other |
| minergie | Niedrigenergie-Bauweise | Low-energy construction |
| minergie | Minergie-Bauweise | Minergie construction |
| minergie | Minergie zertifiziert | Minergie certified |
| minergie | Minergie-P | Minergie-P |
| minergie | Minergie-P Eco | Minergie-P Eco |
| minergie | Minergie-A | Minergie-A |
| minergie | Minergie-A Eco | Minergie-A Eco |
| outSideSpace | vorhanden | Available |
| outSideSpace | Balkon | Balcony |
| outSideSpace | Terrasse | Terrace |
| outSideSpace | Gartensitzplatz | Garden seating area |
| outSideSpace | Garten | Garden |
| worthyOfProtection | schützenswert | Heritage-protected |
| worthyOfProtection | unter Denkmalschutz | Under monument protection |
| view | vorhanden | Available |
| view | Seesicht | Lake view |
| view | Bergsicht | Mountain view |
| view | See- und Bergsicht | Lake and mountain view |
| view | Fernsicht | Panoramic view |
