names

15 rows where place_id = 601601

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646151 1909198 1909198 defendant Mandelbe John reeder 601601 601601 Mandelbe, John, of Byllokby, reeder 2
3723253 1933544 1933544 defendant Gawcell William gent 601601 601601 Gawcell, William, of Byllokby, gent 0
3762348 1945865 1945865 defendant Arche alias Snyterton Thomas yeoman 601601 601601 Arche alias Snyterton, Thomas, of Byllokby, yeoman 5
3774917 1949886 1949886 defendant Gawsell William gent 601601 601601 Gawsell, William,of Byllokby, gent 0
3790870 1954974 1954974 defendant Gansell William gent 601601 601601 Gansell, William, of Byllokby, gent 0
3890346 1987020 1987020 defendant Mauhewe Robert yeoman 601601 601601 Mauhewe, Robert, of Byllokby, yeoman 0
3890347 1987020 1987020 defendant Ufford Peter yeoman 601601 601601 Ufford, Peter, of Byllokby, yeoman 1
4608031 2233629 2233629 defendant Lyng Oliver   601601 601601 Lyng, Oliver, of Byllokby 0
4608032 2233629 2233629 defendant Richeman Thomas   601601 601601 Richeman, Thomas, of Byllokby 1
4963905 2346115 2346115 defendant Pallyng Robert husbandman 601601 601601 Pallyng, Robert, of Byllokby, husbandman 0
4964342 2346249 2346249 defendant Pallyng Robert husbandman 601601 601601 Pallyng, Robert, of Byllokby, husbandman 0
5074488 2378873 2378873 defendant Mancep Katherine spinster 601601 601601 Mancep, Katherine, of Byllokby, spinster 0
5317422 2450294 2450294 defendant Say John, senior laborer 601601 601601 Say, John, senior, of Byllokby, laborer 0
5317423 2450294 2450294 defendant Say John, junior laborer 601601 601601 Say, John, junior, of Byllokby, laborer 1
5378263 2468777 2468777 defendant Bumpsted John gent 601601 601601 Bumpsted, John, of Byllokby, gent 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);