names

105 rows where place_id = 594253

✎ 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
3615295 1872428 1872428 defendant Perkyns William glover 594253 594253 Perkyns, William, of Southam, glover 0
3632554 1904999 1904999 defendant Cee or Bee John husbandman 594253 594253 Cee or Bee, John, of Southam, husbandman 0
3647568 1909632 1909632 defendant Joye Alice widow 594253 594253 Joye, Alice, of Southam, widow 2
3656605 1912320 1912320 defendant Joye John (legal representative) 594253 594253 Joye, John, of Southam, yeoman, executors of 0
3671129 1916939 1916939 defendant Johnson Roger miller 594253 594253 Johnson, Roger, of Southam, miller 0
3671130 1916939 1916939 defendant Johnson Thomas miller 594253 594253 Johnson, Thomas, of Southam, miller 1
3671131 1916939 1916939 defendant Werall Henry husbandman 594253 594253 Werall, Henry, of Southam, husbandman 2
3671132 1916939 1916939 defendant Berege Thomas husbandman 594253 594253 Berege, Thomas, of Southam, husbandman 3
3676241 1918616 1918616 defendant Clyfton Fulk yeoman 594253 594253 Clyfton, Fulk, of Southam, yeoman 1
3688840 1922669 1922669 defendant Brygges John yeoman 594253 594253 Brygges, John, of Southam, yeoman 0
3688841 1922669 1922669 defendant Clyfton Fulk yeoman 594253 594253 Clyfton, Fulk, of Southam, yeoman 1
3692430 1923809 1923809 defendant Brygges John yeoman 594253 594253 Brygges, John, of Southam, yeoman 0
3721249 1932949 1932949 defendant Clyfton Fulk yeoman 594253 594253 Clyfton, Fulk, of Southam, yeoman 0
3782477 1952263 1952263 plaintiff Huddelston John esq 594253 594253 Huddelston, John, of Southam, esq 0
3799063 1957616 1957616 plaintiff Huddelston John esq 594253 594253 Huddelston, John, of Southam, esq 0
3799065 1957617 1957617 plaintiff Huddelston John esq 594253 594253 Huddelston, John, of Southam, esq 0
3888393 1986378 1986378 defendant Brydge William yeoman 594253 594253 Brydge, William, of Southam, yeoman 3
3892193 1987642 1987642 defendant Maycoke Henry   594253 594253 Maycoke, Henry, of Southam, ploughwright 0
3895399 1988671 1988671 defendant Huddulston John   594253 594253 Huddulston, John, of Southam, knight 0
3909619 1993523 1993523 defendant Huddelston John   594253 594253 Huddelston, John, of Southam, knight 0
3942687 2004559 2004559 defendant Bull John clerk 594253 594253 Bull, John, of Southam, clerk 1
3992850 2022195 2022195 defendant Lucas John yeoman 594253 594253 Lucas, John, of Southam, yeoman 2
4087677 2055886 2055886 defendant Walton Nicholas husbandman 594253 594253 Walton, Nicholas, of Southam, husbandman 0
4124810 2069166 2069166 defendant Clarke Robert yeoman 594253 594253 Clarke, Robert, of Southam, yeoman 0
4140053 2074687 2074687 defendant Mayo or Meyho alias Nycholl Henry (legal representative) 594253 594253 Mayo or Meyho alias Nycholl, Henry, of Southam, yeoman, executrix of 0
4140054 2074687 2074687 defendant Mayo alias Nicholl Dorothy widow 594253 594253 Mayo alias Nicholl, Dorothy, of Southam, widow 1
4230937 2106320 2106320 defendant Chenye John gent 594253 594253 Chenye, John, of Southam, gent 1
4230942 2106321 2106321 defendant Chenye John gent 594253 594253 Chenye, John, of Southam, gent 1
4372151 2155109 2155109 defendant Edmunde Anthony husbandman 594253 594253 Edmunde, Anthony, of Southam, husbandman 0
4372154 2155109 2155109 defendant Chenye John yeoman 594253 594253 Chenye, John, of Southam, yeoman 3
4372155 2155109 2155109 defendant Whawley Alexander husbandman 594253 594253 Whawley, Alexander, of Southam, husbandman 4
4395175 2162974 2162974 defendant Collye Thomas cutler 594253 594253 Collye, Thomas, of Southam, cutler 0
4418649 2170707 2170707 plaintiff Yen Hugh   594253 594253 Yen, Hugh, of Southam, formerly William's man 0
4463317 2189219 2189219 plaintiff Truman Richard   594253 594253 Truman, Richard, of Southam 0
4506710 2202575 2202575 plaintiff Treweman Richard   594253 594253 Treweman, Richard, of Southam, on his own account 0
4506717 2202576 2202576 plaintiff Trewman Richard   594253 594253 Trewman, Richard, of Southam 0
4506720 2202577 2202577 plaintiff Trewman Richard   594253 594253 Trewman, Richard, of Southam, on his own account 0
4517117 2205755 2205755 defendant Shabury John   594253 594253 Shabury, John, of Southam 1
4555751 2217734 2217734 defendant Bailly Richard   594253 594253 Bailly, Richard, of Southam 0
4555752 2217734 2217734 defendant Reynold William   594253 594253 Reynold, William, of Southam 1
4559992 2219075 2219075 defendant Emson John   594253 594253 Emson, John, of Southam 0
4559993 2219075 2219075 defendant Chapman William   594253 594253 Chapman, William, of Southam 1
4559994 2219075 2219075 defendant Hygyns William   594253 594253 Hygyns, William, of Southam 2
4564993 2220619 2220619 defendant Saunders William   594253 594253 Saunders, William, of Southam 0
4564995 2220620 2220620 defendant Saundre William   594253 594253 Saundre, William, of Southam 0
4572186 2222851 2222851 defendant Aunesham William   594253 594253 Aunesham, William, of Southam 0
4576380 2224125 2224125 defendant Jones William   594253 594253 Jones, William, of Southam 0
4625000 2238786 2238786 defendant Mountmouth William   594253 594253 Mountmouth, William, of Southam, parson 2
4631039 2240602 2240602 defendant Spitulman William   594253 594253 Spitulman, William, of Southam, linen draper 0
4644729 2244539 2244539 defendant Carter John   594253 594253 Carter, John, of Southam 0
4644730 2244539 2244539 defendant Huchyns Wilaim   594253 594253 Huchyns, Wilaim, of Southam 1
4644731 2244539 2244539 defendant Adams John   594253 594253 Adams, John, of Southam 2
4680990 2259680 2259680 defendant Crakelowe Thomas   594253 594253 Crakelowe, Thomas, of Southam, bailiff 0
4701830 2265974 2265974 defendant Goldeman William (legal representative) 594253 594253 Goldeman, William, of Southam, executors of 0
4701831 2265974 2265974 defendant Wagstaffe Henry barber 594253 594253 (Wagstaffe, Henry, of Southam, barber 1
4701832 2265974 2265974 defendant Douce or Donce Thomas   594253 594253 Douce or Donce, Thomas, of Southam, shoe maker 2
4701833 2265974 2265974 defendant Jones William husbandman 594253 594253 Jones, William, of Southam, husbandman 3
4722555 2272369 2272369 defendant Craklawe Thomas yeoman 594253 594253 Craklawe, Thomas, of Southam, yeoman 0
4755015 2281953 2281953 defendant Parys John tailor 594253 594253 Parys, John, of Southam, tailor 0
4758269 2282963 2282963 defendant Segge William   594253 594253 Segge, William, of Southam, parson 0
4804071 2297459 2297459 defendant Andrewe William laborer 594253 594253 Andrewe, William, of Southam, laborer 0
4806507 2298249 2298249 defendant Iryssh Robert husbandman 594253 594253 Iryssh, Robert, of Southam, husbandman 0
4812937 2300158 2300158 defendant Chekley Henry   594253 594253 Chekley, Henry, of Southam, bailiff 0
4816699 2301320 2301320 plaintiff Marefeld John   594253 594253 Marefeld, John, of Southam 0
4816700 2301320 2301320 defendant Spetylmon William yeoman 594253 594253 Spetylmon, William, of Southam, yeoman 0
4819386 2302137 2302137 defendant Chekkeley Henry yeoman 594253 594253 Chekkeley, Henry, of Southam, yeoman 0
4822928 2303255 2303255 plaintiff Spetilman William   594253 594253 Spetilman, William, of Southam 0
4822933 2303256 2303256 defendant Sugge William   594253 594253 Sugge, William, of Southam, parson 0
4822934 2303256 2303256 defendant Northfolk William husbandman 594253 594253 Northfolk, William, of Southam, husbandman 1
4823340 2303386 2303386 defendant Chekkeley Henry yeoman 594253 594253 Chekkeley, Henry, of Southam, yeoman 0
4849892 2311438 2311438 plaintiff Sugge William   594253 594253 Sugge, William, of Southam, parson 0
4889865 2323619 2323619 defendant Basset Geoffrey husbandman 594253 594253 Basset, Geoffrey, of Southam, husbandman 1
4889866 2323619 2323619 defendant Parys John draper 594253 594253 Parys, John, of Southam, draper 2
4954126 2343201 2343201 defendant Bird Roger husbandman 594253 594253 Bird, Roger, of Southam, husbandman 3
4970786 2348205 2348205 defendant Prenkryche John yeoman 594253 594253 Prenkryche, John, of Southam, yeoman 0
5001887 2357451 2357451 defendant Mathewe John tailor 594253 594253 Mathewe, John, of Southam, tailor 0
5007370 2359049 2359049 defendant Perkyns Ralph husbandman 594253 594253 Perkyns, Ralph, of Southam, husbandman 3
5052259 2372283 2372283 defendant Drewe John   594253 594253 Drewe, John, of Southam, "olyman" 2
5065020 2376069 2376069 defendant Wales William draper 594253 594253 Wales, William, of Southam, draper 1
5065021 2376069 2376069 defendant Jhones William husbandman 594253 594253 Jhones, William, of Southam, husbandman 2
5065022 2376069 2376069 defendant Osbarne Henry yeoman 594253 594253 Osbarne, Henry, of Southam, yeoman 3
5079964 2380486 2380486 defendant Palmer John husbandman 594253 594253 Palmer, John, of Southam, husbandman 0
5079966 2380486 2380486 defendant Jones William husbandman 594253 594253 Jones, William,of Southam, husbandman 2
5096571 2385431 2385431 defendant Touchette Richard husbandman 594253 594253 Touchette, Richard, of Southam, husbandman 0
5190204 2412874 2412874 defendant Sugge William clerk & parson 594253 594253 Sugge, William, of Southam, clerk & parson 0
5229416 2424213 2424213 defendant Commaunder Richard husbandman 594253 594253 Commaunder, Richard, of Southam, husbandman 2
5278296 2438754 2438754 defendant Parkyns Richard husbandman 594253 594253 Parkyns, Richard, of Southam, husbandman 0
5327077 2453174 2453174 defendant Fyssher John husbandman 594253 594253 Fyssher, John, of Southam, husbandman 1
5377130 2468436 2468436 defendant Smyth Richard smith 594253 594253 Smyth, Richard, of Southam, smith 2
5432141 2484580 2484580 defendant Suwet William   594253 594253 Suwet, William, of Southam, parson 0
5432143 2484581 2484581 defendant Shirburne Richard   594253 594253 Shirburne, Richard, of Southam, parson 0
5469073 2495677 2495677 defendant Wryght Thomas miller 594253 594253 Wryght, Thomas, of Southam, miller 0
5469074 2495677 2495677 defendant Hill Thomas husbandman 594253 594253 Hill, Thomas, of Southam, husbandman 1
5469075 2495677 2495677 defendant Parkyns Thomas husbandman 594253 594253 Parkyns, Thomas, of Southam, husbandman 2
5480242 2499072 2499072 defendant Wryght Thomas miller 594253 594253 Wryght, Thomas, of Southam, miller 0
5480243 2499072 2499072 defendant Hill Thomas husbandman 594253 594253 Hill, Thomas, of Southam, husbandman 1
5480244 2499072 2499072 defendant Parkyns Thomas husbandman 594253 594253 Parkyns, Thomas, of Southam, husbandman 2
5494881 2503363 2503363 defendant Whalley Thomas yeoman 594253 594253 Whalley, Thomas, of Southam, yeoman 3
5508068 2507416 2507416 defendant Charyour Robert husbandman 594253 594253 Charyour, Robert, of Southam, husbandman 0
5545703 2518732 2518732 defendant Turnour Thomas yeoman 594253 594253 Turnour, Thomas, of Southam, yeoman 1

Next page

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