changedInput schema / properties / blocks / items / properties / table / description
Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
changedInput schema / properties / blocks / items / properties / table / enum
Previous value: -[
- "deals",
- "firm_deals",
- "buyers",
- "advisers",
- "deals_by_year",
- "firms",
- "funds",
- "companies",
- "new_offerings",
- "placement_agents",
- "found_companies",
- "people",
- "parties"
-]New value: +[
+ "deals",
+ "firm_deals",
+ "buyers",
+ "advisers",
+ "deals_by_year",
+ "firms",
+ "funds",
+ "companies",
+ "new_offerings",
+ "found_buyers",
+ "placement_agents",
+ "found_companies",
+ "people",
+ "parties"
+]
changedInput schema / properties / sheets / items / properties / table / description
Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
changedInput schema / properties / sheets / items / properties / table / enum
Previous value: -[
- "deals",
- "firm_deals",
- "buyers",
- "advisers",
- "deals_by_year",
- "firms",
- "funds",
- "companies",
- "new_offerings",
- "placement_agents",
- "found_companies",
- "people",
- "parties"
-]New value: +[
+ "deals",
+ "firm_deals",
+ "buyers",
+ "advisers",
+ "deals_by_year",
+ "firms",
+ "funds",
+ "companies",
+ "new_offerings",
+ "found_buyers",
+ "placement_agents",
+ "found_companies",
+ "people",
+ "parties"
+]
changedInput schema / properties / slides / items / properties / table / properties / table / description
Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
changedInput schema / properties / slides / items / properties / table / properties / table / enum
Previous value: -[
- "deals",
- "firm_deals",
- "buyers",
- "advisers",
- "deals_by_year",
- "firms",
- "funds",
- "companies",
- "new_offerings",
- "placement_agents",
- "found_companies",
- "people",
- "parties"
-]New value: +[
+ "deals",
+ "firm_deals",
+ "buyers",
+ "advisers",
+ "deals_by_year",
+ "firms",
+ "funds",
+ "companies",
+ "new_offerings",
+ "found_buyers",
+ "placement_agents",
+ "found_companies",
+ "people",
+ "parties"
+]