Logo and icon for Chi Data Buddy, a ChatGPT plugin with description: Chicago data from the City of Chicago Data Portal.. Find out more on Plugin Surf, the best plugin database.

Chi Data Buddy

Chicago data from the City of Chicago Data Portal.

Chicago Data Buddy is a plugin that fetches Chicago data from the City of Chicago Data Portal. Users can learn more about the Chicago Data Portal at https://data.cityofchicago.org/. Although the text data is occasionally formatted incorrectly, some slight cleaning may be needed before data is provided to users. Not all information returned may be interesting to the user, so they can focus on relevant fields and ignore others. With Chi Data Buddy, users can stay informed and gain insight about Chicago regardless of where they are!

Learn how to use Chi Data Buddy effectively! Here are a few example prompts, tips, and the documentation of available commands.

Example prompts

  1. Prompt 1: "Retrieve the number of businesses in different categories, with optional filters on ward and year."

  2. Prompt 2: "Retrieve total contract value, number of contracts, and average contract size for each department, filtered by year."

  3. Prompt 3: "Retrieve murals data filtered by ward number, start year, and end year."

  4. Prompt 4: "Retrieve the (up to) 50 most recently issued business licenses, with an optional filter on ward."

  5. Prompt 5: "Retrieve vendors with the largest contracts filtered by department."

  6. Prompt 6: "Retrieve recently completed service requests, with an optional filter on ward."

Features and commands

Feature/CommandDescription
getBusinessCategoriesThis command allows you to retrieve the number of businesses in different categories. You can apply optional filters on the ward and year. It provides information about the category of the business activity and the number of businesses in that category.
departmentContractsThis command retrieves information about the total contract value, number of contracts, and average contract size for each department. You can filter the results by year.
findMuralsUse this command to retrieve murals data filtered by ward number, start year, and end year. It returns information about the artists credited for the murals, artwork titles, location coordinates, street address, ward number, installation year, and restoration year if applicable.
findNewBusinessesWith this command, you can retrieve the most recently issued business licenses, up to 50 licenses. You can apply an optional filter on the ward. It provides information about the date the license was issued and the name of the business.
largestContractsUse this command to retrieve vendors with the largest contracts, filtered by department. It returns information about the vendor name and the sum of the award amount for their contracts in the specified department.
recentlyCompletedServiceRequestsThis command allows you to retrieve recently completed service requests. You can apply an optional filter on the ward. It provides information about the completion date, creation date, service request number, service request type, and the street address where the request was made.

Configuration

User authenticationNo user authentication
API documentation

For AI

Namechicago_data_portal
DescriptionChicago data from the City of Chicago Data Portal. Users can learn more about the Chicago Data Portal is at https://data.cityofchicago.org/. Text data is occasionally formatted incorrectly (all caps, punctuation or space issues, etc.), so may need slight cleaning before provided to users. Not all information returned may be interesting to the user, so feel free to focus on relevant fields and let the user know what other fields exist.

Updates

First added20 June 2023

Similar plugins