names

72 rows where place_id = 620035

✎ 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
3733304 1936649 1936649 plaintiff Nevyle Robert clerk 620035 620035 Nevyle, Robert, of Roderham, clerk 2
3733324 1936653 1936653 plaintiff Nevyle Robert clerk 620035 620035 Nevyle, Robert, of Roderham, clerk 2
3779168 1951207 1951207 plaintiff Nevyle Robert clerk 620035 620035 Nevyle, Robert, of Roderham, clerk 2
3828564 1966809 1966809 defendant Tompson William cutler 620035 620035 Tompson, William, of Roderham, cutler 1
3828565 1966809 1966809 defendant Lynley Richard roper 620035 620035 Lynley, Richard, of Roderham, roper 2
3837413 1969612 1969612 defendant Wilson Robert butcher 620035 620035 Wilson, Robert, of Roderham, butcher 1
3838038 1969808 1969808 defendant Lytster Robert barker 620035 620035 Lytster, Robert, of Roderham, barker 2
4433358 2175187 2175187 defendant Pronotte John   620035 620035 Pronotte, John, of Roderham 1
4450675 2185170 2185170 defendant Adlastre Nicholas   620035 620035 Adlastre, Nicholas, of Roderham 1
4455200 2186630 2186630 plaintiff Merkesburgh John de   620035 620035 Merkesburgh, John de, of Roderham 0
4458608 2187739 2187739 defendant Bakester Thomas   620035 620035 Bakester, Thomas, of Roderham 0
4470716 2191490 2191490 plaintiff Bugg Robert   620035 620035 Bugg, Robert, of Roderham 0
4484433 2195824 2195824 defendant Ponay Ralph   620035 620035 Ponay, Ralph, of Roderham 0
4510450 2203726 2203726 defendant Bug Robert   620035 620035 Bug, Robert, of Roderham 0
4533393 2210712 2210712 defendant Staynforde John skinner 620035 620035 Staynforde, John, of Roderham, skinner 0
4544120 2214075 2214075 defendant Loseland John   620035 620035 Loseland, John, of Roderham 2
4545983 2214681 2214681 defendant Pondy Ralph   620035 620035 Pondy, Ralph, of Roderham 0
4589718 2228149 2228149 defendant Skynner John   620035 620035 Skynner, John, of Roderham 0
4590246 2228320 2228320 defendant Povay Ralph   620035 620035 Povay, Ralph, of Roderham 0
4616732 2236233 2236233 defendant del Hill John dyer 620035 620035 del Hill, John, of Roderham, dyer 0
4617095 2236354 2236354 defendant Bakester John   620035 620035 Bakester, John, of Roderham 0
4631121 2240631 2240631 defendant Baddesworth William   620035 620035 Baddesworth, William, of Roderham 3
4636396 2242220 2242220 defendant Walker John   620035 620035 Walker, John, of Roderham 1
4654824 2247386 2247386 defendant del Hall John dyer 620035 620035 del Hall, John, of Roderham, dyer 0
4663032 2249904 2249904 defendant Lyster John dyer 620035 620035 Lyster, John, of Roderham, dyer 1
4741609 2278041 2278041 defendant Willus John dyer 620035 620035 Willus, John, of Roderham, dyer 0
4814944 2300784 2300784 defendant Willose John chapman 620035 620035 Willose, John, of Roderham, chapman 0
4814945 2300784 2300784 defendant Mersburhg Simonm   620035 620035 Mersburhg, Simonm, of Roderham 1
4865951 2316325 2316325 defendant Lorde John yeoman 620035 620035 Lorde, John, of Roderham, yeoman 0
4865959 2316326 2316326 defendant Lorde John   620035 620035 Lorde, John, of Roderham, yeoman Middelwode, Richard, of Barleburgh, parish clerk 1
4865965 2316327 2316327 defendant Lorde John yeoman 620035 620035 together with Lorde, John, of Roderham, yeoman 1
4868228 2317041 2317041 defendant del Barneby Hugh husbandman 620035 620035 del Barneby, Hugh, of Roderham, husbandman 0
4880565 2320834 2320834 defendant Lorde John   620035 620035 Lorde, John, of Roderham, yeoman Middelwode, Richard, of Barleburgh, parish clerk 1
4880571 2320835 2320835 defendant Lorde John yeoman 620035 620035 together with Lorde, John, of Roderham, yeoman 1
4880577 2320836 2320836 defendant Lorde John yeoman 620035 620035 Lorde, John, of Roderham, yeoman 0
4888706 2323257 2323257 defendant Belgh Richard chaplain 620035 620035 Belgh, Richard, of Roderham, chaplain 3
4898860 2326286 2326286 defendant West John yeoman 620035 620035 West, John, of Roderham, yeoman 2
4900421 2326776 2326776 plaintiff Weste John   620035 620035 Weste, John, of Roderham 0
4901513 2327077 2327077 plaintiff Weste John   620035 620035 Weste, John, of Roderham 0
4910527 2329806 2329806 plaintiff Bolton Agnes (legal representative) 620035 620035 Bolton, Agnes, of Roderham, executors of 0
4910530 2329806 2329806 defendant Bolton Agnes (legal representative) 620035 620035 Bolton, Agnes, of Roderham, executors of 0
4918547 2332317 2332317 defendant Hynkersell Robert gent 620035 620035 Hynkersell, Robert, of Roderham, gent 2
4927359 2334989 2334989 defendant White Thomas draper 620035 620035 White, Thomas, of Roderham, draper 0
4945138 2340460 2340460 plaintiff Hill Robert   620035 620035 Hill, Robert, of Roderham 0
4953064 2342885 2342885 plaintiff Scot Richard (legal representative) 620035 620035 Scot, Richard, of Roderham, executors of 0
4953069 2342886 2342886 plaintiff Scot Richard (legal representative) 620035 620035 Scot, Richard, of Roderham, executors of 0
5010834 2360022 2360022 defendant Brampton Robert husbandman 620035 620035 Brampton, Robert, of Roderham, husbandman 0
5031588 2366102 2366102 defendant Coket William baker 620035 620035 Coket, William, of Roderham, baker 1
5046759 2370653 2370653 defendant Wolhous William yeoman 620035 620035 Wolhous, William, of Roderham, yeoman 0
5052376 2372308 2372308 defendant of the Hill William shoemaker 620035 620035 of the Hill, William, of Roderham, shoemaker 3
5072348 2378216 2378216 defendant Held William baker 620035 620035 Held, William, of Roderham, baker 1
5103683 2387502 2387502 defendant Kilburn William weaver 620035 620035 Kilburn, William, of Roderham, weaver 0
5141591 2398651 2398651 defendant Silvestre John, junior   620035 620035 Silvestre, John, junior, of Roderham, coverlet weaver 4
5216482 2420551 2420551 defendant Pye John barker 620035 620035 Pye, John, of Roderham, barker 0
5240716 2427496 2427496 defendant Fleccher Richard yeoman 620035 620035 Fleccher, Richard, of Roderham, yeoman 0
5240717 2427496 2427496 defendant Stok John yeoman 620035 620035 Stok, John, of Roderham, yeoman 1
5240718 2427496 2427496 defendant Jelot William yeoman 620035 620035 Jelot, William, of Roderham, yeoman 2
5240723 2427496 2427496 defendant Hervy Henry yeoman 620035 620035 Hervy, Henry, of Roderham, yeoman 7
5292182 2442709 2442709 defendant Yorshire Richard butcher 620035 620035 Yorshire, Richard, of Roderham, butcher 0
5310673 2448229 2448229 defendant Haukesworth Alice (legal representative) 620035 620035 Haukesworth, Alice, of Roderham, widow, executor of 0
5311095 2448350 2448350 defendant Haukesworth Alice (legal representative) 620035 620035 Haukesworth, Alice, of Roderham, widow, executor of 0
5330769 2454274 2454274 defendant Benet Robert yeoman 620035 620035 Benet, Robert, of Roderham, yeoman 0
5380369 2469435 2469435 defendant Coull John chapman 620035 620035 Coull, John, of Roderham, chapman 1
5384949 2470768 2470768 defendant Coull John chapman 620035 620035 Coull, John, of Roderham, chapman 1
5397002 2474223 2474223 defendant Coull John chapman 620035 620035 Coull, John, of Roderham, chapman 1
5397009 2474224 2474224 defendant Coull John chapman 620035 620035 Coull John, of Roderham, chapman 1
5433492 2484977 2484977 defendant Gurry William yeoman 620035 620035 Gurry, William, of Roderham, yeoman 4
5468459 2495506 2495506 defendant Caume John yeoman 620035 620035 Caume, John, of Roderham, yeoman 0
5511998 2508610 2508610 plaintiff Lilly Robert   620035 620035 Lilly, Robert, of Roderham 0
5512138 2508659 2508659 plaintiff Lylly Robert   620035 620035 Lylly, Robert, of Roderham 0
5629282 2553135 2553135 defendant Storrer William husbandman 620035 620035 Storrer, William, of Roderham, husbandman 0
5635573 2555087 2555087 plaintiff West John   620035 620035 West, John, of Roderham 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);