Sample data

Use sample data to familiarize yourself with time series data and InfluxDB Cloud. Sample datasets in InfluxDB Cloud let you access time series data without having to write data to InfluxDB. Sample datasets are available for download and can be written to InfluxDB or loaded at query time.

The sample data below contains both static and live datasets. A static sample dataset is not updated regularly and has fixed timestamps. A “live” sample dataset is updated regularly.

Sample datasets

Do one of the following:

• Run the sample data query in the Script Editor found in Explore from the left-hand navigation bar:
  • Air sensor sample data
  • Bird migration sample data
  • NOAA sample data
    • NOAA NDBC data
    • NOAA water sample data
  • USGS Earthquake data
• Write sample data with InfluxDB task

Air sensor sample data

Air sensor sample data represents an “Internet of Things” (IoT) use case by simulating temperature, humidity, and carbon monoxide levels for multiple rooms in a building.

To download and output the air sensor sample dataset, use the sample.data() function.

import "influxdata/influxdb/sample"

sample.data(set: "airSensor")

Companion SQL sensor data

The air sensor sample dataset is paired with a relational SQL dataset with meta information about sensors in each room. These two sample datasets are used to demonstrate how to join time series data and relational data with Flux in the Query SQL data sources guide.

Download SQL air sensor data

Bird migration sample data

Bird migration sample data is adapted from the Movebank: Animal Tracking data set and represents animal migratory movements throughout 2019.

To download and output the bird migration sample dataset, use the sample.data() function.

import "influxdata/influxdb/sample"

sample.data(set: "birdMigration")

The bird migration sample dataset is used in the Work with geo-temporal data guide to demonstrate how to query and analyze geo-temporal data.

NOAA sample data

The following two National Oceanic and Atmospheric Administration (NOAA) datasets are available to use with InfluxDB.

• NOAA NDBC data
• NOAA water sample data

NOAA NDBC data

The NOAA National Data Buoy Center (NDBC) dataset provides observations (updated every 15 minutes) from the NOAA NDBC network of buoys throughout the world.

To download and output the most recent NOAA NDBC observations, use the sample.data() function.

import "influxdata/influxdb/sample"

sample.data(set: "noaa")

import "influxdata/influxdb/sample"

option task = {
  name: "Collect NOAA NDBC data"
  every: 15m,
}

sample.data(set: "noaa")
  |> to(
      org: "example-org",
      bucket: "example-bucket"
  )

NOAA water sample data

The NOAA water sample dataset is static dataset extracted from NOAA Center for Operational Oceanographic Products and Services data. The sample dataset includes 15,258 observations of water levels (ft) collected every six minutes at two stations (Santa Monica, CA (ID 9410840) and Coyote Creek, CA (ID 9414575)) over the period from August 18, 2015 through September 18, 2015.

import "experimental/csv"

relativeToNow = (tables=<-) =>
  tables
    |> elapsed()
    |> sort(columns: ["_time"], desc: true)
    |> cumulativeSum(columns: ["elapsed"])
    |> map(fn: (r) => ({ r with _time: time(v: int(v: now()) - (r.elapsed * 1000000000))}))

csv.from(url: "https://influx-testdata.s3.amazonaws.com/noaa.csv")
  |> relativeToNow()
  |> to(bucket: "noaa", org: "example-org")

The NOAA water sample dataset is used to demonstrate Flux queries in the Common queries and Common tasks guides.

USGS Earthquake data

The United States Geological Survey (USGS) earthquake dataset contains observations collected from USGS seismic sensors around the world over the last week. Data is updated approximately every 15m.

To download and output the last week of USGS seismic data, use the sample.data() function.

import "influxdata/influxdb/sample"

sample.data(set: "usgs")

Write sample data with an InfluxDB task

Use the Flux InfluxDB sample package to download and write sample data to InfluxDB.

Add the following as an InfluxDB task.

import "influxdata/influxdb/sample"
option task = {
  name: "Collect NOAA NDBC data"
  every: 15m,
}
sample.data(set: "noaa")
  |> to(bucket: "noaa"  )