names

21 rows where place_id = 602199

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648928 1910054 1910054 plaintiff Parker Thomas   602199 602199 Parker, Thomas, of Whitgift 0
3854444 1975029 1975029 defendant Lawe William husbandman 602199 602199 Lawe, William, of Whitgift, husbandman 0
3854445 1975029 1975029 defendant Wrytyngham Stephen husbandman 602199 602199 Wrytyngham, Stephen, of Whitgift, husbandman 1
3949604 2006937 2006937 defendant Hunter William husbandman 602199 602199 Hunter, William, of Whitgift, husbandman 0
3949605 2006937 2006937 defendant Ellys Ranulph husbandman 602199 602199 Ellys, Ranulph, of Whitgift, husbandman 1
3949606 2006937 2006937 defendant Hunton alias Halton John husbandman 602199 602199 Hunton alias Halton, John, of Whitgift, husbandman 2
3949607 2006937 2006937 defendant Underwood Richard husbandman 602199 602199 Underwood, Richard, of Whitgift, husbandman 3
4017495 2030959 2030959 defendant Stephenson Robert yeoman 602199 602199 Stephenson, Robert, of Whitgift, yeoman 1
4465541 2189892 2189892 plaintiff Wright Joan   602199 602199 Wright, Joan, of Whitgift, on his own account 0
4465542 2189892 2189892 defendant Drye Robert   602199 602199 Drye, Robert, of Whitgift 0
4469187 2191030 2191030 defendant Baillif John   602199 602199 Baillif, John, of Whitgift 0
4525221 2208225 2208225 defendant Wallan Henry   602199 602199 Wallan, Henry, of Whitgift 4
4592932 2229115 2229115 defendant Baillyf John   602199 602199 Baillyf, John, of Whitgift 0
4640783 2243406 2243406 defendant Bailly John   602199 602199 Bailly, John, of Whitgift 0
4657768 2248314 2248314 defendant West Robert yeoman 602199 602199 West, Robert, of Whitgift, yeoman 1
4661531 2249436 2249436 defendant Baylly John husbandman 602199 602199 Baylly, John, of Whitgift, husbandman 6
4742881 2278427 2278427 defendant Watson Richard husabndman 602199 602199 Watson, Richard, of Whitgift, husabndman 1
4789586 2292814 2292814 defendant Asshe Henry chaplain 602199 602199 Asshe, Henry, of Whitgift, chaplain 4
4801098 2296534 2296534 plaintiff Whityn Henry   602199 602199 Whityn, Henry, of Whitgift 0
5273033 2437189 2437189 defendant Wytyng John   602199 602199 Wytyng, John, of Whitgift 0
5599764 2534815 2534815 defendant Parkour Thomas yeoman 602199 602199 Parkour, Thomas, of Whitgift, 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);