names

33 rows where place_id = 757082

✎ 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
4443072 2182796 2182796 defendant Cups Thomas fisher 757082 757082 Cups, Thomas, of Marlebergh, fisher 0
4447241 2184046 2184046 defendant Webbe Thomas   757082 757082 Webbe, Thomas, of Marlebergh 1
4447250 2184047 2184047 defendant Webbe Thomas   757082 757082 Webbe, Thomas, of marlebergh 1
4485465 2196161 2196161 defendant Croftes John   757082 757082 Croftes, John, of Marlebergh, parson of the church of St Peter 0
4513697 2204711 2204711 plaintiff (not given) Walter prior of Brunyng 757082 757082 Brunyng, Walter, of Marlebergh, prior of the house of St Margaret 0
4516683 2205632 2205632 plaintiff Cooke Thomas   757082 757082 Cooke, Thomas, of Marlebergh 0
4526491 2208568 2208568 defendant Brombold Richard   757082 757082 Brombold, Richard, of Marlebergh 0
4526492 2208568 2208568 defendant Smyth Adam   757082 757082 Smyth, Adam, of Marlebergh 1
4526493 2208568 2208568 defendant Holehurst Robert   757082 757082 Holehurst, Robert, of Marlebergh 2
4530125 2209710 2209710 defendant Wolman Hugh   757082 757082 Wolman, Hugh, of Marlebergh 0
4554425 2217316 2217316 plaintiff Grombold Richard   757082 757082 Grombold, Richard, of Marlebergh 0
4556488 2217968 2217968 defendant Coupere Robert   757082 757082 Coupere, Robert, of Marlebergh 8
4557668 2218332 2218332 defendant Purnyour John   757082 757082 Purnyour, John, of Marlebergh 1
4562965 2219987 2219987 defendant Gylot Roger   757082 757082 Gylot, Roger, of Marlebergh 1
4569029 2221901 2221901 plaintiff Warner Robert   757082 757082 Warner, Robert, of Marlebergh 0
4581438 2225661 2225661 defendant Blakeman William   757082 757082 Blakeman, William, of Marlebergh 0
4611956 2234799 2234799 defendant Clerk Henry   757082 757082 Clerk, Henry, of Marlebergh 1
4623028 2238179 2238179 defendant Byde John   757082 757082 Byde, John, of Marlebergh 0
4623029 2238179 2238179 defendant Tarant Richard tailor 757082 757082 Tarant, Richard, of Marlebergh, tailor 1
4624434 2238627 2238627 defendant Markys John   757082 757082 Markys, John, of Marlebergh 0
4628666 2239889 2239889 defendant Sadeler Richard   757082 757082 Sadeler, Richard, of Marlebergh 2
4647768 2245409 2245409 plaintiff Smyth Thomas   757082 757082 Smyth, Thomas, of Marlebergh 0
4655168 2247498 2247498 defendant Tannere Walter shoemaker 757082 757082 (Tannere, Walter, of Marlebergh, shoemaker 1
4673549 2257357 2257357 defendant Glover Richard glover & servant of Nicolle 757082 757082 Glover, Richard, of Marlebergh, glover & servant of Nicolle 1
4681228 2259755 2259755 defendant Hathewey Thomas husbandman 757082 757082 Hathewey, Thomas, of Marlebergh, husbandman 0
4696182 2264286 2264286 defendant Brigdoune William merchant 757082 757082 Brigdoune, William, of Marlebergh, merchant 4
4724079 2272828 2272828 defendant Bibury John   757082 757082 Bibury, John, of Marlebergh, wool monger 0
4724080 2272828 2272828 defendant Peyntour Robert husbandman 757082 757082 Peyntour, Robert, of Marlebergh, husbandman 1
4783258 2290783 2290783 defendant Selewode John plumber 757082 757082 Selewode, John, of Marlebergh, plumber 0
4800648 2296383 2296383 defendant Dudmore William merchant 757082 757082 Dudmore, William, of Marlebergh, merchant 0
4804308 2297534 2297534 defendant Sadeler John sadler 757082 757082 Sadeler, John, of Marlebergh, sadler 1
4847207 2310625 2310625 defendant Furbour Richard yeoman 757082 757082 Furbour, Richard, of Marlebergh, yeoman 1
5625110 2551790 2551790 plaintiff Bryd John, junior   757082 757082 Bryd, John, junior, of Marlebergh 2

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