RoadTrafficAccidentLocations.csv
Diesen Datensatz direkt online Analysieren mit 
(Python) oder SQL. Jupyter Notebooks und R-Markdown-Dateien mit Startercode zum Download findest du auch hier.
Comma-Separated Values.
Weitere Informationen zu CSV finden Sie in unserer Rubrik Werkstatt unter Informationen zu Datenformaten.
Datenverzeichnis
| Spalte | Typ | Bezeichnung | Beschreibung |
|---|---|---|---|
| AccidentUID | text | ||
| AccidentType | text | ||
| AccidentType_de | text | ||
| AccidentType_fr | text | ||
| AccidentType_it | text | ||
| AccidentType_en | text | ||
| AccidentSeverityCategory | text | ||
| AccidentSeverityCategory_de | text | ||
| AccidentSeverityCategory_fr | text | ||
| AccidentSeverityCategory_it | text | ||
| AccidentSeverityCategory_en | text | ||
| AccidentInvolvingPedestrian | text | ||
| AccidentInvolvingBicycle | text | ||
| AccidentInvolvingMotorcycle | text | ||
| RoadType | text | ||
| RoadType_de | text | ||
| RoadType_fr | text | ||
| RoadType_it | text | ||
| RoadType_en | text | ||
| AccidentLocation_CHLV95_E | text | ||
| AccidentLocation_CHLV95_N | text | ||
| CantonCode | text | ||
| MunicipalityCode | text | ||
| AccidentYear | text | ||
| AccidentMonth | text | ||
| AccidentMonth_de | text | ||
| AccidentMonth_fr | text | ||
| AccidentMonth_it | text | ||
| AccidentMonth_en | text | ||
| AccidentWeekDay | text | ||
| AccidentWeekDay_de | text | ||
| AccidentWeekDay_fr | text | ||
| AccidentWeekDay_it | text | ||
| AccidentWeekDay_en | text | ||
| AccidentHour | text | ||
| AccidentHour_text | text |
Zusätzliche Informationen
| Feld | Wert |
|---|---|
| Daten wurden zuletzt aktualisiert | 18. August 2025 |
| Metadaten zuletzt aktualisiert | 18. August 2025 |
| Erstellt | unbekannt |
| Format | CSV |
| Lizenz | Creative Commons Attribution |
| Erstellt | vor 2 Monaten |
| Media type | text/csv |
| Size | 36.126.213 |
| Ckan url | https://ckan-staging.zurich.datopian.com |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Filename | RoadTrafficAccidentLocations.csv |
| Has views | True |
| Hash | 927ee9acaacfdd4525bc16c595bf3863 |
| Id | 11f61287-5b62-4309-9425-5d49c49e6074 |
| Ignore hash | False |
| Markdown snippet | Diesen Datensatz direkt online Analysieren mit [](https://renkulab.io/p/opendatazurich/starter-code/sessions/01JZT3TY89P6YRMMJXV9PEDQZW/start?PACKAGE_ID=ad19402b-d923-4a89-979b-bcddf2c36749&RESOURCE_ID=11f61287-5b62-4309-9425-5d49c49e6074) (Python) oder [SQL](https://sql-workbench.com/#queries=v0,%20%20-This-is-autogenerated-code-to-analyze-(meta)-data-from-OpenDataZurich,%20%20-All-information-refers-to-the-data-set-that-can-be-found-here%3A-https%3A%2F%2Fdata.stadt%20zuerich.ch%2Fdataset%2Fad19402b-d923-4a89-979b-bcddf2c36749,%20%20-get-metadata,CREATE-TABLE-metadata-AS-SELECT-*-FROM-read_json(%22https%3A%2F%2Fdata.stadt%20zuerich.ch%2Fapi%2Faction%2Fpackage_show%3Fid%3Dad19402b-d923-4a89-979b-bcddf2c36749%22)~,%20%20-use-this-to-display-metadata,%20%20SELECT-result.title%2C-result.timeRange%2C-result.notes%2C-result.sszBemerkungen-FROM-metadata~,%20%20-get-data,CREATE-TABLE-ogdszh-AS-SELECT-*-FROM-read_csv(%22https%3A%2F%2Fcors.sqlqry.run%2F%3Furl%3Dhttps://data.integ.stadt-zuerich.ch/dataset/int_sid_sid_dav_strassenverkehrsunfallorte/download/RoadTrafficAccidentLocations.csv%22)~,%20%20-show-the-first-5-rows-of-the-data,SELECT-*-FROM-ogdszh-LIMIT-5~). Jupyter Notebooks und R-Markdown-Dateien mit Startercode zum Download findest du auch [hier](https://opendatazurich.github.io/starter-code/). |
| Original url | https://data.integ.stadt-zuerich.ch/dataset/int_sid_sid_dav_strassenverkehrsunfallorte/download/RoadTrafficAccidentLocations.csv |
| Package id | ad19402b-d923-4a89-979b-bcddf2c36749 |
| Position | 1 |
| Resource id | 11f61287-5b62-4309-9425-5d49c49e6074 |
| Resource type | file |
| Set url type | False |
| State | active |
| Task created | 2025-06-13 17:02:02.474998 |
| Url type | upload |
| Zh hash | 927ee9acaacfdd4525bc16c595bf3863 |