names

39 rows where place_id = 589393

✎ 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
3597485 1866834 1866834 defendant Wren John husbandman 589393 589393 Wren, John, of North Flete, husbandman 0
3597486 1866834 1866834 defendant Crofte John husbandman 589393 589393 Crofte, John, of North Flete, husbandman 1
3616463 1872788 1872788 defendant Hilles John husbandman 589393 589393 Hilles, John, of North Flete, husbandman 0
3651574 1910846 1910846 defendant Pyerce Robert husbandman 589393 589393 Pyerce, Robert, of North Flete, husbandman 0
3838006 1969797 1969797 defendant Fuller Thomas husbandman 589393 589393 Fuller, Thomas, of North Flete, husbandman 1
3839665 1970331 1970331 defendant Posyer William yeoman 589393 589393 Posyer, William, of North Flete, yeoman 1
3953066 2008136 2008136 defendant Thornton William husbandman 589393 589393 Thornton, William, of North Flete, husbandman 0
3953067 2008136 2008136 defendant Thornton Robert husbandman 589393 589393 Thornton, Robert, of North Flete, husbandman 1
4107810 2063071 2063071 defendant Saxcie Tristram gent 589393 589393 Saxcie, Tristram, of North Flete, or of Winsall, gent 0
4435677 2175910 2175910 defendant Grigge William   589393 589393 Grigge, William, of North Flete 5
4435697 2175911 2175911 defendant Grigge William   589393 589393 Grigge, William, of North Flete 5
4481268 2194827 2194827 defendant Craft Richard   589393 589393 Craft, Richard, of North Flete 0
4550441 2216082 2216082 defendant Chamberlayn Robert   589393 589393 Chamberlayn, Robert, of North Flete 3
4558911 2218748 2218748 plaintiff Marchall Thomas   589393 589393 Marchall, Thomas, of North Flete 0
4558913 2218748 2218748 defendant Payn Henry   589393 589393 Payn, Henry, of North Flete 1
4597011 2230308 2230308 defendant Bedenesshe Thomas   589393 589393 Bedenesshe, Thomas, of North Flete 0
4626162 2239141 2239141 defendant Pool Thomas   589393 589393 Pool, Thomas, of North Flete 0
4639351 2243020 2243020 defendant Shadde William   589393 589393 Shadde, William, of North Flete 1
4639355 2243021 2243021 defendant Shadde William   589393 589393 Shadde, William, of North Flete 1
4688446 2261953 2261953 defendant Pole Thomas laborer 589393 589393 Pole, Thomas, of North Flete, laborer 2
4708517 2268031 2268031 defendant Ingram Richard tailor 589393 589393 Ingram, Richard, of North Flete, tailor 0
4734395 2275926 2275926 plaintiff Scarburgh Alice (legal representative) 589393 589393 Scarburgh, Alice, of North Flete, formerly wife of John, executors of 0
4734397 2275926 2275926 plaintiff Leytot Richard   589393 589393 Leytot, Richard, of North Flete 2
4736697 2276607 2276607 defendant Bidenerssh John miller 589393 589393 Bidenerssh, John, of North Flete, miller 1
4742826 2278409 2278409 defendant Parage Richard husbandman 589393 589393 Parage, Richard, of North Flete, husbandman 0
4772194 2287274 2287274 plaintiff Letot Richard   589393 589393 Letot, Richard, of North Flete 1
5003852 2358018 2358018 plaintiff Pertrich Reginald   589393 589393 Pertrich, Reginald, of North Flete 0
5041820 2369152 2369152 defendant Fluk Thomas husbandman 589393 589393 Fluk, Thomas, of North Flete, husbandman 1
5113008 2390197 2390197 defendant Bery Simon husbandman 589393 589393 Bery, Simon, of North Flete, husbandman 2
5113013 2390198 2390198 defendant Bery Simon husbandman 589393 589393 Bery, Simon, of North Flete, husbandman 2
5117322 2391500 2391500 defendant Hauker William yeoman 589393 589393 Hauker, William, of North Flete, yeoman 0
5134792 2396677 2396677 defendant Gerard Walter husbandman 589393 589393 Gerard, Walter, of North Flete, husbandman 0
5136093 2397067 2397067 defendant Lymsey John gent 589393 589393 Lymsey, John, of North Flete, gent 0
5175330 2408475 2408475 defendant Lymsey John gent 589393 589393 Lymsey, John, of North Flete, gent 0
5175332 2408475 2408475 defendant Ingram William husbandman 589393 589393 Ingram, William, of North Flete, husbandman 2
5339643 2456972 2456972 defendant Blakeman Walter husbandman 589393 589393 Blakeman, Walter, of North Flete, husbandman 3
5360357 2463274 2463274 defendant Ruttour Robert gent 589393 589393 Ruttour, Robert, of North Flete, gent 1
5407457 2477204 2477204 defendant Alisaunder William gent 589393 589393 Alisaunder, William, of North Flete, gent 0
5594486 2533256 2533256 defendant Serle Hugh yeoman 589393 589393 Serle, Hugh, of North Flete, 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);