Contacts

Table/Column Description/notes Sample Data
extract_charity One per registered/removed main charity
regno registered number of a charity 200012
subno subsidiary number of a charity (may be 0 for main/group charity) 0
name main name of the charity CHURCH AND POOR'S CHARITY
orgtype R (registered) or RM (removed) R
gd Description of Governing Document SCHEME OF 24 JANUARY 1911
aob area of benefit - may not be defined PARISH OF WRESTLINGWORTH
aob_defined area of benefit defined by Governing Document (T/F) F
nhs NHS charity (T/F) F
ha_no Housing Association number
corr Charity correspondent name MRS VALERIE MOLES
add1 address line of charity's correspondent Greenhaven
add2 address line of charity's correspondent Sunnymead Orchard
add3 address line of charity's correspondent Station Road
add4 address line of charity's correspondent Ashwell
add5 address line of charity's correspondent BALDOCK
postcode postcode of charity's correspondent SG7 5RL
phone telephone of charity's correspondent 01462 742245
fax fax of charity's correspondent 1463 742245
extract_class_ref classification reference
classno classification code 101
classtext description of a classification code GENERAL CHARITABLE PURPOSES
extract_remove_ref Reference for remcode in extract_registration
code Register removal reason code A
text Removal reason description AMALGAMATED
extract_registration registration details & removals
regno registered number of a charity 200012
artype subsidiary number of a charity (may be 0 for main/group charity) 0
regdate date of registration for a charity 22-06-1961 00:00
remdate Removal date of a charity - Blank for Registered Charities
remcode Register removal reason code
extract_name Main old and working names for a charity
regno registered number of a charity 200012
subno subsidiary number of a charity (may be 0 for main/group charity) 0
nameno number identifying a charity name 169727
name name of a charity (multiple occurrences possible) CHURCH AND POOR'S CHARITY
extract_class classification details
regno registered number of a charity 200012
class classification code for a charity (multiple occurrences possible) 301
extract_trustee trustee names
regno registered number of a charity 200012
trustee Name of a charity trustee MR Hugh Williams
extract_objects charity objects. Records with sequence numbers
regno registered number of a charity 200012
subno subsidiary number of a charity (may be 0 for main/group charity) 0
seqno Sequence number (in practice 0-20) 0
object Description of objects of a charity 1) A YEARLY PAYMENT TO THE RECTOR FOR THE TIME BEING OF THE ECCLESIASTICAL PARISH OF WRESTLINGWORTH ST PETER FOR A SERMON. 2) FOR SUCH PURPOSES IN
extract_keyword Keywords from charity names and objects
regno registered number of a charity 200012
subno subsidiary number of a charity (may be 0 for main/group charity) 0
type 0 = object: all other values = name
keyword
extract_aob_keyword Keywords from description of area of benefit
regno registered number of a charity 200012
subno subsidiary number of a charity (may be 0 for main/group charity) 0
keyword
extract_charity_aoo Area of operation for a charity
regno registered number of a charity 200012
aootype A B or D
aookey up to three digits
welsh Flag: Y or blank F
master may be blank. If aootype=D then holds continent; if aootype=B then holds GLA/met county
extract_aoo_ref Description of an area of operation
aootype "A (wide) B (LA)
aookey Values if aootype=A are: 1 England/Wales; 2 England; 3 Wales; 4 London.
aooname name of an area of operation
aoosort "for searches 'City of' removed from aooname"
welsh Flag: Y or blank Y
master may be blank. If aootype=D then holds continent; if aootype=B then holds GLA/met county
extract_ar_submit AR submissions for a charity
regno registered number of a charity 200012
arno annual return mailing cycle code AR04
submit_date date submitted aootype
extract_main_charity One for every registered number
regno registered number of a charity 200012
coyno company registration number 246884
trustees trustees incorporated (T/F) F
fyend Financial year end 00:00.0
welsh requires correspondence in both Welsh & English (T/F)
incomedate date for latest gross income (blank if income is an estimate) 30-09-2016 00:00
income 431814
grouptype may be blank SCH
email email address mgv@rwjohnson.co.uk
web website address www.mitchamgardenvillage.co.uk
extract_acct_submit Account submissions for a charity
regno registered number of a charity 200012
submit_date date submitted
arno annual return mailing cycle code
fyend Charity's financial year end date (may be blank) 3009
extract_financial Financial history for a charity
regno registered number of a charity 200012
fystart Charity's financial year start date 1/4/2003 0:00
fyend Charity's financial year end date 31-03-2004 00:00
income 2435
expend 2487
n