names

35 rows where place_id = 680310

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4039951 2038910 2038910 plaintiff Mason Adam yeoman 680310 680310 Mason, Adam, of Hindringham, yeoman 0
4039952 2038910 2038910 defendant Davye William yeoman 680310 680310 Davye, William, of Hindringham, yeoman 0
4040089 2038955 2038955 plaintiff Maye Christopher husbandman 680310 680310 Maye, Christopher, of Hindringham, husbandman 0
4070515 2049747 2049747 defendant Bedingfeld Edmund esq 680310 680310 Bedingfeld, Edmund, of Hindringham, esq 0
4103588 2061567 2061567 defendant Clarke John laborer 680310 680310 Clarke, John, of Hindringham, laborer 1
4242557 2110507 2110507 defendant Clarke George yeoman 680310 680310 Clarke, George, of Hindringham, yeoman 1
4242562 2110508 2110508 defendant Clarke George yeoman 680310 680310 Clarke, George, of Hindringham, yeoman 1
4244635 2111191 2111191 defendant Morley John husbandman 680310 680310 Morley, John, of Hindringham, husbandman 0
4244636 2111191 2111191 defendant Clarke George husbandman 680310 680310 Clarke, George, of Hindringham, husbandman 1
4269707 2119458 2119458 defendant Manne Henry (legal representative) 680310 680310 Manne, Henry, of Hindringham, husbandman, executors of 0
4275622 2121417 2121417 defendant Weston William clerk 680310 680310 Weston, William, of Hindringham, clerk 1
4288436 2125912 2125912 defendant Reade Thomas yeoman 680310 680310 Reade, Thomas, of Hindringham, yeoman 1
4311919 2134305 2134305 defendant Weston William clerk 680310 680310 Weston, William, of Hindringham, clerk 1
4311970 2134322 2134322 defendant Weston William clerk 680310 680310 Weston, William, of Hindringham, clerk 1
4311981 2134326 2134326 defendant Hasting Thomas gent 680310 680310 Hasting, Thomas, of Hindringham, gent 0
4311982 2134326 2134326 defendant Aylyard Simon husbandman 680310 680310 Aylyard, Simon, of Hindringham, husbandman 1
4316922 2136033 2136033 defendant Weston William clerk 680310 680310 Weston, William, of Hindringham, clerk 1
4316980 2136053 2136053 defendant Godfrey Owen chapman 680310 680310 Godfrey, Owen, of Hindringham, chapman 2
4316981 2136053 2136053 defendant Godfrey   widow 680310 680310 Godfrey, , of Hindringham, widow 3
4317195 2136126 2136126 defendant Manne Henry (legal representative) 680310 680310 Manne, Henry, of Hindringham, husbandman, executors of 0
4318464 2136569 2136569 defendant Thurlowe Paul chandler 680310 680310 Thurlowe, Paul, of Hindringham, chandler 0
4324279 2138520 2138520 defendant Davye Christopher gent 680310 680310 Davye, Christopher, of Hindringham, gent 1
4339805 2143694 2143694 defendant Manne Henry   680310 680310 Manne, Henry, of Hindringham, sailor 0
4341933 2144457 2144457 defendant Loades Luke carpenter 680310 680310 Loades, Luke, of Hindringham, carpenter 3
4346874 2146161 2146161 defendant Clarke George husbandman 680310 680310 Clarke, George, of Hindringham, husbandman 1
4355414 2149116 2149116 defendant Framyngham Richard yeoman 680310 680310 Framyngham, Richard, of Hindringham, yeoman 1
4376396 2156627 2156627 defendant Weston William clerk 680310 680310 Weston, William, of Hindringham, clerk 0
4378305 2157309 2157309 defendant Hastyng Thomas gent 680310 680310 Hastyng, Thomas, of Hindringham, gent 0
4389395 2161078 2161078 defendant Manne Henry   680310 680310 Manne, Henry, of Hindringham, sailor 0
4391537 2161782 2161782 defendant Aylard Simon yeoman 680310 680310 Aylard, Simon, of Hindringham, yeoman 0
4392636 2162156 2162156 defendant Loades Luke catpenter 680310 680310 Loades, Luke, of Hindringham, catpenter 3
4392946 2162253 2162253 defendant Alyard Simon husbandman 680310 680310 Alyard, Simon, of Hindringham, husbandman 2
4398508 2164080 2164080 defendant Weston William clerk 680310 680310 Weston, William, of Hindringham, clerk 0
4398509 2164080 2164080 defendant Clarke George husbandman 680310 680310 Clarke, George, of Hindringham, husbandman 1
4407058 2166919 2166919 defendant Reade Thomas yeoman 680310 680310 Reade, Thomas, of Hindringham, yeoman 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);