names

51 rows where place_id = 764534

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4507005 2202660 2202660 defendant Mirestowe John   764534 764534 Mirestowe, John, of Thornour 0
4596257 2230080 2230080 defendant Tyas Thomas   764534 764534 Tyas, Thomas, of Thornour 0
4715747 2270247 2270247 defendant Erle Roger fishmonger 764534 764534 Erle, Roger, of Thornour, fishmonger 1
4715748 2270247 2270247 defendant Erle Robert yeoman 764534 764534 Erle, Robert, of Thornour, yeoman 2
4715749 2270247 2270247 defendant Erle John yeoman 764534 764534 Erle, John, of Thornour, yeoman 3
4715750 2270247 2270247 defendant Marsshalt John yeoman 764534 764534 Marsshalt, John, of Thornour, yeoman 4
4736126 2276434 2276434 defendant Tyas Thomas chapman 764534 764534 Tyas, Thomas, of Thornour, chapman 0
4736128 2276435 2276435 defendant Tyas Thomas chapman 764534 764534 Tyas, Thomas, of Thornour, chapman 0
4745768 2279269 2279269 defendant Tyas Thomas chapman 764534 764534 Tyas, Thomas, of Thornour, chapman 4
4751147 2280813 2280813 defendant Pole John slater 764534 764534 Pole, John, of Thornour, slater 1
4751148 2280813 2280813 defendant Eltoft John husbandman 764534 764534 Eltoft, John, of Thornour, husbandman 2
4751149 2280813 2280813 defendant Neustede William, junior laborer 764534 764534 Neustede, William, junior, of Thornour, laborer 3
4767663 2285866 2285866 defendant Bukshawe William husbandman 764534 764534 Bukshawe, William, of Thornour, husbandman 17
4776215 2288551 2288551 defendant Megson Thomas yeoman 764534 764534 Megson, Thomas, of Thornour, yeoman 0
4817086 2301440 2301440 defendant Bruke Thomas yeoman 764534 764534 Bruke, Thomas, of Thornour, yeoman 3
4817087 2301440 2301440 defendant Sclater William yeoman 764534 764534 Sclater, William, of Thornour, yeoman 4
4817088 2301440 2301440 defendant Yalle Thomas yeoman 764534 764534 Yalle, Thomas, of Thornour, yeoman 5
4817089 2301440 2301440 defendant Scalter Edmund yeoman 764534 764534 Scalter, Edmund, of Thornour, yeoman 6
4817090 2301440 2301440 defendant Scoreby John laborer 764534 764534 Scoreby, John, of Thornour, laborer 7
4817091 2301440 2301440 defendant Eltofss Thomas yeoman 764534 764534 Eltofss, Thomas, of Thornour, yeoman 8
4817092 2301440 2301440 defendant Bleton John   764534 764534 Bleton, John, of Thornour, servant 9
4817093 2301440 2301440 defendant Bowet John   764534 764534 Bowet, John, of Thornour, servant 10
4817094 2301440 2301440 defendant Lund John   764534 764534 Lund, John, of Thornour, servant 11
4821980 2302945 2302945 defendant Sclatyer Thomas slater 764534 764534 Sclatyer, Thomas, of Thornour, slater 0
4824567 2303734 2303734 defendant Bron Henry husbandman 764534 764534 Bron, Henry, of Thornour, husbandman 3
4872412 2318334 2318334 defendant Eltoft Thomas smith 764534 764534 Eltoft, Thomas, of Thornour, smith 0
4875502 2319293 2319293 defendant Pole John slater 764534 764534 Pole, John, of Thornour, slater 1
4895848 2325373 2325373 defendant Thornour Patrick yeoman 764534 764534 Thornour, Patrick, of Thornour, yeoman 10
4896746 2325641 2325641 defendant Eltoft John husbandman 764534 764534 Eltoft, John, of Thornour, husbandman 0
4898570 2326198 2326198 defendant Allan John husbandman 764534 764534 Allan, John, of Thornour, husbandman 0
4898571 2326198 2326198 defendant Howeby John husbandman 764534 764534 Howeby, John, of Thornour, husbandman 1
4898572 2326198 2326198 defendant Calcotes John   764534 764534 Calcotes, John, of Thornour, wright 2
4904400 2327991 2327991 defendant Eltoft John husbandman 764534 764534 Eltoft, John, of Thornour, husbandman 0
5000899 2357140 2357140 defendant Standen John husbandman 764534 764534 Standen, John, of Thornour, husbandman 0
5058771 2374188 2374188 defendant Herryson Thomas husbandman 764534 764534 Herryson, Thomas, of Thornour, husbandman 3
5090798 2383699 2383699 defendant Pole John slater 764534 764534 Pole, John, of Thornour, slater 1
5097608 2385728 2385728 defendant Symson William slater 764534 764534 Symson, William, of Thornour, slater 0
5097611 2385728 2385728 defendant Smyth John slater 764534 764534 Smyth, John, of Thornour, slater 3
5121700 2392776 2392776 defendant Alan William butcher 764534 764534 Alan, William, of Thornour, butcher 1
5150455 2401267 2401267 defendant Atkynson Robert   764534 764534 Atkynson, Robert, of Thornour 2
5154018 2402335 2402335 defendant Proktour James husbandman 764534 764534 Proktour, James, of Thornour, husbandman 4
5171258 2407314 2407314 defendant Procton James husbandman 764534 764534 Procton, James, of Thornour, husbandman 4
5234312 2425624 2425624 defendant Emondson Henry, junior chapman 764534 764534 Emondson, Henry, junior, of Thornour, chapman 0
5234313 2425624 2425624 defendant Emondson Edmund chapman 764534 764534 Emondson, Edmund, of Thornour, chapman 1
5246524 2429144 2429144 defendant Pole John slater 764534 764534 Pole, John, of Thornour, slater 0
5305163 2446550 2446550 defendant Wroo Richard husbandman 764534 764534 Wroo, Richard, of Thornour, husbandman 2
5341238 2457453 2457453 defendant Edmundson Henry chapman 764534 764534 Edmundson, Henry, of Thornour, chapman 0
5344522 2458460 2458460 defendant Lange William yeoman 764534 764534 Lange, William, of Thornour, yeoman 0
5344523 2458460 2458460 defendant Lange John yeoman 764534 764534 Lange, John, of Thornour, yeoman 1
5344525 2458460 2458460 defendant Warde William husbandman 764534 764534 Warde, William, of Thornour, husbandman 3
5572036 2526369 2526369 defendant Henryson William yeoman 764534 764534 Henryson, William, of Thornour, 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);