Real Estate

Singapore CEA Agent Transaction Records

Every residential deal closed by a CEA-registered salesperson since January 2017 — salesperson name and registration number, month, property type (HDB, condo, EC, landed), sale or rental, which party the agent represented, and the HDB town or private postal district.

sg-cea-transactionsreal-estatesingaporeagentsceatransactionsbrokersopen-data

0 rows in the dataset

Download the dataset

Get every row this scraper has collected as one CSV or JSONL file. If the data is older than maxAgeHours, the scraper is re-run with its configured settings first. The key needs the datasets:export scope.

DOWNLOAD_ID=$(curl -s -X POST "https://api.pandorlabs.com/v1/datasets/sg-cea-transactions/downloads" \  -H "Authorization: Bearer $PANDORLABS_KEY" \  -H "Content-Type: application/json" \  -d '{"maxAgeHours":24,"format":"csv"}' | jq -r '.id')while true; do  STATUS=$(curl -s "https://api.pandorlabs.com/v1/downloads/$DOWNLOAD_ID" \    -H "Authorization: Bearer $PANDORLABS_KEY" | jq -r '.status')  [ "$STATUS" != "refreshing" ] && break  sleep 5donecurl -s "https://api.pandorlabs.com/v1/downloads/$DOWNLOAD_ID/file" \  -H "Authorization: Bearer $PANDORLABS_KEY" \  -o dataset.csv

The rate is 1 credit per 100 rows cached and 2 credits live, charged on the rows in the dataset when the download becomes ready. A failed refresh is not charged. The file stays downloadable for 24 hours. See pricing.

Start a run

To choose the targets yourself, send the parameters below as input. The call returns 202 with the run; the key needs the scrapers:run scope and the account a positive credit balance.

curl -X POST "https://api.pandorlabs.com/v1/scrapers/sg-cea-transactions/runs" \  -H "Authorization: Bearer $PANDORLABS_KEY" \  -H "Content-Type: application/json" \  -d '{    "input": {      "datasetIds": [        "d_8b84c4ee58e3cfc0ece0d773c8ca6abc"      ],      "maxItems": 5000000    }  }'

A run is billed at the live rate once it finishes: 2 credits per 100 rows it collected. A run that collects nothing costs nothing.

Parameters

Every parameter is optional. Anything you leave out uses the default shown here; an unknown name or an invalid value is rejected with a 400 that lists each problem.

Advanced

datasetIds
string[]
Only these data.gov.sg datasets
Empty pulls data.gov.sg collection 55 (CEA Salespersons' Property Transaction Records, residential, Jan 2017 onwards).
Default
none
Example
d_8b84c4ee58e3cfc0ece0d773c8ca6abc
maxItems
number
Max rows per run
Default
5000000
Range
1 to 5000000

Input as JSON Schema

The same schema the API validates against. Use it as a tool input schema or to generate a typed client.

inputSchema

{  "type": "object",  "additionalProperties": false,  "properties": {    "datasetIds": {      "type": "array",      "items": {        "type": "string"      },      "maxItems": 1000,      "title": "Only these data.gov.sg datasets",      "description": "Empty pulls data.gov.sg collection 55 (CEA Salespersons' Property Transaction Records, residential, Jan 2017 onwards).",      "default": [],      "examples": [        "d_8b84c4ee58e3cfc0ece0d773c8ca6abc"      ]    },    "maxItems": {      "type": "number",      "minimum": 1,      "maximum": 5000000,      "title": "Max rows per run",      "default": 5000000    }  }}

Run, poll, read rows

The run is asynchronous. Poll it until it reaches a terminal status and its billing is paid, then page through its rows. Until then the rows endpoint answers 409 (still queued or running) or 402 (payment required).

RUN_ID=$(curl -s -X POST "https://api.pandorlabs.com/v1/scrapers/sg-cea-transactions/runs" \  -H "Authorization: Bearer $PANDORLABS_KEY" \  -H "Content-Type: application/json" \  -d '{    "input": {      "datasetIds": [        "d_8b84c4ee58e3cfc0ece0d773c8ca6abc"      ],      "maxItems": 5000000    }  }' | jq -r '.id')while true; do  RUN=$(curl -s "https://api.pandorlabs.com/v1/runs/$RUN_ID" \    -H "Authorization: Bearer $PANDORLABS_KEY")  STATUS=$(echo "$RUN" | jq -r '.status')  BILLING=$(echo "$RUN" | jq -r '.billing.status')  case "$STATUS" in queued|running) ;; *) [ "$BILLING" != "pending" ] && break ;; esac  sleep 5doneecho "$RUN" | jq '{status, rowCount, billing}'curl -s "https://api.pandorlabs.com/v1/runs/$RUN_ID/rows?page=1&limit=100" \  -H "Authorization: Bearer $PANDORLABS_KEY"

See the API reference for pagination, cancelling and listing runs.

Output fields

Rows have no fixed schema; these are the fields observed in the rows collected so far. Coverage is the share of rows where the field is present.

No rows collected yet, so no fields have been observed. Run the scraper once and they will appear here.