names

45 rows where place_id = 624973

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3761385 1945572 1945572 defendant Topp Thomas husbandman 624973 624973 Topp, Thomas, of Stockton, husbandman 1
3761386 1945572 1945572 defendant Rundell Robert tailor 624973 624973 Rundell, Robert, of Stockton, tailor 2
3779586 1951347 1951347 defendant Topp Thomas husbandman 624973 624973 Topp, Thomas, of Stockton, husbandman 1
3779587 1951347 1951347 defendant Rundell Robert tailor 624973 624973 Rundell, Robert, of Stockton, tailor 2
3834693 1968787 1968787 defendant Saunder John, junior husbandman 624973 624973 Saunder, John, junior, of Stockton, husbandman 1
3834694 1968787 1968787 defendant Panter Thomas husbandman 624973 624973 Panter, Thomas, of Stockton, husbandman 2
3834695 1968787 1968787 defendant Cokerell Robert husbandman 624973 624973 Cokerell, Robert, of Stockton, husbandman 3
3834696 1968787 1968787 defendant Carter John, junior husbandman 624973 624973 Carter, John, junior, of Stockton, husbandman 4
3834699 1968788 1968788 defendant Saunder John, junior husbandman 624973 624973 Saunder, John, junior, of Stockton, husbandman 1
3834701 1968788 1968788 defendant Cokerell Robert husbandman 624973 624973 Cokerell, Robert, of Stockton, husbandman 3
3834702 1968788 1968788 defendant Carter John, junior husbandman 624973 624973 Carter, John, junior, of Stockton, husbandman 4
3857486 1975977 1975977 defendant Russell Richard yeoman 624973 624973 Russell, Richard, of Stockton, yeoman 1
3889016 1986566 1986566 defendant Skelton William gent 624973 624973 Skelton, William, of Stockton, gent 0
3966215 2012812 2012812 defendant Agar Lawrence yeoman 624973 624973 Agar, Lawrence, of Stockton, yeoman 4
4001697 2025384 2025384 plaintiff Harries John (legal representative) 624973 624973 Harries, John, of Stockton, executors of 0
4048191 2041791 2041791 defendant Poler Humphrey husbandman 624973 624973 Poler, Humphrey, of Stockton, husbandman 1
4048192 2041791 2041791 defendant Keylyng Francis husbandman 624973 624973 Keylyng, Francis, of Stockton, husbandman 2
4048977 2042078 2042078 plaintiff Toppe John yeoman 624973 624973 Toppe, John, of Stockton, yeoman 0
4115658 2065885 2065885 defendant Oxon or Ockson Thomas husbandman 624973 624973 Oxon or Ockson, Thomas, of Stockton, husbandman 3
4141996 2075373 2075373 defendant Stannard Henry husbandman 624973 624973 Stannard, Henry, of Stockton, husbandman 0
4142142 2075429 2075429 defendant Buttler William gent 624973 624973 Buttler, William, of Stockton, gent 0
4144008 2076067 2076067 defendant Strynger Thomas husbandman 624973 624973 Strynger, Thomas, of Stockton, husbandman 0
4144011 2076068 2076068 defendant Strynger Thomas husbandman 624973 624973 Strynger, Thomas, of Stockton, husbandman 0
4149411 2077921 2077921 defendant Skelton Henry singleman 624973 624973 Skelton, Henry, of Stockton, yeoman, or of Lownd, Suff, singleman 0
4161017 2081930 2081930 defendant Pooler John husbandman 624973 624973 Pooler, John, of Stockton, husbandman 0
4193571 2093320 2093320 defendant Longlay Christopher clerk 624973 624973 Longlay, Christopher, of Stockton, clerk 0
4215510 2100919 2100919 defendant Cornwall Gabriel clerk 624973 624973 Cornwall, Gabriel, of Stockton, clerk 0
4224911 2104181 2104181 defendant Cornwall Gabriel clerk 624973 624973 Cornwall, Gabriel, of Stockton, clerk 0
4252910 2113968 2113968 defendant Johnson Robert tailor 624973 624973 Johnson, Robert, of Stockton, tailor 0
4252915 2113969 2113969 defendant Johnson Robert tailor 624973 624973 Johnson, Robert, of Stockton, tailor 0
4277091 2121919 2121919 defendant Gildingwater Robert yeoman 624973 624973 Gildingwater, Robert, of Stockton, yeoman 1
4292446 2127365 2127365 defendant Tirroll Thomas weaver 624973 624973 Tirroll, Thomas, of Stockton, weaver 0
4320340 2137213 2137213 defendant Masser William, senior yeoman 624973 624973 Masser, William, senior, of Stockton, yeoman 1
4320341 2137213 2137213 defendant Welshe Thomas gent 624973 624973 Welshe, Thomas, of Stockton, gent 2
4327439 2139499 2139499 defendant Parker John gent 624973 624973 Parker, John, of Stockton, gent 1
4328912 2139983 2139983 defendant Withnall Thomas husbandman 624973 624973 Withnall, Thomas, of Stockton, husbandman 2
4333362 2141441 2141441 defendant Mercer William, senior husbandman 624973 624973 Mercer, William, senior, of Stockton, husbandman 0
4333363 2141441 2141441 defendant Mercer William, junior   624973 624973 Mercer, William, junior, of Stockton, husbandman, his son 1
4344439 2145336 2145336 defendant Johnson James husbandman 624973 624973 Johnson, James, of Stockton, husbandman 0
4351375 2147731 2147731 defendant Symons Humphrey yeoman 624973 624973 Symons, Humphrey, of Stockton, yeoman 0
4368227 2153687 2153687 defendant Johnson James husbandman 624973 624973 Johnson, James, of Stockton, husbandman 0
4383011 2159031 2159031 defendant Terrold Thomas weaver 624973 624973 Terrold, Thomas, of Stockton, weaver 3
4701956 2266019 2266019 plaintiff Grane William   624973 624973 Grane, William, of Stockton 0
4701958 2266020 2266020 plaintiff Grane William   624973 624973 Grane, William, of Stockton 0
4701959 2266020 2266020 defendant Cragge John husbandman 624973 624973 Cragge, John, of Stockton, husbandman 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);