names

64 rows where place_id = 600289

✎ 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
3640468 1907451 1907451 plaintiff Amfles Robert   600289 600289 Amfles, Robert, of Lenne 0
3692273 1923753 1923753 defendant Mason Robert bowyer 600289 600289 Mason, Robert, of Lenne, bowyer 0
4420591 2171344 2171344 defendant Jexham John de   600289 600289 Jexham, John de, of Lenne, burgess, son of Richard 0
4432774 2175006 2175006 defendant Southsted John   600289 600289 Southsted, John, of Lenne 0
4435007 2175711 2175711 defendant Fot Stephen skinner 600289 600289 Fot, Stephen, of Lenne, skinner 0
4435010 2175712 2175712 defendant Fot Stephen skinner 600289 600289 Fot, Stephen, of Lenne, skinner 0
4435012 2175713 2175713 defendant Fot Stephen skinner 600289 600289 Fot, Stephen, of Lenne, skinner 0
4435015 2175714 2175714 defendant Fot Stephen skinner 600289 600289 Fot, Stephen, of Lenne, skinner 0
4437983 2181197 2181197 plaintiff algerkirke Robert   600289 600289 algerkirke, Robert, of Lenne 0
4442777 2182697 2182697 defendant Pynnere Adam   600289 600289 Pynnere, Adam, of Lenne 2
4449079 2184655 2184655 defendant Walton Richard de sherman 600289 600289 Walton, Richard de, of Lenne, sherman 0
4456879 2187162 2187162 plaintiff Owhyte John   600289 600289 Owhyte, John, of Lenne, burgess 0
4464777 2189649 2189649 defendant Cadenay John de   600289 600289 Cadenay, John de, of Lenne 0
4464779 2189649 2189649 defendant Muston John de   600289 600289 Muston, John de, of Lenne 2
4474478 2192678 2192678 defendant Markaunt John shipman 600289 600289 Markaunt, John, of Lenne, shipman 0
4475902 2193137 2193137 defendant Bitteryng John   600289 600289 Bitteryng, John, of Lenne 0
4478484 2193944 2193944 plaintiff Hert John   600289 600289 Hert, John, of Lenne, on his own account 0
4488243 2197040 2197040 defendant Roweham William   600289 600289 Roweham, William, of Lenne 0
4492315 2198273 2198273 plaintiff Wyntworth John   600289 600289 Wyntworth, John, of Lenne 0
4512087 2204223 2204223 plaintiff Bolt John   600289 600289 Bolt, John, of Lenne 0
4512090 2204224 2204224 plaintiff Bolt John   600289 600289 Bolt, John, of Lenne 0
4519806 2206550 2206550 defendant Guatton Robert   600289 600289 Guatton, Robert, of Lenne 0
4521284 2207000 2207000 defendant Nenour Thomas   600289 600289 Nenour, Thomas, of Lenne 4
4522770 2207459 2207459 plaintiff H_seye Adam   600289 600289 H_seye, Adam, of Lenne 0
4538057 2212183 2212183 defendant Stevenson John boatman 600289 600289 Stevenson, John, of Lenne, boatman 0
4544988 2214353 2214353 defendant Maynard John   600289 600289 Maynard, John, of Lenne 0
4544991 2214354 2214354 defendant Maynard John   600289 600289 Maynard, John, of Lenne 0
4544994 2214355 2214355 defendant Maynard John   600289 600289 Maynard, John, of Lenne 0
4546510 2214839 2214839 plaintiff Brigge Thomas   600289 600289 Brigge, Thomas, of Lenne 0
4560822 2219342 2219342 defendant Elys William   600289 600289 Elys, William, of Lenne 2
4566422 2221069 2221069 plaintiff Stevenesson John   600289 600289 Stevenesson, John, of Lenne 0
4566423 2221069 2221069 defendant Sylesden William   600289 600289 Sylesden, William, of Lenne, brass worker 0
4566424 2221069 2221069 defendant Paxman John merchant 600289 600289 Paxman, John, of Lenne, merchant 1
4570542 2222360 2222360 plaintiff Wrytte Thomas   600289 600289 Wrytte, Thomas, of Lenne 0
4571711 2222731 2222731 defendant Brendon John   600289 600289 Brendon, John, of Lenne 0
4573886 2223349 2223349 defendant Walsyngham John   600289 600289 Walsyngham, John, of Lenne 4
4576536 2224173 2224173 plaintiff Brygge Thomas   600289 600289 Brygge, Thomas, of Lenne, burgess 0
4578741 2224839 2224839 defendant Seffe Robert   600289 600289 Seffe, Robert, of Lenne 1
4581632 2225704 2225704 defendant Chynche Robert   600289 600289 Chynche, Robert, of Lenne 1
4585428 2226865 2226865 plaintiff Halleyate William   600289 600289 Halleyate, William, of Lenne 0
4585431 2226866 2226866 plaintiff Halleyate William   600289 600289 Halleyate, William, of Lenne 0
4597517 2230469 2230469 defendant Tounesson John   600289 600289 Tounesson, John, of Lenne 1
4597579 2230490 2230490 plaintiff Silesden Wililam   600289 600289 Silesden, Wililam, of Lenne, burgess 0
4598599 2230802 2230802 plaintiff Spyser John   600289 600289 Spyser, John, of Lenne 0
4607741 2233532 2233532 plaintiff Bisshop John   600289 600289 Bisshop, John, of Lenne 0
4608173 2233667 2233667 defendant Hadley Robert   600289 600289 Hadley, Robert, of Lenne 0
4613323 2235198 2235198 defendant Patermak John   600289 600289 Patermak, John, of Lenne 0
4614945 2235685 2235685 defendant Spicer John   600289 600289 Spicer, John, of Lenne 0
4618448 2236780 2236780 defendant Curteys John   600289 600289 Curteys, John, of Lenne, iron worker 0
4629039 2240008 2240008 defendant Daudeney Robert merchant 600289 600289 Daudeney, Robert, of Lenne, merchant 0
4630693 2240501 2240501 defendant Jankyn John   600289 600289 Jankyn, John, of Lenne 0
4630704 2240501 2240501 defendant Creyk John   600289 600289 Creyk, John, of Lenne 11
4639218 2242990 2242990 defendant Syffe alias Blakeneye Robert mercer 600289 600289 Syffe alias Blakeneye, Robert, of Lenne, mercer 0
4647644 2245365 2245365 defendant Multon John   600289 600289 Multon, John, of Lenne 1
4652871 2246833 2246833 defendant Dyet John yeoman 600289 600289 Dyet, John, of Lenne, yeoman 2
4657518 2248243 2248243 defendant Cleffe Simon dyer 600289 600289 Cleffe, Simon, of Lenne, dyer 2
4659476 2248824 2248824 plaintiff de Creyk John   600289 600289 de Creyk, John, of Lenne 0
4666253 2250917 2250917 defendant Herte John yeoman 600289 600289 Herte, John, of Lenne, yeoman 0
4701530 2265873 2265873 defendant Bonet Edmund merchant 600289 600289 Bonet, Edmund, of Lenne, merchant 0
4711488 2268922 2268922 defendant Bonet Edmund merchant 600289 600289 Bonet, Edmund, of Lenne, merchant 0
4712745 2269300 2269300 plaintiff Sparham Thomas (legal representative) 600289 600289 Sparham, Thomas, of Lenne, executors of 0
4761294 2283879 2283879 defendant Phelipp Thomas chapman 600289 600289 Phelipp, Thomas, of Lenne, chapman 0
4826034 2304180 2304180 plaintiff Walton John   600289 600289 Walton, John, of Lenne 0
5623618 2551324 2551324 plaintiff Kellowe John   600289 600289 Kellowe, John, of Lenne 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);