names

30 rows where place_id = 615266

✎ 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
3707998 1928796 1928796 defendant Donnyng William husbandman 615266 615266 Donnyng, William, of Staynford, husbandman 0
3830812 1967520 1967520 plaintiff Ganne Andrew merchant 615266 615266 Ganne, Andrew, of Staynford, merchant 0
4426315 2173039 2173039 defendant Arode Richard   615266 615266 Arode, Richard, of Staynford 1
4446411 2183795 2183795 plaintiff del Park John   615266 615266 del Park, John, of Staynford 0
4446412 2183795 2183795 defendant Reynald Richard   615266 615266 Reynald, Richard, of Staynford 0
4460910 2188479 2188479 defendant Parke John   615266 615266 Parke, John, of Staynford 0
4462201 2188877 2188877 defendant Symmeson Thomas   615266 615266 Symmeson, Thomas, of Staynford 0
4479706 2194314 2194314 plaintiff Johnson Matilda   615266 615266 Johnson, Matilda, of Staynford, formerly wife of Thomas Jonson 0
4570521 2222353 2222353 plaintiff Wryght John   615266 615266 Wryght, John, of Staynford 0
4613688 2235292 2235292 defendant Denyas Richard   615266 615266 Denyas, Richard, of Staynford 0
4613757 2235317 2235317 defendant del Park John   615266 615266 del Park, John, of Staynford 0
4613759 2235318 2235318 defendant del Parke John   615266 615266 del Parke, John, of Staynford 0
4642918 2244039 2244039 defendant Latoner John   615266 615266 Latoner, John, of Staynford 1
4642919 2244039 2244039 defendant Drax Alan   615266 615266 Drax, Alan, of Staynford 2
4642922 2244039 2244039 defendant Astyn John   615266 615266 Astyn, John, of Staynford 5
4642924 2244039 2244039 defendant Dounyng Thomas   615266 615266 Dounyng, Thomas, of Staynford 7
4642925 2244039 2244039 defendant Karlele John   615266 615266 Karlele, John, of Staynford 8
4642926 2244039 2244039 defendant Smyth William   615266 615266 Smyth, William, of Staynford 9
4656156 2247808 2247808 defendant Burdeclever William   615266 615266 Burdeclever, William, of Staynford, "burdeclever" 3
4735618 2276291 2276291 defendant Bray John husbandman 615266 615266 Bray, John, of Staynford, husbandman 0
4745089 2279073 2279073 defendant Doket John yeoman 615266 615266 Doket, John, of Staynford, yeoman 8
4786085 2291687 2291687 defendant Cokhede John husbandman 615266 615266 Cokhede, John, of Staynford, husbandman 1
4830407 2305544 2305544 defendant Nicoll Hugh laborer 615266 615266 Nicoll, Hugh, of Staynford, laborer 2
4870406 2317721 2317721 defendant Craven John husbandman 615266 615266 Craven, John, of Staynford, husbandman 1
4883900 2321874 2321874 defendant Smyth John husbandman 615266 615266 Smyth, John, of Staynford, husbandman 0
4886020 2322487 2322487 defendant Fox Thomas husbandman 615266 615266 Fox, Thomas, of Staynford, husbandman 1
4980952 2351237 2351237 defendant Drax John (legal representative) 615266 615266 Drax, John, of Staynford, executors of 0
5107245 2388548 2388548 defendant Drowre John husbandman 615266 615266 Drowre, John, of Staynford, husbandman 0
5107246 2388548 2388548 defendant Latoner William husbandman 615266 615266 Latoner, William, of Staynford, husbandman 1
5529993 2513887 2513887 defendant Fraunkeleyn John yeoman 615266 615266 Fraunkeleyn, John, of Staynford, 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);