names

18 rows where place_id = 762340

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4427212 2173340 2173340 plaintiff Robertes William   762340 762340 Robertes, William, of Brerdyng, son of John, son of William 0
4436113 2176037 2176037 plaintiff Robert William   762340 762340 Robert, William, of Brerdyng, son of John, son of William 0
4486946 2196635 2196635 defendant Glos John   762340 762340 Glos, John, of Brerdyng 1
4502213 2201289 2201289 defendant Howeles John tanner 762340 762340 Howeles, John, of Brerdyng, tanner 0
4593424 2229229 2229229 defendant Rence Geoffrey shoemaker 762340 762340 Rence, Geoffrey, of Brerdyng, shoemaker 2
4610793 2234447 2234447 plaintiff Chapman Thomas (legal representative) 762340 762340 Chapman, Thomas, of Brerdyng, executors of 0
4665884 2250805 2250805 plaintiff Howeles John   762340 762340 Howeles, John, of Brerdyng 0
4801850 2296761 2296761 plaintiff Wynell or Wyvell John   762340 762340 Wynell or Wyvell, John, of Brerdyng 0
4806622 2298280 2298280 defendant Bailly Thomas chapman 762340 762340 with Bailly, Thomas, of Brerdyng, chapman 2
4886246 2322562 2322562 defendant Roulond Thomas shoemaker 762340 762340 Roulond, Thomas, of Brerdyng, shoemaker 0
4886247 2322562 2322562 defendant Bocher Richard butcher 762340 762340 Bocher, Richard, of Brerdyng, butcher 1
5078892 2380172 2380172 defendant Cook Robert husbandman 762340 762340 Cook, Robert, of Brerdyng, husbandman 0
5128786 2394903 2394903 defendant --aford (illegible) tanner 762340 762340 --aford, --, of Brerdyng, tanner 2
5290615 2442257 2442257 defendant Dameles William yeoman 762340 762340 Dameles, William, of Brerdyng, yeoman 0
5293177 2442985 2442985 defendant Crosse Thomas laborer 762340 762340 Crosse, Thomas, of Brerdyng, laborer 0
5583144 2529801 2529801 defendant Howles William laborer 762340 762340 Howles, William, of Brerdyng, laborer 1
5585260 2530455 2530455 defendant Sqwyer William, junior husbandman 762340 762340 Sqwyer, William, junior, of Brerdyng, husbandman 1
5620240 2550186 2550186 defendant Smyth William   762340 762340 Smyth, William, of Brerdyng, vicar 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);