names

18 rows where place_id = 654068

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3813278 1962062 1962062 defendant Whitehed Thomas yeoman 654068 654068 Whitehed, Thomas, of Est Wytton, yeoman 7
3899004 1989873 1989873 defendant Patryk Thomas clerk 654068 654068 Patryk, Thomas, of Est Wytton, clerk 0
3930872 2000666 2000666 defendant Stroder alias Bark Richard yeoman 654068 654068 Stroder alias Bark, Richard, of East Wytton, yeoman 0
3930873 2000666 2000666 defendant Oddy Lawrence yeoman 654068 654068 Oddy, Lawrence, of East Wytton, yeoman 1
3930874 2000666 2000666 defendant Amler Robert yeoman 654068 654068 Amler, Robert, of East Wytton, yeoman 2
3930875 2000666 2000666 defendant walker Miles yeoman 654068 654068 walker, Miles, of East Wytton,, yeoman 3
3930876 2000666 2000666 defendant Boynton Robert yeoman 654068 654068 Boynton, Robert, of East Wytton, yeoman 4
3940622 2003871 2003871 defendant Lobley Roger yeoman 654068 654068 Lobley, Roger, of East Wytton, yeoman 4
3969876 2014064 2014064 defendant Warde Christopher yeoman 654068 654068 Warde, Christopher, of East Wytton, yeoman 0
4083558 2054394 2054394 defendant Lobley Anthony yeoman 654068 654068 Lobley, Anthony, of East Wytton, yeoman 0
4083559 2054394 2054394 defendant Skayffe John yeoman 654068 654068 Skayffe, John, of East Wytton, yeoman 1
4094106 2058221 2058221 defendant Askwythe Thomas gent 654068 654068 Askwythe, Thomas, of Est Wytton, or of Upper Newsted, Yorks, gent 0
4229863 2105928 2105928 defendant Atkynson Stephen yeoman 654068 654068 Atkynson, Stephen, of Est Wytton, yeoman 3
4403081 2165612 2165612 defendant Atkinson Stephen yeoman 654068 654068 Atkinson, Stephen, of East Wytton, yeoman 1
4819585 2302198 2302198 defendant Fletcher Robert fletcher 654068 654068 Fletcher, Robert, of East Wytton, fletcher 0
4924257 2334026 2334026 defendant Golthwayt Thomas husbandman 654068 654068 Golthwayt, Thomas, of East Wytton, husbandman 14
4946155 2340781 2340781 defendant Hayopp William shoemaker 654068 654068 Hayopp, William, of Est Wytton, shoemaker 0
5588069 2531280 2531280 defendant Askwith Christopher husbandman 654068 654068 Askwith, Christopher, of Est Wytton, husbandman 1

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