names

31 rows where place_id = 609623

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3679384 1919615 1919615 defendant Elenden alias Elyngdon John yeoman 609623 609623 Elenden alias Elyngdon, John, of South Bemflete, yeoman 0
3697934 1925575 1925575 defendant Frend Richard   609623 609623 Frend, Richard, of South Bemflete, wax chandler 1
3854343 1974999 1974999 defendant Munde John, senior waterman 609623 609623 Munde, John, senior, of South Bemflete, waterman 0
3894295 1988310 1988310 defendant Malbroke William pulter 609623 609623 Malbroke, William, of South Bemflete, pulter 3
4523929 2207817 2207817 defendant Hawekyn Roger   609623 609623 Hawekyn, Roger, of South Bemflete 1
4530557 2209855 2209855 plaintiff Orange Richard   609623 609623 Orange, Richard, of South Bemflete 0
4530939 2209968 2209968 plaintiff Pampelon Richard   609623 609623 Pampelon, Richard, of South Bemflete 0
4560928 2219371 2219371 defendant Brasiere John   609623 609623 Brasiere, John, of South Bemflete 0
4560929 2219371 2219371 defendant Holefold John   609623 609623 Holefold, John, of South Bemflete 1
4560931 2219372 2219372 defendant Plot John   609623 609623 Plot, John, of South Bemflete 0
4564359 2220421 2220421 defendant Pamphiloun Richard   609623 609623 Pamphiloun, Richard, of South Bemflete 0
4565176 2220680 2220680 plaintiff Skynner James   609623 609623 Skynner, James, of South Bemflete 0
4565177 2220680 2220680 defendant Prowede Thomas   609623 609623 Prowede, Thomas, of South Bemflete 0
4577248 2224403 2224403 plaintiff Canon John   609623 609623 Canon, John, of South Bemflete 0
4696165 2264282 2264282 defendant Wybard Thomas chaplain 609623 609623 Wybard, Thomas, of South Bemflete, chaplain 1
4977975 2350377 2350377 defendant Alverych John baker 609623 609623 Alverych, John, of South Bemflete, baker 1
5014933 2361245 2361245 defendant Hyk Thomas   609623 609623 Hyk, Thomas, of South Bemflete, shepherd 0
5014934 2361245 2361245 defendant Boll William   609623 609623 Boll, William, of South Bemflete, shepherd 1
5071562 2377990 2377990 defendant Blower John, senior husbandman 609623 609623 Blower, John, senior, of South Bemflete, husbandman 0
5090623 2383640 2383640 defendant Alwyn John butcher 609623 609623 Alwyn, John, of South Bemflete, butcher 0
5095578 2385130 2385130 defendant Ferman John husbandman 609623 609623 Ferman, John, of South Bemflete, husbandman 0
5100939 2386687 2386687 defendant Geffrey James waterman 609623 609623 Geffrey, James, of South Bemflete, waterman 1
5126179 2394139 2394139 defendant Rycher Thomas husbandman 609623 609623 Rycher, Thomas, of South Bemflete, husbandman 0
5141162 2398537 2398537 defendant Stokwode Thomas husbandman 609623 609623 Stokwode, Thomas, of South Bemflete, husbandman 0
5144806 2399634 2399634 defendant Rycher Thomas husbandman 609623 609623 Rycher, Thomas, of South Bemflete, husbandman 0
5154652 2402515 2402515 defendant Tukke John chapman 609623 609623 Tukke, John, of South Bemflete, chapman 1
5263341 2434282 2434282 defendant Tukke John yeoman 609623 609623 Tukke, John, of South Bemflete, yeoman 0
5319356 2450882 2450882 defendant Alwyn John butcher 609623 609623 Alwyn, John, of South Bemflete, butcher 0
5578232 2528262 2528262 defendant Wyseman James husbandman 609623 609623 Wyseman, James, of South Bemflete, husbandman 5
5593992 2533111 2533111 defendant Taylour Thomas mariner 609623 609623 Taylour, Thomas, of South Bemflete, mariner 0
5633352 2554424 2554424 defendant Canoun John yeoman 609623 609623 Canoun, John, of South Bemflete, yeoman 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);