names

35 rows where place_id = 589181

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596825 1866642 1866642 defendant Cornok John cordwainer 589181 589181 Cornok, John, of Pedyngton, cordwainer 0
3638490 1906855 1906855 defendant Geffrun Elizabeth   589181 589181 Geffrun, Elizabeth, of Pedyngton, Nhants widow 2
3639150 1907063 1907063 defendant Croft William clerk 589181 589181 Croft, William, of Pedyngton, clerk 0
3639151 1907063 1907063 defendant Fytis John gent 589181 589181 Fytis, John, of Pedyngton, gent 1
3639152 1907063 1907063 defendant Fyssher Richard yeoman 589181 589181 Fyssher, Richard, of Pedyngton, yeoman 2
3639153 1907063 1907063 defendant Adersbery John yeoman 589181 589181 Adersbery, John, of Pedyngton, yeoman 3
3639154 1907063 1907063 defendant Trewman John yeoman 589181 589181 Trewman, John, of Pedyngton, yeoman 4
3639155 1907063 1907063 defendant Norman Robert yeoman 589181 589181 Norman, Robert, of Pedyngton, yeoman 5
3639156 1907063 1907063 defendant Norman William yeoman 589181 589181 Norman, William, of Pedyngton, yeoman 6
3639157 1907063 1907063 defendant Nelson Simon yeoman 589181 589181 Nelson, Simon, of Pedyngton, yeoman 7
3639158 1907063 1907063 defendant Bolton Robert yeoman 589181 589181 Bolton, Robert, of Pedyngton, yeoman 8
3664050 1914705 1914705 defendant Hayward John   589181 589181 Hayward, John, of Pedyngton 2
3685526 1921625 1921625 defendant Wake Richard gent 589181 589181 Wake, Richard, of Pedyngton, gent 0
3700564 1926419 1926419 defendant Wake Richard gent 589181 589181 Wake, Richard, of Pedyngton, gent 0
3714154 1930726 1930726 defendant Wake Richard gent 589181 589181 Wake, Richard, of Pedyngton, gent 0
3837776 1969730 1969730 defendant Holder John husbandman 589181 589181 Holder, John, of Pedyngton, husbandman 1
4135220 2072915 2072915 defendant Packer Richard yeoman 589181 589181 Packer, Richard, of Pedyngton, or of Barkley, Glos, yeoman 1
4456701 2187120 2187120 defendant Baret John   589181 589181 Baret, John, of Pedyngton 0
4816964 2301408 2301408 defendant Merflete Thoams laborer 589181 589181 Merflete, Thoams, of Pedyngton, laborer 2
4822975 2303269 2303269 defendant Borgeys Thomas yeoman 589181 589181 Borgeys, Thomas, of Pedyngton, yeoman 0
4833035 2306350 2306350 defendant Balgy Paul yeoman 589181 589181 Balgy, Paul, of Pedyngton, yeoman 0
4958795 2344601 2344601 defendant Balgye Paul yeoman 589181 589181 Balgye, Paul, of Pedyngton, yeoman 1
4997192 2356013 2356013 defendant Balgay Paul   589181 589181 Balgay, Paul, of Pedyngton 2
5072164 2378164 2378164 defendant Mannyng Thomas yeoman 589181 589181 Mannyng, Thomas, of Pedyngton, yeoman 0
5080300 2380598 2380598 defendant Ecton John yeoman 589181 589181 Ecton, John, of Pedyngton, yeoman 0
5110771 2389549 2389549 defendant Morekocke John, junior husbandman 589181 589181 Morekocke, John, junior, of Pedyngton, husbandman 0
5138992 2397897 2397897 defendant Mann John husbandman 589181 589181 Mann, John, of Pedyngton, husbandman 3
5159867 2403982 2403982 defendant Mannyng Thomas (legal representative) 589181 589181 Mannyng, Thomas, of Pedyngton, executors of 2
5159869 2403982 2403982 defendant Mannyng John husbandman 589181 589181 Mannyng, John, of Pedyngton, husbandman 4
5174856 2408340 2408340 defendant Mannyng John (legal representative) 589181 589181 Mannyng, John, of Pedyngton, husbandman, also executor of Thomas 3
5238859 2426954 2426954 defendant Balgy Paul yeoman 589181 589181 Balgy, Paul, of Pedyngton, yeoman 2
5551757 2520558 2520558 defendant Archer Richard husbandman 589181 589181 Archer, Richard, of Pedyngton, husbandman 0
5551758 2520558 2520558 defendant Archer William husbandman 589181 589181 Archer, William, of Pedyngton, husbandman 1
5570447 2525927 2525927 defendant Archere Thomas husbandman 589181 589181 Archere, Thomas, of Pedyngton, husbandman 0
5584731 2530299 2530299 defendant Archer Richard husbandman 589181 589181 Archer, Richard, of Pedyngton, husbandman 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);