names

25 rows where place_id = 590703

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602035 1868296 1868296 defendant Aleyn John yeoman 590703 590703 Aleyn, John, of Walton on Thames, Surrey, yeoman 3
3645998 1909142 1909142 defendant Wodecrofte John husbandman 590703 590703 Wodecrofte, John, of Walton on Thames, Surrey, husbandman 0
3686839 1922044 1922044 plaintiff Byers Robert   590703 590703 Byers, Robert, of Walton on Thames, Surrey 0
3786012 1953417 1953417 defendant Dowley Walter yeoman 590703 590703 Dowley, Walter, of Walton on Thames, Surrey, yeoman 4
3870848 1980501 1980501 defendant Leigh Giles esq 590703 590703 Leigh, Giles, of Walton on Thames, Surrey, esq 0
3878502 1983055 1983055 plaintiff Legh Giles esq 590703 590703 Legh, Giles, of Walton on Thames, Surrey, esq 0
4003634 2026064 2026064 defendant Bourne Ralph gent 590703 590703 Bourne, Ralph, of Walton on Thames, Surrey, gent 1
4026030 2033955 2033955 defendant Borne Ralph gent 590703 590703 Borne, Ralph, of Walton on Thames, Surrey, gent 0
4026033 2033956 2033956 defendant Borne Ralph gent 590703 590703 Borne, Ralph, of Walton on Thames, Surrey, gent 0
4026567 2034152 2034152 defendant Bourne Ralph gent 590703 590703 Bourne, Ralph, of Walton on Thames, Surrey, gent 0
4041294 2039374 2039374 defendant Borne Ralph gent 590703 590703 Borne, Ralph, of Walton on Thames, Surrey, gent 0
4041297 2039375 2039375 defendant Bourne Ralph gent 590703 590703 Bourne, Ralph, of Walton on Thames, Surrey, gent 0
4052950 2043490 2043490 defendant Bourn Ralph gent 590703 590703 Bourn, Ralph, of Walton on Thames, Surrey, gent 0
4056082 2044563 2044563 plaintiff Bourne Ralph gent 590703 590703 Bourne, Ralph, of Walton on Thames, Surrey, ,gent 0
4199925 2095523 2095523 defendant Taylor William carpenter 590703 590703 Taylor, William, of Walton on Thames, Surrey, carpenter 2
5079278 2380296 2380296 defendant Halle John husbandman 590703 590703 Halle, John, of Walton on Thames, Surrey, husbandman 1
5079283 2380297 2380297 defendant Halle John husbandman 590703 590703 Halle, John, of Walton on Thames, Surrey, husbandman 1
5146365 2400069 2400069 defendant Halle John husbandman 590703 590703 Halle, John, of Walton on Thames, Surrey, husbandman 1
5166542 2405934 2405934 defendant Halle John husbandman 590703 590703 Halle, John, of Walton on Thames, Surrey, husbandman 1
5181390 2410301 2410301 defendant Halle john husbandman 590703 590703 Halle, john, of Walton on Thames, Surrey, husbandman 1
5183671 2410957 2410957 defendant Quayle John husbandman 590703 590703 Quayle, John, of Walton on Thames, Surrey, husbandman 0
5202905 2416613 2416613 defendant Halle John husbandman 590703 590703 Halle, John, of Walton on Thames, Surrey, husbandman 0
5541877 2517574 2517574 defendant Bremer Thomas yeoman 590703 590703 Bremer, Thomas, of Walton on Thames, Surrey, yeoman 3
5544530 2518398 2518398 defendant Gyles Thomas husbandman 590703 590703 Gyles, Thomas, of Walton on Thames, Surrey, husbandman 2
5576294 2527644 2527644 defendant Gyles Thomas yeoman 590703 590703 Gyles, Thomas, of Walton on Thames, Surrey, yeoman 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);