names

33 rows where place_id = 622413

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3746853 1940935 1940935 defendant Hunt John yeoman 622413 622413 Hunt, John, of Keynsham, yeoman 6
3746855 1940935 1940935 defendant Ilbury John yeoman 622413 622413 Ilbury, John, of Keynsham, yeoman 8
3855806 1975447 1975447 defendant Beche John yeoman 622413 622413 Beche, John, of Keynsham, yeoman 2
3855807 1975447 1975447 defendant Spanley John yeoman 622413 622413 Spanley, John, of Keynsham, yeoman 3
3855808 1975447 1975447 defendant Hyllary John yeoman 622413 622413 Hyllary, John, of Keynsham, yeoman 4
4087994 2056002 2056002 defendant Catcot William gent 622413 622413 Catcot, William, of Keynsham, gent 0
4089771 2056638 2056638 defendant Goslett William gent 622413 622413 Goslett, William, of Keynsham, gent 0
4089772 2056638 2056638 defendant Lammam John, junior yeoman 622413 622413 Lammam, John, junior, of Keynsham, yeoman 1
4089773 2056638 2056638 defendant Abbott William yeoman 622413 622413 Abbott, William, of Keynsham, yeoman 2
4089774 2056638 2056638 defendant Dunne Humphrey laborer 622413 622413 Dunne, Humphrey, of Keynsham, laborer 3
4146564 2076950 2076950 defendant Leman William yeoman 622413 622413 Leman, William, of Keynsham, yeoman 0
4158884 2081175 2081175 defendant Fetyplace Thomas gent 622413 622413 Fetyplace, Thomas, of Keynsham, gent 0
4169436 2084813 2084813 defendant Cole George butcher 622413 622413 Cole, George, of Keynsham, butcher 0
4246720 2111881 2111881 defendant Panter William yeoman 622413 622413 Panter, William, of Keynsham, yeoman 0
4312856 2134626 2134626 defendant Tomson William gent 622413 622413 Tomson, William, of Keynsham, gent 0
5077385 2379736 2379736 defendant Thlewed Thomas tailor 622413 622413 Thlewed, Thomas, of Keynsham, tailor 0
5077386 2379736 2379736 defendant Pope Henry brewer 622413 622413 Pope, Henry, of Keynsham, brewer 1
5077387 2379736 2379736 defendant Doglas John tucker 622413 622413 Doglas, John, of Keynsham, tucker 2
5077388 2379736 2379736 defendant West Nicholas brewer 622413 622413 West, Nicholas, of Keynsham, brewer 3
5077389 2379736 2379736 defendant Goldston Walter   622413 622413 Goldston, Walter, of Keynsham, mason 4
5235720 2426025 2426025 defendant Nele John tailor 622413 622413 Nele, John, of Keynsham, tailor 1
5414282 2479205 2479205 defendant Mody Thomas hosteler 622413 622413 Mody, Thomas, of Keynsham, hosteler 2
5415140 2479468 2479468 defendant Weryngton John laborer 622413 622413 Weryngton, John, of Keynsham, laborer 0
5430053 2483922 2483922 defendant Mody Thomas hosteler 622413 622413 Mody, Thomas, of Keynsham, hosteler 1
5431265 2484295 2484295 defendant Werynton John laborer 622413 622413 Werynton, John, of Keynsham, laborer 0
5441568 2487397 2487397 defendant Mey Thomas innholder 622413 622413 Mey, Thomas, of Keynsham, innholder 0
5442671 2487721 2487721 defendant Catte John   622413 622413 Catte, John, of Keynsham, vicar 0
5447772 2489212 2489212 defendant Werygnton John laborer 622413 622413 Werygnton, John, of Keynsham, laborer 0
5454350 2491209 2491209 defendant May Thomas innholder 622413 622413 May, Thomas, of Keynsham, innholder 0
5460161 2492973 2492973 defendant Weryngton John laborer 622413 622413 Weryngton, John, of Keynsham, laborer 0
5466579 2494943 2494943 defendant Mody Thomas clothier 622413 622413 Mody, Thomas, of Keynsham, clothier 3
5467197 2495132 2495132 defendant Batte John clerk & vicar 622413 622413 Batte, John, of Keynsham, clerk & vicar 0
5467200 2495133 2495133 defendant Batte John clerk & vicar 622413 622413 Batte, John, of Keynsham, clerk & vicar 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);