names

27 rows where place_id = 634335

✎ 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
3818268 1963627 1963627 defendant Rumforth Roger fisher 634335 634335 Rumforth, Roger, of Freeston, fisher 1
3818272 1963627 1963627 defendant Crosseley William husbandman 634335 634335 Crosseley, William, of Freeston, husbandman 5
3818273 1963627 1963627 defendant Harryson Thomas fisher 634335 634335 Harryson, Thomas, of Freeston, fisher 6
3818274 1963627 1963627 defendant Gilson Thomas fisher 634335 634335 Gilson, Thomas, of Freeston, fisher 7
3818275 1963627 1963627 defendant Pakhernes William, senior fisher 634335 634335 Pakhernes, William, senior, of Freeston, fisher 8
3818276 1963627 1963627 defendant Cley Richard husbandman 634335 634335 Cley, Richard, of Freeston, husbandman 9
3818277 1963627 1963627 defendant Wade John husbandman 634335 634335 Wade, John, of Freeston, husbandman 10
3818278 1963627 1963627 defendant Bysshop Thomas weaver 634335 634335 Bysshop, Thomas, of Freeston, weaver 11
3818279 1963627 1963627 defendant Pakhernes William, junior fisher 634335 634335 Pakhernes, William, junior, of Freeston, fisher 12
3818282 1963628 1963628 defendant Rumforth Roger fisher 634335 634335 Rumforth, Roger, of Freeston, fisher 1
3818286 1963628 1963628 defendant Crosseley William husbandman 634335 634335 Crosseley, William, of Freeston, husbandman 5
3818287 1963628 1963628 defendant Harryson Thomas fisher 634335 634335 Harryson, Thomas, of Freeston, fisher 6
3818288 1963628 1963628 defendant Gylson Thomas fisher 634335 634335 Gylson, Thomas, of Freeston, fisher 7
3818289 1963628 1963628 defendant Pakhernes William, senior fisher 634335 634335 Pakhernes, William, senior, of Freeston, fisher 8
3818290 1963628 1963628 defendant Cley Richard husbandman 634335 634335 Cley, Richard, of Freeston, husbandman 9
3818291 1963628 1963628 defendant Wade John husbandman 634335 634335 Wade, John, of Freeston, husbandman 10
3818292 1963628 1963628 defendant Bysshop Thomas weaver 634335 634335 Bysshop, Thomas, of Freeston, weaver 11
3818293 1963628 1963628 defendant Pakhernes William, junior fisher 634335 634335 Pakhernes, William, junior, of Freeston, fisher 12
4296989 2129020 2129020 defendant Gladwynne Robert yeoman 634335 634335 Gladwynne, Robert, of Freeston, yeoman 0
4381756 2158577 2158577 defendant Romford Thomas yeoman 634335 634335 Romford, Thomas, of Freeston, yeoman 0
4459143 2187905 2187905 defendant Farceus Ralph   634335 634335 Farceus, Ralph, of Freeston 1
4806023 2298094 2298094 defendant Fynch Robert   634335 634335 Fynch, Robert, of Freeston, vicar 0
4822715 2303182 2303182 defendant Fynche Robert clerk 634335 634335 Fynche, Robert, of Freeston, clerk 0
5397484 2474358 2474358 defendant Taverner John husbandman 634335 634335 Taverner, John, of Freeston, husbandman 3
5424657 2482337 2482337 defendant Taverner John husbandman 634335 634335 Taverner, John, of Freeston, husbandman 3
5443386 2487938 2487938 defendant Taverner John husbandman 634335 634335 Taverner, John,of Freeston, husbandman 3
5562803 2523711 2523711 defendant Neve Robert husbandman 634335 634335 Neve, Robert, of Freeston, 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);