names

27 rows where place_id = 634554

✎ 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
3819611 1964011 1964011 plaintiff Osbaldeston John esq 634554 634554 Osbaldeston, John, of Chadlyngton, esq 0
4128705 2070561 2070561 defendant Lanchbery Robert husbandman 634554 634554 Lanchbery, Robert, of Chadlyngton, husbandman 0
4671783 2256821 2256821 defendant Whytfelde John gent 634554 634554 Whytfelde, John, of Chadlyngton, gent 0
4691955 2263018 2263018 defendant Whytefelde John husbandman 634554 634554 Whytefelde, John, of Chadlyngton, husbandman 0
4700079 2265446 2265446 defendant Shepherd Simon husbandman 634554 634554 Shepherd, Simon, of Chadlyngton, husbandman 3
4700080 2265446 2265446 defendant Martyn John husbandman 634554 634554 Martyn, John, of Chadlyngton, husbandman 4
4700081 2265446 2265446 defendant Conbrugge William husbandman 634554 634554 Conbrugge, William, of Chadlyngton, husbandman 5
4716488 2270476 2270476 defendant Whytefeld John gent 634554 634554 Whytefeld, John, of Chadlyngton, gent 0
4720009 2271605 2271605 defendant Whytefeld Richard husbandman 634554 634554 Whytefeld, Richard, of Chadlyngton, husbandman 0
4734772 2276031 2276031 defendant Nicol Thomas husbandman 634554 634554 Nicol, Thomas, of Chadlyngton, husbandman 0
4785379 2291444 2291444 defendant Nicholl Henry husbandman 634554 634554 Nicholl, Henry, of Chadlyngton, husbandman 0
4785380 2291444 2291444 defendant Nicholl Thomas husbandman 634554 634554 Nicholl, Thomas, of Chadlyngton, husbandman 1
4785382 2291444 2291444 defendant Waccheharme John husbandman 634554 634554 Waccheharme, John, of Chadlyngton, husbandman 3
4809753 2299213 2299213 defendant Whitefeld John (legal representative) 634554 634554 Whitefeld, John, of Chadlyngton, gent, executors of 0
4809754 2299213 2299213 defendant Hyde William gent 634554 634554 (Hyde, William, of Chadlyngton, gent 1
4899765 2326561 2326561 defendant Martyn John husbandman 634554 634554 Martyn, John, of Chadlyngton, husbandman 0
4908938 2329341 2329341 defendant Osbaldeston John esq 634554 634554 Osbaldeston, John, of Chadlyngton, esq 0
4908939 2329341 2329341 defendant Tydmerssh Thomas yeoman 634554 634554 Tydmerssh, Thomas, of Chadlyngton, yeoman 1
4908940 2329341 2329341 defendant Belle Robert yeoman 634554 634554 Belle, Robert, of Chadlyngton, yeoman 2
4908941 2329341 2329341 defendant Wilkes Henry yeoman 634554 634554 Wilkes, Henry, of Chadlyngton, yeoman 3
4908942 2329341 2329341 defendant Faty Thomas yeoman 634554 634554 Faty, Thomas, of Chadlyngton, yeoman 4
4908943 2329341 2329341 defendant Frensheman William yeoman 634554 634554 Frensheman, William, of Chadlyngton, yeoman 5
4908944 2329341 2329341 defendant Loukyns John laborer 634554 634554 Loukyns, John, of Chadlyngton, laborer 6
4923304 2333713 2333713 plaintiff Mascall John   634554 634554 Mascall, John, of Chadlyngton, on his own account 0
4923306 2333714 2333714 plaintiff Mascall John   634554 634554 Mascall, John, of Chadlyngton, on his own account 0
4968987 2347687 2347687 defendant Olbaldeston John esq 634554 634554 Olbaldeston, John, of Chadlyngton, esq 0
5306497 2446932 2446932 defendant Martyn Thomas husbandman 634554 634554 Martyn, Thomas, of Chadlyngton, 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);