names

15 rows where place_id = 608341

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606338 1869650 1869650 defendant Clerk Agnes single woman 608341 608341 Clerk, Agnes, of Sythyngbourne, flax wife or single woman 0
3673259 1917651 1917651 defendant Harr John plumber 608341 608341 Harr, John, of Sythyngbourne, plumber 0
3734056 1936899 1936899 defendant Heys John husbandman 608341 608341 Heys, John, of Sythyngbourne, husbandman 0
3798238 1957347 1957347 defendant Botyller John smith 608341 608341 Botyller, John, of Sythyngbourne, smith 1
3798239 1957347 1957347 defendant Martyn Thomas tailor 608341 608341 Martyn, Thomas, of Sythyngbourne, tailor 2
4974195 2349238 2349238 defendant Cooke William husbandman 608341 608341 Cooke, William, of Sythyngbourne, husbandman 3
5031698 2366136 2366136 defendant Role William gent 608341 608341 Role, William, of Sythyngbourne, gent 0
5248939 2429814 2429814 defendant Bealde John (legal representative) 608341 608341 Bealde, John, of Sythyngbourne, yeoman, executors of 0
5248940 2429814 2429814 defendant Mayhewe Thomas yeoman 608341 608341 (Mayhewe, Thomas, of Sythyngbourne, yeoman 1
5279554 2439096 2439096 defendant Barker Roger laborer 608341 608341 Barker, Roger, of Sythyngbourne, laborer 0
5281414 2439635 2439635 defendant Cotyng Robert husbandman 608341 608341 Cotyng, Robert, of Sythyngbourne, husbandman 0
5295247 2443603 2443603 defendant Lovelace Richard, senior (legal representative) 608341 608341 Lovelace, Richard, senior, of Sythyngbourne, gent, administrator of 0
5452896 2490745 2490745 defendant Bert (illegible) butcher 608341 608341 Bert, _, of Sythyngbourne, butcher 4
5485397 2500546 2500546 defendant Hert William yeoman 608341 608341 Hert, William, of Sythyngbourne, yeoman 0
5485398 2500546 2500546 defendant Claxton Christopher tailor 608341 608341 Claxton, Christopher, of Sythyngbourne, tailor 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);