names

38 rows where place_id = 597295

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627997 1903611 1903611 defendant Bocher alias Glover William butcher 597295 597295 Bocher alias Glover, William, of Sawston, butcher 0
3641649 1907844 1907844 plaintiff Brayton Robert gent 597295 597295 Brayton, Robert, of Sawston, gent 0
3641651 1907845 1907845 plaintiff Brayton Robert gent 597295 597295 Brayton, Robert, of Sawston, gent 0
3641653 1907846 1907846 plaintiff Brayton Robert gent 597295 597295 Brayton, Robert, of Sawston, gent 0
3653921 1911492 1911492 defendant Potte John yeoman 597295 597295 Potte, John, of Sawston, yeoman 0
3656260 1912203 1912203 defendant Goddyng Richard husbandman 597295 597295 Goddyng, Richard, of Sawston, husbandman 2
3656261 1912203 1912203 defendant Belusshe Henry laborer 597295 597295 Belusshe, Henry, of Sawston, laborer 3
3670155 1916612 1916612 plaintiff Brayton Robert gent 597295 597295 Brayton, Robert, of Sawston, gent 0
3704648 1927740 1927740 defendant Apotte John yeoman 597295 597295 Apotte, John, of Sawston, yeoman 0
3715791 1931227 1931227 defendant Sawston William glover 597295 597295 Sawston, William, of Sawston, glover 0
3717154 1931650 1931650 defendant Holt William gent 597295 597295 Holt, William, of Sawston, gent 0
3721470 1933024 1933024 defendant at Dale John yeoman 597295 597295 at Dale, John, of Sawston, yeoman 0
3729954 1935621 1935621 defendant Carter John husbandman 597295 597295 Carter, John, of Sawston, husbandman 3
3736126 1937541 1937541 defendant Sawston William gent 597295 597295 Sawston, William, of Sawston, gent 1
3742545 1939540 1939540 defendant Holte John gent 597295 597295 Holte, John, of Sawston, gent 0
3742547 1939540 1939540 defendant Gardener Thomas husbandman 597295 597295 Gardener, Thomas, of Sawston, husbandman 2
3742549 1939540 1939540 defendant Dale John husbandman 597295 597295 Dale, John, of Sawston, husbandman 4
3743626 1939882 1939882 defendant Apott Alice widow 597295 597295 Apott, Alice, of Sawston, widow 1
3747184 1941038 1941038 defendant Holt William gent 597295 597295 Holt, William, of Sawston, gent 0
3758657 1944703 1944703 defendant Dall John yeoman 597295 597295 Dall, John, of Sawston, yeoman 1
3807558 1960272 1960272 defendant Gardyner Thomas yeoman 597295 597295 Gardyner, Thomas, of Sawston, yeoman 1
3807563 1960273 1960273 defendant Gardener Thomas yeoman 597295 597295 Gardener, Thomas, of Sawston, yeoman 1
3839779 1970370 1970370 plaintiff Wulworth alias Wolleward John   597295 597295 Wulworth alias Wolleward, John, of Sawston 0
3904013 1991583 1991583 defendant Ellys Thomas husbandman 597295 597295 Ellys, Thomas, of Sawston, husbandman 0
3914686 1995255 1995255 defendant Huddylston John esq 597295 597295 Huddylston, John, of Sawston, esq 0
3918582 1996540 1996540 defendant Campyon John yeoman 597295 597295 Campyon, John, of Sawston, yeoman 0
3972502 2014960 2014960 plaintiff Gardyner James gent 597295 597295 Gardyner, James, of Sawston, gent 0
4107850 2063084 2063084 defendant Fletyber Anthony clerk 597295 597295 Fletyber, Anthony, of Sawston, clerk 0
4140229 2074749 2074749 defendant Campion John husbandman 597295 597295 Campion, John, of Sawston, husbandman 1
4174245 2086449 2086449 defendant Holte Arthur yeoman 597295 597295 Holte, Arthur, of Sawston, yeoman 0
4198789 2095137 2095137 defendant Holte Arthur yeoman 597295 597295 Holte, Arthur, of Sawston, yeoman 1
4265154 2117984 2117984 defendant Samworth alias Samwell John butcher 597295 597295 Samworth alias Samwell, John, of Sawston, butcher 0
4363747 2152095 2152095 defendant Waterson John husbandman 597295 597295 Waterson, John, of Sawston, husbandman 0
4366702 2153139 2153139 defendant Harrison Roland blacksmith 597295 597295 Harrison, Roland, of Sawston, blacksmith 0
4989460 2353783 2353783 defendant Catour Henry husbandman 597295 597295 Catour, Henry, of Sawston, husbandman 0
5122651 2393057 2393057 defendant Pares Roger smith 597295 597295 Pares, Roger, of Sawston, smith 1
5565665 2524547 2524547 defendant Brayton Robert gent 597295 597295 Brayton, Robert, of Sawston, gent 0
5565667 2524548 2524548 defendant Bradley alias Glover John husbandman 597295 597295 Bradley alias Glover, John, of Sawston, husbandman 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);