names

27 rows where place_id = 761440

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4478939 2194078 2194078 defendant Jakson Robert   761440 761440 Jakson, Robert, of Glossop 4
4479308 2194178 2194178 defendant Leghes Richard de   761440 761440 Leghes, Richard de, of Glossop 1
4479312 2194178 2194178 defendant Jakson Robert   761440 761440 Jakson, Robert, of Glossop 5
4508889 2203255 2203255 defendant Andrewe Hugh   761440 761440 Andrewe, Hugh, of Glossop 1
4540123 2212813 2212813 defendant Raulynson John   761440 761440 Raulynson, John, of Glossop 0
4540124 2212813 2212813 defendant Raulynson William   761440 761440 Raulynson, William, of Glossop 1
4669291 2256104 2256104 defendant Bradbury Richard yeoman 761440 761440 Bradbury, Richard, of Glossop, yeoman 0
4686094 2261242 2261242 defendant Monkson William yeoman 761440 761440 Monkson, William, of Glossop, yeoman 0
4808102 2298709 2298709 defendant Bowre John yeoman 761440 761440 Bowre, John, of Glossop, yeoman 1
4841007 2308722 2308722 defendant Neweton Thomas husbandman 761440 761440 Neweton, Thomas, of Glossop, husbandman 0
5034173 2366858 2366858 defendant Clayton Robert yeoman 761440 761440 Clayton, Robert, of Glossop, yeoman 2
5034177 2366858 2366858 defendant Clayton Nicholas yeoman 761440 761440 Clayton, Nicholas, of Glossop, yeoman 6
5034179 2366858 2366858 defendant Stafford Christopher yeoman 761440 761440 Stafford, Christopher, of Glossop, yeoman 8
5251287 2430504 2430504 defendant Darnle John husbandman 761440 761440 Darnle, John, of Glossop, husbandman 2
5322383 2451766 2451766 defendant Couper Ralph yeoman 761440 761440 Couper, Ralph, of Glossop, yeoman 15
5322385 2451766 2451766 defendant Redfern Nicholas yeoman 761440 761440 Redfern, Nicholas, of Glossop, yeoman 17
5322386 2451766 2451766 defendant Redfern Walter yeoman 761440 761440 Redfern, Walter, of Glossop, yeoman 18
5322403 2451767 2451767 defendant Couper Ralph yeoman 761440 761440 Couper, Ralph, of Glossop, yeoman 15
5322405 2451767 2451767 defendant Redfern Nicholas yeoman 761440 761440 Redfern, Nicholas, of Glossop, yeoman 17
5322406 2451767 2451767 defendant Redfern Walter yeoman 761440 761440 Redfern, Walter, of Glossop, yeoman 18
5386713 2471266 2471266 defendant Neweham Christopher yeoman 761440 761440 Neweham, Christopher, of Glossop, yeoman 1
5387476 2471489 2471489 defendant Bradbury Robert yeoman 761440 761440 Bradbury, Robert, of Glossop, yeoman 0
5399949 2475075 2475075 defendant Bradbury Robert yeoman 761440 761440 Bradbury, Robert, of Glossop, yeoman 0
5412935 2478814 2478814 defendant Bradbury Robert yeoman 761440 761440 Bradbury, Robert, of Glossop, yeoman 0
5412937 2478815 2478815 defendant Bradbury Robert yeoman 761440 761440 Bradbury, Robert, of Glossop, yeoman 0
5521324 2511485 2511485 defendant Nedam Brian yeoman 761440 761440 Nedam, Brian, of Glossop, yeoman 0
5603408 2535954 2535954 defendant Neuton William chapman 761440 761440 Neuton, William, of Glossop, chapman 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);