County (Pcard) Purchase Card 2022 - 2024 by US Government | Finance and Economics

2022-01 County P-Card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_01_county_p_card_spend

20.8 KB
464 rows
11 columns


CREATE TABLE n_2022_01_county_p_card_spend (
  "calenday_year" BIGINT,
  "calendar_month" BIGINT,
  "county" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_descr" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_descrption" VARCHAR
);

2022-02 County P-Card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_02_county_p_card_spend

20.75 KB
435 rows
11 columns


CREATE TABLE n_2022_02_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
);

2022-03 County P-Card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_03_county_p_card_spend

19.19 KB
311 rows
11 columns


CREATE TABLE n_2022_03_county_p_card_spend (
  "calenday_year" BIGINT,
  "calendar_month" BIGINT,
  "county" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" DOUBLE,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_descrption" VARCHAR
);

2022.04 County PCard Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_04_county_pcard_spend

18.59 KB
237 rows
11 columns


CREATE TABLE n_2022_04_county_pcard_spend (
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_description" VARCHAR
);

2022–05 County PCard Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_05_county_pcard_spend

18.86 KB
230 rows
11 columns


CREATE TABLE n_2022_05_county_pcard_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
);

2022–06 County PCard Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_06_county_pcard_spend

20.65 KB
221 rows
11 columns


CREATE TABLE n_2022_06_county_pcard_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
);

2022.09 County PCard Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_09_county_pcard_spend_report

18.72 KB
219 rows
11 columns


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

2022.10 County PCard Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_10_county_pcard_spend_report

19.38 KB
231 rows
11 columns


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

2022.11 County PCard Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_11_county_pcard_spend_report

18.49 KB
193 rows
11 columns


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

2022.12 County PCard Spend Report.xls

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2022_12_county_pcard_spend_report_xls

21.83 KB
256 rows
11 columns


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

2023.01 County P-Card Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_01_county_p_card_spend_report

18.59 KB
216 rows
11 columns


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

2023.02 County P-Card Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_02_county_p_card_spend_report

19.67 KB
228 rows
11 columns


CREATE TABLE n_2023_02_county_p_card_spend_report (
  "calenday_year" BIGINT,
  "calendar_month" BIGINT,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_description" VARCHAR
);

2023.03 County P-Card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_03_county_p_card_spend

20.98 KB
259 rows
11 columns


CREATE TABLE n_2023_03_county_p_card_spend (
  "calenday_year" BIGINT,
  "calendar_month" BIGINT,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant_name" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_description" VARCHAR
);

2023.04 County P-Card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_04_county_p_card_spend

19.14 KB
315 rows
11 columns


CREATE TABLE n_2023_04_county_p_card_spend (
  "calenday_year" DOUBLE,
  "calendar_month" DOUBLE,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_description" VARCHAR
);

2023.05 County P-card Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_05_county_p_card_spend_report

20.98 KB
424 rows
11 columns


CREATE TABLE n_2023_05_county_p_card_spend_report (
  "calenday_year" DOUBLE,
  "calendar_month" DOUBLE,
  "program_card_name" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_descrption" VARCHAR
);

2023.06 County P-card Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_06_county_p_card_spend_report

22.6 KB
438 rows
11 columns


CREATE TABLE n_2023_06_county_p_card_spend_report (
  "calenday_year" DOUBLE,
  "calendar_month" DOUBLE,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_descrption" VARCHAR
);

2023.07 County P-card Spent Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_07_county_p_card_spent_report

21.93 KB
446 rows
11 columns


CREATE TABLE n_2023_07_county_p_card_spent_report (
  "calenday_year" DOUBLE,
  "calendar_month" DOUBLE,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_descrption" VARCHAR
);

2023.08 County Pcard Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_08_county_pcard_spend_report

21.32 KB
406 rows
11 columns


CREATE TABLE n_2023_08_county_pcard_spend_report (
  "calenday_year" DOUBLE,
  "calendar_month" DOUBLE,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_descrption" VARCHAR
);

2023.09 County Pcard Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_09_county_pcard_spend_report

19.71 KB
356 rows
11 columns


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

2023.10 County Pcard Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_10_county_pcard_spend_report

20.13 KB
386 rows
11 columns


CREATE TABLE n_2023_10_county_pcard_spend_report (
  "calenday_year" DOUBLE,
  "calendar_month" DOUBLE,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "first_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "transaction_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_descrption" VARCHAR
);

2023.11 County P-Card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_11_county_p_card_spend

23.84 KB
351 rows
17 columns


CREATE TABLE n_2023_11_county_p_card_spend (
  "calenday_year" DOUBLE,
  "calendar_month" DOUBLE,
  "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,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);

2023.12 County P-Card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2023_12_county_p_card_spend

22.15 KB
260 rows
11 columns


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

2024.01 County P-Card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2024_01_county_p_card_spend

21.87 KB
383 rows
13 columns


CREATE TABLE n_2024_01_county_p_card_spend (
  "calenday_year" DOUBLE,
  "calendar_month" DOUBLE,
  "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,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR
);

2024.02 County P-card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2024_02_county_p_card_spend

21.63 KB
290 rows
11 columns


CREATE TABLE n_2024_02_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.03 County P-card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2024_03_county_p_card_spend

22.06 KB
287 rows
11 columns


CREATE TABLE n_2024_03_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.04 County P-card Spend

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2024_04_county_p_card_spend

22.13 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.04 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

21.48 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
);

County (Pcard) Purchase Card 2022 - 2024

About this Dataset