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!
How to
Comments (0)
API docs
Learn how to use Chi Data Buddy effectively! Here are a few example prompts, tips, and the documentation of available commands.
Example prompts
-
Prompt 1: "Retrieve the number of businesses in different categories, with optional filters on ward and year."
-
Prompt 2: "Retrieve total contract value, number of contracts, and average contract size for each department, filtered by year."
-
Prompt 3: "Retrieve murals data filtered by ward number, start year, and end year."
-
Prompt 4: "Retrieve the (up to) 50 most recently issued business licenses, with an optional filter on ward."
-
Prompt 5: "Retrieve vendors with the largest contracts filtered by department."
-
Prompt 6: "Retrieve recently completed service requests, with an optional filter on ward."
Features and commands
| Feature/Command | Description |
|---|---|
getBusinessCategories | This 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. |
departmentContracts | This 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. |
findMurals | Use 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. |
findNewBusinesses | With 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. |
largestContracts | Use 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. |
recentlyCompletedServiceRequests | This 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. |