names

23 rows where place_id = 599068

✎ 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
3635090 1905773 1905773 defendant Bayle Alan husbandman 599068 599068 Bayle, Alan, of Foxcote, husbandman 0
4416254 2169972 2169972 defendant Wygorn Denis   599068 599068 Wygorn, Denis, of Foxcote 0
4422056 2171773 2171773 defendant Benet William   599068 599068 Benet, William, of Foxcote 0
4493809 2198757 2198757 defendant Martyn Nicholas   599068 599068 Martyn, Nicholas, of Foxcote 0
4631906 2240864 2240864 defendant Thomas John   599068 599068 Thomas, John, of Foxcote 0
4683429 2260419 2260419 defendant Foxcote Thomas de gent 599068 599068 Foxcote, Thomas de, of Foxcote, gent 0
4683431 2260420 2260420 defendant Foxcote Thomas de gent 599068 599068 Foxcote, Thomas de, of Foxcote, gent 0
4695718 2264141 2264141 defendant Roberd John laborer 599068 599068 Roberd, John, of Foxcote, laborer 0
4705856 2267205 2267205 defendant Helyer Nicholas husbandman 599068 599068 Helyer, Nicholas, of Foxcote, husbandman 0
4728691 2274211 2274211 defendant Hugyn John husbandman 599068 599068 Hugyn, John, of Foxcote, husbandman 1
4746210 2279386 2279386 plaintiff Harlewyn John   599068 599068 Harlewyn, John, of Foxcote, parson, on his own account 0
4768611 2286162 2286162 defendant Ruyly Robert husbandman 599068 599068 Ruyly, Robert, of Foxcote, husbandman 0
4934555 2337201 2337201 defendant Byry Richard gent 599068 599068 Byry, Richard, of Foxcote, gent 3
4982806 2351772 2351772 defendant Hattres John husbandman 599068 599068 Hattres, John, of Foxcote, husbandman 0
5371584 2466699 2466699 defendant Soughthall Thomas yeoman 599068 599068 Soughthall, Thomas, of Foxcote, yeoman 1
5389272 2471976 2471976 defendant Sougthall Thomas yeoman 599068 599068 Sougthall, Thomas, of Foxcote, yeoman 1
5401929 2475613 2475613 defendant Southall Thomas yeoman 599068 599068 Southall, Thomas, of Foxcote, yeoman 0
5414839 2479372 2479372 defendant Southall Thomas yeoman 599068 599068 Southall, Thomas, of Foxcote, yeoman 1
5482873 2499821 2499821 defendant Southall Thomas yeoman 599068 599068 Southall, Thomas, of Foxcote, yeoman 1
5525131 2512450 2512450 defendant Sowthall John yeoman 599068 599068 Sowthall, John, of Foxcote, yeoman 0
5611611 2547368 2547368 plaintiff Brasiere John   599068 599068 Brasiere, John, of Foxcote 0
5611613 2547369 2547369 plaintiff Brasiere John, senior   599068 599068 Brasiere, John, senior, of Foxcote 0
5622901 2551096 2551096 plaintiff West Nicholas   599068 599068 West, Nicholas, of Foxcote 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);