Data & methods
Where the figures come from, what each field means, how every rate is calculated and how the data was cleaned. Download the cleaned dataset to check or reuse it.
About the data
Sample data
This dashboard currently runs on an illustrative sample dataset that follows the structure of Tamil Nadu's district-wise road accident tables. The numbers are not official statistics and must not be quoted. When the official dataset is loaded, every chart, map, insight and download on this site updates from it automatically.
- Source
- Illustrative sample dataset modelled on the structure of Tamil Nadu district-wise road accident tables. Not official figures.
- Unit of analysis
- District and calendar year
- Coverage
- 2019 to 2025 · 38 districts
- Latest year
- 2025
- Last updated
- 16 November 2026
- Records after cleaning
- 266 district-years
- Population
- Population: Census 2011, re-apportioned to current district boundaries for districts formed after 2011 (approximate).
- Map boundaries
- District boundaries: INDIAN-SHAPEFILES by datta07 (MIT License), simplified
Downloads
Files open in any spreadsheet app. Tamil names display correctly in Excel and Google Sheets. Charts across the site also export their own data and images.
Field definitions
| Field | Meaning |
|---|---|
| year | Calendar year in which the crashes were recorded. |
| district | District where the crash was recorded, on the current 38-district map. Spellings are standardised. |
| accidents | Number of road accidents (crashes) recorded. One crash can involve several vehicles and people. |
| deaths | Number of people killed in those crashes. |
| injuries | Number of people injured, grievous and minor together. |
| population_2011 | Census 2011 population, re-apportioned for districts formed after 2011 (approximate). |
| road_type | Classification of the road where the crash happened: national highway, state highway, district road, city and town road, village and other road. |
| impacting_vehicle | Vehicle recorded as causing the impact. Each crash is counted once, under one vehicle type. |
| recorded_cause | Main traffic violation or condition recorded by police at the scene. |
| collision_type | How the crash happened, for example head-on or hit from behind. |
| time_band | Three-hour window of the day in which the crash happened. |
How figures are calculated
Deaths per 100 accidents
deaths ÷ accidents × 100
A measure of how severe crashes are. Not shown in rankings when a district has fewer than 30 accidents in the selection.
Deaths per lakh population
deaths ÷ population × 1,00,000
Allows districts of different sizes to be compared. Uses 2011 population for every year, so fast-growing districts may look higher than they are.
Year-on-year change
(this year − previous year) ÷ previous year × 100
Rates show the change in points instead of a percentage. Not calculated across a district boundary change.
Share of state total
district value ÷ Tamil Nadu total × 100
Shares within a category chart are the category's part of all crashes in the selection.
Rank
1 = highest value among districts with figures
Districts with equal values share a rank.
State average
Tamil Nadu total ÷ districts reporting
Used for counts. For rates the statewide rate is used instead.
Map shading
5 quantile classes, rounded break points
Each shade holds about the same number of districts. Darker means higher.
Cleaning steps
- Read 273 rows from tn-district-road-accidents-2019-2025-sample.csv and matched each column by its heading:Sl. No. → not usedDistrict Name → districtYear → yearRoad Accidents → accidentsPersons Killed → deathsPersons Injured → injuriesRemarks → remarks
- Removed 7 "Total" rows and checked them against the sum of districts: 19 totals matched exactly, 2 differed because a district figure was not reported.2019 Injuries: 61,686 / 60,992 · 2021 Injuries: 59,480 / 58,884
- Standardised 12 district spellings and fixed 2 names with stray spaces or capital letters:Kanchipuram→Kancheepuram×2Kanyakumari→Kanniyakumari×4Pudukottai→Pudukkottai×1Sivagangai→Sivaganga×3The Nilgiris→Nilgiris×7Thiruvallur→Tiruvallur×3Thiruvannamalai→Tiruvannamalai×2Thiruvarur→Tiruvarur×2Tiruchirapalli→Tiruchirappalli×2Tirupattur→Tirupathur×2Tuticorin→Thoothukudi×1Villupuram→Viluppuram×3
- Converted text to numbers, removing thousand separators and spaces in 141 values. "Nil" is read as zero; dashes, blanks and "NA" are read as missing, never as zero.
- Combined 0 duplicate district-year rows (for example city and rural police units of one district). Every district name was matched.
Missing data
Missing values are never estimated or filled in. Totals that leave out a district say so in a note next to the figure.
| District | Year | Field | In the source |
|---|---|---|---|
| Perambalur | 2019 | Injuries | NA |
| Ariyalur | 2021 | Injuries | - |
7 district-years have no separate figures because the district had not yet been formed; their crashes are counted in the parent district (see below). They are shown as "No separate figures" on the map.
District boundary changes
| District | Formed from | Year formed | Separate figures from |
|---|---|---|---|
| Chengalpattu | Kancheepuram | 2019 | 2020 |
| Kallakurichi | Viluppuram | 2019 | 2020 |
| Mayiladuthurai | Nagapattinam | 2020 | 2021 |
| Ranipet | Vellore | 2019 | 2020 |
| Tenkasi | Tirunelveli | 2019 | 2020 |
| Tirupathur | Vellore | 2019 | 2020 |
Year-on-year changes are not calculated for a parent district in the year its area changed, and per-person rates for those years use the combined population.
Limitations and disclaimer
- Official figures may be revised after publication. Always check the latest official release before quoting a number.
- Recorded causes come from police reports at the scene. They describe what was recorded, not a finding of fault.
- Patterns shown here are associations. A district, road type or vehicle with higher figures is not by itself the cause of those crashes.
- Minor injuries are often under-reported, so injury counts are likely to be lower than the true number.
- Road type and vehicle filters use a combined road type by vehicle table. Cause, collision and time of day come from separate tables, so those two filters do not apply to them.
- District boundaries on the map are approximate and for illustration only.
Official figures may be revised. This dashboard is for public information and does not replace official statistics.
How to cite
SAFETN: Tamil Nadu Road Safety Insights. Tamil Nadu district-wise road accidents, 2019 to 2025. Illustrative sample dataset modelled on the structure of Tamil Nadu district-wise road accident tables. Not official figures. Last updated 16 November 2026.