Federal Reserve Economic Data

API Keys | Terms of Use

fred/release/tables



Description

Get release table trees for a given release. You can go directly to the tree structure by passing the appropriate element_id. You may also use a drill-down approach to start at the root (top most) element by leaving the element_id off.

Note that release dates are published by data sources and do not necessarily represent when data will be available on the FRED or ALFRED websites.

Examples

This request can return either XML or JSON by setting the file_type parameter to xml or json. Note that the default value of file_type is xml. The API key 'abcdefghijklmnopqrstuvwxyz123456' is for demonstration purposes only. Use a registered API key instead.

XML

Request (HTTPS GET)

https://api.stlouisfed.org/fred/release/tables?release_id=53&api_key=abcdefghijklmnopqrstuvwxyz123456&element_id=12886

Response


<elements>
   <name>Personal consumption expenditures</name>
   <element_id>12886</element_id>
   <release_id>53</release_id>
   <element>
      <element_id>12887</element_id>
      <release_id>53</release_id>
      <series_id>DGDSRL1A225NBEA</series_id>
      <parent_id>12886</parent_id>
      <line>3</line>
      <type>series</type>
      <name>Goods</name>
      <level>1</level>
      <children>
         <element>
            <element_id>12888</element_id>
            <release_id>53</release_id>
            <series_id>DDURRL1A225NBEA</series_id>
            <parent_id>12887</parent_id>
            <line>4</line>
            <type>series</type>
            <name>Durable goods</name>
            <level>2</level>
            <children/>
         </element>
         <element>
            <element_id>12889</element_id>
            <release_id>53</release_id>
            <series_id>DNDGRL1A225NBEA</series_id>
            <parent_id>12887</parent_id>
            <line>5</line>
            <type>series</type>
            <name>Nondurable goods</name>
            <level>2</level>
            <children/>
         </element>
      </children>
   </element>
   <element>
      <element_id>12888</element_id>
      <release_id>53</release_id>
      <series_id>DDURRL1A225NBEA</series_id>
      <parent_id>12887</parent_id>
      <line>4</line>
      <type>series</type>
      <name>Durable goods</name>
      <level>2</level>
      <children/>
   </element>
   <element>
      <element_id>12889</element_id>
      <release_id>53</release_id>
      <series_id>DNDGRL1A225NBEA</series_id>
      <parent_id>12887</parent_id>
      <line>5</line>
      <type>series</type>
      <name>Nondurable goods</name>
      <level>2</level>
      <children/>    
   </element>
   <element>
      <element_id>12890</element_id>
      <release_id>53</release_id>
      <series_id>DSERRL1A225NBEA</series_id>
      <parent_id>12886</parent_id>
      <line>6</line>
      <type>series</type>
      <name>Services</name>
      <level>1</level>
      <children/>
   </element>
</elements>

JSON

Request (HTTPS GET)

https://api.stlouisfed.org/fred/release/tables?release_id=53&api_key=abcdefghijklmnopqrstuvwxyz123456&element_id=12886&file_type=json

Response


{  
  {
  "name": "Personal consumption expenditures",
  "element_id": 12886,
  "release_id": "53",
  "elements": {
    "12887": {
      "element_id": 12887,
      "release_id": 53,
      "series_id": "DGDSRL1A225NBEA",
      "parent_id": 12886,
      "line": "3",
      "type": "series",
      "name": "Goods",
      "level": "1",
      "children": [
        {
          "element_id": 12888,
          "release_id": 53,
          "series_id": "DDURRL1A225NBEA",
          "parent_id": 12887,
          "line": "4",
          "type": "series",
          "name": "Durable goods",
          "level": "2",
          "children": [
            
          ]
        },
        {
          "element_id": 12889,
          "release_id": 53,
          "series_id": "DNDGRL1A225NBEA",
          "parent_id": 12887,
          "line": "5",
          "type": "series",
          "name": "Nondurable goods",
          "level": "2",
          "children": [
            
          ]
        }
      ]
    },
    "12888": {
      "element_id": 12888,
      "release_id": 53,
      "series_id": "DDURRL1A225NBEA",
      "parent_id": 12887,
      "line": "4",
      "type": "series",
      "name": "Durable goods",
      "level": "2",
      "children": [
        
      ]
    },
    "12889": {
      "element_id": 12889,
      "release_id": 53,
      "series_id": "DNDGRL1A225NBEA",
      "parent_id": 12887,
      "line": "5",
      "type": "series",
      "name": "Nondurable goods",
      "level": "2",
      "children": [
        
      ]
    },
    "12890": {
      "element_id": 12890,
      "release_id": 53,
      "series_id": "DSERRL1A225NBEA",
      "parent_id": 12886,
      "line": "6",
      "type": "series",
      "name": "Services",
      "level": "1",
      "children": [
        
      ]
    }
  }
}

Parameters

api_key

Read API Keys for more information.

release_id

The id for a release.

file_type

A key or file extension that indicates the type of file to send.

element_id

The release table element id you would like to retrieve.

include_observation_values

A flag to indicate that observations need to be returned. Observation value and date will only be returned for a series type element.

observation_date

The observation date to be included with the returned release table.


Back to Top