names

57 rows where place_id = 594727

✎ 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
3617305 1873037 1873037 defendant Banaster Richard gent 594727 594727 Banaster, Richard, of Acworth, gent 0
3728607 1935189 1935189 defendant Percy Lionel yeoman 594727 594727 Percy, Lionel, of Acworth, yeoman 1
3780873 1951752 1951752 defendant Ellys John laborer 594727 594727 Ellys, John, of Acworth, laborer 0
3801483 1958379 1958379 defendant Percy Lionel gent 594727 594727 Percy, Lionel, of Acworth, gent 1
3801484 1958379 1958379 defendant Wytacres John yeoman 594727 594727 Wytacres, John, of Acworth, yeoman 2
4456518 2187057 2187057 defendant Barneslay John de   594727 594727 Barneslay, John de, of Acworth 0
4687989 2261812 2261812 defendant Parkyn John nayler 594727 594727 Parkyn, John, of Acworth, nayler 2
4710910 2268768 2268768 defendant Patryk Thomas husbandman 594727 594727 Patryk, Thomas, of Acworth, husbandman 3
4733620 2275692 2275692 defendant Andrewe Richard chaplain 594727 594727 Andrewe, Richard, of Acworth, chaplain 0
4820720 2302556 2302556 defendant Altham James yeoman 594727 594727 Altham, James, of Acworth, yeoman 0
4821351 2302760 2302760 defendant Hordren John chaplain 594727 594727 Hordren, John, of Acworth, chaplain 0
4875487 2319287 2319287 defendant Hordorne John chaplain 594727 594727 Hordorne, John, of Acworth, chaplain 0
4887645 2322967 2322967 defendant Hesketh Henry yeoman 594727 594727 Hesketh, Henry, of Acworth, yeoman 1
4895871 2325376 2325376 defendant Horbery William yeoman 594727 594727 Horbery, William, of Acworth, yeoman 1
4895878 2325377 2325377 defendant del Hill John husbandman 594727 594727 del Hill, John, of Acworth, husbandman 0
4898885 2326293 2326293 defendant Hoderode Thomas chaplain 594727 594727 Hoderode, Thomas, of Acworth, chaplain 0
4902717 2327469 2327469 defendant Wodehous James yeoman 594727 594727 Wodehous, James, of Acworth, yeoman 0
4902718 2327469 2327469 defendant Alteham James yeoman 594727 594727 Alteham, James, of Acworth, yeoman 1
4904924 2328142 2328142 defendant Raynald William husbandman 594727 594727 Raynald, William, of Acworth, husbandman 3
4930392 2335905 2335905 defendant Hesketh Henry gent 594727 594727 Hesketh, Henry, of Acworth, gent 0
4969877 2347941 2347941 defendant Couper Richard cooper 594727 594727 Couper, Richard, of Acworth, cooper 0
4969879 2347941 2347941 defendant Smyth Nicholas husbandman 594727 594727 Smyth, Nicholas, of Acworth, husbandman 2
4969880 2347941 2347941 defendant Bro- Richard husbandman 594727 594727 Bro-, Richard, of Acworth, husbandman 3
4969881 2347941 2347941 defendant Coly John husbandman 594727 594727 Coly, John, of Acworth, husbandman 4
5068701 2377135 2377135 defendant Hesketh Henry gent 594727 594727 Hesketh, Henry, of Acworth, gent 0
5071956 2378101 2378101 defendant del Hill John husbandman 594727 594727 del Hill, John, of Acworth, husbandman 1
5079144 2380248 2380248 defendant Couper Richard husbandman 594727 594727 Couper, Richard, of Acworth, husbandman 1
5129645 2395161 2395161 defendant Reynald John, senior husbandman 594727 594727 Reynald, John, senior, of Acworth, husbandman 0
5129647 2395161 2395161 defendant Coly William, junior husbandman 594727 594727 Coly, William, junior, of Acworth, husbandman 2
5129648 2395161 2395161 defendant Hole William   594727 594727 Hole, William, of Acworth 3
5156036 2402924 2402924 defendant Raynald John, sen husbandman 594727 594727 Raynald, John, sen, of Acworth, husbandman 0
5156037 2402924 2402924 defendant Smyth John husbandman 594727 594727 Smyth, John, of Acworth, husbandman 1
5156038 2402924 2402924 defendant Milner Robert husbandman 594727 594727 Milner, Robert, of Acworth, husbandman 2
5156040 2402924 2402924 defendant Hole William husbandman 594727 594727 Hole, William, of Acworth, husbandman 4
5172379 2407647 2407647 defendant Raynald John, sen husbandman 594727 594727 Raynald, John, sen, of Acworth, husbandman 0
5172380 2407647 2407647 defendant Raynald John husbandman 594727 594727 Raynald, John, of Acworth, husbandman 1
5172382 2407647 2407647 defendant Holt William husbandman 594727 594727 Holt, William, of Acworth, husbandman 3
5189929 2412796 2412796 defendant Caterynson Robert laborer 594727 594727 Caterynson, Robert, of Acworth, laborer 2
5189935 2412797 2412797 defendant Caterynson Robert laborer 594727 594727 Caterynson, Robert, of Acworth, laborer 2
5230791 2424614 2424614 defendant Wynter John clerk 594727 594727 Wynter, John, of Acworth, clerk 4
5239261 2427071 2427071 defendant Haworth Edward   594727 594727 Haworth, Edward, of Acworth servant 5
5289321 2441877 2441877 defendant Clyff Robert laborer 594727 594727 Clyff, Robert, of Acworth, laborer 19
5304787 2446434 2446434 defendant Raynold Thomas chaplain 594727 594727 Raynold, Thomas, of Acworth, chaplain 0
5318957 2450762 2450762 defendant Jankynson Thomas husbandman 594727 594727 Jankynson, Thomas, of Acworth, husbandman 0
5318958 2450762 2450762 defendant Jankynson William laborer 594727 594727 Jankynson, William, of Acworth, laborer 1
5346629 2459099 2459099 defendant Dyghton William yeoman 594727 594727 Dyghton, William, of Acworth, yeoman 0
5348468 2459661 2459661 defendant Dyghton William yeoman 594727 594727 Dyghton, William, of Acworth, yeoman 0
5356060 2461974 2461974 defendant Dyghton William yeoman 594727 594727 Dyghton, William, of Acworth, yeoman 1
5356061 2461974 2461974 defendant Parkyn Robert yeoman 594727 594727 Parkyn, Robert, of Acworth, yeoman 2
5370791 2466452 2466452 defendant Sylcok Thomas husbandman 594727 594727 Sylcok, Thomas, of Acworth, husbandman 0
5370792 2466452 2466452 defendant Sylcok (illegible) husbandman 594727 594727 Sylcok, ------, of Acworth, husbandman 1
5391628 2472676 2472676 defendant Jenkynson Willim yeoman 594727 594727 Jenkynson, Willim, of Acworth, yeoman 1
5391629 2472676 2472676 defendant Horner John yeoman 594727 594727 Horner, John, of Acworth, yeoman 2
5391630 2472676 2472676 defendant Broke John yeoman 594727 594727 Broke, John, of Acworth, yeoman 3
5391631 2472676 2472676 defendant Raynold William yeoman 594727 594727 Raynold, William, of Acworth, yeoman 4
5526262 2512792 2512792 defendant Jenkynson William yeoman 594727 594727 Jenkynson, William, of Acworth, yeoman 0
5577873 2528153 2528153 defendant Kempe John husbandman 594727 594727 Kempe, John, of Acworth, 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);