names

15 rows where place_id = 765050

✎ 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
4424660 2172553 2172553 plaintiff Knapeton John de   765050 765050 Knapeton, John de, of Frenge, parson 1
4424663 2172554 2172554 plaintiff Knapeton John de   765050 765050 Knapeton, John de, of Frenge, parson 1
4424666 2172555 2172555 plaintiff Knapton John de   765050 765050 Knapton, John de, of Frenge, parson 0
4424670 2172556 2172556 plaintiff Knapton John de   765050 765050 (Knapton, John de, of Frenge, parson 1
4424675 2172557 2172557 plaintiff Knapton John de   765050 765050 (Knapton, John de, of Frenge, parson 1
4512827 2204445 2204445 defendant Caxston William   765050 765050 Caxston, William, of Frenge 0
4546173 2214748 2214748 defendant Wantwyt John   765050 765050 Wantwyt, John, of Frenge 5
4614627 2235584 2235584 defendant Flynt John   765050 765050 Flynt, John, of Frenge 0
4668628 2255899 2255899 defendant Gerard William   765050 765050 Gerard, William, of Frenge 1
4727399 2273816 2273816 defendant Baly Robert yeoman 765050 765050 Baly, Robert, of Frenge, yeoman 2
4865421 2316152 2316152 defendant Hamond Robert husbandman 765050 765050 (Hamond, Robert, of Frenge, husbandman 2
4881139 2321009 2321009 defendant Bryghtmer Robert husbandman 765050 765050 Bryghtmer, Robert, of Frenge, husbandman 1
4881145 2321010 2321010 defendant Bryghtmer Robert husbandman 765050 765050 Bryghtmer, Robert, of Frenge, husbandman 2
5029342 2365456 2365456 defendant Tylere Thomas   765050 765050 Tylere, Thomas, of Frenge, shepherd 1
5109575 2389231 2389231 defendant Rust Nicholas husbandman 765050 765050 Rust, Nicholas, of Frenge, husbandman 4

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