Purchases made by West Virginia University (2010-2021)
Data license: PDDL · Data source: West Virginia University Office of Procurement Contracting & Payment Services · About: https://github.com/AustinDizzy/wvu-purchases
Tables
pcard_records
account_name, posting_date, trans_date, mcc, mcc_description, merchant_name, trans_amount, ebo, reports_to, dcc, identifier, sales_tax_amount, state_province, city_name, ship_from_zip, country_code, customer_code, expense_desc, item_desc, gp, campus, dept_activity, fund, line_item, function, project, task, award, expenditure_type, expenditure_org1, expenditure_org2, air_city_of_dest, air_city_of_origin, air_stop_over_indicator, ticket_number, passenger_name, vr_checkout_date, vr_renters_name, lod_arrival_date, lod_total_room_nights, flt_item_description, flt_motor_fuel_amount, flt_motor_fuel_sale_amount, flt_motor_fuel_unit_amount, item_quantity, extended_amount, unit_price, state_or_rc_card
2,167,907 rows
procurement_records
purchasing_org, approved_date, approved_time, supplier_contact, number, line, category, description, quantity, uom, price, amount, buyer, cancelled, closure_status, misc_attr, type, supplier, site, currency, item_rev, contract_num, ver, supplier_item, item
89,034 rows
... and 10 hidden tables
Download SQLite DB: purchases.db 867.6 MB