names

28 rows where place_id = 756863

✎ 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
4433463 2175226 2175226 defendant Roos James de   756863 756863 Roos, James de, of Gedeney, knight 0
4441028 2182117 2182117 defendant Bateman William   756863 756863 Bateman, William, of Gedeney 1
4450123 2184998 2184998 defendant Bays John   756863 756863 Bays, John, of Gedeney 0
4453390 2186065 2186065 defendant Spendelove John   756863 756863 Spendelove, John, of Gedeney 0
4461563 2188694 2188694 plaintiff Robyn Simon   756863 756863 Robyn, Simon, of Gedeney 1
4485994 2196324 2196324 defendant Polle William   756863 756863 Polle, William, of Gedeney 0
4488672 2197181 2197181 defendant Sherman John clerk 756863 756863 Sherman, John, of Gedeney, clerk 0
4531640 2210157 2210157 plaintiff Edward John   756863 756863 Edward, John, of Gedeney 2
4542793 2213634 2213634 plaintiff Alger Thomas   756863 756863 Alger, Thomas, of Gedeney 0
4549381 2215749 2215749 defendant Kechyn John   756863 756863 Kechyn, John, of Gedeney 2
4551129 2216296 2216296 defendant Spekke William   756863 756863 Spekke, William, of Gedeney 0
4563755 2220233 2220233 defendant Hilliard John   756863 756863 Hilliard, John, of Gedeney 0
4576131 2224035 2224035 defendant Tovy Thomas   756863 756863 Tovy, Thomas, of Gedeney 0
4578561 2224784 2224784 defendant Tovy Thomas   756863 756863 Tovy, Thomas, of Gedeney 0
4579300 2225009 2225009 defendant del Kechyne John   756863 756863 del Kechyne, John, of Gedeney 0
4579726 2225145 2225145 defendant Spylman Robert   756863 756863 Spylman, Robert, of Gedeney 0
4602885 2232116 2232116 defendant Bullok John weller 756863 756863 Bullok, John, of Gedeney, weller 0
4612976 2235117 2235117 defendant Joupe John   756863 756863 Joupe, John, of Gedeney 0
4612977 2235117 2235117 defendant Wayte John   756863 756863 Wayte, John, of Gedeney 1
4648747 2245693 2245693 defendant Swaby John de chaplain 756863 756863 Swaby, John de, of Gedeney, chaplain 1
4750698 2280691 2280691 defendant Martyn John husbandman 756863 756863 Martyn, John, of Gedeney, husbandman 0
4802782 2297057 2297057 defendant Shepherd Geoffrey husbandman 756863 756863 Shepherd, Geoffrey, of Gedeney, husbandman 0
4857287 2313667 2313667 defendant Kerchiefwhessher Joan widow 756863 756863 Kerchiefwhessher, Joan, of Gedeney, widow 1
4954084 2343187 2343187 defendant Knapton John husbandman 756863 756863 Knapton, John, of Gedeney, husbandman 1
5042115 2369248 2369248 defendant Bochere Thomas   756863 756863 Bochere, Thomas, of Gedeney, salt weller 0
5042116 2369248 2369248 defendant Thakker Thomas husbandman 756863 756863 Thakker, Thomas, of Gedeney, husbandman 1
5123239 2393234 2393234 defendant Ireby John chaplain 756863 756863 Ireby, John, of Gedeney, chaplain 0
5620183 2550173 2550173 plaintiff Roos Robert   756863 756863 Roos, Robert, of Gedeney, knight 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);