names

14 rows where place_id = 613286

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3697537 1925451 1925451 defendant Breten Thomas gent 613286 613286 Breten, Thomas, of Gymmyngham, gent 0
3861057 1977181 1977181 defendant Amys Nicholas husbandman 613286 613286 Amys, Nicholas, of Gymmyngham, husbandman 1
3866760 1979118 1979118 defendant Bretton Thomas gent 613286 613286 Bretton, Thomas, of Gymmyngham, gent 4
3876514 1982391 1982391 defendant Totye William mercer 613286 613286 Totye, William, of Gymmyngham, mercer 2
3987901 2020418 2020418 defendant Bacon John husbandman 613286 613286 Bacon, John, of Gymmyngham, husbandman 0
4004395 2026351 2026351 defendant Reade Anne widow 613286 613286 Reade, Anne, of Gymmyngham, widow 0
4083754 2054463 2054463 defendant Albon John husbandman 613286 613286 Albon, John, of Gymmyngham, husbandman 0
4790910 2293248 2293248 defendant Fysshele Nicholas husbandman 613286 613286 Fysshele, Nicholas, of Gymmyngham, husbandman 1
5303190 2445946 2445946 defendant Hornygtoft John husbandman 613286 613286 Hornygtoft, John, of Gymmyngham, husbandman 0
5474988 2497503 2497503 defendant Baynbrygge John clerk 613286 613286 Baynbrygge, John, of Gymmyngham, clerk 0
5474999 2497508 2497508 defendant Baynbrygge John clerk 613286 613286 Baynbrygge, John, of Gymmyngham, clerk 1
5485371 2500538 2500538 defendant Kyng Richard yeoman 613286 613286 Kyng, Richard, of Gymmyngham, yeoman 0
5552496 2520786 2520786 defendant Forster Nicholas gent 613286 613286 Forster, Nicholas, of Gymmyngham, gent 0
5588724 2531485 2531485 defendant Bonde Richard butcher 613286 613286 Bonde, Richard, of Gymmyngham, butcher 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);