names

44 rows where place_id = 615059

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3706884 1928439 1928439 defendant Stacy William yeoman 615059 615059 Stacy, William, of Thacham, Berks, yeoman 1
3809929 1960993 1960993 defendant Justice Thomas clerk 615059 615059 Justice, Thomas, of Thacham, Berks, clerk 0
3902294 1991001 1991001 defendant Willyams Thomas chapman 615059 615059 Willyams, Thomas, of Thacham, Berks, chapman 1
3906718 1992540 1992540 defendant White Thomas fuller 615059 615059 White, Thomas, of Thacham, Berks, fuller 0
3930470 2000536 2000536 defendant Bye Thomas clothier 615059 615059 Bye, Thomas, of Thacham, Berks, clothier 3
3940181 2003734 2003734 defendant Smythe William husbandman 615059 615059 Smythe, William, of Thacham, Berks, husbandman 3
4063274 2047161 2047161 plaintiff Harte John yeoman 615059 615059 (Harte, John, of Thacham, Berks, yeoman 1
4063279 2047162 2047162 plaintiff Harte John yeoman 615059 615059 (Harte, John, of Thacham, Berks, yeoman 1
4067778 2048788 2048788 defendant Hutchinson John smith 615059 615059 Hutchinson, John, of Thacham, berks, smith 1
4136290 2073323 2073323 defendant Waythe or Wayghte John chapman 615059 615059 Waythe or Wayghte, John, of Thacham, Berks, chapman 0
4177470 2087595 2087595 defendant Waller William clothier 615059 615059 Waller, William, of Thacham, Berks, clothier 0
4375115 2156160 2156160 defendant Goddard Henry tanner 615059 615059 Goddard, Henry, of Thacham, Berks, tanner 0
4612768 2235059 2235059 defendant Bower John   615059 615059 Bower, John, of Thacham, Berks 2
4616123 2236049 2236049 defendant Faram William chapman 615059 615059 Faram, William, of Thacham, Berks, chapman 2
4616127 2236050 2236050 defendant Faram William chapman 615059 615059 Faram, William, of Thacham, Berks, chapman 2
4616130 2236051 2236051 defendant Ponston John chapman 615059 615059 Ponston, John, of Thacham, Berks, chapman 1
4616133 2236052 2236052 defendant Pouston John chapman 615059 615059 Pouston, John, of Thacham, Berks, chapman 1
4639689 2243124 2243124 defendant Bower John   615059 615059 Bower, John, of Thacham, Berks 0
4639696 2243125 2243125 defendant Bower John   615059 615059 Bower, John, of Thacham, Berks 0
4744499 2278915 2278915 defendant Faram William, junior husbandman 615059 615059 Faram, William, junior, of Thacham, Berks, husbandman 1
4774767 2288100 2288100 defendant Faram William chapman 615059 615059 Faram, William, of Thacham, Berks, chapman 1
4787805 2292251 2292251 defendant Hulle John mercer 615059 615059 Hulle, John, of Thacham, Berks, mercer 0
4810212 2299340 2299340 defendant Crowelond John chapman 615059 615059 Crowelond, John, of Thacham, Berks, chapman 0
4829998 2305428 2305428 defendant Bromehull John chapman 615059 615059 Bromehull, John, of Thacham, Bersk, chapman 0
4858826 2314137 2314137 defendant Lyoll John bowyer 615059 615059 Lyoll, John, of Thacham, Berks, bowyer 0
4883576 2321780 2321780 defendant Castell Thomas fuller 615059 615059 Castell, Thomas, of Thacham, Berks, fuller 0
4888944 2323328 2323328 defendant Castell Thomas fuller 615059 615059 Castell, Thomas, of Thacham, Berks, fuller 0
4910076 2329673 2329673 defendant Castell Thomas fuller 615059 615059 Castell, Thomas, of Thacham, Berks, fuller 0
4917902 2332113 2332113 defendant Golderyche John fuller 615059 615059 Golderyche, John, of Thacham, Berks, fuller 0
4932190 2336465 2336465 defendant Lyoll John   615059 615059 Lyoll, John, of Thacham, Berks, bow maker 1
5001170 2357220 2357220 defendant Boteler William husbandman 615059 615059 Boteler, William, of Thacham, Berks, husbandman 1
5013826 2360894 2360894 defendant Castell Ralph weaver 615059 615059 Castell, Ralph, of Thacham, Berks, weaver 0
5023564 2363801 2363801 defendant Bever John smith 615059 615059 Bever, John, of Thacham, Berks, smith 0
5023566 2363802 2363802 defendant Bever John smith 615059 615059 Bever, John, of Thacham, Berks, smith 0
5044183 2369888 2369888 defendant Pury John esq 615059 615059 Pury, John, of Thacham, Berks, esq 1
5089922 2383432 2383432 defendant Perye John esq 615059 615059 Perye, John, of Thacham, Berks, esq 0
5208704 2418269 2418269 defendant Castell Ralph weaver 615059 615059 Castell, Ralph, of Thacham, Berks, weaver 1
5219154 2421328 2421328 defendant Pyrry John esq 615059 615059 Pyrry, John, of Thacham, Berks, esq 5
5219161 2421329 2421329 defendant Pyrry John esq 615059 615059 Pyrry, John, of Thacham, Berks, esq 5
5238322 2426794 2426794 defendant Baker Robert hosteler 615059 615059 Baker, Robert, of Thacham, Berks, hosteler 0
5306781 2447023 2447023 defendant Braknale John hosteler 615059 615059 Braknale, John, of Thacham, Berks, hosteler 0
5328878 2453714 2453714 defendant Bolton John bowyer 615059 615059 Bolton, John, of Thacham, Berks, bowyer 3
5328891 2453718 2453718 defendant Bolton John bowyer 615059 615059 Bolton, John, of Thacham, Berks, bowyer 3
5349730 2460052 2460052 plaintiff Chavelok John clothman 615059 615059 Chavelok, John, of Thacham, Berks, clothman 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);