{"id":66261,"name":"collate","description":"Aggregation SQL Query Builder","url":"https://github.com/dssg/collate","last_synced_at":"2025-09-08T13:36:31.258Z","repository":{"id":46082114,"uuid":"71167444","full_name":"dssg/collate","owner":"dssg","description":"Aggregation SQL Query Builder","archived":false,"fork":false,"pushed_at":"2022-12-26T20:26:44.000Z","size":408,"stargazers_count":1,"open_issues_count":8,"forks_count":3,"subscribers_count":27,"default_branch":"master","last_synced_at":"2025-08-21T06:55:24.423Z","etag":null,"topics":["triage"],"latest_commit_sha":null,"homepage":null,"language":"Python","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/dssg.png","metadata":{"files":{"readme":"README.rst","changelog":"HISTORY.rst","contributing":"CONTRIBUTING.rst","funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null}},"created_at":"2016-10-17T18:14:02.000Z","updated_at":"2019-09-09T00:32:18.000Z","dependencies_parsed_at":"2023-01-31T01:15:29.284Z","dependency_job_id":null,"html_url":"https://github.com/dssg/collate","commit_stats":null,"previous_names":[],"tags_count":4,"template":false,"template_full_name":null,"purl":"pkg:github/dssg/collate","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/dssg","download_url":"https://codeload.github.com/dssg/collate/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/sbom","scorecard":{"id":358019,"data":{"date":"2025-08-11","repo":{"name":"github.com/dssg/collate","commit":"30d051f21c2374bc802ecde4a557a6347dfc9940"},"scorecard":{"version":"v5.2.1-40-gf6ed084d","commit":"f6ed084d17c9236477efd66e5b258b9d4cc7b389"},"score":2.3,"checks":[{"name":"Packaging","score":-1,"reason":"packaging workflow not detected","details":["Warn: no GitHub/GitLab publishing workflow detected."],"documentation":{"short":"Determines if the project is published as a package that others can easily download, install, easily update, and uninstall.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#packaging"}},{"name":"Dangerous-Workflow","score":-1,"reason":"no workflows found","details":null,"documentation":{"short":"Determines if the project's GitHub Action workflows avoid dangerous patterns.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#dangerous-workflow"}},{"name":"Maintained","score":0,"reason":"0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0","details":null,"documentation":{"short":"Determines if the project is \"actively maintained\".","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#maintained"}},{"name":"Code-Review","score":5,"reason":"Found 10/19 approved changesets -- score normalized to 5","details":null,"documentation":{"short":"Determines if the project requires human code review before pull requests (aka merge requests) are merged.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#code-review"}},{"name":"Token-Permissions","score":-1,"reason":"No tokens found","details":null,"documentation":{"short":"Determines if the project's workflows follow the principle of least privilege.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#token-permissions"}},{"name":"Binary-Artifacts","score":10,"reason":"no binaries found in the repo","details":null,"documentation":{"short":"Determines if the project has generated executable (binary) artifacts in the source repository.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#binary-artifacts"}},{"name":"Pinned-Dependencies","score":-1,"reason":"no dependencies found","details":null,"documentation":{"short":"Determines if the project has declared and pinned the dependencies of its build process.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#pinned-dependencies"}},{"name":"CII-Best-Practices","score":0,"reason":"no effort to earn an OpenSSF best practices badge detected","details":null,"documentation":{"short":"Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#cii-best-practices"}},{"name":"Fuzzing","score":0,"reason":"project is not fuzzed","details":["Warn: no fuzzer integrations found"],"documentation":{"short":"Determines if the project uses fuzzing.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#fuzzing"}},{"name":"License","score":9,"reason":"license file detected","details":["Info: project has a license file: LICENSE:0","Warn: project license file does not contain an FSF or OSI license."],"documentation":{"short":"Determines if the project has defined a license.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#license"}},{"name":"Signed-Releases","score":-1,"reason":"no releases found","details":null,"documentation":{"short":"Determines if the project cryptographically signs release artifacts.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#signed-releases"}},{"name":"Branch-Protection","score":0,"reason":"branch protection not enabled on development/release branches","details":["Warn: branch protection not enabled for branch 'master'"],"documentation":{"short":"Determines if the default and release branches are protected with GitHub's branch protection settings.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#branch-protection"}},{"name":"Security-Policy","score":0,"reason":"security policy file not detected","details":["Warn: no security policy file detected","Warn: no security file to analyze","Warn: no security file to analyze","Warn: no security file to analyze"],"documentation":{"short":"Determines if the project has published a security policy.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#security-policy"}},{"name":"SAST","score":0,"reason":"SAST tool is not run on all commits -- score normalized to 0","details":["Warn: 0 commits out of 25 are checked with a SAST tool"],"documentation":{"short":"Determines if the project uses static code analysis.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#sast"}},{"name":"Vulnerabilities","score":0,"reason":"18 existing vulnerabilities detected","details":["Warn: Project is vulnerable to: PYSEC-2019-124 / GHSA-38fc-9xqv-7f7q","Warn: Project is vulnerable to: PYSEC-2019-123 / GHSA-887w-45rq-vxgf","Warn: Project is vulnerable to: PYSEC-2022-238 / GHSA-h3qr-fjhm-jphw","Warn: Project is vulnerable to: GHSA-3ww4-gg4f-jr7f","Warn: Project is vulnerable to: GHSA-5cpq-8wj7-hf2v","Warn: Project is vulnerable to: GHSA-9v9h-cgj8-h64p","Warn: Project is vulnerable to: PYSEC-2018-52 / GHSA-fcf9-3qw3-gxmj","Warn: Project is vulnerable to: PYSEC-2021-62 / GHSA-hggm-jpg3-v476","Warn: Project is vulnerable to: GHSA-jm77-qphf-c4w8","Warn: Project is vulnerable to: GHSA-w7pp-m8wf-vj6r","Warn: Project is vulnerable to: GHSA-x4qr-2fvf-3mr5","Warn: Project is vulnerable to: PYSEC-2020-73","Warn: Project is vulnerable to: PYSEC-2021-437 / GHSA-5xp3-jfq3-5q8x","Warn: Project is vulnerable to: PYSEC-2020-173 / GHSA-gpvv-69j7-gwj8","Warn: Project is vulnerable to: PYSEC-2023-228 / GHSA-mq26-g339-26xf","Warn: Project is vulnerable to: PYSEC-2021-142 / GHSA-8q59-q68h-6hv4","Warn: Project is vulnerable to: PYSEC-2018-49 / GHSA-rprw-h62v-c2w7","Warn: Project is vulnerable to: PYSEC-2022-43017 / GHSA-qwmp-2cf2-g9g6"],"documentation":{"short":"Determines if the project has open, known unfixed vulnerabilities.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#vulnerabilities"}}]},"last_synced_at":"2025-08-18T10:06:05.662Z","repository_id":46082114,"created_at":"2025-08-18T10:06:05.662Z","updated_at":"2025-08-18T10:06:05.662Z"},"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":274194713,"owners_count":25239096,"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-08T02:00:09.813Z","response_time":121,"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":"dssg","name":"Data Science for Social Good","uuid":"3827384","kind":"organization","description":"","email":"info@datascienceforsocialgood.org","website":"http://dssgfellowship.org","location":"Pittsburgh, PA","twitter":"datascifellows","company":null,"icon_url":"https://avatars.githubusercontent.com/u/3827384?v=4","repositories_count":145,"last_synced_at":"2023-04-10T01:09:06.203Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/dssg","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-02T16:35:22.671Z","updated_at":"2023-04-10T01:09:06.463Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/dssg","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/dssg/repositories"},"packages":[{"id":2675672,"name":"collate","ecosystem":"pypi","description":"Aggregated feature generation made easy.","homepage":"https://github.com/dssg/collate","licenses":"MIT license","normalized_licenses":["MIT"],"repository_url":"https://github.com/dssg/collate","keywords_array":["collate"],"namespace":null,"versions_count":4,"first_release_published_at":"2016-12-14T00:06:03.000Z","latest_release_published_at":"2017-10-20T20:31:38.000Z","latest_release_number":"0.3.0","last_synced_at":"2025-08-21T06:19:42.375Z","created_at":"2022-04-10T10:24:21.150Z","updated_at":"2025-08-21T06:26:32.872Z","registry_url":"https://pypi.org/project/collate/","install_command":"pip install collate --index-url https://pypi.org/simple","documentation_url":"https://collate.readthedocs.io/","metadata":{"funding":null,"documentation":null,"classifiers":["Development Status :: 2 - Pre-Alpha","Intended Audience :: Developers","License :: OSI Approved :: MIT License","Natural Language :: English","Programming Language :: Python :: 2","Programming Language :: Python :: 2.6","Programming Language :: Python :: 2.7","Programming Language :: Python :: 3","Programming Language :: Python :: 3.3","Programming Language :: Python :: 3.4","Programming Language :: Python :: 3.5"],"normalized_name":"collate","project_status":null},"repo_metadata":{"id":46082114,"uuid":"71167444","full_name":"dssg/collate","owner":"dssg","description":"Aggregation SQL Query Builder","archived":false,"fork":false,"pushed_at":"2022-12-26T20:26:44.000Z","size":408,"stargazers_count":1,"open_issues_count":8,"forks_count":3,"subscribers_count":27,"default_branch":"master","last_synced_at":"2025-07-20T17:55:22.131Z","etag":null,"topics":["triage"],"latest_commit_sha":null,"homepage":null,"language":"Python","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/dssg.png","metadata":{"files":{"readme":"README.rst","changelog":"HISTORY.rst","contributing":"CONTRIBUTING.rst","funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null}},"created_at":"2016-10-17T18:14:02.000Z","updated_at":"2019-09-09T00:32:18.000Z","dependencies_parsed_at":"2023-01-31T01:15:29.284Z","dependency_job_id":null,"html_url":"https://github.com/dssg/collate","commit_stats":null,"previous_names":[],"tags_count":4,"template":false,"template_full_name":null,"purl":"pkg:github/dssg/collate","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/dssg","download_url":"https://codeload.github.com/dssg/collate/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/sbom","scorecard":{"id":358019,"data":{"date":"2025-08-11","repo":{"name":"github.com/dssg/collate","commit":"30d051f21c2374bc802ecde4a557a6347dfc9940"},"scorecard":{"version":"v5.2.1-40-gf6ed084d","commit":"f6ed084d17c9236477efd66e5b258b9d4cc7b389"},"score":2.3,"checks":[{"name":"Packaging","score":-1,"reason":"packaging workflow not detected","details":["Warn: no GitHub/GitLab publishing workflow detected."],"documentation":{"short":"Determines if the project is published as a package that others can easily download, install, easily update, and uninstall.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#packaging"}},{"name":"Dangerous-Workflow","score":-1,"reason":"no workflows found","details":null,"documentation":{"short":"Determines if the project's GitHub Action workflows avoid dangerous patterns.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#dangerous-workflow"}},{"name":"Maintained","score":0,"reason":"0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0","details":null,"documentation":{"short":"Determines if the project is \"actively maintained\".","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#maintained"}},{"name":"Code-Review","score":5,"reason":"Found 10/19 approved changesets -- score normalized to 5","details":null,"documentation":{"short":"Determines if the project requires human code review before pull requests (aka merge requests) are merged.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#code-review"}},{"name":"Token-Permissions","score":-1,"reason":"No tokens found","details":null,"documentation":{"short":"Determines if the project's workflows follow the principle of least privilege.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#token-permissions"}},{"name":"Binary-Artifacts","score":10,"reason":"no binaries found in the repo","details":null,"documentation":{"short":"Determines if the project has generated executable (binary) artifacts in the source repository.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#binary-artifacts"}},{"name":"Pinned-Dependencies","score":-1,"reason":"no dependencies found","details":null,"documentation":{"short":"Determines if the project has declared and pinned the dependencies of its build process.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#pinned-dependencies"}},{"name":"CII-Best-Practices","score":0,"reason":"no effort to earn an OpenSSF best practices badge detected","details":null,"documentation":{"short":"Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#cii-best-practices"}},{"name":"Fuzzing","score":0,"reason":"project is not fuzzed","details":["Warn: no fuzzer integrations found"],"documentation":{"short":"Determines if the project uses fuzzing.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#fuzzing"}},{"name":"License","score":9,"reason":"license file detected","details":["Info: project has a license file: LICENSE:0","Warn: project license file does not contain an FSF or OSI license."],"documentation":{"short":"Determines if the project has defined a license.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#license"}},{"name":"Signed-Releases","score":-1,"reason":"no releases found","details":null,"documentation":{"short":"Determines if the project cryptographically signs release artifacts.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#signed-releases"}},{"name":"Branch-Protection","score":0,"reason":"branch protection not enabled on development/release branches","details":["Warn: branch protection not enabled for branch 'master'"],"documentation":{"short":"Determines if the default and release branches are protected with GitHub's branch protection settings.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#branch-protection"}},{"name":"Security-Policy","score":0,"reason":"security policy file not detected","details":["Warn: no security policy file detected","Warn: no security file to analyze","Warn: no security file to analyze","Warn: no security file to analyze"],"documentation":{"short":"Determines if the project has published a security policy.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#security-policy"}},{"name":"SAST","score":0,"reason":"SAST tool is not run on all commits -- score normalized to 0","details":["Warn: 0 commits out of 25 are checked with a SAST tool"],"documentation":{"short":"Determines if the project uses static code analysis.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#sast"}},{"name":"Vulnerabilities","score":0,"reason":"18 existing vulnerabilities detected","details":["Warn: Project is vulnerable to: PYSEC-2019-124 / GHSA-38fc-9xqv-7f7q","Warn: Project is vulnerable to: PYSEC-2019-123 / GHSA-887w-45rq-vxgf","Warn: Project is vulnerable to: PYSEC-2022-238 / GHSA-h3qr-fjhm-jphw","Warn: Project is vulnerable to: GHSA-3ww4-gg4f-jr7f","Warn: Project is vulnerable to: GHSA-5cpq-8wj7-hf2v","Warn: Project is vulnerable to: GHSA-9v9h-cgj8-h64p","Warn: Project is vulnerable to: PYSEC-2018-52 / GHSA-fcf9-3qw3-gxmj","Warn: Project is vulnerable to: PYSEC-2021-62 / GHSA-hggm-jpg3-v476","Warn: Project is vulnerable to: GHSA-jm77-qphf-c4w8","Warn: Project is vulnerable to: GHSA-w7pp-m8wf-vj6r","Warn: Project is vulnerable to: GHSA-x4qr-2fvf-3mr5","Warn: Project is vulnerable to: PYSEC-2020-73","Warn: Project is vulnerable to: PYSEC-2021-437 / GHSA-5xp3-jfq3-5q8x","Warn: Project is vulnerable to: PYSEC-2020-173 / GHSA-gpvv-69j7-gwj8","Warn: Project is vulnerable to: PYSEC-2023-228 / GHSA-mq26-g339-26xf","Warn: Project is vulnerable to: PYSEC-2021-142 / GHSA-8q59-q68h-6hv4","Warn: Project is vulnerable to: PYSEC-2018-49 / GHSA-rprw-h62v-c2w7","Warn: Project is vulnerable to: PYSEC-2022-43017 / GHSA-qwmp-2cf2-g9g6"],"documentation":{"short":"Determines if the project has open, known unfixed vulnerabilities.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#vulnerabilities"}}]},"last_synced_at":"2025-08-18T10:06:05.662Z","repository_id":46082114,"created_at":"2025-08-18T10:06:05.662Z","updated_at":"2025-08-18T10:06:05.662Z"},"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":271436369,"owners_count":24759330,"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-08-21T02:00:08.990Z","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"},"tags":[]},"repo_metadata_updated_at":"2025-08-21T06:26:32.871Z","dependent_packages_count":1,"downloads":191,"downloads_period":"last-month","dependent_repos_count":1,"rankings":{"downloads":23.928438529794263,"dependent_repos_count":21.71838761843193,"dependent_packages_count":4.714065656226561,"stargazers_count":31.900032803175193,"forks_count":16.84944724620611,"docker_downloads_count":null,"average":19.82207437076681},"purl":"pkg:pypi/collate","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/pypi/collate","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/pypi/collate","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/pypi/collate/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2025-07-20T17:48:06.574Z","issues_count":19,"pull_requests_count":81,"avg_time_to_close_issue":12884241.263157895,"avg_time_to_close_pull_request":1124221.7808219178,"issues_closed_count":19,"pull_requests_closed_count":73,"pull_request_authors_count":8,"issue_authors_count":8,"avg_comments_per_issue":1.4210526315789473,"avg_comments_per_pull_request":1.6790123456790123,"merged_pull_requests_count":44,"bot_issues_count":0,"bot_pull_requests_count":6,"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,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/issues","maintainers":[{"login":"mbauman","count":16,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mbauman"},{"login":"rayidghani","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/rayidghani"},{"login":"jesteria","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/jesteria"}],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/collate/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/collate/version_numbers","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/collate/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/collate/related_packages","maintainers":[{"uuid":"dssg","login":"dssg","name":null,"email":null,"url":null,"packages_count":9,"html_url":"https://pypi.org/user/dssg/","role":null,"created_at":"2023-02-23T20:34:15.614Z","updated_at":"2023-02-23T20:34:15.614Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/maintainers/dssg/packages"}],"registry":{"name":"pypi.org","url":"https://pypi.org","ecosystem":"pypi","default":true,"packages_count":726146,"maintainers_count":308800,"namespaces_count":0,"keywords_count":238245,"github":"pypi","metadata":{"funded_packages_count":50579},"icon_url":"https://github.com/pypi.png","created_at":"2022-04-04T15:19:23.364Z","updated_at":"2025-09-08T05:32:36.857Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages","maintainers_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/maintainers","namespaces_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/namespaces"}}],"commits":{"id":550916,"full_name":"dssg/collate","default_branch":"master","committers":[{"name":"Eric Potash","email":"eric@k2co3.net","login":"potash","count":71},{"name":"Matt Bauman","email":"mbauman@gmail.com","login":null,"count":42},{"name":"pyup.io bot","email":"github-bot@pyup.io","login":"pyup-bot","count":39},{"name":"Matt Bauman","email":"mbauman@uchicago.edu","login":null,"count":5},{"name":"Tristan Crockett","email":"tristan.h.crockett@gmail.com","login":null,"count":4},{"name":"Kit Rodolfa","email":"shaycrk@gmail.com","login":null,"count":1},{"name":"Jesse London","email":"jesselondon@gmail.com","login":null,"count":1}],"total_commits":163,"total_committers":7,"total_bot_commits":0,"total_bot_committers":0,"mean_commits":23.285714285714285,"dds":0.5644171779141105,"past_year_committers":[],"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":"2023-10-25T13:58:41.151Z","last_synced_commit":"30d051f21c2374bc802ecde4a557a6347dfc9940","created_at":"2023-03-09T04:39:13.082Z","updated_at":"2023-10-25T13:58:41.151Z","commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-08T00:00:16.827Z","repositories_count":5483322,"commits_count":854270774,"contributors_count":31138750,"owners_count":908526,"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":"dssg/collate","html_url":"https://github.com/dssg/collate","last_synced_at":"2025-08-21T06:33:37.422Z","status":"error","issues_count":19,"pull_requests_count":81,"avg_time_to_close_issue":12884241.263157895,"avg_time_to_close_pull_request":1124221.7808219178,"issues_closed_count":19,"pull_requests_closed_count":73,"pull_request_authors_count":8,"issue_authors_count":8,"avg_comments_per_issue":1.4210526315789473,"avg_comments_per_pull_request":1.6790123456790123,"merged_pull_requests_count":44,"bot_issues_count":0,"bot_pull_requests_count":6,"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":"2023-05-14T10:51:25.644Z","updated_at":"2025-08-21T06:33:37.423Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/dssg%2Fcollate/issues","issue_labels_count":{"enhancement":2,"bug":1,"question":1},"pull_request_labels_count":{"dependencies":6},"issue_author_associations_count":{"MEMBER":8,"CONTRIBUTOR":8,"NONE":3},"pull_request_author_associations_count":{"CONTRIBUTOR":63,"MEMBER":11,"NONE":7},"issue_authors":{"mbauman":6,"thcrock":4,"shaycrk":3,"rayidghani":2,"harnav":1,"nanounanue":1,"avishekrk":1,"potash":1},"pull_request_authors":{"pyup-bot":51,"mbauman":10,"potash":9,"dependabot[bot]":6,"shaycrk":2,"jesteria":1,"kenben":1,"thcrock":1},"host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-03T00:00:08.273Z","repositories_count":10054150,"issues_count":30900719,"pull_requests_count":92695808,"authors_count":10570509,"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":"mbauman","count":16,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mbauman"},{"login":"rayidghani","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/rayidghani"},{"login":"jesteria","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/jesteria"}],"active_maintainers":[]},"events":{"total":{},"last_year":{}},"keywords":["triage"],"dependencies":[{"ecosystem":"pypi","filepath":"requirements.txt","sha":null,"kind":"manifest","created_at":"2022-08-28T19:11:03.974Z","updated_at":"2022-08-28T19:11:03.974Z","repository_link":"https://github.com/dssg/collate/blob/master/requirements.txt","dependencies":[{"id":3056592701,"package_name":"SQLAlchemy","ecosystem":"pypi","requirements":"==1.1.11","direct":true,"kind":"runtime","optional":false}]},{"ecosystem":"pypi","filepath":"requirements_dev.txt","sha":null,"kind":"manifest","created_at":"2022-08-28T19:11:04.250Z","updated_at":"2022-08-28T19:11:04.250Z","repository_link":"https://github.com/dssg/collate/blob/master/requirements_dev.txt","dependencies":[{"id":3056596789,"package_name":"pip","ecosystem":"pypi","requirements":"==9.0.1","direct":true,"kind":"development","optional":false},{"id":3056596790,"package_name":"bumpversion","ecosystem":"pypi","requirements":"==0.5.3","direct":true,"kind":"development","optional":false},{"id":3056596791,"package_name":"wheel","ecosystem":"pypi","requirements":"==0.29.0","direct":true,"kind":"development","optional":false},{"id":3056596792,"package_name":"watchdog","ecosystem":"pypi","requirements":"==0.8.3","direct":true,"kind":"development","optional":false},{"id":3056596793,"package_name":"flake8","ecosystem":"pypi","requirements":"==3.3.0","direct":true,"kind":"development","optional":false},{"id":3056596794,"package_name":"tox","ecosystem":"pypi","requirements":"==2.7.0","direct":true,"kind":"development","optional":false},{"id":3056596795,"package_name":"coverage","ecosystem":"pypi","requirements":"==4.4.1","direct":true,"kind":"development","optional":false},{"id":3056596796,"package_name":"Sphinx","ecosystem":"pypi","requirements":"==1.6.3","direct":true,"kind":"development","optional":false},{"id":3056596797,"package_name":"cryptography","ecosystem":"pypi","requirements":"==1.9","direct":true,"kind":"development","optional":false},{"id":3056596798,"package_name":"PyYAML","ecosystem":"pypi","requirements":"==3.12","direct":true,"kind":"development","optional":false},{"id":3056596799,"package_name":"pytest","ecosystem":"pypi","requirements":"==3.1.3","direct":true,"kind":"development","optional":false},{"id":3056596800,"package_name":"SQLAlchemy","ecosystem":"pypi","requirements":"==1.1.11","direct":true,"kind":"development","optional":false},{"id":3056596801,"package_name":"psycopg2","ecosystem":"pypi","requirements":"==2.7.1","direct":true,"kind":"development","optional":false},{"id":3056596802,"package_name":"csvkit","ecosystem":"pypi","requirements":"==1.0.2","direct":true,"kind":"development","optional":false},{"id":3056596803,"package_name":"codecov","ecosystem":"pypi","requirements":"==2.0.9","direct":true,"kind":"development","optional":false},{"id":3056596804,"package_name":"pytest-cov","ecosystem":"pypi","requirements":"==2.5.1","direct":true,"kind":"development","optional":false},{"id":3056596805,"package_name":"testing.postgresql","ecosystem":"pypi","requirements":"==1.3.0","direct":true,"kind":"development","optional":false},{"id":3056596806,"package_name":"pandas","ecosystem":"pypi","requirements":"*","direct":true,"kind":"development","optional":false}]}],"score":9.410992885454862,"created_at":"2025-09-08T11:18:41.748Z","updated_at":"2025-10-07T08:25:08.004Z","avatar_url":"https://github.com/dssg.png","language":"Python","category":null,"sub_category":null,"monthly_downloads":191,"funding_links":[],"readme_doi_urls":[],"works":{},"citation_counts":{},"total_citations":0,"keywords_from_contributors":[],"project_url":"https://science.ecosyste.ms/api/v1/projects/66261","html_url":"https://science.ecosyste.ms/projects/66261"}