| h |
{'redirect_to': <function redirect_to at 0x7ff72504b5e0>, 'url': <function url at 0x7ff72504b700>, 'get_site_protocol_and_host': <function get_site_protocol_and_host at 0x7ff72504b670>, 'url_for': <function url_for at 0x7ff72504b8b0>, 'url_for_static': <function url_for_static at 0x7ff72504ba60>, 'url_for_static_or_external': <function url_for_static_or_external at 0x7ff72504baf0>, 'is_url': <function is_url at 0x7ff72504bb80>, 'url_is_local': <function url_is_local at 0x7ff72504bca0>, 'full_current_url': <function full_current_url at 0x7ff72504bd30>, 'current_url': <function current_url at 0x7ff72504bdc0>, 'lang': <function lang at 0x7ff72504be50>, 'ckan_version': <function ckan_version at 0x7ff72504bee0>, 'lang_native_name': <function lang_native_name at 0x7ff72504bf70>, 'is_rtl_language': <function is_rtl_language at 0x7ff72504d040>, 'get_rtl_css': <function get_rtl_css at 0x7ff72504d0d0>, 'flash_notice': <function flash_notice at 0x7ff72504d160>, 'flash_error': <function flash_error at 0x7ff72504d5e0>, 'flash_success': <function flash_success at 0x7ff72504d670>, 'are_there_flash_messages': <function are_there_flash_messages at 0x7ff72504d700>, 'link_to': <function link_to at 0x7ff72504db80>, 'file': <function file at 0x7ff72504dc10>, 'submit': <function submit at 0x7ff72504dca0>, 'nav_link': <function nav_link at 0x7ff72504dd30>, 'wrapped': <function deprecated.<locals>.decorator.<locals>.wrapped at 0x7ff724fefca0>, 'build_nav_main': <function build_nav_main at 0x7ff72504dee0>, 'build_nav_icon': <function build_nav_icon at 0x7ff724fef310>, 'build_nav': <function build_nav at 0x7ff724fef3a0>, 'build_extra_admin_nav': <function build_extra_admin_nav at 0x7ff724fef4c0>, 'default_group_type': <function default_group_type at 0x7ff724fef5e0>, 'get_facet_items_dict': <function get_facet_items_dict at 0x7ff724fef670>, 'has_more_facets': <function has_more_facets at 0x7ff724fef700>, 'unselected_facet_items': <function unselected_facet_items at 0x7ff724fef790>, 'get_param_int': <function get_param_int at 0x7ff724fef820>, 'sorted_extras': <function sorted_extras at 0x7ff724fefa60>, 'check_access': <function check_access at 0x7ff724fefaf0>, 'linked_user': <function linked_user at 0x7ff724fefb80>, 'group_name_to_title': <function group_name_to_title at 0x7ff724fefd30>, 'truncate': <function truncate at 0x7ff724fefdc0>, 'markdown_extract': <function markdown_extract at 0x7ff724fefe50>, 'icon_url': <function icon_url at 0x7ff724fefee0>, 'icon_html': <function icon_html at 0x7ff724feff70>, 'icon': <function icon at 0x7ff724ff1040>, 'resource_icon': <function resource_icon at 0x7ff724ff10d0>, 'format_icon': <function format_icon at 0x7ff724ff1160>, 'dict_list_reduce': <function dict_list_reduce at 0x7ff724ff11f0>, 'gravatar': <function gravatar at 0x7ff724ff1280>, 'sanitize_url': <function sanitize_url at 0x7ff724ff1310>, 'user_image': <function user_image at 0x7ff724ff13a0>, 'pager_url': <function pager_url at 0x7ff724ff1430>, 'get_page_number': <function get_page_number at 0x7ff724ff14c0>, 'get_display_timezone': <function get_display_timezone at 0x7ff724ff1550>, 'render_datetime': <function render_datetime at 0x7ff724ff15e0>, 'date_str_to_datetime': <function date_str_to_datetime at 0x7ff724ff1670>, 'parse_rfc_2822_date': <function parse_rfc_2822_date at 0x7ff724ff1700>, 'time_ago_from_timestamp': <function time_ago_from_timestamp at 0x7ff724ff1790>, 'button_attr': <function button_attr at 0x7ff724ff1a60>, 'dataset_display_name': <function dataset_display_name at 0x7ff724ff1af0>, 'dataset_link': <function dataset_link at 0x7ff724ff1b80>, 'resource_display_name': <function resource_display_name at 0x7ff724ff1c10>, 'resource_link': <function resource_link at 0x7ff724ff1ca0>, 'tag_link': <function tag_link at 0x7ff724ff1d30>, 'group_link': <function group_link at 0x7ff724ff1dc0>, 'organization_link': <function organization_link at 0x7ff724ff1e50>, 'dump_json': <function dump_json at 0x7ff724ff1ee0>, 'auto_log_message': <function auto_log_message at 0x7ff724ff1f70>, 'activity_div': <function activity_div at 0x7ff724ff3040>, 'snippet': <function snippet at 0x7ff724ff30d0>, 'convert_to_dict': <function convert_to_dict at 0x7ff724ff3160>, 'follow_button': <function follow_button at 0x7ff724ff31f0>, 'follow_count': <function follow_count at 0x7ff724ff3280>, 'add_url_param': <function add_url_param at 0x7ff724ff33a0>, 'remove_url_param': <function remove_url_param at 0x7ff724ff3430>, 'include_resource': <function include_resource at 0x7ff724ff34c0>, 'urls_for_resource': <function urls_for_resource at 0x7ff724ff3550>, 'debug_inspect': <function debug_inspect at 0x7ff724ff35e0>, 'popular': <function popular at 0x7ff724ff3670>, 'groups_available': <function groups_available at 0x7ff724ff3700>, 'organizations_available': <function organizations_available at 0x7ff724ff3790>, 'roles_translated': <function roles_translated at 0x7ff724ff3820>, 'user_in_org_or_group': <function user_in_org_or_group at 0x7ff724ff38b0>, 'dashboard_activity_stream': <function dashboard_activity_stream at 0x7ff724ff3940>, 'recently_changed_packages_activity_stream': <function recently_changed_packages_activity_stream at 0x7ff724ff39d0>, 'escape_js': <function escape_js at 0x7ff724ff3a60>, 'get_pkg_dict_extra': <function get_pkg_dict_extra at 0x7ff724ff3af0>, 'get_request_param': <function get_request_param at 0x7ff724ff3b80>, 'html_auto_link': <function html_auto_link at 0x7ff724ff3c10>, 'render_markdown': <function render_markdown at 0x7ff724ff3ca0>, 'format_resource_items': <function format_resource_items at 0x7ff724ff3d30>, 'resource_preview': <function resource_preview at 0x7ff724ff3dc0>, 'get_allowed_view_types': <function get_allowed_view_types at 0x7ff724ff3e50>, 'rendered_resource_view': <function rendered_resource_view at 0x7ff724ff3ee0>, 'view_resource_url': <function view_resource_url at 0x7ff724ff3f70>, 'resource_view_is_filterable': <function resource_view_is_filterable at 0x7ff724ff4040>, 'resource_view_get_fields': <function resource_view_get_fields at 0x7ff724ff40d0>, 'resource_view_is_iframed': <function resource_view_is_iframed at 0x7ff724ff4160>, 'resource_view_icon': <function resource_view_icon at 0x7ff724ff41f0>, 'resource_view_display_preview': <function resource_view_display_preview at 0x7ff724ff4280>, 'resource_view_full_page': <function resource_view_full_page at 0x7ff724ff4310>, 'remove_linebreaks': <function remove_linebreaks at 0x7ff724ff43a0>, 'list_dict_filter': <function list_dict_filter at 0x7ff724ff4430>, 'SI_number_span': <function SI_number_span at 0x7ff724ff44c0>, 'new_activities': <function new_activities at 0x7ff724ff4550>, 'uploads_enabled': <function uploads_enabled at 0x7ff724ff45e0>, 'get_featured_organizations': <function get_featured_organizations at 0x7ff724ff4670>, 'get_featured_groups': <function get_featured_groups at 0x7ff724ff4700>, 'featured_group_org': <function featured_group_org at 0x7ff724ff4790>, 'get_site_statistics': <function get_site_statistics at 0x7ff724ff4820>, 'resource_formats': <function resource_formats at 0x7ff724ff48b0>, 'unified_resource_format': <function unified_resource_format at 0x7ff724ff4940>, 'check_config_permission': <function check_config_permission at 0x7ff724ff49d0>, 'get_organization': <function get_organization at 0x7ff724ff4a60>, 'license_options': <function license_options at 0x7ff724ff4af0>, 'get_translated': <function get_translated at 0x7ff724ff4b80>, 'facets': <function facets at 0x7ff724ff4c10>, 'mail_to': <function mail_to at 0x7ff724ff4ca0>, 'radio': <function radio at 0x7ff724ff4d30>, 'clean_html': <function clean_html at 0x7ff724ff4dc0>, 'flash': <ckan.lib.helpers._Flash object at 0x7ff7251e9d90>, 'localised_number': <function localised_number at 0x7ff7251ae1f0>, 'localised_SI_number': <function localised_SI_number at 0x7ff7251ae310>, 'localised_nice_date': <function localised_nice_date at 0x7ff7251ae0d0>, 'localised_filesize': <function localised_filesize at 0x7ff7251ae280>, 'get_available_locales': <function get_available_locales at 0x7ff72630be50>, 'get_locales_dict': <function get_locales_dict at 0x7ff72630bdc0>, 'literal': <class 'ckan.lib.helpers.literal'>, 'asbool': <function asbool at 0x7ff726869ee0>, 'urlencode': <function urlencode at 0x7ff727e4bca0>, 'include_asset': <function include_asset at 0x7ff72504b0d0>, 'render_assets': <function render_assets at 0x7ff72504b1f0>, 'sanitize_id': <function sanitize_id at 0x7ff724ff4ee0>, 'compare_pkg_dicts': <function compare_pkg_dicts at 0x7ff724ff4f70>, 'activity_list_select': <function activity_list_select at 0x7ff724ff9040>, 'get_collaborators': <function get_collaborators at 0x7ff724ff90d0>, 'can_update_owner_org': <function can_update_owner_org at 0x7ff724ff9160>, 'get_map_config': <function get_mapview_config at 0x7ff71814db80>, 'get_dataproxy_url': <function get_dataproxy_url at 0x7ff7181633a0>, 'get_package_bdm_schema_name': <function get_package_bdm_schema_name at 0x7ff713e43670>, 'get_possible_resource_types': <function get_possible_resource_types at 0x7ff713e439d0>, 'get_resource_bdm_table_name': <function get_resource_bdm_table_name at 0x7ff713e43700>, 'is_bdm': <function is_bdm at 0x7ff713e433a0>, 'is_bdm_one_click_download': <function is_bdm_one_click_download at 0x7ff713e43430>, 'load_json_schema': <function load_json_schema at 0x7ff713e43790>, 'make_example_bq_query': <function make_example_bq_query at 0x7ff713e434c0>, 'make_example_python_query': <function make_example_python_query at 0x7ff713e43550>, 'make_example_r_query': <function make_example_r_query at 0x7ff713e435e0>, 'separate_bdm_and_links_resources': <function separate_bdm_and_links_resources at 0x7ff713e8cf70>, 'boltons': <module 'boltons' from '/venv/lib/python3.9/site-packages/boltons/__init__.py'>} |
| packages |
[{'id': 'd0f222d0-c8fa-4584-8b26-7fde3ad2b2e2', 'name': 'programa-de-analise-de-residuos-de-agrotoxicos-em-alimentos-para', 'title': 'Programa de Análise de Resíduos de Agrotóxicos em Alimentos (PARA)', 'type': 'dataset', 'notes': 'O Programa de Análise de Resíduos de Agrotóxicos em Alimentos (PARA) foi criado em 2001 com o objetivo de avaliar, continuamente, os níveis de resíduos de agrotóxicos nos alimentos de origem vegetal que chegam à mesa do consumidor. \r\n\r\nO programa é uma ação do Sistema Nacional de Vigilância Sanitária (SNVS), coordenado pela Anvisa em conjunto com órgãos estaduais e municipais de vigilância sanitária e laboratórios estaduais de saúde pública.\r\n\r\nDesde a criação do PARA já foram analisadas mais de 35 mil amostras referentes a 28 tipos de alimentos de origem vegetal.', 'author': None, 'author_email': None, 'maintainer': None, 'maintainer_email': None, 'state': 'active', 'license_id': None, 'url': 'http://portal.anvisa.gov.br/programa-de-analise-de-registro-de-agrotoxicos-para', 'version': None, 'metadata_created': '2019-12-30T15:27:10.293031', 'metadata_modified': '2022-12-20T19:05:38.851621', 'creator_user_id': '27eaffe3-f79b-469f-8f02-4716146bdfcc', 'private': False, 'license_title': None, 'num_resources': 1, 'resources': [{'id': '3d706f96-2ee2-4509-bfe8-fd8e1b1e9c9d', 'name': 'Relatório e Dados', 'description': '', 'position': 0, 'url': 'http://portal.anvisa.gov.br/programa-de-analise-de-registro-de-agrotoxicos-para', 'cache_last_updated': None, 'cache_url': None, 'created': '2019-12-30T15:27:28.740841', 'datastore_active': False, 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2022-12-20T19:05:38.856889', 'mimetype': None, 'mimetype_inner': None, 'package_id': 'd0f222d0-c8fa-4584-8b26-7fde3ad2b2e2', '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', 'country_ip_address_required': None, 'license': 'mit', 'spatial_coverage': ['sa.br'], 'temporal_coverage': ['2001(1)2018'], 'update_frequency': 'one_year', 'observation_level': [{'entity': 'country'}, {'entity': 'product'}]}], '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': '4e4ab02b-6916-493b-9645-375ee3c3d3cd', 'name': 'ciencia-tec-inov', 'title': 'Ciência, Tecnologia e Inovação', 'type': 'group', 'description': '', 'image_url': '2019-09-27-055908.259082science-stem-feature.png', 'created': '2019-09-27T05:59:08.271186', 'is_organization': False, 'approval_status': 'approved', 'state': 'active', 'capacity': 'public', 'display_name': 'Ciência, Tecnologia e Inovação', 'image_display_url': 'https://basedosdados.org/uploads/group/2019-09-27-055908.259082science-stem-feature.png'}, {'id': '83dff031-87ba-4265-9499-57e24e24e0b1', 'name': 'meio-ambiente', 'title': 'Meio Ambiente', 'type': 'group', 'description': '', 'image_url': '2019-09-19-060220.418949young-plant-growing-step-nature-sunshine34152-1142.jpg', 'created': '2019-09-14T20:46:03.698095', 'is_organization': False, 'approval_status': 'approved', 'state': 'active', 'capacity': 'public', 'display_name': 'Meio Ambiente', 'image_display_url': 'https://basedosdados.org/uploads/group/2019-09-19-060220.418949young-plant-growing-step-nature-sunshine34152-1142.jpg'}, {'id': '8358e722-42fc-408a-8859-084d74da5dd5', 'name': 'saude', 'title': 'Saúde', 'type': 'group', 'description': '', 'image_url': '2019-09-19-060434.084225heart-checkup.png', 'created': '2019-09-17T04:33:27.710809', 'is_organization': False, 'approval_status': 'approved', 'state': 'active', 'capacity': 'public', 'display_name': 'Saúde', 'image_display_url': 'https://basedosdados.org/uploads/group/2019-09-19-060434.084225heart-checkup.png'}], 'owner_org': 'f021dc84-fe3f-4648-92c5-ee1a7a061ae9', 'organization': {'id': 'f021dc84-fe3f-4648-92c5-ee1a7a061ae9', 'name': 'agencia-nacional-de-vigilancia-sanitaria-anvisa', 'title': 'Agência Nacional de Vigilância Sanitária (ANVISA)', 'type': 'organization', 'description': 'portal.anvisa.gov.br', 'image_url': '2019-11-04-194416.801644anvisa.jpg', 'created': '2019-11-04T19:42:49.391921', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'num_tags': 1, 'tags': [{'id': '2127beaf-9c9e-4a1d-8047-659bb10b0ffa', 'name': 'agrotoxico', 'vocabulary_id': None, 'state': 'active', 'display_name': 'agrotoxico'}], 'relationships_as_object': [], 'relationships_as_subject': [], 'isopen': False, 'extras': [{'key': 'dataset_args', 'value': {}}]}, {'id': '160cf007-074b-4872-afde-b777cf1d35d2', 'name': 'br-anvisa-medicamentos-industrializados', 'title': 'Sistema Nacional de Gerenciamento de Produtos Controlados (SNGPC)', 'type': 'dataset', 'notes': 'Estes arquivos consolidam dados públicos referentes às movimentações do tipo venda ao consumidor para os medicamentos sujeitos à escrituração junto ao SNGPC.', 'author': 'Anderson da Mota Ribeiro', 'author_email': 'Anderson.Mota@anvisa.gov.br', 'maintainer': '', 'maintainer_email': '', 'state': 'active', 'license_id': '', 'url': 'https://dados.gov.br/dataset/venda-de-medicamentos-industrializados-sngpc', 'version': '', 'metadata_created': '2021-09-12T23:21:14.695612', 'metadata_modified': '2022-12-20T18:44:38.100332', 'creator_user_id': '1baab216-315d-41af-8d31-0ef728ef2f9a', 'private': False, 'license_title': '', 'num_resources': 2, 'resources': [{'id': '169736ba-d887-4923-b085-89232d7783e0', 'name': 'Dados', 'description': '', 'position': 0, 'url': 'https://dados.gov.br/dataset/venda-de-medicamentos-industrializados-sngpc', 'cache_last_updated': None, 'cache_url': None, 'created': '2021-02-26T06:30:49.712586', 'datastore_active': False, 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2022-12-20T18:44:38.104967', 'mimetype': None, 'mimetype_inner': None, 'package_id': '160cf007-074b-4872-afde-b777cf1d35d2', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'external_link', 'language': ['portuguese'], 'has_structured_data': 'yes', 'has_api': 'no', 'is_free': 'yes', 'requires_registration': 'no', 'availability': 'online', 'country_ip_address_required': None, 'license': 'mit', 'spatial_coverage': ['sa.br'], 'temporal_coverage': ['2014(1)2020'], 'update_frequency': 'month', 'observation_level': [{'country': 'br', 'entity': 'municipality'}]}, {'id': '5aa05aa4-3a4b-4250-a646-8efca4f41c5a', 'name': 'microdados', 'description': 'Microdados de vendas de medicamentos industrializados sujeitos à escrituração no SNGPC - Sistema Nacional de Gerenciamento de Produtos Controlados.\n', 'position': 1, 'url': '', 'cache_last_updated': None, 'cache_url': None, 'created': '2021-08-16T23:36:35.101816', 'format': '', 'hash': '', 'last_modified': None, 'metadata_modified': '2022-12-20T18:44:38.105264', 'mimetype': None, 'mimetype_inner': None, 'package_id': '160cf007-074b-4872-afde-b777cf1d35d2', 'size': None, 'state': 'active', 'url_type': None, 'resource_type': 'bdm_table', 'dataset_id': 'br_anvisa_medicamentos_industrializados', 'table_id': 'microdados', 'spatial_coverage': ['sa.br'], 'temporal_coverage': ['2014(1)2020'], 'update_frequency': 'month', 'observation_level': [{'entity': 'transaction'}], 'last_updated': {'metadata': None, 'data': None, 'release': None}, 'version': 'v1.0', 'published_by': {'name': 'Ricardo Dahis', 'email': 'rdahis@basedosdados.org', 'github_user': None, 'ckan_user': None, 'website': 'www.ricardodahis.com'}, 'data_cleaned_by': {'name': 'Ricardo Dahis', 'email': 'rdahis@basedosdados.org', 'github_user': None, 'ckan_user': None, 'website': 'www.ricardodahis.com'}, 'data_cleaning_description': '- Padronização de strings.\n- Substituição da variável municipio por id_municipio.\n- Agregação de regiões do Distrito Federal para Brasília.\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-dev', 'project_id_prod': 'basedosdados-dev', 'project_id_staging': 'basedosdados-dev', 'partitions': ['ano', 'mes'], 'uncompressed_file_size': None, 'compressed_file_size': None, 'columns': [{'name': 'ano', 'bigquery_type': 'int64', 'description': 'Ano da venda do medicamento.', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': True}, {'name': 'mes', 'bigquery_type': 'int64', 'description': 'Mês da venda do medicamento.', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': True}, {'name': 'sigla_uf', 'bigquery_type': 'string', 'description': 'Sigla da Unidade da Federação do endereço da farmácia ou drogaria, cadastrado no banco de dados da Anvisa, representando a UF onde ocorreu a venda.', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', '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': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'principio_ativo', 'bigquery_type': 'string', 'description': 'Nome do princípio ativo do medicamento industrializado, conforme cadastrado no registro do medicamento, no banco de dados da Anvisa. Quando um medicamento tem mais de um princípio ativo, cada um deles é separado pelo caractere "+".', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'descricao_apresentacao', 'bigquery_type': 'string', 'description': 'Apresentação do Medicamento. Representa o modo como um medicamento é apresentado na embalagem.', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'quantidade_vendida', 'bigquery_type': 'int64', 'description': 'Quantidade vendida de caixas ou frascos do medicamento.', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'unidade_medida', 'bigquery_type': 'string', 'description': 'Indica se a quantidade vendida do medicamento foi de caixas ou frascos.', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'conselho_prescritor', 'bigquery_type': 'string', 'description': 'Conselho de Classe do profissional que prescreveu o medicamento vendido.', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'sigla_uf_conselho_prescritor', 'bigquery_type': 'string', 'description': 'Sigla da Unidade Federativa do Conselho de Classe do profissional que prescreveu o medicamento vendido.', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'tipo_receituario', 'bigquery_type': 'int64', 'description': 'Tipo de receituário utilizado na prescriçã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': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'cid10', 'bigquery_type': 'string', 'description': 'Classificação Internacional de Doença (aplicável apenas a medicamentos antimicrobianos).', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'sexo', 'bigquery_type': 'string', 'description': 'Sexo do paciente (aplicável apenas a medicamentos antimicrobianos).', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'idade', 'bigquery_type': 'int64', 'description': 'Valor numérico que representa a idade do paciente, em meses ou anos (aplicável apenas a medicamentos antimicrobianos).', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}, {'name': 'unidade_idade', 'bigquery_type': 'int64', 'description': 'Unidade de medida da idade do paciente, que pode ser em meses ou anos (aplicável apenas a medicamentos antimicrobianos).', 'temporal_coverage': ['(1)'], 'covered_by_dictionary': 'no', 'directory_column': {'dataset_id': None, 'table_id': None, 'column_name': None}, 'measurement_unit': None, 'has_sensitive_data': 'yes', 'observations': None, 'is_in_staging': True, 'is_partition': False}]}], 'groups': [{'id': '8358e722-42fc-408a-8859-084d74da5dd5', 'name': 'saude', 'title': 'Saúde', 'type': 'group', 'description': '', 'image_url': '2019-09-19-060434.084225heart-checkup.png', 'created': '2019-09-17T04:33:27.710809', 'is_organization': False, 'approval_status': 'approved', 'state': 'active', 'capacity': 'public', 'display_name': 'Saúde', 'image_display_url': 'https://basedosdados.org/uploads/group/2019-09-19-060434.084225heart-checkup.png'}], 'owner_org': 'f021dc84-fe3f-4648-92c5-ee1a7a061ae9', 'organization': {'id': 'f021dc84-fe3f-4648-92c5-ee1a7a061ae9', 'name': 'agencia-nacional-de-vigilancia-sanitaria-anvisa', 'title': 'Agência Nacional de Vigilância Sanitária (ANVISA)', 'type': 'organization', 'description': 'portal.anvisa.gov.br', 'image_url': '2019-11-04-194416.801644anvisa.jpg', 'created': '2019-11-04T19:42:49.391921', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'num_tags': 5, 'tags': [{'id': '14b2d7e5-e9e0-4312-9b76-839bf31bcbb1', 'name': 'depressao', 'vocabulary_id': None, 'state': 'active', 'display_name': 'depressao'}, {'id': '93095908-8aee-4091-9a6c-8cd440e70d9f', 'name': 'farmacia', 'vocabulary_id': None, 'state': 'active', 'display_name': 'farmacia'}, {'id': '5621607f-17d0-4e1e-a0c5-06544feb4bfb', 'name': 'medicamento', 'vocabulary_id': None, 'state': 'active', 'display_name': 'medicamento'}, {'id': '62984cfe-97aa-4751-b24c-6277cf9aa243', 'name': 'remedio', 'vocabulary_id': None, 'state': 'active', 'display_name': 'remedio'}, {'id': 'fe165783-3f21-4b7f-aba0-92ee47676380', 'name': 'venda', 'vocabulary_id': None, 'state': 'active', 'display_name': 'venda'}], 'relationships_as_object': [], 'relationships_as_subject': [], 'isopen': False, 'extras': [{'key': 'dataset_args', 'value': {}}]}, {'id': '3974f119-4421-4527-9f77-54d113caf3af', 'name': 'precos-medicamentos-consumidor', 'title': 'Preços de Medicamentos - Consumidor', 'type': 'dataset', 'notes': 'Os dados representam a lista de preços de Medicamentos , contemplando o preço Fábrica, ou preço fabricante (PF), que é o preço máximo que pode ser praticado pelas empresas produtoras ou importadoras do produto e pelas empresas distribuidoras. O PF indica o preço máximo permitido para venda a farmácias e drogarias e o Preço Máximo ao Consumidor (PMC) indica o preço teto de venda ao consumidor.', 'author': '', 'author_email': '', 'maintainer': '', 'maintainer_email': '', 'state': 'active', 'license_id': 'other-pd', 'url': 'http://dados.gov.br/dataset/anvisa-precos-de-medicamentos-consumidor', 'version': '', 'metadata_created': '2019-11-04T19:46:20.426275', 'metadata_modified': '2022-12-18T02:18:14.254245', 'creator_user_id': 'ddda388c-09f7-42cb-80c9-c1ac586b848e', 'private': False, 'license_title': 'Other (Public Domain)', 'num_resources': 1, 'resources': [{'id': '7d159850-c0ef-495f-9a46-e647b88b0cba', 'name': 'dados.gov.br', 'description': '', 'position': 0, 'url': 'https://www.gov.br/anvisa/pt-br/assuntos/medicamentos/cmed/precos', 'cache_last_updated': None, 'cache_url': None, 'created': '2019-11-04T19:46:43.056172', 'datastore_active': True, 'format': 'CSV', 'hash': '', 'last_modified': None, 'metadata_modified': '2022-12-18T02:18:14.262992', 'mimetype': 'text/csv', 'mimetype_inner': None, 'package_id': '3974f119-4421-4527-9f77-54d113caf3af', 'size': None, 'state': 'active', 'url_type': '', 'resource_type': 'external_link', 'language': ['portuguese'], 'has_structured_data': 'yes', 'has_api': None, 'is_free': None, 'requires_registration': None, 'availability': 'online', 'country_ip_address_required': [], 'license': 'mit', 'spatial_coverage': None, 'temporal_coverage': [], 'update_frequency': None, 'observation_level': [{'entity': 'drug'}], 'maintainer_email': '', 'maintainer': ''}], 'groups': [{'id': '8358e722-42fc-408a-8859-084d74da5dd5', 'name': 'saude', 'title': 'Saúde', 'type': 'group', 'description': '', 'image_url': '2019-09-19-060434.084225heart-checkup.png', 'created': '2019-09-17T04:33:27.710809', 'is_organization': False, 'approval_status': 'approved', 'state': 'active', 'capacity': 'public', 'display_name': 'Saúde', 'image_display_url': 'https://basedosdados.org/uploads/group/2019-09-19-060434.084225heart-checkup.png'}], 'owner_org': 'f021dc84-fe3f-4648-92c5-ee1a7a061ae9', 'organization': {'id': 'f021dc84-fe3f-4648-92c5-ee1a7a061ae9', 'name': 'agencia-nacional-de-vigilancia-sanitaria-anvisa', 'title': 'Agência Nacional de Vigilância Sanitária (ANVISA)', 'type': 'organization', 'description': 'portal.anvisa.gov.br', 'image_url': '2019-11-04-194416.801644anvisa.jpg', 'created': '2019-11-04T19:42:49.391921', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'num_tags': 3, 'tags': [{'id': 'dc1a3e4f-d874-4b2a-af17-e9ea9a1c135a', 'name': 'inflacao', 'vocabulary_id': None, 'state': 'active', 'display_name': 'inflacao'}, {'id': '5621607f-17d0-4e1e-a0c5-06544feb4bfb', 'name': 'medicamento', 'vocabulary_id': None, 'state': 'active', 'display_name': 'medicamento'}, {'id': 'eea12ebd-d7e3-4cee-8efc-774bd7f47a9a', 'name': 'preco', 'vocabulary_id': None, 'state': 'active', 'display_name': 'preco'}], 'relationships_as_object': [], 'relationships_as_subject': [], 'isopen': True, 'extras': [{'key': 'dataset_args', 'value': {}}]}] |
