names

45 rows where place_id = 595932

✎ 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
3622430 1874550 1874550 defendant Belcham John clothmaker 595932 595932 Belcham, John, of Waldyngfeld, clothmaker 4
3623086 1874743 1874743 defendant A Wode Thomas clothmaker 595932 595932 A Wode, Thomas, of Waldyngfeld, clothmaker 2
3694393 1924451 1924451 defendant Wryght John laborer 595932 595932 Wryght, John, of Waldyngfeld, laborer 3
3696587 1925165 1925165 defendant Lyon William husbandman 595932 595932 Lyon, William, of Waldyngfeld, husbandman 2
3712139 1930114 1930114 defendant Mayhewe alias Mawhen William husbandman 595932 595932 Mayhewe alias Mawhen, William, of Waldyngfeld, husbandman 1
3712140 1930114 1930114 defendant Mayhewe alias Mawhen Roger clothmaker 595932 595932 Mayhewe alias Mawhen, Roger, of Waldyngfeld, clothmaker 2
3753477 1943025 1943025 defendant Ree John smith 595932 595932 Ree, John, of Waldyngfeld, smith 0
3777563 1950734 1950734 defendant Grene John husbandman 595932 595932 Grene, John, of Waldyngfeld, husbandman 3
3784557 1952957 1952957 defendant Glasewright Robert weaver 595932 595932 Glasewright, Robert, of Waldyngfeld, weaver 1
3789521 1954547 1954547 defendant Bostok Richard husbandman 595932 595932 Bostok, Richard, of Waldyngfeld, husbandman 0
3821393 1964585 1964585 defendant Smyth John husbandman 595932 595932 Smyth, John, of Waldyngfeld, husbandman 4
3839829 1970387 1970387 defendant Gosse Thomas husbandman 595932 595932 Gosse, Thomas, of Waldyngfeld, husbandman 1
3991840 2021834 2021834 defendant Harrys William husbandman 595932 595932 Harrys, William, of Waldyngfeld, husbandman 2
3992885 2022209 2022209 plaintiff Wyncoll John clothier 595932 595932 (Wyncoll, John, of Waldyngfeld, clothier 1
3992889 2022210 2022210 plaintiff Wyncoll John clothier 595932 595932 (Wyncoll, John, of Waldyngfeld, clothier 1
4013962 2029728 2029728 defendant Laye Thomas yeoman 595932 595932 Laye, Thomas, of Waldyngfeld, yeoman 0
4198376 2094979 2094979 defendant Posford Robert sherman 595932 595932 Posford, Robert, of Waldyngfeld, sherman 3
4539382 2212576 2212576 defendant Brook Thomas   595932 595932 Brook Thomas, of Waldyngfeld 0
4539387 2212578 2212578 defendant Brook Thomas   595932 595932 Brook, Thomas, of Waldyngfeld 0
4554430 2217317 2217317 defendant Brook Thomas   595932 595932 Brook, Thomas, of Waldyngfeld 1
4579273 2224998 2224998 defendant Brook Thomas   595932 595932 Brook, Thomas, of Waldyngfeld 3
4645896 2244869 2244869 defendant Woode Richard   595932 595932 Woode, Richard, of Waldyngfeld 1
4667057 2255428 2255428 plaintiff Appilton John   595932 595932 Appilton, John, of Waldyngfeld 0
4705664 2267145 2267145 defendant Ryngesele William yeoman 595932 595932 Ryngesele, William, of Waldyngfeld, yeoman 2
4711499 2268926 2268926 defendant Boyys John yeoman 595932 595932 Boyys, John, of Waldyngfeld, yeoman 1
4722677 2272408 2272408 defendant Colman John weaver 595932 595932 Colman, John, of Waldyngfeld, weaver 2
4756135 2282294 2282294 defendant Reynham Thomas husbandman 595932 595932 Reynham, Thomas, of Waldyngfeld, husbandman 0
4871409 2318023 2318023 defendant Sheldrake John yeoman 595932 595932 Sheldrake, John, of Waldyngfeld, yeoman 3
4896880 2325679 2325679 defendant Berwyk Thomas yeoman 595932 595932 Berwyk, Thomas, of Waldyngfeld, yeoman 1
5029112 2365391 2365391 defendant Balle Richard tailor 595932 595932 Balle, Richard, of Waldyngfeld, tailor 0
5194568 2414141 2414141 defendant Wyles William clerk 595932 595932 Wyles, William, of Waldyngfeld, clerk 1
5255198 2431741 2431741 defendant Thruston Robert yeoman 595932 595932 Thruston, Robert, of Waldyngfeld, yeoman 4
5287216 2441280 2441280 defendant Smyth Robert yeoman 595932 595932 Smyth, Robert, of Waldyngfeld, yeoman 2
5287217 2441280 2441280 defendant Salman Thomas weaver 595932 595932 Salman, Thomas, of Waldyngfeld, weaver 3
5287218 2441280 2441280 defendant Rysby John weaver 595932 595932 Rysby, John, of Waldyngfeld, weaver 4
5391758 2472715 2472715 defendant Holman William yeoman 595932 595932 Holman, William, of Waldyngfeld, yeoman 4
5404725 2476430 2476430 defendant Holman William yeoman 595932 595932 Holman, William, of Waldyngfeld, yeoman 4
5417868 2480272 2480272 defendant Holm_ William yeoman 595932 595932 Holm_, William, of Waldyngfeld, yeoman 2
5417876 2480274 2480274 defendant Holman William yeoman 595932 595932 Holman, William, of Waldyngfeld, yeoman 3
5487504 2501157 2501157 defendant Couper Robert clerk 595932 595932 Couper, Robert, of Waldyngfeld, clerk 0
5506578 2506968 2506968 defendant Rysyng Richard   595932 595932 Rysyng, Richard, of Waldyngfeld 0
5506580 2506969 2506969 defendant Rysyng Richard   595932 595932 Rysyng, Richard, of Waldyngfeld 0
5529617 2513762 2513762 defendant Wode Thomas husbandman 595932 595932 Wode, Thomas, of Waldyngfeld, husbandman 4
5612810 2547762 2547762 defendant Prat John   595932 595932 Prat, John, of Waldyngfeld 0
5613309 2547944 2547944 defendant Ruggeden Walter   595932 595932 Ruggeden, Walter, of Waldyngfeld 2

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