names

41 rows where place_id = 585914

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587485 1863733 1863733 plaintiff Aggys Geoffrey   585914 585914 Aggys, Geoffrey, of Nekton 0
3669356 1916354 1916354 plaintiff Bullibroke John   585914 585914 Bullibroke, John, of Nekton 1
3716315 1931395 1931395 defendant Pycher William carpenter 585914 585914 Pycher, William, of Nekton, carpenter 0
3716316 1931395 1931395 defendant Bonyng William chaplain 585914 585914 Bonyng, William, of Nekton, chaplain 1
3716317 1931395 1931395 defendant Skepper Henry husbandman 585914 585914 Skepper, Henry, of Nekton, husbandman 2
3716318 1931395 1931395 defendant Skepper Robert husbandman 585914 585914 Skepper, Robert, of Nekton, husbandman 3
3716319 1931395 1931395 defendant Blomfeld George husbandman 585914 585914 Blomfeld, George, of Nekton, husbandman 4
3716320 1931395 1931395 defendant Myghte Hugh husbandman 585914 585914 Myghte, Hugh, of Nekton, husbandman 5
3716321 1931395 1931395 defendant Waller George husbandman 585914 585914 Waller, George, of Nekton, husbandman 6
3716322 1931395 1931395 defendant Hawke Giles husbandman 585914 585914 Hawke, Giles, of Nekton, husbandman 7
3716323 1931395 1931395 defendant Petyte Henry husbandman 585914 585914 Petyte, Henry, of Nekton, husbandman 8
3716324 1931395 1931395 defendant Skarlet James husbandman 585914 585914 Skarlet, James, of Nekton, husbandman 9
3717314 1931698 1931698 defendant Skarlett James husbandman 585914 585914 Skarlett, James, of Nekton, husbandman 0
3755536 1943689 1943689 defendant Blomevyle George yeoman 585914 585914 Blomevyle, George, of Nekton, yeoman 0
4675665 2257999 2257999 defendant Egeleyn Ralph   585914 585914 Egeleyn, Ralph, of Nekton, wright 0
4713017 2269391 2269391 plaintiff Stalton Walter   585914 585914 Stalton, Walter, of Nekton 0
4760178 2283532 2283532 defendant Hardekyn Geoffrey tailor 585914 585914 Hardekyn, Geoffrey, of Nekton, tailor 1
4953341 2342963 2342963 defendant atte Lane Richard yeoman 585914 585914 atte Lane, Richard, of Nekton, yeoman 0
4988446 2353505 2353505 defendant Pyrt John husbandman 585914 585914 Pyrt, John, of Nekton, husbandman 2
5102560 2387155 2387155 defendant Lemmer Robert shoemaker 585914 585914 Lemmer, Robert, of Nekton, shoemaker 0
5105968 2388185 2388185 plaintiff Costard James   585914 585914 Costard, James, of Nekton 0
5105969 2388185 2388185 defendant Bakke Robert husbandman 585914 585914 Bakke, Robert, of Nekton, husbandman 0
5198014 2415158 2415158 plaintiff Thomas Roger   585914 585914 Thomas, Roger, of Nekton 0
5217919 2420975 2420975 defendant Garam Robert clerk 585914 585914 Garam, Robert, of Nekton, clerk 0
5234432 2425661 2425661 defendant Thweyt Geoffrey husbandman 585914 585914 Thweyt, Geoffrey, of Nekton, husbandman 1
5241793 2427802 2427802 defendant London Geoffrey yeoman 585914 585914 London, Geoffrey, of Nekton, yeoman 0
5288809 2441739 2441739 defendant London Geoffrey yeoman 585914 585914 London, Geoffrey, of Nekton, yeoman 0
5347690 2459430 2459430 defendant Waterman Henry chaplain 585914 585914 Waterman, Henry, of Nekton, chaplain 9
5347691 2459430 2459430 defendant London Geoffrey husbandman 585914 585914 London, Geoffrey, of Nekton, husbandman 10
5478217 2498511 2498511 defendant Bonyng or Bovyng John, senior carpenter 585914 585914 Bonyng or Bovyng, John, senior, of Nekton, carpenter 1
5540985 2517305 2517305 defendant Beer William chaplain 585914 585914 Beer, William, of Nekton, chaplain 0
5540986 2517305 2517305 defendant Beer Richard baker 585914 585914 Beer, Richard, of Nekton, baker 1
5546857 2519085 2519085 plaintiff Vyncent Robert   585914 585914 Vyncent, Robert, of Nekton 3
5578876 2528457 2528457 defendant Rust John, senior sherman 585914 585914 Rust, John, senior, of Nekton, sherman 4
5581914 2529425 2529425 plaintiff Crysted Thomas   585914 585914 Crysted, Thomas, of Nekton 0
5592550 2532659 2532659 defendant Blomfeld John (legal representative) 585914 585914 Blomfeld, John, of Nekton, husbandman, executor of Beyr, William, executor of 0
5596898 2533947 2533947 defendant Waller George smith 585914 585914 Waller, George, of Nekton, smith 0
5596899 2533947 2533947 defendant Coke John laborer 585914 585914 Coke, John, of Nekton, laborer 1
5596900 2533947 2533947 defendant Hawke Giles laborer 585914 585914 Hawke, Giles, of Nekton, laborer 2
5596901 2533947 2533947 defendant Roper John weaver 585914 585914 Roper, John, of Nekton, weaver 3
5597147 2534015 2534015 defendant Blomefeld John (legal representative) 585914 585914 Blomefeld, John, of Nekton, yeoman, executor of 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);