names

37 rows where place_id = 596089

✎ 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
3623097 1874747 1874747 defendant Sparowe Isabel widow 596089 596089 Sparowe, Isabel, of Keteleston, widow 0
3710145 1929487 1929487 defendant Dalahay William gent 596089 596089 Dalahay, William, of Keteleston, gent 0
4477404 2193599 2193599 plaintiff Curson John   596089 596089 (Curson, John, of Keteleston 1
4477409 2193600 2193600 plaintiff Curson John   596089 596089 (Curson, John, of Keteleston 1
4477425 2193603 2193603 plaintiff Curson John   596089 596089 (Curson, John, of Keteleston 1
4509139 2203334 2203334 defendant Netbraydere John   596089 596089 Netbraydere, John, of Keteleston 1
4516624 2205613 2205613 defendant Breydere John   596089 596089 Breydere, John, of Keteleston 0
4516625 2205613 2205613 defendant Dreu William   596089 596089 Dreu, William, of Keteleston 1
4516626 2205613 2205613 defendant Lente John   596089 596089 Lente, John, of Keteleston 2
4576873 2224269 2224269 defendant Breydere John   596089 596089 Breydere, John, of Keteleston 0
4615688 2235909 2235909 plaintiff Fen John   596089 596089 Fen, John, of Keteleston 0
4630696 2240501 2240501 defendant Breydere Richard   596089 596089 Breydere, Richard, of Keteleston 3
4641202 2243519 2243519 plaintiff Fen John   596089 596089 Fen, John, of Keteleston 0
4650128 2246056 2246056 defendant Lenton John   596089 596089 Lenton, John, of Keteleston 1
4661041 2249277 2249277 defendant Letton John clerk 596089 596089 Letton, John, of Keteleston, clerk 4
4663560 2250082 2250082 defendant Burnell John husbandman 596089 596089 Burnell, John, of Keteleston, husbandman 0
4666329 2250941 2250941 defendant Burnel John yeoman 596089 596089 Burnel, John, of Keteleston, yeoman 1
4674265 2257559 2257559 defendant Drwe Henry carpenter 596089 596089 Drwe, Henry, of Keteleston, carpenter 1
4674266 2257559 2257559 defendant Drwe Edward carpenter 596089 596089 Drwe, Edward, of Keteleston, carpenter 2
4711397 2268895 2268895 defendant atte Fen William husbandman 596089 596089 atte Fen, William, of Keteleston, husbandman 0
4724732 2273031 2273031 defendant Teler Henry yeoman 596089 596089 Teler, Henry, of Keteleston, yeoman 5
4752738 2281258 2281258 plaintiff Tonte of Toute Richard   596089 596089 Tonte of Toute, Richard, of Keteleston, on his own account 0
4759775 2283394 2283394 defendant Barwell John   596089 596089 Barwell, John, of Keteleston, bailiff 1
4786717 2291899 2291899 defendant Burnell John yeoman 596089 596089 Burnell, John, of Keteleston, yeoman 3
4812602 2300058 2300058 defendant Bakton John yeoman 596089 596089 Bakton, John, of Keteleston, yeoman 0
4812606 2300059 2300059 defendant Bakton John yeoman 596089 596089 Bakton, John, of Keteleston, yeoman 2
4848326 2310946 2310946 defendant Kyrkeby John yeoman 596089 596089 Kyrkeby, John, of Keteleston, yeoman 4
4866587 2316510 2316510 defendant Bakton John husbandman 596089 596089 Bakton, John, of Keteleston, husbandman 2
4866588 2316510 2316510 defendant Baxstere Thomas husbandman 596089 596089 Baxstere, Thomas, of Keteleston, husbandman 3
4866589 2316510 2316510 defendant Toute or Tonte Richard husbandman 596089 596089 Toute or Tonte, Richard, of Keteleston, husbandman 4
5095861 2385216 2385216 defendant Crulle John husbandman 596089 596089 Crulle, John, of Keteleston, husbandman 2
5199312 2415548 2415548 defendant Nevell William husbandman 596089 596089 Nevell, William, of Keteleston, husbandman 0
5232785 2425175 2425175 defendant Gouty Thomas laborer 596089 596089 Gouty, Thomas, of Keteleston, laborer 2
5267576 2435619 2435619 defendant Sawer William husbandman 596089 596089 Sawer, William, of Keteleston, husbandman 1
5343264 2458088 2458088 plaintiff Sparowe Richard   596089 596089 Sparowe, Richard, of Keteleston, or of Oxburwe 0
5343266 2458088 2458088 defendant Greene alias Nyghtyngale Robert yeoman 596089 596089 Greene alias Nyghtyngale, Robert, of Keteleston, yeoman 1
5635036 2554944 2554944 defendant Breydere Richard butcher 596089 596089 Breydere, Richard, of Keteleston, butcher 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);