names

33 rows where place_id = 614621

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3704618 1927732 1927732 defendant Pokeryng Robert husbandman 614621 614621 Pokeryng, Robert, of Landford, husbandman 0
3704619 1927732 1927732 defendant Barneham John husbandman 614621 614621 Barneham, John, of Landford, husbandman 1
3704620 1927732 1927732 defendant Hakeworth John, senior husbandman 614621 614621 Hakeworth, John, senior, of Landford, husbandman 2
3704621 1927732 1927732 defendant Sympson William husbandman 614621 614621 Sympson, William, of Landford, husbandman 3
3704622 1927732 1927732 defendant Lownde John husbandman 614621 614621 Lownde, John, of Landford, husbandman 4
3775038 1949925 1949925 defendant Knyfsmyth John yeoman 614621 614621 Knyfsmyth, John, of Landford, yeoman 2
3791284 1955107 1955107 defendant Freman Richard husbandman 614621 614621 Freman, Richard, of Landford, husbandman 0
3791285 1955107 1955107 defendant Wilson Stephen husbandman 614621 614621 Wilson, Stephen, of Landford, husbandman 1
3791286 1955107 1955107 defendant Bette Richard husbandman 614621 614621 Bette, Richard, of Landford, husbandman 2
3792702 1955570 1955570 defendant Hakworth John husbandman 614621 614621 Hakworth, John, of Landford, husbandman 1
3842741 1971262 1971262 defendant Hacworth Thomas husbandman 614621 614621 Hacworth, Thomas, of Landford, husbandman 0
3859003 1976504 1976504 defendant Hacworth Thomas husbandman 614621 614621 Hacworth, Thomas, of Landford, husbandman 0
3893488 1988048 1988048 defendant Upton Thomas husbandman 614621 614621 Upton, Thomas, of Landford, husbandman 0
4277416 2122022 2122022 defendant Wilson Thomas yeoman 614621 614621 Wilson, Thomas, of Landford, yeoman 0
4510078 2203640 2203640 defendant Lygh Robert   614621 614621 Lygh, Robert, of Landford 0
4595009 2229697 2229697 defendant Lye Robert   614621 614621 Lye, Robert, of Landford 0
4719468 2271433 2271433 defendant Hyve Thomas merchant 614621 614621 Hyve, Thomas, of Landford, merchant 0
4870134 2317627 2317627 defendant Perpond Roger gent 614621 614621 Perpond, Roger, of Landford, gent 0
5089549 2383318 2383318 defendant Leek William esq 614621 614621 Leek, William, of Landford, esq 0
5113853 2390439 2390439 defendant Johnson Henry yeoman 614621 614621 Johnson, Henry, of Landford, yeoman 3
5113854 2390439 2390439 defendant Halgh John husbandman 614621 614621 Halgh, John, of Landford, husbandman 4
5118683 2391895 2391895 defendant Hamlet Geoffrey yeoman 614621 614621 Hamlet, Geoffrey, of Landford, yeoman 0
5119084 2392021 2392021 defendant Johnson Henry yeoman 614621 614621 Johnson, Henry, of Landford, yeoman 1
5119099 2392022 2392022 defendant Johnson Henry yeoman 614621 614621 Johnson, Henry, of Landford, yeoman 5
5128030 2394674 2394674 defendant Oxton Thomas yeoman 614621 614621 Oxton, Thomas, of Landford, yeoman 3
5157638 2403363 2403363 defendant Oxston Thomas yeoman 614621 614621 Oxston, Thomas, of Landford, yeoman 0
5157639 2403363 2403363 defendant Johnson Henry husbandman 614621 614621 Johnson, Henry, of Landford, husbandman 1
5173484 2407946 2407946 defendant Oxston Thomas yeoman 614621 614621 Oxston, Thomas, of Landford, yeoman 0
5173485 2407946 2407946 defendant Johnson Henry husbandman 614621 614621 Johnson, Henry, of Landford, husbandman 1
5442532 2487681 2487681 defendant Devyas Thomas gent 614621 614621 Devyas, Thomas, of Landford, gent 0
5455234 2491486 2491486 defendant Denyas Thomas gent 614621 614621 Denyas, Thomas, of Landford, gent 0
5573912 2526936 2526936 defendant Cokkes William, senior husbandman 614621 614621 Cokkes, William, senior, of Landford, husbandman 0
5573913 2526936 2526936 defendant Cokkes William, junior husbandman 614621 614621 Cokkes, William, junior, of Landford, husbandman 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);