names

24 rows where place_id = 600746

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642351 1908055 1908055 plaintiff Carleton John gent 600746 600746 Carleton, John, of Eppyng, Essex, gent 0
3643545 1908410 1908410 defendant Wolloston Richard gent 600746 600746 Wolloston, Richard, of Eppyng, Essex, gent 1
3790755 1954934 1954934 defendant Carleton John gent 600746 600746 Carleton, John, of Eppyng, Essex, gent 0
3807072 1960104 1960104 defendant Carleton John gent 600746 600746 Carleton, John, of Eppyng, Essex, gent 0
3836676 1969371 1969371 defendant Rygby Oliver yeoman 600746 600746 Rygby, Oliver, of Eppyng, Essex, yeoman 2
3877868 1982842 1982842 defendant Charleton John esq 600746 600746 Charleton, John, of Eppyng, Essex, esq 2
3884301 1985014 1985014 defendant Carleton John gent 600746 600746 Carleton, John, of Eppyng, Essex, gent 0
3934663 2001887 2001887 defendant Parker John yeoman [ d / 1456 ? ] 600746 600746 Parker, John, of Eppyng, Essex, yeoman [ d / 1456 ? ] 3
4339209 2143476 2143476 defendant Campyon George innholder 600746 600746 Campyon, George, of Eppyng, Essex, yeoman, innholder 0
4373298 2155517 2155517 defendant Raynsford Robert gent 600746 600746 Raynsford, Robert, of Eppyng, Essex, gent 0
4663552 2250079 2250079 defendant atte Chirche Gilbert husbandman 600746 600746 atte Chirche, Gilbert, of Eppyng, Essex, husbandman 0
4851017 2311768 2311768 defendant Wyberd Thomas husbandman 600746 600746 Wyberd, Thomas, of Eppyng, Essex, husbandman 0
4860771 2314729 2314729 defendant Wyberd Thomas husbandman 600746 600746 Wyberd, Thomas, of Eppyng, Essex, husbandman 4
4860780 2314732 2314732 defendant Wyberd Thomas husbandman 600746 600746 Wyberd, Thomas, of Eppyng, Essex, husbandman 0
5122968 2393148 2393148 defendant Clerke John husbandman 600746 600746 Clerke, John, of Eppyng, Essex, husbandman 2
5122974 2393149 2393149 defendant Clerke John husbandman 600746 600746 Clerke, John, of Eppyng, Essex, husbandman 2
5138723 2397821 2397821 defendant Brigges John   600746 600746 Brigges, John, of Eppyng, Essex 0
5138726 2397822 2397822 defendant Brigges John yeoman 600746 600746 Brigges, John, of Eppyng, Essex, yeoman 0
5490051 2501907 2501907 defendant Westmell Thomas husbandman 600746 600746 Westmell, Thomas, of Eppyng, Essex, husbandman 1
5490054 2501908 2501908 defendant Holwey William husbandman 600746 600746 Holwey, William, of Eppyng, Essex, husbandman 1
5502528 2505709 2505709 defendant Slye John husbandman 600746 600746 Slye, John, of Eppyng, Essex, husbandman 2
5556711 2521922 2521922 defendant Coke John chapman 600746 600746 Coke, John, of Eppyng, Essex, chapman 1
5556716 2521923 2521923 defendant Coke John chapman 600746 600746 Coke, John, of Eppyng, Essex, chapman 1
5607599 2537273 2537273 defendant Coraunte John yeoman 600746 600746 Coraunte, John, of Eppyng, Essex, yeoman 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);