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-09-03T13:56:07.562492

Tables

PCard Public 202108

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2022_31015.pcard_public_202108

1.24 MB
33,966 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.21 MB
33,182 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.2 MB
33,616 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.1 MB
30,501 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

983.11 kB
27,530 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.07 MB
29,068 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

1.01 MB
27,519 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.26 MB
35,632 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
);