names

56 rows where place_id = 641888

✎ 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
3864469 1978316 1978316 defendant Wall Thomas yeoman 641888 641888 Wall, Thomas, of Leskyrd, yeoman 1
3864473 1978317 1978317 defendant Wall Thomas yeoman 641888 641888 Wall, Thomas, of Leskyrd, yeoman 1
3878530 1983063 1983063 defendant Quynterell Richard   641888 641888 Quynterell, Richard, of Leskyrd, Cornw yeoman 0
3879175 1983288 1983288 defendant Bere William gent 641888 641888 Bere, William, of Leskyrd, gent 0
4520775 2206838 2206838 plaintiff Fouke Richard   641888 641888 Fouke, Richard, of Leskyrd 0
4520776 2206838 2206838 defendant Hoper John   641888 641888 Hoper, John, of Leskyrd 0
4520996 2206902 2206902 defendant Greek John   641888 641888 Greek, John, of Leskyrd 0
4525514 2208307 2208307 defendant Fook Richard   641888 641888 Fook, Richard, of Leskyrd 0
4526043 2208441 2208441 defendant Lovepyt William   641888 641888 Lovepyt, William, of Leskyrd 1
4526047 2208441 2208441 defendant Phylyp William   641888 641888 Phylyp, William, of Leskyrd 5
4526541 2208584 2208584 defendant Asshelake Roger   641888 641888 Asshelake, Roger, of Leskyrd 0
4536778 2211774 2211774 plaintiff Stoke John   641888 641888 Stoke, John, of Leskyrd 0
4538919 2212444 2212444 defendant Atteroke John smith 641888 641888 Atteroke, John, of Leskyrd, smith 0
4573177 2223147 2223147 plaintiff Bandy or Baudyn Henry (legal representative) 641888 641888 Bandy or Baudyn, Henry, of Leskyrd, executors of 0
4573180 2223147 2223147 defendant Stoke John   641888 641888 Stoke, John, of Leskyrd 0
4573815 2223328 2223328 plaintiff Baudyn Henry (legal representative) 641888 641888 Baudyn, Henry, of Leskyrd, executors of 0
4573818 2223328 2223328 defendant Stoke John   641888 641888 Stoke, John, of Leskyrd 0
4580658 2225432 2225432 defendant Gille John   641888 641888 Gille, John, of Leskyrd 0
4580662 2225433 2225433 defendant Gille John   641888 641888 Gille, John, of Leskyrd 0
4588983 2227930 2227930 defendant Rowe Roger   641888 641888 Rowe, Roger, of Leskyrd 2
4588990 2227931 2227931 defendant Rowe Roger   641888 641888 Rowe, Roger, of Leskyrd 2
4588991 2227931 2227931 defendant Croppe William   641888 641888 Croppe, William, of Leskyrd 3
4588992 2227931 2227931 defendant Cliker William   641888 641888 Cliker, William, of Leskyrd 4
4589907 2228207 2228207 defendant Hore William, sen   641888 641888 Hore, William, sen, of Leskyrd 1
4589914 2228208 2228208 defendant Hore William, sen   641888 641888 Hore, William, sen, of Leskyrd 1
4589934 2228210 2228210 defendant Stoke John   641888 641888 Stoke, John, of Leskyrd 7
4600648 2231429 2231429 defendant Carpenter Peter   641888 641888 Carpenter, Peter, of Leskyrd 0
4600650 2231430 2231430 defendant Carpenter Peter   641888 641888 Carpenter, Peter, of Leskyrd 0
4632467 2241044 2241044 plaintiff Vaga Richard   641888 641888 Vaga, Richard, of Leskyrd 0
4673971 2257475 2257475 defendant Bray Peter husbandman 641888 641888 with Bray, Peter, of Leskyrd, husbandman 1
4701595 2265893 2265893 plaintiff Gille Robert   641888 641888 Gille, Robert, of Leskyrd 0
4947059 2341074 2341074 defendant Kyng John husbandman 641888 641888 Kyng, John, of Leskyrd, husbandman 0
4947060 2341074 2341074 defendant Chitte Thomas cutler 641888 641888 Chitte, Thomas, of Leskyrd, cutler 1
4947061 2341074 2341074 defendant Mory Richard tanner 641888 641888 Mory, Richard, of Leskyrd, tanner 2
4947063 2341074 2341074 defendant Skynnard Thomas tanner 641888 641888 together with Skynnard, Thomas, of Leskyrd, tanner 4
4947064 2341074 2341074 defendant Golde John husbandman 641888 641888 Golde, John, of Leskyrd, husbandman 5
4947066 2341074 2341074 defendant Havere or Hanere John tanner 641888 641888 (Havere or Hanere, John, of Leskyrd, tanner 7
4947067 2341074 2341074 defendant Heryngboide John cordwainer 641888 641888 Heryngboide, John, of Leskyrd, cordwainer 8
4982583 2351705 2351705 defendant Stephyn Nicholas gent 641888 641888 Stephyn, Nicholas, of Leskyrd, gent 1
4999364 2356681 2356681 defendant Peke Lawrence tanner 641888 641888 Peke, Lawrence, of Leskyrd, tanner 1
4999366 2356681 2356681 defendant Helyer Alan tanner 641888 641888 Helyer, Alan, of Leskyrd, tanner 3
4999370 2356682 2356682 defendant Hendre Robert shoemaker 641888 641888 Hendre, Robert, of Leskyrd, shoemaker 0
4999371 2356682 2356682 defendant Knolle Thomas tanner 641888 641888 Knolle, Thomas, of Leskyrd, tanner 1
4999372 2356682 2356682 defendant Rosmylyen Pastus baker 641888 641888 Rosmylyen, Pastus, of Leskyrd, baker 2
5010847 2360026 2360026 defendant Langedon Roger gent 641888 641888 Langedon, Roger, of Leskyrd, gent 0
5026334 2364592 2364592 defendant Hendre Robert cordwainer 641888 641888 Hendre, Robert, of Leskyrd, cordwainer 3
5030811 2365880 2365880 defendant Kympe Nicholas yeoman 641888 641888 Kympe, Nicholas, of Leskyrd, yeoman 5
5049155 2371384 2371384 defendant Bottaburgh John John clerk 641888 641888 Bottaburgh, John John, of Leskyrd, clerk 0
5049156 2371384 2371384 defendant May Robert tanner 641888 641888 May, Robert, of Leskyrd, tanner 1
5049157 2371384 2371384 defendant Clemens Richard   641888 641888 Clemens, Richard, of Leskyrd, franklin 2
5049158 2371384 2371384 defendant Moungevyle William smith 641888 641888 Moungevyle, William, of Leskyrd, smith 3
5057402 2373782 2373782 defendant Trebygowe Stephen husbandman 641888 641888 Trebygowe, Stephen, of Leskyrd, husbandman 5
5325784 2452793 2452793 plaintiff Skynnard John merchant 641888 641888 Skynnard, John, of Leskyrd, merchant 0
5584549 2530238 2530238 defendant Hampstede Robert cutler 641888 641888 Hampstede, Robert, of Leskyrd, cutler 0
5584550 2530238 2530238 defendant Philip John cutler 641888 641888 Philip, John, of Leskyrd, cutler 1
5630903 2553677 2553677 defendant Felip William tanner 641888 641888 Felip, William, of Leskyrd, tanner 1

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