names

27 rows where place_id = 601009

✎ 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
3643518 1908402 1908402 defendant Orme John tailor 601009 601009 Orme, John, of Mynster, Isle of Sheppey, tailor 0
3676480 1918688 1918688 defendant Bury Thomas tailor 601009 601009 Bury, Thomas, of Mynster, Isle of Sheppey, tailor 3
3704946 1927839 1927839 defendant Goselyng Richard tailor 601009 601009 Goselyng, Richard, of Mynster, Isle of Sheppey, tailor 1
3707615 1928679 1928679 defendant Andrewe Thomas husbandman 601009 601009 Andrewe, Thomas, of Mynster, Isle of Sheppey, husbandman 4
3714916 1930961 1930961 defendant Horne Vincent husbandman 601009 601009 Horne, Vincent, of Mynster, Isle of Sheppey, husbandman 1
3728967 1935306 1935306 defendant Feverer Robert weaver 601009 601009 Feverer, Robert, of Mynster, Isle of Sheppey, weaver 3
3777208 1950622 1950622 defendant Myller Peter   601009 601009 Myller, Peter, of Mynster, Isle of Sheppey 1
3785476 1953247 1953247 defendant Kytteryll William husbandman 601009 601009 Kytteryll, William, of Mynster, Isle of Sheppey, husbandman 1
3788313 1954143 1954143 defendant Kytterell John butcher 601009 601009 Kytterell, John, of Mynster, Isle of Sheppey, butcher 0
3811691 1961553 1961553 defendant Sampson   gent 601009 601009 Sampson, , of Mynster, Isle of Sheppey, gent 0
3829320 1967054 1967054 defendant Sampson Henry gent 601009 601009 Sampson, Henry, of Mynster, Isle of Sheppey, gent 2
3917340 1996157 1996157 defendant Tanner Henry   601009 601009 Tanner, Henry, of Mynster, Isle of Sheppey, minstrel 4
3946659 2005896 2005896 defendant Davye William husbandman 601009 601009 Davye, William, of Mynster, Isle of Sheppey, husbandman 0
4170627 2085228 2085228 defendant Buckmer Robert yeoman 601009 601009 Buckmer, Robert, of Mynster, Isle of Sheppey, yeoman 0
4170628 2085228 2085228 defendant Welles William yeoman 601009 601009 Welles, William, of Mynster, Isle of Sheppey, yeoman 1
4172448 2085826 2085826 defendant Carden Thomas yeoman 601009 601009 Carden, Thomas, of Mynster, Isle of Sheppey, yeoman 0
4181509 2089012 2089012 defendant Carden Thomas yeoman 601009 601009 Carden, Thomas, of Mynster, Isle of Sheppey, yeoman 0
4184111 2089941 2089941 defendant Buckmer Robert husbandman 601009 601009 Buckmer, Robert, of Mynster, Isle of Sheppey, husbandman 0
4195682 2094044 2094044 defendant Carden Thomas yeoman 601009 601009 Carden, Thomas, of Mynster, Isle of Sheppey, yeoman 0
4248751 2112568 2112568 defendant Askewe Richard yeoman 601009 601009 Askewe, Richard, of Mynster, Isle of Sheppey, yeoman 0
4391351 2161725 2161725 defendant Hylles William yeoman 601009 601009 Hylles, William, of Mynster, Isle of Sheppey, yeoman 1
5384302 2470595 2470595 defendant Elyot John husbandman 601009 601009 Elyot, John, of Mynster, Isle of Sheppey, husbandman 0
5384304 2470596 2470596 defendant Hamme Robert husbandman 601009 601009 Hamme, Robert, of Mynster, Isle of Sheppey, husbandman 0
5536904 2516031 2516031 defendant Laybourn John husbandman 601009 601009 Laybourn, John, of Mynster, Isle of Sheppey, husbandman 0
5568293 2525271 2525271 defendant Plott Robert tailor 601009 601009 Plott, Robert, of Mynster, Isle of Sheppey, tailor 0
5577669 2528084 2528084 defendant Browene John husbandman 601009 601009 Browene, John, of Mynster, Isle of Sheppey, husbandman 1
5581863 2529405 2529405 defendant Ryche William yeoman 601009 601009 Ryche, William, of Mynster, Isle of Sheppey, 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);