From a 500-row sample across 11 columns.
| bid_number | bid_title | bid_item_number | bid_item | bidder_name | bid_price | bid_opening_date | contact_name | print_date | print_time | class_number |
|---|---|---|---|---|---|---|---|---|---|---|
| 1900211 | DOC - SHELF-STABLE FOOD PRODUCTS | 110 | RICE, BROWN, WHOLE, PARBOILED, LIGHT ENRICHED | WM R HILL CO INC | 0 | 2019-04-02T00:00:00.000 | FA-TAI SHIEH | 2023-03-31T00:00:00.000 | 00:17:00 | — |
| 1900089 | HRA EFNAP - SHELF STABLE |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
bid_number | integer | The seven (7) digit bid number that corresponds to given bid title a Competitive Sealed Bid (“CSB”) solicitation. | 0% | 190008918000921800264 |
bid_title | text | The title description for a bid solicitation that corresponds to a given bids number a Competitive Sealed Bid (“CSB”) solicitation. A bid title may have more than one (1) bid item associated with it and may be distinguished from other items by its bid item number. | 0% | SHELF-STABLE FOOD PRODUC…HRA EFNAP - SHELF STABLEDOC COMMISSARY ITEMS |
bid_item_number | integer | The item number associated with the type of good or service listed under a Bid Title. Bid items are assigned consecutive numbers that range from one (1) to 999. | 0% | 123 |
class_number | categorical |
GET /api/datasets/9k82-ys7w GET /api/datasets/9k82-ys7w/quality GET /api/datasets/9k82-ys7w/related GET /api/columns?dataset=9k82-ys7w
| 14 |
| SOUP, VEGETABLE, REDUCED SODIUM, 10.5-15 OZ. PER |
| WILD PENGUIN CORPORATION |
| 0 |
| 2018-11-16T00:00:00.000 |
| MARILYN BRETTSCHNEIDER |
| 2023-03-31T00:00:00.000 |
| 00:17:00 |
| — |
| 1800264 | SHELF-STABLE FOOD PRODUCTS | 134 | CRANBERRY SAUCE, JELLIED, GRADE A, NO. 10 CAN, | ROBBINS SALES COMPANY INC | 0 | 2018-04-18T00:00:00.000 | PETER LE | 2023-03-31T00:00:00.000 | 00:17:00 | — |
| 1800180 | LED LIGHTING SYSTEM FOR HERE ART CENTER | 26 | LIGHTING CONSOLE MONITOR | CANDELA CONTROLS INC | 601 | 2018-04-06T00:00:00.000 | BENNY ZHONG | 2023-03-31T00:00:00.000 | 00:17:00 | 1 |
| 1900185 | DOC: PROCESSED FRESH & FROZEN FOODS (GP) | 118 | FISH, FROZEN, WHITING (ATLANTIC OR PACIFIC) 3 OZ. | BROCCOLI ASSOCIATES INC | 0 | 2019-03-20T00:00:00.000 | MIRTA A. JARRETT | 2023-03-31T00:00:00.000 | 00:17:00 | — |
| 1800264 | SHELF-STABLE FOOD PRODUCTS | 122 | COCONUT MILK, 13-15 OZ PER CAN, 12 CANS PER CASE | H SCHRIER & COMPANY INC | 0 | 2018-04-18T00:00:00.000 | PETER LE | 2023-03-31T00:00:00.000 | 00:17:00 | — |
| 1800195 | KOSHER FOODS | 302 | CHICKEN CACCIATORE DINNER | JAMAC FROZEN FOOD CORPORATION | 34.8 | 2018-03-16T00:00:00.000 | PETER LE | 2023-03-31T00:00:00.000 | 00:17:00 | — |
| 1700314 | PRINTED SNAP-OUT FORMS, CARBON & CARBONLESS | 45 | STOCK OPTION/M SHEETS | VANGUARD DIRECT INC | 4 | 2017-07-07T00:00:00.000 | ERENY HANNA | 2023-03-31T00:00:00.000 | 00:17:00 | 1 |
| 1700148 | TRUCK, 25 C.Y. DUAL COMPARTMENT COLLECTION - DSNY | 56 | SPARE PARTS PACKAGE 'P'- TRANSMISSION PUMP, AS | KIMBEL MIXER CO DBA HINES SPEC | 1373.1 | 2017-11-15T00:00:00.000 | JOSEPH VACIRCA | 2023-03-31T00:00:00.000 | 00:17:00 | 2 |
| 1900321 | SYNTHETIC TURF MATERIALS - PARKS | 20 | SLOTTED POLYETHYLENE PIPE - 12' DIA - COUPLING | KEEPER GOALS - A DIV OF DEMAND | 0 | 2019-10-28T00:00:00.000 | BRIAN LEE | 2023-03-31T00:00:00.000 | 00:17:00 | — |
| A bid can consists of one or more Classes where similar or related items (goods and services) can be grouped into a “Class”. If multiple like items are grouped into a class, awards will be made by class. Class numbers can range from a blank class (where there is no class or only one class) to two (2) – 99 classes. |
| 56% |
123of 15 |
bid_item | text | A description of the unit, or bid item, which is specified in a Competitive Sealed Bid (“CSB”) solicitation. A bid title may have more than one bid item which is distinguished from other items by its bid item number. | 0% | CHARGER, ELECTRIC VEHICL…INSPECTION FEEANTIBOTIC-FREE CHICKEN |
bidder_name | text | The name of the vendor that submitted a bid under a specified bid title. A vendor may submit a bid for one or more bid items specified in a Competitive Sealed Bid (“CSB”) solicitation. | 0% | JAMAC FROZEN FOOD CORPOR…UNIVERSAL COFFEE CORPH SCHRIER & COMPANY INC |
bid_price | text | The unit price, in dollars, for the corresponding bid item submitted by a vendor under the specified bid title. | 0% | 0NO CHARGE9 |
bid_opening_date | datetime | The opening date for a Competitive Sealed Bid (“CSB”) solicitation in M/DD/YYYY format. | 0% | 2018-11-16T00:00:00.0002018-01-19T00:00:00.0002018-04-18T00:00:00.000 |
contact_name | text | The name of the staff at the Department of Citywide Administrative Services (“DCAS”) who was listed as the point of contact on the original Competitive Sealed Bid (“CSB”) solicitation. | 0% | PETER LEMIRTA A. JARRETTFA-TAI SHIEH |
print_date | datetime | The date that a bid item was printed under the specified title for a Competitive Sealed Bid (“CSB”) solicitation in M/DD/YYYY format. | 0% | 2023-03-31T00:00:00.000of 1 |
print_time | text | The time that a bid item was printed under the specified title for a Competitive Sealed Bid (“CSB”) solicitation in H:MM format where “H” ranges from 0 – 23. | 0% | 00:17:00of 1 |