names

17 rows where place_id = 591851

✎ 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
3605796 1869479 1869479 defendant Stempe Richard husbandman 591851 591851 Stempe, Richard, of Old Alresford, husbandman 0
3605798 1869479 1869479 defendant Williams John husbandman 591851 591851 Williams, John, of Old Alresford, husbandman 2
3617465 1873082 1873082 defendant Hokley John husbandman 591851 591851 (Hokley, John, of Old Alresford, husbandman 1
3895705 1988770 1988770 plaintiff (not given) Roger rector of Stokley 591851 591851 Stokley, Roger, of Old Alresford, rector of Warneford 0
4684044 2260618 2260618 defendant Averey Roger husbandman 591851 591851 Averey, Roger, of Old Alresford, husbandman 0
4684045 2260618 2260618 defendant Putteman John husbandman 591851 591851 Putteman, John, of Old Alresford, husbandman 1
4684046 2260618 2260618 defendant Frye Ralph husbandman 591851 591851 Frye, Ralph, of Old Alresford, husbandman 2
4684047 2260618 2260618 defendant Brydman Roger husbandman 591851 591851 Brydman, Roger, of Old Alresford, husbandman 3
4684048 2260618 2260618 defendant atte Legh John husbandman 591851 591851 atte Legh, John, of Old Alresford, husbandman 4
5015353 2361372 2361372 defendant Torshawe William, junior husbandman 591851 591851 Torshawe, William, junior, of Old Alresford, husbandman 0
5015357 2361372 2361372 defendant Payn Richard husbandman 591851 591851 (Payn, Richard, of Old Alresford, husbandman 4
5015358 2361372 2361372 defendant Ayleward alias Donner John husbandman 591851 591851 Ayleward alias Donner, John, of Old Alresford, husbandman 5
5057079 2373696 2373696 defendant Martyn John husbandman 591851 591851 Martyn, John, of Old Alresford, husbandman 1
5245380 2428804 2428804 defendant Braban John husbandman 591851 591851 Braban, John, of Old Alresford, husbandman 0
5395851 2473898 2473898 defendant Heyward John husbandman 591851 591851 Heyward, John, of Old Alresford, husbandman 1
5422579 2481703 2481703 defendant Hayward John husbandman 591851 591851 Hayward, John, of Old Alresford, husbandman 1
5494347 2503209 2503209 defendant Clerk John yeoman 591851 591851 Clerk, John, of Old Alresford, yeoman 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);