names

113 rows where place_id = 586527

✎ 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
3588952 1864193 1864193 defendant Stanmowe John (legal representative) 586527 586527 Stanmowe, John, of Bedyngham, yeoman, executor of 13
3588953 1864193 1864193 defendant Stanmow John yeoman 586527 586527 Stanmow, John, of Bedyngham, yeoman 14
3603450 1868745 1868745 plaintiff Denys William yeoman 586527 586527 Denys, William, of Bedyngham, yeoman 0
3603452 1868746 1868746 plaintiff Denys William   586527 586527 Denys, William, of Bedyngham 0
3615118 1872373 1872373 defendant Stannowe John yeoman 586527 586527 Stannowe, John, of Bedyngham, yeoman 0
3648200 1909834 1909834 defendant Rede Robert husbandman 586527 586527 Rede, Robert, of Bedyngham, husbandman 1
3648201 1909834 1909834 defendant Rede John husbandman 586527 586527 Rede, John, of Bedyngham, husbandman 2
3670204 1916628 1916628 defendant Goslyn William husbandman 586527 586527 Goslyn, William, of Bedyngham, husbandman 0
3740789 1938976 1938976 plaintiff Crykmay Thomas husbandman 586527 586527 Crykmay, Thomas, of Bedyngham, husbandman 2
3748478 1941457 1941457 defendant Heyth William husbandman 586527 586527 Heyth, William, of Bedyngham, husbandman 0
3766983 1947340 1947340 defendant Saunder Thomas husbandman 586527 586527 Saunder, Thomas, of Bedyngham, husbandman 2
3798615 1957474 1957474 plaintiff Hethe William yeoman 586527 586527 Hethe, William, of Bedyngham, yeoman 0
3820935 1964442 1964442 defendant Dawys Richard husbandman 586527 586527 Dawys, Richard, of Bedyngham, husbandman 1
3826218 1966047 1966047 defendant Seger John clerk 586527 586527 Seger, John, of Bedyngham, clerk 1
3836784 1969404 1969404 defendant Lover Richard husbandman 586527 586527 Lover, Richard, of Bedyngham, husbandman 0
3863882 1978093 1978093 defendant Cobbell William husbandman 586527 586527 Cobbell, William, of Bedyngham, husbandman 1
3933252 2001416 2001416 plaintiff Grene James husbandman 586527 586527 Grene, James, of Bedyngham, husbandman 0
3950665 2007306 2007306 defendant Kent John   586527 586527 Kent, John, of Bedyngham laborer 0
3950666 2007306 2007306 defendant Goslyn Martha widow 586527 586527 together with Goslyn, Martha, of Bedyngham, widow 1
3950668 2007306 2007306 defendant Goslyn John, senior husbandman 586527 586527 Goslyn, John, senior, of Bedyngham, husbandman 3
3950907 2007383 2007383 defendant Gosselyn John, senior husbandman 586527 586527 Gosselyn, John, senior, of Bedyngham, husbandman 0
3950908 2007383 2007383 defendant Gooche William (legal representative) 586527 586527 Gooche, William, of Bedyngham, yeoman, executors of 1
3950909 2007383 2007383 defendant Gooche John, junior husbandman 586527 586527 (Gooche, John, junior, of Bedyngham, husbandman 2
3950910 2007383 2007383 defendant Gooche Mathia widow 586527 586527 Gooche, Mathia, of Bedyngham, widow 3
3951466 2007570 2007570 defendant Edwardes Robert husbandman 586527 586527 Edwardes, Robert, of Bedyngham, husbandman 0
3978312 2016998 2016998 defendant Gaysley Richard clerk 586527 586527 Gaysley, Richard, of Bedyngham, clerk 0
3997253 2023787 2023787 defendant Lancaster Robert yeoman 586527 586527 Lancaster, Robert, of Bedyngham, or of Alburgh, yeoman 3
4107070 2062821 2062821 defendant Eye or Gye John husbandman 586527 586527 Eye or Gye, John, of Bedyngham, husbandman 3
4114114 2065328 2065328 defendant Barker William smith 586527 586527 Barker, William, of Bedyngham, smith 3
4132309 2071869 2071869 defendant Hele Thomas yeoman 586527 586527 Hele, Thomas, of Bedyngham, yeoman 2
4269316 2119328 2119328 defendant Guye James husbandman 586527 586527 Guye, James, of Bedyngham, husbandman 0
4365404 2152691 2152691 defendant Gratwyck Philip yeoman 586527 586527 Gratwyck, Philip, of Bedyngham, yeoman 0
4365413 2152695 2152695 defendant Gratwyck Philip yeoman 586527 586527 Gratwyck, Philip, of Bedyngham, yeoman 0
4369284 2154078 2154078 defendant Ancocke or Awcocke Henry husbandman 586527 586527 Ancocke or Awcocke, Henry, of Bedyngham, yeoman, or of Smytheweeke, Lewes St Mary, husbandman 0
4394255 2162679 2162679 defendant Fawkener Nicholas yeoman 586527 586527 Fawkener, Nicholas, of Bedyngham, yeoman 0
4439624 2181660 2181660 defendant Westerne Andrew   586527 586527 Westerne, Andrew, of Bedyngham 0
4439625 2181660 2181660 defendant Clerk William   586527 586527 Clerk, William, of Bedyngham 1
4451561 2185458 2185458 defendant Oval Adam   586527 586527 Oval, Adam, of Bedyngham 1
4451562 2185458 2185458 defendant Lygaabed Adam   586527 586527 Lygaabed, Adam, of Bedyngham 2
4490533 2197732 2197732 defendant Whal Adam   586527 586527 Whal, Adam, of Bedyngham 0
4701464 2265859 2265859 defendant Ales John   586527 586527 Ales, John, of Bedyngham, inland fish seller 0
4744275 2278848 2278848 defendant Norton John yeoman 586527 586527 Norton, John, of Bedyngham, yeoman 2
4747896 2279890 2279890 defendant Grevestrete Robert laborer 586527 586527 Grevestrete, Robert, of Bedyngham, laborer 0
4784965 2291310 2291310 defendant Frythe Richard   586527 586527 Frythe, Richard, of Bedyngham, groom 1
4784966 2291310 2291310 defendant Cur Edmund laborer 586527 586527 Cur, Edmund, of Bedyngham, laborer 2
4786403 2291790 2291790 defendant Cur Edmund yeoman 586527 586527 Cur, Edmund, of Bedyngham, yeoman 0
4964201 2346195 2346195 defendant atte Lay Lawrence yeoman 586527 586527 atte Lay, Lawrence, of Bedyngham, yeoman 4
5021623 2363223 2363223 defendant Baker John husbandman 586527 586527 Baker, John, of Bedyngham, husbandman 3
5028319 2365163 2365163 defendant atte Laye Lawrence summoner 586527 586527 atte Laye, Lawrence, of Bedyngham, summoner 0
5035668 2367287 2367287 defendant atte Laye Lawrence yeoman 586527 586527 atte Laye, Lawrence, of Bedyngham, yeoman 0
5035674 2367288 2367288 defendant atte Laye Lawrence yeoman 586527 586527 atte Laye, Lawrence, of Bedyngham, yeoman 0
5125351 2393897 2393897 defendant Herdeler William butcher 586527 586527 Herdeler, William, of Bedyngham, butcher 1
5125352 2393897 2393897 defendant Courte John butcher 586527 586527 Courte, John, of Bedyngham, butcher 2
5138732 2397824 2397824 plaintiff Rychemond Robert yeoman 586527 586527 Rychemond, Robert, of Bedyngham, yeoman 0
5143940 2399371 2399371 defendant Herdeler William butcher 586527 586527 Herdeler, William, of Bedyngham, butcher 1
5143941 2399371 2399371 defendant Courte John butcher 586527 586527 Courte, John, of Bedyngham, butcher 2
5159496 2403892 2403892 plaintiff Rychemond Robert yeoman 586527 586527 Rychemond, Robert, of Bedyngham, yeoman 0
5196023 2414584 2414584 defendant Herdeler John butcher 586527 586527 Herdeler, John, of Bedyngham, butcher 1
5196024 2414584 2414584 defendant Herdeler William butcher 586527 586527 Herdeler, William, of Bedyngham, butcher 2
5212354 2419357 2419357 defendant Gosselyn Thomas yeoman 586527 586527 Gosselyn, Thomas, of Bedyngham, yeoman 0
5212355 2419357 2419357 defendant Courte John butcher 586527 586527 Courte, John, of Bedyngham, butcher 1
5225703 2423188 2423188 defendant Hardeler John butcher 586527 586527 Hardeler, John, of Bedyngham, butcher 0
5233787 2425470 2425470 defendant Newehawe Hugh   586527 586527 Newehawe, Hugh, of Bedyngham 0
5255837 2431948 2431948 defendant Rychemond Robert yeoman 586527 586527 Rychemond, Robert, of Bedyngham, yeoman 5
5256760 2432236 2432236 defendant Payn Thomas husbandman 586527 586527 Payn, Thomas, of Bedyngham, husbandman 0
5258217 2432691 2432691 defendant Rychemonde Robert yeoman 586527 586527 Rychemonde, Robert, of Bedyngham, yeoman 0
5275647 2437943 2437943 defendant Rychemond Robert husbandman 586527 586527 Rychemond, Robert, of Bedyngham, husbandman 0
5278450 2438804 2438804 defendant Rychemond Robert yeoman 586527 586527 Rychemond, Robert, of Bedyngham, yeoman 0
5284224 2440406 2440406 defendant Rychemond Robert yeoman 586527 586527 Rychemond, Robert, of Bedyngham, yeoman 2
5285096 2440667 2440667 defendant Rychemond Robert yeoman 586527 586527 Rychemond, Robert, of Bedyngham, yeoman 0
5297912 2444397 2444397 defendant Kok William husbandman 586527 586527 Kok, William, of Bedyngham, husbandman 1
5324937 2452537 2452537 defendant Markewyk Richard yeoman 586527 586527 Markewyk, Richard, of Bedyngham, yeoman 0
5324940 2452538 2452538 defendant Markwyke Richard yeoman 586527 586527 Markwyke, Richard, of Bedyngham, yeoman 0
5325590 2452731 2452731 defendant Stannowe John husbandman 586527 586527 Stannowe, John, of Bedyngham, husbandman 0
5325591 2452731 2452731 defendant Baker John husbandman 586527 586527 Baker, John, of Bedyngham, husbandman 1
5331807 2454593 2454593 defendant Coppyng William yeoman 586527 586527 Coppyng, William, of Bedyngham, yeoman 0
5345214 2458673 2458673 defendant Seman Thomas yeoman 586527 586527 Seman, Thomas, of Bedyngham, yeoman 2
5393337 2473150 2473150 defendant Hare Mathew yeoman 586527 586527 Hare, Mathew, of Bedyngham, yeoman 0
5407581 2477238 2477238 defendant Coppyng William yeoman 586527 586527 Coppyng, William, of Bedyngham, yeoman 0
5412588 2478709 2478709 defendant Payn Thomas husbandman 586527 586527 Payn, Thomas, of Bedyngham, husbandman 0
5414578 2479298 2479298 defendant Seman Thomas husbandman 586527 586527 Seman, Thomas, of Bedyngham, husbandman 0
5419046 2480623 2480623 defendant Potman John yeoman 586527 586527 Potman, John, of Bedyngham, yeoman 2
5420834 2481159 2481159 defendant Coppyng William husbandman 586527 586527 Coppyng, William, of Bedyngham, husbandman 0
5430391 2484024 2484024 defendant Seman Thomas husbandman 586527 586527 Seman, Thomas, of Bedyngham, husbandman 0
5430393 2484025 2484025 defendant Seman Thomas husbandman 586527 586527 Seman, Thomas, of Bedyngham, husbandman 0
5437230 2486074 2486074 defendant Potman John yeoman 586527 586527 Potman, John, of Bedyngham, yeoman 2
5439844 2486856 2486856 defendant Coppyng William yeoman 586527 586527 Coppyng, William, of Bedyngham, yeoman 0
5439846 2486857 2486857 defendant Coppyng William yeoman 586527 586527 Coppyng, William, of Bedyngham, yeoman 0
5463538 2494009 2494009 defendant Staunowe John   586527 586527 Staunowe, John, of Bedyngham, franklin 0
5477066 2498145 2498145 defendant Caster Leonard gent 586527 586527 together with Caster, Leonard, of Bedyngham, gent 7
5479405 2498856 2498856 defendant Stannawe John, senior yeoman 586527 586527 Stannawe, John, senior, of Bedyngham, yeoman 0
5479406 2498856 2498856 defendant Stannawe John, junior laborer 586527 586527 Stannawe, John, junior, of Bedyngham, laborer 1
5479407 2498856 2498856 defendant Stannawe Robert laborer 586527 586527 Stannawe, Robert, of Bedyngham, laborer 2
5488628 2501482 2501482 defendant Castell Leonard gent 586527 586527 Castell, Leonard, of Bedyngham, gent 0
5493088 2502843 2502843 plaintiff Deneys William   586527 586527 Deneys, William, of Bedyngham 0
5493089 2502843 2502843 defendant Warde John yeoman 586527 586527 Warde, John, of Bedyngham, yeoman 0
5493093 2502844 2502844 defendant Warde John yeoman 586527 586527 Warde, John, of Bedyngham, yeoman 0
5506267 2506879 2506879 defendant Warde John yeoman 586527 586527 Warde, John, of Bedyngham, yeoman 4
5541077 2517333 2517333 defendant Stanhowe John yeoman 586527 586527 Stanhowe, John, of Bedyngham, yeoman 0
5541080 2517334 2517334 defendant Stanhowe John yeoman 586527 586527 Stanhowe, John, of Bedyngham, yeoman 0

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