names

31 rows where place_id = 587751

✎ 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
3592345 1865222 1865222 defendant Smyth Richard butcher 587751 587751 Smyth, Richard, of Bongey, Suff, butcher 0
3622685 1874625 1874625 defendant Elham Thomas yeoman 587751 587751 Elham, Thomas, of Bongey, Suff, yeoman 1
3704843 1927808 1927808 defendant Baly William fletcher 587751 587751 Baly, William, of Bongey, Suff, fletcher 0
3745291 1940435 1940435 defendant Leme John   587751 587751 Leme, John, of Bongey, Suff, wheelwright 1
3748650 1941505 1941505 defendant Waren William carver 587751 587751 Waren, William, of Bongey, Suff, carver 1
3761239 1945518 1945518 plaintiff Elys Richard (legal representative) 587751 587751 Elys, Richard, of Bongey, Suff, tanner, executors of 0
3761243 1945519 1945519 plaintiff Elys Richard (legal representative) 587751 587751 Elys, Richard, of Bongey, Suff, tanner, executors of 0
3799510 1957765 1957765 defendant Leche Nicholas butcher 587751 587751 Leche, Nicholas, of Bongey, Suff, butcher 2
3808666 1960591 1960591 defendant Olyet John   587751 587751 Olyet, John, of Bongey, Suff, coverlet weaver 1
3813914 1962261 1962261 defendant Codde John chandler 587751 587751 Codde, John, of Bongey, Suff, chandler 2
3817237 1963304 1963304 defendant Pak John painter 587751 587751 Pak, John, of Bongey, Suff, painter 11
3818409 1963657 1963657 defendant Lane Roger mercer 587751 587751 Lane, Roger, of Bongey, Suff, mercer 0
3875209 1981949 1981949 plaintiff Elyce Richard (legal representative) 587751 587751 Elyce, Richard, of Bongey, Suff, executors of 0
3879782 1983493 1983493 defendant Denny Christopher pinner 587751 587751 Denny, Christopher, of Bongey, Suff, pinner 0
3882304 1984339 1984339 defendant Lane Roger merchant 587751 587751 Lane, Roger, of Bongey, Suff, merchant 0
3898205 1989607 1989607 defendant Hyll William mercer 587751 587751 Hyll, William, of Bongey, Suff, mercer 0
3937670 2002929 2002929 defendant Pryme Thomas yeoman 587751 587751 Pryme, Thomas, of Bongey, Suff, yeoman 0
4021794 2032524 2032524 defendant Tye Edward yeoman 587751 587751 Tye, Edward, of Bongey, Suff, yeoman 0
4046041 2041024 2041024 defendant Edward Robert baker 587751 587751 Edward, Robert, of Bongey, Suff, baker 2
4654075 2247156 2247156 defendant Elyot William butcher 587751 587751 Elyot, William, of Bongey, Suff, butcher 0
4699774 2265371 2265371 defendant Glanvile Richard yeoman 587751 587751 Glanvile, Richard, of Bongey, Suff, yeoman 4
4912643 2330458 2330458 defendant Aleyn John spicer 587751 587751 Aleyn, John, of Bongey, Suff, spicer 1
5028651 2365256 2365256 defendant Grey Geoffrey gent 587751 587751 Grey, Geoffrey, of Bongey, Suff, gent 1
5277184 2438414 2438414 defendant Edryche John yeoman 587751 587751 Edryche, John, of Bongey, Suff, yeoman 0
5335547 2455704 2455704 defendant Overton or Querton Brian yeoman 587751 587751 Overton or Querton, Brian, of Bongey, Suff, yeoman 1
5406369 2476892 2476892 defendant Qwharton Brian gent 587751 587751 Qwharton, Brian, of Bongey, Suff, gent 0
5419464 2480740 2480740 defendant Qwharton Brian gent 587751 587751 Qwharton, Brian, of Bongey, Suff, gent 0
5437816 2486241 2486241 defendant Qwharton Bryan gent 587751 587751 Qwharton, Bryan, of Bongey, Suff, gent 0
5483371 2499973 2499973 defendant Blenkynsoppe Alexander clerk 587751 587751 Blenkynsoppe, Alexander, of Bongey, Suff, clerk 0
5574041 2526969 2526969 defendant Hamerton reyner yeoman 587751 587751 Hamerton, reyner, of Bongey, Suff, yeoman 2
5585602 2530567 2530567 defendant Chynkell Andrew cooper 587751 587751 Chynkell, Andrew, of Bongey, Suff, cooper 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);