names

46 rows where place_id = 610337

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3672997 1917563 1917563 defendant Lancaster John   610337 610337 Lancaster, John,of Nether Toynton, husbandman, son of Lancaster, Thomas 0
3683076 1920822 1920822 defendant Lancastre John husbandman 610337 610337 Lancastre, John, of Nether Toynton, husbandman 0
3689863 1922987 1922987 defendant Egar Robert (legal representative) 610337 610337 Egar, Robert, of Nether Toynton, drover, executrix of 3
3704330 1927655 1927655 defendant Egar Margaret widow 610337 610337 Egar, Margaret, of Nether Toynton, widow 1
3707972 1928788 1928788 defendant Stanes Thomas gent 610337 610337 Stanes, Thomas, of Nether Toynton, gent 0
3719206 1932293 1932293 defendant Sparrowe John yeoman 610337 610337 Sparrowe, John, of Nether Toynton, yeoman 0
3733999 1936880 1936880 defendant Newcombe Richard yeoman 610337 610337 (Newcombe, Richard, of Nether Toynton, yeoman 1
3747884 1941262 1941262 defendant Egar Robert (legal representative) 610337 610337 Egar, Robert, of Nether Toynton, drover, executrix of 0
3747885 1941262 1941262 defendant Egar Margaret widow 610337 610337 Egar, Margaret, of Nether Toynton, widow 1
3754107 1943231 1943231 defendant Basse John husbandman 610337 610337 Basse, John, of Nether Toynton, husbandman 0
3810138 1961060 1961060 defendant Newcombe Richard yeoman 610337 610337 Newcombe, Richard, of Nether Toynton, yeoman 0
3932409 2001127 2001127 defendant Rawson John husbandman 610337 610337 Rawson, John, of Nether Toynton, husbandman 2
3934867 2001965 2001965 defendant Maxwell Robert yeoman 610337 610337 Maxwell, Robert, of Nether Toynton, yeoman 0
4050725 2042693 2042693 defendant Overey Edward merchant 610337 610337 Overey, Edward, of Nether Toynton, merchant 0
4050728 2042694 2042694 defendant Overey Edward merchant 610337 610337 Overey, Edward, of Nether Toynton, merchant 0
4070765 2049839 2049839 defendant Stevenson William husbandman 610337 610337 Stevenson, William, of Nether Toynton, husbandman 0
4085254 2055008 2055008 defendant Newcome William gent 610337 610337 Newcome, William, of Nether Toynton, gent 0
4085257 2055008 2055008 defendant Newcome Samuel gent 610337 610337 Newcome, Samuel, of Nether Toynton, gent 3
4106038 2062451 2062451 defendant Newcomen Samuel gent 610337 610337 Newcomen, Samuel, of Nether Toynton, gent 2
4127592 2070161 2070161 defendant Newcome Samuel yeoman 610337 610337 Newcome, Samuel, of Nether Toynton, yeoman 0
4133559 2072335 2072335 defendant Stevenson Francis yeoman 610337 610337 Stevenson, Francis, of Nether Toynton, yeoman 0
4179445 2088286 2088286 defendant Newcom Samuel gent 610337 610337 Newcom, Samuel, of Nether Toynton, gent 1
4227518 2105109 2105109 defendant West John gent 610337 610337 West, John, of Nether Toynton, gent 0
4235950 2108148 2108148 defendant Weste John gent 610337 610337 Weste, John, of Nether Toynton, gent 0
4275007 2121212 2121212 defendant Jackson William gent 610337 610337 Jackson, William, of Nether Toynton, gent 0
4277279 2121985 2121985 defendant Burton Thomas carpenter 610337 610337 Burton, Thomas, of Nether Toynton, carpenter 0
4277280 2121985 2121985 defendant Burne Christopher laborer 610337 610337 Burne, Christopher, of Nether Toynton, laborer 1
4277281 2121985 2121985 defendant Williamson John yeoman 610337 610337 Williamson, John, of Nether Toynton, yeoman 2
4288717 2126020 2126020 defendant Newcomen Samuel gent 610337 610337 Newcomen, Samuel, of Nether Toynton, gent 0
4294310 2128043 2128043 defendant Cockborne George clerk 610337 610337 Cockborne, George, of Nether Toynton, clerk 0
4295312 2128409 2128409 defendant Browne Nicholas gent 610337 610337 Browne, Nicholas, of Nether Toynton, gent 0
4295313 2128409 2128409 defendant Cockborne George clerk 610337 610337 Cockborne, George, of Nether Toynton, clerk 1
4295314 2128409 2128409 defendant Burton Thomas carpenter 610337 610337 Burton, Thomas, of Nether Toynton, carpenter 2
4295315 2128409 2128409 defendant Salmon Edward yeoman 610337 610337 Salmon, Edward, of Nether Toynton, yeoman 3
4302674 2131052 2131052 defendant Johnson William husbandman 610337 610337 Johnson, William, of Nether Toynton, husbandman 0
4305803 2132167 2132167 defendant Newcomen Samuel gent 610337 610337 Newcomen, Samuel, of Nether Toynton, gent 0
4342270 2144576 2144576 defendant Mayson Thomas yeoman 610337 610337 Mayson, Thomas, of Nether Toynton, yeoman 2
4345081 2145555 2145555 defendant Cockborne George clerk 610337 610337 Cockborne, George, of Nether Toynton, clerk 2
4347590 2146405 2146405 defendant Cockborne George clerk 610337 610337 Cockborne, George, of Nether Toynton, clerk 0
4718776 2271215 2271215 defendant Alanson Thomas husbandman 610337 610337 Alanson, Thomas, of Nether Toynton, husbandman 0
5130878 2395513 2395513 defendant Lounde Hugh husbandman 610337 610337 Lounde, Hugh, of Nether Toynton, husbandman 1
5150341 2401230 2401230 defendant Lounde Hugh husbandman 610337 610337 Lounde, Hugh, of Nether Toynton, husbandman 1
5185166 2411407 2411407 defendant Lounde Hugh husbandman 610337 610337 Lounde, Hugh, of Nether Toynton, husbandman 1
5221765 2422060 2422060 defendant Walker Thomas husbandman 610337 610337 Walker, Thomas, of Nether Toynton, husbandman 0
5231433 2424780 2424780 defendant Edlyngton Robert husbandman 610337 610337 Edlyngton, Robert, of Nether Toynton, husbandman 1
5231434 2424780 2424780 defendant Bradley Thomas   610337 610337 Bradley, Thomas, of Nether Toynton, wright 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);