names

23 rows where place_id = 885697

✎ 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
5420044 2480913 2480913 defendant Hltoftys Margaret widow 885697 885697 Hltoftys, Margaret, of Farnehill, widow 0
5420046 2480913 2480913 defendant Sewer William tailor 885697 885697 Sewer, William, of Farnehill, tailor 2
5420047 2480913 2480913 defendant Sawer Peter tailor 885697 885697 Sawer, Peter, of Farnehill, tailor 3
5420048 2480913 2480913 defendant Walssh John laborer 885697 885697 Walssh, John, of Farnehill, laborer 4
5420050 2480913 2480913 defendant Caudray John laborer 885697 885697 Caudray, John, of Farnehill, laborer 6
5420051 2480913 2480913 defendant Janyn Richard tailor 885697 885697 Janyn, Richard, of Farnehill, tailor 7
5420052 2480913 2480913 defendant Todyngton John husbandman 885697 885697 Todyngton, John, of Farnehill, husbandman 8
5420053 2480913 2480913 defendant (illegible) Edmund yeoman 885697 885697 _, Edmund, of Farnehill, yeoman 9
5420054 2480913 2480913 defendant Atkynson William weaver 885697 885697 Atkynson, William, of Farnehill, weaver 10
5420055 2480913 2480913 defendant Michell John laborer 885697 885697 Michell, John, of Farnehill, laborer 11
5420056 2480913 2480913 defendant Hertley Thomas laborer 885697 885697 Hertley, Thomas, of Farnehill, laborer 12
5438750 2486517 2486517 defendant Eltoftys Margaret widow 885697 885697 Eltoftys, Margaret, of Farnehill, widow 0
5438752 2486517 2486517 defendant Sawer William tailor 885697 885697 Sawer, William, of Farnehill, tailor 2
5438753 2486517 2486517 defendant Sawer Peter tailor 885697 885697 Sawer, Peter, of Farnehill, tailor 3
5438754 2486517 2486517 defendant Walssh John laborer 885697 885697 Walssh, John, of Farnehill, laborer 4
5438755 2486517 2486517 defendant Wilson Hugh laborer 885697 885697 Wilson, Hugh, of Farnehill, laborer 5
5438756 2486517 2486517 defendant Caudray John laborer 885697 885697 Caudray, John, of Farnehill, laborer 6
5438757 2486517 2486517 defendant Janyn Richard tailor 885697 885697 Janyn, Richard, of Farnehill, tailor 7
5438758 2486517 2486517 defendant Todyngton John husbandman 885697 885697 Todyngton, John, of Farnehill, husbandman 8
5438759 2486517 2486517 defendant Colthyrst Edmunds yeoman 885697 885697 Colthyrst, Edmunds, of Farnehill, yeoman 9
5438760 2486517 2486517 defendant Atkynson William weaver 885697 885697 Atkynson, William, of Farnehill, weaver 10
5438761 2486517 2486517 defendant Michell John laborer 885697 885697 Michell, John, of Farnehill, laborer 11
5476103 2497865 2497865 defendant Eltoftes Margaret widow 885697 885697 Eltoftes, Margaret, of Farnehill, widow 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);