names

31 rows where place_id = 775946

✎ 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
4628582 2239864 2239864 defendant Halle John   775946 775946 Halle, John, of Mersshefeld 1
4782678 2290597 2290597 defendant Halle John chapman 775946 775946 Halle, John, of Mersshefeld, chapman 1
4868955 2317263 2317263 defendant Bole John, junior husbandman 775946 775946 Bole, John, junior, of Mersshefeld, husbandman 0
4903680 2327768 2327768 defendant Fisshe William maltman 775946 775946 Fisshe, William, of Mersshefeld, maltman 0
4915974 2331494 2331494 defendant Cornysshe John laborer 775946 775946 Cornysshe, John, of Mersshefeld, laborer 0
4922195 2333356 2333356 defendant Mabank Thomas chaplain 775946 775946 Mabank, Thomas, of Mersshefeld, chaplain 0
4949489 2341834 2341834 defendant Artur John husbandman 775946 775946 Artur, John, of Mersshefeld, husbandman 0
5015113 2361305 2361305 defendant Nycoll John husbandman 775946 775946 Nycoll, John, of Mersshefeld, husbandman 0
5017172 2361920 2361920 defendant Southwode Thomas laborer 775946 775946 Southwode, Thomas, of Mersshefeld, laborer 1
5017173 2361920 2361920 defendant Mulward William   775946 775946 Mulward, William, of Mersshefeld, servant 2
5017224 2361923 2361923 defendant Benfeld Thomas husbandman 775946 775946 Benfeld, Thomas, of Mersshefeld, husbandman 12
5017225 2361923 2361923 defendant Hert Thomas baker 775946 775946 Hert, Thomas, of Mersshefeld, baker 13
5023765 2363856 2363856 defendant Lucas John clerk 775946 775946 Lucas, John, of Mersshefeld, clerk 0
5031982 2366226 2366226 defendant Pope Thomas chaplain 775946 775946 Pope, Thomas, of Mersshefeld, chaplain 0
5039669 2368509 2368509 defendant Spycer William   775946 775946 Spycer, William, of Mersshefeld, wax chandler 0
5056545 2373538 2373538 defendant Southwode Thoms laborer 775946 775946 Southwode, Thoms, of Mersshefeld, laborer 1
5056546 2373538 2373538 defendant Milleward William   775946 775946 Milleward, William, of Mersshefeld, servant 2
5079738 2380425 2380425 defendant Southwode Thomas laborer 775946 775946 Southwode, Thomas, of Mersshefeld, laborer 1
5079739 2380425 2380425 defendant Milward William   775946 775946 Milward, William, of Mersshefeld, servant 2
5140682 2398387 2398387 defendant Hall Walter husbandman 775946 775946 Hall, Walter, of Mersshefeld, husbandman 0
5140683 2398387 2398387 defendant Hall William husbandman 775946 775946 Hall, William, of Mersshefeld, husbandman 1
5161805 2404561 2404561 defendant Gaunsewell Thomas husbandman 775946 775946 Gaunsewell, Thomas, of Mersshefeld, husbandman 0
5161807 2404562 2404562 defendant Hall Walter husbandman 775946 775946 Hall, Walter, of Mersshefeld, husbandman 0
5161808 2404562 2404562 defendant Hall William husbandman 775946 775946 Hall, William, of Mersshefeld, husbandman 1
5176088 2408692 2408692 defendant Gaunswell Thomas husbandman 775946 775946 Gaunswell, Thomas, of Mersshefeld, husbandman 0
5176090 2408693 2408693 defendant Hall Walter husbandman 775946 775946 Hall, Walter, of Mersshefeld, husbandman 0
5176091 2408693 2408693 defendant Hall William husbandman 775946 775946 Hall, William, of Mersshefeld, husbandman 1
5267992 2435752 2435752 defendant Berkeley John yeoman 775946 775946 Berkeley, John, of Mersshefeld, yeoman 0
5280520 2439379 2439379 defendant Mody William smith 775946 775946 Mody, William, of Mersshefeld, smith 4
5522911 2511996 2511996 defendant Glover Thomas glover 775946 775946 Glover, Thomas, of Mersshefeld, glover 0
5605099 2536465 2536465 defendant Arnold Elizabeth widow 775946 775946 Arnold, Elizabeth, of Mersshefeld, or of Keynesham, Soms, widow 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);