names

16 rows where place_id = 773172

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4597695 2230528 2230528 defendant Blachaller John   773172 773172 Blachaller, John, of Yevele, Soms 3
4654713 2247351 2247351 defendant Lambrok William dyer 773172 773172 Lambrok, William, of Yevele, Soms, dyer 0
4674122 2257513 2257513 defendant Battesford William smith 773172 773172 Battesford, William, of Yevele, Soms, smith 2
4690689 2262636 2262636 defendant Lambroke William chapman 773172 773172 Lambroke, William, of Yevele, Soms, chapman 3
4728597 2274183 2274183 defendant Carpenter John shoemaker 773172 773172 Carpenter, John, of Yevele, Soms, shoemaker 1
4736028 2276407 2276407 defendant Geffrey John mercer 773172 773172 Geffrey, John, of Yevele, Soms, mercer 0
4755620 2282139 2282139 defendant Deye John smith 773172 773172 together with Deye, John, of Yevele, Soms, smith 1
4781128 2290105 2290105 defendant Lambroke William husbandman 773172 773172 Lambroke, William, of Yevele, Soms, husbandman 0
4781823 2290331 2290331 defendant Sele William husbandman 773172 773172 Sele, William, of Yevele, Soms, husbandman 0
4785608 2291524 2291524 defendant Coke John shoemaker 773172 773172 Coke, John, of Yevele, Soms, shoemaker 0
4813853 2300444 2300444 plaintiff Hoper Stephen chapman 773172 773172 Hoper, Stephen, of Yevele, Soms, chapman 0
4845394 2310072 2310072 defendant Steel Edward   773172 773172 Steel, Edward, of Yevele, Soms, brass worker 0
4884899 2322174 2322174 defendant Dawe John husbandman 773172 773172 Dawe, John, of Yevele, Soms, husbandman 0
4909568 2329528 2329528 defendant Kyng Robert weaver 773172 773172 Kyng, Robert, of Yevele, Soms, weaver 3
4965908 2346737 2346737 defendant Barry William smith 773172 773172 Barry, William, of Yevele, Soms, smith 0
5625277 2551844 2551844 defendant Lumbard William   773172 773172 Lumbard, William, of Yevele, Soms, apprentice of law 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);