names

32 rows where place_id = 624979

✎ 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
3761415 1945583 1945583 defendant Reynold John miller 624979 624979 Reynold, John, of Bradefeld, miller 0
4427153 2173318 2173318 defendant Brok William de   624979 624979 Brok, William de, of Bradefeld 0
4520409 2206728 2206728 plaintiff fitz Rauf William   624979 624979 fitz Rauf, William, of Bradefeld 0
4520411 2206729 2206729 plaintiff fitz Rauf William   624979 624979 fitz Rauf, William, of Bradefeld 0
4533193 2210644 2210644 defendant Broun William carter 624979 624979 Broun, William, of Bradefeld, carter 13
4535283 2211303 2211303 defendant Hoo Benedict de   624979 624979 Hoo, Benedict de, of Bradefeld 0
4563014 2219998 2219998 defendant Eyre William   624979 624979 Eyre, William, of Bradefeld 1
4571578 2222689 2222689 defendant Martyn John   624979 624979 Martyn, John, of Bradefeld 0
4576833 2224260 2224260 plaintiff Burghard John   624979 624979 Burghard, John, of Bradefeld 0
4592309 2228943 2228943 defendant Godard Thomas   624979 624979 Godard, Thomas, of Bradefeld 0
4595034 2229704 2229704 defendant Steresacre Richard   624979 624979 Steresacre, Richard, of Bradefeld St Cler 1
4595767 2229928 2229928 plaintiff Rither John   624979 624979 Rither, John, of Bradefeld 0
4599851 2231183 2231183 plaintiff Taillour Thomas   624979 624979 Taillour, Thomas, of Bradefeld 0
4614173 2235442 2235442 defendant Warner John   624979 624979 Warner, John, of Bradefeld, son of Agatha 0
4648208 2245541 2245541 defendant Richer John   624979 624979 Richer, John, of Bradefeld 4
4655645 2247648 2247648 defendant Maykyn William husbandman 624979 624979 Maykyn, William, of Bradefeld, husbandman 0
4660745 2249184 2249184 defendant Ryther John miller 624979 624979 Ryther, John, of Bradefeld, miller 1
4665926 2250819 2250819 defendant Broun John carter 624979 624979 Broun, John, of Bradefeld, carter 2
4665930 2250820 2250820 defendant Broun William carter 624979 624979 Broun, William, of Bradefeld, ,carter 2
4667800 2255635 2255635 defendant Chelmound Robert butcher 624979 624979 Chelmound, Robert, of Bradefeld, butcher 0
4691491 2262863 2262863 defendant Trunche John yeoman 624979 624979 Trunche, John, of Bradefeld, yeoman 0
4692813 2263263 2263263 defendant Chelmond Robert butcher 624979 624979 Chelmond, Robert, of Bradefeld, butcher 0
4705436 2267067 2267067 defendant Hoo William de weaver 624979 624979 Hoo, William de, of Bradefeld, weaver 0
4705437 2267067 2267067 defendant Agas John husbandman 624979 624979 Agas, John, of Bradefeld, husbandman 1
4739828 2277531 2277531 plaintiff Aleyn William (legal representative) 624979 624979 Aleyn, William, of Bradefeld, executors of 0
4801719 2296718 2296718 defendant Everard Walter gent 624979 624979 Everard, Walter, of Bradefeld, or of Staunton Quynteyn, gent 0
4823418 2303412 2303412 defendant Fakon John clerk 624979 624979 Fakon, John, of Bradefeld St Cler, clerk 0
4860679 2314701 2314701 defendant Bowede Robert husbandman 624979 624979 Bowede, Robert, of Bradefeld, husbandman 0
4889686 2323567 2323567 defendant Bowede Thomas chaplain 624979 624979 Bowede, Thomas, of Bradefeld, chaplain 0
5081714 2381033 2381033 defendant Langford Edward esq 624979 624979 Langford, Edward, of Bradefeld, esq 0
5081717 2381033 2381033 defendant Mylys John yeoman 624979 624979 Mylys, John, of Bradefeld, yeoman 3
5249970 2430101 2430101 defendant Symon William laborer 624979 624979 Symon, William, of Bradefeld, laborer 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);