names

45 rows where place_id = 606539

✎ 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
3665570 1915182 1915182 defendant Constable Joan widow 606539 606539 Constable, Joan, of New Shoreham, widow 0
3973171 2015187 2015187 defendant Gravesend William yeoman 606539 606539 Gravesend, William, of New Shoreham, yeoman 3
4061342 2046459 2046459 defendant Gravesend Richard yeoman 606539 606539 Gravesend, Richard, of New Shoreham, yeoman 0
4061344 2046460 2046460 defendant Gravesend Richard yeoman 606539 606539 Gravesend, Richard, of New Shoreham, yeoman 0
4063869 2047361 2047361 defendant Gravesend Richard yeoman 606539 606539 Gravesend, Richard, of New Shoreham, yeoman 0
4063872 2047361 2047361 defendant Gravesend John yeoman 606539 606539 Gravesend, John, of New Shoreham, yeoman 3
4066721 2048395 2048395 defendant Gravesend Richard yeoman 606539 606539 Gravesend, Richard, of New Shoreham, yeoman 0
4074309 2051111 2051111 defendant Ludgater Robert merchant 606539 606539 Ludgater, Robert, of New Shoreham, yeoman, merchant 0
4083701 2054442 2054442 defendant Gravesend Richard yeoman 606539 606539 Gravesend, Richard, of New Shoreham, yeoman 0
4090648 2056943 2056943 defendant Gravesend John merchant 606539 606539 Gravesend, John, of New Shoreham, merchant 0
4095687 2058788 2058788 defendant Gravesend John yeoman 606539 606539 Gravesend, John, of New Shoreham, yeoman 0
4095732 2058806 2058806 defendant Gravesend John yeoman 606539 606539 Gravesend, John, of New Shoreham, yeoman 0
4098617 2059836 2059836 defendant Ludgater Robert yeoman 606539 606539 Ludgater, Robert, of New Shoreham, yeoman 0
4098618 2059836 2059836 defendant Woddyns John yeoman 606539 606539 Woddyns, John, of New Shoreham, yeoman 1
4099892 2060286 2060286 defendant Erle Richard gent 606539 606539 Erle, Richard, of New Shoreham, gent 0
4113124 2064963 2064963 defendant Gravesend Richard yeoman 606539 606539 Gravesend, Richard, of New Shoreham, yeoman 0
4113128 2064965 2064965 defendant Phyllyppe or Phillipes Edward merchant 606539 606539 Phyllyppe or Phillipes, Edward, of New Shoreham, merchant 0
4120407 2067574 2067574 defendant Hester John beer brewer 606539 606539 Hester, John, of New Shoreham, beer brewer 0
4127031 2069957 2069957 defendant Hestar John beer brewer 606539 606539 Hestar, John, of New Shoreham, beer brewer 0
4138311 2074068 2074068 defendant Erle Richard husbandman 606539 606539 Erle, Richard, of New Shoreham, husbandman 1
4140813 2074951 2074951 defendant Earle Richard gent 606539 606539 Earle, Richard, of New Shoreham, gent 0
4178168 2087835 2087835 defendant Hester John brewer 606539 606539 Hester, John, of New Shoreham, brewer 0
4178169 2087835 2087835 defendant Clyff Thomas merchant 606539 606539 Clyff, Thomas, of New Shoreham, merchant 1
4189145 2091696 2091696 defendant Clarke John tailor 606539 606539 Clarke, John, of New Shoreham, tailor 0
4189146 2091696 2091696 defendant Slutter Richard tailor 606539 606539 Slutter, Richard, of New Shoreham, tailor 1
4189147 2091696 2091696 defendant Cookes Thomas shoemaker 606539 606539 Cookes, Thomas, of New Shoreham, shoemaker 2
4191815 2092692 2092692 defendant Hester John brewer 606539 606539 Hester, John, of New Shoreham, brewer 1
4201466 2096059 2096059 defendant Hester John brewer 606539 606539 Hester, John, of New Shoreham, brewer 0
4201467 2096059 2096059 defendant Clyff Thomas merchant 606539 606539 Clyff, Thomas, of New Shoreham, merchant 1
4220104 2102533 2102533 defendant Keys William yeoman 606539 606539 Keys, William, of New Shoreham, yeoman 3
4224565 2104070 2104070 defendant Luntley Thomas merchant 606539 606539 Luntley, Thomas, of New Shoreham, merchant 1
4227102 2104954 2104954 defendant Cowper Balthazar yeoman 606539 606539 Cowper, Balthazar, of New Shoreham, yeoman 0
4250603 2113185 2113185 defendant Luntley Thomas merchant 606539 606539 Luntley, Thomas, of New Shoreham, merchant 1
4317492 2136233 2136233 defendant Hardman Richard yeoman 606539 606539 Hardman, Richard, of New Shoreham, yeoman 0
4318043 2136417 2136417 defendant Harman Richard mercer 606539 606539 Harman, Richard, of New Shoreham, mercer 0
4318116 2136445 2136445 defendant Harman Richard mercer 606539 606539 Harman, Richard, of New Shoreham, mercer 2
4330949 2140651 2140651 defendant Harman Richard mercer 606539 606539 Harman, Richard, of New Shoreham, mercer 2
4359888 2150700 2150700 defendant Harvye Francis butcher 606539 606539 Harvye, Francis, of New Shoreham, butcher 0
4394287 2162687 2162687 defendant Bowier John yeoman 606539 606539 Bowier, John, of New Shoreham, yeoman 2
5087738 2382799 2382799 defendant Benfyld Joan widow 606539 606539 Benfyld, Joan, of New Shoreham, widow 1
5183653 2410953 2410953 plaintiff Dammer Richard   606539 606539 Dammer, Richard, of New Shoreham 0
5183655 2410953 2410953 defendant Curteys William merchant 606539 606539 Curteys, William, of New Shoreham, merchant 1
5203982 2416915 2416915 plaintiff Daumier Richard   606539 606539 Daumier, Richard, of New Shoreham 0
5203984 2416915 2416915 defendant Curteys William merchant 606539 606539 Curteys, William, of New Shoreham, merchant 1
5378826 2468962 2468962 defendant Cukson John yeoman 606539 606539 Cukson, John, of New Shoreham, yeoman 1

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