names

35 rows where place_id = 587171

✎ 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
3590652 1864718 1864718 defendant Langdon Joan widow 587171 587171 Langdon, Joan, of Wannesworth, widow 1
3750902 1942205 1942205 defendant Smyth John miller 587171 587171 Smyth, John, of Wannesworth, miller 2
3750903 1942205 1942205 defendant Atherton Matthew yeoman 587171 587171 Atherton, Matthew, of Wannesworth, yeoman 3
3750904 1942205 1942205 defendant Ogle James yeoman 587171 587171 Ogle, James, of Wannesworth, yeoman 4
3760373 1945249 1945249 defendant Gryffyn John clerk 587171 587171 Gryffyn, John, of Wannesworth, clerk 0
3760374 1945249 1945249 defendant Huysshe John yeoman 587171 587171 Huysshe, John, of Wannesworth, yeoman 1
3763245 1946141 1946141 defendant Gryffyn John clerk 587171 587171 Gryffyn, John, of Wannesworth, clerk 0
3763246 1946141 1946141 defendant Huysshe John yeoman 587171 587171 Huysshe, John, of Wannesworth, yeoman 1
3844933 1971960 1971960 defendant Bonn alias Tayler Richard tailor 587171 587171 Bonn alias Tayler, Richard, of Wannesworth, tailor 0
3844935 1971961 1971961 defendant Capper Thomas laborer 587171 587171 Capper, Thomas, of Wannesworth, laborer 0
3851442 1974045 1974045 defendant Aderton Mathew husbandman 587171 587171 Aderton, Mathew, of Wannesworth, husbandman 0
3913945 1995010 1995010 defendant Tomlyn alias Blme John   587171 587171 Tomlyn alias Blme, John, of Wannesworth, fell monger 0
3956735 2009423 2009423 defendant Bolton John miller 587171 587171 Bolton, John, of Wannesworth, miller 2
4651648 2246501 2246501 defendant Hunte John husbandman 587171 587171 Hunte, John, of Wannesworth, husbandman 17
4651649 2246501 2246501 defendant Colman William husbandman 587171 587171 Colman, William, of Wannesworth, husbandman 18
4651824 2246513 2246513 defendant Hunte John husbandman 587171 587171 Hunte, John, of Wannesworth, husbandman 18
4651825 2246513 2246513 defendant Colman William husbandman 587171 587171 Colman, William, of Wannesworth, husbandman 19
5088575 2383034 2383034 defendant Fyssh Robert husbandman 587171 587171 Fyssh, Robert, of Wannesworth, husbandman 0
5088576 2383034 2383034 defendant Shortfote John laborer 587171 587171 Shortfote, John, of Wannesworth, laborer 1
5088577 2383034 2383034 defendant Shortfote William laborer 587171 587171 Shortfote, William, of Wannesworth, laborer 2
5088578 2383034 2383034 defendant Templer William laborer 587171 587171 Templer, William, of Wannesworth, laborer 3
5088579 2383034 2383034 defendant Stokes William laborer 587171 587171 Stokes, William, of Wannesworth, laborer 4
5223763 2422634 2422634 defendant Notehawe Robert fuller 587171 587171 (Notehawe, Robert, of Wannesworth, fuller 4
5224356 2422798 2422798 defendant atte Ware Thomas brewer 587171 587171 atte Ware, Thomas, of Wannesworth, brewer 0
5224357 2422798 2422798 defendant Beuer John brewer 587171 587171 Beuer, John, of Wannesworth, brewer 1
5261537 2433717 2433717 defendant Wynston John brewer 587171 587171 Wynston, John, of Wannesworth, brewer 0
5275625 2437938 2437938 defendant Hert John fuller 587171 587171 Hert, John, of Wannesworth, fuller 1
5296451 2443952 2443952 defendant Fenamore William tanner 587171 587171 Fenamore, William, of Wannesworth, tanner 0
5342268 2457778 2457778 defendant Jerves William miller 587171 587171 Jerves, William, of Wannesworth, miller 0
5451019 2490196 2490196 defendant Broun William fuller 587171 587171 Broun, William, of Wannesworth, fuller 1
5453485 2490935 2490935 defendant Whyte Thomas husbandman 587171 587171 Whyte, Thomas, of Wannesworth, husbandman 0
5453487 2490936 2490936 defendant Whyte Thomas husbandman 587171 587171 Whyte, Thomas, of Wannesworth, husbandman 0
5490630 2502089 2502089 defendant Cheltenham Ralph miller 587171 587171 Cheltenham, Ralph, of Wannesworth, miller 0
5512952 2508902 2508902 defendant Albone John clerk 587171 587171 Albone, John, of Wannesworth, clerk 0
5549571 2519922 2519922 defendant Olwey Nicholas miller 587171 587171 Olwey, Nicholas, of Wannesworth, miller 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);