Skip to content

Instantly share code, notes, and snippets.

@maccman

maccman/batch_request.csv

Last active Apr 14, 2020
Embed
What would you like to do?
Clearbit Batch Example
email
alex@clearbit.com
source status person_name_full_name person_name_given_name person_name_family_name person_email person_gender person_location person_time_zone person_utc_offset person_geo_city person_geo_state person_geo_state_code person_geo_country person_geo_country_code person_geo_lat person_geo_lng person_bio person_site person_avatar person_employment_domain person_employment_name person_employment_title person_employment_role person_employment_seniority person_facebook_handle person_github_handle person_github_id person_github_avatar person_github_company person_github_blog person_github_followers person_github_following person_twitter_handle person_twitter_id person_twitter_bio person_twitter_followers person_twitter_following person_twitter_statuses person_twitter_favorites person_twitter_location person_twitter_site person_twitter_avatar person_linkedin_handle person_googleplus_handle person_aboutme_handle person_aboutme_bio person_aboutme_avatar person_gravatar_handle person_gravatar_urls person_gravatar_avatar person_gravatar_avatars person_fuzzy company_name company_legal_name company_domain company_domain_aliases company_url company_site_url company_site_title company_site_h1 company_site_meta_description company_site_meta_author company_site_phone_numbers company_site_email_addresses company_category_sector company_category_industry_group company_category_industry company_category_sub_industry company_tags company_description company_founded_date company_location company_time_zone company_utc_offset company_geo_street_number company_geo_street_name company_geo_sub_premise company_geo_city company_geo_postal_code company_geo_state company_geo_state_code company_geo_country company_geo_country_code company_geo_lat company_geo_lng company_logo company_facebook_handle company_linkedin_handle company_twitter_handle company_twitter_id company_twitter_bio company_twitter_followers company_twitter_following company_twitter_location company_twitter_site company_twitter_avatar company_crunchbase_handle company_email_provider company_type company_ticker company_phone company_metrics_alexa_us_rank company_metrics_alexa_global_rank company_metrics_google_rank company_metrics_employees company_metrics_market_cap company_metrics_raised company_metrics_annual_revenue company_tech company_parent_name company_parent_domain
alex@clearbit.com found Alex MacCaw Alex MacCaw alex@clearbit.com male San Francisco, CA, US America/Los_Angeles -7.0 San Francisco California CA United States US 37.7749295 -122.4194155 https://clearbit.com co-founder. Tea, Earl Grey, hot. http://alexmaccaw.com https://d1ts43dypk8bqh.cloudfront.net/v1/avatars/7caac381-b2d2-4e16-924d-1c2505ac96f8 clearbit.com Clearbit Hacker engineering amaccaw maccman 2142.0 https://avatars.githubusercontent.com/u/2142?v=3 Clearbit http://alexmaccaw.com 3304.0 98.0 maccaw 2006261.0 https://clearbit.com co-founder. Tea, Earl Grey, hot. 17513.0 2068.0 9352.0 4782.0 San Francisco http://alexmaccaw.com https://pbs.twimg.com/profile_images/658880981017882629/nlXSOJnc.jpg in/alex-maccaw-ab592978 maccaw maccman {"title"=>"Personal Website","value"=>"http://alexmaccaw.com"} http://2.gravatar.com/avatar/994909da96d3afaf4daaf54973914b64 {"type"=>"thumbnail","url"=>"http://2.gravatar.com/avatar/994909da96d3afaf4daaf54973914b64"} Clearbit clearbit.com clearbit.co,apihub.co http://clearbit.com http://clearbit.com Clearbit Gain insights into your customers Clearbit provides powerful products and data APIs to help your business grow. Contact enrichment, lead generation, financial compliance, and more... +1 252-227-7014 ALEX@CLEARBIT.CO,team@clearbit.com,support@clearbit.com,alex@clearbit.com,harlow@clearbit.com,sales@clearbit.com Information Technology Software & Services Internet Software & Services Internet Software & Services SAAS,B2B,Information Technology & Services,Technology Clearbit provides powerful products and data APIs to help your business grow. Contact enrichment, lead generation, financial compliance, and more... 3030 16th St, San Francisco, CA 94103, USA America/Los_Angeles -7.0 3030 16th Street San Francisco 94103 California CA United States US 37.7652736 -122.4203596 https://logo.clearbit.com/clearbit.com company/clearbit clearbit 2857311332 Business Intelligence APIs 867.0 32.0 San Francisco https://t.co/r06mCbdPuR https://pbs.twimg.com/profile_images/557204249411457024/B0Nb_vTU_normal.png organization/clearbit private 30768.0 60958.0 11.0 3000000.0 google_analytics,mixpanel,adroll,segment,typekit_by_adobe,perfect_audience,mailgun,nginx,google_apps,aws_ec2,mixpanel,customer_io,aws_route_53
@raywu

This comment has been minimized.

Copy link

@raywu raywu commented Jun 28, 2017

@maccman Hi Alex, if the batch request consists of only domains, would the batch result leave person_ related columns empty? i.e.

| domain    | company.id                           | company.name | company.legalName | company.domain | company.domainAliases                                                                                                                                                                                    | company.url | company.site.url | company.site.title                 | company.site.h1              | company.site.metaDescription                                                                                                                           | company.site.metaAuthor | company.site.phoneNumbers                                                           | company.site.emailAddresses                                                                 | company.category.sector | company.category.industryGroup | company.category.industry | company.category.subIndustry | company.tags                                                   | company.description                                                                                                                                    | company.foundedYear | company.location                         | company.timeZone    | company.utcOffset | company.geo.streetNumber | company.geo.streetName | company.geo.subPremise | company.geo.city | company.geo.postalCode | company.geo.state | company.geo.stateCode | company.geo.country | company.geo.countryCode | company.geo.lat | company.geo.lng | company.logo                        | company.facebook.handle | company.facebook.likes | company.linkedin.handle | company.twitter.handle | company.twitter.id | company.twitter.bio                                                                                                                               | company.twitter.followers | company.twitter.following | company.twitter.location | company.twitter.site    | company.twitter.avatar                                                    | company.angellist.id | company.angellist.handle | company.angellist.description | company.angellist.followers | company.angellist.blogUrl | company.crunchbase.handle | company.emailProvider | company.type | company.ticker | company.phone   | company.metrics.alexaUsRank | company.metrics.alexaGlobalRank | company.metrics.googleRank | company.metrics.employees | company.metrics.marketCap | company.metrics.raised | company.metrics.annualRevenue | company.tech                                                                                                                             |
|-----------|--------------------------------------|--------------|-------------------|----------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------|------------------|------------------------------------|------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------|-------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------|-------------------------|--------------------------------|---------------------------|------------------------------|----------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------|------------------------------------------|---------------------|-------------------|--------------------------|------------------------|------------------------|------------------|------------------------|-------------------|-----------------------|---------------------|-------------------------|-----------------|-----------------|-------------------------------------|-------------------------|------------------------|-------------------------|------------------------|--------------------|---------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------|---------------------------|--------------------------|-------------------------|---------------------------------------------------------------------------|----------------------|--------------------------|-------------------------------|-----------------------------|---------------------------|---------------------------|-----------------------|--------------|----------------|-----------------|-----------------------------|---------------------------------|----------------------------|---------------------------|---------------------------|------------------------|-------------------------------|------------------------------------------------------------------------------------------------------------------------------------------|
| zynga.com | 92e1152b-8349-4b93-aa45-30459c6194b3 | Zynga        | Zynga Inc.        | zynga.com      | zynga.co.jp, zynga.co, zynga.jp, zynga.net, zynga.in, zynga.org, zynga.com.my, zynga.de, zindagigames.com, sports365.com, zynga.co.uk, risingtidegames.com, wordswithfriends.com, castlevillelegends.com |             |                  | Zynga | Free Mobile & Online Games | Zynga - Home of Online Games | Online games & mobile games offer limitless fun! Play the most popular free games around by Zynga - Farmville, Hit it Rich, Zynga Poker and many more! |                         | +1 415-339-5833, +1 415-869-6659, +1 415-869-3922, +1 800-762-2530, +1 800-778-7879 | ipagent@zynga.com, lawenforcement@zynga.com, privacy@zynga.com, support@risingtidegames.com | Consumer Discretionary  | Media                          | Media                     | Movies & Entertainment       | Video Games, Internet, Technology, Mobile, B2C, Computer Games | Online games & mobile games offer limitless fun! Play the most popular free games around by Zynga - Farmville, Hit it Rich, Zynga Poker and many more! | 2007                | 699 8th St, San Francisco, CA 94103, USA | America/Los_Angeles | -7                | 699                      | 8th Street             |                        | San Francisco    | 94103                  | California        | CA                    | United States       | US                      | 37.7704448      | -122.4041406    | https://logo.clearbit.com/zynga.com | zynga                   | 3460810                | company/zynga           | zynga                  | 22728255           | We love social games. To get more game info follow @ZyngaGames. For Support, follow @ZyngaSupport For investor relations: https://t.co/yhAZO7jd0I | 467335                    | 1175                      | San Francisco            | https://t.co/zE4hyRRotn | https://pbs.twimg.com/profile_images/2247033532/New_Zynga_Logo_normal.jpg |                      |                          |                               |                             |                           | organization/zynga        | FALSE                 | public       | ZNGA           | +1 800-762-2530 | 3807                        | 9557                            |                            | 1681                      | 3100000000                |                        | 741420000                     | google_analytics, outlook, aws_ec2, google_tag_manager, centos, microsoft_exchange_online, drupal, jobvite, microsoft_office_365, apache |
@erinneegrant

This comment has been minimized.

Copy link

@erinneegrant erinneegrant commented Jul 6, 2017

@raywu That is correct

@sahmmd778

This comment has been minimized.

Copy link

@sahmmd778 sahmmd778 commented Sep 18, 2019

الحميري لخدمات الجوال

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment