names

33 rows where place_id = 591725

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605357 1869343 1869343 defendant Thommes Thomas butcher 591725 591725 Thommes, Thomas, of Leghton Bosard, butcher 0
3887347 1986032 1986032 defendant Brandley John carpenter 591725 591725 Brandley, John, of Leghton Bosard, carpenter 2
4667877 2255652 2255652 defendant Tyler Peter husbandman 591725 591725 Tyler, Peter, of Leghton Bosard, husbandman 1
4667878 2255652 2255652 defendant Wulfale Thomas husbandman 591725 591725 Wulfale, Thomas, of Leghton Bosard, husbandman 2
4805307 2297863 2297863 defendant Brabeyn John weaver 591725 591725 Brabeyn, John, of Leghton Bosard, weaver 0
4805308 2297863 2297863 defendant Brabeyn Nicholas   591725 591725 Brabeyn, Nicholas, of Leghton Bosard, single man 1
4815517 2300958 2300958 defendant Huntle William husbandman 591725 591725 Huntle, William, of Leghton Bosard, husbandman 0
4870300 2317684 2317684 defendant Coteler John butcher 591725 591725 Coteler, John, of Leghton Bosard, butcher 0
4873277 2318595 2318595 defendant Halenden Thomas husbandman 591725 591725 Halenden, Thomas, of Leghton Bosard, husbandman 0
4873278 2318595 2318595 defendant Coteler John butcher 591725 591725 Coteler, John, of Leghton Bosard, butcher 1
4948546 2341523 2341523 defendant Curteys John   591725 591725 Curteys, John, of Leghton Bosard, servant 0
4948548 2341524 2341524 defendant Curteys John   591725 591725 Curteys, John, of Leghton Bosard, servant 0
5238250 2426773 2426773 plaintiff Grosell Henry   591725 591725 Grosell, Henry, of Leghton Bosard 0
5322328 2451751 2451751 defendant Fyssher John tailor 591725 591725 Fyssher, John, of Leghton Bosard, tailor 0
5384407 2470627 2470627 defendant Coteler William butcher 591725 591725 Coteler, William, of Leghton Bosard, butcher 1
5384408 2470627 2470627 defendant Baydon William   591725 591725 Baydon, William, of Leghton Bosard, pie baker 2
5388151 2471664 2471664 plaintiff Godench Richard   591725 591725 Godench, Richard, of Leghton Bosard 0
5388152 2471664 2471664 defendant Person Thomas yeoman 591725 591725 Person, Thomas, of Leghton Bosard, yeoman 0
5391081 2472521 2472521 defendant Rayner John   591725 591725 Rayner, John, of Leghton Bosard, tallow chandler 0
5391214 2472566 2472566 defendant Goodryche John gent 591725 591725 Goodryche, John, of Leghton Bosard, gent 1
5391215 2472566 2472566 defendant Harryk Thomas tanner 591725 591725 Harryk, Thomas, of Leghton Bosard, tanner 2
5403248 2476013 2476013 plaintiff Brame Robert husbandman & Collector of the first 15ths & 10ths of the late King Edward IV 591725 591725 Brame, Robert, of Leghton Bosard, husbandman & Collector of the first 15ths & 10ths of the late King Edward IV 1
5404019 2476225 2476225 defendant Reyner John   591725 591725 Reyner, John, of Leghton Bosard, tallow chandler 0
5404181 2476275 2476275 defendant Godryche John gent 591725 591725 Godryche, John, of Leghton Bosard, gent 2
5404182 2476275 2476275 defendant Harryk Thomas tanner 591725 591725 Harryk, Thomas, of Leghton Bosard, tanner 3
5417330 2480100 2480100 defendant Goodryche John gent 591725 591725 Goodryche, John, of Leghton Bosard, gent 6
5417331 2480100 2480100 defendant Harryk Thomas tanner 591725 591725 Harryk, Thomas, of Leghton Bosard, tanner 7
5434570 2485280 2485280 defendant Goodriche John gent 591725 591725 Goodriche, John, of Leghton Bosard, gent 6
5434571 2485280 2485280 defendant Harryk Thomas tanner 591725 591725 Harryk, Thomas, of Leghton Bosard, tanner 7
5449936 2489869 2489869 defendant Godriche John gent 591725 591725 Godriche, John, of Leghton Bosard, gent 5
5449937 2489869 2489869 defendant Harryk Thomas tanner 591725 591725 Harryk, Thomas, of Leghton Bosard, tanner 6
5449943 2489870 2489870 defendant Gedryche John gent 591725 591725 Gedryche, John, of Leghton Bosard, gent 4
5449944 2489870 2489870 defendant Harryk Thomas tanner 591725 591725 Harryk, Thomas, of Leghton Bosard, tanner 5

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