Works, authors, awards, sources, institutions, funders, publishers, topics, concepts and reference lists.
Publisher: OpenAlex
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| id | string | https://openalex.org/W4415673682 |
| doi | string | https://doi.org/10.16929/ajas/11/2 |
| title | string | Galactic Gold Rush: The Promise and Perils of Mining Beyond |
| display_name | string | Galactic Gold Rush: The Promise and Perils of Mining Beyond |
| ids | map<string,string> | {openalex=https://openalex.org/W4415673682, doi=https://doi. |
| indexed_in | array<string> | [crossref] |
| publication_date | date | 2024-07-01 |
| publication_year | int | 2024 |
| language | string | en |
| type | string | paratext |
| authorships | array<struct<author:struct<display_name:string,id:string,orcid:string,observed_orcids:array<string>>,author_position:string,affiliations:array<struct<institution_ids:array<string>,raw_affiliation_string:string>>,countries:array<string>,raw_author_name:string,raw_orcid:string,is_corresponding:boolean,raw_affiliation_strings:array<string>,institutions:array<struct<country_code:string,display_name:string,id:string,lineage:array<string>,ror:string,type:string>>>> | [] |
| authors_count | int | 0 |
| corresponding_author_ids | array<string> | [] |
| corresponding_institution_ids | array<string> | [] |
| primary_topic | struct<id:string,display_name:string,score:float,subfield:struct<id:string,display_name:string>,field:struct<id:string,display_name:string>,domain:struct<id:string,display_name:string>> | {id=https://openalex.org/T12717, display_name=Space explorat |
| topics | array<struct<id:string,display_name:string,score:float,subfield:struct<id:string,display_name:string>,field:struct<id:string,display_name:string>,domain:struct<id:string,display_name:string>>> | [] |
| keywords | array<struct<id:string,display_name:string,score:float>> | [] |
| concepts | array<struct<id:string,wikidata:string,display_name:string,level:int,score:float>> | [] |
| locations | array<struct<id:string,doi:string,source:struct<id:string,display_name:string,issn_l:string,issn:array<string>,is_oa:boolean,is_in_doaj:boolean,is_core:boolean,listed_in:array<string>,host_organization:string,host_organization_name:string,host_organization_lineage:array<string>,host_organization_lineage_names:array<string>,type:string>,is_oa:boolean,is_published:boolean,landing_page_url:string,pdf_url:string,raw_source_name:string,raw_type:string,provenance:string,license:string,license_id:string,version:string,is_accepted:boolean>> | [{id=10.16929/ajas/11/2, doi=https://doi.org/10.16929/ajas/1 |
| locations_count | int | 2 |
| primary_location | struct<id:string,doi:string,source:struct<id:string,display_name:string,issn_l:string,issn:array<string>,is_oa:boolean,is_in_doaj:boolean,is_core:boolean,listed_in:array<string>,host_organization:string,host_organization_name:string,host_organization_lineage:array<string>,host_organization_lineage_names:array<string>,type:string>,is_oa:boolean,is_published:boolean,landing_page_url:string,pdf_url:string,raw_source_name:string,raw_type:string,provenance:string,license:string,license_id:string,version:string,is_accepted:boolean> | {id=10.16929/ajas/11/2, doi=https://doi.org/10.16929/ajas/11 |
| best_oa_location | struct<id:string,doi:string,source:struct<id:string,display_name:string,issn_l:string,issn:array<string>,is_oa:boolean,is_in_doaj:boolean,is_core:boolean,listed_in:array<string>,host_organization:string,host_organization_name:string,host_organization_lineage:array<string>,host_organization_lineage_names:array<string>,type:string>,is_oa:boolean,is_published:boolean,landing_page_url:string,pdf_url:string,raw_source_name:string,raw_type:string,provenance:string,license:string,license_id:string,version:string,is_accepted:boolean> | {id=null, doi=null, source=null, is_oa=null, is_published=nu |
| sustainable_development_goals | array<struct<id:string,display_name:string,score:double>> | [] |
| study_designs | array<struct<id:string,display_name:string>> | [] |
| awards | array<struct<id:string,display_name:string,funder_award_id:string,funder_id:string,funder_display_name:string>> | [] |
| funders | array<struct<id:string,display_name:string,ror:string>> | [] |
| institutions | array<struct<id:string,display_name:string,ror:string,country_code:string,type:string,lineage:array<string>>> | [] |
| countries_distinct_count | int | 0 |
| institutions_distinct_count | int | 0 |
| open_access | struct<is_oa:boolean,oa_status:string,any_repository_has_fulltext:boolean,oa_url:string> | {is_oa=false, oa_status=closed, any_repository_has_fulltext= |
| is_paratext | boolean | true |
| is_retracted | boolean | false |
| is_xpac | boolean | false |
| biblio | struct<volume:string,issue:string,first_page:string,last_page:string> | {volume=11, issue=2, first_page=null, last_page=null} |
| volume | struct<id:string,display_name:string> | |
| referenced_works | array<string> | [] |
| referenced_works_count | int | 0 |
| related_works | array<string> | [] |
| abstract_inverted_index | string | {"'Pluriversos": [0], "en": [1], "la": [2, 13, 20, 34, 40, 5 |
| cited_by_count | int | 0 |
| counts_by_year | array<struct<year:int,cited_by_count:int>> | [] |
| apc_list | struct<value:int,currency:string,value_usd:int> | {value=400, currency=BRL, value_usd=76} |
| apc_paid | struct<value:double,currency:string,value_usd:double> | {value=400.0, currency=BRL, value_usd=76.0} |
| fwci | double | 0.0 |
| citation_normalized_percentile | struct<value:double,is_in_top_1_percent:boolean,is_in_top_10_percent:boolean> | {value=0.12963242, is_in_top_1_percent=false, is_in_top_10_p |
| cited_by_percentile_year | struct<min:int,max:int> | {min=90, max=94} |
| mesh | array<struct<descriptor_ui:string,descriptor_name:string,qualifier_ui:string,qualifier_name:string,is_major_topic:boolean>> | [] |
| has_content | struct<pdf:boolean,grobid_xml:boolean> | {pdf=false, grobid_xml=false} |
| has_fulltext | boolean | false |
| created_date | timestamp | 2025-10-29 00:00:00.000 |
| updated_date | timestamp | 2025-10-29 00:00:00.000 |
| partition_date | string | 2025-10-29 |
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
-d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.