names

26 rows where place_id = 624533

✎ 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
3758703 1944715 1944715 defendant Nycolson Thomas yeoman 624533 624533 Nycolson, Thomas, of Stratton, Cornw, yeoman 3
3775576 1950106 1950106 defendant Marres Thomas gent 624533 624533 Marres, Thomas, of Stratton, Cornw, gent 0
3776353 1950354 1950354 defendant Walsheman alias Baylly John dyer 624533 624533 Walsheman alias Baylly, John, of Stratton, Cornw, dyer 0
3848026 1972957 1972957 defendant Gyste or Eyste John husbandman 624533 624533 Gyste or Eyste, John, of Stratton, Cornw, husbandman 4
3865378 1978635 1978635 defendant Trevelian John yeoman 624533 624533 Trevelian, John, of Stratton, Cornw, yeoman 2
3915703 1995627 1995627 defendant Nycoll John yeoman 624533 624533 Nycoll, John, of Stratton, Cornw, yeoman 0
4090238 2056795 2056795 defendant Juell or Inell Richard yeoman 624533 624533 Juell or Inell, Richard, of Stratton, Cornw, yeoman 0
4131063 2071427 2071427 defendant Corye John draper 624533 624533 Corye, John, of Stratton, Cornw, draper 0
4203745 2096867 2096867 defendant Juell Samuel chapman 624533 624533 Juell, Samuel, of Stratton, Cornw, chapman 0
4308831 2133238 2133238 defendant Yeo Nicholas merchant 624533 624533 Yeo, Nicholas, of Stratton, Cornw, merchant 0
4383325 2159136 2159136 defendant Will alias Hell Nicholas yeoman 624533 624533 Will alias Hell, Nicholas, of Stratton, Cornw, yeoman 0
4749974 2280467 2280467 defendant Banton William yeoman 624533 624533 Banton, William, of Stratton, Cornw, yeoman 2
4861669 2315026 2315026 defendant Dyrehill John dyer 624533 624533 Dyrehill, John, of Stratton, Cornw, dyer 0
4984150 2352190 2352190 defendant Bampton John gent 624533 624533 Bampton, John, of Stratton, Cornw, gent 1
4984247 2352218 2352218 defendant Bampton John gent 624533 624533 Bampton, John, of Stratton, Cornw, gent 1
5028656 2365257 2365257 defendant Flanche John dyer 624533 624533 Flanche, John, of Stratton, Cornw, dyer 0
5066259 2376436 2376436 defendant Hurdewyke Robert gent 624533 624533 Hurdewyke, Robert, of Stratton, Cornw, gent 1
5073277 2378494 2378494 defendant Flanche John dyer 624533 624533 Flanche, John, of Stratton, Cornw, dyer 0
5073639 2378598 2378598 defendant Burnard Thomas husbandman 624533 624533 Burnard, Thomas, of Stratton, Cornw, husbandman 0
5089211 2383214 2383214 defendant Bampton John gent 624533 624533 Bampton, John, of Stratton, Cornw, gent 2
5295526 2443682 2443682 defendant Martyn John husbandman 624533 624533 Martyn, John, of Stratton, Cornw, husbandman 1
5296553 2443981 2443981 defendant Drewe Richard yeoman 624533 624533 Drewe, Richard, of Stratton, Cornw, yeoman 0
5488365 2501415 2501415 defendant Jolyf John dyer 624533 624533 Jolyf, John, of Stratton, Cornw, dyer 0
5499120 2504680 2504680 defendant Longeford John gent 624533 624533 Longeford, John, of Stratton, Cornw, gent 0
5499123 2504681 2504681 defendant Longeford John gent 624533 624533 Longeford, John, of Stratton, Cornw, gent 0
5499126 2504682 2504682 defendant Longford John gent 624533 624533 Longford, John, of Stratton, Cornw, gent 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);