names

25 rows where place_id = 606091

✎ 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
3663986 1914680 1914680 defendant Hoke Thomas clerk 606091 606091 Hoke, Thomas, of West Depyng, clerk 0
3671325 1917006 1917006 defendant Mason Thomas yeoman 606091 606091 Mason, Thomas, of West Depyng, yeoman 1
3671328 1917007 1917007 defendant Mason Thomas yeoman 606091 606091 Mason, Thomas, of West Depyng, yeoman 1
3854325 1974992 1974992 defendant Grome Robert husbandman 606091 606091 Grome, Robert, of West Depyng, husbandman 0
3854327 1974993 1974993 defendant Irnold Robert husbandman 606091 606091 Irnold, Robert, of West Depyng, husbandman 0
3855085 1975221 1975221 defendant Irnold Robert husbandman 606091 606091 Irnold, Robert, of West Depyng, husbandman 0
3917580 1996238 1996238 defendant Arnold Robert husbandman 606091 606091 Arnold, Robert, of West Depyng, husbandman 0
3958221 2009948 2009948 defendant Roughscote William husbandman 606091 606091 Roughscote, William, of West Depyng, husbandman 0
3981506 2018146 2018146 defendant Hall Thomas innholder 606091 606091 Hall, Thomas, of West Depyng, innholder 0
3981507 2018146 2018146 defendant Turner William cutler 606091 606091 Turner, William, of West Depyng, cutler 1
3981508 2018146 2018146 defendant Heynes Henry butcher 606091 606091 Heynes, Henry, of West Depyng, butcher 2
3988609 2020669 2020669 defendant Hall Thomas yeoman 606091 606091 Hall, Thomas, of West Depyng, yeoman 0
4423731 2172266 2172266 plaintiff Harel Thomas   606091 606091 Harel, Thomas, of West Depyng 0
4859818 2314441 2314441 defendant Squyer Simon husbandman 606091 606091 Squyer, Simon, of West Depyng, husbandman 0
4910249 2329721 2329721 plaintiff Baker John   606091 606091 Baker, John, of West Depyng 2
5082854 2381376 2381376 defendant Brons or Brous William husbandman 606091 606091 Brons or Brous, William, of West Depyng, husbandman 2
5099630 2386327 2386327 defendant Palmer William husbandman 606091 606091 Palmer, William, of West Depyng, husbandman 0
5112540 2390047 2390047 defendant Morton Richard miller 606091 606091 Morton, Richard, of West Depyng, miller 0
5153319 2402124 2402124 defendant Morton Richard miller 606091 606091 Morton, Richard, of West Depyng, miller 0
5170780 2407177 2407177 defendant Morton Richard miller 606091 606091 Morton, Richard, of West Depyng, miller 0
5234127 2425574 2425574 defendant Slyman Thomas   606091 606091 Slyman, Thomas, of West Depyng 0
5335971 2455831 2455831 defendant Sutton Robert husbandman 606091 606091 Sutton, Robert, of West Depyng, husbandman 0
5335973 2455832 2455832 defendant Sutton Robert husbandman 606091 606091 Sutton, Robert, of West Depyng, husbandman 0
5337320 2456232 2456232 defendant Sutton Robert husbandman 606091 606091 Sutton, Robert, of West Depyng, husbandman 0
5377145 2468441 2468441 defendant Hornby George gent 606091 606091 Hornby, George, of West Depyng, 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);