names

40 rows where place_id = 590881

✎ 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
3602598 1868473 1868473 defendant Skepper Thomas smith 590881 590881 Skepper, Thomas, of Exnyng, smith 0
3713532 1930544 1930544 defendant Dawbry Thomas husbandman 590881 590881 Dawbry, Thomas, of Exnyng, husbandman 2
3728997 1935315 1935315 defendant Smyth William husbandman 590881 590881 Smyth, William, of Exnyng, husbandman 2
3728998 1935315 1935315 defendant Danbrye or Daubrye John husbandman 590881 590881 Danbrye or Daubrye, John, of Exnyng, husbandman 3
3754583 1943391 1943391 defendant Bregeman John husbandman 590881 590881 Bregeman, John, of Exnyng, husbandman, husbandman 1
3754691 1943428 1943428 defendant Carter Thomas husbandman 590881 590881 Carter, Thomas, of Exnyng, husbandman 0
3754692 1943428 1943428 defendant Westwoode John husbandman 590881 590881 Westwoode, John, of Exnyng, husbandman 1
3778496 1950991 1950991 defendant Davory Thomas husbandman 590881 590881 Davory, Thomas, of Exnyng, husbandman 0
3778523 1951000 1951000 defendant Dawbery John laborer 590881 590881 Dawbery, John, of Exnyng, laborer 2
3795783 1956548 1956548 defendant Mosse Robert butcher 590881 590881 Mosse, Robert, of Exnyng, butcher 0
3797630 1957156 1957156 defendant Dawbery John butcher 590881 590881 Dawbery, John, of Exnyng, butcher 2
3823334 1965212 1965212 defendant Carter Thomas yeoman 590881 590881 Carter, Thomas, of Exnyng, yeoman 0
3823335 1965212 1965212 defendant Westwod John husbandman 590881 590881 Westwod, John, of Exnyng, husbandman 1
3844478 1971817 1971817 defendant Dawbery John husbandman 590881 590881 Dawbery, John, of Exnyng, husbandman 4
3850008 1973590 1973590 defendant Dawbery John husbandman 590881 590881 Dawbery, John, of Exnyng, husbandman 0
3857203 1975886 1975886 defendant Dawbry John husbandman 590881 590881 Dawbry, John, of Exnyng, husbandman 1
3857207 1975887 1975887 defendant Dere John husbandman 590881 590881 Dere, John, of Exnyng, husbandman 1
3864894 1978460 1978460 defendant Barett John smith 590881 590881 Barett, John, of Exnyng, smith 0
3874619 1981730 1981730 defendant Dawbery John husbandman 590881 590881 Dawbery, John, of Exnyng, husbandman 4
3881522 1984081 1984081 defendant Dabree John laborer 590881 590881 Dabree, John, of Exnyng, laborer 3
3891283 1987352 1987352 defendant Fabyan John yeoman 590881 590881 Fabyan, John, of Exnyng, yeoman 0
3891284 1987352 1987352 defendant Garnett Henry husbandman 590881 590881 Garnett, Henry, of Exnyng, husbandman 1
4036265 2037653 2037653 plaintiff Howlett John, senior (legal representative) 590881 590881 Howlett, John, senior, of Exnyng, executrix of 0
4551553 2216423 2216423 defendant Ballesgap Richard   590881 590881 Ballesgap, Richard, of Exnyng 0
4571206 2222561 2222561 defendant Morys Ralph   590881 590881 Morys, Ralph, of Exnyng 1
4643427 2244180 2244180 defendant Thirlowe John smith 590881 590881 Thirlowe, John, of Exnyng, smith 4
4643434 2244181 2244181 defendant Thirlowe John smith 590881 590881 Thirlowe, John, of Exnyng, smith 4
4666699 2255307 2255307 defendant Dytton Thomas yeoman 590881 590881 Dytton, Thomas, of Exnyng, yeoman 0
4668109 2255732 2255732 defendant Bele William gent 590881 590881 Bele, William, of Exnyng, gent 0
4668111 2255733 2255733 defendant Dytton Thomas yeoman 590881 590881 Dytton, Thomas, of Exnyng, yeoman 0
4668113 2255734 2255734 defendant Dytton Thomas yeoman 590881 590881 Dytton, Thomas, of Exnyng, yeoman 0
4693244 2263388 2263388 defendant Dytton Thomas yeoman 590881 590881 Dytton, Thomas, of Exnyng, yeoman 0
4817240 2301484 2301484 defendant Barker Richard yeoman 590881 590881 Barker, Richard, of Exnyng, yeoman 0
4821324 2302749 2302749 defendant Cardener John husbandman 590881 590881 Cardener, John, of Exnyng, husbandman 0
5148107 2400592 2400592 defendant Grene Thomas miller 590881 590881 Grene, Thomas, of Exnyng, miller 0
5148108 2400592 2400592 defendant Sawyer John smith 590881 590881 Sawyer, John, of Exnyng, smith 1
5374613 2467665 2467665 defendant Fabyen John husbandman 590881 590881 Fabyen, John, of Exnyng, husbandman 0
5551012 2520323 2520323 defendant Hore John   590881 590881 Hore, John, of Exnyng, administrators of 0
5551013 2520323 2520323 defendant Hore Benedict husbandman 590881 590881 (Hore, Benedict, of Exnyng, husbandman 1
5551014 2520323 2520323 defendant Hore Joan widow 590881 590881 Hore, Joan, of Exnyng, widow 2

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