names

36 rows where place_id = 760939

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4474640 2192733 2192733 plaintiff Drewe Thomas   760939 760939 Drewe, Thomas, of Bishop's Lenne 0
4498931 2200305 2200305 plaintiff Godescofte John (legal representative) 760939 760939 Godescofte, John, of Bishop's Lenne, burgess & skinner, executors of 0
4532632 2210472 2210472 defendant Multon Adam shipman 760939 760939 Multon, Adam, of Bishop's Lenne, shipman 0
4544908 2214326 2214326 plaintiff Belleyetere Edmund   760939 760939 Belleyetere, Edmund, of Bishop's Lenne 0
4548107 2215349 2215349 plaintiff Chapman Nicholas   760939 760939 Chapman, Nicholas, of Bishop's Lenne 0
4555569 2217671 2217671 defendant Yorkes John   760939 760939 Yorkes, John, of Bishop's Lenne 0
4557915 2218406 2218406 plaintiff (not given) Thomas prior of Lenne 760939 760939 Lenne, Thomas, of Bishop's Lenne, brother & prior of the Carmelites priory 0
4560760 2219318 2219318 defendant Millere Thomas   760939 760939 Millere, Thomas, of Bishop's Lenne 0
4568771 2221816 2221816 defendant Drury William   760939 760939 Drury, William, of Bishop's Lenne 0
4568773 2221817 2221817 defendant Bocher Hamond   760939 760939 Bocher, Hamond, of Bishop's Lenne 0
4568774 2221817 2221817 defendant Thorne Richard   760939 760939 Thorne, Richard, of Bishop's Lenne 1
4568775 2221817 2221817 defendant Fraunceys Roger   760939 760939 Fraunceys, Roger, of Bishop's Lenne 2
4572158 2222844 2222844 defendant Welles John baker 760939 760939 Welles, John, of Bishop's Lenne, baker 0
4573882 2223349 2223349 defendant Takkere Maud   760939 760939 Takkere, Maud, of Bishop's Lenne, formerly wife of Robert 0
4573883 2223349 2223349 defendant Walpol Adam   760939 760939 Walpol, Adam, of Bishop's Lenne 1
4573885 2223349 2223349 defendant Constable John painter 760939 760939 Constable, John, of Bishop's Lenne, painter 3
4585426 2226864 2226864 plaintiff Halleyate William merchant 760939 760939 Halleyate, William, of Bishop's Lenne, merchant 0
4597580 2230490 2230490 defendant Thweyt Richard   760939 760939 Thweyt, Richard, of Bishop's Lenne, burgess 0
4598525 2230774 2230774 defendant Shipdam John   760939 760939 Shipdam, John, of Bishop's Lenne 2
4598529 2230775 2230775 defendant Shipdam John   760939 760939 Shipdam, John, of Bishop's Lenne 2
4605226 2232800 2232800 defendant Erl John   760939 760939 Erl, John, of Bishop's Lenne 2
4609258 2233999 2233999 defendant Sparham Thomas   760939 760939 Sparham, Thomas, of Bishop's Lenne 2
4612051 2234834 2234834 defendant Patryk John   760939 760939 Patryk, John, of Bishop's Lenne 0
4640929 2243446 2243446 plaintiff Erl William (legal representative) 760939 760939 Erl, William, of Bishop's Lenne, burgess, executors of 0
4640935 2243446 2243446 defendant Spicer John   760939 760939 Spicer, John, of Bishop's Lenne 1
4676541 2258280 2258280 plaintiff Godyng John   760939 760939 Godyng, John, of Bishop's Lenne, bell founder & brass worker, on his own account 0
4680476 2259508 2259508 plaintiff Bateley Geoffrey   760939 760939 Bateley, Geoffrey, of Bishop's Lenne 2
4728673 2274206 2274206 defendant Kyng Thomas weaver 760939 760939 Kyng, Thomas, of Bishop's Lenne, weaver 1
4728675 2274207 2274207 defendant Belle Thomas yeoman 760939 760939 Belle, Thomas, of Bishop's Lenne, yeoman 0
4735251 2276173 2276173 plaintiff Sparham Thomas (legal representative) 760939 760939 Sparham, Thomas, of Bishop's Lenne, executors of 0
4735252 2276173 2276173 plaintiff Brykesworth Alexander draper & burgess 760939 760939 (Brykesworth, Alexander, of Bishop's Lenne, draper & burgess 1
4735253 2276173 2276173 plaintiff Cowhite John   760939 760939 Cowhite, John, of Bishop's Lenne, burgess 2
4736666 2276596 2276596 defendant Belle Thomas yeoman 760939 760939 Belle, Thomas, of Bishop's Lenne, yeoman 0
4736669 2276597 2276597 defendant Belle Thomas yeoman 760939 760939 Belle, Thomas, of Bishop's Lenne, yeoman 0
4998840 2356537 2356537 defendant Monke Walter clerk & master of the house of St John Baptist 760939 760939 Monke, Walter, of Bishop's Lenne, clerk & master of the house of St John Baptist 1
5156052 2402929 2402929 defendant Scarlet Andrew   760939 760939 Scarlet, Andrew, of Bishop's Lenne, tile maker 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);