names

50 rows where place_id = 589230

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596960 1866678 1866678 defendant Fresshmer Robert yeoman 589230 589230 Fresshmer, Robert, of Maltby, yeoman 1
3628019 1903616 1903616 defendant Tounehend Thomas husbandman 589230 589230 Tounehend, Thomas, of Maltby, husbandman 4
3672594 1917426 1917426 defendant Townnesend Richard husbandman 589230 589230 Townnesend, Richard, of Maltby, husbandman 0
3672595 1917426 1917426 defendant Arthur John husbandman 589230 589230 Arthur, John, of Maltby, husbandman 1
3672596 1917426 1917426 defendant Arthur William husbandman 589230 589230 Arthur, William, of Maltby, husbandman 2
3677721 1919079 1919079 defendant Clerke John yeoman 589230 589230 Clerke, John, of Maltby, yeoman 0
3779425 1951288 1951288 defendant Westby Edward   589230 589230 Westby, Edward, of Maltby, gent, son of Westby, William 0
3837412 1969612 1969612 defendant Coke John husbandman 589230 589230 Coke, John, of Maltby, husbandman 0
4089290 2056454 2056454 defendant Parker Ancelm husbandman 589230 589230 Parker, Ancelm, of Maltby, husbandman 0
4130836 2071340 2071340 defendant Townende Thomas husbandman 589230 589230 Townende, Thomas, of Maltby, husbandman 1
4147957 2077418 2077418 defendant Broune John yeoman 589230 589230 Broune, John, of Maltby, or of Saltfletby, yeoman 1
4165484 2083429 2083429 defendant Hartlington Denis yeoman 589230 589230 Hartlington, Denis, of Maltby, yeoman 1
4165485 2083429 2083429 defendant Townesend Thomas husbandman 589230 589230 Townesend, Thomas, of Maltby, husbandman 2
4169077 2084681 2084681 defendant Dougworth Henry miller 589230 589230 Dougworth, Henry, of Maltby, or of Haultbie, Yorks, miller 0
4182380 2089310 2089310 defendant Dungworth Henry miller 589230 589230 Dungworth, Henry, of Maltby, miller 0
4185727 2090510 2090510 defendant Hartlington Denis yeoman 589230 589230 Hartlington, Denis, of Maltby, yeoman 3
4205360 2097425 2097425 defendant Dungworth Henry miller 589230 589230 Dungworth, Henry, of Maltby, miller 0
4313115 2134704 2134704 defendant East Hugh clerk 589230 589230 East, Hugh, of Maltby, clerk 2
4322254 2137858 2137858 defendant Gascoigne Christopher gent 589230 589230 Gascoigne, Christopher, of Maltby, gent 1
4404992 2166240 2166240 defendant Dungworth Henry yeoman 589230 589230 Dungworth, Henry, of Maltby, yeoman 0
4464043 2189424 2189424 defendant Colvyle William   589230 589230 Colvyle, William, of Maltby 0
4492083 2198214 2198214 plaintiff Wyloghs Alice de lez   589230 589230 Wyloghs, Alice de lez, of Maltby 0
4504476 2201958 2201958 defendant del Spenne Robert   589230 589230 del Spenne, Robert, of Maltby 0
4542362 2213501 2213501 defendant Bucher John   589230 589230 Bucher, John, of Maltby 0
4682561 2260164 2260164 defendant atte Kirk John husbandman 589230 589230 atte Kirk, John, of Maltby, husbandman 5
4688173 2261866 2261866 defendant Bramley John husbandman 589230 589230 Bramley, John, of Maltby, husbandman 0
4688174 2261866 2261866 defendant Bramley Richard husbandman 589230 589230 Bramley, Richard, of Maltby, husbandman 1
4711334 2268878 2268878 defendant Bramlay John husbandman 589230 589230 Bramlay, John, of Maltby, husbandman 0
4730411 2274708 2274708 plaintiff Brerlay Richard   589230 589230 Brerlay, Richard, of Maltby 1
4730412 2274708 2274708 plaintiff Bramlay John   589230 589230 Bramlay, John, of Maltby 2
4730413 2274708 2274708 plaintiff Coke John   589230 589230 Coke, John, of Maltby 3
4806733 2298317 2298317 plaintiff Chaumbre Thomas yeoman 589230 589230 Chaumbre, Thomas, of Maltby, yeoman 0
4839389 2308243 2308243 defendant Dancy Simon laborer 589230 589230 Dancy, Simon, of Maltby, laborer 0
4881401 2321081 2321081 defendant Urith John   589230 589230 Urith, John, of Maltby 1
4914387 2331016 2331016 defendant Langholm John gent 589230 589230 Langholm, John, of Maltby, gent 0
4914389 2331017 2331017 defendant Langholm John gent 589230 589230 Langholm, John, of Maltby, gent 0
4936520 2337808 2337808 defendant Saweley John husbandman 589230 589230 Saweley, John, of Maltby, husbandman 10
4961795 2345491 2345491 defendant Sollay John husbandman 589230 589230 Sollay, John, of Maltby, husbandman 4
4965005 2346449 2346449 defendant FitzWilliam Thomas esq 589230 589230 FitzWilliam, Thomas, of Maltby, esq 0
5099329 2386234 2386234 defendant Bramley John husbandman 589230 589230 Bramley, John, of Maltby, husbandman 0
5219466 2421419 2421419 plaintiff Bonyse or Bovyse John   589230 589230 Bonyse or Bovyse, John, of Maltby 1
5250848 2430376 2430376 defendant Bramley John husbandman 589230 589230 Bramley, John, of Maltby, husbandman 1
5308357 2447536 2447536 plaintiff Sandford Brian esq 589230 589230 Sandford, Brian, of Maltby, esq 0
5377225 2468463 2468463 defendant Forster Thomas yeoman 589230 589230 Forster, Thomas, of Maltby, yeoman 0
5377227 2468464 2468464 defendant Forster Thomas yeoman 589230 589230 Forster, Thomas, of Maltby, yeoman 0
5413221 2478880 2478880 plaintiff Forster Thomas   589230 589230 Forster, Thomas, of Maltby 0
5428361 2483408 2483408 plaintiff Forster Thomas   589230 589230 Forster, Thomas, of Maltby 0
5445742 2488614 2488614 plaintiff Forster Thomas   589230 589230 Forster, Thomas, of Maltby 0
5591115 2532199 2532199 defendant Ayer William yeoman 589230 589230 Ayer, William, of Maltby, yeoman 1
5591119 2532200 2532200 defendant Ayer William yeoman 589230 589230 Ayer, William, of Maltby, yeoman 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);