names

31 rows where place_id = 757331

✎ 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
4444952 2183395 2183395 defendant Rych William   757331 757331 Rych, William, of Waldegrave 0
4483374 2195493 2195493 defendant Barcolf Nicholas   757331 757331 Barcolf, Nicholas, of Waldegrave 16
4483375 2195493 2195493 defendant Chyrye John   757331 757331 Chyrye, John, of Waldegrave 17
4591674 2228752 2228752 defendant Smyth John   757331 757331 Smyth, John, of Waldegrave 0
4610873 2234473 2234473 defendant Smyth John   757331 757331 Smyth, John, of Waldegrave 0
4610874 2234473 2234473 defendant Hogge Thomas   757331 757331 Hogge, Thomas, of Waldegrave 1
4633074 2241213 2241213 defendant Hoggys Thomas   757331 757331 Hoggys, Thomas, of Waldegrave 0
4633076 2241213 2241213 defendant Smyth John   757331 757331 Smyth, John, of Waldegrave 2
4677156 2258471 2258471 defendant Smyth John husbandman 757331 757331 Smyth, John, of Waldegrave, husbandman 0
4697026 2264550 2264550 defendant Kyllyng Augustine gent 757331 757331 Kyllyng, Augustine, of Waldegrave, gent 0
4739437 2277419 2277419 defendant Blundell Richard husbandman 757331 757331 Blundell, Richard, of Waldegrave, husbandman 0
4900193 2326687 2326687 defendant Maydewell Simon ploughman 757331 757331 Maydewell, Simon, of Waldegrave, ploughman 0
4900218 2326695 2326695 defendant Maydewell Simon ploughman 757331 757331 Maydewell, Simon, of Waldegrave, ploughman 0
4903000 2327551 2327551 defendant Smyth John smith 757331 757331 Smyth, John, of Waldegrave, smith 0
4903001 2327551 2327551 defendant Pole John weaver 757331 757331 Pole, John, of Waldegrave, weaver 1
4903002 2327551 2327551 defendant Maydewell Simon yeoman 757331 757331 Maydewell, Simon, of Waldegrave, yeoman 2
4925665 2334461 2334461 defendant Smyth John farrier 757331 757331 Smyth, John, of Waldegrave, farrier 0
4925666 2334461 2334461 defendant Pole John weaver 757331 757331 Pole, John, of Waldegrave, weaver 1
4960420 2345080 2345080 defendant Smyth John drover 757331 757331 Smyth, John, of Waldegrave, drover 0
4977084 2350100 2350100 defendant Maydewell Simon yeoman 757331 757331 Maydewell, Simon, of Waldegrave, yeoman 4
4985394 2352553 2352553 defendant Derwent John husbandman 757331 757331 Derwent, John, of Waldegrave, husbandman 0
4985395 2352553 2352553 defendant Derwent William husbandman 757331 757331 Derwent, William, of Waldegrave, husbandman 1
5000684 2357074 2357074 defendant Bernard Robert husbandman 757331 757331 Bernard, Robert, of Waldegrave, husbandman 0
5000685 2357074 2357074 defendant Dalby Thomas husbandman 757331 757331 Dalby, Thomas, of Waldegrave, husbandman 1
5048608 2371224 2371224 defendant Aylmer Thomas drover 757331 757331 Aylmer, Thomas, of Waldegrave, drover 0
5061512 2375033 2375033 defendant Blacusley John yeoman 757331 757331 Blacusley, John, of Waldegrave, yeoman 0
5250069 2430128 2430128 defendant Austen Richard gent 757331 757331 Austen, Richard, of Waldegrave, gent 0
5250074 2430129 2430129 defendant Sprot John husbandman 757331 757331 Sprot, John, of Waldegrave, husbandman 0
5250079 2430130 2430130 defendant Mauncell John husbandman 757331 757331 Mauncell, John, of Waldegrave, husbandman 0
5611916 2547460 2547460 defendant Wryght Henry   757331 757331 Wryght, Henry, of Waldegrave 0
5627698 2552632 2552632 defendant Smyth John drover 757331 757331 Smyth, John, of Waldegrave, drover 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);