names

35 rows where place_id = 776070

✎ 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
4629952 2240288 2240288 defendant Rudham Thomas   776070 776070 Rudham, Thomas, of Bishop's Lenn, Norfolk 2
4629956 2240289 2240289 defendant Rudham Thomas   776070 776070 Rudham, Thomas, of Bishop's Lenn, Norfolk 1
4694505 2263774 2263774 defendant Sporyer Hugh yeoman 776070 776070 Sporyer, Hugh, of Bishop's Lenn, Norfolk, yeoman 0
4698167 2264915 2264915 defendant Tilneye John merchant 776070 776070 Tilneye, John, of Bishop's Lenn, Norfolk, merchant 0
4698980 2265156 2265156 defendant Erl Henry chapman 776070 776070 Erl, Henry, of Bishop's Lenn, Norfolk, chapman 2
4698982 2265157 2265157 defendant Lukwyke William glasier 776070 776070 Lukwyke, William, of Bishop's Lenn, Norfolk, glasier 0
4702900 2266303 2266303 defendant Clerk John chapman 776070 776070 Clerk, John, of Bishop's Lenn, Norfolk, chapman 1
4767622 2285859 2285859 defendant Benet alias Harpour Thomas   776070 776070 Benet alias Harpour, Thomas, of Bishop's Lenn, Norfolk, spice seller 0
4836239 2307313 2307313 defendant Fakes Richard husbandman 776070 776070 Fakes, Richard, of Bishop's Lenn, Norfolk, husbandman 4
4841397 2308845 2308845 defendant Langham William tiler 776070 776070 Langham, William, of Bishop's Lenn, Norfolk, tiler 0
4852996 2312356 2312356 defendant Coker John merchant 776070 776070 Coker, John, of Bishop's Lenn, Norfolk, merchant 0
4994134 2355119 2355119 defendant Massyngham Edmund gent 776070 776070 Massyngham, Edmund, of Bishop's Lenn, Norfolk, gent 0
4996057 2355675 2355675 defendant Frank Richard   776070 776070 Frank, Richard, of Bishop's Lenn, Norfolk, burgess & merchant 0
5003836 2358014 2358014 defendant Nandy Arnald vintner 776070 776070 Nandy, Arnald, of Bishop's Lenn, Norfolk, vintner 0
5004069 2358075 2358075 defendant Dysburgh William merchant 776070 776070 Dysburgh, William, of Bishop's Lenn, Norfolk, merchant 0
5149793 2401076 2401076 defendant Thorysby John merchant 776070 776070 Thorysby, John, of Bishop's Lenn, Norfolk, merchant 0
5151541 2401600 2401600 defendant Thorysby John merchant 776070 776070 Thorysby, John, of Bishop's Lenn, Norfolk, merchant 0
5155371 2402722 2402722 defendant Meke John chapman 776070 776070 Meke, John, of Bishop's Lenn, Norfolk, chapman 1
5168599 2406537 2406537 defendant Thorysby John merchant 776070 776070 Thorysby, John, of Bishop's Lenn, Norfolk, merchant 0
5172821 2407785 2407785 defendant Mollesworth William merchant 776070 776070 Mollesworth, William, of Bishop's Lenn, Norfolk, merchant 1
5175794 2408603 2408603 defendant Thorysby John merchant 776070 776070 Thorysby, John, of Bishop's Lenn, Norfolk, merchant 0
5188653 2412405 2412405 defendant Pygot Simon brewer 776070 776070 Pygot, Simon, of Bishop's Lenn, Norfolk, brewer 0
5188868 2412476 2412476 defendant Pygot Simon merchant & burgess 776070 776070 Pygot, Simon, of Bishop's Lenn, Norfolk, merchant & burgess 0
5198948 2415445 2415445 defendant Pygot Simon merchant 776070 776070 Pygot, Simon, of Bishop's Lenn, Norfolk, merchant 0
5198951 2415446 2415446 defendant Pygot Simon merchant 776070 776070 Pygot, Simon, of Bishop's Lenn, Norfolk, merchant 0
5201558 2416215 2416215 defendant Martyn John brewer 776070 776070 Martyn, John, of Bishop's Lenn, Norfolk, brewer 0
5210042 2418668 2418668 defendant Thoresby John merchant 776070 776070 Thoresby, John, of Bishop's Lenn, Norfolk, merchant 0
5210346 2418757 2418757 defendant Pygot Simon merchant 776070 776070 Pygot, Simon, of Bishop's Lenn, Norfolk, merchant 0
5298395 2444504 2444504 defendant Blaunche John merchant 776070 776070 Blaunche, John, of Bishop's Lenn, Norfolk, merchant 0
5299793 2444909 2444909 defendant (illegible) William butcher 776070 776070 _, William, of Bishop's Lenn, Norfolk, butcher 0
5301089 2445279 2445279 plaintiff Cosyn William (legal representative) 776070 776070 Cosyn, William, of Bishop's Lenn, Norfolk, executors of 0
5302667 2445775 2445775 defendant Blaunche John merchant 776070 776070 Blaunche, John, of Bishop's Lenn, Norfolk, merchant 0
5302669 2445776 2445776 defendant Blaunche John merchant 776070 776070 Blaunche, John, of Bishop's Lenn, Norfolk, merchant 0
5311375 2448435 2448435 defendant at Wodde Nicholas chapman 776070 776070 at Wodde, Nicholas, of Bishop's Lenn, Norfolk, chapman 0
5431336 2484324 2484324 defendant Thorysby Robert gent 776070 776070 Thorysby, Robert, of Bishop's Lenn, Norfolk, 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);