About this Dataset

County (Pcard) Purchase Card 2022 - 2024

This dataset contains information on purchases made through the purchase card programs administered by the Oklahoma Counties.
Organization: State of Oklahoma
Last updated: 2022-02-22T00:42:54.830471

Tables

2024.04 County P-card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2024_04_county_p_card_spend

22.66 kB
274 rows
11 columns


CREATE TABLE n_2024_04_county_p_card_spend (
  "calenday_year" BIGINT,
  "calendar_month" BIGINT,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "n__amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_descrption" VARCHAR
);

2024.05 County P-card Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2024_05_county_p_card_spend_report

21.54 kB
264 rows
11 columns


CREATE TABLE n_2024_05_county_p_card_spend_report (
  "calendar_year" BIGINT,
  "month" BIGINT,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "ch_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "purchase_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_description" VARCHAR
);

2024.06 County P-card Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2024_06_county_p_card_spend_report

22 kB
280 rows
11 columns


CREATE TABLE n_2024_06_county_p_card_spend_report (
  "calendar_year" BIGINT,
  "month" BIGINT,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "ch_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "purchase_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_description" VARCHAR
);