names

28 rows where place_id = 585948

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587552 1863755 1863755 defendant Crocheman John butcher 585948 585948 Crocheman, John, of Retyngdon, butcher 2
3598185 1867063 1867063 defendant Herd John husbandman 585948 585948 Herd, John, of Retyngdon, husbandman 1
3720816 1932801 1932801 defendant Done John husbandman 585948 585948 Done, John, of Retyngdon, husbandman 0
3840464 1970578 1970578 defendant Nobull Thomas   585948 585948 Nobull, Thomas, of Retyngdon, minstrel 4
3857466 1975971 1975971 plaintiff Athaye William   585948 585948 Athaye, William, of Retyngdon 0
4433497 2175238 2175238 defendant Prille William   585948 585948 Prille, William, of Retyngdon 1
4433499 2175239 2175239 defendant Feure John   585948 585948 Feure, John, of Retyngdon 0
4433501 2175240 2175240 plaintiff Gilberd William   585948 585948 Gilberd, William, of Retyngdon 0
4433504 2175241 2175241 plaintiff Gilberd William   585948 585948 Gilberd, William, of Retyngdon 0
4433506 2175241 2175241 defendant Ovyncheld John   585948 585948 Ovyncheld, John, of Retyngdon, son of Matthew 1
4433507 2175241 2175241 defendant Stebbynges Nicholas de   585948 585948 Stebbynges, Nicholas de, of Retyngdon 2
4439474 2181609 2181609 defendant Croket William   585948 585948 Croket, William, of Retyngdon 2
4481217 2194807 2194807 plaintiff Lod Nicholas (legal representative) 585948 585948 Lod, Nicholas, of Retyngdon, farmer of the church, executors of 0
4517229 2205788 2205788 defendant atte Hey Thomas   585948 585948 atte Hey, Thomas, of Retyngdon 1
4545851 2214634 2214634 plaintiff Botere Robert   585948 585948 Botere, Robert, of Retyngdon 0
4593614 2229276 2229276 defendant Botere John   585948 585948 Botere, John, of Retyngdon 0
4677383 2258544 2258544 defendant Camber John, junior husbandman 585948 585948 Camber, John, junior, of Retyngdon, husbandman 0
4732572 2275363 2275363 defendant Ame William farmer of the manor 585948 585948 Ame, William, of Retyngdon, yeoman, farmer of the manor 1
4755514 2282104 2282104 defendant atte Welle Thomas   585948 585948 atte Welle, Thomas, of Retyngdon 2
4771963 2287203 2287203 defendant Selong John chesebyer or cheese buyer 585948 585948 Selong, John, of Retyngdon, chesebyer or cheese buyer 0
5013498 2360784 2360784 defendant Sharp Richard fuller 585948 585948 Sharp, Richard, of Retyngdon, fuller 1
5087993 2382863 2382863 defendant Gylbert William husandman 585948 585948 Gylbert, William, of Retyngdon, husandman 0
5103255 2387383 2387383 plaintiff Bray John husbandman 585948 585948 Bray, John, of Retyngdon, husbandman 0
5221484 2421981 2421981 defendant at Hye William pulter 585948 585948 at Hye, William, of Retyngdon, pulter 1
5319952 2451052 2451052 defendant Bekyrton Henry chaplain 585948 585948 Bekyrton, Henry, of Retyngdon, chaplain 0
5440431 2487041 2487041 defendant Clouber William husbandman 585948 585948 Clouber, William, of Retyngdon, husbandman 0
5453827 2491037 2491037 defendant Camber William husbandman 585948 585948 Camber, William, of Retyngdon, husbandman 0
5605195 2536500 2536500 defendant Radclyff William clerk 585948 585948 Radclyff, William, of Retyngdon, clerk 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);