names

28 rows where place_id = 610861

✎ 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
3685624 1921658 1921658 plaintiff Baskerfeld Philip esq 610861 610861 Baskerfeld, Philip, of Shirborne, Dorset, esq 0
3685626 1921659 1921659 plaintiff Baskerfeld Philip esq 610861 610861 Baskerfeld, Philip, of Shirborne, Dorset, esq 0
3685628 1921660 1921660 plaintiff Baskerfeld Philip esq 610861 610861 Baskerfeld, Philip, of Shirborne, Dorset, esq 0
3936757 2002621 2002621 plaintiff Meyr William gent 610861 610861 Meyr, William, of Shirborne, Dorset, gent 0
3951332 2007532 2007532 defendant Ingelbert Nicholas yeoman 610861 610861 Ingelbert, Nicholas, of Shirborne, Dorset, yeoman 0
4056475 2044700 2044700 defendant Newman Richard husbandman 610861 610861 Newman, Richard, of Shirborne, Dorset, husbandman 0
4116234 2066095 2066095 defendant Rawlyns Henry innholder 610861 610861 Rawlyns, Henry, of Shirborne, Dorset, innholder 2
4306404 2132382 2132382 defendant Knowell Edward gent 610861 610861 Knowell, Edward, of Shirborne, Dorset, gent 0
4372139 2155103 2155103 defendant Kynge John   610861 610861 Kynge, John, of Shirborne, Dorset, woollen draper 0
4739431 2277417 2277417 defendant Langrigee John chapman 610861 610861 Langrigee, John, of Shirborne, Dorset, chapman 0
4769239 2286358 2286358 defendant Cole Robert   610861 610861 Cole, Robert, of Shirborne, Dorset, bow maker 0
4781816 2290329 2290329 defendant Fysshere Robert fisher 610861 610861 Fysshere, Robert, of Shirborne, Dorset, fisher 1
4841747 2308955 2308955 defendant Salter John, sen weaver 610861 610861 (Salter, John, sen, of Shirborne, Dorset, weaver 1
4979980 2350967 2350967 defendant Smyth Thomas smith 610861 610861 Smyth, Thomas, of Shirborne, Dorset, smith 1
5096383 2385375 2385375 defendant Marchall Richard gent 610861 610861 Marchall, Richard, of Shirborne, Dorset, gent 0
5120814 2392518 2392518 defendant Rokes John esq 610861 610861 Rokes, John, of Shirborne, Dorset, esq 0
5237454 2426536 2426536 defendant Rede Robert chapman 610861 610861 Rede, Robert, of Shirborne, Dorset, chapman 3
5267349 2435553 2435553 defendant Fyssher alias Mygall Thomas yeoman 610861 610861 Fyssher alias Mygall, Thomas, of Shirborne, Dorset, yeoman 0
5290979 2442363 2442363 defendant Kynge John draper or cordwainer 610861 610861 Kynge, John, of Shirborne, Dorset, draper or cordwainer 0
5313135 2448959 2448959 defendant Parre John clothier 610861 610861 Parre, John, of Shirborne, Dorset, clothier 0
5313200 2448982 2448982 defendant Porte Edward yeoman 610861 610861 Porte, Edward, of Shirborne, Dorset, yeoman 1
5331719 2454574 2454574 defendant White Simon, junior yeoman 610861 610861 White, Simon, junior, of Shirborne, Dorset, yeoman 1
5334055 2455251 2455251 defendant Hore John yeoman 610861 610861 Hore, John, of Shirborne, Dorset, yeoman 6
5490243 2501967 2501967 defendant Baukary or Babkary Richard (legal representative) 610861 610861 Baukary or Babkary, Richard, of Shirborne, Dorset, brasier, executrix of 2
5522336 2511806 2511806 defendant Couke or Conke Philip clothier 610861 610861 Couke or Conke, Philip, of Shirborne, Dorset, clothier 0
5559365 2522706 2522706 defendant Brone John yeoman 610861 610861 Brone, John, of Shirborne, Dorset, yeoman 0
5568118 2525222 2525222 defendant Lawes William innholder 610861 610861 Lawes, William, of Shirborne, Dorset, innholder 0
5573838 2526915 2526915 defendant Brightrigge Robert tanner 610861 610861 Brightrigge, Robert, of Shirborne, Dorset, 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);