names

28 rows where place_id = 767740

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4504388 2201924 2201924 plaintiff Rolwis Alan   767740 767740 Rolwis, Alan, of Little Waldyngfeld, vicar 0
4542699 2213603 2213603 defendant Merffrey William fuller 767740 767740 Merffrey, William, of Little Waldyngfeld, fuller 5
4542706 2213604 2213604 defendant Merffrey William fuller 767740 767740 Merffrey, William, of Little Waldyngfeld, fuller 5
4547540 2215163 2215163 plaintiff Calle William   767740 767740 Calle, William, of Little Waldyngfeld 0
4607989 2233618 2233618 defendant Monk Thomas   767740 767740 Monk, Thomas, of Little Waldyngfeld 4
4607991 2233619 2233619 defendant Lerecok Margaret   767740 767740 Lerecok, Margaret, of Little Waldyngfeld 0
4672829 2257144 2257144 defendant Ballard John, junior laborer 767740 767740 Ballard, John, junior, of Little Waldyngfeld, laborer 0
4679113 2259073 2259073 defendant Bardener Adma fuller 767740 767740 Bardener, Adma, of Little Waldyngfeld, fuller 0
4687158 2261589 2261589 defendant Gardyner Adam fuller 767740 767740 Gardyner, Adam, of Little Waldyngfeld, fuller 0
4825302 2303955 2303955 defendant Calle Simon husbandman 767740 767740 Calle, Simon, of Little Waldyngfeld, husbandman 0
4844278 2309718 2309718 defendant Hayward John husbandman 767740 767740 Hayward, John, of Little Waldyngfeld, husbandman 0
4847008 2310570 2310570 defendant Smyth alias Dyer Nicholas yeoman 767740 767740 Smyth alias Dyer, Nicholas, of Little Waldyngfeld, yeoman 0
4918683 2332359 2332359 defendant Ive Henry fuller 767740 767740 Ive, Henry, of Little Waldyngfeld, fuller 2
4926112 2334593 2334593 defendant Smyth Nicholas husbandman 767740 767740 Smyth, Nicholas, of Little Waldyngfeld, husbandman 1
4932181 2336462 2336462 defendant Cook William weaver 767740 767740 Cook, William, of Little Waldyngfeld, weaver 1
5003401 2357892 2357892 defendant Berwyk Thomas laborer 767740 767740 Berwyk, Thomas, of Little Waldyngfeld, laborer 0
5137729 2397548 2397548 defendant Appulton John, junior yeoman 767740 767740 Appulton, John, junior, of Little Waldyngfeld, yeoman 2
5307855 2447367 2447367 defendant Rysby John weaver 767740 767740 Rysby, John, of Little Waldyngfeld, weaver 0
5376123 2468123 2468123 plaintiff Rysyng Richard merchant 767740 767740 Rysyng, Richard, of Little Waldyngfeld, merchant 0
5392262 2472876 2472876 plaintiff Rysyng Richard merchant 767740 767740 Rysyng, Richard, of Little Waldyngfeld, merchant 0
5392264 2472877 2472877 plaintiff Rysyng Richard merchant 767740 767740 Rysyng, Richard, of Little Waldyngfeld, merchant 0
5392650 2472963 2472963 defendant Braybroke Hugh husbandman 767740 767740 Braybroke, Hugh, of Little Waldyngfeld, husbandman 1
5393718 2473264 2473264 defendant Gale Richard clothmaker 767740 767740 Gale, Richard, of Little Waldyngfeld, clothmaker 0
5406920 2477042 2477042 defendant Gale Richard   767740 767740 Gale, Richard, of Little Waldyngfeld, cloth maker 0
5413518 2478969 2478969 plaintiff Gale Richard   767740 767740 Gale, Richard, of Little Waldyngfeld 0
5438794 2486524 2486524 defendant Gale Richard clothmaker 767740 767740 Gale, Richard, of Little Waldyngfeld, clothmaker 0
5454479 2491252 2491252 defendant Bronde William yeoman 767740 767740 Bronde, William, of Little Waldyngfeld, yeoman 1
5620296 2550203 2550203 defendant Prat John   767740 767740 Prat, John, of Little Waldyngfeld 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);