names

21 rows where place_id = 588818

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595697 1866282 1866282 defendant Eyer William clerk 588818 588818 Eyer, William, of Sutton, Isle of Ely, clerk 2
3837315 1969580 1969580 defendant Buck John husbandman 588818 588818 (Buck, John, of Sutton, Isle of Ely, husbandman 1
3837316 1969580 1969580 defendant Smyth William husbandman 588818 588818 Smyth, William, of Sutton, Isle of Ely, husbandman 2
4133699 2072387 2072387 defendant Foster Andrew husbandman 588818 588818 Foster, Andrew, of Sutton, Isle of Ely, husbandman 1
4242124 2110358 2110358 defendant Gibbes John, senior yeoman 588818 588818 Gibbes, John, senior, of Sutton, Isle of Ely, yeoman 3
4251816 2113596 2113596 defendant Gibbs John, senior yeoman 588818 588818 Gibbs, John, senior, of Sutton, Isle of Ely, yeoman 3
4251951 2113642 2113642 defendant Shoncke John yeoman 588818 588818 Shoncke, John, of Sutton, Isle of Ely, yeoman 1
4298714 2129640 2129640 defendant Custance Robert yeoman 588818 588818 Custance, Robert, of Sutton, Isle of Ely, yeoman 1
4343072 2144848 2144848 defendant Webb Sarah spinster 588818 588818 Webb, Sarah, of Sutton, Isle of Ely, spinster 1
4343075 2144849 2144849 defendant Foster John, junior yeoman 588818 588818 Foster, John, junior, of Sutton, Isle of Ely, yeoman 1
4348751 2146824 2146824 defendant Higham John gent 588818 588818 Higham, John, of Sutton, Isle of Ely, gent 0
4394114 2162633 2162633 defendant Cheesewrite Andrew, junior   588818 588818 Cheesewrite, Andrew, junior, of Sutton, Isle of Ely 0
4394115 2162633 2162633 defendant Cheesewrite Robert husbandman 588818 588818 Cheesewrite, Robert, of Sutton, Isle of Ely, husbandman 1
4941098 2339238 2339238 plaintiff Dygreve John   588818 588818 Dygreve, John, of Sutton, Isle of Ely 0
4967208 2347124 2347124 defendant Munde Thomas tailor 588818 588818 Munde, Thomas, of Sutton, Isle of Ely, tailor 0
5236167 2426165 2426165 defendant Bedyngham alias Barbour John husbandman 588818 588818 Bedyngham alias Barbour, John, of Sutton, Isle of Ely, husbandman 0
5255267 2431764 2431764 defendant Graneham or Graveham William husbandman 588818 588818 Graneham or Graveham, William, of Sutton, Isle of Ely, husbandman 0
5287475 2441359 2441359 defendant Recher John husbandman 588818 588818 Recher, John, of Sutton, Isle of Ely, husbandman 1
5287479 2441360 2441360 defendant Recher John   588818 588818 Recher, John, of Sutton, Isle of Ely 1
5485618 2500603 2500603 defendant Maryet William butcher 588818 588818 Maryet, William, of Sutton, Isle of Ely, butcher 0
5565298 2524437 2524437 plaintiff Buk William, senior   588818 588818 Buk, William, senior, of Sutton, Isle of Ely 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);