Harvested on
Alex Market | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Berkeley Natural Grocery Company | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Five Markets | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Green Earth Natural Foods | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Healthy U | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Heartland Healthy Food | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Heartland ORGANIC & NATURAL FOODS | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Lakeshore Natural Foods | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Nature's Best Foods | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Oceana Market | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Sun Valley Fine Foods | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
The Food Mill | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
The Good Life Grocery | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
The Nature Stop | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
The Vital Moss | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
Valencia Whole Foods | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | https://www.google.com/maps/@37.7320273,-122.6758449,10z/data=!4m6!1m2!10m1!1e1!1... | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC | 2024-12-17 16:59:24 UTC |
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/n134374_42e66e939026c147270189f87120e17feses/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/n134374_42e66e939026c147270189f87120e17feses/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/n134374_42e66e939026c147270189f87120e17feses/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/n134374_42e66e939026c147270189f87120e17feses/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/n134374_42e66e939026c147270189f87120e17feses/latest_all.csv").read
temp_file.rewind
CSV.foreach( open(uri), :headers => :first_row ).each do |row|
# Each row
puts row
end