GitTables 1M

Summary

GitTables 1M (https://gittables.github.io) is a corpus of currently 1M relational tables extracted from CSV files in GitHub repositories, that are associated with a license that allows distribution. We aim to grow this to at least 10M tables.

Each parquet file in this corpus represents a table with the original content (e.g. values and header) as extracted from the corresponding CSV file. Table columns are enriched with annotations corresponding to >2K semantic types from Schema.org and DBpedia (provided as metadata of the parquet file). These column annotations consist of, for example, semantic types, hierarchical relations to other types, and descriptions.

We believe GitTables can facilitate many use-cases, among which:

Data integration, search and validation.

Data visualization and analysis recommendation.

Schema analysis and completion for e.g. database or knowledge base design.

If you have questions, the paper, documentation, and contact details are provided on the website: https://gittables.github.io. We recommend using Zenodo's API to easily download the full dataset (i.e. all zipped topic subsets).

Dataset contents

The data is provided in subsets of tables stored in parquet files, each subset corresponds to a term that was used to query GitHub with. The column annotations and other metadata (e.g. URL and repository license) are attached to the metadata of the parquet file. This version corresponds to this version of the paper https://arxiv.org/abs/2106.07258v4.

In summary, this dataset can be characterized as follows:

Statistic

Value

# tables

1M

average # columns

12

average # rows

142

# annotated tables (at least 1 column annotation)

723K+ (DBpedia), 738K+ (Schema.org)

# unique semantic types

835 (DBpedia), 677 (Schema.org)

How to download

The dataset can be downloaded through Zenodo's interface directly, or using Zenodo's API (recommended for full download).

Future releases

Future releases will include the following:

Increased number of tables (expected at least 10M)

Associated datasets

- GitTables benchmark - column type detection: https://zenodo.org/record/5706316

- GitTables 1M - CSV files: https://zenodo.org/record/6515973