> ## Content Index > Fetch the complete content index at: https://expected-parrot.ghost.io/llms.txt > Use this file to discover other available public pages before exploring further. # How to retrieve, combine & query your saved results with SQL - URL: https://expected-parrot.ghost.io/how-to-retrieve-combine-and-query/ - Published: 2025-05-12T14:28:33.000Z - Updated: 2026-10-17T15:55:20.000Z - Description: Quick methods for accessing and analyzing your automatically stored results from anywhere. - Author: John Horton - Tags: Newsletter, #Migrated-1792252444613, #Import 2026-10-17 15:54 When you run a [survey](https://docs.expectedparrot.com/en/latest/surveys.html?ref=expected-parrot.ghost.io) at Expected Parrot the [results](https://docs.expectedparrot.com/en/latest/results.html?ref=expected-parrot.ghost.io) are automatically stored at your [Coop](https://www.expectedparrot.com/login?ref=expected-parrot.ghost.io) account where you can [view, share and export](https://docs.expectedparrot.com/en/latest/coop.html?ref=expected-parrot.ghost.io) them at any time. You can also retrieve them at your workspace to analyze them locally using a variety of [built-in methods](https://docs.expectedparrot.com/en/latest/results.html?ref=expected-parrot.ghost.io#creating-tables-by-selecting-columns) for working with results. Below we share some quick examples of methods for retrieving multiple sets of results at once, combining them, and analyzing them with SQL queries. This can be useful when you are re-running an experiment with different AI agents and/or language models, or want to compare fresh responses over time. [Subscribe](#/portal/signup) # Retrieving saved results When you run an [EDSL](https://github.com/expectedparrot/edsl?ref=expected-parrot.ghost.io) survey, details about the survey job and results are displayed in your workspace while the job is running (you can also hide this output by passing `verbose=False`): ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/e5a2b14a-06dc-4394-9f18-0c85f6b47a7e_1652x704.png) ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/7b83cb2d-f85a-414b-a699-2ef0cb84f92e_1614x1192.png) When the job is completed the results are automatically stored at your Coop account, where you can view, organize, share and export them (a link to Results is in the job status details shown above): ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/3858b319-0a23-4d0a-88cb-9538866c631b_2650x1226.png) You can retrieve stored results at any time by passing the unique identifier to the `pull` method: ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/8ed68c79-aa0d-4db8-b0d4-06f546ff2790_1650x80.png) You can also give the results a unique alias, if desired: ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/deb188bd-7114-47f5-a67b-97a1a02d0af1_2656x1422.png) This allows you to retrieve by alias instead: ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/67179ae1-d80f-401f-a8ab-f9f58ca154c5_1652x76.png) # Multiple results If you want to retrieve several sets of results at once you can use the `list` method to identify and select them. For example, say you reran the survey above multiple times with different models: ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/eaafc438-4bb8-4178-8678-09fa92f42d58_1650x226.png) You can then specify which results to retrieve, e.g., the 3 most recent: ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/acbc2aab-1f9f-4fb7-ad66-eed40e124317_1650x156.png) ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/d41ed025-27cd-4f09-9d9a-d38ade3a48a8_2544x508.png) The `page` specifies which set of 10 objects to look back to (1 by default, the most recent page) and `page_size` specifies how many objects to return (10 by default). If you want to search results by survey job status or description instead you can call the method on `Jobs` (all parameters are optional): ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/e4c6de63-d261-4244-aea9-0d0c657e33da_1652x152.png) Once you’ve identified the relevant jobs or results you can use the fetch methods for instantiating the results. These are equivalent: ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/a255a24e-3c02-436e-8c62-74d33c449b31_1652x154.png) This returns a list of results objects. You can combine them to analyze them together (the columns must be identical): ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/893f6e72-9ab1-49e9-ba39-4230427baff7_1652x78.png) # Methods for analyzing results Now all of the methods for working with results are available to us. For example, you can use the `sql` method to run queries on the combined results: ![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/013c3dcb-72dc-40a3-9658-b14927616f93_1654x1200.png) If you want to share an analysis, or a notebook of code for reproducing it, you can post that to Coop as well: [![](https://storage.ghost.io/c/bc/8c/bc8c40e2-e3d8-4888-8bb9-3276553ff8a4/content/images/2026/10/5bced425-513e-4442-b9cf-63415563faf1_1654x630.png)](https://www.expectedparrot.com/content/RobinHorton/sql-example-notebook?ref=expected-parrot.ghost.io) Please see our [docs](https://docs.expectedparrot.com/en/latest?ref=expected-parrot.ghost.io) for more examples of analytical methods and instructions for [getting started](https://www.expectedparrot.com/getting-started?ref=expected-parrot.ghost.io). If you don’t see a method that you need, please post a message at our [Discord channel](https://discord.com/invite/mxAYkjfy9m?ref=expected-parrot.ghost.io) or [send us an email](mailto:info@expectedparrot.com) to request it. [Subscribe](#/portal/signup)