names

24 rows where place_id = 595508

✎ 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
3620777 1874072 1874072 plaintiff Mason Thomas husbandman 595508 595508 Mason, Thomas, of Swannescombe, husbandman 0
3631692 1904725 1904725 defendant Maykyn John tanner 595508 595508 Maykyn, John, of Swannescombe, tanner 1
3679200 1919563 1919563 defendant Chalderton Arnold gent 595508 595508 Chalderton, Arnold, of Swannescombe, gent 0
3818315 1963635 1963635 defendant Clement John husbandman 595508 595508 Clement, John, of Swannescombe, husbandman 3
3900493 1990395 1990395 defendant Meriall Martin husbandman 595508 595508 Meriall, Martin, of Swannescombe, husbandman 3
4754023 2281642 2281642 defendant Hildeman Ralph husbandman 595508 595508 Hildeman, Ralph, of Swannescombe, husbandman 0
4754024 2281642 2281642 defendant Gosehen Richard husbandman 595508 595508 Gosehen, Richard, of Swannescombe, husbandman 1
4928458 2335323 2335323 defendant Mason John laborer 595508 595508 Mason, John, of Swannescombe, laborer 0
4928459 2335323 2335323 defendant atte Hethe Robert husbandman 595508 595508 atte Hethe, Robert, of Swannescombe, husbandman 1
4953701 2343069 2343069 defendant Mason John laborer 595508 595508 Mason, John, of Swannescombe, laborer 0
4953702 2343069 2343069 defendant Hethe Robert husbandman 595508 595508 Hethe, Robert, of Swannescombe, husbandman 1
4970375 2348084 2348084 defendant Everard Peter laborer 595508 595508 Everard, Peter, of Swannescombe, laborer 4
4975373 2349593 2349593 defendant Bokelond Robert husbandman 595508 595508 Bokelond, Robert, of Swannescombe, husbandman 3
4978460 2350505 2350505 defendant Smyth Andrew laborer 595508 595508 Smyth, Andrew, of Swannescombe, laborer 1
4983889 2352110 2352110 defendant Danyell William husbandman 595508 595508 Danyell, William, of Swannescombe, husbandman 0
4983890 2352110 2352110 defendant Maston Robert husbandman 595508 595508 Maston, Robert, of Swannescombe, husbandman 1
5259194 2432993 2432993 defendant Danyell William husbandman 595508 595508 Danyell, William, of Swannescombe, husbandman 0
5263920 2434475 2434475 defendant Danyell William husbandman 595508 595508 Danyell, William, of Swannescombe, husbandman 0
5263922 2434476 2434476 defendant Gest Richard husbandman 595508 595508 Gest, Richard, of Swannescombe, husbandman 0
5263923 2434476 2434476 defendant Danyell William husbandman 595508 595508 Danyell, William, of Swannescombe, husbandman 1
5287528 2441377 2441377 defendant Person alias Croucher William clerk 595508 595508 Person alias Croucher, William, of Swannescombe, clerk 0
5338485 2456606 2456606 defendant Thomas Reginald chaplain 595508 595508 Thomas, Reginald, of Swannescombe, chaplain 0
5555265 2521544 2521544 defendant Maldby Thomas yeoman 595508 595508 Maldby, Thomas, of Swannescombe, yeoman 2
5569305 2525582 2525582 defendant Clement Guy husbandman 595508 595508 Clement, Guy, of Swannescombe, husbandman 1

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