names

24 rows where place_id = 616408

✎ 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
3714219 1930746 1930746 defendant Delarever Thomas, junior esq 616408 616408 Delarever, Thomas, junior, of Brandesby, esq 0
3723171 1933516 1933516 defendant Dalaryver Thomas, junior gent 616408 616408 Dalaryver, Thomas, junior, of Brandesby, gent 0
3760501 1945289 1945289 defendant Esterby George yeoman 616408 616408 Esterby, George, of Brandesby, yeoman 0
3931329 2000771 2000771 plaintiff Delaryner Thomas esq 616408 616408 Delaryner, Thomas, of Brandesby, esq 0
4437160 2176363 2176363 defendant Ryver John de la   616408 616408 Ryver, John de la, of Brandesby 1
4502769 2201444 2201444 defendant Middelton John de   616408 616408 Middelton, John de, of Brandesby, parson 0
4668262 2255787 2255787 defendant Milner Richard milner 616408 616408 Milner, Richard, of Brandesby, milner 0
4797710 2295463 2295463 defendant Rakebayn John husbandman 616408 616408 Rakebayn, John, of Brandesby, husbandman 2
4817500 2301565 2301565 defendant Delaryver Thomas esq 616408 616408 Delaryver, Thomas, of Brandesby, esq 0
4817501 2301565 2301565 defendant Appilton Thomas clerk 616408 616408 Appilton, Thomas, of Brandesby, clerk 1
4820018 2302340 2302340 defendant Ryver Thomas de esq 616408 616408 Ryver, Thomas de, of Brandesby, esq 0
4862467 2315257 2315257 defendant de la Ryver Thomas esq 616408 616408 de la Ryver, Thomas, of Brandesby, esq 0
4867719 2316874 2316874 defendant Wath Henry chaplain 616408 616408 Wath, Henry, of Brandesby, chaplain 0
4869555 2317442 2317442 defendant Preston Thomas yeoman 616408 616408 Preston, Thomas, of Brandesby, yeoman 5
4869560 2317442 2317442 defendant Appilton Thomas clerk 616408 616408 Appilton, Thomas, of Brandesby, clerk 10
4870162 2317637 2317637 defendant Lokton William barker 616408 616408 Lokton, William, of Brandesby, barker 0
4870169 2317638 2317638 defendant Lokton William barker 616408 616408 Lokton, William, of Brandesby, barker 0
4883896 2321872 2321872 defendant de la Ryver Thomas gent 616408 616408 de la Ryver, Thomas, of Brandesby, gent 0
4887666 2322972 2322972 defendant de la Ryver Thomas gent 616408 616408 de la Ryver, Thomas, of Brandesby, gent 0
4896668 2325619 2325619 defendant de la Ryver Thomas gent 616408 616408 de la Ryver, Thomas, of Brandesby, gent 0
5213819 2419770 2419770 defendant Forster Robert husbandman 616408 616408 Forster, Robert, of Brandesby, husbandman 1
5355521 2461799 2461799 defendant Pynkne Robert   616408 616408 Pynkne, Robert, of Brandesby, wright 1
5579549 2528682 2528682 defendant Otturburn Thomas yeoman 616408 616408 Otturburn, Thomas, of Brandesby, yeoman 0
5616543 2548973 2548973 defendant Ryvere Thomas de la   616408 616408 Ryvere, Thomas de la, of Brandesby, parson 2

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);