names

31 rows where place_id = 587153

✎ 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
3590611 1864706 1864706 defendant Bettys John husbandman 587153 587153 Bettys, John, of Wolpyt, husbandman 0
3590613 1864706 1864706 defendant Humfray William tailor 587153 587153 Humfray, William, of Wolpyt, tailor 2
3597058 1866702 1866702 defendant Mannyng Richard husbandman 587153 587153 Mannyng, Richard, of Wolpyt, husbandman 3
3603057 1868623 1868623 defendant Thorpe John merchant 587153 587153 Thorpe, John, of Wolpyt, merchant 0
3634891 1905713 1905713 defendant Fen Andrew mercer 587153 587153 Fen, Andrew, of Wolpyt, mercer 3
3659655 1913274 1913274 defendant Stevyns Thomas   587153 587153 Stevyns, Thomas, of Wolpyt, Suff, rector 0
4517135 2205761 2205761 defendant Welde John   587153 587153 Welde, John, of Wolpyt 1
4574975 2223694 2223694 defendant Cook Margaret daughter of Thomas 587153 587153 Cook, Margaret, of Wolpyt, daughter of Thomas 0
4586746 2227256 2227256 defendant Barbour Stephen   587153 587153 Barbour, Stephen, of Wolpyt 0
4794648 2294466 2294466 defendant Catour Walter husbandman 587153 587153 Catour, Walter, of Wolpyt, husbandman 0
4794649 2294466 2294466 defendant Hewet Thomas husbandman 587153 587153 Hewet, Thomas, of Wolpyt, husbandman 1
4983195 2351876 2351876 defendant Schep John (legal representative) 587153 587153 Schep, John, of Wolpyt, executors of 1
5013411 2360757 2360757 defendant Wade James yeoman 587153 587153 Wade, James, of Wolpyt, yeoman 0
5013412 2360757 2360757 defendant Joynour Adam cordwainer 587153 587153 Joynour, Adam, of Wolpyt, cordwainer 1
5013413 2360757 2360757 defendant Dakris Reginald yeoman 587153 587153 Dakris, Reginald, of Wolpyt, yeoman 2
5091914 2384015 2384015 defendant Bloys Thomas husbandman 587153 587153 Bloys, Thomas, of Wolpyt, husbandman 1
5091915 2384015 2384015 defendant Wellys John yeoman 587153 587153 Wellys, John, of Wolpyt, yeoman 2
5116160 2391152 2391152 defendant Bloys Thomas husbandman 587153 587153 Bloys, Thomas, of Wolpyt, husbandman 1
5189693 2412732 2412732 defendant Turnour Thomas mercer 587153 587153 Turnour, Thomas, of Wolpyt, mercer 1
5189694 2412732 2412732 defendant Geffray William shoemaker 587153 587153 Geffray, William, of Wolpyt, shoemaker 2
5206602 2417664 2417664 defendant Turnour Thomas mercer 587153 587153 Turnour, Thomas, of Wolpyt, mercer 1
5206603 2417664 2417664 defendant Geffray William shoemaker 587153 587153 Geffray, William, of Wolpyt, shoemaker 2
5253831 2431314 2431314 defendant Wyseman Geoffrey baker 587153 587153 Wyseman, Geoffrey, of Wolpyt, baker 0
5255613 2431874 2431874 plaintiff Copynger Robert woolman 587153 587153 Copynger, Robert, of Wolpyt, woolman 0
5278799 2438907 2438907 plaintiff Bloys Thomas woolman or yeoman 587153 587153 Bloys, Thomas, of Wolpyt, woolman or yeoman 0
5330827 2454294 2454294 defendant Crystemasse John butcher 587153 587153 Crystemasse, John, of Wolpyt, butcher 0
5474264 2497281 2497281 defendant Beket John   587153 587153 Beket, John, of Wolpyt, wheel wright 0
5523164 2512074 2512074 defendant Andrewe John husbandman 587153 587153 Andrewe, John, of Wolpyt, husbandman 0
5523476 2512170 2512170 defendant Flory Robert yeoman 587153 587153 Flory, Robert, of Wolpyt, yeoman 1
5627858 2552681 2552681 defendant Howet Thomas chapman 587153 587153 Howet, Thomas, of Wolpyt, chapman 0
5627861 2552682 2552682 defendant Hewet Thomas chapman 587153 587153 Hewet, Thomas, of Wolpyt, chapman 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);