_grist_Tables_column
52 rows sorted by widgetOptions descending
This data as json, CSV (advanced)
Suggested facets: parentId, type, widgetOptions, isFormula, formula, summarySourceCol, displayCol, visibleCol
id | parentId | parentPos | colId | type | widgetOptions ▲ | isFormula | formula | label | untieColIdFromLabel | summarySourceCol | displayCol | visibleCol |
---|---|---|---|---|---|---|---|---|---|---|---|---|
18 | 2 | 18 | Company | Ref:Companies | {"widget":"Reference"} | 0 | Company | 0 | 0 | 38 | 2 | |
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 |
1 | 1 | 1 | manualSort | ManualSortPos | 0 | manualSort | 0 | 0 | 0 | 0 | ||
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 | ||
5 | 1 | 5 | funding_total_usd | Numeric | 0 | funding_total_usd | 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 | ||
11 | 1 | 11 | funding_rounds | Int | 0 | funding_rounds | 0 | 0 | 0 | 0 | ||
12 | 1 | 12 | founded_at | Date | 0 | founded_at | 0 | 0 | 0 | 0 | ||
13 | 1 | 13 | founded_year | Int | 0 | founded_year | 0 | 0 | 0 | 0 | ||
14 | 1 | 14 | first_funding_at | Date | 0 | first_funding_at | 0 | 0 | 0 | 0 | ||
15 | 1 | 15 | last_funding_at | Date | 0 | last_funding_at | 0 | 0 | 0 | 0 | ||
16 | 1 | 16 | last_milestone_at | Date | 0 | last_milestone_at | 0 | 0 | 0 | 0 | ||
17 | 2 | 17 | manualSort | ManualSortPos | 0 | manualSort | 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 | ||
33 | 2 | 33 | funded_at | Date | 0 | funded_at | 0 | 0 | 0 | 0 | ||
34 | 2 | 34 | funded_year | Int | 0 | funded_year | 0 | 0 | 0 | 0 | ||
35 | 2 | 35 | raised_amount_usd | Int | 0 | raised_amount_usd | 0 | 0 | 0 | 0 | ||
38 | 2 | 38 | gristHelper_Display2 | Any | 1 | $Company.permalink | gristHelper_Display2 | 0 | 0 | 0 | 0 | |
39 | 2 | 21.5 | Company_category_code | Any | 1 | $Company.category_code | Company_category_code | 0 | 0 | 0 | 0 | |
40 | 3 | 39 | category_code | Text | 0 | category_code | 0 | 4 | 0 | 0 | ||
41 | 3 | 40 | group | RefList:Companies | 1 | table.getSummarySourceGroup(rec) | group | 0 | 0 | 0 | 0 | |
43 | 3 | 42 | funding_total_usd | Numeric | 1 | SUM($group.funding_total_usd) | funding_total_usd | 0 | 0 | 0 | 0 | |
44 | 4 | 43 | funded_year | Int | 0 | funded_year | 0 | 34 | 0 | 0 | ||
45 | 4 | 44 | group | RefList:Investments | 1 | table.getSummarySourceGroup(rec) | group | 0 | 0 | 0 | 0 | |
47 | 4 | 46 | raised_amount_usd | Numeric | 1 | SUM($group.raised_amount_usd) | raised_amount_usd | 0 | 0 | 0 | 0 | |
48 | 3 | 47 | count | Int | 1 | len($group) | count | 0 | 0 | 0 | 0 | |
49 | 3 | 48 | funding_rounds | Int | 1 | SUM($group.funding_rounds) | funding_rounds | 0 | 0 | 0 | 0 | |
50 | 3 | 49 | founded_year | Int | 1 | SUM($group.founded_year) | founded_year | 0 | 0 | 0 | 0 | |
51 | 4 | 50 | count | Int | 1 | len($group) | count | 0 | 0 | 0 | 0 | |
52 | 5 | 51 | Company_category_code | Any | 0 | Company_category_code | 0 | 39 | 0 | 0 | ||
53 | 5 | 52 | funded_year | Int | 0 | funded_year | 0 | 34 | 0 | 0 | ||
54 | 5 | 53 | group | RefList:Investments | 1 | table.getSummarySourceGroup(rec) | group | 0 | 0 | 0 | 0 | |
55 | 5 | 54 | count | Int | 1 | len($group) | count | 0 | 0 | 0 | 0 | |
56 | 5 | 55 | raised_amount_usd | Numeric | 1 | SUM($group.raised_amount_usd) | raised_amount_usd | 0 | 0 | 0 | 0 | |
57 | 6 | 56 | Company_category_code | Any | 0 | Company_category_code | 0 | 39 | 0 | 0 | ||
58 | 6 | 57 | group | RefList:Investments | 1 | table.getSummarySourceGroup(rec) | group | 0 | 0 | 0 | 0 | |
59 | 6 | 58 | count | Int | 1 | len($group) | count | 0 | 0 | 0 | 0 | |
61 | 6 | 60 | raised_amount_usd | Numeric | 1 | SUM($group.raised_amount_usd) | raised_amount_usd | 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);