@misc{center_for_history_and_new_media_zotero_nodate,
title = {Zotero {Quick} {Start} {Guide}},
url = {http://zotero.org/support/quick_start_guide},
author = {{Center for History and New Media}},
annote = {Welcome to Zotero!View the Quick Start Guide to learn how to begin collecting, managing, citing, and sharing your research sources.Thanks for installing Zotero.}
}

@article{morris_dilemma_2006,
title = {The {Dilemma} of {Growth}: {Understanding} {Venture} {Size} {Choices} of {Women} {Entrepreneurs}},
volume = {44},
issn = {1540-627X},
shorttitle = {The {Dilemma} of {Growth}},
url = {http://onlinelibrary.wiley.com/doi/10.1111/j.1540-627X.2006.00165.x/abstract},
doi = {10.1111/j.1540-627X.2006.00165.x},
abstract = {In recent years the number of women-owned firms with employees has expanded at three times the rate of all employer firms. Yet women remain underrepresented in their proportion of high-growth firms. A number of plausible explanations exist. To develop richer insights, a two-stage research project was undertaken. A mail survey was sent to a sample of female entrepreneurs to assess motives, obstacles, goals and aspirations, needs, and business identity. Based on the survey results, follow-up, in-depth interviews were conducted with entrepreneurs, selecting equally from modest-growth and high-growth ventures. In terms of quantitative findings, growth orientation was associated with whether a woman was “pushed” or “pulled” into entrepreneurship, was motivated by wealth or achievement factors, had a strong women's identity in the venture, had equity partners, and believed women faced unique selling obstacles. The qualitative research made clear that modest- and high-growth entrepreneurs differ in how they view themselves, their families, their ventures, and the larger environment. The results of both stages suggest that growth is a deliberate choice and that women have a clear sense of the costs and benefits of growth and make careful trade-off decisions.},
language = {en},
number = {2},
urldate = {2017-03-28},
journal = {Journal of Small Business Management},
author = {Morris, Michael H. and Miyasaki, Nola N. and Watters, Craig E. and Coombes, Susan M.},
month = apr,
year = {2006},
pages = {221--244},
file = {Full Text PDF:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/BNJ4C7HC/Morris et al. - 2006 - The Dilemma of Growth Understanding Venture Size .pdf:application/pdf;Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/MHXNUBKG/Morris et al. - 2006 - The Dilemma of Growth Understanding Venture Size .html:text/html}
}

@article{menzies_examining_2004,
title = {Examining {Venture}-related {Myths} {Concerning} {Women} {Entrepreneurs}},
volume = {9},
copyright = {Copyright Norfolk State University Foundation Aug 2004},
issn = {10849467},
url = {http://search.proquest.com/docview/208428310/abstract/E7779CA6B1314111PQ/1},
abstract = {Despite the increasing number of women who are starting businesses, distinct hurdles exist for them. For instance, there is a lower occurrence of females as business owners and a paucity of academic research on the topic of female entrepreneurs. Another major hurdle is the presence of "derogatory myths" like those specified in the U.S. Diana Project. A random sample of nascent entrepreneurs in Canada is utilized to examine these myths about women entrepreneurs. Although many of the myths were unsubstantiated, the findings show that perhaps women do not have the right educational background to start large businesses and they may be starting businesses unattractive to venture capitalists. These findings are a clear wake-up call for the implementation of new programs and policies to increase the number of females studying computer and engineering sciences and to encourage and nurture a higher incidence of females as lead entrepreneurs. [PUBLICATION ABSTRACT]},
language = {English},
number = {2},
urldate = {2017-03-28},
journal = {Journal of Developmental Entrepreneurship; Norfolk},
author = {Menzies, Teresa V. and Diochon, Monica and Gasse, Yvon},
month = aug,
year = {2004},
keywords = {Business And Economics, Education, Entrepreneurs, Gender equity, Studies, Women owned businesses},
pages = {89--107},
file = {Full Text PDF:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/F7FGQ8IA/Menzies et al. - 2004 - Examining Venture-related Myths Concerning Women E.pdf:application/pdf}
}

@article{brush_role_2002,
title = {The role of social capital and gender in linking financial suppliers and entrepreneurial firms: {A} framework for future research},
volume = {4},
issn = {1369-1066},
shorttitle = {The role of social capital and gender in linking financial suppliers and entrepreneurial firms},
url = {http://dx.doi.org/10.1080/1369106022000024897},
doi = {10.1080/1369106022000024897},
abstract = {Equity capital fuels growth companies and yields high returns for investors. The process of equity investment and ultimate harvesting of innovative companies has created significant wealth among fund investors, venture capitalists, angels and new entrepreneurs. Extensive research investigates all phases of the venture capital investment process, industry characteristics and returns to investors. Surprisingly absent from current research are studies including women, on both the supply (equity provider) and demand (equity seeker) sides. Women make significant contributions to the US economy in the workforce and as business owners, yet research about women as recipients of equity capital and providers of equity is extremely scarce. This raises a question–are women being left out of the wealth creation process? Our paper addresses this question by exploring women's role in supply and demand of equity capital. We utilize a social capital perspective to develop a conceptual framework and focus our analysis on early stage and angel investment. The paper concludes with directions for future research.},
number = {4},
urldate = {2017-03-28},
journal = {Venture Capital},
author = {Brush, Candida G. and Carter, Nancy M. and Greene, Patricia G. and Hart, Myra M. and Gatewood, Elizabeth},
month = oct,
year = {2002},
keywords = {Business Angels, Social Capital, Venture Capital, Venture Capitalists, Women Entrepreneurs},
pages = {305--323},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/SIT8QJDS/Brush et al. - 2002 - The role of social capital and gender in linking f.html:text/html}
}

@article{chaganti_management_1986,
title = {Management in {Women}-{Owned} {Enterprises}},
volume = {24},
issn = {0047-2778},
url = {https://www.questia.com/library/journal/1G1-4587541/management-in-women-owned-enterprises},
abstract = {MANAGEMENT IN WOMEN-OWNED ENTERPRISES According to recent statistics, women are starting small...},
language = {eng},
urldate = {2017-03-28},
journal = {Journal of Small Business Management},
author = {Chaganti, Radha},
month = oct,
year = {1986},
pages = {18},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/UKSZF5DF/Chaganti - 1986 - Management in Women-Owned Enterprises.html:text/html}
}

@article{brush_use_2006,
title = {The use of bootstrapping by women entrepreneurs in positioning for growth},
volume = {8},
issn = {1369-1066},
url = {http://www.tandfonline.com/doi/abs/10.1080/13691060500433975},
doi = {10.1080/13691060500433975},
abstract = {The number of women entrepreneurs is rising rapidly and many are creating substantial businesses. For most women-led ventures, growth is funded by personal investment and debt, although a small percentage draw on private equity investment to fuel high growth. Of those that seek growth, not only do they face higher obstacles in obtaining capital, but little is known about ways they position ventures for growth. This paper addresses the question: ‘How do women develop financing strategies to prove the business concept, meet early stage milestones, and demonstrate to external investors the value and potential of their businesses?’ Data are drawn from phone interviews with 88 US female entrepreneurs seeking an equity investment to grow their businesses. The analysis examines the correspondence between bootstrapping and stage of business development. Results show significant differences in the use of bootstrap options utilized by women-led ventures depending on stage of business development. Companies that have not achieved sales were more likely to emphasize bootstrapping to reduce labour, while those companies with greater sales were more likely to minimize cost of operations. Implications for future research and education are suggested.},
number = {1},
urldate = {2017-03-28},
journal = {Venture Capital},
author = {Brush, Professor Candida G. and Carter, Nancy M. and Gatewood, Elizabeth J. and Greene, Patricia G. and Hart, Myra M.},
month = jan,
year = {2006},
keywords = {bootsrapping, growth, private equity, Women entrepreneurs},
pages = {15--31},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/7EFAH2QI/Brush et al. - 2006 - The use of bootstrapping by women entrepreneurs in.html:text/html}
}

@article{gundry_ambitious_2001,
title = {The ambitious entrepreneur: {High} growth strategies of women-owned enterprises},
volume = {16},
issn = {0883-9026},
shorttitle = {The ambitious entrepreneur},
url = {http://www.sciencedirect.com/science/article/pii/S0883902699000592},
doi = {10.1016/S0883-9026(99)00059-2},
abstract = {During the last two decades, researchers have sought to develop categories of entrepreneurs and their businesses along a variety of dimensions to better comprehend and analyze the entrepreneurial growth process. Some of this research has focused on differences related to industrial sectors, firm size, the geographical region in which a business is located, the use of high-technology or low-technology, and the life-cycle stage of the firm (i.e., start-up vs. more mature, formalized companies). Researchers have also considered ways in which entrepreneurs can be differentiated from small business managers. One of these classifications is based on the entrepreneur's desire to grow the business rapidly. This is the focus of our study.
To date, the media have paid considerable attention to rapidly growing new ventures. However, still lacking are large-scale research studies guided by theory through which we can expand our knowledge of the underlying factors supporting ambitious expansion plans. Some research has identified factors that enhance or reduce the willingness of the entrepreneur to grow the business. Factors include the strategic origin of the business (i.e., the methods and paths through which the firm was founded); previous experience of the founder/owner; and the ability of the entrepreneur to set realistic, measurable goals and to manage conflict effectively.
Our study attempted to identify the strategic paths chosen by entrepreneurs and the relation of those paths to the growth orientation of the firm. The entrepreneurs sampled in this study are women entrepreneurs across a wide range of industrial sectors. Recent reviews of entrepreneurship research have suggested the need for more studies comparing high-growth firms with slower-growth firms to better delineate their differences in strategic choices and behaviors.
Our study sought to answer the following questions: What characterizes a “high growth-oriented entrepreneur?” Is this distinction associated with specific strategic intentions, prior experience, equity held in previous firms, the type of company structure in place, or success factors the entrepreneur perceives are important to the business? Do “high growth” entrepreneurs show greater entrepreneurial “intensity” (i.e., commitment to the firm's success)? Are they willing to “pay the price” for their own and their firm's success? (i.e., the “opportunity costs” associated with business success and growth). Other relationships under investigation included different patterns of financing the business' start-up and early growth. Do “high-growth” entrepreneurs use unique sources of funding compared with “lower-growth” entrepreneurs?
Eight hundred thirty-two entrepreneurs responded to a survey in which they were asked to describe their growth intentions along nineteen strategic dimensions, as well as respond to the foregoing questions. Some of the strategic activity measures included adding a new product or service, expanding operations, selling to a new market, and applying for a loan to expand operations. Actual growth rates based on sales revenues were calculated, and average annualized growth rates of the industrial sectors represented in the sample were obtained. This study showed that high-growth-oriented entrepreneurs were clearly different from low-growth-oriented entrepreneurs along several dimensions. The former were much more likely to select strategies for their firms that permitted greater focus on market expansion and new technologies, to exhibit greater intensity towards business ownership (“my business is the most important activity in my life”), and to be willing to incur greater opportunity costs for the success of their firms (“I would rather own my own business than earn a higher salary while employed by someone else”).
The high-growth–oriented entrepreneurs tended to have a more structured approach to organizing their businesses, which suggests a more disciplined perception of managing the firm. In summary, results showed the group of high-growth–oriented entrepreneurs, labeled “ambitious,” as having the following distinctions: strategic intentions that emphasize market growth and technological change, stronger commitment to the success of the business, greater willingness to sacrifice on behalf of the business, earlier planning for the growth of the business, utilization of a team-based form of organization design, concern for reputation and quality, adequate capitalization, strong leadership, and utilization of a wider range of financing sources for the expansion of the venture. The purpose in uncovering these differences is to enable entrepreneurs and researchers to identify more clearly the attributes of rapid-growth ventures and their founders and to move closer to a field-based model of the entrepreneurial growth process which will help delineate the alternative paths to venture growth and organizational change.},
number = {5},
urldate = {2017-03-28},
journal = {Journal of Business Venturing},
author = {Gundry, Lisa K and Welsch, Harold P},
month = sep,
year = {2001},
pages = {453--470},
file = {ScienceDirect Full Text PDF:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/98R9EGFM/Gundry and Welsch - 2001 - The ambitious entrepreneur High growth strategies.pdf:application/pdf;ScienceDirect Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/5VID9HCF/Gundry and Welsch - 2001 - The ambitious entrepreneur High growth strategies.html:text/html}
}

@article{de_bruin_advancing_2007,
title = {Advancing a {Framework} for {Coherent} {Research} on {Women}'s {Entrepreneurship}},
volume = {31},
issn = {1540-6520},
url = {http://onlinelibrary.wiley.com/doi/10.1111/j.1540-6520.2007.00176.x/abstract},
doi = {10.1111/j.1540-6520.2007.00176.x},
language = {en},
number = {3},
urldate = {2017-03-28},
journal = {Entrepreneurship Theory and Practice},
author = {De Bruin, Anne and Brush, Candida G. and Welter, Friederike},
month = may,
year = {2007},
pages = {323--339},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/HARBD3QD/De Bruin et al. - 2007 - Advancing a Framework for Coherent Research on Wom.html:text/html}
}

@article{brush_exploration_2001,
title = {Exploration of the {Venture} {Capital} {Industry}: {Is} {Gender} an {Issue}?},
shorttitle = {Exploration of the {Venture} {Capital} {Industry}},
url = {http://digitalknowledge.babson.edu/eshppw/17},
journal = {Venture Capital},
author = {Brush, Candida},
month = jan,
year = {2001},
file = {Untitled Attachment:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/FBFSEK3R/Brush - 2001 - Exploration of the Venture Capital Industry Is Ge.html:text/html}
}

@article{teresa_nelson_women_2009,
title = {Women entrepreneurs and venture capital: managing the shadow negotiation},
volume = {1},
issn = {1756-6266},
shorttitle = {Women entrepreneurs and venture capital},
url = {http://www.emeraldinsight.com/doi/abs/10.1108/17566260910942345},
doi = {10.1108/17566260910942345},
number = {1},
urldate = {2017-03-28},
journal = {International Journal of Gender and Entrepreneurship},
author = {{Teresa Nelson} and {Sylvia Maxfield} and {Deborah Kolb}},
month = mar,
year = {2009},
pages = {57--76},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/SJKTSKCI/Teresa Nelson et al. - 2009 - Women entrepreneurs and venture capital managing .html:text/html}
}

@article{sass_rubin_venture_2010,
title = {Venture {Capital} and {Underserved} {Communities}},
volume = {45},
issn = {1078-0874},
url = {http://journals.sagepub.com/doi/abs/10.1177/1078087410361574},
doi = {10.1177/1078087410361574},
abstract = {Access to equity capital is critical for the growth of businesses, especially for young companies, which lack the cash flows necessary to repay loans. To meet this need, a thriving venture capital industry has evolved, fostering job creation, economic growth, and innovation in the United States. Not all companies, however, have been equally able to access such investments. Firms owned by women and people of color and those located in rural and distressed urban regions of the country have been underserved by the venture capital industry. This note analyzes the factors responsible for this and proposes policies designed to ensure a more equitable economic landscape.},
language = {en},
number = {6},
urldate = {2017-03-28},
journal = {Urban Affairs Review},
author = {Sass Rubin, Julia},
month = jul,
year = {2010},
pages = {821--835},
file = {SAGE PDF Full Text:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/GQM5CSIW/Sass Rubin - 2010 - Venture Capital and Underserved Communities.pdf:application/pdf}
}

@article{kim_klyver_entrepreneurial_2007,
title = {Entrepreneurial network composition: {An} analysis across venture development stage and gender},
volume = {22},
issn = {0964-9425},
shorttitle = {Entrepreneurial network composition},
url = {http://www.emeraldinsight.com/doi/full/10.1108/09649420710836344},
doi = {10.1108/09649420710836344},
number = {8},
urldate = {2017-03-28},
journal = {Women in Management Review},
author = {{Kim Klyver} and {Siri Terjesen}},
month = nov,
year = {2007},
pages = {682--688},
file = {Full Text PDF:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/KUW4S3SB/Kim Klyver and Siri Terjesen - 2007 - Entrepreneurial network composition An analysis a.pdf:application/pdf;Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/UIR9JTUZ/Kim Klyver and Siri Terjesen - 2007 - Entrepreneurial network composition An analysis a.html:text/html}
}

@article{sila_women_2016,
title = {Women on board: {Does} boardroom gender diversity affect firm risk?},
volume = {36},
issn = {0929-1199},
shorttitle = {Women on board},
url = {http://www.sciencedirect.com/science/article/pii/S0929119915001248},
doi = {10.1016/j.jcorpfin.2015.10.003},
abstract = {We investigate the relationship between boardroom gender diversity and firm risk. To identify a causal effect of gender on risk, we use a dynamic model that controls for reverse causality and for gender and risk being influenced by unobservable firm factors. We find no evidence that female boardroom representation influences equity risk. We also show that findings of a negative relationship between the two variables are spurious and driven by unobserved between-firm heterogeneous factors.},
urldate = {2017-03-28},
journal = {Journal of Corporate Finance},
author = {Sila, Vathunyoo and Gonzalez, Angelica and Hagendorff, Jens},
month = feb,
year = {2016},
keywords = {Board of directors, Endogeneity, Equity risk, Gender diversity},
pages = {26--53},
file = {ScienceDirect Full Text PDF:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/TVIJSMZQ/Sila et al. - 2016 - Women on board Does boardroom gender diversity af.pdf:application/pdf;ScienceDirect Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/463QZXFT/Sila et al. - 2016 - Women on board Does boardroom gender diversity af.html:text/html}
}

@misc{noauthor_pg_nodate,
type = {Text},
title = {Pg 22 {\textbar} {Corporate} {Governance}},
url = {http://www.catalyst.org/knowledge/topics/corporate-governance},
abstract = {Pg 22 {\textbar} Leadership at the top of corporations shapes companies, communities, and societies. A gender-diverse board of directors and senior leadership team (C-suite) will help corporations lead and manage sustainable, effective business strategies, role model employee opportunities, and enhance their reputation.},
urldate = {2017-03-28},
journal = {Catalyst},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/5KCNCMT3/Pg 22 Corporate Governance.html:text/html}
}

@article{greene_patterns_2001,
title = {Patterns of venture capital funding: {Is} gender a factor?},
volume = {3},
issn = {1369-1066},
shorttitle = {Patterns of venture capital funding},
url = {http://dx.doi.org/10.1080/13691060118175},
doi = {10.1080/13691060118175},
abstract = {Since the early 1980s, new ventures with high growth potential and large capital needs have found an ever-increasing pool of venture capital available to support their growth. However, the flow of venture capital investment to women-led businesses remains meager in spite of the fact that in the US and Europe an increasing number of businesses are owned by women. The apparent disparity between potential investment opportunity and actual deals made between venture capital firms and women-led businesses raises the question of whether gender is an issue. The majority of venture capital studies investigate equity funds flows, investor criteria and the nature of the investor-investee relationship. Research on women entrepreneurs focuses on psychological dimensions, business characteristics and performance. Questions about the intersection of gender and venture capital financing are largely unexamined. This exploratory study utilizes longitudinal data to track US venture capital investments by proportion, stage, industry and gender. The descriptive statistics and our analysis of the findings suggest several hypotheses to explain the apparent gender gap.},
number = {1},
urldate = {2017-03-28},
journal = {Venture Capital},
author = {Greene, Patricia G. and Brush, Candida G. and Hart, Myra M. and Saparito, Patrick},
month = jan,
year = {2001},
keywords = {Gender, Human Capital, Strategic Choice, Structural Barriers},
pages = {63--83},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/DPQSX9X2/Greene et al. - 2001 - Patterns of venture capital funding Is gender a f.html:text/html}
}

@misc{teare_first_nodate,
title = {The first comprehensive study on women in venture capital and their impact on female founders},
url = {http://social.techcrunch.com/2016/04/19/the-first-comprehensive-study-on-women-in-venture-capital/},
abstract = {The CrunchBase Women in Venture report is the third study in our ongoing analysis of women and their participation in the startup ecosystem. This report..},
urldate = {2017-03-28},
journal = {TechCrunch},
author = {Teare, Gené and Desmond, Ned},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/DN65KRJK/Teare and Desmond - The first comprehensive study on women in venture .html:text/html}
}

@book{hart_emergence_2003,
title = {The {Emergence} of {Entrepreneurship} {Policy}: {Governance}, {Start}-{Ups}, and {Growth} in the {U}.{S}. {Knowledge} {Economy}},
isbn = {978-1-139-44078-3},
shorttitle = {The {Emergence} of {Entrepreneurship} {Policy}},
abstract = {This volume seeks to catalyze the emergence of a novel field of policy studies: entrepreneurship policy. Practical experience and academic research both point to the central role of entrepreneurs in the process of economic growth and to the importance of public policy in creating the conditions under which entrepreneurial companies can flourish. The contributors, who hail from the disciplines of economics, geography, history, law, management, and political science, seek to crystallize key findings and to stimulate debate about future opportunities for policy-makers and researchers in this area. The chapters include surveys of the economic, social, and cultural contexts for US entrepreneurship policy; assessments of regional efforts to link knowledge producers to new enterprises; explorations of policies that aim to foster entrepreneurship in under-represented communities; detailed analyses of three key industries (biotechnology, e-commerce, and telecommunications); and considerations of challenges in policy implementation.},
language = {en},
publisher = {Cambridge University Press},
author = {Hart, David M.},
month = oct,
year = {2003},
note = {Google-Books-ID: 2fo6eEp42J4C},
keywords = {Business \& Economics / Economics / General, Business \& Economics / General, Business \& Economics / Industrial Management, Political Science / General, Political Science / Public Policy / Economic Policy, Social Science / Sociology / General}
}

@article{shrader_women_1997,
title = {Women {In} {Management} {And} {Firm} {Financial} {Performance}: {An} {Exploratory} {Study}},
volume = {9},
issn = {1045-3695},
shorttitle = {Women {In} {Management} {And} {Firm} {Financial} {Performance}},
url = {http://www.jstor.org/stable/40604152},
abstract = {This study explores relationships of women in management positions with firm financial performance. Utilizing the resource-based theory of competitive advantage, as well as stakeholder and diversity arguments, we hypothesize that firms employing greater percentages of women managers at the general management, top management, and board of director levels will experience relatively better financial performance. Examining data from the Wall Street Journal for 200 large firms, we find positive relationships between the firm's total percentage of women managers and ROS, ROA, ROI, and ROE. High percentages of women top managers and board members did not predict performance.},
number = {3},
urldate = {2017-03-28},
journal = {Journal of Managerial Issues},
author = {Shrader, Charles B. and Blackburn, Virginia B. and Iles, Paul},
year = {1997},
pages = {355--372}
}

@techreport{brush_diana_2008,
address = {Rochester, NY},
type = {{SSRN} {Scholarly} {Paper}},
title = {The {Diana} {Project}: {Women} {Business} {Owners} and {Equity} {Capital}: {The} {Myths} {Dispelled}},
shorttitle = {The {Diana} {Project}},
url = {https://papers.ssrn.com/abstract=1262312},
abstract = {This report from the Diana Project explores the extent of equity investments in women-owned businesses. Surveyed were 1,700 applicants to the 2000 Springboard f},
number = {ID 1262312},
urldate = {2017-03-28},
institution = {Social Science Research Network},
author = {Brush, Candy and Carter, Nancy M. and Gatewood, Elizabeth J. and Greene, Patricia G. and Hart, Myra},
month = sep,
year = {2008},
keywords = {Equity capital, Female entrepreneurs, Female owned businesses, Firm growth, Gender, Venture capital}
}

@misc{noauthor_female-founded_nodate,
title = {Female-founded, {VC}-funded: {The} numbers behind venture investment in women [datagraphic] {\textbar} {PitchBook} {News}},
shorttitle = {Female-founded, {VC}-funded},
url = {https://pitchbook.com/news/articles/female-founded-vc-funded-the-numbers-behind-venture-investment-in-women-datagraphic},
abstract = {In honor of Women’s History Month, we’re releasing a collection of data on female-founded companies with VC backing.},
urldate = {2017-03-28},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/VVKVZBFS/Female-founded, VC-funded The numbers behind vent.html:text/html}
}

@article{harrison_does_2007,
title = {Does {Gender} {Matter}? {Women} {Business} {Angels} and the {Supply} of {Entrepreneurial} {Finance}},
volume = {31},
issn = {1540-6520},
shorttitle = {Does {Gender} {Matter}?},
url = {http://onlinelibrary.wiley.com/doi/10.1111/j.1540-6520.2007.00182.x/abstract},
doi = {10.1111/j.1540-6520.2007.00182.x},
abstract = {There is a substantial literature on the relationship between gender and access to finance. However, most studies have been concerned with access to debt finance. More recently, the focus of this research has broadened to examine women and venture capital. This article extends the focus further by examining the role of women in the business angel market, which is more important than the formal venture capital market in terms of both the number of ventures supported and total capital flows. Based on a detailed analysis of business angels in the U.K., the study concludes that women investors who are active in the market differ from their male counterparts in only limited respects. Future research into women business angels, and the possible existence of gender differences, needs to be based on more fully elaborated standpoint epistemologies that focus on the experience of the woman angel investor per se, and center on the examination of the role of homophily, social capital, networking, and competition in investment behavior.},
language = {en},
number = {3},
urldate = {2017-03-28},
journal = {Entrepreneurship Theory and Practice},
author = {Harrison, Richard T. and Mason, Colin M.},
month = may,
year = {2007},
pages = {445--472},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/QUVINADF/Harrison and Mason - 2007 - Does Gender Matter Women Business Angels and the .html:text/html}
}

@techreport{brush_gatekeepers_2004,
address = {Rochester, NY},
type = {{SSRN} {Scholarly} {Paper}},
title = {Gatekeepers of {Venture} {Growth}: {A} {Diana} {Project} {Report} on the {Role} and {Participation} of {Women} in the {Venture} {Capital} {Industry}},
shorttitle = {Gatekeepers of {Venture} {Growth}},
url = {https://papers.ssrn.com/abstract=1260385},
abstract = {Women have received a disproportionately low share of available venture capital in the United States. This study provides the first overview of women decision},
number = {ID 1260385},
urldate = {2017-03-28},
institution = {Social Science Research Network},
author = {Brush, Candida G. and Carter, Nancy M. and Gatewood, Elizabeth J. and Greene, Patricia G. and Hart, Myra},
year = {2004},
keywords = {Barriers to growth, Female entrepreneurs, Female owned businesses, Females, Managers, Venture capital, Venture capitalists},
file = {Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/XD84WIHI/Brush et al. - 2004 - Gatekeepers of Venture Growth A Diana Project Rep.html:text/html}
}

@article{chrisman_comparison_1990,
title = {A comparison of assistance needs of male and female pre-venture entrepreneurs},
volume = {5},
issn = {0883-9026},
url = {http://www.sciencedirect.com/science/article/pii/088390269090019P},
doi = {10.1016/0883-9026(90)90019-P},
abstract = {In spite of the proliferation of studies of female entrepreneurs, few researchers have attempted to directly compare female and male entrepreneurs in terms of their problems, the assistance received in addressing these problems, the value of outside consulting services, and the number of startups subsequent to counseling. Such studies are needed, not only to determine if there are differences in the problems male and female entrepreneurs face, but more importantly, to determine if any of these differences affect the successful development of new ventures. The fact that the SBA recently established a special training program for women entrepreneurs funded by a new \$10 million grant, approved by Congress in 1988 (H.R. 5050), makes the issue even more timely and pertinent. To address this issue, this article compares samples of aspiring male and female entrepreneurs who received consulting assistance from a state-level Small Business Development Center (SBDC). The two groups were compared in terms of: (1) the strategic, administrative, and operating assistance received; (2) their evaluation of the value of the consulting services; and (3) their propensity to initiate ventures after receiving SBDC assistance. The study was based on the results of two surveys of the entire population of 457 long-term pre-venture clients that received counseling from one SBDC state system between July 1, 1985, and June 30, 1987. All clients were asked to complete a questionnaire concerning the kinds of assistance sought, the quality of the service received, and whether or not they subsequently went into business. We received 162 (35.4\%) usable responses, of which 94 were from males (58.0\%) and 68 were from females (42.0\%). T-tests and chi-square tests of independence and goodness-of-fit were used to test hypotheses pertaining to the assistance needs of aspiring male and female entrepreneurs. Results indicated that male and female clients of the SBDC are virtually identical in terms of their assistance needs. Females do not appear to need more assistance than males, nor do they appear to require different types of assistance. The virtually identical ratings of service value among males and females also indicates that both genders are equally satisfied with the assistance received. Taken together, these findings suggest that females suffer no significant entrepreneurial disadvantages compared to males. If they had, it would be logical to assume that females, who received the same types and amounts of assistance as males, would find such levels of service inadequate, and consequently, rate it less favorably. Furthermore, the fact that the proportion of female clients was statistically equal to the proportion of net new businesses operated by women refutes the notion that general-assistance programs such as the SBDC are not equally accessible to both genders. The fact that female client start-ups were significantly higher than their proportional representation in the region further supports this conclusion. The primary implication for public policy makers and outside consultants is that little evidence exists to warrant special treatment or special programs for females, especially at a cost of \$10 million. In terms of research implications, our results suggest that it would be better if future studies concentrated on behaviors and strategic factors affecting the performance of new ventures (whether male-or female-owned), rather than merely comparing the characteristics of the entrepreneurs who start them.},
number = {4},
urldate = {2017-03-28},
journal = {Journal of Business Venturing},
author = {Chrisman, James J. and Carsrud, Alan L. and DeCastro, Julio and Herron, Lanny},
month = jul,
year = {1990},
pages = {235--248},
file = {ScienceDirect Full Text PDF:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/2KEMBAB6/Chrisman et al. - 1990 - A comparison of assistance needs of male and femal.pdf:application/pdf;ScienceDirect Snapshot:/Users/carlin/Library/Application Support/Zotero/Profiles/c5jhnzb8.default/zotero/storage/9BBM2EQV/Chrisman et al. - 1990 - A comparison of assistance needs of male and femal.html:text/html}
}

@article{ahern_changing_2012,
title = {The {Changing} of the {Boards}: {The} {Impact} on {Firm} {Valuation} of {Mandated} {Female} {Board} {Representation}},
volume = {127},
issn = {0033-5533},
shorttitle = {The {Changing} of the {Boards}},
url = {https://academic.oup.com/qje/article/127/1/137/1832366/The-Changing-of-the-Boards-The-Impact-on-Firm},
doi = {10.1093/qje/qjr049},
number = {1},
urldate = {2017-03-28},
journal = {The Quarterly Journal of Economics},
author = {Ahern, Kenneth R. and Dittmar, Amy K.},
month = feb,
year = {2012},
pages = {137--197}
}

==data found by other studies==

@article{ahl2006metaresearch},
title={Why Research on Women Entrepreneurs Needs New Directions},
author={Ahl, Helene},
journal={Entrepreneurship Theory and Practice}
volume={30}
Issue={5}
page={595-621}
abstract={Research articles on women's entrepreneurship reveal, in spite of intentions to the contrary and in spite of inconclusive research results, a tendency to recreate the idea of women as being secondary to men and of women's businesses being of less significance or, at best, as being a complement. Based on a discourse analysis, this article discusses what research practices cause these results. It suggests new research directions that do not reproduce women's subordination but capture more and richer aspects of women's entrepreneurship.},
URL={http://onlinelibrary.wiley.com/doi/10.1111/j.1540-6520.2006.00138.x/full}
}

Has some interesting meta-theories that we could apply to our research of women in entrepreneurship.

@article{scottincrease},
title={Why More Women Are Becoming Entrepreneurs},
author={Scott, Carole E.},
journal={Journal of Small Business Management}
abstract={From 1972 to 1982 the number of self-employed women in the United States increased by 69 percent. This represented a rate of increase five times greater than that for men in the same period. From 1977 to 1980 the proportion of non-farm, sole proprietorships operated by women increased from 22.6 percent to 26.1 percent. In addition, the number of non-farm, sole proprietorships operated by couples soared from 284,405 in 1981 to 440,000 in 1982. To find out why women are turning to entrepreneurship in increasing numbers, two surveys were conducted: one of women entrepreneurs in the state of Georgia, and another of both male and female entrepreneurs in the Atlanta area for purposes of comparison.},
URL={https://www.questia.com/library/journal/1G1-4587543/why-more-women-are-becoming-entrepreneurs}
}

Says number of self employed women skyrocked between 1972-1982 (of course, this could just be because more women were entering the workplace in general during this time).

@article{cetindmar2011turkey},
title={What the numbers tell: The impact of human, family and financial capital on women and men's entry into entrepreneurship in Turkey},
author={Cetindamar, Dilek},
journal={Journal of Entrepreneurship and Regional Development}
volume={24}
issue={1,2}
page={29-51}
year={2011}
abstract={Entrepreneurship contributes to economic development in countries worldwide. Entrepreneurial activity is beneficial for both men and women, including those in developing countries. However, men and women may not engage in entrepreneurship to the same extent because of differential access to (various forms of) capital. This study examines the relative importance of three types of capital – human, family and financial – in pursuing entrepreneurship. Using data collected in Turkey, we find that regardless of sex, all three forms of capital influence the likelihood of becoming an entrepreneur in varying degrees. Contrary to expectations, the impact of human capital on the likelihood of becoming an entrepreneur is higher for women than men. Data also revealed that family capital facilitates women's entry into entrepreneurship only when family size is very large (i.e. seven or more). No gender differences are observed in the impact of financial capital on the likelihood of becoming an entrepreneur. Findings suggest that to encourage entrepreneurship in Turkey, policy-makers should emphasize access to human and financial capital. Furthermore, findings suggest that women's likelihood of becoming an entrepreneur will be especially encouraged if they have increased access to education, as well as the skills necessary to take advantage of their family capital.},
URL={https://www.questia.com/library/journal/1G1-4587543/why-more-women-are-becoming-entrepreneurs}
}

Unfortunately this study was done in Turkey but they found that "No gender differences are observed in the impact of financial capital on the likelihood of becoming an entrepreneur"

===Research for women on boards specifically==

@article{ahern2012valuation},
title={The Changing of the Boards: The Impact on Firm Valuation of Mandated Female Board Representation},
author={Ahern, Kenneth and Dittmar, Amy},
journal={The Quarterly Journal of Economics}
year={2012}
abstract={In 2003, a new law required that 40% of Norwegian firms' directors be women—at the time only 9% of directors were women. We use the prequota cross-sectional variation in female board representation to instrument for exogenous changes to corporate boards following the quota. We find that the constraint imposed by the quota caused a significant drop in the stock price at the announcement of the law and a large decline in Tobin's Q over the following years, consistent with the idea that firms choose boards to maximize value. The quota led to younger and less experienced boards, increases in leverage and acquisitions, and deterioration in operating performance.},
URL={https://academic.oup.com/qje/article-abstract/127/1/137/1832366/The-Changing-of-the-Boards-The-Impact-on-Firm?redirectedFrom=fulltext}
}

This study from Norway but is interesting still

@article{sila2016firmrisk},
title={Women on board: Does boardroom gender diversity affect firm risk?},
author={Sila, Vathunyoo and Gonzalez, Angelica},
journal={Journal of Corporate Finance}
volume={36}
page={26-53}
abstract={We investigate the relationship between boardroom gender diversity and firm risk. To identify a causal effect of gender on risk, we use a dynamic model that controls for reverse causality and for gender and risk being influenced by unobservable firm factors. We find no evidence that female boardroom representation influences equity risk. We also show that findings of a negative relationship between the two variables are spurious and driven by unobserved between-firm heterogeneous factors.},
URL={http://www.sciencedirect.com/science/article/pii/S0929119915001248}
}

@article{rose2007danishboards},
title={Does female board representation influence firm performance? The Danish evidence},
author={Rose, Caspar},
journal={Corporate Governance: An International Review}
volume={15}
Issue={2}
page={404-413}
abstract={Board diversity has become a major issue within corporate governance where a number of studies seek to explore the impact of diversity on firm performance. The debate focuses on questions such as whether a corporation’s board should reflect the firm’s stakeholders or be more in line with society in general. This article uses a sample of listed Danish firms during the period of 1998–2001 in a cross sectional analysis. Despite that fact that Denmark has gone very far in the liberalisation of women, Danish board rooms are still to a large extent dominated by men. Contrary to a number of other studies, this article does not find any significant link between firm performance as measured by Tobin’s Q and female board representation. This is also the case for board members’ educational background as well as the proportion of foreigners. It is argued that board members with an unconventional background are socialised unconsciously adopting the ideas of the majority of conventional board members, which entails that a potential performance effect does not materialise.},
URL={http://onlinelibrary.wiley.com/doi/10.1111/j.1467-8683.2007.00570.x/full}
}

Unfortunately is a Danish study. But, Danish board rooms are still to a large extent dominated by men. Contrary to a number of other studies, this article does not find any significant link between firm performance as measured by Tobin’s Q and female board representation.

==External factors that could explain the data==

@article{langowitz2007propensity},
title={The Entrepreneurial Propensity of Women},
author={Langowitz, Nan and Minniti, Maria},
year={2007},
journal={Entrepreneurship Theory and Practice}
volume={31}
issue={3}
pages={341-364}
abstract={Entrepreneurship is becoming an increasingly important source of employment for women across many countries. The level of female involvement in entrepreneurial activity, however, is still significantly lower than that of men. We take a behavioral economics approach and, using a large sample of individuals in 17 countries, we investigate what variables influence the entrepreneurial propensity of women and whether those variables have a significant correlation with differences across genders. In addition to demographic and economic variables, we include a number of perceptual variables. Our results show that subjective perceptual variables have a crucial influence on the entrepreneurial propensity of women and account for much of the difference in entrepreneurial activity between the sexes. Specifically, we find that women tend to perceive themselves and the entrepreneurial environment in a less favorable light than men across all countries in our sample and regardless of entrepreneurial motivation. Our results suggest that perceptual variables may be significant universal factors influencing entrepreneurial behavior.},
URL={http://onlinelibrary.wiley.com/doi/10.1111/j.1540-6520.2007.00177.x/full}
}

Women tend to perceive themselves and the entrepreneurial environment in a less favorable light than men across all countries in our sample and regardless of entrepreneurial motivation.

@article{carter1992family},
title={Women as Entrepreneurs : A Study of Female Business Owners, Their Motivations, Experiences and Strategies for Success},
author={Carter, Sara and Cannon, Tom},
year={1992},
abstract={Intended for business and academic libraries, this book provides case studies of women entrepreneurs. It considers problems which are specific to women in business; these include raising finances, finding clients, and the simultaneous management of domestic commitments, especially childcare.},
filename={Carter et al (1992) - Women as Entrepreneurs: A Study of Female Business Owners, Their Motivations, Experiences, and Strategies for Success}
URL={http://strathprints.strath.ac.uk/47694/}
}

This examines reasons women may or may not become business owners.

@article{birley1987training},
title={Do Women Entrepreneurs Require Different Training?},
author={Birley, Sue, Moss, Caroline, Peter, Saunders},
journal={American Journal of Small Business},
year={1987},
abstract={This paper analyzes the characteristics of male and female participants attending pioneering entrepreneurship development programs, which form part of an economic strategy directed at increasing the quality and quantfty of new firms. The participants did not need to have a business plan, finance available or formal education, but must have had a “reasonably feasible idea”. The results show significant differences between the characteristics of the male and female entrepreneurs, and the businesses which they form. .},
URL={https://core.ac.uk/download/pdf/137594.pdf}
}

This discusses the different characteristics of male and female entrepreneurs.

@article{demartino2003mba},
title={Differences between women and men MBA entrepreneurs: exploring family flexibility and wealth creation as career motivators?},
author={DeMartino, Richard, Barbato, Robert},
journal={Journal of Business Venturing},
volume={18}
pages={815-832}
issue={6}
year={2003},
abstract={Previous research into gender differences among entrepreneurs has yielded varied explanations as to why female entrepreneurs differ from male entrepreneurs. This study explores motivational differences using a sample of MBA entrepreneurs. This allows comparisons between male and female entrepreneurs, who are similar in terms of business education, educational credentials, and other important variables. Logistic regression is used to measure the relationship between career motivators and gender and between career motivators and gender adjusted for marital status and the presence of dependent children. The study concludes that differences between female and male entrepreneurs become larger if the entrepreneurs are married with dependent children.}
URL={http://www.sciencedirect.com/science/article/pii/S088390260300003X}
}

Study found that differences between male/female entrepreneurs largest when they're married with dependent children as opposed to unmarried.

@article{zapalska1997psychpoland},
title={A profile of woman entrepreneurs and enterprises in Poland},
author={Zapalska, Alina},
journal={Journal of Small Business Management},
pages={76-82}
year={1997},
abstract={A study investigates whether Polish female entrepreneurs possess the characteristics required for effective performance as entrepreneurs. Trait analysis suggests that there are no significant differences between the psychological propensities of successful female and male entrepreneurs. The study also explores the types of businesses started by Polish women, their business objectives, and the relationship between the entrepreneur's background and the entrepreneur's decision to start a new venture.}
URL={http://search.proquest.com/docview/220989307?pq-origsite=gscholar}
}

This study found that male and female entrepreneurs don't differ too much psychologically (compared to the study cited above).

@article{cohoon2010differences},
title={Are Successful Women Entrepreneurs Different from Men?},
author={Cohoon, J, Wadhwa, Vivek, Mitchell, Lesa},
journal={Journal of Small Business Management},
pages={1-16}
year={2010},
abstract={Women are one particularly understudied group of entrepreneurs. We know very little about female entrepreneurs, and our ignorance of this important demographic is a serious blind spot in any effort to increase the total number of entrepreneurs participating in our economy. What little we do know suggests that women are not nearly as active in the entrepreneurial space as they could be.

This study attempts to address part of this knowledge gap. This based on data were collected in 2008-2009 from 549 respondents from randomly selected high-tech companies who were invited to participate. It compares the backgrounds, and experiences and motivations of men and women entrepreneurs.

Our findings show that successful women and men entrepreneurs are similar in almost every respect. They had equivalent levels of education (slightly less than half earned graduate degrees), early interest in starting their own business (about half had at least some interest), a strong desire to build wealth or capitalize on a business idea, access to funding, and they largely agreed on the top issues and challenges facing any entrepreneur.

The data also identify some small but potentially informative gender differences among successful entrepreneurs. For instance, motivations for starting a business differed slightly between men and women. The latter were more likely to cite a business partner’s encouragement as a key incentive to take the plunge. Women also were more likely than men to get early funding from their business partners.}
URL={http://search.proquest.com/docview/220989307?pq-origsite=gscholar}
}

This study found that male and female entrepreneurs don't differ too much psychologically, only minutely in their reasons for starting a business.

==Impacts from less women in VC/entrepreneurship fields==

@article{pines2011financialcrisis},
title={Gender differences in entrepreneurship: Equality, diversity and inclusion in times of global crisis},
author={Pines, Ayala, Lerner, Miri, Schwartz, Dafna},
journal={Equality, Diversity, and Inclusion: An International Journal},
year={2010},
abstract={ In 2008, the world had undergone a global economic crisis. Since women always face greater difficulties in obtaining capital than men, the economic crisis had a greater effect on them. The purpose of this paper is to examine the implications of the global crisis for women's entrepreneurship, from the perspective of equality, diversity and inclusion.}
URL={http://www.emeraldinsight.com/doi/abs/10.1108/02610151011024493}
}

This study found that the rates of women's entrepreneurship are lower than men's. Furthermore, the percent of women entrepreneurs is higher in countries where the general income per capita is small and where women have no other option for making a living.

Women in Entrepreneurship Lit Review

2017-03-28T20:34:57Z

Carlin:

Carlin Cherry (Work Log)

2017-03-28T19:29:40Z

Carlin: /* Spring 2017 */

==Spring 2017==
3/28/17 2-4:30 - redoing lit review with updated dates for [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

3/24/17 12:45-2 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

3/22/17 12:45-2, 4-5:30 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

3/21/17 2:15-4:45 - write up plan for rest of semester, think of ways to fix doctor problem in data + redo c-level to include everything in addition to ceo+founder

3/20/17 11:00-12:15 - refamiliarizing self with project since I've been gone for 2 weeks, starting some analysis, making plan to complete project by end of term

3/8/17 12:45-2 - run regressions and analysis, hopefully write and finish blog post

3/7/17 2:30-5 - finish cleaning Women2017 dataset, data analysis, hopefully start to write article

3/6/17 11:50-1:05, 4-4:30 - finish cleaning Women2017 dataset

3/3/17 10:30-10:45, 12:45-2 - finish cleaning Women2017 dataset

3/1/17 12:45-2 - continue cleaning Women2017 dataset

2/28/17 2:20-4:50 - load company, people, title lookup, statalookup

2/27/17 11:45-1 - going through excel sheet and assigning 1's to people in relevant positions of power

2/24/17 12:45-2 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/22/17 12:45-2, 4-5:30 - stata with Ed, continue writing report [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/21/17 2:30-5:15 - run regressions on new "realbig" dataset using performance measure, men in power, etc.

2/20/17 11:50-1:05 - build new dataset to contain men and year variables, stata practice at very end for a bit just to remember what I'm doing

2/16/17 12:45-2 - stata learning

2/15/17 12:30-2, 4-5:30 - continuing drafting report, regression hopefully this afternoon with ed

2/14/15 2:20 - 4:50 - building combined table with coname, womenceo?, womeninpower?, #powerpos, state, yearfirstinvest, norounds, tot$invest

2/13/17 12-1:15 - detailing plan for building combined table with coname, womenceo?, womeninpower?, #powerpos, state, yearfirstinvest, norounds, tot$invest

2/8/17 12:45-2 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/7/17 2:20-4:50 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/6/16 12:45 - 2 - try to find some results grouped by state

2/2/17 12:45-2 - redo sdc pulls so I can group by state, etc.

2/1/17 - 12:45-2, 4-5:30 - start building tables [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

1/31/17 1:45 - 4:30 - a lot of working with sdc and pulling appropriate data, put new sdc pulls through normalizer script

1/30/17 12:45-2 - redid the sdc pulls so they could be put through normalizer script

1/27/17 12:45-2 - start building tables using normalized sdc data

1/25 12:45-2, 4-5:30 - SDC pull, rerun through tables w new added variables (i.e. industry, etc)

1/24/17 11:45-1:00, 2:30-5:15 - revisiting women in entrepreneurship [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)#To-do], oil&gas industry innovation project planning [http://mcnair.bakerinstitute.org/wiki/Innovation_in_the_Oil_and_Gas_Industry]

1/20/17 12:30-2 - accelerator data, hopefully the last day!

1/19/17 2:30-4:15 - accelerator data....still....

1/18/17 12-1:30 - accelerator data

1/17/17 2:30-4:30 - backtracked blog posts and posted them on facebook

1/13/17 12:45-2 - twitter, accelerator data

1/12/17 2-4 - accelerator data

1/11/17 12-2, 4-5 - accelerator data

1/10/17 2:30-4:30 - accelerator data, mining for twitter articles

1/9/17 12:45-2 - review and analysis of past semester per Ed's request, possibly hootsuite and twitter

==Fall 2016==
8/31/16 3:00-5:00 - Set up Bio page, Work Logs, poked around on Wiki.

9/1/16 2:20-3:50 - Hootsuite setup and tweets.

9/2/16 3:00-5:30 - Classified all remaining uncategorized pages, wrote norms for blog posts and tweeting, worked with Anne on Hootsuite.

9/6/16 2:30-4, 5:30-6 - Helped new staff members set up their pages, worked with Twitter/Hootsuite, started writing workplace norms on [[Help for new staff]]

9/7/16 12:30-2, 3-5:30 - Hootsuite/Twitter scheduling, recategorized Projects on Project management page by adding Priority, Due Date, and Stage (see https://mcnaircenter.slack.com/messages/wikicategorization/ for details), brainstormed ideas for mcnair center for this semester w Julia, Ramee, Albert

9/8/16 2:30-3:40 - http://www.mcnaircenter.org/wiki/Women_in_Entrepreneurship_(Issue_Brief), meeting with Twitter team

9/9/16 12:30-2 - helped Catherine set up her pages, read Health Innovation documents sent by Accenture, brainstormed potential collaboration with them

9/13/16 2:00-4:00 - research on Space startups for a potential blog post, research ideas for cross collaboration project with law professor, twitter

9/14/16 3:00-4:30 - reading Tay's blog post on Women in Entrep, brainstorming topics for women in entrep blog series, researching my topic area for said blog series [[Women in Innovation and Entrepreneurship: 2nd In Blog Series]]

9/15/16 10:30-12, 2:30-4 - [[Women in Innovation and Entrepreneurship: 2nd In Blog Series]]

9/20/16 9:30-10:30, 2:30-4 - Hootsuite, Forbes's Women in Entrepreneurship, [[Women in Innovation and Entrepreneurship: 2nd In Blog Series]], meeting w albert and ed

9/21/16 12:45-2, 3-5:30 - Hootsuite, general article research, working connections to get patent lawyer here, started [[Spotlight on Innovation: Space]]

9/22/16 2:20-3:50 - mcnair shirt design, doodle poll for mcnair party, continue researching [[Spotlight on Innovation: Space]]

9/23/16 12:30-2 - call tshirt people, write shirt proposal, doodle poll for mcnair meeting

9/27/16 10-12, 2:30-4 - [[Clinton/Trump Debate]] - will finish on 9/28

9/28/16 12:45-2, 2:45-5:15 - [[Clinton/Trump Debate]], organize the mcnair staff meeting

9/29/16 1:15-4 - met with Albert, Ed, and Anne to discuss McNair management things, space research, podcasts, linkedin

10/4/16 2:20-3:50 - [[Small Business Development Ecosystem of Houston]]

10/5/16 12:45-2, 3-5:30 - [[Small Business Development Ecosystem of Houston]]

10/6/16 10-12, 2:20-3:50 - finishing resource descriptions for [[Small Business Development Ecosystem of Houston]]

10/7/16 12:45-2 - linked blogs to external sources (http://mcnair.bakerinstitute.org/blog/trumppence-entrepreneurship/ and http://mcnair.bakerinstitute.org/blog/clintonkaine-entrepreneurship/), wrote final edits before they were published

10/12/16 12:30-2, 3-5:30 - twitter, [[Small Business Development Ecosystem of Houston]] - write up the institution wiki pages (https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web) and integrate graphics that Julia did into the wiki page

10/13/16 2:20-3:50 - met with anne re mcnair admin (mcnair center meeting logistics coordination, blog update, work logs logistical issues, table overlay of graphic for small business htx page), continue institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web

10/18/16 9:30-11:30, 2:20-3:50, 5:30-7 - finish institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web, check in w Julia, Ed, and Albert re status of Small Business in HTX, McNair center meeting from 5:30-7!

10/19/16 12:30-2, 3-5:30 - thought we were finished but turns out someone still copied and pasted so we are finishing institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web, developing Ankita meeting agenda with Catherine, phone conference with ankita at 4:30

10/20/16 2:20-3:40 - meeting with Ed, Albert, and Catherine re [[Small Business Development Ecosystem of Houston]] - link to meeting notes can be found here [[HTX Small Biz Meeting Notes]]. Developing ideas for patent thingies

10/21/16 12:45-2 - [[Fall 2016 Project Ideas Page]], email from anne re shirts

10/25/16 9:45-11:45, 2:30-4 - morning: news from weekend, working on idea #2 from [[Fall 2016 Project Ideas Page]] (researching open v closed innovation, read introduction to Henry Chesbrough book [https://books.google.com/books?hl=en&lr=&id=OeLIH89YiMcC&oi=fnd&pg=PR17&dq=innovation+henry+chesbrough&ots=RD7FiTIKj9&sig=HcDqoK7Vl3c9xc0Fu_6wQ10_vgc#v=onepage&q=innovation%20henry%20chesbrough&f=false]) afternoon: learn more about patent data, talk w avesh, start getting info from SDC [[Innovation in the Oil and Gas Industry]]

10/26/16 12:30-2, 3-5:15 - mcnair admin (20 min), SDC acquisitions and mergers data (play around with it)

10/27/16 2:30-4 - work on project page [[Innovation in the Oil and Gas Industry]], twitter articles, SQL workshop from 3-4

10/28/16 12:45-2 - [[Innovation in the Oil and Gas Industry]] SDC planning, help julia with caricatures

11/1/16 10-12, 2:30-4 - morning: mcnair admin (semester performance reviews and meeting 1x a week on thurs from 3-4 to do sql training), upload pics to facebook, afternoon: avesh and i discuss [[Innovation in the Oil and Gas Industry]]

11/2/16 12:45-2, 3-5:30 - interview with East-West tea in early afternoon, writing [[Spotlight on Rice Entrepreneurs: East-West Tea]] in late afternoon

11/3/16 2:30-4 - SQL training

11/4/16 12:45-2 - responding to edits on [[Spotlight on Rice Entrepreneurs: East-West Tea]] and getting peer review

11/8/16 9-12, 2:30-4 - came in a little early this morning since I'll be missing my shifts later this week. finished [[Spotlight on Rice Entrepreneurs: East-West Tea]] and published it on the blog. worked on organizing data from SDC pull of companies (created sql database and tables)

11/9/16 12:45-2 - organizing data from SDC pull of companies (created sql database and tables)

11/15/16 2:30-4 - ed is repurposing me [[VC Policy Report]]

11/16/16 12:45-2, 3-5, 6-7 : first chunk - articles, looking up dates for Ed, editing Julia's moonshot article, admin. second chunk - working with avesh on [[VC Policy Report]]. third chunk - elevator pitch competition for spotlight series

11/17/16 10-12, 2:30-4 : first chunk - writing new blog post article [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], [[VC Policy Report]] second chunk - [[VC Policy Report]]

11/18/16 3-4: finishing up the aggregate data table sql for [[VC Policy Report]]

11/22/16 10-12, 2:10-3:40 - twitter, making interview questions for [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], interview with the winners from 11-12, afternoon: IPO aggregate table work on [[VC Policy Report]].

11/23/16 12:45-2 - ask ben how far he got on ipo aggregate table and act accordingly with [[VC Policy Report]], add some tweets in hootsuite

11/29/16 10-12, 2:30-4 - accelerator data with dylan, fixing east-west page yet again, interview with elevator pitch people from 11-12. afternoon: accelerator data

11/30/16 12:45-2, 3-5:30 - first: finish [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], second: accelerator data

12/1/16 1:30-3:30 - accelerator data

12/2/16 3-4:15 - accelerator data

12/5/16 10-12 - accelerator data

12/6/2016 9-12 - accelerator data

12/7/16 10-12 - hootsuite, revise [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], accelerator data

12/8/16 9-12 - accelerator data, hootsuite, check w/ anne re elevator pitch blog post

[[Internal Classification: Work Logs| ]]
[[Category:Work Log]]

Carlin Cherry (Work Log)

2017-03-24T17:59:12Z

Carlin: /* Spring 2017 */

==Spring 2017==
3/24/17 12:45-2 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

3/22/17 12:45-2, 4-5:30 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

3/21/17 2:15-4:45 - write up plan for rest of semester, think of ways to fix doctor problem in data + redo c-level to include everything in addition to ceo+founder

3/20/17 11:00-12:15 - refamiliarizing self with project since I've been gone for 2 weeks, starting some analysis, making plan to complete project by end of term

3/8/17 12:45-2 - run regressions and analysis, hopefully write and finish blog post

3/7/17 2:30-5 - finish cleaning Women2017 dataset, data analysis, hopefully start to write article

3/6/17 11:50-1:05, 4-4:30 - finish cleaning Women2017 dataset

3/3/17 10:30-10:45, 12:45-2 - finish cleaning Women2017 dataset

3/1/17 12:45-2 - continue cleaning Women2017 dataset

2/28/17 2:20-4:50 - load company, people, title lookup, statalookup

2/27/17 11:45-1 - going through excel sheet and assigning 1's to people in relevant positions of power

2/24/17 12:45-2 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/22/17 12:45-2, 4-5:30 - stata with Ed, continue writing report [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/21/17 2:30-5:15 - run regressions on new "realbig" dataset using performance measure, men in power, etc.

2/20/17 11:50-1:05 - build new dataset to contain men and year variables, stata practice at very end for a bit just to remember what I'm doing

2/16/17 12:45-2 - stata learning

2/15/17 12:30-2, 4-5:30 - continuing drafting report, regression hopefully this afternoon with ed

2/14/15 2:20 - 4:50 - building combined table with coname, womenceo?, womeninpower?, #powerpos, state, yearfirstinvest, norounds, tot$invest

2/13/17 12-1:15 - detailing plan for building combined table with coname, womenceo?, womeninpower?, #powerpos, state, yearfirstinvest, norounds, tot$invest

2/8/17 12:45-2 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/7/17 2:20-4:50 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/6/16 12:45 - 2 - try to find some results grouped by state

2/2/17 12:45-2 - redo sdc pulls so I can group by state, etc.

2/1/17 - 12:45-2, 4-5:30 - start building tables [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

1/31/17 1:45 - 4:30 - a lot of working with sdc and pulling appropriate data, put new sdc pulls through normalizer script

1/30/17 12:45-2 - redid the sdc pulls so they could be put through normalizer script

1/27/17 12:45-2 - start building tables using normalized sdc data

1/25 12:45-2, 4-5:30 - SDC pull, rerun through tables w new added variables (i.e. industry, etc)

1/24/17 11:45-1:00, 2:30-5:15 - revisiting women in entrepreneurship [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)#To-do], oil&gas industry innovation project planning [http://mcnair.bakerinstitute.org/wiki/Innovation_in_the_Oil_and_Gas_Industry]

1/20/17 12:30-2 - accelerator data, hopefully the last day!

1/19/17 2:30-4:15 - accelerator data....still....

1/18/17 12-1:30 - accelerator data

1/17/17 2:30-4:30 - backtracked blog posts and posted them on facebook

1/13/17 12:45-2 - twitter, accelerator data

1/12/17 2-4 - accelerator data

1/11/17 12-2, 4-5 - accelerator data

1/10/17 2:30-4:30 - accelerator data, mining for twitter articles

1/9/17 12:45-2 - review and analysis of past semester per Ed's request, possibly hootsuite and twitter

==Fall 2016==
8/31/16 3:00-5:00 - Set up Bio page, Work Logs, poked around on Wiki.

9/1/16 2:20-3:50 - Hootsuite setup and tweets.

9/2/16 3:00-5:30 - Classified all remaining uncategorized pages, wrote norms for blog posts and tweeting, worked with Anne on Hootsuite.

9/6/16 2:30-4, 5:30-6 - Helped new staff members set up their pages, worked with Twitter/Hootsuite, started writing workplace norms on [[Help for new staff]]

9/7/16 12:30-2, 3-5:30 - Hootsuite/Twitter scheduling, recategorized Projects on Project management page by adding Priority, Due Date, and Stage (see https://mcnaircenter.slack.com/messages/wikicategorization/ for details), brainstormed ideas for mcnair center for this semester w Julia, Ramee, Albert

9/8/16 2:30-3:40 - http://www.mcnaircenter.org/wiki/Women_in_Entrepreneurship_(Issue_Brief), meeting with Twitter team

9/9/16 12:30-2 - helped Catherine set up her pages, read Health Innovation documents sent by Accenture, brainstormed potential collaboration with them

9/13/16 2:00-4:00 - research on Space startups for a potential blog post, research ideas for cross collaboration project with law professor, twitter

9/14/16 3:00-4:30 - reading Tay's blog post on Women in Entrep, brainstorming topics for women in entrep blog series, researching my topic area for said blog series [[Women in Innovation and Entrepreneurship: 2nd In Blog Series]]

9/15/16 10:30-12, 2:30-4 - [[Women in Innovation and Entrepreneurship: 2nd In Blog Series]]

9/20/16 9:30-10:30, 2:30-4 - Hootsuite, Forbes's Women in Entrepreneurship, [[Women in Innovation and Entrepreneurship: 2nd In Blog Series]], meeting w albert and ed

9/21/16 12:45-2, 3-5:30 - Hootsuite, general article research, working connections to get patent lawyer here, started [[Spotlight on Innovation: Space]]

9/22/16 2:20-3:50 - mcnair shirt design, doodle poll for mcnair party, continue researching [[Spotlight on Innovation: Space]]

9/23/16 12:30-2 - call tshirt people, write shirt proposal, doodle poll for mcnair meeting

9/27/16 10-12, 2:30-4 - [[Clinton/Trump Debate]] - will finish on 9/28

9/28/16 12:45-2, 2:45-5:15 - [[Clinton/Trump Debate]], organize the mcnair staff meeting

9/29/16 1:15-4 - met with Albert, Ed, and Anne to discuss McNair management things, space research, podcasts, linkedin

10/4/16 2:20-3:50 - [[Small Business Development Ecosystem of Houston]]

10/5/16 12:45-2, 3-5:30 - [[Small Business Development Ecosystem of Houston]]

10/6/16 10-12, 2:20-3:50 - finishing resource descriptions for [[Small Business Development Ecosystem of Houston]]

10/7/16 12:45-2 - linked blogs to external sources (http://mcnair.bakerinstitute.org/blog/trumppence-entrepreneurship/ and http://mcnair.bakerinstitute.org/blog/clintonkaine-entrepreneurship/), wrote final edits before they were published

10/12/16 12:30-2, 3-5:30 - twitter, [[Small Business Development Ecosystem of Houston]] - write up the institution wiki pages (https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web) and integrate graphics that Julia did into the wiki page

10/13/16 2:20-3:50 - met with anne re mcnair admin (mcnair center meeting logistics coordination, blog update, work logs logistical issues, table overlay of graphic for small business htx page), continue institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web

10/18/16 9:30-11:30, 2:20-3:50, 5:30-7 - finish institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web, check in w Julia, Ed, and Albert re status of Small Business in HTX, McNair center meeting from 5:30-7!

10/19/16 12:30-2, 3-5:30 - thought we were finished but turns out someone still copied and pasted so we are finishing institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web, developing Ankita meeting agenda with Catherine, phone conference with ankita at 4:30

10/20/16 2:20-3:40 - meeting with Ed, Albert, and Catherine re [[Small Business Development Ecosystem of Houston]] - link to meeting notes can be found here [[HTX Small Biz Meeting Notes]]. Developing ideas for patent thingies

10/21/16 12:45-2 - [[Fall 2016 Project Ideas Page]], email from anne re shirts

10/25/16 9:45-11:45, 2:30-4 - morning: news from weekend, working on idea #2 from [[Fall 2016 Project Ideas Page]] (researching open v closed innovation, read introduction to Henry Chesbrough book [https://books.google.com/books?hl=en&lr=&id=OeLIH89YiMcC&oi=fnd&pg=PR17&dq=innovation+henry+chesbrough&ots=RD7FiTIKj9&sig=HcDqoK7Vl3c9xc0Fu_6wQ10_vgc#v=onepage&q=innovation%20henry%20chesbrough&f=false]) afternoon: learn more about patent data, talk w avesh, start getting info from SDC [[Innovation in the Oil and Gas Industry]]

10/26/16 12:30-2, 3-5:15 - mcnair admin (20 min), SDC acquisitions and mergers data (play around with it)

10/27/16 2:30-4 - work on project page [[Innovation in the Oil and Gas Industry]], twitter articles, SQL workshop from 3-4

10/28/16 12:45-2 - [[Innovation in the Oil and Gas Industry]] SDC planning, help julia with caricatures

11/1/16 10-12, 2:30-4 - morning: mcnair admin (semester performance reviews and meeting 1x a week on thurs from 3-4 to do sql training), upload pics to facebook, afternoon: avesh and i discuss [[Innovation in the Oil and Gas Industry]]

11/2/16 12:45-2, 3-5:30 - interview with East-West tea in early afternoon, writing [[Spotlight on Rice Entrepreneurs: East-West Tea]] in late afternoon

11/3/16 2:30-4 - SQL training

11/4/16 12:45-2 - responding to edits on [[Spotlight on Rice Entrepreneurs: East-West Tea]] and getting peer review

11/8/16 9-12, 2:30-4 - came in a little early this morning since I'll be missing my shifts later this week. finished [[Spotlight on Rice Entrepreneurs: East-West Tea]] and published it on the blog. worked on organizing data from SDC pull of companies (created sql database and tables)

11/9/16 12:45-2 - organizing data from SDC pull of companies (created sql database and tables)

11/15/16 2:30-4 - ed is repurposing me [[VC Policy Report]]

11/16/16 12:45-2, 3-5, 6-7 : first chunk - articles, looking up dates for Ed, editing Julia's moonshot article, admin. second chunk - working with avesh on [[VC Policy Report]]. third chunk - elevator pitch competition for spotlight series

11/17/16 10-12, 2:30-4 : first chunk - writing new blog post article [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], [[VC Policy Report]] second chunk - [[VC Policy Report]]

11/18/16 3-4: finishing up the aggregate data table sql for [[VC Policy Report]]

11/22/16 10-12, 2:10-3:40 - twitter, making interview questions for [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], interview with the winners from 11-12, afternoon: IPO aggregate table work on [[VC Policy Report]].

11/23/16 12:45-2 - ask ben how far he got on ipo aggregate table and act accordingly with [[VC Policy Report]], add some tweets in hootsuite

11/29/16 10-12, 2:30-4 - accelerator data with dylan, fixing east-west page yet again, interview with elevator pitch people from 11-12. afternoon: accelerator data

11/30/16 12:45-2, 3-5:30 - first: finish [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], second: accelerator data

12/1/16 1:30-3:30 - accelerator data

12/2/16 3-4:15 - accelerator data

12/5/16 10-12 - accelerator data

12/6/2016 9-12 - accelerator data

12/7/16 10-12 - hootsuite, revise [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], accelerator data

12/8/16 9-12 - accelerator data, hootsuite, check w/ anne re elevator pitch blog post

[[Internal Classification: Work Logs| ]]
[[Category:Work Log]]

Women in Entrepreneurship (Issue Brief)

2017-03-22T18:19:20Z

Carlin: /* Current planto complete project */

{{McNair Projects
|Has title=Women in Entrepreneurship (Issue Brief)
|Has owner=Carlin Cherry
|Has start date=Spring 2016
|Has keywords=Women, Entrepreneurship
|Is billed to=AccMcNair01
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
}}

=Spring 2017=
==Current plan to complete project==
#Lit Review (which will be compiled here [[Women in Entrepreneurship Lit Review]]). Keep track of the things that have already been done in other research reports, so that we can do something different/original or so we can prove their data wrong. Will be done on 3/21.
#Brainstorm ways to fix Dr. problem in data (assigning gender to those who are doctors), recode them. Think of new variables to add depending on the guidance from the lit review (might include adding different variables than solely womenceo/womenfounder but will depend on litreview). This should be done over the remainder the week (3/22-3/25).
#I think from there I can do analysis and start to write report!

Need to solve doctor problem.

==For analysis==

Note that:
*finaldatasetcode.sql (in 181/Women) has been updated
*hopethisworks5.txt (in both 181/Women and E/Women) has been created
**Use this as your dataset now
**It contains IPO, IPOyear, IPOAmount, MA, MAyear, MAAmount, and Exit
**IPO, MA, and Exit are 0/1 variables. Year is an int, and Amount is a real.
**Many MAs will not have amounts.

Build graphs of:
*Over time (last ten yrs)
**percent of co's with woman ceo (binary)
**percent of co's with woman founder (binary)
**percent of co's with woman clevel (binary)
**percent of co's with women in top management (vp and above)
**average fraction of women founders
**average fraction of women clevel
**average fraction of women in top management (vp and above)
*Some of the above by industry
*Some of the above by state

Regresions:
*rounds womanvar w/controls
*inv womanvar w/controls
*exit womanvar w/controls
*ipo womanvar w/controls
*ma womanvar w/controls
*ipoamount womanvar w/controls
*maamount womanvar w/controls

==TO DO after 2/28==
#Check cleancos and verify that it is actually clean (yes)
#Make Dr. a control variable (yes)
#Sum all c-level, etc.
#aggregate to company level

We need to build:
*IPO 1/0
*M&A 1/0
*Number of rounds
*Total invested
*Is the CEO a woman 1/0
*Are any of the founders women 1/0
*Is CEO doctor 1/0
*Number of founders
*Number of founders that are doctors
*Number of women founders
*State - coded
*Industry -code them!
*Year of First investment -extracted

Ed is going to add IPO and Acq to rc1andcp3

Here's the code to add zeros to cleanpeople:
DROP TABLE cleanpeople2;
CREATE TABLE cleanpeople2 AS
SELECT
prefix,
firstname,
lastname,
jobtitle,
fulltitle,
cname,
CASE WHEN genval IS NOT NULL THEN genval ELSE 0::int END AS women,
CASE WHEN doctor IS NOT NULL THEN doctor ELSE 0::int END AS doctor,
CASE WHEN charman IS NOT NULL THEN charman ELSE 0::int END AS charman,
CASE WHEN ceo IS NOT NULL THEN ceo ELSE 0::int END AS ceo,
CASE WHEN cfo IS NOT NULL THEN cfo ELSE 0::int END AS cfo,
CASE WHEN coo IS NOT NULL THEN coo ELSE 0::int END AS coo,
CASE WHEN cio IS NOT NULL THEN cio ELSE 0::int END AS cio,
CASE WHEN cto IS NOT NULL THEN cto ELSE 0::int END AS cto,
CASE WHEN otherclvl IS NOT NULL THEN otherclvl ELSE 0::int END AS otherclvl,
CASE WHEN boardmember IS NOT NULL THEN boardmember ELSE 0::int END AS boardmember,
CASE WHEN president IS NOT NULL THEN president ELSE 0::int END AS president,
CASE WHEN vp IS NOT NULL THEN vp ELSE 0::int END AS vp,
CASE WHEN founder IS NOT NULL THEN founder ELSE 0::int END AS founder,
CASE WHEN director IS NOT NULL THEN director ELSE 0::int END AS director
FROM cleanpeople WHERE jobtitle IS NOT NULL;

==TO DO up to 2/28==

#Load
##company
##people
##title lookup
##state lookup
#Refine people
##gender 0/1
##Join title lookup
##Dr.'s?
#Aggregate to company level (left join)
##Agg. People
##Join state lookup
#Export!

Done! Here is the code for this part of project:

DROP TABLE titlelookup;
CREATE TABLE titlelookup(
fulltitle varchar(150),
charman int,
ceo int,
cfo int,
coo int,
cio int,
cto int,
otherclvl int,
boardmember int,
president int,
vp int,
founder int,
director int
);
\COPY titlelookup FROM 'Important Titles in Women2017 dataset.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--628

DROP TABLE statelookup;
CREATE TABLE statelookup(
statename varchar(100),
uniquecode int
);
\COPY statelookup FROM 'uniquestateval.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--50

DROP TABLE people;
CREATE TABLE people(
prefix varchar(5),
firstname varchar(50),
lastname varchar(50),
jobtitle varchar(150),
cname varchar(150)
);
\COPY people FROM 'pull5-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--186181

DROP TABLE cleancos;
CREATE TABLE cleancos AS
SELECT pull3info.*
FROM pull3info
JOIN Cleancosbase ON pull3info.companyname=cleancosbase.companyname AND minfirstdate=firstinvestdate;
--43534

DROP TABLE genvalpeople;
CREATE TABLE genvalpeople AS
SELECT *,
CASE WHEN prefix='Ms' THEN 1::int
WHEN prefix='Mrs' THEN 1::int
WHEN prefix='Mr' THEN 0::int
ELSE Null::int END AS genval FROM people;
--186181

DROP TABLE cleanpeople;
CREATE TABLE cleanpeople AS
SELECT genvalpeople.*, titlelookup.*
FROM genvalpeople LEFT JOIN titlelookup ON genvalpeople.jobtitle=fulltitle;
--186181

DROP TABLE uniquevalstate;
CREATE TABLE uniquevalstate AS
SELECT cleancos.*, statelookup.*
FROM cleancos LEFT JOIN statelookup ON cleancos.companystate=statelookup.statename;
--43534

DROP TABLE dataset;
CREATE TABLE dataset AS
SELECT cleanpeople.*, uniquevalstate.*
FROM cleanpeople LEFT JOIN uniquevalstate ON cleanpeople.cname=uniquevalstate.companyname;
--186181

\COPY people TO 'finaldataset.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--186181

==Paper==
https://docs.google.com/document/d/1RHC0Namt9VpmUxINmRvHw4U34dDmgYPcUMbwhhthcCA/edit

==Timeline==
*Prior
**review/update lit review
***should come from both industry and academic sources
*Intro
**Update stats to reflect 2017
**citations
**add something specifically about the importance of women in leadership in vc companies
*Thesis/Issue Brief focus
**This issue brief has two broad goals. First, it will examine the role of women in entrepreneurship fields today by researching their representation in leadership positions of VC-backed companies. Second, it will examine the effectiveness of current policy related to women in entrepreneurship.
*Research
**search in SDC to reflect the current date rather than 2016
***add industry/other variables
**build SQL tables with the following parameters: group by state, role, city, msa, industry
**relationship between women in leadership roles and performance of the firm, where performance measured by no rounds invested/ipo
**state fix-effects
*Policy
**Trump's proposed policy changes that will impact vc-backed companies, entrepreneurship/innovation in general, women in the workplace: research can be found at [[Trump and Women in Entrepreneurship]]
***crowd-funding impact

==Timeline==
*1/24 - finish outline, reread tables/data collection process, update lit review
*1/25 - SDC pull

*1/30 - rerun through tables w new added variables (i.e. industry, etc)
*1/31 - read over new data and refine into something presentable, find appropriate parameters for issue brief, etc. maybe start making charts and graphs if time. @ this point check in w ed
*2/1 - finish making graphs and charts, research trump policy and write it up
*2/3 - start finalizing paper, putting all the pieces of the puzzle together, any additions or time to fix things that went off schedule, last edits, submit paper to anne for review

==SDC Search==
===pull 1===
*Database Selection
**VentureXpert
**Portfolio Companies

*Search Items:
**Date that received company received first investment: 01/01/1980 to 01/01/2017
**venture-related deals
**Company Nation: U.S.

*Custom Report
**Company Founding Date
**Company IPO Date
**Date Received Last Investment
**Date Received First Investment
**Company Name
**Company State
**Company City
**Company VE Primary Industry Class
**Company VE Primary Industry Major Group
**Company 6-digit CUSIP
**Total amt invested in company
**No. Financing Rounds Company Received
**Executive's First Name
**Executive's Last Name
**Executive's Job Title
**Executive's Prefix
**VE Primary Industry Sub-Group 3
**VE Primary Industry Minor Group
**VE Primary Industry Sub-Group 1
**Company IPO
**Company Website

*Saved in 182 in mcnair/projects/women2017 as "pull1"

===pull 3===
*Database Selection
**VentureXpert
**Portfolio Companies

*Search Items:
**Date that received company received first investment: 01/01/1980 to 01/01/2017
**Venture related deals - select all venture related deals
**Company Nation: U.S.

*custom report
*company founding date
*company ipo date
*date company received last investment
*date company received first investment
*company staet
*company name
*company industry class
*company industry major group
*company industry subgroup 1
*company industry subgroup 3
*Company industry minor group
*company cusip
*total known amt invested in company
*no rouds company received investment
*company ipo status
*company website

*saved in 182 in mcnair/projects/women2017 as "pull3"

===pull 4===
*Database Selection
**VentureXpert
**Portfolio Companies

*Search Items:
**Date that received company received first investment: 01/01/1980 to 01/01/2017
**Venture-related deals
**Company Nation: U.S.

*custom report
*company name
*executive's name prefix
*executive's first name
*executive's last name
*executive's job title

*saved in 182 in mcnair/projects/women2017 as "pull4"

===pull 5===
*Database Selection
**VentureXpert
**Portfolio Companies

*Search Items:
**Date that received company received first investment: 01/01/1980 to 01/01/2017
**Venture-related deals
**Company Nation: U.S.

*custom report
*executive's name prefix
*executive's first name
*executive's last name
*executive's job title
*company name
*saved in 182 in mcnair/projects/women2017 as "pull5"

===pull 6===
*Database Selection
**VentureXpert
**Portfolio Companies

*Search Items:
**Date that received company received first investment: 01/01/1980 to 01/01/2017
**venture-related deals
**Company Nation: U.S.

*Custom Report
*executive's name prefix
*executive's first name
*executive's last name
*executive's job title
*company name
*company city
*company state

===pull 7===
*Database Selection
**VentureXpert
**Portfolio Companies

*Search Items:
**Date that received company received first investment: 01/01/1980 to 01/01/2017
**venture-related deals
**Company Nation: U.S.

*Custom Report
*executive's name prefix
*executive's first name
*executive's last name
*executive's job title
*company name
*Company ve primary industry major group
*Company ve primary industry minor group
*Company ve primary industry sub group 1
*Company ve primary industry sub group 2
*Company ve primary industry sub group 3

==What I have done up to 2/7/17 (in english, not sql)==

I have done many SDC pulls with many different variables. The most important tables are nowomenstate, nowomencity, nowomenminorind, and nowomensub2. nowomenstate shows the number of women in "power positions" in each state as a percentage of all power position workers. nowomencity does the same thing at a city level. nowomenminorind shows the number of women in power positions grouped by their company's minor industry group. nowomensub2 does the same except grouped by the company's industry sub group 2.

==Tables built up to 02/07/17==

SDC pull #1
company founding date
company ipo date
date company received last investment
date company received first investment
company staet
company name
company industry class
company industry major group
company industry subgroup 1
company industry subgroup 3
Company industry minor group
company cusip
ttoal known amt invested in company
no rouds company received investment
company ipo status
company website

SDC pull #2
company name
executive's name prefix
executive's first name
executive's last name
executive's job title

logging on:
researcher@128.42.44.181
password: 9million

cd /bulk
cd \Women2017
psql Women2017

DROP TABLE pull3info;
CREATE TABLE pull3info(
/*taken from pull3.txt*/
ipodate date,
lastinvestdate date,
firstinvestdate date,
companyfoundingdate date,
ipostatus varchar(10),
companystate varchar(50),
companyname varchar(200),
industryclass varchar(200),
majorgroup varchar(200),
minorgroup varchar(200),
subgroup1 varchar(200),
subgroup3 varchar(200),
cusip varchar(6),
totalinvested float,
numrounds int,
website varchar(200)
);

\COPY pull3info FROM 'pull3-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

--COPY 43606

DROP TABLE cleancosbase;
CREATE TABLE cleancosbase AS
SELECT companyname, min(firstinvestdate) as minfirstdate FROM pull3info WHERE companyname !='Undisclosed Company' OR companyname !='New York Digital Health LLC' GROUP BY companyname;
--43534

DROP TABLE cleancos;
CREATE TABLE cleancos AS
SELECT pull3info.*
FROM pull3info
JOIN Cleancosbase ON pull3info.companyname=cleancosbase.companyname AND minfirstdate=firstinvestdate;
--43534

DROP TABLE pull4info;
CREATE TABLE pull4info(
/*taken from pull4.txt*/
execfirstname varchar(50),
jobtitle varchar(100),
execlastname varchar(50),
execprefix varchar(5),
companyname varchar(200)
);

\COPY pull4info FROM 'pull4-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

/*the job title column of the exec is for some reason combined with the first name
even after normalizing the data. I will repull the data from SDC to see if it was
simply an error in the pull or something. If that doesn't work, will go to ed.
*/

SDC pull #5
executive's name prefix
executive's first name
executive's last name
executive's job title
company name

DROP TABLE pull5info;
CREATE TABLE pull5info(
/*taken from pull5.txt*/
execprefix varchar(5),
execfirstname varchar(50),
execlastname varchar(50),
jobtitle varchar(100),
companyname varchar(200)
);

\COPY pull5info FROM 'pull5-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

--COPY 186181

DROP TABLE distinctnocompanies;
CREATE TABLE distinctcompanies AS
SELECT DISTINCT companyname FROM pull3info;
/*created this per ed's advice to see how many companies are distinct from each other
so we dont get duplicates in the dataset - only really creating a table to get the
specific number*/

--COPY 43536
/*this means there are 70 duplicates in the data. could mean that some companies in diff
states have the same name, or it could be a for real duplicate. can go back and check
on this later but rn seems like a relatively nominal amt.*/

DROP TABLE totaltable;
CREATE TABLE totaltable AS
SELECT * FROM pull5info LEFT JOIN pull3info ON pull5info.CompanyName = pull3info.companyname;
/*represents the table combining pull3info and pull5info, aka all of the info about
the companies and the executives' info matched on company name*/

/*WHERE IM AT:

START GROUPING BY WOMEN IN pull3info
ed says to rename pull3info but idc like i know what it is

*/

DROP TABLE commonnames;
CREATE TABLE commonnames(
/*common male and female names with corresponding 0 or 1*/
name varchar(100),
mf int
);

DROP TABLE commonnamesclean;
CREATE TABLE commonnamesclean AS
SELECT name, sum(mf) AS mf FROM commonnames GROUP BY name HAVING count(mf) = 1;

\COPY commonnames FROM 'realcommonnames.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--4654

DROP TABLE impoppl;
CREATE TABLE impoppl AS
/*selecting the people with important job titles*/
SELECT * FROM pull5info WHERE jobtitle IN ('Board Member', 'CEO', 'Founder', 'CFO',
'COO', 'Chairman', 'Chief Executive Officer', 'Chief Financial Officer', 'President',
'Treasurer', 'Vice President');
--67733

DROP TABLE binarymanwoman;
CREATE TABLE binarymanwoman AS
/*creates table with a column populated with 1 if prefix is Ms or Mrs and 0 if mr*/
SELECT*,
CASE WHEN execprefix='Ms' THEN 1::int
WHEN execprefix='Mrs' THEN 1::int
WHEN execprefix='Mr' THEN 0::int
ELSE Null::int END AS binaryval FROM pull5info;
--186181

DROP TABLE binarycommonmatch;
CREATE TABLE binarycommonmatch AS
/*matching common names to list of execs who have dr prefix/are gender unidentified*/
SELECT execprefix, execfirstname, execlastname, jobtitle, companyname,
CASE WHEN binaryval IS NULL AND mf IS NOT NULL THEN mf
WHEN binaryval IS NOT NULL THEN binaryval
ELSE NULL::int END AS binaryval
FROM binarymanwoman LEFT JOIN commonnamesclean ON execfirstname = name
WHERE execfirstname IS NOT NULL;
--171307

DROP TABLE doctors;
CREATE TABLE doctors AS
/*represents the leaders from companies who haven't been assigned a gender*/
SELECT * FROM binarycommonmatch WHERE binaryval IS NULL;
--7016

DROP TABLE women;
CREATE TABLE women AS
SELECT * FROM binarycommonmatch WHERE binaryval=1;
--18101
/*this means that 18101/171307 of the people in "important" positions are women
which is equal to 0.105. Could be +/- 0.04 bc of the doctors/unidentified genders
in the data*/

/*next steps: redo SDC pull, group by

state
city
company
exec prefix, first name, last name, job title

also check in w ed about the no of doctos and whether getting within a 4% margin is
ok*/

SDC pull #6

company state
company city
company name
exec first name
exec last name
exec prefix
exec job title

DROP TABLE execbylocation;
CREATE TABLE execbylocation(
state varchar(75),
city varchar(75),
companyname varchar(100),
execjob varchar(100),
execprefix varchar(5),
firstname varchar(50),
lastname varchar(50)
);

\COPY execbylocation FROM 'pull6-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--186242

DROP TABLE impopplbylocation;
CREATE TABLE impopplbylocation AS
/*selecting the people with important job titles*/
SELECT * FROM execbylocation WHERE execjob IN ('Board Member', 'CEO', 'Founder', 'CFO',
'COO', 'Chairman', 'Chief Executive Officer', 'Chief Financial Officer', 'President',
'Treasurer', 'Vice President');
--67750

DROP TABLE impoppllocname;
CREATE TABLE impoppllocname AS
SELECT * FROM impopplbylocation WHERE execprefix IN ('Ms', 'Mrs');
--5646

/*here's what I want to do: I have a table with all the (identifiable) women, and a
separate table with both men and women. I want to group by state in both, then
divide the no of females in state (impoppllocname)/total in state (impopplbylocation)
where state=state (i.e. females in california in impoppllocname divided by
total no of ppl from california in impopplbylocation) to get the percentage of females
in each state with "important" positions. however, sql is a turd and won't let me group
by state for some odd reason in either of these tables. is there a more efficient
way to do this than with two tables? perhaps. But idk! help!*/

DROP TABLE binpplbylocation;
CREATE TABLE binpplbylocation AS
/*creates table with a column populated with 1 if prefix is Ms or Mrs and 0 if mr*/
SELECT*,
CASE WHEN execprefix='Ms' THEN 1::float
WHEN execprefix='Mrs' THEN 1::float
WHEN execprefix='Mr' THEN 0::float
ELSE Null::int END AS binaryval FROM impopplbylocation;
--67750

DROP TABLE nowomenstate;
CREATE TABLE nowomenstate AS
SELECT binpplbylocation.state, sum(binaryval)/count(binaryval) AS percentage
FROM binpplbylocation GROUP BY binpplbylocation.state
ORDER BY percentage ASC;
/*this gives the no of women in each state/all the ppl in a state to yield the percentage
of women in each state who are females in power*/
--54 (includes Guam, D.C., etc.)
/*Wyoming the lowest, at 0, and Hawaii the highest, at 16.9%, Texas at 8.1%*/

DROP TABLE nowomencity;
CREATE TABLE nowomencity AS
SELECT binpplbylocation.city, sum(binaryval)/count(binaryval) AS percentage
FROM binpplbylocation GROUP BY binpplbylocation.city
ORDER BY percentage DESC;
--2049

SELECT * FROM nowomencity WHERE city='San Antonio';
--Houston has 7.8% of women in leadership positions in all of its companies
--Austin has 9.1%
--Dallas has 9.9%
--San Antonio has 7.4%

/*next do sdc pull to group by industry minor group 3, industry major group*/

SDC pull #7

Custom Report
executive's name prefix
executive's first name
executive's last name
executive's job title
company name
Company major group
company minor group
company sub group 1,2,3

perl NormalizeFixedWidth.pl -file="pull7.txt"

DROP TABLE execbyindustry;
CREATE TABLE execbyindustry(
execprefix varchar(5),
firstname varchar(50),
lastname varchar(50),
jobtitle varchar(50),
companyname varchar(100),
majorgroup varchar(100),
minorgroup varchar(100),
subgroup1 varchar(100),
subgroup2 varchar(100),
subgroup3 varchar(100)
);

\COPY execbyindustry FROM 'pull7-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--186272

DROP TABLE impopplbylocation2;
CREATE TABLE impopplbylocation2 AS
/*selecting the people with important job titles*/
SELECT * FROM execbyindustry WHERE jobtitle IN ('Board Member', 'CEO', 'Founder', 'CFO',
'COO', 'Chairman', 'Chief Executive Officer', 'Chief Financial Officer', 'President',
'Treasurer', 'Vice President');
--67764

DROP TABLE binpplbyindustry;
CREATE TABLE binpplbyindustry AS
/*creates table with a column populated with 1 if prefix is Ms or Mrs and 0 if mr*/
SELECT*,
CASE WHEN execprefix='Ms' THEN 1::float
WHEN execprefix='Mrs' THEN 1::float
WHEN execprefix='Mr' THEN 0::float
ELSE Null::int END AS binaryval FROM impopplbylocation2;
--67764

DROP TABLE nowomenmajorind;
CREATE TABLE nowomenmajorind AS
SELECT binpplbyindustry.majorgroup, sum(binaryval)/count(binaryval) AS percentage
FROM binpplbyindustry GROUP BY binpplbyindustry.majorgroup
ORDER BY percentage DESC;
--6
/*highest is biotechnology, with 11% of company founders being women. lowest is
semiconductors/other electric, with 4%*/

DROP TABLE nowomenminorind;
CREATE TABLE nowomenminorind AS
SELECT binpplbyindustry.minorgroup, sum(binaryval)/count(binaryval) AS percentage
FROM binpplbyindustry GROUP BY binpplbyindustry.minorgroup
ORDER BY percentage DESC;
--10
/*consumer related higher than biotechnology at 11.9% vs 11.5%, with lowest still
semiconductors/other electric at 4%)*/

DROP TABLE nowomensub1;
CREATE TABLE nowomensub1 AS
SELECT binpplbyindustry.subgroup1, sum(binaryval)/count(binaryval) AS percentage
FROM binpplbyindustry GROUP BY binpplbyindustry.subgroup1
ORDER BY percentage DESC;
--18
/*pretty similar to minorind; not much difference/nothing revolutionary to add*/

DROP TABLE nowomensub2;
CREATE TABLE nowomensub2 AS
SELECT binpplbyindustry.subgroup2, sum(binaryval)/count(binaryval) AS percentage
FROM binpplbyindustry GROUP BY binpplbyindustry.subgroup2
ORDER BY percentage DESC;
--69
/*consumer products = 15%, consumer services = 14%, energy enhanced recovery = 14%,
med/health services 13%, then biotech research at 13%. Lowest: industrial services at
2.5%, idustrial equipment at 2.9%, power supplies at 3.1%, laser related at 3.3%,
optoelectronics at 3.6%*/

DROP TABLE nowomensub3;
CREATE TABLE nowomensub3 AS
SELECT binpplbyindustry.subgroup3, sum(binaryval)/count(binaryval) AS percentage
FROM binpplbyindustry GROUP BY binpplbyindustry.subgroup3
ORDER BY percentage ASC;
--560
/*industrial products=50%!, agriculture=33%, ecommerce selling products = 29%,
biotech food enzymes and cultures = 29%, computers and hardware=28%. lowest: there are
straight up 0 in about 75 different things.*/

/*up next: build table with coname, women ceo&founder (binary 0/1), women in power (0
or 1), #power positions, #women in power, state, year co received first investment,
no rounds, total$invested*/

==STATA regression info==

name text file "big.do"
press play - will run in stata

commands in stata:
summarize numrounds -> gives mean, skewness, kurtosis
summarize numrounds, det -> same as above except w higher level of detail
tab numrounds -> frequency count
gen -> generate a variable
gen invested = totalinvested*1000 = new variable
gen abovemeaninv =0 if totalinvested <. (where . is equal to positive infinity, it's what stata puts in when there's a missing value)
replace abovemeaninv=1 if totalivnested > mean & totalinvested <.

reg some measure of performance on some measure of women

reg numrounds womeninpower

if 2(std. err.) < coef, you're good
The relationship between numrounds and womeninpower is highly statistically significant
- R-squared - says of all the variation in the number of rounds, women in power only explains less than one percent of that variation 0.66%

if you use .log you can automatically replace it whenever you run the script

rebuild data set to contain men
need year variable - extract year from date

multivariate regression
y should be perfromance measure
x should be the explanatory variables
if you run multiple variables with , robust it will be fine

i.year = indicator that takes value 1 if it's the year it's invested

=Spring 2016=
==The Paper==
===Introduction===

Over the past century, the United States has witnessed two large-scale social trends involving [[Women in Entrepreneurship|women in entrepreneurship]] that have had a significant impact on the country's economic growth. First, huge numbers of women have made their way into the official labor force. Around this time 50 years ago (February 1966), women's labor force participation rate was 39.6%, but in February 2016, 56.8% of women participated in the labor force [https://research.stlouisfed.org/fred2/series/LNS11300002]. This demonstrates substantial growth in women's entry to the labor force. Second, women are achieving a higher degree of education than in years past. As labor market barriers to women have been lowered, the benefits of a college education have grown more for women than men, and females now outpace males in college enrollment. [http://www.pewresearch.org/fact-tank/2014/03/06/womens-college-enrollment-gains-leave-men-behind/] This has provided women with similar access to the same jobs as men.

However, these trends have slowed from their early twenty-first century spikes; room for growth is smaller now than it was before. Economists predict that economic growth from these two trends is unlikely to be repeated to the same magnitude. With this, everyone is looking for the modern-day economy-boosting equivalent to women's entry to the labor force. Given the rising share of women among educated workers, it seems clear that the future of American economic growth is in the hands of women. Encouraging women to enter into fields of entrepreneurship, particularly high-growth entrepreneurship, might be the United States' silver bullet.

This issue brief aims to examine the role of women in entrepreneurship today by examining their jobs (or lack thereof) in entrepreneurship related fields, and examine the effectiveness of current policy related to women in entrepreneurship.

===Status Quo===

'''Our research'''

We examined all leaders in companies from 1980-2016 who have the titles of either chariman, CEO, CFO, COO, CIO, CTO, board member, President, Vice President, Founder, and Director. Of company members with those titles, only 29.8% were women. Of those women leaders, 22% were CEOs, 14% chairwomen, 27% CFOs, 26% COOs, 31% CIOs, 12% CTOs, 25% board members, 20% presidents, 34% vice presidents, 23% founders, and 39% directors. (from tables, PercentWomenXCompany, where X is job title)

Generally, the percentage of women in "leadership roles" in companies has trended upwards since 1980. (from companywomentot table) However, the number of women CEOs over the past two decades has not dramatically increased or decreased, aside from a dramatic upward spike in women CEOs during 2015. (from PercentWomenCEOCompanybyyear table)

Grouped by state, Michigan has highest percentage of women in leadership in its companies, coming in at 37.5%. Texas has 26.6%. Wyoming has a whopping 0%. (from womenstates)

These data show that of the women listed as "Company Executives", only a very small percentage have positions of power. However, this number has grown since 1980, which demonstrates a slow but positive growth of women in executive positions in general.

'''Info from external sources'''

Overall, women-owned businesses account for slightly less than 1/3 of all businesses in the United States. At first glance the statistics portray a positive picture for the field's growth: the number of women-owned firms has grown 68 percent since 2007, compared to only 47 percent for all businesses. [http://www.theatlantic.com/business/archive/2015/04/women-are-owning-more-and-more-small-businesses/390642/]. However, these women owned businesses are typically only run by the woman herself; among employer firms, women-owned businesses account for only 16% of the total, and their shares of revenue and employees are in the single digits. [http://www.kauffman.org/~/media/kauffman_org/research%20reports%20and%20covers/2014/11/sources_of_economic_hope_womens_entrepreneurship.pdf]

The few women in entrepreneurial leadership roles also have to deal with negative societal perceptions of their jobs. According to data from a 2015 Pew Research Center survey, 43% of Americans believe that the U.S. is not prepared to hire women for top-tier executive positions. A relatively smaller, but still significant, number of Americans (23%) believe that women don’t have the time to hold an executive position, given their “family responsibilities”. [http://www.citylab.com/work/2015/09/where-can-female-entrepreneurs-find-the-most-success/406987/]

The American public's generally negative perception of women in entrepreneurship presents itself institutionally as well. Even though female founders perform equal to or better than their male counterparts when raising money online, only 10 percent of startups which raised Series A last year had female founders. [http://www.inc.com/lisa-calhoun/30-surprising-facts-about-female-founders.html] Texas claims the worst record of supporting women seeking venture capital. Last year, 42 Texas startups got Series A rounds, yet not a single startup had female founders. In terms of venture capital structure, ninety-four percent of decision makers at venture capital funds are male, and 90% of today's venture capital funds never see a female founder. Among chief executives of S.&P. 1500 firms, for each woman, there are four men named John, Robert, William or James. [http://www.nytimes.com/2015/03/03/upshot/fewer-women-run-big-companies-than-men-named-john.html?_r=2] But venture capital firms with women partners are more than twice as likely to invest in companies with a woman on the executive team and three times as likely to invest in companies with women CEOs.

Though at first glance women-owned business growth seems striking, the numbers are deceptive in that their shares of revenue and employees are in single digits. Furthermore, women who do go into entrepreneurship face societal disapproval of their actions, with a plurality of Americans believing not only that the country is not prepared to hire women to executive positions, but also that women are incapable of holding these positions due to their family responsibilities. Further, women get start-up capital for their companies 2-3 times as often from women-led VC funds, but only 6% of decision makers at VC funds are women. It's no wonder women are vastly underrepresented in this field.

'''What women need'''

Almost half-of female founders (48 percent) cite a lack of available mentors or advisers as holding them back. A third say lack of capital is a constraint. [http://www.inc.com/lisa-calhoun/30-surprising-facts-about-female-founders.html]

'''Relevant policy'''

The Obama administration recognized the importance of expanding the role that women-owned businesses play in the national economy. Some of his initiatives include increasing access to capital, incentivizing small business growth and hiring, encouraging women owned business competition for government contracts, and enhancing long term survival of women owned businesses. Two primary pieces of legislation have bolstered the limited growth that the United States has seen in the field of women entrepreneurs, The Small Business Jobs Act of 2010 and the Women’s Equity in Contracting Act. Both of these seek to help businesses headed up by women win more government contracts.

The president has worked on increasing small business access to capital through the Recovery Act and the Small Business Jobs Act. Through this act, the president has reformed SBA lending practices and built on existing infrastructure. SBA loans are 3-5x more likely to go to women and minorities than traditional business loans. Over 12,000 SBA Recovery loans have gone to women-owned small businesses, totaling more than $3 billion. [http://www.dol.gov/wb/media/Obama%20Administration's%20Support%20for%20Women%20Entrepreneurs%20%282%29.pdf] The president has also increased tax cuts with the aim of helping small businesses invest in their firms and create jobs. Specific to women, the SBA opened several new Women's Business Centers in 2009 and 2010, bringing their total to 114.

Jessica Milli, senior research associate at the Institute of Women’s Policy Research, said things like the Jobs Act and SBA's programs for women "really aim to put women-owned businesses...at a competitive advantage. (They) restrict competition, which has really helped to boost revenues and help more businesses get into the industry.” But such policies can’t, and haven't, solved all the challenges inherent to being a female entrepreneur. Even with targeted legislation, women business owners still face a significant wage gap and continually have smaller amounts of start-up capital than their male peers.

'''Conclusion'''
As women's prevalence in the United States workforce has increased, the United States has experienced an economic boom. However, women's numbers are still small in entrepreneurial fields, and even more microscopic in leadership positions in those fields. Current policy fails because it doesn't properly address women's lack of access to capital and mentorship. Moving forward, the United States must seek strategies to incentivize more women to enter the entrepreneurial workforce.

==The Research==

*SQL info can also be found on researcher@128.42.44.181 in the Women folder. Called "women.sql".

==creating basic tables==
DROP TABLE companyreal;
CREATE TABLE companyreal(
datefounded date,
companyname varchar(100),
prefix varchar(5),
firstname varchar(100),
lastname varchar(100),
jobtitle varchar(100),
companystate varchar(100),
companycity varchar(100),
industrygroup varchar(100),
amtinvestedthous float,
rounds int
);

\COPY companyreal FROM 'womencompanieslast-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--129536

DROP TABLE fundreal;
CREATE TABLE fundreal(
datefounded date,
fundname varchar(100),
prefix varchar(5),
firstname varchar(100),
lastname varchar(100),
jobtitle varchar(100),
fundstate varchar(100),
fundcity varchar(100),
fundtargetsizemil float,
firmname varchar(100)
);

\COPY fundreal FROM 'womenfundslast-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--156005

===adding variable where if person is woman, adds value of 1 to their name===
DROP TABLE manwomanfund;
CREATE TABLE manwomanfund AS
SELECT prefix, lastname, datefounded, jobtitle, fundname, fundcity, fundstate,
removeinitial(firstname) as firstname,
CASE WHEN prefix='Ms' THEN 1::int
WHEN prefix='Mr' THEN 0::int
ELSE Null::int END AS womanman FROM fundreal;
--156005

DROP TABLE manwomancompany;
CREATE TABLE manwomancompany AS
SELECT prefix, lastname, datefounded, jobtitle, companyname, companycity, companystate, industrygroup,
removeinitial(firstname) as firstname, amtinvestedthous, rounds,
CASE WHEN prefix='Ms' THEN 1::int
WHEN prefix='Mr' THEN 0::int
ELSE Null::int END AS womanman FROM companyreal;
--129536

===for people without a prefix, trying to assign gender variable to them based on list of common names===

DROP TABLE manwomanfund2;
CREATE TABLE manwomanfund2 AS
SELECT datefounded, prefix, firstname, lastname, fundname, jobtitle, womanman AS origwomanman, mf,
fundcity, fundstate,
CASE WHEN womanman IS NULL AND mf IS NOT NULL THEN mf
WHEN womanman IS NOT NULL THEN womanman
ELSE NULL::int END AS womanman
FROM manwomanfund LEFT JOIN commonnamesclean ON firstname = name
WHERE firstname IS NOT NULL;
--152819

DROP TABLE manwomancompany2;
CREATE TABLE manwomancompany2 AS
SELECT datefounded, prefix, firstname, lastname, companyname, jobtitle, womanman AS origwomanman, mf,
companycity, companystate, industrygroup, rounds, amtinvestedthous,
CASE WHEN womanman IS NULL AND mf IS NOT NULL THEN mf
WHEN womanman IS NOT NULL THEN womanman
ELSE NULL::int END AS womanman
FROM manwomancompany LEFT JOIN commonnamesclean ON lower(firstname) = lower(name)
WHERE firstname IS NOT NULL;
--123278

--%, state, city, round no

===me playing around, these tables not relevant===

DROP TABLE fundWomenCEOs;
CREATE TABLE fundwomentot AS
SELECT EXTRACT(YEAR FROM datefounded), AVG(womanman) AS PercentWomen
FROM manwomanfund2 GROUP BY EXTRACT(YEAR FROM datefounded);
--37

DROP TABLE companyWomen;
CREATE TABLE companywomentot AS
SELECT EXTRACT(YEAR FROM datefounded), AVG(womanman) AS PercentWomen
FROM manwomancompany2 GROUP BY EXTRACT(YEAR FROM datefounded);
--36

DROP TABLE womencompanystate;
CREATE TABLE womencompanystate AS
SELECT companystate, AVG(womanman) AS WomenPerState
FROM manwomancompany2 GROUP BY companystate;
--51

DROP TABLE womenfundstate;
CREATE TABLE womencfundstate AS
SELECT fundstate, AVG(womanman) AS WomenPerState
FROM manwomanfund2 GROUP BY fundstate;
--51

DROP TABLE womencompanycity;
CREATE TABLE womencompanycity AS
SELECT companycity, AVG(womanman) AS WomenPerCity
FROM manwomancompany2 GROUP BY companycity;

===assigning variable to titles===

DROP TABLE titles01;
CREATE TABLE titles01(
title varchar(100),
chairman int,
CEO int,
CFO int,
COO int,
CIO int,
CTO int,
boardmember int,
president int,
vicepresident int,
founder int,
director int
);

\COPY titles01 FROM 'impotitleslast.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

DROP TABLE title02;

===massive conglomeration table===

DROP TABLE ManWomanCompany3;
CREATE TABLE ManWomanCompany3 AS
SELECT Manwomancompany2.*,
CASE WHEN chairman IS NOT NULL THEN 1::int ELSE 0::int END AS chairman,
CASE WHEN CEO IS NOT NULL THEN 1::int ELSE 0::int END AS CEO,
CASE WHEN CFO IS NOT NULL THEN 1::int ELSE 0::int END AS CFO,
CASE WHEN COO IS NOT NULL THEN 1::int ELSE 0::int END AS COO,
CASE WHEN CIO IS NOT NULL THEN 1::int ELSE 0::int END AS CIO,
CASE WHEN CTO IS NOT NULL THEN 1::int ELSE 0::int END AS CTO,
CASE WHEN boardmember IS NOT NULL THEN 1::int ELSE 0::int END AS boardmember,
CASE WHEN president IS NOT NULL THEN 1::int ELSE 0::int END AS president,
CASE WHEN vicepresident IS NOT NULL THEN 1::int ELSE 0::int END AS vicepresident,
CASE WHEN founder IS NOT NULL THEN 1::int ELSE 0::int END AS founder,
CASE WHEN director IS NOT NULL THEN 1::int ELSE 0::int END AS director
FROM ManwomanCompany2
LEFT JOIN titles01 ON manwomancompany2.jobtitle=titles01.title;

===tables for percent of women in a given job title===
DROP TABLE PercentWomenCompany;
CREATE TABLE PercentWomenCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3;
--.29812

DROP TABLE PercentWomenCEOsCompany;
CREATE TABLE PercentWomenCEOsCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE ceo = 1;
--.22597

DROP TABLE PercentWomenChairmanCompany;
CREATE TABLE PercentWomenChairmanCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE chairman = 1;
--.142417

DROP TABLE PercentWomenCFOCompany;
CREATE TABLE PercentWomenCFOCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE cfo = 1;
--.27087

DROP TABLE PercentWomenCOOCompany;
CREATE TABLE PercentWomenCOOCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE coo = 1;
--.26353

DROP TABLE PercentWomenCIOCompany;
CREATE TABLE PercentWomenCIOCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE cio = 1;
--.31707

DROP TABLE PercentWomenCTOCompany;
CREATE TABLE PercentWomenCTOCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE cto = 1;
--.12588

DROP TABLE PercentWomenboardmemberCompany;
CREATE TABLE PercentWomenboardmemberCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE boardmember = 1;
--.2545

DROP TABLE PercentWomenPresidentCompany;
CREATE TABLE PercentWomenPresidentCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE president = 1;
--.19646

DROP TABLE PercentWomenVPCompany;
CREATE TABLE PercentWomenVPCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE vicepresident = 1;
--.3468

DROP TABLE PercentWomenfounderCompany;
CREATE TABLE PercentWomenfounderCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE founder = 1;
--.2394

DROP TABLE PercentWomendirectorCompany;
CREATE TABLE PercentWomendirectorCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE director = 1;
--.38625

==table for finding percentage of women in companies by state==

DROP TABLE womenstates;
CREATE TABLE womenstates AS
SELECT companystate, sum(mf)/count(mf) FROM ManWomanCompany3 GROUP BY companystate;

===Example output data===

Year CEOs Founders Start-ups Partners FundExecs
-------------------------------------------------------------
1980 2% 2% 4% 1% 2%
1981 ...

*Table on money raised?
*Data on likelihood of follow-on round

===still to do:===
#this data still discounts a (small) percentage of data (doctors who didn't have a common name)
#have data organized, now we need to figure out how to extract it in meaningful terms for the report.

<includeonly>
[[Category: McNair Projects]]
</includeonly>

Carlin Cherry (Work Log)

2017-03-22T18:18:50Z

Carlin: /* Spring 2017 */

==Spring 2017==
3/22/17 12:45-2, 4-5:30 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

3/21/17 2:15-4:45 - write up plan for rest of semester, think of ways to fix doctor problem in data + redo c-level to include everything in addition to ceo+founder

3/20/17 11:00-12:15 - refamiliarizing self with project since I've been gone for 2 weeks, starting some analysis, making plan to complete project by end of term

3/8/17 12:45-2 - run regressions and analysis, hopefully write and finish blog post

3/7/17 2:30-5 - finish cleaning Women2017 dataset, data analysis, hopefully start to write article

3/6/17 11:50-1:05, 4-4:30 - finish cleaning Women2017 dataset

3/3/17 10:30-10:45, 12:45-2 - finish cleaning Women2017 dataset

3/1/17 12:45-2 - continue cleaning Women2017 dataset

2/28/17 2:20-4:50 - load company, people, title lookup, statalookup

2/27/17 11:45-1 - going through excel sheet and assigning 1's to people in relevant positions of power

2/24/17 12:45-2 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/22/17 12:45-2, 4-5:30 - stata with Ed, continue writing report [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/21/17 2:30-5:15 - run regressions on new "realbig" dataset using performance measure, men in power, etc.

2/20/17 11:50-1:05 - build new dataset to contain men and year variables, stata practice at very end for a bit just to remember what I'm doing

2/16/17 12:45-2 - stata learning

2/15/17 12:30-2, 4-5:30 - continuing drafting report, regression hopefully this afternoon with ed

2/14/15 2:20 - 4:50 - building combined table with coname, womenceo?, womeninpower?, #powerpos, state, yearfirstinvest, norounds, tot$invest

2/13/17 12-1:15 - detailing plan for building combined table with coname, womenceo?, womeninpower?, #powerpos, state, yearfirstinvest, norounds, tot$invest

2/8/17 12:45-2 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/7/17 2:20-4:50 - [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

2/6/16 12:45 - 2 - try to find some results grouped by state

2/2/17 12:45-2 - redo sdc pulls so I can group by state, etc.

2/1/17 - 12:45-2, 4-5:30 - start building tables [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)]

1/31/17 1:45 - 4:30 - a lot of working with sdc and pulling appropriate data, put new sdc pulls through normalizer script

1/30/17 12:45-2 - redid the sdc pulls so they could be put through normalizer script

1/27/17 12:45-2 - start building tables using normalized sdc data

1/25 12:45-2, 4-5:30 - SDC pull, rerun through tables w new added variables (i.e. industry, etc)

1/24/17 11:45-1:00, 2:30-5:15 - revisiting women in entrepreneurship [http://mcnair.bakerinstitute.org/wiki/Women_in_Entrepreneurship_(Issue_Brief)#To-do], oil&gas industry innovation project planning [http://mcnair.bakerinstitute.org/wiki/Innovation_in_the_Oil_and_Gas_Industry]

1/20/17 12:30-2 - accelerator data, hopefully the last day!

1/19/17 2:30-4:15 - accelerator data....still....

1/18/17 12-1:30 - accelerator data

1/17/17 2:30-4:30 - backtracked blog posts and posted them on facebook

1/13/17 12:45-2 - twitter, accelerator data

1/12/17 2-4 - accelerator data

1/11/17 12-2, 4-5 - accelerator data

1/10/17 2:30-4:30 - accelerator data, mining for twitter articles

1/9/17 12:45-2 - review and analysis of past semester per Ed's request, possibly hootsuite and twitter

==Fall 2016==
8/31/16 3:00-5:00 - Set up Bio page, Work Logs, poked around on Wiki.

9/1/16 2:20-3:50 - Hootsuite setup and tweets.

9/2/16 3:00-5:30 - Classified all remaining uncategorized pages, wrote norms for blog posts and tweeting, worked with Anne on Hootsuite.

9/6/16 2:30-4, 5:30-6 - Helped new staff members set up their pages, worked with Twitter/Hootsuite, started writing workplace norms on [[Help for new staff]]

9/7/16 12:30-2, 3-5:30 - Hootsuite/Twitter scheduling, recategorized Projects on Project management page by adding Priority, Due Date, and Stage (see https://mcnaircenter.slack.com/messages/wikicategorization/ for details), brainstormed ideas for mcnair center for this semester w Julia, Ramee, Albert

9/8/16 2:30-3:40 - http://www.mcnaircenter.org/wiki/Women_in_Entrepreneurship_(Issue_Brief), meeting with Twitter team

9/9/16 12:30-2 - helped Catherine set up her pages, read Health Innovation documents sent by Accenture, brainstormed potential collaboration with them

9/13/16 2:00-4:00 - research on Space startups for a potential blog post, research ideas for cross collaboration project with law professor, twitter

9/14/16 3:00-4:30 - reading Tay's blog post on Women in Entrep, brainstorming topics for women in entrep blog series, researching my topic area for said blog series [[Women in Innovation and Entrepreneurship: 2nd In Blog Series]]

9/15/16 10:30-12, 2:30-4 - [[Women in Innovation and Entrepreneurship: 2nd In Blog Series]]

9/20/16 9:30-10:30, 2:30-4 - Hootsuite, Forbes's Women in Entrepreneurship, [[Women in Innovation and Entrepreneurship: 2nd In Blog Series]], meeting w albert and ed

9/21/16 12:45-2, 3-5:30 - Hootsuite, general article research, working connections to get patent lawyer here, started [[Spotlight on Innovation: Space]]

9/22/16 2:20-3:50 - mcnair shirt design, doodle poll for mcnair party, continue researching [[Spotlight on Innovation: Space]]

9/23/16 12:30-2 - call tshirt people, write shirt proposal, doodle poll for mcnair meeting

9/27/16 10-12, 2:30-4 - [[Clinton/Trump Debate]] - will finish on 9/28

9/28/16 12:45-2, 2:45-5:15 - [[Clinton/Trump Debate]], organize the mcnair staff meeting

9/29/16 1:15-4 - met with Albert, Ed, and Anne to discuss McNair management things, space research, podcasts, linkedin

10/4/16 2:20-3:50 - [[Small Business Development Ecosystem of Houston]]

10/5/16 12:45-2, 3-5:30 - [[Small Business Development Ecosystem of Houston]]

10/6/16 10-12, 2:20-3:50 - finishing resource descriptions for [[Small Business Development Ecosystem of Houston]]

10/7/16 12:45-2 - linked blogs to external sources (http://mcnair.bakerinstitute.org/blog/trumppence-entrepreneurship/ and http://mcnair.bakerinstitute.org/blog/clintonkaine-entrepreneurship/), wrote final edits before they were published

10/12/16 12:30-2, 3-5:30 - twitter, [[Small Business Development Ecosystem of Houston]] - write up the institution wiki pages (https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web) and integrate graphics that Julia did into the wiki page

10/13/16 2:20-3:50 - met with anne re mcnair admin (mcnair center meeting logistics coordination, blog update, work logs logistical issues, table overlay of graphic for small business htx page), continue institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web

10/18/16 9:30-11:30, 2:20-3:50, 5:30-7 - finish institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web, check in w Julia, Ed, and Albert re status of Small Business in HTX, McNair center meeting from 5:30-7!

10/19/16 12:30-2, 3-5:30 - thought we were finished but turns out someone still copied and pasted so we are finishing institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web, developing Ankita meeting agenda with Catherine, phone conference with ankita at 4:30

10/20/16 2:20-3:40 - meeting with Ed, Albert, and Catherine re [[Small Business Development Ecosystem of Houston]] - link to meeting notes can be found here [[HTX Small Biz Meeting Notes]]. Developing ideas for patent thingies

10/21/16 12:45-2 - [[Fall 2016 Project Ideas Page]], email from anne re shirts

10/25/16 9:45-11:45, 2:30-4 - morning: news from weekend, working on idea #2 from [[Fall 2016 Project Ideas Page]] (researching open v closed innovation, read introduction to Henry Chesbrough book [https://books.google.com/books?hl=en&lr=&id=OeLIH89YiMcC&oi=fnd&pg=PR17&dq=innovation+henry+chesbrough&ots=RD7FiTIKj9&sig=HcDqoK7Vl3c9xc0Fu_6wQ10_vgc#v=onepage&q=innovation%20henry%20chesbrough&f=false]) afternoon: learn more about patent data, talk w avesh, start getting info from SDC [[Innovation in the Oil and Gas Industry]]

10/26/16 12:30-2, 3-5:15 - mcnair admin (20 min), SDC acquisitions and mergers data (play around with it)

10/27/16 2:30-4 - work on project page [[Innovation in the Oil and Gas Industry]], twitter articles, SQL workshop from 3-4

10/28/16 12:45-2 - [[Innovation in the Oil and Gas Industry]] SDC planning, help julia with caricatures

11/1/16 10-12, 2:30-4 - morning: mcnair admin (semester performance reviews and meeting 1x a week on thurs from 3-4 to do sql training), upload pics to facebook, afternoon: avesh and i discuss [[Innovation in the Oil and Gas Industry]]

11/2/16 12:45-2, 3-5:30 - interview with East-West tea in early afternoon, writing [[Spotlight on Rice Entrepreneurs: East-West Tea]] in late afternoon

11/3/16 2:30-4 - SQL training

11/4/16 12:45-2 - responding to edits on [[Spotlight on Rice Entrepreneurs: East-West Tea]] and getting peer review

11/8/16 9-12, 2:30-4 - came in a little early this morning since I'll be missing my shifts later this week. finished [[Spotlight on Rice Entrepreneurs: East-West Tea]] and published it on the blog. worked on organizing data from SDC pull of companies (created sql database and tables)

11/9/16 12:45-2 - organizing data from SDC pull of companies (created sql database and tables)

11/15/16 2:30-4 - ed is repurposing me [[VC Policy Report]]

11/16/16 12:45-2, 3-5, 6-7 : first chunk - articles, looking up dates for Ed, editing Julia's moonshot article, admin. second chunk - working with avesh on [[VC Policy Report]]. third chunk - elevator pitch competition for spotlight series

11/17/16 10-12, 2:30-4 : first chunk - writing new blog post article [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], [[VC Policy Report]] second chunk - [[VC Policy Report]]

11/18/16 3-4: finishing up the aggregate data table sql for [[VC Policy Report]]

11/22/16 10-12, 2:10-3:40 - twitter, making interview questions for [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], interview with the winners from 11-12, afternoon: IPO aggregate table work on [[VC Policy Report]].

11/23/16 12:45-2 - ask ben how far he got on ipo aggregate table and act accordingly with [[VC Policy Report]], add some tweets in hootsuite

11/29/16 10-12, 2:30-4 - accelerator data with dylan, fixing east-west page yet again, interview with elevator pitch people from 11-12. afternoon: accelerator data

11/30/16 12:45-2, 3-5:30 - first: finish [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], second: accelerator data

12/1/16 1:30-3:30 - accelerator data

12/2/16 3-4:15 - accelerator data

12/5/16 10-12 - accelerator data

12/6/2016 9-12 - accelerator data

12/7/16 10-12 - hootsuite, revise [[Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post)]], accelerator data

12/8/16 9-12 - accelerator data, hootsuite, check w/ anne re elevator pitch blog post

[[Internal Classification: Work Logs| ]]
[[Category:Work Log]]