documents

Regulatory documents from Regulations.gov including rules, proposed rules, notices, and supporting materials.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

60 rows where agency_id = "BOEM", document_type = "Other" and posted_year = 2013 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: posted_month, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)

posted_year 1

  • 2013 · 60 ✖

document_type 1

  • Other · 60 ✖

agency_id 1

  • BOEM · 60 ✖
id agency_id docket_id title document_type subtype posted_date ▲ posted_year posted_month comment_start_date comment_end_date last_modified fr_doc_num open_for_comment withdrawn object_id
BOEM-2013-0094-0001 BOEM BHP Billiton S-07614 Supplemental Development Operations Coordination Document BOEM-2013-0094 BHP Billiton S-07614 Supplemental Development Operations Coordination Document Other   2013-12-23T05:00:00Z 2013 12 2013-12-23T05:00:00Z 2014-01-04T04:59:59Z 2013-12-23T17:44:41Z   0 0 09000064814d1df5
BOEM-2013-0093-0001 BOEM BP Exploration N-9762 Initial Exploration Plan BOEM-2013-0093 BP Exploration N-9762 Initial Exploration Plan Other   2013-12-13T05:00:00Z 2013 12 2013-12-13T05:00:00Z 2013-12-24T04:59:59Z 2013-12-13T16:05:57Z   0 0 09000064814bc8a7
BOEM-2013-0093-0002 BOEM BP Exploration N-9762 Initial Exploration Plan BOEM-2013-0093 BP Exploration N-9762 Initial Exploration Plan Other   2013-12-13T05:00:00Z 2013 12 2013-12-13T05:00:00Z 2013-12-24T04:59:59Z 2013-12-18T02:02:16Z   0 0 09000064814bc8a8
BOEM-2013-0092-0001 BOEM Chevron U.S.A. Inc. N-9754 Initial Exploration Plan BOEM-2013-0092 Chevron USA Inc N-9743 Initial Exploration Plan Other   2013-12-11T05:00:00Z 2013 12 2013-12-11T05:00:00Z 2013-12-22T04:59:59Z 2013-12-18T02:02:24Z   0 0 09000064814b911c
BOEM-2013-0091-0001 BOEM Exxon Mobil Corporation S-7637 Supplemental Exploration Plan BOEM-2013-0091 Exxon Mobil Corporation S-7637 Supplemental Exploration Plan Other   2013-12-11T05:00:00Z 2013 12 2013-12-11T05:00:00Z 2013-12-24T04:59:59Z 2013-12-18T02:02:05Z   0 0 09000064814b89e5
BOEM-2013-0088-0001 BOEM Noble N-9756 Initial Exploration Plan BOEM-2013-0088 Noble N-9756 Initial Exploration Plan Other   2013-12-03T05:00:00Z 2013 12 2013-12-03T05:00:00Z 2013-12-14T04:59:59Z 2014-01-10T16:18:32Z   0 0 09000064814a4531
BOEM-2013-0086-0001 BOEM Anadarko S-07636 Supplemental Exploration Plan BOEM-2013-0086 Anadarko S-07636 Supplemental Exploration Plan Other   2013-11-25T05:00:00Z 2013 11 2013-11-25T05:00:00Z 2013-12-07T04:59:59Z 2013-11-25T15:58:57Z   0 0 0900006481495fdb
BOEM-2013-0085-0001 BOEM Eni US Operating N-9735 Initial Exploration Plan BOEM-2013-0085 Eni US Operating N-9735 Initial Exploration Plan Other   2013-11-22T05:00:00Z 2013 11 2013-11-22T05:00:00Z 2013-12-03T04:59:59Z 2014-01-10T16:18:15Z   0 0 0900006481491957
BOEM-2013-0084-0001 BOEM Union Oil Company of California R-5982 Revised Exploration Plan BOEM-2013-0084 Union Oil Company of California R-5982 Revised Exploration Plan Other   2013-11-21T05:00:00Z 2013 11 2013-11-21T05:00:00Z 2013-12-01T04:59:59Z 2013-11-25T02:02:19Z   0 0 090000648148d7ab
BOEM-2013-0082-0001 BOEM Walter N-9745 Initial Exploration Plan BOEM-2013-0082 Walter N-9745 Initial Exploration Plan Other   2013-11-14T05:00:00Z 2013 11 2013-11-14T05:00:00Z 2013-11-24T04:59:59Z 2014-01-10T16:17:56Z   0 0 090000648147f5fc
BOEM-2013-0050-0013 BOEM Potential Commercial Leasing for Wind Power on the Outer Continental Shelf (OCS) Offshore Oregon, Request for Interest BOEM-2013-0050 Comment from Ron Sadler, NA Other   2013-11-12T05:00:00Z 2013 11 2013-11-12T05:00:00Z 2013-10-31T03:59:59Z 2013-11-22T19:34:54Z   0 0 090000648146821e
BOEM-2011-0096-0004 BOEM Alaska Annual Studies Plans, Alaska Outer Continental Shelf Region BOEM-2011-0096 Alaska Annual Studies Plan, Proposed Study FY 2015 - Instructions Other   2013-11-12T05:00:00Z 2013 11 2013-11-12T05:00:00Z 2013-12-21T04:59:59Z 2013-12-21T02:01:37Z   0 0 0900006481474a91
BOEM-2013-0080-0001 BOEM LLOG S-7635 Supplemental Exploration Plan BOEM-2013-0080 LLOG S-7635 Supplemental Exploration Plan Other   2013-11-08T05:00:00Z 2013 11 2013-11-08T05:00:00Z 2013-11-19T04:59:59Z 2014-01-10T16:17:39Z   0 0 0900006481474328
BOEM-2013-0079-0001 BOEM Chevron USA Inc N-9743 Initial Exploration Plan BOEM-2013-0079 Chevron USA Inc N-9743 Initial Exploration Plan Other   2013-11-04T05:00:00Z 2013 11 2013-11-04T05:00:00Z 2013-11-16T04:59:59Z 2013-11-04T20:06:08Z   0 0 090000648146f8bd
BOEM-2013-0078-0001 BOEM Anadarko S-7625 Supplemental Exploration Plan BOEM-2013-0078 Anadarko S-7625 Supplemental Exploration Plan Other   2013-11-04T05:00:00Z 2013 11 2013-11-04T05:00:00Z 2013-11-12T04:59:59Z 2013-11-04T15:14:49Z   0 0 0900006481469f93
BOEM-2013-0074-0001 BOEM Walter N-09728 Initial Exploration Plan BOEM-2013-0074 Walter N-09728 Initial Exploration Plan Other   2013-10-22T04:00:00Z 2013 10 2013-10-22T04:00:00Z 2013-11-03T03:59:59Z 2013-10-27T03:22:10Z   0 0 0900006481459572
BOEM-2013-0072-0001 BOEM Shell Offshore Inc S-7626 Supplemental Development Operations Coordination Document BOEM-2013-0072 Shell Offshore Inc S-7626 Supplemental Development Operations Coordination Document Other   2013-09-20T04:00:00Z 2013 9 2013-09-20T04:00:00Z 2013-10-02T03:59:59Z 2013-09-20T23:25:27Z   0 0 090000648142e722
BOEM-2013-0070-0001 BOEM Statoil N-09721 Initial Exploration Plan BOEM-2013-0070 Statoil N-9721 Initial Exploration Plan Other   2013-09-11T04:00:00Z 2013 9 2013-09-11T04:00:00Z 2013-09-22T03:59:59Z 2013-09-11T19:40:03Z   0 0 09000064813f5065
BOEM-2013-0069-0001 BOEM Statoil N-09711 Initial Exploration Plan BOEM-2013-0069 Statoil N-9711 Initial Exploration Plan Other   2013-09-11T04:00:00Z 2013 9 2013-09-11T04:00:00Z 2013-09-22T03:59:59Z 2013-09-11T19:32:20Z   0 0 09000064813f5064
BOEM-2013-0067-0001 BOEM Apache Deepwater LLC R-5906 Revised Exploration Plan BOEM-2013-0067 Apache Deepwater LLC R-5906 Revised Exploration Plan Other   2013-09-09T04:00:00Z 2013 9 2013-09-09T04:00:00Z 2013-09-21T03:59:59Z 2013-09-09T14:52:04Z   0 0 09000064813e545c
BOEM-2013-0066-0001 BOEM Shell S-07621 Supplemental Exploration Plan BOEM-2013-0066 Shell S-07621 Supplemental Exploration Plan Other   2013-09-03T04:00:00Z 2013 9 2013-09-03T04:00:00Z 2013-09-15T03:59:59Z 2013-09-03T17:16:50Z   0 0 09000064813d6f90
BOEM-2013-0062-0001 BOEM Statoil N-9711 Initial Exploration Plan BOEM-2013-0062 Statoil N-9711 Initial Exploration Plan Other   2013-08-20T04:00:00Z 2013 8 2013-08-20T04:00:00Z 2013-08-31T03:59:59Z 2013-08-20T20:38:53Z   0 0 09000064813bbc41
BOEM-2013-0063-0001 BOEM Walter N-09734 BOEM-2013-0063 Walter N-09734 Other   2013-08-20T04:00:00Z 2013 8 2013-08-20T04:00:00Z 2013-09-01T03:59:59Z 2013-08-26T01:02:20Z   0 0 09000064813bc27f
BOEM-2013-0061-0001 BOEM Statoil N-9721 Initial Exploration Plan BOEM-2013-0061 Statoil N-9721 Initial Exploration Plan Other   2013-08-20T04:00:00Z 2013 8 2013-08-20T04:00:00Z 2013-08-31T03:59:59Z 2013-08-26T01:02:21Z   0 0 09000064813bb6d5
BOEM-2013-0060-0001 BOEM Anadarko Petroleum S-7623 Supplemental Exploration Plan BOEM-2013-0060 Anadarko Petroleum S-7623 Supplemental Exploration Plan Other   2013-08-19T04:00:00Z 2013 8 2013-08-19T04:00:00Z 2013-08-29T03:59:59Z 2013-08-19T21:53:29Z   0 0 09000064813b9909
BOEM-2013-0057-0001 BOEM BHP Billiton Petroleum (GOM) Inc. S-7616 Supplemental Development Operations Coordination Document BOEM-2013-0057 BHP Billiton Petroleum (GOM) Inc. S-7616 Supplemental Development Operations Coordinations Document Other   2013-08-06T04:00:00Z 2013 8 2013-08-06T04:00:00Z 2013-08-17T03:59:59Z 2013-08-06T20:41:28Z   0 0 09000064813942b9
BOEM-2013-0056-0001 BOEM Anadarko S-07615 Supplemental Exploration Plan BOEM-2013-0056 Anadarko S-07615 Supplemental Exploration Plan Other   2013-08-05T04:00:00Z 2013 8 2013-08-05T04:00:00Z 2013-08-17T03:59:59Z 2013-08-07T01:02:04Z   0 0 090000648138e610
BOEM-2013-0055-0001 BOEM N-09727 Initial Exploration Plan BOEM-2013-0055 N-09727 Initial Exploration Plan Other   2013-08-01T04:00:00Z 2013 8 2013-08-01T04:00:00Z 2013-08-13T03:59:59Z 2013-08-01T15:32:56Z   0 0 090000648138a321
BOEM-2013-0053-0001 BOEM Murphy N-09687 Initial Exploration Plan BOEM-2013-0053 Murphy N-09687 Initial Exploration Plan Other   2013-07-24T04:00:00Z 2013 7 2013-07-24T04:00:00Z 2013-08-06T03:59:59Z 2013-08-01T01:02:25Z   0 0 090000648137aa56
BOEM-2013-0052-0001 BOEM STATOIL S-07610 Supplemental Exploration Plan BOEM-2013-0052 STATOIL S-07610 Supplemental Exploration Plan Other   2013-07-19T04:00:00Z 2013 7 2013-07-19T04:00:00Z 2013-07-31T03:59:59Z 2013-07-30T01:03:40Z   0 0 090000648136fd4d
BOEM-2013-0049-0001 BOEM Murphy Exploration & Production Company- USA N-9708 Initial Exploration Plan BOEM-2013-0049 Murphy Exploration & Production Company- USA N-9708 Initial Exploration Plan Other   2013-07-12T04:00:00Z 2013 7 2013-07-12T04:00:00Z 2013-07-24T03:59:59Z 2013-07-12T13:12:32Z   0 0 0900006481363804
BOEM-2013-0048-0001 BOEM ConocoPhillips Company N-09725 Initial Exploration Plan BOEM-2013-0048 ConocoPhillips Company N-09725 Initial Exploration Plan Other   2013-07-09T04:00:00Z 2013 7 2013-07-09T04:00:00Z 2013-07-21T03:59:59Z 2013-07-09T14:13:00Z   0 0 090000648135bd70
BOEM-2013-0047-0001 BOEM Shell R-5873 Revised Development Operations Coordination Document BOEM-2013-0047 Shell R-5873 Revised Development Operations Coordination Document Other   2013-07-01T04:00:00Z 2013 7 2013-07-01T04:00:00Z 2013-07-14T03:59:59Z 2013-07-01T18:34:03Z   0 0 090000648134f666
BOEM-2013-0045-0001 BOEM Anadarko S-7617 Supplemental Development Operations Coordinations Document BOEM-2013-0045 Anadarko S-7617 Supplemental Development Operations Coordinations Document Other   2013-06-28T04:00:00Z 2013 6 2013-06-28T04:00:00Z 2013-07-09T03:59:59Z 2013-06-28T17:10:23Z   0 0 0900006481347e7f
BOEM-2013-0044-0001 BOEM Shell S-07608 Supplemental Exploration Plan BOEM-2013-0044 Shell S-07608 Supplemental Exploration Plan Other   2013-06-28T04:00:00Z 2013 6 2013-06-28T04:00:00Z 2013-07-11T03:59:59Z 2013-06-28T14:54:44Z   0 0 0900006481347e8d
BOEM-2013-0043-0001 BOEM Murphy Exploration and Production Company- USA N-9697 Initial Exploration Plan BOEM-2013-0043 Murphy Exploration & Production Company - USA N-9697 Initial Exploration Plan Other   2013-06-25T04:00:00Z 2013 6 2013-06-25T04:00:00Z 2013-07-08T03:59:59Z 2013-06-25T15:46:59Z   0 0 090000648133e1c1
BOEM-2013-0041-0001 BOEM Chevron N-9704 Initial Exploration Plan BOEM-2013-0041 Chevron USA Inc N-9704 Initial Exploration Plan Other   2013-06-18T04:00:00Z 2013 6 2013-06-18T04:00:00Z 2013-06-30T03:59:59Z 2013-06-18T21:33:07Z   0 0 090000648132e170
BOEM-2013-0040-0001 BOEM Stone Energy S-7609 Supplemental Development Operations Coordination Document BOEM-2013-0040 Stone Energy S-7609 Supplemental Development Operations Coordination Document Other   2013-06-13T04:00:00Z 2013 6 2013-06-13T04:00:00Z 2013-06-25T03:59:59Z 2013-06-13T18:22:25Z   0 0 090000648131f0cb
BOEM-2013-0039-0001 BOEM Stone Energy Corp N-09706 Initial Exploration Plan BOEM-2013-0039 Stone Energy Corp N-09706 Initial Exploration Plan Other   2013-06-12T04:00:00Z 2013 6 2013-06-12T04:00:00Z 2013-06-24T03:59:59Z 2013-06-12T18:15:28Z   0 0 090000648131b7ba
BOEM-2013-0037-0001 BOEM Noble Energy Inc. N-09714 Initial Exploration Plan BOEM-2013-0037 Noble Energy Inc N-09714 Initial Exp Plan Other   2013-06-11T04:00:00Z 2013 6 2013-06-11T04:00:00Z 2013-06-23T03:59:59Z 2013-06-11T20:49:03Z   0 0 0900006481318fb7
BOEM-2013-0036-0001 BOEM Walter Oil & Gas N-9688 Initial Development Operations Coordinations Document BOEM-2013-0036 Walter Oil & Gas N-9688 Initial Development Operations Coordinations Document Other   2013-06-07T04:00:00Z 2013 6 2013-06-07T04:00:00Z 2013-06-18T03:59:59Z 2013-06-07T15:57:56Z   0 0 0900006481312211
BOEM-2013-0035-0001 BOEM Department of Interior: Bureau of Ocean Energy Management (BOEM) & Bureau of Safety and Environment and Enforcement (BSEE) review of Alaska Outer Continental Shelf Oil & Gas Drilling Standards. BOEM-2013-0035 Department of Interior: Bureau of Ocean Energy Management (BOEM) & Bureau of Saftey and Environment Enforcement (BSEE) review of Alaska Outer Continental Shelf Oil & Gas Drilling Standards. Other   2013-06-06T04:00:00Z 2013 6 2013-06-06T04:00:00Z 2013-06-22T03:59:59Z 2013-06-25T01:14:18Z   0 0 09000064813100d3
BOEM-2013-0033-0001 BOEM LLOG N-09709 Initial Exploration Plan BOEM-2013-0033 LLOG N-09709 Initial Exploration Plan Other   2013-05-22T04:00:00Z 2013 5 2013-05-22T04:00:00Z 2013-06-04T03:59:59Z 2013-05-22T17:18:42Z   0 0 09000064812f338d
BOEM-2013-0031-0001 BOEM Exxon N-9713 Initial Exploration Plan BOEM-2013-0031 Exxon N-9713 Initial Exploration Plan Other   2013-05-15T04:00:00Z 2013 5 2013-05-15T04:00:00Z 2013-05-29T03:59:59Z 2013-05-15T15:03:32Z   0 0 09000064812e594c
BOEM-2013-0028-0001 BOEM Apache Deepwater N-09702 Initial Exploration Plan BOEM-2013-0028 Apache Deepwater N-09702 Initial Exploration Plan Other   2013-05-13T04:00:00Z 2013 5 2013-05-13T04:00:00Z 2013-05-25T03:59:59Z 2013-05-13T13:20:28Z   0 0 09000064812d8a83
BOEM-2013-0026-0001 BOEM Petrobras America Inc. N-09674 Initial Exploration Plan BOEM-2013-0026 Petrobras America Inc. N-09674 Initial Exploration Plan Other   2013-05-13T04:00:00Z 2013 5 2013-05-13T04:00:00Z 2013-05-21T03:59:59Z 2013-05-13T21:45:39Z   0 0 09000064812d664d
BOEM-2013-0027-0001 BOEM Anadarko Petroleum Corporation S-7593 Supplemental Exploration Plan BOEM-2013-0027 Anadarko Petroleum Corporation S-7593 Supplemental Exploration Plan Other   2013-05-10T04:00:00Z 2013 5 2013-05-10T04:00:00Z 2013-05-22T03:59:59Z 2013-05-10T13:59:45Z   0 0 09000064812d82c4
BOEM-2013-0024-0001 BOEM Apache Deepwater LLC N-09678 Initial Exploration Plan BOEM-2013-0024 Apache Deepwater LLC N-09678 Initial Exploration Plan Other   2013-05-07T04:00:00Z 2013 5 2013-05-07T04:00:00Z 2013-05-18T03:59:59Z 2013-05-07T11:47:23Z   0 0 09000064812bcf1a
BOEM-2013-0024-0002 BOEM Apache Deepwater LLC N-09678 Initial Exploration Plan BOEM-2013-0024 Apache Deepwater LLC N-09678 Initial Exploration Plan Other   2013-05-07T04:00:00Z 2013 5 2013-05-07T04:00:00Z 2013-05-18T03:59:59Z 2013-05-07T11:47:12Z   0 0 09000064812bcf1b
BOEM-2013-0023-0001 BOEM N-09699 Initial Development Operations Coordination Document BOEM-2013-0023 N-09699 Initial Development Operations Coordination Document Other   2013-05-06T04:00:00Z 2013 5 2013-05-06T04:00:00Z 2013-05-18T03:59:59Z 2013-05-06T15:23:36Z   0 0 09000064812bb63b
BOEM-2013-0021-0001 BOEM Anadarko S-7604 Supplemental Exploration Plan BOEM-2013-0021 Anadarko S-7604 Supplemental Exploration Plan Other   2013-04-29T04:00:00Z 2013 4 2013-04-29T04:00:00Z 2013-05-11T03:59:59Z 2013-05-11T01:04:00Z   0 0 09000064812abc7c
BOEM-2013-0017-0001 BOEM Anadarko S-7606 Supplemental Exploration Plan BOEM-2013-0017 Anadarko S-7606 Supplemental Exploration Plan Other   2013-04-17T04:00:00Z 2013 4 2013-04-17T04:00:00Z 2013-04-28T03:59:59Z 2013-04-17T18:51:46Z   0 0 0900006481298a4c
BOEM-2013-0016-0001 BOEM N-09683 Initial Exploration Plan BOEM-2013-0016 N-09683 Initial Exploration Plan Other   2013-04-16T04:00:00Z 2013 4 2013-04-16T04:00:00Z 2013-04-29T03:59:59Z 2013-04-16T14:21:57Z   0 0 0900006481295ea4
BOEM-2013-0012-0001 BOEM Stone Energy N-09684 Initial Exploration Plan BOEM-2013-0012 Stone Energy N-09684 Initial Exploration Plan Other   2013-03-25T04:00:00Z 2013 3 2013-03-25T04:00:00Z 2013-04-06T03:59:59Z 2013-03-25T17:55:48Z   0 0 0900006481242129
BOEM-2013-0011-0001 BOEM Shell Offshore Inc. S-7599 Supplemental Exploration Plan BOEM-2013-0011 Shell Offshore Inc. S-7599 Supplemental Exploration Plan Other   2013-03-22T04:00:00Z 2013 3 2013-03-22T04:00:00Z 2013-04-03T03:59:59Z 2013-03-22T15:48:28Z   0 0 090000648123da23
BOEM-2013-0010-0001 BOEM LLOG N-9690 Initial Exploration Plan BOEM-2013-0010 LLOG N-9690 Initial Exploration Plan Other   2013-03-18T04:00:00Z 2013 3 2013-03-18T04:00:00Z 2013-03-30T03:59:59Z 2013-03-20T02:00:47Z   0 0 09000064812320cc
BOEM-2013-0006-0001 BOEM ENI S-7580 Supplemental Development Operations Coordinations Document BOEM-2013-0006 ENI S-7580 Supplemental Development Operations Coordinations Document Other   2013-01-24T05:00:00Z 2013 1 2013-01-24T05:00:00Z 2013-02-05T04:59:59Z 2013-01-25T01:25:24Z   0 0 09000064811d6953
BOEM-2013-0004-0001 BOEM Statoil N-09669 Initial Exploration Plan BOEM-2013-0004 Statoil N-09669 Initial Exploration Plan Other   2013-01-23T05:00:00Z 2013 1 2013-01-23T05:00:00Z 2013-02-04T04:59:59Z 2013-01-23T16:02:20Z   0 0 09000064811d36c8
BOEM-2013-0003-0001 BOEM Shell R-5746 Revised Development Operations Coordinations Document BOEM-2013-0003 Shell R-5746 Revised Development Operations Coordinations Document Other   2013-01-16T05:00:00Z 2013 1 2013-01-16T05:00:00Z 2013-01-29T04:59:59Z 2013-01-16T15:30:08Z   0 0 09000064811c0d3e
BOEM-2013-0001-0001 BOEM Murphy S-07590 Supplemental Exploration Plan BOEM-2013-0001 Murphy S-07590 Supplemental Exploration Plan Other   2013-01-08T05:00:00Z 2013 1 2013-01-08T05:00:00Z 2013-01-20T04:59:59Z 2013-01-15T03:02:11Z   0 0 09000064811b0361

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE documents (
    id TEXT PRIMARY KEY,
    agency_id TEXT,
    docket_id TEXT REFERENCES dockets(id),
    title TEXT,
    document_type TEXT,
    subtype TEXT,
    posted_date TEXT,
    posted_year INTEGER,
    posted_month INTEGER,
    comment_start_date TEXT,
    comment_end_date TEXT,
    last_modified TEXT,
    fr_doc_num TEXT,
    open_for_comment INTEGER,
    withdrawn INTEGER,
    object_id TEXT
);
CREATE INDEX idx_docs_agency ON documents(agency_id);
CREATE INDEX idx_docs_docket ON documents(docket_id);
CREATE INDEX idx_docs_date ON documents(posted_date);
CREATE INDEX idx_docs_year ON documents(posted_year);
CREATE INDEX idx_docs_type ON documents(document_type);
CREATE INDEX idx_docs_frnum ON documents(fr_doc_num);
CREATE INDEX idx_docs_comment_end ON documents(comment_end_date) WHERE comment_end_date IS NOT NULL AND withdrawn = 0;