names

17 rows where place_id = 590170

✎ 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
3600140 1867695 1867695 defendant Tylly John yeoman 590170 590170 Tylly, John, of Merden, Kent, yeoman 1
3600145 1867696 1867696 defendant Tilly John yeoman 590170 590170 Tilly, John, of Merden, Kent, yeoman 0
3620864 1874088 1874088 defendant Atherst William husbandman 590170 590170 Atherst, William, of Merden, Kent, husbandman 0
3620877 1874092 1874092 defendant Miller Thomas gent 590170 590170 Miller, Thomas, of Merden, Kent, gent 0
3647998 1909775 1909775 defendant Dyve Thomas husbandman 590170 590170 Dyve, Thomas, of Merden, Kent, husbandman 4
4138822 2074258 2074258 defendant Godfrey Peter husbandman 590170 590170 Godfrey, Peter, of Merden, Kent, husbandman 0
4852989 2312355 2312355 defendant Armegrove John gent 590170 590170 Armegrove, John, of Merden, Kent, gent 1
4969560 2347845 2347845 defendant Mellere William, junior husbandman 590170 590170 Mellere, William, junior, of Merden, Kent, husbandman 0
4969562 2347845 2347845 defendant Rolf John husbandman 590170 590170 Rolf, John, of Merden, Kent, husbandman 2
5038430 2368129 2368129 defendant Pytlesden Thomas gent 590170 590170 Pytlesden, Thomas, of Merden, Kent, gent 1
5048187 2371086 2371086 defendant Pytlesden Thomas gent 590170 590170 Pytlesden, Thomas, of Merden, Kent, gent 2
5165828 2405749 2405749 defendant Slegge Stephen gent 590170 590170 Slegge, Stephen, of Merden, Kent, gent 0
5249731 2430040 2430040 defendant Norton George gent et al 590170 590170 Norton, George, of Merden, Kent, gent et al 14
5272530 2437040 2437040 defendant Deggesell Thomas yeoman 590170 590170 Deggesell, Thomas, of Merden, Kent, yeoman 0
5377317 2468496 2468496 defendant Couper Robert clerk 590170 590170 Couper, Robert, of Merden, Kent, clerk 0
5533046 2514877 2514877 defendant Swonerdon John clothier 590170 590170 Swonerdon, John, of Merden, Kent, clothier 1
5553974 2521201 2521201 defendant Martham John, senior yeoman 590170 590170 Martham, John, senior, of Merden, Kent, yeoman 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);