names

37 rows where place_id = 591222

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603768 1868849 1868849 defendant Aikerode John yeoman 591222 591222 Aikerode, John, of Waddesworth, yeoman 0
3716267 1931381 1931381 defendant Michell Edward yeoman 591222 591222 Michell, Edward, of Waddesworth, yeoman 1
3731873 1936200 1936200 defendant Michell Edward yeoman 591222 591222 Michell, Edward, of Waddesworth, yeoman 1
3731903 1936209 1936209 defendant Michell Edward yeoman 591222 591222 Michell, Edward, of Waddesworth, yeoman 1
4172492 2085842 2085842 defendant Brigge William, senior yeoman 591222 591222 Brigge, William, senior, of Waddesworth, yeoman 0
4564524 2220464 2220464 defendant E_ John de   591222 591222 E_, John de, of Waddesworth 2
4676729 2258342 2258342 defendant Peke John yeoman 591222 591222 Peke, John, of Waddesworth, yeoman 0
4685845 2261164 2261164 defendant Shawe Thomas chapman 591222 591222 Shawe, Thomas, of Waddesworth, chapman 0
4702011 2266039 2266039 defendant Peke John yeoman 591222 591222 Peke, John, of Waddesworth, yeoman 0
4705912 2267228 2267228 defendant Peek John yeoman 591222 591222 Peek, John, of Waddesworth, yeoman 0
4789082 2292641 2292641 defendant Peek John yeoman 591222 591222 Peek, John, of Waddesworth, yeoman 0
4879309 2320460 2320460 defendant Peke John yeoman 591222 591222 Peke, John, of Waddesworth, yeoman 4
4953207 2342918 2342918 defendant Rawlynson William yeoman 591222 591222 Rawlynson, William, of Waddesworth, yeoman 2
4989840 2353878 2353878 defendant Waddesworth Margery   591222 591222 Waddesworth, Margery, of Waddesworth, servant 1
5031215 2366003 2366003 defendant Aykrode William, junior yeoman 591222 591222 Aykrode, William, junior, of Waddesworth, yeoman 19
5031244 2366004 2366004 defendant Aykrode William, junior yeoman 591222 591222 Aykrode, William, junior, of Waddesworth, yeoman 18
5031274 2366005 2366005 defendant Aykrode William, junior yeoman 591222 591222 Aykrode, William, junior, of Waddesworth, yeoman 18
5034156 2366855 2366855 defendant Shakilton John, senior yeoman 591222 591222 Shakilton, John, senior, of Waddesworth, yeoman 1
5034157 2366855 2366855 defendant Shakilton John, junior yeoman 591222 591222 Shakilton, John, junior, of Waddesworth, yeoman 2
5034158 2366855 2366855 defendant Shakilton Christopher husbandman 591222 591222 Shakilton, Christopher, of Waddesworth, husbandman 3
5036402 2367503 2367503 defendant Akerode Richard miller 591222 591222 Akerode, Richard, of Waddesworth, miller 0
5113919 2390459 2390459 defendant Barnes Thomas yeoman 591222 591222 Barnes, Thomas, of Waddesworth, yeoman 0
5141656 2398669 2398669 defendant Holme John husbandman 591222 591222 Holme, John, of Waddesworth, husbandman 2
5160724 2404236 2404236 defendant Westeby Henry gent 591222 591222 Westeby, Henry, of Waddesworth, gent 0
5483434 2499993 2499993 defendant Helewell Richard husbandman 591222 591222 Helewell, Richard, of Waddesworth, husbandman 1
5557973 2522286 2522286 defendant Ferrour Henry yeoman 591222 591222 Ferrour, Henry, of Waddesworth, yeoman 0
5557975 2522287 2522287 defendant Ferrour Henry yeoman 591222 591222 Ferrour, Henry, of Waddesworth, yeoman 0
5560590 2523059 2523059 defendant Thomas Richard laborer 591222 591222 Thomas, Richard, of Waddesworth, laborer 1
5560591 2523059 2523059 defendant Thomas Christopher laborer 591222 591222 Thomas, Christopher, of Waddesworth, laborer 2
5560592 2523059 2523059 defendant Thomas Robert, junior laborer 591222 591222 Thomas, Robert, junior, of Waddesworth, laborer 3
5560593 2523059 2523059 defendant Thomas William laborer 591222 591222 Thomas, William, of Waddesworth, laborer 4
5562993 2523772 2523772 defendant Sutclif Robert yeoman 591222 591222 Sutclif, Robert, of Waddesworth, yeoman 2
5575637 2527469 2527469 defendant Thomas Robert husbandman 591222 591222 Thomas, Robert, of Waddesworth, husbandman 0
5575638 2527469 2527469 defendant Thomas Richard laborer 591222 591222 Thomas, Richard, of Waddesworth, laborer 1
5575639 2527469 2527469 defendant Thomas Christopher laborer 591222 591222 Thomas, Christopher, of Waddesworth, laborer 2
5575640 2527469 2527469 defendant Thomas Robert, junior laborer 591222 591222 Thomas, Robert, junior, of Waddesworth, laborer 3
5575641 2527469 2527469 defendant Thomas William laborer 591222 591222 Thomas, William, of Waddesworth, laborer 4

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