names

36 rows where place_id = 585965

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587593 1863767 1863767 defendant Coke John clothmaker 585965 585965 Coke, John, of Bylston, Suff, clothmaker 1
3591347 1864921 1864921 defendant Benet Thomas mercer 585965 585965 Benet, Thomas, of Bylston, Suff, mercer 0
3600232 1867720 1867720 defendant Coke John chapman 585965 585965 Coke, John, of Bylston, Suff, chapman 1
3606510 1869708 1869708 defendant Carter Alexander pedder 585965 585965 Carter, Alexander, of Bylston, Suff, pedder 1
3609053 1870489 1870489 defendant Couper William clothmaker 585965 585965 Couper, William, of Bylston, Suff, clothmaker 0
3615316 1872434 1872434 defendant Cooke John clothman 585965 585965 Cooke, John, of Bylston, Suff, clothman 3
3670690 1916796 1916796 defendant Stansby Richard clothmaker 585965 585965 Stansby, Richard, of Bylston, Suff, clothmaker 1
3756287 1943927 1943927 defendant Cowper Lawrence innholder 585965 585965 Cowper, Lawrence, of Bylston, Suff, innholder 4
3869940 1980187 1980187 defendant Reycroft Henry clothman 585965 585965 Reycroft, Henry, of Bylston, Suff, clothman 0
3943384 2004800 2004800 defendant Osmon Henry chapman 585965 585965 Osmon, Henry, of Bylston, Suff, chapman 6
4965028 2346459 2346459 defendant Waryn John weaver 585965 585965 Waryn, John, of Bylston, Suff, weaver 0
5002917 2357759 2357759 defendant Bington John chapman 585965 585965 Bington, John, of Bylston, Suff, chapman 2
5027475 2364914 2364914 defendant Motte John merchant 585965 585965 (Motte, John, of Bylston, Suff, merchant 1
5340964 2457372 2457372 defendant Baron John tailor 585965 585965 Baron, John, of Bylston, Suff, tailor 0
5353340 2461122 2461122 defendant Goslyn John clothmaker 585965 585965 Goslyn, John, of Bylston, Suff, clothmaker 3
5362201 2463843 2463843 defendant Keggell John yeoman 585965 585965 Keggell, John, of Bylston, Suff, yeoman 0
5375437 2467904 2467904 defendant Coke John chapman 585965 585965 Coke, John, of Bylston, Suff, chapman 2
5378832 2468965 2468965 defendant Cocke John clothman 585965 585965 Cocke, John, of Bylston, Suff, clothman 0
5383016 2470211 2470211 defendant Cooke John clothman 585965 585965 Cooke, John, of Bylston, Suff, clothman 0
5394276 2473427 2473427 defendant Croke John clothman 585965 585965 Croke, John, of Bylston, Suff, clothman 0
5429016 2483600 2483600 defendant Bryght Robert woolman 585965 585965 Bryght, Robert, of Bylston, Suff, woolman 0
5429301 2483696 2483696 defendant Coke John clothman 585965 585965 Coke, John, of Bylston, Suff, clothman 1
5433040 2484847 2484847 defendant Markday Richard clothmaker 585965 585965 Markday, Richard, of Bylston, Suff, clothmaker 0
5446362 2488806 2488806 defendant Coke John clothman 585965 585965 Coke, John, of Bylston, Suff, clothman 1
5446365 2488807 2488807 defendant Coke John clothman 585965 585965 Coke, John, of Bylston, Suff, clothman 1
5463825 2494096 2494096 defendant Markday Richard clothman 585965 585965 Markday, Richard, of Bylston, Suff, clothman 0
5463831 2494097 2494097 defendant Markday Richard clothman 585965 585965 Markday, Richard, of Bylston, Suff, clothman 0
5486914 2500983 2500983 defendant Markday Richard clothman 585965 585965 Markday, Richard, of Bylston, Suff, clothman 0
5508930 2507646 2507646 defendant Wodgate Nicholas clothmaker 585965 585965 Wodgate, Nicholas, of Bylston, Suff, clothmaker 2
5515286 2509624 2509624 defendant Coke John yeoman 585965 585965 Coke, John, of Bylston, Suff, yeoman 3
5529533 2513735 2513735 defendant Coke John clothmaker 585965 585965 Coke, John, of Bylston, Suff, clothmaker 3
5531223 2514280 2514280 defendant Bemes John clothmaker or fuller 585965 585965 Bemes, John, of Bylston, Suff, clothmaker or fuller 0
5562688 2523679 2523679 defendant Rande Anne widow 585965 585965 Rande, Anne, of Bylston, Suff, widow 0
5584616 2530260 2530260 defendant Hamond William clothmaker 585965 585965 Hamond, William, of Bylston, Suff, clothmaker 0
5596753 2533902 2533902 defendant Parker Henry clothman 585965 585965 Parker, Henry, of Bylston, Suff, clothman 0
5598564 2534436 2534436 defendant Markday Richard clothman 585965 585965 Markday, Richard, of Bylston, Suff, clothman 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);