names

29 rows where place_id = 589761

✎ 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
3598653 1867202 1867202 defendant Partryche Thomas butcher 589761 589761 Partryche, Thomas, of Wodebrygge, butcher 0
3598975 1867309 1867309 defendant Hacche Nicholas dyer 589761 589761 Hacche, Nicholas, of Wodebrygge, dyer 1
4649310 2245848 2245848 defendant Fyn John   589761 589761 Fyn, John, of Wodebrygge 2
4782468 2290525 2290525 defendant Essex William glover 589761 589761 Essex, William, of Wodebrygge, glover 3
5068104 2376965 2376965 defendant Walle Roger butcher 589761 589761 Walle, Roger, of Wodebrygge, butcher 0
5068105 2376965 2376965 defendant Wode Robert husbandman 589761 589761 Wode, Robert, of Wodebrygge, husbandman 1
5118940 2391972 2391972 defendant Bery William baker 589761 589761 Bery, William, of Wodebrygge, baker 2
5118942 2391972 2391972 defendant Mersshman Henry beer brewer 589761 589761 Mersshman, Henry, of Wodebrygge, beer brewer 4
5125128 2393824 2393824 defendant Alford Benedict tailor 589761 589761 Alford, Benedict, of Wodebrygge, tailor 0
5134015 2396446 2396446 defendant Rase Thomas (legal representative) 589761 589761 Rase, Thomas, of Wodebrygge, executrix of 2
5134020 2396447 2396447 defendant Rase Thomas (legal representative) 589761 589761 Rase, Thomas, of Wodebrygge, executrix of 2
5157647 2403367 2403367 defendant Kempe John (legal representative) 589761 589761 Kempe, John, of Wodebrygge, executors of 0
5157649 2403367 2403367 defendant Kempe Thomas merchant 589761 589761 Kempe, Thomas, of Wodebrygge, merchant 2
5157650 2403367 2403367 defendant Alvard Thomas yeoman 589761 589761 Alvard, Thomas, of Wodebrygge, yeoman 3
5166597 2405949 2405949 defendant Alvard Benedict tailor 589761 589761 Alvard, Benedict, of Wodebrygge, tailor 0
5202944 2416623 2416623 defendant Alvard Benedict tailor 589761 589761 Alvard, Benedict, of Wodebrygge, tailor 0
5220924 2421815 2421815 defendant Tylley Stephen husbandman 589761 589761 Tylley, Stephen, of Wodebrygge, husbandman 0
5295886 2443786 2443786 defendant Foster Alan yeoman 589761 589761 Foster, Alan, of Wodebrygge, yeoman 1
5391577 2472662 2472662 defendant Alvard Benedict   589761 589761 Alvard, Benedict, of Wodebrygge, beer brewer, administratix of 0
5400307 2475163 2475163 defendant More Robert   589761 589761 More, Robert, of Wodebrygge, paten maker 0
5445406 2488526 2488526 defendant Bulle John mariner 589761 589761 Bulle, John, of Wodebrygge, mariner 0
5497401 2504160 2504160 defendant Hawe John mercer 589761 589761 Hawe, John, of Wodebrygge, mercer 0
5503626 2506049 2506049 defendant Cantell Robert dyer 589761 589761 Cantell, Robert, of Wodebrygge, dyer 0
5533456 2515016 2515016 defendant Lopham Robert pedder 589761 589761 Lopham, Robert, of Wodebrygge, pedder 0
5538841 2516637 2516637 defendant Lathered Richard smith 589761 589761 Lathered, Richard, of Wodebrygge, smith 1
5538865 2516641 2516641 defendant Hert Joan widow 589761 589761 Hert, Joan, of Wodebrygge, widow 0
5569131 2525522 2525522 defendant Purry Edmund husbandman 589761 589761 Purry, Edmund, of Wodebrygge, husbandman 1
5569138 2525524 2525524 defendant Purry Edmund husbandman 589761 589761 Purry, Edmund, of Wodebrygge, husbandman 2
5627207 2552474 2552474 defendant Prestmere John cordwainer 589761 589761 Prestmere, John, of Wodebrygge, cordwainer 4

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