names

71 rows where place_id = 757102

✎ 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
4431639 2174662 2174662 plaintiff Bright Waldon John de   757102 757102 Bright Waldon, John de, of Braunford, parson 0
4443280 2182859 2182859 plaintiff Carpenter Lawrence   757102 757102 Carpenter, Lawrence, of Braunford 0
4444215 2183172 2183172 defendant Bene John   757102 757102 Bene, John, of Braunford 0
4452181 2185665 2185665 defendant Dawys Peter   757102 757102 Dawys, Peter, of Braunford 4
4465954 2190014 2190014 defendant Weyland John   757102 757102 Weyland, John, of Braunford 1
4479789 2194341 2194341 defendant Deye Thomas   757102 757102 Deye, Thomas, of Braunford 2
4494612 2199006 2199006 defendant Smyth John   757102 757102 Smyth, John, of Braunford 4
4522226 2207297 2207297 defendant Podde William   757102 757102 Podde, William, of Braunford 2
4532016 2210279 2210279 plaintiff Pod William   757102 757102 Pod, William, of Braunford 0
4532017 2210279 2210279 defendant Bene John   757102 757102 Bene, John, of Braunford 0
4534164 2210947 2210947 defendant Langeton Thomas shoemaker 757102 757102 Langeton, Thomas, of Braunford, shoemaker 0
4535914 2211504 2211504 defendant Langton Thomas   757102 757102 Langton, Thomas, of Braunford 1
4611937 2234793 2234793 defendant Tarlee John, sen   757102 757102 Tarlee, John, sen, of Braunford 0
4648192 2245536 2245536 plaintiff Stonyng Walter   757102 757102 Stonyng, Walter, of Braunford, vicar 0
4658222 2248452 2248452 defendant Pope John   757102 757102 Pope, John, of Braunford 0
4666617 2251039 2251039 defendant Garlond Christiana spinner 757102 757102 Garlond, Christiana, of Braunford, spinner 1
4699071 2265177 2265177 defendant Sorell John butcher 757102 757102 Sorell, John, of Braunford, butcher 0
4706680 2267472 2267472 defendant Canoun Robert yeoman 757102 757102 Canoun, Robert, of Braunford, yeoman 0
4729330 2274390 2274390 defendant Rendham Nicholas yeoman 757102 757102 Rendham, Nicholas, of Braunford, yeoman 2
4737650 2276884 2276884 defendant Packard Robert butcher 757102 757102 Packard, Robert, of Braunford, butcher 1
4756812 2282496 2282496 defendant Dey_ John yeoman 757102 757102 Dey_, John, of Braunford, yeoman 1
4805221 2297832 2297832 defendant Nevyll John clerk 757102 757102 with Nevyll, John, of Braunford, clerk 1
4829723 2305341 2305341 defendant Broke William   757102 757102 Broke, William, of Braunford, mason 0
4890431 2323775 2323775 defendant Brook William   757102 757102 Brook, William, of Braunford, mason 0
4915243 2331274 2331274 defendant Starlyng John yeoman 757102 757102 Starlyng, John, of Braunford, yeoman 0
4927143 2334924 2334924 defendant Munmouth Thomas husbandman 757102 757102 Munmouth, Thomas, of Braunford, husbandman 1
4953343 2342964 2342964 defendant Barnabe William yeoman 757102 757102 Barnabe, William, of Braunford, yeoman 0
4977145 2350118 2350118 defendant Plummer Nicholas husbandman 757102 757102 Plummer, Nicholas, of Braunford, husbandman 4
4978605 2350550 2350550 defendant Clerk Edmund yeoman 757102 757102 Clerk, Edmund, of Braunford, yeoman 1
4983312 2351914 2351914 defendant Starlyng John, senior husbandman 757102 757102 Starlyng, John, senior, of Braunford, husbandman 0
4986838 2353003 2353003 defendant Tarle John   757102 757102 Tarle, John, of Braunford, wright 0
4986839 2353003 2353003 defendant Waylov William laborer 757102 757102 Waylov, William, of Braunford, laborer 1
4986840 2353003 2353003 defendant Baryngton Barhtolomew laborer 757102 757102 Baryngton, Barhtolomew, of Braunford, laborer 2
4988219 2353446 2353446 defendant Pygewell John yeoman 757102 757102 Pygewell, John, of Braunford, yeoman 0
5026805 2364714 2364714 plaintiff Lolt William (legal representative) 757102 757102 Lolt, William, of Braunford, executors of 0
5026810 2364714 2364714 defendant Sterlyng John butcher 757102 757102 Sterlyng, John, of Braunford, butcher 0
5039032 2368320 2368320 defendant Benaker John   757102 757102 Benaker, John, of Braunford, servant 0
5039033 2368320 2368320 defendant Vaus Stephen laborer 757102 757102 Vaus, Stephen, of Braunford, laborer 1
5039820 2368552 2368552 defendant Wodeward Roger yeoman 757102 757102 Wodeward, Roger, of Braunford, yeoman 2
5097662 2385741 2385741 defendant Walle Stephen husbandman 757102 757102 Walle, Stephen, of Braunford, husbandman 0
5129760 2395190 2395190 defendant Bocher John butcher 757102 757102 Bocher, John, of Braunford, butcher 2
5148895 2400801 2400801 defendant Bocher John butcher 757102 757102 Bocher, John, of Braunford, butcher 2
5245687 2428898 2428898 defendant Gegge Robert carpenter 757102 757102 Gegge, Robert, of Braunford, carpenter 0
5255981 2431994 2431994 defendant Elenger William yeoman 757102 757102 Elenger, William, of Braunford, yeoman 0
5266494 2435269 2435269 plaintiff Wade William, senior   757102 757102 Wade, William, senior, of Braunford 0
5267592 2435624 2435624 defendant Smyth John clerk 757102 757102 Smyth, John, of Braunford, clerk 1
5270987 2436611 2436611 defendant Clerk William smith 757102 757102 Clerk, William, of Braunford, smith 4
5271566 2436779 2436779 defendant Cook John yeoman 757102 757102 Cook, John, of Braunford, yeoman 1
5271605 2436791 2436791 defendant Belton John gent 757102 757102 Belton, John, of Braunford, gent 0
5277390 2438466 2438466 defendant Byles William husbandman 757102 757102 Byles, William, of Braunford, husbandman 0
5278912 2438945 2438945 plaintiff Bolton John   757102 757102 Bolton, John, of Braunford 0
5284456 2440468 2440468 defendant Gegge Robert carpenter 757102 757102 Gegge, Robert, of Braunford, carpenter 0
5291370 2442480 2442480 defendant Bolton John gent 757102 757102 Bolton, John, of Braunford, gent 0
5291371 2442480 2442480 defendant Gegge Robert carpenter 757102 757102 Gegge, Robert, of Braunford, carpenter 1
5326906 2453121 2453121 defendant Yonge Thomas husbandman 757102 757102 Yonge, Thomas, of Braunford, husbandman 0
5339242 2456844 2456844 defendant Waryn John yeoman 757102 757102 Waryn, John, of Braunford, yeoman 0
5403505 2476072 2476072 defendant Boure Thomas husbandman 757102 757102 Boure, Thomas, of Braunford, husbandman 2
5410728 2478154 2478154 defendant Byles William yeoman 757102 757102 Byles, William, of Braunford, yeoman 0
5416620 2479885 2479885 defendant Boure Thomas husbandman 757102 757102 Boure, Thomas, of Braunford, husbandman 1
5420326 2481004 2481004 defendant Onwyn William husbandman 757102 757102 Onwyn, William, of Braunford, husbandman 0
5424798 2482375 2482375 defendant Byles William yeoman 757102 757102 Byles, William, of Braunford, yeoman 0
5424805 2482376 2482376 defendant Byles William   757102 757102 Byles, William, of Braunford 0
5427202 2483076 2483076 defendant Kenton Edmund husbandman 757102 757102 Kenton, Edmund, of Braunford, husbandman 0
5427203 2483076 2483076 defendant Vyncent John husbandman 757102 757102 Vyncent, John, of Braunford, husbandman 1
5439108 2486620 2486620 defendant Onwyn William husbandman 757102 757102 Onwyn, William, of Braunford, husbandman 0
5468285 2495456 2495456 defendant Onewyn William husbandman 757102 757102 Onewyn, William, of Braunford, husbandman 0
5468286 2495456 2495456 defendant Yonge Thomas husbandman 757102 757102 Yonge, Thomas, of Braunford, husbandman 1
5496296 2503793 2503793 defendant Bilys William husbandman 757102 757102 Bilys, William, of Braunford, husbandman 0
5503648 2506054 2506054 defendant Bolton John   757102 757102 Bolton, John, of Braunford, gent, son of Bolton, John 0
5581553 2529305 2529305 defendant Bylys William yeoman 757102 757102 Bylys, William, of Braunford, yeoman 2
5597189 2534027 2534027 defendant Bylys William yeoman 757102 757102 Bylys, William, of Braunford, yeoman 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);