names

17 rows where place_id = 614920

✎ 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
3706268 1928247 1928247 defendant Hunyng Roger yeoman 614920 614920 Hunyng, Roger, of Swynshede, yeoman 0
3706524 1928326 1928326 plaintiff Irby Anthony gent 614920 614920 Irby, Anthony, of Swynshede, gent 0
3970816 2014379 2014379 defendant Baxter Thomas carpenter 614920 614920 Baxter, Thomas, of Swynshede, carpenter 10
3970840 2014381 2014381 defendant Baxster Thomas carpenter 614920 614920 Baxster, Thomas, of Swynshede, carpenter 10
3978672 2017117 2017117 defendant Samson John, junior husbandman 614920 614920 Samson, John, junior, of Swynshede, husbandman 0
3980346 2017741 2017741 defendant Kyd Henry smith 614920 614920 Kyd, Henry, of Swynshede, smith 0
3998989 2024397 2024397 plaintiff Fowler Robert smith 614920 614920 Fowler, Robert, of Swynshede, smith 0
4095784 2058826 2058826 defendant Nuttall Margaret widow 614920 614920 Nuttall, Margaret, of Swynshede, widow 1
4608097 2233647 2233647 plaintiff Bolle Thomas   614920 614920 Bolle, Thomas, of Swynshede, son of John 0
4629287 2240096 2240096 defendant Wilkynson John   614920 614920 Wilkynson, John, of Swynshede 2
4629288 2240096 2240096 defendant Whytelove John   614920 614920 Whytelove, John, of Swynshede 3
4796911 2295190 2295190 plaintiff Shipwryght William   614920 614920 Shipwryght, William, of Swynshede 0
4926439 2334688 2334688 defendant Grantham William husbandman 614920 614920 Grantham, William, of Swynshede, husbandman 0
5012177 2360409 2360409 defendant Loste William   614920 614920 Loste, William, of Swynshede, parson of the church of the BM 1
5177587 2409139 2409139 defendant Frythe Thomas gent 614920 614920 Frythe, Thomas, of Swynshede, gent 0
5197137 2414903 2414903 defendant Frythe Thomas gent 614920 614920 Frythe, Thomas, of Swynshede, gent 0
5209940 2418640 2418640 defendant Fryth Thomas gent 614920 614920 Fryth, Thomas, of Swynshede, gent 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);