names

25 rows where place_id = 668983

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3991281 2021645 2021645 defendant Gawpyn William yeoman 668983 668983 Gawpyn, William, of Lytchett Matravers, yeoman 0
3991282 2021645 2021645 defendant Bolney Bartholomew yeoman 668983 668983 Bolney, Bartholomew, of Lytchett Matravers, yeoman 1
3991283 2021645 2021645 defendant Kyrley or Kyrbye William yeoman 668983 668983 Kyrley or Kyrbye, William, of Lytchett Matravers, yeoman 2
3991284 2021645 2021645 defendant Jenkyns Peter yeoman 668983 668983 Jenkyns, Peter, of Lytchett Matravers, yeoman 3
3991285 2021645 2021645 defendant Woodferd John yeoman 668983 668983 Woodferd, John, of Lytchett Matravers, yeoman 4
3991286 2021645 2021645 defendant Hooper Richard yeoman 668983 668983 Hooper, Richard, of Lytchett Matravers, yeoman 5
3991287 2021645 2021645 defendant Wyntrey John yeoman 668983 668983 Wyntrey, John, of Lytchett Matravers, yeoman 6
3991288 2021645 2021645 defendant Churchyll John yeoman 668983 668983 Churchyll, John, of Lytchett Matravers, yeoman 7
3991298 2021647 2021647 defendant Purse John yeoman 668983 668983 Purse, John, of Lytchett Matravers, yeoman 0
3991299 2021647 2021647 defendant Bolney Bartholomew yeoman 668983 668983 Bolney, Bartholomew, of Lytchett Matravers, yeoman 1
3991300 2021647 2021647 defendant Randall William yeoman 668983 668983 Randall, William, of Lytchett Matravers, yeoman 2
3991301 2021647 2021647 defendant Upshawe Andrew yeoman 668983 668983 Upshawe, Andrew, of Lytchett Matravers, yeoman 3
3991302 2021647 2021647 defendant Baker John yeoman 668983 668983 Baker, John, of Lytchett Matravers, yeoman 4
3991303 2021647 2021647 defendant Woodfarde John yeoman 668983 668983 Woodfarde, John, of Lytchett Matravers, yeoman 5
3991304 2021647 2021647 defendant Hennyng John yeoman 668983 668983 Hennyng, John, of Lytchett Matravers, yeoman 6
3991305 2021647 2021647 defendant Churchyll John yeoman 668983 668983 Churchyll, John, of Lytchett Matravers, yeoman 7
3991306 2021647 2021647 defendant Wyntrey John yeoman 668983 668983 Wyntrey, John, of Lytchett Matravers, yeoman 8
3991307 2021647 2021647 defendant Kyrbye William yeoman 668983 668983 Kyrbye, William, of Lytchett Matravers, yeoman 9
3991308 2021647 2021647 defendant Whealer John yeoman 668983 668983 Whealer, John, of Lytchett Matravers, yeoman 10
4158246 2080956 2080956 defendant Holmes William husbandman 668983 668983 Holmes, William, of Lytchett Matravers, husbandman 2
4243533 2110826 2110826 defendant Trenchard George gent 668983 668983 Trenchard, George, of Lytchett Matravers, gent 0
4255400 2114803 2114803 defendant Trenchard George esq 668983 668983 Trenchard, George, of Lytchett Matravers, esq 0
4384279 2159436 2159436 defendant Cooke Charles gent 668983 668983 Cooke, Charles, of Lytchett Matravers, gent 0
4384280 2159436 2159436 defendant Beale Thomas husbandman 668983 668983 Beale, Thomas, of Lytchett Matravers, husbandman 1
4409636 2167821 2167821 defendant Cooke Charles gent 668983 668983 Cooke, Charles, of Lytchett Matravers, gent 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);