Skip to content

Instantly share code, notes, and snippets.

@asadoughi

asadoughi/edgar.ipynb

Created August 9, 2017 01:27
Show Gist options
  • Save asadoughi/35adc4237e5ba69162fadf8df4fec532 to your computer and use it in GitHub Desktop.
Save asadoughi/35adc4237e5ba69162fadf8df4fec532 to your computer and use it in GitHub Desktop.
Download ZIP
CFSheet Jupyter Notebook
Display the source blob
Display the rendered blob
Raw
edgar.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"CPU times: user 21 µs, sys: 9 µs, total: 30 µs\n",
"Wall time: 36 µs\n"
]
}
],
"source": [
"%%time\n",
"\n",
"import os\n",
"import requests\n",
"\n",
"def curl(url, cached=True):\n",
" CACHE_PATH = os.path.expanduser(\"~/.edgar_cache\")\n",
" if cached:\n",
" filename = url[url.rfind(\"/\")+1:]\n",
" path = url[url.find(\"//\")+2:url.rfind(\"/\")]\n",
" try:\n",
" os.makedirs(os.path.join(CACHE_PATH, path))\n",
" except OSError as e:\n",
" pass\n",
" cache_path = os.path.join(CACHE_PATH, path, filename)\n",
" if os.path.exists(cache_path):\n",
" return open(cache_path).read()\n",
" \n",
" print \"INFO: Cache miss: {}\".format(url)\n",
" response = requests.get(url)\n",
" if cached:\n",
" with open(cache_path, \"wb\") as f:\n",
" f.write(response.content)\n",
" return response.content"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"def _newlines(s):\n",
" start_line = 0\n",
" end_line = s.find(\"\\n\", start_line)\n",
" while end_line != -1:\n",
" yield s[start_line:end_line]\n",
" start_line = end_line + 1\n",
" end_line = s.find(\"\\n\", start_line)\n",
"\n",
"class Splitter(object):\n",
" HEADERS = [\"Form Type\", \"Company Name\", \"CIK\", \"Date Filed\", \"File Name\"]\n",
" def __init__(self, header_line):\n",
" self._indices = self._parse_header(header_line)\n",
" def _parse_header(self, header_line):\n",
" indices = []\n",
" for i in range(len(self.HEADERS)):\n",
" start = header_line.index(self.HEADERS[i])\n",
" indices.append(start)\n",
" return indices\n",
" def split(self, line):\n",
" return {self.HEADERS[i]: line[self._indices[i]:self._indices[i+1] if i+1 < len(self.HEADERS) else None].strip()\n",
" for i in range(len(self.HEADERS))}\n",
"\n",
"def lines(s):\n",
" data_started = False\n",
" prev_line = None\n",
" splitter = None\n",
" for line in _newlines(s):\n",
" if not data_started:\n",
" if line.startswith(\"---\"):\n",
" data_started = True\n",
" splitter = Splitter(prev_line)\n",
" else:\n",
" yield splitter.split(line)\n",
" prev_line = line"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Downloading quarter...2016/QTR1\n",
"Parsing response...\n",
"\n",
"Downloading quarter...2016/QTR2\n",
"Parsing response...\n",
"\n",
"Downloading quarter...2016/QTR3\n",
"Parsing response...\n",
"\n",
"Downloading quarter...2016/QTR4\n",
"Parsing response...\n",
"\n",
"Downloading quarter...2017/QTR1\n",
"Parsing response...\n",
"\n",
"Downloading quarter...2017/QTR2\n",
"Parsing response...\n",
"\n",
"Downloading quarter...2017/QTR3\n",
"INFO: Cache miss: https://www.sec.gov/Archives/edgar/full-index/2017/QTR3/form.idx\n",
"Parsing response...\n",
"\n",
"CPU times: user 14 s, sys: 3.48 s, total: 17.5 s\n",
"Wall time: 18.3 s\n"
]
}
],
"source": [
"%%time\n",
"\n",
"base_url = \"https://www.sec.gov/Archives/\"\n",
"# since may 2016\n",
"quarters = [\"2016/QTR1\", \"2016/QTR2\", \"2016/QTR3\", \"2016/QTR4\", \"2017/QTR1\", \"2017/QTR2\", \"2017/QTR3\"] \n",
"data = []\n",
"for quarter in quarters:\n",
" print \"Downloading quarter...{}\".format(quarter)\n",
" form_idx = curl(base_url + \"edgar/full-index/\" + quarter + \"/form.idx\", cached=(quarter != \"2017/QTR3\"))\n",
" print \"Parsing response...\"\n",
" data.extend(lines(form_idx))\n",
" print"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"\"\"\"\n",
"https://www.sec.gov/info/edgar/specifications/form-c-xml-tech-specs-2.htm\n",
"\n",
"C: Offering Statement\n",
"C/A: Amendment to Offering Statement\n",
"C-W: Offering Statement Withdrawal\n",
"C/A-W: Amendment to Offering Statement Withdrawal\n",
"C-U: Progress Update\n",
"C-U-W: Progress Update Withdrawal\n",
"C-AR: Annual Report\n",
"C-AR/A: Amendment to Annual Report\n",
"C-AR-W: Annual Report Withdrawal\n",
"C-AR/A-W: Amendment to Annual Report Withdrawal\n",
"C-TR: Termination of Reporting\n",
"C-TR-W: Termination of Reporting Withdrawal\n",
"\"\"\"\n",
"\n",
"FORM_TYPES = (\"C\", \"C/A\", \"C-W\", \"C/A-W\",\n",
" \"C-U\", \"C-U-W\", \"C-AR\", \"C-AR/A\",\n",
" \"C-AR-W\", \"C-AR/A-W\", \n",
" \"C-TR\", \"C-TR-W\")\n",
"FORM_TYPES_NEW_INVESTMENTS = (\"C\", \"C/A\")"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>CIK</th>\n",
" <th>Company Name</th>\n",
" <th>Date Filed</th>\n",
" <th>File Name</th>\n",
" <th>Form Type</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>count</th>\n",
" <td>890</td>\n",
" <td>890</td>\n",
" <td>890</td>\n",
" <td>890</td>\n",
" <td>890</td>\n",
" </tr>\n",
" <tr>\n",
" <th>unique</th>\n",
" <td>424</td>\n",
" <td>426</td>\n",
" <td>268</td>\n",
" <td>890</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>top</th>\n",
" <td>1691341</td>\n",
" <td>Damsel Productions LLC</td>\n",
" <td>2017-06-29</td>\n",
" <td>edgar/data/1710908/0001669191-17-000106.txt</td>\n",
" <td>C</td>\n",
" </tr>\n",
" <tr>\n",
" <th>freq</th>\n",
" <td>10</td>\n",
" <td>10</td>\n",
" <td>22</td>\n",
" <td>1</td>\n",
" <td>453</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" CIK Company Name Date Filed \\\n",
"count 890 890 890 \n",
"unique 424 426 268 \n",
"top 1691341 Damsel Productions LLC 2017-06-29 \n",
"freq 10 10 22 \n",
"\n",
" File Name Form Type \n",
"count 890 890 \n",
"unique 890 2 \n",
"top edgar/data/1710908/0001669191-17-000106.txt C \n",
"freq 1 453 "
]
},
"execution_count": 19,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"pd.set_option('display.max_rows', 1000)\n",
"\n",
"df = pd.DataFrame(data)\n",
"df = df[df[\"Form Type\"].isin(FORM_TYPES_NEW_INVESTMENTS)]\n",
"df.describe()"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>CIK</th>\n",
" <th>Company Name</th>\n",
" <th>Date Filed</th>\n",
" <th>File Name</th>\n",
" <th>Form Type</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>count</th>\n",
" <td>424</td>\n",
" <td>424</td>\n",
" <td>424</td>\n",
" <td>424</td>\n",
" <td>424</td>\n",
" </tr>\n",
" <tr>\n",
" <th>unique</th>\n",
" <td>424</td>\n",
" <td>424</td>\n",
" <td>197</td>\n",
" <td>424</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>top</th>\n",
" <td>1690794</td>\n",
" <td>InGen Dynamics, Inc.</td>\n",
" <td>2017-06-29</td>\n",
" <td>edgar/data/1710908/0001669191-17-000106.txt</td>\n",
" <td>C/A</td>\n",
" </tr>\n",
" <tr>\n",
" <th>freq</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>15</td>\n",
" <td>1</td>\n",
" <td>242</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" CIK Company Name Date Filed \\\n",
"count 424 424 424 \n",
"unique 424 424 197 \n",
"top 1690794 InGen Dynamics, Inc. 2017-06-29 \n",
"freq 1 1 15 \n",
"\n",
" File Name Form Type \n",
"count 424 424 \n",
"unique 424 2 \n",
"top edgar/data/1710908/0001669191-17-000106.txt C/A \n",
"freq 1 242 "
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# de-dupe\n",
"df = df.sort_values(by=[\"Date Filed\", \"Form Type\"]) # C/A is after C\n",
"df = df.drop_duplicates(subset=\"CIK\", keep=\"last\")\n",
"df.describe()"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"def get_url(file_name):\n",
" file_name = file_name[:file_name.rfind(\"/\")] + file_name[file_name.rfind(\"/\"):-4].replace(\"-\",\"\") + \"/primary_doc.xml\"\n",
" url = base_url + file_name\n",
" return url"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Company name, Company CIK, Platform Name, Platform CIK, Funding deadline"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Company CIK</th>\n",
" <th>Company Name</th>\n",
" <th>Funding Deadline</th>\n",
" <th>Platform CIK</th>\n",
" <th>Platform Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0001674213</td>\n",
" <td>Gigmor, Inc</td>\n",
" <td>2016-10-31</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital LLC</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Company CIK Company Name Funding Deadline Platform CIK \\\n",
"0 0001674213 Gigmor, Inc 2016-10-31 0001665160 \n",
"\n",
" Platform Name \n",
"0 StartEngine Capital LLC "
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"import xmltodict\n",
"\n",
"# TODO: flatten XML straight into dataframe\n",
"def xml2df(xml_data):\n",
" xml_data = xmltodict.parse(xml_data)\n",
" record = {}\n",
" record[\"Company Name\"] = xml_data[\"edgarSubmission\"][\"formData\"][\"issuerInformation\"][\"issuerInfo\"][\"nameOfIssuer\"]\n",
" record[\"Company CIK\"] = xml_data[\"edgarSubmission\"][\"headerData\"][\"filerInfo\"][\"filer\"][\"filerCredentials\"][\"filerCik\"]\n",
" record[\"Platform Name\"] = xml_data[\"edgarSubmission\"][\"formData\"][\"issuerInformation\"][\"companyName\"]\n",
" record[\"Platform CIK\"] = xml_data[\"edgarSubmission\"][\"formData\"][\"issuerInformation\"][\"commissionCik\"]\n",
" d = xml_data[\"edgarSubmission\"][\"formData\"][\"offeringInformation\"][\"deadlineDate\"]\n",
" record[\"Funding Deadline\"] = d[-4:] + \"-\"+ d[:-5] \n",
" return record\n",
"file_name = df[\"File Name\"].iloc[0]\n",
"company_filing = curl(get_url(file_name))\n",
"record = xml2df(company_filing)\n",
"pd.DataFrame([record])"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"records = []\n",
"for file_name in df[\"File Name\"]:\n",
" company_filing = curl(get_url(file_name))\n",
" record = xml2df(company_filing)\n",
" records.append(record)\n",
"df = pd.DataFrame(records)"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"df = df.sort_values(by=[\"Funding Deadline\", \"Company CIK\"])\n",
"month = df[(df[\"Funding Deadline\"] >= \"2017-08-06\") & (df[\"Funding Deadline\"] < \"2017-09-01\")]"
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Company CIK</th>\n",
" <th>Company Name</th>\n",
" <th>Funding Deadline</th>\n",
" <th>Platform CIK</th>\n",
" <th>Platform Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>293</th>\n",
" <td>0001522456</td>\n",
" <td>Richard Garriott de Cayeux</td>\n",
" <td>2017-08-07</td>\n",
" <td>0001603038</td>\n",
" <td>SeedInvest, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>289</th>\n",
" <td>0001699481</td>\n",
" <td>Trikke Tech Inc.</td>\n",
" <td>2017-08-07</td>\n",
" <td>0001603038</td>\n",
" <td>SI SECURITIES, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>361</th>\n",
" <td>0001705463</td>\n",
" <td>Darling Media, Inc.</td>\n",
" <td>2017-08-07</td>\n",
" <td>0001683054</td>\n",
" <td>FIRST DEMOCRACY VC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>329</th>\n",
" <td>0001697113</td>\n",
" <td>Exploride, Inc.</td>\n",
" <td>2017-08-08</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>260</th>\n",
" <td>0001705546</td>\n",
" <td>Grease Box, LLC</td>\n",
" <td>2017-08-08</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>254</th>\n",
" <td>0001681334</td>\n",
" <td>SecurShade Inc</td>\n",
" <td>2017-08-11</td>\n",
" <td>0001625242</td>\n",
" <td>VENTURE.CO BROKERAGE SERVICES LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>330</th>\n",
" <td>0001692073</td>\n",
" <td>Filmio, Inc.</td>\n",
" <td>2017-08-13</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>392</th>\n",
" <td>0001557286</td>\n",
" <td>Napa Valley Limoncello Co, LLC</td>\n",
" <td>2017-08-14</td>\n",
" <td>0001683054</td>\n",
" <td>First Democracy VC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>340</th>\n",
" <td>0001699829</td>\n",
" <td>Magnabid</td>\n",
" <td>2017-08-14</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>367</th>\n",
" <td>0001708725</td>\n",
" <td>chirrp,Inc.</td>\n",
" <td>2017-08-14</td>\n",
" <td>0001603038</td>\n",
" <td>SeedInvest, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>300</th>\n",
" <td>0001709126</td>\n",
" <td>Hear My Voice, Inc.</td>\n",
" <td>2017-08-14</td>\n",
" <td>0001603038</td>\n",
" <td>SI Securities, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>337</th>\n",
" <td>0001702978</td>\n",
" <td>Yonduur</td>\n",
" <td>2017-08-15</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>0001682915</td>\n",
" <td>RealtyReturns, Inc.</td>\n",
" <td>2017-08-17</td>\n",
" <td>0001670761</td>\n",
" <td>DreamFunded MarketPlace, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>397</th>\n",
" <td>0001641104</td>\n",
" <td>Sam Lee Laundry LLC</td>\n",
" <td>2017-08-18</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>272</th>\n",
" <td>0001694994</td>\n",
" <td>Big Cheese, Inc.</td>\n",
" <td>2017-08-18</td>\n",
" <td>0001665087</td>\n",
" <td>FlashFunders Funding Portal, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>410</th>\n",
" <td>0001704012</td>\n",
" <td>Next Future Transportation Inc.</td>\n",
" <td>2017-08-18</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>308</th>\n",
" <td>0001703197</td>\n",
" <td>Count It Labs Inc.</td>\n",
" <td>2017-08-21</td>\n",
" <td>0001603038</td>\n",
" <td>SI SECURITIES, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>311</th>\n",
" <td>0001707005</td>\n",
" <td>Puptimize Inc.</td>\n",
" <td>2017-08-21</td>\n",
" <td>0001603038</td>\n",
" <td>SI SECURITIES, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>313</th>\n",
" <td>0001396156</td>\n",
" <td>LARADA SCIENCES INC</td>\n",
" <td>2017-08-22</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>395</th>\n",
" <td>0001691935</td>\n",
" <td>Princeton Audio, LLC</td>\n",
" <td>2017-08-22</td>\n",
" <td>0001683054</td>\n",
" <td>First Democracy VC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>407</th>\n",
" <td>0001704611</td>\n",
" <td>GRACEDBYGRIT</td>\n",
" <td>2017-08-22</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>365</th>\n",
" <td>0001710903</td>\n",
" <td>The Light Phone Inc.</td>\n",
" <td>2017-08-24</td>\n",
" <td>0001672732</td>\n",
" <td>OpenDeal Inc., dba Republic</td>\n",
" </tr>\n",
" <tr>\n",
" <th>309</th>\n",
" <td>0001706937</td>\n",
" <td>WhereBy.Us Enterprises, Inc</td>\n",
" <td>2017-08-28</td>\n",
" <td>0001603038</td>\n",
" <td>SI SECURITIES, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>391</th>\n",
" <td>0001708142</td>\n",
" <td>Ironclad Distillery, Inc.</td>\n",
" <td>2017-08-28</td>\n",
" <td>0001683054</td>\n",
" <td>First Democracy VC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>321</th>\n",
" <td>0001708461</td>\n",
" <td>SCOLLAR, INC.</td>\n",
" <td>2017-08-28</td>\n",
" <td>0001603038</td>\n",
" <td>SI SECURITIES, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>324</th>\n",
" <td>0001710284</td>\n",
" <td>Leah Shabshelowitz</td>\n",
" <td>2017-08-28</td>\n",
" <td>0001603038</td>\n",
" <td>SeedInvest, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>326</th>\n",
" <td>0001710400</td>\n",
" <td>VolAero UAV &amp; Drones Holdings Corp.</td>\n",
" <td>2017-08-28</td>\n",
" <td>0001669191</td>\n",
" <td>NetCapital Funding Portal Inc.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>409</th>\n",
" <td>0001671112</td>\n",
" <td>Mi Ola, Inc</td>\n",
" <td>2017-08-31</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>401</th>\n",
" <td>0001674439</td>\n",
" <td>NextRX Inc.</td>\n",
" <td>2017-08-31</td>\n",
" <td>0001667145</td>\n",
" <td>truCrowd, Inc</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92</th>\n",
" <td>0001688437</td>\n",
" <td>Eve Fund 1, LLC.</td>\n",
" <td>2017-08-31</td>\n",
" <td>0001598610</td>\n",
" <td>Indie Crowd Funder, LLC.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224</th>\n",
" <td>0001699583</td>\n",
" <td>JPM Forex inc.</td>\n",
" <td>2017-08-31</td>\n",
" <td>0001667145</td>\n",
" <td>truCrowd, Inc</td>\n",
" </tr>\n",
" <tr>\n",
" <th>381</th>\n",
" <td>0001703592</td>\n",
" <td>MySwimPro, Inc.</td>\n",
" <td>2017-08-31</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>334</th>\n",
" <td>0001706022</td>\n",
" <td>Vibrant TV, LLC</td>\n",
" <td>2017-08-31</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>331</th>\n",
" <td>0001706237</td>\n",
" <td>K-LAWYERS, INC.</td>\n",
" <td>2017-08-31</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Company CIK Company Name Funding Deadline \\\n",
"293 0001522456 Richard Garriott de Cayeux 2017-08-07 \n",
"289 0001699481 Trikke Tech Inc. 2017-08-07 \n",
"361 0001705463 Darling Media, Inc. 2017-08-07 \n",
"329 0001697113 Exploride, Inc. 2017-08-08 \n",
"260 0001705546 Grease Box, LLC 2017-08-08 \n",
"254 0001681334 SecurShade Inc 2017-08-11 \n",
"330 0001692073 Filmio, Inc. 2017-08-13 \n",
"392 0001557286 Napa Valley Limoncello Co, LLC 2017-08-14 \n",
"340 0001699829 Magnabid 2017-08-14 \n",
"367 0001708725 chirrp,Inc. 2017-08-14 \n",
"300 0001709126 Hear My Voice, Inc. 2017-08-14 \n",
"337 0001702978 Yonduur 2017-08-15 \n",
"41 0001682915 RealtyReturns, Inc. 2017-08-17 \n",
"397 0001641104 Sam Lee Laundry LLC 2017-08-18 \n",
"272 0001694994 Big Cheese, Inc. 2017-08-18 \n",
"410 0001704012 Next Future Transportation Inc. 2017-08-18 \n",
"308 0001703197 Count It Labs Inc. 2017-08-21 \n",
"311 0001707005 Puptimize Inc. 2017-08-21 \n",
"313 0001396156 LARADA SCIENCES INC 2017-08-22 \n",
"395 0001691935 Princeton Audio, LLC 2017-08-22 \n",
"407 0001704611 GRACEDBYGRIT 2017-08-22 \n",
"365 0001710903 The Light Phone Inc. 2017-08-24 \n",
"309 0001706937 WhereBy.Us Enterprises, Inc 2017-08-28 \n",
"391 0001708142 Ironclad Distillery, Inc. 2017-08-28 \n",
"321 0001708461 SCOLLAR, INC. 2017-08-28 \n",
"324 0001710284 Leah Shabshelowitz 2017-08-28 \n",
"326 0001710400 VolAero UAV & Drones Holdings Corp. 2017-08-28 \n",
"409 0001671112 Mi Ola, Inc 2017-08-31 \n",
"401 0001674439 NextRX Inc. 2017-08-31 \n",
"92 0001688437 Eve Fund 1, LLC. 2017-08-31 \n",
"224 0001699583 JPM Forex inc. 2017-08-31 \n",
"381 0001703592 MySwimPro, Inc. 2017-08-31 \n",
"334 0001706022 Vibrant TV, LLC 2017-08-31 \n",
"331 0001706237 K-LAWYERS, INC. 2017-08-31 \n",
"\n",
" Platform CIK Platform Name \n",
"293 0001603038 SeedInvest, LLC \n",
"289 0001603038 SI SECURITIES, LLC \n",
"361 0001683054 FIRST DEMOCRACY VC \n",
"329 0001665160 StartEngine Capital, LLC \n",
"260 0001670254 Wefunder Portal LLC \n",
"254 0001625242 VENTURE.CO BROKERAGE SERVICES LLC \n",
"330 0001665160 StartEngine Capital, LLC \n",
"392 0001683054 First Democracy VC \n",
"340 0001665160 StartEngine Capital, LLC \n",
"367 0001603038 SeedInvest, LLC \n",
"300 0001603038 SI Securities, LLC \n",
"337 0001665160 StartEngine Capital, LLC \n",
"41 0001670761 DreamFunded MarketPlace, LLC \n",
"397 0001670254 Wefunder Portal LLC \n",
"272 0001665087 FlashFunders Funding Portal, LLC \n",
"410 0001665160 StartEngine Capital, LLC \n",
"308 0001603038 SI SECURITIES, LLC \n",
"311 0001603038 SI SECURITIES, LLC \n",
"313 0001665160 StartEngine Capital LLC \n",
"395 0001683054 First Democracy VC \n",
"407 0001665160 StartEngine Capital, LLC \n",
"365 0001672732 OpenDeal Inc., dba Republic \n",
"309 0001603038 SI SECURITIES, LLC \n",
"391 0001683054 First Democracy VC \n",
"321 0001603038 SI SECURITIES, LLC \n",
"324 0001603038 SeedInvest, LLC \n",
"326 0001669191 NetCapital Funding Portal Inc. \n",
"409 0001665160 StartEngine Capital, LLC \n",
"401 0001667145 truCrowd, Inc \n",
"92 0001598610 Indie Crowd Funder, LLC. \n",
"224 0001667145 truCrowd, Inc \n",
"381 0001670254 Wefunder Portal LLC \n",
"334 0001665160 StartEngine Capital, LLC \n",
"331 0001665160 StartEngine Capital, LLC "
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"month.to_csv(\"201708.csv\", index=False)\n",
"month"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Company CIK</th>\n",
" <th>Company Name</th>\n",
" <th>Funding Deadline</th>\n",
" <th>Platform CIK</th>\n",
" <th>Platform Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>273</th>\n",
" <td>0001682209</td>\n",
" <td>Chicago Steak Company, Inc.</td>\n",
" <td>2017-09-01</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>271</th>\n",
" <td>0001691477</td>\n",
" <td>Cornerstone Kids, Inc.</td>\n",
" <td>2017-09-01</td>\n",
" <td>0001664804</td>\n",
" <td>Jumpstart Micro, Inc</td>\n",
" </tr>\n",
" <tr>\n",
" <th>180</th>\n",
" <td>0001699705</td>\n",
" <td>Retaggio's, Inc</td>\n",
" <td>2017-09-01</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>325</th>\n",
" <td>0001708179</td>\n",
" <td>Hoke Poke 5077 Lankershim, LLC</td>\n",
" <td>2017-09-01</td>\n",
" <td>0001667892</td>\n",
" <td>NextSeed US LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>370</th>\n",
" <td>0001711575</td>\n",
" <td>SXC Live Inc.</td>\n",
" <td>2017-09-02</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>422</th>\n",
" <td>0001709244</td>\n",
" <td>Gab Al Inc</td>\n",
" <td>2017-09-08</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>356</th>\n",
" <td>0001711484</td>\n",
" <td>Kriya, Inc</td>\n",
" <td>2017-09-10</td>\n",
" <td>0001603038</td>\n",
" <td>SI Securities, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>358</th>\n",
" <td>0001711652</td>\n",
" <td>Baja United Imports, Inc.</td>\n",
" <td>2017-09-10</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>364</th>\n",
" <td>0001710938</td>\n",
" <td>Franklin and Cortlandt Vinyl LLC</td>\n",
" <td>2017-09-13</td>\n",
" <td>0001683054</td>\n",
" <td>First Democracy VC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>270</th>\n",
" <td>0001706216</td>\n",
" <td>Noise Makers Studios</td>\n",
" <td>2017-09-14</td>\n",
" <td>0001668506</td>\n",
" <td>GrowthFountain Capital LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>261</th>\n",
" <td>0001699476</td>\n",
" <td>PlantSnap Inc.</td>\n",
" <td>2017-09-15</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>369</th>\n",
" <td>0001701787</td>\n",
" <td>Nutripy, Inc.</td>\n",
" <td>2017-09-17</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>408</th>\n",
" <td>0001706908</td>\n",
" <td>GeoOrbital Inc.</td>\n",
" <td>2017-09-18</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>372</th>\n",
" <td>0001706977</td>\n",
" <td>Snowledge Corporation</td>\n",
" <td>2017-09-18</td>\n",
" <td>0001603038</td>\n",
" <td>SeedInvest, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>366</th>\n",
" <td>0001711429</td>\n",
" <td>Three Little Stooges Productions LLC</td>\n",
" <td>2017-09-18</td>\n",
" <td>0001683054</td>\n",
" <td>First Democracy VC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>393</th>\n",
" <td>0001605652</td>\n",
" <td>NestGSV, Inc.</td>\n",
" <td>2017-09-19</td>\n",
" <td>0001683054</td>\n",
" <td>First Democracy VC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>332</th>\n",
" <td>0001706788</td>\n",
" <td>Los Angeles SuperStars, Inc.</td>\n",
" <td>2017-09-19</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>236</th>\n",
" <td>0001701418</td>\n",
" <td>BlueHollar, LLC</td>\n",
" <td>2017-09-20</td>\n",
" <td>0001668506</td>\n",
" <td>GrowthFountain Capital LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>374</th>\n",
" <td>0001701373</td>\n",
" <td>SPARE CS, INC</td>\n",
" <td>2017-09-22</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>379</th>\n",
" <td>0001689103</td>\n",
" <td>OPER, LLC</td>\n",
" <td>2017-09-23</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>378</th>\n",
" <td>0001712494</td>\n",
" <td>Go Fish Marketplace, Inc.</td>\n",
" <td>2017-09-23</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>384</th>\n",
" <td>0001712452</td>\n",
" <td>PRINT THE FUTURE, INC.</td>\n",
" <td>2017-09-24</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>382</th>\n",
" <td>0001660948</td>\n",
" <td>BOXX Corp</td>\n",
" <td>2017-09-25</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>287</th>\n",
" <td>0001687706</td>\n",
" <td>Alkane Truck Company, Inc</td>\n",
" <td>2017-09-25</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>196</th>\n",
" <td>0001701254</td>\n",
" <td>GlobeChat, Inc.</td>\n",
" <td>2017-09-25</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>406</th>\n",
" <td>0001706413</td>\n",
" <td>Caylent, Inc.</td>\n",
" <td>2017-09-25</td>\n",
" <td>0001669191</td>\n",
" <td>NetCapital Funding Portal Inc.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>383</th>\n",
" <td>0001712508</td>\n",
" <td>MedAnswers, Inc</td>\n",
" <td>2017-09-25</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>306</th>\n",
" <td>0001687197</td>\n",
" <td>Bluurp, Inc</td>\n",
" <td>2017-09-26</td>\n",
" <td>0001670761</td>\n",
" <td>DreamFunded MarketPlace, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>399</th>\n",
" <td>0001713288</td>\n",
" <td>Keezel, Inc.</td>\n",
" <td>2017-09-26</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>193</th>\n",
" <td>0001699472</td>\n",
" <td>Beachmonkey Inc.</td>\n",
" <td>2017-09-27</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>338</th>\n",
" <td>0001677504</td>\n",
" <td>Fama, Inc.</td>\n",
" <td>2017-09-28</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>389</th>\n",
" <td>0001695197</td>\n",
" <td>BLAZnTECH, Inc.</td>\n",
" <td>2017-09-28</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>386</th>\n",
" <td>0001701035</td>\n",
" <td>CentSai Inc.</td>\n",
" <td>2017-09-29</td>\n",
" <td>0001603038</td>\n",
" <td>SI SECURITIES, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>377</th>\n",
" <td>0001710332</td>\n",
" <td>Duralogic USA, LLC</td>\n",
" <td>2017-09-29</td>\n",
" <td>0001603038</td>\n",
" <td>SI Securities, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>421</th>\n",
" <td>0000352956</td>\n",
" <td>FAFCO, INC.</td>\n",
" <td>2017-09-30</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>312</th>\n",
" <td>0001608695</td>\n",
" <td>G. Randall &amp; Sons, Inc.</td>\n",
" <td>2017-09-30</td>\n",
" <td>0001667145</td>\n",
" <td>truCrowd, Inc</td>\n",
" </tr>\n",
" <tr>\n",
" <th>298</th>\n",
" <td>0001684321</td>\n",
" <td>Italian Cafe, LLC</td>\n",
" <td>2017-09-30</td>\n",
" <td>0001667727</td>\n",
" <td>crowdsourcefunded.com</td>\n",
" </tr>\n",
" <tr>\n",
" <th>155</th>\n",
" <td>0001688220</td>\n",
" <td>KBlock Tools, LLC</td>\n",
" <td>2017-09-30</td>\n",
" <td>0001670761</td>\n",
" <td>DreamFunded MarketPlace, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>145</th>\n",
" <td>0001690216</td>\n",
" <td>Bronzebuck LLC</td>\n",
" <td>2017-09-30</td>\n",
" <td>0001667727</td>\n",
" <td>crowdsourcefunded.com</td>\n",
" </tr>\n",
" <tr>\n",
" <th>390</th>\n",
" <td>0001704205</td>\n",
" <td>Ideal Conceal, Inc.</td>\n",
" <td>2017-09-30</td>\n",
" <td>0001667145</td>\n",
" <td>truCrowd, Inc</td>\n",
" </tr>\n",
" <tr>\n",
" <th>363</th>\n",
" <td>0001705496</td>\n",
" <td>Stanley Grove LLC</td>\n",
" <td>2017-09-30</td>\n",
" <td>0001665872</td>\n",
" <td>MinnowCfunding LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>387</th>\n",
" <td>0001711875</td>\n",
" <td>Jetpack, Inc.</td>\n",
" <td>2017-09-30</td>\n",
" <td>0001672732</td>\n",
" <td>OpenDeal, Inc., dba Republic</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Company CIK Company Name Funding Deadline \\\n",
"273 0001682209 Chicago Steak Company, Inc. 2017-09-01 \n",
"271 0001691477 Cornerstone Kids, Inc. 2017-09-01 \n",
"180 0001699705 Retaggio's, Inc 2017-09-01 \n",
"325 0001708179 Hoke Poke 5077 Lankershim, LLC 2017-09-01 \n",
"370 0001711575 SXC Live Inc. 2017-09-02 \n",
"422 0001709244 Gab Al Inc 2017-09-08 \n",
"356 0001711484 Kriya, Inc 2017-09-10 \n",
"358 0001711652 Baja United Imports, Inc. 2017-09-10 \n",
"364 0001710938 Franklin and Cortlandt Vinyl LLC 2017-09-13 \n",
"270 0001706216 Noise Makers Studios 2017-09-14 \n",
"261 0001699476 PlantSnap Inc. 2017-09-15 \n",
"369 0001701787 Nutripy, Inc. 2017-09-17 \n",
"408 0001706908 GeoOrbital Inc. 2017-09-18 \n",
"372 0001706977 Snowledge Corporation 2017-09-18 \n",
"366 0001711429 Three Little Stooges Productions LLC 2017-09-18 \n",
"393 0001605652 NestGSV, Inc. 2017-09-19 \n",
"332 0001706788 Los Angeles SuperStars, Inc. 2017-09-19 \n",
"236 0001701418 BlueHollar, LLC 2017-09-20 \n",
"374 0001701373 SPARE CS, INC 2017-09-22 \n",
"379 0001689103 OPER, LLC 2017-09-23 \n",
"378 0001712494 Go Fish Marketplace, Inc. 2017-09-23 \n",
"384 0001712452 PRINT THE FUTURE, INC. 2017-09-24 \n",
"382 0001660948 BOXX Corp 2017-09-25 \n",
"287 0001687706 Alkane Truck Company, Inc 2017-09-25 \n",
"196 0001701254 GlobeChat, Inc. 2017-09-25 \n",
"406 0001706413 Caylent, Inc. 2017-09-25 \n",
"383 0001712508 MedAnswers, Inc 2017-09-25 \n",
"306 0001687197 Bluurp, Inc 2017-09-26 \n",
"399 0001713288 Keezel, Inc. 2017-09-26 \n",
"193 0001699472 Beachmonkey Inc. 2017-09-27 \n",
"338 0001677504 Fama, Inc. 2017-09-28 \n",
"389 0001695197 BLAZnTECH, Inc. 2017-09-28 \n",
"386 0001701035 CentSai Inc. 2017-09-29 \n",
"377 0001710332 Duralogic USA, LLC 2017-09-29 \n",
"421 0000352956 FAFCO, INC. 2017-09-30 \n",
"312 0001608695 G. Randall & Sons, Inc. 2017-09-30 \n",
"298 0001684321 Italian Cafe, LLC 2017-09-30 \n",
"155 0001688220 KBlock Tools, LLC 2017-09-30 \n",
"145 0001690216 Bronzebuck LLC 2017-09-30 \n",
"390 0001704205 Ideal Conceal, Inc. 2017-09-30 \n",
"363 0001705496 Stanley Grove LLC 2017-09-30 \n",
"387 0001711875 Jetpack, Inc. 2017-09-30 \n",
"\n",
" Platform CIK Platform Name \n",
"273 0001670254 Wefunder Portal LLC \n",
"271 0001664804 Jumpstart Micro, Inc \n",
"180 0001670254 Wefunder Portal LLC \n",
"325 0001667892 NextSeed US LLC \n",
"370 0001665160 StartEngine Capital, LLC \n",
"422 0001665160 StartEngine Capital, LLC \n",
"356 0001603038 SI Securities, LLC \n",
"358 0001665160 StartEngine Capital, LLC \n",
"364 0001683054 First Democracy VC \n",
"270 0001668506 GrowthFountain Capital LLC \n",
"261 0001670254 Wefunder Portal LLC \n",
"369 0001665160 StartEngine Capital, LLC \n",
"408 0001665160 StartEngine Capital LLC \n",
"372 0001603038 SeedInvest, LLC \n",
"366 0001683054 First Democracy VC \n",
"393 0001683054 First Democracy VC \n",
"332 0001665160 StartEngine Capital, LLC \n",
"236 0001668506 GrowthFountain Capital LLC \n",
"374 0001665160 StartEngine Capital, LLC \n",
"379 0001665160 StartEngine Capital, LLC \n",
"378 0001665160 StartEngine Capital, LLC \n",
"384 0001665160 StartEngine Capital, LLC \n",
"382 0001665160 StartEngine Capital, LLC \n",
"287 0001665160 StartEngine Capital, LLC \n",
"196 0001670254 Wefunder Portal LLC \n",
"406 0001669191 NetCapital Funding Portal Inc. \n",
"383 0001665160 StartEngine Capital, LLC \n",
"306 0001670761 DreamFunded MarketPlace, LLC \n",
"399 0001665160 StartEngine Capital, LLC \n",
"193 0001670254 Wefunder Portal LLC \n",
"338 0001665160 StartEngine Capital, LLC \n",
"389 0001670254 Wefunder Portal LLC \n",
"386 0001603038 SI SECURITIES, LLC \n",
"377 0001603038 SI Securities, LLC \n",
"421 0001670254 Wefunder Portal LLC \n",
"312 0001667145 truCrowd, Inc \n",
"298 0001667727 crowdsourcefunded.com \n",
"155 0001670761 DreamFunded MarketPlace, LLC \n",
"145 0001667727 crowdsourcefunded.com \n",
"390 0001667145 truCrowd, Inc \n",
"363 0001665872 MinnowCfunding LLC \n",
"387 0001672732 OpenDeal, Inc., dba Republic "
]
},
"execution_count": 26,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"month2 = df[(df[\"Funding Deadline\"] >= \"2017-09-01\") & (df[\"Funding Deadline\"] < \"2017-10-01\")]\n",
"month2.to_csv(\"201709.csv\", index=False)\n",
"month2"
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Company CIK</th>\n",
" <th>Company Name</th>\n",
" <th>Funding Deadline</th>\n",
" <th>Platform CIK</th>\n",
" <th>Platform Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>348</th>\n",
" <td>0001708189</td>\n",
" <td>IgnitedStudios Hollywood, LLC</td>\n",
" <td>2017-10-01</td>\n",
" <td>0001667892</td>\n",
" <td>NextSeed US LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353</th>\n",
" <td>0001706031</td>\n",
" <td>Suite 100 Edwards LLC</td>\n",
" <td>2017-10-02</td>\n",
" <td>0001667892</td>\n",
" <td>NextSeed US LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>318</th>\n",
" <td>0001710459</td>\n",
" <td>LafayetteRaceway.com, LLC</td>\n",
" <td>2017-10-02</td>\n",
" <td>0001669191</td>\n",
" <td>NetCapital Funding Portal Inc.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>291</th>\n",
" <td>0001705517</td>\n",
" <td>Herbal Compliance, CO</td>\n",
" <td>2017-10-04</td>\n",
" <td>0001668506</td>\n",
" <td>GrowthFountain Capital LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223</th>\n",
" <td>0001701251</td>\n",
" <td>BioClonetics Immunotherapeutics, Inc.</td>\n",
" <td>2017-10-08</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>420</th>\n",
" <td>0001680729</td>\n",
" <td>Arbit, Inc.</td>\n",
" <td>2017-10-10</td>\n",
" <td>0001683054</td>\n",
" <td>First Democracy VC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360</th>\n",
" <td>0001702940</td>\n",
" <td>Buy Insta Slim, Inc</td>\n",
" <td>2017-10-12</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>154</th>\n",
" <td>0001690794</td>\n",
" <td>StressPal, Inc.</td>\n",
" <td>2017-10-14</td>\n",
" <td>0001670761</td>\n",
" <td>DreamFunded MarketPlace, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>110</th>\n",
" <td>0001674421</td>\n",
" <td>Bloomery Investment Holdings, LLC</td>\n",
" <td>2017-10-16</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>352</th>\n",
" <td>0001710397</td>\n",
" <td>HUGY INC.</td>\n",
" <td>2017-10-16</td>\n",
" <td>0001669191</td>\n",
" <td>NetCapital Funding Portal Inc.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>414</th>\n",
" <td>0001709539</td>\n",
" <td>Shark Wheel LLC</td>\n",
" <td>2017-10-17</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>231</th>\n",
" <td>0001701252</td>\n",
" <td>Rental Marketplace, LLC</td>\n",
" <td>2017-10-18</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>248</th>\n",
" <td>0001699477</td>\n",
" <td>MilTec Platform, Inc.</td>\n",
" <td>2017-10-23</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>385</th>\n",
" <td>0001711471</td>\n",
" <td>YeKim LLC</td>\n",
" <td>2017-10-24</td>\n",
" <td>0001672732</td>\n",
" <td>OpenDeal Inc.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>244</th>\n",
" <td>0001701268</td>\n",
" <td>Brewtex LLC</td>\n",
" <td>2017-10-26</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>245</th>\n",
" <td>0001703945</td>\n",
" <td>Designer Solutions Inc.</td>\n",
" <td>2017-10-26</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>388</th>\n",
" <td>0001711700</td>\n",
" <td>N-Gen Technologies, Inc.</td>\n",
" <td>2017-10-26</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>423</th>\n",
" <td>0001713366</td>\n",
" <td>Spendwith, Corp.</td>\n",
" <td>2017-10-29</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>405</th>\n",
" <td>0001528338</td>\n",
" <td>JUDOBABY INC.</td>\n",
" <td>2017-10-30</td>\n",
" <td>0001665160</td>\n",
" <td>StartEngine Capital, LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>228</th>\n",
" <td>0001703991</td>\n",
" <td>FUGU, Inc.</td>\n",
" <td>2017-10-30</td>\n",
" <td>0001665812</td>\n",
" <td>GRIDSHARE LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>411</th>\n",
" <td>0001710904</td>\n",
" <td>Rapunzl Investments, LLC</td>\n",
" <td>2017-10-30</td>\n",
" <td>0001669191</td>\n",
" <td>NetCapital Funding Portal Inc.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>237</th>\n",
" <td>0001674249</td>\n",
" <td>Urban Juncture, Inc.</td>\n",
" <td>2017-10-31</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>396</th>\n",
" <td>0001689299</td>\n",
" <td>Ridgemont Outfitters, Inc.</td>\n",
" <td>2017-10-31</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>398</th>\n",
" <td>0001689304</td>\n",
" <td>Scrap Connection, Inc.</td>\n",
" <td>2017-10-31</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>249</th>\n",
" <td>0001703585</td>\n",
" <td>DirectCare, Inc.</td>\n",
" <td>2017-10-31</td>\n",
" <td>0001670254</td>\n",
" <td>Wefunder Portal LLC</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Company CIK Company Name Funding Deadline \\\n",
"348 0001708189 IgnitedStudios Hollywood, LLC 2017-10-01 \n",
"353 0001706031 Suite 100 Edwards LLC 2017-10-02 \n",
"318 0001710459 LafayetteRaceway.com, LLC 2017-10-02 \n",
"291 0001705517 Herbal Compliance, CO 2017-10-04 \n",
"223 0001701251 BioClonetics Immunotherapeutics, Inc. 2017-10-08 \n",
"420 0001680729 Arbit, Inc. 2017-10-10 \n",
"360 0001702940 Buy Insta Slim, Inc 2017-10-12 \n",
"154 0001690794 StressPal, Inc. 2017-10-14 \n",
"110 0001674421 Bloomery Investment Holdings, LLC 2017-10-16 \n",
"352 0001710397 HUGY INC. 2017-10-16 \n",
"414 0001709539 Shark Wheel LLC 2017-10-17 \n",
"231 0001701252 Rental Marketplace, LLC 2017-10-18 \n",
"248 0001699477 MilTec Platform, Inc. 2017-10-23 \n",
"385 0001711471 YeKim LLC 2017-10-24 \n",
"244 0001701268 Brewtex LLC 2017-10-26 \n",
"245 0001703945 Designer Solutions Inc. 2017-10-26 \n",
"388 0001711700 N-Gen Technologies, Inc. 2017-10-26 \n",
"423 0001713366 Spendwith, Corp. 2017-10-29 \n",
"405 0001528338 JUDOBABY INC. 2017-10-30 \n",
"228 0001703991 FUGU, Inc. 2017-10-30 \n",
"411 0001710904 Rapunzl Investments, LLC 2017-10-30 \n",
"237 0001674249 Urban Juncture, Inc. 2017-10-31 \n",
"396 0001689299 Ridgemont Outfitters, Inc. 2017-10-31 \n",
"398 0001689304 Scrap Connection, Inc. 2017-10-31 \n",
"249 0001703585 DirectCare, Inc. 2017-10-31 \n",
"\n",
" Platform CIK Platform Name \n",
"348 0001667892 NextSeed US LLC \n",
"353 0001667892 NextSeed US LLC \n",
"318 0001669191 NetCapital Funding Portal Inc. \n",
"291 0001668506 GrowthFountain Capital LLC \n",
"223 0001670254 Wefunder Portal LLC \n",
"420 0001683054 First Democracy VC \n",
"360 0001665160 StartEngine Capital, LLC \n",
"154 0001670761 DreamFunded MarketPlace, LLC \n",
"110 0001670254 Wefunder Portal LLC \n",
"352 0001669191 NetCapital Funding Portal Inc. \n",
"414 0001665160 StartEngine Capital, LLC \n",
"231 0001670254 Wefunder Portal LLC \n",
"248 0001670254 Wefunder Portal LLC \n",
"385 0001672732 OpenDeal Inc. \n",
"244 0001670254 Wefunder Portal LLC \n",
"245 0001670254 Wefunder Portal LLC \n",
"388 0001665160 StartEngine Capital, LLC \n",
"423 0001665160 StartEngine Capital, LLC \n",
"405 0001665160 StartEngine Capital, LLC \n",
"228 0001665812 GRIDSHARE LLC \n",
"411 0001669191 NetCapital Funding Portal Inc. \n",
"237 0001670254 Wefunder Portal LLC \n",
"396 0001670254 Wefunder Portal LLC \n",
"398 0001670254 Wefunder Portal LLC \n",
"249 0001670254 Wefunder Portal LLC "
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"month3 = df[(df[\"Funding Deadline\"] >= \"2017-10-01\") & (df[\"Funding Deadline\"] < \"2017-11-01\")]\n",
"month3.to_csv(\"201710.csv\", index=False)\n",
"month3"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 2",
"language": "python",
"name": "python2"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.10"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment