_grist_Tables_column
19 rows where type = "Text"
This data as json, CSV (advanced)
Suggested facets: parentId, colId, widgetOptions, isFormula, formula, label, summarySourceCol
id ▼ | parentId | parentPos | colId | type | widgetOptions | isFormula | formula | label | untieColIdFromLabel | summarySourceCol | displayCol | visibleCol |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 1 | 2 | permalink | Text | 0 | permalink | 0 | 0 | 0 | 0 | ||
3 | 1 | 3 | name | Text | 0 | name | 0 | 0 | 0 | 0 | ||
4 | 1 | 4 | category_code | Text | 0 | category_code | 0 | 0 | 0 | 0 | ||
6 | 1 | 6 | status | Text | 0 | status | 0 | 0 | 0 | 0 | ||
7 | 1 | 7 | country_code | Text | 0 | country_code | 0 | 0 | 0 | 0 | ||
8 | 1 | 8 | state_code | Text | 0 | state_code | 0 | 0 | 0 | 0 | ||
9 | 1 | 9 | region | Text | 0 | region | 0 | 0 | 0 | 0 | ||
10 | 1 | 10 | city | Text | 0 | city | 0 | 0 | 0 | 0 | ||
25 | 2 | 25 | investor_permalink | Text | 0 | investor_permalink | 0 | 0 | 0 | 0 | ||
26 | 2 | 26 | investor_name | Text | 0 | investor_name | 0 | 0 | 0 | 0 | ||
27 | 2 | 27 | investor_category_code | Text | 0 | investor_category_code | 0 | 0 | 0 | 0 | ||
28 | 2 | 28 | investor_country_code | Text | 0 | investor_country_code | 0 | 0 | 0 | 0 | ||
29 | 2 | 29 | investor_state_code | Text | 0 | investor_state_code | 0 | 0 | 0 | 0 | ||
30 | 2 | 30 | investor_region | Text | 0 | investor_region | 0 | 0 | 0 | 0 | ||
31 | 2 | 31 | investor_city | Text | 0 | investor_city | 0 | 0 | 0 | 0 | ||
32 | 2 | 32 | funding_round_type | Text | 0 | funding_round_type | 0 | 0 | 0 | 0 | ||
40 | 3 | 39 | category_code | Text | 0 | category_code | 0 | 4 | 0 | 0 | ||
62 | 1 | 1.5 | Link | Text | {"widget":"HyperLink","textColor":"#000000"} | 1 | "%s https://www.crunchbase.com%s" % ($name, $permalink) | Link | 0 | 0 | 0 | 0 |
63 | 2 | 61 | Investor | Text | {"widget":"HyperLink","textColor":"#000000"} | 1 | $investor_name + " https://www.crunchbase.com" + $investor_permalink | Investor | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "_grist_Tables_column" (id INTEGER PRIMARY KEY, "parentId" BLOB DEFAULT 0, "parentPos" BLOB DEFAULT 1e999, "colId" BLOB DEFAULT '', "type" BLOB DEFAULT '', "widgetOptions" BLOB DEFAULT '', "isFormula" BLOB DEFAULT 0, "formula" BLOB DEFAULT '', "label" BLOB DEFAULT '', "untieColIdFromLabel" BLOB DEFAULT 0, "summarySourceCol" BLOB DEFAULT 0, "displayCol" BLOB DEFAULT 0, "visibleCol" BLOB DEFAULT 0);