Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Task

Name: Work Video:
Duration: 3 min 30 s
Description: Tao Yu, Rui Zhang, Kai Yang, Michihiro Yasunaga, Dongxu Wang, Zifan Li, James Ma, Irene Li, Qingning Yao, Shanelle Roman, Zilin Zhang, Dragomir Radev. Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing. 2018.
Tao Yu; Rui Zhang; Kai Yang; Michihiro Yasunaga; Dongxu Wang; Zifan Li; James Ma; Irene Li; Qingning Yao; Shanelle Roman; Zilin Zhang; Dragomir Radev
{'id': 'https://openalex.org/W2890431379', 'doi': 'https://doi.org/10.18653/v1/d18-1425', 'title': 'Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Task', 'display_name': 'Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Task', 'publication_year': 2018, 'publication_date': '2018-01-01', 'ids': {'openalex': 'https://openalex.org/W2890431379', 'doi': 'https://doi.org/10.18653/v1/d18-1425', 'mag': '2890431379'}, 'language': 'en', 'primary_location': {'is_oa': True, 'landing_page_url': 'https://doi.org/10.18653/v1/d18-1425', 'pdf_url': 'https://www.aclweb.org/anthology/D18-1425.pdf', 'source': {'id': 'https://openalex.org/S4363608991', 'display_name': 'Proceedings of the 2021 Conference on Empirical Methods in Natural Language Processing', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'conference'}, 'license': 'cc-by', 'license_id': 'https://openalex.org/licenses/cc-by', 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, 'type': 'article', 'type_crossref': 'proceedings-article', 'indexed_in': ['crossref'], 'open_access': {'is_oa': True, 'oa_status': 'hybrid', 'oa_url': 'https://www.aclweb.org/anthology/D18-1425.pdf', 'any_repository_has_fulltext': True}, 'authorships': [{'author_position': 'first', 'author': {'id': 'https://openalex.org/A5100664162', 'display_name': 'Tao Yu', 'orcid': 'https://orcid.org/0000-0003-2550-5008'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Tao Yu', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5100422092', 'display_name': 'Rui Zhang', 'orcid': 'https://orcid.org/0000-0002-8132-6250'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Rui Zhang', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5102720412', 'display_name': 'Kai Yang', 'orcid': 'https://orcid.org/0000-0002-3340-9377'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Kai Yang', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5005898634', 'display_name': 'Michihiro Yasunaga', 'orcid': 'https://orcid.org/0009-0003-3008-927X'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Michihiro Yasunaga', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5100433001', 'display_name': 'Dongxu Wang', 'orcid': 'https://orcid.org/0000-0002-4427-4412'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Dongxu Wang', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5067424300', 'display_name': 'Zifan Li', 'orcid': 'https://orcid.org/0000-0002-0830-0740'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Zifan Li', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5020010517', 'display_name': 'James Ma', 'orcid': 'https://orcid.org/0000-0001-7576-5532'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'James Ma', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5101537931', 'display_name': 'Irene Li', 'orcid': 'https://orcid.org/0000-0002-1851-5390'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Irene Li', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5054860845', 'display_name': 'Qingning Yao', 'orcid': None}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Qingning Yao', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5017230099', 'display_name': 'Shanelle Roman', 'orcid': None}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Shanelle Roman', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5101580150', 'display_name': 'Zilin Zhang', 'orcid': 'https://orcid.org/0000-0002-9179-9043'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Zilin Zhang', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}, {'author_position': 'last', 'author': {'id': 'https://openalex.org/A5081787254', 'display_name': 'Dragomir Radev', 'orcid': 'https://orcid.org/0000-0001-7830-6489'}, 'institutions': [{'id': 'https://openalex.org/I32971472', 'display_name': 'Yale University', 'ror': 'https://ror.org/03v76x132', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I32971472']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Dragomir Radev', 'raw_affiliation_strings': ['Department of Computer Science, Yale University'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer Science, Yale University', 'institution_ids': ['https://openalex.org/I32971472']}]}], 'institution_assertions': [], 'countries_distinct_count': 1, 'institutions_distinct_count': 1, 'corresponding_author_ids': [], 'corresponding_institution_ids': [], 'apc_list': None, 'apc_paid': None, 'fwci': 13.268, 'has_fulltext': True, 'fulltext_origin': 'pdf', 'cited_by_count': 505, 'citation_normalized_percentile': {'value': 0.857952, 'is_in_top_1_percent': False, 'is_in_top_10_percent': False}, 'cited_by_percentile_year': {'min': 99, 'max': 100}, 'biblio': {'volume': None, 'issue': None, 'first_page': None, 'last_page': None}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T10028', 'display_name': 'Topic Modeling', 'score': 0.9999, 'subfield': {'id': 'https://openalex.org/subfields/1702', 'display_name': 'Artificial Intelligence'}, 'field': {'id': 'https://openalex.org/fields/17', 'display_name': 'Computer Science'}, 'domain': {'id': 'https://openalex.org/domains/3', 'display_name': 'Physical Sciences'}}, 'topics': [{'id': 'https://openalex.org/T10028', 'display_name': 'Topic Modeling', 'score': 0.9999, 'subfield': {'id': 'https://openalex.org/subfields/1702', 'display_name': 'Artificial Intelligence'}, 'field': {'id': 'https://openalex.org/fields/17', 'display_name': 'Computer Science'}, 'domain': {'id': 'https://openalex.org/domains/3', 'display_name': 'Physical Sciences'}}, {'id': 'https://openalex.org/T10181', 'display_name': 'Natural Language Processing Techniques', 'score': 0.9998, 'subfield': {'id': 'https://openalex.org/subfields/1702', 'display_name': 'Artificial Intelligence'}, 'field': {'id': 'https://openalex.org/fields/17', 'display_name': 'Computer Science'}, 'domain': {'id': 'https://openalex.org/domains/3', 'display_name': 'Physical Sciences'}}, {'id': 'https://openalex.org/T12016', 'display_name': 'Web Data Mining and Analysis', 'score': 0.987, 'subfield': {'id': 'https://openalex.org/subfields/1710', 'display_name': 'Information Systems'}, 'field': {'id': 'https://openalex.org/fields/17', 'display_name': 'Computer Science'}, 'domain': {'id': 'https://openalex.org/domains/3', 'display_name': 'Physical Sciences'}}], 'keywords': [{'id': 'https://openalex.org/keywords/zhàng', 'display_name': 'Zhàng', 'score': 0.70621634}, {'id': 'https://openalex.org/keywords/distributional-semantics', 'display_name': 'Distributional semantics', 'score': 0.4324086}], 'concepts': [{'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.7487984}, {'id': 'https://openalex.org/C186644900', 'wikidata': 'https://www.wikidata.org/wiki/Q194152', 'display_name': 'Parsing', 'level': 2, 'score': 0.71762645}, {'id': 'https://openalex.org/C2777045944', 'wikidata': 'https://www.wikidata.org/wiki/Q12170198', 'display_name': 'Zhàng', 'level': 3, 'score': 0.70621634}, {'id': 'https://openalex.org/C204321447', 'wikidata': 'https://www.wikidata.org/wiki/Q30642', 'display_name': 'Natural language processing', 'level': 1, 'score': 0.6484809}, {'id': 'https://openalex.org/C154945302', 'wikidata': 'https://www.wikidata.org/wiki/Q11660', 'display_name': 'Artificial intelligence', 'level': 1, 'score': 0.61262226}, {'id': 'https://openalex.org/C2780451532', 'wikidata': 'https://www.wikidata.org/wiki/Q759676', 'display_name': 'Task (project management)', 'level': 2, 'score': 0.5503475}, {'id': 'https://openalex.org/C36503486', 'wikidata': 'https://www.wikidata.org/wiki/Q11235244', 'display_name': 'Domain (mathematical analysis)', 'level': 2, 'score': 0.5174325}, {'id': 'https://openalex.org/C510870499', 'wikidata': 'https://www.wikidata.org/wiki/Q47607', 'display_name': 'SQL', 'level': 2, 'score': 0.5145925}, {'id': 'https://openalex.org/C2778828372', 'wikidata': 'https://www.wikidata.org/wiki/Q5283209', 'display_name': 'Distributional semantics', 'level': 3, 'score': 0.4324086}, {'id': 'https://openalex.org/C199360897', 'wikidata': 'https://www.wikidata.org/wiki/Q9143', 'display_name': 'Programming language', 'level': 1, 'score': 0.35435367}, {'id': 'https://openalex.org/C130318100', 'wikidata': 'https://www.wikidata.org/wiki/Q2268914', 'display_name': 'Semantic similarity', 'level': 2, 'score': 0.17447278}, {'id': 'https://openalex.org/C191935318', 'wikidata': 'https://www.wikidata.org/wiki/Q148', 'display_name': 'China', 'level': 2, 'score': 0.09816474}, {'id': 'https://openalex.org/C95457728', 'wikidata': 'https://www.wikidata.org/wiki/Q309', 'display_name': 'History', 'level': 0, 'score': 0.093550116}, {'id': 'https://openalex.org/C33923547', 'wikidata': 'https://www.wikidata.org/wiki/Q395', 'display_name': 'Mathematics', 'level': 0, 'score': 0.088027805}, {'id': 'https://openalex.org/C127413603', 'wikidata': 'https://www.wikidata.org/wiki/Q11023', 'display_name': 'Engineering', 'level': 0, 'score': 0.0712105}, {'id': 'https://openalex.org/C134306372', 'wikidata': 'https://www.wikidata.org/wiki/Q7754', 'display_name': 'Mathematical analysis', 'level': 1, 'score': 0.0}, {'id': 'https://openalex.org/C166957645', 'wikidata': 'https://www.wikidata.org/wiki/Q23498', 'display_name': 'Archaeology', 'level': 1, 'score': 0.0}, {'id': 'https://openalex.org/C201995342', 'wikidata': 'https://www.wikidata.org/wiki/Q682496', 'display_name': 'Systems engineering', 'level': 1, 'score': 0.0}], 'mesh': [], 'locations_count': 2, 'locations': [{'is_oa': True, 'landing_page_url': 'https://doi.org/10.18653/v1/d18-1425', 'pdf_url': 'https://www.aclweb.org/anthology/D18-1425.pdf', 'source': {'id': 'https://openalex.org/S4363608991', 'display_name': 'Proceedings of the 2021 Conference on Empirical Methods in Natural Language Processing', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'conference'}, 'license': 'cc-by', 'license_id': 'https://openalex.org/licenses/cc-by', 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, {'is_oa': True, 'landing_page_url': 'https://arxiv.org/abs/1809.08887', 'pdf_url': 'https://arxiv.org/pdf/1809.08887', 'source': {'id': 'https://openalex.org/S4306400194', 'display_name': 'arXiv (Cornell University)', 'issn_l': None, 'issn': None, 'is_oa': True, 'is_in_doaj': False, 'is_core': False, 'host_organization': 'https://openalex.org/I205783295', 'host_organization_name': 'Cornell University', 'host_organization_lineage': ['https://openalex.org/I205783295'], 'host_organization_lineage_names': ['Cornell University'], 'type': 'repository'}, 'license': None, 'license_id': None, 'version': 'submittedVersion', 'is_accepted': False, 'is_published': False}], 'best_oa_location': {'is_oa': True, 'landing_page_url': 'https://doi.org/10.18653/v1/d18-1425', 'pdf_url': 'https://www.aclweb.org/anthology/D18-1425.pdf', 'source': {'id': 'https://openalex.org/S4363608991', 'display_name': 'Proceedings of the 2021 Conference on Empirical Methods in Natural Language Processing', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'conference'}, 'license': 'cc-by', 'license_id': 'https://openalex.org/licenses/cc-by', 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, 'sustainable_development_goals': [{'id': 'https://metadata.un.org/sdg/4', 'display_name': 'Quality education', 'score': 0.72}], 'grants': [], 'datasets': [], 'versions': [], 'referenced_works_count': 50, 'referenced_works': ['https://openalex.org/W1494362579', 'https://openalex.org/W1496189301', 'https://openalex.org/W1810532455', 'https://openalex.org/W1860267373', 'https://openalex.org/W1902237438', 'https://openalex.org/W2047237057', 'https://openalex.org/W2091671846', 'https://openalex.org/W2096979215', 'https://openalex.org/W2108598243', 'https://openalex.org/W2121465811', 'https://openalex.org/W2126170172', 'https://openalex.org/W2130942839', 'https://openalex.org/W2133564696', 'https://openalex.org/W2154268919', 'https://openalex.org/W2158396456', 'https://openalex.org/W2161002933', 'https://openalex.org/W2163274265', 'https://openalex.org/W2164155814', 'https://openalex.org/W2165382777', 'https://openalex.org/W2189089430', 'https://openalex.org/W2242083635', 'https://openalex.org/W2250225488', 'https://openalex.org/W2250701144', 'https://openalex.org/W2252123671', 'https://openalex.org/W2269738476', 'https://openalex.org/W2626990892', 'https://openalex.org/W2751448157', 'https://openalex.org/W2762513422', 'https://openalex.org/W2768409085', 'https://openalex.org/W2798663534', 'https://openalex.org/W2809324505', 'https://openalex.org/W2891000242', 'https://openalex.org/W2962713807', 'https://openalex.org/W2962728167', 'https://openalex.org/W2963357517', 'https://openalex.org/W2963545046', 'https://openalex.org/W2963617989', 'https://openalex.org/W2963655793', 'https://openalex.org/W2963748441', 'https://openalex.org/W2963794306', 'https://openalex.org/W2963866663', 'https://openalex.org/W2964271186', 'https://openalex.org/W2964308564', 'https://openalex.org/W2964315653', 'https://openalex.org/W2964325845', 'https://openalex.org/W3195542280', 'https://openalex.org/W4246375690', 'https://openalex.org/W4255584681', 'https://openalex.org/W4293350112', 'https://openalex.org/W4301674784'], 'related_works': ['https://openalex.org/W2389678104', 'https://openalex.org/W2387562377', 'https://openalex.org/W2384722335', 'https://openalex.org/W2380507695', 'https://openalex.org/W2376544228', 'https://openalex.org/W2375840727', 'https://openalex.org/W2375137083', 'https://openalex.org/W2371486229', 'https://openalex.org/W2367687999', 'https://openalex.org/W2364559953'], 'abstract_inverted_index': {'Tao': [0], 'Yu,': [1], 'Rui': [2], 'Zhang,': [3, 21], 'Kai': [4], 'Yang,': [5], 'Michihiro': [6], 'Yasunaga,': [7], 'Dongxu': [8], 'Wang,': [9], 'Zifan': [10], 'Li,': [11, 15], 'James': [12], 'Ma,': [13], 'Irene': [14], 'Qingning': [16], 'Yao,': [17], 'Shanelle': [18], 'Roman,': [19], 'Zilin': [20], 'Dragomir': [22], 'Radev.': [23], 'Proceedings': [24], 'of': [25], 'the': [26], '2018': [27], 'Conference': [28], 'on': [29], 'Empirical': [30], 'Methods': [31], 'in': [32], 'Natural': [33], 'Language': [34], 'Processing.': [35], '2018.': [36]}, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W2890431379', 'counts_by_year': [{'year': 2024, 'cited_by_count': 64}, {'year': 2023, 'cited_by_count': 130}, {'year': 2022, 'cited_by_count': 79}, {'year': 2021, 'cited_by_count': 113}, {'year': 2020, 'cited_by_count': 74}, {'year': 2019, 'cited_by_count': 30}], 'updated_date': '2024-12-20T06:54:59.502263', 'created_date': '2018-09-27'}
Publication Information

Basic Information

Access and Citation

AI Researcher Chatbot

Primary Location

Authors

Topics

Keywords

Related Works
