names

63 rows where place_id = 595673

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621418 1874238 1874238 defendant Exceter John yeoman 595673 595673 Exceter, John, of Long Sutton, yeoman 4
3625483 1875509 1875509 defendant Gay John husbandman 595673 595673 Gay, John, of Long Sutton, husbandman 2
3627371 1903414 1903414 defendant Patrike Richard weaver 595673 595673 Patrike, Richard, of Long Sutton, weaver 0
3633001 1905141 1905141 defendant Jopys William husbandman 595673 595673 Jopys, William, of Long Sutton, husbandman 0
3650647 1910567 1910567 defendant Bolle William husbandman 595673 595673 Bolle, William, of Long Sutton, husbandman 0
3707871 1928760 1928760 defendant Wylson Thomas yeoman 595673 595673 Wylson, Thomas, of Long Sutton, yeoman 2
3708561 1928978 1928978 defendant Burne John gent 595673 595673 Burne, John, of Long Sutton, gent 0
3754172 1943252 1943252 defendant Harte William clerk 595673 595673 Harte, William, of Long Sutton, clerk 0
3779621 1951355 1951355 defendant Parson John husbandman 595673 595673 Parson, John, of Long Sutton, husbandman 0
3782567 1952289 1952289 defendant Hamlyng John butcher 595673 595673 Hamlyng, John, of Long Sutton, butcher 1
3819637 1964020 1964020 defendant Burne John gent 595673 595673 Burne, John, of Long Sutton, gent 0
3836972 1969471 1969471 defendant Nowell Richard husbandman 595673 595673 Nowell, Richard, of Long Sutton, husbandman 0
3886956 1985902 1985902 defendant Gould Robert husbandman 595673 595673 Gould, Robert, of Long Sutton, husbandman 0
3915795 1995661 1995661 defendant Hurde George yeoman 595673 595673 Hurde, George, of Long Sutton, yeoman 0
4037051 2037916 2037916 plaintiff Jenes William yeoman 595673 595673 Jenes, William, of Long Sutton, yeoman 0
4037053 2037917 2037917 plaintiff Jenes William yeoman 595673 595673 Jenes, William, of Long Sutton, yeoman 0
4227467 2105088 2105088 defendant Hurd John yeoman 595673 595673 Hurd, John, of Long Sutton, yeoman 0
4227469 2105089 2105089 defendant Hurde John yeoman 595673 595673 Hurde, John, of Long Sutton, yeoman 0
4227577 2105131 2105131 defendant Boule Mathew tanner 595673 595673 Boule, Mathew, of Long Sutton, tanner 0
4261809 2116904 2116904 defendant Morley Anthony yeoman 595673 595673 Morley, Anthony, of Long Sutton, yeoman 1
4283817 2124249 2124249 defendant Dudley John gent 595673 595673 Dudley, John, of Long Sutton, gent 0
4284992 2124681 2124681 defendant Hutchinson William minister of theology 595673 595673 Hutchinson, William, of Long Sutton, or of Childe Ockford, Dorset, clerk, minister of theology 0
4293803 2127852 2127852 defendant Hutchinson William clerk 595673 595673 Hutchinson, William, of Long Sutton, or of Childe Ockford, Dorset, clerk 0
4301218 2130545 2130545 defendant Dudley John gent 595673 595673 Dudley, John, of Long Sutton, gent 0
4306943 2132569 2132569 defendant Crybbe William husbandman 595673 595673 Crybbe, William, of Long Sutton, husbandman 0
4317570 2136260 2136260 defendant Dudley Thomas gent 595673 595673 Dudley, Thomas, of Long Sutton, gent 0
4338939 2143373 2143373 defendant Langdon Henry   595673 595673 Langdon, Henry, of Long Sutton, mason 0
4366819 2153181 2153181 defendant Hutchinson William clerk 595673 595673 Hutchinson, William, of Long Sutton, clerk 0
4366821 2153182 2153182 defendant Hutchinson William clerk 595673 595673 Hutchinson, William, of Long Sutton, clerk 0
4366822 2153182 2153182 defendant Metford Amicius husbandman 595673 595673 Metford, Amicius, of Long Sutton, husbandman 1
4366824 2153183 2153183 defendant Hutchinson William clerk 595673 595673 Hutchinson, William, of Long Sutton, clerk 0
4366825 2153183 2153183 defendant Metford Aunsin husbandman 595673 595673 Metford, Aunsin, of Long Sutton, husbandman 1
4366826 2153183 2153183 defendant Welman William   595673 595673 Welman, William, of Long Sutton, groom 2
4366828 2153184 2153184 defendant Hutchinson William clerk 595673 595673 Hutchinson, William, of Long Sutton, clerk 0
4380186 2158016 2158016 defendant Hutchinson William clerk 595673 595673 Hutchinson, William, of Long Sutton, clerk 0
4576345 2224109 2224109 defendant Burcy John   595673 595673 Burcy, John, of Long Sutton 0
4778809 2289345 2289345 defendant Cone or Cove Stephen husbandman 595673 595673 Cone or Cove, Stephen, of Long Sutton, husbandman 0
4778837 2289354 2289354 defendant Cone or Cove Stephen husbandman 595673 595673 Cone or Cove, Stephen, of Long Sutton, husbandman 0
4826188 2304225 2304225 defendant Touker John   595673 595673 Touker, John, of Long Sutton, husbandman, vicar 0
4842229 2309103 2309103 defendant Person John husbandman 595673 595673 Person, John, of Long Sutton, husbandman 1
4919107 2332489 2332489 defendant Irlond John yeoman 595673 595673 Irlond, John, of Long Sutton, yeoman 1
4952932 2342837 2342837 defendant Dene Richard husbandman 595673 595673 Dene, Richard, of Long Sutton, husbandman 1
4963524 2346004 2346004 defendant Batte Richard husbandman 595673 595673 Batte, Richard, of Long Sutton, husbandman 0
4971002 2348267 2348267 defendant Crypse John husbandman 595673 595673 Crypse, John, of Long Sutton, husbandman 0
5062656 2375389 2375389 defendant Sylke John gent 595673 595673 Sylke, John, of Long Sutton, gent 0
5211248 2419018 2419018 defendant Palyngton John husbandman 595673 595673 Palyngton, John, of Long Sutton, husbandman 0
5211826 2419197 2419197 defendant Mede Thomas husbandman 595673 595673 Mede, Thomas, of Long Sutton, husbandman 0
5216968 2420703 2420703 defendant Bowern William gent 595673 595673 Bowern, William, of Long Sutton, gent 3
5231966 2424919 2424919 defendant Irlond John husbandman 595673 595673 Irlond, John, of Long Sutton, husbandman 0
5242807 2428100 2428100 defendant Bole Willim husbandman 595673 595673 Bole, Willim, of Long Sutton, husbandman 0
5320219 2451135 2451135 defendant Taillour John laborer 595673 595673 Taillour, John, of Long Sutton, laborer 1
5329967 2454041 2454041 defendant Owyd William husbandman 595673 595673 Owyd, William, of Long Sutton, husbandman 1
5420951 2481197 2481197 defendant Porter Thomas husbandman 595673 595673 Porter, Thomas, of Long Sutton, husbandman 0
5420952 2481197 2481197 defendant Toumys Thomas husbandman 595673 595673 Toumys, Thomas, of Long Sutton, husbandman 1
5438067 2486320 2486320 defendant Smyth Edward yeoman 595673 595673 Smyth, Edward, of Long Sutton, yeoman 1
5465537 2494599 2494599 defendant Porter Thomas husbandman 595673 595673 Porter, Thomas, of Long Sutton, husbandman 0
5481300 2499354 2499354 defendant Boxe John yeoman 595673 595673 Boxe, John, of Long Sutton, yeoman 0
5481301 2499354 2499354 defendant Boxe Edward yeoman 595673 595673 Boxe, Edward, of Long Sutton, yeoman 1
5488667 2501492 2501492 defendant Gay John husbandman 595673 595673 Gay, John, of Long Sutton, husbandman 7
5549073 2519770 2519770 defendant Borne John gent 595673 595673 (Borne, John, of Long Sutton, gent 1
5549074 2519770 2519770 defendant Borne Margaret widow 595673 595673 Borne, Margaret, of Long Sutton, widow 2
5549650 2519945 2519945 defendant Borne John gent 595673 595673 (Borne, John, of Long Sutton, gent 1
5549651 2519945 2519945 defendant Borne Margaret widow 595673 595673 Borne, Margaret, of Long Sutton, widow 2

Advanced export

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

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);