Types of tables

Google Fusion Tables is a table-based data visualization application. Tables have columns (types of data) and rows (data values). You can select a subset of data based on either column or row values, or both.

Types of tables

There are three types of tables: base, view, and merged. Every table is a document with its own title, viewers, saved visualizations, and set of data. The data in each type of table has different properties.
  • base: A table. Typically this is created by importing a CSV, spreadsheet or KML file, although you can add rows manually. Most tables are this type.
  • view: A table that is populated by data from a base table. It can contain all or just a subset of the base table's data. The view table is a separate document with a different name, different viewers, visualizations, and its own URL. However, the data is always from the base table and can only be edited accordingly. Use a view to share only a subset of a table and to gather data from other people.
  • merged: You can combine two or more tables into a single new table. To merge, each of the tables must have a column with the same values. Merged tables inherit the column types, data, and edit permissions on data from the base table. You cannot insert new rows into a merged table. You can merge tables owned by different people.

You can find out about the data that comprises a table by looking in File > About this table.