names

41 rows where place_id = 615030

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3706763 1928400 1928400 defendant Sparke John husbandman 615030 615030 Sparke, John, of Marke, husbandman 2
3712768 1930311 1930311 defendant Downe William husbandman 615030 615030 Downe, William, of Marke, husbandman 0
3796319 1956713 1956713 defendant Sparke John husbandman 615030 615030 Sparke, John, of Marke, husbandman 0
3844851 1971934 1971934 defendant Rugge Richard husbandman 615030 615030 Rugge, Richard, of Marke, husbandman 0
3923720 1998242 1998242 defendant Dun John   615030 615030 Dun, John, of Marke, husbandman, son of Donne, Robert 2
3940306 2003777 2003777 defendant Warman William husbandman 615030 615030 (Warman, William, of Marke, husbandman 3
4003044 2025852 2025852 defendant Coxe Thomas husbandman 615030 615030 Coxe, Thomas, of Marke, husbandman 0
4003046 2025853 2025853 defendant Coxe Thomas husbandman 615030 615030 Coxe, Thomas, of Marke, husbandman 0
4004775 2026484 2026484 defendant Henney George shoemaker 615030 615030 Henney, George, of Marke, shoemaker 2
4096097 2058931 2058931 defendant Syme Robert husbandman 615030 615030 Syme, Robert, of Marke, husbandman 0
4113043 2064931 2064931 defendant Dyshe Arthur yeoman 615030 615030 Dyshe, Arthur, of Marke, yeoman 0
4113046 2064932 2064932 defendant Dyshe Arthur yeoman 615030 615030 Dyshe, Arthur, of Marke, yeoman 0
4200403 2095697 2095697 defendant Sheppard John husbandman 615030 615030 Sheppard, John, of Marke, husbandman 0
4208916 2098667 2098667 defendant Coxe Thomas husbandman 615030 615030 Coxe, Thomas, of Marke, husbandman 0
4243959 2110961 2110961 defendant Carter John husbandman 615030 615030 Carter, John, of Marke, husbandman 1
4261323 2116753 2116753 defendant Inglond James husbandman 615030 615030 Inglond, James, of Marke, husbandman 0
4283325 2124074 2124074 defendant Jenkyns Francis yeoman 615030 615030 Jenkyns, Francis, of Marke, yeoman 0
4288172 2125819 2125819 defendant Jenkyns Francis husbandman 615030 615030 Jenkyns, Francis, of Marke, husbandman 0
4288174 2125819 2125819 defendant Wembridge Walter husbandman 615030 615030 Wembridge, Walter, of Marke, husbandman 2
4290377 2126615 2126615 defendant Symes Gabriel husbandman 615030 615030 Symes, Gabriel, of Marke, husbandman 0
4321104 2137475 2137475 defendant Whytinge William yeoman 615030 615030 Whytinge, William, of Marke, yeoman 1
4355795 2149247 2149247 defendant Allen Peter husbandman 615030 615030 Allen, Peter, of Marke, husbandman 0
4355796 2149247 2149247 defendant Giblet John husbandman 615030 615030 Giblet, John, of Marke, husbandman 1
4355797 2149247 2149247 defendant Syme Gabriel husbandman 615030 615030 Syme, Gabriel, of Marke, husbandman 2
4355798 2149247 2149247 defendant Stearte Gabriel husbandman 615030 615030 Stearte, Gabriel, of Marke, husbandman 3
4358962 2150370 2150370 defendant Champony Richard miller 615030 615030 Champony, Richard, of Marke, miller 2
4371013 2154689 2154689 defendant Warwicke Richard husbandman 615030 615030 Warwicke, Richard, of Marke, husbandman 0
4372541 2155250 2155250 defendant Syme George husbandman 615030 615030 Syme, George, of Marke, husbandman 0
4378030 2157214 2157214 defendant Becke Nicholas husbandman 615030 615030 Becke, Nicholas, of Marke, husbandman 0
4378031 2157214 2157214 defendant Harrys Robert yeoman 615030 615030 Harrys, Robert, of Marke, yeoman 1
4378032 2157214 2157214 defendant Colson William husbandman 615030 615030 Colson, William, of Marke, husbandman 2
4378033 2157214 2157214 defendant Lane John tailor 615030 615030 Lane, John, of Marke, tailor 3
4388864 2160907 2160907 defendant Edward Richard husbandman 615030 615030 Edward, Richard, of Marke, husbandman 0
4388865 2160907 2160907 defendant Churchowse George husbandman 615030 615030 together with Churchowse, George, of Marke, husbandman 1
4388866 2160907 2160907 defendant Tutton William husbandman 615030 615030 Tutton, William, of Marke, husbandman 2
4388867 2160907 2160907 defendant Bawden Henry husbandman 615030 615030 Bawden, Henry, of Marke, husbandman 3
4408367 2167372 2167372 defendant Gibbes Walter miller 615030 615030 Gibbes, Walter, of Marke, miller 2
4408368 2167372 2167372 defendant Syme Gabriel husbandman 615030 615030 Syme, Gabriel, of Marke, husbandman 3
4409555 2167793 2167793 defendant Gibbes Walter husbandman 615030 615030 Gibbes, Walter, of Marke, husbandman 0
5378593 2468889 2468889 defendant Say Henry husbandman 615030 615030 Say, Henry, of Marke, husbandman 1
5501156 2505299 2505299 defendant Gent John mercer 615030 615030 Gent, John, of Marke, mercer 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);