names

37 rows where place_id = 588392

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594340 1865862 1865862 defendant Smalwode Peter yeoman 588392 588392 Smalwode, Peter, of Elmested, yeoman 0
3603986 1868913 1868913 defendant Horsley William husbandman 588392 588392 Horsley, William, of Elmested, husbandman 0
3656715 1912353 1912353 defendant Fylpotte William husbandman 588392 588392 Fylpotte, William, of Elmested, husbandman 0
3669362 1916355 1916355 defendant Brown William   588392 588392 Brown, William, of Elmested, parish clerk 2
3727095 1934740 1934740 defendant Deveres Robert   588392 588392 Deveres, Robert, of Elmested, pale maker 5
3776491 1950401 1950401 defendant Myxer John yeoman 588392 588392 Myxer, John, of Elmested, yeoman 0
3980729 2017870 2017870 defendant Moone Michael husbandman 588392 588392 Moone, Michael, of Elmested, husbandman 2
4036124 2037600 2037600 defendant Cloke Thomas yeoman 588392 588392 Cloke, Thomas, of Elmested, yeoman 0
4210587 2099258 2099258 defendant Harrys Peter yeoman 588392 588392 Harrys, Peter, of Elmested, yeoman 0
4234131 2107467 2107467 plaintiff Dunkyn Michael yeoman 588392 588392 Dunkyn, Michael, of Elmested, yeoman 0
4234133 2107467 2107467 defendant Page Thomas gent 588392 588392 Page, Thomas, of Elmested, husbandman, assign of Walter Tresse, of Elmested, gent 0
4278480 2122409 2122409 defendant Waight Henry yeoman 588392 588392 Waight, Henry, of Elmested, yeoman 0
4278740 2122500 2122500 defendant Wayte Henry yeoman 588392 588392 Wayte, Henry, of Elmested, yeoman 0
4369343 2154100 2154100 defendant Cloke Thomas yeoman 588392 588392 Cloke, Thomas, of Elmested, yeoman 1
4378859 2157515 2157515 defendant Bedell Silvester yeoman 588392 588392 Bedell, Silvester, of Elmested, yeoman 0
4378862 2157516 2157516 defendant Payne John husbandman 588392 588392 Payne, John, of Elmested, husbandman 0
4378863 2157516 2157516 defendant Myller William yeoman 588392 588392 Myller, William, of Elmested, yeoman 1
4378864 2157516 2157516 defendant Bedell Silvester husbandman 588392 588392 Bedell, Silvester, of Elmested, husbandman 2
4401392 2165062 2165062 defendant Payne John yeoman 588392 588392 Payne, John, of Elmested, yeoman 1
4476476 2193309 2193309 plaintiff Fynchngfeld John master & parson 588392 588392 Fynchngfeld, John, of Elmested, master & parson 0
4541307 2213180 2213180 plaintiff Wombe John (legal representative) 588392 588392 Wombe, John, of Elmested, executors of 0
4672870 2257158 2257158 plaintiff Coppe William   588392 588392 Coppe, William, of Elmested 0
4672875 2257158 2257158 defendant Hamon William laborer 588392 588392 Hamon, William, of Elmested, laborer 4
4672878 2257158 2257158 defendant Page Edmund laborer 588392 588392 Page, Edmund, of Elmested, laborer 7
4701532 2265874 2265874 defendant Pekard William husbandman 588392 588392 Pekard, William, of Elmested, husbandman 0
4701533 2265874 2265874 defendant Medewe John husbandman 588392 588392 Medewe, John, of Elmested, husbandman 1
4706989 2267567 2267567 defendant Franseys John husbandman 588392 588392 Franseys, John, of Elmested, husbandman 0
4706990 2267567 2267567 defendant Medwe John husbandman 588392 588392 Medwe, John, of elmested, husbandman 1
4730606 2274773 2274773 defendant Franseys John husbandman 588392 588392 Franseys, John, of Elmested, husbandman 0
4730607 2274773 2274773 defendant Medwe John husbandman 588392 588392 Medwe, John, of Elmested, husbandman 1
4735475 2276241 2276241 defendant Seman Henry yeoman 588392 588392 Seman, Henry, of Elmested, yeoman 0
4790122 2292990 2292990 defendant Steven William laborer 588392 588392 Steven, William, of Elmested, laborer 0
4940573 2339077 2339077 defendant Twisse Richard chaplain 588392 588392 Twisse, Richard, of Elmested, chaplain 0
5013835 2360896 2360896 defendant Fraunceys Thomas husbandman 588392 588392 Fraunceys, Thomas, of Elmested, husbandman 1
5019886 2362694 2362694 defendant Chache Walter husbandman 588392 588392 Chache, Walter, of Elmested, husbandman 0
5489529 2501749 2501749 defendant Horton Thomas husbandman 588392 588392 Horton, Thomas, of Elmested, husbandman 0
5515272 2509621 2509621 defendant Smalwode Peter yeoman 588392 588392 Smalwode, Peter, of Elmested, yeoman 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);