names

26 rows where place_id = 695960

✎ 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
4112127 2064595 2064595 defendant Melton William husbandman 695960 695960 Melton, William, of Oxcombe, husbandman 1
4453890 2186233 2186233 defendant Clerk Gilbert   695960 695960 Clerk, Gilbert, of Oxcombe 0
4453891 2186233 2186233 defendant Brinthorp John de   695960 695960 Brinthorp, John de, of Oxcombe, parson 1
4494559 2198990 2198990 plaintiff Hakworth John de   695960 695960 Hakworth, John de, of Oxcombe, parson 1
4494560 2198990 2198990 plaintiff Proktour Robert   695960 695960 Proktour, Robert, of Oxcombe 2
4614559 2235561 2235561 plaintiff Bradley Richard   695960 695960 Bradley, Richard, of Oxcombe 2
4659303 2248776 2248776 defendant de Bradley Richard esq 695960 695960 de Bradley, Richard, of Oxcombe, esq 0
4666048 2250851 2250851 defendant Coupar Roger husbandman 695960 695960 Coupar, Roger, of Oxcombe, husbandman 1
4680218 2259422 2259422 defendant Decke William   695960 695960 Decke, William, of Oxcombe, parson 0
4744484 2278909 2278909 defendant Smyth John husbandman 695960 695960 Smyth, John, of Oxcombe, husbandman 0
4753697 2281530 2281530 defendant Smyth John husbandman 695960 695960 Smyth, John, of Oxcombe, husbandman 0
4754234 2281702 2281702 defendant Ricarde William husbandman 695960 695960 Ricarde, William, of Oxcombe, husbandman 0
4765630 2285240 2285240 defendant Bekke William de clerk 695960 695960 Bekke, William de, of Oxcombe, clerk 0
4765631 2285240 2285240 defendant Smyth John husbandman 695960 695960 Smyth, John, of Oxcombe, husbandman 1
4820500 2302484 2302484 defendant Clerk Roger   695960 695960 Clerk, Roger, of Oxcombe, bailiff 0
4820501 2302484 2302484 defendant Bok William clerk 695960 695960 Bok, William, of Oxcombe, clerk 1
4825585 2304042 2304042 defendant Bek John husbandman 695960 695960 Bek, John, of Oxcombe, husbandman 2
4867936 2316940 2316940 defendant Clerk Roger   695960 695960 Clerk, Roger, of Oxcombe, bailiff 1
4869222 2317344 2317344 defendant Clerk Roger   695960 695960 Clerk, Roger, of Oxcombe, bailiff 0
4980212 2351029 2351029 defendant Clerk Roger   695960 695960 Clerk, Roger, of Oxcombe, bailiff 1
5040892 2368896 2368896 plaintiff Cawode John   695960 695960 Cawode, John, of Oxcombe 0
5066167 2376406 2376406 defendant Goose Robert husbandman 695960 695960 Goose, Robert, of Oxcombe, husbandman 0
5079719 2380420 2380420 plaintiff Cawode John (legal representative) 695960 695960 Cawode, John, of Oxcombe, executors of 0
5189375 2412624 2412624 defendant Dale John husbandman 695960 695960 Dale, John, of Oxcombe, husbandman 3
5240764 2427506 2427506 defendant Dale John husbandman 695960 695960 Dale, John, of Oxcombe, husbandman 2
5571890 2526320 2526320 defendant Gedney Gilbert husbandman 695960 695960 Gedney, Gilbert, of Oxcombe, husbandman 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);