Coverage of fluoride data in water supply systems using the R software

Detalhes bibliográficos
Autor(a) principal: Paulino,Camila de Moraes
Data de Publicação: 2022
Outros Autores: Belotti,Lorrayne, Azevedo,Moises Kim Zanotto de, Frazão,Paulo
Tipo de documento: Artigo
Idioma: eng
Título da fonte: Revista de Saúde Pública
Texto Completo: http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0034-89102022000100215
Resumo: ABSTRACT OBJECTIVE To present a protocol to criticize data on fluoride monitoring in water with R software programming features, illustrating its application to describe data coverage, and fluoridation quality in 2015. METHODS The study used big data from the Sistema de Informação de Vigilância da Qualidade da Água para Consumo Humano (Information System for Surveillance of Water Quality for Human Consumption) that included all the Brazilian municipalities. Data criticism procedures were performed with the aid of R software. Filters were applied to remove municipalities with less than four months of records (1), and records with null values (2) and outliers (3). Municipalities were classified regarding the presence of valid information and fluoridation quality according to macro-region, federation units, and population size, presenting the roadmap at each step. RESULTS Approximately 134,000 records were reviewed. Of the Brazilian municipalities, 39% had data on the fluoride parameter, and only 33.3% had four months or more of information frequency. After applying filters, 1,810 (32.5%) municipalities had valid information for the fluoride parameter, with substantial variation between the South (83.6%) and North (0.7%) macro-regions. Of these, 726 (40.1%) showed very good fluoridation quality, determined by 80% or more records within the optimal concentration interval for prevention of dental caries, with higher value (54.3%) in municipalities with 50,000 inhabitants or more, and lower (34.2%) in those with less than 10,000 inhabitants. CONCLUSIONS Important differences persist within and between the Brazilian macro-regions regarding both the availability of information on the parameter, and the quality of water fluoridation in public supply systems in Brazil. The protocol for data review and processing with R software programming resources proved to be very useful for the production of information for decision-making based on a standardized method.
id USP-23_a4da50c694536f1656fa2de4222eabd3
oai_identifier_str oai:scielo:S0034-89102022000100215
network_acronym_str USP-23
network_name_str Revista de Saúde Pública
repository_id_str
spelling Coverage of fluoride data in water supply systems using the R softwareWater SupplyFluoridation, standardsWater Supply CoverageWater QualityBig DataDecision Making, OrganizationalABSTRACT OBJECTIVE To present a protocol to criticize data on fluoride monitoring in water with R software programming features, illustrating its application to describe data coverage, and fluoridation quality in 2015. METHODS The study used big data from the Sistema de Informação de Vigilância da Qualidade da Água para Consumo Humano (Information System for Surveillance of Water Quality for Human Consumption) that included all the Brazilian municipalities. Data criticism procedures were performed with the aid of R software. Filters were applied to remove municipalities with less than four months of records (1), and records with null values (2) and outliers (3). Municipalities were classified regarding the presence of valid information and fluoridation quality according to macro-region, federation units, and population size, presenting the roadmap at each step. RESULTS Approximately 134,000 records were reviewed. Of the Brazilian municipalities, 39% had data on the fluoride parameter, and only 33.3% had four months or more of information frequency. After applying filters, 1,810 (32.5%) municipalities had valid information for the fluoride parameter, with substantial variation between the South (83.6%) and North (0.7%) macro-regions. Of these, 726 (40.1%) showed very good fluoridation quality, determined by 80% or more records within the optimal concentration interval for prevention of dental caries, with higher value (54.3%) in municipalities with 50,000 inhabitants or more, and lower (34.2%) in those with less than 10,000 inhabitants. CONCLUSIONS Important differences persist within and between the Brazilian macro-regions regarding both the availability of information on the parameter, and the quality of water fluoridation in public supply systems in Brazil. The protocol for data review and processing with R software programming resources proved to be very useful for the production of information for decision-making based on a standardized method.Faculdade de Saúde Pública da Universidade de São Paulo2022-01-01info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersiontext/htmlhttp://old.scielo.br/scielo.php?script=sci_arttext&pid=S0034-89102022000100215Revista de Saúde Pública v.56 2022reponame:Revista de Saúde Públicainstname:Universidade de São Paulo (USP)instacron:USP10.11606/s1518-8787.2022056003709info:eu-repo/semantics/openAccessPaulino,Camila de MoraesBelotti,LorrayneAzevedo,Moises Kim Zanotto deFrazão,Pauloeng2022-04-05T00:00:00Zoai:scielo:S0034-89102022000100215Revistahttp://www.scielo.br/scielo.php?script=sci_serial&pid=0034-8910&lng=pt&nrm=isoONGhttps://old.scielo.br/oai/scielo-oai.phprevsp@org.usp.br||revsp1@usp.br1518-87870034-8910opendoar:2022-04-05T00:00Revista de Saúde Pública - Universidade de São Paulo (USP)false
dc.title.none.fl_str_mv Coverage of fluoride data in water supply systems using the R software
title Coverage of fluoride data in water supply systems using the R software
spellingShingle Coverage of fluoride data in water supply systems using the R software
Paulino,Camila de Moraes
Water Supply
Fluoridation, standards
Water Supply Coverage
Water Quality
Big Data
Decision Making, Organizational
title_short Coverage of fluoride data in water supply systems using the R software
title_full Coverage of fluoride data in water supply systems using the R software
title_fullStr Coverage of fluoride data in water supply systems using the R software
title_full_unstemmed Coverage of fluoride data in water supply systems using the R software
title_sort Coverage of fluoride data in water supply systems using the R software
author Paulino,Camila de Moraes
author_facet Paulino,Camila de Moraes
Belotti,Lorrayne
Azevedo,Moises Kim Zanotto de
Frazão,Paulo
author_role author
author2 Belotti,Lorrayne
Azevedo,Moises Kim Zanotto de
Frazão,Paulo
author2_role author
author
author
dc.contributor.author.fl_str_mv Paulino,Camila de Moraes
Belotti,Lorrayne
Azevedo,Moises Kim Zanotto de
Frazão,Paulo
dc.subject.por.fl_str_mv Water Supply
Fluoridation, standards
Water Supply Coverage
Water Quality
Big Data
Decision Making, Organizational
topic Water Supply
Fluoridation, standards
Water Supply Coverage
Water Quality
Big Data
Decision Making, Organizational
description ABSTRACT OBJECTIVE To present a protocol to criticize data on fluoride monitoring in water with R software programming features, illustrating its application to describe data coverage, and fluoridation quality in 2015. METHODS The study used big data from the Sistema de Informação de Vigilância da Qualidade da Água para Consumo Humano (Information System for Surveillance of Water Quality for Human Consumption) that included all the Brazilian municipalities. Data criticism procedures were performed with the aid of R software. Filters were applied to remove municipalities with less than four months of records (1), and records with null values (2) and outliers (3). Municipalities were classified regarding the presence of valid information and fluoridation quality according to macro-region, federation units, and population size, presenting the roadmap at each step. RESULTS Approximately 134,000 records were reviewed. Of the Brazilian municipalities, 39% had data on the fluoride parameter, and only 33.3% had four months or more of information frequency. After applying filters, 1,810 (32.5%) municipalities had valid information for the fluoride parameter, with substantial variation between the South (83.6%) and North (0.7%) macro-regions. Of these, 726 (40.1%) showed very good fluoridation quality, determined by 80% or more records within the optimal concentration interval for prevention of dental caries, with higher value (54.3%) in municipalities with 50,000 inhabitants or more, and lower (34.2%) in those with less than 10,000 inhabitants. CONCLUSIONS Important differences persist within and between the Brazilian macro-regions regarding both the availability of information on the parameter, and the quality of water fluoridation in public supply systems in Brazil. The protocol for data review and processing with R software programming resources proved to be very useful for the production of information for decision-making based on a standardized method.
publishDate 2022
dc.date.none.fl_str_mv 2022-01-01
dc.type.driver.fl_str_mv info:eu-repo/semantics/article
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
format article
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0034-89102022000100215
url http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0034-89102022000100215
dc.language.iso.fl_str_mv eng
language eng
dc.relation.none.fl_str_mv 10.11606/s1518-8787.2022056003709
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv text/html
dc.publisher.none.fl_str_mv Faculdade de Saúde Pública da Universidade de São Paulo
publisher.none.fl_str_mv Faculdade de Saúde Pública da Universidade de São Paulo
dc.source.none.fl_str_mv Revista de Saúde Pública v.56 2022
reponame:Revista de Saúde Pública
instname:Universidade de São Paulo (USP)
instacron:USP
instname_str Universidade de São Paulo (USP)
instacron_str USP
institution USP
reponame_str Revista de Saúde Pública
collection Revista de Saúde Pública
repository.name.fl_str_mv Revista de Saúde Pública - Universidade de São Paulo (USP)
repository.mail.fl_str_mv revsp@org.usp.br||revsp1@usp.br
_version_ 1748936506714619904