{"id":37734,"name":"sql-ecology-lesson","description":"Data Management with SQL for Ecologists","url":"https://github.com/datacarpentry/sql-ecology-lesson","last_synced_at":"2025-09-05T07:32:06.668Z","repository":{"id":27129167,"uuid":"30597605","full_name":"datacarpentry/sql-ecology-lesson","owner":"datacarpentry","description":"Data Management with SQL for Ecologists","archived":false,"fork":false,"pushed_at":"2025-09-02T00:03:17.000Z","size":11219,"stargazers_count":52,"open_issues_count":47,"forks_count":147,"subscribers_count":16,"default_branch":"main","last_synced_at":"2025-09-02T02:25:21.059Z","etag":null,"topics":["carpentries","data-carpentry","data-wrangling","database","ecology","english","lesson","sql","stable"],"latest_commit_sha":null,"homepage":"http://datacarpentry.github.io/sql-ecology-lesson","language":null,"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/datacarpentry.png","metadata":{"files":{"readme":"README.md","changelog":"NEWS.md","contributing":"CONTRIBUTING.md","funding":null,"license":"LICENSE.md","code_of_conduct":"CODE_OF_CONDUCT.md","threat_model":null,"audit":null,"citation":"CITATION","codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":"AUTHORS","dei":null,"publiccode":null,"codemeta":null,"zenodo":".zenodo.json"},"funding":{"github":["carpentries"],"custom":["https://www.zeffy.com/en-US/donation-form/donate-to-make-a-difference-7497"]}},"created_at":"2015-02-10T15:07:29.000Z","updated_at":"2025-06-27T13:10:18.000Z","dependencies_parsed_at":"2022-09-01T00:01:19.179Z","dependency_job_id":"47dd99df-a7ea-4c70-a556-df29d918ba56","html_url":"https://github.com/datacarpentry/sql-ecology-lesson","commit_stats":{"total_commits":339,"total_committers":85,"mean_commits":3.988235294117647,"dds":0.911504424778761,"last_synced_commit":"c33bc663157fb5c0bfb07e211c00772c8e0dc692"},"previous_names":[],"tags_count":2,"template":false,"template_full_name":null,"purl":"pkg:github/datacarpentry/sql-ecology-lesson","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/datacarpentry%2Fsql-ecology-lesson","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/datacarpentry%2Fsql-ecology-lesson/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/datacarpentry%2Fsql-ecology-lesson/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/datacarpentry%2Fsql-ecology-lesson/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/datacarpentry","download_url":"https://codeload.github.com/datacarpentry/sql-ecology-lesson/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/datacarpentry%2Fsql-ecology-lesson/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":273727419,"owners_count":25157129,"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-05T02:00:09.113Z","response_time":402,"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":"datacarpentry","name":"Data Carpentry","uuid":"6666450","kind":"organization","description":"Workshops teaching scientists basic skills for retrieving, viewing, managing, and manipulating data in an open and reproducible way.","email":"team@carpentries.org","website":"https://datacarpentry.org/","location":null,"twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/6666450?v=4","repositories_count":89,"last_synced_at":"2023-03-13T13:55:49.004Z","metadata":{"has_sponsors_listing":false,"funding":{"github":["carpentries"],"custom":["https://www.zeffy.com/en-US/donation-form/donate-to-make-a-difference-7497"]}},"html_url":"https://github.com/datacarpentry","funding_links":["https://github.com/sponsors/carpentries","https://www.zeffy.com/en-US/donation-form/donate-to-make-a-difference-7497"],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-03T05:35:33.263Z","updated_at":"2023-03-13T13:55:49.124Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/datacarpentry","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/datacarpentry/repositories"},"packages":[],"commits":{"id":1327470,"full_name":"datacarpentry/sql-ecology-lesson","default_branch":"main","committers":[{"name":"Christina Koch","email":"christinakconnect@gmail.com","login":null,"count":30},{"name":"Ethan White","email":"ethan@weecology.org","login":"ethanwhite","count":27},{"name":"Timothée Poisot","email":"tim@poisotlab.io","login":null,"count":25},{"name":"Tracy Teal","email":"tracyt@idyll.org","login":null,"count":23},{"name":"Paula Andrea","email":"orchid00","login":"orchid00","count":22},{"name":"Francois Michonneau","email":"francois.michonneau@gmail.com","login":"fmichonneau","count":17},{"name":"Aleksandra Pawlik","email":"aleksandra.n.pawlik@gmail.com","login":null,"count":14},{"name":"Remi Rampin","email":"remirampin@gmail.com","login":null,"count":12},{"name":"Karen Cranston","email":"karen.cranston@gmail.com","login":null,"count":9},{"name":"Jaime Ashander","email":"jashander@ucdavis.edu","login":null,"count":9},{"name":"Kari L. Jordan","email":"kariljordan@carpentries.org","login":null,"count":8},{"name":"Carlos Martinez","email":"c.martinez@esciencecenter.nl","login":null,"count":8},{"name":"Maneesha Sane","email":"ahseenam@gmail.com","login":null,"count":7},{"name":"Jacqui Muller","email":"jacqui.jm77@gmail.com","login":null,"count":6},{"name":"James Foster","email":"38274066+jd-foster","login":"jd-foster","count":5},{"name":"amyehodge","email":"amyhodge@stanford.edu","login":null,"count":5},{"name":"Nicky Nicolson","email":"nicky.nicolson@gmail.com","login":null,"count":5},{"name":"Dave Jones","email":"dave@waveform.org.uk","login":null,"count":5},{"name":"Michel Heeremans","email":"michael.heeremans@geo.uio.no","login":null,"count":5},{"name":"Byron Smith","email":"me@byronjsmith.com","login":null,"count":4},{"name":"Fanie Riekert","email":"riekertsjpk@ufs.ac.za","login":null,"count":4},{"name":"Casey Youngflesh","email":"caseyyoungflesh","login":"caseyyoungflesh","count":4},{"name":"Jin","email":"jinchoi721@gmail.com","login":null,"count":3},{"name":"EmmanuelleRN","email":"emmanuellernunes@gmail.com","login":null,"count":3},{"name":"BJ Lougee","email":"almightybeeij@gmail.com","login":null,"count":3},{"name":"Josh Herr","email":"joshua.r.herr@gmail.com","login":null,"count":3},{"name":"Marchand","email":"marchanp@uqat.ca","login":null,"count":3},{"name":"Zhian N. Kamvar","email":"zkamvar@gmail.com","login":"zkamvar","count":3},{"name":"Adam Mansur","email":"mansura@si.edu","login":null,"count":2},{"name":"singlarohit","email":"rohit.singla1@gmail.com","login":null,"count":2},{"name":"Sam Bail","email":"samanthapbail@gmail.com","login":null,"count":2},{"name":"Lisa Ngo","email":"lngo@berkeley.edu","login":null,"count":2},{"name":"Erin Becker","email":"erinstellabecker@gmail.com","login":null,"count":2},{"name":"Christie Bahlai","email":"cbahlai@msu.edu","login":null,"count":2},{"name":"Greg Wilson","email":"gvwilson@software-carpentry.org","login":null,"count":2},{"name":"Auriel Fournier","email":"aurielfournier@gmail.com","login":null,"count":2},{"name":"Viviane Girardin","email":"47330181+vivigirardin","login":"vivigirardin","count":2},{"name":"Karthik Ram","email":"karthik.ram@gmail.com","login":"karthik","count":2},{"name":"Hilmar Lapp","email":"hlapp@drycafe.net","login":null,"count":1},{"name":"Jethro Johnson","email":"jjoh090@gmail.com","login":null,"count":1},{"name":"Dan Villa","email":"dan.villa@jax.org","login":null,"count":1},{"name":"Andrew Scheller","email":"github@loowis.durge.org","login":null,"count":1},{"name":"Juan Rodriguez Herrera","email":"j.herrera@epcc.ed.ac.uk","login":null,"count":1},{"name":"Kevin Foobar","email":"kevin@fu9ar.com","login":null,"count":1},{"name":"Christopher Medrela","email":"chris.medrela+github@gmail.com","login":null,"count":1},{"name":"Luis J. Villanueva","email":"villanueval@si.edu","login":null,"count":1},{"name":"Remi Rampin","email":"r@remirampin.com","login":null,"count":1},{"name":"Philipp Matthias Schäfer","email":"philipp.matthias.schaefer@posteo.de","login":null,"count":1},{"name":"Adrian Png","email":"adrian.png@fuzziebrain.com","login":null,"count":1},{"name":"Sophie Clayton","email":"sclayton@uw.edu","login":null,"count":1},{"name":"Sumana Harihareswara","email":"sumanah@panix.com","login":null,"count":1},{"name":"Nicola Soranzo","email":"nicola.soranzo@earlham.ac.uk","login":null,"count":1},{"name":"tatumhawkins","email":"tatumhawkins87@gmail.com","login":null,"count":1},{"name":"Sebastian Schmeier","email":"s.schmeier@gmail.com","login":null,"count":1},{"name":"Akima George","email":"asemone@umich.edu","login":null,"count":1},{"name":"Robert Davey","email":"robertdavey@carpentries.org","login":null,"count":1},{"name":"bathmer","email":"benedikt.athmer@gmail.com","login":null,"count":1},{"name":"emjonaitis","email":"jonaitis@wisc.edu","login":null,"count":1},{"name":"cjcenter","email":"calumcenter@gmail.com","login":null,"count":1},{"name":"jensmith3","email":"44028576+jensmith3","login":"jensmith3","count":1},{"name":"Dominic Bordelon","email":"dominicbordelon@gmail.com","login":null,"count":1},{"name":"yatang12","email":"138057065+yatang12","login":"yatang12","count":1},{"name":"ashander","email":"ashander","login":"ashander","count":1},{"name":"gaurav","email":"gaurav@ggvaidya.com","login":"gaurav","count":1},{"name":"drsjford","email":"79376938+drsjford","login":"drsjford","count":1},{"name":"The Carpentries Apprentice (beta)","email":"64428345+carpentries-bot","login":"carpentries-bot","count":1},{"name":"ShenmengXu","email":"93963343+ShenmengXu","login":"ShenmengXu","count":1},{"name":"drewfrobot","email":"24725355+drewfrobot","login":"drewfrobot","count":1},{"name":"Will Furnass","email":"will@thearete.co.uk","login":"willfurnass","count":1},{"name":"Xu Fei","email":"xuf12","login":"xuf12","count":1},{"name":"Amanda Devine","email":"devine.amanda.m@gmail.com","login":null,"count":1},{"name":"PH03N1X007","email":"32409852+PH03N1X007","login":"PH03N1X007","count":1},{"name":"Neil Bizzell","email":"NBizzell","login":"NBizzell","count":1},{"name":"JCSzamosi","email":"4465403+JCSzamosi","login":"JCSzamosi","count":1},{"name":"Fernando Rios","email":"zoidy","login":"zoidy","count":1},{"name":"Chris Wood","email":"wood-chris","login":"wood-chris","count":1},{"name":"Aditya Sarin","email":"aditya28sarin@gmail.com","login":null,"count":1},{"name":"Laurent Gatto","email":"lg390@cam.ac.uk","login":null,"count":1},{"name":"Moritz Neeb","email":"moritz.neeb@campus.tu-berlin.de","login":null,"count":1},{"name":"Saira Kazmi","email":"sairarizkaz@gmail.com","login":null,"count":1},{"name":"novica","email":"nnovica@gmail.com","login":null,"count":1},{"name":"Geoffrey Boushey","email":"Geoffrey.Boushey@ucsf.edu","login":null,"count":1},{"name":"henrykironde","email":"henrykironde@gmail.com","login":"henrykironde","count":1},{"name":"Ryan J. Gan","email":"68126014+Libraryan-prog","login":"Libraryan-prog","count":1},{"name":"Debbie B","email":"buehlerd","login":"buehlerd","count":1}],"total_commits":339,"total_committers":85,"total_bot_commits":0,"total_bot_committers":0,"mean_commits":3.988235294117647,"dds":0.911504424778761,"past_year_committers":[{"name":"James Foster","email":"38274066+jd-foster","login":"jd-foster","count":4},{"name":"Zhian N. Kamvar","email":"zkamvar@gmail.com","login":"zkamvar","count":3},{"name":"singlarohit","email":"rohit.singla1@gmail.com","login":null,"count":2},{"name":"Adam Mansur","email":"mansura@si.edu","login":null,"count":2},{"name":"EmmanuelleRN","email":"emmanuellernunes@gmail.com","login":null,"count":1},{"name":"drewfrobot","email":"24725355+drewfrobot","login":"drewfrobot","count":1},{"name":"yatang12","email":"138057065+yatang12","login":"yatang12","count":1},{"name":"Philipp Matthias Schäfer","email":"philipp.matthias.schaefer@posteo.de","login":null,"count":1},{"name":"JCSzamosi","email":"4465403+JCSzamosi","login":"JCSzamosi","count":1},{"name":"Robert Davey","email":"robertdavey@carpentries.org","login":null,"count":1},{"name":"ShenmengXu","email":"93963343+ShenmengXu","login":"ShenmengXu","count":1},{"name":"The Carpentries Apprentice (beta)","email":"64428345+carpentries-bot","login":"carpentries-bot","count":1}],"past_year_total_commits":19,"past_year_total_committers":12,"past_year_total_bot_commits":0,"past_year_total_bot_committers":0,"past_year_mean_commits":1.5833333333333333,"past_year_dds":0.7894736842105263,"last_synced_at":"2024-01-28T13:35:35.470Z","last_synced_commit":"c33bc663157fb5c0bfb07e211c00772c8e0dc692","created_at":"2023-09-11T16:22:16.854Z","updated_at":"2024-01-28T13:35:35.471Z","commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/datacarpentry%2Fsql-ecology-lesson/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-08-29T00:00:19.078Z","repositories_count":5479765,"commits_count":853309695,"contributors_count":31095220,"owners_count":906558,"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":"datacarpentry/sql-ecology-lesson","html_url":"https://github.com/datacarpentry/sql-ecology-lesson","last_synced_at":"2025-08-31T09:54:03.145Z","status":null,"issues_count":58,"pull_requests_count":51,"avg_time_to_close_issue":32503354.724137932,"avg_time_to_close_pull_request":9149424.586956521,"issues_closed_count":29,"pull_requests_closed_count":46,"pull_request_authors_count":33,"issue_authors_count":33,"avg_comments_per_issue":1.9137931034482758,"avg_comments_per_pull_request":1.0392156862745099,"merged_pull_requests_count":42,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":1,"past_year_pull_requests_count":4,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":254800.0,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":1,"past_year_pull_request_authors_count":4,"past_year_issue_authors_count":1,"past_year_avg_comments_per_issue":0.0,"past_year_avg_comments_per_pull_request":0.25,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":1,"created_at":"2023-09-11T16:22:51.872Z","updated_at":"2025-09-02T15:03:24.072Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/datacarpentry%2Fsql-ecology-lesson","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/datacarpentry%2Fsql-ecology-lesson/issues","issue_labels_count":{"help wanted":15,"type:enhancement":14,"status:in progress":10,"good first issue":8,"status:need more info":6,"type:discussion":5,"type:bug":3,"type:clarification":1},"pull_request_labels_count":{"type: template and tools":7,"status:wait":2,"type:template and tools":1,"status:need more info":1},"issue_author_associations_count":{"NONE":31,"CONTRIBUTOR":30,"MEMBER":2},"pull_request_author_associations_count":{"CONTRIBUTOR":50,"NONE":5,"MEMBER":2},"issue_authors":{"ChristinaLK":17,"maneesha":6,"MathildeMousset":5,"Talishask":3,"steltenpower":2,"tobyhodges":2,"adamancer":2,"brookbowers-uga":1,"sstevens2":1,"kyeater":1,"V-Sher":1,"Wang-Jing-NZ":1,"kevinworthington":1,"djb5":1,"jd-foster":1,"michaelshensky":1,"drewfrobot":1,"kekoziar":1,"megannibbs":1,"mostafizur67":1,"dmolesUC":1,"singlarohit":1,"kglibrarian":1,"skk74":1,"tracykteal":1,"ilmcconnell":1,"ErinBecker":1,"SebastianMosidi":1,"kristindawn":1,"annajiat":1,"sbhave77":1,"acsimonson":1,"bjbecerra":1},"pull_request_authors":{"ChristinaLK":7,"carpentries-bot":7,"jd-foster":4,"adamancer":4,"EmmanuelleRN":3,"spbail":3,"maneesha":2,"villanueval":2,"froggleston":1,"ltngo":1,"dmolesUC":1,"NBizzell":1,"drewfrobot":1,"emjonaitis":1,"fmichonneau":1,"ShenmengXu":1,"fiveop":1,"drsjford":1,"JCSzamosi":1,"Joe-Heffer-Shef":1,"Libraryan-prog":1,"dvdan-jgm":1,"chbrandt":1,"yatang12":1,"novica":1,"nsoranzo":1,"dojobo":1,"hshimon":1,"tobyhodges":1,"JacquiM":1,"steltenpower":1,"singlarohit":1,"aditya28sarin":1},"host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-03T00:00:08.273Z","repositories_count":10061380,"issues_count":31059648,"pull_requests_count":94180482,"authors_count":10686066,"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":{"type: template and tools":4},"past_year_issue_author_associations_count":{"NONE":1},"past_year_pull_request_author_associations_count":{"CONTRIBUTOR":5,"NONE":2},"past_year_issue_authors":{"dmolesUC":1},"past_year_pull_request_authors":{"carpentries-bot":4,"maneesha":1,"Joe-Heffer-Shef":1,"dmolesUC":1},"maintainers":[{"login":"tobyhodges","count":3,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/tobyhodges"},{"login":"fmichonneau","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/fmichonneau"}],"active_maintainers":[]},"events":{"total":{"IssuesEvent":1,"WatchEvent":5,"DeleteEvent":3,"IssueCommentEvent":12,"PushEvent":41,"PullRequestReviewEvent":8,"PullRequestReviewCommentEvent":9,"PullRequestEvent":8,"ForkEvent":4,"CreateEvent":5},"last_year":{"IssuesEvent":1,"WatchEvent":5,"DeleteEvent":3,"IssueCommentEvent":12,"PushEvent":41,"PullRequestReviewEvent":8,"PullRequestReviewCommentEvent":9,"PullRequestEvent":8,"ForkEvent":4,"CreateEvent":5}},"keywords":["carpentries","data-carpentry","data-wrangling","database","ecology","english","lesson","sql","stable"],"dependencies":[{"ecosystem":"rubygems","filepath":"Gemfile","sha":null,"kind":"manifest","created_at":"2022-09-01T00:01:19.064Z","updated_at":"2022-09-01T00:01:19.064Z","repository_link":"https://github.com/datacarpentry/sql-ecology-lesson/blob/main/Gemfile","dependencies":[{"id":3447471025,"package_name":"github-pages","ecosystem":"rubygems","requirements":"\u003e= 0","direct":true,"kind":"development","optional":false}]}],"score":9.037771106624906,"created_at":"2025-09-04T15:51:11.559Z","updated_at":"2025-10-07T08:15:30.724Z","avatar_url":"https://github.com/datacarpentry.png","language":null,"category":null,"sub_category":null,"monthly_downloads":0,"funding_links":["https://github.com/sponsors/carpentries","https://www.zeffy.com/en-US/donation-form/donate-to-make-a-difference-7497"],"readme_doi_urls":[],"works":{},"citation_counts":{},"total_citations":0,"keywords_from_contributors":["open-educational-resources","jekyll","github-pages","beta","metagenomics","prediction","pre-alpha","data-leakage","carpentries-incubator","bootstrapping"],"project_url":"https://science.ecosyste.ms/api/v1/projects/37734","html_url":"https://science.ecosyste.ms/projects/37734","bibtex_url":"https://science.ecosyste.ms/projects/37734/export.bibtex","apalike_url":"https://science.ecosyste.ms/projects/37734/export.apalike"}