names

18 rows where place_id = 627173

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3774587 1949778 1949778 defendant Hollok John yeoman 627173 627173 Hollok, John, of Ikelesham, yeoman 0
3811126 1961376 1961376 defendant Hollok John yeoman 627173 627173 Hollok, John, of Ikelesham, yeoman 0
4571443 2222653 2222653 defendant Bayforth Simon   627173 627173 Bayforth, Simon, of Ikelesham 0
4571444 2222653 2222653 defendant Wyltyng Thomas   627173 627173 Wyltyng, Thomas, of Ikelesham 1
4571445 2222653 2222653 defendant Wyltyng John   627173 627173 Wyltyng, John, of Ikelesham 2
4571447 2222654 2222654 defendant Hykke John   627173 627173 Hykke, John, of Ikelesham 0
4743870 2278735 2278735 defendant Bayford Simon smith 627173 627173 Bayford, Simon, of Ikelesham, smith 0
4743871 2278735 2278735 defendant Shepherd Robert husbandman 627173 627173 Shepherd, Robert, of Ikelesham, husbandman 1
4864991 2316028 2316028 defendant Ichyngton Thomas husbandman 627173 627173 Ichyngton, Thomas, of Ikelesham, husbandman 0
4929241 2335563 2335563 defendant Fynche William esq 627173 627173 Fynche, William, of Ikelesham, esq 0
4954687 2343355 2343355 defendant Fynch William gent 627173 627173 Fynch, William, of Ikelesham, esq, or of Nederfeld, gent 0
5092256 2384117 2384117 defendant Gardener Richard cordwainer 627173 627173 Gardener, Richard, of Ikelesham, cordwainer 0
5092258 2384118 2384118 defendant Gardener Richard cordewainer 627173 627173 Gardener, Richard, of Ikelesham, cordewainer 0
5258560 2432794 2432794 defendant Neulond John yeoman 627173 627173 Neulond, John, of Ikelesham, yeoman 0
5258561 2432794 2432794 defendant Grove William tanner 627173 627173 Grove, William, of Ikelesham, tanner 1
5284487 2440473 2440473 defendant Fynche John gent 627173 627173 Fynche, John, of Ikelesham, gent 0
5284489 2440474 2440474 defendant Fynche John gent 627173 627173 Fynche, John, of Ikelesham, gent 0
5304726 2446410 2446410 defendant Fynche John gent 627173 627173 Fynche, John, of Ikelesham, gent 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);