names

21 rows where place_id = 703385

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3980790 2017892 2017892 defendant Rede Walter (legal representative) 703385 703385 Rede, Walter, of Langporte, Soms tanner, executrix of 1
4072486 2050464 2050464 plaintiff Palmer Henry baker 703385 703385 Palmer, Henry, of Langporte Eastover, baker 0
4147430 2077242 2077242 defendant Wolmyngton Thomas clothier 703385 703385 Wolmyngton, Thomas, of Langporte, clothier 1
4176093 2087115 2087115 defendant Pullen William smith 703385 703385 Pullen, William, of Langporte, smith 2
4179762 2088396 2088396 defendant Welshe Walter tucker 703385 703385 Welshe, Walter, of Langporte, tucker 0
4192983 2093111 2093111 defendant Curteys David husbandman 703385 703385 Curteys, David, of Langporte Estover, husbandman 0
4195295 2093903 2093903 defendant Wynterheye Philip gent 703385 703385 Wynterheye, Philip, of Langporte Estover, gent 0
4196970 2094491 2094491 defendant Welshe Walter tucker 703385 703385 Welshe, Walter, of Langporte Estover, tucker 0
4202003 2096244 2096244 defendant Welshe Walter yeoman 703385 703385 Welshe, Walter, of Langporte, yeoman 0
4202005 2096245 2096245 defendant Welshe Walter yeoman 703385 703385 Welshe, Walter, of Langporte, yeoman 0
4205207 2097372 2097372 defendant Welshe Walter sherman or clothworker 703385 703385 Welshe, Walter, of Langporte Estover, sherman or clothworker 0
4221297 2102947 2102947 defendant Deane Francis yeoman 703385 703385 together with Deane, Francis, of Langporte, yeoman 2
4236805 2108449 2108449 defendant Gold William husbandman 703385 703385 Gold, William, of Langporte Estover, husbandman 0
4286218 2125125 2125125 defendant Thomas William yeoman 703385 703385 Thomas, William, of Langporte Estover, yeoman 0
4294853 2128245 2128245 defendant Thomas William yeoman 703385 703385 Thomas, William, of Langporte Estover, yeoman 0
4303332 2131293 2131293 defendant Souchey Andrew yeoman 703385 703385 Souchey, Andrew, of Langporte, yeoman 0
4303335 2131293 2131293 defendant Serle William husbandman 703385 703385 Serle, William, of Langporte, husbandman 3
4364187 2152247 2152247 defendant Thomas Robert yeoman 703385 703385 Thomas, Robert, of Langporte, yeoman 0
4371136 2154737 2154737 defendant Poper or Popell Richard husbandman 703385 703385 Poper or Popell, Richard, of Langporte, husbandman 0
4378799 2157492 2157492 defendant Whyte Thomas butcher 703385 703385 Whyte, Thomas, of Langporte, butcher 0
4526940 2208709 2208709 defendant Milner John   703385 703385 Milner, John, of Langporte 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);