thunderstorm

A new EIP Policy expires user ceredentials within 20 hours, preventing Googler driven workflows. A decision has been made to shut down the StarThinker UI, please seek alternatives. The UI will remain on GitHub for partners.



All

analytics Federal Reserve Regional Data

Download federal reserve region.



lock_openGet Access listGit Hub sourcePython menu_bookColab airAirflow thumb_upTest



Instructions

Specify the values for a Fred observations API call.
A table will appear in the dataset.

Details

Open Source YES
Age Aug. 4, 2020 (1 year, 6 months)
Authors kenjora@google.com
Shedule Days Configured by user.
Shedule Hours Configured by user.
[
    {
        "fred": {
            "auth": {
                "field": {
                    "name": "auth",
                    "kind": "authentication",
                    "order": 0,
                    "default": "service",
                    "description": "Credentials used for writing data."
                }
            },
            "api_key": {
                "field": {
                    "name": "fred_api_key",
                    "kind": "string",
                    "order": 1,
                    "default": "",
                    "description": "32 character alpha-numeric lowercase string."
                }
            },
            "frequency": {
                "field": {
                    "name": "fred_frequency",
                    "kind": "choice",
                    "order": 4,
                    "default": "",
                    "description": "An optional parameter that indicates a lower frequency to aggregate values to.",
                    "choices": [
                        "",
                        "d",
                        "w",
                        "bw",
                        "m",
                        "q",
                        "sa",
                        "a",
                        "wef",
                        "weth",
                        "wew",
                        "wetu",
                        "wem",
                        "wesu",
                        "wesa",
                        "bwew",
                        "bwem"
                    ]
                }
            },
            "region_type": {
                "field": {
                    "name": "fred_region_type",
                    "kind": "choice",
                    "order": 3,
                    "default": "county",
                    "description": "The region you want want to pull data for.",
                    "choices": [
                        "bea",
                        "msa",
                        "frb",
                        "necta",
                        "state",
                        "country",
                        "county",
                        "censusregion"
                    ]
                }
            },
            "regions": [
                {
                    "series_group": {
                        "field": {
                            "name": "fred_series_group",
                            "kind": "string",
                            "order": 2,
                            "default": "",
                            "description": "The ID for a group of seriess found in GeoFRED."
                        }
                    },
                    "units": {
                        "field": {
                            "name": "fred_units",
                            "kind": "choice",
                            "order": 3,
                            "default": "lin",
                            "description": "A key that indicates a data value transformation.",
                            "choices": [
                                "lin",
                                "chg",
                                "ch1",
                                "pch",
                                "pc1",
                                "pca",
                                "cch",
                                "cca",
                                "log"
                            ]
                        }
                    },
                    "season": {
                        "field": {
                            "name": "fred_season",
                            "kind": "choice",
                            "order": 4,
                            "default": "SA",
                            "description": "The seasonality of the series group.",
                            "choices": [
                                "SA",
                                "NSA",
                                "SSA"
                            ]
                        }
                    },
                    "aggregation_method": {
                        "field": {
                            "name": "fred_aggregation_method",
                            "kind": "choice",
                            "order": 5,
                            "default": "avg",
                            "description": "A key that indicates the aggregation method used for frequency aggregation.",
                            "choices": [
                                "avg",
                                "sum",
                                "eop"
                            ]
                        }
                    }
                }
            ],
            "out": {
                "bigquery": {
                    "project": {
                        "field": {
                            "name": "project",
                            "kind": "string",
                            "order": 10,
                            "default": "",
                            "description": "Existing BigQuery project."
                        }
                    },
                    "dataset": {
                        "field": {
                            "name": "dataset",
                            "kind": "string",
                            "order": 11,
                            "default": "",
                            "description": "Existing BigQuery dataset."
                        }
                    }
                }
            }
        }
    }
]


Run This Workflow In Minutes On Google Cloud

Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.

Deployment Stepslaunch Developer Guidebuild UI How Tolaptop