Devam Ediyor

Extract Crunchbase company information using API into CSV

Project Description:

I am looking someone who can set me up with the ability to extract company information from Crunchbase.com.

Crunchbase provides an API:

- [url removed, login to view]

- [url removed, login to view]

- [url removed, login to view]

The final output should be in excel or csv format and I need to be able to run this script myself in future.

My API key is: api_key 7w7t4hh4bsf2t6qzkajcahkr

My requirements are:

- The script should be easy for me to run. Because I am not an expert you will need to outline what software/method I should use for this

- The output should be csv

In terms of exact outputs here are my requirements:

[The list of companies on Crunchbase is here: [url removed, login to view]

And a sample company is here: [url removed, login to view]]

The excel/csv output should contain columns with the following headings/content:

(0) Crunchbase URL ("crunchbase_url")

(1) Company name ("name")

(2) Crunchbase Link ("crunchbase_url")

(3) Website ("homepage_url")

(4) Blog ("blog_url")

(5) Twitter name ("twitter_username")

(6) Category ("category_code")

(7) Employees ("number_of_employees")

(8) Founded ("founded_year")

(9) Deadpull ("deadpooled_year")

(10) Tags ("tag_list")

(11) Description ("description")

(12) Overview ("overview")

(13) names of competitors

[url removed, login to view]

"competitions": ... --> Groundlink, Hailo

(14) The Country of the Headquarters ("country code" of headquarters)

(15) All information about fundings

[url removed, login to view]

one column/entry "total_money_raised": "$[url removed, login to view]",

then specific round info:

[{"round_code": "angel",

"raised_amount": 500000.0,

"funded_year": 2004,

"funded_month": 9,

"funded_day": 1,

...

make 2 columns for each "round_code": "seed", "angel", "a", "b", "c", "d", "unattributed" (= everything that is not angel, seed, a, b, c, d)

(facebook did several "c" rounds, should be summed up)

column example:

"total_money_raised", "seed raised_amount", "seed funded_date", ..., "unattributed amount"

$[url removed, login to view], -, -, 500000, 9/1/2004, 12700000, 5/1/2005, 27500000, 4/1/2006, 375000000, 7/1/2010 (if multiple round_codes, cumulate and take first date), 200000000, 5/26,2009, [unattributed amount]

unattributed amount is everything cumulated that is not seed, angel, a, b, c, or d (no date required)

Company got acquired (14) or IPOed (15):

(16) All information if the company has been acquired

Here is an example of a company that has acquisition information to extract:

[url removed, login to view]

The relevant information to extract is held within this section

"acquisition":

{"price_amount": null,

"price_currency_code": "USD",

"term_code": "cash",

"source_url": "[url removed, login to view]",

"acquired_year": 2007,

"acquiring_company":

{"name": "Facebook",

Here is an example of a company that has not been acquired ("acquisition": null)

[url removed, login to view]

Only the 'null'is required in this case.

(17) All information about an IPO if it has had one

Example company with an IPO: [url removed, login to view]

"ipo":

{"valuation_amount": 2740000000000.0,

"valuation_currency_code": "USD",

"pub_year": 2012,

"pub_month": 5,

"pub_day": 18,

"stock_symbol": "NASDAQ:FB"},

(for the CSV, you can use one column with the IPO / acquisition date, instead of 3 columns with pub_year, pub_month, pub_day)

Example company without an IPO: [url removed, login to view]

Beceriler: Mühendislik, MySQL, Yazılım Mimarisi, Yazılım Test Etme, Web Scraping

Daha fazlasını görün: contain web developer, web developer website names, web developer overview, web developer outline, web developer names, web developer company names, web developer companies list, method web developer, software developer overview, software developer names, overview web developer, need software engineering company, key web developer 2005, developer overview, fb developer, developer web section, cash engineering, angel web, facebook developer founded, using api, uber for, uber a, need company blog, key information, information about

İşveren Hakkında:
( 1 değerlendirme ) Downingtown, United States

Proje NO: #4416504

Seçilen:

ehsankayani

HI, I am an expert in making similar scripts and you can see it on my profile. I will make you a form application easy to use . Thank you

3 gün içinde 210$ USD
(35 Değerlendirme)
6.0

9 freelancer bu iş için ortalamada 183$ teklif veriyor

toinnisfree

quick pro help. ftp and milestone required.

in 4 gün içinde210$ USD
(319 Değerlendirme)
7.5
mantislin

Hi sir, please check PM, thx Kimi.

in 5 gün içinde248$ USD
(88 Değerlendirme)
6.2
marchent

Please read my message from your inbox. I have sent you a detail there.

in 5 gün içinde100$ USD
(143 Değerlendirme)
6.0
abupabuya

hi sir I just want sale my items if you interested.. .May be you need a mailing list to use in your business i have 500,000 USA EMAIL Business list- all have email, email was extracted from their own site

1 gün içinde 99$ USD
(14 Değerlendirme)
4.6
MohabSystems

Please check PMB for details. Thank you

in 3 gün içinde220$ USD
(8 Değerlendirme)
3.2
wbslivera

Hello, I can help you thanks

in 2 gün içinde84$ USD
(4 Değerlendirme)
2.6
ON7

did something exactly only that for other api, I'll send you the application that I created in 2 minutes for you to decide.

1 gün içinde 143$ USD
(2 Değerlendirme)
2.2
rlord17

I can have this done today once given the go ahead

1 gün içinde 330$ USD
(0 Değerlendirme)
0.0