names

52 rows where place_id = 589553

✎ 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
3597955 1866984 1866984 defendant Laxston John yeoman 589553 589553 Laxston, John, of St Osithe, yeoman 0
3597956 1866984 1866984 defendant Fraunceys John yeoman 589553 589553 Fraunceys, John, of St Osithe, yeoman 1
3609465 1870625 1870625 defendant Harreys William mariner 589553 589553 Harreys, William, of St Osithe, mariner 0
3609475 1870627 1870627 defendant Harreys William mariner 589553 589553 Harreys, William, of St Osithe, mariner 0
3650636 1910563 1910563 defendant Norton William laborer 589553 589553 Norton, William, of St Osithe, laborer 2
3719202 1932291 1932291 defendant Blore Thomas yeoman 589553 589553 Blore, Thomas, of St Osithe, yeoman 0
3728501 1935162 1935162 defendant Blore Thomas yeoman 589553 589553 Blore, Thomas, of St Osithe, yeoman 0
3734766 1937118 1937118 defendant Cawston John yeoman 589553 589553 Cawston, John, of St Osithe, yeoman 0
3749394 1941728 1941728 defendant Croydon John mercer 589553 589553 Croydon, John, of St Osithe, mercer 0
3759017 1944807 1944807 defendant Bateman William tanner 589553 589553 Bateman, William, of St Osithe, tanner 0
3772990 1949256 1949256 plaintiff Weston Richard yeoman 589553 589553 Weston, Richard, of St Osithe, yeoman 0
3772991 1949256 1949256 defendant Potfeld alias Molle John mariner 589553 589553 Potfeld alias Molle, John, of St Osithe, mariner 0
3848775 1973202 1973202 defendant Woodcoke William yeoman 589553 589553 Woodcoke, William, of St Osithe, yeoman 0
3850609 1973778 1973778 defendant Bett William husbandman 589553 589553 Bett, William, of St Osithe, husbandman 1
3868118 1979572 1979572 defendant Badcok John   589553 589553 Badcok, John, of St Osithe 0
3881698 1984127 1984127 defendant Sagor John yeoman 589553 589553 Sagor, John, of St Osithe, yeoman 0
3897220 1989287 1989287 defendant Cokcoke Clement yeoman 589553 589553 Cokcoke, Clement, of St Osithe, yeoman 0
4127673 2070189 2070189 defendant Sadler William yeoman 589553 589553 Sadler, William, of St Osithe, yeoman 0
4278537 2122428 2122428 defendant Blowers Elizabeth widow 589553 589553 Blowers, Elizabeth, of St Osithe, widow 1
4287292 2125512 2125512 defendant Blowers John, senior (legal representative) 589553 589553 Blowers, John, senior, of St Osithe, yeoman, administratrix of 0
4334897 2141933 2141933 defendant Browne Edward   589553 589553 Browne, Edward, of St Osithe, Essex clothier 1
4359248 2150469 2150469 defendant Richardson William clover 589553 589553 Richardson, William, of St Osithe, clover 0
4361974 2151442 2151442 defendant Wolman Henry yeoman 589553 589553 Wolman, Henry, of St Osithe, yeoman 0
4361975 2151442 2151442 defendant Mathew John butcher 589553 589553 Mathew, John, of St Osithe, butcher 1
4365881 2152833 2152833 defendant Ruffle or Russle John yeoman 589553 589553 Ruffle or Russle, John, of St Osithe, yeoman 0
4401584 2165127 2165127 defendant Rayner Robert miller 589553 589553 Rayner, Robert, of St Osithe, miller 0
4477075 2193487 2193487 defendant Coupere William   589553 589553 Coupere, William, of St Osithe 0
4493063 2198529 2198529 defendant Bourgh William   589553 589553 Bourgh, William, of St Osithe 0
4636010 2242095 2242095 plaintiff atte Fryth John   589553 589553 atte Fryth, John, of St Osithe 0
4835665 2307148 2307148 defendant Hunte John yeoman 589553 589553 Hunte, John, of St Osithe, yeoman 0
4846502 2310415 2310415 defendant Hunte John yeoman 589553 589553 Hunte, John, of St Osithe, yeoman 2
4915272 2331282 2331282 plaintiff Depyng John   589553 589553 Depyng, John, of St Osithe, prior & formerly of St Botulph's Colchester 0
4915273 2331282 2331282 defendant Depyng John   589553 589553 Depyng, John, of St Osithe, prior & formerly of St Botulph's Colchester 0
4993067 2354811 2354811 defendant Waryn William husbandman 589553 589553 Waryn, William, of St Osithe, husbandman 0
5129860 2395219 2395219 defendant Steyke William smith 589553 589553 Steyke, William, of St Osithe, smith 0
5314294 2449292 2449292 defendant Barfote John smith 589553 589553 Barfote, John, of St Osithe, smith 2
5323712 2452179 2452179 defendant Barfote John smith 589553 589553 (Barfote, John, of St Osithe, smith 1
5323713 2452179 2452179 defendant Marchall Ralph husbandman 589553 589553 Marchall, Ralph, of St Osithe, husbandman 2
5358308 2462652 2462652 defendant Hoton Richard yeoman 589553 589553 Hoton, Richard, of St Osithe, yeoman 1
5368093 2465647 2465647 defendant Neweton John   589553 589553 Neweton, John, of St Osithe, abbot of the Monastery 0
5381308 2469708 2469708 defendant Neweton John   589553 589553 Neweton, John, of St Osithe, abbot of the monastery 0
5385799 2471006 2471006 defendant Beverell Thomas husbandman 589553 589553 Beverell, Thomas, of St Osithe, husbandman 1
5479321 2498833 2498833 plaintiff Assheman John   589553 589553 Assheman, John, of St Osithe 1
5483364 2499971 2499971 defendant Page John, junior yeoman 589553 589553 Page, John, junior, of St Osithe, yeoman 0
5543340 2518035 2518035 defendant Pyke John dyer 589553 589553 Pyke, John, of St Osithe, dyer 0
5549351 2519860 2519860 defendant Medowe John carpenter 589553 589553 Medowe, John, of St Osithe, carpenter 0
5559311 2522693 2522693 defendant Stacy Hugh yeoman 589553 589553 Stacy, Hugh, of St Osithe, yeoman 0
5559315 2522693 2522693 defendant Medowe John carpenter 589553 589553 Medowe, John, of St Osithe, carpenter 4
5572279 2526444 2526444 defendant Aleyn William sherman 589553 589553 Aleyn, William, of St Osithe, sherman 0
5607015 2537089 2537089 defendant Coope William barker 589553 589553 Coope, William, of St Osithe, barker 0
5607018 2537089 2537089 defendant Tothe Ralph shoemaker 589553 589553 Tothe, Ralph, of St Osithe, shoemaker 3
5608847 2537668 2537668 defendant Newton John   589553 589553 Newton, John, of St Osithe, abbot of the Monastery 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);