names

30 rows where place_id = 600038

✎ 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
3639437 1907142 1907142 defendant Janyng Thomas husbandman 600038 600038 Janyng, Thomas, of Bretenham, husbandman 0
3639439 1907142 1907142 defendant Braunston Robert husbandman 600038 600038 Braunston, Robert, of Bretenham, husbandman 2
3682486 1920625 1920625 defendant Englond Peter laborer 600038 600038 Englond, Peter, of Bretenham, laborer 0
3692003 1923665 1923665 defendant Coket Robert laborer 600038 600038 Coket, Robert, of Bretenham, laborer 0
3710107 1929473 1929473 defendant Hudson John clerk 600038 600038 Hudson, John, of Bretenham, clerk 0
3710108 1929473 1929473 defendant Janyn John husbandman 600038 600038 Janyn, John, of Bretenham, husbandman 1
3724674 1934001 1934001 defendant Hudson John clerk 600038 600038 Hudson, John, of Bretenham, clerk 0
3724675 1934001 1934001 defendant Janyn John husbandman 600038 600038 Janyn, John, of Bretenham, husbandman 1
3760768 1945370 1945370 plaintiff Dobbys William yeoman 600038 600038 Dobbys, William, of Bretenham, yeoman 0
3760771 1945371 1945371 plaintiff Kyng Robert husbandman 600038 600038 Kyng, Robert, of Bretenham, husbandman 1
3765838 1946981 1946981 defendant Dobbys William husbandman 600038 600038 Dobbys, William, of Bretenham, husbandman 0
3765839 1946981 1946981 defendant Kyng Robert husbandman 600038 600038 Kyng, Robert, of Bretenham, husbandman 1
3770158 1948334 1948334 defendant Smyth Robert husbandman 600038 600038 Smyth, Robert, of Bretenham, husbandman 0
3778924 1951124 1951124 plaintiff Dobbys William yeoman 600038 600038 Dobbys, William, of Bretenham, yeoman 0
3808097 1960424 1960424 defendant Raynner John husbandman 600038 600038 Raynner, John, of Bretenham, husbandman 0
3815717 1962834 1962834 defendant Hamond Hugh husbandman 600038 600038 Hamond, Hugh, of Bretenham, husbandman 0
3832785 1968183 1968183 defendant Rayner John husbandman 600038 600038 Rayner, John, of Bretenham, husbandman 0
3844750 1971901 1971901 defendant Symondys John (legal representative) 600038 600038 Symondys, John, of Bretenham, yeoman, executors of 2
3844752 1971901 1971901 defendant Symondys Thomas husbandman 600038 600038 Symondys, Thomas, of Bretenham, husbandman 4
3945850 2005623 2005623 defendant Angell Edward yeoman 600038 600038 Angell, Edward, of Bretenham, yeoman 0
3999478 2024578 2024578 defendant Lockwode Thomas husbandman 600038 600038 Lockwode, Thomas, of Bretenham, husbandman 0
4025836 2033890 2033890 defendant Wright John husbandman 600038 600038 Wright, John, of Bretenham, husbandman 4
4158516 2081047 2081047 defendant Makyn Henry yeoman 600038 600038 Makyn, Henry, of Bretenham, yeoman 1
4224140 2103929 2103929 defendant Kembold Henry husbandman 600038 600038 Kembold, Henry, of Bretenham, husbandman 0
4524651 2208046 2208046 defendant Purry Nicholas   600038 600038 Purry, Nicholas, of Bretenham 0
5042753 2369439 2369439 defendant Kyng Nicholas husbandman 600038 600038 Kyng, Nicholas, of Bretenham, husbandman 2
5083578 2381590 2381590 defendant Russhebroke John yeoman 600038 600038 Russhebroke, John, of Bretenham, yeoman 0
5087329 2382674 2382674 defendant Russhebroke John husbandman 600038 600038 Russhebroke, John, of Bretenham, husbandman 1
5273100 2437205 2437205 defendant Walle Richard   600038 600038 Walle, Richard, of Bretenham, parson 3
5273101 2437205 2437205 defendant Watche Thomas clerk & parson 600038 600038 Watche, Thomas, of Bretenham, clerk & parson 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);