Filter api example

100%

Filter api example

✓ Published0🌍 Public

Last edited Feb 9, 2019

Created on Feb 9, 2019

This example demonstrates the process of requesting a filtered dataset from the UK Office for National Statistics (ONS) API and asynchronously retrieving the resulting CSV file. It uses Python with the `requests` library to POST a JSON payload specifying a dataset edition and a geography dimension filter, then polls the returned `filter_output` link until the data is ready. The code parses the JSON response with `json.loads` and reads the CSV into a pandas DataFrame using `pd.read_csv`, highlighting an API workflow for on-demand data extraction.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist cf029c23fefdf183ae507ea5205298dc

This example demonstrates how to query the UK Office for National Statistics (ONS) beta API to retrieve filtered mid-year population estimates. The Python script constructs a JSON request specifying dimensions like age (0-89), sex, and time (2015-2017), then submits it via `requests.post` to the `/v1/filters` endpoint. The process illustrates that omitting a required `geography` dimension causes the request to fail, while including it allows the script to poll the returned `filter_output` link and obtain a CSV download URL. The code uses `requests`, `json`, and `pandas` to manage the API interaction and data retrieval.

RRobinL

81% match

Loading thumbnail…

API request OData CBS

This example demonstrates the structure and querying of CBS (Statistics Netherlands) open data via its OData API, showing how different URL patterns access metadata, raw datasets, and filtered subsets. The visualization highlights the API’s flexibility by contrasting `$top`, `$skip`, `$filter`, and `$format` parameters across both untyped and typed data feeds. It uses the `$metadata` endpoint to reveal the dataset schema, while the queries return JSON-formatted rows for geographic units like neighborhoods. The rendering relies on standard browser fetch or XMLHttpRequest for these OData requests, with no external visualization libraries—the focus is purely on data retrieval patterns and response structures.

FFrieseWoudloper

54% match

Loading thumbnail…

Some refactored API live coding

This example demonstrates a live-coding workflow for inspecting and cleaning data fetched from the Dutch RDW open-data API (`https://opendata.rdw.nl/resource/t5pc-eb34.json`). It fetches the raw JSON using the `fetch` API within an `async` function, then maps results down to a single selected column (`areaid`). With the filtered array, the code logs all data, a single record, and the cleaned column values, then uses a `Set` to list unique entries and filters for values containing "WEST". The visualization is limited to console output, with no graphical rendering.

Ddavidvanr21

51% match

Loading thumbnail…

Some refactored API live coding

This example demonstrates a live-coded workflow for inspecting and cleaning data from the Dutch government’s open-data API for road traffic information, accessed via the `fetch` API. It fetches JSON from the RDW endpoint, extracts values from a specified column (`areaid`), and then logs unique values and filters entries containing “WEST” using standard JavaScript array methods. The code shows a step-by-step refactoring process, with console output at each stage, but does not render a visualization. It uses no external libraries, relying solely on native JavaScript functions like `Set` for deduplication.

LLaurens

51% match

Loading thumbnail…

Untitled

This example demonstrates an interactive data table with filtering, sorting, and pagination controls, showing country-level economic indicators such as population, exchange rates, and GDP. Built with the TableFilter library, it provides dropdown selectors for country, ISO code, and year, along with custom numeric range filters and column-specific sorting. The table includes features like row counters, reset buttons, highlighted active columns, and keyword highlighting, all styled with custom CSS. Data is embedded directly in the HTML table structure, and TableFilter handles the client-side filtering and interaction logic.

JJunepp

49% match

Loading thumbnail…

How to use The Guardian's API to download article data for content analysis (in Python 3.x)

This example demonstrates how to perform content analysis on Guardian news articles by programmatically downloading article data through The Guardian’s open API. It shows the entire workflow, from constructing API queries with parameters like `from-date`, `to-date`, and `show-fields`, to parsing the returned JSON metadata and article bodies. The Python script uses the `requests` library to fetch paginated results into day-sized chunks, saving the raw JSON files locally for further analysis. The example also highlights the API’s response structure, including fields such as `wordcount`, `byline`, and full article HTML.

GGeorgeMcIntire

49% match

Loading thumbnail…

Live API Coding - By Laurens

This example fetches live data from the RDW Open Data API using the `fetch` function, starting with the endpoint `https://opendata.rdw.nl/resource/t5pc-eb34.json`. It retrieves the JSON response, logs the full dataset and the first record, and then applies a custom `filterData` function to extract all values for the `areaid` column. The code also defines a `listUnique` function to identify unique values in an array, though it is not called in the visible flow. The page itself is minimal, with no visual output—only console logging and basic HTML/CSS styling.

Ddavidvanr21

49% match

Loading thumbnail…

Gist e13df2ee55aa6c1117d5d6b6371e9b69

This example uses Yahoo Finance’s quote API to visualize live foreign-exchange data for the GBP/USD pair through D3.js. The JSON response is processed to display key metrics such as the current price, day’s high and low, and 52-week range, using D3’s scales and SVG paths to render a candlestick-style chart. Only the most recent quote is shown, with no time-series animation or historical data. The rendering logic draws on D3’s `forceSimulation` for layout and `geoPath` for styling, though the visual itself is a simple static chart of the currency pair’s market range.

RRobinL

49% match