names

20 rows where place_id = 602751

✎ 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
3651622 1910866 1910866 defendant Legge Robert yeoman 602751 602751 Legge, Robert, of Holgate, yeoman 0
3704034 1927550 1927550 defendant Whale John yeoman 602751 602751 (Whale, John, of Holgate, yeoman 1
3704038 1927551 1927551 defendant Whayle John yeoman 602751 602751 (Whayle, John, of Holgate, yeoman 1
4148889 2077734 2077734 defendant Corrye William gent 602751 602751 Corrye, William, of Holgate, gent 0
4315402 2135497 2135497 defendant Legge William yeoman 602751 602751 Legge, William, of Holgate, yeoman 0
4328595 2139880 2139880 defendant Legge William yeoman 602751 602751 Legge, William, of Holgate, yeoman 0
4363318 2151952 2151952 defendant Becke alias Hall John laborer 602751 602751 Becke alias Hall, John, of Holgate, laborer 1
4388396 2160754 2160754 defendant Fewtrell Henry husbandman 602751 602751 Fewtrell, Henry, of Holgate, husbandman 0
4389782 2161205 2161205 defendant Beck alias Hall John laborer 602751 602751 Beck alias Hall, John, of Holgate, laborer 1
4586445 2227176 2227176 plaintiff Speller Thomas   602751 602751 Speller, Thomas, of Holgate 1
4650696 2246220 2246220 defendant Hogekys William   602751 602751 Hogekys, William, of Holgate, son of William 1
4833502 2306484 2306484 defendant Jaunes Richard chaplain 602751 602751 Jaunes, Richard, of Holgate, chaplain 0
4877277 2319848 2319848 defendant Ongall Richard husbandman 602751 602751 Ongall, Richard, of Holgate, husbandman 1
4877278 2319848 2319848 defendant Spellere Thomas husbandman 602751 602751 Spellere, Thomas, of Holgate, husbandman 2
4910093 2329679 2329679 defendant Gale Richard husbandman 602751 602751 Gale, Richard, of Holgate, husbandman 2
5015643 2361459 2361459 defendant Gayterd Richard husbandman 602751 602751 Gayterd, Richard, of Holgate, husbandman 0
5015644 2361459 2361459 defendant Symkynson John husbandman 602751 602751 Symkynson, John, of Holgate, husbandman 1
5024720 2364151 2364151 defendant Carter Richard husbandman 602751 602751 Carter, Richard, of Holgate, husbandman 0
5309416 2447857 2447857 plaintiff Spellar William husbandman 602751 602751 Spellar, William, of Holgate, husbandman 2
5633168 2554375 2554375 defendant Gayll Richard husbandman 602751 602751 Gayll, Richard, of Holgate, husbandman 3

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