names

15 rows where place_id = 591626

✎ 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
3605015 1869231 1869231 defendant Harlwyn Thomas husbandman 591626 591626 Harlwyn, Thomas, of Geddyng, husbandman 2
3705092 1927883 1927883 defendant Whelbely Robert husbandman 591626 591626 Whelbely, Robert, of Geddyng, husbandman 0
4335127 2142020 2142020 defendant Southe Walter yeoman 591626 591626 Southe, Walter, of Geddyng, yeoman 0
4577471 2224468 2224468 defendant Smyth John   591626 591626 Smyth, John, of Geddyng 0
4608890 2233882 2233882 defendant Smyth John   591626 591626 Smyth, John, of Geddyng 4
4718259 2271046 2271046 defendant Cosyn John clerk 591626 591626 Cosyn, John, of Geddyng, clerk 4
4727828 2273946 2273946 defendant Shastyng John husbandman 591626 591626 Shastyng, John, of Geddyng, husbandman 4
4742377 2278264 2278264 defendant Wodelond Thomas smith 591626 591626 Wodelond, Thomas, of Geddyng, smith 0
4886637 2322685 2322685 defendant Manfeld Geoffrey yeoman 591626 591626 Manfeld, Geoffrey, of Geddyng, yeoman 1
4915719 2331416 2331416 defendant Tyler Robert tiler 591626 591626 Tyler, Robert, of Geddyng, tiler 0
5038040 2368009 2368009 defendant Ramsey William husbandman 591626 591626 Ramsey, William, of Geddyng, husbandman 1
5241450 2427698 2427698 defendant Mason Robert   591626 591626 Mason, Robert, of Geddyng, mason 1
5255618 2431874 2431874 defendant Mason Robert   591626 591626 Mason, Robert, of Geddyng, freemason 4
5266228 2435191 2435191 defendant Chamberleyn Margaret widow 591626 591626 (Chamberleyn, Margaret, of Geddyng, widow 1
5490891 2502173 2502173 defendant Chamberleyn Robert   591626 591626 Chamberleyn, Robert, of Geddyng, knight 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);