names

64 rows where place_id = 586154

✎ 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
3588045 1863913 1863913 defendant Harlyng Thomas husbandman 586154 586154 (Harlyng, Thomas, of Magna Elyngham, husbandman 1
3591508 1864970 1864970 defendant Buske John husbandman 586154 586154 Buske, John, of Magna Elyngham, husbandman 0
3606064 1869563 1869563 defendant Couper Robertm husbandman 586154 586154 Couper, Robertm, of Magna Elyngham, husbandman 0
3606065 1869563 1869563 defendant Bryse John husbandman 586154 586154 Bryse, John, of Magna Elyngham, husbandman 1
3606066 1869563 1869563 defendant Cade John, senior husbandman 586154 586154 Cade, John, senior, of Magna Elyngham, husbandman 2
3625182 1875412 1875412 plaintiff Welles John, senior (legal representative) 586154 586154 Welles, John, senior, of Magna Elyngham, executors of 0
3625185 1875412 1875412 defendant Mynnes Richard butcher 586154 586154 Mynnes, Richard, of Magna Elyngham, butcher 0
3629946 1904222 1904222 defendant Mellys Robert husbandman 586154 586154 Mellys, Robert, of Magna Elyngham, husbandman 1
3674873 1918169 1918169 defendant Fenne Thomas husbandman 586154 586154 Fenne, Thomas, of Magna Elyngham, husbandman 1
3710829 1929704 1929704 defendant Webster William husbandman 586154 586154 Webster, William, of Magna Elyngham, husbandman 2
3740808 1938983 1938983 plaintiff Seman Nicholas (legal representative) 586154 586154 Seman, Nicholas, of Magna Elyngham, executor of 0
3740812 1938983 1938983 defendant Seman Margaret widow 586154 586154 Seman, Margaret, of Magna Elyngham, widow 2
3750243 1941993 1941993 defendant Borell John   586154 586154 Borell, John, of Magna Elyngham, shepherd 2
3755828 1943774 1943774 defendant Burman John husbandman 586154 586154 Burman, John, of of Magna Elyngham, husbandman 3
3760980 1945438 1945438 defendant Yonges Richard weaver 586154 586154 Yonges, Richard, of Magna Elyngham, weaver 0
3760981 1945438 1945438 defendant Elden William turner 586154 586154 Elden, William, of Magna Elyngham, turner 1
3775179 1949969 1949969 defendant Webster William husbandman 586154 586154 Webster, William, of Magna Elyngham, husbandman 0
3775180 1949969 1949969 defendant Webster John laborer 586154 586154 Webster, John, of Magna Elyngham, laborer 1
3835460 1969030 1969030 defendant Duffeld John butcher 586154 586154 Duffeld, John, of Magna Elyngham, butcher 0
3914375 1995150 1995150 plaintiff Cady Richard   586154 586154 Cady, Richard, of Magna Elyngham 0
3914377 1995151 1995151 plaintiff Cady Richard   586154 586154 Cady, Richard, of Magna Elyngham 0
3976997 2016521 2016521 defendant Cowper Robert baker 586154 586154 Cowper, Robert, of Magna Elyngham, baker 0
4030361 2035511 2035511 defendant Floorye John sawyer 586154 586154 Floorye, John, of Magna Elyngham, sawyer 0
4069055 2049223 2049223 defendant Howse Robert husbandman 586154 586154 Howse, Robert, of Magna Elyngham, husbandman 0
4652344 2246685 2246685 defendant Goodhale John husbandman 586154 586154 Goodhale, John, of Magna Elyngham, husbandman 1
4657559 2248254 2248254 defendant Galyon Peter yeoman 586154 586154 Galyon, Peter, of Magna Elyngham, yeoman 5
4658745 2248608 2248608 defendant Fulcher John   586154 586154 Fulcher, John, of Magna Elyngham, Norf, ploughman, his son 4
4663832 2250172 2250172 plaintiff Grene John   586154 586154 Grene, John, of Magna Elyngham 0
4665247 2250619 2250619 defendant atte Hill Thomas husbandman 586154 586154 atte Hill, Thomas, of Magna Elyngham, husbandman 0
4665248 2250619 2250619 defendant Mannyng Walter yeoman 586154 586154 Mannyng, Walter, of Magna Elyngham, yeoman 1
4665250 2250619 2250619 defendant atte Castell John husbandman 586154 586154 atte Castell, John, of Magna Elyngham, husbandman 3
4665251 2250619 2250619 defendant Aleyn John yeoman 586154 586154 Aleyn, John, of Magna Elyngham, yeoman 4
4788570 2292484 2292484 defendant Gaubriell John husbandman 586154 586154 Gaubriell, John, of Magna Elyngham, husbandman 0
4791715 2293505 2293505 plaintiff Mannyng John   586154 586154 Mannyng, John, of Magna Elyngham 0
4791718 2293506 2293506 plaintiff Mannyng John   586154 586154 Mannyng, John, of Magna Elyngham 0
4802035 2296821 2296821 defendant Whytyng William yeoman 586154 586154 Whytyng, William, of Magna Elyngham, yeoman 1
4886577 2322666 2322666 defendant Mannyng Thomas gent 586154 586154 Mannyng, Thomas, of Magna Elyngham, gent 1
4891875 2324192 2324192 defendant Mannyng Thomas gent 586154 586154 Mannyng, Thomas, of Magna Elyngham, gent 1
4898521 2326187 2326187 defendant Mannyng John (legal representative) 586154 586154 Mannyng, John, of Magna Elyngham, executor of 0
4904639 2328059 2328059 defendant Mannyng Thomas gent 586154 586154 Mannyng, Thomas, of Magna Elyngham, gent 1
4974051 2349202 2349202 plaintiff Mannyng John (legal representative) 586154 586154 Mannyng, John, of Magna Elyngham, executor of 0
4974741 2349412 2349412 defendant Sweteman John husbandman 586154 586154 Sweteman, John, of Magna Elyngham, husbandman 3
4980476 2351098 2351098 defendant Layte Roger barker 586154 586154 Layte, Roger, of Magna Elyngham, barker 0
5022219 2363392 2363392 defendant Swetman John husbandman 586154 586154 Swetman, John, of Magna Elyngham, husbandman 0
5059290 2374343 2374343 defendant Eyre John husbandman 586154 586154 Eyre, John, of Magna Elyngham, husbandman 1
5071145 2377863 2377863 defendant Fullere John butcher 586154 586154 Fullere, John, of Magna Elyngham, butcher 1
5084380 2381839 2381839 defendant Mannyng Thomas esq 586154 586154 Mannyng, Thomas, of Magna Elyngham, esq 0
5084381 2381839 2381839 defendant Marchall John yeoman 586154 586154 Marchall, John, of Magna Elyngham, yeoman 1
5092585 2384208 2384208 defendant Dorant Hugh husbandman 586154 586154 Dorant, Hugh, of Magna Elyngham, husbandman 0
5113939 2390464 2390464 defendant Gerard John husbandman 586154 586154 Gerard, John, of Magna Elyngham, husbandman 3
5120088 2392313 2392313 defendant Weke John husbandman 586154 586154 Weke, John, of Magna Elyngham, husbandman 0
5222151 2422184 2422184 plaintiff Marchall Richard   586154 586154 Marchall, Richard, of Magna Elyngham 0
5483277 2499945 2499945 plaintiff Kemp Robert   586154 586154 Kemp, Robert, of Magna Elyngham 0
5504719 2506393 2506393 defendant Hardyng Thomas husbandman 586154 586154 (Hardyng, Thomas, of Magna Elyngham, husbandman 5
5549927 2520014 2520014 defendant Bryan John husbandman 586154 586154 Bryan, John, of Magna Elyngham, husbandman 2
5552549 2520802 2520802 defendant Crosse John weaver 586154 586154 Crosse, John, of Magna Elyngham, weaver 0
5552550 2520802 2520802 defendant Godewyn Walter husbandman 586154 586154 Godewyn, Walter, of Magna Elyngham, husbandman 1
5562412 2523605 2523605 defendant Dole Simon scrivener 586154 586154 Dole, Simon, of Magna Elyngham, scrivener 0
5562760 2523695 2523695 defendant Ocle Simon scrivener 586154 586154 Ocle, Simon, of Magna Elyngham, scrivener 0
5581618 2529328 2529328 defendant Bryan John yeoman 586154 586154 Bryan, John, of Magna Elyngham, yeoman 0
5584437 2530196 2530196 defendant Mollys Robert smith 586154 586154 Mollys, Robert, of Magna Elyngham, smith 4
5596171 2533718 2533718 defendant Mollys Robert husbandman 586154 586154 Mollys, Robert, of Magna Elyngham, husbandman 2
5596347 2533768 2533768 defendant Molle Robert smith 586154 586154 Molle, Robert, of Magna Elyngham, smith 1
5607970 2537399 2537399 defendant Herward Robert gent 586154 586154 Herward, Robert, of Magna Elyngham, gent 1

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