{"id":204592,"name":null,"description":"🔍 System for Systematic Quantitative Literature Eeviews","url":"https://github.com/danielvartan/sqlr","last_synced_at":"2025-09-11T08:28:06.284Z","repository":{"id":160735673,"uuid":"350190889","full_name":"danielvartan/sqlr","owner":"danielvartan","description":"🔍 System for Systematic Quantitative Literature Eeviews","archived":true,"fork":false,"pushed_at":"2023-09-26T05:08:06.000Z","size":95811,"stargazers_count":8,"open_issues_count":2,"forks_count":0,"subscribers_count":1,"default_branch":"main","last_synced_at":"2025-04-28T15:43:30.657Z","etag":null,"topics":["evidence-synthesis","r","r-package","rstats","systematic-review"],"latest_commit_sha":null,"homepage":"https://danielvartan.github.io/sqlr/","language":"R","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"other","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/danielvartan.png","metadata":{"files":{"readme":"README.Rmd","changelog":null,"contributing":".github/CONTRIBUTING.md","funding":".github/FUNDING.yml","license":"LICENSE","code_of_conduct":"CODE_OF_CONDUCT.md","threat_model":null,"audit":null,"citation":"CITATION.cff","codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":"codemeta.json"},"funding":{"github":["danielvartan"]}},"created_at":"2021-03-22T03:12:03.000Z","updated_at":"2025-03-11T21:14:57.000Z","dependencies_parsed_at":"2024-05-02T04:44:57.650Z","dependency_job_id":null,"html_url":"https://github.com/danielvartan/sqlr","commit_stats":null,"previous_names":["danielvartan/sqlr"],"tags_count":0,"template":false,"template_full_name":null,"purl":"pkg:github/danielvartan/sqlr","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/danielvartan%2Fsqlr","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/danielvartan%2Fsqlr/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/danielvartan%2Fsqlr/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/danielvartan%2Fsqlr/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/danielvartan","download_url":"https://codeload.github.com/danielvartan/sqlr/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/danielvartan%2Fsqlr/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":274601754,"owners_count":25315198,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2022-07-04T15:15:14.044Z","status":"online","status_checked_at":"2025-09-11T02:00:13.660Z","response_time":74,"last_error":null,"robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":true,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"}},"owner":{"login":"danielvartan","name":"Daniel Vartanian","uuid":"29462472","kind":"user","description":"Academic. Passionate about #opendata and #openscience.","email":"","website":"danielvartan.com","location":"São Paulo, Brazil","twitter":null,"company":"@sustentarea","icon_url":"https://avatars.githubusercontent.com/u/29462472?u=617260e556dbca8b68b9ede5d30266c04e6882cd\u0026v=4","repositories_count":84,"last_synced_at":"2025-09-04T20:28:36.184Z","metadata":{"has_sponsors_listing":true},"html_url":"https://github.com/danielvartan","funding_links":["https://github.com/sponsors/danielvartan"],"total_stars":104,"followers":45,"following":221,"created_at":"2023-09-04T22:08:23.820Z","updated_at":"2025-09-04T20:28:36.184Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/danielvartan","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/danielvartan/repositories"},"packages":[],"commits":{"id":5148489,"full_name":"danielvartan/sqlr","default_branch":"master","committers":null,"total_commits":null,"total_committers":null,"total_bot_commits":null,"total_bot_committers":null,"mean_commits":null,"dds":null,"past_year_committers":null,"past_year_total_commits":null,"past_year_total_committers":null,"past_year_total_bot_commits":null,"past_year_total_bot_committers":null,"past_year_mean_commits":null,"past_year_dds":null,"last_synced_at":null,"last_synced_commit":null,"created_at":"2024-11-11T14:44:09.164Z","updated_at":"2024-11-11T14:44:09.164Z","commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/danielvartan%2Fsqlr/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-11T02:23:18.710Z","repositories_count":5578974,"commits_count":890284450,"contributors_count":33161064,"owners_count":922942,"icon_url":"https://github.com/github.png","host_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories"}},"issues_stats":{"full_name":"danielvartan/sqlr","html_url":"https://github.com/danielvartan/sqlr","last_synced_at":"2024-11-11T14:45:24.335Z","status":null,"issues_count":3,"pull_requests_count":0,"avg_time_to_close_issue":554301.0,"avg_time_to_close_pull_request":null,"issues_closed_count":1,"pull_requests_closed_count":0,"pull_request_authors_count":0,"issue_authors_count":1,"avg_comments_per_issue":0.0,"avg_comments_per_pull_request":null,"merged_pull_requests_count":0,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":0,"past_year_pull_requests_count":0,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":null,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":0,"past_year_pull_request_authors_count":0,"past_year_issue_authors_count":0,"past_year_avg_comments_per_issue":null,"past_year_avg_comments_per_pull_request":null,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":0,"created_at":"2024-11-11T14:44:09.769Z","updated_at":"2024-11-11T14:45:24.336Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/danielvartan%2Fsqlr","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/danielvartan%2Fsqlr/issues","issue_labels_count":{"enhancement":2,"documentation":1},"pull_request_labels_count":{},"issue_author_associations_count":{"OWNER":3},"pull_request_author_associations_count":{},"issue_authors":{"danielvartan":3},"pull_request_authors":{},"host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-11T00:00:09.407Z","repositories_count":10235011,"issues_count":32583100,"pull_requests_count":103219565,"authors_count":10756197,"icon_url":"https://github.com/github.png","host_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories","owners_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/owners","authors_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors"},"past_year_issue_labels_count":{},"past_year_pull_request_labels_count":{},"past_year_issue_author_associations_count":{},"past_year_pull_request_author_associations_count":{},"past_year_issue_authors":{},"past_year_pull_request_authors":{},"maintainers":[{"login":"danielvartan","count":3,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/danielvartan"}],"active_maintainers":[]},"events":{"total":{},"last_year":{}},"keywords":["evidence-synthesis","r","r-package","rstats","systematic-review"],"dependencies":[{"ecosystem":"actions","filepath":".github/workflows/check-standard.yaml","sha":null,"kind":"manifest","created_at":"2023-05-15T01:45:17.952Z","updated_at":"2023-05-15T01:45:17.952Z","repository_link":"https://github.com/danielvartan/sqlr/blob/main/.github/workflows/check-standard.yaml","dependencies":[{"id":9655829525,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":9655829527,"package_name":"r-lib/actions/setup-pandoc","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":9655829538,"package_name":"r-lib/actions/setup-r","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":9655829541,"package_name":"r-lib/actions/setup-r-dependencies","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":9655829542,"package_name":"r-lib/actions/check-r-package","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/pkgdown.yaml","sha":null,"kind":"manifest","created_at":"2023-05-15T01:45:18.061Z","updated_at":"2023-05-15T01:45:18.061Z","repository_link":"https://github.com/danielvartan/sqlr/blob/main/.github/workflows/pkgdown.yaml","dependencies":[{"id":9655829641,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":9655829642,"package_name":"r-lib/actions/setup-pandoc","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":9655829643,"package_name":"r-lib/actions/setup-r","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":9655829644,"package_name":"r-lib/actions/setup-r-dependencies","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":9655829645,"package_name":"JamesIves/github-pages-deploy-action","ecosystem":"actions","requirements":"v4.4.1","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/test-coverage.yaml","sha":null,"kind":"manifest","created_at":"2023-05-15T01:45:18.090Z","updated_at":"2023-05-15T01:45:18.090Z","repository_link":"https://github.com/danielvartan/sqlr/blob/main/.github/workflows/test-coverage.yaml","dependencies":[{"id":9655830808,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":9655830809,"package_name":"r-lib/actions/setup-r","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":9655830810,"package_name":"r-lib/actions/setup-r-dependencies","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":9655830811,"package_name":"actions/upload-artifact","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"cran","filepath":"DESCRIPTION","sha":null,"kind":"manifest","created_at":"2023-05-15T01:45:18.160Z","updated_at":"2023-05-15T01:45:18.160Z","repository_link":"https://github.com/danielvartan/sqlr/blob/main/DESCRIPTION","dependencies":[{"id":9655830833,"package_name":"R","ecosystem":"cran","requirements":"\u003e= 4.1","direct":true,"kind":"depends","optional":false},{"id":9655830834,"package_name":"checkmate","ecosystem":"cran","requirements":"\u003e= 2.1.0","direct":true,"kind":"imports","optional":false},{"id":9655830835,"package_name":"cli","ecosystem":"cran","requirements":"\u003e= 3.6.0","direct":true,"kind":"imports","optional":false},{"id":9655830836,"package_name":"dplyr","ecosystem":"cran","requirements":"\u003e= 1.1.0","direct":true,"kind":"imports","optional":false},{"id":9655830837,"package_name":"googlesheets4","ecosystem":"cran","requirements":"\u003e= 1.0.1","direct":true,"kind":"imports","optional":false},{"id":9655830838,"package_name":"gutils","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":9655830839,"package_name":"lifecycle","ecosystem":"cran","requirements":"\u003e= 1.0.3","direct":true,"kind":"imports","optional":false},{"id":9655830840,"package_name":"refstudio","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":9655830879,"package_name":"rlang","ecosystem":"cran","requirements":"\u003e= 1.0.6","direct":true,"kind":"imports","optional":false},{"id":9655830880,"package_name":"stringr","ecosystem":"cran","requirements":"\u003e= 1.5.0","direct":true,"kind":"imports","optional":false},{"id":9655830881,"package_name":"covr","ecosystem":"cran","requirements":"\u003e= 3.6.1","direct":true,"kind":"suggests","optional":false},{"id":9655830882,"package_name":"knitr","ecosystem":"cran","requirements":"\u003e= 1.42","direct":true,"kind":"suggests","optional":false},{"id":9655830883,"package_name":"mockr","ecosystem":"cran","requirements":"\u003e= 0.2.1","direct":true,"kind":"suggests","optional":false},{"id":9655830884,"package_name":"rmarkdown","ecosystem":"cran","requirements":"\u003e= 2.20","direct":true,"kind":"suggests","optional":false},{"id":9655830886,"package_name":"spelling","ecosystem":"cran","requirements":"\u003e= 2.2","direct":true,"kind":"suggests","optional":false},{"id":9655830887,"package_name":"testthat","ecosystem":"cran","requirements":"\u003e= 3.1.6","direct":true,"kind":"suggests","optional":false},{"id":9655830888,"package_name":"utils","ecosystem":"cran","requirements":"\u003e= 4.1.0","direct":true,"kind":"suggests","optional":false}]}],"score":null,"created_at":"2025-09-09T04:17:28.923Z","updated_at":"2025-11-04T15:59:33.445Z","avatar_url":"https://github.com/danielvartan.png","language":"R","category":null,"sub_category":null,"monthly_downloads":0,"funding_links":["https://github.com/sponsors/danielvartan"],"readme_doi_urls":["https://doi.org/10.1080/07294360.2013.841651"],"works":{},"citation_counts":{},"total_citations":0,"keywords_from_contributors":[],"project_url":"https://science.ecosyste.ms/api/v1/projects/204592","html_url":"https://science.ecosyste.ms/projects/204592","bibtex_url":"https://science.ecosyste.ms/projects/204592/export.bibtex","apalike_url":"https://science.ecosyste.ms/projects/204592/export.apalike"}