names

32 rows where place_id = 762794

✎ 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
4452676 2185845 2185845 plaintiff Killum John de   762794 762794 Killum, John de, of Feriby, vicar 0
4491118 2197912 2197912 defendant Heryng John   762794 762794 Heryng, John, of Feriby 0
4525703 2208339 2208339 plaintiff Jonson Robert   762794 762794 Jonson, Robert, of Feriby 0
4525706 2208339 2208339 plaintiff Dubler William   762794 762794 Dubler, William, of Feriby 3
4535587 2211407 2211407 plaintiff Smyth John   762794 762794 Smyth, John, of Feriby 0
4535588 2211407 2211407 defendant Cotyngham Thomas   762794 762794 Cotyngham, Thomas, of Feriby 0
4542680 2213598 2213598 defendant Hakenay William miller 762794 762794 Hakenay, William, of Feriby, miller 0
4576510 2224164 2224164 defendant Richecok Robert   762794 762794 Richecok, Robert, of Feriby 0
4581045 2225550 2225550 defendant Doubler Adam   762794 762794 Doubler, Adam, of Feriby 0
4582814 2226059 2226059 defendant Joneson Robert   762794 762794 Joneson, Robert, of Feriby 0
4582817 2226059 2226059 defendant Horne Robert   762794 762794 Horne, Robert, of Feriby 3
4585688 2226948 2226948 defendant Budyher John   762794 762794 Budyher, John, of Feriby 1
4587922 2227625 2227625 plaintiff Jonson Robert   762794 762794 Jonson, Robert, of Feriby 0
4587925 2227625 2227625 defendant Horne William   762794 762794 Horne, William, of Feriby 2
4587930 2227625 2227625 defendant Cotyngham Thomas   762794 762794 Cotyngham, Thomas, of Feriby 7
4587931 2227625 2227625 defendant Hanesworth John   762794 762794 Hanesworth, John, of Feriby 8
4591969 2228841 2228841 defendant Horne Robert   762794 762794 Horne, Robert, of Feriby 0
4600254 2231305 2231305 defendant Norne William   762794 762794 Norne, William, of Feriby 0
4600255 2231305 2231305 defendant Richecokes Robert   762794 762794 Richecokes, Robert, of Feriby 1
4621165 2237608 2237608 defendant Herforth John   762794 762794 Herforth, John, of Feriby 0
4621167 2237609 2237609 defendant Perkynson Robert   762794 762794 Perkynson, Robert, of Feriby 0
4679260 2259122 2259122 plaintiff Jonson Robert (legal representative) 762794 762794 Jonson, Robert, of Feriby, son of John, of South Feriby, executrix of 0
4679265 2259123 2259123 plaintiff Jonson Robert (legal representative) 762794 762794 Jonson, Robert, of Feriby, son of John, of South Feriby, executrix of 0
4679268 2259124 2259124 plaintiff Jonson Stephen   762794 762794 Jonson, Stephen, of Feriby 0
4699816 2265389 2265389 defendant Erell Alan husbandman 762794 762794 Erell, Alan, of Feriby, husbandman 0
4699818 2265389 2265389 defendant Heryng John husbandman 762794 762794 Heryng, John, of Feriby, husbandman 2
4705174 2266987 2266987 defendant Agas Robert husbandman 762794 762794 Agas, Robert, of Feriby, husbandman 2
4715272 2270109 2270109 plaintiff Walde John   762794 762794 Walde, John, of Feriby 0
4810984 2299550 2299550 defendant Hoton John   762794 762794 Hoton, John, of Feriby, Yorks, prior 2
5200966 2416045 2416045 defendant Agas William husbandman 762794 762794 Agas, William, of Feriby, husbandman 3
5200967 2416045 2416045 defendant Kirkeman William husbandman 762794 762794 Kirkeman, William, of Feriby, husbandman 4
5614673 2548387 2548387 defendant Osayn William   762794 762794 Osayn, William, of Feriby, shepherd 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);