names

75 rows where place_id = 757517

✎ 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
4431949 2174772 2174772 defendant Gane John   757517 757517 Gane, John, of Brunham, son of Robert 0
4431954 2174773 2174773 defendant Gane John   757517 757517 Gane, John, of Brunham, son of Robert 0
4446575 2183840 2183840 defendant Fullere Richard   757517 757517 Fullere, Richard, of Brunham 0
4477235 2193549 2193549 plaintiff Cursam John   757517 757517 Cursam, John, of Brunham 3
4477650 2193676 2193676 defendant Southgate Thomas   757517 757517 Southgate, Thomas, of Brunham 0
4498933 2200305 2200305 defendant Bernyngham John   757517 757517 Bernyngham, John, of Brunham 0
4566604 2221125 2221125 defendant Burgh John   757517 757517 Burgh, John, of Brunham 0
4566610 2221126 2221126 defendant Burgh John   757517 757517 Burgh, John, of Brunham 0
4570006 2222190 2222190 defendant Grogan John   757517 757517 Grogan, John, of Brunham 0
4578389 2224729 2224729 plaintiff Clerk John   757517 757517 Clerk, John, of Brunham, parson of St Andrew's church 0
4597518 2230469 2230469 defendant Webstere John   757517 757517 Webstere, John, of Brunham 2
4608123 2233654 2233654 defendant Millere Robert   757517 757517 Millere, Robert, of Brunham 0
4609256 2233999 2233999 defendant Grene John   757517 757517 Grene, John, of Brunham 0
4619991 2237233 2237233 defendant Hongate Thomas   757517 757517 Hongate, Thomas, of Brunham 0
4625361 2238896 2238896 defendant Bradle John   757517 757517 Bradle, John, of Brunham 0
4630690 2240500 2240500 defendant Colyn John   757517 757517 Colyn, John, of Brunham 12
4633224 2241260 2241260 defendant fullere Robert   757517 757517 fullere, Robert, of Brunham 1
4633226 2241260 2241260 defendant Bradley John   757517 757517 Bradley, John, of Brunham 3
4633227 2241260 2241260 defendant Colyn John   757517 757517 Colyn, John, of Brunham 4
4637792 2242592 2242592 defendant Grene John   757517 757517 Grene, John, of Brunham 3
4637793 2242592 2242592 defendant Smyth James   757517 757517 Smyth, James, of Brunham 4
4640412 2243310 2243310 defendant Smyth James   757517 757517 Smyth, James, of Brunham 1
4648371 2245571 2245571 defendant Colyn John   757517 757517 Colyn, John, of Brunham 10
4656647 2247974 2247974 plaintiff Heyward Thomas   757517 757517 Heyward, Thomas, of Brunham 1
4656648 2247974 2247974 defendant Heyward John yeoman 757517 757517 Heyward, John, of Brunham, yeoman 0
4660513 2249112 2249112 defendant Bulwere Thomas butcher 757517 757517 Bulwere, Thomas, of Brunham, butcher 4
4670724 2256523 2256523 defendant Brogon Geoffrey yeoman 757517 757517 Brogon, Geoffrey, of Brunham, yeoman 0
4688081 2261843 2261843 plaintiff Syf John merchant 757517 757517 Syf, John, of Brunham, merchant, on his own account 0
4689495 2262271 2262271 plaintiff Vewetre Simon   757517 757517 Vewetre, Simon, of Brunham 0
4689497 2262271 2262271 defendant Teler John yeoman 757517 757517 Teler, John, of Brunham, yeoman 0
4699412 2265276 2265276 defendant Depham Thomas clerk 757517 757517 Depham, Thomas, of Brunham, clerk 0
4711144 2268840 2268840 defendant Wacy William   757517 757517 Wacy, William, of Brunham. husbandman 1
4711145 2268840 2268840 defendant Chalonere Thomas husbandman 757517 757517 Chalonere, Thomas, of Brunham, husbandman 2
4711146 2268840 2268840 defendant Depedale Robert husbandman 757517 757517 Depedale, Robert, of Brunham, husbandman 3
4712342 2269175 2269175 defendant Lawes Thomas clerk 757517 757517 Lawes, Thomas, of Brunham, clerk 0
4745644 2279239 2279239 defendant (not given) Robert prior of Chyve or Chyne 757517 757517 Chyve or Chyne, Robert, of Brunham, prior of the Carmelite order 0
4746124 2279362 2279362 defendant Fuller Robert yeoman 757517 757517 Fuller, Robert, of Brunham, yeoman 3
4746125 2279362 2279362 defendant Grogon Robert yeoman 757517 757517 Grogon, Robert, of Brunham, yeoman 4
4746126 2279362 2279362 defendant Creek Thomas clerk 757517 757517 Creek, Thomas, of Brunham, clerk 5
4844877 2309920 2309920 defendant Wetyng John clerk 757517 757517 Wetyng, John, of Brunham, clerk 2
4844882 2309920 2309920 defendant Sylk Thomas husbandman 757517 757517 Sylk, Thomas, of Brunham, husbandman 7
4865349 2316132 2316132 defendant Sylk Thomas butcher 757517 757517 Sylk, Thomas, of Brunham, butcher 1
4865354 2316133 2316133 defendant Seffrey Richard butcher 757517 757517 Seffrey, Richard, of Brunham, butcher 0
4865416 2316152 2316152 plaintiff Geyton William   757517 757517 Geyton, William, of Brunham 0
4865420 2316152 2316152 defendant Fuller Richard (legal representative) 757517 757517 Fuller, Richard, of Brunham, executors of 1
4865422 2316152 2316152 defendant Fuller Emma widow 757517 757517 Fuller, Emma, of Brunham, widow 3
4906332 2328568 2328568 defendant Lexham William gent 757517 757517 Lexham, William, of Brunham, gent 1
4918345 2332257 2332257 plaintiff Gygg Thomas   757517 757517 Gygg, Thomas, of Brunham 0
4918350 2332258 2332258 plaintiff Gygg Thomas   757517 757517 Gygg, Thomas, of Brunham 0
4919306 2332545 2332545 defendant Gygges Thomas gent 757517 757517 Gygges, Thomas, of Brunham, gent 1
4934823 2337290 2337290 plaintiff Barbour Gilbert   757517 757517 Barbour, Gilbert, of Brunham 0
4934824 2337290 2337290 defendant Patgrys Robert yeoman 757517 757517 Patgrys, Robert, of Brunham, yeoman 0
5005183 2358413 2358413 plaintiff Reynham Thomas de (legal representative) 757517 757517 Reynham, Thomas de, of Brunham, executors of 0
5075171 2379072 2379072 defendant Dalby William clerk 757517 757517 Dalby, William, of Brunham, or of Beston juxta Norwich, clerk 3
5114120 2390527 2390527 plaintiff London Roger   757517 757517 London, Roger, of Brunham 0
5124867 2393746 2393746 defendant Baxter Henry yeoman 757517 757517 Baxter, Henry, of Brunham, yeoman 2
5126972 2394368 2394368 defendant (not given) Edmund vicar of Bately 757517 757517 Bately, Edmund, of Brunham, perpetual vicar of St Clement's church, together with St Andrew's & North Walsham 1
5171586 2407410 2407410 plaintiff Lexam Margaret   757517 757517 Lexam, Margaret, of Brunham 0
5190104 2412851 2412851 plaintiff Lexham Margaret   757517 757517 Lexham, Margaret, of Brunham 0
5190108 2412852 2412852 plaintiff Lexham Margaret   757517 757517 Lexham, Margaret, of Brunham 0
5201254 2416121 2416121 defendant Baxster Henry yeoman 757517 757517 Baxster, Henry, of Brunham, yeoman 2
5206771 2417718 2417718 plaintiff Lexham Margaret   757517 757517 Lexham, Margaret, of Brunham 0
5211950 2419233 2419233 defendant Baxster Henry yeoman 757517 757517 Baxster, Henry, of Brunham, yeoman 2
5240045 2427290 2427290 defendant Antyngham William yeoman 757517 757517 Antyngham, William, of Brunham, yeoman 2
5241550 2427729 2427729 plaintiff London Roger   757517 757517 London, Roger, of Brunham 0
5272397 2436995 2436995 defendant Taffy Thomas husbandman 757517 757517 Taffy, Thomas, of Brunham, husbandman 1
5624406 2551576 2551576 defendant Scot John ploughman 757517 757517 Scot, John, of Brunham, ploughman 3
5624411 2551577 2551577 defendant Scot John ploughman 757517 757517 Scot, John, of Brunham, ploughman 3
5628205 2552779 2552779 defendant Smyth James   757517 757517 Smyth, James, of Brunham 3
5628206 2552779 2552779 defendant Wasy William yeoman 757517 757517 Wasy, William, of Brunham, yeoman 4
5632649 2554232 2554232 defendant Colyns John yeoman 757517 757517 Colyns, John, of Brunham, yeoman 5
5632650 2554232 2554232 defendant Fullere Robert yeoman 757517 757517 Fullere, Robert, of Brunham, yeoman 6
5633575 2554495 2554495 defendant Smyth John smith 757517 757517 Smyth, John, of Brunham, smith 0
5633576 2554495 2554495 defendant Smyth James smith 757517 757517 Smyth, James, of Brunham, smith 1
5634580 2554812 2554812 defendant Fullere Robert yeoman 757517 757517 Fullere, Robert, of Brunham, 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);