names

12 rows where place_id = 592241

✎ 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
3607065 1869874 1869874 defendant Gronde Richard husbandman 592241 592241 Gronde, Richard, of Morley, Norf, husbandman 1
3634065 1905451 1905451 defendant Crane John yeoman 592241 592241 Crane, John, of Morley, Norf, yeoman 2
3634068 1905452 1905452 defendant Crane John yeoman 592241 592241 Crane, John, of Morley, Norf, yeoman 1
3789360 1954493 1954493 defendant Conall Robert husbandman 592241 592241 Conall, Robert, of Morley, Norf, husbandman 0
3939649 2003568 2003568 plaintiff Sedley Martin gent 592241 592241 Sedley, Martin, of Morley, Norf, gent 0
3971029 2014423 2014423 defendant Grene Thomas husbandman 592241 592241 Grene, Thomas, of Morley St Peter, Norf, husbandman 2
4072353 2050414 2050414 defendant Newton Mathew clerk 592241 592241 Newton, Mathew, of Morley, Norf, clerk 0
4089095 2056394 2056394 defendant Davy John yeoman 592241 592241 Davy, John, of Morley, Norf, yeoman 0
4277044 2121904 2121904 defendant Webster Thomas yeoman 592241 592241 Webster, Thomas, of Morley, Norf, yeoman 0
4286464 2125200 2125200 defendant Hubberd Roger esq 592241 592241 Hubberd, Roger, of Morley, Norf, esq 0
5222991 2422442 2422442 defendant Regnold or Reynald John laborer 592241 592241 Regnold or Reynald, John, of Morley, Norf, singleman, laborer 1
5482313 2499653 2499653 defendant Crane John husbandman 592241 592241 Crane, John, of Morley, Norf, husbandman 2

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