State Use Procurement Schedule by US Government | Demographics and Population Studies

Qualified Organization

@usgov.state_of_oklahoma_state_use_procurement_schedule.qualified_organization

11.15 KB
45 rows
8 columns


CREATE TABLE qualified_organization (
  "qualified_organization" VARCHAR,
  "id" BIGINT,
  "address" VARCHAR,
  "website" VARCHAR,
  "phone" VARCHAR,
  "fax" VARCHAR,
  "primary_email" VARCHAR,
  "p_card" VARCHAR
);

Procure Schedule

@usgov.state_of_oklahoma_state_use_procurement_schedule.procure_schedule

138.17 KB
2540 rows
10 columns


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

Mandatory

@usgov.state_of_oklahoma_state_use_procurement_schedule.mandatory

5.52 KB
152 rows
4 columns


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

Suitable To Procure

@usgov.state_of_oklahoma_state_use_procurement_schedule.suitable_to_procure

8.55 KB
278 rows
6 columns


CREATE TABLE suitable_to_procure (
  "suitable_to_procure" VARCHAR,
  "category" BIGINT,
  "vendor" VARCHAR,
  "vendor_1" VARCHAR,
  "n__all" VARCHAR,
  "unnamed_5" VARCHAR
);

SW001

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw001

18.22 KB
190 rows
11 columns


CREATE TABLE sw001 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.47 KB
26 rows
10 columns


CREATE TABLE sw015 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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

88.34 KB
1650 rows
10 columns


CREATE TABLE sw022 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" DOUBLE,
  "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.59 KB
79 rows
14 columns


CREATE TABLE sw064 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE,
  "cat" BIGINT,
  "cat_desc" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR
);

SW078

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw078

13.85 KB
84 rows
10 columns


CREATE TABLE sw078 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.31 KB
19 rows
10 columns


CREATE TABLE sw097 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.5 KB
71 rows
10 columns


CREATE TABLE sw104 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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

17.85 KB
67 rows
23 columns


CREATE TABLE sw131 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "ln" BIGINT,
  "item" BIGINT,
  "description" VARCHAR,
  "uom" VARCHAR,
  "n" DOUBLE,
  "cat" BIGINT,
  "cat_desc" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR
);

SW172

@usgov.state_of_oklahoma_state_use_procurement_schedule.sw172

7.77 KB
9 rows
10 columns


CREATE TABLE sw172 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.06 KB
1 row
10 columns


CREATE TABLE sw177 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.27 KB
61 rows
10 columns


CREATE TABLE sw203 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.26 KB
23 rows
10 columns


CREATE TABLE sw320 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.23 KB
12 rows
10 columns


CREATE TABLE sw700 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.6 KB
15 rows
10 columns


CREATE TABLE sw772 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.52 KB
8 rows
10 columns


CREATE TABLE sw800 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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

7.91 KB
1 row
10 columns


CREATE TABLE sw801 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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

7.93 KB
13 rows
10 columns


CREATE TABLE sw803 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.62 KB
15 rows
10 columns


CREATE TABLE sw910 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.78 KB
19 rows
10 columns


CREATE TABLE sw915 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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

7.83 KB
5 rows
10 columns


CREATE TABLE sw916 (
  "sw" VARCHAR,
  "suv" VARCHAR,
  "ps" BIGINT,
  "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.13 KB
15 rows
10 columns


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

State Use Procurement Schedule

About this Dataset