names

38 rows where place_id = 658022

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3946661 2005897 2005897 defendant Handson John yeoman 658022 658022 Handson, John, of Lymynge, yeoman 0
4213973 2100410 2100410 defendant Cobbe Ambrose yeoman 658022 658022 Cobbe, Ambrose, of Lymynge, yeoman 0
4219495 2102318 2102318 defendant Tunbridge Thomas yeoman 658022 658022 Tunbridge, Thomas, of Lymynge, yeoman 0
4219496 2102318 2102318 defendant Jenken Thomas, junior husbandman 658022 658022 Jenken, Thomas, junior, of Lymynge, husbandman 1
4368693 2153853 2153853 defendant Eastland Philip husbandman 658022 658022 Eastland, Philip, of Lymynge, husbandman 0
4480838 2194676 2194676 defendant Kete. John junior   658022 658022 Kete. John, junior, of Lymynge 0
4488807 2197217 2197217 defendant Knyte John   658022 658022 Knyte, John, of Lymynge, senior 9
4488808 2197217 2197217 defendant Knyte John   658022 658022 Knyte, John, of Lymynge, junior 10
4495921 2199403 2199403 defendant Kete John   658022 658022 Kete, John, of Lymynge 0
4500804 2200867 2200867 defendant Lothour Henry   658022 658022 Lothour, Henry, of Lymynge 0
4503881 2201776 2201776 plaintiff Preme William   658022 658022 Preme, William, of Lymynge, parson, on his own account 0
4505331 2202197 2202197 defendant Bocher John   658022 658022 Bocher, John, of Lymynge 0
4515647 2205318 2205318 defendant Kote John   658022 658022 Kote, John, of Lymynge, senior 0
4651636 2246501 2246501 defendant Gilberd Richard husbandman 658022 658022 Gilberd, Richard, of Lymynge, husbandman 5
4651637 2246501 2246501 defendant Gardyner Henry husbandman 658022 658022 Gardyner, Henry, of Lymynge, husbandman: Br-, William, of Lymynge, husbandman 6
4651810 2246513 2246513 defendant Gybon John husbandman 658022 658022 Gybon, John, of Lymynge, husbandman 4
4651811 2246513 2246513 defendant Gilberd Richard husbandman 658022 658022 Gilberd, Richard, of Lymynge, husbandman 5
4651812 2246513 2246513 defendant Gardyner Henry husbandman 658022 658022 Gardyner, Henry, of Lymynge, husbandman 6
4651813 2246513 2246513 defendant Grubbe William husbandman 658022 658022 Grubbe, William, of Lymynge, husbandman 7
4684455 2260741 2260741 defendant Wodhell William gent 658022 658022 Wodhell, William, of Lymynge, gent 2
4685778 2261141 2261141 defendant Jankyn John laborer 658022 658022 Jankyn, John, of Lymynge, laborer 1
4685780 2261141 2261141 defendant Wryght John yeoman 658022 658022 Wryght, John, of Lymynge, yeoman 3
4711721 2268988 2268988 defendant Wryght John yeoman 658022 658022 Wryght, John, of Lymynge, yeoman 1
4718421 2271099 2271099 defendant Grubbe Richard husbandman 658022 658022 Grubbe, Richard, of Lymynge, husbandman 0
4750887 2280741 2280741 defendant Wodhull William husbandman 658022 658022 Wodhull, William, of lymynge, husbandman 3
4789790 2292874 2292874 defendant Brapsone William   658022 658022 Brapsone, William, of Lymynge, franklin 1
4789793 2292875 2292875 defendant Brapson William   658022 658022 Brapson, William, of Lymynge, franklin 1
4790099 2292979 2292979 defendant Bysele Simon yeoman 658022 658022 Bysele, Simon, of Lymynge, yeoman 0
4838784 2308059 2308059 defendant Horn Robert laborer 658022 658022 Horn, Robert, of Lymynge, laborer 0
4895592 2325291 2325291 defendant Swayn William husbandman 658022 658022 Swayn, William, of Lymynge, husbandman 0
4897027 2325723 2325723 defendant Londoneys John laborer 658022 658022 Londoneys, John, of Lymynge, laborer 0
4914043 2330902 2330902 defendant Horn Thomas husbandman 658022 658022 Horn, Thomas, of Lymynge, husbandman 0
4914903 2331170 2331170 defendant Boyton John laborer 658022 658022 Boyton, John, of Lymynge, laborer 0
4969983 2347972 2347972 defendant Godelande Richard husbandman 658022 658022 Godelande, Richard, of Lymynge, husbandman 0
4990000 2353920 2353920 defendant Godelande Richard husbandman 658022 658022 Godelande, Richard, of Lymynge, husbandman 0
5345301 2458704 2458704 defendant Grubbe William yeoman 658022 658022 Grubbe, William, of Lymynge, yeoman 0
5517757 2510395 2510395 defendant Kete Richard baker 658022 658022 Kete, Richard, of Lymynge, baker 0
5619202 2549853 2549853 defendant Giffard Richard   658022 658022 Giffard, Richard, of Lymynge 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);