{"id":2669,"name":"easyaccess","description":"easyaccess: Enhanced SQL command line interpreter for astronomical surveys - Published in JOSS (2019)","url":"https://github.com/mgckind/easyaccess","last_synced_at":"2025-09-04T16:51:18.876Z","repository":{"id":26973019,"uuid":"30436568","full_name":"mgckind/easyaccess","owner":"mgckind","description":"SQL command line interpreter for astronomical surveys","archived":false,"fork":false,"pushed_at":"2022-06-21T21:10:58.000Z","size":4225,"stargazers_count":15,"open_issues_count":33,"forks_count":14,"subscribers_count":6,"default_branch":"master","last_synced_at":"2025-08-28T01:43:31.542Z","etag":null,"topics":["astronomy","interpreter","python","sql-query"],"latest_commit_sha":null,"homepage":"http://matias-ck.com/easyaccess/","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/mgckind.png","metadata":{"files":{"readme":"README.md","changelog":"CHANGES.md","contributing":"CONTRIBUTING.md","funding":null,"license":"LICENSE.txt","code_of_conduct":"CODE_OF_CONDUCT.md","threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":"AUTHORS.md","dei":null,"publiccode":null,"codemeta":null,"zenodo":null}},"created_at":"2015-02-06T22:46:56.000Z","updated_at":"2023-03-24T07:09:54.000Z","dependencies_parsed_at":"2022-08-24T15:06:32.594Z","dependency_job_id":null,"html_url":"https://github.com/mgckind/easyaccess","commit_stats":null,"previous_names":[],"tags_count":26,"template":false,"template_full_name":null,"purl":"pkg:github/mgckind/easyaccess","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mgckind%2Feasyaccess","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mgckind%2Feasyaccess/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mgckind%2Feasyaccess/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mgckind%2Feasyaccess/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/mgckind","download_url":"https://codeload.github.com/mgckind/easyaccess/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mgckind%2Feasyaccess/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":273517575,"owners_count":25119798,"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-03T02:00:09.631Z","response_time":76,"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":"mgckind","name":"Matias Carrasco Kind","uuid":"6931913","kind":"user","description":"Data Science Research Services @giesdsrs director at UIUC. Astrophysicist and former Senior Research Scientist at @ncsa","email":"","website":"matias-ck.com","location":"Champaign, IL","twitter":null,"company":"Gies College of Business","icon_url":"https://avatars.githubusercontent.com/u/6931913?u=bace13f31519feb467a8b3ab36f457c0cd4c4eb1\u0026v=4","repositories_count":34,"last_synced_at":"2023-08-26T15:30:50.578Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/mgckind","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-07T22:36:56.239Z","updated_at":"2023-08-26T15:30:50.853Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/mgckind","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/mgckind/repositories"},"packages":[],"commits":{"id":3529749,"full_name":"mgckind/easyaccess","default_branch":"master","committers":[{"name":"Matias Carrasco Kind","email":"mgckind@gmail.com","login":"mgckind","count":456},{"name":"Alex Drlica-Wagner","email":"kadrlica@fnal.gov","login":"kadrlica","count":84},{"name":"audreykoz","email":"audrey@koziol.cc","login":"audreykoz","count":59},{"name":"Matias Carrasco Kind","email":"Matias@mck-air.local","login":null,"count":23},{"name":"T. Andrew Manning","email":"manninga@illinois.edu","login":"manning-ncsa","count":9},{"name":"Matias Carrasco Kind","email":"Matias@wirelessprvnat-172-17-216-96.near.illinois.edu","login":null,"count":8},{"name":"madamow","email":"astromysz@gmail.com","login":"madamow","count":1}],"total_commits":640,"total_committers":7,"total_bot_commits":0,"total_bot_committers":0,"mean_commits":91.42857142857143,"dds":0.2875,"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":"2025-08-07T07:40:03.727Z","last_synced_commit":"c1cf082123094ec6435fb989d863825d294e461e","created_at":"2024-10-15T17:13:44.870Z","updated_at":"2025-08-07T07:40:03.728Z","commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/mgckind%2Feasyaccess/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-08-08T00:00:12.331Z","repositories_count":5415433,"commits_count":848633733,"contributors_count":30917352,"owners_count":904148,"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":"mgckind/easyaccess","html_url":"https://github.com/mgckind/easyaccess","last_synced_at":"2025-08-31T20:34:47.763Z","status":"error","issues_count":67,"pull_requests_count":37,"avg_time_to_close_issue":9747774.803278688,"avg_time_to_close_pull_request":695989.2222222222,"issues_closed_count":61,"pull_requests_closed_count":36,"pull_request_authors_count":2,"issue_authors_count":10,"avg_comments_per_issue":2.253731343283582,"avg_comments_per_pull_request":1.1081081081081081,"merged_pull_requests_count":33,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":1,"past_year_pull_requests_count":1,"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":1,"past_year_issue_authors_count":1,"past_year_avg_comments_per_issue":0.0,"past_year_avg_comments_per_pull_request":0.0,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":0,"created_at":"2024-10-15T17:13:45.237Z","updated_at":"2025-08-31T20:34:47.764Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/mgckind%2Feasyaccess","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/mgckind%2Feasyaccess/issues","issue_labels_count":{"enhancement":12,"installation":4,"bug":3,"question":1,"help wanted":1},"pull_request_labels_count":{},"issue_author_associations_count":{"OWNER":30,"COLLABORATOR":27,"NONE":10},"pull_request_author_associations_count":{"OWNER":20,"COLLABORATOR":18},"issue_authors":{"mgckind":30,"kadrlica":25,"richardgmcmahon":3,"erykoff":2,"beckermr":2,"hoyleb":1,"ehneilsen":1,"nsevilla":1,"bruno-moraes":1,"MatSmithAstro":1},"pull_request_authors":{"mgckind":20,"kadrlica":18},"host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-08-31T00:00:11.523Z","repositories_count":9891229,"issues_count":28890506,"pull_requests_count":82587873,"authors_count":8238428,"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":{"COLLABORATOR":1},"past_year_pull_request_author_associations_count":{"COLLABORATOR":2},"past_year_issue_authors":{"kadrlica":1},"past_year_pull_request_authors":{"kadrlica":2},"maintainers":[{"login":"mgckind","count":50,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mgckind"},{"login":"kadrlica","count":43,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/kadrlica"},{"login":"beckermr","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/beckermr"}],"active_maintainers":[{"login":"kadrlica","count":3,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/kadrlica"}]},"events":{"total":{"IssuesEvent":1,"IssueCommentEvent":1,"PullRequestEvent":1},"last_year":{"IssuesEvent":1,"IssueCommentEvent":1,"PullRequestEvent":1}},"keywords":["astronomy","interpreter","python","sql-query"],"dependencies":[{"ecosystem":"pypi","filepath":"setup.py","sha":null,"kind":"manifest","created_at":"2022-08-24T15:06:32.313Z","updated_at":"2022-08-24T15:06:32.313Z","repository_link":"https://github.com/mgckind/easyaccess/blob/master/setup.py","dependencies":[{"id":2523259236,"package_name":"pandas","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":2523259237,"package_name":"termcolor","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":2523259238,"package_name":"fitsio","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":2523259239,"package_name":"setuptools","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":2523259240,"package_name":"cx_Oracle","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":2523259241,"package_name":"numpy","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":2523259242,"package_name":"future","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":2523259243,"package_name":"requests","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false}]}],"score":5.817111159963204,"created_at":"2025-09-04T09:18:04.569Z","updated_at":"2025-10-07T08:04:41.367Z","avatar_url":"https://github.com/mgckind.png","language":"Python","category":"Scientific Software","sub_category":"Peer-reviewed","monthly_downloads":0,"funding_links":[],"readme_doi_urls":["https://doi.org/10.21105/joss.01022"],"works":{},"citation_counts":{},"total_citations":0,"keywords_from_contributors":[],"project_url":"https://science.ecosyste.ms/api/v1/projects/2669","html_url":"https://science.ecosyste.ms/projects/2669"}