names

67 rows where place_id = 589641

✎ 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
3598261 1867087 1867087 defendant Underwode William laborer 589641 589641 Underwode, William, of Shorne, laborer 0
3604353 1869028 1869028 defendant Page Thomas yeoman 589641 589641 Page, Thomas, of Shorne, yeoman 0
3605023 1869233 1869233 defendant at Wode William laborer 589641 589641 at Wode, William, of Shorne, laborer 2
3653526 1911370 1911370 defendant Cryslate Richard husbandman 589641 589641 Cryslate, Richard, of Shorne, husbandman 0
3721560 1933048 1933048 defendant Hawke John yeoman 589641 589641 Hawke, John, of Shorne, yeoman 0
3721561 1933048 1933048 defendant Byshop Thomas yeoman 589641 589641 Byshop, Thomas, of Shorne, yeoman 1
3776293 1950331 1950331 defendant Webster Thomas husbandman 589641 589641 Webster, Thomas, of Shorne, husbandman 2
3818327 1963637 1963637 defendant Arderne John yeoman 589641 589641 Arderne, John, of Shorne, yeoman 1
3826850 1966246 1966246 defendant Cole Edward clerk 589641 589641 Cole, Edward, of Shorne, clerk 0
3826851 1966246 1966246 defendant Wyleman Geoffrey chaplain 589641 589641 Wyleman, Geoffrey, of Shorne, chaplain 1
3826853 1966247 1966247 defendant Wyldeman Geoffrey   589641 589641 Wyldeman, Geoffrey, of Shorne 0
3876282 1982307 1982307 defendant Hawke Richard husbandman 589641 589641 Hawke, Richard, of Shorne, husbandman 0
3915004 1995371 1995371 defendant Hutteworth John yeoman 589641 589641 Hutteworth, John, of Shorne, yeoman 2
3946474 2005836 2005836 defendant Smyth William yeoman 589641 589641 Smyth, William, of Shorne, yeoman 0
3958957 2010215 2010215 defendant Smyth Robert husbandman 589641 589641 Smyth, Robert, of Shorne, husbandman 0
3964954 2012348 2012348 defendant Balden John yeoman 589641 589641 Balden, John, of Shorne, yeoman 0
3965581 2012575 2012575 defendant Franke Henry yeoman 589641 589641 Franke, Henry, of Shorne, yeoman 0
4013583 2029593 2029593 defendant Balden John yeoman 589641 589641 Balden, John, of Shorne, yeoman 0
4090031 2056717 2056717 defendant Jetter Richard yeoman 589641 589641 Jetter, Richard, of Shorne, yeoman 0
4090033 2056718 2056718 defendant Reynolde David yeoman 589641 589641 Reynolde, David, of Shorne, yeoman 0
4193662 2093351 2093351 defendant Becher James clerk 589641 589641 Becher, James, of Shorne, clerk 0
4311306 2134100 2134100 defendant Colte Stephen gent 589641 589641 Colte, Stephen, of Shorne, gent 0
4319409 2136894 2136894 defendant Highsted Ralph   589641 589641 Highsted, Ralph, of Shorne, collar maker 0
4478715 2194008 2194008 defendant Hauk John   589641 589641 Hauk, John, of Shorne 0
4493584 2198698 2198698 plaintiff Bateman John   589641 589641 Bateman, John, of Shorne 0
4493585 2198698 2198698 defendant Bateman Richard   589641 589641 Bateman, Richard, of Shorne 0
4515611 2205305 2205305 defendant Aleyn John   589641 589641 Aleyn, John, of Shorne 0
4558298 2218537 2218537 defendant Tebaud Robert   589641 589641 Tebaud, Robert, of Shorne 2
4603448 2232270 2232270 defendant Webbe Thomas   589641 589641 Webbe, Thomas, of Shorne 0
4694927 2263904 2263904 defendant Sabyne John butcher 589641 589641 Sabyne, John, of Shorne, butcher 0
4696015 2264238 2264238 defendant Hoke John husbandman 589641 589641 Hoke, John, of Shorne, husbandman 0
4707212 2267635 2267635 defendant Shepey John chandler 589641 589641 Shepey, John, of Shorne, chandler 0
4707719 2267780 2267780 defendant Rolfe Robert butcher 589641 589641 Rolfe, Robert, of Shorne, butcher 1
4712875 2269338 2269338 defendant Chambre Richard husbandman 589641 589641 Chambre, Richard, of Shorne, husbandman 1
4750371 2280589 2280589 defendant Rolf John husbandman 589641 589641 Rolf, John, of Shorne, husbandman 0
4770499 2286749 2286749 defendant Chapman Stephen laborer 589641 589641 Chapman, Stephen, of Shorne, laborer 0
4779970 2289736 2289736 defendant Yonge Thomas yeoman 589641 589641 Yonge, Thomas, of Shorne, yeoman 0
4803560 2297301 2297301 defendant Cristelote Thomas husbandman 589641 589641 Cristelote, Thomas, of Shorne, husbandman 0
4813448 2300319 2300319 defendant Beket Robert husbandman 589641 589641 Beket, Robert, of Shorne, husbandman 0
4823064 2303297 2303297 defendant Cristlot Thomas carpenter 589641 589641 Cristlot, Thomas, of Shorne, carpenter 0
4845956 2310242 2310242 defendant Rolf Robert smith 589641 589641 Rolf, Robert, of Shorne, smith 0
4856985 2313565 2313565 defendant Irland Thomas thatcher 589641 589641 Irland, Thomas, of Shorne, thatcher 0
4896985 2325706 2325706 defendant Shepey John husbandman 589641 589641 Shepey, John, of Shorne, husbandman 1
4983199 2351877 2351877 defendant Chambre Richard yeoman 589641 589641 Chambre, Richard, of Shorne, yeoman 0
5021193 2363098 2363098 defendant Pette Lawrence husbandman 589641 589641 Pette, Lawrence, of Shorne, husbandman 1
5056657 2373561 2373561 defendant Smyth Peter husbandman 589641 589641 Smyth, Peter, of Shorne, husbandman 0
5062861 2375425 2375425 defendant Castell Roger butcher 589641 589641 Castell, Roger, of Shorne, butcher 0
5070382 2377634 2377634 defendant Mason Richard butcher 589641 589641 Mason, Richard, of Shorne, butcher 0
5105540 2388068 2388068 defendant Crepehegge Walter husbndman 589641 589641 Crepehegge, Walter, of Shorne, husbndman 0
5135691 2396948 2396948 defendant Neweman Richard smith 589641 589641 Neweman, Richard, of Shorne, smith 4
5137077 2397360 2397360 defendant Page John yeoman 589641 589641 Page, John, of Shorne, yeoman 2
5159338 2403847 2403847 defendant Hamond Robert husbandman 589641 589641 Hamond, Robert, of Shorne, husbandman 0
5243774 2428371 2428371 plaintiff Page William   589641 589641 Page, William, of Shorne 1
5249943 2430095 2430095 defendant Davy William butcher 589641 589641 Davy, William, of Shorne, butcher 0
5311297 2448408 2448408 defendant Hochon William thatcher 589641 589641 Hochon, William, of Shorne, thatcher 2
5317012 2450164 2450164 defendant Karl- William husbandman 589641 589641 Karl-, William, of Shorne, husbandman 0
5318232 2450546 2450546 defendant Bedyll Richard husbandman 589641 589641 Bedyll, Richard, of Shorne, husbandman 0
5335767 2455763 2455763 defendant Chirche John husbandman 589641 589641 Chirche, John, of Shorne, husbandman 1
5337885 2456414 2456414 defendant Bedyll John husbandman 589641 589641 Bedyll, John, of Shorne, husbandman 0
5337887 2456415 2456415 defendant Bedyll John husbandman 589641 589641 Bedyll, John, of Shorne, husbandman 0
5339641 2456972 2456972 defendant Chaundler John butcher 589641 589641 Chaundler, John, of Shorne, or of Parva Waltham, Essex, butcher 1
5348447 2459654 2459654 defendant Lemman William laborer 589641 589641 Lemman, William, of Shorne, laborer 2
5351382 2460530 2460530 defendant Goyne William laborer 589641 589641 Goyne, William, of Shorne, laborer 3
5362780 2464001 2464001 defendant Broun Richard husbandman 589641 589641 Broun, Richard, of Shorne, husbandman 2
5425620 2482644 2482644 defendant Davy John husbandman 589641 589641 Davy, John, of Shorne, husbandman 2
5553866 2521169 2521169 defendant Bysshop Thomas yeoman 589641 589641 Bysshop, Thomas, of Shorne, yeoman 1
5630581 2553573 2553573 defendant Payn Richard butcher 589641 589641 Payn, Richard, of Shorne, butcher 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);