• Market Insights
  • Community Data Catalog
  • Integrations
  • API Documentation
    • Documentation Overview
    • Quick start for getting Data
    • Quick start for exporting Data
    • Semantic Query Language
    • Data Source Management API
    • WebHooks API
    • Sentiment Analysis
  • Sign In
  • Sign Up for Free

Sign In

Sign in with Google
Sign in with LinkedIn
Sign in with GitHub
Forgot your password?
Sign up For Free

3 simple steps to get you started

Step 1. Watching this 55 seconds tutorial

Step 2. Get

Your Chrome Extension

Start your 55 seconds tutorial.

Step 3. Get data in a few clicks

Get data from any page you want to get data from.

Need more help?

Need to talk to someone? Contact us—we’d love to help.

3 simple steps to get you started

Step 1. Watching this 55 seconds tutorial

Step 2. Get

Your Chrome Extension

Start your 55 seconds tutorial.

Step 3. Get data in a few clicks

Get data from any page you want to get data from.

Need more help?

Need to talk to someone? Contact us—we’d love to help.

Opps...

We are still busy preparing this batch of data. Please come back in a few minutes.

Hmmm...

Seems like this data source was never ran before...

No changes detected

Changes are only available only when you have ran at least a second time.

Earth calling Mars...?

Nope... guess no Martians around... Maybe set the webhook URL before pressing this button again...

Server response
    

columbiabank.com
Leadership / Executive Team | Columbia Bank

By
Sarah Gray
2
Use for Free
  • Data Set Preview
  • Settings
  • Recipe
  • Collaborators
  • Sample Code
Harvested on
11
--
--
CSV JSON HTML Changes
namejob_titleemailorigin_patternorigin_urlcreatedAtupdatedAtpingedAt
Lisa K DowEVP, Chief Risk Officerdowl@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Greg SigristEVP, Chief Financial Officergsigrist@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Hadley S RobbinsPresident, CEOrobbinsh@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Dave LawsonEVP, Chief Human Resources Officerdlawson@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Andy McDonaldEVP, Chief Credit Officeramcdonald@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Kumi Y BaruffiEVP, General Counselkbaruffi@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Eric EidEVP, Chief Innovation and Technology Officereeid@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Clint SteinEVP, Chief Operating Officercstein@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Chris MerrywellEVP, Chief Consumer Banking Officercmerrywell@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
David DevineEVP, Chief Marketing Officerddevine@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Todd L LeberEVP, Chief Commercial Banking Officertleber@columbiabank.comhttps://www.columbiabank.com/about-us/leadershiphttps://www.columbiabank.com/about-us/leadership2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC2019-02-17 00:42:35 UTC
Data source unique ID
n24215_aaa9c65c96b91e40c787a0d6fa595146eses
Privacy
Public
Last ran status
COMPLETED
Last ran
2019-02-17 00:42:35 UTC
Crawl Frequency
Not scheduled
Urls to Monitor
Use default URL in recipe

Sample code snippets to quickly import data set into your application

For more information on how to automatically trigger an import please reference our WebHook API guide


Integrating with Java

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.URL;
import java.net.URLConnection;
import java.util.Arrays;

public class HelloWorld {
  public static void main(String[] args) {

    try {
      URL urlCSV = new URL(
        "https://cache.getdata.io/n24215_aaa9c65c96b91e40c787a0d6fa595146eses/latest_all.csv"
      );

      URLConnection urlConn = urlCSV.openConnection();
      InputStreamReader inputCSV = new InputStreamReader(
        ((URLConnection) urlConn).getInputStream()
      );
      BufferedReader br = new BufferedReader(inputCSV);

      String line;
      String[] fields;
      while ((line = br.readLine()) != null) {
        // Each row
        fields = line.split(",");
        System.out.println(Arrays.toString(fields));

      }
      // clean up buffered reader
      br.close();


    } catch (Exception e) {
      System.out.println(e.getMessage());
    }
  }   
}


Integrating with NodeJs

const csv     = require('csv-parser');
const https   = require('https');
const fs      = require('fs');

const file = fs.createWriteStream("temp_download.csv");
const request = https.get(
  "https://cache.getdata.io/n24215_aaa9c65c96b91e40c787a0d6fa595146eses/latest_all.csv", 
  function(response) {
    response.pipe(file);
  }
);

file.on('finish', function() {
  file.close();
  fs.createReadStream('temp_download.csv').pipe(csv()).on('data', (row) => {
    // Each row
    console.log(row);

  }).on('end', () => {
    console.log('CSV file successfully processed');

  });
});



Integrating with PHP

$data = file_get_contents("https://cache.getdata.io/n24215_aaa9c65c96b91e40c787a0d6fa595146eses/latest_all.csv");
$rows = explode("\n",$data);
$s = array();
foreach($rows as $row) {

  # Each row
  var_dump( $row);
  
}


Integrating with Python

import csv
import urllib2

url = 'https://cache.getdata.io/n24215_aaa9c65c96b91e40c787a0d6fa595146eses/latest_all.csv'
response = urllib2.urlopen(url)
cr = csv.reader(response)

for row in cr:
  # Each row
  print row


Integrating with Ruby

require 'open-uri'
require 'tempfile'
require 'csv'

temp_file = Tempfile.new( "getdata", :encoding => 'ascii-8bit')
temp_file << open("https://cache.getdata.io/n24215_aaa9c65c96b91e40c787a0d6fa595146eses/latest_all.csv").read
temp_file.rewind

CSV.foreach( open(uri), :headers => :first_row ).each do |row|      
  # Each row
  puts row
end

Sarah Gray owner

Categories

People
Finance

Related Data Sources

financialbuzz.com

Financial Buzz - The Latest Buzz in Financial News Online - news headlines - Copy

We monitor the news headline from this website which we then use to train our sentiment analysis e...

Finance

created on 2024-07-09

Matthew Baldwin
1
102

TikTok Influencer profile page email address scraping

Step 1: Generate a list of TikTok influencer handle URL using Google sheet Step 2: Submit t...

People

created on 2024-03-22

Gary Teh
3
182

datos recovery instagram

This recipe is useful for gathering Instagram profiles that are similar to the current profile you...

People

created on 2022-07-09

Luisangel Ascencio
3
5

Instagram social signals (name, handle, post, followers, following) - Copy - Copy

People

created on 2022-05-19

Ramy Nagy
3
49
More related data sources