names

18 rows where place_id = 639303

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3848096 1972983 1972983 defendant Poyns Robert mariner 639303 639303 Poyns, Robert, of Lye, Essex, mariner 0
4035255 2037287 2037287 defendant Salmon William mariner 639303 639303 Salmon, William, of Lye, Essex, mariner 2
4035261 2037288 2037288 defendant Salmon William mariner 639303 639303 Salmon, William, of Lye, Essex, mariner 2
4718742 2271201 2271201 defendant Bromley John clerk 639303 639303 Bromley, John, of Lye, Essex, clerk 3
4728363 2274109 2274109 defendant Hadley John   639303 639303 Hadley, John, of Lye, Essex, boat man 0
4728367 2274110 2274110 defendant Hadley John boatman 639303 639303 Hadley, John, of Lye, Essex, boatman 2
4800731 2296413 2296413 defendant Alvowe William shipman 639303 639303 Alvowe, William, of Lye, Essex, shipman 0
4800733 2296414 2296414 defendant Alvowe William shipman or chapman 639303 639303 Alvowe, William, of Lye, Essex, shipman or chapman 0
4831448 2305868 2305868 defendant Alfowe Thomas chapman 639303 639303 Alfowe, Thomas, of Lye, Essex, chapman 0
4893166 2324581 2324581 defendant Skynner Thomas husbandman 639303 639303 (Skynner, Thomas, of Lye, Essex, husbandman 2
4896324 2325515 2325515 defendant Deth Thomas shipman 639303 639303 Deth, Thomas, of Lye, Essex, shipman 0
4901901 2327202 2327202 defendant Deth Thomas shipman 639303 639303 Deth, Thomas, of Lye, Essex, shipman 0
5119819 2392233 2392233 defendant Haddok John mariner 639303 639303 Haddok, John, of Lye, Essex, mariner 1
5215391 2420231 2420231 defendant Hampton John mariner 639303 639303 Hampton, John, of Lye, Essex, mariner 2
5335626 2455727 2455727 defendant Lane Thomas husbandman 639303 639303 Lane, Thomas, of Lye, Essex, husbandman 1
5380861 2469582 2469582 defendant Gylle Richard husbandman 639303 639303 Gylle, Richard, of Lye, Essex, husbandman 2
5384053 2470526 2470526 defendant Gille Richard husbandman 639303 639303 Gille, Richard, of Lye, Essex, husbandman 2
5608657 2537609 2537609 defendant Gille Richard husbandman 639303 639303 Gille, Richard, of Lye, Essex, husbandman 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);