names

35 rows where place_id = 597048

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627091 1903334 1903334 defendant Sowgate Walter husbandman 597048 597048 Sowgate, Walter, of Wyrlyngham, husbandman 0
3765764 1946958 1946958 defendant Ovy John butcher 597048 597048 Ovy, John, of Wyrlyngham, butcher 0
3838793 1970061 1970061 defendant Davy Roger husbandman 597048 597048 Davy, Roger, of Wyrlyngham, husbandman 0
3894187 1988272 1988272 defendant Rose John husbandman 597048 597048 Rose, John, of Wyrlyngham, husbandman 1
3908383 1993101 1993101 defendant Rose John husbandman 597048 597048 Rose, John, of Wyrlyngham, husbandman 0
3919992 1997026 1997026 defendant Falke Thomas husbandman 597048 597048 Falke, Thomas, of Wyrlyngham, husbandman 0
4456651 2187106 2187106 defendant Wrong John   597048 597048 Wrong, John, of Wyrlyngham 0
4496126 2199467 2199467 defendant Hawe John   597048 597048 Hawe, John, of Wyrlyngham 0
4516096 2205448 2205448 defendant Hawe John   597048 597048 Hawe, John, of Wyrlyngham 0
4672004 2256888 2256888 defendant Totewey Henry husbandman 597048 597048 Totewey, Henry, of Wyrlyngham, husbandman 0
4720914 2271874 2271874 defendant Heyward William husbandman 597048 597048 Heyward, William, of Wyrlyngham, husbandman 0
4724879 2273076 2273076 defendant Heyward Wiliam husbandman 597048 597048 Heyward, Wiliam, of Wyrlyngham, husbandman 1
4754454 2281771 2281771 defendant Havell Roger fissher 597048 597048 Havell, Roger, of Wyrlyngham, fissher 3
4770462 2286735 2286735 defendant Heyward William husbandman 597048 597048 Heyward, William, of Wyrlyngham, husbandman 0
4770464 2286736 2286736 defendant Heyward William husbandman 597048 597048 Heyward, William, of Wyrlyngham, husbandman 0
4781935 2290356 2290356 defendant Wronge William husbandman 597048 597048 Wronge, William, of Wyrlyngham, husbandman 0
4785816 2291597 2291597 defendant Heyward William husbandman 597048 597048 Heyward, William, of Wyrlyngham, husbandman 0
4818967 2302014 2302014 defendant Grene Simon clerk 597048 597048 Grene, Simon, of Wyrlyngham, clerk 0
4884042 2321920 2321920 plaintiff Leberd John   597048 597048 Leberd, John, of Wyrlyngham 1
4884043 2321920 2321920 defendant Heyward William yeoman 597048 597048 Heyward, William, of Wyrlyngham, yeoman 0
4895008 2325105 2325105 defendant Heyward William husbandman 597048 597048 Heyward, William, of Wyrlyngham, husbandman 0
4903157 2327597 2327597 plaintiff Leberd John   597048 597048 Leberd, John, of Wyrlyngham 1
4903158 2327597 2327597 defendant Heyward William yeoman 597048 597048 Heyward, William, of Wyrlyngham, yeoman 0
5199488 2415597 2415597 defendant Eye John butcher 597048 597048 Eye, John, of Wyrlyngham, butcher 2
5213226 2419598 2419598 defendant Broke alias Reder Richard husbandman 597048 597048 Broke alias Reder, Richard, of Wyrlyngham, husbandman 0
5231299 2424752 2424752 defendant Broke alias Rede Richard husbandman 597048 597048 Broke alias Rede, Richard, of Wyrlyngham, husbandman 0
5369339 2466012 2466012 plaintiff Eye John, junior yeoman 597048 597048 Eye, John, junior, of Wyrlyngham, yeoman 0
5369340 2466012 2466012 defendant Falke John, senior   597048 597048 Falke, John, senior, of Wyrlyngham, ship wright 0
5375652 2467976 2467976 defendant Plomer William clerk 597048 597048 Plomer, William, of Wyrlyngham, clerk 2
5379861 2469286 2469286 defendant Quynte Walter husbandman 597048 597048 Quynte, Walter, of Wyrlyngham, husbandman 0
5379862 2469286 2469286 defendant Crowe Robert husbandman 597048 597048 Crowe, Robert, of Wyrlyngham, husbandman 1
5399569 2474957 2474957 defendant Hanell or Havell Walter fisher 597048 597048 Hanell or Havell, Walter, of Wyrlyngham, fisher 0
5412583 2478708 2478708 defendant Havell William fisher 597048 597048 Havell, William, of Wyrlyngham, fisher 0
5525171 2512466 2512466 plaintiff Grevall John, senior   597048 597048 Grevall, John, senior, of Wyrlyngham 0
5532981 2514857 2514857 defendant Clerk Nicholas thatcher 597048 597048 Clerk, Nicholas, of Wyrlyngham, thatcher 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);