names

21 rows where place_id = 757244

✎ 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
4444380 2183230 2183230 defendant Carpenter Robert   757244 757244 Carpenter, Robert, of Modeford 12
4444385 2183230 2183230 defendant White John   757244 757244 White, John, of Modeford 17
4444400 2183231 2183231 defendant Carpenter Robert   757244 757244 Carpenter, Robert, of Modeford 12
4444405 2183231 2183231 defendant White John   757244 757244 White, John, of Modeford 17
4573770 2223314 2223314 defendant Purdy John   757244 757244 Purdy, John, of Modeford 1
4595936 2229983 2229983 defendant Maundevyle John   757244 757244 Maundevyle, John, of Modeford 2
4613733 2235309 2235309 defendant Smyth William   757244 757244 Smyth, William, of Modeford 0
4641635 2243655 2243655 plaintiff Gamelyn Henry   757244 757244 Gamelyn, Henry, of Modeford 0
4656199 2247826 2247826 defendant Stokbrygge Richard carpenter 757244 757244 Stokbrygge, Richard, of Modeford, carpenter 0
4747564 2279793 2279793 defendant Broune John husbandman 757244 757244 Broune, John, of Modeford, husbandman 0
4808206 2298745 2298745 defendant Broun Thomas husbandman 757244 757244 Broun, Thomas, of Modeford, husbandman 0
4830269 2305503 2305503 defendant Gret Thomas husbandman 757244 757244 Gret, Thomas, of Modeford, husbandman 1
4974990 2349493 2349493 defendant Goudesone William yeoman 757244 757244 Goudesone, William, of Modeford, yeoman 0
4974991 2349493 2349493 defendant Jamys Henry yeoman 757244 757244 Jamys, Henry, of Modeford, yeoman 1
5090789 2383697 2383697 defendant Martyn John husbandman 757244 757244 Martyn, John, of Modeford, husbandman 0
5090790 2383697 2383697 defendant Martyn Nicholas husbandman 757244 757244 Martyn, Nicholas, of Modeford, husbandman 1
5090791 2383697 2383697 defendant Martyn Richard husbandman 757244 757244 Martyn, Richard, of Modeford, husbandman 2
5090792 2383697 2383697 defendant Cuffe John husbandman 757244 757244 Cuffe, John, of Modeford, husbandman 3
5226967 2423543 2423543 defendant Maundevyle Walter laborer 757244 757244 Maundevyle, Walter, of Modeford, laborer 5
5226968 2423543 2423543 defendant Coke Nicholas laborer 757244 757244 Coke, Nicholas, of Modeford, laborer 6
5629172 2553098 2553098 defendant Wodecourt John husbandman 757244 757244 Wodecourt, John, of Modeford, husbandman 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);