{"id":359909,"url":"https://github.com/AMPATH/etl-flat-table-sync","last_synced_at":"2026-05-29T14:01:46.989Z","repository":{"id":46496092,"uuid":"356677134","full_name":"AMPATH/etl-flat-table-sync","owner":"AMPATH","description":"Sync service for seamless synchronization and transformation of data from AMRS to ETL flat tables","archived":false,"fork":false,"pushed_at":"2023-09-07T14:45:28.000Z","size":152,"stargazers_count":0,"open_issues_count":2,"forks_count":4,"subscribers_count":1,"default_branch":"main","last_synced_at":"2026-05-01T00:07:08.689Z","etag":null,"topics":["etl","etl-automation","json-schema","sync"],"latest_commit_sha":null,"homepage":"https://github.com/AMPATH/etl-flat-table-sync","language":"JavaScript","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":null,"status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/AMPATH.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":null,"code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null,"zenodo":null}},"created_at":"2021-04-10T19:37:13.000Z","updated_at":"2023-07-18T09:14:44.000Z","dependencies_parsed_at":"2025-04-22T13:03:57.250Z","dependency_job_id":null,"html_url":"https://github.com/AMPATH/etl-flat-table-sync","commit_stats":null,"previous_names":[],"tags_count":2,"template":false,"template_full_name":null,"purl":"pkg:github/AMPATH/etl-flat-table-sync","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/AMPATH%2Fetl-flat-table-sync","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/AMPATH%2Fetl-flat-table-sync/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/AMPATH%2Fetl-flat-table-sync/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/AMPATH%2Fetl-flat-table-sync/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/AMPATH","download_url":"https://codeload.github.com/AMPATH/etl-flat-table-sync/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/AMPATH%2Fetl-flat-table-sync/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":286080680,"owners_count":32553755,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-05-02T22:28:24.418Z","status":"ssl_error","status_checked_at":"2026-05-02T22:28:14.225Z","response_time":132,"last_error":"SSL_read: unexpected eof while reading","robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":false,"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":"AMPATH","name":"AMPATH","uuid":"1184260","kind":"organization","description":null,"email":"dev@ampath.or.ke","website":"http://medicine.iupui.edu/kenya/hiv.aids.html","location":"Eldoret, Kenya","twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/1184260?v=4","repositories_count":122,"last_synced_at":"2024-04-14T06:15:50.276Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/AMPATH","funding_links":[],"total_stars":84,"followers":19,"following":0,"created_at":"2022-11-03T19:40:26.343Z","updated_at":"2024-04-14T06:16:12.045Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/AMPATH","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/AMPATH/repositories"},"packages":[],"commits":{"id":9753953,"full_name":"AMPATH/etl-flat-table-sync","default_branch":"main","total_commits":92,"total_committers":3,"total_bot_commits":0,"total_bot_committers":0,"mean_commits":30.666666666666668,"dds":0.5108695652173914,"past_year_total_commits":0,"past_year_total_committers":0,"past_year_total_bot_commits":0,"past_year_total_bot_committers":0,"past_year_mean_commits":0.0,"past_year_dds":0.0,"last_synced_at":"2026-05-05T02:07:21.371Z","last_synced_commit":"6e0ae60a523a0dd3e72fceb3c355639d93acfcc7","created_at":"2025-04-22T13:03:51.214Z","updated_at":"2026-05-05T02:07:21.358Z","committers":[{"name":"Kipchumba C. Bett","email":"kbett68@gmail.com","login":"corneliouzbett","count":45},{"name":"maikofelix47","email":"maikofelix89@gmail.com","login":"maikofelix47","count":45},{"name":"Ian","email":"52504170+ibacher","login":"ibacher","count":2}],"past_year_committers":[],"commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/AMPATH%2Fetl-flat-table-sync/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2026-05-07T00:00:08.754Z","repositories_count":6229874,"commits_count":897148572,"contributors_count":34911324,"owners_count":1149942,"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":{"table":{"full_name":"AMPATH/etl-flat-table-sync","html_url":"https://github.com/AMPATH/etl-flat-table-sync","last_synced_at":"2026-04-16T17:01:28.362Z","status":"error","issues_count":0,"pull_requests_count":12,"avg_time_to_close_issue":null,"avg_time_to_close_pull_request":577505.9,"issues_closed_count":0,"pull_requests_closed_count":10,"pull_request_authors_count":4,"issue_authors_count":0,"avg_comments_per_issue":null,"avg_comments_per_pull_request":0.16666666666666666,"merged_pull_requests_count":10,"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":"2025-04-22T13:03:51.526Z","updated_at":"2026-04-16T17:01:28.362Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/AMPATH%2Fetl-flat-table-sync","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/AMPATH%2Fetl-flat-table-sync/issues","issue_labels_count":{"table":{}},"pull_request_labels_count":{"table":{"hacktoberfest-accepted":1}},"issue_author_associations_count":{"table":{}},"pull_request_author_associations_count":{"table":{"MEMBER":8,"CONTRIBUTOR":2,"COLLABORATOR":1}},"issue_authors":{"table":{}},"pull_request_authors":{"table":{"corneliouzbett":6,"ibacher":2,"drizzentic":2,"maikofelix47":1}},"host":{"table":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2026-04-26T00:00:11.126Z","repositories_count":14422732,"issues_count":34455524,"pull_requests_count":112721130,"authors_count":11246384,"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":{"table":{}},"past_year_pull_request_labels_count":{"table":{}},"past_year_issue_author_associations_count":{"table":{}},"past_year_pull_request_author_associations_count":{"table":{}},"past_year_issue_authors":{"table":{}},"past_year_pull_request_authors":{"table":{}},"maintainers":[{"table":{"login":"corneliouzbett","count":6,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/corneliouzbett"}},{"table":{"login":"drizzentic","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/drizzentic"}},{"table":{"login":"maikofelix47","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/maikofelix47"}}],"active_maintainers":[]}},"events":{"total":{},"last_year":{}},"keywords":["etl","etl-automation","json-schema","sync"],"dependencies":[{"ecosystem":"npm","filepath":"package-lock.json","sha":null,"kind":"lockfile","created_at":"2022-09-26T18:10:34.671Z","updated_at":"2022-09-26T18:10:34.671Z","repository_link":"https://github.com/AMPATH/etl-flat-table-sync/blob/main/package-lock.json","dependencies":[{"id":6137579241,"package_name":"axios","ecosystem":"npm","requirements":"0.21.1","direct":false,"kind":"runtime","optional":false},{"id":6137579242,"package_name":"bignumber.js","ecosystem":"npm","requirements":"9.0.0","direct":false,"kind":"runtime","optional":false},{"id":6137579243,"package_name":"core-util-is","ecosystem":"npm","requirements":"1.0.2","direct":false,"kind":"runtime","optional":false},{"id":6137579244,"package_name":"follow-redirects","ecosystem":"npm","requirements":"1.14.1","direct":false,"kind":"runtime","optional":false},{"id":6137579245,"package_name":"inherits","ecosystem":"npm","requirements":"2.0.4","direct":false,"kind":"runtime","optional":false},{"id":6137579246,"package_name":"isarray","ecosystem":"npm","requirements":"1.0.0","direct":false,"kind":"runtime","optional":false},{"id":6137579247,"package_name":"moment","ecosystem":"npm","requirements":"2.29.1","direct":false,"kind":"runtime","optional":false},{"id":6137579248,"package_name":"mysql","ecosystem":"npm","requirements":"2.18.1","direct":false,"kind":"runtime","optional":false},{"id":6137579249,"package_name":"process-nextick-args","ecosystem":"npm","requirements":"2.0.1","direct":false,"kind":"runtime","optional":false},{"id":6137579250,"package_name":"readable-stream","ecosystem":"npm","requirements":"2.3.7","direct":false,"kind":"runtime","optional":false},{"id":6137579251,"package_name":"safe-buffer","ecosystem":"npm","requirements":"5.1.2","direct":false,"kind":"runtime","optional":false},{"id":6137579252,"package_name":"sqlstring","ecosystem":"npm","requirements":"2.3.1","direct":false,"kind":"runtime","optional":false},{"id":6137579253,"package_name":"string_decoder","ecosystem":"npm","requirements":"1.1.1","direct":false,"kind":"runtime","optional":false},{"id":6137579254,"package_name":"util-deprecate","ecosystem":"npm","requirements":"1.0.2","direct":false,"kind":"runtime","optional":false}]},{"ecosystem":"npm","filepath":"package.json","sha":null,"kind":"manifest","created_at":"2022-09-26T18:10:34.825Z","updated_at":"2022-09-26T18:10:34.825Z","repository_link":"https://github.com/AMPATH/etl-flat-table-sync/blob/main/package.json","dependencies":[{"id":6137580057,"package_name":"axios","ecosystem":"npm","requirements":"^0.21.1","direct":true,"kind":"runtime","optional":false},{"id":6137580058,"package_name":"moment","ecosystem":"npm","requirements":"^2.29.1","direct":true,"kind":"runtime","optional":false},{"id":6137580059,"package_name":"mysql","ecosystem":"npm","requirements":"^2.18.1","direct":true,"kind":"runtime","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/docker-build-push.yml","sha":null,"kind":"manifest","created_at":"2025-04-22T13:03:56.870Z","updated_at":"2025-04-22T13:03:56.870Z","repository_link":"https://github.com/AMPATH/etl-flat-table-sync/blob/main/.github/workflows/docker-build-push.yml","dependencies":[{"id":22801863565,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":22801863566,"package_name":"docker/metadata-action","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":22801863567,"package_name":"docker/login-action","ecosystem":"actions","requirements":"v1","direct":true,"kind":"composite","optional":false},{"id":22801863568,"package_name":"docker/build-push-action","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/docker-publish.yml","sha":null,"kind":"manifest","created_at":"2025-04-22T13:03:56.938Z","updated_at":"2025-04-22T13:03:56.938Z","repository_link":"https://github.com/AMPATH/etl-flat-table-sync/blob/main/.github/workflows/docker-publish.yml","dependencies":[{"id":22801863569,"package_name":"docker/setup-qemu-action","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":22801863570,"package_name":"docker/setup-buildx-action","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":22801863571,"package_name":"docker/login-action","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":22801863572,"package_name":"docker/build-push-action","ecosystem":"actions","requirements":"v4","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/node.js.yml","sha":null,"kind":"manifest","created_at":"2025-04-22T13:03:56.999Z","updated_at":"2025-04-22T13:03:56.999Z","repository_link":"https://github.com/AMPATH/etl-flat-table-sync/blob/main/.github/workflows/node.js.yml","dependencies":[{"id":22801863573,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":22801863574,"package_name":"actions/setup-node","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"docker","filepath":"Dockerfile","sha":null,"kind":"manifest","created_at":"2025-04-22T13:03:57.061Z","updated_at":"2025-04-22T13:03:57.061Z","repository_link":"https://github.com/AMPATH/etl-flat-table-sync/blob/main/Dockerfile","dependencies":[{"id":22801863575,"package_name":"node","ecosystem":"docker","requirements":"12-alpine","direct":true,"kind":"build","optional":false}]},{"ecosystem":"docker","filepath":"docker/Dockerfile","sha":null,"kind":"manifest","created_at":"2025-04-22T13:03:57.132Z","updated_at":"2025-04-22T13:03:57.132Z","repository_link":"https://github.com/AMPATH/etl-flat-table-sync/blob/main/docker/Dockerfile","dependencies":[{"id":22801863576,"package_name":"node","ecosystem":"docker","requirements":"12-alpine","direct":true,"kind":"build","optional":false}]}],"score":1.791759469228055,"created_at":"2025-04-22T12:52:20.623Z","updated_at":"2026-05-29T14:01:46.989Z","avatar_url":"https://github.com/AMPATH.png","language":"JavaScript","codemeta":null,"publiccode":null,"project_url":"https://summary.ecosyste.ms/api/v1/projects/359909","html_url":"https://summary.ecosyste.ms/projects/359909"}