In our research, we crawled 3712 publicly available CSV files distributed on two Open Data portals: GovUK and Mendeley Data.
The first gathers data produced by actors of the public sector of the United Kingdom, e.g., city councils, ministry cabinets, or hospitals. The second acts as a repository for research projects carried by scientifical institutions, e.g. universities or research institutes.
We analyzed the crawled CSV files with respect to their compliance to the RFC4180 standard under different aspects: at the file-level, at the table-level and at the row- and column-level.
The image below summarizes the results of our finding.