names

30 rows where place_id = 641375

✎ 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
3861159 1977210 1977210 defendant Guld William laborer 641375 641375 Guld, William, of Gillyng, laborer 1
3861160 1977210 1977210 defendant Walley Thomas yeoman 641375 641375 Walley, Thomas, of Gillyng, yeoman 2
3861161 1977210 1977210 defendant Smyth Richard laborer 641375 641375 Smyth, Richard, of Gillyng, laborer 3
3861162 1977210 1977210 defendant Plomer Thomas shoemaker 641375 641375 Plomer, Thomas, of Gillyng, shoemaker 4
4035907 2037515 2037515 defendant Francke William gent 641375 641375 Francke, William, of Gillyng, gent 0
4093321 2057929 2057929 defendant Hicke George yeoman 641375 641375 Hicke, George, of Gillyng, yeoman 0
4464430 2189546 2189546 defendant Upton Richard de   641375 641375 Upton, Richard de, of Gillyng, vicar 0
4533068 2210608 2210608 defendant Pirler (illegible)   641375 641375 together with Pirler, _, of Gillyng 3
4560540 2219236 2219236 plaintiff Noble John   641375 641375 Noble, John, of Gillyng 0
4575426 2223827 2223827 plaintiff Botiller John   641375 641375 Botiller, John, of Gillyng 0
4619978 2237228 2237228 defendant Walker William   641375 641375 Walker, William, of Gillyng 3
4622490 2238014 2238014 defendant Smyth Robert   641375 641375 Smyth, Robert, of Gillyng 3
4628689 2239898 2239898 plaintiff Sergant John (legal representative) 641375 641375 Sergant, John, of Gillyng, executors of 0
4643438 2244182 2244182 defendant Sclater Robert   641375 641375 Sclater, Robert, of Gillyng 1
4647718 2245391 2245391 plaintiff Smyth John   641375 641375 Smyth, John, of Gillyng 0
4665796 2250779 2250779 plaintiff Hothom William   641375 641375 Hothom, William, of Gillyng 0
4793297 2294000 2294000 defendant Forster Robert yeoman 641375 641375 Forster, Robert, of Gillyng, yeoman 0
4803013 2297128 2297128 defendant Marton Richard   641375 641375 Marton, Richard, of Gillyng 3
4808479 2298821 2298821 defendant Boteler Robert   641375 641375 Boteler, Robert, of Gillyng, franklin 0
4811905 2299838 2299838 defendant Boteler Robert   641375 641375 Boteler, Robert, of Gillyng 0
4839789 2308356 2308356 defendant Etton Nicholas   641375 641375 Etton, Nicholas, of Gillyng, gent, son of John Etton, knight 2
4866957 2316628 2316628 defendant Etton Robert   641375 641375 (Etton, Robert, of Gillyng, gent, son of John 1
4866958 2316628 2316628 defendant Etton Nicholas   641375 641375 Etton, Nicholas, of Gillyng, gent, son of John 2
4961827 2345497 2345497 defendant Smythson John husbandman 641375 641375 Smythson, John, of Gillyng, husbandman 0
4961828 2345497 2345497 defendant Esyk Richard slater 641375 641375 Esyk, Richard, of Gillyng, slater 1
4969541 2347839 2347839 defendant Gybson Thomas   641375 641375 Gybson, Thomas, of Gillyng, wright 0
5015560 2361438 2361438 defendant Barker Thomas husbandman 641375 641375 Barker, Thomas, of Gillyng, husbandman 2
5039477 2368458 2368458 defendant Barker Thomas husbandman 641375 641375 Barker, Thomas, of Gillyng, husbandman 3
5039478 2368458 2368458 defendant Willyamson John husbandman 641375 641375 Willyamson, John, of Gillyng, husbandman 4
5039479 2368458 2368458 defendant Bank John husbandman 641375 641375 Bank, John, of Gillyng, husbandman 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);