Department of Finance · City of Atlanta Open Checkbook (Socrata)

Employee Credit Card Data

Name: Employee Credit Card Data
Creator: Department of Finance

Currentdata updated Oct 5, 202613,399recordsReport a problem

This data set provides charges for all executive credit cards.

At a glance

Loading chart…

Preview

Loading rows…

Fields

Name	Label	Type
employee_name	Employee Name	string
expense_type	Expense Type	string
employee_id	Employee ID	string
cycle_date	Cycle Data	string
posting_date	Posting Date	date
merchant_name	Merchant Name	string
amount	Amount	number

Use this data

JSON API (same tools as MCP)

curl -s -X POST https://open-data-atl.vercel.app/api/tools/query_dataset \
  -H 'content-type: application/json' \
  -d '{"id":"atl-socrata-whg7-uci9","groupBy":["employee_name"],"aggregate":{"fn":"count"},"orderBy":[{"field":"count","direction":"desc"}],"limit":20}'

MCP client config

{
  "mcpServers": {
    "open-data-atl": {
      "type": "http",
      "url": "https://open-data-atl.vercel.app/api/mcp"
    }
  }
}

Ask your agent

Using the open-data-atl MCP server, describe_dataset "atl-socrata-whg7-uci9" and summarize what it contains.

Upstream API

https://atlanta.data.socrata.com/resource/whg7-uci9.json

Report a problem

Report an error for the maintainer to review. You can check its status on this site.

At a glance

Employee Credit Card Data: records by Expense Type

COURT COSTS INCLUDING ALIMONY AND CHILD SUPPORT3,610
Court Costs including Alimony and Child Support1,720
EATING PLACES RESTAURANTS1,481
DELTA750
GOVERNMENT SERVICES NOT ELSEWHERE CLASSIFIED541
LIMOUSINES AND TAXICABS497
QUICK PAYMENT SERVICE FAST-FOOD RESTAURANTS413
No MCC354
LODGING HOTELS MOTELS/ RESORTS297
AUTOMOBILE PARKING LOTS AND GARAGES282
BUSINESS SERVICES NOT ELSEWHERE CLASSIFIED210
MARRIOTT HOTELS192
DIRECT MARKETING CONTINUITY/SUBSCRIPTION MERCHANTS147
Delta108
ORGANIZATIONS CHARITABLE AND SOCIAL SERVICE103

Records (count)

Top 15 values.

View chart data

Employee Credit Card Data: records by Expense Type
Expense Type	Records (count)
COURT COSTS INCLUDING ALIMONY AND CHILD SUPPORT	3,610
Court Costs including Alimony and Child Support	1,720
EATING PLACES RESTAURANTS	1,481
DELTA	750
GOVERNMENT SERVICES NOT ELSEWHERE CLASSIFIED	541
LIMOUSINES AND TAXICABS	497
QUICK PAYMENT SERVICE FAST-FOOD RESTAURANTS	413
No MCC	354
LODGING HOTELS MOTELS/ RESORTS	297
AUTOMOBILE PARKING LOTS AND GARAGES	282
BUSINESS SERVICES NOT ELSEWHERE CLASSIFIED	210
MARRIOTT HOTELS	192
DIRECT MARKETING CONTINUITY/SUBSCRIPTION MERCHANTS	147
Delta	108
ORGANIZATIONS CHARITABLE AND SOCIAL SERVICE	103

Source: Department of Finance. Fetched Oct 30, 2026. Query

Loading chart…

Preview

First 10 rows. Fetched Oct 30, 2026.
employee_name	employee_id	cycle_date	posting_date	expense_type	merchant_name	amount
TAI D WHITE	36545	12/29/2023	2023-12-01T00:00:00.000	COURT COSTS INCLUDING ALIMONY AND CHILD SUPPORT	GAEFILE 013736116-0	25.72
TAI D WHITE	36545	12/29/2023	2023-12-01T00:00:00.000	COURT COSTS INCLUDING ALIMONY AND CHILD SUPPORT	GAEFILE 013736059-0	25.72
BALRAM BHEODARI	9995	12/29/2023	2023-12-04T00:00:00.000	AUTOMOBILE PARKING LOTS AND GARAGES	LANIER PARKING 21023900	425
TAI D WHITE	36545	12/29/2023	2023-12-04T00:00:00.000	BELLAGIO	BELLAGIO - ADV DEP	-266.44
TAI D WHITE	36545	12/29/2023	2023-12-04T00:00:00.000	BELLAGIO	BELLAGIO - ADV DEP	-209.75
EUGENE JOHNSON	9797	12/29/2023	2023-12-04T00:00:00.000	EATING PLACES RESTAURANTS	MARCUS BAR & GRILLE ATL	36.49
TAI D WHITE	36545	12/29/2023	2023-12-04T00:00:00.000	COURT COSTS INCLUDING ALIMONY AND CHILD SUPPORT	GAEFILE 013751131-0	25.72
DELANO RODRIGUES	40489	12/29/2023	2023-12-05T00:00:00.000	BARS/COCKTAIL LOUNGES/DISCOTHEQUES	BUFFALO WILD WNGS 0279	25.84
TAI D WHITE	36545	12/29/2023	2023-12-05T00:00:00.000	GOVERNMENT SERVICES NOT ELSEWHERE CLASSIFIED	GREEN COURT LEGAL TECHNO	3.92
TAI D WHITE	36545	12/29/2023	2023-12-05T00:00:00.000	COURT COSTS INCLUDING ALIMONY AND CHILD SUPPORT	GAEFILE 013757083-0	25.72

Loading rows…

Name

Label

Type

employee_name

Employee Name

string

expense_type

Expense Type

string

employee_id

Employee ID

string

cycle_date

Cycle Data

string

posting_date

Posting Date

date

merchant_name

Merchant Name

string

amount

Amount

number

Use this data

JSON API (same tools as MCP)

curl -s -X POST https://open-data-atl.vercel.app/api/tools/query_dataset \
  -H 'content-type: application/json' \
  -d '{"id":"atl-socrata-whg7-uci9","groupBy":["employee_name"],"aggregate":{"fn":"count"},"orderBy":[{"field":"count","direction":"desc"}],"limit":20}'

MCP client config

{
  "mcpServers": {
    "open-data-atl": {
      "type": "http",
      "url": "https://open-data-atl.vercel.app/api/mcp"
    }
  }
}

Ask your agent

Using the open-data-atl MCP server, describe_dataset "atl-socrata-whg7-uci9" and summarize what it contains.

Upstream API

https://atlanta.data.socrata.com/resource/whg7-uci9.json