names

18 rows where place_id = 612937

✎ 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
3686942 1922082 1922082 defendant Clerke William (legal representative) 612937 612937 Clerke, William, of Tudeley, clothmaker, executors of 1
3695679 1924880 1924880 plaintiff Rayne John   612937 612937 Rayne, John, of Tudeley 0
3715735 1931210 1931210 defendant Kyppyng Petronilla widow 612937 612937 Kyppyng, Petronilla, of Tudeley, widow 1
3715740 1931211 1931211 defendant Kyppyng Petronilla widow 612937 612937 Kyppyng, Petronilla, of Tudeley, widow 1
3756186 1943894 1943894 defendant Browne John yeoman 612937 612937 Browne, John, of Tudeley, yeoman 0
3789817 1954646 1954646 defendant Benett Gregory weaver 612937 612937 Benett, Gregory, of Tudeley, weaver 0
3794548 1956175 1956175 defendant Wyllyams John yeoman 612937 612937 Wyllyams, John, of Tudeley, yeoman 0
3821778 1964698 1964698 defendant Luk Thomas yeoman 612937 612937 Luk, Thomas, of Tudeley, yeoman 0
3838621 1970006 1970006 defendant Bowser John husbandman 612937 612937 Bowser, John, of Tudeley, husbandman 2
3848780 1973204 1973204 defendant Burnet Robert tanner 612937 612937 Burnet, Robert, of Tudeley, tanner 0
3861919 1977446 1977446 defendant Myllys John husbandman 612937 612937 Myllys, John, of Tudeley, husbandman 0
3924879 1998639 1998639 defendant Wylliams John husbandman 612937 612937 Wylliams, John, of Tudeley, husbandman 0
4318090 2136436 2136436 defendant Mylles Richard clothier 612937 612937 Mylles, Richard, of Tudeley, clothier 0
4319331 2136871 2136871 defendant Myll Richard clothier 612937 612937 Myll, Richard, of Tudeley, clothier 1
5097026 2385561 2385561 defendant Wyseman John husbandman 612937 612937 Wyseman, John, of Tudeley, husbandman 6
5541188 2517365 2517365 defendant Wyseman John (legal representative) 612937 612937 Wyseman, John, of Tudeley, clothman, executor of 0
5541189 2517365 2517365 defendant Wyseman Thomas asshburner 612937 612937 Wyseman, Thomas, of Tudeley, asshburner 1
5586824 2530918 2530918 defendant Fane Richard husbandman 612937 612937 Fane, Richard, of Tudeley, 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);