names

24 rows where place_id = 699202

✎ 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
4127846 2070248 2070248 defendant Davies Richard vintner 699202 699202 Davies, Richard, of Uxbridge, vintner 2
4334713 2141876 2141876 defendant Adames alias Fletcher Ralph yeoman 699202 699202 Adames alias Fletcher, Ralph, of Uxbridge, yeoman 2
4406374 2166696 2166696 defendant White Tristram mercer 699202 699202 White, Tristram, of Uxbridge, mercer 2
4407066 2166921 2166921 defendant Rose Nicholas bricklayer 699202 699202 Rose, Nicholas, of Uxbridge, bricklayer 3
4649902 2245988 2245988 defendant Standen John   699202 699202 Standen, John, of Uxbridge 0
4717323 2270750 2270750 defendant Halstowe John   699202 699202 Halstowe, John, of Uxbridge, Middx, scrivenor 1
4770012 2286592 2286592 plaintiff Whyte Stephen   699202 699202 Whyte, Stephen, of Uxbridge 1
4772805 2287463 2287463 defendant Longe John yeoman 699202 699202 Longe, John, of Uxbridge, yeoman 0
4773058 2287544 2287544 plaintiff Sturmy John   699202 699202 Sturmy, John, of Uxbridge, spice seller 0
5134123 2396476 2396476 defendant Clyfford Stephen yeoman 699202 699202 Clyfford, Stephen, of Uxbridge, yeoman 2
5134129 2396477 2396477 defendant Clyfford Stephen yeoman 699202 699202 Clyfford, Stephen, of Uxbridge, yeoman 3
5156573 2403076 2403076 defendant Hert John chapman 699202 699202 Hert, John, of Uxbridge, chapman 0
5157014 2403193 2403193 defendant Hert John chapman 699202 699202 Hert, John, of Uxbridge, chapman 0
5171274 2407320 2407320 defendant Gullofre William dyer 699202 699202 Gullofre, William, of Uxbridge, dyer 1
5171276 2407320 2407320 defendant Clyfford Stephen yeoman 699202 699202 Clyfford, Stephen, of Uxbridge, yeoman 3
5173069 2407834 2407834 defendant Hert John chapman 699202 699202 Hert, John, of Uxbridge, chapman 0
5178128 2409309 2409309 defendant Quentrell Richard husbandman 699202 699202 Quentrell, Richard, of Uxbridge, husbandman 0
5178129 2409309 2409309 defendant Staunton Richard   699202 699202 Staunton, Richard, of Uxbridge, pin maker 1
5189568 2412689 2412689 defendant Gullofre William dyer 699202 699202 Gullofre, William, of Uxbridge, dyer 1
5189569 2412689 2412689 defendant Clyfford (illegible) yeoman 699202 699202 Clyfford, _, of Uxbridge, yeoman 2
5207435 2417916 2417916 defendant Gulloffy William dyer 699202 699202 Gulloffy, William, of Uxbridge, dyer 0
5208658 2418254 2418254 defendant Wakefeld Richard fishmonger 699202 699202 Wakefeld, Richard, of Uxbridge, fishmonger 0
5208660 2418255 2418255 defendant Wakefeld Richard fishmonger 699202 699202 Wakefeld, Richard, of Uxbridge, fishmonger 0
5372866 2467109 2467109 defendant Surrey John chaplain 699202 699202 Surrey, John, of Uxbridge, chaplain 2

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);