names

27 rows where place_id = 586255

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588274 1863987 1863987 defendant Palmer Anne widow 586255 586255 Palmer, Anne, of Otford, Kent, widow 4
3588282 1863988 1863988 defendant Palmer Anne widow 586255 586255 Palmer, Anne, of Otford, Kent, widow 4
3658622 1912951 1912951 defendant Palmer John gent 586255 586255 Palmer, John, of Otford, Kent, gent 0
3677536 1919020 1919020 defendant Hill Richard gent 586255 586255 Hill, Richard, of Otford, Kent, gent 11
3692797 1923938 1923938 defendant Selyngar Anthony yeoman 586255 586255 Selyngar, Anthony, of Otford, Kent, yeoman 2
3721699 1933071 1933071 defendant Hill Richard gent 586255 586255 Hill, Richard, of Otford, Kent, gent 6
3787703 1953938 1953938 defendant Multon Robert, junior yeoman 586255 586255 Multon, Robert, junior, of Otford, Kent, yeoman 0
3814398 1962418 1962418 defendant Barett James gent and merchant 586255 586255 Barett, James, of Otford, Kent, gent and merchant 0
3815873 1962868 1962868 defendant Atwode Edward gent 586255 586255 Atwode, Edward, of Otford, Kent, gent 0
3836553 1969335 1969335 defendant Ravensby John yeoman 586255 586255 Ravensby, John, of Otford, Kent, yeoman 0
3838563 1969987 1969987 defendant at Mere Christopher yeoman 586255 586255 at Mere, Christopher, of Otford, Kent, yeoman 1
3869533 1980053 1980053 defendant Multon Robert yeoman 586255 586255 Multon, Robert, of Otford, Kent, yeoman 0
3886099 1985601 1985601 defendant Chaterton Alice widow 586255 586255 Chaterton, Alice, of Otford, Kent, widow 3
4906855 2328729 2328729 defendant Dryver John tanner 586255 586255 Dryver, John, of Otford, Kent, tanner 3
5160253 2404093 2404093 defendant Palmer John gent 586255 586255 Palmer, John, of Otford, Kent, gent 0
5175092 2408410 2408410 defendant Palmer John gent 586255 586255 Palmer, John, of Otford, Kent, gent 0
5175099 2408411 2408411 defendant Palmer John   586255 586255 Palmer, John, of Otford, Kent 0
5196569 2414748 2414748 defendant Denparke John husbandman 586255 586255 Denparke, John, of Otford, Kent, husbandman 0
5209702 2418577 2418577 defendant Denparke John husbandman 586255 586255 Denparke, John, of Otford, Kent, husbandman 0
5217888 2420962 2420962 defendant Dunkyn John yeoman 586255 586255 Dunkyn, John, of Otford, Kent, yeoman 3
5294781 2443457 2443457 defendant Couper John yeoman 586255 586255 Couper, John, of Otford, Kent, yeoman 0
5373263 2467236 2467236 defendant Palmer Thomas gent 586255 586255 (Palmer, Thomas, of Otford, Kent, gent 1
5403155 2475986 2475986 defendant Palmer John gent 586255 586255 Palmer, John, of Otford, Kent, gent 0
5416167 2479766 2479766 defendant Palmer John gent 586255 586255 Palmer, John, of Otford, Kent, gent 0
5416170 2479767 2479767 defendant Palmer John gent 586255 586255 Palmer, John, of Otford, Kent, gent 0
5432907 2484811 2484811 defendant Palmer John gent 586255 586255 Palmer, John, of Otford, Kent, gent 0
5549859 2519991 2519991 defendant Palmer Thomas gent 586255 586255 Palmer, Thomas, of Otford, Kent, gent 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);