Purchase Card (PCard) Fiscal Year 2022 by US Government | Finance and Economics

About this Dataset

Purchase Card (PCard) Fiscal Year 2022

This dataset contains information on purchases made through the purchase card programs administered by the state and higher ed institutions.
Organization: State of Oklahoma
Last updated: 2021-08-07T14:55:37.375831

Tables

PCard Public 202107

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202107

1.03 MB
29830 rows
13 columns


CREATE TABLE pcard_public_202107 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_description" VARCHAR,
  "rowid" VARCHAR
);

PCard Public 202108

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202108

1.18 MB
33966 rows
13 columns


CREATE TABLE pcard_public_202108 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_description" VARCHAR,
  "rowid" VARCHAR
);

PCard Public 202109

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202109

1.15 MB
33182 rows
13 columns


CREATE TABLE pcard_public_202109 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_description" VARCHAR,
  "rowid" VARCHAR
);

PCard Public 202110

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202110

1.15 MB
33616 rows
13 columns


CREATE TABLE pcard_public_202110 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_description" VARCHAR,
  "rowid" VARCHAR
);

PCard Public 202111

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202111

1.04 MB
30501 rows
13 columns


CREATE TABLE pcard_public_202111 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_description" VARCHAR,
  "rowid" VARCHAR
);

PCard Public 202112

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202112

960.07 KB
27530 rows
13 columns


CREATE TABLE pcard_public_202112 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_description" VARCHAR,
  "rowid" VARCHAR
);

PCard Public 202201

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202201

1.02 MB
29068 rows
13 columns


CREATE TABLE pcard_public_202201 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_description" VARCHAR,
  "rowid" VARCHAR
);

PCard Public 202202

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202202

985.08 KB
27519 rows
13 columns


CREATE TABLE pcard_public_202202 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_description" VARCHAR,
  "rowid" VARCHAR
);

PCard Public 202203

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202203

1.2 MB
35632 rows
13 columns


CREATE TABLE pcard_public_202203 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_description" VARCHAR,
  "rowid" VARCHAR
);