names

45 rows where place_id = 613070

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3696490 1925130 1925130 plaintiff Serlby Hugh esq 613070 613070 Serlby, Hugh, of Herthill, esq 0
3806689 1959990 1959990 defendant Symmys Richard husbandman 613070 613070 Symmys, Richard, of Herthill, husbandman 0
3912760 1994599 1994599 defendant Hall Thomas carpenter 613070 613070 Hall, Thomas, of Herthill, carpenter 0
3912761 1994599 1994599 defendant Spencer Robert husbandman 613070 613070 Spencer, Robert, of Herthill, husbandman 1
4413257 2169019 2169019 defendant Ayremynne Roger de master & parson 613070 613070 Ayremynne, Roger de, of Herthill, master & parson 0
4455048 2186583 2186583 plaintiff Mawer Robert   613070 613070 Mawer, Robert, of Herthill 0
4533917 2210877 2210877 defendant Clerk Richard   613070 613070 Clerk, Richard, of Herthill 3
4533918 2210877 2210877 defendant Warner John   613070 613070 Warner, John, of Herthill 4
4533920 2210877 2210877 defendant Taillour William   613070 613070 Taillour, William, of Herthill 6
4599491 2231056 2231056 defendant Warnar John   613070 613070 Warnar, John, of Herthill 0
4599501 2231058 2231058 defendant Warnar John   613070 613070 Warnar, John, of Herthill 0
4653547 2247042 2247042 defendant Warner John husbandman 613070 613070 Warner, John, of Herthill, husbandman 0
4653549 2247042 2247042 defendant Gilly John yeoman 613070 613070 Gilly, John, of Herthill, yeoman 2
4653550 2247042 2247042 defendant Savage John yeoman 613070 613070 Savage, John, of Herthill, yeoman 3
4653551 2247042 2247042 defendant Warde William husbandman 613070 613070 Warde, William, of Herthill, husbandman 4
4752439 2281173 2281173 defendant Belgh William de husbandman 613070 613070 Belgh, William de, of Herthill, husbandman 0
4802751 2297045 2297045 defendant atte Dawes Ralph butcher 613070 613070 atte Dawes, Ralph, of Herthill, butcher 0
4821816 2302898 2302898 defendant Milner Thomas husbandman 613070 613070 Milner, Thomas, of Herthill, husbandman 0
4821817 2302898 2302898 defendant Milner John husbandman 613070 613070 Milner, John, of Herthill, husbandman 1
4821818 2302898 2302898 defendant Bylton Roger husbandman 613070 613070 Bylton, Roger, of Herthill, husbandman 2
4821819 2302898 2302898 defendant Boytson John husbandman 613070 613070 Boytson, John, of Herthill, husbandman 3
4821820 2302898 2302898 defendant Plesyngton John husbandman 613070 613070 Plesyngton, John, of Herthill, husbandman 4
4853430 2312484 2312484 defendant Keton Nicholas gent 613070 613070 Keton, Nicholas, of Herthill, gent 0
4880317 2320753 2320753 defendant Tomson William husbandman 613070 613070 Tomson, William, of Herthill, husbandman 1
4880318 2320753 2320753 defendant Rokley John chaplain 613070 613070 Rokley, John, of Herthill, chaplain 2
4880320 2320753 2320753 defendant Anyden or Avyden Thomas husbandman 613070 613070 Anyden or Avyden, Thomas, of Herthill, husbandman 4
4880321 2320753 2320753 defendant Clyff Roger laborer 613070 613070 Clyff, Roger, of Herthill, laborer 5
4880322 2320753 2320753 defendant Belegh John husbandman 613070 613070 Belegh, John, of Herthill, husbandman 6
4880614 2320847 2320847 defendant Tomson William husbandman 613070 613070 Tomson, William, of Herthill, husbandman 1
4880615 2320847 2320847 defendant Rokley John chaplain 613070 613070 Rokley, John, of Herthill, chaplain 2
4880617 2320847 2320847 defendant Anyden or Avyden Thomas husbandman 613070 613070 Anyden or Avyden, Thomas, of Herthill, husbandman 4
4880618 2320847 2320847 defendant Clyff Roger laborer 613070 613070 Clyff, Roger, of Herthill, laborer 5
4880619 2320847 2320847 defendant Belegh John husbandman 613070 613070 Belegh, John, of Herthill, husbandman 6
4881304 2321055 2321055 defendant Keton Nicholas gent 613070 613070 Keton, Nicholas, of Herthill, gent 0
4904921 2328142 2328142 defendant Keton Nicholas gent 613070 613070 Keton, Nicholas, of Herthill, gent 0
4983345 2351926 2351926 defendant Dawes Ralph butcher 613070 613070 Dawes, Ralph, of Herthill, butcher 1
5021575 2363209 2363209 defendant Banester Richard clerk 613070 613070 Banester, Richard, of Herthill, clerk 0
5069894 2377487 2377487 defendant Anotson John husbandman 613070 613070 Anotson, John, of Herthill, husbandman 3
5245834 2428948 2428948 defendant Clyffe Roger husbandman 613070 613070 Clyffe, Roger, of Herthill, husbandman 0
5245835 2428948 2428948 defendant Clyffe John husbandman 613070 613070 Clyffe, John, of Herthill, husbandman 1
5440283 2486996 2486996 defendant Belgh William husbandman 613070 613070 Belgh, William, of Herthill, husbandman 0
5574089 2526987 2526987 defendant Marssh Robert husbandman 613070 613070 Marssh, Robert, of Herthill, husbandman 2
5586794 2530910 2530910 defendant Cliff Richard husbandman 613070 613070 Cliff, Richard, of Herthill, husbandman 0
5620433 2550251 2550251 defendant Wryght Thomas   613070 613070 Wryght, Thomas, of Herthill 0
5620434 2550251 2550251 defendant Milner John   613070 613070 Milner, John, of Herthill 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);