names

25 rows where place_id = 593235

✎ 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
3611001 1871118 1871118 defendant Eyer John husbandman 593235 593235 Eyer, John, of Langtre, husbandman 2
3730779 1935854 1935854 plaintiff Browne John   593235 593235 Browne, John, of Langtre 0
3763134 1946101 1946101 defendant Browne John, senior gent 593235 593235 Browne, John, senior, of Langtre, gent 0
3763135 1946101 1946101 defendant Browne John, junior gent 593235 593235 Browne, John, junior, of Langtre, gent 1
3785972 1953409 1953409 defendant Marten Richard husbandman 593235 593235 Marten, Richard, of Langtre, husbandman 0
3828100 1966656 1966656 defendant Wysse Richard husbandman 593235 593235 Wysse, Richard, of Langtre, husbandman 0
3892899 1987871 1987871 defendant Prodeham Richard husbandman 593235 593235 Prodeham, Richard, of Langtre, husbandman 1
3892901 1987872 1987872 defendant Prodeham William husbandman 593235 593235 Prodeham, William, of Langtre, husbandman 0
3904785 1991861 1991861 defendant Bacheler John laborer 593235 593235 Bacheler, John, of Langtre, laborer 0
3965254 2012461 2012461 defendant Folle Stephen husbandman 593235 593235 Folle, Stephen, of Langtre, husbandman 0
3981042 2017981 2017981 plaintiff Prudham John   593235 593235 Prudham, John, of Langtre, groom 0
4248229 2112398 2112398 defendant Stapledon John husbandman 593235 593235 Stapledon, John, of Langtre, husbandman 3
4770146 2286631 2286631 defendant Cook Walter   593235 593235 Cook, Walter, of Langtre, parson 0
5076920 2379592 2379592 defendant Laury John clerk 593235 593235 Laury, John, of Langtre, clerk 0
5076921 2379592 2379592 defendant Gotehille John husbandman 593235 593235 Gotehille, John, of Langtre, husbandman 1
5192244 2413467 2413467 defendant Laure John clerk 593235 593235 Laure, John, of Langtre, clerk 0
5192246 2413468 2413468 defendant Laure John clerk 593235 593235 Laure, John, of Langtre, clerk 0
5207680 2417986 2417986 defendant Laure John clerk 593235 593235 Laure, John, of Langtre, clerk 0
5261664 2433759 2433759 defendant Lyttecote William yeoman 593235 593235 Lyttecote, William, of Langtre, yeoman 0
5312859 2448877 2448877 defendant Pakman Thomas husbandman 593235 593235 Pakman, Thomas, of Langtre, husbandman 0
5330207 2454109 2454109 defendant Parkman Thomas husbandman 593235 593235 Parkman, Thomas, of Langtre, husbandman 0
5424177 2482195 2482195 defendant Whytloke William husbandman 593235 593235 Whytloke, William, of Langtre, husbandman 2
5424571 2482322 2482322 defendant Wynscote Thomas laborer 593235 593235 Wynscote, Thomas, of Langtre, laborer 0
5512846 2508873 2508873 defendant Broun Thomas gent 593235 593235 Broun, Thomas, of Langtre, gent 0
5564656 2524249 2524249 defendant Atkyn Nicholas clerk 593235 593235 Atkyn, Nicholas, of Langtre, clerk 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);