names

21 rows where place_id = 590251

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3600373 1867762 1867762 defendant Bekwyth Elizabeth widow 590251 590251 Bekwyth, Elizabeth, of Beverlay, widow 0
3620214 1873900 1873900 defendant Eles Elias glover 590251 590251 Eles, Elias, of Beverlay, glover 0
3913991 1995024 1995024 plaintiff Browne Richard merchant 590251 590251 Browne, Richard, of Beverlay, merchant 0
4459290 2187954 2187954 plaintiff Roynton Joan   590251 590251 Roynton, Joan, of Beverlay, formerly wife of William 0
4462084 2188843 2188843 defendant West Robert   590251 590251 West, Robert, of Beverlay 0
4466292 2190117 2190117 plaintiff Ython William draper 590251 590251 Ython, William, of Beverlay, draper 0
4515703 2205334 2205334 defendant Alnot John butcher 590251 590251 Alnot, John, of Beverlay, butcher 0
4561009 2219396 2219396 plaintiff Ottelay William de (legal representative) 590251 590251 Ottelay, William de, of Beverlay, parson of St Nicholas church, administrator of 0
4564852 2220570 2220570 defendant Bolys John   590251 590251 Bolys, John, of Beverlay 12
4691932 2263011 2263011 defendant Wathen William fisher 590251 590251 Wathen, William, of Beverlay, fisher 3
4691933 2263011 2263011 defendant Moys John   590251 590251 Moys, John, of Beverlay, shoe maker 4
4714235 2269783 2269783 defendant Crosby William potter 590251 590251 Crosby, William, of Beverlay, potter 1
4871696 2318116 2318116 defendant Howell John yeoman 590251 590251 Howell, John, of Beverlay, yeoman 0
4898914 2326302 2326302 defendant Jefrason Robert barker 590251 590251 Jefrason, Robert, of Beverlay, barker 0
5057731 2373881 2373881 defendant Messanger John weaver 590251 590251 Messanger, John, of Beverlay, weaver 0
5062940 2375445 2375445 defendant Broune John yeoman 590251 590251 Broune, John, of Beverlay, yeoman 0
5086661 2382491 2382491 defendant Stabyll John   590251 590251 Stabyll, John, of Beverlay, mason 2
5308809 2447674 2447674 defendant Payne Thomas husbandman 590251 590251 Payne, Thomas, of Beverlay, husbandman 1
5492790 2502762 2502762 defendant Sprotley Richard chaplain 590251 590251 Sprotley, Richard, of Beverlay, chaplain 0
5514982 2509526 2509526 defendant Wode Robert clerk 590251 590251 Wode, Robert, of Beverlay, clerk 0
5577650 2528077 2528077 defendant Gylson Robert   590251 590251 Gylson, Robert, of Beverlay, surgeon 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);