names

33 rows where place_id = 593600

✎ 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
3612534 1871553 1871553 defendant Creche Richard husbandman 593600 593600 Creche, Richard, of Pesemerssh, husbandman 0
4509816 2203556 2203556 defendant Beneyt Ralph (legal representative) 593600 593600 Beneyt, Ralph, of Pesemerssh, executors of 0
4630978 2240582 2240582 defendant Mot William   593600 593600 Mot, William, of Pesemerssh 0
4640033 2243211 2243211 defendant Brethe John   593600 593600 Brethe, John, of Pesemerssh 2
4669991 2256313 2256313 defendant Brodeney John laborer 593600 593600 Brodeney, John, of Pesemerssh, laborer 1
4682986 2260294 2260294 defendant Motte William yeoman 593600 593600 Motte, William, of Pesemerssh, yeoman 0
4682987 2260294 2260294 defendant Douve John laborer 593600 593600 Douve, John, of Pesemerssh, laborer 1
4711519 2268931 2268931 defendant Stevene Richard husbandman 593600 593600 Stevene, Richard, of Pesemerssh, husbandman 2
4734169 2275867 2275867 defendant Kempe John, sen husbandman 593600 593600 Kempe, John, sen, of Pesemerssh, husbandman 0
4734171 2275867 2275867 defendant Stevene John husbandman 593600 593600 (Stevene, John, of Pesemerssh, husbandman 2
4737929 2276969 2276969 defendant Breche John husbandman 593600 593600 Breche, John, of Pesemerssh, husbandman 0
4744771 2278985 2278985 defendant Wattle John husbandman 593600 593600 Wattle, John, of Pesemerssh, husbandman 4
4748388 2280034 2280034 defendant Wyndere William laborer 593600 593600 Wyndere, William, of Pesemerssh, laborer 0
4768930 2286262 2286262 defendant Stephene Richard husbandman 593600 593600 Stephene, Richard, of Pesemerssh, husbandman 2
4782486 2290532 2290532 defendant Watel John butcher 593600 593600 Watel, John, of Pesemerssh, butcher 0
4782494 2290534 2290534 defendant Watel John butcher 593600 593600 Watel, John, of Pesemerssh, butcher 0
4784456 2291142 2291142 defendant Romayn John husbandman 593600 593600 Romayn, John, of Pesemerssh, husbandman 1
4796997 2295220 2295220 defendant Romayn John husbandman 593600 593600 Romayn, John, of Pesemerssh, husbandman 1
4800239 2296252 2296252 defendant Stephen Richard husbandman 593600 593600 Stephen, Richard, of Pesemerssh, husbandman 0
4800242 2296253 2296253 defendant Watell John husbandman 593600 593600 Watell, John, of Pesemerssh, husbandman 0
4869071 2317298 2317298 defendant Lynam Thomas husbandman 593600 593600 Lynam, Thomas, of Pesemerssh, husbandman 1
4950306 2342061 2342061 defendant Castelwyse John husbandman 593600 593600 Castelwyse, John, of Pesemerssh, husbandman 0
5058848 2374213 2374213 defendant Bette Robert husbandman 593600 593600 Bette, Robert, of Pesemerssh, husbandman 0
5078765 2380137 2380137 defendant Jenkyn William laborer 593600 593600 Jenkyn, William, of Pesemerssh, laborer 0
5096246 2385340 2385340 defendant Stephyn John husbandman 593600 593600 Stephyn, John, of Pesemerssh, husbandman 0
5257704 2432530 2432530 defendant Watte John laborer 593600 593600 Watte, John, of Pesemerssh, laborer 0
5257705 2432530 2432530 defendant Watels Simon laborer 593600 593600 Watels, Simon, of Pesemerssh, laborer 1
5257706 2432530 2432530 defendant Langley Richard laborer 593600 593600 Langley, Richard, of Pesemerssh, laborer 2
5257707 2432530 2432530 defendant Randolf John laborer 593600 593600 Randolf, John, of Pesemerssh, laborer 3
5257710 2432530 2432530 defendant Watell Thomas laborer 593600 593600 Watell, Thomas, of Pesemerssh, laborer 6
5283659 2440268 2440268 defendant Wody John gent 593600 593600 Wody, John, of Pesemerssh, gent 0
5492338 2502622 2502622 defendant Wody John gent 593600 593600 Wody, John, of Pesemerssh, gent 1
5507111 2507133 2507133 defendant Wody John gent 593600 593600 Wody, John, of Pesemerssh, gent 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);