names

19 rows where place_id = 608951

✎ 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
3676257 1918621 1918621 defendant Godhyne Edmund yeoman 608951 608951 Godhyne, Edmund, of Fayrefeld, yeoman 0
3724367 1933909 1933909 plaintiff Robyn Edmund yeoman 608951 608951 Robyn, Edmund, of Fayrefeld, yeoman 0
3729546 1935488 1935488 defendant Goddard Simon husbandman 608951 608951 Goddard, Simon, of Fayrefeld, husbandman 0
4297909 2129353 2129353 defendant Ferne John husbandman 608951 608951 Ferne, John, of Fayrefeld, husbandman 1
4297912 2129353 2129353 defendant Palfreman Ellen widow 608951 608951 Palfreman, Ellen, of Fayrefeld, widow 4
4509819 2203556 2203556 defendant Admond John tailor 608951 608951 Admond, John, of Fayrefeld, tailor 3
4695700 2264136 2264136 defendant Sedlyde Robert farmer 608951 608951 Sedlyde, Robert, of Fayrefeld, farmer 0
4704912 2266914 2266914 defendant Lamsyn John husbandman 608951 608951 Lamsyn, John, of Fayrefeld, husbandman 0
4878252 2320150 2320150 defendant Nedam Thomas husbandman 608951 608951 Nedam, Thomas, of Fayrefeld, husbandman 1
4901300 2327016 2327016 defendant Daukyn John husbandman 608951 608951 Daukyn, John, of Fayrefeld, husbandman 0
5007692 2359144 2359144 defendant Dawekyn John husbandman 608951 608951 Dawekyn, John, of Fayrefeld, husbandman 12
5024167 2363981 2363981 defendant Verney John gent 608951 608951 Verney, John, of Fayrefeld, gent 0
5116487 2391254 2391254 defendant Rolf Thomas husbandman 608951 608951 Rolf, Thomas, of Fayrefeld, husbandman 0
5322384 2451766 2451766 defendant Halle William yeoman 608951 608951 Halle, William, of Fayrefeld, yeoman 16
5322404 2451767 2451767 defendant Halle William yeoman 608951 608951 Halle, William, of Fayrefeld, yeoman 16
5399818 2475041 2475041 defendant Hoggekynson John husbandman 608951 608951 Hoggekynson, John, of Fayrefeld, husbandman 5
5412815 2478782 2478782 defendant Hoggekynson John husbandman 608951 608951 Hoggekynson, John, of Fayrefeld, husbandman 5
5467777 2495299 2495299 defendant Inglot William husbandman 608951 608951 Inglot, William, of Fayrefeld, husbandman 0
5489103 2501624 2501624 defendant Godard Thomas yeoman 608951 608951 Godard, Thomas, of Fayrefeld, yeoman 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);