| packages |
[{'id': '9a22e6cb-3cdf-4849-ba53-53dd0fa95281', 'name': 'world-fao-production', 'title': 'Crop and Livestock Production', 'type': 'dataset', 'notes': 'These datasets are originally elaborated by the Food and Agriculture Organization of the United Nations (FAO), and are freely accessible on FAOSTAT portal. Here you can find Crop and Livestock data for more than 245 countries and territories, regarding 278 products from 1961 until 2021.', 'author': None, 'author_email': None, 'maintainer': '', 'maintainer_email': '', 'state': 'active', 'license_id': None, 'url': None, 'version': '', 'metadata_created': '2023-02-01T17:11:15.520297', 'metadata_modified': '2023-02-02T15:15:21.710193', 'creator_user_id': '1baab216-315d-41af-8d31-0ef728ef2f9a', 'private': False, 'license_title': None, 'num_resources': 8, 'resources': [{'id': 'd7bd9c58-62ae-4d82-b81e-edf7fad46453', 'name': 'country_group', 'description': "This dataset contains a list of FAO's area groups and its components.", 'position': 0, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2023-02-01T17:21:12.383020', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2023-02-01T17:21:12.373366', 'mimetype': None, 'mimetype_inner': None, 'package_id': '9a22e6cb-3cdf-4849-ba53-53dd0fa95281', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'world_fao_production', 'table_id': 'country_group', 'spatial_coverage': ['world'], 'temporal_coverage': ['1961(1)2021'], 'update_frequency': 'one_year', 'observation_level': [{'entity': 'country', 'columns': ['fao_area_id']}], 'last_updated': {'metadata': '2023-01-16', 'data': '2023-01-18 10:00:00', 'release': '2023-01-18 10:00:00'}, 'version': 'v1.0', 'published_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaned_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaning_description': '1- Download FAOSTAT directories datasets using R selenium; 2- Rename columns; 3- Drop columns; 4- Change data types', 'data_cleaning_code_url': 'https://github.com/basedosdados/mais/tree/master/bases/world_fao_production/code', 'partner_organization': {'name': None, 'organization_id': None}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados-dev', 'project_id_prod': 'basedosdados-dev', 'project_id_staging': 'basedosdados-dev', 'partitions': None, 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'fao_area_group_id', 'bigquery_type': 'string', 'description': "FAO's area group id", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'fao_area_group', 'bigquery_type': 'string', 'description': "FAO's area group name", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'fao_area_id', 'bigquery_type': 'string', 'description': "Identifies FAO's area types (Eg. countries, continents, economic blocks...)", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'fao_area', 'bigquery_type': 'string', 'description': "FAO's area type names", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}]}, {'id': 'ec72b88f-cac1-4f65-ad7d-f6aeef4e6d22', 'name': 'crop_livestock', 'description': "The Food and Agriculture Organization of the United Nations (FAO) was born in 1945, after the ending of the World War II. FAO's part of the United Nations (UN) system focused on leading internacional efforts to defeat hunger. This dataset integrates FAO's production data domain and gathers annual data of crop and livestock statistics, recorded for 278 products since 1961, including almost all countries of the world and other geographical areas.", 'position': 1, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2023-02-01T17:21:34.031366', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2023-02-02T14:56:12.097424', 'mimetype': None, 'mimetype_inner': None, 'package_id': '9a22e6cb-3cdf-4849-ba53-53dd0fa95281', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'world_fao_production', 'table_id': 'crop_livestock', 'spatial_coverage': ['world'], 'temporal_coverage': ['1961(1)2021'], 'update_frequency': 'one_year', 'observation_level': [{'entity': 'other', 'columns': ['element_id']}, {'entity': 'item', 'columns': ['item_id']}, {'entity': 'region', 'columns': ['fao_area_id']}, {'entity': 'year', 'columns': ['year']}], 'last_updated': {'metadata': '2023-01-16', 'data': '2023-01-18 10:00:00', 'release': '2023-01-18 10:00:00'}, 'version': 'v1.0', 'published_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaned_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaning_description': '1- Access FAOSTAT API using FAOSTAT R package; 2- Rename columns; 3- Drop columns; 4- Change data types', 'data_cleaning_code_url': 'https://github.com/basedosdados/mais/tree/master/bases/world_fao_production/code', 'partner_organization': {'name': None, 'organization_id': None}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados-dev', 'project_id_prod': 'basedosdados-dev', 'project_id_staging': 'basedosdados-dev', 'partitions': ['year'], 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'year', 'bigquery_type': 'int64', 'description': 'Year', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': 'br_bd_diretorios_data_tempo', 'table_id': 'ano', 'column_name': 'ano'}, 'measurement_unit': 'year', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': True}, {'name': 'fao_area_id', 'bigquery_type': 'string', 'description': "Identifies FAO's area types (Eg. countries, continents, economic blocks...)", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'fao_area', 'bigquery_type': 'string', 'description': "FAO's area types (Eg. countries, continents, economic blocks...)", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item_id', 'bigquery_type': 'string', 'description': 'Identifies the Itens present in a dataset (Eg. Wheat, Oat, Crops Primary)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item', 'bigquery_type': 'string', 'description': 'Items present in a dataset (Eg. Wheat, Oat, Crops Primary)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'element_id', 'bigquery_type': 'string', 'description': 'Identifies the attributes of a Item (Eg. Area Harvested, Production)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'element', 'bigquery_type': 'string', 'description': 'Attributes of a Item (Eg. Area Harvested, Production)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'unit_id', 'bigquery_type': 'string', 'description': 'Measurement unit of a specific id_item (Eg. Oat) and its id_element (Area Harvested)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'yes', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'value', 'bigquery_type': 'float64', 'description': 'Value', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'flag_id', 'bigquery_type': 'string', 'description': 'Identifies the source of the data', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'yes', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}]}, {'id': '34f167e1-f434-472e-9821-9a11d1630e0d', 'name': 'dictionary', 'description': 'dictionary', 'position': 2, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2023-02-01T17:21:56.199036', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2023-02-02T15:15:21.716457', 'mimetype': None, 'mimetype_inner': None, 'package_id': '9a22e6cb-3cdf-4849-ba53-53dd0fa95281', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'world_fao_production', 'table_id': 'dictionary', 'spatial_coverage': None, 'temporal_coverage': ['1961(1)2021'], 'update_frequency': None, 'observation_level': None, 'last_updated': {'metadata': '2023-01-17', 'data': '2023-01-18 10:00:00', 'release': '2023-01-18 10:00:00'}, 'version': 'v1.0', 'published_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaned_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaning_description': '1- Rename columns; 2- Drop columns; 3- Change data types', 'data_cleaning_code_url': 'https://github.com/basedosdados/mais/tree/master/bases/world_fao_production/code', 'partner_organization': {'name': None, 'organization_id': None}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados-dev', 'project_id_prod': 'basedosdados-dev', 'project_id_staging': 'basedosdados-dev', 'partitions': None, 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'table_id', 'bigquery_type': 'string', 'description': 'Indicates the dataset of the column_name, key and value', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'column_name', 'bigquery_type': 'string', 'description': 'Indicates the column name of the key and value', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'key', 'bigquery_type': 'string', 'description': 'A column id related to the given table_id and column_name', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'temporal_coverage', 'bigquery_type': 'string', 'description': 'Temporal coverage', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'value', 'bigquery_type': 'string', 'description': 'An id description related to the given key, column_name and table_id', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}]}, {'id': 'e8986e8d-aa2f-4a64-8322-5adef3a66950', 'name': 'element', 'description': "This dataset contains the elements description, code and measurement unit of the 3 main datasets (crop_livestock;production_indices;value_agricultural_production) of FAO's data production domain. In FAOSTAT's production domain the data is presented in the long format, therefore the elements are simply the attributes of the crop and livestock products. Eg. area_harvested and yield for the crop_livestock_production dataset.", 'position': 3, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2023-02-01T17:22:17.714998', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2023-02-02T14:59:07.460037', 'mimetype': None, 'mimetype_inner': None, 'package_id': '9a22e6cb-3cdf-4849-ba53-53dd0fa95281', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'world_fao_production', 'table_id': 'element', 'spatial_coverage': ['world'], 'temporal_coverage': ['1961(1)2021'], 'update_frequency': 'one_year', 'observation_level': [{'entity': 'other', 'columns': ['element_id']}], 'last_updated': {'metadata': '2023-01-17', 'data': '2023-01-18 10:00:00', 'release': '2023-01-18 10:00:00'}, 'version': 'v1.0', 'published_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaned_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaning_description': '1- Download FAOSTAT directories datasets using R selenium; 2- Rename columns; 3- Drop columns; 4- Change data types', 'data_cleaning_code_url': 'https://github.com/basedosdados/mais/tree/master/bases/world_fao_production/code', 'partner_organization': {'name': None, 'organization_id': None}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados-dev', 'project_id_prod': 'basedosdados-dev', 'project_id_staging': 'basedosdados-dev', 'partitions': None, 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'element_id', 'bigquery_type': 'string', 'description': 'Identifies the attributes of a Item (Eg. Area Harvested, Production)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'element', 'bigquery_type': 'string', 'description': 'Element name', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'element_description', 'bigquery_type': 'string', 'description': 'Element description', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': None, 'observations': None, 'is_in_staging': None, 'is_partition': None}, {'name': 'unit_id', 'bigquery_type': 'string', 'description': 'Measurement unit of the element', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'yes', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}]}, {'id': '032dea2f-ffa6-4d56-a15f-a0d893fbffb8', 'name': 'item', 'description': "This dataset contains descriptions of 278 items investigated in FAO's production data domain. Besides that, there's also HS and CPC codes equivalents to FAO's products.", 'position': 4, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2023-02-01T17:22:39.872867', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2023-02-01T17:22:39.857812', 'mimetype': None, 'mimetype_inner': None, 'package_id': '9a22e6cb-3cdf-4849-ba53-53dd0fa95281', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'world_fao_production', 'table_id': 'item', 'spatial_coverage': ['world'], 'temporal_coverage': ['1961(1)2021'], 'update_frequency': 'one_year', 'observation_level': [{'entity': 'item', 'columns': ['item_id']}], 'last_updated': {'metadata': '2023-01-17', 'data': '2023-01-18 10:00:00', 'release': '2023-01-18 10:00:00'}, 'version': 'v1.0', 'published_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaned_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaning_description': '1- Download FAOSTAT directories datasets using R selenium; 2- Rename columns; 3- Drop columns; 4- Change data types', 'data_cleaning_code_url': 'https://github.com/basedosdados/mais/tree/master/bases/world_fao_production/code', 'partner_organization': {'name': None, 'organization_id': None}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados-dev', 'project_id_prod': 'basedosdados-dev', 'project_id_staging': 'basedosdados-dev', 'partitions': None, 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'item_id', 'bigquery_type': 'string', 'description': 'Item id', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item', 'bigquery_type': 'string', 'description': 'Item name', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item_description', 'bigquery_type': 'string', 'description': 'Item description', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'hs07_id', 'bigquery_type': 'string', 'description': 'Harmonized System (HS07) Code', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'hs12_id', 'bigquery_type': 'string', 'description': 'Harmonized System (HS12) Code', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'cpc_id', 'bigquery_type': 'string', 'description': 'Customs Procedure Code', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}]}, {'id': '087d0b25-2a4e-420d-b64d-82e4651a00ba', 'name': 'item_group', 'description': "This dataset contains the groups of 278 items investigated in FAO's production data domain.", 'position': 5, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2023-02-01T17:23:01.068111', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2023-02-01T17:23:01.049949', 'mimetype': None, 'mimetype_inner': None, 'package_id': '9a22e6cb-3cdf-4849-ba53-53dd0fa95281', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'world_fao_production', 'table_id': 'item_group', 'spatial_coverage': ['world'], 'temporal_coverage': ['1961(1)2021'], 'update_frequency': 'one_year', 'observation_level': [{'entity': 'other', 'columns': ['item_group_id']}], 'last_updated': {'metadata': '2023-01-17', 'data': '2023-01-18 10:00:00', 'release': '2023-01-18 10:00:00'}, 'version': 'v1.0', 'published_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaned_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaning_description': '1- Download FAOSTAT directories datasets using R selenium; 2- Rename columns; 3- Drop columns; 4- Change data types', 'data_cleaning_code_url': 'https://github.com/basedosdados/mais/tree/master/bases/world_fao_production/code', 'partner_organization': {'name': None, 'organization_id': None}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados-dev', 'project_id_prod': 'basedosdados-dev', 'project_id_staging': 'basedosdados-dev', 'partitions': None, 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'item_group_id', 'bigquery_type': 'string', 'description': 'Item group id', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item_group', 'bigquery_type': 'string', 'description': 'Item group name', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item_id', 'bigquery_type': 'string', 'description': 'Item id', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item', 'bigquery_type': 'string', 'description': 'Item name', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}]}, {'id': 'dc215ce4-4ea7-4e92-a296-44b20a314a79', 'name': 'production_indices', 'description': "The Food and Agriculture Organization of the United Nations (FAO) was born in 1945, after the ending of the World War II. FAO's part of the United Nations (UN) system focused on leading internacional efforts to defeat hunger. This dataset (Production Indices) integrates FAO's production data domain. It gathers annual data of crop statistics indices recorded for 173 products since 1961, including almost all countries of the world and geographical aggregates (Economic Blocks, Continents) according to the United Nations M-49 list.", 'position': 6, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2023-02-01T17:23:27.024151', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2023-02-02T14:58:18.343346', 'mimetype': None, 'mimetype_inner': None, 'package_id': '9a22e6cb-3cdf-4849-ba53-53dd0fa95281', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'world_fao_production', 'table_id': 'production_indices', 'spatial_coverage': ['world'], 'temporal_coverage': ['1961(1)2020'], 'update_frequency': 'one_year', 'observation_level': [{'entity': 'other', 'columns': ['element_id']}, {'entity': 'item', 'columns': ['item_id']}, {'entity': 'region', 'columns': ['fao_area_id']}, {'entity': 'year', 'columns': ['year']}], 'last_updated': {'metadata': '2023-01-16', 'data': '2023-01-18 10:00:00', 'release': '2023-01-18 10:00:00'}, 'version': 'v1.0', 'published_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaned_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaning_description': '1- Access FAOSTAT API using FAOSTAT R package; 2- Rename columns; 3- Drop columns; 4- Change data types', 'data_cleaning_code_url': 'https://github.com/basedosdados/mais/tree/master/bases/world_fao_production/code', 'partner_organization': {'name': None, 'organization_id': None}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados-dev', 'project_id_prod': 'basedosdados-dev', 'project_id_staging': 'basedosdados-dev', 'partitions': ['ano'], 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'year', 'bigquery_type': 'int64', 'description': 'year', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': 'br_bd_diretorios_data_tempo', 'table_id': 'ano', 'column_name': 'ano'}, 'measurement_unit': 'year', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': True}, {'name': 'fao_area_id', 'bigquery_type': 'string', 'description': "Identifies FAO's area types (Eg. countries, continents, economic blocks...)", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'fao_area', 'bigquery_type': 'string', 'description': "FAO's area types (Eg. countries, continents, economic blocks...)", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item_id', 'bigquery_type': 'string', 'description': 'Identifies the Itens present in a dataset (Eg. Wheat, Oat, Crops Primary)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item', 'bigquery_type': 'string', 'description': 'Items present in a dataset (Eg. Wheat, Oat, Crops Primary)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'element_id', 'bigquery_type': 'string', 'description': 'Identifies the attributes of a Item (Eg. Area Harvested, Production)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'element', 'bigquery_type': 'string', 'description': 'Attributes of a Item (Eg. Area Harvested, Production)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'unit_id', 'bigquery_type': 'string', 'description': 'Measurement unit of a specific id_item (Eg. Oat) and its id_element (Area Harvested)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'yes', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'value', 'bigquery_type': 'float64', 'description': 'value', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'flag_id', 'bigquery_type': 'string', 'description': 'Identifies the source of the data', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'yes', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}]}, {'id': '361c7d4b-0092-40a4-a108-ea9489ed93fa', 'name': 'value_agricultural_production', 'description': "The Food and Agriculture Organization of the United Nations (FAO) was born in 1945, after the ending of the World War II. FAO's part of the United Nations (UN) system focused on leading internacional efforts to defeat hunger. integrates FAO's production data domain and gathers annual data of crop statistics indices, recorded for 173 products since 1961, including almost all countries of the world and geographical aggregates (Economic Blocks, Continents) according to the United Nations M-49 list.", 'position': 7, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2023-02-01T17:23:52.277831', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2023-02-02T14:57:40.305645', 'mimetype': None, 'mimetype_inner': None, 'package_id': '9a22e6cb-3cdf-4849-ba53-53dd0fa95281', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'world_fao_production', 'table_id': 'value_agricultural_production', 'spatial_coverage': ['world'], 'temporal_coverage': ['1961(1)2020'], 'update_frequency': 'one_year', 'observation_level': [{'entity': 'other', 'columns': ['element_id']}, {'entity': 'item', 'columns': ['item_id']}, {'entity': 'region', 'columns': ['fao_area_id']}, {'entity': 'year', 'columns': ['year']}], 'last_updated': {'metadata': '2023-01-16', 'data': '2023-01-18 10:00:00', 'release': '2023-01-18 10:00:00'}, 'version': 'v1.0', 'published_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaned_by': {'name': 'Gabriel Pisa Folhes', 'email': 'gabriel.pisa@basedosdados.org', 'github_user': 'folhesgabriel', 'ckan_user': 'pisa_gab', 'website': None}, 'data_cleaning_description': '1- Access FAOSTAT API using FAOSTAT R package; 2- Rename columns; 3- Drop columns; 4- Change data types', 'data_cleaning_code_url': 'https://github.com/basedosdados/mais/tree/master/bases/world_fao_production/code', 'partner_organization': {'name': None, 'organization_id': None}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados-dev', 'project_id_prod': 'basedosdados-dev', 'project_id_staging': 'basedosdados-dev', 'partitions': ['year'], 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'year', 'bigquery_type': 'int64', 'description': 'year', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': 'br_bd_diretorios_data_tempo', 'table_id': 'ano', 'column_name': 'ano'}, 'measurement_unit': 'year', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': True}, {'name': 'fao_area_id', 'bigquery_type': 'string', 'description': "Identifies FAO's area types (Eg. countries, continents, economic blocks...)", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'fao_area', 'bigquery_type': 'string', 'description': "FAO's area types (Eg. countries, continents, economic blocks...)", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item_id', 'bigquery_type': 'string', 'description': 'Identifies the Itens present in a dataset (Eg. Wheat, Oat, Crops Primary)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'item', 'bigquery_type': 'string', 'description': 'Itens present in a dataset (Eg. Wheat, Oat, Crops Primary)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'element_id', 'bigquery_type': 'string', 'description': 'Identifies the attributes of a Item (Eg. Area Harvested, Production)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'element', 'bigquery_type': 'string', 'description': 'Attributes of a Item (Eg. Area Harvested, Production)', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'unit_id', 'bigquery_type': 'string', 'description': "Measurement unit of a specific id_item (Eg. Oat) and its id_element (Area Harvested)'", 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'yes', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'value', 'bigquery_type': 'float64', 'description': 'value', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'flag_id', 'bigquery_type': 'string', 'description': 'Identifies the source of the data', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'yes', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}]}], 'groups': [{'id': '995d9eba-e1d7-49a0-bb67-e59d580c08e3', 'name': 'agropecuaria', 'title': 'Agropecuária', 'type': 'group', 'description': '', 'image_url': '2019-09-19-055635.125506ico-destinonegocio-pecuaria-istock-getty-images-1030x773.jpg', 'created': '2019-09-17T04:41:57.406944', 'is_organization': False, 'approval_status': 'approved', 'state': 'active', 'capacity': 'public', 'display_name': 'Agropecuária', 'image_display_url': 'https://basedosdados.org/uploads/group/2019-09-19-055635.125506ico-destinonegocio-pecuaria-istock-getty-images-1030x773.jpg'}, {'id': '52e4efe1-c527-4446-88dc-33ec9af7abb8', 'name': 'economia', 'title': 'Economia', 'type': 'group', 'description': '', 'image_url': '2019-09-19-055720.95356961SjkfwyNTL.png', 'created': '2019-09-17T04:33:42.307242', 'is_organization': False, 'approval_status': 'approved', 'state': 'active', 'capacity': 'public', 'display_name': 'Economia', 'image_display_url': 'https://basedosdados.org/uploads/group/2019-09-19-055720.95356961SjkfwyNTL.png'}], 'owner_org': 'f7ee2858-068e-4e3e-a915-faa18ad9a207', 'organization': {'id': 'f7ee2858-068e-4e3e-a915-faa18ad9a207', 'name': 'world-fao', 'title': 'Food and Agriculture Organization (FAO)', 'type': 'organization', 'description': 'www.fao.org', 'image_url': '2020-07-23-000134.966486FAOlogo.svg-860x873.png', 'created': '2020-07-23T00:01:36.521930', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'num_tags': 4, 'tags': [{'id': '8e7b91ea-0f40-49c1-87f6-cb84b24bd83e', 'name': 'agropecuaria', 'vocabulary_id': None, 'state': 'active', 'display_name': 'agropecuaria'}, {'id': 'fc9f439e-4e9c-4b9b-8b6e-2a968d48a668', 'name': 'alimentacao', 'vocabulary_id': None, 'state': 'active', 'display_name': 'alimentacao'}, {'id': 'd00521cd-976f-4a58-89c5-e606a1be2a78', 'name': 'producao', 'vocabulary_id': None, 'state': 'active', 'display_name': 'producao'}, {'id': '50136e50-daa7-463e-b1f4-7cd07c994ef0', 'name': 'produtividade agricola', 'vocabulary_id': None, 'state': 'active', 'display_name': 'produtividade agricola'}], 'relationships_as_object': [], 'relationships_as_subject': [], 'isopen': False, 'extras': [{'key': 'dataset_args', 'value': {'short_description': None, 'description': None, 'ckan_url': None, 'github_url': None}}]}, {'id': '08f82907-825e-4587-8aa0-fedcc0d2d346', 'name': 'br-ibge-censo-agropecuario', 'title': 'Censo Agropecuário', 'type': 'dataset', 'notes': 'O Censo Agropecuário, realizado pelo Instituto Brasileiro de Geografia e Estatística (IBGE), é a principal e mais completa investigação estatística e territorial sobre a produção agropecuária do país. Visa obter informações sobre a estrutura, a dinâmica e o nível de produção da atividade agropecuária brasileira.\r\n\r\nAs informações geradas possibilitam a avaliação de políticas públicas como, por exemplo, a de redistribuição de terras. Elas permitem, ainda, estudos a respeito da expansão das fronteiras agrícolas, da dinamização produtiva ditada pelas inovações tecnológicas, e enriquecem a produção de indicadores ambientais. Propiciam também análises sobre transformações decorrentes do processo de reestruturação e de ajustes na economia e de seus reflexos sobre o setor.\r\n\r\nEnquanto as pesquisas mensais e trimestrais sobre agricultura e pecuária disponibilizam dados referentes ao Brasil, Grandes Regiões e Unidades da Federação, os resultados do Censo Agro são referidos a municípios e a localidades, permitindo agregações e análises de diferentes recortes territoriais, como unidades de conservação ambiental, terras indígenas, bacias hidrográficas, Biomas, assentamentos fundiários, áreas remanescentes de quilombos, etc.', 'author': '', 'author_email': '', 'maintainer': '', 'maintainer_email': '', 'state': 'active', 'license_id': 'cc-by', 'url': '', 'version': '', 'metadata_created': '2019-09-17T05:32:59.022082', 'metadata_modified': '2023-01-13T09:48:51.953674', 'creator_user_id': '27eaffe3-f79b-469f-8f02-4716146bdfcc', 'private': False, 'license_title': 'Creative Commons Attribution', 'num_resources': 2, 'resources': [{'id': '1321d163-1f7c-4031-9456-d6f8f99bdf65', 'name': 'Dados', 'description': '', 'position': 0, 'url': 'https://censoagro2017.ibge.gov.br/', 'cache_last_updated': None, 'cache_url': None, 'created': '2019-09-17T05:33:26.628799', 'datastore_active': False, 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2022-12-20T18:45:38.608168', 'mimetype': None, 'mimetype_inner': None, 'package_id': '08f82907-825e-4587-8aa0-fedcc0d2d346', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'external_link', 'language': ['portuguese'], 'has_structured_data': 'yes', 'has_api': None, 'is_free': 'yes', 'requires_registration': 'no', 'availability': None, 'country_ip_address_required': [], 'license': 'mit', 'spatial_coverage': ['sa.br'], 'temporal_coverage': ['2005(12)2017'], 'update_frequency': 'ten_years', 'observation_level': [{'country': 'br', 'entity': 'municipality'}], 'maintainer_email': '', 'maintainer': ''}, {'id': 'af2d0db3-c3c4-476c-ab22-fa0e9361393b', 'name': 'municipio', 'description': 'Contém variáveis do Censo Agropecuário do Brasil nos anos de 1985, 1996, 2006 e 2017.', 'position': 1, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2022-05-05T11:43:02.665268', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2023-01-08T04:15:11.223955', 'mimetype': None, 'mimetype_inner': None, 'package_id': '08f82907-825e-4587-8aa0-fedcc0d2d346', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'br_ibge_censo_agropecuario', 'table_id': 'municipio', 'spatial_coverage': ['sa.br'], 'temporal_coverage': ['1985', '1995', '2006', '2017'], 'update_frequency': 'ten_years', 'observation_level': [{'country': 'br', 'entity': 'municipality', 'columns': ['id_municipio'], 'column': ['id_municipio']}, {'entity': 'year', 'columns': ['ano']}], 'last_updated': {'metadata': '2022-05-16', 'data': '2022-05-16 17:00:37', 'release': None}, 'version': 'v1.0', 'published_by': {'name': 'Gustavo Alcantara', 'email': 'gustavo.alcantara@basedosdados.org.br', 'github_user': 'gustavoalcantara', 'ckan_user': 'gustavoalcantara', 'website': None}, 'data_cleaned_by': {'name': 'Arthur Bragança', 'email': 'arthurbraganca@gmail.com', 'github_user': 'arthurbraganca7', 'ckan_user': '', 'website': 'https://arthurbraganca.com/'}, 'data_cleaning_description': 'Padronização das variáveis nas diretrizes da Base dos Dados.', 'data_cleaning_code_url': 'https://github.com/basedosdados/mais/tree/master/bases/br_ibge_censo_agropecuario/code', 'partner_organization': {'name': None, 'organization_id': None}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados', 'project_id_prod': 'basedosdados', 'project_id_staging': 'basedosdados-staging', 'partitions': None, 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'ano', 'bigquery_type': 'int64', 'description': 'Ano', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': 'br_bd_diretorios_data_tempo', 'table_id': 'ano', 'column_name': 'ano'}, 'measurement_unit': 'year', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'sigla_uf', 'bigquery_type': 'string', 'description': 'Sigla da UF', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': 'br_bd_diretorios_brasil', 'table_id': 'uf', 'column_name': 'sigla_uf'}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'id_municipio', 'bigquery_type': 'string', 'description': 'ID Município - IBGE 7 Dígitos', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': 'br_bd_diretorios_brasil', 'table_id': 'municipio', 'column_name': 'id_municipio'}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_total', 'bigquery_type': 'float64', 'description': 'Área Total', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_proprietario', 'bigquery_type': 'float64', 'description': 'Área Total dos Estabelecimentos na Condição de Proprietário', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_arrendatario', 'bigquery_type': 'float64', 'description': 'Área Total dos Estabelecimentos na Condição de Arrendatário', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_parceiro', 'bigquery_type': 'float64', 'description': 'Área Total dos Estabelecimentos na Condição de Parceiro', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_ocupante', 'bigquery_type': 'float64', 'description': 'Área Total dos Estabelecimentos na Condição de Ocupante', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_lavoura_permanente', 'bigquery_type': 'float64', 'description': 'Área total de lavoura permanente', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_lavoura_temporaria', 'bigquery_type': 'float64', 'description': 'Área Total de Lavoura Temporária', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_pastagem_natural', 'bigquery_type': 'float64', 'description': 'Área Total de Pastagem Natural', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_pastagem_plantada', 'bigquery_type': 'float64', 'description': 'Área Total de Pastagem Plantada', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_pastagem', 'bigquery_type': 'float64', 'description': 'Área Total de Pastagem', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_mata_natural', 'bigquery_type': 'float64', 'description': 'Área Total de Mata Natural', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_mata_plantada', 'bigquery_type': 'float64', 'description': 'Área Total de Mata Plantada', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_sistema_agroflorestal', 'bigquery_type': 'float64', 'description': 'Área Total de Sistemas Agroflorestais', 'temporal_coverage': ['2017'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_mata', 'bigquery_type': 'float64', 'description': 'Área Total de Mata', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_nao_utilizada', 'bigquery_type': 'float64', 'description': 'Área Total não Utilizada', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_estabelecimentos', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_cafe', 'bigquery_type': 'float64', 'description': 'Produção de Café em Toneladas', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ton', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_cafe', 'bigquery_type': 'float64', 'description': 'Área destinada ao plantio de Café', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_estabelecimentos_cafe', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos destinados à produção de Café', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_cafe', 'bigquery_type': 'float64', 'description': 'Valor Total da produção de Café', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_bovinos_total', 'bigquery_type': 'int64', 'description': 'Efetivos Total de Animais Bovinos em Estabelecimentos Agropecuários', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_bezerros', 'bigquery_type': 'int64', 'description': 'Efetivos Total de Animais Bovinos Bezerros em Estabelecimentos Agropecuários', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_bovinos_garrote', 'bigquery_type': 'int64', 'description': 'Efetivos Total de Animais Bovinos Novilho Garrote em Estabelecimentos Agropecuários', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_bovinos_vaca', 'bigquery_type': 'int64', 'description': 'Efetivos Total de Animais Bovinos Vaca em Estabelecimentos Agropecuários', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_bovinos_trabalho', 'bigquery_type': 'int64', 'description': 'Efetivo Total de Animais Bovinos de Trabalho', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': None, 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_bovinos_touro', 'bigquery_type': 'int64', 'description': 'Efetivos Total de Animais Bovinos Touro', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_estabelecimentos_energia_eletrica', 'bigquery_type': 'int64', 'description': 'Número Total de Estabelecimentos que possuem energia Elétrica', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'despesa_total', 'bigquery_type': 'float64', 'description': 'Despesa Total', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'despesa_adubos', 'bigquery_type': 'float64', 'description': 'Despesa Total com Adubos', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'despesa_sementes', 'bigquery_type': 'float64', 'description': 'Despesa Total com Sementes', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'despesa_arrendamentos', 'bigquery_type': 'float64', 'description': 'Despesa Total com Arrendamento', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'despesa_salarios', 'bigquery_type': 'float64', 'description': 'Despesa Total com Salários', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'despesa_defensivos', 'bigquery_type': 'float64', 'description': 'Despesa Total com Defensivos', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'despesa_cotas', 'bigquery_type': 'float64', 'description': 'Despesa Total com Cotas', 'temporal_coverage': ['1985, 1996, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'areas_irrigacao', 'bigquery_type': 'float64', 'description': 'Áreas destinadas à irrigação', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_leite', 'bigquery_type': 'float64', 'description': 'Produção de Leite (em mil litros)', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'meter^3', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_total', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuários', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_proprietario', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuários na condição de Proprietário', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_arrendatario', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos na Condição de Arrendatário', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_parceiros', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuários na condição de Parceiro', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_ocupantes', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuários na condição de Ocupante', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_outros', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuários na condição Outros', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_nenhuma', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuários na condição Nenhuma', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_cooperativas', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuarios na Orientação de Cooperativa', 'temporal_coverage': ['1985,2006'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_cooperativas_credito', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuários na Orientação de Cooperativa de Crédito', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_cooperativa_energia_eletrica', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuários na Orientação de Cooperativa que possuem energia elétrica', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_cooperativa_energia_outras', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos Agropecuários na Orientação de Cooperativa Outras', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_tratores', 'bigquery_type': 'int64', 'description': 'Número absoluto de Tratores', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_maquina_colheita', 'bigquery_type': 'int64', 'description': 'Número absoluto de Máquina de Colheita', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_maquinas_plantio', 'bigquery_type': 'int64', 'description': 'Número absoluto de máquinas de plantio', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_tratores_estabelecimentos_menor_10', 'bigquery_type': 'int64', 'description': 'Número absoluto de tratores em estabelecimentos menores que 10 hectares', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_tratores_estabelecimentos_maior_10', 'bigquery_type': 'int64', 'description': 'Número absoluto de tratores em estabelecimentos maiores que 10 ha', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'pessoal_ocupado_total', 'bigquery_type': 'int64', 'description': 'Pessoal ocupado em Estabelecimentos Agropecuários', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'person', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'pessoal_ocupado_parentesco_produtor', 'bigquery_type': 'int64', 'description': 'Pessoal ocupado em Estabelecimentos Agropecuários com laço de parentesco com o Produtor', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'pessoal_14_mais_sem_parentesco', 'bigquery_type': 'int64', 'description': 'Pessoal ocupado em Estabelecimentos Agropecuários sem laço de parentesco com o Produtor', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'person', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'pessoal_14_mais_com_parentesco_produtor', 'bigquery_type': 'int64', 'description': 'Pessoal com 14 anos ou mais ocupado em Estabelecimentos Agropecuários com laço de parentesco com o Produtor', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'person', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'pessoal_14_mais_empregadas', 'bigquery_type': 'int64', 'description': 'Pessoal com 14 anos ou mais empregado em Estabelecimentos Agropecuários', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'person', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'pessoal_14_mais_ocupado', 'bigquery_type': 'int64', 'description': 'Pessoal com 14 anos ou mais ocupado em Estabelecimentos Agropecuários', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'person', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_producao_total', 'bigquery_type': 'float64', 'description': 'Valor Total da Produção Total', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_producao_total_animal', 'bigquery_type': 'float64', 'description': 'Valor total da Produção animal', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_animal_grande', 'bigquery_type': 'float64', 'description': 'Valor total da produção de animal grande', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_animal_medio', 'bigquery_type': 'float64', 'description': 'Valor total da produção de animal médio', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_aves', 'bigquery_type': 'float64', 'description': 'Valor Total da Produção de Aves', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_vegetal', 'bigquery_type': 'float64', 'description': 'Valor Total da Produção Vegetal', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_hortifruti', 'bigquery_type': 'float64', 'description': 'Valor Total da Produção de Hortifruti e Floricultura', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_silvicultura', 'bigquery_type': 'float64', 'description': 'Valor Total da Produção na Silvicultura', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_vegicultura', 'bigquery_type': 'float64', 'description': 'Valor Total da Produção na Extração Vegetal', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_lavoura_temporaria', 'bigquery_type': 'float64', 'description': 'Valor Total da Produção na Lavoura Temporária', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_producao_lavoura_permanente', 'bigquery_type': 'float64', 'description': 'Valor Total da Produção na Lavoura Permanente', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_total_arroz', 'bigquery_type': 'float64', 'description': 'Produção de Arroz em Toneladas', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ton', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_total_feijao', 'bigquery_type': 'float64', 'description': 'Produção de Feijão em Toneladas', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_total_milho', 'bigquery_type': 'float64', 'description': 'Produção de Milho em Toneladas', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_total_mandioca', 'bigquery_type': 'float64', 'description': 'Produção de Mandioca em Toneladas', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_total_soja', 'bigquery_type': 'float64', 'description': 'Produção de Soja em Toneladas', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_total_algodao', 'bigquery_type': 'float64', 'description': 'Produção de Algodão em Toneladas', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_total_cana', 'bigquery_type': 'float64', 'description': 'Produção de Cana de Açúcar em Toneladas', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'producao_total_trigo', 'bigquery_type': 'float64', 'description': 'Produção de Trigo em Toneladas', 'temporal_coverage': ['1996, 2006, 2017'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_arroz', 'bigquery_type': 'float64', 'description': 'Área destinada a Plantio de Arroz', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_feijao', 'bigquery_type': 'float64', 'description': 'Área destinada a Plantio de Feijão', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_milho', 'bigquery_type': 'float64', 'description': 'Área destinada a Plantio de Milho', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_mandioca', 'bigquery_type': 'float64', 'description': 'Área destinada a Plantio de Mandioca', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_soja', 'bigquery_type': 'float64', 'description': 'Área destinada a Plantio de Soja', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_algodao', 'bigquery_type': 'float64', 'description': 'Área destinada a Plantio de Algodão', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_cana', 'bigquery_type': 'float64', 'description': 'Área destinada a Plantio de Cana', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'area_trigo', 'bigquery_type': 'float64', 'description': 'Área destinada a Plantio de Trigo', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'ha', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_arroz', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos destinados à produção de Arroz', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_feijao', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos destinados à produção de Feijão', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_milho', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos destinados à produção de Milho', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_mandioca', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos destinados à produção de Mandioca', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_soja', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos destinados à produção de Soja', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_algodao', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos destinados à produção de Algodão', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_cana', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos destinados à produção de Cana', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'numero_estabelecimentos_trigo', 'bigquery_type': 'int64', 'description': 'Número de Estabelecimentos destinados à produção de Trigo', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_arroz', 'bigquery_type': 'float64', 'description': 'Valor da produção de arroz', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_feijao', 'bigquery_type': 'float64', 'description': 'Valor da produção de Feijão', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_milho', 'bigquery_type': 'float64', 'description': 'Valor da produção de Milho', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_mandioca', 'bigquery_type': 'float64', 'description': 'Valor da produção de Mandioca', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_soja', 'bigquery_type': 'float64', 'description': 'Valor da produção de Soja', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_algodao', 'bigquery_type': 'float64', 'description': 'Valor da produção de Algodão', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_cana', 'bigquery_type': 'float64', 'description': 'Valor da produção de Cana', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_trigo', 'bigquery_type': 'float64', 'description': 'Valor da produção de Trigo', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total', 'bigquery_type': 'float64', 'description': 'Valor da Produção Total', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_terras', 'bigquery_type': 'float64', 'description': 'Valor da Produção das Terras', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_cultura_permanente', 'bigquery_type': 'float64', 'description': 'Valor do Total de Produção em Culturas Permanentes', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_matas_plantadas', 'bigquery_type': 'float64', 'description': 'Valor do Total de Produção em Matas Plantadas', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_predios_benfeitorias', 'bigquery_type': 'float64', 'description': 'Valor de Prédio e Benfeitorias', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_animais', 'bigquery_type': 'float64', 'description': 'Valor Total dos Animais', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_animais_transporte', 'bigquery_type': 'float64', 'description': 'Valor Total dos Animais de Transporte', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'valor_total_maquinas_transporte', 'bigquery_type': 'float64', 'description': 'Valor Total das Maquinas de Transporte', 'temporal_coverage': ['1985, 2006'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'brl', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'proporcao_despesa_fertilizante', 'bigquery_type': 'float64', 'description': 'Porcentagem da despesa com fertilizantes', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'percent', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'proporcao_despesa_defensivos', 'bigquery_type': 'float64', 'description': 'Porcentagem da despesa com defensivos agrícolas', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'percent', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'proporcao_despesa_sementes', 'bigquery_type': 'float64', 'description': 'Porcentagem da despesa com sementes', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'percent', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'proporcao_despesa_salarios', 'bigquery_type': 'float64', 'description': 'Porcentagem da despesa com salários', 'temporal_coverage': ['(10)'], 'covered_by_dictionary': None, 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': 'percent', 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}], 'number_rows': 20738}], 'groups': [{'id': '995d9eba-e1d7-49a0-bb67-e59d580c08e3', 'name': 'agropecuaria', 'title': 'Agropecuária', 'type': 'group', 'description': '', 'image_url': '2019-09-19-055635.125506ico-destinonegocio-pecuaria-istock-getty-images-1030x773.jpg', 'created': '2019-09-17T04:41:57.406944', 'is_organization': False, 'approval_status': 'approved', 'state': 'active', 'capacity': 'public', 'display_name': 'Agropecuária', 'image_display_url': 'https://basedosdados.org/uploads/group/2019-09-19-055635.125506ico-destinonegocio-pecuaria-istock-getty-images-1030x773.jpg'}], 'owner_org': 'b82f9164-33eb-4e10-9c26-8c99e4591db3', 'organization': {'id': 'b82f9164-33eb-4e10-9c26-8c99e4591db3', 'name': 'br-ibge', 'title': 'Instituto Brasileiro de Geografia e Estatística (IBGE)', 'type': 'organization', 'description': 'www.ibge.gov.br', 'image_url': '2019-09-19-153117.558371IBGE.png', 'created': '2019-09-14T20:59:07.312684', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'num_tags': 4, 'tags': [{'id': '1f075efd-034d-4d59-bd45-419277bb0f7b', 'name': 'fazenda', 'vocabulary_id': None, 'state': 'active', 'display_name': 'fazenda'}, {'id': '59c674f3-d651-46e1-97e6-38f90b3d2759', 'name': 'imovel', 'vocabulary_id': None, 'state': 'active', 'display_name': 'imovel'}, {'id': '1cb6dd8e-7101-4f4b-a05b-182bddc9b7be', 'name': 'propriedade', 'vocabulary_id': None, 'state': 'active', 'display_name': 'propriedade'}, {'id': '39961774-bf45-40c8-8037-38dfaf070610', 'name': 'uso da terra', 'vocabulary_id': None, 'state': 'active', 'display_name': 'uso da terra'}], 'relationships_as_object': [], 'relationships_as_subject': [], 'isopen': True, 'license_url': 'http://www.opendefinition.org/licenses/cc-by', 'extras': [{'key': 'dataset_args', 'value': {}}]}, {'id': '61c965b5-fc3c-4f23-9d31-9e4cd7473c47', 'name': 'br-seeg-emissoes', 'title': 'Emissões de gases de efeito estufa no Brasil', 'type': 'dataset', 'notes': 'O Sistema de Estimativas de Emissões e Remoções de Gases de Efeito Estufa (SEEG) é uma iniciativa do Observatório do Clima que compreende a produção de estimativas anuais das emissões de gases de efeito estufa (GEE) no Brasil, documentos analíticos sobre a evolução das emissões e um portal na internet para disponibilização de forma simples e clara dos métodos e dados do sistema.\r\n\r\nSão avaliados todos os cinco setores que são fontes de emissões – Agropecuária, Energia, Mudanças de Uso da Terra, Processos Industriais e Resíduos com o mesmo grau de detalhamento contido nos inventários de emissões.', 'author': None, 'author_email': None, 'maintainer': None, 'maintainer_email': None, 'state': 'active', 'license_id': '', 'url': 'http://seeg.eco.br/', 'version': None, 'metadata_created': '2021-09-12T23:20:54.566133', 'metadata_modified': '2022-12-30T09:50:53.686474', 'creator_user_id': '1baab216-315d-41af-8d31-0ef728ef2f9a', 'private': False, 'license_title': '', 'num_resources': 4, 'resources': [{'id': '9385e606-da87-44bb-89bd-50fba7bec93f', 'name': 'brasil', 'description': 'Dados a nível de Brasil completo.\n', 'position': 0, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2021-03-13T18:16:47.244226', 'datastore_active': False, 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2022-12-23T10:04:07.849022', 'mimetype': None, 'mimetype_inner': None, 'package_id': '61c965b5-fc3c-4f23-9d31-9e4cd7473c47', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'br_seeg_emissoes', 'table_id': 'brasil', 'spatial_coverage': ['sa.br'], 'temporal_coverage': ['2000(1)2019'], 'update_frequency': 'one_year', 'observation_level': [{'columns': ['nivel_1']}, {'columns': ['nivel_2']}, {'columns': ['nivel_3']}, {'columns': ['nivel_4']}, {'columns': ['nivel_5']}, {'columns': ['nivel_6']}, {'columns': ['tipo_emissao']}, {'columns': ['gas']}, {'entity': 'year', 'columns': ['ano']}], 'last_updated': {'metadata': None, 'data': None, 'release': None}, 'version': 'v1.0', 'published_by': {'name': 'Ricardo Dahis', 'email': 'rdahis@basedosdados.org', 'github_user': '', 'ckan_user': '', 'website': 'www.ricardodahis.com'}, 'data_cleaned_by': {'name': None, 'email': None, 'github_user': '', 'ckan_user': '', 'website': ''}, 'data_cleaning_description': '- Transformamos a base do formato "wide" para formato "long" em ano.\n- Substituímos valores "NA" para valores nulos.\n', 'data_cleaning_code_url': None, 'partner_organization': {'name': '', 'organization_id': ''}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados', 'project_id_prod': 'basedosdados', 'project_id_staging': 'basedosdados-staging', 'partitions': [], 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'ano', 'bigquery_type': 'int64', 'description': 'Ano', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_1', 'bigquery_type': 'string', 'description': 'Nível 1 - Setor', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_2', 'bigquery_type': 'string', 'description': 'Nível 2 - Processo Emissor', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_3', 'bigquery_type': 'string', 'description': 'Nível 3 - Forma de Emissão', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_4', 'bigquery_type': 'string', 'description': 'Nível 4 - Processo Específico', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_5', 'bigquery_type': 'string', 'description': 'Nível 5 - Tipo de Atividade', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_6', 'bigquery_type': 'string', 'description': 'Nível 6 - Atividade Específica', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'tipo_emissao', 'bigquery_type': 'string', 'description': 'Tipo de Emissão', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'gas', 'bigquery_type': 'string', 'description': 'Gás', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'atividade_economica', 'bigquery_type': 'string', 'description': 'Atividade Econômica', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'produto', 'bigquery_type': 'string', 'description': 'Produto', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'emissao', 'bigquery_type': 'float64', 'description': 'Emissão', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}], 'number_rows': 454850}, {'id': '8929bdc1-cf37-40ff-9615-752e87736d68', 'name': 'uf', 'description': 'Dados de emissões a nível de unidade da federação.\n', 'position': 1, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2021-03-13T18:16:53.180134', 'datastore_active': False, 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2022-12-23T10:04:19.964373', 'mimetype': None, 'mimetype_inner': None, 'package_id': '61c965b5-fc3c-4f23-9d31-9e4cd7473c47', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'br_seeg_emissoes', 'table_id': 'uf', 'spatial_coverage': ['sa.br'], 'temporal_coverage': ['2000(1)2019'], 'update_frequency': 'one_year', 'observation_level': [{'entity': 'state', 'column': ['sigla_uf']}, {'columns': ['nivel_1']}, {'columns': ['nivel_2']}, {'columns': ['nivel_3']}, {'columns': ['nivel_4']}, {'columns': ['nivel_5']}, {'columns': ['nivel_6']}, {'columns': ['tipo_emissao']}, {'columns': ['gas']}, {'entity': 'year', 'columns': ['ano']}], 'last_updated': {'metadata': None, 'data': None, 'release': None}, 'version': 'v1.0', 'published_by': {'name': 'Ricardo Dahis', 'email': 'rdahis@basedosdados.org', 'github_user': '', 'ckan_user': '', 'website': 'www.ricardodahis.com'}, 'data_cleaned_by': {'name': None, 'email': None, 'github_user': '', 'ckan_user': '', 'website': ''}, 'data_cleaning_description': '- Transformamos a base do formato "wide" para formato "long" em ano.\n- Substituímos valores "NA" para valores nulos.\n', 'data_cleaning_code_url': None, 'partner_organization': {'name': '', 'organization_id': ''}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados', 'project_id_prod': 'basedosdados', 'project_id_staging': 'basedosdados-staging', 'partitions': ['ano'], 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'sigla_uf', 'bigquery_type': 'string', 'description': 'Sigla da Unidade da Federação', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_1', 'bigquery_type': 'string', 'description': 'Nível 1 - Setor', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_2', 'bigquery_type': 'string', 'description': 'Nível 2 - Processo Emissor', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_3', 'bigquery_type': 'string', 'description': 'Nível 3 - Forma de Emissão', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_4', 'bigquery_type': 'string', 'description': 'Nível 4 - Processo Específico', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_5', 'bigquery_type': 'string', 'description': 'Nível 5 - Tipo de Atividade', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_6', 'bigquery_type': 'string', 'description': 'Nível 6 - Atividade Específica', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'tipo_emissao', 'bigquery_type': 'string', 'description': 'Tipo de Emissão', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'gas', 'bigquery_type': 'string', 'description': 'Gás', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'atividade_economica', 'bigquery_type': 'string', 'description': 'Atividade Econômica', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'produto', 'bigquery_type': 'string', 'description': 'Produto', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'emissao', 'bigquery_type': 'float64', 'description': 'Emissão', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'ano', 'bigquery_type': 'int64', 'description': 'Ano', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': True}], 'number_rows': 3276750}, {'id': '7fbb58ee-e96b-4473-a103-e525db61dd72', 'name': 'municipio', 'description': 'Dados de emissões a nível de municipio.\n', 'position': 2, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2021-03-13T18:16:59.014936', 'datastore_active': False, 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2022-12-23T10:04:38.013377', 'mimetype': None, 'mimetype_inner': None, 'package_id': '61c965b5-fc3c-4f23-9d31-9e4cd7473c47', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'br_seeg_emissoes', 'table_id': 'municipio', 'spatial_coverage': ['sa.br'], 'temporal_coverage': ['2000(1)2019'], 'update_frequency': 'one_year', 'observation_level': [{'country': 'br', 'entity': 'municipality', 'column': ['id_municipio']}, {'columns': ['nivel_1']}, {'columns': ['nivel_2']}, {'columns': ['nivel_3']}, {'columns': ['nivel_4']}, {'columns': ['nivel_5']}, {'columns': ['nivel_6']}, {'columns': ['tipo_emissao']}, {'columns': ['gas']}, {'entity': 'year', 'columns': ['ano']}], 'last_updated': {'metadata': None, 'data': None, 'release': None}, 'version': 'v1.0', 'published_by': {'name': 'Ricardo Dahis', 'email': 'rdahis@basedosdados.org', 'github_user': '', 'ckan_user': '', 'website': 'www.ricardodahis.com'}, 'data_cleaned_by': {'name': None, 'email': None, 'github_user': '', 'ckan_user': '', 'website': ''}, 'data_cleaning_description': '- Transformamos a base do formato "wide" para formato "long" em ano.\n- Substituímos valores "NA" para valores nulos.\n- Deletamos as linhas nas quais a variável "id_municipio" era nula.\n', 'data_cleaning_code_url': None, 'partner_organization': {'name': '', 'organization_id': ''}, 'raw_files_url': None, 'auxiliary_files_url': None, 'architecture_url': None, 'source_bucket_name': 'basedosdados', 'project_id_prod': 'basedosdados', 'project_id_staging': 'basedosdados-staging', 'partitions': ['ano'], 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'sigla_uf', 'bigquery_type': 'string', 'description': 'Sigla da Unidade da Federação', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'id_municipio', 'bigquery_type': 'string', 'description': 'ID Município - IBGE 7 Dígitos', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'nivel_1', 'bigquery_type': 'string', 'description': 'Nível 1 - Setor', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'no', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name' |
