​
Overview

The SG Cars Trends API provides access to structured data about Singapore’s automotive market. This guide explains the core data models and their relationships.

​
Core Data Models

​
Car Registration Data

Car registration data represents monthly vehicle registration statistics by manufacturer, fuel type, and vehicle type. 
{
  "month": "2024-01",
  "make": "Toyota",
  "fuel_type": "Petrol",
  "vehicle_type": "Passenger Cars",
  "number": 245
}

​
Fields

FieldTypeDescriptionExample
monthstringRegistration month in YYYY-MM format"2024-01"
makestringVehicle manufacturer/brand"Toyota"
fuel_typestringType of fuel used"Petrol"
vehicle_typestringCategory of vehicle"Passenger Cars"
numberintegerNumber of registrations245

​
Fuel Types

Petrol

Traditional gasoline-powered vehicles

Diesel

Diesel-powered vehicles

Electric

Battery electric vehicles (BEV)

Hybrid

Petrol-electric hybrid vehicles

Others

Alternative fuel types (CNG, LPG, etc.)

​
Vehicle Types

Passenger Cars

Standard passenger vehicles

Goods & Other Vehicles

Commercial and utility vehicles

Motorcycles & Scooters

Two-wheeled vehicles

Buses

Public and private buses

Taxis

Licensed taxi vehicles

Rental Cars

Car rental fleet vehicles

​
COE Bidding Data

Certificate of Entitlement (COE) bidding data represents the results of Singapore’s vehicle quota auction system. 
{
  "month": "2024-01",
  "bidding_no": 1,
  "vehicle_class": "Category A",
  "quota": 1000,
  "bids_success": 950,
  "bids_received": 1200,
  "premium": 85000
}

​
Fields

FieldTypeDescriptionExample
monthstringBidding month in YYYY-MM format"2024-01"
bidding_nointegerBidding exercise number (1 or 2)1
vehicle_classstringCOE category"Category A"
quotaintegerNumber of COEs available1000
bids_successintegerNumber of successful bids950
bids_receivedintegerTotal bids received1200
premiumintegerWinning bid amount in SGD85000

​
COE Categories

Category A

Cars with engine capacity ≤ 1600cc and maximum power ≤ 130 bhp

Category B

Cars with engine capacity > 1600cc or maximum power > 130 bhp

Category C

Goods vehicles and buses

Category D

Motorcycles

Category E

Open category (for all vehicles)

​
COE PQP Data

Prevailing Quota Premium (PQP) data represents the benchmark COE prices used for vehicle valuation. 
{
  "month": "2024-01",
  "vehicle_class": "Category A",
  "pqp": 87500
}

​
Fields

FieldTypeDescriptionExample
monthstringMonth in YYYY-MM format"2024-01"
vehicle_classstringCOE category"Category A"
pqpintegerPQP amount in SGD87500

​
Months Data

Available data months for different data types. 
{
  "month": "2024-01",
  "has_cars": true,
  "has_coe": true
}

​
Fields

FieldTypeDescriptionExample
monthstringMonth in YYYY-MM format"2024-01"
has_carsbooleanWhether car data is availabletrue
has_coebooleanWhether COE data is availabletrue

​
Makes Data

Vehicle manufacturers/brands available in the dataset. 
{
  "make": "Toyota",
  "total_registrations": 2450,
  "months_active": 12
}

​
Fields

FieldTypeDescriptionExample
makestringVehicle manufacturer/brand"Toyota"
total_registrationsintegerTotal registrations across all months2450
months_activeintegerNumber of months with data12

​
Data Relationships

​
Hierarchical Structure

​
Data Aggregation

The API provides various aggregation levels:
  1. Individual Records: Raw data points
  2. Monthly Summaries: Aggregated by month
  3. Make Summaries: Aggregated by manufacturer
  4. Fuel Type Summaries: Aggregated by fuel type
  5. Vehicle Type Summaries: Aggregated by vehicle type

​
Data Quality and Updates

​
Update Frequency

  • Car Registration Data: Monthly (typically mid-month)
  • COE Bidding Data: Bi-monthly (1st and 3rd Wednesday)
  • COE PQP Data: Monthly (after COE bidding)

​
Data Source

All data is sourced from Singapore’s Land Transport Authority (LTA) DataMall, ensuring accuracy and official validation.

​
Data Validation

Checksum Verification

Files are validated using SHA-256 checksums

Schema Validation

All data passes through strict schema validation

Business Rules

Data consistency checks prevent anomalies

Historical Validation

Cross-referencing with historical data

​
Usage Patterns

​
Common Queries

  1. Monthly Trends: Get all data for a specific month
  2. Make Comparison: Compare registrations across manufacturers
  3. Fuel Type Analysis: Track adoption of different fuel types
  4. COE Market Analysis: Monitor COE premium trends
  5. Year-over-Year Growth: Compare same months across years

​
Performance Considerations

  • Indexing: Data is indexed on month, make, and fuel_type
  • Caching: Frequently accessed data is cached with Redis
  • Pagination: Large datasets are paginated for optimal performance

​
Next Steps

Filtering Guide

Learn advanced filtering techniques

Comparison Analytics

Use built-in comparison tools

API Reference

Explore all endpoints

Examples

See practical examples