names

67 rows where place_id = 641884

✎ 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
3864460 1978313 1978313 defendant Gunby or Gimby John laborer 641884 641884 Gunby or Gimby, John, of Wymundham, laborer 0
3894528 1988379 1988379 defendant Banyard John gent 641884 641884 Banyard, John, of Wymundham, gent 0
3970584 2014303 2014303 defendant Browne Edmund butcher 641884 641884 Browne, Edmund, of Wymundham, butcher 2
4009099 2028022 2028022 plaintiff Mychell Thomas cordwainer 641884 641884 Mychell, Thomas, of Wymundham, cordwainer 0
4429417 2174006 2174006 defendant Toly John   641884 641884 Toly, John, of Wymundham 0
4437651 2176532 2176532 defendant Langham William   641884 641884 Langham, William, of Wymundham 0
4452843 2185902 2185902 defendant Lethale John   641884 641884 Lethale, John, of Wymundham 0
4458175 2187593 2187593 plaintiff Purley William   641884 641884 Purley, William, of Wymundham 0
4472991 2192228 2192228 plaintiff Coupere Thomas   641884 641884 Coupere, Thomas, of Wymundham 0
4473232 2192290 2192290 defendant Coleman William   641884 641884 Coleman, William, of Wymundham 0
4488528 2197134 2197134 plaintiff Stukele John (legal representative) 641884 641884 Stukele, John, of Wymundham, chaplain, executors of 0
4488531 2197134 2197134 defendant Grout William   641884 641884 Grout, William, of Wymundham 0
4488532 2197134 2197134 defendant Savage Thomas   641884 641884 Savage, Thomas, of Wymundham 1
4489549 2197452 2197452 defendant Toly Robert   641884 641884 Toly, Robert, of Wymundham 0
4489550 2197452 2197452 defendant toly John   641884 641884 toly, John, of Wymundham, son of Robert 1
4491305 2197969 2197969 defendant Crispyng Roger   641884 641884 Crispyng, Roger, of Wymundham 1
4503405 2201636 2201636 defendant Fyke Thomas   641884 641884 Fyke, Thomas, of Wymundham 0
4522334 2207333 2207333 defendant Haunbrasse John   641884 641884 Haunbrasse, John, of Wymundham 0
4542939 2213685 2213685 plaintiff Annore William   641884 641884 Annore, William, of Wymundham 0
4553060 2216900 2216900 defendant Boteler Thomas   641884 641884 Boteler, Thomas, of Wymundham 0
4553194 2216932 2216932 defendant Bailly John   641884 641884 Bailly, John, of Wymundham 5
4553195 2216932 2216932 defendant Huntyngdon John   641884 641884 Huntyngdon, John, of Wymundham 6
4563763 2220236 2220236 plaintiff Dragyll Thomas   641884 641884 Dragyll, Thomas, of Wymundham 1
4580113 2225270 2225270 defendant Cook William   641884 641884 Cook, William, of Wymundham 0
4604043 2232432 2232432 defendant Monument Richard   641884 641884 Monument, Richard, of Wymundham 3
4608517 2233772 2233772 plaintiff Boverych Richard   641884 641884 Boverych, Richard, of Wymundham 0
4610503 2234357 2234357 plaintiff Cartere Robert   641884 641884 Cartere, Robert, of Wymundham 0
4623226 2238237 2238237 defendant Andrew John   641884 641884 Andrew, John, of Wymundham 1
4633549 2241347 2241347 defendant Reedhord John   641884 641884 Reedhord, John, of Wymundham 0
4647270 2245256 2245256 plaintiff Bate Thomas   641884 641884 Bate, Thomas, of Wymundham 3
4647275 2245257 2245257 plaintiff Bate Thomas   641884 641884 Bate, Thomas, of Wymundham 3
4672417 2257027 2257027 plaintiff Cok Isabel   641884 641884 (Cok, Isabel, of Wymundham, formerly wife of Testator 1
4672445 2257034 2257034 defendant Chapman Richard chapman 641884 641884 Chapman, Richard, of Wymundham, chapman 0
4672454 2257037 2257037 plaintiff Cok William (legal representative) 641884 641884 Cok, William, of Wymundham, executors of 0
4672455 2257037 2257037 plaintiff Cok Isabel   641884 641884 (Cok, Isabel, of Wymundham, formerly wife of Testator 1
4702999 2266320 2266320 plaintiff Turnepas John   641884 641884 Turnepas, John, of Wymundham 1
4754726 2281862 2281862 defendant Waggestaf John yeoman 641884 641884 Waggestaf, John, of Wymundham, yeoman 0
4767797 2285901 2285901 defendant Grym Thomas yeoman 641884 641884 Grym, Thomas, of Wymundham, yeoman 0
4807311 2298482 2298482 defendant Deye William husbandman 641884 641884 Deye, William, of Wymundham, husbandman 1
4808551 2298843 2298843 plaintiff Cryspyn Roger   641884 641884 Cryspyn, Roger, of Wymundham 0
4811915 2299842 2299842 plaintiff Purley William   641884 641884 Purley, William, of Wymundham 3
4830182 2305483 2305483 defendant Deye William husbandman 641884 641884 Deye, William, of Wymundham, husbandman 0
4832672 2306239 2306239 defendant Kyng Richard yeoman 641884 641884 Kyng, Richard, of Wymundham, yeoman 0
4843588 2309515 2309515 plaintiff Massyngham Stephen   641884 641884 Massyngham, Stephen, of Wymundham 0
4861548 2314980 2314980 defendant Dyngdale Richard clerk 641884 641884 Dyngdale, Richard, of Wymundham, clerk 1
4869889 2317553 2317553 defendant Dey William yeoman 641884 641884 Dey, William, of Wymundham, yeoman 0
4872468 2318348 2318348 defendant Staunton William husbandman 641884 641884 Staunton, William, of Wymundham, husbandman 4
4931129 2336121 2336121 defendant Chirche alias Mason John   641884 641884 Chirche alias Mason, John, of Wymundham, mason 0
4956748 2343974 2343974 plaintiff Vyrley John her brother 641884 641884 Vyrley, John, of Wymundham, her brother 1
4956749 2343974 2343974 defendant Chyrche alias Mason John   641884 641884 Chyrche alias Mason, John, of Wymundham, mason 0
4971238 2348336 2348336 defendant Goldbetere James husbandman 641884 641884 Goldbetere, James, of Wymundham, husbandman 1
5021674 2363236 2363236 defendant Colun William yeoman 641884 641884 Colun, William, of Wymundham, yeoman 1
5070459 2377656 2377656 defendant Baker John husbandman 641884 641884 Baker, John, of Wymundham, husbandman 0
5110531 2389480 2389480 plaintiff Walter Richard   641884 641884 Walter, Richard, of Wymundham 1
5110532 2389480 2389480 defendant Buckle alias Pye John   641884 641884 Buckle alias Pye, John, of Wymundham, paten maker 0
5110533 2389480 2389480 defendant Turnour John turner 641884 641884 Turnour, John, of Wymundham, turner 1
5110534 2389480 2389480 defendant Walter William butcher 641884 641884 Walter, William, of Wymundham, butcher 2
5118184 2391755 2391755 plaintiff Reede Nicholas   641884 641884 Reede, Nicholas, of Wymundham 0
5127032 2394381 2394381 defendant Neweland William   641884 641884 Neweland, William, of Wymundham, wax chandler 0
5145676 2399878 2399878 defendant Newlond William   641884 641884 Newlond, William, of Wymundham, tallow chandler 0
5158366 2403569 2403569 defendant Bukley John yeoman 641884 641884 Bukley, John, of Wymundham, yeoman 3
5158766 2403686 2403686 plaintiff Rede Nicholas   641884 641884 Rede, Nicholas, of Wymundham 0
5287506 2441369 2441369 defendant Walter Richard butcher 641884 641884 Walter, Richard, of Wymundham, butcher 0
5344383 2458424 2458424 plaintiff Wethyrby John   641884 641884 Wethyrby, John, of Wymundham 1
5615763 2548725 2548725 plaintiff Gybun John   641884 641884 Gybun, John, of Wymundham 0
5616628 2549001 2549001 defendant Gyboun John   641884 641884 Gyboun, John, of Wymundham 0
5621456 2550609 2550609 plaintiff Stuecle John de   641884 641884 Stuecle, John de, of Wymundham, vicar 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);