names

73 rows where place_id = 610768

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3685062 1921471 1921471 defendant Smyth Richard husbandman 610768 610768 Smyth, Richard, of Brighthelmeston, husbandman 0
3991335 2021655 2021655 plaintiff Brakepole Thomas   610768 610768 Brakepole, Thomas, of Brighthelmeston 0
4057378 2045020 2045020 defendant Godley Richard yeoman 610768 610768 Godley, Richard, of Brighthelmeston, yeoman 2
4057379 2045020 2045020 defendant Chamber Thomas yeoman 610768 610768 Chamber, Thomas, of Brighthelmeston, yeoman 3
4127786 2070227 2070227 defendant Nicoll Richard fisherman 610768 610768 Nicoll, Richard, of Brighthelmeston, fisherman 0
4135137 2072884 2072884 defendant Norton Richard innholder 610768 610768 Norton, Richard, of Brighthelmeston, innholder 1
4135609 2073059 2073059 defendant Brackepole Thomas yeoman 610768 610768 Brackepole, Thomas, of Brighthelmeston, yeoman 2
4135610 2073059 2073059 defendant Ockenden Edward yeoman 610768 610768 Ockenden, Edward, of Brighthelmeston, yeoman 3
4139520 2074498 2074498 defendant Turnor Samuel yeoman 610768 610768 Turnor, Samuel, of Brighthelmeston, yeoman 0
4168990 2084648 2084648 defendant Okenden Edward (legal representative) 610768 610768 Okenden, Edward, of Brighthelmeston, fishmerman, administratrix of 0
4168992 2084648 2084648 defendant Jackson Thomas fishmerman 610768 610768 Jackson, Thomas, of Brighthelmeston, fishmerman 2
4169511 2084839 2084839 defendant Bowredge Bartholomew mercer 610768 610768 Bowredge, Bartholomew, of Brighthelmeston, mercer 0
4181623 2089058 2089058 defendant Leedes Edward yeoman 610768 610768 Leedes, Edward, of Brighthelmeston, yeoman 0
4186170 2090648 2090648 defendant Colbye John fisherman 610768 610768 Colbye, John, of Brighthelmeston, fisherman 0
4215583 2100948 2100948 defendant Streter John fisherman 610768 610768 Streter, John, of Brighthelmeston, fisherman 0
4216741 2101349 2101349 defendant Hyncok Francis butcher 610768 610768 Hyncok, Francis, of Brighthelmeston, butcher 0
4219978 2102489 2102489 defendant Streter John fisherman 610768 610768 Streter, John, of Brighthelmeston, fisherman 2
4219979 2102489 2102489 defendant Hickley John fisherman 610768 610768 Hickley, John, of Brighthelmeston, fisherman 3
4220233 2102580 2102580 defendant Streter John fisherman 610768 610768 Streter, John, of Brighthelmeston, fisherman 0
4224566 2104070 2104070 defendant Streater John fisherman 610768 610768 Streater, John, of Brighthelmeston, yeoman, fisherman 2
4226025 2104572 2104572 defendant Hincocke Francis butcher 610768 610768 Hincocke, Francis, of Brighthelmeston, butcher 1
4226905 2104881 2104881 defendant Streter John fisherman 610768 610768 Streter, John, of Brighthelmeston, fisherman 1
4226906 2104881 2104881 defendant Streter Richard fisherman 610768 610768 Streter, Richard, of Brighthelmeston, fisherman 2
4226928 2104890 2104890 defendant Elgate John tailor 610768 610768 Elgate, John, of Brighthelmeston, tailor 1
4226929 2104890 2104890 defendant Nicholl Thomas mariner 610768 610768 Nicholl, Thomas, of Brighthelmeston, or of Michinge, mariner 2
4227148 2104973 2104973 defendant Pyper Stephen husbandman 610768 610768 Pyper, Stephen, of Brighthelmeston, husbandman 0
4230313 2106093 2106093 defendant Nycholes Richard fisher 610768 610768 Nycholes, Richard, of Brighthelmeston, fisher 1
4237526 2108716 2108716 defendant Cartwright William scrivener 610768 610768 Cartwright, William, of Brighthelmeston, scrivener 0
4240541 2109819 2109819 defendant Bradford Edward (legal representative) 610768 610768 Bradford, Edward, of Brighthelmeston, fisherman, administrator of 0
4240542 2109819 2109819 defendant Howell Henry fisherman 610768 610768 Howell, Henry, of Brighthelmeston, fisherman 1
4250604 2113185 2113185 defendant Streater John yeoman 610768 610768 Streater, John, of Brighthelmeston, yeoman 2
4250605 2113185 2113185 defendant Nicholls Richard fisherman 610768 610768 Nicholls, Richard, of Brighthelmeston, yeoman, fisherman 3
4267323 2118706 2118706 defendant Elgate John tailor 610768 610768 Elgate, John, of Brighthelmeston, tailor 1
4267324 2118706 2118706 defendant Nicholl Thomas mariner 610768 610768 Nicholl, Thomas, of Brighthelmeston, or of Michinge, mariner 2
4288992 2126119 2126119 defendant Humfrey Richard fisherman 610768 610768 (Humfrey, Richard, of Brighthelmeston, fisherman 1
4309334 2133421 2133421 defendant Gifforde Richard merchant 610768 610768 Gifforde, Richard, of Brighthelmeston, merchant 0
4311555 2134180 2134180 defendant Adeane John butcher 610768 610768 Adeane, John, of Brighthelmeston, butcher 1
4313201 2134729 2134729 defendant Duplake Thomas, senior husbandman 610768 610768 Duplake, Thomas, senior, of Brighthelmeston, fisherman, or of Telscombe, husbandman 0
4314378 2135140 2135140 defendant Duplake Thomas fisherman 610768 610768 Duplake, Thomas, of Brighthelmeston, fisherman 0
4314927 2135331 2135331 defendant Kyllyck Richard merchant 610768 610768 Kyllyck, Richard, of Brighthelmeston, merchant 0
4314928 2135331 2135331 defendant Awood Richard fisherman 610768 610768 Awood, Richard, of Brighthelmeston, fisherman 1
4314929 2135331 2135331 defendant Myller John fisherman 610768 610768 Myller, John, of Brighthelmeston, fisherman 2
4318420 2136551 2136551 defendant Waters Nicholas tanner 610768 610768 Waters, Nicholas, of Brighthelmeston, tanner 0
4318421 2136551 2136551 defendant Farmer John butcher 610768 610768 Farmer, John, of Brighthelmeston, butcher 1
4318422 2136551 2136551 defendant Woodlande John butcher 610768 610768 Woodlande, John, of Brighthelmeston, butcher 2
4318526 2136592 2136592 defendant Fawssett Francis tailor 610768 610768 Fawssett, Francis, of Brighthelmeston, tailor 0
4323113 2138144 2138144 defendant Norton Robert clerk 610768 610768 Norton, Robert, of Brighthelmeston, clerk 0
4363414 2151989 2151989 defendant Gunter John   610768 610768 Gunter, John, of Brighthelmeston 3
4364942 2152514 2152514 defendant Nicholson Mark merchant 610768 610768 Nicholson, Mark, of Brighthelmeston, merchant 3
4367166 2153313 2153313 defendant Watkynson Brian   610768 610768 Watkynson, Brian, of Brighthelmeston chapman 1
4367168 2153313 2153313 defendant Nicolson Mark chapman 610768 610768 Nicolson, Mark, of Brighthelmeston, chapman 3
4367902 2153571 2153571 defendant Tuttey Thomas vintner 610768 610768 Tuttey, Thomas, of Brighthelmeston, yeoman, vintner 0
4367912 2153574 2153574 defendant Buckerell Stephen fisherman 610768 610768 Buckerell, Stephen, of Brighthelmeston, fisherman 1
4367913 2153574 2153574 defendant Buckerell Robert fisherman 610768 610768 Buckerell, Robert, of Brighthelmeston, fisherman 2
4370551 2154518 2154518 defendant Freeland Thomas fisherman 610768 610768 Freeland, Thomas, of Brighthelmeston, fisherman 2
4370552 2154518 2154518 defendant Freeman Richard fisherman 610768 610768 Freeman, Richard, of Brighthelmeston, fisherman 3
4380302 2158058 2158058 defendant Ede Robert blacksmith 610768 610768 Ede, Robert, of Brighthelmeston, blacksmith 2
4380647 2158186 2158186 defendant Mason Anthony yeoman 610768 610768 Mason, Anthony, of Brighthelmeston, yeoman 0
4389885 2161241 2161241 defendant Watkynson Brian mercer 610768 610768 Watkynson, Brian, of Brighthelmeston, mercer 0
4389886 2161241 2161241 defendant Watkynson Mathew mercer 610768 610768 Watkynson, Mathew, of Brighthelmeston, mercer 1
4389887 2161241 2161241 defendant Harffle Edward shoemaker 610768 610768 Harffle, Edward, of Brighthelmeston, shoemaker 2
4389888 2161241 2161241 defendant Gunter John chapman 610768 610768 Gunter, John, of Brighthelmeston, chapman 3
4394285 2162687 2162687 defendant Nicholson Mark yeoman 610768 610768 Nicholson, Mark, of Brighthelmeston, yeoman 0
4404273 2166001 2166001 defendant Nicholl Richard   610768 610768 Nicholl, Richard, of Brighthelmeston, sailor 0
4404274 2166001 2166001 defendant Streater John fisherman 610768 610768 Streater, John, of Brighthelmeston, sailor, fisherman 1
4404278 2166002 2166002 defendant Hardinge Randolph   610768 610768 Hardinge, Randolph, of Brighthelmeston, sailor. Fisher 2
4574029 2223400 2223400 defendant Elyot William   610768 610768 Elyot, William, of Brighthelmeston 0
4582726 2226036 2226036 defendant Hale Robert   610768 610768 Hale, Robert, of Brighthelmeston 3
5335481 2455681 2455681 defendant Sacre John   610768 610768 Sacre, John, of Brighthelmeston, "repyer" 0
5335484 2455682 2455682 defendant Sacre John   610768 610768 Sacre, John, of Brighthelmeston, "repyer" 0
5335487 2455683 2455683 defendant Sacre John   610768 610768 Sacre, John, of Brighthelmeston, "repyer" 0
5516247 2509918 2509918 defendant Frensshe Thomas yeoman 610768 610768 Frensshe, Thomas, of Brighthelmeston, yeoman 2
5575008 2527265 2527265 defendant Smyth Richard yeoman 610768 610768 Smyth, Richard, of Brighthelmeston, 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);