names

21 rows where place_id = 595466

✎ 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
3620583 1874014 1874014 defendant Aleyn Thomas husbandman 595466 595466 Aleyn, Thomas, of Pepynbery, husbandman 2
3647070 1909476 1909476 defendant Stace Thomas miller 595466 595466 Stace, Thomas, of Pepynbery, miller 1
3666594 1915491 1915491 defendant Crotynden John husbandman 595466 595466 Crotynden, John, of Pepynbery, husbandman 1
3866369 1978986 1978986 plaintiff Polley John, senior (legal representative) 595466 595466 Polley, John, senior, of Pepynbery, executor of 0
3902471 1991057 1991057 defendant Wynter William husbandman 595466 595466 Wynter, William, of Pepynbery, husbandman 0
4425431 2172781 2172781 plaintiff Marchaunt William, senior   595466 595466 Marchaunt, William, senior, of Pepynbery 0
4579533 2225080 2225080 defendant Herst Simon   595466 595466 Herst, Simon, of Pepynbery 1
4672698 2257103 2257103 defendant Chitecroft John husbandman 595466 595466 Chitecroft, John, of Pepynbery, husbandman 2
4779439 2289549 2289549 defendant Blakepette John shoemaker 595466 595466 Blakepette, John, of Pepynbery, shoemaker 0
4779440 2289549 2289549 defendant atte Broke Nicholas laborer 595466 595466 atte Broke, Nicholas, of Pepynbery, laborer 1
4779441 2289549 2289549 defendant Robyn John laborer 595466 595466 Robyn, John, of Pepynbery, laborer 2
4779442 2289549 2289549 defendant Poyll John shoemaker 595466 595466 Poyll, John, of Pepynbery, shoemaker 3
4779444 2289549 2289549 defendant Croweherst John wheeler 595466 595466 Croweherst, John, of Pepynbery, wheeler 5
4779445 2289549 2289549 defendant Chytecroft John laborer 595466 595466 Chytecroft, John, of Pepynbery, laborer 6
5342597 2457885 2457885 defendant Donke or Douke John husbandman 595466 595466 Donke or Douke, John, of Pepynbery, husbandman 0
5367508 2465485 2465485 defendant Lorken John laborer 595466 595466 Lorken, John, of Pepynbery, laborer 1
5367510 2465485 2465485 defendant Lorken William laborer 595466 595466 Lorken, William, of Pepynbery, laborer 3
5487830 2501249 2501249 defendant Aleyn Thomas yeoman 595466 595466 Aleyn, Thomas, of Pepynbery, yeoman 0
5487831 2501249 2501249 defendant Colyn Thomas husbandman 595466 595466 Colyn, Thomas, of Pepynbery, husbandman 1
5491273 2502277 2502277 defendant Benge Simon husbandman 595466 595466 Benge, Simon, of Pepynbery, husbandman 0
5631488 2553858 2553858 defendant Roo John cordwainer 595466 595466 Roo, John, of Pepynbery, cordwainer 1

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