names

34 rows where place_id = 596757

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626063 1903010 1903010 defendant Mathewe Robert yeoman 596757 596757 Mathewe, Robert, of Ronton, yeoman 0
3631969 1904812 1904812 plaintiff Harecourt John esq 596757 596757 Harecourt, John, of Ronton, esq 1
3631998 1904823 1904823 plaintiff Harecourt John esq 596757 596757 Harecourt, John, of Ronton, esq 1
3654119 1911551 1911551 plaintiff (not given) Thomas prior of Alton 596757 596757 Alton, Thomas, of Ronton, prior of the monastery of St Mary 0
3654120 1911551 1911551 defendant Parche John yeoman 596757 596757 Parche, John, of Ronton, yeoman 0
3654123 1911552 1911552 plaintiff (not given) Thomas prior of Alton 596757 596757 Alton, Thomas, of Ronton, prior of the Monastery of the Blessed Mary 0
3654124 1911552 1911552 defendant Perche John yeoman 596757 596757 Perche, John, of Ronton, yeoman 0
3682874 1920753 1920753 defendant Cooke Henry weaver 596757 596757 Cooke, Henry, of Ronton, weaver 0
3734903 1937155 1937155 defendant Starky Ralph yeoman 596757 596757 Starky, Ralph, of Ronton, yeoman 3
3755545 1943692 1943692 defendant Harecourt John esq 596757 596757 Harecourt, John, of Ronton, esq 0
3791261 1955100 1955100 defendant Harecourt John esq 596757 596757 Harecourt, John, of Ronton, esq 0
3829278 1967041 1967041 defendant Harecourt John esq 596757 596757 Harecourt, John, of Ronton, esq 0
3887572 1986094 1986094 defendant Harecourt John, senior esq 596757 596757 Harecourt, John, senior, of Ronton, esq 0
3887573 1986094 1986094 defendant Harecourt John, junior gent 596757 596757 Harecourt, John, junior, of Ronton, gent 1
3887574 1986094 1986094 defendant Cockys Thomas laborer 596757 596757 Cockys, Thomas, of Ronton, laborer 2
3917734 1996287 1996287 defendant Barne Richard husbandman 596757 596757 Barne, Richard, of Ronton, husbandman 0
3966400 2012881 2012881 plaintiff Bowdon Edward husbandman 596757 596757 Bowdon, Edward, of Ronton, husbandman 0
4034357 2036961 2036961 plaintiff Harecourt Simon esq 596757 596757 Harecourt, Simon, of Ronton, esq 0
4034360 2036962 2036962 plaintiff Harecourte Simon esq 596757 596757 Harecourte, Simon, of Ronton, esq 0
4096587 2059106 2059106 defendant Coke alias Harecourt John esq 596757 596757 Coke alias Harecourt, John, of Ronton, gent, bastard son of Robert Harecourt, of Broughe Hall, esq 1
4142320 2075490 2075490 defendant Pott Richard smith 596757 596757 Pott, Richard, of Ronton, smith 2
4166100 2083651 2083651 defendant Palmer William blacksmith 596757 596757 Palmer, William, of Ronton, blacksmith 0
4189589 2091859 2091859 defendant Pott Richard husbandman 596757 596757 Pott, Richard, of Ronton, husbandman 2
4318373 2136533 2136533 defendant Harecourt John gent 596757 596757 Harecourt, John, of Ronton, gent 0
4318374 2136533 2136533 defendant Rute Thomas laborer 596757 596757 Rute, Thomas, of Ronton, yeoman, Mason, Thomas, of Ronton, laborer 1
4323846 2138388 2138388 defendant ap Humfrey John laborer 596757 596757 ap Humfrey, John, of Ronton, laborer 2
4327782 2139616 2139616 defendant Bagold alias Gardener Edward laborer 596757 596757 Bagold alias Gardener, Edward, of Ronton, laborer 1
4327784 2139616 2139616 defendant Talbott John laborer 596757 596757 Talbott, John, of Ronton, laborer 3
4503644 2201714 2201714 defendant Smyth Geoffrey   596757 596757 Smyth, Geoffrey, of Ronton 1
4506284 2202465 2202465 plaintiff Talyour Nicholas   596757 596757 Talyour, Nicholas, of Ronton, on his own account 0
4790834 2293225 2293225 defendant Staundon John husbandman 596757 596757 Staundon, John, of Ronton, husbandman 0
4932115 2336440 2336440 defendant Gogh Deius husbandman 596757 596757 Gogh, Deius, of Ronton, husbandman 0
5348949 2459804 2459804 defendant Corbet Robert yeoman 596757 596757 Corbet, Robert, of Ronton, yeoman 0
5348950 2459804 2459804 defendant Scanlowe Thomas husbandman 596757 596757 Scanlowe, Thomas, of Ronton, 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);