names

43 rows where place_id = 588487

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594668 1865962 1865962 defendant Sampson John husbandman 588487 588487 Sampson, John, of Bekenham, husbandman 0
3617714 1873163 1873163 defendant Brogreve Edward gent 588487 588487 Brogreve, Edward, of Bekenham, gent 0
3618223 1873323 1873323 defendant Holden Robert   588487 588487 Holden, Robert, of Bekenham 0
3629022 1903953 1903953 defendant Lye Robert yeoman 588487 588487 Lye, Robert, of Bekenham, yeoman 1
3629025 1903954 1903954 defendant Lye Edward yeoman 588487 588487 Lye, Edward, of Bekenham, yeoman 1
3713216 1930438 1930438 defendant Burbage William husbandman 588487 588487 Burbage, William, of Bekenham, husbandman 0
3713217 1930438 1930438 defendant Stanysmore George husbandman 588487 588487 Stanysmore, George, of Bekenham, husbandman 1
3713218 1930438 1930438 defendant Morgayn John husbandman 588487 588487 Morgayn, John, of Bekenham, husbandman 2
3763017 1946064 1946064 defendant Kempsall Thomas (legal representative) 588487 588487 Kempsall, Thomas, of Bekenham, yeoman, administrator of 0
3763018 1946064 1946064 defendant Kempsall John yeoman 588487 588487 Kempsall, John, of Bekenham, yeoman 1
3813819 1962235 1962235 defendant Dawe Richard husbandman 588487 588487 Dawe, Richard, of Bekenham, husbandman 0
3923945 1998317 1998317 plaintiff Style Humphrey   588487 588487 Style, Humphrey, of Bekenham, knight 0
4594959 2229679 2229679 plaintiff Pykenot John   588487 588487 Pykenot, John, of Bekenham 0
4594960 2229679 2229679 defendant Clerk John baker 588487 588487 Clerk, John, of Bekenham, baker 0
4594961 2229680 2229680 plaintiff Pykenot John   588487 588487 Pykenot, John, of Bekenham 0
4594962 2229680 2229680 defendant Clerk John baker 588487 588487 Clerk, John, of Bekenham, baker 0
4652146 2246610 2246610 defendant de la Rever Thomas gent 588487 588487 de la Rever, Thomas, of Bekenham, gent 1
4758927 2283145 2283145 plaintiff Caulston John   588487 588487 Caulston, John, of Bekenham 0
4958700 2344569 2344569 defendant atte Neder Richard husbandman 588487 588487 atte Neder, Richard, of Bekenham, husbandman 2
4958702 2344569 2344569 defendant Abbot John, junior husbandman 588487 588487 Abbot, John, junior, of Bekenham, husbandman 4
4972950 2348834 2348834 defendant Causton Thomas   588487 588487 Causton, Thomas, of Bekenham 0
5104732 2387823 2387823 defendant Nether Richard husbandman 588487 588487 Nether, Richard, of Bekenham, husbandman 0
5104733 2387823 2387823 defendant Abbot John husbandman 588487 588487 Abbot, John, of Bekenham, husbandman 1
5104734 2387823 2387823 defendant York John husbandman 588487 588487 York, John, of Bekenham, husbandman 2
5104735 2387823 2387823 defendant Midday John carpenter 588487 588487 Midday, John, of Bekenham, carpenter 3
5320959 2451358 2451358 defendant Abot John husbandman 588487 588487 Abot, John, of Bekenham, husbandman 0
5328562 2453619 2453619 defendant Pope Robert yeoman 588487 588487 Pope, Robert, of Bekenham, yeoman 0
5350319 2460220 2460220 defendant Brandon William esq 588487 588487 Brandon, William, of Bekenham, esq 0
5438302 2486388 2486388 defendant Wodeman Edmund laborer 588487 588487 Wodeman, Edmund, of Bekenham, laborer 3
5438303 2486388 2486388 defendant Mere William laborer 588487 588487 Mere, William, of Bekenham, laborer 4
5438304 2486388 2486388 defendant Forster Thomas laborer 588487 588487 Forster, Thomas, of Bekenham, laborer 5
5496908 2504006 2504006 defendant Alexaunder John husbandman 588487 588487 Alexaunder, John, of Bekenham, husbandman 0
5511812 2508547 2508547 defendant Sampson John husbandman 588487 588487 Sampson, John, of Bekenham, husbandman 0
5545561 2518687 2518687 defendant Lowen Thomas collier 588487 588487 Lowen, Thomas, of Bekenham, collier 1
5545562 2518687 2518687 defendant Godfrey Richard laborer 588487 588487 Godfrey, Richard, of Bekenham, laborer 2
5545563 2518687 2518687 defendant Morys Richard laborer 588487 588487 Morys, Richard, of Bekenham, laborer 3
5545564 2518687 2518687 defendant Kitman Robert laborer 588487 588487 Kitman, Robert, of Bekenham, laborer 4
5545565 2518687 2518687 defendant Colyns Thomas laborer 588487 588487 Colyns, Thomas, of Bekenham, laborer 5
5545566 2518687 2518687 defendant Lowen Thomas laborer 588487 588487 Lowen, Thomas, of Bekenham, laborer 6
5550463 2520157 2520157 defendant Tomson Cornelius tailor 588487 588487 Tomson, Cornelius, of Bekenham, tailor 0
5550464 2520157 2520157 defendant Borstall John husbandman 588487 588487 Borstall, John, of Bekenham, husbandman 1
5554186 2521268 2521268 defendant Violet alias Ferrour Henry yeoman 588487 588487 Violet alias Ferrour, Henry, of Bekenham, yeoman 0
5554187 2521268 2521268 defendant Burbage John yeoman 588487 588487 Burbage, John, of Bekenham, yeoman 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);