names

35 rows where place_id = 703906

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4150072 2078163 2078163 defendant Alchard William yeoman 703906 703906 Alchard, William, of Eyk, yeoman 0
4522629 2207416 2207416 defendant Lystre Simon   703906 703906 Lystre, Simon, of Eyk 2
4522634 2207417 2207417 defendant Lystre Simon   703906 703906 Lystre, Simon, of Eyk 2
4580157 2225282 2225282 plaintiff Dallyng John   703906 703906 Dallyng, John, of Eyk, parson 0
4602991 2232149 2232149 defendant Elys John   703906 703906 Elys, John, of Eyk 1
4671399 2256702 2256702 defendant Elys John husbandman 703906 703906 Elys, John, of Eyk, husbandman 4
4682618 2260180 2260180 defendant Hampstede William   703906 703906 Hampstede, William, of Eyk, parson & formerly parson of Ikene 4
4683212 2260365 2260365 plaintiff Bery Nicholas   703906 703906 Bery, Nicholas, of Eyk 1
4823759 2303520 2303520 defendant Bury Nicholas gent 703906 703906 Bury, Nicholas, of Eyk, gent 0
4849837 2311421 2311421 defendant Bury Nicholas gent 703906 703906 Bury, Nicholas, of Eyk, gent 0
4865200 2316091 2316091 defendant Bury Nicholas gent 703906 703906 Bury, Nicholas, of Eyk, gent 1
4877852 2320034 2320034 defendant Bury Nicholas gent 703906 703906 Bury, Nicholas, of Eyk, gent 0
4882177 2321328 2321328 defendant Bury Nicholas gent 703906 703906 Bury, Nicholas, of Eyk, gent 1
4885622 2322378 2322378 defendant Thorn Roger husbandman 703906 703906 Thorn, Roger, of Eyk, husbandman 0
4955049 2343461 2343461 defendant Bury Nicholas gent 703906 703906 Bury, Nicholas, of Eyk, or of Becclys, Suff, gent 0
4981726 2351452 2351452 defendant Broun John baker 703906 703906 Broun, John, of Eyk, baker 0
4985061 2352462 2352462 defendant Hervy Richard laborer 703906 703906 Hervy, Richard, of Eyk, laborer 1
4985062 2352462 2352462 defendant Colvyle William laborer 703906 703906 Colvyle, William, of Eyk, laborer 2
4985063 2352462 2352462 defendant Deyne Nicholas laborer 703906 703906 Deyne, Nicholas, of Eyk, laborer 3
4987194 2353119 2353119 defendant Baker John husbandman 703906 703906 Baker, John, of Eyk, husbandman 0
4987195 2353119 2353119 defendant Broun William   703906 703906 Broun, William, of eyk, servant 1
4987196 2353119 2353119 defendant Flete Roger laborer 703906 703906 Flete, Roger, of Eyk, laborer 2
4989593 2353816 2353816 defendant Leg John tailor 703906 703906 Leg, John, of Eyk, tailor 10
4989598 2353817 2353817 defendant Spicer Richard husbandman 703906 703906 Spicer, Richard, of Eyk, husbandman 3
4989633 2353820 2353820 defendant Baker John husbandman 703906 703906 Baker, John, of eyk, husbandman 7
5014341 2361053 2361053 defendant Broun John husbandman 703906 703906 Broun, John, of Eyk, husbandman 0
5031580 2366099 2366099 defendant Broun John baker 703906 703906 Broun, John, of Eyk, baker 1
5036492 2367534 2367534 defendant Feket John husbandman 703906 703906 (Feket, John, of Eyk, husbandman 3
5040585 2368791 2368791 defendant Godard Walter yeoman 703906 703906 Godard, Walter, of Eyk, yeoman 3
5048214 2371097 2371097 plaintiff Ramsey John, junior   703906 703906 Ramsey, John, junior, of Eyk, bailiff for the Duke of Norfolk 0
5051836 2372164 2372164 plaintiff Wuley John   703906 703906 Wuley, John, of Eyk 0
5051837 2372164 2372164 defendant Onttete John laborer 703906 703906 Onttete, John, of Eyk, laborer 0
5070100 2377551 2377551 defendant Halle Roger husbandman 703906 703906 Halle, Roger, of Eyk, husbandman 1
5248795 2429766 2429766 defendant Halle Roger husbandman 703906 703906 Halle, Roger, of Eyk, husbandman 2
5267390 2435566 2435566 plaintiff Wulcy John   703906 703906 Wulcy, John, of Eyk, or of Blytheburgh 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);