names

58 rows where place_id = 594350

✎ 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
3615710 1872557 1872557 defendant Multon Thomas yeoman 594350 594350 Multon, Thomas, of Welborne, yeoman 0
3666724 1915536 1915536 defendant Playter Edmund gent 594350 594350 Playter, Edmund, of Welborne, gent 1
3672794 1917498 1917498 defendant Rypley Thomas laborer 594350 594350 Rypley, Thomas, of Welborne, laborer 0
3691329 1923447 1923447 defendant Wilkynson John yeoman 594350 594350 Wilkynson, John, of Welborne, yeoman 3
3772475 1949081 1949081 defendant Wyllyngton John husbandman 594350 594350 Wyllyngton, John, of Welborne, husbandman 2
3844242 1971747 1971747 defendant Parker John husbandman 594350 594350 Parker, John, of Welborne, husbandman 0
3943833 2004953 2004953 defendant Bradshawe Hugh yeoman 594350 594350 Bradshawe, Hugh, of Welborne, yeoman 0
3948764 2006636 2006636 defendant Uttyng Thomas husbandman 594350 594350 Uttyng, Thomas, of Welborne, husbandman 1
3978110 2016920 2016920 defendant Pereman Edmund husbandman 594350 594350 Pereman, Edmund, of Welborne, husbandman 0
3995034 2022971 2022971 defendant Bradshawe Hugh yeoman 594350 594350 Bradshawe, Hugh, of Welborne, yeoman 0
4011073 2028734 2028734 defendant Deane John, junior husbandman 594350 594350 Deane, John, junior, of Welborne, or of Mattsall, husbandman 0
4028059 2034686 2034686 defendant Hansard Luke husbandman 594350 594350 Hansard, Luke, of Welborne, husbandman 0
4063778 2047331 2047331 defendant Wilson John gent 594350 594350 Wilson, John, of Welborne, gent 0
4074934 2051336 2051336 defendant Wylson John gent 594350 594350 Wylson, John, of Welborne, gent 0
4081779 2053788 2053788 defendant Worthington William gent 594350 594350 Worthington, William, of Welborne, gent 0
4081799 2053795 2053795 defendant Wilson John gent 594350 594350 Wilson, John, of Welborne, gent 0
4081859 2053816 2053816 defendant Beckingham William carpenter 594350 594350 Beckingham, William, of Welborne, carpenter 0
4087085 2055674 2055674 defendant Wilson John gent 594350 594350 Wilson, John, of Welborne, gent 1
4087088 2055675 2055675 defendant Wilson John gent 594350 594350 Wilson, John, of Welborne, gent 1
4109954 2063817 2063817 defendant Wilson John gent 594350 594350 Wilson, John, of Welborne, gent 0
4118589 2066943 2066943 defendant Worthington William gent 594350 594350 Worthington, William, of Welborne, gent 0
4118787 2066999 2066999 defendant Beckingham William carpenter 594350 594350 Beckingham, William, of Welborne, carpenter 3
4145840 2076698 2076698 defendant Witton Anthony yeoman 594350 594350 Witton, Anthony, of Welborne, yeoman 0
4148445 2077585 2077585 defendant Awdley Anthony gent 594350 594350 Awdley, Anthony, of Welborne, gent 1
4148446 2077585 2077585 defendant Clarke William yeoman 594350 594350 Clarke, William, of Welborne, yeoman 2
4172559 2085862 2085862 defendant Randoll Robert yeoman 594350 594350 Randoll, Robert, of Welborne, yeoman 1
4173785 2086286 2086286 defendant Webster Christopher gent 594350 594350 Webster, Christopher, of Welborne, gent 0
4195754 2094069 2094069 defendant Randoll Robert yeoman 594350 594350 Randoll, Robert, of Welborne, yeoman 1
4221327 2102957 2102957 defendant Morgan Alexander gent 594350 594350 Morgan, Alexander, of Welborne, gent 0
4229579 2105831 2105831 defendant Pickeringe William husbandman 594350 594350 Pickeringe, William, of Welborne, husbandman 0
4229580 2105831 2105831 defendant West Thomas husbandman 594350 594350 West, Thomas, of Welborne, husbandman 1
4238248 2108986 2108986 defendant Pickeringe William husbandman 594350 594350 Pickeringe, William, of Welborne, husbandman 0
4238249 2108986 2108986 defendant West Thomas husbandman 594350 594350 West, Thomas, of Welborne, husbandman 1
4245444 2111451 2111451 defendant Paxton Thomas yeoman 594350 594350 Paxton, Thomas, of Welborne, yeoman 1
4252685 2113885 2113885 defendant Baldwyn Richard yeoman 594350 594350 Baldwyn, Richard, of Welborne, yeoman 2
4257341 2115431 2115431 defendant Greeve John tailor 594350 594350 Greeve, John, of Welborne, tailor 0
4261480 2116803 2116803 defendant Sparling Robert husbandman 594350 594350 Sparling, Robert, of Welborne, husbandman 0
4261481 2116803 2116803 defendant Ellis Thomas husbandman 594350 594350 Ellis, Thomas, of Welborne, husbandman 1
4261482 2116803 2116803 defendant Wetherell Francis husbandman 594350 594350 Wetherell, Francis, of Welborne, husbandman 2
4261483 2116803 2116803 defendant Reynold John husbandman 594350 594350 Reynold, John, of Welborne, husbandman 3
4274848 2121150 2121150 defendant Morgan Alexander esq 594350 594350 Morgan, Alexander, of Welborne, esq 0
4282127 2123651 2123651 defendant Knowles Thomas laborer 594350 594350 Knowles, Thomas, of Welborne, laborer 1
4333725 2141559 2141559 defendant Seaborne Joan widow 594350 594350 Seaborne, Joan, of Welborne, widow 1
4373932 2155747 2155747 defendant Ellis Thomas husbandman 594350 594350 Ellis, Thomas, of Welborne, husbandman 0
4687843 2261764 2261764 defendant Derby John pedder 594350 594350 Derby, John, of Welborne, pedder 0
4701452 2265857 2265857 defendant Derny or Verny William   594350 594350 Derny or Verny, William, of Welborne 1
4762552 2284268 2284268 defendant Dervy John   594350 594350 Dervy, John, of Welborne, pedlar 2
4786164 2291710 2291710 defendant Derby John pedder 594350 594350 Derby, John, of Welborne, pedder 2
4786170 2291711 2291711 defendant Derby John pedder 594350 594350 Derby, John, of Welborne, pedder 2
4881926 2321245 2321245 defendant Stupton John husbandman 594350 594350 Stupton, John, of Welborne, husbandman 2
4982549 2351695 2351695 defendant Careby Thomas   594350 594350 Careby, Thomas, of Welborne, servant 0
5015016 2361273 2361273 defendant Russell Thomas husbandman 594350 594350 Russell, Thomas, of Welborne, husbandman 0
5015017 2361273 2361273 defendant Martyn John husbandman 594350 594350 Martyn, John, of Welborne, husbandman 1
5066078 2376377 2376377 defendant Godewyn John (legal representative) 594350 594350 Godewyn, John, of Welborne, clerk, executor of 0
5066089 2376379 2376379 defendant Leton Robert husbandman 594350 594350 Leton, Robert, of Welborne, husbandman 4
5502991 2505845 2505845 plaintiff Clerk William   594350 594350 Clerk, William, of Welborne 1
5502994 2505846 2505846 plaintiff Clerk William   594350 594350 Clerk, William, of Welborne 1
5578212 2528257 2528257 defendant Farowe William husbandman 594350 594350 Farowe, William, of Welborne, husbandman 1

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);