- query
- The OLX search URL you submitted, repeated on every row that came from it.
- id
- OLX’s own identifier for the listing.
- author_title
- The seller’s display name as OLX shows it.
- author_id
- OLX’s identifier for the seller account, which is what you group by to find everything one seller has listed.
- company_name
- The trading name where the seller has one. Do not treat this as a mirror of
business - the two do not track each other reliably in either direction. - is_phone_viewable
- Whether OLX exposes a phone number on the listing - the lowercase strings
yes and no. - author_member_since
- The date the seller’s account was created, as
YYYY-MM-DD. A rough proxy for how established they are. - listing_url
- Link to the offer. Identical to
url on every row we have seen - the two are a duplicate pair, so pick one and ignore the other. - title
- The listing title as the seller wrote it.
- description
- The listing body text.
- business
- Whether the listing is from a trader rather than a private seller - the lowercase strings
yes and no. - location_city_id
- OLX’s numeric id for the city.
- location_city_name
- The city name as displayed.
- location_city_normalized_name
- The normalised form of the city name - the one to join on, since the displayed name carries local spelling and diacritics.
- location_region_id
- OLX’s numeric id for the region.
- location_region_name
- The region name as displayed.
- location_region_normalized_name
- The normalised form of the region name.
- images
- Every image URL in one string, joined by a semicolon and a space - not an array. Split on
"; " to get the list. - price
- The asking price as a bare number in a string - no symbol and no thousands separator. The unit is in the next column, not this one.
- currency
- The currency the price is quoted in. Read this per row. A single search on one national site returned prices in more than one currency, so inferring it from the domain will give you wrong numbers.
- phones
- Intended for the seller’s phone number.
- location_district_id
- OLX’s numeric id for the district, where the listing has one.
- location_district_name
- The district name, where the listing has one.
- location
- The combined location string as OLX displays it, typically city and region together. The split columns above are the same information, already separated.
- date
- When the listing was posted, as
YYYY-MM-DD. A real date - no arithmetic against your run date required. - url
- Link to the offer. The duplicate of
listing_url. - image
- The first image URL - the same value as the first entry in
images. - details
- The category-specific spec line OLX prints under the title, as free text - a vehicle listing gives something like
150 000 km · 2022. It varies by category and carries trailing whitespace, so trim it before parsing.