Database of expense reports published on Ma Dada

## Motivations for the creation of the dataset The main objective of the creation of this dataset was to create a database listing the expense notes of the mayors who had responded positively to the requests made on the site requesting access to an administrative document, Madada.fr. The database lists only the expense notes that the town halls have kindly communicated publicly on Madada.fr. Indeed, the aim was to study the exact content of the mayors’ expense notes since 2020 available on the platform. We received no funding, the database was created as part of an article written for a student magazine (https://chicane-lemag.fr/) of the Masters of Information of Sciences Po Aix and EJCAM. The article entitled “What does the analysis of data on Mayors’ expense reports in 2022 tell us?” is available at this address: https://chicane-lemag.fr/16/2023/11/27/analyse-donnees-notes-de-frais-elus/ ## Composition of the dataset The dataset contains on each line the information of a specific expense note between 2020 and 2023 according to: — Date (day/month/year) — Community concerned — Supplier’s name — SIRET number — Main activity of the supplier — Object of expenditure — Supporting document — Amount in euros — Category of expenditure ## Data collection process The data were collected manually. Two students ensured this data collection. The collection took place from 1 October 2023 to 10 November 2023. They were collected from requests for expense reports on Madada.fr. They therefore represent not all the mayors of France but only those who have communicated their notes on the platform. ## Data pre-processing The data were cleaned and prepared by a careful reading of the supporting documents submitted by the mayors in order to justify their expense reports. The information was collected and then transferred to an Airtable database planned to identify these expense reports. ## Dissemination of the dataset The data is made available to all on data.gouv.fr under ODbL license. ## Dataset maintenance There are no plans to update these data. ## Legal and ethical considerations The publication of this data is governed by the right of access to administrative documents, as provided for in Book III of the Code of Relations between the Public and the Administration. The Council of State ruled that “notes of expenses and receipts of travel as well as notes of catering expenses and receipts of representation expenses of local elected officials or public officials constitute administrative documents, which may be communicated to any person who so requests” (Council of State 52521, reading of 8 February 2023).### 数据集构建动因 本数据集的核心构建目标为搭建数据库，收录对Madada.fr平台行政文书调取请求作出积极回应的市长公务报销单据。该数据库仅收录法国各市政厅通过Madada.fr平台公开披露的报销单据，旨在研究2020年以来该平台可获取的市长公务报销单据的具体内容。 本研究未获得任何外部经费资助，数据集的构建是为《Chicane》学生杂志（https://chicane-lemag.fr/）撰写的专题文章的组成部分，该杂志隶属于巴黎政治学院艾克斯分校信息学硕士项目与EJCAM。题为《2022年市长公务报销单据数据分析揭示了什么？》的文章可通过以下链接获取：https://chicane-lemag.fr/16/2023/11/27/analyse-donnees-notes-de-frais-elus/ ### 数据集构成 本数据集的每一行对应2020至2023年间的单张公务报销单据，包含以下字段： — 单据日期（日/月/年） — 所属社区 — 供应商名称 — SIRET编号 — 供应商主营业务 — 支出事由 — 佐证文件 — 欧元计价金额 — 支出类别 ### 数据采集流程 本数据集采用人工采集方式，由两名学生负责完成。数据采集时段为2023年10月1日至2023年11月10日，采集自Madada.fr平台上的公务报销单据调取请求。需说明的是，本数据集仅涵盖已在该平台披露报销单据的法国市长，而非全体法国市长。 ### 数据预处理 研究人员通过仔细研读市长提交的报销佐证文件，对数据进行了清洗与整理。采集到的信息被汇总并录入至用于归集该类报销单据的Airtable数据库。 ### 数据集发布 本数据集已通过data.gouv.fr平台向全体公众开放，采用ODbL许可证。 ### 数据集维护计划 目前暂无更新该数据集的相关规划。 ### 法律与伦理考量 本数据的发布受《公共与行政关系法典》第三编规定的行政文书调取权规制。法国最高行政法院曾作出裁定：“地方民选官员或公职人员的公务报销单据、差旅凭证、餐饮接待凭证及礼仪支出凭证均属于行政文书，可应任何申请人的请求予以披露”（法国最高行政法院，2023年2月8日第52521号判例）。