names

33 rows where place_id = 588723

✎ 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
3595383 1866187 1866187 defendant Clerk John chapman 588723 588723 Clerk, John, of Westram, Kent, chapman 3
3683743 1921049 1921049 defendant Hayte John pulter 588723 588723 Hayte, John, of Westram, Kent, pulter 1
3702307 1926980 1926980 defendant Hartystonge John carpenter 588723 588723 Hartystonge, John, of Westram, Kent, carpenter 0
3758475 1944646 1944646 defendant Potter John baker 588723 588723 Potter, John, of Westram, Kent, baker 0
3776501 1950404 1950404 defendant Potter John baker 588723 588723 Potter, John, of Westram, Kent, baker 0
3779713 1951386 1951386 defendant Potter John gent 588723 588723 Potter, John, of Westram, Kent, gent 0
3809216 1960764 1960764 defendant Potter Edward yeoman 588723 588723 Potter, Edward, of Westram, Kent, yeoman 0
3809226 1960767 1960767 defendant Potter Edward yeoman 588723 588723 Potter, Edward, of Westram, Kent, yeoman 0
3879275 1983320 1983320 plaintiff Middelton William gent 588723 588723 Middelton, William, of Westram, Kent, gent 0
4404075 2165932 2165932 defendant Sacksbie Anthony yeoman 588723 588723 Sacksbie, Anthony, of Westram, Kent, yeoman 0
4753202 2281385 2281385 defendant Gourder Thomas husbandman 588723 588723 Gourder, Thomas, of Westram, Kent, husbandman 0
4939400 2338705 2338705 defendant Marchaunt John yeoman 588723 588723 Marchaunt, John, of Westram, Kent, yeoman 0
4977408 2350205 2350205 defendant Herman John husbandman 588723 588723 Herman, John, of Westram, Kent, husbandman 0
4977410 2350206 2350206 defendant Herman John husbandman 588723 588723 Herman, John, of Westram, Kent, husbandman 0
5054051 2372803 2372803 defendant Smyth John husbandman 588723 588723 Smyth, John, of Westram, Kent, husbandman 5
5075259 2379092 2379092 defendant atte Welle Richard husbandman 588723 588723 atte Welle, Richard, of Westram, Kent, husbandman 0
5092342 2384138 2384138 defendant Colham William tanner 588723 588723 Colham, William, of Westram, Kent, tanner 3
5107488 2388620 2388620 defendant Colman William tanner 588723 588723 Colman, William, of Westram, Kent, tanner 0
5223477 2422558 2422558 defendant Smyth Richard yeoman 588723 588723 Smyth, Richard, of Westram, Kent, yeoman 1
5315556 2449719 2449719 defendant Parker William husbandman 588723 588723 Parker, William, of Westram, Kent, husbandman 2
5391756 2472715 2472715 defendant Hunter John yeoman 588723 588723 Hunter, John, of Westram, Kent, yeoman 2
5483859 2500116 2500116 defendant Lak Richard clerk 588723 588723 Lak, Richard, of Westram, Kent, clerk 0
5485607 2500599 2500599 defendant Hunter John yeoman 588723 588723 Hunter, John, of Westram, Kent, yeoman 4
5488347 2501408 2501408 defendant Bekyn John cooper 588723 588723 Bekyn, John, of Westram, Kent, cooper 4
5497689 2504253 2504253 defendant Clerk John chapman 588723 588723 Clerk, John, of Westram, Kent, chapman 2
5497693 2504254 2504254 defendant Clerke John chapman 588723 588723 Clerke, John, of Westram, Kent, chapman 2
5502092 2505575 2505575 defendant Hunter John husbandman 588723 588723 (Hunter, John, of Westram, Kent, husbandman 1
5502095 2505576 2505576 defendant Hunter John husbandman 588723 588723 (Hunter, John, of Westram, Kent, husbandman 1
5508575 2507547 2507547 defendant Clerk John chapman 588723 588723 Clerk, John, of Westram, Kent, chapman 4
5512542 2508781 2508781 defendant Clerk John gent 588723 588723 Clerk, John, of Westram, Kent, gent 2
5516386 2509958 2509958 defendant Hunter John yeoman 588723 588723 (Hunter, John, of Westram, Kent, yeoman 1
5551456 2520461 2520461 defendant Lambe Robert husbandman 588723 588723 Lambe, Robert, of Westram, Kent, husbandman 2
5567734 2525136 2525136 defendant Colman William tanner 588723 588723 Colman, William, of Westram, Kent, tanner 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);