names

186 rows where place_id = 590201

✎ 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
3600212 1867713 1867713 defendant Bedyngham Thomas yeoman 590201 590201 Bedyngham, Thomas, of Berkyng, Essex, yeoman 3
3600481 1867797 1867797 defendant Bedyngham Thomas yeoman 590201 590201 Bedyngham, Thomas, of Berkyng, Essex, yeoman 3
3602679 1868501 1868501 defendant Brounyng Thomas carpenter 590201 590201 Brounyng, Thomas, of Berkyng, Essex, carpenter 0
3613456 1871854 1871854 defendant Fayreman Simon yeoman 590201 590201 Fayreman, Simon, of Berkyng, Essex, yeoman 3
3661821 1913980 1913980 defendant Waller William yeoman 590201 590201 Waller, William, of Berkyng, Essex, yeoman 3
3662227 1914102 1914102 defendant Nicholas John yeoman 590201 590201 Nicholas, John, of Berkyng, Essex, yeoman 3
3667790 1915867 1915867 plaintiff Wyott William gent 590201 590201 Wyott, William, of Berkyng, Essex, gent 0
3726250 1934476 1934476 defendant Valentyne Andrew husbandman 590201 590201 Valentyne, Andrew, of Berkyng, Essex, husbandman 0
3772639 1949134 1949134 defendant Estwell Richard gent 590201 590201 Estwell, Richard, of Berkyng, Essex, tanner. Warner, Richard, of London, gent 3
3790302 1954784 1954784 defendant Estwell Richard tanner 590201 590201 Estwell, Richard, of Berkyng, Essex, tanner 0
3798588 1957463 1957463 defendant Smyth Hugh yeoman 590201 590201 Smyth, Hugh, of Berkyng, Essex, yeoman 0
3801571 1958394 1958394 defendant Bado Robert clerk 590201 590201 Bado, Robert, of Berkyng, Essex, clerk 1
3808211 1960449 1960449 defendant Chapman William yeoman 590201 590201 Chapman, William, of Berkyng, Essex, yeoman 4
3825903 1965950 1965950 defendant Page William yeoman 590201 590201 Page, William, of Berkyng, Essex, yeoman 0
3825917 1965954 1965954 defendant Smyth Hugh yeoman 590201 590201 Smyth, Hugh, of Berkyng, Essex, yeoman 0
3825929 1965957 1965957 defendant Nicholas John yeoman 590201 590201 Nicholas, John, of Berkyng, Essex, yeoman 0
3825953 1965962 1965962 defendant Rand William gent 590201 590201 Rand, William, of berkyng, Essex, gent 0
3825962 1965965 1965965 defendant Wyatt William (legal representative) 590201 590201 Wyatt, William, of Berkyng, Essex, gent, executor of 0
3825966 1965966 1965966 defendant Wyatt William (legal representative) 590201 590201 Wyatt, William, of Berkyng, Essex, gent, executor of 0
3826038 1965987 1965987 defendant Wodland John husbandman 590201 590201 Wodland, John, of Berkyng, Essex, husbandman 0
3826044 1965989 1965989 defendant Marram John yeoman 590201 590201 Marram, John, of Berkyng, Essex, yeoman 0
3826092 1966001 1966001 defendant Browne Robert husbandman 590201 590201 Browne, Robert, of Berkyng, Essex, husbandman 1
3826107 1966006 1966006 defendant Humfrey John carpenter 590201 590201 Humfrey, John, of Berkyng, Essex, carpenter 0
3839816 1970381 1970381 defendant Burre John gent 590201 590201 Burre, John, of Berkyng, Essex, gent 0
3840416 1970564 1970564 defendant Marham John yeoman 590201 590201 Marham, John, of Berkyng, Essex, yeoman 0
3892134 1987622 1987622 defendant Clerke Joan   590201 590201 Clerke, Joan, of Berkyng, Essex, widow of Clerk, Richard, senior, of Berkyng 0
3912238 1994421 1994421 defendant Sparowe William   590201 590201 Sparowe, William, of Berkyng, Essex 0
4007481 2027460 2027460 plaintiff Lawson alias Edmond Margery widow 590201 590201 Margery his wife, alias Margery Marshall, of Berkyng, Essex, widow 2
4482232 2195152 2195152 defendant Cosyngton William   590201 590201 Cosyngton, William, of Berkyng, Essex, mason 0
4622763 2238095 2238095 defendant Cowpere Peter   590201 590201 Cowpere, Peter, of Berkyng, Essex 0
4666209 2250903 2250903 defendant Lecham Thomas gent 590201 590201 Lecham, Thomas, of Berkyng, Essex, gent 2
4666214 2250904 2250904 defendant Lecham Thomas gent 590201 590201 Lecham, Thomas, of Berkyng, Essex, gent 1
4759538 2283325 2283325 defendant Alberd William draper 590201 590201 Alberd, William, of Berkyng, Essex, draper 1
4785342 2291433 2291433 defendant Bounde John herder 590201 590201 Bounde, John, of Berkyng, Essex, herder 1
4790610 2293150 2293150 defendant Welles William   590201 590201 Welles, William, of Berkyng, Essex, bailiff 0
4792772 2293827 2293827 defendant Shortale John brewer 590201 590201 Shortale, John, of Berkyng, Essex, brewer 0
4792774 2293828 2293828 defendant Shortale John brewer 590201 590201 Shortale, John, of Berkyng, Essex, brewer 0
4794611 2294455 2294455 defendant Alberd William draper 590201 590201 Alberd, William, of Berkyng, Essex, draper 0
4794614 2294456 2294456 defendant Alberd William draper 590201 590201 Alberd, William, of Berkyng, Essex, draper 0
4801566 2296672 2296672 defendant Chambre Alice widow 590201 590201 Chambre, Alice, of Berkyng, Essex, widow 1
4838048 2307823 2307823 defendant More Roger gent 590201 590201 More, Roger, of Berkyng, Essex, gent 0
4838051 2307824 2307824 defendant Moor Roger gent 590201 590201 Moor, Roger, of Berkyng, Essex, gent 0
4865241 2316102 2316102 defendant More Roger gent 590201 590201 More, Roger, of Berkyng, Essex, gent 0
4874007 2318808 2318808 defendant Mille William pulter 590201 590201 Mille, William, of Berkyng, Essex, pulter 0
4889143 2323392 2323392 defendant Bedeford Henry gent 590201 590201 Bedeford, Henry, of Berkyng, Essex, gent 4
4890603 2323817 2323817 defendant Somercotes John gent 590201 590201 Somercotes, John, of Berkyng, Essex, gent 0
4897277 2325807 2325807 defendant Somercotes John gent 590201 590201 Somercotes, John, of Berkyng, Essex, gent 0
4899188 2326387 2326387 defendant Bedeford Henry gent 590201 590201 Bedeford, Henry, of Berkyng, Essex, gent 4
4910038 2329663 2329663 defendant Byfeld William husbandman 590201 590201 (Byfeld, William, of Berkyng, Essex, husbandman 2
4923351 2333731 2333731 defendant Lilford John yeoman 590201 590201 Lilford, John, of Berkyng, Essex, yeoman 2
4923358 2333732 2333732 defendant Lilford John yeoman 590201 590201 Lilford, John, of Berkyng, Essex, yeoman 2
4929811 2335737 2335737 defendant Malmayn John husbandman 590201 590201 Malmayn, John, of Berkyng, Essex, husbandman 0
4941515 2339363 2339363 defendant Payntour John painter 590201 590201 Payntour, John, of Berkyng, Essex, painter 3
4941520 2339364 2339364 defendant Payntour John painter 590201 590201 Payntour, John, of Berkyng, Essex, painter 3
4956592 2343925 2343925 defendant Grene Thomas chaplain 590201 590201 Grene, Thomas, of Berkyng, Essex, chaplain 0
4965697 2346664 2346664 plaintiff Cumfort William husbandman 590201 590201 Cumfort, William, of Berkyng, Essex, husbandman 0
4965699 2346665 2346665 plaintiff Cumfort William husbandman 590201 590201 Cumfort, William, of Berkyng, Essex, husbandman 0
4980999 2351249 2351249 defendant Hull Thomas clerk 590201 590201 Hull, Thomas, of Berkyng, Essex, clerk 0
4991981 2354489 2354489 defendant Dodde Richard barber 590201 590201 Dodde, Richard, of Berkyng, Essex, barber 0
4995592 2355519 2355519 defendant Grove Nicholas laborer 590201 590201 Grove, Nicholas, of Berkyng, Essex, laborer 0
5011305 2360167 2360167 defendant Payn John gent 590201 590201 Payn, John, of Berkyng, Essex, gent 0
5014846 2361219 2361219 defendant Edmondesson William smith 590201 590201 Edmondesson, William, of Berkyng, Essex, smith 0
5015460 2361404 2361404 defendant Byfeld William draper 590201 590201 Byfeld, William, of Berkyng, Essex, draper 0
5015465 2361405 2361405 defendant Byfeld William draper 590201 590201 Byfeld, William, of Berkyng, Essex, draper 0
5017897 2362118 2362118 defendant Benamour Richard husbandman 590201 590201 Benamour, Richard, of Berkyng, Essex, husbandman 1
5018708 2362361 2362361 defendant Dodde Richard barber 590201 590201 Dodde, Richard, of Berkyng, Essex, barber 0
5025830 2364455 2364455 defendant Bienamour Richard gent 590201 590201 Bienamour, Richard, of Berkyng, Essex, gent 0
5036593 2367568 2367568 defendant Payn John painter 590201 590201 Payn, John, of Berkyng, Essex, painter 1
5037829 2367942 2367942 defendant Bonamour Richard gent 590201 590201 Bonamour, Richard, of Berkyng, Essex, gent 3
5057936 2373946 2373946 defendant Dodde Richard barber 590201 590201 Dodde, Richard, of Berkyng, Essex, barber 0
5093537 2384508 2384508 defendant Wroxham Rchard gent 590201 590201 Wroxham, Rchard, of Berkyng, Essex, gent 1
5094331 2384748 2384748 defendant Byfyld William draper 590201 590201 Byfyld, William, of Berkyng, Essex, draper 0
5094335 2384749 2384749 defendant Byfyld William draper 590201 590201 Byfyld, William, of Berkyng, Essex, draper 0
5104594 2387778 2387778 defendant Debenham Thomas ostler 590201 590201 Debenham, Thomas, of Berkyng, Essex, ostler 0
5104597 2387779 2387779 defendant Debenham Thomas ostler 590201 590201 Debenham, Thomas, of Berkyng, Essex, ostler 0
5107932 2388759 2388759 defendant Welke Stephen husandman 590201 590201 Welke, Stephen, of Berkyng, Essex, husandman 4
5118804 2391931 2391931 defendant Frost Thomas husbandman 590201 590201 Frost, Thomas, of Berkyng, Essex, husbandman 0
5126547 2394240 2394240 defendant Cappes John carpenter 590201 590201 Cappes, John, of Berkyng, Essex, carpenter 1
5136491 2397189 2397189 defendant Dryland John chapman 590201 590201 Dryland, John, of Berkyng, Essex, chapman 4
5136507 2397192 2397192 defendant (illegible) John chapman 590201 590201 --, John, of Berkyng, Essex, chapman 2
5137389 2397447 2397447 defendant Serle John dyer 590201 590201 Serle, John, of Berkyng, Essex, dyer 4
5173074 2407835 2407835 defendant Dryland John chapman 590201 590201 Dryland, John, of Berkyng, Essex, chapman 3
5212600 2419432 2419432 defendant Potkyns Thomas barber 590201 590201 Potkyns, Thomas, of Berkyng, Essex, barber 3
5213833 2419774 2419774 defendant Wynterbourne John yeoman 590201 590201 Wynterbourne, John, of Berkyng, Essex, yeoman 0
5218649 2421182 2421182 defendant Hervy John gent 590201 590201 Hervy, John, of Berkyng, Essex, gent 2
5243553 2428309 2428309 defendant Dryland John chapman 590201 590201 Dryland, John, of Berkyng, Essex, chapman 0
5243561 2428311 2428311 defendant Dryland John chapman 590201 590201 Dryland, John, of Berkyng, Essex, chapman 1
5252134 2430780 2430780 defendant Cosyn or Cofyn Robert yeoman 590201 590201 Cosyn or Cofyn, Robert, of Berkyng, Essex, yeoman 0
5261777 2433793 2433793 defendant Bedyngham Thomas gent 590201 590201 Bedyngham, Thomas, of Berkyng, Essex, gent 1
5267831 2435702 2435702 defendant Ruston John, senior gent 590201 590201 Ruston, John, senior, of Berkyng, Essex, gent 1
5271860 2436860 2436860 defendant Wroxham Richard gent 590201 590201 Wroxham, Richard, of Berkyng, Essex, gent 16
5273244 2437243 2437243 defendant Bedyngham Thomas husbandman 590201 590201 Bedyngham, Thomas, of Berkyng, Essex, husbandman 0
5273248 2437244 2437244 defendant Bedyngham Thomas yeoman 590201 590201 Bedyngham, Thomas, of Berkyng, Essex, yeoman 0
5275667 2437948 2437948 defendant Bedyngham Thomas yeoman 590201 590201 Bedyngham, Thomas, of Berkyng, Essex, yeoman 0
5292409 2442777 2442777 defendant Bedyngham Thomas yeoman 590201 590201 Bedyngham, Thomas, of Berkyng, Essex, yeoman 1
5292415 2442779 2442779 defendant Bedyngham Thomas yeoman 590201 590201 Bedyngham, Thomas, of Berkyng, Essex, yeoman 1
5293141 2442976 2442976 plaintiff Sha or Shawe John (legal representative) 590201 590201 Sha or Shawe, John, of Berkyng, Essex, yeoman, executrix of 0
5293148 2442978 2442978 plaintiff Shaa or Shawe John (legal representative) 590201 590201 Shaa or Shawe, John, of Berkyng, Essex, gent, executrix of 0
5295076 2443547 2443547 defendant Tanner Thomas husbandman 590201 590201 Tanner, Thomas, of Berkyng, Essex, husbandman 3
5295081 2443548 2443548 defendant Tanner Thomas husbandman 590201 590201 Tanner, Thomas, of Berkyng, Essex, husbandman 1

Next page

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);