names

34 rows where place_id = 602710

✎ 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
3651372 1910795 1910795 defendant Hall John mercer 602710 602710 Hall, John, of Newark on Trent, Notts, mercer 0
3861067 1977184 1977184 plaintiff Empson William glover 602710 602710 Empson, William, of Newark on Trent, Notts, glover 0
3873362 1981307 1981307 defendant Lucas Richard gent 602710 602710 Lucas, Richard, of Newark on Trent, Notts, gent 0
3873364 1981308 1981308 defendant Lucas Richard gent 602710 602710 Lucas, Richard, of Newark on Trent, Notts, gent 0
3879927 1983545 1983545 defendant Lucas Richard gent 602710 602710 Lucas, Richard, of Newark on Trent, Notts, gent 0
3932412 2001128 2001128 plaintiff Forster Anthony esq 602710 602710 Forster, Anthony, of Newark on Trent, Notts, esq 0
3940143 2003721 2003721 defendant Grevys Roger gent 602710 602710 Grevys, Roger, of Newark on Trent, Notts, gent 0
3961057 2010960 2010960 defendant Cowton Thomas chapman 602710 602710 Cowton, Thomas, of Newark on Trent, Notts, chapman 0
3965319 2012487 2012487 defendant Levarton John mercer 602710 602710 Levarton, John, of Newark on Trent, Notts, mercer 0
3968689 2013685 2013685 defendant Chapman Mathew baker 602710 602710 Chapman, Mathew, of Newark on Trent, Notts, baker 4
4027705 2034557 2034557 defendant Bradshawe Bartholomew yeoman 602710 602710 Bradshawe, Bartholomew, of Newark on Trent, Notts, yeoman 2
4038580 2038438 2038438 plaintiff Leeke Francis   602710 602710 Leeke, Francis, of Newark on Trent, Notts, knight 0
4051526 2042964 2042964 defendant Chambers David tailor 602710 602710 Chambers, David, of Newark on Trent, Notts, tailor 0
4051530 2042965 2042965 defendant Chambers David tailor 602710 602710 Chambers, David, of Newark on Trent, Notts, tailor 0
4052403 2043281 2043281 defendant Parke William yeoman 602710 602710 Parke, William, of Newark on Trent, Notts, yeoman 0
4054037 2043825 2043825 defendant Leverton John chapman 602710 602710 Leverton, John, of Newark on Trent, Notts, chapman 2
4074430 2051158 2051158 defendant Constable Robert   602710 602710 Constable, Robert, of Newark on Trent, Notts, knight 1
4098976 2059958 2059958 defendant Constable Robert   602710 602710 Constable, Robert, of Newark on Trent, Notts, or of Berwick on Tweede, knight 0
4215774 2101014 2101014 defendant Doughtye Thomas gent 602710 602710 Doughtye, Thomas, of Newark on Trent, Notts, gent 0
4236727 2108419 2108419 defendant Brotherick Edward yeoman 602710 602710 Brotherick, Edward, of Newark on Trent, Notts, yeoman 0
4236730 2108420 2108420 defendant Kediarde Richard yeoman 602710 602710 Kediarde, Richard, of Newark on Trent, Notts, yeoman 0
4256895 2115278 2115278 defendant Noble William gent 602710 602710 Noble, William, of Newark on Trent, Notts, gent 0
4257060 2115335 2115335 defendant Doughtie Thomas gent 602710 602710 Doughtie, Thomas, of Newark on Trent, Notts, gent 0
4260931 2116617 2116617 defendant Taylor Thomas draper 602710 602710 Taylor, Thomas, of Newark on Trent, Notts, draper 1
4268023 2118923 2118923 defendant Harryson William chapman 602710 602710 Harryson, William, of Newark on Trent, Notts, chapman 0
4269320 2119330 2119330 defendant Doughtie Thomas gent 602710 602710 Doughtie, Thomas, of Newark on Trent, Notts, gent 0
4272086 2120229 2120229 defendant Lettyn Robert   602710 602710 Lettyn, Robert, of Newark on Trent, Notts, mason 2
4282943 2123936 2123936 defendant Hasell Lawrence innholder 602710 602710 Hasell, Lawrence, of Newark on Trent, Notts, innholder 0
4293767 2127839 2127839 defendant Lambert Robert painter 602710 602710 Lambert, Robert, of Newark on Trent, Notts, painter 0
4295450 2128460 2128460 defendant Redyard Richard yeoman 602710 602710 Redyard, Richard, of Newark on Trent, Notts, yeoman 0
4371344 2154817 2154817 defendant Riddiatt Rochard yeoman 602710 602710 Riddiatt, Rochard, of Newark on Trent, Notts, yeoman 0
4377691 2157092 2157092 defendant Parke George vintner 602710 602710 Parke, George, of Newark on Trent, Notts, vintner 0
5533895 2515143 2515143 defendant Taillour Edmund chapman 602710 602710 Taillour, Edmund, of Newark on Trent, Notts, chapman 3
5599186 2534624 2534624 defendant Sympson John yeoman 602710 602710 (Sympson, John, of Newark on Trent, Notts, yeoman 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);