names

51 rows where place_id = 621460

✎ 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
3741553 1939227 1939227 defendant Tenant William yeoman 621460 621460 Tenant, William, of Bedall, yeoman 0
3779239 1951229 1951229 defendant Akeryge Peter draper 621460 621460 Akeryge, Peter, of Bedall, draper 0
3779241 1951230 1951230 defendant Akeryge William mercer 621460 621460 Akeryge, William, of Bedall, mercer 0
3788679 1954260 1954260 defendant Tenaunt William yeoman 621460 621460 Tenaunt, William, of Bedall, yeoman 0
3788680 1954261 1954261 plaintiff Stapilton Thomas   621460 621460 Stapilton, Thomas, of Bedall, bailiff 0
3804924 1959483 1959483 defendant Tenaunt William yeoman 621460 621460 Tenaunt, William, of Bedall, yeoman 0
3817167 1963281 1963281 defendant Tenaunt John yeoman 621460 621460 Tenaunt, John, of Bedall, yeoman 0
3817169 1963282 1963282 defendant Tenaunt William yeoman 621460 621460 Tenaunt, William, of Bedall, yeoman 0
3817171 1963283 1963283 defendant Tenaunt William yeoman 621460 621460 Tenaunt, William, of Bedall, yeoman 0
3854571 1975074 1975074 defendant Barker Richard yeoman 621460 621460 Barker, Richard, of Bedall, yeoman 0
3909846 1993598 1993598 defendant Kettylwell Michael glover 621460 621460 Kettylwell, Michael, of Bedall, glover 0
4004310 2026323 2026323 plaintiff Jackson George (legal representative) 621460 621460 Jackson, George, of Bedall, clerk, executors of 0
4017285 2030888 2030888 plaintiff Tenaunt Adam gent 621460 621460 Tenaunt, Adam, of Bedall, gent 0
4032283 2036217 2036217 defendant Tenante Adam gent 621460 621460 Tenante, Adam, of Bedall, gent 0
4032285 2036218 2036218 defendant Tenante Adam gent 621460 621460 Tenante, Adam, of Bedall, gent 0
4036798 2037850 2037850 plaintiff Jackson George (legal representative) 621460 621460 Jackson, George, of Bedall, executors of 0
4055162 2044238 2044238 defendant Johnson John chapman 621460 621460 Johnson, John, of Bedall, chapman 0
4056818 2044822 2044822 defendant Lodge Elizabeth widow 621460 621460 Lodge, Elizabeth, of Bedall, widow 0
4056839 2044828 2044828 defendant Johnson John chapman 621460 621460 Johnson, John, of Bedall, chapman 0
4080443 2053315 2053315 defendant Lodge George merchant 621460 621460 Lodge, George, of Bedall, merchant 0
4109464 2063647 2063647 defendant Lodge Elizabeth widow 621460 621460 Lodge, Elizabeth, of Bedall, widow 0
4109521 2063667 2063667 defendant Lodge Elizabeth widow 621460 621460 Lodge, Elizabeth, of Bedall, widow 0
4223040 2103549 2103549 defendant Barghe Christopher innholder 621460 621460 Barghe, Christopher, of Bedall, innholder 0
4229860 2105928 2105928 defendant Jayke James yeoman 621460 621460 Jayke, James, of Bedall, yeoman 0
4229861 2105928 2105928 defendant Jayke Edward yeoman 621460 621460 Jayke, Edward, of Bedall, yeoman 1
4229862 2105928 2105928 defendant Hawle John yeoman 621460 621460 Hawle, John, of Bedall, yeoman 2
4250428 2113126 2113126 defendant Hallidaye John yeoman 621460 621460 Hallidaye, John, of Bedall, yeoman 1
4250723 2113218 2113218 defendant Barghe Christopher yeoman 621460 621460 Barghe, Christopher, of Bedall, yeoman 0
4276595 2121748 2121748 defendant Mushe George yeoman 621460 621460 Mushe, George, of Bedall, yeoman 0
4289749 2126396 2126396 defendant Hall John yeoman 621460 621460 Hall, John, of Bedall, yeoman 1
4289750 2126396 2126396 defendant Jackson Luke laborer 621460 621460 Jackson, Luke, of Bedall, laborer 2
4317536 2136247 2136247 defendant Tenant George gent 621460 621460 Tenant, George, of Bedall, gent 3
4374518 2155947 2155947 defendant Kennett Lucy yeoman 621460 621460 Kennett, Lucy, of Bedall, yeoman 3
4374537 2155951 2155951 defendant Temande Christopher yeoman 621460 621460 Temande, Christopher, of Bedall, yeoman 2
4392617 2162152 2162152 defendant Foster Edmund chapman 621460 621460 Foster, Edmund, of Bedall, chapman 3
4397650 2163792 2163792 defendant Peres Henry yeoman 621460 621460 Peres, Henry, of Bedall, yeoman 0
4492686 2198415 2198415 defendant Crakall Richard   621460 621460 Crakall, Richard, of Bedall 2
4492695 2198417 2198417 defendant Sturton John   621460 621460 Sturton, John, of Bedall 0
4500232 2200698 2200698 defendant Thirne John smith 621460 621460 Thirne, John, of Bedall, smith 3
4636183 2242149 2242149 defendant Alemon John   621460 621460 Alemon, John, of Bedall 3
4636187 2242149 2242149 defendant Rande John   621460 621460 Rande, John, of Bedall 7
4740859 2277840 2277840 defendant Borell Robert de yeoman 621460 621460 Borell, Robert de, of Bedall, yeoman 0
4740860 2277840 2277840 defendant Bowes John yeoman 621460 621460 Bowes, John, of Bedall, yeoman 1
4826289 2304257 2304257 defendant Wade John   621460 621460 Wade, John, of Bedall 1
4981201 2351307 2351307 defendant Crakall Robert yeoman 621460 621460 Crakall, Robert, of Bedall, yeoman 0
4985441 2352568 2352568 defendant Lofthous John yeoman 621460 621460 Lofthous, John, of Bedall, yeoman 2
5390708 2472403 2472403 defendant Bokill Richard yeoman 621460 621460 (Bokill, Richard, of Bedall, yeoman 1
5579117 2528542 2528542 defendant Porter Thomas yeoman 621460 621460 Porter, Thomas, of Bedall, yeoman 0
5593509 2532954 2532954 defendant Walker Christopher draper 621460 621460 Walker, Christopher, of Bedall, draper 0
5593510 2532954 2532954 defendant Tenant William yeoman 621460 621460 Tenant, William, of Bedall, yeoman 1
5622763 2551049 2551049 plaintiff Watkyn John   621460 621460 Watkyn, John, of Bedall 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);