Mandatory

@usgov.state_of_oklahoma_state_use_procurement_schedule.mandatory

5.65 kB
152 rows
4 columns

CREATE TABLE mandatory (
  "products" VARCHAR,
  "contract" VARCHAR,
  "services" VARCHAR,
  "contract_1" VARCHAR
);

Procure Schedule

@usgov.state_of_oklahoma_state_use_procurement_schedule.procure_schedule

141.48 kB
2,540 rows
10 columns

CREATE TABLE procure_schedule (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" DOUBLE  -- PS#,
  "ln" DOUBLE,
  "item" VARCHAR,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" VARCHAR  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

Suitable To Procure

@usgov.state_of_oklahoma_state_use_procurement_schedule.suitable_to_procure

8.75 kB
278 rows
6 columns

CREATE TABLE suitable_to_procure (
  "suitable_to_procure" VARCHAR,
  "category" BIGINT,
  "vendor" VARCHAR,
  "vendor_1" VARCHAR,
  "n__all" VARCHAR  -- (All),
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

SW001

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw001

18.66 kB
190 rows
11 columns

CREATE TABLE sw001 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR,
  "full_catalog" VARCHAR
);

SW015

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw015

10.72 kB
26 rows
10 columns

CREATE TABLE sw015 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW022

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw022

90.46 kB
1,650 rows
10 columns

CREATE TABLE sw022 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" DOUBLE  -- PS#,
  "ln" DOUBLE,
  "item" VARCHAR,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" VARCHAR  -- $,
  "cat" DOUBLE,
  "cat_desc" VARCHAR
);

SW064

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw064

15.96 kB
79 rows
14 columns

CREATE TABLE sw064 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);

SW078

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw078

14.18 kB
84 rows
10 columns

CREATE TABLE sw078 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW097

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw097

8.51 kB
19 rows
10 columns

CREATE TABLE sw097 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW104

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw104

10.75 kB
71 rows
10 columns

CREATE TABLE sw104 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW131

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw131

18.28 kB
67 rows
23 columns

CREATE TABLE sw131 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

SW172

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw172

7.96 kB
9 rows
10 columns

CREATE TABLE sw172 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW177

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw177

7.23 kB
1 row
10 columns

CREATE TABLE sw177 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW203

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw203

11.54 kB
61 rows
10 columns

CREATE TABLE sw203 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW320

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw320

10.5 kB
23 rows
10 columns

CREATE TABLE sw320 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW700

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw700

7.4 kB
12 rows
10 columns

CREATE TABLE sw700 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW772

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw772

8.81 kB
15 rows
10 columns

CREATE TABLE sw772 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW800

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw800

9.75 kB
8 rows
10 columns

CREATE TABLE sw800 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW801

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw801

8.1 kB
1 row
10 columns

CREATE TABLE sw801 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW803

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw803

8.12 kB
13 rows
10 columns

CREATE TABLE sw803 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW910

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw910

8.83 kB
15 rows
10 columns

CREATE TABLE sw910 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW915

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw915

8.99 kB
19 rows
10 columns

CREATE TABLE sw915 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW916

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw916

8.02 kB
5 rows
10 columns

CREATE TABLE sw916 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" VARCHAR  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

SW917

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw917

8.32 kB
15 rows
10 columns

CREATE TABLE sw917 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT  -- PS#,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE  -- $,
  "cat" BIGINT,
  "cat_desc" VARCHAR
);

State Use Procurement Schedule

About this Dataset