names

43 rows where place_id = 588281

✎ 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
3592777 1865352 1865352 defendant Crasse Marmaduke yeoman 588281 588281 Crasse, Marmaduke, of Wyngfeld, household of Duke of Suffolk, yeoman 3
3593974 1865755 1865755 defendant Carter Thomas carpenter 588281 588281 Carter, Thomas, of Wyngfeld, carpenter 0
3628744 1903869 1903869 defendant Wolnawe Robert yeoman 588281 588281 Wolnawe, Robert, of Wyngfeld, yeoman 0
3650141 1910414 1910414 defendant Heryng William carpenter 588281 588281 Heryng, William, of Wyngfeld, carpenter 0
3680081 1919835 1919835 defendant Cotton Henry smith 588281 588281 Cotton, Henry, of Wyngfeld, smith 0
3712912 1930359 1930359 defendant Wrythok John husbandman 588281 588281 Wrythok, John, of Wyngfeld, husbandman 1
3763571 1946240 1946240 defendant Clarke Robert husbandman 588281 588281 Clarke, Robert, of Wyngfeld, husbandman 1
3789361 1954493 1954493 defendant Harpor John husbandman 588281 588281 Harpor, John, of Wyngfeld, husbandman 1
3810041 1961029 1961029 defendant Dey Thomas clerk 588281 588281 Dey, Thomas, of Wyngfeld, clerk 0
3836653 1969366 1969366 defendant Thomson Robert clerk 588281 588281 Thomson, Robert, of Wyngfeld, clerk 2
3841536 1970933 1970933 defendant Alger John yeoman 588281 588281 Alger, John, of Wyngfeld, yeoman 1
3850211 1973658 1973658 defendant Harvy Thomas husbandman 588281 588281 Harvy, Thomas, of Wyngfeld, husbandman 3
3858158 1976206 1976206 defendant Alger John yeoman 588281 588281 Alger, John, of Wyngfeld, yeoman 3
3864710 1978391 1978391 defendant Coole William baker and brewer 588281 588281 Coole, William, of Wyngfeld, baker and brewer 0
3868954 1979858 1979858 defendant Powle Peter husbandman 588281 588281 Powle, Peter, of Wyngfeld, husbandman 0
3868955 1979858 1979858 defendant Todde Reginald weaver 588281 588281 Todde, Reginald, of Wyngfeld, weaver 1
3868956 1979858 1979858 defendant Coke John husbandman 588281 588281 Coke, John, of Wyngfeld, husbandman 2
3882781 1984504 1984504 defendant Powle Peter husbandman 588281 588281 Powle, Peter, of Wyngfeld, husbandman 0
3882782 1984504 1984504 defendant Todde Reginald weaver 588281 588281 Todde, Reginald, of Wyngfeld, weaver 1
3882783 1984504 1984504 defendant Coke John husbandman 588281 588281 Coke, John, of Wyngfeld, husbandman 2
3897692 1989436 1989436 defendant Palmer Stephen husbandman 588281 588281 Palmer, Stephen, of Wyngfeld, husbandman 0
3952341 2007890 2007890 plaintiff Heringe Thomas yeoman 588281 588281 Heringe, Thomas, of Wyngfeld, yeoman 0
3954871 2008770 2008770 defendant Manne William tailor 588281 588281 Manne, William, of Wyngfeld, tailor 0
3956482 2009332 2009332 defendant Carvell alias Wright Henry husbandman 588281 588281 Carvell alias Wright, Henry, of Wyngfeld, husbandman 0
4386375 2160122 2160122 defendant Ellys John husbandman 588281 588281 Ellys, John, of Wyngfeld, husbandman 0
4440441 2181924 2181924 defendant Littelfeld Richard   588281 588281 Littelfeld, Richard, of Wyngfeld 1
4457804 2187455 2187455 defendant Typtot Ellis   588281 588281 Typtot, Ellis, of Wyngfeld 0
4855111 2312948 2312948 defendant Roger John   588281 588281 Roger, John, of Wyngfeld, servant 4
5078443 2380051 2380051 defendant Cotton alias Lardener John   588281 588281 Cotton alias Lardener, John, of Wyngfeld, draper, exectutor of 0
5078444 2380051 2380051 defendant Cotton William yeoman 588281 588281 Cotton, William, of Wyngfeld, yeoman 1
5088277 2382946 2382946 defendant Scot Richard husbandman 588281 588281 Scot, Richard, of Wyngfeld, husbandman 2
5256895 2432286 2432286 defendant Scot Robert husbandman 588281 588281 Scot, Robert, of Wyngfeld, husbandman 0
5314430 2449342 2449342 defendant Bedston William gent 588281 588281 Bedston, William, of Wyngfeld, gent 2
5341473 2457525 2457525 defendant Kent John yeoman 588281 588281 Kent, John, of Wyngfeld, yeoman 0
5374324 2467573 2467573 defendant Warner John yeoman 588281 588281 Warner, John, of Wyngfeld, yeoman 0
5422603 2481712 2481712 defendant Plomer John chaplain 588281 588281 Plomer, John, of Wyngfeld, chaplain 1
5508644 2507569 2507569 defendant Wrythokke John, junior tailor 588281 588281 Wrythokke, John, junior, of Wyngfeld, tailor 2
5529361 2513697 2513697 defendant Williams John yeoman 588281 588281 Williams, John, of Wyngfeld, yeoman 1
5541240 2517380 2517380 defendant Whythed Edmund yeoman 588281 588281 Whythed, Edmund, of Wyngfeld, yeoman 2
5541242 2517380 2517380 defendant Robynson William yeoman 588281 588281 Robynson, William, of Wyngfeld, yeoman 4
5541243 2517380 2517380 defendant Sleyter John yeoman 588281 588281 Sleyter, John, of Wyngfeld, yeoman 5
5582256 2529523 2529523 defendant Conwold William tailor 588281 588281 Conwold, William, of Wyngfeld, tailor 1
5595537 2533551 2533551 defendant Heryng William husbandman 588281 588281 Heryng, William, of Wyngfeld, husbandman 2

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