names

32 rows where place_id = 600121

✎ 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
3639777 1907250 1907250 defendant Wolder Thomas husbandman 600121 600121 Wolder, Thomas, of Fyndon, husbandman 0
3841765 1971012 1971012 defendant Sumner John husbandman 600121 600121 Sumner, John, of Fyndon, husbandman 0
3866531 1979036 1979036 defendant Sommer John husbandman 600121 600121 Sommer, John, of Fyndon, husbandman 0
3947718 2006264 2006264 defendant Summer Richard husbandman 600121 600121 Summer, Richard, of Fyndon, husbandman 1
3947719 2006264 2006264 defendant Summer John husbandman 600121 600121 Summer, John, of Fyndon, husbandman 2
3947721 2006264 2006264 defendant Wappam Reginald yeoman 600121 600121 Wappam, Reginald, of Fyndon, yeoman 4
4177458 2087591 2087591 defendant Scutt Thomas sherman 600121 600121 Scutt, Thomas, of Fyndon, sherman 1
4180029 2088492 2088492 defendant Sympson George clerk 600121 600121 Sympson, George, of Fyndon, clerk 0
4321471 2137599 2137599 defendant Streater Henry husbandman 600121 600121 Streater, Henry, of Fyndon, husbandman 0
4554190 2217234 2217234 defendant Kyngeswode John   600121 600121 Kyngeswode, John, of Fyndon 0
4592345 2228953 2228953 defendant Huchons John   600121 600121 Huchons, John, of Fyndon, vicar 0
4605968 2232982 2232982 defendant Taillour Richard   600121 600121 Taillour, Richard, of Fyndon 0
4632359 2241009 2241009 defendant Brewes John   600121 600121 Brewes, John, of Fyndon, vicar 0
4707363 2267679 2267679 defendant Olyver Robert laborer 600121 600121 Olyver, Robert, of Fyndon, laborer 2
4715603 2270207 2270207 defendant Kyngeswode John yeoman 600121 600121 Kyngeswode, John, of Fyndon, yeoman 0
4720189 2271659 2271659 defendant Grover Thomas   600121 600121 Grover, Thomas, of Fyndon, park man 1
4834617 2306830 2306830 plaintiff Croner Nicholas (legal representative) 600121 600121 Croner, Nicholas, of Fyndon, executors of 0
5077189 2379679 2379679 defendant Waryn John husbandman 600121 600121 Waryn, John, of Fyndon, husbandman 2
5082288 2381194 2381194 defendant Wareyn John, senior husbandman 600121 600121 Wareyn, John, senior, of Fyndon, husbandman 0
5082289 2381194 2381194 defendant Wolder John husbandman 600121 600121 Wolder, John, of Fyndon, husbandman 1
5082290 2381194 2381194 defendant Waren John, junior husbandman 600121 600121 Waren, John, junior, of Fyndon, husbandman 2
5118171 2391751 2391751 defendant Bacheler alias Bensey Thomas merchant 600121 600121 Bacheler alias Bensey, Thomas, of Fyndon, merchant 0
5124393 2393587 2393587 defendant (illegible) --husbandman   600121 600121 --, --husbandman, of Fyndon 0
5139734 2398097 2398097 plaintiff Sound Robert husbandman 600121 600121 Sound, Robert, of Fyndon, husbandman 0
5139735 2398097 2398097 plaintiff Sound John husbandman 600121 600121 Sound, John, of Fyndon, husbandman 1
5147112 2400293 2400293 defendant Brynkton William butcher 600121 600121 Brynkton, William, of Fyndon, butcher 1
5166947 2406062 2406062 defendant Brynkton William butcher 600121 600121 Brynkton, William, of Fyndon, butcher 1
5203214 2416703 2416703 defendant Brynkton William butcher 600121 600121 Brynkton, William, of Fyndon, butcher 1
5221564 2422003 2422003 defendant Cowner John yeoman 600121 600121 Cowner, John, of Fyndon, yeoman 1
5263646 2434380 2434380 defendant Couper John husbandman 600121 600121 Couper, John, of Fyndon, husbandman 2
5283832 2440307 2440307 defendant Slade Thomas husbandman 600121 600121 Slade, Thomas, of Fyndon, husbandman 0
5527332 2513129 2513129 defendant Serle John husbandman 600121 600121 Serle, John, of Fyndon, husbandman 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);