names

37 rows where place_id = 609663

✎ 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
3641356 1907750 1907750 defendant Hogon John   609663 609663 Hogon, John, of Rowton, worsted weaver 0
3679618 1919692 1919692 defendant Lyster John gent 609663 609663 Lyster, John, of Rowton, gent 2
3679624 1919693 1919693 defendant Lyster John gent 609663 609663 Lyster, John, of Rowton, gent 2
3756543 1944024 1944024 defendant Hogon William, junior   609663 609663 Hogon, William, junior, of Rowton, husbandman, son of Hogon, John 0
3768292 1947724 1947724 defendant Leche Thomas yeoman 609663 609663 Leche, Thomas, of Rowton, yeoman 0
3769508 1948125 1948125 defendant Deyo Hugh husbandman 609663 609663 Deyo, Hugh, of Rowton, husbandman 2
3774436 1949729 1949729 defendant Hogon William, junior   609663 609663 Hogon, William, junior, of Rowton, husbandman, son of Hogon, John 0
3800647 1958115 1958115 defendant Haynes Richard gent 609663 609663 Haynes, Richard, of Rowton, gent 0
3828347 1966740 1966740 defendant Bowsley William husbandman 609663 609663 Bowsley, William, of Rowton, husbandman 2
3833417 1968378 1968378 defendant Lytster John gent 609663 609663 Lytster, John, of Rowton, gent 0
3863514 1977993 1977993 defendant Henston Thomas husbandman 609663 609663 Henston, Thomas, of Rowton, husbandman 0
3863515 1977993 1977993 defendant Donne William husbandman 609663 609663 Donne, William, of Rowton, husbandman 1
3863516 1977993 1977993 defendant Corne Hugh husbandman 609663 609663 Corne, Hugh, of Rowton, husbandman 2
3863517 1977993 1977993 defendant Corne John laborer 609663 609663 Corne, John, of Rowton, laborer 3
3863530 1977998 1977998 defendant Rowton Thomas husbandman 609663 609663 Rowton, Thomas, of Rowton, husbandman 0
3882619 1984451 1984451 defendant Downton William yeoman 609663 609663 Downton, William, of Rowton, yeoman 1
3882620 1984451 1984451 defendant Bakyn Richard yeoman 609663 609663 Bakyn, Richard, of Rowton, yeoman 2
3919913 1996995 1996995 plaintiff Lyster John gent 609663 609663 Lyster, John, of Rowton, gent 0
3955080 2008841 2008841 plaintiff Lyster Katherine widow 609663 609663 Lyster, Katherine, of Rowton, widow 0
3975665 2016048 2016048 defendant Bryght Thomas husbandman 609663 609663 Bryght, Thomas, of Rowton, husbandman 0
3991690 2021785 2021785 defendant Doune or Donne Mathew husbandman 609663 609663 Doune or Donne, Mathew, of Rowton, husbandman 0
4022570 2032795 2032795 defendant Wigmore Robert (legal representative) 609663 609663 Wigmore, Robert, of Rowton, gent, executors of 0
4022571 2032795 2032795 defendant Wygmore Joan widow 609663 609663 (Wygmore, Joan, of Rowton, widow 1
4022572 2032795 2032795 defendant Wigmore Robert   609663 609663 Wigmore, Robert, of Rowton, gent, his son 2
4022573 2032795 2032795 defendant Wigmore Bartholomew   609663 609663 Wigmore, Bartholomew, of Rowton, gent, his son 3
4086094 2055299 2055299 defendant Bates Christopher carpenter 609663 609663 Bates, Christopher, of Rowton, carpenter 0
4153835 2079440 2079440 defendant Lyster Gabriel gent 609663 609663 Lyster, Gabriel, of Rowton, gent 0
4166717 2083855 2083855 defendant Syll Richard mariner 609663 609663 Syll, Richard, of Rowton, mariner 2
4258924 2115957 2115957 defendant Arger Barnaby clerk 609663 609663 Arger, Barnaby, of Rowton, clerk 0
4320624 2137304 2137304 defendant Warde William yeoman 609663 609663 Warde, William, of Rowton, yeoman 0
4320625 2137304 2137304 defendant Webster Peter butcher 609663 609663 Webster, Peter, of Rowton, butcher 1
4332722 2141228 2141228 defendant Warde William yeoman 609663 609663 Warde, William, of Rowton, yeoman 0
4332723 2141228 2141228 defendant Webster Peter butcher 609663 609663 Webster, Peter, of Rowton, butcher 1
4340305 2143873 2143873 defendant Webster Peter yeoman 609663 609663 Webster, Peter, of Rowton, yeoman 0
4343533 2145015 2145015 defendant Langdale Henry yeoman 609663 609663 Langdale, Henry, of Rowton, yeoman 1
5578551 2528361 2528361 defendant Hogon William (legal representative) 609663 609663 Hogon, William, of Rowton, yeoman, executrix of 7
5578552 2528361 2528361 defendant Hogon Katherine widow 609663 609663 Hogon, Katherine, of Rowton, widow 8

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