names

43 rows where place_id = 586982

✎ 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
3590138 1864553 1864553 defendant Bayly Robert yeoman 586982 586982 Bayly, Robert, of Algarkyrk, yeoman 0
4715872 2270278 2270278 defendant Warner William husbandman 586982 586982 Warner, William, of Algarkyrk, husbandman 2
4776329 2288590 2288590 defendant Hunyng Katherine widow 586982 586982 Hunyng, Katherine, of Algarkyrk, widow 0
4776330 2288590 2288590 defendant Abraham Robert   586982 586982 Abraham, Robert, of Algarkyrk, servant 1
4778663 2289310 2289310 defendant Arnald William husbandman 586982 586982 Arnald, William, of Algarkyrk, husbandman 0
4802064 2296831 2296831 defendant Touper Katherine widow 586982 586982 Touper, Katherine, of Algarkyrk, widow 0
4802066 2296831 2296831 defendant Hermod John husbandman 586982 586982 Hermod, John, of Algarkyrk, husbandman 2
4802067 2296831 2296831 defendant Bradenham John husbandman 586982 586982 Bradenham, John, of Algarkyrk, husbandman 3
4890393 2323763 2323763 defendant Hunnyng John husbandman 586982 586982 Hunnyng, John, of Algarkyrk, husbandman 1
4923554 2333800 2333800 defendant Adelyn William husbandman 586982 586982 Adelyn, William, of Algarkyrk, husbandman 2
4987613 2353257 2353257 defendant Gybon Alice widow 586982 586982 Gybon, Alice, of Algarkyrk, widow 0
5018669 2362349 2362349 defendant London Thomas husbandman 586982 586982 London, Thomas, of Algarkyrk, husbandman 3
5025888 2364468 2364468 defendant Chosell Thomas husbandman 586982 586982 Chosell, Thomas, of Algarkyrk, husbandman 0
5025890 2364468 2364468 defendant Bate John husbandman 586982 586982 Bate, John, of Algarkyrk, husbandman 2
5027824 2365018 2365018 defendant Bullok John husbandman 586982 586982 Bullok, John, of Algarkyrk, husbandman 0
5031303 2366012 2366012 defendant London Thomas husbandman 586982 586982 London, Thomas, of Algarkyrk, husbandman 3
5094104 2384677 2384677 plaintiff Roberd William husbandman 586982 586982 Roberd, William, of Algarkyrk, husbandman 0
5098718 2386054 2386054 defendant Hunnyng Simon husbandman 586982 586982 Hunnyng, Simon, of Algarkyrk, husbandman 0
5098720 2386055 2386055 defendant Pulvertofte Thomas husbandman 586982 586982 Pulvertofte, Thomas, of Algarkyrk, husbandman 0
5098721 2386055 2386055 defendant Hunnyng Simon husbandman 586982 586982 Hunnyng, Simon, of Algarkyrk, husbandman 1
5112321 2389991 2389991 defendant Crabdam John husbandman 586982 586982 Crabdam, John, of Algarkyrk, husbandman 0
5118486 2391842 2391842 defendant London William laborer 586982 586982 London, William, of Algarkyrk, laborer 2
5118490 2391843 2391843 defendant London William   586982 586982 London, William, of Algarkyrk, laborer, son of Thomas 2
5157210 2403250 2403250 defendant Prykfeld Thomas gent 586982 586982 Prykfeld, Thomas, of Algarkyrk, gent 0
5173210 2407877 2407877 defendant Prykfeld Thomas gent 586982 586982 Prykfeld, Thomas, of Algarkyrk, gent 0
5229690 2424304 2424304 defendant Hunnyng Simon (legal representative) 586982 586982 Hunnyng, Simon, of Algarkyrk, yeoman, executors of 1
5229691 2424304 2424304 defendant Slye John gent 586982 586982 (Slye, John, of Algarkyrk, gent 2
5229692 2424304 2424304 defendant Pery John husbandman 586982 586982 Pery, John, of Algarkyrk, husbandman 3
5229693 2424304 2424304 defendant Baylly Robert husbandman 586982 586982 Baylly, Robert, of Algarkyrk, husbandman 4
5297203 2444178 2444178 defendant Gybbon Thomas husbanman 586982 586982 Gybbon, Thomas, of Algarkyrk, husbanman 2
5308505 2447580 2447580 plaintiff Seggefeld Thomas chaplain 586982 586982 Seggefeld, Thomas, of Algarkyrk, chaplain 0
5314804 2449472 2449472 defendant Andrewe John husbandman 586982 586982 Andrewe, John, of Algarkyrk, husbandman 0
5330699 2454259 2454259 defendant Crabdam William husbandman 586982 586982 Crabdam, William, of Algarkyrk, husbandman 1
5344710 2458519 2458519 defendant Smyth John husbandman 586982 586982 Smyth, John, of Algarkyrk, husbandman 4
5351703 2460633 2460633 defendant Baly Robert husbandman 586982 586982 Baly, Robert, of Algarkyrk, husbandman 0
5353202 2461077 2461077 defendant Toby Elizabeth widow 586982 586982 Toby, Elizabeth, of Algarkyrk, widow 1
5353203 2461077 2461077 defendant Toby William husbandman 586982 586982 Toby, William, of Algarkyrk, husbandman 2
5363216 2464150 2464150 defendant Welby Thomas gent 586982 586982 Welby, Thomas, of Algarkyrk, gent 1
5377843 2468649 2468649 defendant Michell Robert yeoman 586982 586982 Michell, Robert, of Algarkyrk, yeoman 13
5377858 2468650 2468650 defendant Michell Robert yeoman 586982 586982 Michell, Robert, of Algarkyrk, yeoman 13
5520310 2511171 2511171 defendant Feld Athelard   586982 586982 Feld, Athelard, of Algarkyrk, gent, administrators of 0
5520311 2511171 2511171 defendant Tasker Thomas yeoman 586982 586982 (Tasker, Thomas, of Algarkyrk, yeoman 1
5570436 2525922 2525922 defendant Stevynson John husbandman 586982 586982 Stevynson, John, of Algarkyrk, husbandman 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);