names

31 rows where place_id = 596248

✎ 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
3623859 1874993 1874993 defendant Fyloll William gent 596248 596248 Fyloll, William, of Wodelond, gent 0
3683133 1920843 1920843 defendant Venycomb John laborer 596248 596248 Venycomb, John, of Wodelond, laborer 0
3746092 1940685 1940685 defendant Chedulton William husbandman 596248 596248 Chedulton, William, of Wodelond, husbandman 0
3876863 1982502 1982502 defendant Walton Robert husbandman 596248 596248 Walton, Robert, of Wodelond, husbandman 0
4514951 2205084 2205084 defendant Velde John   596248 596248 Velde, John, of Wodelond 3
4588539 2227784 2227784 defendant Raule John   596248 596248 Raule, John, of Wodelond 0
4588540 2227784 2227784 defendant Fox Walter   596248 596248 Fox, Walter, of Wodelond 1
4598482 2230762 2230762 defendant Lauerans William   596248 596248 Lauerans, William, of Wodelond 2
4598484 2230762 2230762 defendant Rolvys John   596248 596248 Rolvys, John, of Wodelond 4
4657777 2248317 2248317 defendant Knyght Hugh husbandman 596248 596248 Knyght, Hugh, of Wodelond, husbandman 0
4657778 2248317 2248317 defendant Langeley John husbandman 596248 596248 Langeley, John, of Wodelond, husbandman 1
4667546 2255568 2255568 defendant Bailly John yeoman 596248 596248 Bailly, John, of Wodelond, yeoman 2
4670245 2256400 2256400 defendant Hulet John laborer 596248 596248 Hulet, John, of Wodelond, laborer 0
4726976 2273703 2273703 defendant Wybbury John esq 596248 596248 Wybbury, John, of Wodelond, esq 0
4733802 2275752 2275752 defendant Daunce John barber 596248 596248 Daunce, John, of Wodelond, barber 1
4760247 2283557 2283557 defendant Daunce John laborer 596248 596248 Daunce, John, of Wodelond, laborer 0
5043792 2369771 2369771 plaintiff Ewyas David   596248 596248 Ewyas, David, of Wodelond, parson 2
5043798 2369772 2369772 defendant Ewyas David   596248 596248 Ewyas, David, of Wodelond, parson 2
5043803 2369773 2369773 defendant Ewyas David   596248 596248 Ewyas, David, of Wodelond, parson 2
5060582 2374744 2374744 defendant Baker William yeoman 596248 596248 Baker, William, of Wodelond, yeoman 1
5082943 2381400 2381400 defendant Burell Walter gent 596248 596248 Burell, Walter, of Wodelond, gent 0
5090604 2383634 2383634 plaintiff Rumney Thomas   596248 596248 (Rumney, Thomas, of Wodelond 1
5131184 2395611 2395611 defendant Talbot Robert yeoman 596248 596248 Talbot, Robert, of Wodelond, yeoman 0
5135833 2396994 2396994 defendant Petynpace Simon laborer 596248 596248 Petynpace, Simon, of Wodelond, laborer 3
5150677 2401348 2401348 defendant Talbot Robert yeoman 596248 596248 Talbot, Robert, of Wodelond, yeoman 0
5169104 2406702 2406702 defendant Talbot Robert yeoman 596248 596248 Talbot, Robert, of Wodelond, yeoman 0
5191882 2413358 2413358 defendant Petypace Simon laborer 596248 596248 Petypace, Simon, of Wodelond, laborer 2
5266077 2435141 2435141 defendant Bradelegh Thomas husbandman 596248 596248 Bradelegh, Thomas, of Wodelond, husbandman 0
5306501 2446934 2446934 defendant Fermour John husbandman 596248 596248 Fermour, John, of Wodelond, husbandman 0
5547534 2519296 2519296 defendant Shirford John, junior husbandman 596248 596248 Shirford, John, junior, of Wodelond, husbandman 2
5633131 2554364 2554364 defendant Breton John tinner 596248 596248 Breton, John, of Wodelond, tinner 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);