names

20 rows where place_id = 648323

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3901036 1990575 1990575 defendant Clerke John husbandman 648323 648323 Clerke, John, of Asshen, husbandman 0
4118161 2066779 2066779 defendant Rede Robert yeoman 648323 648323 Rede, Robert, of Asshen, yeoman 0
4118163 2066780 2066780 defendant Rede Robert yeoman 648323 648323 Rede, Robert, of Asshen, yeoman 0
4118169 2066783 2066783 defendant Sherman John yeoman 648323 648323 Sherman, John, of Asshen, yeoman 0
4118171 2066784 2066784 defendant Sherman John yeoman 648323 648323 Sherman, John, of Asshen, yeoman 0
4412958 2168927 2168927 defendant Chaunceux Roger   648323 648323 Chaunceux, Roger, of Asshen, parson 0
4418806 2170749 2170749 defendant Chaunceux Roger   648323 648323 Chaunceux, Roger, of Asshen, parson 0
4637224 2242438 2242438 defendant Kempston Walter (legal representative) 648323 648323 Kempston, Walter, of Asshen, parson of, executors of 0
4641766 2243692 2243692 defendant Broke William   648323 648323 Broke, William, of Asshen 0
4728321 2274100 2274100 defendant Parker John   648323 648323 Parker, John, of Asshen 11
4728337 2274101 2274101 defendant Parker John   648323 648323 Parker, John, of Asshen 11
4819619 2302208 2302208 defendant Assheby Philip gent 648323 648323 Assheby, Philip, of Asshen, gent 0
4820367 2302440 2302440 defendant Assheby Philip gent 648323 648323 Assheby, Philip, of Asshen, gent 0
4820369 2302441 2302441 defendant Assheby Philip gent 648323 648323 Assheby, Philip, of Asshen, gent 0
4828708 2305021 2305021 defendant Body William clerk 648323 648323 Body, William, of Asshen, clerk 0
4857675 2313780 2313780 defendant Gryme John yeoman 648323 648323 Gryme, John, of Asshen, yeoman 0
4979631 2350864 2350864 defendant Carter John husbandman 648323 648323 Carter, John, of Asshen, husbandman 5
5289491 2441926 2441926 defendant Ryvell John husbandman 648323 648323 Ryvell, John, of Asshen, husbandman 2
5320089 2451099 2451099 defendant Shirley Elizabeth widow 648323 648323 (Shirley, Elizabeth, of Asshen, widow 3
5578682 2528396 2528396 defendant Rande Richard smith 648323 648323 Rande, Richard, of Asshen, smith 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);