{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Univeristy of Minnesota River Surface Area Dataset" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Source\n", "\n", "https://data-catalog.mint.isi.edu/datasets/da6b6d47-7672-4e6e-a455-7bbc7e7ceb99" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Description\n", "\n", "The original University of Minnesota dataset contains timeseries surface area measurements (sq km) on 1.5 km x 1.5 km samples of Ethiopian rivers from satellite imagery data. This version of the data aggregates the measurements by woreda. Each surface measurement bounding box is intersected with the woredas. The river surface area of the bounding box is allocated to the woredas based on the fraction of coverage." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import io, os, json\n", "import pandas as pd\n", "from requests import post, put, delete, get\n", "from requests.auth import HTTPBasicAuth\n", "from io import StringIO\n", "from IPython.display import display, HTML" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "datamart_api_url = \"https://dsbox02.isi.edu:8888/datamart-api-wm\"\n", "user = \"datamart\" \n", "password = \"datamart-api-789\" \n", "auth = HTTPBasicAuth(user, password)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## API Examples\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get metadata about Aggregated dataset\n", "\n", "GET /metadata/datasets/UMINNESOTA_AGGREGATE" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
namedescriptionurldataset_idlast_updatelast_update_precision
0University of Minnesota River Segment Surface ...This dataset provides surface area timeseries ...https://data-catalog.mint.isi.edu/datasets/da6...UMINNESOTA_AGGREGATE2021-02-08T20:27:5214
\n", "
" ], "text/plain": [ " name \\\n", "0 University of Minnesota River Segment Surface ... \n", "\n", " description \\\n", "0 This dataset provides surface area timeseries ... \n", "\n", " url dataset_id \\\n", "0 https://data-catalog.mint.isi.edu/datasets/da6... UMINNESOTA_AGGREGATE \n", "\n", " last_update last_update_precision \n", "0 2021-02-08T20:27:52 14 " ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "url = f\"{datamart_api_url}/metadata/datasets/UMINNESOTA_AGGREGATE\"\n", "response = get(url, auth=auth)\n", "df = pd.DataFrame(response.json())\n", "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get metadata about Aggregated dataset\n", "\n", "GET /metadata/datasets/UMINNESOTA_AGGREGATE" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
namedescriptionurldataset_idlast_updatelast_update_precision
0University of Minnesota River Segment Surface ...This dataset provides surface area timeseries ...https://data-catalog.mint.isi.edu/datasets/da6...UMINNESOTA_AGGREGATE2021-02-08T20:27:5214
\n", "
" ], "text/plain": [ " name \\\n", "0 University of Minnesota River Segment Surface ... \n", "\n", " description \\\n", "0 This dataset provides surface area timeseries ... \n", "\n", " url dataset_id \\\n", "0 https://data-catalog.mint.isi.edu/datasets/da6... UMINNESOTA_AGGREGATE \n", "\n", " last_update last_update_precision \n", "0 2021-02-08T20:27:52 14 " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "url = f\"{datamart_api_url}/metadata/datasets/UMINNESOTA_AGGREGATE\"\n", "response = get(url, auth=auth)\n", "df = pd.DataFrame(response.json())\n", "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get variables for the dataset (Only area is available)\n", "\n", "GET /metadata/datasets/UMINNESOTA_AGGREGATE/variables" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[\n", " {\n", " \"name\": \"area\",\n", " \"variable_id\": \"area\",\n", " \"description\": \"area occupied by an object\",\n", " \"corresponds_to_property\": \"P2046\",\n", " \"qualifier\": [\n", " {\n", " \"name\": \"point in time\",\n", " \"identifier\": \"P585\"\n", " },\n", " {\n", " \"name\": \"stated in\",\n", " \"identifier\": \"P248\"\n", " }\n", " ]\n", " }\n", "]\n" ] } ], "source": [ "url = f\"{datamart_api_url}/metadata/datasets/UMINNESOTA_AGGREGATE/variables\"\n", "response = get(url, auth=auth)\n", "print(json.dumps(response.json(), indent=2))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get complete timeseries data\n", "\n", "GET /datasets/UMINNESOTA_AGGREGATE/variables/area" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
dataset_idvariable_idvariablemain_subjectmain_subject_idvaluevalue_unittimetime_precisioncountrycountry_idadmin1admin2admin3region_coordinatestated_instated_in_idstated in
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.8907422015-09-03T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459503.1993642015-10-03T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.2919192015-10-20T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459502.8153572015-10-23T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459502.5505452015-11-12T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459502.1016412015-11-22T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0430042015-11-29T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0087622015-12-09T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459501.4044792015-12-22T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0165442015-12-29T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459501.0444102016-01-01T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0179622016-01-08T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459501.0246172016-01-11T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0004712016-01-18T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.9874762016-01-21T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.9730922016-01-31T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0000472016-03-08T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.6678832016-03-11T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.6795732016-03-21T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.5559582016-04-10T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "url = f\"{datamart_api_url}/datasets/UMINNESOTA_AGGREGATE/variables/area\"\n", "response = get(url, auth=auth)\n", "df = pd.read_csv(StringIO(response.text))\n", "display(HTML(df.fillna('').head(20).to_html(index=False)))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get timeseries data for Oromia Region\n", "\n", "GET /datasets/UMINNESOTA_AGGREGATE/variables/area?admin1=Oromia%20Region" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
dataset_idvariable_idvariablemain_subjectmain_subject_idvaluevalue_unittimetime_precisioncountrycountry_idadmin1admin2admin3region_coordinatestated_instated_in_idstated in
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.7171462015-11-16T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.7099872015-11-26T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.9462282015-12-06T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.2560332015-12-16T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.2462862016-01-05T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.7324352016-01-25T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.5371352016-02-14T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224290.0380182016-02-24T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.0441072016-03-15T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224290.3849332016-03-25T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224290.1622962016-04-04T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224290.0825112016-04-14T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224290.1411542016-04-24T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.1280792016-05-04T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.1960332016-05-14T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.8499002016-05-24T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.6628802016-06-13T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224290.1350972016-06-23T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.1506872016-07-03T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
UMINNESOTA_AGGREGATEareaareaBosetQ24224291.2766992016-07-13T00:00:00ZdayEthiopiaQ115Oromia RegionMisraq Shewa ZoneBoset
" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "url = f\"{datamart_api_url}/datasets/UMINNESOTA_AGGREGATE/variables/area?admin1=Oromia%20Region\"\n", "response = get(url, auth=auth)\n", "df = pd.read_csv(StringIO(response.text))\n", "display(HTML(df.fillna('').head(20).to_html(index=False)))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Get timeseries data for Tsegede woreda\n", "\n", "GET /datasets/UMINNESOTA_AGGREGATE/variables/area?admin3=Tsegede" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
dataset_idvariable_idvariablemain_subjectmain_subject_idvaluevalue_unittimetime_precisioncountrycountry_idadmin1admin2admin3region_coordinatestated_instated_in_idstated in
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.8907422015-09-03T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459503.1993642015-10-03T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.2919192015-10-20T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459502.8153572015-10-23T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459502.5505452015-11-12T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459502.1016412015-11-22T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0430042015-11-29T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0087622015-12-09T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459501.4044792015-12-22T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0165442015-12-29T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459501.0444102016-01-01T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0179622016-01-08T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459501.0246172016-01-11T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0004712016-01-18T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.9874762016-01-21T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.9730922016-01-31T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.0000472016-03-08T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.6678832016-03-11T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.6795732016-03-21T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
UMINNESOTA_AGGREGATEareaareaTsegedeQ14459500.5559582016-04-10T00:00:00ZdayEthiopiaQ115Tigray RegionMi'irabawi ZoneTsegede
" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "url = f\"{datamart_api_url}/datasets/UMINNESOTA_AGGREGATE/variables/area?admin3=Tsegede\"\n", "response = get(url, auth=auth)\n", "df = pd.read_csv(StringIO(response.text))\n", "display(HTML(df.fillna('').head(20).to_html(index=False)))" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.10" } }, "nbformat": 4, "nbformat_minor": 4 }