names

26 rows where place_id = 609959

✎ 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
3681245 1920219 1920219 defendant Pamplyn William waterman 609959 609959 Pamplyn, William, of Stowe Bardolff, waterman 0
3780283 1951563 1951563 defendant Rayneham William husbandman 609959 609959 Rayneham, William, of Stowe Bardolff, husbandman 0
3780499 1951632 1951632 defendant Wotton Thomas husbandman 609959 609959 Wotton, Thomas, of Stowe Bardolff, husbandman 2
3892870 1987863 1987863 defendant Sattabe Thomas waterman 609959 609959 Sattabe, Thomas, of Stowe Bardolff, waterman 0
3931353 2000781 2000781 defendant Heynes William laborer 609959 609959 Heynes, William, of Stowe Bardolff, laborer 0
3975275 2015922 2015922 defendant Norryche or Norwyche Henry husbandman 609959 609959 Norryche or Norwyche, Henry, of Stowe Bardolff, husbandman 0
3989241 2020893 2020893 defendant Watson William husbandman 609959 609959 Watson, William, of Stowe Bardolff, husbandman 0
4037020 2037907 2037907 defendant Sylkworth Christopher husbandman 609959 609959 Sylkworth, Christopher, of Stowe Bardolff, husbandman 1
4054586 2044030 2044030 plaintiff Barker William yeoman 609959 609959 Barker, William, of Stowe Bardolff, yeoman 0
4054587 2044030 2044030 defendant Hunter William yeoman 609959 609959 Hunter, William, of Stowe Bardolff, clerk, yeoman 0
4054588 2044031 2044031 plaintiff Barker William yeoman 609959 609959 Barker, William, of Stowe Bardolff, yeoman 0
4054589 2044031 2044031 defendant Hunter William yeoman 609959 609959 Hunter, William, of Stowe Bardolff, yeoman 0
4083703 2054443 2054443 defendant Foxe Thomas butcher 609959 609959 Foxe, Thomas, of Stowe Bardolff, butcher 0
4083704 2054443 2054443 defendant Rawlyn Edmund husbandman 609959 609959 Rawlyn, Edmund, of Stowe Bardolff, husbandman 1
4083705 2054443 2054443 defendant Yryshe John laborer or waterman 609959 609959 Yryshe, John, of Stowe Bardolff, laborer or waterman 2
4102614 2061235 2061235 defendant Fretwell George husbandman 609959 609959 Fretwell, George, of Stowe Bardolff, husbandman 0
5258448 2432757 2432757 defendant Bernesdale Thomas waterman 609959 609959 Bernesdale, Thomas, of Stowe Bardolff, waterman 3
5555570 2521625 2521625 defendant Barnesdale Robert husbandman 609959 609959 Barnesdale, Robert, of Stowe Bardolff, husbandman 0
5555576 2521625 2521625 defendant Guybon Richard husbandman 609959 609959 Guybon, Richard, of Stowe Bardolff, husbandman 6
5555580 2521626 2521626 defendant Crosse Thomas husbandman 609959 609959 Crosse, Thomas, of Stowe Bardolff, husbandman 0
5555581 2521626 2521626 defendant Barnesdale Geoffrey waterman 609959 609959 Barnesdale, Geoffrey, of Stowe Bardolff, waterman 1
5555583 2521626 2521626 defendant Becon Walter husbandman 609959 609959 Becon, Walter, of Stowe Bardolff, husbandman 3
5568894 2525455 2525455 defendant Barnesdale Geoffrey   609959 609959 Barnesdale, Geoffrey, of Stowe Bardolff, yeoman, administrators of 0
5568895 2525455 2525455 defendant Barnesdale Robert yeoman 609959 609959 (Barnesdale, Robert, of Stowe Bardolff, yeoman 1
5568896 2525455 2525455 defendant Barnesdale William   609959 609959 Barnesdale, William, of Stowe Bardolff 2
5597829 2534217 2534217 defendant Reynham William husbandman 609959 609959 Reynham, William, of Stowe Bardolff, husbandman 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);