names

20 rows where place_id = 629757

✎ 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
3790253 1954766 1954766 defendant Russell Robert tanner 629757 629757 Russell, Robert, of Heigham juxta Norwich, tanner 0
3857664 1976034 1976034 defendant Russell Robert tanner 629757 629757 Russell, Robert, of Heigham juxta Norwich, tanner 0
3862375 1977607 1977607 defendant Russell Robert tanner 629757 629757 Russell, Robert, of Heigham juxta Norwich, tanner 0
3862679 1977711 1977711 defendant Kyng Robert tanner 629757 629757 Kyng, Robert, of Heigham juxta Norwich, tanner 3
3876119 1982262 1982262 defendant Pace William clerk 629757 629757 Pace, William, of Heigham juxta Norwich, clerk 0
3876148 1982270 1982270 defendant Paie William clerk 629757 629757 Paie, William, of Heigham juxta Norwich, clerk 0
3956217 2009242 2009242 defendant Waldgrave Robert esq 629757 629757 Waldgrave, Robert, of Heigham juxta Norwich, esq 1
4288655 2125998 2125998 defendant Wrenche Henry tanner 629757 629757 Wrenche, Henry, of Heigham juxta Norwich, tanner 0
4318129 2136450 2136450 defendant Norton John husbandman 629757 629757 Norton, John, of Heigham juxta Norwich, husbandman 2
4331547 2140848 2140848 defendant Norton John husbandman 629757 629757 Norton, John, of Heigham juxta Norwich, husbandman 1
4961088 2345279 2345279 defendant Collesson John leather carver 629757 629757 Collesson, John, of Heigham juxta Norwich, leather carver 0
5075664 2379221 2379221 defendant Stalon Ralph barker 629757 629757 Stalon, Ralph, of Heigham juxta Norwich, barker 1
5088313 2382956 2382956 defendant Lyngfeld Robert husbandman 629757 629757 Lyngfeld, Robert, of Heigham juxta Norwich, husbandman 1
5088314 2382956 2382956 defendant Stalon Ralph barker 629757 629757 Stalon, Ralph, of Heigham juxta Norwich, barker 2
5101089 2386731 2386731 defendant Courtby Thomas carter 629757 629757 Courtby, Thomas, of Heigham juxta Norwich, carter 1
5281910 2439786 2439786 defendant Courby Thomas carpenter 629757 629757 Courby, Thomas, of Heigham juxta Norwich, carpenter 0
5284442 2440465 2440465 defendant Courby Robert yeoman 629757 629757 Courby, Robert, of Heigham juxta Norwich, yeoman 2
5501524 2505409 2505409 defendant Mete John barker 629757 629757 Mete, John, of Heigham juxta Norwich, barker 3
5546017 2518827 2518827 defendant Grene John   629757 629757 Grene, John, of Heigham juxta Norwich 0
5546019 2518828 2518828 defendant Grene John yeoman 629757 629757 Grene, John, of Heigham juxta Norwich, 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);