SODA Query

SODA (Socrata) Query Client for Deno.

Features

Create SODA queries
Use SODA queries to fetch from Socrata Open Data API
Build complex queries with ease, in a functional way
SQL Builder, inspired by sql-builder

Installation

import { SodaQuery } from 'https://deno.land/x/soda/mod.ts'

Example

import { SodaQuery } from 'https://deno.land/x/soda/mod.ts'

const DOMAIN = 'data.cityofnewyork.us';
const DATASET = 'erm2-nwe9';

const query = new SodaQuery(DOMAIN).withDataset(DATASET)
  .select('agency', 'borough', 'complaint_type')
  .where('complaint_type', 'LIKE', 'Noise%')
  .where('created_date', '>', '2019-01-01T00:00:00.000')
  .where('created_date', '<', '2020-01-01T00:00:00.000')
  .order('created_date', 'DESC')
  .limit(10)
  .execute()

API

SodaQuery

You can create a new SodaQuery instance by passing a domain and optionally an authOptions object and an options object.

import { SodaQuery } from 'https://deno.land/x/soda/mod.ts'

const query = new SodaQuery("data.organization.com");

There is also a shorthand, that will use the domain and dataset ID:

import { createQueryWithDataset } from 'https://deno.land/x/soda/mod.ts'

const query = createQueryWithDataset("data.organization.com", "dataset-id");

Querying data

Note: Most methods return the instance of SodaQuery. This means that you can chain methods together.

—> Documentation coming soon <---

License

MIT