{"id":58160,"name":"sql-humanities-lesson","description":"SQL for Humanities","url":"https://github.com/carpentries-incubator/sql-humanities-lesson","last_synced_at":"2025-09-05T15:05:47.050Z","repository":{"id":87821743,"uuid":"101793375","full_name":"carpentries-incubator/sql-humanities-lesson","owner":"carpentries-incubator","description":"SQL for Humanities","archived":false,"fork":false,"pushed_at":"2023-08-29T16:03:57.000Z","size":1741,"stargazers_count":6,"open_issues_count":8,"forks_count":0,"subscribers_count":4,"default_branch":"gh-pages","last_synced_at":"2025-09-02T03:42:13.586Z","etag":null,"topics":["alpha","carpentries","carpentries-incubator","data-wrangling","database","digital-humanities","english","lesson","sql"],"latest_commit_sha":null,"homepage":"https://carpentries-incubator.github.io/sql-humanities-lesson","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/carpentries-incubator.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},"funding":{"github":["carpentries"],"custom":["https://give.communityin.org/TheCarpentries"]}},"created_at":"2017-08-29T18:28:39.000Z","updated_at":"2023-08-29T16:04:05.000Z","dependencies_parsed_at":null,"dependency_job_id":"cb9f396c-d401-460d-bb22-a8fb2b4492d1","html_url":"https://github.com/carpentries-incubator/sql-humanities-lesson","commit_stats":null,"previous_names":[],"tags_count":1,"template":false,"template_full_name":null,"purl":"pkg:github/carpentries-incubator/sql-humanities-lesson","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/carpentries-incubator%2Fsql-humanities-lesson","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/carpentries-incubator%2Fsql-humanities-lesson/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/carpentries-incubator%2Fsql-humanities-lesson/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/carpentries-incubator%2Fsql-humanities-lesson/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/carpentries-incubator","download_url":"https://codeload.github.com/carpentries-incubator/sql-humanities-lesson/tar.gz/refs/heads/gh-pages","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/carpentries-incubator%2Fsql-humanities-lesson/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":273774747,"owners_count":25165740,"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":"carpentries-incubator","name":"carpentries-incubator","uuid":"53264631","kind":"organization","description":"","email":null,"website":null,"location":null,"twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/53264631?v=4","repositories_count":107,"last_synced_at":"2023-02-27T03:40:27.694Z","metadata":{"has_sponsors_listing":false,"funding":{"github":["carpentries"],"custom":["https://give.communityin.org/TheCarpentries"]}},"html_url":"https://github.com/carpentries-incubator","funding_links":["https://github.com/sponsors/carpentries","https://give.communityin.org/TheCarpentries"],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-10T13:05:59.233Z","updated_at":"2023-02-27T03:40:27.711Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/carpentries-incubator","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/carpentries-incubator/repositories"},"packages":[],"commits":{"id":8043293,"full_name":"carpentries-incubator/sql-humanities-lesson","default_branch":"gh-pages","committers":[{"name":"Greg Wilson","email":"gvwilson@software-carpentry.org","login":null,"count":98},{"name":"Francois Michonneau","email":"francois.michonneau@gmail.com","login":"fmichonneau","count":47},{"name":"Raniere Silva","email":"raniere@rgaiacs.com","login":"rgaiacs","count":40},{"name":"Ethan White","email":"ethan@weecology.org","login":"ethanwhite","count":34},{"name":"Tracy Teal","email":"tracyt@idyll.org","login":"tracykteal","count":31},{"name":"Timothée Poisot","email":"tim@poisotlab.io","login":null,"count":27},{"name":"Abigail Cabunoc","email":"abigail.cabunoc@gmail.com","login":"abbycabs","count":25},{"name":"Iain Emsley","email":"iain.emsley@kellogg.ox.ac.uk","login":null,"count":18},{"name":"Aleksandra Pawlik","email":"aleksandra.n.pawlik@gmail.com","login":"apawlik","count":17},{"name":"Jaime Ashander","email":"jashander@ucdavis.edu","login":"ashander","count":16},{"name":"Christina Koch","email":"christinakconnect@gmail.com","login":"ChristinaLK","count":9},{"name":"Carlos Martinez","email":"c.martinez@esciencecenter.nl","login":"c-martinez","count":8},{"name":"Paula Andrea","email":"orchid00","login":"orchid00","count":7},{"name":"Karen Cranston","email":"karen.cranston@gmail.com","login":"kcranston","count":7},{"name":"Erin Becker","email":"erinstellabecker@gmail.com","login":"ErinBecker","count":7},{"name":"Kari L. Jordan","email":"kariljordan@carpentries.org","login":"kariljordan","count":6},{"name":"Michel Heeremans","email":"michael.heeremans@geo.uio.no","login":"heereman","count":5},{"name":"Dave Jones","email":"dave@waveform.org.uk","login":"waveform80","count":5},{"name":"Nicky Nicolson","email":"nicky.nicolson@gmail.com","login":"nickynicolson","count":5},{"name":"Rémi Emonet","email":"remi.emonet@reverse--com.heeere","login":"twitwi","count":5},{"name":"Byron Smith","email":"me@byronjsmith.com","login":"bsmith89","count":4},{"name":"Casey Youngflesh","email":"caseyyoungflesh","login":"caseyyoungflesh","count":4},{"name":"Piotr Banaszkiewicz","email":"piotr@banaszkiewicz.org","login":"pbanaszkiewicz","count":4},{"name":"Fanie Riekert","email":"riekertsjpk@ufs.ac.za","login":"fanie-riekert","count":4},{"name":"Jin","email":"jinchoi721@gmail.com","login":"metajinomics","count":3},{"name":"BJ Lougee","email":"almightybeeij@gmail.com","login":"almightybeeij","count":3},{"name":"Erik Hanson","email":"hansonew@gmail.com","login":"ewhanson","count":3},{"name":"Hilmar Lapp","email":"hlapp@drycafe.net","login":"hlapp","count":3},{"name":"Josh Herr","email":"joshua.r.herr@gmail.com","login":"jrherr","count":3},{"name":"Auriel Fournier","email":"aurielfournier@gmail.com","login":"aurielfournier","count":2},{"name":"Christie Bahlai","email":"cbahlai@msu.edu","login":"cbahlai","count":2},{"name":"James Allen","email":"jamesallen0108@gmail.com","login":"jpallen","count":2},{"name":"Jon Pipitone","email":"jon.pipitone@utoronto.ca","login":"pipitone","count":2},{"name":"Karthik Ram","email":"karthik.ram@gmail.com","login":"karthik","count":2},{"name":"Maneesha Sane","email":"ahseenam@gmail.com","login":"maneesha","count":2},{"name":"Maxim Belkin","email":"maxim-belkin","login":"maxim-belkin","count":2},{"name":"Nick Young","email":"nbay92@gmail.com","login":"neon-ninja","count":2},{"name":"evanwill","email":"evanpeterw@gmail.com","login":"evanwill","count":2},{"name":"Gabriel A. Devenyi","email":"gdevenyi@gmail.com","login":"gdevenyi","count":1},{"name":"Laurent Gatto","email":"lg390@cam.ac.uk","login":"LaurentGatto","count":1},{"name":"henrykironde","email":"henrykironde@gmail.com","login":"henrykironde","count":1},{"name":"Xu Fei","email":"xuf12","login":"xuf12","count":1},{"name":"Will Furnass","email":"will@thearete.co.uk","login":"willfurnass","count":1},{"name":"Ian Carroll","email":"icarroll@sesync.org","login":null,"count":1},{"name":"Sebastian Schmeier","email":"s.schmeier@gmail.com","login":null,"count":1},{"name":"Moritz Neeb","email":"moritz.neeb@campus.tu-berlin.de","login":null,"count":1},{"name":"W. Trevor King","email":"wking@tremily.us","login":"wking","count":1},{"name":"Sumana Harihareswara","email":"sumanah@panix.com","login":"brainwane","count":1},{"name":"Michael Hansen","email":"hansen.mike@gmail.com","login":"synesthesiam","count":1},{"name":"Christopher Medrela","email":"chris.medrela+github@gmail.com","login":"chrismedrela","count":1},{"name":"Bill Mills","email":"mills.wj@gmail.com","login":"bkatiemills","count":1},{"name":"Adrian Png","email":"adrian.png@fuzziebrain.com","login":"fuzziebrain","count":1},{"name":"Akima George","email":"asemone@umich.edu","login":"ASGeorge","count":1},{"name":"Geoffrey Boushey","email":"Geoffrey.Boushey@ucsf.edu","login":"gboushey","count":1},{"name":"Jethro Johnson","email":"jjoh090@gmail.com","login":"jethrojohnson","count":1},{"name":"Kevin Foobar","email":"kevin@fu9ar.com","login":"kevin-vilbig","count":1},{"name":"Sophie Clayton","email":"sclayton@uw.edu","login":"sophieclayton","count":1},{"name":"Saira Kazmi","email":"sairarizkaz@gmail.com","login":"rizkaz","count":1},{"name":"Andrew Scheller","email":"github@loowis.durge.org","login":"lurch","count":1}],"total_commits":487,"total_committers":59,"total_bot_commits":0,"total_bot_committers":0,"mean_commits":8.254237288135593,"dds":0.7987679671457906,"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-06-02T15:26:15.898Z","last_synced_commit":"5a844fa98edb30cd62c84ccfe671727b6b5d358c","created_at":"2024-12-29T12:56:47.031Z","updated_at":"2025-06-02T15:27:24.903Z","commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/carpentries-incubator%2Fsql-humanities-lesson/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-05T00:00:10.343Z","repositories_count":5480019,"commits_count":853389012,"contributors_count":31098138,"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":"carpentries-incubator/sql-humanities-lesson","html_url":"https://github.com/carpentries-incubator/sql-humanities-lesson","last_synced_at":"2025-08-31T11:52:18.495Z","status":null,"issues_count":14,"pull_requests_count":2,"avg_time_to_close_issue":486037.6666666667,"avg_time_to_close_pull_request":287877.5,"issues_closed_count":6,"pull_requests_closed_count":2,"pull_request_authors_count":2,"issue_authors_count":4,"avg_comments_per_issue":0.35714285714285715,"avg_comments_per_pull_request":0.5,"merged_pull_requests_count":2,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":1,"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":1,"past_year_avg_comments_per_issue":0.0,"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":"2024-12-29T12:56:50.149Z","updated_at":"2025-08-31T11:52:18.496Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/carpentries-incubator%2Fsql-humanities-lesson","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/carpentries-incubator%2Fsql-humanities-lesson/issues","issue_labels_count":{"type:bug":1},"pull_request_labels_count":{},"issue_author_associations_count":{"COLLABORATOR":7,"NONE":6,"MEMBER":1},"pull_request_author_associations_count":{"CONTRIBUTOR":2},"issue_authors":{"iaine":7,"gperu":3,"luciamichielin":3,"tobyhodges":1},"pull_request_authors":{"ewhanson":1,"fmichonneau":1},"host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-05T00:00:10.444Z","repositories_count":10102346,"issues_count":31523475,"pull_requests_count":97727319,"authors_count":10703653,"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":{"MEMBER":1},"past_year_pull_request_author_associations_count":{},"past_year_issue_authors":{"tobyhodges":1},"past_year_pull_request_authors":{},"maintainers":[{"login":"iaine","count":7,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/iaine"},{"login":"tobyhodges","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/tobyhodges"}],"active_maintainers":[{"login":"tobyhodges","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/tobyhodges"}]},"events":{"total":{"IssuesEvent":1},"last_year":{"IssuesEvent":1}},"keywords":["alpha","carpentries","carpentries-incubator","data-wrangling","database","digital-humanities","english","lesson","sql"],"dependencies":[],"score":6.716594773520978,"created_at":"2025-09-04T15:51:34.647Z","updated_at":"2025-10-07T08:22:54.293Z","avatar_url":"https://github.com/carpentries-incubator.png","language":"Python","category":null,"sub_category":null,"monthly_downloads":0,"funding_links":["https://github.com/sponsors/carpentries","https://give.communityin.org/TheCarpentries"],"readme_doi_urls":[],"works":{},"citation_counts":{},"total_citations":0,"keywords_from_contributors":["stable","data-carpentry","ecology","metagenomics","carpentries-lab","bioinformatics","spreadsheet","helpwanted-list","carpentry-lesson","beta"],"project_url":"https://science.ecosyste.ms/api/v1/projects/58160","html_url":"https://science.ecosyste.ms/projects/58160","bibtex_url":"https://science.ecosyste.ms/projects/58160/export.bibtex","apalike_url":"https://science.ecosyste.ms/projects/58160/export.apalike"}