names

25 rows where place_id = 592160

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606793 1869798 1869798 defendant Richeman John husbandman 592160 592160 Richeman, John, of Dynton, husbandman 0
3725237 1934181 1934181 defendant Mortymer John husbandman 592160 592160 Mortymer, John, of Dynton, husbandman 0
3788305 1954140 1954140 defendant Robyns Richard husbandman 592160 592160 Robyns, Richard, of Dynton, husbandman 0
3808103 1960427 1960427 plaintiff A Wood William (legal representative) 592160 592160 A Wood, William, of Dynton, yeoman, executrix of 0
3808842 1960646 1960646 plaintiff Awoode William (legal representative) 592160 592160 Awoode, William, of Dynton, yeoman, executrix of 0
3886055 1985587 1985587 defendant Attewood John husbandman 592160 592160 Attewood, John, of Dynton, husbandman 1
3886994 1985914 1985914 defendant Hodder Roger (legal representative) 592160 592160 Hodder, Roger, of Dynton, husbandman, executrix of 0
3886995 1985914 1985914 defendant Hodder Edith widow 592160 592160 Hodder, Edith, of Dynton, widow 1
3901759 1990811 1990811 defendant Ellys Edmund tailor 592160 592160 Ellys, Edmund, of Dynton, tailor 2
3907279 1992727 1992727 defendant Atwood John husbandman 592160 592160 Atwood, John, of Dynton, husbandman 0
3910235 1993737 1993737 defendant Symbarb Hugh, senior gent 592160 592160 Symbarb, Hugh, senior, of Dynton, gent 0
4028933 2034991 2034991 defendant Clement alias Broune William husbandman 592160 592160 Clement alias Broune, William, of Dynton, husbandman 0
4028935 2034992 2034992 defendant Clement alias Broune William husbandman 592160 592160 Clement alias Broune, William, of Dynton, husbandman 0
4178440 2087932 2087932 defendant Loostman or Looftman alias Lusman or Lufman John husbandman 592160 592160 Loostman or Looftman alias Lusman or Lufman, John, of Dynton, husbandman 0
4274930 2121183 2121183 defendant Daniell Henry yeoman 592160 592160 Daniell, Henry, of Dynton, yeoman 0
4284295 2124433 2124433 defendant Wilson Richard yeoman 592160 592160 Wilson, Richard, of Dynton, yeoman 0
4310894 2133959 2133959 defendant Dannyell Henry yeoman 592160 592160 Dannyell, Henry, of Dynton, yeoman 0
4718206 2271033 2271033 defendant Eston Philip tailor 592160 592160 Eston, Philip, of Dynton, tailor 0
4955418 2343580 2343580 defendant Lambard John gent 592160 592160 Lambard, John, of Dynton, gent 0
5057863 2373922 2373922 defendant Chapman William yeoman 592160 592160 Chapman, William, of Dynton,yeoman 0
5081065 2380839 2380839 defendant Chapman William yeoman 592160 592160 Chapman, William, of Dynton, yeoman 0
5223270 2422500 2422500 defendant Colet Thomas husbandman 592160 592160 Colet, Thomas, of Dynton, husbandman 2
5237431 2426531 2426531 defendant Frankeleyn Thomas husbandman 592160 592160 Frankeleyn, Thomas, of Dynton, husbandman 0
5252477 2430885 2430885 defendant Lamberd John gent 592160 592160 Lamberd, John, of Dynton, gent 0
5593736 2533029 2533029 defendant Richeman John   592160 592160 Richeman, John, of Dynton, plough maker 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);