names

36 rows where place_id = 609521

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3678811 1919441 1919441 defendant Standysbury Thomas yeoman 609521 609521 Standysbury, Thomas, of Stepney, Middx, yeoman 0
3753817 1943137 1943137 defendant Shawe George fisher 609521 609521 Shawe, George, of Stepney, Middx, fisher 0
3925337 1998786 1998786 defendant Sansbery Thomas yeoman 609521 609521 Sansbery, Thomas, of Stepney, Middx, yeoman 0
3936459 2002516 2002516 plaintiff Markham John   609521 609521 Markham, John, of stepney, Middx, knight 0
4054548 2044015 2044015 defendant James William gent 609521 609521 James, William, of Stepney, Middx, gent 0
4059711 2045867 2045867 defendant James William gent 609521 609521 James, William, of Stepney, Middx, gent 0
4070769 2049841 2049841 defendant Beverley Thomas   609521 609521 Beverley, Thomas, of Stepney, Middx, gent, attorney of the bench 0
4076614 2051934 2051934 defendant James William gent 609521 609521 James, William, of Stepney, Middx, gent 0
4076616 2051935 2051935 defendant James William gent 609521 609521 James, William, of Stepney, Middx, gent 0
4093595 2058028 2058028 defendant James William gent 609521 609521 James, William, of Stepney, Middx, gent 0
4109100 2063511 2063511 defendant Lyster Michael gent 609521 609521 Lyster, Michael, of Stepney, Middx, gent 0
4203581 2096807 2096807 defendant Skipwith Richard esq 609521 609521 Skipwith, Richard, of Stepney, Middx, esq 0
4209370 2098831 2098831 defendant Skipwith Richard esq 609521 609521 Skipwith, Richard, of Stepney, Middx, esq 0
4213437 2100218 2100218 defendant Freman Henry gent 609521 609521 Freman, Henry, of Stepney, Middx, gent 0
4225581 2104411 2104411 defendant Caed William gent 609521 609521 Caed, William, of Stepney, Middx, gent 0
4301846 2130769 2130769 defendant Cannock Francis   609521 609521 Francis his wife, formerly Francis Ryche, of Stepney, Middx 2
4311334 2134110 2134110 defendant Wilcockes Peter gent 609521 609521 Wilcockes, Peter, of Stepney, Middx, gent 0
4343853 2145131 2145131 defendant Cottesford Samuel clerk 609521 609521 Cottesford, Samuel, of Stepney, Middx, clerk 2
4345485 2145690 2145690 defendant Cottesford Samuel clerk 609521 609521 Cottesford, Samuel, of Stepney, Middx, or of Clacton Magna, Essex, clerk 0
4399795 2164520 2164520 defendant Cottesforde Samuel clerk 609521 609521 Cottesforde, Samuel, of Stepney, Middx, clerk 1
4403402 2165704 2165704 defendant Purser Edward yeoman 609521 609521 Purser, Edward, of Stepney, Middx, yeoman 0
4649573 2245905 2245905 plaintiff Waryn John   609521 609521 Waryn, John, of Stepney, Middx 1
4756732 2282469 2282469 defendant Potte Adam fishmonger 609521 609521 Potte, Adam, of Stepney, Middx, fishmonger 2
4772577 2287392 2287392 defendant Boys Walter mariner 609521 609521 Boys, Walter, of Stepney, Middx, mariner 0
4806278 2298170 2298170 defendant Lomley Marmaduke de clerk 609521 609521 Lomley, Marmaduke de, of Stepney, Middx, clerk 0
4833951 2306627 2306627 defendant Rayle Alexander   609521 609521 Rayle, Alexander, of Stepney, Middx 1
4911198 2330010 2330010 plaintiff Aubre Thomas   609521 609521 Aubre, Thomas, of Stepney, Middx 1
5151634 2401634 2401634 defendant Alardson John beer brewer 609521 609521 Alardson, John, of Stepney, Middx, beer brewer 0
5179835 2409837 2409837 defendant Laylan John yeoman 609521 609521 Laylan, John, of Stepney, Middx, yeoman 0
5181067 2410205 2410205 defendant Flemyng John carter 609521 609521 Flemyng, John, of Stepney, Middx, carter 4
5408387 2477478 2477478 defendant (illegible) William esq 609521 609521 _, William, of Stepney, Middx, esq 0
5418413 2480435 2480435 defendant Bulman John gent 609521 609521 Bulman, John, of Stepney, Middx, gent 0
5493186 2502871 2502871 defendant Haynes William beer brewer 609521 609521 Haynes, William, of Stepney, Middx, beer brewer 0
5493468 2502959 2502959 defendant Haynes William beer brewer 609521 609521 Haynes, William, of Stepney, Middx, beer brewer 0
5595127 2533445 2533445 defendant Sapcote Richard gent 609521 609521 Sapcote, Richard, of Stepney, Middx, gent 0
5595129 2533446 2533446 defendant Sapcote Richard gent 609521 609521 Sapcote, Richard, of Stepney, Middx, gent 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);