names

25 rows where place_id = 586104

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587948 1863881 1863881 defendant Carswyll John husbandman 586104 586104 Carswyll, John, of Brent, husbandman 0
3611775 1871348 1871348 defendant Craneford Robert husbandman 586104 586104 Craneford, Robert, of Brent, husbandman 0
3764157 1946440 1946440 defendant Toser Thomas husbandman 586104 586104 Toser, Thomas, of Brent, husbandman 0
3764158 1946440 1946440 defendant Toser Richard husbandman 586104 586104 Toser, Richard, of Brent, husbandman 1
3764159 1946440 1946440 defendant Hardyng Richard husbandman 586104 586104 Hardyng, Richard, of Brent, husbandman 2
3764160 1946440 1946440 defendant Copleston John laborer 586104 586104 Copleston, John, of Brent, laborer 3
3781917 1952092 1952092 defendant Wyndeyate Henry merchant 586104 586104 Wyndeyate, Henry, of Brent, merchant 0
3985789 2019680 2019680 defendant Stephens Walter husbandman 586104 586104 Stephens, Walter, of Brent, husbandman 0
4096967 2059245 2059245 defendant Isgar Henry yeoman 586104 586104 Isgar, Henry, of Brent, yeoman 3
4096982 2059249 2059249 defendant Bonell Roger yeoman 586104 586104 Bonell, Roger, of Brent, yeoman 0
4096987 2059250 2059250 defendant Midlane Robert yeoman 586104 586104 Midlane, Robert, of Brent, yeoman 1
4125599 2069440 2069440 defendant Rede Lawrence clothier 586104 586104 Rede, Lawrence, of Brent, clothier 0
4487994 2196959 2196959 defendant Hele John   586104 586104 Hele, John, of Brent 0
4513808 2204743 2204743 defendant Knyght Robert   586104 586104 Knyght, Robert, of Brent, vicar 0
4773361 2287643 2287643 defendant Northecote John laborer 586104 586104 Northecote, John, of Brent, laborer 1
4954717 2343365 2343365 defendant Gerveys John husbandman 586104 586104 Gerveys, John, of Brent, husbandman 1
4954718 2343365 2343365 defendant Peper Ralph butcher 586104 586104 Peper, Ralph, of Brent, butcher 2
5016034 2361574 2361574 defendant Brode John husbandman 586104 586104 Brode, John, of Brent, husbandman 1
5019185 2362500 2362500 defendant Brounyng William husbandman 586104 586104 Brounyng, William, of Brent, husbandman 2
5043490 2369675 2369675 defendant Alman Henry husbandman 586104 586104 Alman, Henry, of Brent, husbandman 1
5105954 2388179 2388179 defendant Maddok William husbandman 586104 586104 Maddok, William, of Brent, husbandman 3
5217871 2420958 2420958 defendant Hore John, junior husbandman 586104 586104 Hore, John, junior, of Brent, husbandman 2
5348130 2459559 2459559 defendant Yoland Nicholas butcher 586104 586104 Yoland, Nicholas, of Brent, butcher 1
5500946 2505230 2505230 defendant Shorte Julia widow 586104 586104 Shorte, Julia, of Brent, widow 1
5523328 2512127 2512127 defendant Thorn William husbandman 586104 586104 Thorn, William, of Brent, husbandman 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);