NYSgptData LibraryConnectPricing

Employee benefit plans (Form 5500)

Annual returns of employee benefit plans with all schedules and column layouts, plan years 1999 to 2025.

197MRecords
94Tables
2,139Fields
CurrentYears

Publisher: U.S. Department of Labor, Employee Benefits Security Administration

Try it

This runs against the full table, free, with no key.

Tables
dol_f_sch_d_part236.2Mdol_f_sch_d_part130.3Mdol_f_sch_a_part114.3Mdol_f_550014.1Mdol_f_sch_c_part1_item2_codes12.6Mdol_f_sch_c_part1_item3_codes11.5Mdol_f_5500_sf10.9Mdol_f_sch_a10.9Mdol_f_sch_i8.5Mdol_f_sch_r7.4Mdol_f_sch_c_part1_item35.7Mdol_f_sch_p5.4Mdol_f_sch_c_part1_item24.9Mdol_f_sch_t4.4Mdol_f_sch_d3.8Mdol_f_sch_h2.9Mdol_f_sch_c_part1_item12.9Mdol_f_sch_c2.4Mdol_f_sch_c_part12.2Mdol_f_sch_sb_part11.8Mdol_f_sch_sb757Kdol_f_sch_c_part2715Kdol_f_sch_mep_part2497Kdol_f_sch_b478Kdol_f_nonstandard254Kdol_f_sch_r_part1170Kdol_f_sch_sb_actv_part_data163Kdol_f_sch_h_part1134Kdol_f_sch_c_part3115Kdol_f_5500_sf_part7105Kdol_f_sch_mb_part166.4Kdol_f_sch_g_part362.8Kdol_f_sch_g_part160.3Kdol_f_sch_g45.5Kdol_f_sch_mb_part240.2Kdol_f_sch_g_part239.1Kdol_f_sch_c_part2_codes34.7Kdol_f_sch_mb24.2Kdol_f_sch_sb_expect_ben_paymts23.6Kdol_f_sch_i_part115.5Kdol_f_sch_mep15Kdol_f_sch_mb_actv_part_data13.5Kdol_f_sch_h_layout4.1Kdol_f_sch_mb_proj_exp_benef_pay3.2Kdol_f_5500_layout3.1Kdol_f_5500_sf_layout2.8Kdol_f_sch_a_layout2.3Kdol_f_sch_mb_layout2.2Kdol_f_sch_b_layout2.1Kdol_f_sch_sb_layout2Kdol_f_sch_i_layout2Kdol_f_sch_mb_withd_liab_amt1.4Kdol_f_sch_mb_emp_cont_with_liab1.4Kdol_f_sch_r_layout1.1Kdol_f_sch_g_part1_layout591dol_f_sch_a_part1_layout510dol_f_sch_dcg469dol_f_sch_c_part2_layout466dol_f_sch_c_part1_item2_layout391dol_f_sch_g_part2_layout391dol_f_sch_g_part3_layout391dol_f_sch_dcg_layout359dol_f_sch_c_part1_item3_layout340dol_f_sch_c_part3_layout338dol_f_sch_t_layout334dol_f_sch_d_part1_layout273dol_f_sch_c_part1_item1_layout272dol_f_nonstandard_layout230dol_f_sch_d_part2_layout229dol_f_sch_r_part1_layout204dol_f_sch_d_layout162dol_f_sch_g_layout162dol_f_sch_c_part1_layout140dol_f_sch_c_layout121dol_f_sch_p_layout112dol_f_5500_sf_part7_layout102dol_f_sch_h_part1_layout102dol_f_sch_i_part1_layout102dol_f_sch_mb_part1_layout102dol_f_sch_mb_part2_layout102dol_f_sch_sb_part1_layout102dol_f_sch_c_part1_item2_codes_layout85dol_f_sch_c_part1_item3_codes_layout85dol_f_sch_c_part2_codes_layout85dol_f_sch_mep_layout39dol_f_sch_mb_actv_part_data_layout32dol_f_sch_mb_proj_exp_benef_pay_layout32dol_f_sch_sb_actv_part_data_layout32dol_f_sch_sb_expect_ben_paymts_layout32dol_f_sch_mb_emp_cont_with_liab_layout28dol_f_sch_mb_withd_liab_amt_layout28dol_f_sch_dcg_plan_transfer_layout21dol_f_sch_mep_part2_layout21dol_f_sch_dcg_plan_transfer15
Fields in dol_f_sch_d_part2
FieldTypeExample
filing_idstring62037306000150
page_idstring3
page_seqstring994
page_row_numstring6
row_numstring7957
image_form_idstring550370306000150001
dfe_p2_plan_01_namestringG & J PEPSI-COLA BOTTLERS, INC.
dfe_p2_plan_spons_01_namestringG & J PEPSI-COLA BOTTLERS
dfe_p2_plan_01_einstring341031008
dfe_p2_plan_01_pnstring003
ack_idstring
row_orderstring
dfe_p2_plan_namestring
dfe_p2_plan_spons_namestring
dfe_p2_plan_einstring
dfe_p2_plan_pnstring
Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

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.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Nonprofits and Benefit Plans