names

61 rows where place_id = 585966

✎ 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
3587597 1863768 1863768 defendant Otterey John dyer 585966 585966 Otterey, John, of Bryggewater, Soms, dyer 0
3591991 1865109 1865109 defendant Gryffyth John yeoman 585966 585966 Gryffyth, John, of Bryggewater, Soms, yeoman 2
3591995 1865110 1865110 defendant Gryffyth John yeoman 585966 585966 Gryffyth, John, of Bryggewater, Soms, yeoman 2
3592660 1865318 1865318 defendant Wymere John merchant 585966 585966 Wymere, John, of Bryggewater, Soms, merchant 1
3608926 1870450 1870450 defendant Norman Thomas yeoman 585966 585966 Norman, Thomas, of Bryggewater, Soms, yeoman 2
3651963 1910959 1910959 defendant Rede John dyer 585966 585966 Rede, John, of Bryggewater, Soms, dyer 0
3695638 1924866 1924866 defendant Raffe Thomas merchant 585966 585966 Raffe, Thomas, of Bryggewater, Soms, merchant 0
3730484 1935767 1935767 defendant Benett Ralph yeoman 585966 585966 Benett, Ralph, of Bryggewater, Soms, yeoman 1
3761825 1945708 1945708 defendant Tyrell Richard merchant 585966 585966 Tyrell, Richard, of Bryggewater, Soms, merchant 0
4715217 2270088 2270088 defendant Kedwelly John merchant 585966 585966 Kedwelly, John, of Bryggewater, Soms, merchant 1
4745550 2279209 2279209 defendant Lane Thomas husbandman 585966 585966 Lane, Thomas, of Bryggewater, Soms, husbandman 1
4785663 2291545 2291545 defendant Pytte John merchant 585966 585966 Pytte, John, of Bryggewater, Soms, merchant 0
4911264 2330028 2330028 defendant of Thomas William gent 585966 585966 of Thomas, William, of Bryggewater, Soms, gent 0
4987589 2353247 2353247 defendant Craddok Thomas merchant 585966 585966 (Craddok, Thomas, of Bryggewater, Soms, merchant 1
4996972 2355949 2355949 defendant St Barbe Thomas esq 585966 585966 St Barbe, Thomas, of Bryggewater, Soms, esq 0
5008512 2359386 2359386 defendant Mey John merchant 585966 585966 Mey, John, of Bryggewater, Soms, merchant 1
5011582 2360250 2360250 defendant May John chapman 585966 585966 May, John, of Bryggewater, Soms, chapman 1
5028820 2365304 2365304 defendant Colyford Elizabeth widow 585966 585966 (Colyford, Elizabeth, of Bryggewater, Soms, widow 1
5028823 2365305 2365305 defendant Colyford Edward (legal representative) 585966 585966 Colyford, Edward, of Bryggewater, Soms, executors of 0
5039673 2368510 2368510 defendant Parker John chapman 585966 585966 Parker, John, of Bryggewater, Soms, chapman 2
5039679 2368511 2368511 defendant Parker John chapman 585966 585966 Parker, John, of Bryggewater, Soms, chapman 2
5047163 2370773 2370773 defendant Mareman John glover 585966 585966 Mareman, John, of Bryggewater, Soms, glover 0
5051645 2372110 2372110 defendant May John chapman 585966 585966 May, John, of Bryggewater, Soms, chapman 0
5055934 2373341 2373341 defendant Smyth John chapman 585966 585966 Smyth, John, of Bryggewater, Soms, chapman 1
5079835 2380446 2380446 defendant Willyam David   585966 585966 Willyam, David, of Bryggewater, Soms, franklin 6
5092077 2384057 2384057 defendant Martyn John chapman 585966 585966 Martyn, John, of Bryggewater, Soms, chapman 0
5096594 2385438 2385438 defendant Hylle John chapman 585966 585966 Hylle, John, of Bryggewater, Soms, chapman 1
5096598 2385439 2385439 defendant Martyn John chapman 585966 585966 Martyn, John, of Bryggewater, Soms, chapman 0
5141753 2398701 2398701 plaintiff Walsshe John dyer or deighe 585966 585966 Walsshe, John, of Bryggewater, Soms, dyer or deighe 0
5176734 2408880 2408880 plaintiff Walshe John dyer 585966 585966 Walshe, John, of Bryggewater, Soms, dyer 0
5199049 2415473 2415473 plaintiff Walsh John dyer 585966 585966 Walsh, John, of Bryggewater, Soms, dyer 0
5245818 2428943 2428943 defendant Best John   585966 585966 Best, John, of Bryggewater, Soms, cook 0
5255932 2431979 2431979 defendant Huchyn Robert merchant 585966 585966 Huchyn, Robert, of Bryggewater, Soms, merchant 0
5298767 2444616 2444616 defendant P_ John mercer 585966 585966 P_, John, of Bryggewater, Soms, mercer 3
5309329 2447830 2447830 defendant St Barbe Thomas esq 585966 585966 St Barbe, Thomas, of Bryggewater, Soms, esq 1
5343059 2458014 2458014 defendant Alys John chapman 585966 585966 Alys, John, of Bryggewater, Soms, chapman 3
5368629 2465784 2465784 defendant Parys John clothmaker 585966 585966 Parys, John, of Bryggewater, Soms, clothmaker 1
5379951 2469314 2469314 defendant Palweb John chapman 585966 585966 Palweb, John, of Bryggewater, Soms, chapman 0
5395487 2473787 2473787 defendant Hamelyn Adam merchant 585966 585966 Hamelyn, Adam, of Bryggewater, Soms, merchant 0
5400642 2475244 2475244 defendant West William merchant 585966 585966 West, William, of Bryggewater, Soms, merchant 4
5401155 2475393 2475393 defendant Fylippe Thomas gent 585966 585966 Fylippe, Thomas, of Bryggewater, Soms, gent 1
5407695 2477274 2477274 defendant Drewe John gent 585966 585966 Drewe, John, of Bryggewater, Soms, gent 0
5420321 2481002 2481002 defendant Hamelyne Adam merchant 585966 585966 Hamelyne, Adam, of Bryggewater, Soms, merchant 0
5425079 2482462 2482462 defendant West Walter merchant 585966 585966 West, Walter, of Bryggewater, Soms, merchant 4
5428497 2483450 2483450 defendant Coper John merchant 585966 585966 Coper, John, of Bryggewater, Soms, merchant 0
5428499 2483451 2483451 defendant Coper John merchant 585966 585966 Coper, John, of Bryggewater, Soms, merchant 0
5429851 2483871 2483871 defendant Felyppe Thomas gent 585966 585966 Felyppe, Thomas, of Bryggewater, Soms, gent 1
5439087 2486614 2486614 defendant Hamelyn Adam merchant 585966 585966 Hamelyn, Adam, of Bryggewater, Soms, merchant 0
5439105 2486619 2486619 defendant Hameleyn Adam merchant 585966 585966 Hameleyn, Adam, of Bryggewater, Soms, merchant 0
5440074 2486935 2486935 defendant Drewe John gent 585966 585966 Drewe, John, of Bryggewater, Soms, gent 0
5442828 2487767 2487767 defendant Thorley John brewer 585966 585966 Thorley, John, of Bryggewater, Soms, brewer 2
5447780 2489215 2489215 defendant Colyns William   585966 585966 Colyns, William, of Bryggewater, Soms, shr_ 3
5455609 2491583 2491583 defendant Thorley John mercer 585966 585966 Thorley, John, of Bryggewater, Soms, mercer 2
5477631 2498326 2498326 defendant Pygmyr John clothman 585966 585966 Pygmyr, John, of Bryggewater, Soms, clothman 2
5485778 2500641 2500641 defendant Kendale John gent 585966 585966 Kendale, John, of Bryggewater, Soms, gent 0
5494359 2503214 2503214 defendant Drewe John gent 585966 585966 Drewe, John, of Bryggewater, Soms, gent 0
5500919 2505220 2505220 defendant Philip Thomas merchant 585966 585966 (Philip, Thomas, of Bryggewater, Soms, merchant 1
5500922 2505221 2505221 defendant Kendale John merchant 585966 585966 Kendale, John, of Bryggewater, Soms, merchant 0
5525938 2512705 2512705 defendant Baker John gent 585966 585966 Baker, John, of Bryggewater, Soms, gent 0
5596433 2533795 2533795 defendant Faunt alias Harwode Peter merchant 585966 585966 Faunt alias Harwode, Peter, of Bryggewater, Soms, merchant 0
5596439 2533796 2533796 defendant Faunt alias Harwode Peter merchant 585966 585966 Faunt alias Harwode, Peter, of Bryggewater, Soms, merchant 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);