names

29 rows where place_id = 718204

✎ 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
4126557 2069783 2069783 defendant Ruddocke Stephen husbandman 718204 718204 Ruddocke, Stephen, of Est Harlinge, husbandman 2
4218438 2101950 2101950 defendant Chapman Thomas clerk 718204 718204 Chapman, Thomas, of Est Harlinge, clerk 1
4223477 2103701 2103701 defendant White Edward husbandman 718204 718204 White, Edward, of East Harlinge, husbandman 0
4224616 2104086 2104086 defendant Whighte Edward yeoman 718204 718204 Whighte, Edward, of Est harlinge, yeoman 0
4244659 2111199 2111199 defendant Chapman Thomas clerk 718204 718204 Chapman, Thomas, of Est Harlinge, clerk 1
4254242 2114417 2114417 defendant Porter Richard   718204 718204 Porter, Richard, of East Harlinge, woollen draper 0
4269443 2119371 2119371 defendant Reve Edward yeoman 718204 718204 Reve, Edward, of East Harlinge, yeoman 0
4288625 2125985 2125985 defendant Peake David cordwainer 718204 718204 Peake, David, of East Harlinge, cordwainer 0
4311609 2134203 2134203 defendant Gawdy Philip gent 718204 718204 Gawdy, Philip, of East Harlinge, gent 0
4332587 2141187 2141187 defendant Rowhead Francis cordwainer 718204 718204 Rowhead, Francis, of Est Harlinge, cordwainer 0
4332588 2141187 2141187 defendant Whood Robert husbandman 718204 718204 Whood, Robert, of East Harlinge, husbandman 1
4337692 2142929 2142929 defendant Grigge Lionel yeoman 718204 718204 Grigge, Lionel, of East Harlinge, yeoman 0
4337693 2142929 2142929 defendant Porter Edward yeoman 718204 718204 Porter, Edward, of East Harlinge, yeoman 1
4337694 2142929 2142929 defendant Crosse Thomas husbandman 718204 718204 Crosse, Thomas, of East Harlinge, husbandman 2
4344441 2145337 2145337 defendant Hubberd Robert yeoman 718204 718204 Hubberd, Robert, of Est Harlinge, yeoman 0
4353977 2148616 2148616 defendant Bett Christopher   718204 718204 Bett, Christopher, of Est Harlinge, shepherd 0
4386555 2160178 2160178 defendant Hubberd John husbandman 718204 718204 Hubberd, John, of Est Harlinge, husbandman 0
4386556 2160178 2160178 defendant Grigg Lionel yeoman 718204 718204 Grigg, Lionel, of Est Harlinge, yeoman 1
4386557 2160178 2160178 defendant Moore John husbandman 718204 718204 Moore, John, of Est Harlinge, husbandman 2
4393643 2162478 2162478 defendant Shugforth William husbandman 718204 718204 Shugforth, William, of East Harlinge, husbandman 2
4394556 2162770 2162770 defendant Dringell Robert husbandman 718204 718204 Dringell, Robert, of East Harlinge, husbandman 0
4394558 2162770 2162770 defendant Welles William beer brewer 718204 718204 Welles, William, of East Harlinge, beer brewer 2
4394559 2162770 2162770 defendant Shuckforthe William husbandman 718204 718204 Shuckforthe, William, of East Harlinge, husbandman 3
4401921 2165238 2165238 defendant Thurkettle Thomas husbandman 718204 718204 Thurkettle, Thomas, of Est Harlinge, husbandman 3
4405724 2166483 2166483 defendant Tayler William tailor 718204 718204 Tayler, William, of East Harlinge, tailor 0
4406917 2166877 2166877 defendant Sturton Elizabeth widow 718204 718204 Sturton, Elizabeth, of East Harlinge, widow 3
4407357 2167022 2167022 defendant Hubberd Robert yeoman 718204 718204 Hubberd, Robert, of Est Harlinge, yeoman 1
4408030 2167255 2167255 defendant Weylye Andrew cooper 718204 718204 Weylye, Andrew, of East Harlinge, cooper 1
4411238 2168345 2168345 defendant Canceller Thomas   718204 718204 Canceller, Thomas, of Est Harlinge husbandman 1

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