{"id":169342,"name":null,"description":"A dagster ETL for collecting and cleaning PUDL usage metrics.","url":"https://github.com/catalyst-cooperative/pudl-usage-metrics","last_synced_at":"2025-09-09T21:02:03.554Z","repository":{"id":37623278,"uuid":"494207528","full_name":"catalyst-cooperative/pudl-usage-metrics","owner":"catalyst-cooperative","description":"A dagster ETL for collecting and cleaning PUDL usage metrics.","archived":false,"fork":false,"pushed_at":"2025-09-01T21:19:54.000Z","size":4972,"stargazers_count":2,"open_issues_count":18,"forks_count":0,"subscribers_count":6,"default_branch":"main","last_synced_at":"2025-09-01T21:27:34.260Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":null,"language":"Python","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"mit","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/catalyst-cooperative.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":".github/FUNDING.yml","license":"LICENSE","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,"notice":null,"maintainers":null,"copyright":null,"agents":null,"dco":null,"cla":null},"funding":{"open_collective":"catalyst-cooperative","custom":"https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick\u0026hosted_button_id=PZBZDFNKBJW5E\u0026source=url"}},"created_at":"2022-05-19T19:41:57.000Z","updated_at":"2025-09-01T19:53:17.000Z","dependencies_parsed_at":"2024-01-14T02:35:49.298Z","dependency_job_id":"5a1d93a2-928a-45b6-b23e-8d197930d82f","html_url":"https://github.com/catalyst-cooperative/pudl-usage-metrics","commit_stats":{"total_commits":255,"total_committers":7,"mean_commits":36.42857142857143,"dds":"0.43137254901960786","last_synced_commit":"460cc5d1a37fa09afe800dd6430eb1a1d9537ddd"},"previous_names":[],"tags_count":0,"template":false,"template_full_name":null,"purl":"pkg:github/catalyst-cooperative/pudl-usage-metrics","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/catalyst-cooperative%2Fpudl-usage-metrics","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/catalyst-cooperative%2Fpudl-usage-metrics/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/catalyst-cooperative%2Fpudl-usage-metrics/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/catalyst-cooperative%2Fpudl-usage-metrics/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/catalyst-cooperative","download_url":"https://codeload.github.com/catalyst-cooperative/pudl-usage-metrics/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/catalyst-cooperative%2Fpudl-usage-metrics/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":274363260,"owners_count":25271663,"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-09T02:00:10.223Z","response_time":80,"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":"catalyst-cooperative","name":"Catalyst Cooperative","uuid":"25487946","kind":"organization","description":"Catalyst is a small data engineering cooperative working on electricity regulation and climate change.","email":"hello@catalyst.coop","website":"https://catalyst.coop","location":"United States of America","twitter":"CatalystCoop","company":null,"icon_url":"https://avatars.githubusercontent.com/u/25487946?v=4","repositories_count":82,"last_synced_at":"2025-08-28T13:31:31.021Z","metadata":{"has_sponsors_listing":true},"html_url":"https://github.com/catalyst-cooperative","funding_links":["https://github.com/sponsors/catalyst-cooperative"],"total_stars":688,"followers":204,"following":0,"created_at":"2022-11-14T23:39:00.072Z","updated_at":"2025-08-28T13:31:31.022Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/catalyst-cooperative","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/catalyst-cooperative/repositories"},"packages":[],"commits":{"id":1346224,"full_name":"catalyst-cooperative/pudl-usage-metrics","default_branch":"main","committers":[{"name":"bendnorman","email":"bdn29@cornell.edu","login":"bendnorman","count":145},{"name":"Lord Business","email":"pudl@catalyst.coop","login":null,"count":54},{"name":"pre-commit-ci[bot]","email":"66853113+pre-commit-ci[bot]","login":"pre-commit-ci[bot]","count":23},{"name":"Zane Selvans","email":"zane.selvans@catalyst.coop","login":"zaneselvans","count":22},{"name":"dependabot[bot]","email":"49699333+dependabot[bot]","login":"dependabot[bot]","count":8},{"name":"John Xia","email":"dazhong.xia@catalyst.coop","login":"jdangerx","count":2},{"name":"Ben Norman","email":"bennett.norman@envelope.city","login":null,"count":1}],"total_commits":255,"total_committers":7,"total_bot_commits":31,"total_bot_committers":2,"mean_commits":36.42857142857143,"dds":0.43137254901960786,"past_year_committers":[{"name":"pre-commit-ci[bot]","email":"66853113+pre-commit-ci[bot]","login":"pre-commit-ci[bot]","count":12},{"name":"dependabot[bot]","email":"49699333+dependabot[bot]","login":"dependabot[bot]","count":2},{"name":"John Xia","email":"dazhong.xia@catalyst.coop","login":"jdangerx","count":2},{"name":"Bennett Norman","email":"bennett.norman@catalyst.coop","login":"bendnorman","count":1}],"past_year_total_commits":17,"past_year_total_committers":4,"past_year_total_bot_commits":14,"past_year_total_bot_committers":2,"past_year_mean_commits":4.25,"past_year_dds":0.2941176470588235,"last_synced_at":"2024-01-25T00:08:08.952Z","last_synced_commit":"460cc5d1a37fa09afe800dd6430eb1a1d9537ddd","created_at":"2023-09-12T09:56:19.775Z","updated_at":"2024-01-25T00:08:08.952Z","commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/catalyst-cooperative%2Fpudl-usage-metrics/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-09T00:17:06.873Z","repositories_count":5537301,"commits_count":874258671,"contributors_count":32257598,"owners_count":918899,"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":"catalyst-cooperative/pudl-usage-metrics","html_url":"https://github.com/catalyst-cooperative/pudl-usage-metrics","last_synced_at":"2025-09-09T11:15:38.334Z","status":null,"issues_count":42,"pull_requests_count":230,"avg_time_to_close_issue":6439238.647058823,"avg_time_to_close_pull_request":1938552.5751295337,"issues_closed_count":17,"pull_requests_closed_count":193,"pull_request_authors_count":7,"issue_authors_count":7,"avg_comments_per_issue":0.9761904761904762,"avg_comments_per_pull_request":0.3130434782608696,"merged_pull_requests_count":146,"bot_issues_count":2,"bot_pull_requests_count":200,"past_year_issues_count":16,"past_year_pull_requests_count":106,"past_year_avg_time_to_close_issue":348043.4,"past_year_avg_time_to_close_pull_request":82795.21348314607,"past_year_issues_closed_count":5,"past_year_pull_requests_closed_count":89,"past_year_pull_request_authors_count":5,"past_year_issue_authors_count":7,"past_year_avg_comments_per_issue":0.0,"past_year_avg_comments_per_pull_request":0.05660377358490566,"past_year_bot_issues_count":2,"past_year_bot_pull_requests_count":91,"past_year_merged_pull_requests_count":87,"created_at":"2023-09-12T09:56:31.858Z","updated_at":"2025-09-09T11:15:38.335Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/catalyst-cooperative%2Fpudl-usage-metrics","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/catalyst-cooperative%2Fpudl-usage-metrics/issues","issue_labels_count":{"inframundo":10,"Epic":5,"github_actions":4,"bug":3,"s3":3,"datasette":2,"superset":2,"zenodo":2,"dependencies":1,"github":1},"pull_request_labels_count":{"dependencies":142,"github_actions":13,"inframundo":9,"bug":5,"github":4,"kaggle":3,"s3":2,"zenodo":2},"issue_author_associations_count":{"MEMBER":40,"CONTRIBUTOR":2},"pull_request_author_associations_count":{"CONTRIBUTOR":200,"MEMBER":30},"issue_authors":{"bendnorman":28,"e-belfer":6,"jdangerx":3,"zaneselvans":2,"cmgosnell":1,"dependabot[bot]":1,"pre-commit-ci[bot]":1},"pull_request_authors":{"dependabot[bot]":142,"pre-commit-ci[bot]":58,"e-belfer":15,"bendnorman":10,"jdangerx":2,"zaneselvans":2,"cmgosnell":1},"host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-09T00:00:11.778Z","repositories_count":10197613,"issues_count":32264351,"pull_requests_count":101811900,"authors_count":10741277,"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":{"bug":2,"zenodo":2,"s3":1,"dependencies":1,"github_actions":1,"github":1},"past_year_pull_request_labels_count":{"dependencies":60,"github_actions":6,"bug":5,"github":4,"kaggle":3,"zenodo":2,"s3":1},"past_year_issue_author_associations_count":{"MEMBER":14,"CONTRIBUTOR":2},"past_year_pull_request_author_associations_count":{"CONTRIBUTOR":91,"MEMBER":15},"past_year_issue_authors":{"bendnorman":6,"e-belfer":4,"zaneselvans":2,"cmgosnell":1,"dependabot[bot]":1,"jdangerx":1,"pre-commit-ci[bot]":1},"past_year_pull_request_authors":{"dependabot[bot]":59,"pre-commit-ci[bot]":32,"e-belfer":13,"cmgosnell":1,"bendnorman":1},"maintainers":[{"login":"bendnorman","count":38,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/bendnorman"},{"login":"e-belfer","count":21,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/e-belfer"},{"login":"jdangerx","count":5,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/jdangerx"},{"login":"zaneselvans","count":4,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/zaneselvans"},{"login":"cmgosnell","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/cmgosnell"}],"active_maintainers":[{"login":"e-belfer","count":17,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/e-belfer"},{"login":"bendnorman","count":7,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/bendnorman"},{"login":"cmgosnell","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/cmgosnell"},{"login":"zaneselvans","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/zaneselvans"},{"login":"jdangerx","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/jdangerx"}]},"events":{"total":{"CreateEvent":55,"IssuesEvent":9,"WatchEvent":1,"DeleteEvent":55,"MemberEvent":1,"IssueCommentEvent":9,"PushEvent":144,"PullRequestReviewCommentEvent":20,"PullRequestReviewEvent":27,"PullRequestEvent":169},"last_year":{"CreateEvent":55,"IssuesEvent":9,"WatchEvent":1,"DeleteEvent":55,"MemberEvent":1,"IssueCommentEvent":9,"PushEvent":144,"PullRequestReviewCommentEvent":20,"PullRequestReviewEvent":27,"PullRequestEvent":169}},"keywords":[],"dependencies":[{"ecosystem":"actions","filepath":".github/workflows/bot-auto-merge.yml","sha":null,"kind":"manifest","created_at":"2023-02-12T07:02:05.530Z","updated_at":"2023-02-12T07:02:05.530Z","repository_link":"https://github.com/catalyst-cooperative/pudl-usage-metrics/blob/main/.github/workflows/bot-auto-merge.yml","dependencies":[{"id":7575670214,"package_name":"ridedott/merge-me-action","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/load-metrics.yml","sha":null,"kind":"manifest","created_at":"2023-02-12T07:02:05.696Z","updated_at":"2023-02-12T07:02:05.696Z","repository_link":"https://github.com/catalyst-cooperative/pudl-usage-metrics/blob/main/.github/workflows/load-metrics.yml","dependencies":[{"id":7575670668,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":7575670669,"package_name":"google-github-actions/auth","ecosystem":"actions","requirements":"v1","direct":true,"kind":"composite","optional":false},{"id":7575670670,"package_name":"conda-incubator/setup-miniconda","ecosystem":"actions","requirements":"v2.2.0","direct":true,"kind":"composite","optional":false},{"id":7575670671,"package_name":"haythem/public-ip","ecosystem":"actions","requirements":"v1.3","direct":true,"kind":"composite","optional":false},{"id":7575670672,"package_name":"8398a7/action-slack","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/pre-commit-ci-auto-merge.yaml","sha":null,"kind":"manifest","created_at":"2023-02-12T07:02:05.778Z","updated_at":"2023-02-12T07:02:05.778Z","repository_link":"https://github.com/catalyst-cooperative/pudl-usage-metrics/blob/main/.github/workflows/pre-commit-ci-auto-merge.yaml","dependencies":[{"id":7575671233,"package_name":"ridedott/merge-me-action","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/tox-pytest.yml","sha":null,"kind":"manifest","created_at":"2023-02-12T07:02:05.973Z","updated_at":"2023-02-12T07:02:05.973Z","repository_link":"https://github.com/catalyst-cooperative/pudl-usage-metrics/blob/main/.github/workflows/tox-pytest.yml","dependencies":[{"id":7575673403,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":7575673405,"package_name":"conda-incubator/setup-miniconda","ecosystem":"actions","requirements":"v2.2.0","direct":true,"kind":"composite","optional":false},{"id":7575673407,"package_name":"google-github-actions/auth","ecosystem":"actions","requirements":"v1","direct":true,"kind":"composite","optional":false},{"id":7575673409,"package_name":"codecov/codecov-action","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":7575673410,"package_name":"8398a7/action-slack","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"pypi","filepath":"setup.py","sha":null,"kind":"manifest","created_at":"2023-02-12T07:02:06.629Z","updated_at":"2023-02-12T07:02:06.629Z","repository_link":"https://github.com/catalyst-cooperative/pudl-usage-metrics/blob/main/setup.py","dependencies":[{"id":7575677560,"package_name":"pandas","ecosystem":"pypi","requirements":"\u003e=1.4,\u003c1.5","direct":true,"kind":"runtime","optional":false},{"id":7575677561,"package_name":"sqlalchemy","ecosystem":"pypi","requirements":"\u003e=1.4,\u003c2","direct":true,"kind":"runtime","optional":false},{"id":7575677562,"package_name":"dagster","ecosystem":"pypi","requirements":"\u003e=0.15,\u003c1.2","direct":true,"kind":"runtime","optional":false},{"id":7575677563,"package_name":"dagit","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":7575677564,"package_name":"dagster-pandera","ecosystem":"pypi","requirements":"\u003e=0.15,\u003c0.18","direct":true,"kind":"runtime","optional":false},{"id":7575677565,"package_name":"pandas-gbq","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":7575677566,"package_name":"pydata-google-auth","ecosystem":"pypi","requirements":"\u003e=1.3,\u003c1.5","direct":true,"kind":"runtime","optional":false},{"id":7575677567,"package_name":"jupyterlab","ecosystem":"pypi","requirements":"\u003e=3.2.8,\u003c3.5.0","direct":true,"kind":"runtime","optional":false},{"id":7575677568,"package_name":"psycopg2","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":7575677569,"package_name":"ipinfo","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":7575677570,"package_name":"joblib","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":7575677571,"package_name":"matplotlib","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":7575677572,"package_name":"pytest","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":7575677573,"package_name":"pg8000","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":7575677574,"package_name":"cloud-sql-python-connector","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false}]},{"ecosystem":"pypi","filepath":"pyproject.toml","sha":null,"kind":"manifest","created_at":"2023-09-23T05:08:13.340Z","updated_at":"2023-09-23T05:08:13.340Z","repository_link":"https://github.com/catalyst-cooperative/pudl-usage-metrics/blob/main/pyproject.toml","dependencies":[]},{"ecosystem":"conda","filepath":"environment.yml","sha":null,"kind":"manifest","created_at":"2024-01-14T02:35:47.613Z","updated_at":"2024-01-14T02:35:47.613Z","repository_link":"https://github.com/catalyst-cooperative/pudl-usage-metrics/blob/main/environment.yml","dependencies":[{"id":15597930244,"package_name":"jupyter_contrib_nbextensions","ecosystem":"conda","requirements":"~=0.5","direct":true,"kind":"runtime","optional":false},{"id":15597930245,"package_name":"pip","ecosystem":"conda","requirements":"\u003e=21,\u003c23","direct":true,"kind":"runtime","optional":false},{"id":15597930246,"package_name":"pre-commit","ecosystem":"conda","requirements":"~=2.9","direct":true,"kind":"runtime","optional":false},{"id":15597930247,"package_name":"python","ecosystem":"conda","requirements":"\u003e=3.10,\u003c3.11","direct":true,"kind":"runtime","optional":false},{"id":15597930248,"package_name":"setuptools","ecosystem":"conda","requirements":"\u003c62","direct":true,"kind":"runtime","optional":false}]}],"score":4.941642422609304,"created_at":"2025-09-09T01:22:33.443Z","updated_at":"2025-10-07T08:39:40.669Z","avatar_url":"https://github.com/catalyst-cooperative.png","language":"Python","category":null,"sub_category":null,"monthly_downloads":0,"funding_links":["https://opencollective.com/catalyst-cooperative","https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick\u0026hosted_button_id=PZBZDFNKBJW5E\u0026source=url"],"readme_doi_urls":[],"works":{},"citation_counts":{},"total_citations":0,"keywords_from_contributors":["archiving","emissions","cems","climate","coal","ddj","eia","eia860","eia923","epa"],"project_url":"https://science.ecosyste.ms/api/v1/projects/169342","html_url":"https://science.ecosyste.ms/projects/169342"}