names

24 rows where place_id = 756254

✎ 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
4435831 2175953 2175953 defendant Leek William   756254 756254 Leek, William, of Morle 0
4441008 2182110 2182110 defendant Mayhowe John   756254 756254 Mayhowe, John, of Morle 0
4473343 2192322 2192322 defendant Nevyll Richard   756254 756254 Nevyll, Richard, of Morle 0
4473345 2192323 2192323 defendant Reynald John   756254 756254 Reynald, John, of Morle 0
4473347 2192323 2192323 defendant Dunnyng John   756254 756254 Dunnyng, John, of Morle 2
4478325 2193896 2193896 defendant Robert John   756254 756254 Robert, John, of Morle 0
4518829 2206255 2206255 plaintiff Drape John (legal representative) 756254 756254 Drape, John, of Morle, son of William, executors of 0
4601166 2231598 2231598 defendant Dun Thomas   756254 756254 Dun, Thomas, of Morle 0
4716823 2270588 2270588 defendant Dunnyng William yeoman 756254 756254 Dunnyng, William, of Morle, yeoman 3
4745819 2279284 2279284 defendant Swanton Andrew yeoman 756254 756254 Swanton, Andrew, of Morle, yeoman 0
4832403 2306169 2306169 defendant Asshe Richard clerk 756254 756254 Asshe, Richard, of Morle, clerk 0
4856886 2313531 2313531 defendant Asshe Richard clerk 756254 756254 Asshe, Richard, of Morle, clerk 1
4892976 2324528 2324528 defendant Morle Thomas gent 756254 756254 Morle, Thomas, of Morle, gent 0
4900869 2326903 2326903 defendant Corbald Nicholas husbandman 756254 756254 Corbald, Nicholas, of Morle, husbandman 0
4902514 2327403 2327403 defendant Morle Thomas gent 756254 756254 Morle, Thomas, of Morle, gent 0
4912415 2330385 2330385 defendant Morle Thomas gent 756254 756254 Morle, Thomas, of Morle, gent 0
4924987 2334246 2334246 defendant Wryght Roger laborer 756254 756254 Wryght, Roger, of Morle, laborer 3
4949881 2341941 2341941 defendant Assh Richard chaplain 756254 756254 Assh, Richard, of Morle, chaplain 15
5030105 2365677 2365677 plaintiff Payn John   756254 756254 Payn, John, of Morle 0
5215580 2420280 2420280 defendant Mannyng Henry husbandman 756254 756254 Mannyng, Henry, of Morle St Peter, husbandman 0
5247513 2429424 2429424 defendant Harys William chaplain 756254 756254 (Harys, William, of Morle, chaplain 6
5365794 2464957 2464957 plaintiff Bonde John   756254 756254 Bonde, John, of Morle 0
5633231 2554399 2554399 plaintiff Taillour William   756254 756254 Taillour, William, of Morle 0
5633384 2554436 2554436 plaintiff Tayllour William   756254 756254 Tayllour, William, of Morle 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);