names

92 rows where place_id = 594598

✎ 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
3616788 1872880 1872880 defendant Foweler Robert gent 594598 594598 Foweler, Robert, of Bray, gent 0
3651144 1910722 1910722 defendant Staverton Humphrey gent 594598 594598 Staverton, Humphrey, of Bray, gent 0
3651146 1910723 1910723 defendant Staverton Humphrey gent 594598 594598 Staverton, Humphrey, of Bray, gent 0
3676629 1918727 1918727 defendant Fynche John carpenter 594598 594598 Fynche, John, of Bray, carpenter 0
3686077 1921805 1921805 defendant Yateley Robert husbandman 594598 594598 Yateley, Robert, of Bray, husbandman 3
3701133 1926602 1926602 defendant Staveley John gent 594598 594598 Staveley, John, of Bray, gent 0
3708409 1928927 1928927 defendant Blount William husbandman 594598 594598 Blount, William, of Bray, husbandman 0
3732982 1936537 1936537 plaintiff Wodde Thomas   594598 594598 Wodde, Thomas, of Bray 1
3732983 1936537 1936537 defendant Fynche John carpenter 594598 594598 Fynche, John, of Bray, carpenter 0
3737711 1938016 1938016 defendant Fynche John husbandman 594598 594598 Fynche, John, of Bray, husbandman 0
3753832 1943142 1943142 defendant Banbury Richard fisher 594598 594598 Banbury, Richard, of Bray, fisher 0
3753833 1943142 1943142 defendant Dyblyn Robert baker 594598 594598 Dyblyn, Robert, of Bray, baker 1
3753845 1943147 1943147 defendant Banbury Richard fisher 594598 594598 Banbury, Richard, of Bray, fisher 0
3753846 1943147 1943147 defendant Dyblyng Robert baker 594598 594598 Dyblyng, Robert, of Bray, baker 1
3766057 1947050 1947050 defendant Fynche John carpenter 594598 594598 Fynche, John, of Bray, carpenter 0
3766059 1947051 1947051 defendant Fynche John carpenter 594598 594598 Fynche, John, of Bray, carpenter 0
3767252 1947397 1947397 defendant Nores John carpenter 594598 594598 Nores, John, of Bray, carpenter 2
3800520 1958087 1958087 defendant Fynche John carpenter 594598 594598 Fynche, John, of Bray, carpenter 0
3827462 1966457 1966457 plaintiff Bray Edmund   594598 594598 Bray, Edmund, of Bray, knight 0
3827471 1966458 1966458 plaintiff Bray Edmund   594598 594598 Bray, Edmund, of Bray, knight 0
3853720 1974794 1974794 defendant Norres John carpenter 594598 594598 Norres, John, of Bray, carpenter 0
3934575 2001859 2001859 defendant Norryes John carpenter 594598 594598 Norryes, John, of Bray, carpenter 0
4076716 2051959 2051959 plaintiff Slye William yeoman 594598 594598 Slye, William, of Bray, yeoman 0
4078829 2052725 2052725 defendant Goring John laborer 594598 594598 Goring, John, of Bray, laborer 1
4124302 2068984 2068984 defendant Wynche Robert (legal representative) 594598 594598 Wynche, Robert, of Bray, husbandman, administrator of 0
4139228 2074399 2074399 defendant Potter Thomas tailor 594598 594598 Potter, Thomas, of Bray, tailor 0
4219199 2102212 2102212 defendant Jennens William yeoman 594598 594598 Jennens, William, of Bray, yeoman 0
4219204 2102213 2102213 defendant Jennens William yeoman 594598 594598 Jennens, William, of Bray, yeoman 0
4229277 2105724 2105724 defendant Beckley Thomas yeoman 594598 594598 Beckley, Thomas, of Bray, yeoman 1
4259167 2116041 2116041 defendant Beckley Thomas yeoman 594598 594598 Beckley, Thomas, of Bray, yeoman 1
4347844 2146496 2146496 defendant Gayer George gent 594598 594598 Gayer, George, of Bray, gent 0
4518070 2206026 2206026 defendant Laurence John, sen   594598 594598 Laurence, John, sen, of Bray 0
4518072 2206026 2206026 defendant Gilmyn John   594598 594598 Gilmyn, John, of Bray 2
4624548 2238659 2238659 defendant More John   594598 594598 More, John, of Bray 0
4720650 2271792 2271792 defendant Wilmo Thomas husbandman 594598 594598 Wilmo, Thomas, of Bray, husbandman 0
4744044 2278782 2278782 defendant Smyth Henry   594598 594598 Smyth, Henry, of Bray, holy water clerk 0
4744046 2278783 2278783 defendant Smyth Henry   594598 594598 Smyth, Henry, of Bray, holy water clerk 0
4764301 2284831 2284831 defendant Martyn Richard (legal representative) 594598 594598 Martyn, Richard, of Bray, executors of 1
4796962 2295206 2295206 defendant Dallyng Robert husbandman 594598 594598 Dallyng, Robert, of Bray, husbandman 1
4796965 2295207 2295207 defendant Dallyng Robert husbandman 594598 594598 Dallyng, Robert, of Bray, husbandman 1
4879859 2320614 2320614 defendant Bowyer Thomas   594598 594598 Bowyer, Thomas, of Bray 0
4885794 2322428 2322428 defendant Goryng Richard butcher 594598 594598 Goryng, Richard, of Bray, butcher 0
4892375 2324352 2324352 defendant Cruchefeld Thomas husbandman 594598 594598 Cruchefeld, Thomas, of Bray, husbandman 2
4931642 2336285 2336285 defendant Palmer John yeoman 594598 594598 Palmer, John, of Bray, yeoman 1
4931643 2336285 2336285 defendant Mauncell John gent 594598 594598 Mauncell, John, of Bray, gent 2
4983121 2351854 2351854 defendant Palmere John   594598 594598 Palmere, John, of Bray, franklin 6
5057385 2373777 2373777 defendant Dalyn John husbandman 594598 594598 Dalyn, John, of Bray, husbandman 0
5057387 2373778 2373778 defendant Dalyn John husbandman 594598 594598 Dalyn, John, of Bray, husbandman 0
5088759 2383089 2383089 defendant Cruchefeld Thomas gent 594598 594598 Cruchefeld, Thomas, of Bray, gent 1
5120166 2392334 2392334 defendant Shere William husbandman 594598 594598 Shere, William, of Bray, husbandman 0
5120573 2392447 2392447 defendant Bowyer James husbandman 594598 594598 Bowyer, James, of Bray, husbandman 0
5120574 2392447 2392447 defendant Towe William shoemaker 594598 594598 Towe, William, of Bray, shoemaker 1
5127356 2394482 2394482 defendant Pratte John husbandman 594598 594598 Pratte, John, of Bray, husbandman 1
5146245 2400031 2400031 defendant Pratte John husbandman 594598 594598 Pratte, John, of Bray, husbandman 1
5155305 2402701 2402701 plaintiff Morys William   594598 594598 Morys, William, of Bray, parson of the parish church 4
5155311 2402702 2402702 plaintiff (not given) William vicar of Morys 594598 594598 Morys, William, of Bray, vicar of the parish church 4
5160515 2404166 2404166 defendant Smyth Ralph husbandman 594598 594598 Smyth, Ralph, of Bray, husbandman 0
5171998 2407524 2407524 plaintiff (not given) William vicar of Morys 594598 594598 Morys, William, of Bray, vicar of the parish church 4
5190879 2413079 2413079 plaintiff Morys William   594598 594598 Morys, William, of Bray, vicar 4
5190885 2413080 2413080 plaintiff Morys William   594598 594598 Morys, William, of Bray, vicar 4
5193933 2413955 2413955 defendant Motte John husbandman 594598 594598 Motte, John, of Bray, husbandman 0
5223307 2422510 2422510 plaintiff Norreys William, senior gent 594598 594598 Norreys, William, senior, of Bray, gent 0
5223309 2422511 2422511 plaintiff Norreys William, senior gent 594598 594598 Norreys, William, senior, of Bray, gent 0
5223346 2422522 2422522 defendant Browne Richard husbandman 594598 594598 Browne, Richard, of Bray, husbandman 0
5243480 2428289 2428289 defendant Boyer Thomas husbandman 594598 594598 Boyer, Thomas, of Bray, husbandman 0
5243481 2428289 2428289 defendant Saddoke Robert husbandman 594598 594598 Saddoke, Robert, of Bray, husbandman 1
5243482 2428289 2428289 defendant Lytelton Thomas husbandman 594598 594598 Lytelton, Thomas, of Bray, husbandman 2
5283162 2440139 2440139 defendant Brome Thomas husbandman 594598 594598 Brome, Thomas, of Bray, husbandman 2
5305256 2446575 2446575 defendant Staverton Thomas yeoman 594598 594598 Staverton, Thomas, of Bray, yeoman 1
5336045 2455857 2455857 defendant Shere John husbandman 594598 594598 Shere, John, of Bray, husbandman 0
5341666 2457587 2457587 defendant Nook Thomas husbandman 594598 594598 Nook, Thomas, of Bray, husbandman 0
5374427 2467607 2467607 defendant Foweler Agnes widow 594598 594598 Foweler, Agnes, of Bray, widow 0
5374429 2467608 2467608 defendant Foweler Agnes widow 594598 594598 Foweler, Agnes, of Bray, widow 0
5379623 2469215 2469215 defendant Symon Thomas husbandman 594598 594598 Symon, Thomas, of Bray, husbandman 0
5391142 2472541 2472541 defendant Fowler Agnes widow 594598 594598 Fowler, Agnes, of Bray, widow 0
5420927 2481188 2481188 defendant Symon Thomas husbandman 594598 594598 Symon, Thomas, of Bray, husbandman 2
5440588 2487090 2487090 defendant Symon Thomas   594598 594598 Symon, Thomas, of Bray 0
5440593 2487091 2487091 defendant Symon Thomas husbandman 594598 594598 Symon, Thomas, of Bray, husbandman 1
5440722 2487134 2487134 defendant Symond Thomas husbandman 594598 594598 Symond, Thomas, of Bray, husbandman 1
5482673 2499762 2499762 defendant Danyell George gent 594598 594598 Danyell, George, of Bray, gent 0
5504312 2506263 2506263 defendant Bower Robert husbandman 594598 594598 Bower, Robert, of Bray, husbandman 0
5507970 2507389 2507389 defendant Danyell George gent 594598 594598 Danyell, George, of Bray, gent 0
5522870 2511981 2511981 defendant Foweler Robert gent 594598 594598 Foweler, Robert, of Bray, gent 0
5540601 2517189 2517189 defendant Staverton Ralph esq 594598 594598 Staverton, Ralph, of Bray, esq 1
5540602 2517189 2517189 defendant Halle John yeoman 594598 594598 Halle, John, of Bray, yeoman 2
5550313 2520111 2520111 defendant Ambrose Thomas husbandman 594598 594598 Ambrose, Thomas, of Bray, husbandman 0
5560607 2523065 2523065 defendant Bewer Richard tanner 594598 594598 Bewer, Richard, of Bray, tanner 0
5562020 2523494 2523494 defendant Towe Thomas husbandman 594598 594598 Towe, Thomas, of Bray, husbandman 4
5577228 2527929 2527929 defendant Stretend Thmas yeoman 594598 594598 Stretend, Thmas, of Bray, yeoman 0
5580525 2528998 2528998 defendant Heyward John husbandman 594598 594598 Heyward, John, of Bray, husbandman 1
5580526 2528998 2528998 defendant Bowyer Robert (legal representative) 594598 594598 Bowyer, Robert, of Bray, husbandman, executor of 2
5580527 2528998 2528998 defendant Aylmer Walter yeoman 594598 594598 (Aylmer, Walter, of Bray, yeoman 3

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