names

24 rows where place_id = 588897

✎ 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
3595948 1866363 1866363 defendant White Hugh husbandman 588897 588897 White, Hugh, of Kylmyngton, husbandman 10
3595949 1866363 1866363 defendant Morgan Thomas husbandman 588897 588897 Morgan, Thomas, of Kylmyngton, husbandman 11
3618435 1873397 1873397 defendant Cokee Richard husbandman 588897 588897 Cokee, Richard, of Kylmyngton, husbandman 8
3618458 1873399 1873399 defendant Conley John, senior tailor 588897 588897 Conley, John, senior, of Kylmyngton, tailor 7
3618459 1873399 1873399 defendant Conley John, junior tailor 588897 588897 Conley, John, junior, of Kylmyngton, tailor 8
3618460 1873399 1873399 defendant Basley John, junior husbandman 588897 588897 Basley, John, junior, of Kylmyngton, husbandman 9
3853814 1974826 1974826 defendant Rowe John husbandman 588897 588897 Rowe, John, of Kylmyngton, husbandman 0
3961367 2011070 2011070 defendant Dare Alice widow 588897 588897 Dare, Alice, of Kylmyngton, widow 0
3961368 2011070 2011070 defendant Goddard John husbandman 588897 588897 Goddard, John, of Kylmyngton, husbandman 1
4065483 2047945 2047945 defendant Baseley James yeoman 588897 588897 Baseley, James, of Kylmyngton, yeoman 1
4089432 2056506 2056506 defendant Longe William merchant 588897 588897 Longe, William, of Kylmyngton, merchant 0
4104501 2061892 2061892 defendant Gyldon John husbandman 588897 588897 Gyldon, John, of Kylmyngton, husbandman 1
4104502 2061892 2061892 defendant Bysse Hugh husbandman 588897 588897 Bysse, Hugh, of Kylmyngton, husbandman 2
4127399 2070089 2070089 defendant Butter Robert butcher 588897 588897 Butter, Robert, of Kylmyngton, butcher 2
4203416 2096746 2096746 defendant Butter Robert butcher 588897 588897 Butter, Robert, of Kylmyngton, butcher 0
4582489 2225964 2225964 defendant Hulle William, sen   588897 588897 Hulle, William, sen, of Kylmyngton 0
4694895 2263892 2263892 defendant Okerford John laborer 588897 588897 Okerford, John, of Kylmyngton, laborer 1
5099717 2386353 2386353 defendant Horbery John clerk 588897 588897 Horbery, John, of Kylmyngton, clerk 2
5534699 2515395 2515395 defendant Geffreys Thomas husbandman 588897 588897 Geffreys, Thomas, of Kylmyngton, husbandman 0
5535876 2515724 2515724 defendant Somerton Robert laborer 588897 588897 Somerton, Robert, of Kylmyngton, laborer 1
5535877 2515724 2515724 defendant Smyth William laborer 588897 588897 Smyth, William, of Kylmyngton, laborer 2
5595484 2533537 2533537 defendant Chapell John, junior carpenter 588897 588897 Chapell, John, junior, of Kylmyngton, carpenter 0
5595486 2533537 2533537 defendant Chapell John, senior husbandman 588897 588897 Chapell, John, senior, of Kylmyngton, husbandman 2
5595487 2533537 2533537 defendant Danyell Thomas skinner 588897 588897 Danyell, Thomas, of Kylmyngton, skinner 3

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);