names

21 rows where case_id = 2334970

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4927278 2334970 2334970 plaintiff Routh John     Routh, John 0
4927279 2334970 2334970 defendant Burgys Robert husbandman 596148 596148 Burgys, Robert, of Lokyngton, husbandman 0
4927280 2334970 2334970 defendant Hoton Richard husbandman 823287 823287 Hoton, Richard, of Ett----, husbandman 1
4927281 2334970 2334970 defendant Kirkeby Richard husbandman 823288 823288 Kirkeby, Richard, of Southborn, husbandman 2
4927282 2334970 2334970 defendant Appylby William yeoman 774017 774017 Appylby, William, of Kyrkelley, yeoman 3
4927283 2334970 2334970 defendant Risum Roger   589274 589274 Risum, Roger, of Cotyngham, bailiff 4
4927284 2334970 2334970 defendant Mylner Nicholas husbandman 822152 822152 Mylner, Nicholas, of Hoton Crauncewyk or Hutton Cranswick, husbandman 5
4927285 2334970 2334970 defendant Still Patrick husbandman 589274 589274 Still, Patrick, of Cotyngham, husbandman 6
4927286 2334970 2334970 defendant Raynthorp Bartholomew husbandman 589274 589274 Raynthorp, Bartholomew, of Cotyngham, husbandman 7
4927287 2334970 2334970 defendant Catwyk William pynder 593309 593309 Catwyk, William, of Crauncewyk, pynder 8
4927288 2334970 2334970 defendant Betonson William husbandman 590199 590199 Betonson, William, of Nessewyke, husbandman 9
4927289 2334970 2334970 defendant Kyndo William husbandman 590199 590199 Kyndo, William, of Nessewyke, husbandman 10
4927290 2334970 2334970 defendant Goundre Stephen husbandman 593309 593309 Goundre, Stephen, of Crauncewyk, husbandman 11
4927291 2334970 2334970 defendant Smyth Richard husbandman 593309 593309 Smyth, Richard, of Crauncewyk, husbandman 12
4927292 2334970 2334970 defendant Roos Ivell husbandman 761472 761472 Roos, Ivell, of Routh, husbandman 13
4927293 2334970 2334970 defendant Glover Thomas husbandman 761472 761472 Glover, Thomas, of Routh, husbandman 14
4927294 2334970 2334970 defendant Ake John chaplain 586070 586070 Ake, John, of Beverley, chaplain 15
4927295 2334970 2334970 defendant Reyner John husbandman 589274 589274 Reyner, John, of Cotyngham, husbandman 16
4927296 2334970 2334970 defendant Bysshop John husbandman 692762 692762 Bysshop, John, of Bourn, husbandman 17
4927297 2334970 2334970 defendant Smyth John husbandman 593309 593309 Smyth, John, of Crauncewyk, husbandman 18
4927298 2334970 2334970 defendant Goodson John glover 761472 761472 Goodson, John, of Routh, glover 19

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);