names

46 rows where place_id = 587020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590257 1864598 1864598 defendant Knyff Thomas gent 587020 587020 Knyff, Thomas, of Iseldon, gent 0
3637998 1906701 1906701 defendant Bemrose John smith 587020 587020 (Bemrose, John, of Iseldon, smith 3
3638003 1906702 1906702 defendant Benrose John smith 587020 587020 (Benrose, John, of Iseldon, smith 3
3682120 1920519 1920519 defendant Percyvall John laborer 587020 587020 Percyvall, John, of Iseldon, laborer 0
3682121 1920519 1920519 defendant Gardener John laborer 587020 587020 Gardener, John, of Iseldon, laborer 1
3682122 1920519 1920519 defendant Goderd Thomas osteler 587020 587020 Goderd, Thomas, of Iseldon, osteler 2
3682123 1920519 1920519 defendant Acorne John   587020 587020 Acorne, John, of Iseldon, cook 3
3689053 1922738 1922738 defendant Grey John laborer 587020 587020 Grey, John, of Iseldon, laborer 0
3752689 1942769 1942769 defendant Middelton Robert yeoman 587020 587020 Middelton, Robert, of Iseldon, yeoman 0
3752691 1942770 1942770 defendant Middelton Robert yeoman 587020 587020 Middelton, Robert, of Iseldon, yeoman 0
3769492 1948120 1948120 defendant Middelton Robert yeoman 587020 587020 Middelton, Robert, of Iseldon, yeoman 0
3769888 1948237 1948237 defendant Middelton Robert yeoman 587020 587020 Middelton, Robert, of Iseldon, yeoman 0
3837855 1969754 1969754 defendant Johnson William pewterer 587020 587020 Johnson, William, of Iseldon, pewterer 1
3837856 1969754 1969754 defendant Rowland Thomas smith 587020 587020 Rowland, Thomas, of Iseldon, smith 2
4433841 2175348 2175348 plaintiff Hastinges Humphrey de (legal representative) 587020 587020 Hastinges, Humphrey de, of Iseldon, prebendary of the prebend of Islington, in the church of St Paul's, London, executors of 0
4433845 2175348 2175348 defendant Holewey Stephen   587020 587020 Holewey, Stephen, of Iseldon 0
4528758 2209279 2209279 plaintiff Medmenham John chaplain 587020 587020 Medmenham, John, of Iseldon, chaplain 0
4528759 2209279 2209279 plaintiff Sewale John   587020 587020 Sewale, John, of Iseldon 1
4571474 2222659 2222659 defendant Crullyng Thomas   587020 587020 Crullyng, Thomas, of Iseldon 0
4571475 2222659 2222659 defendant Gentylman John   587020 587020 Gentylman, John, of Iseldon 1
4597277 2230393 2230393 plaintiff Sewale John   587020 587020 Sewale, John, of Iseldon 0
4657968 2248378 2248378 defendant Dauber Richard laborer 587020 587020 Dauber, Richard, of Iseldon, laborer 0
5038220 2368066 2368066 plaintiff Yon William   587020 587020 Yon, William, of Iseldon 1
5107920 2388755 2388755 defendant Brokehirst alias Geffrey William husbandman 587020 587020 Brokehirst alias Geffrey, William, of Iseldon, husbandman 0
5132053 2395866 2395866 defendant Thorp Geoffrey draper 587020 587020 Thorp, Geoffrey, of Iseldon, draper 0
5151646 2401637 2401637 defendant Thorp Geoffrey drover 587020 587020 Thorp, Geoffrey, of iseldon, drover 0
5154471 2402457 2402457 defendant Halom William esq 587020 587020 Halom, William, of Iseldon, esq 0
5206727 2417704 2417704 defendant Marchall William skinner 587020 587020 Marchall, William, of Iseldon, skinner 2
5241433 2427691 2427691 defendant Halom William esq 587020 587020 Halom, William, of Iseldon, esq 0
5241435 2427692 2427692 defendant Halom William esq 587020 587020 Halom, William, of Iseldon, esq 0
5250522 2430270 2430270 defendant Gerveys Richard yeoman 587020 587020 Gerveys, Richard, of Iseldon, yeoman 0
5284087 2440366 2440366 defendant Mynte Henry yeoman 587020 587020 Mynte, Henry, of Iseldon, yeoman 2
5288386 2441624 2441624 plaintiff Wodelonde John yeoman 587020 587020 Wodelonde, John, of Iseldon, yeoman 1
5288665 2441707 2441707 plaintiff Wodelonde John yeoman 587020 587020 Wodelonde, John, of Iseldon, yeoman 1
5292429 2442782 2442782 defendant Gerveys Richard yeoman 587020 587020 Gerveys, Richard, of Iseldon, yeoman 0
5329031 2453763 2453763 plaintiff Adam Richard (legal representative) 587020 587020 Adam, Richard, of Iseldon, grasier, executors of 0
5329039 2453764 2453764 plaintiff Adam Richard (legal representative) 587020 587020 Adam, Richard, of Iseldon, grazier, executors of 0
5329879 2454005 2454005 defendant Rankyn Joan widow 587020 587020 Rankyn, Joan, of Iseldon, widow 2
5352534 2460885 2460885 plaintiff Ferytour William smith 587020 587020 Ferytour, William, of Iseldon, smith 0
5425189 2482501 2482501 defendant Cordell John husbandman 587020 587020 Cordell, John, of iseldon, husbandman 2
5425190 2482501 2482501 defendant Lyman John husbandman 587020 587020 Lyman, John, of Iseldon, husbandman 3
5539108 2516715 2516715 defendant Golde John yeoman 587020 587020 Golde, John, of Iseldon, yeoman 0
5586404 2530788 2530788 defendant Ingland John yeoman 587020 587020 Ingland, John, of Iseldon, yeoman 3
5586412 2530789 2530789 defendant Ingland John yeoman 587020 587020 Ingland, John, of Iseldon, yeoman 3
5607822 2537354 2537354 plaintiff Wrey Robert   587020 587020 Wrey, Robert, of Iseldon 0
5607824 2537354 2537354 defendant Whitwey Robert gent 587020 587020 Whitwey, Robert, of Iseldon, gent 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);