names

51 rows where place_id = 667201

✎ 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
3984190 2019111 2019111 defendant Backe Richard singleman 667201 667201 Backe, Richard, of Bungeye, singleman 1
4423672 2172247 2172247 plaintiff Haneworth Nicholas de   667201 667201 Haneworth, Nicholas de, of Bungeye 0
4423674 2172247 2172247 defendant Cotere John   667201 667201 Cotere, John, of Bungeye 0
4440771 2182030 2182030 defendant Taverner Thomas   667201 667201 Taverner, Thomas, of Bungeye 0
4441413 2182255 2182255 defendant Carfot John   667201 667201 Carfot, John, of Bungeye 2
4447167 2184020 2184020 defendant Rose William   667201 667201 Rose, William, of Bungeye, servant of Robert 6
4447915 2184277 2184277 defendant Hullokes John   667201 667201 Hullokes, John, of Bungeye 0
4487509 2196810 2196810 plaintiff Smyth Richard weaver 667201 667201 Smyth, Richard, of Bungeye, weaver 0
4487510 2196810 2196810 defendant Smyth Richard draper 667201 667201 Smyth, Richard, of Bungeye, draper 0
4499750 2200554 2200554 defendant Lystere John   667201 667201 Lystere, John, of Bungeye 2
4507618 2202843 2202843 defendant Budwe Robert   667201 667201 Budwe, Robert, of Bungeye 0
4531192 2210030 2210030 plaintiff Passhelowe John   667201 667201 Passhelowe, John, of Bungeye 0
4572237 2222855 2222855 defendant Rydel Clement   667201 667201 Rydel, Clement, of bungeye 0
4593042 2229132 2229132 plaintiff Owedyn John draper 667201 667201 Owedyn, John, of Bungeye, draper 0
4595510 2229853 2229853 plaintiff Reve Thomas   667201 667201 Reve, Thomas, of Bungeye 0
4595511 2229853 2229853 defendant Pashelewe John   667201 667201 Pashelewe, John, of Bungeye 0
4595514 2229855 2229855 plaintiff Reve William   667201 667201 Reve, William, of Bungeye 0
4595517 2229856 2229856 plaintiff Reve William   667201 667201 Reve, William, of Bungeye 0
4599374 2231021 2231021 defendant Dunston John   667201 667201 Dunston, John, of Bungeye 0
4606077 2233015 2233015 defendant Redell Clement   667201 667201 Redell, Clement, of Bungeye 0
4606079 2233015 2233015 defendant Smyth Richard   667201 667201 Smyth, Richard, of Bungeye 2
4616593 2236190 2236190 defendant Rabbat john   667201 667201 Rabbat, john, of Bungeye 2
4618978 2236929 2236929 plaintiff (not given) John vicar of Herde 667201 667201 Herde, John, of Bungeye, vicar of Holy Trinity church 0
4639882 2243167 2243167 defendant Marche John   667201 667201 Marche, John, of Bungeye 0
4646735 2245111 2245111 plaintiff Reve William   667201 667201 Reve, William, of Bungeye 0
4652024 2246566 2246566 defendant Noloth Nicholas laborer 667201 667201 Noloth, Nicholas, of Bungeye, laborer 0
4661561 2249448 2249448 plaintiff Elyot Robert   667201 667201 Elyot, Robert, of Bungeye 0
4674060 2257498 2257498 plaintiff Dod William (legal representative) 667201 667201 Dod, William, of Bungeye, executors of 0
4699155 2265200 2265200 plaintiff Dod William (legal representative) 667201 667201 Dod, William, of Bungeye, executors of 0
4699853 2265399 2265399 defendant Pekke John   667201 667201 Pekke, John, of Bungeye, bed weaver 2
4716633 2270522 2270522 plaintiff Wode Thomas   667201 667201 Wode, Thomas, of Bungeye 0
4716638 2270523 2270523 plaintiff Wode Thomas   667201 667201 Wode, Thomas, of bungeye 0
4719231 2271363 2271363 defendant Paschelewe Robert mercer 667201 667201 Paschelewe, Robert, of Bungeye, mercer 1
4722295 2272297 2272297 defendant Neweman Thomas tanner 667201 667201 Neweman, Thomas, of Bungeye, tanner 0
4722296 2272297 2272297 defendant Smyth Richard draper 667201 667201 Smyth, Richard, of Bungeye, draper 1
4724163 2272850 2272850 defendant Pekke John   667201 667201 together with Pekke, John, of Bungeye, bed weaver 1
4755534 2282110 2282110 defendant Deye William butcher 667201 667201 Deye, William, of Bungeye, butcher 0
4755535 2282110 2282110 defendant Culpoy Adam yeoman 667201 667201 Culpoy, Adam, of Bungeye, yeoman 1
4759869 2283421 2283421 defendant Deye William yeoman 667201 667201 Deye, William, of Bungeye, yeoman 0
4759870 2283421 2283421 defendant Culpy Adam yeoman 667201 667201 Culpy, Adam, of Bungeye, yeoman 1
4759872 2283422 2283422 defendant Oulpy Robert husbandman 667201 667201 Oulpy, Robert, of Bungeye, husbandman 0
4771789 2287153 2287153 defendant Smyth Richard draper 667201 667201 Smyth, Richard, of Bungeye, draper 0
4786546 2291842 2291842 defendant Deye William butcher 667201 667201 Deye, William, of Bungeye, butcher 0
4884102 2321938 2321938 defendant Smyth Richard yeoman 667201 667201 Smyth, Richard, of Bungeye, yeoman 3
4975876 2349746 2349746 defendant Aleyn John chapman 667201 667201 Aleyn, John, of Bungeye, chapman 0
5002520 2357649 2357649 defendant Aleyn John chapman 667201 667201 Aleyn, John, of Bungeye, chapman 0
5095593 2385135 2385135 defendant Culpy Adam yeoman 667201 667201 Culpy, Adam, of Bungeye, yeoman 0
5095594 2385135 2385135 defendant Deye William butcher 667201 667201 Deye, William, of Bungeye, butcher 1
5482291 2499646 2499646 defendant Jonson Geoffrey butcher 667201 667201 Jonson, Geoffrey, of Bungeye, butcher 1
5630868 2553662 2553662 defendant atte Gapp Joan singlewoman 667201 667201 atte Gapp, Joan, of Bungeye, singlewoman 1
5633033 2554333 2554333 defendant Aleyn William mercer 667201 667201 Aleyn, William, of Bungeye, mercer 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);