About this Dataset

Purchase Card (PCard) Fiscal Year 2021

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.809915

Tables

Pcard 202009

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_202009

1.02 MB
27,848 rows
13 columns

CREATE TABLE pcard_202009 (
  "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 202010

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_202010

999.77 kB
27,894 rows
13 columns

CREATE TABLE pcard_202010 (
  "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 202011

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_202011

867.34 kB
23,686 rows
13 columns

CREATE TABLE pcard_202011 (
  "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 202012

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_202012

836.38 kB
23,010 rows
13 columns

CREATE TABLE pcard_202012 (
  "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 202101

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_202101

919.47 kB
25,352 rows
13 columns

CREATE TABLE pcard_202101 (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ch_last_name" VARCHAR,
  "first_name" VARCHAR,
  "item_descr" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" VARCHAR,
  "post_date" VARCHAR,
  "mcc_descr" VARCHAR,
  "rowid" VARCHAR
);

Pcard 202102

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_202102

873.62 kB
24,101 rows
13 columns

CREATE TABLE pcard_202102 (
  "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 202103

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_202103

1.17 MB
32,622 rows
13 columns

CREATE TABLE pcard_202103 (
  "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 202008

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_public_202008

1.12 MB
30,849 rows
13 columns

CREATE TABLE pcard_public_202008 (
  "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 202104

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_public_202104

1.15 MB
31,250 rows
13 columns

CREATE TABLE pcard_public_202104 (
  "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 202105

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_public_202105

1.12 MB
30,629 rows
13 columns

CREATE TABLE pcard_public_202105 (
  "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 202106

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2021_c492c.pcard_public_202106

1.13 MB
31,066 rows
13 columns

CREATE TABLE pcard_public_202106 (
  "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
);