names

30 rows where place_id = 608789

✎ 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
3675412 1918347 1918347 defendant Smythe Thomas weaver 608789 608789 Smythe, Thomas, of Cheryton, weaver 0
3826264 1966060 1966060 defendant ap Thomas Richard gent 608789 608789 ap Thomas, Richard, of Cheryton, Gower, gent 2
3836362 1969280 1969280 defendant Man Thomas yeoman 608789 608789 Man, Thomas, of Cheryton, yeoman 0
3858732 1976404 1976404 defendant Man Thomas yeoman 608789 608789 Man, Thomas, of Cheryton, yeoman 0
3918438 1996494 1996494 defendant Man Thomas yeoman 608789 608789 Man, Thomas, of Cheryton, yeoman 0
3924595 1998541 1998541 defendant Bassett John husbandman 608789 608789 Bassett, John, of Cheryton, husbandman 0
3924596 1998541 1998541 defendant Bassett William husbandman 608789 608789 Bassett, William, of Cheryton, husbandman 1
3924597 1998541 1998541 defendant Honyman Richard husbandman 608789 608789 Honyman, Richard, of Cheryton, husbandman 2
3973011 2015132 2015132 defendant Layne John, senior husbandman 608789 608789 Layne, John, senior, of Cheryton, husbandman 1
3975058 2015839 2015839 plaintiff Honywood John   608789 608789 Honywood, John, of Cheryton 0
3975585 2016026 2016026 defendant Cupper William husbandman 608789 608789 Cupper, William, of Cheryton, husbandman 2
4043795 2040237 2040237 defendant Prouse William yeoman 608789 608789 Prouse, William, of Cheryton, yeoman 0
4578163 2224670 2224670 defendant Aspeley John   608789 608789 Aspeley, John, of Cheryton 0
4702364 2266150 2266150 defendant Hony Richard clerk 608789 608789 Hony, Richard, of Cheryton, clerk 0
4710224 2268550 2268550 defendant Hoke John husbandman 608789 608789 Hoke, John, of Cheryton, husbandman 0
4756225 2282320 2282320 defendant Pessa John yeoman 608789 608789 Pessa, John, of Cheryton, yeoman 3
4773936 2287828 2287828 defendant Hynde Richard husbandman 608789 608789 Hynde, Richard, of Cheryton, husbandman 0
4773938 2287829 2287829 defendant Hynde Richard husbandman 608789 608789 Hynde, Richard, of Cheryton, husbandman 0
4922827 2333553 2333553 defendant Alkham Ppeter husbandman 608789 608789 Alkham, Ppeter, of Cheryton, husbandman 0
4934244 2337099 2337099 defendant Haselgrove William clerk 608789 608789 Haselgrove, William, of Cheryton, clerk 0
4935399 2337467 2337467 defendant Helyer John butcher 608789 608789 Helyer, John, of Cheryton, butcher 1
4949427 2341811 2341811 defendant Brounyng John husbandman 608789 608789 Brounyng, John, of Cheryton, husbandman 0
5036021 2367391 2367391 defendant Waryn Peter miller 608789 608789 Waryn, Peter, of Cheryton, miller 0
5104560 2387766 2387766 defendant Hoke Richard   608789 608789 Hoke, Richard, of Cheryton, franklin 0
5104562 2387767 2387767 defendant Hoke Richard   608789 608789 Hoke, Richard, of Cheryton, franklin 0
5118747 2391914 2391914 defendant Parys William   608789 608789 Parys, William, of Cheryton, mason 0
5127600 2394557 2394557 defendant Wrytyll John   608789 608789 Wrytyll, John, of Cheryton, mason 3
5321812 2451599 2451599 defendant Alkeham Peter husbandman 608789 608789 Alkeham, Peter, of Cheryton, husbandman 0
5370401 2466328 2466328 defendant Wallyn John husbandman 608789 608789 Wallyn, John, of Cheryton, husbandman 3
5602552 2535694 2535694 defendant Thornegate William carpenter 608789 608789 Thornegate, William, of Cheryton, carpenter 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);