names

36 rows where place_id = 625056

✎ 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
3761835 1945710 1945710 defendant Dulyn Edmund gent 625056 625056 Dulyn, Edmund, of Newton Ferrys, gent 0
3761836 1945710 1945710 defendant Salmon Thomas husbandman 625056 625056 Salmon, Thomas, of Newton Ferrys, husbandman 1
3761837 1945710 1945710 defendant Harke Nicholas husbandman 625056 625056 Harke, Nicholas, of Newton Ferrys, husbandman 2
3767945 1947610 1947610 defendant Dunne William husbandman 625056 625056 Dunne, William, of Newton Ferrys, husbandman 1
3779984 1951464 1951464 defendant Dulyn Edmund gent 625056 625056 Dulyn, Edmund, of Newton Ferrys, gent 1
3780018 1951476 1951476 defendant Dulyn Edmund gent 625056 625056 Dulyn, Edmund, of Newton Ferrys, gent 0
3780019 1951476 1951476 defendant Salmon Thomas husbandman 625056 625056 Salmon, Thomas, of Newton Ferrys, husbandman 1
3780020 1951476 1951476 defendant Harke Nicholas husbandman 625056 625056 Harke, Nicholas, of Newton Ferrys, husbandman 2
3814174 1962337 1962337 defendant Dulyng Edmund gent 625056 625056 Dulyng, Edmund, of Newton Ferrys, gent 0
3814175 1962337 1962337 defendant Salman Thomas husbandman 625056 625056 Salman, Thomas, of Newton Ferrys, husbandman 1
3814176 1962337 1962337 defendant Harke Nicholas husbandman 625056 625056 Harke, Nicholas, of Newton Ferrys, husbandman 2
3970201 2014175 2014175 defendant Damerell John yeoman 625056 625056 Damerell, John, of Newton Ferrys, yeoman 0
4002953 2025828 2025828 plaintiff Holberton Alvered   625056 625056 Holberton, Alvered, of Newton Ferrys, husbandman, administrators of 0
4002954 2025828 2025828 plaintiff Fourlond John yeoman 625056 625056 (Fourlond, John, of Newton Ferrys, yeoman 1
4002955 2025828 2025828 plaintiff Collett John mariner 625056 625056 Collett, John, of Newton Ferrys, mariner 2
4002956 2025828 2025828 plaintiff Wolcombe Baldwin yeoman 625056 625056 Wolcombe, Baldwin, of Newton Ferrys, yeoman 3
4002965 2025829 2025829 plaintiff Holberton Alvered   625056 625056 Holberton, Alvered, of Newton Ferrys, husbandman, administrators of 0
4002966 2025829 2025829 plaintiff Fourlond John yeoman 625056 625056 (Fourlond, John, of Newton Ferrys, yeoman 1
4002967 2025829 2025829 plaintiff Collett John mariner 625056 625056 Collett, John, of Newton Ferrys, mariner 2
4002968 2025829 2025829 plaintiff Wolcombe Baldwin yeoman 625056 625056 Wolcombe, Baldwin, of Newton Ferrys, yeoman 3
4002976 2025830 2025830 plaintiff Holberton Alvered   625056 625056 Holberton, Alvered, of Newton Ferrys, husbandman, administrators of 0
4002977 2025830 2025830 plaintiff Fourlond John yeoman 625056 625056 (Fourlond, John, of Newton Ferrys, yeoman 1
4002978 2025830 2025830 plaintiff Collett John mariner 625056 625056 Collett, John, of Newton Ferrys, mariner 2
4002979 2025830 2025830 plaintiff Wolcombe Baldwin yeoman 625056 625056 Wolcombe, Baldwin, of Newton Ferrys, yeoman 3
4002984 2025831 2025831 plaintiff Holberton Alvered   625056 625056 Holberton, Alvered, of Newton Ferrys, husbandman, administrators of 0
4002985 2025831 2025831 plaintiff Fourlond John yeoman 625056 625056 (Fourlond, John, of Newton Ferrys, yeoman 1
4002986 2025831 2025831 plaintiff Collett John mariner 625056 625056 Collett, John, of Newton Ferrys, mariner 2
4002987 2025831 2025831 plaintiff Wolcombe Baldwin yeoman 625056 625056 Wolcombe, Baldwin, of Newton Ferrys, yeoman 3
4013958 2029726 2029726 defendant Salman Baldwin husbandman 625056 625056 Salman, Baldwin, of Newton Ferrys, husbandman 0
4035519 2037377 2037377 plaintiff Furlond John   625056 625056 (Furlond, John, of Newton Ferrys 1
4035520 2037377 2037377 plaintiff Collett John mariner 625056 625056 Collett, John, of Newton Ferrys, mariner 2
4035521 2037377 2037377 plaintiff Wolcombe Baldwin yeoman 625056 625056 Wolcombe, Baldwin, of Newton Ferrys, yeoman 3
4035525 2037378 2037378 plaintiff Furlond John   625056 625056 (Furlond, John, of Newton Ferrys 1
4035526 2037378 2037378 plaintiff Collett John mariner 625056 625056 Collett, John, of Newton Ferrys, mariner 2
4035527 2037378 2037378 plaintiff Wolcombe Baldwin yeoman 625056 625056 Wolcombe, Baldwin, of Newton Ferrys, yeoman 3
4035535 2037379 2037379 defendant Baker Edmund husbandman 625056 625056 Baker, Edmund, of Newton Ferrys, husbandman 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);