Vehicle Registration Transactions: Cars
Data as of 31 Oct 2024, 23:59Car registration transactions from 2000 to the present. The table below provides a preview of the full dataset, which contains hundreds of thousands of transactions per year.
0 views·0 downloads
How is this data produced?
This dataset contains the actual transactional records of all cars registered with the Road Transport Department (JPJ) since 2000, excluding any personal identifiable data (note: no personal data as defined by Act 709 is ever handled or even received by the data.gov.my team in the process of producing this dataset). Under Malaysian law, all vehicles must be registered with JPJ and be assigned a registration plate number before they can be used on the road.
While there has been cleaning and validation conducted prior to publication, no other amendment or aggregation has been performed; each row in the dataset represents 1 registration transaction. This is the most granular form of the data, i.e. the single source of truth from which all other car registration statistics are derived, including those shown on data.gov.my.
What caveats I should bear in mind when using this data?
This dataset captures the registration of cars, not the sale or import or any other transaction. Therefore, if a car is not registered for use on the road, it will not be present in this dataset (e.g. cars which are purchased purely for private display).
Furthermore, it should be noted that this dataset was extremely difficult to prepare, especially for data from the early 2000s when data collection systems were not as sophisticated as they are now. Accordingly, if you spot any errors in the dataset or have any suggestions to improve its quality, please write to data.dtsa@jdn.gov.my so the data.gov.my team can work with JPJ to fix or improve it as soon as possible.
Publication(s) using this data
datagovmy features a dashboard on car popularity and vehicle registrations, which enables you to explore this dataset in an interactive manner!
Metadata
Dataset description
Car registration transactions from 2000 to the present. The table below provides a preview of the full dataset, which contains hundreds of thousands of transactions per year.
Variable definitions
- Date of Registration
- Vehicle Type
- Car Maker
- Car Model
- Car Colour
- Fuel
- State of Registration
Name in Dataset | Variable | Definition |
|---|---|---|
date_reg (Date) | Date of Registration | The date of registration of the vehicle in YYYY-MM-DD format; please note that this date may not be the same as the date of purchase |
type (Categorical) | Vehicle Type | One of 5 vehicle types classed under as Cars for the purpose of analysis, namely motorcars ('motokar'), MPVs ('motokar_pelbagai_utiliti'), jeeps ('jip'), pick-up trucks ('pick_up') and window vans ('window_van') |
maker (String) | Car Maker | Maker of the vehicle (e.g. Perodua, Proton, Toyota) in upper-case text |
model (String) | Car Model | Model of the vehicle (e.g. Bezza (Perodua), Saga (Proton), City (Honda)) in upper-case text |
colour (String) | Car Colour | Colour of the car in lower-case English text; please note these are broadly defined colours which do not distinguish between shades of the same colour (e.g. light blue and dark blue are both classed as blue) |
fuel (String) | Fuel | Fuel used by the car's engine(s); there are 7 types, namely petrol ('petrol'), diesel ('diesel'), green diesel ('greendiesel'), natural gas ('ng'), liquefied natural gas ('lng'), hydrogen ('hydrogen'), and electricity ('electric'). Cars which can run on electricity or fuel are classed as hybrid (either 'hybrid_petrol' or 'hybrid_diesel'). Combinations of two fuels indicate that the car's engine can use more than one type of fuel; for instance, 'diesel_ng' means the car's engine can use both diesel and natural gas as fuel. |
state (String) | State of Registration | One of 16 states, or 'Rakan Niaga'; this either indicates the state of the JPJ office the car was registered at, or that the car was registered through an official JPJ partner portal ('Rakan Niaga'). Please note that this data field has no relation to the car's number plate, which may be freely chosen with no dependence on where the car was registered. |
Last updated:
10 Nov 2024, 16:00
Next update:
10 Dec 2024, 16:00
Data source(s)
- Road Transport Department
- Ministry of Transport
URLs to dataset
License
This data is made open under the Creative Commons Attribution 4.0 International License (CC BY 4.0). A copy of the license is available Here.
Download
Data
Full Dataset (CSV)
Recommended for individuals seeking an Excel-friendly format.
0
Full Dataset (Parquet)
Recommended for data scientists seeking to work with data via code.
0
Code
Connect directly to the data with Python.
# If not already installed, do: pip install pandas fastparquet
import pandas as pd
URL_DATA = 'https://storage.data.gov.my/transportation/cars_2024.parquet'
df = pd.read_parquet(URL_DATA)
if 'date' in df.columns: df['date'] = pd.to_datetime(df['date'])
print(df)Sample OpenAPI query
This data catalog is not available through OpenAPI as the nature of the data makes it unsuitable for API access. For the full dataset, please use the provided download link as shown in the above section.
© 2024 Public Sector Open Data