names

52 rows where place_id = 615415

✎ 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
3650351 1910486 1910486 defendant Coo John   615415 615415 Coo, John, of Coggeshall, yeoman, son of Coo, Thomas 0
3708786 1929041 1929041 defendant Nicholas John laborer 615415 615415 Nicholas, John, of Coggeshall, laborer 7
3718073 1931948 1931948 defendant Paynemer Robert fuller 615415 615415 Paynemer, Robert, of Coggeshall, fuller 0
3741255 1939123 1939123 defendant Hall Robert clerk 615415 615415 Hall, Robert, of Coggeshall, clerk 0
3756716 1944073 1944073 defendant Oryff alias Rowse Nicholas butcher 615415 615415 Oryff alias Rowse, Nicholas, of Coggeshall, butcher 2
3762577 1945942 1945942 defendant Seman Thomas yeoman 615415 615415 Seman, Thomas, of Coggeshall, yeoman 0
3848643 1973159 1973159 defendant Mylys Robert grocer 615415 615415 Mylys, Robert, of Coggeshall, grocer 0
3907599 1992831 1992831 defendant Cole John husbandman 615415 615415 Cole, John, of Coggeshall, husbandman 1
3948167 2006422 2006422 defendant Lytherlande Robert clothier 615415 615415 Lytherlande, Robert, of Coggeshall, clothier 0
3948168 2006422 2006422 defendant Rame or Ramme William clothier 615415 615415 Rame or Ramme, William, of Coggeshall, clothier 1
3948178 2006425 2006425 defendant Porter John clothier 615415 615415 Porter, John, of Coggeshall, clothier 0
3948181 2006426 2006426 defendant Torrell Thomas clothier 615415 615415 Torrell, Thomas, of Coggeshall, clothier 0
3948188 2006428 2006428 defendant Enewe Elizabeth widow 615415 615415 Enewe, Elizabeth, of Coggeshall, widow 1
3965686 2012614 2012614 defendant Colman Robert clothier 615415 615415 Colman, Robert, of Coggeshall, clothier 0
3965687 2012614 2012614 defendant Copsheffe George clothier 615415 615415 Copsheffe, George, of Coggeshall, clothier 1
3969853 2014058 2014058 defendant Hales Henry tailor 615415 615415 Hales, Henry, of Coggeshall, tailor 3
3969856 2014059 2014059 defendant Jeggyns Roger clothier 615415 615415 Jeggyns, Roger, of Coggeshall, clothier 0
3969857 2014059 2014059 defendant Ryse Peter clothier 615415 615415 Ryse, Peter, of Coggeshall, clothier 1
3969860 2014060 2014060 defendant Tyll Thomas clothier 615415 615415 Tyll, Thomas, of Coggeshall, clothier 0
3969861 2014060 2014060 defendant Clarke William clothier 615415 615415 Clarke, William, of Coggeshall, clothier 1
3985346 2019517 2019517 plaintiff Tyrrell Thomas   615415 615415 Tyrrell, Thomas, of Coggeshall clothier 0
3985348 2019518 2019518 plaintiff Tyrrell Thomas clothier 615415 615415 Tyrrell, Thomas, of Coggeshall, clothier 0
4169024 2084660 2084660 defendant Browne Thomas dyer 615415 615415 Browne, Thomas, of Coggeshall, dyer 0
4169026 2084661 2084661 defendant Browne Thomas dyer 615415 615415 Browne, Thomas, of Coggeshall, dyer 0
4171541 2085511 2085511 defendant Cooke Jonah clothier 615415 615415 Cooke, Jonah, of Coggeshall, clothier 0
4188646 2091510 2091510 defendant Saunders John yeoman 615415 615415 Saunders, John, of Coggeshall, yeoman 0
4202450 2096398 2096398 defendant Browne Thomas dyer 615415 615415 Browne, Thomas, of Coggeshall, dyer 1
4217192 2101508 2101508 defendant Todd Richard tanner 615415 615415 Todd, Richard, of Coggeshall, tanner 0
4231818 2106626 2106626 defendant Saunder William yeoman 615415 615415 Saunder, William, of Coggeshall, yeoman 0
4239245 2109350 2109350 defendant Digby William grocer 615415 615415 Digby, William, of Coggeshall, grocer 0
4239246 2109350 2109350 defendant Graye Robert clothier 615415 615415 Graye, Robert, of Coggeshall, clothier 1
4282381 2123738 2123738 defendant Colman Robert clothier 615415 615415 Colman, Robert, of Coggeshall, yeoman, clothier 0
4282382 2123738 2123738 defendant Rise Peter clothier 615415 615415 Rise, Peter, of Coggeshall, clothier 1
4390107 2161311 2161311 defendant Todd Gregory haberdasher 615415 615415 Todd, Gregory, of Coggeshall, haberdasher 2
4393086 2162297 2162297 defendant Saunders Agnes   615415 615415 Saunders, Agnes, of Coggeshall widow 1
4393091 2162298 2162298 defendant Saunders John clothmaker 615415 615415 Saunders, John, of Coggeshall, clothmaker 1
4715895 2270285 2270285 defendant fitz William William gent 615415 615415 fitz William, William, of Coggeshall, gent 0
4773367 2287646 2287646 defendant Sayer Thomas dyer 615415 615415 Sayer, Thomas, of Coggeshall, dyer 0
5155040 2402628 2402628 defendant Barbour John barber 615415 615415 Barbour, John, of Coggeshall, barber 0
5290990 2442367 2442367 plaintiff Paycok John, junior   615415 615415 Paycok, John, junior, of Coggeshall 0
5386151 2471107 2471107 defendant Panell Thomas yeoman 615415 615415 Panell, Thomas, of Coggeshall, yeoman 0
5386152 2471107 2471107 defendant Sponer Thomas yeoman 615415 615415 Sponer, Thomas, of Coggeshall, yeoman 1
5398421 2474612 2474612 defendant Panell Thomas yeoman 615415 615415 Panell, Thomas, of Coggeshall, yeoman 0
5398422 2474612 2474612 defendant Sponer Thomas yeoman 615415 615415 Sponer, Thomas, of Coggeshall, yeoman 1
5425853 2482697 2482697 defendant Panell Thomas husbandman 615415 615415 Panell, Thomas, of Coggeshall, husbandman 0
5425854 2482697 2482697 defendant Sponer Thomas yeoman 615415 615415 Sponer, Thomas, of Coggeshall, yeoman 1
5506401 2506912 2506912 defendant Rery William fuller 615415 615415 Rery, William, of Coggeshall, fuller 0
5506402 2506912 2506912 defendant Aylward John fuller 615415 615415 Aylward, John, of Coggeshall, fuller 1
5506403 2506912 2506912 defendant Aylward Edwrd fuller 615415 615415 Aylward, Edwrd, of Coggeshall, fuller 2
5506404 2506912 2506912 defendant Chapman John weaver 615415 615415 Chapman, John, of Coggeshall, weaver 3
5534823 2515431 2515431 defendant Clerk John clothmaker 615415 615415 Clerk, John, of Coggeshall, clothmaker 1
5596112 2533699 2533699 defendant Rande Edward dyer 615415 615415 Rande, Edward, of Coggeshall, dyer 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);