names

27 rows where place_id = 603326

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654188 1911570 1911570 defendant Peryn William husbandman 603326 603326 Peryn, William, of Wacton, husbandman 4
3752552 1942724 1942724 defendant Courteys Henry husbandman 603326 603326 Courteys, Henry, of Wacton, husbandman 4
3756257 1943915 1943915 defendant ap Howell John husbandman 603326 603326 ap Howell, John, of Wacton, husbandman 2
3819627 1964016 1964016 defendant Lavyle alias Norman William husbandman 603326 603326 Lavyle alias Norman, William, of Wacton, husbandman 0
3921659 1997588 1997588 defendant Ponyett Agnes widow 603326 603326 Ponyett, Agnes, of Wacton, widow 2
3947828 2006303 2006303 defendant Frost John husbandman 603326 603326 Frost, John, of Wacton, husbandman 0
4033960 2036799 2036799 defendant Dancoke John yeoman 603326 603326 Dancoke, John, of Wacton, yeoman 1
4075647 2051593 2051593 defendant Smyth Thomas husbandman 603326 603326 Smyth, Thomas, of Wacton, husbandman 0
4112367 2064681 2064681 defendant Goslinge John yeoman 603326 603326 Goslinge, John, of Wacton, or of Blickling, yeoman 0
4158899 2081182 2081182 defendant Bennett John yeoman 603326 603326 Bennett, John, of Wacton, yeoman 0
4235848 2108111 2108111 defendant Puddyng Thomas, junior yeoman 603326 603326 Puddyng, Thomas, junior, of Wacton, yeoman 0
4259233 2116063 2116063 defendant Russell William gent 603326 603326 Russell, William, of Wacton, gent 3
4260511 2116483 2116483 defendant Rayner Alice widow 603326 603326 Rayner, Alice, of Wacton, widow 3
4264843 2117879 2117879 defendant Reyner George husbandman 603326 603326 Reyner, George, of Wacton, husbandman 1
4278789 2122519 2122519 defendant Fludd Edward esq 603326 603326 Fludd, Edward, of Wacton, or of Cressyngham, esq 0
4278790 2122519 2122519 defendant Wellys Edward butcher 603326 603326 Wellys, Edward, of Wacton, butcher 1
4285507 2124866 2124866 defendant Cullinge John husbandman 603326 603326 Cullinge, John, of Wacton, husbandman 0
4285509 2124867 2124867 defendant Watson George husbandman 603326 603326 Watson, George, of Wacton, husbandman 0
4340115 2143806 2143806 defendant Russell William gent 603326 603326 Russell, William, of Wacton, gent 0
4340857 2144075 2144075 defendant Lavile John gent 603326 603326 Lavile John, of Wacton, gent 1
4346858 2146155 2146155 defendant Horne George   603326 603326 Horne, George, of Wacton, wheelwright 2
4404466 2166059 2166059 defendant South John husbandman 603326 603326 South, John, of Wacton, husbandman 0
4404467 2166059 2166059 defendant South Joyce widow 603326 603326 South, Joyce, of Wacton, widow 1
5434630 2485294 2485294 defendant Boteld Thomas husbandman 603326 603326 Boteld, Thomas, of Wacton, husbandman 2
5462121 2493563 2493563 defendant Boteld Thomas husbandman 603326 603326 Boteld, Thomas, of Wacton, husbandman 2
5473668 2497091 2497091 defendant Boteld Thomas husbandman 603326 603326 Boteld, Thomas, of Wacton, husbandman 2
5485106 2500467 2500467 defendant Boteld Thomas husbandman 603326 603326 Boteld, Thomas, of Wacton, 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);