names

23 rows where place_id = 610229

✎ 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
3682563 1920652 1920652 defendant Cave William husbandman 610229 610229 Cave, William, of Flixburgh, husbandman 0
4511223 2203957 2203957 plaintiff Bellesby William de   610229 610229 Bellesby, William de, of Flixburgh 0
4526531 2208581 2208581 defendant atte Hill Robert   610229 610229 atte Hill, Robert, of Flixburgh 1
4537728 2212077 2212077 defendant Clerk John   610229 610229 Clerk, John, of Flixburgh 4
4580341 2225331 2225331 defendant Manfeld Richard de   610229 610229 Manfeld, Richard de, of Flixburgh 0
4580344 2225332 2225332 defendant Clerk John butcher 610229 610229 Clerk, John, of Flixburgh, butcher 0
4673568 2257365 2257365 plaintiff Miler John   610229 610229 Miler, John, of Flixburgh, parson 2
4745990 2279327 2279327 defendant Haytfeld John gent 610229 610229 (Haytfeld, John, of Flixburgh, gent 1
5102852 2387252 2387252 defendant Clerk Nicholas husbandman 610229 610229 Clerk, Nicholas, of Flixburgh, husbandman 0
5289995 2442079 2442079 plaintiff Mountford Henry gent 610229 610229 Mountford, Henry, of Flixburgh, gent 0
5398817 2474721 2474721 defendant Wastnes John esq 610229 610229 Wastnes, John, of Flixburgh, esq 2
5418823 2480553 2480553 defendant Wright Thomas husbandman 610229 610229 Wright, Thomas, of Flixburgh, husbandman 0
5418824 2480553 2480553 defendant Ripley John laborer 610229 610229 Ripley, John, of Flixburgh, laborer 1
5418825 2480553 2480553 defendant Marchand John husbandman 610229 610229 Marchand, John, of Flixburgh, husbandman 2
5418827 2480553 2480553 defendant Kirkeham John fisher 610229 610229 Kirkeham, John, of Flixburgh, fisher 4
5418828 2480553 2480553 defendant Dubbyng William fisher 610229 610229 Dubbyng, William, of Flixburgh, fisher 5
5463477 2493987 2493987 defendant Wright Thomas husbandman 610229 610229 Wright, Thomas, of Flixburgh, husbandman 0
5463478 2493987 2493987 defendant Rypley John laborer 610229 610229 Rypley, John, of Flixburgh, laborer 1
5463479 2493987 2493987 defendant Marchand John husbandman 610229 610229 Marchand, John, of Flixburgh, husbandman 2
5463480 2493987 2493987 defendant Davy John husbandman 610229 610229 Davy, John, of Flixburgh, husbandman 3
5463481 2493987 2493987 defendant Kyrkeham John fisher 610229 610229 Kyrkeham, John, of Flixburgh, fisher 4
5463482 2493987 2493987 defendant Dubbyng William fisher 610229 610229 Dubbyng, William, of Flixburgh, fisher 5
5515119 2509576 2509576 defendant Wastenes Thomas gent 610229 610229 Wastenes, Thomas, of Flixburgh, gent 1

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);