Study 3896 - Residence and Kinship in Stonehouse, Gloucestershire,
1558-1804



Data Description
================


Type
----
Database containing 4 tables and 63 queries (no relationships).


Format
------
Tab delimited ASCII or Microsoft Access.



Using the Data
======
Users may receive the data as either:
1) A Microsoft Access 2.0 database (On request)
2) A Microsoft Access97 database
3) A set of tab delimited ASCII files.

Users who order the tab delimited files will receive the following
files:
OBJECT  NAME IN DATABASE                                TAB FILE NAME
Table   A:1 Resiants Lists                              a1.tab
Table   A:2 Resiants List Entries                       a2.tab
Table   A:3 Properties                                  a3.tab
Table   A:4 Persons                                     a4.tab
Query   C:1 RL titles in date order                     c1.tab
Query   C:2 Property Refs                               c2.tab
Query   C:3 RL all entries original order               c3.tab
Query   C:4 RL all lists original names alpha           c4.tab
Query   C:5 RL per standard name, and (no parameters)   c5.tab
Query   C:9 Person IDs                                  c9.tab
Query   C:10 Person IDs all men alpha                   c10.tab
Query   C:11 MBLR men alpha                             c11.tab
Query   C:12 MBLR men total marriages                   c12.tab
Query   C:13 MBLR men/wives not sig/ID alpha            c13.tab
Query   C:14 MBLR total wives not sig/ID                c14.tab
Query   C:15 MBLR widowers alpha                        c15.tab
Query   C:16 MBLR widows alpha                          c16.tab
Query   C:17 MBLR wives sig alpha                       c17.tab
Query   C:18 MBLR wives sig not ID alpha                c18.tab
Query   C:19 Person IDs all women alpha                 c19.tab
Query   C:20 Person IDs unknown origins                 c20.tab
Query   C:21 Property Areas                             c21.tab
Query   C:22 Property Origins                           c22.tab
Query   C:24 RL entries with typed events               c24.tab
Query   C:30 Typed change events per C                  c30.tab
Query   C:32 Typed change events per list               c32.tab
Query   C:33 Typed change events per type               c33.tab
Query   C:34 Typed change events not sons               c34.tab
Query   C:35 Typed change events not sons per Elliott   c35.tab
Query   C:36 Typed change events incomers               c36.tab
Query   C:37 Person IDs, all TE                         c37.tab
Query   C:38 Person IDs, all men TE                     c38.tab
Query   C:39 Person IDs, all men TE not sons            c39.tab
Query   C:42 Person IDs female events                   c42.tab
Query   C:43 Person IDs, all women TE                   c43.tab
Query   C:46 Person IDs, men in multi-typed events      c46.tab
Query   C:47 Person IDs, women in multi-typed events    c47.tab
Query   C:51 Person IDs, men in cloth typed events      c51.tab
Query   C:52 Person IDs, men in land typed events       c52.tab
Query   C:54 Typed change events/check                  c54.tab
Query   C:55 Person IDs, women in cloth events          c55.tab
Query   C:56 Person IDs, women in land events           c56.tab
Query   C:57 Person IDs, women in other events          c57.tab
Query   C:58 Person IDs, all men TE/fathers             c58.tab
Query   C:59 Person IDs, all women TE/fathers           c59.tab
Query   C:60 Poor alpha                                 c60.tab
Query   C:61 Person IDs, men known bap/marriage         c61.tab
Query   C:62 Person IDs, women known bap/marriage       c62.tab

The results of the following queries have not been saved to tab
delimited ASCII files. Users who receive the study as tab delimited
files will need to rerun these queries (see next section) to generate
their results:

C:6 RL per Elliott date order [occs added]
C:7 RL per list original with Elliott
C:8 RL per list Elliott groups [occs added]
C:23 RL per Elliott all ch/events
C:25 RL per Elliott typed ch/events
C:26 Typed change events C1
C:27 Typed change events C2
C:28 Typed change events C3
C:29 Typed change events C4
C:31 Typed change events per category
C:40 Person IDs, all men TE/Area
C:41 Person IDs, all men TE/Cohort
C:44 Person IDs, all women TE/Area/
C:45 Person IDs, all women TE/Cohort
C:48 Person IDs, TE/subgroups
C:49 RL per list occs alpha with Elliott
C:50 Occupation alpha persons
C:53 Person IDs, men in other typed events



Documentation
=============
The document "dbdef" contains details of the SQL select statements
for all the queries in the database. Note that the SQL syntax is that
used by Microsoft Access97.



Hamish James, History Data Service, 12/08/1999