names

45 rows where place_id = 757051

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4442736 2182681 2182681 defendant Wetewang William de   757051 757051 Wetewang, William de, of Seteryngton 1
4442740 2182683 2182683 defendant Wetewant William de   757051 757051 Wetewant, William de, of Seteryngton 0
4442749 2182686 2182686 defendant Wetewang William de   757051 757051 Wetewang, William de, of Seteryngton 1
4442860 2182725 2182725 defendant del Grene John   757051 757051 del Grene, John, of Seteryngton 0
4450538 2185132 2185132 defendant Bukton John de   757051 757051 Bukton, John de, of Seteryngton 0
4496363 2199538 2199538 defendant Foxholes Thomas   757051 757051 Foxholes, Thomas, of Seteryngton 0
4496365 2199539 2199539 defendant Foxholes Thomas   757051 757051 Foxholes, Thomas, of Seteryngton 0
4498356 2200144 2200144 defendant Morlay William   757051 757051 Morlay, William, of Seteryngton 0
4498357 2200144 2200144 defendant Chaloner Thomas   757051 757051 Chaloner, Thomas, of Seteryngton 1
4506917 2202635 2202635 defendant Wetewang William   757051 757051 Wetewang, William, of Seteryngton 0
4512883 2204460 2204460 defendant Wodeburgh John   757051 757051 Wodeburgh, John, of Seteryngton 0
4514304 2204891 2204891 defendant Pikeryng John de chaplain 757051 757051 Pikeryng, John de, of Seteryngton, chaplain 0
4538346 2212282 2212282 defendant Wodeburgh John   757051 757051 (Wodeburgh, John, of Seteryngton 1
4579193 2224975 2224975 defendant Foxeles Thomas   757051 757051 Foxeles, Thomas, of Seteryngton 0
4616221 2236075 2236075 defendant Wetewang William   757051 757051 Wetewang, William, of Seteryngton 0
4641440 2243592 2243592 defendant Wetewang William   757051 757051 Wetewang, William, of Seteryngton 1
4659641 2248868 2248868 defendant Wetewang William husbandman 757051 757051 Wetewang, William, of Seteryngton, husbandman 3
4664628 2250415 2250415 defendant Wetewang William husbandman 757051 757051 Wetewang, William, of Seteryngton, husbandman 3
4671002 2256600 2256600 defendant Taillour Robert yeoman 757051 757051 Taillour, Robert, of Seteryngton, yeoman 0
4723975 2272797 2272797 defendant Huland Robert chaplain 757051 757051 Huland, Robert, of Seteryngton, chaplain 1
4749098 2280222 2280222 plaintiff Neuton Robert   757051 757051 Neuton, Robert, of Seteryngton, parson 0
4758406 2283005 2283005 defendant Caa John laborer 757051 757051 Caa, John, of Seteryngton, laborer 1
4758407 2283005 2283005 defendant Carter Walter laborer 757051 757051 Carter, Walter, of Seteryngton, laborer 2
4805994 2298086 2298086 defendant Brymlay John laborer 757051 757051 Brymlay, John, of Seteryngton, laborer 0
4813992 2300486 2300486 plaintiff Barton John   757051 757051 Barton, John, of Seteryngton, parson 3
4832201 2306104 2306104 defendant Brymlay John laborer 757051 757051 Brymlay, John, of Seteryngton, laborer 0
4840682 2308626 2308626 plaintiff Barton John   757051 757051 Barton, John, of Seteryngton, parson 3
5105182 2387955 2387955 defendant Selby Thomas chaplain 757051 757051 Selby, Thomas, of Seteryngton, chaplain 0
5137649 2397526 2397526 plaintiff Preston Thomas   757051 757051 Preston, Thomas, of Seteryngton 0
5290122 2442118 2442118 defendant Bolfour John husbandman 757051 757051 Bolfour, John, of Seteryngton, husbandman 1
5290123 2442118 2442118 defendant Danyson or Davyson Joan widow 757051 757051 Danyson or Davyson, Joan, of Seteryngton, widow 2
5290124 2442118 2442118 defendant Carter Richard weaver 757051 757051 Carter, Richard, of Seteryngton, weaver 3
5290125 2442118 2442118 defendant Freman Thomas husbandman 757051 757051 Freman, Thomas, of Seteryngton, husbandman 4
5299515 2444834 2444834 plaintiff Bukton Robert gent 757051 757051 Bukton, Robert, of Seteryngton, gent 0
5331369 2454460 2454460 defendant Bedlyngton Robert husbandman 757051 757051 Bedlyngton, Robert, of Seteryngton, husbandman 0
5335959 2455825 2455825 defendant Bukton Robert esq 757051 757051 Bukton, Robert, of Seteryngton, esq 0
5335961 2455826 2455826 defendant Bukton Robert esq 757051 757051 Bukton, Robert, of Seteryngton, esq 0
5385607 2470953 2470953 defendant Geste Edmund yeoman 757051 757051 Geste, Edmund, of Seteryngton, yeoman 0
5385609 2470954 2470954 defendant Geste Edmund yeoman 757051 757051 Geste, Edmund, of Seteryngton, yeoman 0
5477528 2498293 2498293 defendant Bygod Richard clerk 757051 757051 Bygod, Richard, of Seteryngton, clerk 2
5488984 2501576 2501576 defendant Bygod Richard clerk 757051 757051 Bygod, Richard, of Seteryngton, clerk 1
5528396 2513420 2513420 defendant Bigod Ralph   757051 757051 Bigod, Ralph, of Seteryngton, knight 3
5612242 2547570 2547570 defendant Sergeant Simon   757051 757051 Sergeant, Simon, of Seteryngton 0
5615984 2548796 2548796 defendant Proctour Thomas   757051 757051 Proctour, Thomas, of Seteryngton 0
5633713 2554544 2554544 defendant Lare Richard husbandman 757051 757051 Lare, Richard, of Seteryngton, husbandman 0

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);