names

13 rows where place_id = 612744

✎ 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
3694802 1924580 1924580 defendant Webster William husbandman 612744 612744 Webster, William, of Cunsby, husbandman 0
4127779 2070224 2070224 defendant Hollingworthe Thomas yeoman 612744 612744 Hollingworthe, Thomas, of Cunsby, yeoman 2
4131409 2071552 2071552 defendant Beverley Thomas yeoman 612744 612744 Beverley, Thomas, of Cunsby, yeoman 0
4155130 2079886 2079886 defendant Beverley Thomas yeoman 612744 612744 Beverley, Thomas, of Cunsby, yeoman 0
4167068 2083985 2083985 defendant Maye Alice widow 612744 612744 Maye, Alice, of Cunsby, widow 1
4182521 2089366 2089366 defendant Burrell Nicholas tailor 612744 612744 Burrell, Nicholas, of Cunsby, tailor 1
4193505 2093293 2093293 defendant Conyers John gent 612744 612744 Conyers, John, of Cunsby, gent 0
4364833 2152475 2152475 defendant Brewer William yeoman 612744 612744 Brewer, William, of Cunsby, yeoman 1
4490605 2197757 2197757 plaintiff Warde John   612744 612744 Warde, John, of Cunsby 0
5388139 2471662 2471662 defendant Hardylsey John dyer 612744 612744 Hardylsey, John, of Cunsby, dyer 18
5388140 2471662 2471662 defendant Deny John husbandman 612744 612744 Deny, John, of Cunsby, husbandman 19
5388141 2471662 2471662 defendant Pyarson John   612744 612744 Pyarson, John, of Cunsby 20
5388143 2471662 2471662 defendant Baweme William laborer 612744 612744 Baweme, William, of Cunsby, laborer 22

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