names

42 rows where place_id = 653488

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3928757 1999956 1999956 plaintiff Bradshaye John   653488 653488 Bradshaye, John, of Bolton, Lancs 0
3928762 1999957 1999957 plaintiff Bradshaye John   653488 653488 Bradshaye, John, of Bolton, Lancs 0
3930495 2000542 2000542 defendant Whytell Robert husbandman 653488 653488 Whytell, Robert, of Bolton, Lancs, husbandman 1
3930496 2000542 2000542 defendant Ince Simon husbandman 653488 653488 Ince, Simon, of Bolton, of Lancs, husbandman 2
3945527 2005511 2005511 plaintiff Bradshawe Richard (legal representative) 653488 653488 Bradshawe, Richard, of Bolton, Lancs, "cottman", executors of 0
3993229 2022322 2022322 defendant Sedon Oliver chapman 653488 653488 Sedon, Oliver, of Bolton, Lancs, chapman 0
4017252 2030877 2030877 defendant Rothewell Robert chapman 653488 653488 Rothewell, Robert, of Bolton, Lancs, chapman 0
4025101 2033639 2033639 plaintiff Bradshaw James clothier 653488 653488 Bradshaw, James, of Bolton, Lancs, clothier 0
4025103 2033640 2033640 plaintiff Bradshaw James clothier 653488 653488 Bradshaw, James, of Bolton, Lancs, clothier 0
4028308 2034779 2034779 defendant Fogge Lawrence chapman 653488 653488 Fogge, Lawrence, of Bolton, Lancs, chapman 1
4028341 2034787 2034787 defendant Fogge Lawrence chapman 653488 653488 Fogge, Lawrence, of Bolton, Lancs, chapman 1
4035219 2037275 2037275 plaintiff Hewson alias Robynson Thomas husbandman 653488 653488 Hewson alias Robynson, Thomas, of Bolton, Lancs, husbandman 0
4083727 2054451 2054451 defendant Aynsworth John gent 653488 653488 Aynsworth, John, of Bolton, Lancs, gent 0
4121000 2067798 2067798 defendant Bateman Henry clothier 653488 653488 Bateman, Henry, of Bolton, Lancs, clothier 0
4144047 2076081 2076081 defendant Bateman Henry clothier 653488 653488 Bateman, Henry, of Bolton, Lancs, clothier 0
4153408 2079288 2079288 defendant Parker John chapman 653488 653488 Parker, John, of Bolton, Lancs, chapman 0
4157931 2080844 2080844 defendant Aynesworth John gent 653488 653488 Aynesworth, John, of Bolton, Lancs, or of Staple Inn, Middx, gent 0
4166924 2083929 2083929 defendant Battman Henry chapman 653488 653488 Battman, Henry, of Bolton, Lancs, chapman 0
4201486 2096067 2096067 defendant Aynesworth John gent 653488 653488 Aynesworth, John, of Bolton, Lancs, gent 0
4251217 2113382 2113382 defendant Sharples alias Warde Richard gent 653488 653488 Sharples alias Warde, Richard, of Bolton, Lancs, gent 1
4251223 2113383 2113383 defendant Sharples alias Warde Richard gent 653488 653488 Sharples alias Warde, Richard, of Bolton, Lancs, gent 1
4300062 2130119 2130119 defendant Morris Ralph clothier 653488 653488 Morris, Ralph, of Bolton, Lancs, clothier 0
4319464 2136917 2136917 defendant Hornbye Richard yeoman 653488 653488 Hornbye, Richard, of Bolton, Lancs, yeoman 1
4334849 2141919 2141919 defendant Norris Robert draper 653488 653488 Norris, Robert, of Bolton, Lancs, draper 2
4358189 2150098 2150098 defendant Norrys Robert draper 653488 653488 Norrys, Robert, of Bolton, Lancs, draper 2
4783375 2290820 2290820 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4783379 2290820 2290820 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4783569 2290880 2290880 defendant Lever Henry gent 653488 653488 Lever, Henry, of Bolton, Lancs, gent 0
4783574 2290881 2290881 defendant Lever Henry gent 653488 653488 Lever, Henry, of Bolton, Lancs, gent 0
4784062 2291021 2291021 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4784066 2291021 2291021 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4784079 2291022 2291022 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4784083 2291022 2291022 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4796547 2295074 2295074 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4796551 2295074 2295074 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4798823 2295811 2295811 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4798827 2295811 2295811 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
4798840 2295812 2295812 defendant Bolton Roger gent 653488 653488 Bolton, Roger, of Bolton, Lancs, gent 9
4798844 2295812 2295812 defendant Halghe William gent 653488 653488 Halghe, William, of Bolton, Lancs, gent 13
5138440 2397748 2397748 defendant Southworthe Edmund clerk 653488 653488 Southworthe, Edmund, of Bolton, Lancs, clerk 0
5138443 2397749 2397749 defendant Southworthe Edmund clerk 653488 653488 Southworthe, Edmund, of Bolton, Lancs, clerk 0
5138490 2397758 2397758 defendant Southworth Edmund clerk 653488 653488 Southworth, Edmund, of Bolton, Lancs, clerk 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);