names

16 rows where case_id = 1869801

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606800 1869801 1869801 plaintiff Pegeon John gent   Pegeon, John, gent 0
3606801 1869801 1869801 defendant Race Richard glover 587167 587167 Race, Richard, of Parva Walsyngham, glover 0
3606802 1869801 1869801 defendant Ibottys Adam husbandman 592162 592162 Ibottys, Adam, of Folshaumth, husbandman 1
3606803 1869801 1869801 defendant Sepens Simon husbandman 587446 587446 Sepens, Simon, of West Rudham, husbandman 2
3606804 1869801 1869801 defendant Nogeon John husbandman 586387 586387 Nogeon, John, of Southerey, husbandman 3
3606805 1869801 1869801 defendant Glover John yeoman 592163 592163 Glover, John, of Haddenham, Cams, yeoman 4
3606806 1869801 1869801 defendant Wolnawe Robert husbandman 592164 592164 Wolnawe, Robert, of Fresyngfeld, Suff, husbandman 5
3606807 1869801 1869801 defendant Awles John husbandman 587220 587220 Awles, John, of Fresyngfeld, husbandman 6
3606808 1869801 1869801 defendant Dynne William gent 591451 591451 Dynne, William, of North Creyk, gent 7
3606809 1869801 1869801 defendant Herdwyk William clerk 586231 586231 Herdwyk, William, of Wygenhale St German, clerk 8
3606810 1869801 1869801 defendant Crowe Christopher yeoman 592166 592166 Crowe, Christopher, of Myleham, yeoman 9
3606811 1869801 1869801 defendant Selwyn Richard gent 591456 591456 Selwyn, Richard, of Feltwell, gent 10
3606812 1869801 1869801 defendant Franklyn Edmund husbandman 592167 592167 Franklyn, Edmund, of Tytelshale, husbandman 11
3606813 1869801 1869801 defendant Ledegate James chaplain 592168 592168 Ledegate, James, of Cressenhale, chaplain 12
3606814 1869801 1869801 defendant Maryot John mariner 592169 592169 Maryot, John, of Burnham Depdale, mariner 13
3606815 1869801 1869801 defendant Hunt Robert husbandman 592170 592170 Hunt, Robert, of Norwold, husbandman 14

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