names

21 rows where place_id = 728491

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4277420 2122024 2122024 defendant Awdley Edmund gent 728491 728491 Awdley, Edmund, of Pagrave, gent 0
4277423 2122025 2122025 defendant Awdley Edmund gent 728491 728491 Awdley, Edmund, of Pagrave, gent 1
4318799 2136690 2136690 defendant Audeley Philip esq 728491 728491 Audeley, Philip, of Pagrave, esq 0
4329091 2140040 2140040 defendant Auldley Philip esq 728491 728491 Auldley, Philip, of Pagrave, esq 1
4340027 2143778 2143778 defendant Awdeley Edmund   728491 728491 Awdeley, Edmund, of Pagrave, gent, his son 1
4382480 2158845 2158845 defendant Awdeley Philip esq 728491 728491 Awdeley, Philip, of Pagrave, esq 0
4383752 2159272 2159272 defendant Awdeley Philip esq 728491 728491 Awdeley, Philip, of Pagrave, esq 0
4383758 2159273 2159273 defendant Awdeley Philip esq 728491 728491 Awdeley, Philip, of Pagrave, esq 0
4410729 2168180 2168180 defendant Prentyce Thomas   728491 728491 Prentyce, Thomas, of Pagrave, wheelwright 0
4457552 2187374 2187374 defendant Maupas William   728491 728491 Maupas, William, of Pagrave 0
4560695 2219293 2219293 defendant Canon Walter   728491 728491 Canon, Walter, of Pagrave, servant of Robert Canon 0
4563052 2220012 2220012 plaintiff Rande John   728491 728491 Rande, John, of Pagrave 0
4705499 2267086 2267086 defendant Canon Robert yeoman 728491 728491 Canon, Robert, of Pagrave, yeoman 0
4946534 2340911 2340911 defendant Canon William husbandman 728491 728491 Canon, William, of Pagrave, husbandman 0
4985256 2352517 2352517 defendant Wotton William yeoman 728491 728491 Wotton, William, of Pagrave, yeoman 1
5443502 2487967 2487967 plaintiff Canon Richard singleman 728491 728491 Canon, Richard, of Pagrave, singleman 0
5456227 2491776 2491776 plaintiff Canon Richard singleman 728491 728491 Canon, Richard, of Pagrave, singleman 0
5614327 2548269 2548269 defendant Maupas William   728491 728491 Maupas, William, of Pagrave 0
5625876 2552042 2552042 defendant Pagrave Edmund esq 728491 728491 Pagrave, Edmund, of Pagrave, esq 0
5627309 2552509 2552509 defendant Pagrave Edmund gent 728491 728491 Pagrave, Edmund, of Pagrave, gent 3
5632665 2554234 2554234 defendant Rande Richard yeoman 728491 728491 Rande, Richard, of Pagrave, yeoman 2

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);