names

40 rows where place_id = 654482

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3932540 2001173 2001173 defendant Freman Richard husbandman 654482 654482 Freman, Richard, of Great Cressyngham, husbandman 0
3932541 2001173 2001173 defendant Wate William butcher 654482 654482 Wate, William, of Great Cressyngham, butcher 1
4455945 2186876 2186876 defendant Boteler Adam chaplain 654482 654482 together with Boteler, Adam, of Great Cressyngham, chaplain 1
4465047 2189730 2189730 defendant Fullere John   654482 654482 Fullere, John, of Great Cressyngham 0
4540586 2212955 2212955 defendant Baldeswell Richard   654482 654482 Baldeswell, Richard, of Great Cressyngham 0
4540587 2212955 2212955 defendant Fullere John   654482 654482 Fullere, John, of Great Cressyngham 1
4540589 2212955 2212955 defendant Glosbrigg Ralph   654482 654482 Glosbrigg, Ralph, of Great Cressyngham 3
4544984 2214352 2214352 defendant atte Strete William   654482 654482 atte Strete, William, of Great Cressyngham 3
4553266 2216953 2216953 defendant Mason Bartholomew   654482 654482 Mason, Bartholomew, of Great Cressyngham 0
4553267 2216953 2216953 defendant Frost John   654482 654482 Frost, John, of Great Cressyngham 1
4559484 2218916 2218916 plaintiff Merston Henry   654482 654482 Merston, Henry, of Great Cressyngham, parson 0
4584763 2226659 2226659 defendant Wolryche Adam butcher 654482 654482 Wolryche, Adam, of Great Cressyngham, butcher 0
4594687 2229591 2229591 defendant Woderyche Adam   654482 654482 Woderyche, Adam, of Great Cressyngham 0
4607779 2233545 2233545 plaintiff Blake John   654482 654482 Blake, John, of Great Cressyngham 0
4620901 2237518 2237518 plaintiff Kent John   654482 654482 Kent, John, of Great Cressyngham 0
4648645 2245658 2245658 plaintiff Taillour Thomas   654482 654482 Taillour, Thomas, of Great Cressyngham 0
4712937 2269360 2269360 defendant Andrewe John yeoman 654482 654482 Andrewe, John, of Great Cressyngham, yeoman 0
4719181 2271348 2271348 plaintiff Berford William master & parson 654482 654482 Berford, William, of Great Cressyngham, master & parson 0
4719183 2271349 2271349 plaintiff Berford William master & parson 654482 654482 Berford, William, of Great Cressyngham, master & parson 0
4719185 2271350 2271350 plaintiff Berford William master & parson 654482 654482 Berford, William, of Great Cressyngham, master & parson 0
4719187 2271351 2271351 plaintiff Berford William master & parson 654482 654482 Berford, William, of Great Cressyngham, master & parson 0
4719460 2271431 2271431 defendant Vilsent Robert smith 654482 654482 Vilsent, Robert, of Great Cressyngham, smith 0
4762879 2284371 2284371 defendant Lesewode Robert yeoman 654482 654482 Lesewode, Robert, of Great Cressyngham, yeoman 0
4807314 2298483 2298483 defendant Ramston Henry yeoman 654482 654482 Ramston, Henry, of Great Cressyngham, yeoman 0
4811691 2299765 2299765 defendant Rollysby John   654482 654482 Rollysby, John, of Great Cressyngham, shepherd 8
4924594 2334129 2334129 defendant Ryslee Margery widow 654482 654482 Ryslee, Margery, of Great Cressyngham, widow 2
4995353 2355454 2355454 defendant Costard Richard yeoman 654482 654482 Costard, Richard, of Great Cressyngham, yeoman 1
5003887 2358026 2358026 defendant Buk John husbandman 654482 654482 Buk, John, of Great Cressyngham, husbandman 4
5012062 2360376 2360376 defendant Foucher William   654482 654482 Foucher, William, of Great Cressyngham, rope maker 0
5049418 2371462 2371462 defendant Bryston William yeoman 654482 654482 Bryston, William, of Great Cressyngham, yeoman 0
5049421 2371462 2371462 defendant Vyncent Robert (legal representative) 654482 654482 Vyncent, Robert, of Great Cressyngham, yeoman, executor of 3
5049422 2371462 2371462 defendant Vyncent Margaret widow 654482 654482 Vyncent, Margaret, of Great Cressyngham, widow 4
5049459 2371473 2371473 defendant Wygenhale Robert yeoman 654482 654482 Wygenhale, Robert, of Great Cressyngham, yeoman 2
5049468 2371474 2371474 defendant Wygenhale Robert yeoman 654482 654482 Wygenhale, Robert, of Great Cressyngham, yeoman 2
5128522 2394816 2394816 defendant Foucher John husbandman 654482 654482 Foucher, John, of Great Cressyngham, husbandman 2
5140728 2398402 2398402 defendant Ryseley Richard gent 654482 654482 Ryseley, Richard, of Great Cressyngham, gent 0
5161847 2404573 2404573 defendant Ryseley Richard gent 654482 654482 Ryseley, Richard, of Great Cressyngham, gent 0
5198096 2415187 2415187 defendant Ryseley Richard gent 654482 654482 Ryseley, Richard, of Great Cressyngham, gent 0
5451728 2490391 2490391 defendant Baldwyn John chaplain 654482 654482 Baldwyn, John, of Great Cressyngham, chaplain 0
5451729 2490391 2490391 defendant Walpole Richard husbandman 654482 654482 Walpole, Richard, of Great Cressyngham, husbandman 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);