names

44 rows where place_id = 688519

✎ 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
4076148 2051757 2051757 defendant Tutchett alias Awdeley Richard gent 688519 688519 Tutchett alias Awdeley, Richard, of Puryton, gent 0
4076150 2051758 2051758 defendant Tutchett alias Awdeley Richard gent 688519 688519 Tutchett alias Awdeley, Richard, of Puryton, gent 0
4210609 2099267 2099267 defendant Counsell Philip yeoman 688519 688519 Counsell, Philip, of Puryton, yeoman 3
4314153 2135057 2135057 defendant Cooke Thomas husbandman 688519 688519 Cooke, Thomas, of Puryton, husbandman 0
4447039 2183984 2183984 plaintiff Hunte William   688519 688519 Hunte, William, of Puryton 2
4463884 2189382 2189382 plaintiff Waas Nicholas   688519 688519 Waas, Nicholas, of Puryton, vicar 0
4463886 2189383 2189383 plaintiff Waay Nicholas   688519 688519 Waay, Nicholas, of Puryton, vicar 0
4524121 2207876 2207876 plaintiff Hewet William   688519 688519 Hewet, William, of Puryton 0
4535948 2211520 2211520 plaintiff Sowy William chaplain 688519 688519 Sowy, William, of Puryton, chaplain 0
4565793 2220860 2220860 plaintiff Sowy William chaplain 688519 688519 Sowy, William, of Puryton, chaplain 0
4838195 2307868 2307868 defendant Bole Richard drover 688519 688519 Bole, Richard, of Puryton, drover 0
4853735 2312583 2312583 plaintiff Wyke John (legal representative) 688519 688519 Wyke, John, of Puryton, esq, executor of 0
4853736 2312583 2312583 plaintiff Pyke Henry   688519 688519 (Pyke, Henry, of Puryton, vicar 1
4853740 2312584 2312584 plaintiff Wyke John (legal representative) 688519 688519 Wyke, John, of Puryton, esq, executors of 0
4853741 2312584 2312584 plaintiff Pyke Henry   688519 688519 (Pyke, Henry, of Puryton, vicar 1
4865227 2316096 2316096 defendant Strange John clerk 688519 688519 Strange, John, of Puryton, clerk 1
4865428 2316154 2316154 defendant Bole Richard drover 688519 688519 Bole, Richard, of Puryton, drover 0
4911309 2330041 2330041 defendant Courtenay Humphrey   688519 688519 Courtenay, Humphrey, of Puryton, knight 0
4917438 2331968 2331968 defendant Strange John clerk 688519 688519 Strange, John, of Puryton, clerk 1
4978280 2350451 2350451 defendant Pyt Walter husbandman 688519 688519 Pyt, Walter, of Puryton, husbandman 1
4978281 2350451 2350451 defendant Manby William husbandman 688519 688519 Manby, William, of Puryton, husbandman 2
4978282 2350451 2350451 defendant Puryton John husbandman 688519 688519 Puryton, John, of Puryton, husbandman 3
4978283 2350451 2350451 defendant Tryant Richard yeoman 688519 688519 Tryant, Richard, of Puryton, yeoman 4
4986740 2352971 2352971 defendant Saunder John husbandman 688519 688519 Saunder, John, of Puryton, husbandman 0
4990018 2353926 2353926 defendant Gode William husbandman 688519 688519 Gode, William, of Puryton, husbandman 1
4990019 2353926 2353926 defendant Shene John weaver 688519 688519 Shene, John, of Puryton, weaver 2
4990020 2353926 2353926 defendant Popyll Thomas husbandman 688519 688519 Popyll, Thomas, of Puryton, husbandman 3
4990021 2353926 2353926 defendant Scotte Robert husbandman 688519 688519 Scotte, Robert, of Puryton, husbandman 4
4995209 2355414 2355414 defendant Strange John clerk 688519 688519 Strange, John, of Puryton, clerk 0
4998073 2356286 2356286 defendant Courteney Humphrey   688519 688519 Courteney, Humphrey, of Puryton, knight 0
5007214 2359002 2359002 defendant Jocy or Joty John husbandman 688519 688519 Jocy or Joty, John, of Puryton, husbandman 0
5022092 2363353 2363353 defendant Lyddon John husbandman 688519 688519 Lyddon, John, of Puryton, husbandman 4
5034765 2367025 2367025 defendant Treant Richard husbandman 688519 688519 Treant, Richard, of Puryton, husbandman 3
5045965 2370423 2370423 defendant Courtenay Humphrey   688519 688519 Courtenay, Humphrey, of Puryton, knight 0
5048464 2371179 2371179 defendant Wyke John yeoman 688519 688519 Wyke, John, of Puryton, yeoman 1
5087503 2382723 2382723 defendant Tydy Richard husbandman 688519 688519 Tydy, Richard, of Puryton, husbandman 1
5154911 2402595 2402595 defendant Burgeys Richard husbandman 688519 688519 Burgeys, Richard, of Puryton, husbandman 2
5190069 2412837 2412837 defendant Burgeys Richard husbandman 688519 688519 Burgeys, Richard, of Puryton, husbandman 1
5190074 2412838 2412838 defendant Burgeys Richard husbandman 688519 688519 Burgeys, Richard, of Puryton, husbandman 2
5249439 2429947 2429947 defendant Laurence Margaret widow 688519 688519 Laurence, Margaret, of Puryton, widow 3
5557849 2522248 2522248 defendant Fryce Thomas husbandman 688519 688519 Fryce, Thomas, of Puryton, husbandman 0
5596848 2533935 2533935 defendant Goode Robert husbandman 688519 688519 Goode, Robert, of Puryton, husbandman 2
5612945 2547820 2547820 defendant Tryvet John   688519 688519 Tryvet, John, of Puryton 0
5629023 2553046 2553046 defendant Wilkyn David   688519 688519 Wilkyn, David, of Puryton, shipwright 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);