names

16 rows where place_id = 768418

✎ 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
4548799 2215561 2215561 defendant Tilles Thomas   768418 768418 Tilles, Thomas, of Burgh by Aylesham 0
4631325 2240688 2240688 defendant Burgh John   768418 768418 Burgh, John, of Burgh by Aylesham 0
4733174 2275553 2275553 defendant Gent Walter miller 768418 768418 Gent, Walter, of Burgh by Aylesham, miller 0
4765602 2285231 2285231 defendant Goneheld Henry yeoman 768418 768418 Goneheld, Henry, of Burgh by Aylesham, yeoman 0
4765603 2285231 2285231 defendant Aleyn John merchant 768418 768418 Aleyn, John, of Burgh by Aylesham, merchant 1
4909939 2329632 2329632 defendant Gunmeld Richard clerk 768418 768418 Gunmeld, Richard, of Burgh by Aylesham, clerk 0
4911672 2330151 2330151 defendant Goneld Richard   768418 768418 Goneld, Richard, of Burgh by Aylesham, parson 2
5000135 2356919 2356919 defendant Colman Walter shoemaker 768418 768418 Colman, Walter, of Burgh by Aylesham, shoemaker 0
5124616 2393673 2393673 defendant Emson Richard miller 768418 768418 Emson, Richard, of Burgh by Aylesham, miller 0
5124617 2393673 2393673 defendant Miller Richard yeoman 768418 768418 Miller, Richard, of Burgh by Aylesham, yeoman 1
5158536 2403616 2403616 defendant Yemmes William miller 768418 768418 Yemmes, William, of Burgh by Aylesham, miller 2
5162630 2404791 2404791 defendant Red Stephen husbandman 768418 768418 Red, Stephen, of Burgh by Aylesham, husbandman 4
5181263 2410263 2410263 defendant Catys John yeoman 768418 768418 Catys, John, of Burgh by Aylesham, yeoman 1
5208754 2418282 2418282 defendant Yemmes William miller 768418 768418 Yemmes, William, of Burgh by Aylesham, miller 2
5443462 2487955 2487955 defendant Elyot John husbandman 768418 768418 Elyot, John, of Burgh by Aylesham, husbandman 12
5467087 2495102 2495102 defendant Elres John husbandman 768418 768418 Elres, John, of Burgh by Aylesham, husbandman 10

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