names

15 rows where place_id = 765220

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4514645 2205000 2205000 defendant Braceby Hugh   765220 765220 Braceby, Hugh, of Welyngoure 0
4545642 2214560 2214560 defendant Byngeley Robert   765220 765220 Byngeley, Robert, of Welyngoure 0
4661729 2249510 2249510 plaintiff Eustace Robert   765220 765220 Eustace, Robert, of Welyngoure 0
4808926 2298967 2298967 defendant Whyte Robert yeoman 765220 765220 Whyte, Robert, of Welyngoure, yeoman 1
4821918 2302927 2302927 defendant Boys John esq 765220 765220 Boys, John, of Welyngoure, esq 0
5062700 2375402 2375402 plaintiff Hogon William   765220 765220 Hogon, William, of Welyngoure 0
5062701 2375402 2375402 defendant Sledmare Thomas husbandman 765220 765220 Sledmare, Thomas, of Welyngoure, husbandman 0
5062702 2375402 2375402 defendant Sledmare Edward husbandman 765220 765220 Sledmare, Edward, of Welyngoure, husbandman 1
5154400 2402442 2402442 defendant Martyn William husbandman 765220 765220 Martyn, William, of Welyngoure, husbandman 0
5213705 2419742 2419742 defendant Boys Thomas gent 765220 765220 Boys, Thomas, of Welyngoure, gent 0
5213706 2419742 2419742 defendant Roos Alice widow 765220 765220 Roos, Alice, of Welyngoure, widow 1
5213707 2419742 2419742 defendant Clerk John husbandman 765220 765220 Clerk, John, of Welyngoure, husbandman 2
5213708 2419742 2419742 defendant Thomson Richard husbandman 765220 765220 Thomson, Richard, of Welyngoure, husbandman 3
5213709 2419742 2419742 defendant Veysy Richard husbandman 765220 765220 Veysy, Richard, of Welyngoure, husbandman 4
5614409 2548299 2548299 defendant Forster William   765220 765220 Forster, William, of Welyngoure 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);