names

46 rows where place_id = 604427

✎ 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
3657961 1912741 1912741 defendant Glover William husbandman 604427 604427 Glover, William, of Crowle, husbandman 1
3696933 1925261 1925261 defendant Gese John husbandman 604427 604427 Gese, John, of Crowle, husbandman 1
3713208 1930434 1930434 defendant Pratt James clerk 604427 604427 Pratt, James, of Crowle, clerk 0
3965611 2012587 2012587 defendant Tynseley Roger gent 604427 604427 Tynseley, Roger, of Crowle, gent 0
3965613 2012587 2012587 defendant Hale Francis yeoman 604427 604427 Hale, Francis, of Crowle, yeoman 2
3971674 2014656 2014656 defendant Awdus Margaret spinster 604427 604427 Awdus, Margaret, of Crowle, spinster 2
4082244 2053962 2053962 defendant Glover Thomas yeoman 604427 604427 Glover, Thomas, of Crowle, yeoman 2
4098442 2059770 2059770 defendant Penryse alias Glover Katherine widow 604427 604427 Penryse alias Glover, Katherine, of Crowle, widow 0
4098443 2059770 2059770 defendant Adam Gilbert husbandman 604427 604427 Adam, Gilbert, of Crowle, husbandman 1
4135158 2072892 2072892 defendant Berryer Robert yeoman 604427 604427 Berryer, Robert, of Crowle, yeoman 0
4159177 2081276 2081276 defendant Berrier Robert yeoman 604427 604427 Berrier, Robert, of Crowle, yeoman 0
4237136 2108573 2108573 defendant Gardner alias Weaver William husbandman 604427 604427 Gardner alias Weaver, William, of Crowle, husbandman 0
4237559 2108727 2108727 defendant Atkinson Charles harper 604427 604427 Atkinson, Charles, of Crowle, harper 3
4245780 2111566 2111566 defendant Gardner alias Weaver William husbandman 604427 604427 Gardner alias Weaver, William, of Crowle, husbandman 0
4246158 2111693 2111693 defendant Atkinson Charles harper 604427 604427 Atkinson, Charles, of Crowle, harper 3
4277314 2121992 2121992 defendant Pynder Stephen yeoman 604427 604427 (Pynder, Stephen, of Crowle, yeoman 4
4281460 2123420 2123420 defendant Tinkler Robert yeoman 604427 604427 Tinkler, Robert, of Crowle, yeoman 2
4281461 2123420 2123420 defendant Hewton Richard yeoman 604427 604427 Hewton, Richard, of Crowle, yeoman 3
4284215 2124404 2124404 defendant Tynsley Thomas gent 604427 604427 Tynsley, Thomas, of Crowle, gent 0
4284219 2124406 2124406 defendant Tillesley Thomas gent 604427 604427 Tillesley, Thomas, of Crowle, gent 0
4284223 2124408 2124408 defendant Tynsley Thomas gent 604427 604427 Tynsley, Thomas, of Crowle, gent 0
4285910 2125014 2125014 defendant Pynder Richard yeoman 604427 604427 Pynder, Richard, of Crowle, yeoman 0
4292720 2127458 2127458 defendant Horneyblowe John, senior yeoman 604427 604427 Horneyblowe, John, senior, of Crowle, yeoman 0
4293145 2127611 2127611 defendant Leite Armaell yeoman 604427 604427 Leite, Armaell, of Crowle, yeoman 1
4293146 2127611 2127611 defendant Hornyblowe William yeoman 604427 604427 Hornyblowe, William, of Crowle, yeoman 2
4293149 2127612 2127612 defendant Leite Armaell yeoman 604427 604427 Leite, Armaell, of Crowle, yeoman 1
4293150 2127612 2127612 defendant Hornyblowe William yeoman 604427 604427 Hornyblowe, William, of Crowle, yeoman 2
4295164 2128354 2128354 defendant Glewe William yeoman 604427 604427 Glewe, William, of Crowle, yeoman 1
4297034 2129036 2129036 defendant Panter John butcher 604427 604427 Panter, John, of Crowle, butcher 0
4299975 2130087 2130087 defendant Conyworth John   604427 604427 Conyworth, John, of Crowle weaver 0
4326286 2139157 2139157 defendant Horneblowe or Horneblower William yeoman 604427 604427 Horneblowe or Horneblower, William, of Crowle, yeoman 3
4343376 2144956 2144956 defendant Tyldesley Thomas   604427 604427 Tyldesley, Thomas, of Crowle gent 0
4349222 2146989 2146989 defendant Hall or Hale William yeoman 604427 604427 Hall or Hale, William, of Crowle, yeoman 0
4349223 2146989 2146989 defendant Thornton Thomas yeoman 604427 604427 Thornton, Thomas, of Crowle, yeoman 1
4360559 2150945 2150945 defendant Tildesley Thomas gent 604427 604427 Tildesley, Thomas, of Crowle, gent 1
4379243 2157656 2157656 defendant Tyldesley Thomas gent 604427 604427 Tyldesley, Thomas, of Crowle, gent 0
4381652 2158548 2158548 defendant Mawe John, senior yeoman 604427 604427 Mawe, John, senior, of Crowle, yeoman 0
4381653 2158548 2158548 defendant Mawe John, junior yeoman 604427 604427 Mawe, John, junior, of Crowle, yeoman 1
4381654 2158548 2158548 defendant Hall William yeoman 604427 604427 Hall, William, of Crowle, yeoman 2
4383949 2159337 2159337 defendant Paynter John butcher 604427 604427 Paynter, John, of Crowle, butcher 0
4385229 2159748 2159748 defendant Wever alias Garner William yeoman 604427 604427 Wever alias Garner, William, of Crowle, yeoman 0
4400249 2164676 2164676 defendant Gardner alias Weaver William husbandman 604427 604427 Gardner alias Weaver, William, of Crowle, husbandman 0
4497908 2199992 2199992 plaintiff Erre John   604427 604427 Erre, John, of Crowle, vicar 0
5122586 2393039 2393039 defendant Knot Giles gent 604427 604427 Knot, Giles, of Crowle, gent 0
5400710 2475265 2475265 defendant (illegible) (illegible) laborer 604427 604427 ---, ---, of Crowle, laborer 0
5623655 2551336 2551336 defendant Honybourn John laborer 604427 604427 Honybourn, John, of Crowle, laborer 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);